Spreadsheet: 881109d1729021693-calculating-number-of-winter-workdays-between-two-dats-revised-structural-erection-worksheet-test
Sheet: Bid Worksheet

Bid Worksheet lbs/mh Breakdown
Bid Item | Cost Code | Cost Code Description | Description | Quantity | Production Rate | QTY/md | Manhours | Cost P/hr | Price P/hr | Labor Cost | Labor Price | Added | Total Price | Price P/MH | Margin | Profit | Percent | Cost P/Hr Advantage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COST CODE | [NAME]
1 | 36010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36010 | Unload & Shakeout under 30'-0"
2 | 36020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36020 | Erection under 30'-0"
3 | 36030 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36030 | Plumb Bldg. under 30'-0"
4 | 36040 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36040 | [NAME] Up under 30'-0"
5 | 36050 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36050 | Decking under 30'-0"
6 | 36060 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36060 | Welding under 30'-0"
7 | 36070 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36070 | Studs under 30'-0"
8 | 36080 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36080 | Trim/misc. under 30'-0"
9 | 36090 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36090 | Install Wall Panels under 30'0"
10 | 36100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36100 | Install [NAME] under 30'-0"
1 | 37010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37010 | Unload & Shakeout 30'-0" and over
2 | 37020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37020 | Erection 30'-0" and over
3 | 37030 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37030 | Plumb Bldg. 30'-0" and over
4 | 37040 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37040 | [NAME] Up 30'-0" and over
5 | 37050 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37050 | Decking 30'-0" and over
6 | 37060 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37060 | Welding 30'-0" and over
7 | 37070 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37070 | Studs 30'-0" and over
8 | 37080 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37080 | Trim/misc. 30'-0" and over
9 | 37090 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37090 | Install Wall Panels 30'-0" and over
10 | 37100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37100 | Install Roof Panels 30'-0" and over
 | 18560 |  | EO13706 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18560 | [NAME]. EO13706
 | 18560 |  | Winter Man Hours |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 | 0
 |  |  | Total Rebar
Bid Item | Cost Code | Cost Code Description | Description | Material Quantity | lbs/mh | lbs/md | Manhours | Cost P/hr | Price P/hr | Labor Cost | Labor Price | Added | Total Price | Price           P/Ton | Margin | Profit | Percent | Cost P/Hr Advantage
 | 21010
 | 21060 |  |  |  | 0
 |  |  | Total Mesh
Bid Item | Cost Code | Cost Code Description | Description |  | lbs/mh | lbs/md | Manhours | Cost P/hr | Price P/hr | Labor Cost | Labor Price | Added | Total Price | Price           P/Ton | Margin | Profit | Percent | Cost P/Hr Advantage
 | 19010
 | 19020 |  |  |  | 0
 |  |  | Total Cable
Bid Item | Cost Code | Cost Code Description | Description | Material Quantity | lbs/mh | lbs/md | Manhours | Cost P/hr | Price P/hr | Labor Cost | Labor Price | Added | Total Price | Price           P/Ton | Margin | Profit | Percent | Cost P/Hr Advantage
 | 18570 |  |  | 0 | 0
 | 18460
 |  |  | Total Couplers
Bid Item | Cost Code | Cost Code Description | Description | Material Quantity | lbs/mh | lbs/md | Manhours | Cost P/hr | Price P/hr | Labor Cost | Labor Price | Added | Total Price | Price           P/Ton | Margin | Profit | Percent | Cost P/Hr Advantage
 | 18580
 |  |  | Total Stud Rails
 | Item | Quantity | Average Production Rate | Manhours |  | Unit Price | Alt. Unit Price |  |  |  |  |  | Total M/Hrs
 | Rebar |  |  |  |  |  |  | p/lb |  |  |  |  | Total Labor Cost
 | Mesh |  |  |  |  |  |  | p/sq ft |  |  |  |  | Total Labor Price
 | Cable |  |  |  |  |  |  | p/lb |  |  |  |  | Total Added
 | Couplers |  |  |  |  |  |  |  |  |  |  |  | Total Supplies
 | Stud Rails |  |  |  |  |  |  |  |  |  |  |  | Gross Margin
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Profit
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Job Value
 | Non-Production Cost Codes |  |  |  | Notes:
 | Cost Code | Description | Rate | Estimated Cost
 | 40020 | JOBSITE SAFETY
 | 47010 | FIELD SUPPLIES | 32
 | 47020 | EQUIPMENT | 175
 | 47030 | JOB TRAVEL
 | 47010 | FIELD SUPPLIES