Section_J_-_Attachment_14A_B_C_Contract_Totals_Tables.xls
XLS spreadsheet 80 KB Posted
- Attached to
- TECHNOLOGY INSERTION HARDWARE (TIH 16/18) Federal contract opportunity
- Solicitation number
- N0025313R0013
About this file
TIH 16/18 Attachment 14 - Contracts Totals Tables
View the file
Other files for this federal contract opportunity
Show all 19
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
Worksheet 14A
| Composite Rate (CR) Calculation for CLINs 1002, 2002, and 2009. Complete as specified. | |||||||
| Steps: | 1st Year of Performance | 2nd Year of Performance | 3rd Year of Performance | 4th Year of Performance | 5th Year of Performance | 6th Year of Performance | 7th Year of Performance |
| Government provided hours estimate as applicable to Sample Task 1, 2, 3, and 4 (Note a). | 19,040 | 34,500 | 59,830 | 34,500 | 40,790 | Not applicable to Sample Task | Not applicable to Sample Task |
| 1a) If Offeror proposes different hours, insert here (Note b). | NA | NA | |||||
| 1b) Target Cost from Attachment 12A | NA | NA | |||||
| 1c) Cost of Money (COM) from Attachment 12A | NA | NA | |||||
| 1d) Composite Rate Calculation--Part 1: Target Cost from Attachment 12A less Cost Of Money divided by hours. |
| If proposed hours (step 1a) are different than Government provided hours, divide by the proposed hours. | (Value from 1b - Value from 1c) / # of hours | (Value from 1b - Value from 1c) / # of hours | (Value from 1b - Value from 1c) / # of hours | (Value from 1b - Value from 1c) / # of hours | (Value from 1b - Value from 1c) / # of hours | Escalate based on Year 5 | Escalate based on Year 5 | |
| 1e) Fill in rate based on calculations specified in step 1d). | ||||||||
| 1f) Multiply rate (step 1e) by Target Fee percentage proposed in Attachment 12A. | Value from 1e * Target Fee % | Value from 1e * Target Fee % | Value from 1e * Target Fee % | Value from 1e * Target Fee % | Value from 1e * Target Fee % | Value from 1e * Target Fee % | Value from 1e * Target Fee % | |
| 1g) Fill-in Target Fee Hourly Rate Amount based on calculations specified in step 1f. | ||||||||
| 1h) Composite Rate Calculation--Part 2: Cost of Money divided by hours | Value from 1c / # of hours | Value from 1c / # of hours | Value from 1c / # of hours | Value from 1c / # of hours | Value from 1c / # of hours | Escalate based on Year 5 | Escalate based on Year 5 | |
| 1i) Fill in rate based on calculations specified in step 1h | ||||||||
| 1j) Calculate total composite rate (Sum values from 1e and 1i) | Value from 1e + Value from 1i | Value from 1e + Value from 1i | Value from 1e + Value from 1i | Value from 1e + Value from 1i | Value from 1e + Value from 1i | Value from 1e + Value from 1i | Value from 1e + Value from 1i | |
| 1k) Fill in rate based on calculations specified in step 1j. This should match the composite rate entered in Section B. | ||||||||
| 1l) Calculate Fee-Burdened Composite Rate (Sum values from 1g and 1k) | Value from 1g + Value from 1k | Value from 1g + Value from 1k | Value from 1g + Value from 1k | Value from 1g + Value from 1k | Value from 1g + Value from 1k | Value from 1g + Value from 1k | Value from 1g + Value from 1k | |
| 1m) Fill in Fee Burdened Composite Rate based on calculations specified in step 1j (this will be used for evaluation purposes only in generating GTEC) | ||||||||
| Notes: |
(a) These hours do not equal the max ceiling hours, but are representative of the effort involved for the sample task.
(b) The Government-provided estimate of hours for the sample task assumes a second TI cycle will kick-off in the third year of performance, just as TI-18 will kick-off two years after TI-16. If the Offeror proposes a quantity of hours different from the Government-provided hours, the Offeror must also assume a second TI cycle to begin in Year 3.
&CSection J - Attachment 14A TIH 16/18 Contract Totals Table
&CSOLICITATION NO.
N00253-13-R-0013&R&P
Worksheet 14B
| Cost Per Year of Performance for CLINs 1002, 2002, and 2009. Complete as specified. | ||||||||
| Steps: | CLINS | 1st Year of Performance | 2nd Year of Performance | 3rd Year of Performance | 4th Year of Performance | 5th Year of Performance | 6th Year of Performance | 7th Year of Performance |
| CPIF ceiling hours from Section B. | CLIN 1002 | 57,070 | 105,210 | 30,570 | 1,340 | 1,170 | 0 | 0 |
| CLIN 2002 | 0 | 0 | 60,980 | 98,310 | 57,510 | 2,120 | 2,120 | |
| CLIN 2009 | 0 | 0 | 8,710 | 15,700 | 360 | 360 | 360 | |
| 1a) Fee-Burdened Composite Rate per year of performance. Taken from Attachment 14A, step 1m | ||||||||
| 1b) Calculation: Max ceiling hours multiplied by Fee-Burdened Composite Rate (CR) | CLIN 1002 | 57,070 X CR | 105,210 X CR | 30,570 X CR | 1,340 X CR | 1,170 X CR | NA | NA |
| CLIN 2002 | NA | NA | 60,980 X CR | 98,310 X CR | 57,510 X CR | 2,120 X CR | 2,120 X CR | |
| CLIN 2009 | NA | NA | 8,710 X CR | 15,700 X CR | 360 X CR | 360 X CR | 360 X CR | |
| 1c) Total Cost Per Year of Performance for CLIN 1002, 2002, and 2009. | CLIN 1002 | $ | $ | $ | $ | $ | $0 | $0 |
| CLIN 2002 | $0 | $0 | $ | $ | $ | $ | $ | |
| CLIN 2009 | $0 | $0 | $ | $ | $ | $ | $ |
&CSection J - Attachment 14B TIH 16/18 Contract Totals Table
&CSOLICITATION NO.
N00253-13-R-0013&R&P
Worksheet 14C
| Total Cost for CLINs 1002, 2002, and 2009. Complete as specified. |
| Steps: |
| 1) Sum of the 1st, 2nd, 3rd, 4th, 5th, 6th, and 7th Total Cost Per Year of Performance taken from Attachment 14B, step 1c broken down per CLIN as follows: |
| 1a) CLIN 1002 Estimated Cost. |
| 1c) CLIN 2002 Estimated Cost. |
| 1d) CLIN 2009 Estimated Cost. |
&CSection J - Attachment 14C TIH 16/18 Contract Totals Table
&CSOLICITATION NO.
N00253-13-R-0013&R&P
File details come from the government source that posted it. Updated .