DRAFT_Cost-Price_Workbook.xlsx
XLSX spreadsheet 244 KB Posted
- Attached to
- Instrumentation Range Support Program Federal contract opportunity
- Solicitation number
- FA2521-18-R-0024
About this file
This document is a request for information for logistics sustainment support services for instrumentation tracking systems. Key details include that the proposed contract would re-compete the Instrumentation Radar Support Program currently supporting 26 agencies across DoD, DoE, NASA and six foreign governments. Services required are management of government-owned stock, stock acquisition, responding to requisitions, component repair, fabrication, on-site overhauls, engineering field support, engineering investigations, system modifications, relocations, subsystem upgrades, and design/manufacture/installation/testing. The applicable NAICS code is 334511 with a size standard of 1250 employees. Responses are due by June 29, 2018 and shall identify business size and type. The document provides contact information for questions.
Draft Cost/Price Workbook
View the file
Other files for this federal contract opportunity
Show all 50
Instrumentation Range Support Program has more files on GovTribe.
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
INSTRUCTIONS
WORKBOOK
*GENERAL INSTRUCTIONS
| The use of this Workbook is required and must be complete. Supporting documentation is highly recommended but not in lieu of required worksheet data. | |
| 1 | Insert the firm's name on the Header Tab of each worksheet. |
| 2 | Begin by entering the Rates and Fees in the"Indirects and Fee" Tab of this Workbook. |
| 3 | Light Yellow cells indicate Offeror Fill-In. |
| 4 | Blue cells will auto populate based on information provided by Offeror as provided and linked from the INDIRECTS AND FEE Tab . The Offeror is required to link the rates provided in the Indirects and Fee Tab |
| 5 | Green cells indicate cells containing or potentially containing formulas for auto calculation. |
| 6 | Orange cells are to be filled in by the Subcontractor |
| 7 | Red Cells contain Government provided Plug Numbers |
| 8 | The worksheets of the workbook should all be formatted for printing on 11 x 17 paper, without requiring "adjustments." i.e scaling less than 100% If adjustments are required, spreadsheet may not be evaluated. |
| 9 | Please note if more subcontractors are needed, the prime may add additional rows to accommodate them, but ensure integrity of formulas. |
| 10 | Enter all Indirect Rate Categories as they apply to corporate accounting practices and approved by DCMA while maintaining the integrity of the spreadsheet. |
| 11 | All percentages should be formatted to two decimal places (ex. 17.25%) and used for reference only. When used to calculate, 17.25% will be entered as .1725 in the cell. |
| 12 | Composite rates (when used) will include an detailed explanation of what makes up that rate. |
| 13 | If there is not going to be any data entry in a row or group of rows, please just hide the rows. Do not delete. For example, if the prime is only utilizing one subcontractor, then the rows concerning subs 2 would be hidden. |
* More detailed instruction can be found on each CLIN TAB
&"-,Bold"&14[Company Name] [Version]
INDIRECTS AND FEE
PROPOSED INDIRECT RATES AND FEES
| PROPOSED INDIRECT RATES | ||||||||||||||
| YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 6 | YEAR 7 | ||||||||
| CATEGORY | % | 0.00 | % | 0.00 | % | 0.00 | % | 0.00 | % | 0.00 | % | 0.00 | % | 0.00 |
| FRINGE | 0.50 | |||||||||||||
| OVERHEAD | 0.15 | |||||||||||||
| G&A | 0.10 | |||||||||||||
| MATERIAL HANDLING | 0.02 | |||||||||||||
| SUBCONTRACTOR HANDING | 0.00 |
| PROPOSED FEES | ||||||||||||||
| YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 6 | YEAR 7 | ||||||||
| TYPE FEE | % | 0.00 | % | 0.00 | % | 0.00 | % | 0.00 | % | 0.00 | % | 0.00 | % | 0.00 |
| PRIME FIXED FEE | 0.00 | |||||||||||||
| PRIME FEE ON SUBCONTRACTOR | 0.00 |
TEP ROLL-UP
| TOTAL EVALUATED PRICE | |||||
| CLIN | Type CLIN | DESCRIPTION | PWS Ref | PHASE-IN | |
| 1JUL 20 - 31 DEC 20 | YEAR 1 | ||||
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | ||||
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | ||||
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | ||||
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | ||||
| 1 OCT 24 - 30 SEP 25 | YEAR 6 (OPTION) | ||||
| 1 OCT 25 - 30 SEP 26 | YEAR 7 (OPTION) | ||||
| 1 OCT 26 - 30 SEP 27 | TOTAL |
| X001 | CPFF | Program Management | 3.1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X002 | FFP | Inventory Management | 3.2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X003 | CPFF | Obsolescence |
Remanufacture & Fabrication Test/Specialized Equip
| Stock Replenishment | 3.3 | $ - 0 | $ 240,000.00 | $ 240,000.00 | $ 240,000.00 | $ 240,000.00 | $ 240,000.00 | $ 240,000.00 | $ 240,000.00 | $ 1,680,000.00 | |||
| X004 | FFP | Transition In | |||||||||||
| Phase-Out | 3.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| X005 | CPFF | Routine Range Requirements | 4.1 | $ - 0 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 31,500,000.00 | |
| X006 | CPFF | High Cost Range Requirements | 4.1 | $ - 0 | $ 54,600,000.00 | $ 54,600,000.00 | $ 54,600,000.00 | $ 54,600,000.00 | $ 54,600,000.00 | $ 54,600,000.00 | $ 54,600,000.00 | $ 382,200,000.00 | |
| X007 | CPFF | Engineering |
Field Support Technical Studies
| Investigations | 4.2 | $ - 0 | $ 6,424,440.00 | $ 6,424,440.00 | $ 6,424,440.00 | $ 6,424,440.00 | $ 6,424,440.00 | $ 6,424,440.00 | $ 6,424,440.00 | $ 44,971,080.00 | 0 | ||
| X008 | FFP | Pre-Overhaul and Overhauls | 4.3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X009 | CPFF | System Modifications | 4.4 | $ - 0 | $ 52,300,000.00 | $ 52,300,000.00 | $ 52,300,000.00 | $ 52,300,000.00 | $ 52,300,000.00 | $ 52,300,000.00 | $ 52,300,000.00 | $ 366,100,000.00 | |
| X010 | CR | Travel and Transportation | 4.5 | $ - 0 | $ 663,800.00 | $ 663,800.00 | $ 663,800.00 | $ 663,800.00 | $ 663,800.00 | $ 663,800.00 | $ 663,800.00 | $ 4,646,600.00 | |
| X011 | NSP | Data/CDRLS | 5.0 | $ - 0 | $ - 0 |
| TOTAL EVALUATED PRICE: | $ - 0 | $ 118,728,240.00 | $ 118,728,240.00 | $ 118,728,240.00 | $ 118,728,240.00 | $ 118,728,240.00 | $ 118,728,240.00 | $ 118,728,240.00 | $ 831,097,680.00 |
| Total Evaluated Price does not include cost of Phase-In |
| SCHEDULE B | ||||
| CLIN | Type CLIN | DESCRIPTION | YEAR 1 | |
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | |||
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | |||
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | |||
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | |||
| 1 OCT 24 - 30 SEP 25 | YEAR 6 (OPTION) | |||
| 1 OCT 25 - 30 SEP 26 | YEAR 7 (OPTION) | |||
| 1 OCT 26 - 30 SEP 27 | TOTAL |
| PRICE | FEE | TOTAL | PRICE | FEE | TOTAL | PRICE | FEE | TOTAL | PRICE | FEE | TOTAL | PRICE | FEE | TOTAL | PRICE | FEE | TOTAL | PRICE | FEE | TOTAL | ||||
| X001 | CPFF | Program Management | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X002 | FFP | Inventory Management | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | |
| X003 | CPFF | Obsolescence |
Remanufacture & Fabrication Test/Specialized Equip
| Stock Replenishment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| X004 | FFP | Transition In/Out | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | ||
| X005 | CPFF | Routine Range Requirements | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X006 | CPFF | High Cost Range Requirements | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| X007 | CPFF | Engineering |
Field Support Technical Studies
| Investigations | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| X008 | FFP | Pre-Overhaul and Overhauls | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | |||
| X009 | CPFF | System Modifications | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| X010 | CR | Travel and Transportation | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||
| X011 | NSP | Data/CDRLS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTAL: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
SCHEDULE B
ROLL-UP
| CLIN | Type CLIN | DESCRIPTION | PWS Ref | BASE PERIOD | |||||||||
| 1 JAN 21 - 30 SEP 25 | OPTION PERIOD | ||||||||||||
| 1 OCT 25 - 30 SEP 27 | TOTAL | ||||||||||||
| PRICE/COST | FEE | TOTAL | PRICE/COST | FEE | TOTAL | PRICE/COST | FEE | TOTAL |
| X001 | CPFF | Program Management | 3.1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| X002 | FFP | Inventory Management | 3.2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | ||
| X003 | CPFF | Obsolescence |
Remanufacture & Fabrication Test/Specialized Equip
| Stock Replenishment | 3.3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| X004 | FFP | Transition In/Out | 3.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||
| X005 | CPFF | Routine Range Requirements | 4.1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X006 | CPFF | High Cost Range Requirements | 4.1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X007 | CPFF | Engineering |
Field Support Technical Studies
| Investigations | 4.2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| X008 | FFP | Pre-Overhaul and Overhauls | 4.3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | |||
| X009 | CPFF | System Modifications | 4.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| X010 | CR | Travel and Transportation | 4.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0 | $ - 0 | |||
| X011 | NSP | Data/CDRLS | 5.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTAL: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
CLIN X001
CLIN X001
PROGRAM MANAGEMENT
WORKBOOK
| INSTRUCTIONS | ||||
| CLIN X001 | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee CLIN | OFFEROR FILL-IN | ||
| 2 | Use the Historical Info Sample L-01 and the SOW to assist in completing this Workbook page | CELLS CONTAINING FORMULAS | ||
| 3 | Prime Indirect Rates and Fees should reflect the data provided by the Offeror on the Indirects and Fee Tab of the Workbook | SUBCONTRACOR FILL-IN | ||
| 4 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | Provide this workbook to any "Major Subcontractors" that the Prime plan to use. They are to fill out only the areas marked as "Subcontractor Fill-In" | |||
| 6 | There are no Government provided Plug Numbers for this CLIN | |||
| 7 | The TOTAL PRICE Tabs are to be properly linked to the TEP Roll-up Tab | |||
| 8 | Formulas in the GREEN cells are provided for info only. The Offeror is responsible to ensure that ALL formulas represent costs and pricing submitted on this proposal |
| YEAR 1 | ||||||||||||||||||||
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | |||||||||||||||||||
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | |||||||||||||||||||
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | |||||||||||||||||||
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | |||||||||||||||||||
| 1 OCT 24 - 30 SEP 25 | YEAR 6 (OPTION) | |||||||||||||||||||
| 1 OCT 25 - 30 SEP 26 | Year 7 (OPTION) 1 OCT 26 - 30 SEP 27 | TOTAL | ||||||||||||||||||
| LABOR CATEGORY | ||||||||||||||||||||
| (PRIME) | LABOR | |||||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR HOURS | LABOR COST (UNBURDENED) | ||||||||||||||||
| PRIME (LABOR COST) | $ - 0 | 0.0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| SUBTOTAL: | ||||||||||||||||||||
| LABOR COST (UNBURDENED) | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 |
| PRIME (MISC) | MISCELLANIOUS COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | TOTAL MISC COST |
| MATERIAL/ODC COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| MATERIAL HANDLING | 0.02 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | |
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0
| 0.00 | $ - 0 | 0.00 | $ - 0 |
| $ - 0 | |||
| 0.00 | $ - 0 | 0.00 | $ - 0 |
| SUBTOTAL: | ||||||||
| (MISC) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| PRIME | ||||
| (INDIRECTS) | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | TOTAL |
INDIRECT/FEE
| FRINGE | 0.50 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
OVERHEAD 0.15 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.02 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | |||||||||
| (BURDENED + MISC COST+INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
MATERIAL HANDLING 0.10 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
PRIME FIXED FEE 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| TOTAL PRIME: | |||||||||
| (WITH FEE) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBCONTRACTOR 1 (LABOR) | LABOR | ||||||||||
| MAJOR SUBCONTRACTOR 1 | LABOR | ||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR HOURS | LABOR COST (UNBURDENED) | |||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | ||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | ||||||||||
| SUBTOTAL SUB 1: |
(LABOR HRS + LABOR COSTS)
DOTY, KRISTIN GS-12 USAF AFSPC 45 CONS/PKD: DOTY, KRISTIN GS-12 USAF AFSPC 45 CONS/PKD:
INCLUDED IN Primes proposal
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0
| SUBCONTRACTOR 1 | |||||||||||||||||||||
| (MISC) | MISCELLANIOUS COST | RATE | MISC COST | RATE | MISC/IND COST | RATE | MISC/IND | ||||||||||||||
| COST | RATE | MISC/IND COST | RATE | MISC/IND COST | RATE | MISC/IND COST | RATE | MISC/IND COST | TOTAL MISC/IND COST | ||||||||||||
| MATERIAL/ODC COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| MATERIAL HANDLING | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | 0 | $ - 0 | ||||||
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (MISC) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBCONTRACTOR 1 | ||||
| (INDIRECTS) | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | RATE | INDIRECT/FEE | ||
| COST | TOTAL |
INDIRECT/FEE
| FRINGE | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL | |||||||||
| (INDIRECTS): | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | |||||||||
| (BURDENED + MISC COST+INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
G&A 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
FEE (SUB) 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| TOTAL SUBCONTRACTOR: | |||||||||
| (WITH FEE) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SUBCONTRACTOR | TOTAL SUBCONTRACTOR 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SUBCONTRACTOR 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| SUBTOTAL SUBCONTRACTOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
PRIME INDIRECT (BURDENS) 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
PRIMES FEE ON SUBS 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
TOTAL SUBCONTRACTORS PRICE: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| TOTAL PRICE | TOTAL SUBCONTRACTOR PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PRIME COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
CLIN X002
| CLIN X002 | ||||
| INSTRUCTIONS | LEGEND | |||
| 1 | This is a Firm Fixed Price (FFP) CLIN | CELLS WITH FORMULAS | ||
| 2 | Use L-01, L-04 and the SOW to assist in completing this section of the Workbook | OFFEROR FILL-IN |
CLIN X002
INVENTORY MANAGEMENT
WORKBOOK
| YEAR 1 | ||
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | |
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | |
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | |
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | |
| 1 OCT 24 - 30 SEP 25 | YEAR 6 |
(OPTION)
1 OCT 25 - 30 SEP 26 Year 7
(OPTION)
| 1 OCT 26 - 30 SEP 27 | TOTAL | |||||||||
| TOTAL: | ||||||||||
| SUBCONTRACTOR PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL: | ||||||||||
| PRIME PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL PRICE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
CLIN X003
CLIN X003
a. OBSOLESCENCE
b. REMANUFACTURING AND FABRICATION
c. TEST AND SPECIAL REQUIREMENTS
d. STOCK LEVEL REPLENISHMENT
| CLIN X003a | ||||
| INSTRUCTIONS | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee (CPFF) CLIN | OFFEROR FILL-IN | ||
| 2 | Use the Historical Info Sample L-01, Engineering and Obsolescence Sample L-06 and the SOW to assist in completing this Workbook section | CELLS CONTAINING FORMULAS | ||
| 3 | Prime Indirect Rates and Fees should reflect the data provided by the Offeror on the Indirects and Fee Tab of the Workbook | SUBCONTRACOR FILL-IN | ||
| 4 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | Provide this workbook to any "Major Subcontractors" that the Prime plan to use. They are to fill out only the areas marked as "Subcontractor Fill-In" | |||
| 6 | There are no Government provided Plug Numbers for this CLIN section | |||
| 7 | The TOTAL PRICE Tabs are to be properly linked to the TEP Roll-up Tab | |||
| 8 | Formulas in the GREEN cells are provided for info only. The Offeror is responsible to ensure that ALL formulas represent costs and pricing submitted on this proposal |
CLIN X003a
OBSOLESCENCE
| YEAR 1 | |||||||||||||||||||||
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | ||||||||||||||||||||
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | ||||||||||||||||||||
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | ||||||||||||||||||||
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | ||||||||||||||||||||
| 1 OCT 24 - 30 SEP 25 | YEAR 6 (OPTION) | ||||||||||||||||||||
| 1 OCT 25 - 30 SEP 26 | Year 7 (OPTION) 1 OCT 26 - 30 SEP 27 | TOTAL | |||||||||||||||||||
| LABOR CATEGORY | |||||||||||||||||||||
| (PRIME) | LABOR | ||||||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR HOURS | LABOR COST (UNBURDENED) | |||||||||||||||||
| PRIME (LABOR COST) | $ - 0 | 0.0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| SUBTOTAL: | |||||||||||||||||||||
| LABOR COST (UNBURDENED) | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 |
| PRIME (MISC) | MISCELLANIOUS COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | TOTAL MISC COST |
| MATERIAL/ODC COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| MATERIAL HANDLING | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | $ - 0 | |
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 0.0 0.0 0.0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 0.0 0.0 0.0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 0.0 0.0 0.0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 0.0 0.0 0.0 $ - 0
| SUBTOTAL: | |||||||||||
| (MISC) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| PRIME | |||||||||||
| (INDIRECTS) | INDIRECT COSTS and FEE | RATE | INDIRECT/FEE | ||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | TOTAL |
INDIRECT/FEE
| FRINGE | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
OVERHEAD 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | |||||||||
| (BURDENED + MISC COST+INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
G&A (Applied to All Costs) 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
FIXED FEE (PRIME) 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| TOTAL PRIME: | |||||||||
| (WITH FEE) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBCONTRACTOR 1 (LABOR) | LABOR | |||||||||||||||
| MAJOR SUBCONTRACTOR 1 | LABOR | |||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR HOURS | LABOR COST (UNBURDENED) | ||||||||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| SUBTOTAL SUB 1: |
(LABOR HRS + LABOR COSTS)
DOTY, KRISTIN GS-12 USAF AFSPC 45 CONS/PKD: DOTY, KRISTIN GS-12 USAF AFSPC 45 CONS/PKD:
INCLUDED IN Primes proposal
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0
| SUBCONTRACTOR 1 | |||||||||||||||||||||
| (MISC) | SUBCONTRACTOR | ||||||||||||||||||||
| MISCELLANIOUS COST | RATE | MISC COST | RATE | MISC/IND COST | RATE | MISC/IND | |||||||||||||||
| COST | RATE | MISC/IND COST | RATE | MISC/IND COST | RATE | MISC/IND COST | RATE | MISC/IND COST | TOTAL MISC/IND COST | ||||||||||||
| MATERIAL/ODC COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| MATERIAL HANDLING | 0.02 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | ||||||
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (MISC) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBCONTRACTOR 1 | |||
| (INDIRECTS) | SUIBCONTRACTOR | ||
| INDIRECT COSTS and FEE | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | TOTAL |
INDIRECT/FEE
| FRINGE | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
| SUBTOTAL | |||||||||
| (INDIRECTS): | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | |||||||||
| (BURDENED + MISC COST+INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
G&A 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
FEE (SUB) 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
| TOTAL SUBCONTRACTOR: | |||||||||
| (WITH FEE) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SUBCONTRACTOR | TOTAL SUBCONTRACTOR 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SUBCONTRACTOR 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| SUBTOTAL SUBCONTRACTOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
PRIME INDIRECT (BURDENS) 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
PRIMES FEE ON SUBS 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
TOTAL SUBCONTRACTORS PRICE: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| TOTAL | ||||||||||||||||||
| PRICE | TOTAL SUBCONTRACTOR PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| TOTAL PRIME COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTAL PRICE: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| INSTRUCTIONS | ||||
| CLIN X003b | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee CLIN | OFFEROR FILL-IN | ||
| 2 | Use the SOW to assist in completing this Workbook section | CELLS CONTAINING FORMULAS | ||
| 3 | Prime Indirect Rates and Fees should reflect the data provided by the Offeror on the Indirects and Fee Tab of the Workbook | SUBCONTRACOR FILL-IN | ||
| 4 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | Provide this workbook to any "Major Subcontractors" that the Prime plan to use. They are to fill out only the areas marked as "Subcontractor Fill-In" | PLUG NUMBER | ||
| 6 | There are Government provided Plug Numbers for this CLIN section | |||
| 7 | The TOTAL PRICE Tabs are to be properly linked to the TEP Roll-up Tab | |||
| 8 | Formulas in the GREEN cells are provided for info only. The Offeror is responsible to ensure that ALL formulas represent costs and pricing submitted on this proposal |
CLIN X003b
REMANUFACTURE AND FABRICATION (NON-RANGE SPECIFIC)
| YEAR 1 | ||||||||||
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | |||||||||
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | |||||||||
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | |||||||||
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | |||||||||
| 1 OCT 24 - 30 SEP 25 | YEAR 6 (OPTION) | |||||||||
| 1 OCT 25 - 30 SEP 26 | Year 7 (OPTION) 1 OCT 26 - 30 SEP 27 | TOTAL | ||||||||
| TOTAL UNBURDENED LABOR: | $81,000.00 | $81,000.00 | $81,000.00 | $81,000.00 | $81,000.00 | $81,000.00 | $81,000.00 | $567,000.00 |
| PRIME COEFFICIENT | MISCELLANIOUS COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | TOTAL MISC COST |
| MATERIAL COST | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 63,000.00 | ||||||||
| MATERIAL HANDLING | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 |
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| SUBTOTAL: | ||||||||
| (MISC) | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 9,000.00 | $ 63,000.00 |
INDIRECT COSTS RATE COST RATE COST RATE COST RATE COST RATE COST RATE COST RATE COST TOTAL INDIRECT COST
| FRINGE | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | |
| SUBTOTAL | ||||||||||||||||
| (BURDENED LABOR COST) | $ 81,000.00 | $ 81,000.00 | $ 81,000.00 | $ 81,000.00 | $ 81,000.00 | $ 81,000.00 | $ 81,000.00 | $ 567,000.00 |
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL: | ||||||||
| (INDIRECT COST) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | ||||||||
| (MISC+BURDENED LABOR+INDIRECT COST) | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 630,000.00 |
G&A 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL COSTS: | ||||||||
| (MISC+BURDENED LABOR+ INDIRECTS+G&A) | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 90,000.00 | $ 630,000.00 |
FIXED FEE (PRIME) 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
TOTAL PRICE $ 90,000.00 $ 90,000.00 $ 90,000.00 $ 90,000.00 $ 90,000.00 $ 90,000.00 $ 90,000.00 $ 630,000.00
| INSTRUCTIONS | ||||
| CLIN X003c | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee CLIN | OFFEROR FILL-IN | ||
| 2 | Use the Logistics Sample L-07 and the SOW to assist in completing this Workbook section | CELLS CONTAINING FORMULAS | ||
| 3 | Prime Indirect Rates and Fees should reflect the data provided by the Offeror on the Indirects and Fee Tab of the Workbook | SUBCONTRACOR FILL-IN | ||
| 4 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | Provide this workbook to any "Major Subcontractors" that the Prime plan to use. They are to fill out only the areas marked as "Subcontractor Fill-In" | |||
| 6 | There are no Government provided Plug Numbers for this CLIN section | |||
| 7 | The TOTAL PRICE Tabs are to be properly linked to the TEP Roll-up Tab | |||
| 8 | Formulas in the GREEN cells are provided for info only. The Offeror is responsible to ensure that ALL formulas represent costs and pricing submitted on this proposal |
CLIN 3c
TEST AND SPECIAL REQUIREMENTS
| YEAR 1 | |||||||||||||||||||||
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | ||||||||||||||||||||
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | ||||||||||||||||||||
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | ||||||||||||||||||||
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | ||||||||||||||||||||
| 1 OCT 24 - 30 SEP 25 | YEAR 6 (OPTION) | ||||||||||||||||||||
| 1 OCT 25 - 30 SEP 26 | Year 7 (OPTION) 1 OCT 26 - 30 SEP 27 | TOTAL | |||||||||||||||||||
| LABOR CATEGORY | |||||||||||||||||||||
| (PRIME) | LABOR | ||||||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | ||||||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR HOURS | LABOR COST (UNBURDENED) | |||||||||||||||||
| PRIME (LABOR COST) | $ - 0 | 0.0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||||||||
| SUBTOTAL: | |||||||||||||||||||||
| LABOR COST (UNBURDENED) | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 |
| PRIME (MISC) | MISCELLANIOUS COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | TOTAL MISC COST |
| MATERIAL/ODC COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||
| MATERIAL HANDLING | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | $ - 0 | |
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
| SUBTOTAL: | |||||||||||
| (MISC) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| PRIME | |||||||||||
| (INDIRECTS) | INDIRECT COSTS and FEE | RATE | INDIRECT/FEE | ||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | RATE | INDIRECT/FEE | |||||||||
| COST | TOTAL |
INDIRECT/FEE
| FRINGE | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
OVERHEAD 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | |||||||||
| (BURDENED + MISC COST+INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
G&A 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
FIXED FEE (PRIME) 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| TOTAL PRIME: | |||||||||
| (WITH FEE) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBCONTRACTOR 1 (LABOR) | LABOR | |||||||||||||||
| MAJOR SUBCONTRACTOR 1 | LABOR | |||||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR | |||||||||||||
| RATE | LABOR HOURS | LABOR COST (UNBURDENED) | LABOR HOURS | LABOR COST (UNBURDENED) | ||||||||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| $ - 0 | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 0.0 | $ - 0 | ||||||
| SUBTOTAL SUB 1: |
(LABOR HRS + LABOR COSTS)
DOTY, KRISTIN GS-12 USAF AFSPC 45 CONS/PKD: DOTY, KRISTIN GS-12 USAF AFSPC 45 CONS/PKD:
INCLUDED IN Primes proposal
DOTY, KRISTIN GS-12 USAF AFSPC 45 CONS/PKD: DOTY, KRISTIN GS-12 USAF AFSPC 45 CONS/PKD:
INCLUDED IN Primes proposal
0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0
| SUBCONTRACTOR 1 | |||||||||||||||||||||
| (MISC) | SUBCONTRACTOR | ||||||||||||||||||||
| MISCELLANIOUS COST | RATE | MISC COST | RATE | MISC/IND COST | RATE | MISC/IND | |||||||||||||||
| COST | RATE | MISC/IND COST | RATE | MISC/IND COST | RATE | MISC/IND COST | RATE | MISC/IND COST | TOTAL MISC/IND COST | ||||||||||||
| MATERIAL/ODC COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||
| MATERIAL HANDLING | 0.02 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | ||||||
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.00 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (MISC) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBCONTRACTOR 1 | |||
| (INDIRECTS) | SUIBCONTRACTOR | ||
| INDIRECT COSTS and FEE | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | RATE | INDIRECT/FEE | |
| COST | TOTAL |
INDIRECT/FEE
| FRINGE | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | 0.0 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 0.0 $ - 0 0.0 $ - 0 $ - 0
0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
| SUBTOTAL | |||||||||
| (INDIRECTS): | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | |||||||||
| (BURDENED + MISC COST+INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
G&A 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
FEE (SUB) 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
| TOTAL SUBCONTRACTOR: | |||||||||
| (WITH FEE) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SUBCONTRACTOR | TOTAL SUBCONTRACTOR 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL SUBCONTRACTOR 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| SUBTOTAL SUBCONTRACTOR: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
PRIME INDIRECT (BURDENS) 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
PRIMES FEE ON SUBS 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 $ - 0
TOTAL SUBCONTRACTORS PRICE: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| TOTAL | ||||||||||||||||||
| PRICE | TOTAL SUBCONTRACTOR PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| TOTAL PRIME COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTAL PRICE: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| INSTRUCTIONS | ||||
| CLIN X003d | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee (CPFF) CLIN | OFFEROR FILL-IN | ||
| 2 | Use the CONOPS document, stock level snapshop and the SOW to assist in completing this Workbook section | CELLS CONTAINING FORMULAS | ||
| 3 | Prime Indirect Rates and Fees should reflect the data provided by the Offeror on the Indirects and Fee Tab of the Workbook | SUBCONTRACOR FILL-IN | ||
| 4 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | Provide this workbook to any "Major Subcontractors" that the Prime plan to use. They are to fill out only the areas marked as "Subcontractor Fill-In" | PLUG NUMBER | ||
| 6 | There are Government provided Plug Numbers for this CLIN section | |||
| 7 | The TOTAL PRICE Tabs are to be properly linked to the TEP Roll-up Tab | |||
| 8 | Formulas in the GREEN cells are provided for info only. The Offeror is responsible to ensure that ALL formulas represent costs and pricing submitted on this proposal |
CLIN X003d
STOCK LEVEL REPLENISHMENT
| YEAR 1 | ||||||||||
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | |||||||||
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | |||||||||
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | |||||||||
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | |||||||||
| 1 OCT 24 - 30 SEP 25 | YEAR 6 (OPTION) | |||||||||
| 1 OCT 25 - 30 SEP 26 | Year 7 (OPTION) 1 OCT 26 - 30 SEP 27 | TOTAL | ||||||||
| TOTAL | ||||||||||
| UNBURDENED LABOR: | $15,000.00 | $15,000.00 | $15,000.00 | $15,000.00 | $15,000.00 | $15,000.00 | $15,000.00 | $105,000.00 |
| PRIME COEFFICIENT | MISCELLANIOUS COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | TOTAL MISC COST |
| MATERIAL COST | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 945,000.00 | ||||||||
| MATERIAL HANDLING | 0.00 | $0.00 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 |
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| SUBTOTAL: | ||||||||
| (MISC) | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 135,000.00 | $ 945,000.00 |
INDIRECT COSTS RATE COST RATE COST RATE COST RATE COST RATE COST RATE COST RATE COST TOTAL INDIRECT COST
| FRINGE | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | |
| SUBTOTAL | ||||||||||||||||
| (BURDENED LABOR COST) | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 15,000.00 | $ 105,000.00 |
Material Fee 0.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
0.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
0.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| SUBTOTAL: | ||||||||
| (INDIRECT COST) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | ||||||||
| (MISC+BURDENED LABOR+INDIRECT COST) | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 1,050,000.00 |
G&A 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL COSTS: | ||||||||
| (MISC+BURDENED LABOR+ INDIRECTS+G&A) | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 150,000.00 | $ 1,050,000.00 |
FIXED FEE (PRIME) 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
TOTAL PRICE $ 150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $150,000.00 $ 1,050,000.00
CLIN X003
ROLL-UP
| YEAR 1 | |||||||||||||||||
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | ||||||||||||||||
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | ||||||||||||||||
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | ||||||||||||||||
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | ||||||||||||||||
| 1 OCT 24 - 30 SEP 25 | YEAR 6 (OPTION) | ||||||||||||||||
| 1 OCT 25 - 30 SEP 26 | Year 7 (OPTION) 1 OCT 26 - 30 SEP 27 | TOTAL | |||||||||||||||
| CLIN TOTAL | TOTAL: | ||||||||||||||||
| OBSOLESENCE | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| TOTAL: | |||||||||||||||||
| REMANUFACTURE AND FABRICATION | $90,000.00 | $90,000.00 | $90,000.00 | $90,000.00 | $90,000.00 | $90,000.00 | $90,000.00 | $630,000.00 | |||||||||
| TOTAL: | |||||||||||||||||
| TEST AND SPECIALIZED EQUIPMENT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| TOTAL: | |||||||||||||||||
| STOCK LEVEL REPLENISHMENT | $150,000.00 | $150,000.00 | $150,000.00 | $150,000.00 | $150,000.00 | $150,000.00 | $150,000.00 | $1,050,000.00 | |||||||||
| TOTAL:CLIN X003 | $240,000.00 | $240,000.00 | $240,000.00 | $240,000.00 | $240,000.00 | $240,000.00 | $240,000.00 | $1,680,000.00 | |||||||||
| $240,000.00 | $240,000.00 | $240,000.00 | $240,000.00 | $240,000.00 | $240,000.00 | $240,000.00 | $1,680,000.00 |
CLIN X004
CLIN X004
a. PHASE-IN
b. PHASE-OUT
| INSTRUCTIONS | ||||
| CLIN 0004a | LEGEND | |||
| 1 | This is a Firm Fixed Price CLIN | CELLS WITH FORMULAS | ||
| 2 | TBN = To Be Negociated | OFFEROR FILL-IN | ||
| 3 | Note "Affordability" in Section M, para 2.4.1.2 | DO NOT PRICE |
CLIN 0004a
PHASE-IN
| PHASE-IN | ||
| 1 Jul 20 - 31 Dec 20 | YEAR 1 | |
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | |
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | |
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | |
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | |
| 1 OCT 24 - 30 SEP 25 | YEAR 6 |
(OPTION)
1 OCT 25 - 30 SEP 26 Year 7
(OPTION)
| 1 OCT 26 - 30 SEP 27 | TOTAL | ||||||||||
| TOTAL: | |||||||||||
| SUBCONTRACTOR PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL: | |||||||||||
| PRIME PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL PRICE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| INSTRUCTIONS | ||||
| CLIN 1004b | LEGEND | |||
| 1 | This is a Firm Fixed Price CLIN | CELLS WITH FORMULAS | ||
| 2 | TBN = To Be Negotiated | OFFEROR FILL-IN | ||
| DO NOT PRICE |
CLIN 1004b
PHASE-OUT
| PHASE-IN | ||
| 1 Jul 20 - 31 Dec 20 | YEAR 1 | |
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | |
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | |
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | |
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | |
| 1 OCT 24 - 30 SEP 25 | YEAR 6 |
(OPTION)
1 OCT 25 - 30 SEP 26 Year 7
(OPTION)
| 1 OCT 26 - 30 SEP 27 | TOTAL | ||||||||||
| TOTAL: | |||||||||||
| SUBCONTRACTOR PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | TBN | TBN | $ - 0 | ||
| TOTAL: | |||||||||||
| PRIME PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | TBN | TBN | $ - 0 | |||
| TOTAL PRICE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
CLIN X004
| PHASE-IN | ||
| 1 Jul 20 - 31 Dec 20 | YEAR 1 | |
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | |
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | |
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | |
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | |
| 1 OCT 24 - 30 SEP 25 | YEAR 6 |
(OPTION)
1 OCT 25 - 30 SEP 26 Year 7
(OPTION)
| 1 OCT 26 - 30 SEP 27 | TOTAL | ||||||||||
| TOTAL: | |||||||||||
| PHASE-IN | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| TOTAL: | |||||||||||
| PHASE-OUT | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | TBN | TBN | $ - 0 | $ - 0 | ||
| TOTAL PRICE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
CLIN X005
CLIN X005
a. MATERIAL ACQUISITION (ROUTINE)
b. REMANUFACTURE AND FABRICATION (RANGE SPECIFIC)
| INSTRUCTIONS | ||||
| CLIN X005a | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee CLIN | OFFEROR FILL-IN | ||
| 2 | Use the SOW to assist in completing this Workbook section | CELLS CONTAINING FORMULAS | ||
| 3 | Prime Indirect Rates and Fees should reflect the data provided by the Offeror on the Indirects and Fee Tab of the Workbook | SUBCONTRACOR FILL-IN | ||
| 4 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | Provide this workbook to any "Major Subcontractors" that the Prime plan to use. They are to fill out only the areas marked as "Subcontractor Fill-In" | PLUG NUMBER | ||
| 6 | There are Government provided Plug Numbers for this CLIN section | |||
| 7 | The TOTAL PRICE Tabs are to be properly linked to the TEP Roll-up Tab | |||
| 8 | Formulas in the GREEN cells are provided for info only. The Offeror is responsible to ensure that ALL formulas represent costs and pricing submitted on this proposal |
CLIN X005a
MATERIAL ACQUISITION (ROUTINE)
| YEAR 1 | ||||||||||
| 1 JAN 21 - 30 SEP 21 | YEAR 2 | |||||||||
| 1 OCT 21 - 30 SEP 22 | YEAR 3 | |||||||||
| 1 OCT 22 - 30 SEP 23 | YEAR 4 | |||||||||
| 1 OCT 23 - 30 SEP 24 | YEAR 5 | |||||||||
| 1 OCT 24 - 30 SEP 25 | YEAR 6 (OPTION) | |||||||||
| 1 OCT 25 - 30 SEP 26 | Year 7 (OPTION) 1 OCT 26 - 30 SEP 27 | TOTAL | ||||||||
| TOTAL | ||||||||||
| UNBURDENED LABOR: | $675,000.00 | $675,000.00 | $675,000.00 | $675,000.00 | $675,000.00 | $675,000.00 | $675,000.00 | $4,725,000.00 |
| PRIME COEFFICIENT | MISCELLANIOUS COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | RATE | MISC COST | TOTAL MISC COST |
| MATERIAL COST | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 26,775,000.00 | ||||||||
| MATERIAL HANDLING | 0.00 | $0.00 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 |
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| SUBTOTAL: | ||||||||
| (MISC) | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 3,825,000.00 | $ 26,775,000.00 |
INDIRECT COSTS RATE COST RATE COST RATE COST RATE COST RATE COST RATE COST RATE COST TOTAL INDIRECT COST
| FRINGE | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | 0.00 | $ - 0 | $ - 0 | |
| SUBTOTAL | ||||||||||||||||
| (BURDENED LABOR COST) | $ 675,000.00 | $ 675,000.00 | $ 675,000.00 | $ 675,000.00 | $ 675,000.00 | $ 675,000.00 | $ 675,000.00 | $ 4,725,000.00 |
Material Fee 0.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
0.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
0.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| SUBTOTAL: | ||||||||
| (INDIRECT COST) | $ - 0 | $ - 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $ - 0 |
| SUBTOTAL: | ||||||||
| (MISC+BURDENED LABOR+INDIRECT COST) | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 31,500,000.00 |
G&A 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
| SUBTOTAL COSTS: | ||||||||
| (MISC+BURDENED LABOR+ INDIRECTS+G&A) | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 4,500,000.00 | $ 31,500,000.00 |
FIXED FEE (PRIME) 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 0.00 $ - 0 $ - 0
TOTAL PRICE $ 4,500,000.00 $4,500,000.00 $4,500,000.00 $4,500,000.00 $4,500,000.00 $4,500,000.00 $4,500,000.00 $ 31,500,000.00
| INSTRUCTIONS | ||||
| CLIN X005b | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee (CPFF) CLIN | OFFEROR FILL-IN | ||
| 2 | Use the Historical Info Sample L-01, Logistics Sample L-07 (TAB #, R-F) and the SOW to assist in completing this Workbook section | CELLS CONTAINING FORMULAS | ||
| 3 | Prime Indirect Rates and Fees should reflect the data provided by the Offeror on the Indirects and Fee Tab of the Workbook | SUBCONTRACOR FILL-IN |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .