Actual and Projected Costs. Credit Period: On October 23, 2017, XXXXX submitted a credit request totaling $597.062.03 for the State’s review and approval. A detailed statement of actual costs and a signed invoice were provided in the October 2017 TRLIA credit request. This initial request covered costs incurred through August 2017. A supplemental request was submitted on March 31, 2018 covering costs after the initial credit request to October 3, 2017. The State’s share was Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. Table 9-1. TRLIA - 200-Year Goldfields Levee Project Prior Quarter Actual Cost Comparison and True-Up Element Description State Cost Share A Previosly Projected Costs [1] B Actual Costs for Quarter 7 [2] C Difference between QTR and Actual D = B -C Actual State Cost Share E = C x A Retention on Actual State Cost Share (10%) F = E x 10% Payment By State G = E - F Local Creditable Cost Share H = C x (1 - A) Total Use of Credit Amount 10. Payment Requested and State Disbursements Table 10-1 shows the Next Quarter’s projected costs and associated advance request net of any true-up against prior advances and Right of Way capital projections. (Note – any prior advance funds not expended are netted from this request). [Note – this Table is not applicable as no advance is requested with this Quarter 8 report]. Table 10-2 provides the detail of any excess funding (or funding due) shown on Table 10-1. Excess funding (or funding due) is determined based on the State’s share of the prior Advance Payments as compared to the State’s Share of expenses (net of retention) documented within TRLIA’s Statement of Costs. Table 10-3 shows the remaining State budget after prior State payments (both State Share and Local Credit) as well as the projected remaining budget after the payment request shown on Table 10-1. Table 10-4 shows a ledger of payments made to date, their use (either Local Credit or State Share Advance or True-Up) and the remaining grant balance. Table 10-2. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding True Up Costs True Up Cost Total True Up State Share of Retention on State Share of True Up Costs State Share of True Up Costs to be Immediately Payments Element Description QTR 7 [1] QTR 1-6 [2] Costs True Up Costs (10%) Funded Received [3] True Up Funding A B C = A + B D = 0.85 * C E = D x 10% F = D - E G H = F - G Table 10-1. TRLIA - 200-Year Goldfields Levee Project: Summary of Payment Request and Comparison to State Share Budget Prior State Element Payments (Advances and Description True Ups) [1] State Share Budget Remaining State Share Budget Pending Advanced Request [2] State Share of Projection Quarter 10 Remaining State Share Budget A B C = B - A D E F = C - D Total Payment Report Request Date Payment Type Receipt Date Credit Portion State Portion Amount Notes
Appears in 1 contract
Actual and Projected Costs. Credit Period: Period (Update): On October 23, 2017, XXXXX TRLIA submitted a credit request totaling $597.062.03 an Initial Credit Request for the State’s review and approval. A detailed statement of actual costs and a signed invoice were provided in the October 2017 TRLIA credit request. This initial request covered costs incurred through August 2017. On February 14, 2018 DWR approved the initial request in the State’s share of $575,807.83. A supplemental request was submitted on March 31, 2018 has been prepared covering costs cost incurred after the initial credit request to October 3, 2017. The Total Expenses associated with the supplemental request is $688,476.32 and the State’s share was is $585,204.87. On June 20, 2018 TRLIA submitted a revised supplemental credit request adjusting ENGEO’s reimbursable expenses markup from 20% down to 5%. The State’s share of the supplemental request is $561,909.92. Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. Table 9-1. TRLIA - 200-Year Goldfields Levee Project Prior Quarter Actual Cost Comparison and True-Up Element Description State Cost Share A Previosly Projected Costs [1] B Actual Costs for Quarter 7 [2] C Difference between QTR and Actual D = B -C 1 Actual State Cost Share E = C x A Retention on Actual State Cost Share (10%) F = E x 10% Payment By State G = E - F Local Creditable Cost Share H = C x (1 - A) Total Use of Credit Description Amount 10. Payment Requested and State Disbursements Table 10-1 shows the Next Quarter’s projected costs and associated advance request net of any relative to the true-up against from prior advances and Right of Way capital projections. (Note – any prior advance funds not expended are netted from this request). [Note – this Table is not applicable as no advance is requested with this Quarter 8 report]advances. Table 10-2 provides the detail of any the excess funding (or funding due) shown on Table 10-1. Excess funding (or funding due) is was determined based on the 90% of the State’s share of the prior Quarters 1 & 2 Advance Payments as compared to the State’s Share of expenses (net of Payment less Quarter 1 State share True-up less retention) documented within TRLIA’s Statement of Costs. Table 10-3 shows the remaining State state budget after prior State payments (both State Share and Local Credit) as well as the projected remaining budget after the payment request requests shown on Table 10-1. Table 10-4 shows a ledger of payments made to date, their use (either Local Credit or State Share Advance or True-Up) date and the remaining grant balance. Table 10-21. TRLIA - TRLIA- 200-Year Goldfields Levee Project: True-Up Funding True Up Costs True Up Cost Total True Up State Share of Retention on State Share of True Up Costs State Share of True Up Costs to be Immediately Payments Advance Request Element Description QTR 7 Projected Costs [1] QTR 1-6 State Share 85% Advance State Share Funding Requested less Excess Funding from Prior Advances [2] Costs True Up Costs (10%) Funded Received [3] True Up Funding Remaining Advanced Request A B C = A + B * 90% D = 0.85 * C E = C + D x 10% F Total $1,666,993 $1,416,944 $1,275,250 ($786,047) $489,202 Advance Element Description True‐Up Costs (State Share) Witheld Retention Payments Received True‐Up Funding (Excess) A B C C = D - E G H = F - G A ‐ C ‐ B Total $294,880 $29,488 $1,051,439 ($786,047) Table 10-13. TRLIA - TRLIA- 200-Year Goldfields Levee Project: Summary of Budget and Payment Request and Comparison to State Share Budget Reconciliation Element Description Prior State Element Payments (Advances and Description True Ups) [1] State Share Budget Remaining Budget (Prior State Share Budget Pending Payments) Advanced Request [2] State Share of Projection Quarter 10 Quarters 2 & 3 Remaining State Share Budget A B C = B - A C=B‐A D E F = C - D E=B‐A‐D Total Payment $1,051,439 $32,600,000 $31,548,561 $489,202 $31,059,359 Xxxxx Xxxxxx Remaining $31,548,561 11. Tracking Tables and Deliverables Table 11.1. Earned Value Report Request Date Payment Type Receipt Date Credit Portion State Portion Amount Notesby Element
Appears in 1 contract
Samples: Funding Agreement
Actual and Projected Costs. Credit Period: On October 23, 2017, XXXXX submitted a credit request totaling $597.062.03 for the State’s review and approval. A detailed statement of actual costs and a signed invoice were provided in the October 2017 TRLIA credit request. This initial request covered costs incurred through August 2017. A supplemental request was submitted on March 31, 2018 covering costs after the initial credit request to October 3, 2017. The State’s share was Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. Table 9-1. TRLIA - 200-Year Goldfields Levee Project Prior Quarter Actual Cost Comparison and True-Up Element Description State Cost Share A Previosly Projected Costs [1] B Actual Costs for Quarter 7 [2] C Difference between QTR and Actual D = B -C Quarters 1 & 2 Actual State Cost Share E = C x A Retention on Actual State Cost Share (10%) F = E x 10% Payment By State G = E - F Local Creditable Cost Share H = C x (1 - A) Total Use of Credit Description Amount 10. Payment Requested and State Disbursements Table 10-1 shows the Next Quarter’s projected costs and associated advance request net of any relative to the true-up against from prior advances and Right of Way capital projections. (Note – any prior advance funds not expended are netted from this request). [Note – this Table is not applicable as no advance is requested with this Quarter 8 report]advances. Table 10-2 provides the detail of any the excess funding (or funding due) shown on Table 10-1. Excess funding (or funding due) is was determined based on the 90% of the State’s share of the prior Quarters 1 & 2 Advance Payments as compared to the State’s Share of expenses (net of Payment less Quarter 1 & 2 combined State share True-up less retention) documented within TRLIA’s Statement of Costs. Table 10-3 shows the remaining State state budget after prior State payments (both State Share and Local Credit) as well as the projected remaining budget after the payment request requests shown on Table 10-1. Table 10-4 shows a ledger of payments made to date, their use (either Local Credit or State Share Advance or True-Up) date and the remaining grant balance. Total $1,266,202 $1,076,272 $968,645 ($294,222) $674,423 Table 10-2. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding True Up Costs True Up Cost Total True Up State Share of Retention on State Share of True Up Costs State Share of True Up Costs to be Immediately Payments Advance Element Description QTR 7 True‐Up Costs (State Share) Witheld Retention Payments Received True‐Up Funding (Excess) A [1] QTR 1-6 [2] Costs True Up Costs (10%) Funded Received [3] True Up Funding A B B C = A + ‐ B D = 0.85 * C E = D x 10% F = D - E G H = F - G Total $841,352 $84,135 $1,051,439 ($294,222) Table 10-13. TRLIA - 200-Year Goldfields Levee Project: Summary of Payment Request and Comparison to State Share Budget Element Description Prior State Element Payments (Advances and Description True Ups) [1] State Share Budget Remaining Budget (Prior State Share Budget Pending Payments) Advanced Request [2] State Share of Projection Quarter 10 Quarters 2 & 3 Remaining State Share Budget A B C = B - A C=B‐A D E F = C - D E=B‐A‐D Total Payment $1,051,439 $32,600,000 $31,548,561 $674,423 $30,874,138 Xxxxx Xxxxxx Remaining $31,548,561 11. Tracking Tables and Deliverables Table 11.1. Earned Value Report Request Date Payment Type Receipt Date Credit Portion State Portion Amount Notesby Element
Appears in 1 contract
Samples: Funding Agreement
Actual and Projected Costs. Credit Period: On October 23, 2017, XXXXX submitted a credit request totaling $597.062.03 for the State’s review and approval. A detailed statement of actual costs and a signed invoice were provided in the October 2017 TRLIA credit request. This initial request covered costs incurred through August 2017. A supplemental request was submitted on March 31, 2018 covering costs after the initial credit request to October 3, 2017. The State’s share was Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. Table 9-1. TRLIA - 200-Year Goldfields Levee Project Prior Quarter Actual Cost Comparison and True-Up Element Description State Cost Share A Previosly Projected Costs [1] B Actual Costs for Quarter 7 6 [2] C Difference between QTR and Actual D = B -C Actual State Cost Share E = C x A Retention on Actual State Cost Share (10%) Payment By State Local Creditable Cost Share A B C D = B ‐C E = C x A F = E x 10% Payment By State G = E - ‐ F Local Creditable Cost Share H = C x (1 - ‐ A) Total Use of Credit Amount 10. Payment Requested and State Disbursements Table 10-1 shows the Next Quarter’s projected costs and associated advance request net of any true-up against prior advances and Right of Way capital projections. (Note – any prior advance funds not expended are netted from this request). [Note – this Table is not applicable as no advance is requested with this Quarter 8 report]. Table 10-2 provides the detail of any excess funding (or funding due) shown on Table 10-1. Excess funding (or funding due) is determined based on the State’s share of the prior Advance Payments as compared to the State’s Share of expenses (net of retention) documented within TRLIA’s Statement of Costs. Table 10-3 shows the remaining State budget after prior State payments (both State Share and Local Credit) as well as the projected remaining budget after the payment request shown on Table 10-1. Table 10-4 shows a ledger of payments made to date, their use (either Local Credit or State Share Advance or True-Up) and the remaining grant balance. Table 10-21. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding True Up Costs True Up Cost Total True Up State Share of Retention on State Share of True Up Costs State Share of True Up Costs to be Immediately Payments Element Description QTR 7 6 [1] QTR 1-6 1‐5 [2] Costs True Up Costs (10%) Funded Received [3] True Up Funding A B C = A + B D = 0.85 * C E = D x 10% F = D - ‐ E G H = F - ‐ G Table 10-12. TRLIA - 200-Year Goldfields Levee Project: Summary of Payment Request and Comparison to State Share Budget Prior State Element Description Payments (Advances and Description True Ups) [1] State Share Budget Remaining State Share Budget Pending Advanced Request [2] State Share of Projection Quarter 10 9 Remaining State Share Budget A B C = B - ‐ A D E F = C ‐ D Table 10-3. TRLIA - D 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Total Payment Report Request Date Payment Type Receipt Date Credit Portion State Portion Amount Notes
Appears in 1 contract
Actual and Projected Costs. Credit Period: On October 23, 2017, XXXXX submitted a credit request totaling $597.062.03 for the State’s review and approval. A detailed statement of actual costs and a signed invoice were provided in the October 2017 TRLIA credit request. This initial request covered costs incurred through August 2017. A supplemental request was submitted on March 31, 2018 covering costs after the initial credit request to October 3, 2017. The State’s share was Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. Table 9-1. TRLIA - 200-Year Goldfields Levee Project Prior Quarter Actual Cost Comparison and True-Up Element Description State Cost Share A Previosly Previously Projected Costs [1] B Actual Costs for the Quarter 7 [2] C Difference between QTR and Actual D = B -C Actual State Cost Share E = C x A Retention on Actual State Cost Share (10%) F = E x 10% Payment By State G = E - F Local Creditable Cost Share H = C x (1 - A) Description Amount Total Use of Credit Amount for Local Share this quarter $115,595 Total Use of Credit 10. Payment Requested and State Disbursements Table 10-1 shows the Next Quarter’s projected costs and associated advance request net of any the true-up against for prior advances and Right of Way capital projections. (Note – any prior advance funds not expended are netted from this request). [Note – this Table is not applicable as no advance is requested with this Quarter 8 report]advances. Table 10-2 provides the detail of any the excess funding (or funding due) shown on Table 10-1. Excess funding (or funding due) is was determined based on the State’s share of the prior Quarters 1 & 2 Advance Payments as compared to the State’s Share of expenses (Payment less Quarter 1 & 2 combined State share True-ups net of retention) documented within TRLIA’s Statement of Costs. Table 10-3 shows the remaining State budget after prior State payments (both State Share and Local Credit) as well as the projected remaining budget after the payment request shown on Table 10-1. Table 10-4 shows a ledger of payments made to date, their use (either Local Credit or State Share Advance or True-Up) date and the remaining grant balance. Table 10-1. TRLIA - 200-Year Goldfields Levee Project: 5th and 6th Quarter Projected Cost Element Description Projected Costs [1] State Share 85% Advance State Share Funding Requested less Excess Funding from Prior Advances [2] Remaining Advanced Request A B C = B * 90% D E = C + D Total $770,634 $655,039 $589,535 ($492,895) $96,639 Table 10-2. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding True Quarter 3 (to date) Advance Element Description True-Up Costs True (State Share) Witheld Retention Payments Received True-Up Cost Total True Up State Share of Retention on State Share of True Up Costs State Share of True Up Costs to be Immediately Payments Element Description QTR 7 Funding (excess) A [1] QTR 1-6 B C [2] Costs True Up Costs (10%) Funded Received [3] True Up Funding A B C D = A + - B D = 0.85 * - C E = D x 10% F = D - E G H = F - G Total $528,610 $52,861 $968,645 ($492,895) Table 10-13. TRLIA - 200-Year Goldfields Levee Project: Summary of Payment Request and Comparison to State Share Budget Element Description Prior State Element Payments (Advances and Description True Ups) [1] State Share Budget Remaining Budget (Prior State Share Budget Pending Payments) Advanced Request [2] State Share of Projection Quarter 10 Quarters 5 & 6 Remaining State Share Budget A B C = B - C=B-A D E F = C - E=B-A-D Total $2,215,064 $32,600,000 $30,384,936 $96,639 $30,288,296 Report Justifying Payment Report Payment Request Date Payment Type Payment Receipt Date Credit Portion State Portion Total Payment Amount NotesNotes Xxxxx Xxxxxx Remaining $8,311,162 $30,384,936 $38,696,098 11. Tracking Tables and Deliverables Table 11.1. Earned Value Report by Element
Appears in 1 contract