Wall Cost Estimator

Walls are built out of either brick or stone. Stone walls cost $3 per cubic foot, while brick walls cost $2 per cubic foot.

The builder will only construct wall sections that are 20 feet long, 6 feet tall and 2 feet wide.

A section of wall is built by a crew of two workers. It will take a crew three eight-hour days to build a wall regardless of material type.

The owner pays workers $10 per hour. In addition, the owner adds 20% of labor cost to cover fringe benefits.

The owner adds 30% of total costs as a profit margin.

The first worksheet of your spreadsheet, named Answers you should

• Place your name in cell A1
• Allow the user to input the number of wall sections in cell B3.
• Allow the user to input the type of material, Brick or Rock, in Cell B4.
• Produce the estimate and place it in cell B5.

Definitions

• Volume of a wall segment is computed by multiplying length by width by height. All measurements should be in the same unit.
• A workers pay is computed by multiplying the hours worked by the hourly wage.
• The labor cost is the sum of all workers pay.
• Fringe benefits are computing by multiplying the labor cost by the fringe benefit percentage.
• Total costs are computed by adding all material costs and labor costs.
• Profit margin is computed by multiplying total costs by the profit margin percent.
• The final cost is computed by adding the profit margin to the total cost.

Submit