J1-_Labor_and_Material_Price_Sheet.xlsx
XLSX spreadsheet 78 KB Posted
- Attached to
- Combat Systems Repair and Refurbishment Federal contract opportunity
- Solicitation number
- N5005420R0001
About this file
This document contains a labor and material price sheet submitted in response to a solicitation for Combat Systems Repair and Refurbishment in support of the Mid-Atlantic Regional Maintenance Center. The price sheet includes fully burdened labor rates and material prices for the base year and four option periods. Pricing is provided for CLIN 0001 for the base year and CLINs 0101 through 0401 for the four option periods. Total evaluated pricing for the base year and all option periods is $4,762,103. Supporting documentation is included showing the contractor's indirect rates for overhead, G&A, MHX, and overhead at the company and customer sites for 2017 through 2023. The solicitation was issued by the Department of the Navy Naval Sea Systems Command for Combat Systems Repair and Refurbishment in support of MARMC.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Amendment_0004_SF30_N5005420R0001.pdf | ||
| Bidders_Questions_and_Answers_(007-008).pdf | ||
| Amendment_0003_SF30_N5005420R0001.pdf | ||
| Bidders_Questions_and_Answers_(005-006).pdf | ||
| Bidders_Questions_and_Answers_(002_004).pdf | ||
| Amendment_0002_SF30_N5005420R0001.pdf | ||
| Amendment_0001_SF30_N5005420R0001.pdf | ||
| Bidders_Questions_and_Answers_(001).pdf | ||
| RFP- N5005420R0001.pdf | ||
| J-3_LWT_042-037.pdf | ||
| J-5_SWT_077-001.pdf | ||
| J-7_Capacity_Evaluation_Form.xlsx | XLSX spreadsheet | |
| J-4_SWT_042-001.pdf | ||
| J-9_Past_Performance_Assessment_Questionnaire.docx | DOCX document | |
| J-10_Request_for_Specification_Clarification.docx | DOCX document | |
| J-2_CDRLs.pdf | ||
| J-11 SHIP ACCESS FORM.xlsx | XLSX spreadsheet | |
| J-6 -Small-Business-Participation-Plan-Table.xlsx | XLSX spreadsheet | |
| J-8_Past_Performance_Reference_List.docx | DOCX document |
Show all 19
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
J1 Labor and Matl Price Sheet
Offeror Name:
| CLIN 0001 (BASE) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 80,086 | $0 | 80,086 | $0 | |
| Total Labor | 80,086 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Material | $934,138 | |
| Total Material Price | $934,138 |
Total Base Year 80,086 $934,138
| CLIN 0101 (OPTION PERIOD 1) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 80,086 | $0 | 80,086 | $0 | |
| Total Labor | 80,086 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Material | $942,755 | |
| Total Material Price | $942,755 |
Total Option Period 1 80,086 $942,755
| CLIN 0201 (OPTION PERIOD 2) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 80,086 | $0 | 80,086 | $0 | |
| Total Labor | 80,086 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Matieral | $952,183 | |
| Total Material Price | $952,183 |
Total Option Period 2 80,086 $952,183
| CLIN 0301 (OPTION PERIOD 3) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 80,086 | $0 | 80,086 | $0 | |
| Total Labor | 80,086 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Material | $961,705 | |
| Total Material Price | $961,705 |
Total Option Period 3 80,086 $961,705
| CLIN 0401 (OPTION PERIOD 4) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 80,086 | $0 | 80,086 | $0 | |
| Total Labor | 80,086 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Material | $971,321 | |
| Total Material Price | $971,321 |
Total Option Period 4 80,086 $971,321
Total Evaluated Price Base & Options = Sum of Base and Option Year Totals 400,430 $4,762,103
| NOTES: | Attachment J1 |
| 1. Fully Burdened Ship Repair Labor Rates must be entered as dollars and cents. | |
| 2. Labor Price is calculated as follows: Rate*Hours | |
| 3. Total Material is calculated as follows: Material * (1+ Material Burden Rate) |
9. Forecasted Rates
| \\Naeanrfkfs101v.nadsusea.nads.navy.mil\cs021$\USFF_NRFK_N50054_MARMC3\MARMC_DEPT_400\BRC_413\C413 Pre Awards\Combat Systems\Solicitation\Attachments\[J1-_Labor_and_Material_Price_Sheet.xlsx]9. Forecasted Rates | 3/4/20 | 8:30 | |||||||||
| 2018 Estimated Indirect Rates | L-3 Unidyne, Incorporated | ||||||||||
| 2017 | 2017 | 2017 | 2018 | 2018 | 2018 | ||||||
| Pool | Rate % | Rate | Pool | Base | Double Check | Pool | Base | Rate % | Pool | Base | Rate % |
OH Company Site 59.80% 0.5980 16,212,858 27,112,616 59.80% 16,879,602 26,580,996 63.50% 16,212,858 27,112,616 59.80%
OH Customer Site 43.17% 0.4317 1,473,892 3,414,494 43.17% 1,534,505 3,347,543 45.84% 1,473,892 3,414,494 43.17%
G&A 19.75% 0.1975 10,316,895 52,240,514 19.75% 10,741,171 51,216,190 20.97% 10,316,895 52,240,514 19.75%
MHX 3.17% 0.0317 1,095,124 34,527,249 3.17% 1,140,160 33,850,244 3.37% 1,095,124 34,527,249 3.17%
For Cost of Money Purposes continue to use the 2017 approved rates:
FCCM - OH 0.132% 0.00132
FCCM - OH CUST N/A N/A
FCCM - G&A 0.019% 0.00019
FCCM - MHX 0.002% 0.00002
&"times,Regular"&9See Source Selection FAR 2.101 and 3.104 &"times,Regular"&9L-3 Unidyne Proprietary Information &"times,Regular"&9&P of &N
10. Indirect Rate Support Sample Indirect Rate Supporting Documentation
| Budget | Actual Expenses | |||
| Overhead Expense | 2016 | 2015 | 2014 | 2013 |
| Payroll Taxes | REFER TO INDIVIDUAL INDIRECT RATE TABS 10A THROUGH 10D FOR FULL DETAILS | |||
| Vacation | ||||
| Holiday | ||||
| Sick Leave | ||||
| Pensions | ||||
| Office Equipment | ||||
| Depreciation | ||||
| Travel | ||||
| Reproduction | ||||
| Rent | ||||
| Advertising | ||||
| Insurance | ||||
| Telephone | ||||
| Total Pool |
| Less Unallowable Costs |
| Entertainment |
| Net Allowable Costs |
| Allocation Base |
| Direct Labor |
Overhead Rate
| *Contributing Government Contracts | Expiration Date | Value of Contracts |
| N000XX-XX-X-00XX | ||
| N000XX-XX-X-00XX | ||
| N000XX-XX-X-00XX |
| * When developing your percentage, these are the contracts contributing |
| to development of the percentage. |
&"times,Regular"&9See Source Selection FAR 2.101 and 3.104 &"times,Regular"&9L-3 Unidyne Proprietary Information &"times,Regular"&9&P of &N
10A. G&A Indirect Rate Details G&A Indirect Rate Supporting Documentation
| Overhead Expense | 2017 Provisional | 2018-23 Forecast |
| Labor | $ 4,286,257 | $ 4,116,950 |
| Travel | $ 210,205 | $ 201,902 |
| Depreciation | $ 87,000 | $ 83,564 |
| Fringe Benefits (Vacation, Holiday, Med) | $ 1,421,429 | $ 1,365,283 |
| Corp Allocations & Support | $ 3,165,596 | $ 3,040,555 |
| Training & Ed | $ 20,000 | $ 19,210 |
| Bus Licenses | $ 190,000 | $ 182,495 |
| Computer Software | $ 434,000 | $ 416,857 |
| Repairs & Mntce | $ 25,000 | $ 24,013 |
| Utilities / Telephone | $ 183,648 | $ 176,394 |
| All Other Misc G&A Expenses | $ 718,036 | $ 689,674 |
Total G&A Pool $ 10,741,171 $ 10,316,895
Less Unallowable Costs
Net Allowable Costs $ 10,741,171 $ 10,316,895
| G&A Allocation Base | ||
| Direct Labor & Overhead Applied to DL & Fringe | $ 51,216,190 | $ 52,240,514 |
G&A Indirect Rate 20.97% 19.75%
*Contributing Government Contracts Expiration Date Value of Contracts
| * When developing your percentage, these are the contracts contributing |
| to development of the percentage. |
&"times,Regular"&9See Source Selection FAR 2.101 and 3.104 &"times,Regular"&9L-3 Unidyne Proprietary Information &"times,Regular"&9&P of &N
10B. MHX Indirect Rate Details MHX Indirect Rate Supporting Documentation
| Overhead Expense | 2017 Provisional | 2018-23 Forecast |
| Labor | $ 767,750 | $ 737,424 |
| Travel | $ 6,000 | $ 5,763 |
| Depreciation | $ 15,000 | $ 14,408 |
| Fringe Benefits (Vacation, Holiday, Med) | $ 272,910 | $ 262,130 |
| Training & Ed | $ 1,000 | $ 961 |
| Repairs & Mntce | $ 4,000 | $ 3,842 |
| Utilities / Telephone | $ 14,000 | $ 13,447 |
| All Other Misc MHX Expenses (Rent) | $ 59,500 | $ 57,150 |
Total MHX Pool $ 1,140,160 $ 1,095,124
Less Unallowable Costs
Net Allowable Costs $ 1,140,160 $ 1,095,124
| MHX Allocation Base | ||
| Direct Material & Subcontractors | $ 33,850,244 | $ 34,527,249 |
MHX Indirect Rate 3.37% 3.17%
*Contributing Government Contracts Expiration Date Value of Contracts
| * When developing your percentage, these are the contracts contributing |
| to development of the percentage. |
&"times,Regular"&9See Source Selection FAR 2.101 and 3.104 &"times,Regular"&9L-3 Unidyne Proprietary Information &"times,Regular"&9&P of &N
10C. OHCustIndirectRateDetails Overhead Customer Site Indirect Rate Supporting Documentation
| Overhead Expense | 2017 Provisional | 2018-23 Forecast |
| Labor | $ 194,125 | $ 186,457 |
| Fringe Benefits (Vacation, Holiday, Med) | $ 1,340,380 | $ 1,287,435 |
Total Customer Site Pool $ 1,534,505 $ 1,473,892
Less Unallowable Costs
Net Allowable Costs $ 1,534,505 $ 1,473,892
| Customer Site Allocation Base | ||
| Customer Site Direct Labor | $ 3,347,583 | $ 3,414,535 |
Customer Site Overhead Rate 45.84% 43.17%
*Contributing Government Contracts Expiration Date Value of Contracts
| * When developing your percentage, these are the contracts contributing |
| to development of the percentage. |
&"times,Regular"&9See Source Selection FAR 2.101 and 3.104 &"times,Regular"&9L-3 Unidyne Proprietary Information &"times,Regular"&9&P of &N
10D. OHCoIndirectRateDetails Overhead Company Site Indirect Rate Supporting Documentation
Overhead Expense 2017 Provisional 2018-23 Forecast
| Labor | $ 1,796,398 | $ 1,725,440 |
| Travel | $ 200,000 | $ 192,100 |
| Depreciation | $ 762,000 | $ 731,901 |
| Fringe Benefits (Vacation, Holiday, Med) | $ 10,457,062 | $ 10,044,008 |
| Rent | $ 1,119,000 | $ 1,074,800 |
| Training & Ed | $ 101,000 | $ 97,011 |
| Propertt Taxes | $ 343,000 | $ 329,452 |
| Computer related | $ 162,000 | $ 155,601 |
| Repairs & Mntce | $ 500,000 | $ 480,250 |
| Utilities / Telephone | $ 889,142 | $ 854,021 |
| All Other Misc | $ 550,000 | $ 528,275 |
Total Company Site Overhead Pool $ 16,879,602 $ 16,212,857
Less Unallowable Costs
Net Allowable Costs $ 16,879,602 $ 16,212,857
| Company Site Allocation Base | ||
| Company Site Direct Labor | $ 26,580,996 | $ 27,112,616 |
Company Site Overhead Rate 63.50% 59.80%
*Contributing Government Contracts Expiration Date Value of Contracts
| * When developing your percentage, these are the contracts contributing |
| to development of the percentage. |
&"times,Regular"&9See Source Selection FAR 2.101 and 3.104 &"times,Regular"&9L-3 Unidyne Proprietary Information &"times,Regular"&9&P of &N
File details come from the government source that posted it. Updated .