B08 - Solicitation Attachment D - Level of Effort (LOE) Spreadsheet.xlsx

XLSX spreadsheet 240 KB Posted

Attached to
Draft Solicitation - Aberdeen Test Center Welding, Machining, Painting, and Fabrication Services
Solicitation number
W91CRB-27-R-A002
Issued by

About this file

This is a Level of Effort (LOE) spreadsheet template for pricing proposals on the Machine Shop Re-Compete contract opportunity for Aberdeen Test Center. The contract covers welding, machining, painting, and fabrication services with a period of performance from December 7, 2026, to December 6, 2031 (five years). The total estimated contract value is $5,000,000, consisting entirely of fixed-price task orders at $1,000,000 per year.

The template requires offerors to provide detailed pricing breakdowns across multiple worksheets, including direct labor rates by category (Welder Project Leader, Journeyperson Machinist, Journeyperson Welder, General Laborer, Gunsmith Machinist, CNC Operator Technician, Experimental Welder, Painter, and others), labor hour allocations totaling 80,640 productive hours per year (403,200 over the contract period), and overtime hours (2,422 per year; 12,110 total). The template includes sections for Time and Materials labor costs, Other Direct Costs (ODCs), indirect rate calculations (fringe, overhead, and G&A), and fully burdened labor rates. Offerors must designate whether work is performed by the prime contractor or subcontractors, provide historical and estimated indirect rate data for multiple fiscal years, and submit supporting documentation for labor rates, including pay stubs, employee letters of intent, or salary survey data. The spreadsheet is structured to automatically calculate and cross-reference pricing data across worksheets, with annual productive hours standardized at 1,920 hours per full-time equivalent employee.

View the file

Other files

File Type Posted
Solicitation - W91CRB27RA002.pdf PDF
Labor Categories and Qualifications.pdf PDF
3. GFP Listing April2026.pdf PDF
2. QASP - June 2026 Rev1.pdf PDF
Perfromnce Work Statement_October 2026 Rev2.pdf PDF
CDRL INFO.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

Instructions

Instructions
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
Government Inputs
Solicitation Number:TBD
Name of Action:Machine Shop Re-Compete
Period of Performance:07 December 2026 to 06 December 2031
Annual Productive Hours:1920
Offeror Inputs
Prime Contractor/Subcontractor Name/Division:

Section B

