Attachment_3_-_Pricing_Matrix_Spreadsheet.xlsx
XLSX spreadsheet 37 KB Posted
- Solicitation number
- N55236-16-R-0006
About this file
Attachment 3 Pricing Matrix Spreadsheet
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N55236-16-R-0006-0001.pdf | ||
| Attachment_2_-_Request_for_Specification_Clarification_Form.doc | DOC document | |
| Attachment_4_-_Profit_Adjustment_Formula.docx | DOCX document | |
| Exhibit_A_-_SWRMC_PV-CDRL.pdf | ||
| N55236-16-R-0006.pdf | ||
| Attachment_1_-_Reference_Information_Sheet.docx | DOCX document |
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
Material Worksheet
PRIME VENDOR MATERIALS PRICING MATRIX
SOLICITATION NO. N55236-16-R-0006
OFFEROR NAME:
FFP MATERIAL CLINs Description of Material/ODC Estimated # of Delivery Orders/Year* Material Cost Ceiling* Fully Burdened Labor** Material Total (Target Cost)
| 0001 | Base Year | 300+ | $ 2,962,807.00 | $ - 0 | $ 2,962,807.00 |
| 1001 | Option Year 1 | 309+ | $ 3,051,691.21 | $ - 0 | $ 3,051,691.21 |
| 2001 | Option Year 2 | 318+ | $ 3,143,241.95 | $ - 0 | $ 3,143,241.95 |
| 3001 | Option Year 3 | 328+ | $ 3,237,539.20 | $ - 0 | $ 3,237,539.20 |
| 4001 | Option Year 4 | 338+ | $ 3,334,665.38 | $ - 0 | $ 3,334,665.38 |
| $ - 0 | $ - 0 | $ - 0 | |||
| Total Cost of Material/ODC's | $ 15,729,944.74 | $ - 0 | $ 15,729,944.74 | ||
| * Note - Estimated # of Delivery Orders and Material Cost Ceilings Estimated with 3% Growth per/Year. | |||||
| **Note - Offeror to complete highlighted portion of spreadsheet and provide separate breakout of proposed labor categories, hours, and rates to support. | |||||
| N55236-16-R-0006 | |||||
| ATTACHMENT 3 |
Services Worksheet
PRIME VENDOR SERVICES PRICING MATRIX
SOLICITATION NO. N55236-16-R-0006
OFFEROR NAME:
FFP SERVICES CLINs Description of Service/ODC Estimated # of Delivery Orders/Year Services Cost Ceiling* Fully Burdened Labor** Services Total (Target Cost)
| 0002 | Base Year | 100 | $ 1,210,161.00 | $ - 0 | $ 1,210,161.00 |
| 1002 | Option Year 1 | 103 | $ 1,246,465.83 | $ - 0 | $ 1,246,465.83 |
| 2002 | Option Year 2 | 107 | $ 1,283,859.80 | $ - 0 | $ 1,283,859.80 |
| 3002 | Option Year 3 | 110 | $ 1,322,375.60 | $ - 0 | $ 1,322,375.60 |
| 4002 | Option Year 4 | 113 | $ 1,362,046.87 | $ - 0 | $ 1,362,046.87 |
| $ - 0 | $ - 0 | $ - 0 | |||
| Total Cost of Services/ODC's | $ 6,424,909.10 | $ - 0 | $ 6,424,909.10 |
* Note - Services Cost Ceiling Estimated with 3% Product Family Work Growth per/Year.
**Note - Offeror to complete highlighted portion of spreadsheet and provide separate breakout of proposed labor categories, hours, and rates to support.
| N55236-16-R-0006 |
| ATTACHMENT 3 |
Incentive Worksheet
PRIME VENDOR INCENTIVE PRICING MATRIX
SOLICITATION NO. N55236-16-R-0006
OFFEROR NAME:
FPI CLINs Description Material Worksheet Totals Services Worksheet Totals Total Target Cost Target Profit 6%** Target Price
| 0003 | Base Year | $ 2,962,807.00 | $ 1,210,161.00 | $ 4,172,968.00 | $ 250,378.08 | $ 4,423,346.08 |
| 1003 | Option Year 1 | $ 3,051,691.21 | $ 1,246,465.83 | $ 4,298,157.04 | $ 257,889.42 | $ 4,556,046.46 |
| 2003 | Option Year 2 | $ 3,143,241.95 | $ 1,283,859.80 | $ 4,427,101.75 | $ 265,626.11 | $ 4,692,727.86 |
| 3003 | Option Year 3 | $ 3,237,539.20 | $ 1,322,375.60 | $ 4,559,914.80 | $ 273,594.89 | $ 4,833,509.69 |
| 4003 | Option Year 4 | $ 3,334,665.38 | $ 1,362,046.87 | $ 4,696,712.25 | $ 281,802.73 | $ 4,978,514.98 |
| $ - 0 | $ - 0 | $ - 0 | ||||
| Incentive Target Profit/Price | $ 22,154,853.84 | $ 1,329,291.23 | $ 23,484,145.07 | |||
| *This worksheet auto-populates from Material/Services Worksheets. | ||||||
| ** Note - FPI Matrix is based on the incentive arrangement point of departure recommended in DFARS 216.403-1(b)(2) with applied risk adjustment resulting in the following: |
| Under Target Ratio: (Government Share/Contractor Share) 50/50 | |
| Over Target Ratio: (Government Share/Contractor Share) 50/50 | |
| Ceiling Price: Target Cost x 110% | |
| Target Profit: Target cost x 6% (Based on Weighted Guidelines) | |
| N55236-16-R-0006 | |
| ATTACHMENT 3 |
G&A Rates
PRIME VENDOR INCENTIVE PRICING MATRIX
SOLICITATION NO. N55236-16-R-0006
OFFEROR NAME:
BASE YEAR - FY17 G&A Applicable to: % OY 1 - FY18 G&A Applicable to: % OY 2 - FY19 G&A Applicable to: % OY 3 - FY20 G&A Applicable to: % OY 4 - FY21 G&A Applicable to: %
| Labor Costs | 0.00% | Labor Costs | 0.00% | Labor Costs | 0.00% | Labor Costs | 0.00% | Labor Costs | 0.00% |
| FCCOM | 0.00% | FCCOM | 0.00% | FCCOM | 0.00% | FCCOM | 0.00% | FCCOM | 0.00% |
| Materials | 0.00% | Materials | 0.00% | Materials | 0.00% | Materials | 0.00% | Materials | 0.00% |
| Services | 0.00% | Services | 0.00% | Services | 0.00% | Services | 0.00% | Services | 0.00% |
| ODCs | 0.00% | ODCs | 0.00% | ODCs | 0.00% | ODCs | 0.00% | ODCs | 0.00% |
Escalation Factor 0.00% Escalation Factor 0.00% Escalation Factor 0.00% Escalation Factor 0.00%
| *Note - Offeror to complete all highlighted portions of spreadsheet. | |
| N55236-16-R-0006 | |
| ATTACHMENT 3 |
File details come from the government source that posted it. Updated .