One NSN Annual Escalation_Proposal_Template 2022.xls
XLS spreadsheet 85 KB Posted
- Attached to
- CL22186007 Armor Transparent Vehicular Window
- Solicitation number
- CL22186007TransparentArmor
View the file
Other files
| File | Type | Posted |
|---|---|---|
| DCAA Model Generic Proposal.xls | XLS spreadsheet | |
| Proposal Adequacy Checklist 252.215-7009 Jan 2014.docx | DOCX document | |
| One NSN Multi-Year_KT_Proposal_Template 2022.xls | XLS spreadsheet | |
| Adequate Proposal Schematic--Generic Jan 2010.xls | XLS spreadsheet | |
| CL22186007 Market Research LTC Questionnaire.docx | DOCX document | |
| CL22186007 Market Research LTC Spreadsheet NSN info.xlsx | XLSX spreadsheet |
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 .