Section B - Supplies or Services Prices
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
(The format below is a sample. Propose in the actual format of the Section B contained in the solicitation)
Transition-In
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
0001Transition-In1Each$ - 0
FFP$ - 0From Price Summary Worksheet
Estimated price=$ - 0
Year 2
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
1001Year 11Each$ - 0
T&M-Time and Materials$ - 0From Price Summary Worksheet
Estimated price=$ - 0
Fee=$ - 0From Price Summary Worksheet
Price + Fee=$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
1002Fixed Price Task Orders1Each$ - 0
FFPEstimated price=$ 1,000,000.00From Price Summary Worksheet
From Price Summary Worksheet and ODC Detail Worksheet
Subtotal$ 1,000,000.00
Year 2
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
2001Year 21Each$ - 0
T&M-Time and Materials$ - 0From Price Summary Worksheet
Estimated price=$ - 0
Fee=$ - 0From Price Summary Worksheet
Price + Fee=$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
2002Fixed Price Task Orders1Each$ - 0
FFPEstimated price=$ 1,000,000.00From Price Summary Worksheet
From Price Summary Worksheet and ODC Detail Worksheet
Subtotal$ 1,000,000.00
Year 3
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
3001Year 31Each$ - 0
T&M-Time and Materials$ - 0From Price Summary Worksheet
Estimated price=$ - 0
Fee=$ - 0From Price Summary Worksheet
Price + Fee=$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
3002Fixed Price Task Orders1Each$ - 0
FFPEstimated price=$ 1,000,000.00From Price Summary Worksheet
From Price Summary Worksheet and ODC Detail Worksheet
Subtotal$ 1,000,000.00
Year 4
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
4001Year 41Each$ - 0
T&M-Time and Materials$ - 0From Price Summary Worksheet
Estimated price=$ - 0
Fee=$ - 0From Price Summary Worksheet
Price + Fee=$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
4002Fixed Price Task Orders1Each$ - 0
FFPEstimated price=$ 1,000,000.00From Price Summary Worksheet
From Price Summary Worksheet and ODC Detail Worksheet
Subtotal$ 1,000,000.00
Year 5
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
5001Year 51Each$ - 0
T&M-Time and Materials$ - 0From Price Summary Worksheet
Estimated price=$ - 0
Fee=$ - 0From Price Summary Worksheet
Price + Fee=$ - 0
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
5002Fixed Price Task Orders1Each$ - 0
FFPEstimated price=$ 1,000,000.00From Price Summary Worksheet
From Price Summary Worksheet and ODC Detail Worksheet
Subtotal$ 1,000,000.00
Transition-In
CLINSUPPLIES/SERVICESQTYUNITUNIT PRICEAMOUNT
0001Transition-Out1Each$ - 0
FFPFrom Price Summary Worksheet
Estimated price=$ - 0
TOTAL
TOTAL
Estimated price=$ 5,000,000.00
Profit/Fee=$ - 0
Total Price=$ 5,000,000.00
Double check figure$ 5,000,000.00CLIN Totals
Double check figure$ 5,000,000.00Price Summary Total
Double check figure$ 5,000,000.00Individual Worksheet Total

Price Summary

Price Summary Spreadsheet
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
Machine Shop Re-CompeteYear 1Year 2Year 3Year 4Year 5TOTAL
Labor & Subcontract Labor Hours80,64080,64080,64080,64080,640403,200From Labor Detail Worksheet
Direct & Indirect Labor & Subcontract Labor (less G&A)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Detail Worksheet
G&A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Detail Worksheet
Direct & Indirect Labor & Subcontract Labor (Less Fee)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Detail Worksheet
Labor-Time$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ODC-Materials Less (G&A)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Material G&A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Materials$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Time and Materials$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor & Subcontract Labor OT Hours2,4222,4222,4222,4222,42212,110From Labor Detail Worksheet
OT Direct & Indirect Labor & Subcontract Labor (less G&A)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Detail Worksheet
OT G&A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Detail Worksheet
OT Direct & Indirect Labor & Subcontract Labor (Less Fee)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OT Fee$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0From Labor Detail Worksheet
OT Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Transition-In$ - 0Fill in
Transition-Out$ - 0Fill in
FFP Task Orders$ 1,000,000.00$ 1,000,000.00$ 1,000,000.00$ 1,000,000.00$ 1,000,000.00$ 5,000,000.00From FFP Task Orders Sheet
Total:$ 1,000,000.00$ 1,000,000.00$ 1,000,000.00$ 1,000,000.00$ 1,000,000.00$ 5,000,000.00
$ 5,000,000.00
$ - 0

Direct Labor Rate Schedule

Direct Labor Rate Schedule
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
CLIN 0001: Year 1CLIN 1001: Year 2CLIN 2001: Year 3CLIN 3001: Year 4CLIN 4001: Year 5
Labor CategoriesSCA IdentifierLabor TypeProposed Labor RateOT RateBasis for Rate ProposedEscalationProposed Labor RateOT RateEscalationProposed Labor RateOT RateEscalationProposed Labor RateOT RateEscalationProposed Labor RateOT Rate
Government Site
Welder Project Leadern/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Journeyperson Machinistn/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Journeyperson Weldern/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
General Laborern/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Gunsmith Machinistn/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Material/Supply Techniciann/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
CNC Operator Techniciann/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sheetmetal Workern/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
CNC Cutting Table Techniciann/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
(CAM) Program Designer (PD)n/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Experimental Weldern/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Paintern/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Painter Leadern/aProfessional$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Please enter all the corresponding labor categories proposed in the labor detail spreadhseets.

