Project Scope: You are working for a general contractor and they need you to come up with a detailed estimate for a house that they are going to build. The company is subcontracting out some of the work, but you need to develop estimates for the following.

You need to develop an Estimate Work Sheet and Estimate Summary $($with proper CSI divisions$)$ in Excel for the following components:

Estimate Worksheet: Quantity Take$-$Off Only

Estimate Summary Sheet: Cost Information: Material & Labor Costs only$($Direct Project Costs$)$

Carpeting

Develop an Estimate Worksheet and Estimate Summary Sheet for carpeting.

Determine the number of square yards of carpet and padding needed for the four bedrooms and the hallway.

Assume $12\%$ for waste and overlap

Production rate: Pad installation: $100y{d}^2$ hour

Carpet Installation: $30y{d}^2$ hour

Wage: $$18\mathrm{.}50$ hour

Tile

Develop an Estimate Worksheet and Estimate Summary Sheet for tile.

How many square feet of backing material is needed for the $2$ bathrooms, living room, kitchen, and dining area? Assume the kitchen counters are $2$ feet deep, $9$ ft $.$ long, and $7$ fthigh and all three are the same dimensions. Assume $8\%$ waste.

How many square feet of tile are needed for the $2$ bathrooms, living room, kitchen, and dining area? Assume the kitchen counters are $2$ feet deep, $9$ ft long, and $7$ ft high, and all three are the same dimensions. Assume $8\%$ waste.

Production rate:

Backing material: $200f\frac{t^2}{?}$ hour

Tile: $30f\frac{t^2}{h}$our

Wage: $$24\mathrm{.}50$ hour

Paint

Develop an Estimate Worksheet and Estimate Summary Sheet for paint

How many gallons of primer and paint are needed to paint all interior walls and the ceiling? The walls are to receive one coat of primer and two coats of paint. The exterior walls only need paint on the interior sides. The walls are $8$ feet high. One

gallon of primer will cover $300$ square feet, square feet with a single coat.

Production Rate: $200f\frac{t^2}{?}$ hour $\frac{?}{?}$ coat

Wage: $$21\mathrm{.}50/$hour

Drawing Assumptions

Assume the hallway is $3$ ft $.$ wide. Use this dimension to calculate the dimensions of the top bedroom and bathroom. Assume doors are $7$ feet tall by $3$ feet wide.

Assume the inner walls are $8^{\text{'}\text{'}}$ thick

Additional Assignment Instructions

Show all your work in an excel spreadsheet and note any assumptions made regarding dimensions. Be sure to label all your work. Each Estimate Worksheet $(3$ total$)$ and Estimate Summary Sheet $(3$ total$)$ should be on a separate labeled tab in one Excel File. The $1^{st}$ tab should be a Total Estimate Summary for the entire project.

Estimate the costs of all materials and labor and provide a detailed list of all costs $($w$/$ CSI references$)$ broken down into categories using the following cost information:

Your boss tells you to add $15\%$ in for overhead, $4\%$ for small tools, and $12\%$ profit to the Total Estimate Summary. He wants you to give him a one page memo that outlines the work that is to be done, the material cost, the labor cost, and the total project cost along with a pdf of the Total Estimate Summary

Project Deliverables

Cover Memo and supporting materials $(8$ pages total$)$

a$.$ One page summary cover memo

b$.$ Copy of the Total Estimate Summary

Excel Spreadsheet with the following tabs:

Excel Spreadsheet with the following tabs:

a$.$ Total Estimate Summary

b$.$ Carpeting Estimate Worksheet

c$.$ Carpeting Estimate Summary

d$.$ Tile Estimate Worksheet

e$.$ Tile Estimate Summary

f Paint Estimate Worksheet

g$.$ Paint Estimate Summary