The file's text, extracted by GovTribe without its formatting.
Attachment I
| ATTACHMENT I_REV01 CHANGE ORDER MARKUP RATES/EXTENDED OVERHEAD | |
| | Fill In Yellow Items Only |
| 1 | Attachment H CLIN 0001 PRICE | |
(This price shall match the proposed CLIN 0001 Price from Attachment H Schedule of Prices)
| | P-834 Maximum Funding Limitation | $98,880,000 |
| 2 | HYPOTHETICAL CHANGE ORDER AMOUNT (PRIME) | |
| (This change order amount is hypothetical and shall be used only in the total evaluated price for the purpose of establishing basic contract HOOH and Subcontractor Overhead Rates. All other allowable rates will be negotiated post award as needed.) The hypothetical change represents a 2% change for prime contractor work using the maximum funding limitation as the base contract value. | $1,977,600.00 | | |
| 3 | HYPOTHETICAL CHANGE ORDER AMOUNT (SUB) |
| (This change order amount is hypothetical and shall be used only in the total evaluated price for the purpose of establishing basic contract HOOH and Subcontractor Overhead Rates. All other allowable rates will be negotiated post award as needed.) The hypothetical change represents a 3% change for subcontractor work using the maximum funding limitation as the base contract value. | $2,966,400.00 | |
| 4 | PRIME CONTRACTOR WORK: |
| | Proposed field office overhead rate |
| (NAVFAC Standard Rate = 10%) | (Negotiated Post Award)% | |
| | SUB-CONTRACTORS WORK: |
| 5 | Proposed field office overhead rate |
| (NAVFAC Standard Rate = 10%) | (Negotiated Post Award)% | |
6 Proposed Profit (Negotiated Post Award)%
| SUMMARY: |
| 7 | Proposed overhead rate on subcontractors |
(NAVFAC Standard Rate = 5%)
| 8 | Subcontractor's Markup (Line 3 x Line 7) | $0.00 |
| 9 | SubTotal - Subcontractor = Line 3 + (Line 3 x Line 7) | $2,966,400.00 |
| 10 | Proposed prime contractor home office overhead rate (NAVFAC Standard Rate = 3%) | |
| 11 | HOOH Markup (Line 2 x Line 10) | $0.00 |
| 12 | SubTotal - Prime = Line 2 + (Line 2 x Line 10) | $1,977,600.00 |
| 13 | Proposed profit | (Negotiated Post Award)% |
| 14 | Total Change Order Markup Rates Amount (Line 9 + Line 12) | $4,944,000.00 |
| 15 | CLIN 0001 EVALUATED PRICE = Line 1 + Line 14 | $4,944,000.00 |
N44255-19-R-0002 ATTACHMENT I_Rev01
Attachment I Sample
| | ATTACHMENT I_REV01 - CHANGE ORDER MARKUP RATES/EXTENDED OVERHEAD | | The spreadsheet will calculate the evaluated price for CLIN 0001 automatically. The Offeror only needs to fill out the yellow cells for the CLIN 0001 amount, subcontractor markup, and HOOH. The remaining values are pre-populated and represent the hypothetical contract change identified in the Price factor. |
| | SAMPLE | Fill In Yellow Items Only | |
| 1 | Attachment H CLIN 0001 PRICE | | |
| (This price shall match the proposed CLIN 0001 Price from Attachment F Schedule of Prices) | $25,000,000.00 | Offeror Proposes $25,000,000 for CLIN 0001 | | |
| | P-834 Maximum Funding Limitation | $98,880,000 | |
| 2 | HYPOTHETICAL CHANGE ORDER AMOUNT (PRIME) | | |
| (This change order amount is hypothetical and shall be used only in the total evaluated price for the purpose of establishing basic contract HOOH and Subcontractor Overhead Rates. All other allowable rates will be negotiated post award as needed.) The hypothetical change represents a 2% change for prime contractor work using the maximum funding limitation as the base contract value. | $1,977,600.00 | | | |
| 3 | HYPOTHETICAL CHANGE ORDER AMOUNT (SUB) |
| (This change order amount is hypothetical and shall be used only in the total evaluated price for the purpose of establishing basic contract HOOH and Subcontractor Overhead Rates. All other allowable rates will be negotiated post award as needed.) The hypothetical change represents a 3% change for subcontractor work using the maximum funding limitation as the base contract value. | $2,966,400.00 | |
| 4 | PRIME CONTRACTOR WORK: |
| | Proposed field office overhead rate |
| (NAVFAC Standard Rate = 10%) | (Negotiated Post Award)% | |
| | SUB-CONTRACTORS WORK: |
| 5 | Proposed field office overhead rate |
| (NAVFAC Standard Rate = 10%) | (Negotiated Post Award)% | |
6 Proposed Profit (Negotiated Post Award)%
| | SUMMARY: | |
| 7 | Proposed overhead rate on subcontractors | |
| (NAVFAC Standard Rate = 5%) | 5.00% | Offeror Proposes 5% for overhead on subcontractors | |
| 8 | Subcontractor's Markup (Line 3 x Line 7) | $148,320.00 |
| 9 | SubTotal - Subcontractor = Line 3 + (Line 3 x Line 7) | $3,114,720.00 |
| 10 | Proposed prime contractor home office overhead rate (NAVFAC Standard Rate = 3%) | 3.00% | Offeror proposes 3% for HOOH |
| 11 | HOOH Markup (Line 2 x Line 10) | $59,328.00 | |
| 12 | SubTotal - Prime = Line 2 + (Line 2 x Line 10) | $2,036,928.00 | |
| 13 | Proposed profit | (Negotiated Post Award)% | |
| 14 | Total Change Order Markup Rates Amount (Line 9 + Line 12) | $5,151,648.00 | Total amount for the hypothetical modification is calculated in line 14. |
| 15 | CLIN 0001 EVALUATED PRICE = Line 1 + Line 14 | $30,151,648.00 | Evaluated price for CLIN 0001 is the CLIN 0001 proposed price plus the total of the hypothetical modification (line 14). |
| | | This amount gets entered in Cell D5 of Attachment F Schedule of Prices |
N44255-17-R-8002
ATTACHMENT G
