J-1_Labor_and_Material_Price_Sheet.xlsx
XLSX spreadsheet 75 KB Posted
- Solicitation number
- N5005419R0023
About this file
This document contains an indirect rate proposal from L-3 Unidyne, Inc. in support of their bid for the Navy's solicitation for MK-41 Vertical Launch System Repair & Refurbishment. L-3 Unidyne provides their fully burdened labor rates and material pricing sheets for the base year and four option years of the contract. They include their G&A, overhead, and material handling expense pool details and rates for 2017-2018 which were used to develop their pricing. The solicitation from the Naval Sea Systems Command requires MK-41 Vertical Launch System Repair & Refurbishment services in support of the Mid-Atlantic Regional Maintenance Center, with responses due on an unspecified date. L-3 Unidyne's indirect rate proposal and pricing sheets were provided to support their bid response.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Bidder's_Questions_and_Answers_(016).pdf | ||
| Amendment_0001_SF30_N5005419R0023.pdf | ||
| Amendment 0001 SF-30 RFP N5005419R0017.pdf | ||
| Bidder's_Questions_and_Answers_(001-015).pdf | ||
| J-10_Request_for_Specification_Clarification.docx | DOCX document | |
| J-9_Past_Performance_Assessment_Questionnaire.docx | DOCX document | |
| J-8_Past_Performance_Reference_List.docx | DOCX document | |
| J-3_LWT_042-037.pdf | ||
| J-6 -Small-Business-Participation-Plan-Table.xlsx | XLSX spreadsheet | |
| J-4_SWT_042-001.pdf | ||
| J-11_Ship_Access_Form.xlsx | XLSX spreadsheet | |
| J-10_Request_for_Specification_Clarification.docx | DOCX document | |
| J-7_Capacity_Evaluation_Form.xlsx | XLSX spreadsheet | |
| RFP-N5005419R0023.docx | DOCX document | |
| J-2_CDRLs.pdf | ||
| J-9_Past_Performance_Assessment_Questionnaire.docx | DOCX document | |
| J-5_SWT_077-001.pdf |
Show all 17
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
J1 Labor and Matl Price Sheet
Offeror Name:
| CLIN 1001 (BASE) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 69,405 | $0 | 69,405 | $0 | |
| Total Labor | 69,405 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Material | $1,800,000 | |
| Total Material Price | $1,800,000 |
Total Base Year 69,405 $1,800,000
| CLIN 2001 (OPTION PERIOD 1) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 69,405 | $0 | 69,405 | $0 | |
| Total Labor | 69,405 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Material | $1,800,000 | |
| Total Material Price | $1,800,000 |
Total Option Period 1 69,405 $1,800,000
| CLIN 3001 (OPTION PERIOD 2) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 69,405 | $0 | 69,405 | $0 | |
| Total Labor | 69,405 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Matieral | $1,800,000 | |
| Total Material Price | $1,800,000 |
Total Option Period 2 69,405 $1,800,000
| CLIN 4001 (OPTION PERIOD 3) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 69,405 | $0 | 69,405 | $0 | |
| Total Labor | 69,405 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Material | $1,800,000 | |
| Total Material Price | $1,800,000 |
Total Option Period 3 69,405 $1,800,000
| CLIN 5001 (OPTION PERIOD 4) | |||||
| Fully Burdened Ship Repair Labor Rate | TOTAL | ||||
| Hours | Rate | Price | Total Hours | Total Price | |
| Direct Production Labor Hours | 69,405 | $0 | 69,405 | $0 | |
| Total Labor | 69,405 | $0 |
| Material Burden Rate | Insert Rate -> | |
| Material | $1,800,000 | |
| Total Material Price | $1,800,000 |
Total Option Period 4 69,405 $1,800,000
Total Evaluated Price Base & Options = Sum of Base and Option Year Totals 347,025 $9,000,000
| 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
| J:\USFF_NRFK_N50054_MARMC3\MARMC_DEPT_400\BRC_413\C413 Pre Awards\VLS PRE AWARD\Position II - Solicitation\Solicitation\Attachments\[J1-_Labor_and_Material_Price_Sheet.xlsx]9. Forecasted Rates | 12/11/19 | 10:52 | |||||||||
| 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 .