One NSN Annual Escalation_Proposal_Template 2022.xls
XLS spreadsheet 85 KB Posted
- Attached to
- CL22194001 ARM, CONTROL, VEHICULAR SUSPENSION
- Solicitation number
- CL2219401CONTROLARM
About this file
This market research document requests capability statements from potential suppliers for an automotive control arm to be used on military vehicles. The Defense Logistics Agency Land and Maritime is seeking information to determine if issuing a solicitation for an indefinite delivery, indefinite quantity contract with a potential length of one to five years would be feasible. Interested parties should submit capability statements including company and contact information, product details, and documentation proving items are commercial by July 15, 2022 to the specified acquisition specialist via email. The market research responses will be used to develop a solicitation that complies with domestic source restrictions and will be issued as either a commercial item or negotiated procurement.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Adequate Proposal Schematic--Generic Jan 2010.xls | XLS spreadsheet | |
| DCAA Model Generic Proposal.xls | XLS spreadsheet | |
| Proposal Adequacy Checklist 252.215-7009 Jan 2014.docx | DOCX document | |
| (CL22194001)MR LTC Question.docx | DOCX document | |
| NSN Data.xlsx | XLSX spreadsheet | |
| (CL22194001)MR LTC Spreadsheet NSN info.xlsx | XLSX spreadsheet | |
| One NSN Multi-Year_KT_Proposal_Template 2022.xls | XLS spreadsheet | |
| Table 15-2 Instructions for Submitting Cost Price Proposals (2022).docx | DOCX document |
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
Information
| For additional assistance, go to the DCAA website -https://WWW.DCAA.MIL |
| Select "Customers" tab |
| Select "Guidance" tab |
| Select "Audit Process Overview - Information for Contractors" to access the audit proccess overview page |
| Click the link "Information for Contractors" which gives a clear discussion of the requirements (Enclosure 3 Price Proposals) |
| THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS NOT OFFICIAL GOVERNMENT DOCUMENTATION |
| THIS INFORMATION IS FOR EDUCATION ONLY |
Summary
| Advanced Tank Technologies | |||||||||||||||||
| SPM4A6-08-R-XXXX | |||||||||||||||||
| Summary - Total Proposed Costs | |||||||||||||||||
| NSN | |||||||||||||||||
| 2022 | 2023 | 2024 | 2025 | 2026 | |||||||||||||
| Base Year | Contract Year 2 | Contract Year 3 | Contract Year 4 | Contract Year 5 | All Years | ||||||||||||
| Element of Cost | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Rate | Unit Price | Total Amount | Total | Reference |
| Material | $ 3,360.00 | $ 1,491,840.00 | $ 3,380.00 | $ 1,500,720.00 | $ 3,400.00 | $ 1,509,600.00 | $ 3,420.00 | $ 1,518,480.00 | $ 3,460.00 | $ 1,536,240.00 | $ 7,556,880.00 | Schedule A | |||||
| Material Overhead | 160.00% | 5,376.00 | $ 2,386,944.00 | 159.67% | 5,396.85 | $ 2,396,201.40 | 159.33% | 5,417.22 | $ 2,405,245.68 | 159.00% | 5,437.80 | $ 2,414,383.20 | 158.67% | 5,489.98 | $ 2,437,551.12 | $ 12,040,325.40 | Schedule B |
| Direct Labor | 63.20 | $ 28,060.80 | 65.10 | $ 28,904.40 | 67.04 | $ 29,765.76 | 69.06 | $ 30,662.64 | 71.12 | $ 31,577.28 | $ 148,970.88 | Schedule C | |||||
| Labor Overhead | 29.09% | 18.38 | $ 8,160.72 | 28.82% | 18.76 | $ 8,329.44 | 28.57% | 19.15 | $ 8,502.60 | 28.33% | 19.56 | $ 8,684.64 | 28.11% | 19.99 | $ 8,876.00 | $ 42,553.40 | Schedule D |
| Subtotal | 8,817.58 | $ 3,915,005.52 | 8,860.71 | $ 3,934,155.24 | 8,903.41 | $ 3,953,114.04 | 8,946.42 | $ 3,972,210.48 | 9,041.09 | $ 4,014,244.40 | $ 19,788,729.68 | ||||||
| G&A | 15.71% | 1,385.24 | $ 615,046.56 | 17.62% | 1,561.26 | $ 693,199.44 | 17.38% | 1,547.41 | $ 687,050.04 | 17.86% | 1,597.83 | $ 709,436.52 | 17.81% | 1,610.22 | $ 714,937.68 | $ 3,419,670.24 | Schedule E |
| Total Cost | 10,202.82 | $ 4,530,052.08 | 10,421.97 | $ 4,627,354.68 | 10,450.82 | $ 4,640,164.08 | 10,544.25 | $ 4,681,647.00 | 10,651.31 | $ 4,729,181.64 | $ 23,208,399.48 | ||||||
| Profit | 10.00% | 1,020.28 | $ 453,004.32 | 10.00% | 1,042.20 | $ 462,736.80 | 10.00% | 1,045.08 | $ 464,015.52 | 10.00% | 1,054.43 | $ 468,166.92 | 10.00% | 1,065.13 | $ 472,918.00 | $ 2,320,841.56 | |
| Total Price | $ 11,223.10 | $ 4,983,056.40 | $ 11,464.17 | $ 5,090,091.48 | $ 11,495.90 | $ 5,104,179.60 | $ 11,598.68 | $ 5,149,813.92 | $ 11,716.44 | $ 5,202,099.64 | $ 25,529,241.04 | ||||||
| Annual Demand Quantity | 444 | 444 | 444 | 444 | 444 | 2,220 | |||||||||||
| This data summarizes costs for five years - Please adjust for your company | |||||||||||||||||
| **HINT: Choose on of the following statements. This also can be embeded within 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 |
&R&12&F&A
Schedule A - Material
| Advanced Tank Technologies | |||||||||||||
| SPM4A6-08-R-XXXX | |||||||||||||
| NSN | |||||||||||||
| Schedule A - Bill of Material | |||||||||||||
| Quantity Range 1-18 | Quantity Range 19-24 | Quantity Range 55-91 | Quantity Range 92-218 | ||||||||||
| Total | |||||||||||||
| Extended | |||||||||||||
| Quantity | Price / | Total | Total | Total | Total | ||||||||
| Description | Units | Unit Price | Per Unit | Unit Price | Material | Unit Price | Material | Unit Price | Material | Unit Price | Material | Notes | |
| MMMMMMM | sq. yd. | $ 1,000.00 | 2 | $ 2,000.00 | $ 888,000.00 | $ 2,020.00 | $ 896,880.00 | $ 2,040.00 | $ 905,760.00 | $ 2,060.00 | $ 914,640.00 | $ 3,605,280.00 | 1 |
| MMMMMMM | pcs | $ 500.00 | 2 | $ 1,000.00 | $ 444,000.00 | $ 1,000.00 | $ 444,000.00 | $ 1,000.00 | $ 444,000.00 | $ 1,000.00 | $ 444,000.00 | $ 1,776,000.00 | 1 |
| MMMMMMM | pcs | $ 40.00 | 1 | $ 40.00 | $ 17,760.00 | $ 40.00 | $ 17,760.00 | $ 40.00 | $ 17,760.00 | $ 40.00 | $ 17,760.00 | $ 71,040.00 | 1 |
| MMMMMMM | pcs | $ 300.00 | 1 | $ 300.00 | $ 133,200.00 | $ 300.00 | $ 133,200.00 | $ 300.00 | $ 133,200.00 | $ 300.00 | $ 133,200.00 | $ 532,800.00 | 1 |
| MMMMMMM | pcs | $ 20.00 | 1 | $ 20.00 | $ 8,880.00 | $ 20.00 | $ 8,880.00 | $ 20.00 | $ 8,880.00 | $ 20.00 | $ 8,880.00 | $ 35,520.00 | 1 |
| Total Material | $ 3,360.00 | $ 1,491,840.00 | $ 3,380.00 | $ 1,500,720.00 | $ 3,400.00 | $ 1,509,600.00 | $ 3,420.00 | $ 1,518,480.00 | $ 6,020,640.00 | ||||
| Annual Demand Quantity | 444 | 444 | 444 | 444 | 1,776 | ||||||||
| Explanatory Notes - Please adjust for your company | |||||||||||||
| 1. Material prices are supported by multiple vendor quotes. Supporting documetation will be provided upon request . | |||||||||||||
| 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 |
&R&F&A
Schedule B - Material OH
| Advanced Tank Technologies | |||||||||
| SPM4A6-08-R-XXXX | |||||||||
| NSN | |||||||||
| Schedule B - Material Overhead | |||||||||
| 2022 | 2023 | 2024 | 2025 | 2026 | Actual Expenses | ||||
| Material Overhead Expenses | Base Year | Contract Year 2 | Contract Year 3 | Contract Year 4 | Contract Year 5 | 2019 | 2020 | 2021 | Notes |
| Total Expense Pool | $ 500,000.00 | $ 500,000.00 | $ 500,000.00 | $ 500,000.00 | $ 500,000.00 | $ 400,000.00 | $ 436,000.00 | $ 450,000.00 | 1 |
| Less Unallowable Costs | $ 20,000.00 | $ 21,000.00 | $ 22,000.00 | $ 23,000.00 | $ 24,000.00 | $ 17,000.00 | $ 18,000.00 | $ 19,000.00 | 1 |
| Net Allowable Expenses | $ 480,000.00 | $ 479,000.00 | $ 478,000.00 | $ 477,000.00 | $ 476,000.00 | $ 383,000.00 | $ 418,000.00 | $ 431,000.00 | |
| Allocation Base | |||||||||
| Total Materials | $ 300,000.00 | $ 300,000.00 | $ 300,000.00 | $ 300,000.00 | $ 300,000.00 | $ 270,000.00 | $ 275,000.00 | $ 280,000.00 | |
| Materials Overhead Rate | 160.00% | 159.67% | 159.33% | 159.00% | 158.67% | 141.85% | 152.00% | 153.93% | |
| Explanatory Notes - Please adjust for your company | |||||||||
| 1. The budgeted material overhead expenses and allocation base dollars are based on the company's | |||||||||
| operating budget for 20XX and is available immediately upon request. | |||||||||
| 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 |
&R&F&A
Schedule C - Labor
| Advanced Tank Technologies | ||||||||||||||||||
| SPM4A6-08-R-XXXX | ||||||||||||||||||
| NSN | ||||||||||||||||||
| Schedule C - Direct Labor | ||||||||||||||||||
| 2022 | 2023 | 2024 | 2025 | 2026 | ||||||||||||||
| Unit | Base Year | Contract Year 2 | Contract Year 3 | Contract Year 4 | Contract Year 5 | 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 | Notes | |
| Engineering | 1.2 | $ 48.00 | $ 57.60 | $ 25,574.40 | $ 49.44 | $ 59.33 | $ 26,342.52 | $ 50.92 | $ 61.10 | $ 27,128.40 | $ 52.45 | $ 62.94 | $ 27,945.36 | $ 54.02 | $ 64.82 | $ 28,780.08 | $ 135,770.76 | 1,2 |
| Assembly | 0.4 | $ 14.00 | $ 5.60 | $ 2,486.40 | $ 14.42 | $ 5.77 | $ 2,561.88 | $ 14.85 | $ 5.94 | $ 2,637.36 | $ 15.30 | $ 6.12 | $ 2,717.28 | $ 15.76 | $ 6.30 | $ 2,797.20 | $ 13,200.12 | 1,2 |
| Total | 1.6 | $ 63.20 | $ 28,060.80 | $ 65.10 | $ 28,904.40 | $ 67.04 | $ 29,765.76 | $ 69.06 | $ 30,662.64 | $ 71.12 | $ 31,577.28 | $ 148,970.88 | ||||||
| Annual Demand Quantity | 444 | 444 | 444 | 444 | 444 | 2,220 | ||||||||||||
| Explanatory Notes - Please adjust for your company | ||||||||||||||||||
| 1. All labor hours proposed are based on ________ (Please fil in the blank with the basis of the labor hours) | ||||||||||||||||||
| 2. The direct labor rates are based on _______ (Please fill in the blank with the basis of the labor rates) | ||||||||||||||||||
| Supporting data can be provided upon request. | ||||||||||||||||||
| 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 |
&R&F&A
Schedule D - Labor OH
| Advanced Tank Technologies | |||||||||
| SPM4A6-08-R-XXXX | |||||||||
| NSN | |||||||||
| Schedule D - Labor Overhead or Manufacturing Overhead | |||||||||
| Labor Overhead | |||||||||
| 2022 | 2023 | 2024 | 2025 | 2026 | Actual Expenses | ||||
| Labor Overhead Expenses | Base Year | Contract Year 2 | Contract Year 3 | Contract Year 4 | Contract Year 5 | 2019 | 2020 | 2021 | Notes |
| Total Expense Pool | $ 50,000.00 | $ 51,000.00 | $ 52,000.00 | $ 53,000.00 | $ 54,000.00 | $ 47,000.00 | $ 48,000.00 | $ 49,000.00 | 1 |
| Less Unallowable Costs | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | 1 |
| Net Allowable Expenses | $ 48,000.00 | $ 49,000.00 | $ 50,000.00 | $ 51,000.00 | $ 52,000.00 | $ 45,000.00 | $ 46,000.00 | $ 47,000.00 | |
| Allocation Base | |||||||||
| Total Labor Dollars | $ 165,000.00 | $ 170,000.00 | $ 175,000.00 | $ 180,000.00 | $ 185,000.00 | $ 150,000.00 | $ 155,000.00 | $ 160,000.00 | |
| Labor Overhead Rate | 29.09% | 28.82% | 28.57% | 28.33% | 28.11% | 30.00% | 29.68% | 29.38% | |
| Explanatory Notes - Please adjust for your company | |||||||||
| 1. The budgeted labor overhead expenses and allocation base dollars are based on the company's | |||||||||
| operating budget for 20XX and is available immediately upon request. | |||||||||
| 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 |
&R&F&A
Schedule E - G&A
| Advanced Tank Technologies | |||||||||
| SPM4A6-08-R-XXXX | |||||||||
| NSN | |||||||||
| Schedule E - G&A Expenses | |||||||||
| 2022 | 2023 | 2024 | 2025 | 2026 | Actual Expenses | ||||
| G&A Expenses | Base Year | Contract Year 2 | Contract Year 3 | Contract Year 4 | Contract Year 5 | 2019 | 2020 | 2021 | |
| Notes | |||||||||
| Total Expense Pool | $ 1,800,000.00 | $ 2,000,000.00 | $ 2,000,000.00 | $ 2,000,000.00 | $ 2,000,000.00 | $ 1,600,000.00 | $ 1,700,000.00 | $ 1,800,000.00 | |
| Less Unallowable Costs | $ 150,000.00 | $ 150,000.00 | $ 175,000.00 | $ 125,000.00 | $ 130,000.00 | $ 200,000.00 | $ 190,000.00 | $ 180,000.00 | 1 |
| Net Allowable Expenses | $ 1,650,000.00 | $ 1,850,000.00 | $ 1,825,000.00 | $ 1,875,000.00 | $ 1,870,000.00 | $ 1,400,000.00 | $ 1,510,000.00 | $ 1,620,000.00 | 1 |
| Allocation Base | |||||||||
| Total Cost Input | $ 10,500,000.00 | $ 10,500,000.00 | $ 10,500,000.00 | $ 10,500,000.00 | $ 10,500,000.00 | $ 10,000,000.00 | $ 10,000,000.00 | $ 10,000,000.00 | 2 |
| G&A Rate | 15.71% | 17.62% | 17.38% | 17.86% | 17.81% | 14.00% | 15.10% | 16.20% | |
| Explanatory Notes - Please adjust for your company | |||||||||
| 1. The budgeted overhead expenses and allocation base dollars are based on the company's | |||||||||
| operating budget for 20xx and is available immediately upon request. | |||||||||
| 2. Projected expense pool costs and allocation base dollars for 20xx to 20xx are based on budget forecasts and | |||||||||
| expected future business volume. Supporting details are available upon request | |||||||||
| 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 |
&R&F&A
File details come from the government source that posted it. Updated .