M67854-18-R-7600_-_Attachment_7_-_PDSS_CLIN_X001_Share_Lines.xlsx
XLSX spreadsheet 99 KB Posted
- Attached to
- Amendment 6
- Solicitation number
- M67854-18-R-7600
- Issued by
-
United States Marine Corps
About this file
This document contains a file attachment and description related to a federal solicitation for professional services and systems engineering support. The file attachment provides templates for vendors to submit estimated annual costs for contract line item numbers to support the United States Marine Corps over five years. Pricing is to be submitted for CLINs 0001 through 4001, with annual fee percentages calculated based on proposed costs and target availability rates of 96% each year. Contractors can earn additional fee incentives for availability above 96%, but will receive no fee if availability is below 85%. The solicitation was originally scheduled for release in January 2018 but has been delayed until the third week of January due to circumstances beyond the agency's control.
M67854-18-R-7600 - Attachment 7
View the file
Other files
Show 40 more
Latest 50 of 57 listed here. See the rest on GovTribe.
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
Estimate
| * Vendor bids Target cost ONLY for each year | ||||
| Target Cost for CLIN X001 | ||||
| Variables | Calculations | |||
| Target Cost | 25 | Cost (M) | Fee (M) | |
| Target Fee Percentage | 5.5% | Min Effective Cost | $ 21.25 | $ 3.25 |
| Under Share Vendor | 50% | Target Cost | $ 25.00 | $ 1.38 |
| Over Share Vendor | 30% | Point of Total Assumption | $ 28.39 | $ 0.36 |
| Ceiling Price Percentage | 115% | Ceiling Price | $ 28.75 | $ - 0 |
| Min Effective Cost | 85% |
&A &D
Cost versus Fee
Fee (M) [Y VALUE]
21.25 25 28.392857142857139 28.749999999999996 3.25 1.375 0.35714285714285765 0 Cost (Millions)
Fee (Millions)
Year 1
| * Vendor bids Target cost ONLY for each year | |||||
| All other variables remain "locked" | |||||
| Target Cost is for CLIN 0001 | |||||
| Variables | Calculations | ||||
| Target Cost | Cost (M) | Fee (M) | |||
| Target Fee Percentage | 5.5% | Min Effective Cost | ERROR:#VALUE! | ERROR:#VALUE! | |
| Under Share Vendor | 50% | Target Cost | ERROR:#VALUE! | ||
| Over Share Vendor | 30% | Point of Total Assumption | ERROR:#VALUE! | ERROR:#VALUE! | |
| Ceiling Price Percentage | 115% | Ceiling Price | ERROR:#VALUE! | $ - 0 | |
| Min Effective Cost | 85% |
&A &D
Cost versus Fee
Fee (M) [Y VALUE]
#VALUE! #VALUE! #VALUE! 0 0 0 0 Cost (Millions)
Year 2
| * Vendor bids Target cost ONLY for each year | |||||
| All other variables remain "locked" | |||||
| Target Cost is for CLIN 1001 | |||||
| Variables | Calculations | ||||
| Target Cost | Cost (M) | Fee (M) | |||
| Target Fee Percentage | 5.5% | Min Effective Cost | ERROR:#VALUE! | ERROR:#VALUE! | |
| Under Share Vendor | 50% | Target Cost | ERROR:#VALUE! | ||
| Over Share Vendor | 30% | Point of Total Assumption | ERROR:#VALUE! | ERROR:#VALUE! | |
| Ceiling Price Percentage | 115% | Ceiling Price | ERROR:#VALUE! | $ - 0 | |
| Min Effective Cost | 85% |
&A &D
Cost versus Fee
Fee (M) [Y VALUE]
#VALUE! #VALUE! #VALUE! 0 0 0 0 Cost (Millions)
Year 3
| * Vendor bids Target cost ONLY for each year | |||||
| All other variables remain "locked" | |||||
| Target Cost is for CLIN 2001 | |||||
| Variables | Calculations | ||||
| Target Cost | Cost (M) | Fee (M) | |||
| Target Fee Percentage | 5.5% | Min Effective Cost | ERROR:#VALUE! | ERROR:#VALUE! | |
| Under Share Vendor | 50% | Target Cost | ERROR:#VALUE! | ||
| Over Share Vendor | 30% | Point of Total Assumption | ERROR:#VALUE! | ERROR:#VALUE! | |
| Ceiling Price Percentage | 115% | Ceiling Price | ERROR:#VALUE! | $ - 0 | |
| Min Effective Cost | 85% |
&A &D
Cost versus Fee
Fee (M) [Y VALUE]
#VALUE! #VALUE! #VALUE! 0 0 0 0 Cost (Millions)
Year 4
| * Vendor bids Target cost ONLY for each year | |||||
| All other variables remain "locked" | |||||
| Target Cost is for CLIN 3001 | |||||
| Variables | Calculations | ||||
| Target Cost | Cost (M) | Fee (M) | |||
| Target Fee Percentage | 5.5% | Min Effective Cost | ERROR:#VALUE! | ERROR:#VALUE! | |
| Under Share Vendor | 50% | Target Cost | ERROR:#VALUE! | ||
| Over Share Vendor | 30% | Point of Total Assumption | ERROR:#VALUE! | ERROR:#VALUE! | |
| Ceiling Price Percentage | 115% | Ceiling Price | ERROR:#VALUE! | $ - 0 | |
| Min Effective Cost | 85% |
&A &D
Cost versus Fee
Fee (M) [Y VALUE]
#VALUE! #VALUE! #VALUE! 0 0 0 0 Cost (Millions)
Year 5
| * Vendor bids Target cost ONLY for each year | |||||
| All other variables remain "locked" | |||||
| Target Cost is for CLIN 4001 | |||||
| Variables | Calculations | ||||
| Target Cost | Cost (M) | Fee (M) | |||
| Target Fee Percentage | 5.5% | Min Effective Cost | ERROR:#VALUE! | ERROR:#VALUE! | |
| Under Share Vendor | 50% | Target Cost | ERROR:#VALUE! | ||
| Over Share Vendor | 30% | Point of Total Assumption | ERROR:#VALUE! | ERROR:#VALUE! | |
| Ceiling Price Percentage | 115% | Ceiling Price | ERROR:#VALUE! | $ - 0 | |
| Min Effective Cost | 85% |
&A &D
Cost versus Fee
Fee (M) [Y VALUE]
#VALUE! #VALUE! #VALUE! 0 0 0 0 Cost (Millions)
Availability Yr 1
| Ao | Fee |
| 90% | 2.00% |
| 91% | 2.25% |
| 92% | 2.50% |
| 93% | 2.75% |
| 94% | 3.00% |
| 95% | 4.25% |
| 96% | 5.50% |
| 97% | 6.25% |
| 98% | 7.00% |
| 99% | 7.75% |
| 100% | 8.50% |
| There is 0% Ao profit fee paid to contractor below 85% AND they are INELIGIBLE for cost profit fee payments that month | |
| Target Availability is 96% |
Fee (as % of CLIN 0001)
Fee 0.9 0.91 0.92 0.93 0.94 0.95 0.96 0.97 0.98 0.99 1 0.02 2.2499999999999999E-2 2.5000000000000001E-2 2.75E-2 0.03 4.2500000000000003E-2 5.5E-2 6.25E-2 7.0000000000000007E-2 7.7499999999999999E-2 8.5000000000000006E-2 System Availability percentage
Fee Earned By Contractor
Availability Yr 2
| Ao | Fee |
| 90% | 0.00% |
| 91% | 0.00% |
| 92% | 0.00% |
| 93% | 2.75% |
| 94% | 3.00% |
| 95% | 4.25% |
| 96% | 5.50% |
| 97% | 6.25% |
| 98% | 7.00% |
| 99% | 7.75% |
| 100% | 8.50% |
| There is 0% Ao profit fee paid to contractor below 85% AND they are INELIGIBLE for cost profit fee payments that month | |
| Target Availability is 96% |
Fee (as % of CLIN 1001)
Fee 0.9 0.91 0.92 0.93 0.94 0.95 0.96 0.97 0.98 0.99 1 0 0 0 2.75E-2 0.03 4.2500000000000003E-2 5.5E-2 6.25E-2 7.0000000000000007E-2 7.7499999999999999E-2 8.5000000000000006E-2 System Availability percentage
Availability Yr 3
| Ao | Fee |
| 90% | 0.00% |
| 91% | 0.00% |
| 92% | 0.00% |
| 93% | 0.00% |
| 94% | 3.00% |
| 95% | 4.25% |
| 96% | 5.50% |
| 97% | 6.25% |
| 98% | 7.00% |
| 99% | 7.75% |
| 100% | 8.50% |
| There is 0% Ao profit fee paid to contractor below 85% AND they are INELIGIBLE for cost profit fee payments that month | |
| Target Availability is 96% |
Fee (as % of CLIN 2001)
Fee 0.9 0.91 0.92 0.93 0.94 0.95 0.96 0.97 0.98 0.99 1 0 0 0 0 0.03 4.2500000000000003E-2 5.5E-2 6.25E-2 7.0000000000000007E-2 7.7499999999999999E-2 8.5000000000000006E-2 System Availability percentage
Availability Yr 4
| Ao | Fee |
| 90% | 0.00% |
| 91% | 0.00% |
| 92% | 0.00% |
| 93% | 0.00% |
| 94% | 3.00% |
| 95% | 4.25% |
| 96% | 5.50% |
| 97% | 6.25% |
| 98% | 7.00% |
| 99% | 7.75% |
| 100% | 8.50% |
| There is 0% Ao profit fee paid to contractor below 85% AND they are INELIGIBLE for cost profit fee payments that month | |
| Target Availability is 96% |
Fee (as % of CLIN 3001)
Fee 0.9 0.91 0.92 0.93 0.94 0.95 0.96 0.97 0.98 0.99 1 0 0 0 0 0.03 4.2500000000000003E-2 5.5E-2 6.25E-2 7.0000000000000007E-2 7.7499999999999999E-2 8.5000000000000006E-2 System Availability percentage
Availability Yr 5
| Ao | Fee |
| 90% | 0.00% |
| 91% | 0.00% |
| 92% | 0.00% |
| 93% | 0.00% |
| 94% | 3.00% |
| 95% | 4.25% |
| 96% | 5.50% |
| 97% | 6.25% |
| 98% | 7.00% |
| 99% | 7.75% |
| 100% | 8.50% |
| There is 0% Ao profit fee paid to contractor below 85% AND they are INELIGIBLE for cost profit fee payments that month | |
| Target Availability is 96% |
Fee (as % of CLIN 4001
Fee 0.9 0.91 0.92 0.93 0.94 0.95 0.96 0.97 0.98 0.99 1 0 0 0 0 0.03 4.2500000000000003E-2 5.5E-2 6.25E-2 7.0000000000000007E-2 7.7499999999999999E-2 8.5000000000000006E-2 System Availability percentage
File details come from the government source that posted it. Updated .