Breakdown of Labor and Materials cost.xlsx
XLSX spreadsheet 30 KB Posted
- Solicitation number
- 31100PR260000060
About this file
This is a Project Cost Estimate spreadsheet for the replacement of a grease trap at Building 20, located at Base LA/LB, with a project date of August 12, 2026, under the management of Paul Nelson. The document is structured as a detailed cost breakdown template using the MasterFormat division classification system, containing line items for materials, labor (in manhours), and other direct costs across 16 construction divisions including General Requirements, Sitework, Concrete, Masonry, Metals, Wood and Plastics, Thermal and Moisture Protection, Doors and Windows, Finishes, Specialties, Equipment, Furnishings, Special Construction, Conveying Systems, Fire Protection, Plumbing, Mechanical, and Electrical.
The spreadsheet includes cost escalation factors with a 5% contingency, 10% overhead allocation, 10% profit markup, and 3% bonds applied to the total direct costs to arrive at the final project cost. However, the document contains numerous formula errors (displayed as "ERROR:#REF!") throughout the cost cells, indicating incomplete data entry or broken cell references, which prevents the generation of accurate subtotals and the final project cost total. Only the Division 1: General Requirements section shows complete data with $0 material costs and 0 manhours, while all other divisions display error messages and cannot be evaluated for actual cost estimates.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SOW-b38 vertical package unit install.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Summary
| Project Serial Number: | Project Manager: | Paul Nelson | ||||
| Project Description: | Replace Bldg 20 Grease Trap | Date: | 8/12/26 | |||
| Project Location: | Base LA/LB | Total Cost: | ERROR:#REF! | |||
| BREAKDOWN OF COSTS | ||||||
| MATERIAL | MANHOURS | LABOR | OTHER DIRECT | TOTAL | ||
| DIVISION 1: GENERAL REQUIREMENTS | $0 | 0 | $0 | $0 | $0 | |
| DIVISION 2: SITEWORK | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 3: CONCRETE | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 4: MASONRY | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 5: METALS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 6: WOOD AND PLASTICS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 7: THERMAL AND MOISTURE PROTECTION | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 8: DOORS AND WINDOWS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 9: FINISHES | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 10: SPECIALTIES | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 11: EQUIPMENT | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 12: FURNISHINGS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 13: SPECIAL CONSTRUCTION | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 14: CONVEYING SYSTEMS | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 21: FIRE PROTECTION | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 22: PLUMBING | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 23: MECHANICAL | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| DIVISION 26: ELECTRICAL | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| SUBTOTALS: | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| TOTAL DIRECT COSTS: | ERROR:#REF! | Prepared By: | ||
| CONTINGENCY: | 5% | ERROR:#REF! | Project Total IGE: | |
| SUBTOTAL: | ERROR:#REF! | FY | 2024 | |
| OVERHEAD: | 10% | ERROR:#REF! | Qtr | 2 |
| SUBTOTAL: | ERROR:#REF! | |||
| PROFIT: | 10% | ERROR:#REF! | ||
| SUBTOTAL: | ERROR:#REF! | |||
| BONDS: | 3% | ERROR:#REF! | ||
| For Official Use Only | ||||
| TOTAL PROJECT COST: | ERROR:#REF! | |||
| Roundup | ERROR:#REF! |
&"Arial,Bold"PROJECT COST ESTIMATE - SUMMARY PAGE
&"Arial,Bold"&A &"Arial,Bold"Page &P of &N
Div 1
| Project Serial Number: | Project Manager: | |||||||||||
| Project Description: | Date: | |||||||||||
| Project Location: | Total Cost: | |||||||||||
| GENERAL REQUIREMENTS | MATERIAL COSTS | LABOR COSTS | OTHER DIRECT | |||||||||
| SOURCE/ | UNIT | MH/ | MAN | AVG | UNIT | LINE | ||||||
| MEANS LINE # | UOM | QTY | COST | TOTAL | UNIT | HRS | RATE | TOTAL | COST | TOTAL | TOTAL | |
| Mobilization | $0 | 0 | $0 | $0 | $0 | |||||||
| $0 | 0 | $0 | $0 | $0 | ||||||||
| $0 | 0 | $0 | $0 | $0 | ||||||||
| $0 | 0 | $0 | $0 | $0 | ||||||||
| $0 | 0 | $0 | $0 | $0 | ||||||||
| $0 | 0 | $0 | $0 | $0 | ||||||||
| $0 | 0 | $0 | $0 | $0 | ||||||||
| $0 | 0 | $0 | $0 | $0 |
| Contingency | Included in mobilization |
| Overhead | Included in mobilization |
| Profit | Included in mobilization |
TOTAL COST $0
&"Arial,Bold"PROJECT COST ESTIMATE (CONT.)
&"Arial,Bold"&A &"Arial,Bold"Page &P of &N
File details come from the government source that posted it. Updated .