Indicate the basis of the proposed rates and provide documentation to substantiate the rates, such as pay stubs, signed employee letters of intent, etc. If the rates are based on estimates please provide salary survey data and other data to corroborate the rates.

Please provide the basis of escalation.

T&M Fully Burdened Labor Rates

Direct Labor Rate Schedule
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
CLIN 0001: Year 1CLIN 1001: Year 2CLIN 2001: Year 3CLIN 3001: Year 4CLIN 4001: Year 5
Labor CategoriesProposed Labor RateOT RateProposed Labor RateOT RateEscalationProposed Labor RateOT RateEscalationProposed Labor RateOT RateEscalationProposed Labor RateOT Rate
Government Site
Welder Project Leader$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Journeyperson Machinist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Journeyperson Welder$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
General Laborer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Gunsmith Machinist$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Material/Supply Technician$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
CNC Operator Technician$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sheetmetal Worker$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
CNC Cutting Table Technician$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
(CAM) Program Designer (PD)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Experimental Welder$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Painter$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Painter Leader$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Labor Detail

Labor Detail Spreadsheet
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
Annual Productive Hours: 1920
Direct LaborIndirect Labor
CLIN 0001: Year 10.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTETotal Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalWelder Project LeaderEnter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalJourneyperson MachinistEnter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalJourneyperson WelderEnter P or S1426,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalGeneral LaborerEnter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalGunsmith MachinistEnter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalMaterial/Supply TechnicianEnter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalCNC Operator TechnicianEnter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalSheetmetal WorkerEnter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalCNC Cutting Table TechnicianEnter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Professional(CAM) Program Designer (PD)Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalExperimental WelderEnter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalPainterEnter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalPainter LeaderEnter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4280,640$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct LaborIndirect Labor
CLIN 1001: Year 20.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTETotal Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalERROR:#REF!Enter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S1426,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4280,640$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct LaborIndirect Labor
CLIN 2001: Year 30.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTETotal Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalERROR:#REF!Enter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S1426,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4280,640$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct LaborIndirect Labor
CLIN 3001: Year 40.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTETotal Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalERROR:#REF!Enter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S1426,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4280,640$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct LaborIndirect Labor
CLIN 4001: Year 50.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)FTETotal Productive HoursHourly Base Pay Rate (Note 5)Fringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalERROR:#REF!Enter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S23,840.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S1426,880.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S35,760.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S611,520.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S11,920.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:4280,640$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Total:403,2000000000000
Weighted Average:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#REF!

OT Labor Detail

