Attachment_L-04_-_EPW_17-R-DH02.xlsx

XLSX spreadsheet 45 KB Posted

Attached to
Radar Division Scientific and Engineering Support Federal contract opportunity
Solicitation number
N00173-17-R-DH02
Issued by
Department of the Navy Secretary of the Navy Office of Naval Research

About this file

Excel Pricing Workbook

View the file

Other files for this federal contract opportunity

Show all 14

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

L-04 (a) Indirect Rates

Attachment L-04 (a)
Indirect Rate & ODC's
Instructions:
Only input/change data in blue cells.
1. L-04 (a): Indirect Rates & ODC's - Input rates for all 5 years. Material and Travel amounts are given, total will adjust with G&A and M&H when applicable.

2. L-04 (b): Unburdened Direct Labor Rates - Input labor rates for Year 1 for each category and provide name of employee, remaining years will populate based on data from L-4 (a).

3. L-04 (c): Input hours for each labor category into L-04 (c) for each year (each year is on a separate page).

4. L-04 (d): Confirm totals.

Indirect RatesYear 1Year 2Year 3Year 4Year 5
Fringe Rate %0.00%0.00%0.00%0.00%0.00%
Overhead Rate %0.00%0.00%0.00%0.00%0.00%
G&A Rate %0.00%0.00%0.00%0.00%0.00%
Fee %0.00%0.00%0.00%0.00%0.00%
Escalation Rate %0.00%0.00%0.00%0.00%0.00%
Material handling Rate %0.00%0.00%0.00%0.00%0.00%
Travel Estimate$36,643.75$37,010.19$37,380.29$37,754.09$38,131.63
Travel w/ G&A$36,643.75$37,010.19$37,380.29$37,754.09$38,131.63
Material$50,000.00$50,500.00$51,005.00$51,515.05$52,030.20
Material w/ G&A $ M/H$50,000.00$50,500.00$51,005.00$51,515.05$52,030.20
Annual Total$86,643.75$87,510.19$88,385.29$89,269.14$90,161.83
Combined Travel Total$186,919.95
Combined Material Total$255,050.25

&"Times New Roman,Regular"Attachment L-04

N00173-17-R-DH02

L-04 (b) Labor Rates

Attachment L-04 (b)
Unburdened Direct Labor Rate
Labor CategoryEmployee NameYear 1Year 2Year 3Year 4Year 5
Labor Category 1$0.00$0.00$0.00$0.00$0.00
Labor Category 2$0.00$0.00$0.00$0.00$0.00
Labor Category 3$0.00$0.00$0.00$0.00$0.00
Labor Category 4$0.00$0.00$0.00$0.00$0.00
Labor Category 5$0.00$0.00$0.00$0.00$0.00
Labor Category 6$0.00$0.00$0.00$0.00$0.00
Labor Category 7$0.00$0.00$0.00$0.00$0.00
Labor Category 8$0.00$0.00$0.00$0.00$0.00
Labor Category 9$0.00$0.00$0.00$0.00$0.00
Labor Category 10$0.00$0.00$0.00$0.00$0.00
Labor Category 11$0.00$0.00$0.00$0.00$0.00
Labor Category 12$0.00$0.00$0.00$0.00$0.00
Labor Category 13$0.00$0.00$0.00$0.00$0.00
Labor Category 14$0.00$0.00$0.00$0.00$0.00
Labor Category 15$0.00$0.00$0.00$0.00$0.00
Labor Category 16$0.00$0.00$0.00$0.00$0.00
Labor Category 17$0.00$0.00$0.00$0.00$0.00
Labor Category 18$0.00$0.00$0.00$0.00$0.00
Labor Category 19$0.00$0.00$0.00$0.00$0.00
Labor Category 20$0.00$0.00$0.00$0.00$0.00
Labor Category 21$0.00$0.00$0.00$0.00$0.00
Labor Category 22$0.00$0.00$0.00$0.00$0.00
Labor Category 23$0.00$0.00$0.00$0.00$0.00
Labor Category 24$0.00$0.00$0.00$0.00$0.00
Labor Category 25$0.00$0.00$0.00$0.00$0.00
Labor Category 26$0.00$0.00$0.00$0.00$0.00
Labor Category 27$0.00$0.00$0.00$0.00$0.00

L-04(c) Year 1-5 Burdended Rate

