Copy of Multi-Year_Multi-Clin_Proposal_Template 2019.xls
XLS spreadsheet 214 KB Posted
- Attached to
- Helicopter Assembly Parts
- Solicitation number
- SPE7LX-21-R-0123
View the file
Other files
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
Cover Page
| Double click on WORD icon to open the Cover Page template. | |
| For additional assistance, go to the DCAA website - WWW.DCAA.MIL | |
| Highlight Select 'Guidance' tab to show drop-down menu | |
| Select from drop-down menu 'Audit Process Overview - Information for Contractors' | |
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | |
| THIS INFORMATION IS FOR EDUCATION ONLY |
Summary Whole Contract
| * Company Name * | ||||||||||||
| Request for Proposal SPMXXX-19-R-0000 | ||||||||||||
| Summary - Total Proposed Costs for all NSNs | ||||||||||||
| *HINT: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | ||||||||||||
| Base Period - FY 2019 | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | All Years | |||||||
| Element of Cost | Rate | Unit Price | Rate | Unit Price | Rate | Unit Price | Rate | Unit Price | Rate | Unit Price | Total | Reference |
| Material | $ 618,150.00 | $ 649,057.50 | $ 681,510.38 | $ 715,585.89 | $ 751,365.19 | $ 3,415,668.96 | Schedule A | |||||
| Material Overhead | 15.07% | 93,155.21 | 15.13% | 98,202.40 | 15.18% | 103,453.27 | 15.22% | 108,912.17 | 15.27% | 114,733.46 | $ 518,456.52 | Schedule B |
| Direct Labor | 72,080.00 | $ 73,521.60 | $ 74,992.03 | $ 76,491.87 | $ 78,021.71 | $ 375,107.21 | Schedule C | |||||
| Labor Overhead | 32.69% | 23,562.95 | 32.58% | 23,953.34 | 33.09% | 24,814.86 | 33.07% | 25,295.86 | 32.97% | 25,723.76 | $ 123,350.77 | Schedule D |
| Subtotal | 806,948.16 | 844,734.84 | 884,770.55 | 926,285.80 | 969,844.12 | $ 4,432,583.46 | ||||||
| G&A | 61.25% | 494,255.75 | 60.38% | 510,089.88 | 56.96% | 504,003.22 | 54.37% | 503,590.71 | 51.06% | 495,226.65 | $ 2,507,166.22 | Schedule E |
| Total Cost | 1,301,203.90 | 1,354,824.72 | 1,388,773.77 | 1,429,876.52 | 1,465,070.77 | $ 6,939,749.68 | ||||||
| Profit | 10.00% | 130,120.39 | 10.00% | 135,482.47 | 10.00% | 138,877.38 | 10.00% | 142,987.65 | 10.00% | 146,507.08 | $ 693,974.97 | |
| Total Price | $ 1,431,324.29 | $ 1,490,307.19 | $ 1,527,651.15 | $ 1,572,864.17 | $ 1,611,577.85 | $ 7,633,724.65 | ||||||
| HINT 2: DELETE Surge section below if surge is not required or in the solicitation | ||||||||||||
| Surge | ||||||||||||
| Base Period - FY 2016 | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | All Years | |||||||
| Element of Cost | Rate | Unit Price | Rate | Unit Price | Rate | Unit Price | Rate | Unit Price | Rate | Unit Price | Total | Reference |
| Material | $ - 0 | |||||||||||
| Material Overhead | 15.07% | $ - 0 | 15.13% | $ - 0 | 15.18% | $ - 0 | 15.22% | $ - 0 | 15.27% | $ - 0 | $ - 0 | |
| Direct Labor | $ - 0 | |||||||||||
| Mfg Overhead | 32.69% | $ - 0 | 32.58% | $ - 0 | 33.09% | $ - 0 | 33.07% | $ - 0 | 32.97% | $ - 0 | $ - 0 | |
| Subtotal | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| G&A | 61.25% | $ - 0 | 60.38% | $ - 0 | 56.96% | $ - 0 | 54.37% | $ - 0 | 51.06% | $ - 0 | $ - 0 | |
| Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Profit | 10.00% | $ - 0 | 10.00% | $ - 0 | 10.00% | $ - 0 | 10.00% | $ - 0 | 10.00% | $ - 0 | $ - 0 | |
| Total Price | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Explanatory Note: | ||||||||||||
| This data summarizes costs for all solicitation NSNs | ||||||||||||
| **HINT 3: The following identifying information can be embeded within the spreadsheet or in the Footer Section of the spreadsheet | ||||||||||||
| **Proprietary Information | ||||||||||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | ||||||||||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | ||||||||||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION.
THIS INFORMATION IS FOR EDUCATION ONLY
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A&R&12
NSN Summary ALT 1A
| * Company Name * | ||||
| Request for Proposal SPMXXX-19-R-0000 | ||||
| Schedule of Unit Cost and Total Cost by Cost Element | ||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | ||||
| CLIN 0001 NSN 1234-56-789-xxxx - See Comments below | ||||
| Element of Cost | Unit Price | Total Amount | Reference | |
| Material | $ 1,159.50 | $ 463,800.00 | Schedule A | |
| Material Overhead | 15.07% | $ 174.74 | $ 69,894.66 | Schedule B |
| Subtotal | $ 1,334.24 | $ 533,694.66 | ||
| Direct Labor | $ 63.20 | $ 25,280.00 | Schedule C | |
| Direct Labor Overhead | 32.69% | $ 20.66 | $ 8,264.03 | Schedule D |
| Subtotal | $ 1,418.10 | $ 567,238.69 | ||
| G&A | 61.25% | $ 868.58 | $ 347,433.70 | Schedule E |
| Total Cost | $ 2,286.68 | $ 914,672.39 | ||
| Profit | 10.00% | $ 228.67 | $ 91,467.24 | |
| Total Price | $ 2,515.35 | $ 1,006,139.63 | ||
| Annual Demand Quantity (ADQ) | 400 | |||
| Explanatory Note: | ||||
| This data summarizes costs for five years OR Base Year plus Option | ||||
| **Proprietary Information | ||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | ||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | ||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IS FOR EDUCATION ONLY&R
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A
NSN Summary ALT 1B
| Company Name * | ||||
| Request for Proposal SPMXXX-19-R-0000 | ||||
| Schedule of Unit Cost and Total Cost by Cost Element | ||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | ||||
| CLIN 0002 NSN 0000-56-789-xxxx - See Comments Below | ||||
| Element of Cost | Unit Price | Total Amount | Reference | |
| Material | $ 343.00 | $ 154,350.00 | Schedule A | |
| Material Overhead | 15.07% | $ 51.69 | $ 23,260.55 | Schedule B |
| Subtotal | $ 394.69 | $ 177,610.55 | ||
| Direct Labor | $ 104.00 | $ 46,800.00 | Schedule C | |
| Direct Labor Overhead | 32.69% | $ 34.00 | $ 15,298.92 | Schedule D |
| Subtotal | $ 532.69 | 239,709 | ||
| G&A | 61.25% | $ 326.27 | $ 146,822.05 | Schedule E |
| Total Cost | $ 858.96 | 386,531.51 | ||
| Profit | 10.00% | $ 85.90 | $ 38,653.15 | |
| Total Price | $ 944.85 | $ 425,184.66 | ||
| Annual Demand Quantity (ADQ) | 450 | |||
| Explanatory Note: | ||||
| This data summarizes costs for all NSNs | ||||
| **Proprietary Information | ||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | ||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | ||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IS FOR EDUCATION ONLY&C
&R &CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A
NSN Summary ALT C
| *Company Name * | |||||||||||||||
| Request for Proposal SPMXXX-19-R-0000 | |||||||||||||||
| Schedule of Unit Cost and Total Cost by Cost Element | |||||||||||||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | |||||||||||||||
| Clin | NSN | Part Number | Material | Material Overhead | Subtotal | Labor | Labor Overhead | Subtotal | G&A | Total Cost | Profit | Total Price | ADQ | Summary Total | |
| Rate | 15.07% | 32.69% | 61% | 10% | |||||||||||
| 0001 | 1234-56-789-xxxx | XYZ-01 | $ 1,159.50 | $ 174.74 | $ 1,334.24 | $ 63.20 | $ 20.66 | $ 1,418.10 | $ 868.58 | $ 2,286.68 | $ 228.67 | $ 2,515.35 | 400 | $ 1,006,139.63 | |
| 0002 | 0000-56-789-xxxx | XYZ-02 | $ 343.00 | $ 51.69 | $ 394.69 | $ 104.00 | $ 34.00 | $ 532.69 | $ 326.27 | $ 858.96 | $ 85.90 | $ 944.85 | 450 | $ 425,184.66 | |
| Total | $ 1,431,324.29 | ||||||||||||||
| Explanatory Note: | |||||||||||||||
| This data summarizes costs for all NSNs | |||||||||||||||
| Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | |||||||||||||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | |||||||||||||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IS FOR EDUCATION ONLY&C
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A
Schedule A - Material ALT 1A
| Company Name * | |||||||||||||||
| Request for Proposal SPMXXX-19-R-0000 | |||||||||||||||
| Schedule of Unit Cost and Total Cost by Cost Element | |||||||||||||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | |||||||||||||||
| Schedule A - Bill of Material | |||||||||||||||
| CLIN 0001 NSN 1234-56-789-xxxx | |||||||||||||||
| Base Year - 2019 | Option Yr 1 | Option Yr 2 | Option Yr 3 | Option Yr 4 | Total | ||||||||||
| Quantity | Extended | ||||||||||||||
| Per Unit | Price / | Total | Total | Total | Total | Total | |||||||||
| Description | Units | Unit Price | (Note 5) | Unit Price | Material | Unit Price | Material | Unit Price | Material | Unit Price | Material | Unit Price | Material | Notes | |
| MMMMMMM | FT | $ 86.00 | 2 | $ 172.00 | $ 68,800.0 | $ 174.58 | $ 69,832.0 | $ 177.20 | $ 70,880.0 | $ 179.86 | $ 71,944.0 | $ 182.56 | $ 73,024.0 | $ 354,480.00 | 1 |
| MMMMMMM | FT | $ 1.00 | 50 | $ 50.00 | $ 20,000.0 | $ 50.75 | $ 20,300.0 | $ 51.51 | $ 20,604.0 | $ 52.28 | $ 20,912.0 | $ 53.06 | $ 21,224.0 | $ 103,040.00 | 1 |
| MMMMMMM | EA | $ 100.00 | 1 | $ 100.00 | $ 40,000.0 | $ 101.50 | $ 40,600.0 | $ 103.02 | $ 41,208.0 | $ 104.57 | $ 41,828.0 | $ 106.14 | $ 42,456.0 | $ 206,092.00 | 1 |
| MMMMMMM | EA | $ 17.50 | 17 | $ 297.50 | $ 119,000.0 | $ 301.96 | $ 120,784.0 | $ 306.49 | $ 122,596.0 | $ 311.09 | $ 124,436.0 | $ 315.76 | $ 126,304.0 | $ 613,120.00 | 1 |
| MMMMMMM | EA | $ 36.00 | 15 | $ 540.00 | $ 216,000.0 | $ 548.10 | $ 219,240.0 | $ 556.32 | $ 222,528.0 | $ 564.66 | $ 225,864.0 | $ 573.13 | $ 229,252.0 | $ 1,112,884.00 | 1 |
| Total Material | $ 1,159.50 | $ 463,800.0 | $ 1,176.89 | $ 470,756.00 | $ 1,194.54 | $ 477,816.0 | $ 1,212.46 | $ 484,984.0 | $ 1,230.65 | $ 492,260.0 | $ 2,389,616.00 | ||||
| Annual Demand Quantity | 400 | 400 | 400 | 400 | 400 | 2,000 | |||||||||
| Cost Escalation | 1.50% | 1.50% | 1.50% | 1.50% | 2 | ||||||||||
| Explanatory Notes: | |||||||||||||||
| 1. These prices are supported by multiple vendor quotes. | |||||||||||||||
| 2. The proposed escalation is based on Global Insight XXXXXX for military vehicles | |||||||||||||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | |||||||||||||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | |||||||||||||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IF FOR EDUCATION ONLY
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A
Schedule A - Material ALT 1B
| Company Name * | |||||||||||||||
| Request for Proposal SPMXXX-19-R-0000 | |||||||||||||||
| Schedule of Unit Cost and Total Cost by Cost Element | |||||||||||||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | |||||||||||||||
| Schedule A - Bill of Material | |||||||||||||||
| CLIN 0002 NSN 0000-56-789-xxxx | |||||||||||||||
| Base Year - 2019 | Option Yr 1 | Option Yr 2 | Option Yr 3 | Option Yr 4 | Total | ||||||||||
| Quantity | Extended | ||||||||||||||
| Per Unit | Price / | Total | Total | Total | Total | Total | |||||||||
| Description | Units | Unit Price | (Note 5) | Unit Price | Material | Unit Price | Material | Unit Price | Material | Unit Price | Material | Unit Price | Material | Notes | |
| MMMMMMM | FT | $ 100.00 | 2 | $ 200.00 | $ 90,000.00 | $ 203.00 | $ 91,350.00 | $ 206.05 | $ 92,722.50 | $ 209.14 | $ 94,113.00 | $ 212.28 | $ 95,526.00 | $ 463,711.50 | 1 |
| MMMMMMM | FT | $ 15.00 | 2 | $ 30.00 | $ 13,500.00 | $ 30.45 | $ 13,702.50 | $ 30.91 | $ 13,909.50 | $ 31.37 | $ 14,116.50 | $ 31.84 | $ 14,328.00 | $ 69,556.50 | 1 |
| MMMMMMM | EA | $ 27.00 | 1 | $ 27.00 | $ 12,150.00 | $ 27.41 | $ 12,334.50 | $ 27.82 | $ 12,519.00 | $ 28.24 | $ 12,708.00 | $ 28.66 | $ 12,897.00 | $ 62,608.50 | 1 |
| MMMMMMM | EA | $ 18.00 | 2 | $ 36.00 | $ 16,200.00 | $ 36.54 | $ 16,443.00 | $ 37.09 | $ 16,690.50 | $ 37.65 | $ 16,942.50 | $ 38.21 | $ 17,194.50 | $ 83,470.50 | 1 |
| MMMMMMM | EA | $ 50.00 | 1 | $ 50.00 | $ 22,500.00 | $ 50.75 | $ 22,837.50 | $ 51.51 | $ 23,179.50 | $ 52.28 | $ 23,526.00 | $ 53.06 | $ 23,877.00 | $ 115,920.00 | 1 |
| Total Material | $ 343.00 | $ 154,350.00 | $ 348.15 | $ 156,667.50 | $ 353.38 | $ 159,021.00 | $ 358.68 | $ 161,406.00 | $ 364.05 | $ 163,822.50 | $ 795,267.00 | ||||
| Annual Demand Quantity | 450 | 450 | 450 | 450 | 450 | 2,250 | |||||||||
| Cost Escalation | 1.50% | 1.50% | 1.50% | 1.50% | 2 | ||||||||||
| Explanatory Notes: | |||||||||||||||
| 1. These prices are supported by multiple vendor quotes. | |||||||||||||||
| 2. The proposed escalation is based on Global Insight XXXXX for military vehicles | |||||||||||||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | |||||||||||||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | |||||||||||||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IF FOR EDUCATION ONLY
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A
Schedule B - Material OH
| COMMENT - This schedule would be the same for all NSNs, therefore only need one | ||||||||
| Company Name * | ||||||||
| Request for Proposal SPMXXX-19-R-0000 | ||||||||
| Schedule of Unit Cost and Total Cost by Cost Element | ||||||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | ||||||||
| Schedule B - Material Overhead | ||||||||
| Budget | Projected | Projected | Projected | Projected | Actual Expenses | |||
| Material Overhead Expenses | 2019 | 2020 | 2021 | 2022 | 2023 | 2016 | 2017 | 2018 |
| Total Expense Pool | $500,000 | $575,000 | $661,250 | $760,438 | $874,503 | $400,000 | $436,000 | $450,000 |
| Less Unallowable Costs | 20,000 | 21,000 | 22,000 | 23,000 | 24,000 | 17,000 | 18,000 | 19,000 |
| Net Allowable Expenses | $480,000 | $554,000 | $639,250 | $737,438 | $850,503 | $383,000 | $418,000 | $431,000 |
| Allocation Base | ||||||||
| Total Materials | 3,184,883 | 3,662,615.45 | 4,212,007.77 | 4,843,808.93 | 5,570,380.27 | 2,500,000 | 2,750,000 | 3,000,000 |
| Materials Overhead Rate | 15.07% | 15.13% | 15.18% | 15.22% | 15.27% | 15.32% | 15.20% | 14.37% |
| Explanatory Notes | ||||||||
| 1. The budgeted Material Overhead expenses and allocation base dollars are based on the company's | ||||||||
| operating budget for 2018 and is available immediately upon request. | ||||||||
| 2. The actual expense shown for fiscal years 2016 through 2018. We anticipate minimal inflation and a stable | ||||||||
| business base. | ||||||||
| 3. Supporting details are available upon request. | ||||||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | ||||||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | ||||||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IS FOR EDUCATION ONLY
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restriction on the title page of the proposal
&A
Schedule C - Labor ALT 1A
| * Company Name * | |||||||||||||||||
| Request for Proposal SPMXXX-19-R-0000 | |||||||||||||||||
| Schedule of Labor Expenses | |||||||||||||||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | |||||||||||||||||
| Schedule C - Direct Labor | |||||||||||||||||
| CLIN 0001 NSN 1234-56-789-xxxx | |||||||||||||||||
| Unit | Base Year - 2019 | Option 1 | Option 2 | Option 3 | Option 4 | Total | |||||||||||
| Labor | Labor | Unit | Total | Labor | Unit | Total | Labor | Unit | Total | Labor | Unit | Total | Labor | Unit | Total | ||
| Labor Category or Mfg Process | Hours | Rate | Labor | Labor | Rate | Labor | Labor | Rate | Labor | Labor | Rate | Labor | Labor | Rate | Labor | Labor | |
| (Note 1) | (Note 2) | ||||||||||||||||
| Engineering | 1.2 | $ 48.00 | $ 57.60 | $ 23,040.00 | $ 48.96 | $ 58.75 | $ 23,500.00 | $ 49.94 | $ 59.93 | $ 23,972.00 | $ 50.94 | $ 61.13 | $ 24,452.00 | $ 51.96 | $ 62.35 | $ 24,940.00 | $ 4,796,160.00 |
| Assembly | 0.4 | $ 14.00 | $ 5.60 | $ 2,240.00 | $ 14.28 | $ 5.71 | $ 2,284.00 | $ 14.57 | $ 5.83 | $ 2,332.00 | $ 14.86 | $ 5.94 | $ 2,376.00 | $ 15.16 | $ 6.06 | $ 2,424.00 | $ 466,240.00 |
| Total | 1.6 | $ 63.20 | $ 25,280.00 | $ 64.46 | $ 25,784.00 | $ 65.76 | $ 26,304.00 | $ 67.07 | $ 26,828.00 | $ 68.41 | $ 27,364.00 | $ 5,262,400.00 | |||||
| Labor Rate Escalation (Note 3) | 2.0% | 2.0% | 2.0% | 2.0% | |||||||||||||
| ADQ | 400 | 400 | 400 | 400 | 400 | 2,000 | |||||||||||
| SURGE - DELETE THIS SECTION IF NOT NEEDED | |||||||||||||||||
| Unit | |||||||||||||||||
| Labor | Labor | Total | Base | ||||||||||||||
| Labor Category or Mfg Process | Hours | Rate | Labor | Year | Option 1 | Option 2 | Option 3 | Option 4 | Total | ||||||||
| Engineering | $ - 0 | $ - 0 | |||||||||||||||
| Assembly | $ - 0 | $ - 0 | |||||||||||||||
| Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| ADQ | 0 | ||||||||||||||||
| Explanatory Notes | |||||||||||||||||
| 1. All proposed Direct Labor Hours are based on 2018 production historical actuals OR All proposed Direct Labor Hours are based on engineering estimates of previous production runs | |||||||||||||||||
| 2. The Direct Labor Rates are based on payroll data for individuals OR Direct Labor Rates are actual average rates for labor categories | |||||||||||||||||
| 3. Labor rates are escalated xx% percent each year based on BLS Global Insight | |||||||||||||||||
| 4. The supporting details available upon request | |||||||||||||||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | |||||||||||||||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | |||||||||||||||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THIS INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IS FOR EDUCATION ONLY
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A&R
Schedule C - Labor ALT 1B
| * Company Name * | |||||||||||||||||
| Request for Proposal SPMXXX-19-R-0000 | |||||||||||||||||
| Schedule of Labor Expenses | |||||||||||||||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | |||||||||||||||||
| Schedule C - Direct Labor | |||||||||||||||||
| CLIN 0002 NSN 0000-56-789-xxxx | |||||||||||||||||
| Unit | Base Year - 2019 | Option 1 | Option 2 | Option 3 | Option 4 | Total | |||||||||||
| Labor | Labor | Unit | Total | Labor | Unit | Total | Labor | Unit | Total | Labor | Unit | Total | Labor | Unit | Total | ||
| Labor Category or Mfg Process | Hours | Rate | Labor | Labor | Rate | Labor | Labor | Rate | Labor | Labor | Rate | Labor | Labor | Rate | Labor | Labor | |
| (Note 1) | (Note 2) | ||||||||||||||||
| Engineering | 1 | $ 48.00 | $ 48.00 | $ 21,600.00 | $ 48.96 | $ 48.96 | $ 22,032.00 | $ 49.94 | $ 49.94 | $ 22,473.00 | $ 50.94 | $ 50.94 | $ 22,923.00 | $ 51.96 | $ 51.96 | $ 23,382.00 | $ 112,410.00 |
| Assembly | 4 | $ 14.00 | $ 56.00 | $ 25,200.00 | $ 14.28 | $ 57.12 | $ 25,704.00 | $ 14.57 | $ 58.28 | $ 26,226.00 | $ 14.86 | $ 59.44 | $ 26,748.00 | $ 15.16 | $ 60.64 | $ 27,288.00 | $ 131,166.00 |
| Total | 5 | $ 104.00 | $ 46,800.00 | $ 106.08 | $ 47,736.00 | $ 108.22 | $ 48,699.00 | $ 110.38 | $ 49,671.00 | $ 112.60 | $ 50,670.00 | $ 243,576.00 | |||||
| Labor Rate Escalation (Note 2) | 2.0% | 2.0% | 2.0% | 2.0% | |||||||||||||
| ADQ | 450 | 450 | 450 | 450 | 450 | 2,250 | |||||||||||
| SURGE - DELETE THIS SECTION IF NOT NEEDED | |||||||||||||||||
| Unit | |||||||||||||||||
| Labor | Labor | Total | Base | ||||||||||||||
| Labor Category or Mfg Process | Hours | Rate | Labor | Year | Option 1 | Option 2 | Option 3 | Option 4 | Total | ||||||||
| Engineering | $ - 0 | $ - 0 | |||||||||||||||
| Assembly | $ - 0 | $ - 0 | |||||||||||||||
| Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| ADQ | 0 | ||||||||||||||||
| Explanatory Notes | |||||||||||||||||
| 1. All proposed Direct Labor Hours are based on 2018 production historical actuals OR All proposed Direct Labor Hours are based on engineering estimates of previous production runs | |||||||||||||||||
| 2. The Direct Labor Rates are based on payroll data for individuals OR Direct Labor Rates are actual average rates for labor categories | |||||||||||||||||
| 3. Labor rates are escalated xx% percent each year based on BLS Global Insight | |||||||||||||||||
| 4. The supporting details available upon request | |||||||||||||||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | |||||||||||||||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | |||||||||||||||||
| THIS INFORMATION IS FOR EDUCATION PURPOSES ONLY |
&L&"Arial,Bold"THIS INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IS FOR EDUCATION ONLY
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A
Schedule D - Labor OH
| COMMENT - This schedule would be the same for all NSNs, therefore only need one | ||||||||
| * Company Name * | ||||||||
| Request for Proposal SPMXXX-19-R-0000 | ||||||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | ||||||||
| Schedule D - Labor Overhead or Manufacturing Overhead | ||||||||
| Budget | Projected | Projected | Projected | Projected | Actual Expenses | |||
| Manufacturing Overhead Expenses | 2019 | 2020 | 2021 | 2022 | 2023 | 2016 | 2017 | 2018 |
| Total Expense Pool | $2,000,000 | $2,040,000 | $2,080,800 | $2,122,416 | $2,164,864 | $1,600,000 | $1,700,000 | $1,800,000 |
| Less Unallowable Costs | 200,000 | 210,000 | 185,000 | 190,000 | 200,000 | $200,000 | $190,000 | $180,000 |
| Net Allowable Expenses | $1,800,000 | $1,830,000 | $1,895,800 | $1,932,416 | $1,964,864 | $1,800,000 | $1,890,000 | $1,980,000 |
| Allocation Base | ||||||||
| Total Labor Dollars | 5,505,976 | 5,616,095.52 | 5,728,417.43 | 5,842,985.78 | 5,959,845.49 | $10,000,000 | $10,000,000 | $10,000,000 |
| Manufacturing Overhead Rate | 32.69% | 32.58% | 33.09% | 33.07% | 32.97% | 18.00% | 18.90% | 19.80% |
| Explanatory Notes | ||||||||
| 1. The budgeted manufacturing overhead expenses and allocation base dollars are based on the company's | ||||||||
| operating budget for 2018 and is available upon request. | ||||||||
| 2. Projected expense pool costs and allocation base dollars for 2019 to 2023 are based on budget forecasts. | ||||||||
| 3. Supporting details are available upon request | ||||||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | ||||||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | ||||||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IS FOR EDUCATION ONLY
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A
Schedule E - G&A
| COMMENT - This schedule would be the same for all NSNs, therefore only need one | ||||||||
| * Company Name * | ||||||||
| Request for Proposal SPMXXX-19-R-0000 | ||||||||
| *HINT 1: This identifying information can be embeded within the spreadsheet or in the Header Section of the spreadsheet | ||||||||
| Schedule E - G&A Expenses | ||||||||
| G&A Expenses | Budget | Projected | Projected | Projected | Projected | Actual Expenses | ||
| 2019 | 2020 | 2021 | 2022 | 2023 | 2016 | 2017 | 2018 | |
| Total Expense Pool | $7,500,000 | $8,000,000 | $8,150,000 | $8,280,000 | $8,300,000 | $6,800,000.00 | $6,900,000.00 | $7,000,000.00 |
| Less Unallowable Costs | $ 150,000 | $ 150,000.00 | $ 175,000.00 | $ 125,000.00 | $ 130,000.00 | $125,000.00 | $120,000.00 | $115,000.00 |
| Net Allowable Expenses | $7,350,000 | $7,850,000 | $7,975,000 | $8,155,000 | $8,170,000 | $6,925,000.00 | $7,020,000.00 | $7,115,000.00 |
| Allocation Base | ||||||||
| Total Cost Input | $12,000,000 | $13,000,000 | $14,000,000 | $15,000,000 | $16,000,000 | 10,000,000 | $10,050,000 | $11,000,000 |
| G&A Rate | 61.25% | 60.38% | 56.96% | 54.37% | 51.06% | 69.25% | 69.85% | 64.68% |
| Explanatory Notes | ||||||||
| 1. The budgeted manufacturing overhead expenses and allocation base dollars are based on the company's | ||||||||
| operating budget for 2018 and is available immediately upon request. | ||||||||
| 2. Projected expense pool costs and allocation base dollars for 2019 to 2023 are based on budget forecasts. | ||||||||
| 3. Supporting documentation is available upon request. | ||||||||
| **Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal | ||||||||
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION | ||||||||
| THIS INFORMATION IS FOR EDUCATION ONLY |
&L&"Arial,Bold"THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION
THIS INFORMATION IS FOR EDUCATION ONLY
&CProprietary Information Use or disclosure of data contained in this workbook is subject to the restricitions on the title page of the proposal
&A
MBD014E4A5C.doc
PROPOSAL COVER SHEET
1.
Solicitation/Contract/Modification No.: SPMXXX-19-R-0000
Company Name
3990 East Highway
Columbus, OH 43213
3.
Point of Contact
Jane Doe
Program Manager
(614) 692-9999
4.
Contract Administration Office
Audit Office
DCMA Columbus
DCAA District Branch Office
200 North High St
200 North High St
Columbus, OH 43213-9999
Columbus, OH 43213-9999
5.
Type of Contract Action: New Contract – Firm Fixed Price IQC
6.
Proposed Cost + Profit or Fee = Total:
$6,939,749.68+ $693,974.97 = $7,633,724.65
7.
Government Property:
We will not require the use of any Government property in the performance of this work.
8.
Cost Accounting Standards (CAS) and Estimating & Accounting Compliance:
a. Our organization is NOT subject to the Cost Accounting Standards Board (CASB) Regulations (Public Law 91-379) as amended and FAR Part 30. We have a Small Business Exemption.
b. This contract action is NOT subject to CAS. We have a Small Business Exemption.
c. NO, we have not submitted a CASB Disclosure Statement (CASB DS-1 or 2).
d. We have NOT been notified that we are or may be in noncompliance with our Disclosure Statement or CAS.
e. NO aspect of this proposal is inconsistent with our disclosed practices or applicable CAS.
f. YES, this proposal is consistent with our established estimating and accounting practices and procedures and FAR Part 31, Cost Principles.
9.
This proposal reflects our estimates and/or actual costs as of this date and conforms with the instructions in FAR 15.403-5(b)(1) and FAR 15.408, Table 15-2. By submitting this proposal, we grant the Contracting Officer and authorized representative(s) the right to examine, at any time before award, those records, which include books, documents, accounting procedures and practices, and other data, regardless of type and form or whether such supporting information is specifically referenced or included in the proposal as the basis for pricing, that will permit an adequate evaluation of the proposed price.
10.
Date __________________________
11.
Signature of authorized representative ___________________________________
The information contained in this proposal is proprietary information and is for official use only.
File details come from the government source that posted it. Updated .