Labor Detail Spreadsheet
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
Annual Productive Hours: 1920
Direct LaborIndirect Labor
CLIN 0001: FFP Base Period0.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)OT HoursOT Hourly Base PayFringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalWelder Project LeaderEnter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalJourneyperson MachinistEnter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalJourneyperson WelderEnter P or S806.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalGeneral LaborerEnter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalGunsmith MachinistEnter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalMaterial/Supply TechnicianEnter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalCNC Operator TechnicianEnter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalSheetmetal WorkerEnter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalCNC Cutting Table TechnicianEnter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Professional(CAM) Program Designer (PD)Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalExperimental WelderEnter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalPainterEnter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalPainter LeaderEnter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:2,422$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct LaborIndirect Labor
CLIN 1001: Year 20.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)OT HoursOT Hourly Base PayFringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalERROR:#REF!Enter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S806.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:2,422$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct LaborIndirect Labor
CLIN 2001: Year 30.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)OT HoursOT Hourly Base PayFringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalERROR:#REF!Enter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S806.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:2,422$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct LaborIndirect Labor
CLIN 3001: Year 40.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)OT HoursOT Hourly Base PayFringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalERROR:#REF!Enter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S806.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:2,422$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Direct LaborIndirect Labor
CLIN 4001: Year 50.00%0.00%0.00%0.00%
WD or DB IdentifierLabor TypeLabor Categories (Note 2)Effort To Be Performed By The Prime (P) or Subcontractor (S) (Note 2)If Col e=S, Enter Name of Subcontractor(s) (Note 2)OT HoursOT Hourly Base PayFringe (Note 6a)Overhead (Note 6b)Prime/Sub Hourly Rate Before Application Of Prime G&A & Fee (IF Col C=S Enter Sub Rate) (Note 7)Total Prime & Sub Labor Before Prime G&A & FeeG&A (Note 8)Total Price Before ProfitProfitTotal PriceProposal Fully Burdened Hourly Billing RateWrap Rate
abcdehijkl = i + j+ km = h x lno = m + npq = o + pr = q/hs = r/i
ProfessionalERROR:#REF!Enter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S115.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S806.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S173.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S346.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
ProfessionalERROR:#REF!Enter P or S58.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total:2,422$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Weighted Average:1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#DIV/0!
Total:12,1100000000000
Weighted Average:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0ERROR:#REF!

ODC Detail

ODC Detail Spreadsheet
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
CLINDescriptionODCs (Note 10)Burden/G&A RateG&ATotal ODC
abcde = c x df = c + e
0002ODCs Base Year$ - 0$ - 0
1002ODCs Year 2$ - 0$ - 0
2002ODCs Year 3$ - 0$ - 0
3002ODCs Year 4$ - 0$ - 0
4002ODCs Year 5$ - 0$ - 0
Total$ - 0$ - 0$ - 0
(To Section B)

FFP Task Orders

ODC Detail Spreadsheet
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
CLINDescriptionTotal FFPProposed Fee
abcd
0002FFP Tasks$ 1,000,000.00
1002FFP Tasks$ 1,000,000.00
2002FFP Tasks$ 1,000,000.00
3002FFP Tasks$ 1,000,000.00
4002FFP Tasks$ 1,000,000.00

Total $ 5,000,000.00

Indirect Rate Summary

Indirect Rate Summary Spreadsheet
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
EntityContract TypeFringe RateOverhead RateG&A RateProposed Profit Rate% of Effort Performed by Prime and Subs Based on Labor Hours
Base Year
PRIME CONTRACTOR0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(i.e. 100%)
Year 2
PRIME CONTRACTOR0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(i.e. 100%)
Year 3
PRIME CONTRACTOR0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%(i.e. 100%)
Year 4
PRIME CONTRACTOR0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%
Year 5
PRIME CONTRACTOR0.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 10.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 20.00%0.00%0.00%0.00%0.00%
SUBCONTRACTOR 30.00%0.00%0.00%0.00%0.00%
ETC0.00%0.00%0.00%0.00%0.00%
0.00%

Please enter corresponding indirect rates for the prime and each subcontractor for each of the periods.

Subcontractors may provide data separately in the above format for proprietary reasons.

Provide the necessary narrative describing how the rates were derived and applied, the composition of the allocation pools & bases, and provide any supporting forward rate agreements and DCAA/DCMA agreements/reports.

If rates proposed are based on other than actual rates, please state the reason(s).

Sample Fringe, Overhead, and G&A worksheet schedules follow this tab.

Fringe Worksheet

Fringe Rate Worksheet
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
Fringe Expenses:FY2024 ActualFY2025 ActualFY2026 ActualEstimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
Indirect payroll$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Payroll taxes (FICA, FUTA, SUTA, Workmans Comp)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Vacation (PTO)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Holiday$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sick Leave$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Health/Disability Ins$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Workmans Compensation/Defense Base Act$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Bonuses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Retention Pay$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
401k Match$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Mil Leave$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Breavement$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Insurance$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Pool$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Cost
Entertainment, etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Net Allowable Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Overhead Worksheet