Attachment L-04 (c)
Years 1 - 5 Burdended Rates
Proposed Rates & FactorsYear 1Year 2Year 3Year 4Year 5
Fringe (Direct Labor)0.00%0.00%0.00%0.00%0.00%
Onsite Direct Labor OH0.00%0.00%0.00%0.00%0.00%
General & Administrative0.00%0.00%0.00%0.00%0.00%
Fee (Prime Labor)0.00%0.00%0.00%0.00%0.00%

Subject to FPRA? (Yes/No):

Year 1
Labor CategoryEst HoursProposed Unburdened Direct Labor RateFringe Rate %O/H Rate %G&A Rate %Fee %Loaded Labor RateTotal Dollars (Est Hrs x Loaded Rt)
Labor Category 10$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 20$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 30$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 40$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 50$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 60$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 70$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 80$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 90$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 100$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 110$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 120$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 130$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 140$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 150$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 160$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 170$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 180$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 190$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 200$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 210$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 220$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 230$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 240$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 250$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 260$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 270$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Total0$0.00
Year 2
Labor CategoryEst HoursProposed Unburdened Direct Labor RateFringe Rate %O/H Rate %G&A Rate %Fee %Loaded Labor RateTotal Dollars (Est Hrs x Loaded Rt)
Labor Category 10$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 20$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 30$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 40$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 50$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 60$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 70$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 80$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 90$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 100$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 110$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 120$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 130$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 140$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 150$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 160$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 170$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 180$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 190$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 200$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 210$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 220$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 230$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 240$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 250$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 260$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 270$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Total0$0.00
Year 3
Labor CategoryEst HoursProposed Unburdened Direct Labor RateFringe Rate %O/H Rate %G&A Rate %Fee %Loaded Labor RateTotal Dollars (Est Hrs x Loaded Rt)
Labor Category 10$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 20$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 30$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 40$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 50$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 60$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 70$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 80$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 90$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 100$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 110$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 120$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 130$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 140$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 150$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 160$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 170$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 180$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 190$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 200$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 210$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 220$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 230$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 240$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 250$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 260$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 270$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Total0$0.00
Year 4
Labor CategoryEst HoursProposed Unburdened Direct Labor RateFringe Rate %O/H Rate %G&A Rate %Fee %Loaded Labor RateTotal Dollars (Est Hrs x Loaded Rt)
Labor Category 10$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 20$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 30$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 40$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 50$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 60$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 70$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 80$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 90$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 100$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 110$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 120$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 130$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 140$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 150$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 160$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 170$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 180$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 190$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 200$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 210$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 220$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 230$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 240$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 250$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 260$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 270$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Total0$0.00
Year 5
Labor CategoryEst HoursProposed Unburdened Direct Labor RateFringe Rate %O/H Rate %G&A Rate %Fee %Loaded Labor RateTotal Dollars (Est Hrs x Loaded Rt)
Labor Category 10$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 20$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 30$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 40$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 50$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 60$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 70$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 80$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 90$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 100$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 110$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 120$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 130$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 140$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 150$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 160$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 170$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 180$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 190$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 200$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 210$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 220$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 230$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 240$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 250$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 260$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Labor Category 270$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Total0$0.00

L-04 (d) Cost Proposal Total

Attachment L-04(d)
COST SUMMARY FORMAT (CPFF)
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Total for All YearsYear 1Year 2Year 3Year 4Year 5
Cost ElementsLabor CategoryHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Employee Name 1
Employee Name 2
Etc.
Total Direct Labor Cost
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost
COM
Total Prime Contractor Labor Cost
Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor 1
Subcontractor 2
Etc.
Total proposed subcontractor labor cost and fee
Prime contractor pass through (not including fee)
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through

Total Labor Cost (Prime and Subcontractor Labor)

Fee
Prime Contractor Fee for Prime Contractor Labor
Fixed Fee
Prime Contractor Fee for Subcontractor Labor
Fixed Fee
Total Fee (for Prime and Subcontractor Labor)
Fixed Fee

Total Labor Cost Plus Fixed Fee (CPFF)

Other Direct Costs
Other Direct Costs (ODCs)
Any adders to ODCs such as G&A, Handling
Fixed Fee
Total ODCs

Total CPFF CLINs

Pass Through Analysis - Total for All YearsAmountPercent
Subcontractor proposed cost and fee
Pass Through Amount (not including fee)
Prime Contractor Fee for Subcontractor Labor *
Total Pass Through Amount (including fee)

N00173-16-R-DH02

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