Breakdown of Labor and Materials cost.xlsx

XLSX spreadsheet 30 KB Posted

Attached to
31100PR260000060-Replace vertical package unit located at Building 38
Solicitation number
31100PR260000060
Issued by

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 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 TrapDate:8/12/26
Project Location:Base LA/LBTotal Cost:ERROR:#REF!
BREAKDOWN OF COSTS
MATERIALMANHOURSLABOROTHER DIRECTTOTAL
DIVISION 1: GENERAL REQUIREMENTS$00$0$0$0
DIVISION 2: SITEWORKERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 3: CONCRETEERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 4: MASONRYERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 5: METALSERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 6: WOOD AND PLASTICSERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 7: THERMAL AND MOISTURE PROTECTIONERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 8: DOORS AND WINDOWSERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 9: FINISHESERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 10: SPECIALTIESERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 11: EQUIPMENTERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 12: FURNISHINGSERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 13: SPECIAL CONSTRUCTIONERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 14: CONVEYING SYSTEMSERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 21: FIRE PROTECTIONERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 22: PLUMBINGERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 23: MECHANICALERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
DIVISION 26: ELECTRICALERROR:#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!FY2024
OVERHEAD:10%ERROR:#REF!Qtr2
SUBTOTAL:ERROR:#REF!
PROFIT:10%ERROR:#REF!
SUBTOTAL:ERROR:#REF!
BONDS:3%ERROR:#REF!
For Official Use Only
TOTAL PROJECT COST:ERROR:#REF!
RoundupERROR:#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 REQUIREMENTSMATERIAL COSTSLABOR COSTSOTHER DIRECT
SOURCE/UNITMH/MANAVGUNITLINE
MEANS LINE #UOMQTYCOSTTOTALUNITHRSRATETOTALCOSTTOTALTOTAL
Mobilization$00$0$0$0
$00$0$0$0
$00$0$0$0
$00$0$0$0
$00$0$0$0
$00$0$0$0
$00$0$0$0
$00$0$0$0
ContingencyIncluded in mobilization
OverheadIncluded in mobilization
ProfitIncluded 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 .