UDOT Contract Modification Rate Expiration Template 2.8.23.xlsx

	A	B	C	D	E
1
2	UDOT Contract Modification Rate Expiration Template

3					For CPFF contracts executed with an Impacted Rate
4	Date Modification Requested by Firm
5	Consultant Name
6	Prime or Subconsultant on Contract
7	Contract Number
8	PIN Number
9	Estimated Mod NTP Date
10	Impacted ICR - Effective Date			Impacted ICR - Expiration Date
11	Fiscal Year-End of Impacted Rate
12	Unimpacted ICR
13	Impacted ICR
14	Fixed Fee Rate
15
16	Remaining Contract Costs	Unimpacted ICR	Impacted ICR	Other Direct Cost (ODC) OH & FF Debit Adjustments
17				Other Direct Cost (ODC) OH & FF Debit Adjustments
18	Remaining Raw Labor Amount			0.00	N/A
19	Remaining Overhead Amount	0.00	0.00	0.00	OH Debit Adjustment
20	Remaining Fixed Fee	0.00	0.00	0.00	FF Debit Adjustment
21	Remaining Other Direct Costs (ODC)			0.00	N/A
22	Remaining Subconsultant(s) Amount			0.00	N/A
23	Totals	0.00	0.00	0.00	Total Contract Modification Debit Amount
24
25	General Instruction:
26	1. This template is to be submitted one month prior to the end of a prime or its subconsultant(s) Recovery Period to allow adjustment to the maximum-not-to-exceed contract amount based upon the difference between overhead and fixed fee at the impacted and unimpacted rates.
27	2. The consultant will need to calculate the amount of unperformed labor hours/cost remaining in the contract after the expiration of the Recovery Period.
28	3. This template is also to be used for any and all modifications where labor hours are increased for an affected firm that has already reached Recovery.
29	4. All fields with blue shading must be completed by the consultant, and the consultant must verify that the calculations and Total Contract Modification Debit Amount appears correct prior to submission.
30	5. Prime consultants will remit the template to the UDOT Project Manager, and subconsultants will remit the template to the prime consultant.
31	6. A consultant will NOT be able to submit invoices that include OH & FF Debit Adjustments until this template is submitted and the modification is executed. If the modification is submitted after the Recovery Period Expiration Date, the affected consultant may calculate the total Contract Modification Debit Amount (Mod template total amount) back to the date of the expired recovery period.
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100