Attch 9 - FPIF Monthly Invoicing Worksheet 20220721.xlsx
XLSX spreadsheet 129 KB Posted
- Attached to
- Joint Navigation Warfare Center (JNWC) IV - DRAFT Request for Proposal Federal contract opportunity
- Solicitation number
- FA2518-22-R-0027
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| DRAFT JNWC IV TO One PWS.pdf | ||
| DRAFT JNWC IV Basic IDIQ Work Statement.pdf | ||
| 0 - DRAFT Request for Proposal FA251822R0027.pdf | ||
| Attch 5 - DRAFT J9 Engineering Support Scenario 20220721.pdf | ||
| Attch 6 - DRAFT Factor 2 Staffing Matrix 20220721.xlsx | XLSX spreadsheet | |
| Attch 7 - DRAFT FPIF CLIN Structure Spreadsheet 20220721.xlsx | XLSX spreadsheet | |
| Attch 8 - Professional Compensation Evaluation Plan Form 20220721.xlsx | XLSX spreadsheet | |
| 0 - DRAFT Request for Proposal FA251822R0027.pdf | ||
| Attch 1 - DRAFT Section L Instructions Conditions Notices to Offerors 20220721.pdf | ||
| Attch 2 - DRAFT Section M Evaluation Factors for Award 20220721.pdf | ||
| Attch 3 - DRAFT J3 Warfighter Support Scenario 20220721.pdf | ||
| Attch 4 - DRAFT J3 Warfighter Support Grading Key 20220721.xlsx | XLSX spreadsheet |
Show all 12
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
IDIQ OP
DRAFT
Joint Navigation Warfare Center (JNWC) IV
RFP: FA2518-22-R-0027
Section J Attachment 9: FPIF Monthly Invoicing Worksheet NOTE: This attachment is for informational purposose ONLY. It is used to identfy how the FPIF will be administered on a monthly basis and is NOT required for proposal submission.
| EXAMPLE: Illistration not meant to be a representation of all Task Oders | |||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
| IDIQ | BASIC ORDERING PERIOD | OPTIONAL ORDER PERIOD |
| TO #1 | |||||
| base period | OY1 | OY2 | OY3 | OY4 |
| TO #2 | |||||
| base period | OY1 | OY2 | OY3 | OY4 |
| 0 | Base +4 |
| 0 | Monthly |
Instructions
Will be completed prior to final RFP release
Cumulative Annual Summary
RWW FPIF with: Target Cost $700,000; Target Profit $70,000; Target Price $770,000; Ceiling Price $840,000. Share 50/50 Under & 50/50 Over.
| Target Cost | $ 700,000 | |
| Target Profit %/$ | 10.00% | $ 70,000 |
| Target Price | $ 770,000 | |
| Ceiling %/$ | 120.00% | $ 840,000 |
| Assigned Shares | ||||||
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |||
| Under Target | 50.0% | / | 50.0% | |||
| Over Target | 50.0% | / | 50.0% |
| Calculated Shares | ||
| Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared. | Cost | Profit |
| Optimistic |
DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.
Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |
| Under Target | / | |||
| Over Target | / |
Point of Total Assumption (PTA) $ 840,000
Final Actual Audited Allowable Cost: $ 696,500
Final Contract Price: $ 768,250
Final Contractor Profit (Loss): $ 71,750
Final Contractor Profit (Loss) %: 10.30%
Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.
| Govt | /Ktr | |||||||
| 50% | 50% | Under | 50 | 50 | 50/50 Under | |||
| 50% | 50% | Over | 50 | 50 | 50/50 Over | |||
| Under Target | Target-PTA | Ceiling | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Cost | Profit | |||
| left Scaler | $ 700,000 | $ 70,000 | $ 700,000 | $ 70,000 | $ 840,000 | $ - 0 | ||
| 2 | $ 420,000 | $ 210,000 | $ 840,000 | $ - 0 | right scaler | $ 840,000 | 0 | |
| 1 | $ 980,000 | $ (140,000) | ||||||
| $ 980,000 | $ (140,000) | |||||||
| Final Cost - Profit (Loss) | Final Price horizontal | Dollar Text | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Target Cost | $700,000 | |||
| $ 696,500 | $ 71,750 | 0 | $ 71,750 | Target Profit | $70,000 | |||
| $ 696,500 | 0 | $ 696,500 | $ 71,750 | Target Price | $770,000 | |||
| Ceiling Price | $840,000 |
Target-PTA
| 700000 | 840000 | 70000 | 0 | Ceiling | |||||||||
| 840000 | 840000 | 980000 | 980000 | 0 | 0 | -140000 | -140000 | Under Target | 700000 | 420000 | 70000 | 210000 | Final Cost - Profit (Loss) |
| 696500 | 696500 | 71750 | 0 | Final Price horizontal | |||||||||
| 0 | 696500 | 71750 | 71750 | Analyst Notes |
Annual Math
RWW FPIF with: Target Cost $700,000; Target Profit $70,000; Target Price $770,000; Ceiling Price $840,000. Share 50/50 Under & 50/50 Over.
| Target Cost | $ 700,000 | |
| Target Profit %/$ | 10.00% | $ 70,000 |
| Target Price | $ 770,000 | |
| Ceiling %/$ | 120.00% | $ 840,000 |
| Assigned Shares | ||||||
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |||
| Under Target | 50.0% | / | 50.0% | |||
| Over Target | 50.0% | / | 50.0% |
| Calculated Shares | ||
| Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared. | Cost | Profit |
| Optimistic |
DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.
Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |
| Under Target | / | |||
| Over Target | / |
Point of Total Assumption (PTA) $ 840,000
Final Actual Audited Allowable Cost: $ 696,500
Final Contract Price: $ 768,250
Final Contractor Profit (Loss): $ 71,750
Final Contractor Profit (Loss) %: 10.30%
Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.
| Govt | /Ktr | |||||||
| 50% | 50% | Under | 50 | 50 | 50/50 Under | |||
| 50% | 50% | Over | 50 | 50 | 50/50 Over | |||
| Under Target | Target-PTA | Ceiling | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Cost | Profit | |||
| left Scaler | $ 700,000 | $ 70,000 | $ 700,000 | $ 70,000 | $ 840,000 | $ - 0 | ||
| 2 | $ 420,000 | $ 210,000 | $ 840,000 | $ - 0 | right scaler | $ 840,000 | 0 | |
| 1 | $ 980,000 | $ (140,000) | ||||||
| $ 980,000 | $ (140,000) | |||||||
| Final Cost - Profit (Loss) | Final Price horizontal | Dollar Text | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Target Cost | $700,000 | |||
| $ 696,500 | $ 71,750 | 0 | $ 71,750 | Target Profit | $70,000 | |||
| $ 696,500 | 0 | $ 696,500 | $ 71,750 | Target Price | $770,000 | |||
| Ceiling Price | $840,000 |
Target-PTA
| 700000 | 840000 | 70000 | 0 | Ceiling | |||||||||
| 840000 | 840000 | 980000 | 980000 | 0 | 0 | -140000 | -140000 | Under Target | 700000 | 420000 | 70000 | 210000 | Final Cost - Profit (Loss) |
| 696500 | 696500 | 71750 | 0 | Final Price horizontal | |||||||||
| 0 | 696500 | 71750 | 71750 | Analyst Notes |
Base Aug 2023
RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.
| Target Cost | 100,000 | |
| Target Profit %/$ | 10.00% | $ 10,000 |
| Target Price | $ 110,000 | |
| Ceiling %/$ | 120.00% | $ 120,000 |
| Assigned Shares | ||||||
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |||
| Under Target | 50.0% | / | 50.0% | |||
| Over Target | 50.0% | / | 50.0% |
| Calculated Shares | ||
| Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared. | Cost | Profit |
| Optimistic |
DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.
Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |
| Under Target | / | |||
| Over Target | / |
Point of Total Assumption (PTA) $ 120,000
Final Actual Audited Allowable Cost: $ 90,000
Final Contract Price: $ 105,000
Final Contractor Profit (Loss): $ 15,000
Final Contractor Profit (Loss) %: 16.67%
Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encourage to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.
| Govt | /Ktr | |||||||
| 50% | 50% | Under | 50 | 50 | 50/50 Under | |||
| 50% | 50% | Over | 50 | 50 | 50/50 Over | |||
| Under Target | Target-PTA | Ceiling | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Cost | Profit | |||
| left Scaler | $ 100,000 | $ 10,000 | $ 100,000 | $ 10,000 | $ 120,000 | $ - 0 | ||
| 2 | $ 60,000 | $ 30,000 | $ 120,000 | $ - 0 | right scaler | $ 120,000 | 0 | |
| 1 | $ 140,000 | $ (20,000) | ||||||
| $ 140,000 | $ (20,000) | |||||||
| Final Cost - Profit (Loss) | Final Price horizontal | Dollar Text | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Target Cost | $100,000 | |||
| $ 90,000 | $ 15,000 | 0 | $ 15,000 | Target Profit | $10,000 | |||
| $ 90,000 | 0 | $ 90,000 | $ 15,000 | Target Price | $110,000 | |||
| Ceiling Price | $120,000 |
Target-PTA
| 100000 | 120000 | 10000 | 0 | Ceiling | |||||||||
| 120000 | 120000 | 140000 | 140000 | 0 | 0 | -20000 | -20000 | Under Target | 100000 | 60000 | 10000 | 30000 | Final Cost - Profit (Loss) |
| 90000 | 90000 | 15000 | 0 | Final Price horizontal | |||||||||
| 0 | 90000 | 15000 | 15000 | Analyst Notes |
Sep 2023
RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.
| Target Cost | 100,000 | |
| Target Profit %/$ | 10.00% | $ 10,000 |
| Target Price | $ 110,000 | |
| Ceiling %/$ | 120.00% | $ 120,000 |
| Assigned Shares | ||||||
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |||
| Under Target | 50.0% | / | 50.0% | |||
| Over Target | 50.0% | / | 50.0% |
| Calculated Shares | ||
| Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared. | Cost | Profit |
| Optimistic |
DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.
Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |
| Under Target | / | |||
| Over Target | / |
Point of Total Assumption (PTA) $ 120,000
Final Actual Audited Allowable Cost: $ 100,000
Final Contract Price: $ 110,000
Final Contractor Profit (Loss): $ 10,000
Final Contractor Profit (Loss) %: 10.00%
Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.
| Govt | /Ktr | |||||||
| 50% | 50% | Under | 50 | 50 | 50/50 Under | |||
| 50% | 50% | Over | 50 | 50 | 50/50 Over | |||
| Under Target | Target-PTA | Ceiling | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Cost | Profit | |||
| left Scaler | $ 100,000 | $ 10,000 | $ 100,000 | $ 10,000 | $ 120,000 | $ - 0 | ||
| 2 | $ 60,000 | $ 30,000 | $ 120,000 | $ - 0 | right scaler | $ 120,000 | 0 | |
| 1 | $ 140,000 | $ (20,000) | ||||||
| $ 140,000 | $ (20,000) | |||||||
| Final Cost - Profit (Loss) | Final Price horizontal | Dollar Text | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Target Cost | $100,000 | |||
| $ 100,000 | $ 10,000 | 0 | $ 10,000 | Target Profit | $10,000 | |||
| $ 100,000 | 0 | $ 100,000 | $ 10,000 | Target Price | $110,000 | |||
| Ceiling Price | $120,000 |
Target-PTA
| 100000 | 120000 | 10000 | 0 | Ceiling | |||||||||
| 120000 | 120000 | 140000 | 140000 | 0 | 0 | -20000 | -20000 | Under Target | 100000 | 60000 | 10000 | 30000 | Final Cost - Profit (Loss) |
| 100000 | 100000 | 10000 | 0 | Final Price horizontal | |||||||||
| 0 | 100000 | 10000 | 10000 | Analyst Notes |
Oct 2023
RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.
| Target Cost | 100,000 | |
| Target Profit %/$ | 10.00% | $ 10,000 |
| Target Price | $ 110,000 | |
| Ceiling %/$ | 120.00% | $ 120,000 |
| Assigned Shares | ||||||
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |||
| Under Target | 50.0% | / | 50.0% | |||
| Over Target | 50.0% | / | 50.0% |
| Calculated Shares | ||
| Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared. | Cost | Profit |
| Optimistic |
DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.
Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |
| Under Target | / | |||
| Over Target | / |
Point of Total Assumption (PTA) $ 120,000
Final Actual Audited Allowable Cost: $ 104,000
Final Contract Price: $ 112,000
Final Contractor Profit (Loss): $ 8,000
Final Contractor Profit (Loss) %: 7.69%
Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.
| Govt | /Ktr | |||||||
| 50% | 50% | Under | 50 | 50 | 50/50 Under | |||
| 50% | 50% | Over | 50 | 50 | 50/50 Over | |||
| Under Target | Target-PTA | Ceiling | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Cost | Profit | |||
| left Scaler | $ 100,000 | $ 10,000 | $ 100,000 | $ 10,000 | $ 120,000 | $ - 0 | ||
| 2 | $ 60,000 | $ 30,000 | $ 120,000 | $ - 0 | right scaler | $ 120,000 | 0 | |
| 1 | $ 140,000 | $ (20,000) | ||||||
| $ 140,000 | $ (20,000) | |||||||
| Final Cost - Profit (Loss) | Final Price horizontal | Dollar Text | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Target Cost | $100,000 | |||
| $ 104,000 | $ 8,000 | 0 | $ 8,000 | Target Profit | $10,000 | |||
| $ 104,000 | 0 | $ 104,000 | $ 8,000 | Target Price | $110,000 | |||
| Ceiling Price | $120,000 |
Target-PTA
| 100000 | 120000 | 10000 | 0 | Ceiling | |||||||||
| 120000 | 120000 | 140000 | 140000 | 0 | 0 | -20000 | -20000 | Under Target | 100000 | 60000 | 10000 | 30000 | Final Cost - Profit (Loss) |
| 104000 | 104000 | 8000 | 0 | Final Price horizontal | |||||||||
| 0 | 104000 | 8000 | 8000 | Analyst Notes |
Nov 2023
RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.
| Target Cost | 100,000 | |
| Target Profit %/$ | 10.00% | $ 10,000 |
| Target Price | $ 110,000 | |
| Ceiling %/$ | 120.00% | $ 120,000 |
| Assigned Shares | ||||||
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |||
| Under Target | 50.0% | / | 50.0% | |||
| Over Target | 50.0% | / | 50.0% |
| Calculated Shares | ||
| Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared. | Cost | Profit |
| Optimistic |
DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.
Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |
| Under Target | / | |||
| Over Target | / |
Point of Total Assumption (PTA) $ 120,000
Final Actual Audited Allowable Cost: $ 98,000
Final Contract Price: $ 109,000
Final Contractor Profit (Loss): $ 11,000
Final Contractor Profit (Loss) %: 11.22%
Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.
| Govt | /Ktr | |||||||
| 50% | 50% | Under | 50 | 50 | 50/50 Under | |||
| 50% | 50% | Over | 50 | 50 | 50/50 Over | |||
| Under Target | Target-PTA | Ceiling | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Cost | Profit | |||
| left Scaler | $ 100,000 | $ 10,000 | $ 100,000 | $ 10,000 | $ 120,000 | $ - 0 | ||
| 2 | $ 60,000 | $ 30,000 | $ 120,000 | $ - 0 | right scaler | $ 120,000 | 0 | |
| 1 | $ 140,000 | $ (20,000) | ||||||
| $ 140,000 | $ (20,000) | |||||||
| Final Cost - Profit (Loss) | Final Price horizontal | Dollar Text | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Target Cost | $100,000 | |||
| $ 98,000 | $ 11,000 | 0 | $ 11,000 | Target Profit | $10,000 | |||
| $ 98,000 | 0 | $ 98,000 | $ 11,000 | Target Price | $110,000 | |||
| Ceiling Price | $120,000 |
Target-PTA
| 100000 | 120000 | 10000 | 0 | Ceiling | |||||||||
| 120000 | 120000 | 140000 | 140000 | 0 | 0 | -20000 | -20000 | Under Target | 100000 | 60000 | 10000 | 30000 | Final Cost - Profit (Loss) |
| 98000 | 98000 | 11000 | 0 | Final Price horizontal | |||||||||
| 0 | 98000 | 11000 | 11000 | Analyst Notes |
Dec 2023
RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.
| Target Cost | 100,000 | |
| Target Profit %/$ | 10.00% | $ 10,000 |
| Target Price | $ 110,000 | |
| Ceiling %/$ | 120.00% | $ 120,000 |
| Assigned Shares | ||||||
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |||
| Under Target | 50.0% | / | 50.0% | |||
| Over Target | 50.0% | / | 50.0% |
| Calculated Shares | ||
| Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared. | Cost | Profit |
| Optimistic |
DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.
Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |
| Under Target | / | |||
| Over Target | / |
Point of Total Assumption (PTA) $ 120,000
Final Actual Audited Allowable Cost: $ 99,000
Final Contract Price: $ 109,500
Final Contractor Profit (Loss): $ 10,500
Final Contractor Profit (Loss) %: 10.61%
Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.
| Govt | /Ktr | |||||||
| 50% | 50% | Under | 50 | 50 | 50/50 Under | |||
| 50% | 50% | Over | 50 | 50 | 50/50 Over | |||
| Under Target | Target-PTA | Ceiling | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Cost | Profit | |||
| left Scaler | $ 100,000 | $ 10,000 | $ 100,000 | $ 10,000 | $ 120,000 | $ - 0 | ||
| 2 | $ 60,000 | $ 30,000 | $ 120,000 | $ - 0 | right scaler | $ 120,000 | 0 | |
| 1 | $ 140,000 | $ (20,000) | ||||||
| $ 140,000 | $ (20,000) | |||||||
| Final Cost - Profit (Loss) | Final Price horizontal | Dollar Text | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Target Cost | $100,000 | |||
| $ 99,000 | $ 10,500 | 0 | $ 10,500 | Target Profit | $10,000 | |||
| $ 99,000 | 0 | $ 99,000 | $ 10,500 | Target Price | $110,000 | |||
| Ceiling Price | $120,000 |
Target-PTA
| 100000 | 120000 | 10000 | 0 | Ceiling | |||||||||
| 120000 | 120000 | 140000 | 140000 | 0 | 0 | -20000 | -20000 | Under Target | 100000 | 60000 | 10000 | 30000 | Final Cost - Profit (Loss) |
| 99000 | 99000 | 10500 | 0 | Final Price horizontal | |||||||||
| 0 | 99000 | 10500 | 10500 | Analyst Notes |
Jan 2024
RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.
| Target Cost | 100,000 | |
| Target Profit %/$ | 10.00% | $ 10,000 |
| Target Price | $ 110,000 | |
| Ceiling %/$ | 120.00% | $ 120,000 |
| Assigned Shares | ||||||
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |||
| Under Target | 50.0% | / | 50.0% | |||
| Over Target | 50.0% | / | 50.0% |
| Calculated Shares | ||
| Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared. | Cost | Profit |
| Optimistic |
DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.
Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |
| Under Target | / | |||
| Over Target | / |
Point of Total Assumption (PTA) $ 120,000
Final Actual Audited Allowable Cost: $ 102,500
Final Contract Price: $ 111,250
Final Contractor Profit (Loss): $ 8,750
Final Contractor Profit (Loss) %: 8.54%
Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.
| Govt | /Ktr | |||||||
| 50% | 50% | Under | 50 | 50 | 50/50 Under | |||
| 50% | 50% | Over | 50 | 50 | 50/50 Over | |||
| Under Target | Target-PTA | Ceiling | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Cost | Profit | |||
| left Scaler | $ 100,000 | $ 10,000 | $ 100,000 | $ 10,000 | $ 120,000 | $ - 0 | ||
| 2 | $ 60,000 | $ 30,000 | $ 120,000 | $ - 0 | right scaler | $ 120,000 | 0 | |
| 1 | $ 140,000 | $ (20,000) | ||||||
| $ 140,000 | $ (20,000) | |||||||
| Final Cost - Profit (Loss) | Final Price horizontal | Dollar Text | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Target Cost | $100,000 | |||
| $ 102,500 | $ 8,750 | 0 | $ 8,750 | Target Profit | $10,000 | |||
| $ 102,500 | 0 | $ 102,500 | $ 8,750 | Target Price | $110,000 | |||
| Ceiling Price | $120,000 |
Target-PTA
| 100000 | 120000 | 10000 | 0 | Ceiling | |||||||||
| 120000 | 120000 | 140000 | 140000 | 0 | 0 | -20000 | -20000 | Under Target | 100000 | 60000 | 10000 | 30000 | Final Cost - Profit (Loss) |
| 102500 | 102500 | 8750 | 0 | Final Price horizontal | |||||||||
| 0 | 102500 | 8750 | 8750 | Analyst Notes |
Feb 2024
RWW FPIF with: Target Cost $100,000; Target Profit $10,000; Target Price $110,000; Ceiling Price $120,000. Share 50/50 Under & 50/50 Over.
| Target Cost | 100,000 | |
| Target Profit %/$ | 10.00% | $ 10,000 |
| Target Price | $ 110,000 | |
| Ceiling %/$ | 120.00% | $ 120,000 |
| Assigned Shares | ||||||
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |||
| Under Target | 50.0% | / | 50.0% | |||
| Over Target | 50.0% | / | 50.0% |
| Calculated Shares | ||
| Desktop Williams: For calculated shares to be used, any assigned shares above must be cleared. | Cost | Profit |
| Optimistic |
DAU User: Optimistic cost must be less than target cost and optimistic profit must be greater than target profit.
Pessimistic DAU User: Pessimistic cost must be greater than target cost and pessimistic profit must be less than target profit.
| Desktop Williams: Shares assigned here take precedence over calculated shares below using optimistic and pessimistic values. | Govt | / | Ktr | |
| Under Target | / | |||
| Over Target | / |
Point of Total Assumption (PTA) $ 120,000
Final Actual Audited Allowable Cost: $ 103,000
Final Contract Price: $ 111,500
Final Contractor Profit (Loss): $ 8,500
Final Contractor Profit (Loss) %: 8.25%
Example purposes only to show how annual/monthly FPIF math will work. Offerors are highly encouraged to experiment with this spreadsheet to familiarize themselves with how it is anticipated to work.
| Govt | /Ktr | |||||||
| 50% | 50% | Under | 50 | 50 | 50/50 Under | |||
| 50% | 50% | Over | 50 | 50 | 50/50 Over | |||
| Under Target | Target-PTA | Ceiling | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Cost | Profit | |||
| left Scaler | $ 100,000 | $ 10,000 | $ 100,000 | $ 10,000 | $ 120,000 | $ - 0 | ||
| 2 | $ 60,000 | $ 30,000 | $ 120,000 | $ - 0 | right scaler | $ 120,000 | 0 | |
| 1 | $ 140,000 | $ (20,000) | ||||||
| $ 140,000 | $ (20,000) | |||||||
| Final Cost - Profit (Loss) | Final Price horizontal | Dollar Text | ||||||
| Cost | Profit/(Loss) | Cost | Profit/(Loss) | Target Cost | $100,000 | |||
| $ 103,000 | $ 8,500 | 0 | $ 8,500 | Target Profit | $10,000 | |||
| $ 103,000 | 0 | $ 103,000 | $ 8,500 | Target Price | $110,000 | |||
| Ceiling Price | $120,000 |
Target-PTA
| 100000 | 120000 | 10000 | 0 | Ceiling | |||||||||
| 120000 | 120000 | 140000 | 140000 | 0 | 0 | -20000 | -20000 | Under Target | 100000 | 60000 | 10000 | 30000 | Final Cost - Profit (Loss) |
| 103000 | 103000 | 8500 | 0 | Final Price horizontal | |||||||||
| 0 | 103000 | 8500 | 8500 | Analyst Notes |
File details come from the government source that posted it. Updated .