Filetype Excel XLS | Posted on 08 Aug 2022 | 3 years ago
Authentication
digital resources
188x Filetype XLS File size 0.07 MB Source: www.madison-lake.k12.oh.us
Sheet 1: Worksheet
| Building Materials Cost Estimate | ||||||||||
| Category | Item | Material | Size/Description | Quantity | Unit Cost | Cost | Retail Unit Cost | Retail Cost | Notes | |
| Floor | Floor | Concrete | Cubic yard | $98.00 | $0.00 | $0.00 | varies (from pad estimate) | |||
| Rebar | Steel | #4 (1/2in. X 10ft) | $4.78 | $0.00 | $0.00 | varies (from pad estimate) | ||||
| Forms | Pine | 2in. x 4in. – 12ft | $2.41 | $0.00 | $0.00 | varies (from pad estimate) | ||||
| Forms | Pine | 2in. x 4in. – 16ft | $3.75 | $0.00 | $0.00 | varies (from pad estimate) | ||||
| Walls | Stud | Pine | 2in. x 4in. - 92 5/8in. | $1.79 | $0.00 | $0.00 | include king studs and trimmer boards |
|||
| Partial Studs | Pine | 2in. x 4in. - 8ft | $1.79 | $0.00 | $0.00 | approx. for cripple studs and gable studs |
||||
| Top Plate | Pine | 2in. x 4in. - 8ft | * | $1.79 | $0.00 | $0.00 | double top pl. at 8ft and single top plate at gable ends |
|||
| Sole Plate | Pine | 2in. x 4in. - 8ft | $1.79 | $0.00 | $0.00 | neglect door opng | ||||
| Headers | Pine | 2in. x 6in. - 8ft | $2.89 | $0.00 | $0.00 | dbl members | ||||
| Wall Sheathing | OSB | 1/2in. x 4ft x 8ft sheet | $6.85 | $0.00 | $0.00 | |||||
| Vapor Barrier | House Wrap | 9ft x 150ft roll | $98.00 | $0.00 | $0.00 | Missing in original template | ||||
| Siding | 3/4in. Wood Bevel Siding | Bundle of 200 sq. ft | $300.00 | $0.00 | $0.00 | |||||
| Wall Finish (interior) | OSB | 1/2in. x 4ft x 8ft sheet | $6.85 | $0.00 | $0.00 | |||||
| Paint | Exterior Latex Paint | Gallon (400 sq. ft per gallon) 2 coats |
$15.99 | $0.00 | $0.00 | round up to next whole | ||||
| R-11 Batt Insulation | Fiberglass | 3.5in. x 15in. - 40 sq. ft | $8.48 | $0.00 | $0.00 | |||||
| Anchor Bolt | Steel | 1/2in. Æ x 6in. | $0.42 | $0.00 | $0.00 | every 4ft of perimeter | ||||
| Openings | Double Hung Window | Vinyl | 24in. x 36in. | $134.00 | $0.00 | $0.00 | ||||
| Door | Steel | Double - 7ft x 80in. | $250.00 | $0.00 | $0.00 | |||||
| Roof | Ridge Board | Pine | 2in. x 8in. - 8ft | $3.29 | $0.00 | $0.00 | ||||
| Rafters | Pine | 2in. x 6in. - 8ft | ** | $2.89 | $0.00 | $0.00 | dbl rafters at gable wall | |||
| Blocking | Pine | 2in. x 6in. - 8ft | $2.89 | $0.00 | $0.00 | |||||
| Sheathing | Oriented Strand Board (OSB) | 7/16in. x 4ft x 8ft sheet | $6.39 | $0.00 | $0.00 | use 8ft rafter length roof width = 16ft +2ft overhangs |
||||
| Roofing Felt 15# | Roll covers 500 sq. ft. | $23.67 | $0.00 | $0.00 | see above | |||||
| Shingles | Composition/Asphalt | Square (covers 100 sq. ft.) | $23.80 | $0.00 | $0.00 | see above | ||||
| R-19 Batt Insulation | Fiberglass | 5.5in. x 15in. - 87.5 sq. ft | *** | $27.84 | $0.00 | $0.00 | ||||
| Fascia | Pine | 1in. x 8in. - 10ft | $12.69 | $0.00 | $0.00 | include entire perimeter of roof, including sloped edges at gables |
||||
| Drip Edge | Galvanized Metal | 3in. x 10ft | $3.79 | $0.00 | $0.00 | only at lower edge of roof | ||||
| Interior Finish | Gypsum Wall Board | 1/2in. x 4ft x 8ft sheet | $6.44 | $0.00 | $0.00 | missing in original template | ||||
| Total Cost | $0.00 | |||||||||
| * Top Plate Calculations | ||||||||||
| Roof slope is 5/12. Therefore, the roof angle is 22.6 degrees [ tan q = 5/12]. | ||||||||||
| Length of top plate at top of gable wall can be calculated using cosine function [ cos 22.6 = 6/L]. | ||||||||||
| L=6/(cos 22.6) | ||||||||||
| L=6.5ft Use a full 8ft length for each. | ||||||||||
| There are four gable end top plates. | ||||||||||
| Add top plates (double) at top of 8ft wall. | ||||||||||
| Top plate length = 2(2*12+2*16) + 4(8) = 144ft | ||||||||||
| Since each board is 8ft long, divide total length by 8ft. | ||||||||||
| No. of 8ft boards = 144ft/8 = 18 | ||||||||||
| Round up to 18 boards. | ||||||||||
| ** Rafter Calculations | ||||||||||
| Roof slope is 5/12. Therefore, the roof angle is 22.6 degrees [ tan q = 5/12]. | ||||||||||
| A one foot overhang increases the base of the triangle. | ||||||||||
| Length of rafter is then calculated using the cosine function [cos 22.6 = 7/L]. | ||||||||||
| L = 7/(cos 22.6) | ||||||||||
| L=7.58ft | ||||||||||
| Therefore, purchase one 8ft board for each rafter. | ||||||||||
| *** Roof/Ceiling Insulation Calculations | ||||||||||
| Roof slope is 5/12. Therefore the roof angle is 22.6 degrees [ tan q = 5/12]. | ||||||||||
| No insulation in overhang. | ||||||||||
| Length of insulation in ceiling can be calculated using cosine function [cos 22.6 = 6/L]. | ||||||||||
| L=6/(cos 22.6) | ||||||||||
| L=6.5ft | ||||||||||
| Therefore, area of roof/ceiling requiring insulation is 2* (6.5 * 16) = 208 sq. ft. | ||||||||||
| Since each roll of insulation contains 87.5 sq. ft, you will need: | ||||||||||
| No. of rolls of insulation = 208/87.5 = 2.4 rolls | ||||||||||
| Round up to 3 rolls. | ||||||||||
no reviews yet
Please Login to review.
