Atch_11_Pricing_Template_7_Nov_2016.xls
XLS spreadsheet 105 KB Posted
- Attached to
- Hostile Forces - Tagging, Tracking and Locating
- Solicitation number
- H92222-16-R-0028
- Issued by
-
United States Special Operations Command
About this file
Revised Attachment 11 dated 11 Nov 2016 replaces all previous versions
View the file
Other files
| File | Type | Posted |
|---|---|---|
| H92222-16-R-0028-0004.pdf | ||
| Atch_19__Q_and_A.xlsx | XLSX spreadsheet | |
| Atch_18_Follow-on_Q_and_A.xlsx | XLSX spreadsheet | |
| H92222-16-R-0028-0003.pdf | ||
| Atch_7_PPI_2_Nov_16.doc | DOC document | |
| Atch_17_Follow-on_Q_and_A.xlsx | XLSX spreadsheet | |
| H92222-16-R-0028-0002.pdf | ||
| Atch_11_Pricing_Template_Rev_-_102616.xls | XLS spreadsheet | |
| H92222-16-R-0028-0001.pdf | ||
| Atch_16_Combined_Q_and_A.xlsx | XLSX spreadsheet | |
| Atch_13_SDS_Basic_21_Jul_16.xlsx | XLSX spreadsheet | |
| Atch_15_SDS_NET_9_Sep_16.xlsx | XLSX spreadsheet | |
| Atch_14_SDS_FSR_OP_9_Sep_16.xlsx | XLSX spreadsheet | |
| Atch_11_Pricing_Template_Rev_-_091216.xls | XLS spreadsheet | |
| Atch_10_Client_Authorization.doc | DOC document | |
| Atch_8_SF1408-14.pdf | ||
| H92222-16-R-0028.pdf | ||
| Atch_4_DD254.pdf | ||
| Atch_9_Sub-contractor_Consent.doc | DOC document | |
| Atch_6_OCI_Disclosure_Form.docx | DOCX document | |
| Atch_12_Cost-Price_Instructions_Attachment.docx | DOCX document | |
| Atch_5_CDRL_A001_Monthly_Reports.pdf | ||
| Atch_7PPQ_Questionnaire_Interview.docx | DOCX document |
Show all 23
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
TPP
| Total Proposed Price (TPP) | ||||||
| TO TEP | ||||||
| TO #1 Field Service Representative and Operational Planner Support (FSR & OPS) | $3,512,727 | |||||
| TO #2 New Equipment Training (NET) | $219,375 | |||||
| Total Proposed Price (TPP) | $3,732,102 | |||||
| Summary of Proposed TO #1 FSR & OPS Price | $3,512,727 | |||||
| Description | Base Year | Option Yr. 1 | Option Yr. 2 | Option Yr. 3 | Option Yr. 4 | Total |
| FPP Labor | $0 | $0 | $0 | $0 | $0 | $0 |
| ODCs | $0 | $0 | $0 | $0 | $0 | $0 |
| FFP CLIN Subtotal | $0 | $0 | $0 | $0 | $0 | $0 |
| Travel (Cost CLIN) | $675,000 | $688,500 | $702,270 | $716,315 | $730,642 | $3,512,727 |
| Cost CLIN Subtotal | $675,000 | $688,500 | $702,270 | $716,315 | $730,642 | $3,512,727 |
| Total Proposed Price | $675,000 | $688,500 | $702,270 | $716,315 | $730,642 | $3,512,727 |
| Summary of Proposed TO #2 NET Price | $219,375 | |||||
| Description | Base Year | Total | ||||
| Labor | $0 | $0 | ||||
| ODC Other | $21,875 | $21,875 | ||||
| Travel | $197,500 | $197,500 | ||||
| Indirect Costs | $0 | $0 | ||||
| Fee | $0 | $0 | ||||
| FCCM | $0 | $0 | ||||
| Total Proposed Price | $219,375 | $219,375 |
Section B Prices
| Section B Totals - TO #1 Field Service Representative and Operational Planner Support (FSR & OPS) | Section B Totals - TO #2 NET | |||||||||
| ITEM NO | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE* | AMOUNT | ITEM NO | SUPPLIES/SERVICES | COST* | TOTAL AMOUNT | |
| 0001 | FFP - Labor | 12 | Months | $0.00 | $0.00 | 0002 | CPFF - Labor | $0.00 | $0.00 | |
| 0003 | Travel | 1 | Lot | $675,000.00 | $675,000.00 | 0003 | Cost - Travel | $197,500.00 | $197,500.00 | |
| 0003 | Cost - ODC Other | $21,875.00 | $21,875.00 | |||||||
| Fee | $0.00 | $0.00 | ||||||||
| FSR & OPT Base Total | $675,000.00 | NET Base Total | $219,375.00 | |||||||
| ITEM NO | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE* | AMOUNT | Total | $219,375.00 | |||
| 1001 | FFP - Labor | 12 | Months | $0.00 | $0.00 | |||||
| 1003 | Travel | 1 | Lot | $688,500.00 | $688,500.00 | |||||
| FSR & OPT OY1 Total | $688,500.00 | |||||||||
| ITEM NO | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE* | AMOUNT | |||||
| 2001 | FFP - Labor | 12 | Months | $0.00 | $0.00 | |||||
| 2003 | Travel | 1 | Lot | $702,270.00 | $702,270.00 | |||||
| FSR & OPT OY1 Total | $702,270.00 | |||||||||
| ITEM NO | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE* | AMOUNT | |||||
| 3001 | FFP - Labor | 12 | Months | $0.00 | $0.00 | |||||
| 3003 | Travel | 1 | Lot | $716,315.40 | $716,315.40 | |||||
| FSR & OPT OY1 Total | $716,315.40 | |||||||||
| ITEM NO | SUPPLIES/SERVICES | QUANTITY | UNIT | UNIT PRICE* | AMOUNT | |||||
| 4001 | FFP - Labor | 12 | Months | $0.00 | $0.00 | |||||
| 4003 | Travel | 1 | Lot | $730,641.71 | $730,641.71 | |||||
| FSR & OPT OY1 Total | $730,641.71 | |||||||||
| Total | $3,512,727.11 |
TO #1 FSR & OPS
HF-TTL FSR and Ops Planner Firm Fixed Price: The quantity of hours for each labor category will be multiplied by the fully burdened labor rate. The amount negotiated for ODCs will be added to the total labor amount to arrive at the task order FFP. The Government provided travel amount plus proposed G&A; as applicable, will be added to the FFP to arrive at the Total Task Order price.
| SOW Para. | # of FTEs | Hours per FTE* | Total Annual Hrs | FBLR | Base Year | FBLR | Year 1 | FBLR | Year 2 | FBLR | Year 3 | FBLR | Year 4 | Total | |
| Field Service Representative (FSR) | 4.1 | 35 | 1,880 | 65,800 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $0.00 |
| Operational Planners | 4.2 | 3 | 1,880 | 5,640 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $0.00 |
| In-theater Field Service Representative | 4.1.1.5 | 14 | 1,880 | 26,320 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $ - 0 | $0.00 | $0.00 |
| Total FFP Labor | 5,640 | 97,760 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Other Direct Costs-provide a Basis of Estimate (BOE) for any proposed ODCs not included in the FBLR | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| FFP Subtotal | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| Travel - Government provided amount for evaluation purposes | $675,000.00 | $688,500.00 | $702,270.00 | $716,315.40 | $730,641.71 | $3,512,727.11 | |||||||||
| G&A on Travel (Insert applicable G&A rate in highlighted cells) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||
| Total Travel | $675,000.00 | $688,500.00 | $702,270.00 | $716,315.40 | $730,641.71 | $3,512,727.11 | |||||||||
| Annual Total | $675,000.00 | $688,500.00 | $702,270.00 | $716,315.40 | $730,641.71 | $3,512,727.11 | |||||||||
| Task Order Total Proposed Price | $3,512,727.11 | ||||||||||||||
| *Hours: The hours provided are the required hours for this task; DO NOT change the number of hours per FTE or Total Annual Hours |
TO #2 NET
| Instructions: | ||||||
| 1. Do not change Labor hours | ||||||
| 2. Insert applicable amounts in yellow highlighted cells. | ||||||
| 3. If required, insert additional rows as needed for Indirect Costs and FCCM and ensure that the formula captures the changes. | ||||||
| 4. Provide data to support proposed Rates IAW Cost/Price Narrative Instructions Attachment #_12____. | ||||||
| 5. 470 hours represents 90 days. | ||||||
| New Equipment Training - CPFF | ||||||
| Base Year | Total | |||||
| Resource | FTEs | Hours/Allocation Base | Rate | Amount | Hours | Amount |
| Labor | ||||||
| NET Training | 21 | 470 | $0.00 | 9,870.00 | $0.00 | |
| Total Labor | $0.00 | 9,870.00 | - 0 | |||
| Other Direct Costs (ODC) | ||||||
| ODC Other | ||||||
| Training Kit (Government Provided Amount) | $15,000.00 | $15,000.00 | ||||
| Shipping (Government Provided Amount) | $6,875.00 | $6,875.00 | ||||
| Total ODC Other | $21,875.00 | $21,875.00 | ||||
| Travel (Government Provided Amount) | $197,500.00 | $197,500.00 | ||||
| Total ODC | $219,375.00 | $219,375.00 | ||||
| Total Direct Cost | $219,375.00 | $219,375.00 | ||||
| Indirect Costs | ||||||
| Fringe | $0.00 | $0.00 | ||||
| Overhead (OH) | $0.00 | $0.00 | ||||
| G&A on Labor | $0.00 | $0.00 | ||||
| G&A on ODC Other | $21,875.00 | $0.00 | $0.00 | |||
| G&A on Travel | $197,500.00 | $0.00 | $0.00 | |||
| Total G&A | $0.00 | $0.00 | ||||
| Total Indirect Costs | $0.00 | $0.00 | ||||
| Total Cost | $219,375.00 | $219,375.00 | ||||
| Fee | $0.00 | $0.00 | ||||
| Facilities Capital Cost of Money (FCCM) | ||||||
| OH COM | $0.00 | $0.00 | ||||
| G&A COM (Labor) | $0.00 | $0.00 | ||||
| G&A COM (ODC Other) | $0.00 | $0.00 | ||||
| G&A COM (Travel) | $0.00 | $0.00 | ||||
| Total FCCM | $0.00 | $0.00 | ||||
| Total Price | $219,375.00 | 9,870.00 | $219,375.00 | |||
| $219,375.00 |
FBLR Development
| Fully Burdened Labor Rate (FBLR) Development | ||||||
| Instructions: | ||||||
| Fill in rates in yellow highlighted cells. | ||||||
| Ensure that indirect rates are charged to labor IAW your accounting practices. | ||||||
| Change formula if required. | ||||||
| Add columns for additional indirect rates if necessary. | ||||||
| If any indirect rate utilized below is not applicable, leave it blank | ||||||
| Base Year | ||||||
| Labor Category | Direct Labor | Fringe % | OH % | G&A % | Profit % | FBLR |
| Hrly Rate | ||||||
| Field Service Representative (FSR) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Operational Planners | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| In-theater Field Service Representative | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| FSR/OP Program Management | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option Year 1 | ||||||
| Labor Category | Direct Labor | Fringe % | OH % | G&A % | Profit % | FBLR |
| Hrly Rate | ||||||
| Field Service Representative (FSR) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Operational Planners | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| In-theater Field Service Representative | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| FSR/OP Program Management | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option Year 2 | ||||||
| Labor Category | Direct Labor | Fringe % | OH % | G&A % | Profit % | FBLR |
| Hrly Rate | ||||||
| Field Service Representative (FSR) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Operational Planners | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| In-theater Field Service Representative | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| FSR/OP Program Management | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option Year 3 | ||||||
| Labor Category | Direct Labor | Fringe % | OH % | G&A % | Profit % | FBLR |
| Hrly Rate | ||||||
| Field Service Representative (FSR) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Operational Planners | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| In-theater Field Service Representative | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| FSR/OP Program Management | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Option Year 4 | ||||||
| Labor Category | Direct Labor | Fringe % | OH % | G&A % | Profit % | FBLR |
| Hrly Rate | ||||||
| Field Service Representative (FSR) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Operational Planners | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| In-theater Field Service Representative | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| FSR/OP Program Management | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
File details come from the government source that posted it. Updated .