[go: up one dir, main page]
Scribd
Upload
74 views1 page

Estimating With Microsoft Excel 3

The document provides a cost estimate for footings and foundations that includes quantities, unit costs, and totals for various components of the project including form work, concrete, rebar, and other materials. The total estimated cost for labor is $3,148 and the total estimated cost for materials is $4,729.53, bringing the overall total cost estimate to $11,025.53.

Uploaded by

rabzih
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
74 views1 page

Estimating With Microsoft Excel 3

The document provides a cost estimate for footings and foundations that includes quantities, unit costs, and totals for various components of the project including form work, concrete, rebar, and other materials. The total estimated cost for labor is $3,148 and the total estimated cost for materials is $4,729.53, bringing the overall total cost estimate to $11,025.53.

Uploaded by

rabzih
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

FOOTINGS & FOUNDATIONS

Labor
Item Qty. LF CuYd $/Unit Cost
Form Work Footing (Continuous) 258 $ 3.00 $ 774.00
Footing (Spot) 5 $ 18.00 $ 90.00
Footing (Steps) 8 $ 18.00 $ 144.00
Foundation Walls (4 Ft.) 120 $ 5.00 $ 600.00
Foundation Walls (8 Ft.) 135 $ 8.00 $ 1,080.00
Specialty Items Corners 14 $ 15.00 $ 210.00
Window Blockout 4 $ 10.00 $ 40.00
Beam Pockets 13 $ 15.00 $ 195.00
Door Blockouts Garage 0 $ 8.00 $ -
Door Blockout Encased 1 $ 15.00 $ 15.00
Blanket $ 2.00 $ -
Subtotal Labor $ 3,148.00
Material
Qty. % CuYd $/Unit Cost
Concrete 3000 psi. Standard 5-5.5 54.44 $ 65.00 $ 3,538.89
Misc. Items #4 Rebar (20' pieces) 104.25 $ 3.27 $ 340.90
J-Bolts 47 $ 0.45 $ 21.15
Straps 33 $ 9.50 $ 313.50
Window Blockout Rental 4 $ 48.00 $ 192.00
Door Blockout Rental 1 $ 48.00 $ 48.00
Nut $ Washer Sets 47 $ 0.20 $ 9.40
Rebar Dowels 125 $ 0.71 $ 88.75
Waste 5 2.72 $ 65.00 $ 176.94
Subtotal Material $ 4,729.53
Total $ 11,025.53

Figure 2 - Example Detail Sheet

Formulas
Formulas are entered into the cell where you want the value to be located. A formula is created
by first entering = (the equals sign) and then adding, subtracting, multiplying, etc. the values of
other cells. In this example, concrete cubic yards and totals are automatically calculated.

A B C D E F G
1 Concrete
2 Description Thickness " Width ' Length ' CY $/CY Total
3 Driveway 4 18 30 6.67 $ 62.00 $ 413.33
4 Walk 4 4 15 0.74 $ 62.00 $ 45.93
5 Patio 4 14 16 2.77 $ 62.00 $ 171.46
6
7 Total $ 630.72
Figure 3 - Concrete Detail
The formulas for this example are shown in Figure 4. The cubic yard (CY) formula in cell E3
was created using this sequence; press =, click on cell B3, press / (divide), type 12 (to convert to
feet), press * (multiply), click on cell C3, press *, click on cell D3, press /, type 27 (to convert
cubic feet to cubic yards), press enter. You’ve now completed the formula to calculate CY. The

You might also like