Amend 2_Attachment L-11 TEP Cost Workbook.xlsx
XLSX spreadsheet 263 KB Posted
- Attached to
- Instrumentation Range Support Program Federal contract opportunity
- Solicitation number
- FA2521-20-R-0006
About this file
This document package relates to a solicitation for Instrumentation Range Support Program (IRSP III) services. The solicitation seeks proposals to provide program management, inventory management, obsolescence management, range requirements, engineering support, equipment overhauls, system modifications, travel, and data deliverables. Specific services include routine and high-cost material acquisition, remanufacturing and fabrication, test and specialized equipment procurement, and stock replenishment. Proposals are due by November 15, 2019 with an anticipated award date of March 2020. The period of performance is a seven year base period from January 2021 through September 2027 with option periods to extend. Pricing shall be submitted using the attached cost workbook template with cost plus fixed fee, firm fixed price, and cost reimbursement line items. The incumbent contractor is encouraged to propose and small businesses are invited to compete under the terms set forth.
View the file
Other files for this federal contract opportunity
Show all 49
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 | The "Prime Contractor" is responsible for forwarding this Cost/Price Workbook to all Major Subcontractors so they can complete their section of the workbook. Most Subcontractors consider their indirect/fee information to be proprietary and will not want to submit their pricing information to a prime. The Prime will fill in the yellow highlighted “Total Subcontractor” section for the totals provided by each Subcontractor. |
| 4 | Light Yellow cells indicate Offeror Fill-In. |
| 5 | 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 |
| 6 | Green cells indicate cells containing or potentially containing formulas for auto calculation. |
| 7 | Orange cells are to be filled in by the Subcontractor |
| 8 | Red Cells contain Government provided Plug Numbers |
| 9 | 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% |
| 10 | This workbook contain various formulas in selected cells. These cells are not locked and it’s the offerors' responsibility to change the formulas and/or add formulas based on business practices. |
| 11 | Additional rows may be added to reflect additional labor categories, indirect rates and fees. |
| 12 | Enter all Indirect Rate Categories as they apply to corporate accounting practices and approved by DCMA while maintaining the integrity of the spreadsheet. |
| 13 | 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 | ||||||||||||||
| BASE ORDERING PERIOD | OPTION | |||||||||||||
| YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 6 | YEAR 7 | ||||||||
| CATEGORY | % | 0.0000 | % | 0.0000 | % | 0.0000 | % | 0.0000 | % | 0.0000 | % | 0.0000 | % | 0.0000 |
| FRINGE | 0.00% | 0.0000 | ||||||||||||
| OVERHEAD | 0.00% | 0.0000 | ||||||||||||
| G&A | 0.00% | 0.0000 | ||||||||||||
| MATERIAL HANDLING | 0.00% | 0.0000 | ||||||||||||
| SUBCONTRACTOR HANDING | 0.00% | 0.0000 | ||||||||||||
| ESCALATION |
| *PROPOSED FEES | ||||||||||||||
| BASE ORDERING PERIOD | OPTION | |||||||||||||
| YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 6 | YEAR 7 | ||||||||
| TYPE FEE | % | 0.0000 | % | 0.0000 | % | 0.0000 | % | 0.0000 | % | 0.0000 | % | 0.0000 | % | 0.0000 |
| PRIME FIXED FEE | 0.00% | 0.0000 | ||||||||||||
| PRIME FEE ON SUBCONTRACTOR | 0.00% | 0.0000 | ||||||||||||
| 0.0000 | ||||||||||||||
| 0.0000 | ||||||||||||||
| 0.0000 |
*SEE RFP Section L para. 2.4.1.1 and TABLE 2.4.1.b.
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 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 1,925,000.00 | |||
| X004 | FFP | *Transition In | |||||||||||
| Phase-Out | 3.4 | $ - 0 | $ - 0 | ||||||||||
| X005 | CPFF | Routine Range Requirements | 4.1 | $ - 0 | $ 2,000,000.00 | $ 2,000,000.00 | $ 2,000,000.00 | $ 2,000,000.00 | $ 2,000,000.00 | $ 2,000,000.00 | $ 2,000,000.00 | $ 14,000,000.00 | |
| X006 | CPFF | High Cost Range Requirements | 4.1 | $ - 0 | $ 30,000,000.00 | $ 30,000,000.00 | $ 30,000,000.00 | $ 30,000,000.00 | $ 30,000,000.00 | $ 30,000,000.00 | $ 30,000,000.00 | $ 210,000,000.00 | |
| X007 | CPFF | Engineering |
Field Support Technical Studies
| Investigations | 4.2 | $ - 0 | $ 4,560,000.00 | $ 4,560,000.00 | $ 4,560,000.00 | $ 4,560,000.00 | $ 4,560,000.00 | $ 4,560,000.00 | $ 4,560,000.00 | $ 31,920,000.00 | |||
| X008 | FFP | Pre-Overhaul and Overhauls | 4.3 | $ - 0 | $ 2,191,252.00 | $ 2,223,530.00 | $ 2,236,729.00 | $ 2,184,399.00 | $ 2,266,968.00 | $ 2,227,025.00 | $ 2,188,654.00 | $ 15,518,557.00 | |
| X009 | CPFF | System Modifications | 4.4 | $ - 0 | $ 12,000,000.00 | $ 12,000,000.00 | $ 12,000,000.00 | $ 12,000,000.00 | $ 12,000,000.00 | $ 12,000,000.00 | $ 12,000,000.00 | $ 84,000,000.00 | |
| X010 | CR | Travel and Transportation | 4.5 | $ - 0 | $ 609,980.00 | $ 609,980.00 | $ 609,980.00 | $ 609,980.00 | $ 609,980.00 | $ 609,980.00 | $ 609,980.00 | $ 4,269,860.00 | |
| X011 | NSP | Data/CDRLS | 5.0 | $ - 0 | $ - 0 |
| *TOTAL EVALUATED PRICE: | $ - 0 | $ 51,636,232.00 | $ 51,668,510.00 | $ 51,681,709.00 | $ 51,629,379.00 | $ 51,711,948.00 | $ 51,672,005.00 | $ 51,633,634.00 | $ 361,633,417.00 | |
| * | Total Evaluated Price does not include cost of Phase-In |
SCHEDULE B
ROLLUP
BY FISCAL YEAR
| 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 |
| COST | FEE | TOTAL | COST | FEE | TOTAL | COST | FEE | TOTAL | COST | FEE | TOTAL | COST | FEE | TOTAL | COST | FEE | TOTAL | COST | 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 PRICE: $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
SCHEDULE B
ROLLUP
BY BASE AND OPTION PERIOD
| CLIN | Type CLIN | DESCRIPTION | PWS Ref | BASE PERIOD | |||||||||
| 1 JAN 21 - 30 SEP 25 | OPTION PERIOD | ||||||||||||
| 1 OCT 25 - 30 SEP 27 | TOTAL | ||||||||||||
| COST | FEE | TOTAL | COST | FEE | TOTAL | 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 PRICE: $ - 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 (CPFF) CLIN | OFFEROR FILL-IN | ||
| 2 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | CELLS CONTAINING FORMULAS | ||
| 3 | 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" | SUBCONTRACOR FILL-IN | ||
| 4 | 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 | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | Price this section based on the totality of the requirement as stated in SOW paragraph 3.1, 3.1.1, 3.1.2, 3.1.3, 3.1.4, 6.0, and 7.0 for each fiscal year. | |||
| 6 | Prime Labor Cost Section: Enter the labor category, the corresponding Labor Rate and associated Labor Hours. The unburdened Labor Cost will automatically be calculated. | |||
| 7 | Escalate labor rates for all labor categories for each fiscal year or explain why no escalation is used in the Cost narrative. | |||
| 8 | Prime Miscellaneous Cost Section: Insert any miscellaneous direct cost associated with Program Management. | |||
| 9 | Prime Indirect Section: Link all Indirect Cost as entered in the Indirect TAB in this Workbook (as associated with Program Management) | |||
| 10 | Subcontractor Labor, Miscellaneous and Indirect Cost Sections: The prime contractor is responsible for providing this workbook to all major subcontractors. If the subcontractor chooses not to provide their detailed data to the prime, this section is to be filled out by the subcontractor and included as part of their proposal direct to the Contracting Officer or in a sealed envelop to the Prime. | |||
| 11 | Subcontractor Total Section: Filled out by the Prime Contractor based on information provided by the Subcontractor they are teaming with. List subcontractor's total, separately and complete prime burdens and fees. | |||
| 12 | Additional rows can be added or deleted based on the Offeror's needs. | |||
| 13 | There are no Government provided Plug Numbers for this CLIN section |
| 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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | |
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
PRIME FIXED FEE 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 0 0.0 $ - 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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | ||||||
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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 - NOT FEE) 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
FEE (SUB) 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.00 $ - 0 $ - 0
PRIMES FEE ON SUBS 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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: | |||||||||||||||||
| CLIN X001 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| * | Ensure that the TOTAL PRICE CLIN X001 cells are properly linked to the "TEP Rollup Tab" |
| FEE AND COST BREAKOUT | |||||||||||
| 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 PRIME FEE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| *** TOTAL COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| TOTAL PRICE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| ** | Enter the "Total Prime Fee" |
| *** | Enter the "Total Cost" |
| **** | Ensure that the TOTAL PRIME FEE cells are properly linked to the Schedule B sections of the "TEP Rollup Tab" |
CLIN X002
| CLIN X002 | ||||
| INSTRUCTIONS | LEGEND | |||
| 1 | This is a Firm Fixed Price (FFP) CLIN | CELLS WITH FORMULAS | ||
| 2 | Price this section based on the totality of the requirement as stated in SOW paragraph 3.2.1 for each fiscal year. | 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 COST | $ - 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 | ||
| * | NOTE: Ensure that the TOTAL PRICE cells are properly linked to the "TEP Rollup Tab" |
CLIN X003
CLIN X003
a. OBSOLESCENCE
b. REMANUFACTURING AND FABRICATION
c. TEST AND SPECIAL REQUIREMENTS
d. STOCK LEVEL REPLENISHMENT
CLIN X003a
INSTRUCTIONS FOR PRICING
| OBSOLESENCE | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee (CPFF) CLIN | OFFEROR FILL-IN | ||
| 2 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | CELLS CONTAINING FORMULAS | ||
| 3 | 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" | SUBCONTRACOR FILL-IN | ||
| 4 | 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 | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | Price this section based on the totality of the requirement as stated in SOW paragraph 3.3.1 for each fiscal year. | |||
| 6 | The estimated Work Load Indicator for Obsolescence Engineering is approximately 3,000 hours per fiscal year. | |||
| 7 | Prime Labor Cost Section: Enter the labor category, the corresponding Labor Rate and associated Labor Hours. The unburdened Labor Cost will automatically be calculated. | |||
| 8 | Escalate labor rates for all labor categories for each fiscal year or explain why no escalation is used in the Cost narrative. | |||
| 9 | Prime Miscellaneous Cost Section: Insert any miscellaneous cost associated with Obsolescence Engineering. | |||
| 10 | Prime Indirect Section: Link all Indirect Cost as entered in the Indirect TAB in this Workbook (as associated with Obsolescence Engineering) | |||
| 11 | Subcontractor Labor, Miscellaneous and Indirect Cost Sections: The prime contractor is responsible for providing this workbook to all major subcontractors. If the subcontractor chooses not to provide their detailed data to the prime, this section is to be filled out by the subcontractor and included as part of their proposal direct to the Contracting Officer or in a sealed envelop to the Prime. | |||
| 12 | Subcontractor Total Section: Filled out by the Prime Contractor based on information provided by the Subcontract they are teaming with. List each subcontractor totals, burdens and fees separately. | |||
| 13 | Additional rows can be added or deleted based on the Offeror's needs. | |||
| 14 | There are no Government provided Plug Numbers for this CLIN section |
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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | |
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
FIXED FEE (PRIME) 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | ||||||
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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 - NOT FEE) 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
FEE (SUB) 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
PRIMES FEE ON SUBS 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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
REMANUFACTURE AND FABRICATION (NON-RANGE SPECIFIC)
| CLIN X003b | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee CLIN | OFFEROR FILL-IN | ||
| 2 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | CELLS CONTAINING FORMULAS | ||
| 3 | Provide this workbook to any "Major Subcontractors" that the Prime plans to use. They are to fill out only the areas marked as "Subcontractor Fill-In" | SUBCONTRACOR FILL-IN | ||
| 4 | There are Government provided Plug Numbers for this CLIN section | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | 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 | PLUG NUMBER | ||
| 6 | Prime Coefficient Section: Apply Miscellaneous Costs, Indirects and fees associated with the non-range specific Remanufacturing and Fabrication requirement. | |||
| 7 | Ensure all Indirect Cost and Fees are Linked from the Indirect/Fee TAB in this Workbook. |
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: | $42,000.00 | $42,000.00 | $42,000.00 | $42,000.00 | $42,000.00 | $42,000.00 | $42,000.00 | $294,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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | |
| SUBTOTAL | ||||||||||||||||
| (BURDENED LABOR COST) | $ 42,000.00 | $ 42,000.00 | $ 42,000.00 | $ 42,000.00 | $ 42,000.00 | $ 42,000.00 | $ 42,000.00 | $ 294,000.00 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | ||||||||
| (INDIRECT COST) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | ||||||||
| (MISC+BURDENED LABOR+INDIRECT COST) | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 357,000.00 |
G&A 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL COSTS: | ||||||||
| (MISC+BURDENED LABOR+ INDIRECTS+G&A) | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 357,000.00 |
FIXED FEE (PRIME) 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
TOTAL PRICE: $ 51,000.00 $ 51,000.00 $ 51,000.00 $ 51,000.00 $ 51,000.00 $ 51,000.00 $ 51,000.00 $ 357,000.00
INSTRUCTIONS
TEST AND SPECIALIZED EQUIPMENT
| CLIN X003c | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee (CPFF) CLIN | OFFEROR FILL-IN | ||
| 2 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | CELLS CONTAINING FORMULAS | ||
| 3 | There are Government provided Plug Numbers for this CLIN section | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 4 | 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 | |||
| 6 | Price this section based on the totality of the requirement as stated in SOW paragraph 3.3.3 for each fiscal year. | |||
| 7 | Prime Labor Cost Section: Enter the labor category, the corresponding Labor Rate and associated Labor Hours. All labor associated with the procurement of test and specialized equipment should be captured under CLIN X001 | |||
| 8 | Escalate labor rates for all labor categories for each fiscal year (if any) | |||
| 9 | Prime Miscellaneous Cost Section: Insert any miscellaneous cost associated with Test and Specialized Equipment. | |||
| 10 | Prime Indirect Section: Link all Indirect Cost as entered in the Indirect TAB in this Workbook (as associated with Test and Specialized Equipment) | |||
| 11 | Additional rows can be added or deleted based on the Offeror's needs. |
CLIN X003c
TEST AND SPECIALIZED EQUIPMENT
| 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 | ||||||||||||
| 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 | |||||||||
| EQUIPMENT COST | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 700,000.00 | |||||||||||||||||
| EQUIPMENT HANDLING | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | ||||||||||
| SUBTOTAL MATERIAL COST: (MATERIALS+HANDLING) | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 700,000.00 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (MISC) | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 700,000.00 |
| 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.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | ||||||||
| SUBTOTAL | |||||||||||||||||||||||
| (BURDENED LABOR) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (INDIRECTS) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | |||||||||
| (BURDENED + MISC COST+INDIRECTS) | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 700,000.00 |
G&A (Applied to All Costs - NOT FEE) 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | |||||||||
| (WITH G&A) | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 700,000.00 |
FIXED FEE (PRIME) 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| TOTAL PRIME: | |||||||||
| (WITH FEE) | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 700,000.00 |
TOTAL PRICE: $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 700,000.00
INSTRUCTIONS
STOCK LEVEL REPLENISHMENT
| CLIN X003d | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee CLIN | OFFEROR FILL-IN | ||
| 2 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | CELLS CONTAINING FORMULAS | ||
| 4 | There are Government provided Plug Numbers for this CLIN section | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | 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 | PLUG NUMBER | ||
| 6 | Prime Coefficient Section: Apply Miscellaneous Costs, Indirect and fees associated with the Stock Level Replenishment requiring. | |||
| 7 | Ensure all Indirect Cost and Fees are Linked from the Indirect/Fee TAB in this Workbook. |
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: | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $12,000.00 | $84,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 | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 784,000.00 | ||||||||
| MATERIAL HANDLING | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | ||||||||
| (MISC) | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 112,000.00 | $ 784,000.00 |
| INDIRECT COSTS | RATE | COST | RATE | COST | RATE | COST | RATE | COST | RATE | COST | RATE | COST | RATE | COST | TOTAL INDIRECT COST | |
| FRINGE | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | 0.0000 | $ - 0 | $ - 0 | |
| SUBTOTAL | ||||||||||||||||
| (BURDENED LABOR COST) | $ 12,000.00 | $ 12,000.00 | $ 12,000.00 | $ 12,000.00 | $ 12,000.00 | $ 12,000.00 | $ 12,000.00 | $ 84,000.00 |
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL: | ||||||||
| (INDIRECT COST) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| SUBTOTAL: | ||||||||
| (MISC+BURDENED LABOR+INDIRECT COST) | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 868,000.00 |
G&A (Applied to All Costs - NOT FEE) 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 $ - 0
| SUBTOTAL COSTS: | ||||||||
| (MISC+BURDENED LABOR+ INDIRECTS+G&A) | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 868,000.00 |
FIXED FEE (PRIME) 0.0000 COST 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000 $ - 0 0.0000
TOTAL PRICE: $ 124,000.00 $124,000.00 $124,000.00 $124,000.00 $124,000.00 $124,000.00 $124,000.00 $ 868,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: | ||||||||||||||||
| OBSOLESCENCE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| TOTAL: | |||||||||||||||||
| REMANUFACTURE AND FABRICATION | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 51,000.00 | $ 357,000.00 | |||||||||
| TOTAL: | |||||||||||||||||
| TEST AND SPECIALIZED EQUIPMENT | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 700,000.00 | |||||||||
| TOTAL: | |||||||||||||||||
| STOCK LEVEL REPLENISHMENT | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 124,000.00 | $ 868,000.00 | |||||||||
| *TOTAL PRICE: | |||||||||||||||||
| CLIN X003 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 275,000.00 | $ 1,925,000.00 | |||||||||
| $275,000.00 | $275,000.00 | $275,000.00 | $275,000.00 | $275,000.00 | $275,000.00 | $275,000.00 | $1,925,000.00 |
* NOTE: Ensure that the TOTAL PRICE CLIN X003 cells are properly linked to the "TEP Rollup Tab"
| FEE AND COST BREAKOUT | |||||||||||
| 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 PRIME FEE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| *** TOTAL COST: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| TOTAL PRICE: | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| ** | Enter the "Total Prime Fee" |
| *** | Enter the "Total Cost" |
| **** | Ensure that the TOTAL PRIME FEE cells are properly linked to the Schedule B sections of the "TEP Rollup Tab" |
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 | Price this section based on the totality of the requirement as stated in SOW paragraph 3.4.1 for each fiscal year. | OFFEROR FILL-IN | ||
| 3 | Phase-In pricing will not be evaluated as part of the TEP but will be evaluated for reasonableness and affordability. | 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 PRICE: | $ - 0 | $ - 0 |
| INSTRUCTIONS | ||||
| CLIN 1004b | LEGEND | |||
| 1 | This is a Firm Fixed Price CLIN | CELLS WITH FORMULAS | ||
| 2 | No action required by Offeror. TBN = To Be Negotiated after contract award | 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 COST: | ERROR:#REF! | TBN | TBN | TBN |
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 |
* NOTE: Ensure that the TOTAL PRICE cells are properly linked to the "TEP Rollup Tab"
CLIN X005
CLIN X005
a. MATERIAL ACQUISITION (ROUTINE)
b. REMANUFACTURE AND FABRICATION (RANGE SPECIFIC)
INSTRUCTIONS
MATERIAL ACQUISITION (ROUTINE)
| CLIN X005a | LEGEND | |||
| 1 | This is a Cost Plus Fixed Fee CLIN | OFFEROR FILL-IN | ||
| 2 | Prime: Fill in yellow cells marked as "Offeror Fill-In" | CELLS CONTAINING FORMULAS | ||
| 4 | There are Government provided Plug Numbers for this CLIN section | AUTO-FILL FROM INDIRECT/FEE TAB | ||
| 5 | 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 | PLUG NUMBER | ||
| 6 | Price this section based on the totality of the requirement as stated in SOW paragraph 4.1.1, 4.1.1.1, 4.1.1.2 AND 4.1.1.3 for each fiscal year. | |||
| 7 | Workload Indicators: See Attachment L-01 | |||
| 8 | Prime Labor Cost Section: Enter the labor category, the corresponding Labor Rate and associated Labor Hours. The unburdened Labor Cost will automatically be calculated. | |||
| 9 | Escalate labor rates for all labor categories for each fiscal year or explain why no escalation is used in the Cost narrative. | |||
| 10 | Prime Miscellaneous Cost Section: A Plug Number for Material Cost is provided. Insert any other miscellaneous cost associated with routine material acquisition. | |||
| 11 | Prime Indirect Section: Link all Indirect Cost as entered in the Indirect TAB in this Workbook |
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 .