Overhead Rate Worksheet
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
Overhead Expenses:FY2024 ActualFY2025 ActualFY2026 ActualEstimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
$ - 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
$ - 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
$ - 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
Less: FAR 31 Unallowable Cost
Entertainment, etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Net Allowable Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
OH Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
B&P Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

G&A Worksheet

G&A Rate Worksheet
Solicitation Number: TBD
Name of Action: Machine Shop Re-Compete
Prime Contractor/Subcontractor Name/Division:
Period of Performance: 07 December 2026 to 06 December 2031
G&A Expenses:FY2024 ActualFY2025 ActualFY2026 ActualEstimated Year 1Estimated Year 2Estimated Year 3Estimated Year 4Estimated Year 5
Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subscriptions$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Postage$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Printing$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Supplies$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Telephone$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Travel$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Misc$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Recruiting$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Maint$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Equip$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Consultants$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Prof fees$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Filings$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Legal$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total G&A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Less: FAR 31 Unallowable Costs
Interest$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contributions$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Advertising, etc.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Unallowable Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
G&A Pool After Deducting Unallowable Cost$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Allocation Base
Direct Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Fringe$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Overhead (including any unallowable cost)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Other Direct Costs (inclusing any unallowable cost)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total G&A Allocation Base$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

1. GENERAL

Each offeror is to provide a price proposal and accompanying narrative as part of their proposal in response to the solicitation. FAR 15.403-5(b) allows the contracting officer to specify the format of cost or pricing data or data other than certified cost or pricing data. The completed workbook shall be part of the price proposal. This is a required flow down requirement, and therefore shall be submitted for the prime offeror AND for any and all divisions and subcontractors proposed to perform effort in response to this solicitation. The information will be evaluated for fairness, reasonableness, based on the price analysis.

2. OVERALL INSTRUCTIONS

1. The worksheets are designed to automatically compute and populate other cells in the Excel workbook.

2. The worksheet tabs shaded green have inputs required on that worksheet.

3. More detailed instructions follow number 9 below.

4. Type the appropriate name of the Prime Contractor/Subcontractor/Division in Cell H14 on the Instructions worksheet of the LOE Workbook. It will carry through the remaining worksheets.

5. Please enter the requested data in the green shaded areas on the Direct Labor Rate Schedule, which includes the proposed labor rates, the basis for the rate proposed and the escalation rate used. The direct rate information feeds into the Labor Detail worksheet.

6. Please enter the requested data in the green shaded areas on the Labor Detail worksheet, which includes which entity will be performing the work (columns D and E). Column L will only need inputs if the prime offeror is inputting a subcontractor’s fully burdened labor rate into that column.

7. Please enter the requested data in the green shaded areas on the ODC Detail worksheet.

For the purposes of proposal, the Government has input normalized values for the ODCs.

These numbers are to be used. The offerors may add any burden and/or G&A as appropriate. Since these are estimated amounts that may or may not occur, no fixed fee will be allowed on the ODCs.

8. Please enter the requested data in the green shaded areas on the Indirect Rate Summary worksheet.

9. Please enter the requested data in the green shaded areas on the Fringe, Overhead, and G&A worksheets. These worksheets assist in calculating the indirect rates. This will enable the price evaluation team to analyze the indirects. PLEASE NOTE: The rates at the bottom DO NOT carry over to the Indirect Rate Summary.

3. SECTION B WORKSHEET

The Section B worksheet imports data from the Price Summary, Labor Detail, and ODC Detail worksheets and is used as a basis for the proposed formal Section B. Please note that there are three cells that may turn green. THESE ARE NOT INPUTS. It is a different shade of green and is only used as a check to ensure the final price on the Section B worksheet agrees with the summations pulled from the other worksheets.

4. PRICE SUMMARY WORKSHEET

This worksheet is for Government analysis purposes. It is populated from the Labor Detail and ODC Detail worksheets.

5. DIRECT LABOR RATE SCHEDULE WORKSHEET

Enter the requested data in the green shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for price analysis and contract administration purposes.

6. LABOR DETAIL WORKSHEET

Enter the requested data in the green shaded cells. It may be necessary for each offeror to revise the number of rows, columns, and/or formulas to reflect nuances in the offeror's accounting and estimating systems. However, it is requested that the general format be maintained as much as possible for price analysis and contract administration purposes. For specific instructions, see the Notes that follow.

NOTE 1: NOT USED.

NOTE 2: Column C of the Labor Detail worksheet contains several labor categories. During contract performance these categories may be performed by the prime contractor and/or other divisions or subcontractors. The offeror is to enter a ‘P’ in column D if the effort is to be performed by the prime contractor and a ‘S’ if performed by another division or subcontractor.

Enter the name of the division or subcontractor in column E. If the particular individual category is to be performed by more than one entity, the offeror will be required to insert additional row(s) under the labor category and to allocate the FTEs in column F and the hours in columns G and H for the individual category in column C for the original and inserted rows to reflect the proposed performance during the contract. After this allocation, the total of the original and inserted rows under the individual category shall total to the number of hours provided by the Government for the respective labor category.

NOTE 3: For the purposes of this solicitation, the hours worked under a FTE shall consist of the hours worked by an individual employee and not multiple employees (i.e. 1 FTE = 1 employee).

One FTE shall not be split among two or more employees.

NOTE 4: Do not modify the productive hour amounts in this column. The productive hours in this column are estimated productive hours that may or may not be ordered by the Government during the contract and are based on a 1,920 hour work year per FTE. Productive hours are the total hours in a work year less any days not actually worked (i.e. not including holidays, sick days, vacations, etc). Productive hours are hours that will actually be worked and billed to the contract. For the purposes of this solicitation please assume a 40 hour work week NOT to include overtime or uncompensated overtime.

NOTE 5: The hourly base pay rate copies over from the Direct Labor Rate Schedule. The base labor rate is the rate actual paid to the employee EXCLUSIVE of social security, federal unemployment, state unemployment, workman's compensation, non-statutory fringe benefits (i.e.

401K, vacations, holidays, etc), overhead, G&A, and fee. For proprietary reason, subcontractors may provide this information directly to the Contracting Officer if the subcontractor chooses not to disclose this information to the offeror. Escalation on wages in out years for Service Contract

Act positions is unallowable except where the Collective Bargaining Agreement and/or Wage Determinations indicate otherwise.

NOTE 6a: Apply fringe to prime offeror derived rates. ‘Fringe Worksheet’ provides a sample to be used to compute the fringe rate. Provide a schedule and describe all elements included in the fringe benefit rate. Fringe shall include social security, federal unemployment, state unemployment, workman's compensation, and non-statutory fringe benefits (i.e. 401K, vacations, holidays, etc). If the offeror's accounting system applies fringe and overhead together, use only one of the worksheets and clearly indicate this in the proposal. The rate will carry over from the Indirect Rate Summary.

NOTE 6b: Apply overhead to prime offeror derived rates. ‘Overhead Worksheet’ provides a sample to be used to compute the overhead rate. Provide a schedule and describe all elements included in the overhead rate. If the offeror's accounting system applies fringe and overhead together, use only one of the worksheets and clearly indicate this in the proposal. The rate will carry over from the Indirect Rate Summary.

NOTE 7: This field will automatically calculate the prime hourly burdened rate before the application of G&A and fee. If the prime is proposing the use of a subcontractor, please enter the subcontractor billing rate (if performed by a subcontractor) BEFORE application of prime G&A expense and fixed fee. Therefore, the rate calculated for prime contractor performed rate categories is as follows: rate = prime base labor rate + prime fringe + prime overhead.

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .