Atch_3-ITW_AA_Pricing_Model.xlsx
XLSX spreadsheet 105 KB Posted
- Attached to
- Integrated Tactical Warning/Attack Assessment (ITW/AA) Simulation Support Federal contract opportunity
- Solicitation number
- FA4600-15-R-0035
About this file
Attachment 3- ITW/AA Pricing Model
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| FA4600-15-R-0035-A001.pdf | ||
| ITW_AA_Pricing_Model-Amend_1.xlsx | XLSX spreadsheet | |
| RFP-FA4600-15-R-0035_ITW_AA.pdf | ||
| Atch_6-_Special_Offutt_Provisions.docx | DOCX document | |
| Exhibit_B-_CDRLs.pdf | ||
| Atch_7_-_Past_Performance_Information_Sheet.docx | DOCX document | |
| Atch_10_-_Subktr-_Team_Consent_Ltr.docx | DOCX document | |
| ITW_AA_QASP.docx | DOCX document | |
| Atch_2 _NCIC_Screening.pdf | ||
| Atch_11_-_Client_Authorization_Ltr.docx | DOCX document | |
| Atch_9-_Questionnaire_Cover_Letter.docx | DOCX document | |
| Exhibit_A-_CDRL_List.docx | DOCX document | |
| Atch_4-DD_254-ITW_AA.pdf | ||
| Atch_1_Insurance_Requirements_Certif.pdf | ||
| RFP-FA4600-15-R-0035_ITW_AA.pdf | ||
| Atch_8-_Past_Performance_Questionnaire.docx | DOCX document |
Show all 16
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
Directions
| COST/PRICE MODEL DIRECTIONS FOR | |||
| RFP FA4600-15-R-0035 | |||
| ITW/AA Pricing Model | |||
| (ONLY FILL IN AREAS HIGHLIGHTED IN YELLOW) | |||
| Directions: | |||
| 1 | Fill in only the cells that are highlighted in yellow, beginning with the company name at the top of the "Loading Factors" TAB. | ||
| If changes to locked cells are required, please submit to the government in the form of a question. | |||
| 2 | Based on historical data, the government has populated the FTE hours as 1920. | ||
| 3 | Complete Tabs for each CLIN X001/X003/X006. Input Labor Categories, rates, and hours for the base period, and then hours only for remaining periods. | ||
| Use only the Labor Categories from the "Labor Cat Descriptions" Tab located in this Pricing Model. Rates for option periods will automatically populated based on the | |||
| escalation rate specified in the "Loading Factors" TAB. Please note: Labor Categories need to be typed in again for each Option Period 4 due to page layout. | |||
| Please add rows as needed for additonal labor categories in a given CLIN. | |||
| 4 | CLINs X0002/X0004/X0005/X0007 are government populated | ||
| 5 | Complete Tab for CLIN 0008 Transition, which covers all costs for the transition period. | ||
| 6 | CLIN X0009 is government populated | ||
| 7 | If applicable, provide proprietary statement in the footer of each TAB. |
| Assumptions | |
| 1. | All rates provided shall be fully burdened rates (fully burdened rates shall include all direct costs, indirect costs and profit) |
| 2. | Client site refers to work done at Government locations. |
| 3. | Grand totals are reflected in whole dollars. |
| 4. | Price the rates for a period of performance start date of 13 June 2016 |
| 5. | Labor category descriptions are in the TAB called "Labor Cat Description". |
| Directions for PRIME | |
| 1. | If the assumptions are valid, fill in only the cells that are highlighted in yellow, beginning with the prime name at the top of Tab "Loading Factors" |
| 2. | If the assumptions are not valid, modify appropriate loaded rates in the "Loading Factors" Tab, and if needed throughout the Tabs. Identify changes by highlighting (shading) the cells with changed formulas in Green and describe the changes as well as the reasons for those changes in the space provided at the bottom of the "Loading Factors" Tab. |
| 3. | Complete cells in the Tabs highlighted in yellow |
| 4. | For Periods beyond the base year, the fully burdened labor rates will automatically be escalated based on inputs in the Tab "Loading Factors". |
| 5. | If applicable provide your proprietary statement in the footer of each Tab. |
| Helpful Hints and Reminders: | |
| 1. | Use the checklist provided below to ensure your proposal is complete. |
| Price Model Checklist | |
| Have the following been completed? | |
| Prime company name is entered on the "Loading Factors" Tab. (Company name automatically populates to the rest of the Tabs) | |
| Input your annual escalation rates into the "Loading Factors" Tab. | |
| If rates/categories differ from the model, the differences are explained at the bottom of the "Loading Factors" Tab. | |
| Fully burdened rates are entered in the "Client (Gov't) Site" and "Contractor Site" | |
| Completed the "Benefit Summary" tab. | |
| Supporting information for calculating your escalation rates is loaded into the "Esc Rate caculation" Tab. | |
| Supporting information for labor rates is provided if required. |
FA4600-15-R-0035,ITW/AA Recompete Attachment 4
Loading Factors
| LOADING FACTORS ITW/AA | ||||||
| Prime Name: | ||||||
| Subcontractor Name: | ||||||
| Base Year | Option 1 | Option 2 | Option 3 | Option 4 | Option 5-6 Mo Ext | |
| LOADING FACTORS: | 13 June 2016 - 12 June 2017 | 13 June 2017 - 2 June 2018 | 13 June 2018 - 12 June 2019 | 13 June 2019 - 12 June 2020 | 13 June 2020 - 12 June 2021 | 13 June 2021- 12 December 2021 |
| Labor Escalation | 0.00% |
| Identify your company's Full Time Equivalent (FTE) hours. | |
| Subcontractor identify the type of contract you have with the Prime? | Drop Down Menu |
&12FA4600-15-R-0035, ITW/AA Recompete Attachment 4
CLIN X001 Labor ITW_AA
| Prime Name: | 0 |
| Sub Name: | 0 |
| CLIN X001 LABOR HOUR & PRICE BREAKDOWN |
| CLIN X001 (FFP) | CLIN 0001 - Base Period | CLIN 1001-Option 1 | CLIN 2001-Option 2 | CLIN 3001-Option 3 | ||||||||
| Labor Integerated Tactical Warning/Attack Assessment Simulation Media (ITW/AA) | 13 Jun 16 - 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | ||||||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| Subtotal with FTE CLIN X001 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 |
| CLIN X001 (FFP) (Years Con't) | CLIN 4001-Option 4 | CLIN 5001-6 Month Ext | ||||
| Labor Integerated Tactical Warning/Attack Assessment Simulation Media (ITW/AA) | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 - 12 Dec 21 | ||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| Subtotal with FTE CLIN X001 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 |
&12FA4600-15-R-0035,ITW/AA Recompete Attachment 4
&"Times New Roman,Regular"&P / &N
CLIN X002 Travel ITW_AA
| Prime Name: | 0 |
| Sub Name: | 0 |
| CLIN X002 Travel ITW/AA |
| CLIN X002 (Cost Reimbursement) | CLIN 0002 - Base Period | CLIN 1002-Option 1 | CLIN 2002-Option 2 | CLIN 3002-Option 3 | ||||||||
| Travel ITW/AA | 13 Jun 16- 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | ||||||||
| Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | |
| Automatic Government Population | 0 | 0.00 | 30,000.00 | 0 | 0.00 | 30,000.00 | 0 | 0.00 | 30,000.00 | 0 | 0.00 | 30,000.00 |
| Subtotal CLIN X002 | 0 | 0.00 | $ 30,000 | 0 | 0.00 | $ 30,000 | 0 | 0.00 | $ 30,000 | 0 | 0.00 | $ 30,000 |
| CLIN X002 (Cost Reimbursement) | CLIN 4002-Option 4 | CLIN 5002-6 Month Ext | ||||
| Travel ITW/AA | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 - 12 Dec 21 | ||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost |
| Automatic Government Population | 0 | 0.00 | 30,000.00 | 0 | 0.00 | 15,000.00 |
| Subtotal CLIN X002 | 0 | 0.00 | $ 30,000 | 0 | 0.00 | $ 15,000 |
Attachment 4
&"Times New Roman,Regular" &"Times New Roman,Regular"&P / &N
CLIN X003 Labor NORAD_NORTHCOM
| Prime Name: | 0 |
| Sub Name: | 0 |
| CLIN X003 LABOR HOUR & PRICE BREAKDOWN |
| CLIN X003 (FFP) | CLIN 0003 - Base Period | CLIN 1003-Option 1 | CLIN 2003-Option 2 | CLIN 3003-Option 3 | ||||||||
| Labor-NORAD/NORTHCOM/J7 w/CCE & C2 | 13 Jun 16- 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | ||||||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| Subtotal with FTE CLIN X003 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 |
| CLIN X003 (FFP) (Years Con't) | CLIN 4003-Option 4 | CLIN 5003-6 Month Ext | ||||
| Labor-NORAD/NORTHCOM/J7 w/CCE & C2 | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 - 12 Dec 21 | ||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| Subtotal with FTE CLIN X003 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 |
Attachment 4
&"Times New Roman,Regular"&P / &N
CLINX004 Travel NORAD_NORTHCOM
| Prime Name: | 0 |
| Sub Name: | 0 |
| CLIN X004 Travel NORAD/NORTHCOM |
| CLIN X004 (Cost Reimbursement) | CLIN 0004 - Base Period | CLIN 1004-Option 1 | CLIN 2004-Option 2 | CLIN 3004-Option 3 | ||||||||
| Travel NORAD/NORTHCOM | 13 Jun 16 - 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | ||||||||
| Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | |
| Automatic Government Population | 0 | 0.00 | 5,000.00 | 0 | 0.00 | 5,000.00 | 0 | 0.00 | 5,000.00 | 0 | 0.00 | 5,000.00 |
| Subtotal CLIN X004 | 0 | 0.00 | $ 5,000 | 0 | 0.00 | $ 5,000 | 0 | 0.00 | $ 5,000 | 0 | 0.00 | $ 5,000 |
| CLIN X004 (Cost Reimbursement) | CLIN 4004-Option 4 | CLIN 5004-6 Month Ext | ||||
| Travel NORAD/NORTHCOM | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 - 12 Dec 21 | ||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost |
| Automatic Government Population | 0 | 0.00 | 5,000.00 | 0 | 0.00 | 2,500.00 |
| Subtotal CLIN X004 | 0 | 0.00 | $ 5,000 | 0 | 0.00 | $ 2,500 |
Attachment 4
CLIN X005 Material ODC-Support
| Prime Name: | 0 |
| Sub Name: | 0 |
| CLIN X005 Material ODC-NORAD |
| CLIN X005 (FFP) | CLIN 0005 - Base Period | CLIN 1005-Option 1 | CLIN 2005-Option 2 | CLIN 3005-Option 3 | ||||||||
| Material/ODC Support | 13 Jun 16 - 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | ||||||||
| Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | |
| Automatic Government Population | 0 | 0.00 | 5,000.00 | 0 | 0.00 | 5,000.00 | 0 | 0.00 | 5,000.00 | 0 | 0.00 | 5,000.00 |
| Subtotal CLIN X005 | 0 | 0.00 | $ 5,000 | 0 | 0.00 | $ 5,000 | 0 | 0.00 | $ 5,000 | 0 | 0.00 | $ 5,000 |
| CLIN X005 (FFP) (Years Con't) | CLIN 4005-Option 4 | CLIN 5005-6 Month Ext | ||||
| Material/ODC Support | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 - 12 Dec 21 | ||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost |
| Automatic Government Population | 0 | 0.00 | 5,000.00 | 0 | 0.00 | 2,500.00 |
| Subtotal CLIN X005 | 0 | 0.00 | $ 5,000 | 0 | 0.00 | $ 2,500 |
Attachment 4
&"Times New Roman,Regular"&P / &N
CLIN X006 Labor-Software_ATM
| Prime Name: | 0 |
| Sub Name: | 0 |
| CLIN X006 LABOR HOUR & PRICE BREAKDOWN |
| CLIN X006 (FFP) | CLIN 0006 - Base Period | CLIN 1006-Option 1 | CLIN 2006-Option 2 | CLIN 3006-Option 3 | ||||||||
| Labor-Software ATM Initiative | 13 Jun 16 - 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19-12 Jun 20 | ||||||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| Subtotal with FTE CLIN X007 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 |
| CLIN X006 (FFP) (Years Con't) | CLIN 4006-Option 4 | CLIN 5006-6 Month Ext | ||||
| Labor-Software ATM Initiative | 13 Jun 20 - 12 Jun 21 | 13 Jun 21- 12 Dec 21 | ||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | 0 | 0.00 | 0.00 | |
| Subtotal with FTE CLIN X007 | 0 | ERROR:#DIV/0! | $ - 0 | 0 | ERROR:#DIV/0! | $ - 0 |
Attachment 4
&"Times New Roman,Regular"&P / &N
CLIN X0007 Travel Software_ATM
| Prime Name: | 0 |
| Sub Name: | 0 |
| CLIN X007 Travel Software/ATM |
| CLIN X007 (Cost Reimbursement) | CLIN 0007 - Base Period | CLIN 1007-Option 1 | CLIN 2007-Option 2 | CLIN 3007-Option 3 | ||||||||
| Travel Travel/ATM | 13 Jun 16 - 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | ||||||||
| Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | Hours | Rate | Cost | |
| Automatic Government Population | 0 | 0.00 | 10,000.00 | 0 | 0.00 | 10,000.00 | 0 | 0.00 | 10,000.00 | 0 | 0.00 | 10,000.00 |
| Subtotal CLIN X007 | 0 | 0.00 | $ 10,000 | 0 | 0.00 | $ 10,000 | 0 | 0.00 | $ 10,000 | 0 | 0.00 | $ 10,000 |
| CLIN X007 (Cost Reimbursement) | CLIN 4007-Option 4 | CLIN 5007-6 Month Ext | ||||
| Travel Travel/ATM | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 - 12 Dec 21 | ||||
| Labor Category | Hours | Rate | Cost | Hours | Rate | Cost |
| Automatic Government Population | 0 | 0.00 | 10,000.00 | 0 | 0.00 | 5,000.00 |
| Subtotal CLIN X007 | 0 | 0.00 | $ 10,000 | 0 | 0.00 | $ 5,000 |
FA4600-15-R-0035, ITW/AA Recompete Attachment 4
CLIN X008 Transition
| Prime Name: | |||
| Sub Name: | |||
| CLIN 0008 (FFP) | CLIN 0008- BASE PERIOD | ||
| Transition | 13 Jun 16 -24 Jun 16 | ||
| Labor Category | Hours | Rate | Cost |
| Labor ITW/AA | |||
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| Labor NORAD/NORTHCOM | |||
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| Material/ODC Support | |||
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| Labor ATM Inititative | |||
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| 0 | 0.00 | 0.00 | |
| Cumulative Subtotal with FTE CLIN 0008 | 0 | ERROR:#DIV/0! | 0.00 |
Attachment 4
Grand Total
| Prime Name: | 0 | |||||||||||||
| BASE PERIOD | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | OPTION 5 - 6 MO EXT | |||||||||
| Note: All Cost figures are rounded to nearest dollar. | 13 Jun 16 - 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 - 12 Dec 21 | TOTAL | |||||||
| Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | Hours | Cost | |
| CLIN X001 FFP Labor ITW/AA | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - 0 |
| CLIN X003 FFP Labor NORAD/NORTHCOM | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - 0 |
| CLIN X005 FFP Labor Material ODC Support | 0 | $ 5,000 | 0 | $ 5,000 | 0 | $ 5,000 | 0 | $ 5,000 | 0 | $ 5,000 | 0 | $ 2,500 | 0 | $ 27,500 |
| CLIN X006 FFP Labor Software/ATM | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - | 0 | $ - 0 |
| CLIN X008 FFP Transition | 0 | 0 | $ - 0 | |||||||||||
| GRAND TOTAL BY YEAR | - 0 | $ 5,000 | - 0 | $ 5,000 | - 0 | $ 5,000 | - 0 | $ 5,000 | - 0 | $ 5,000 | - 0 | $ 2,500 | - 0 | $ 27,500 |
| FTE TOTALS FOR PRIME & SUB | ||||||||||
| BASE PERIOD | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | OPTION 5 - 6 MO EXT | TOTAL | ||||
| Total FTEs | 13 Jun 16 - 15 Jul 15 | 16 Jul 15- 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 - 12 Dec 21 | FTEs | % | |
| FTE GRAND TOTAL | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#REF! |
| OTHER DIRECT COSTS AND TRAVEL | ||||||||
| BASE PERIOD | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | OPTION 5 - 6 MO EXT | |||
| Travel & Material/Equip | 13 Jun 16 - 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 -12 Dec 21 | TOTAL | |
| CLIN X002 Travel ITW/AA | $ 30,000 | $ 30,000 | $ 30,000 | $ 30,000 | $ 30,000 | $ 15,000 | $ 165,000 | |
| CLIN X004 Travel NORAD/NORTHCOM | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 2,500 | $ 27,500 | |
| CLIN X007 Travel ATM Initiative | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | $ 5,000 | $ 55,000 | |
| GRAND TOTAL TRAVEL/ODCs | $ 45,000 | $ 45,000 | $ 45,000 | $ 45,000 | $ 45,000 | $ 22,500 | $ 247,500 |
| GRAND TOTAL SUMMARY | ||||||||
| BASE PERIOD | OPTION 1 | OPTION 2 | OPTION 3 | OPTION 4 | OPTION 5 - 6 MO EXT | |||
| 13 Jun 16 - 12 Jun 17 | 13 Jun 17 - 12 Jun 18 | 13 Jun 18 - 12 Jun 19 | 13 Jun 19 - 12 Jun 20 | 13 Jun 20 - 12 Jun 21 | 13 Jun 21 - 12 Dec 21 | TOTAL | ||
| TOTAL PROPOSED PRICE | Cost | Cost | Cost | Cost | Cost | Cost | Cost | |
| GRAND TOTAL LABOR | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 2,500 | 27,500 | |
| GRAND TOTAL TRAVEL & ODCs | 45,000 | 45,000 | 45,000 | 45,000 | 45,000 | 22,500 | 247,500 | |
| GRAND TOTAL PROPOSED PRICE | 50,000 | 50,000 | 50,000 | 50,000 | 50,000 | 25,000 | 275,000 |
&"Times New Roman,Regular"&12FA4600-15-R-0035,ITW/AA Recompete Attachment 5 &D
&"Times New Roman,Regular" &P / &N
Benefits
| Prime Name: | 0 |
| Solicitation No. | FA4600-15-R-0035 |
| EMPLOYEE COMPENSATION PLAN | |
| INSTRUCTIONS: | Complete this chart and the Salary Data chart. Completion of this TAB "Benefit Summary" is mandatory and satisfies the requirement for the FAR 52.222-46 clause for Employee Compensation Plan. No other information is required for the Employee Compensation Plan, although supplementary information may be submitted, if desired. See "EMPLOYEE COMPENSATION PLAN GUIDE" below for guidance on how to complete the below chart. |
| Salaries |
| Salary Supporting Data |
| Eligibility for Benefits |
| Vacation |
| Sick Leave |
| Holidays |
| Military leave |
| Jury Duty |
| Medical Insurance |
| Dental Care |
| Vision Care |
| Short Term Disability |
| Long-Term Disability |
| Life Insurance |
| Retirement /Pension |
| Education Assistance |
| % of Salary (Fringe Benefits) |
| Additional Notes: |
| EMPLOYEE COMPENSATION PLAN GUIDE |
| In order to receive a contract award, a company must have an acceptable Professional Employee Compensation Plan. A company may have an excellent record of employee retention and may have a high fringe rate, but if the Professional Employee Compensation Plan does not support this, it is impossible to make a determination of acceptability. Without an acceptable plan, a company cannot receive contract award without opening discussions. 55th CONS strives to award contracts based on initial proposals. |
| This guidance was developed to provide the contractors with insight as to the information 55th CONS needs to evaluate a compensation plan. Contractors required to submit a compensation plan must complete the tab in the pricing model labeled "Benefit Summary". Completion of these spreadsheets is mandatory and satisfies the requirement for the Employee Compensation Plan. No additional information is required, but supplemental data may be provided if desired. |
| Important: The Employee Compensation Plan does not have to be long, and does not have to present the entire employee manual. It is possible to provide the pertinent information in 2 or 3 pages using the attached guidance. Chart or spreadsheet format is an effective way to provide the information. |
Attachment 4
Exc Rate Caculation
| Prime Name: | 0 |
| ESCALATION RATE CALCULATIONS | |
| PLACE YOUR ESC. SPREADSHEETS HERE and THEN LINK FULLY BURDENED RATE TO "Loading Factors" tab under appropriate columns for each performance year (Base Year, Op Yrs 1 - 4) |
FA4600-15-R-0035, ITW/AA Recompete Attachment 4
Labor Cat Descriptions
| ITW/AA Labor Category Descriptions | |||
| Skill Level Definitions | Level I (Entry/Junior): less than 5 years experience | Requires a HS Diploma (BA/BS Preferred) and 0-5 years of experience in the field or in a related area; Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Primary job functions do not typically require exercising independent judgment. Works under general supervision; typically reports to a supervisor or manager. | NOTE: Experience may be factored in lieu of education for qualification purposes. |
| Level II (Intermediate): 5 to 12 years experience | May require a master’s degree; at least 5-12 years of experience in the field or in a related area; Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment |
to plan and accomplish goals. May lead and direct the work of others. May report to a supervisor or manager.
Level III (Senior): more than 10 years experience May require a master’s degree and/or Ph.D.; at least 12 years of experience in the field or in a related area; Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals and independently performs a wide variety of complicated tasks. May provide consultation on complex projects and is considered to be the top level contributor/ specialist. May lead and direct the work of others. May report to an executive or director.
| Num | Labor Category Name | Description |
| 1 | Computer System Analyst | Analyzes and develops computer software possessing a wide range of capabilities, including numerous engineering, business, and records management functions. Develops plans for automated information systems from project inception to conclusion. Analyzes user interfaces, maintain hardware and software performance tuning, analyze workload and computer usage, maintain interfaces with outside systems, analyze downtimes, analyze proposed system modifications, upgrades and new COTS. Analyzes the problem and the information to be processed. Defines the problem, and develops system requirements and program specifications, from which programmers prepare detailed flow charts, programs, and tests. Coordinates closely with programmers to ensure proper implementation of program and system specifications. Develops, in conjunction with functional users, system alternative solutions. |
| 2 | Data/Configuration Management Specialist | Supports configuration management planning. Describes provisions for configuration identification, change control, configuration status accounting, and configuration audits. Supports configuration planning. Identifies and maintains the original configuration of requirements documentation, design documentation, software, and related documentation. Responsible for configuration change control. Supports the change process so that only approved and validated changes are incorporated into product documents and related software. Responsible for configuration status accounting. Tracks all problems and changes in product documents and software and reports changes and current configuration. Responsible for configuration audits. Supports audits to verify that requirements of all baselines have been met. |
| 3 | Engineer | Provides engineering, technical, and managerial direction for problem definition, analysis, requirement development and implementation for complex systems in the engineering discipline required to meet technical requirements. Makes recommendations and advises on system development, improvements, optimization, or support efforts. Performs risk assessments and analysis employing modeling and simulation techniques. |
| 4 | Modeling and Simulation Specialist | Expert in modeling and simulation functions or operations such as, but not limited to exercises, plans, coordination, demonstrations, and instruction in the fields such as, but not limited to health, environmental, transportation, law enforcement, military, and civil agencies. Provides supervision and guidance on the proper operation and use of simulation models and exercises. May support live, constructive, or virtual training. |
| 5 | Program Manager | Serves as the contractor's single contract manager, and shall be the contractor's authorized interface with the Government Contracting Officer (CO), the contract level Contracting Officer's Representative (COR), government management personnel and customer agency representatives. Responsible for formulating and enforcing work standards, assigning contractor schedules, reviewing work discrepancies, supervising contractor personnel and communicating policies, purposes, and goals of the organization to subordinates. Shall be responsible for the overall contract performance and shall not serve in any other capacity under this contract. |
| 6 | Project Manager | Responsible for the overall management of the specific task order(s) and insuring that the technical/financial solutions and schedules in the specific delivery orders are implemented in a timely manner. Organizes, directs and coordinates the planning and production of all activities associated with assigned delivery order projects. Demonstrates competent writing and oral communication skills. Ensures quality products and services are delivered. |
| 7 | Subject Matter Expert | Provides extremely high level subject matter expertise for work described in the task. Provides advanced technical knowledge and analysis of highly specialized applications and operational environment, high-level functional systems analysis, design, integration, documentation, training, and implementation advice on complex problems which require doctorate level knowledge of the subject matter for effective implementation. Applies principles, methods, and knowledge of specific functional areas of expertise to specific task order requirements. Provides advice on esoteric problems which require extensive knowledge of the subject matter. Designs and prepares technical reports, studies, and related documentation, makes charts and graphs to record results, prepares and delivers presentations, training, and briefings as required by the task order. |
| 8 | System Analyst | Formulates/defines system scope and objectives for assigned projects. Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time and form of desired results. Prepares detailed specifications from which programs will be written. Responsible for program design, coding, testing, debugging and documentation. Has full technical knowledge of all phases of applications systems analysis and programming. Has good understanding of the business or function for which applications is designed. |
| 9 | Systems Engineer | Performs a variety of complex project tasks applied to specialized technology problems. Tasks involve integration of electronic processes or methodologies to resolve total system problems or technology problems. Applies analytical and systematic approaches in the resolution of problems of work flow, organization, and planning. Directs and assists system engineers in the application of system engineering principles to the solution of secure systems design problems. Expert knowledge of LANs, WANs, VPNs, routers, firewalls, network protocols, and other security and network operations and monitoring, vulnerability analysis, PKI, data encryption, key management, data warehousing, and data mining capabilities. |
| 10 | Test Engineer | Provides test and evaluation of hardware and/or software development. This includes developing and documenting test plans and procedures, conducting testing, and evaluating and documenting results. Prepares studies, plans, and analyses in support of the delivery order. |
Attachment 4
File details come from the government source that posted it. Updated .