Common use of Actual and Projected Costs Clause in Contracts

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 $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-1 on the following page provides a summary of the previously projected costs for Quarter 6 (January – March 2019) (reference the Quarter 5 report) as compared to the actual Costs for Quarter 6 (refer to SOC included with this report dated September 12, 2019). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 6 (January – March 2019). 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 Previosly Projected Costs [1] Actual Costs for Quarter 6 [2] Difference between QTR and Actual Actual State Cost Share 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% G = E ‐ F H = C x (1 ‐ A) 1 Grant Applicatoin 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ 2 Program Management 85% $ 123,592 $ 114,569 $ 9,023 $ 97,383 $ 9,738 $ 87,645 $ 17,185 3 Design & ROW Support 85% $ 155,252 $ 461,327 $ (306,075) $ 392,128 $ 39,213 $ 352,915 $ 69,199 4 Environmental Review & Permitting 85% $ 75,059 $ 92,474 $ (17,415) $ 78,603 $ 7,860 $ 70,742 $ 13,871 5 ROW Acquisition 85% $ ‐ $ 252,437 $ (252,437) N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ ‐ $ 50,000 $ (50,000) $ 42,500 $ 4,250 $ 38,250 $ 7,500 7 Closeout Process 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 353,903 $ 970,806 $ (616,904) $ 610,614 $ 61,061 $ 549,553 $ 107,755 [1] Projected costs for Quarter 6 (refer to QPR5) [2] Reference SOC dated September 12, 2019 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit Total Use of Credit Amount Initial Starting Credit Request $575,808 Supplemental Credit Request $561,910 Authorized Local Credit by DWR (to date) $1,137,718 less Credit Payments received (Credit Payment No. 1) N/A Quarter 1 local share paid by State $52,037 Quarter 2 local share paid by State $96,436 Quarter 3 local share Paid by State $104,449 Quarter 4 local share Paid by State $121,286 Quarter 5 local share Paid by State $80,551 Pending Quarter 6 local share $107,755 Remaining Authorized Local Credit $575,204 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 7 Report September 12, 2019 This section of the report has been updated to include an accounting of quarterly costs incurred from the prior quarter as documented within the submitted quarterly Statements of Cost and any requested true-up funding. This requested funding is summarized in the following tables listed below. 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 7 report for the 9th quarter]. 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-1. 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 6 [1] QTR 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 1 Grant Applicatoin $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ 2 Program Management $ 114,569 $ 500,930 $ 615,498 $ 523,173 $ 52,317 $ 470,856 $ 468,856 $ 2,000 3 Design & ROW Support $ 461,327 $ 1,992,455 $ 2,453,782 $ 2,085,715 $ 208,571 $ 1,877,143 $ 1,542,708 $ 334,435 4 Environmental Review & Permitting $ 92,474 $ 426,562 $ 519,035 $ 441,180 $ 44,118 $ 397,062 $ 312,446 $ 84,616 5 ROW Acquisition $ 252,437 $ 5,000 $ 257,437 N/A N/A N/A $ ‐ N/A 6 Construction, Mitigation, & Other Project $ 50,000 $ ‐ $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ ‐ $ 38,250 7 Closeout Process $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 970,806 $ 2,924,946 $ 3,895,753 $ 3,092,568 $ 309,257 $ 2,783,312 $ 2,324,010 $ 459,301 [1] Reference Table 9‐1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1‐5 [3} Payments received through March 2019 Table 10-2. TRLIA - 200-Year Goldfields Levee Project: Summary of Payment Request and Comparison to State Share Budget Prior State Element Description Payments (Advances and True Ups) [1] State Share Budget Remaining State Share Budget Pending Advanced Request [2] State Share of Projection Quarter 9 Remaining State Share Budget A B C = B ‐ A D E F = C ‐ D 1 Grant Application $ ‐ $ 21,335 $ 21,335 $ ‐ $ ‐ $ 21,335 2 Program Management $ 704,668 $ 1,912,500 $ 1,207,832 $ ‐ $ ‐ $ 1,207,832 3 Design & ROW Support $ 1,881,554 $ 4,802,500 $ 2,920,946 $ ‐ $ ‐ $ 2,920,946 4 Environmental Review & Permitting $ 538,840 $ 1,105,000 $ 566,160 $ ‐ $ ‐ $ 566,160 5 ROW Acquisition $ ‐ $ 6,098,338 $ 6,098,338 $ ‐ $ ‐ $ 6,098,338 6 Construction, Mitigation, & Other Project $ 5,072,906 $ 31,843,647 $ 26,770,741 $ ‐ $ ‐ $ 26,770,741 7 Closeout Process $ ‐ $ 81,345 $ 81,345 $ ‐ $ ‐ $ 81,345 [1] Includes all State Payments to Date $ 8,197,968 $ 45,864,665 $ 37,666,697 $ ‐ $ ‐ $ 37,666,697 [2] All pending requests Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Payment Payment Total Payment Report Request Date Payment Type Receipt Date Credit Portion State Portion Amount Notes QPR1 2/23/2018 Advance 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 Advance 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True‐Up QPR3 6/12/2018 Advance 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True‐Up QPR4 12/28/2018 Advance 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True‐Up QPR5 1/23/2019 Advance 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True‐Up QPR6 7/1/2019 Advance 8/22/2019 $80,551 $5,310,251 $5,390,802 Q8 Advance, Q5 Local True‐Up QPR7 8/1/2019 Advance In Progress *$107,775 $0 *$107,775 Q9 Advance, Q6 Local True‐Up Cumulative Payments $454,758 $7,743,209 $8,197,967 Total Grant Amount [1] $8,093,765 $45,864,665 $53,958,430 Xxxxx Xxxxxx Remaining $7,639,006 $38,121,456 $45,760,463 * Pending DWR Approval

Appears in 1 contract

Samples: www.trlia.org

AutoNDA by SimpleDocs

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 $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-1 on the following page provides a summary of the previously projected costs for Quarter 6 7 (January April March June 2019) (reference the Quarter 5 6 report) as compared to the actual Costs for Quarter 6 7 (refer to SOC included with this report dated September 12December 20, 2019). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 6 7 (January April March June 2019). Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. TRLIA 200-Year Goldfields Levee Project Quarter 8 Report December 27, 2019 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 6 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%) 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) 1 Grant Applicatoin Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 123,592 124,145 $ 114,569 135,860 $ 9,023 (11,715) $ 97,383 115,481 $ 9,738 11,548 $ 87,645 103,933 $ 17,185 20,379 3 Design & ROW Support 85% $ 155,252 127,781 $ 461,327 284,782 $ (306,075157,001) $ 392,128 242,065 $ 39,213 24,206 $ 352,915 217,858 $ 69,199 42,717 4 Environmental Review & Permitting 85% $ 75,059 70,378 $ 92,474 12,660 $ (17,415) 57,718 $ 78,603 10,761 $ 7,860 1,076 $ 70,742 9,685 $ 13,871 1,899 5 ROW Acquisition 85% $ - $ 252,437 5,000 $ (252,4375,000) N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ - $ 50,000 - $ (50,000) - $ 42,500 - $ 4,250 - $ 38,250 - $ 7,500 - 7 Closeout Process 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 353,903 $ 970,806 - $ (616,9041,218) $ 610,614 1,218 $ 61,061 (1,035) $ 549,553 (104) $ 107,755 (932) $ (183) $ 322,303 $ 437,084 $ (114,781) $ 367,271 $ 36,727 $ 330,544 $ 64,813 [1] Projected costs for Quarter 6 7 (refer to QPR5QPR6) [2] Reference SOC dated September 12December 20, 2019 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit Total Use of Credit Amount Initial Starting Credit Request $575,808 Supplemental Credit Request $561,910 Authorized Local Credit by DWR (to date) $1,137,718 less Credit Payments received (Credit Payment No. 1) N/A Quarter 1 local share paid by State $52,037 Quarter 2 local share paid by State $96,436 Quarter 3 local share Paid by State $104,449 Quarter 4 local share Paid by State $121,286 Quarter 5 local share Paid by State $80,551 Pending Quarter 6 local share (subject to DWR Review) $107,755 108,513 Pending Quarter 7 Local Share (subject to DWR Review) $64,813 Remaining Authorized Local Credit $575,204 509,634 10 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 7 8 Report September 12December 27, 2019 This section of the report has been updated to include an accounting of quarterly costs incurred from the prior quarter as documented within the submitted quarterly Statements of Cost and any requested true-up funding. This requested funding is summarized in the following four tables listed below. 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 7 report for the 9th quarter8 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-12. 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 6 7 [1] QTR 1‐5 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 1 Grant Applicatoin Application $ - $ - $ - $ - $ - $ - $ - $ - 2 Program Management $ 114,569 $ 500,930 135,860 $ 615,498 $ 523,173 751,358 $ 52,317 638,654 $ 470,856 63,865 $ 468,856 574,789 $ 2,000 535,280 $ 39,509 3 Design & ROW Support $ 461,327 284,782 $ 1,992,455 2,458,831 $ 2,453,782 2,743,613 $ 2,085,715 2,332,071 $ 208,571 233,207 $ 1,877,143 2,098,864 $ 1,542,708 1,518,275 $ 334,435 580,589 4 Environmental Review & Permitting $ 92,474 $ 426,562 12,660 $ 519,035 $ 441,180 531,695 $ 44,118 451,941 $ 397,062 45,194 $ 312,446 406,747 $ 84,616 379,403 $ 27,344 5 ROW Acquisition $ 252,437 $ 5,000 $ 257,437 $ 262,437 N/A N/A N/A $ - N/A 6 Construction, Mitigation, & Other Project $ - $ 50,000 $ ‐ $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ - $ 38,250 7 Closeout Process $ (1,218) $ - $ (1,218) $ (1,035) $ (104) $ (932) $ - $ (932) $ 970,806 437,084 $ 2,924,946 3,900,802 $ 3,895,753 4,337,886 $ 3,092,568 3,464,131 $ 309,257 346,413 $ 2,783,312 3,117,718 $ 2,324,010 2,432,958 $ 459,301 684,760 [1] Reference Table 9‐19-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1‐5 QTR1-6 [3} Payments received through March June 2019 Table 10-21. 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 9 10 Remaining State Share Budget A B C = B - A D E F = C - D 1 Grant Application $ - $ 21,335 19,793 $ 21,335 19,793 $ - $ - $ 21,335 19,793 2 Program Management $ 704,668 762,197 $ 1,912,500 1,774,288 $ 1,207,832 1,012,091 $ - $ - $ 1,207,832 1,012,091 3 Design & ROW Support $ 1,881,554 1,939,083 $ 4,802,500 4,455,434 $ 2,920,946 2,516,351 $ - $ - $ 2,920,946 2,516,351 4 Environmental Review & Permitting $ 538,840 596,369 $ 1,105,000 1,025,144 $ 566,160 428,775 $ - $ - $ 566,160 428,775 5 ROW Acquisition $ - $ 6,098,338 5,657,624 $ 6,098,338 5,657,624 $ - $ - $ 6,098,338 5,657,624 6 Construction, Mitigation, & Other Project $ 5,072,906 $ 31,843,647 29,542,377 $ 26,770,741 24,469,470 $ - $ - $ 26,770,741 24,469,470 7 Closeout Process $ - $ 81,345 75,466 $ 81,345 75,466 $ - $ - $ 81,345 75,466 $ 8,370,555 $ 42,550,126 $ 34,179,571 $ - $ - $ 34,179,571 [1] Includes all State Payments received and pending to Date $ 8,197,968 $ 45,864,665 $ 37,666,697 $ ‐ $ ‐ $ 37,666,697 date [2] All pending requests Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Payment Payment Total Payment Report Request Date Payment Type Receipt Date Credit Portion State Portion Amount Notes QPR1 2/23/2018 Advance 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 Advance 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True‐Up True-Up QPR3 6/12/2018 Advance 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True‐Up True-Up QPR4 12/28/2018 Advance 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True‐Up True-Up QPR5 1/23/2019 Advance 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True‐Up True-Up QPR6 7/1/2019 Advance 8/22/2019 $80,551 $5,310,251 $5,390,802 Q8 Advance, Q5 Local True‐Up True-Up *QPR7 8/1/2019 Advance True-Up In Progress *$107,775 $0 *$107,775 Q9 Advance, Q6 Local True‐Up True-Up *QPR8 12/20/2019 True-Up In Progress $64,813 $0 $64,813 Q7 Local True-Up Cumulative Payments $454,758 627,346 $7,743,209 $8,197,967 8,370,555 Total Grant Amount [1] $8,093,765 11,408,304 $45,864,665 42,550,126 $53,958,430 Xxxxx Xxxxxx Remaining $7,639,006 10,780,958 $38,121,456 34,806,918 $45,760,463 45,587,875 * Pending DWR Approval

Appears in 1 contract

Samples: cms9files1.revize.com

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 $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-1 on the following page provides a summary of the previously projected costs for Quarter 6 (January – March 2019) (reference the Quarter 5 report) Quarters 3 & 4 as compared to the actual Costs for Quarter 6 (refer to 3 based on TRLIA’s November 29, 2018 Statement of Cost for the 3rd Quarter. This 4th Quarter Report SOC included with this report dated September 12, 2019)presents the costs for Quarters 1 through 3. Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during for Quarter 6 (January – March 2019)3. 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 Costs Element Description State Cost Share Previosly Previously Projected Costs [1] Actual Costs for the Quarter 6 [2] Difference between QTR and Actual Actual State Cost Share 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% G = E ‐ F H = C x (1 ‐ A) [1] [2] 1 Grant Applicatoin Application 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $0 $0 $0 $0 $0 2 Program Management 85% $ 123,592 $ 114,569 $ 9,023 $ 97,383 $ 9,738 $ 87,645 $ 17,185 $248,837 $101,527 $147,311 $86,298 $15,229 3 Design & ROW Support 85% $ 155,252 $ 461,327 $ (306,075) $ 392,128 $ 39,213 $ 352,915 $ 69,199 $802,249 $454,078 $348,171 $385,966 $68,112 4 Environmental Envrionmental Review & Permitting 85% $ 75,059 $ 92,474 $ (17,415) $ 78,603 $ 7,860 $ 70,742 $ 13,871 $215,116 $66,290 $148,826 $56,347 $9,944 5 ROW Acquisition (Post Add to SPFC) 85% $ ‐ $ 252,437 $ (252,437) N/A N/A N/A N/A $0 $0 $0 $0 $0 6 Construction, Mitigation, & Other Project A 85% $ ‐ $ 50,000 $ (50,000) $ 42,500 $ 4,250 $ 38,250 $ 7,500 $0 $0 $0 $0 $0 7 Closeout Process (Post Add to SPFC) 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 353,903 $ 970,806 $ (616,904) $ 610,614 $ 61,061 $ 549,553 $ 107,755 $0 $0 $0 $0 $0 Total $1,266,202 $621,894 $644,308 $528,610 $93,284 [1] Projected costs for Quarter 6 Quarters 3 & 4 (refer to QPR5as presented in Table 10-1 of the Q3 Report) [2] Reference SOC dated September 12, 2019 Quarter 3 Statement of Cost (subject to DWR Review review); Cost incurred through Apr-Jun 2018 Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit Description Amount Total Use of Credit Amount for Local Share this quarter $115,595 Total Local Share Eligible for Credit with Advance Total Use of Credit Initial Starting Credit Request $575,808 677,421 Supplemental Credit Request $561,910 661,070 Authorized Local Credit by DWR (to date) $1,137,718 1,338,491 less Credit Payments received (Credit Payment No. 1) N/A Quarter less Requested Payments 1 local share paid by State and 2 $52,037 Quarter 1,051,439 Less Requested Report 2 local share paid by State $96,436 Quarter 489,202 Less Requested Report 3 local share Paid by State $104,449 Quarter 4 local share Paid by State $121,286 Quarter 5 local share Paid by State $80,551 Pending Quarter 6 local share $107,755 674,423 Remaining Authorized Local Credit $575,204 -$876,573 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 7 4 Report September 12November 29, 2019 2018 This section of the report has been updated to include an accounting of quarterly costs incurred from the prior quarter as documented within the submitted quarterly Statements of Cost and any requested true-up funding. This requested funding is summarized in the following four tables listed below. Based on the projected costs for Quarter 5 and Quarter 6, TRLIA requests an advance of $96,639 covering 90% of the State’s share for the next two-quarters less funding received and not expended from advances for the prior Quarterly Report (reference Tables 10-1 & 10-2 on the following page). 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 7 report for the 9th quarter]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: True-Up Funding True Up Costs True Up 5th and 6th Quarter Projected 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 6 Projected Costs [1] QTR 1‐5 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 = D ‐ E G H = F ‐ G 1 Grant Applicatoin $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ Application $0 $0 $0 $0 $0 2 Program Management $ 114,569 $ 500,930 $ 615,498 $ 523,173 $ 52,317 $ 470,856 $ 468,856 $ 2,000 $249,875 $212,394 $191,154 ($112,693) $78,462 3 Design & ROW Support $ 461,327 $ 1,992,455 $ 2,453,782 $ 2,085,715 $ 208,571 $ 1,877,143 $ 1,542,708 $ 334,435 $368,469 $313,199 $281,879 ($266,351) $15,528 4 Environmental Envrionmental Review & Permitting $ 92,474 $ 426,562 $ 519,035 $ 441,180 $ 44,118 $ 397,062 $ 312,446 $ 84,616 $152,290 $129,446 $116,502 ($113,852) $2,650 5 ROW Acquisition $ 252,437 $ 5,000 $ 257,437 N/A N/A N/A $ ‐ N/A (Post Add to SPFC) $0 $0 $0 $0 $0 6 Construction, Mitigation, & Other Project $ 50,000 $ ‐ $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ ‐ $ 38,250 Activites $0 $0 $0 $0 $0 7 Closeout Process $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 970,806 $ 2,924,946 $ 3,895,753 $ 3,092,568 $ 309,257 $ 2,783,312 $ 2,324,010 $ 459,301 (Post Add to SPFC) $0 $0 $0 $0 $0 Total $770,634 $655,039 $589,535 ($492,895) $96,639 [1] Reference Table 9‐1, Total Subject to DWR Review Covers period from 10/1/2018 through 3/31/2019 (Q5 & Q6) [2] Reference Previously Approved DWR Statement of Costs for QTR1‐5 [3} Payments received through March 2019 Table 10-2 Table 10-2. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding Quarter 3 (to date) Advance Element Description True-Up Costs (State Share) Witheld Retention Payments Received True-Up Funding (excess) A [1] B C [2] D = A - B - C 1 Grant Application $0 $0 $0 $0 2 Program Management $86,298 $8,630 $190,360 ($112,693) 3 Design & ROW Support $385,966 $38,597 $613,720 ($266,351) 4 Envrionmental Review & Permitting $56,347 $5,635 $164,564 ($113,852) 5 ROW Acquisition (Post Add to SPFC) $0 $0 $0 $0 6 Construction, Mitigation, & Other Project Activ $0 $0 $0 $0 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 Total $528,610 $52,861 $968,645 ($492,895) [2] Reflects Advanced Payment for Q3 & Q4 (reference Table 10-1 from Q3 Report) Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Summary of Payment Request and Comparison to State Share Budget Element Description Prior State Element Description Payments (Advances and True Ups) [1] State Share Budget Remaining Budget (Prior State Share Budget Pending Payments) Advanced Request [2] State Share of Projection Quarter 9 Quarters 5 & 6 Remaining State Share Budget A B C = B ‐ C=B-A D E F = C ‐ E=B-A-D 1 Grant Application $ ‐ $ 21,335 $ 21,335 $ ‐ $ ‐ $ 21,335 $0 $19,829 $19,829 $0 $19,829 2 Program Management $ 704,668 $ 1,912,500 $ 1,207,832 $ ‐ $ ‐ $ 1,207,832 $402,433 $1,777,501 $1,375,068 $78,462 $1,296,606 3 Design & ROW Support $ 1,881,554 $ 4,802,500 $ 2,920,946 $ ‐ $ ‐ $ 2,920,946 $1,567,141 $4,654,920 $3,087,779 $15,528 $3,072,251 4 Environmental Envrionmental Review & Permitting $ 538,840 $ 1,105,000 $ 566,160 $ ‐ $ ‐ $ 566,160 $245,490 $802,403 $556,913 $2,650 $554,263 5 ROW Acquisition $ ‐ $ 6,098,338 $ 6,098,338 $ ‐ $ ‐ $ 6,098,338 (Post Add to SPFC) $0 $6,578,413 $6,578,413 $0 $6,578,413 6 Construction, Mitigation, & Other Project $ 5,072,906 $ 31,843,647 $ 26,770,741 $ ‐ $ ‐ $ 26,770,741 Activites $0 $18,691,331 $18,691,331 $0 $18,691,331 7 Closeout Process $ ‐ $ 81,345 $ 81,345 $ ‐ $ ‐ $ 81,345 [1] Includes all State Payments (Post Add to Date $ 8,197,968 $ 45,864,665 $ 37,666,697 $ ‐ $ ‐ $ 37,666,697 [2] All pending requests SPFC) $0 $75,603 $75,603 $0 $75,603 Total $2,215,064 $32,600,000 $30,384,936 $96,639 $30,288,296 Table 10-34. TRLIA - 200-Year Goldfields Levee Project: Payment Requests Request and State Disbursements Report Justifying Payment Payment Total Payment Report Request Date Payment Type Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes QPR1 Q1 2/23/2018 Advance 3/9/2018 $0 206,165 $1,051,439 $1,051,439 1,257,604 Q1&Q2 Advance QPR2 Q2 3/28/2018 Advance 9/17/2018 Payment 8/17/2018 $52,037 $489,201 489,202 $541,238 541,239 QPR2 Payment Q3 Advance, Q1 Local True‐Up QPR3 6/12/2018 Advance Payment 8/21/2018 $96,436 $674,422 674,423 $770,858 Q4 Advance, Q2 Local True‐Up QPR4 12/28/2018 Advance 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True‐Up QPR5 1/23/2019 Advance 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True‐Up QPR6 7/1/2019 Advance 8/22/2019 $80,551 $5,310,251 $5,390,802 Q8 Advance, Q5 Local True‐Up QPR7 8/1/2019 Advance In Progress *$107,775 $0 *$107,775 Q9 Advance, Q6 Local True‐Up 770,859 QPR3 Payment Cumulative Payments $454,758 354,638 $7,743,209 2,215,064 $8,197,967 2,569,702 Total Grant Amount [1] $8,093,765 8,665,800 $45,864,665 32,600,000 $53,958,430 41,265,800 Xxxxx Xxxxxx Remaining $7,639,006 8,311,162 $38,121,456 30,384,936 $45,760,463 * Pending DWR Approval38,696,098 11. Tracking Tables and Deliverables Table 11.1. Earned Value Report by Element TRLIA 200-Year Goldfields Levee Project Quarter 4 Report November 29, 2018 Table 11-1 on the following page, provides a summary of the costs expended to date, as compared to earned value.

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 $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-1 on the The following page provides a summary of the previously projected costs for Quarter 6 (January – March 2019) (reference the Quarter 5 report) Quarters as compared to the actual Costs for Quarters 1 and 2 based on TRLIA’s June 10, 2018 Statement of Cost. This SOC presents the costs for both Quarter 6 (refer to SOC included with this report dated September 12, 2019)1 and Quarter 2. Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 6 (January – March 2019)for Quarters 1 and 2. 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 Costs Element Description State Cost Share Previosly Previously Projected Costs [1] Actual Costs for Quarter 6 [2] Quarters 1 & 2 Difference between QTR and Actual Actual State Cost Share 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% G = E ‐ F H = C x (1 ‐ A) [1] [2] 1 Grant Applicatoin Application 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $0 $0 $0 $0 $0 2 Program Management 85% $ 123,592 $ 114,569 $ 9,023 $ 97,383 $ 9,738 $ 87,645 $ 17,185 $249,585 $200,087 $49,498 $170,074 $30,013 3 Design & ROW Support 85% $ 155,252 $ 461,327 $ (306,075) $ 392,128 $ 39,213 $ 352,915 $ 69,199 $1,168,604 $743,545 $425,060 $632,013 $111,532 4 Environmental Envrionmental Review & Permitting 85% $ 75,059 $ 92,474 $ (17,415) $ 78,603 $ 7,860 $ 70,742 $ 13,871 $248,803 $46,195 $202,608 $39,266 $6,929 5 ROW Acquisition (Post Add to SPFC) 85% $ ‐ $ 252,437 $ (252,437) N/A N/A N/A N/A $0 $0 $0 $0 $0 6 Construction, Mitigation, & Other Project A 85% $ ‐ $ 50,000 $ (50,000) $ 42,500 $ 4,250 $ 38,250 $ 7,500 $0 $0 $0 $0 $0 7 Closeout Process (Post Add to SPFC) 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 353,903 $ 970,806 $ (616,904) $ 610,614 $ 61,061 $ 549,553 $ 107,755 $0 $0 $0 $0 $0 Total $1,666,993 $989,826 $677,166 $841,352 $148,474 [1] Projected costs for Quarter 6 (refer to QPR5) Quarters 2 & 3 from Q2 Report [2] Reference SOC dated September 12, 2019 Quarter 3 Statement of Cost (subject to DWR Review review) Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit Description Amount Total Use of Credit Amount for Local Share this quarter $189,930 Total Local Share Eligible for Credit with Advance Total Use of Credit Initial Starting Credit Request $575,808 677,421 pending Supplemental Credit Request $561,910 661,070 Authorized Local Credit by DWR (to date) $1,137,718 677,421 less Credit Payments received (Credit Payment No. 1) N/A Quarter less Requested Payments 1 local share paid by State and 2 $52,037 Quarter 2 local share paid by State $96,436 Quarter 3 local share Paid by State $104,449 Quarter 4 local share Paid by State $121,286 Quarter 5 local share Paid by State $80,551 Pending Quarter 6 local share $107,755 1,051,439 Remaining Authorized Local Credit $575,204 ‐$374,018 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 7 3 Report September June 12, 2019 2018 This section of the report has been updated (relative to the Quarter 1 report) to include an accounting of quarterly costs incurred from the prior quarter as documented within the submitted quarterly Statements Statement of Cost and any requested true-up funding. This requested funding is summarized in the following four tables listed below. Based on the projected costs for Quarter 3 and Quarter 4, TRLIA requests an advance of $674,423 covering 90% of the State’s share for the next two-quarters less funding received from the advance received from the prior Quarter Report (reference Tables 10-1 & 10-2 on the following page). 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 7 report for the 9th quarter]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. Table 10-1. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding True Up Costs True Up 3rd and 4th Quarter Projected 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 6 Projected Costs [1] QTR 1‐5 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 = D ‐ E G H = F ‐ G 1 Grant Applicatoin $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ Application $0 $0 $0 $0 $0 2 Program Management $ 114,569 $ 500,930 $ 615,498 $ 523,173 $ 52,317 $ 470,856 $ 468,856 $ 2,000 $248,837 $211,512 $190,360 ($32,359) $158,002 3 Design & ROW Support $ 461,327 $ 1,992,455 $ 2,453,782 $ 2,085,715 $ 208,571 $ 1,877,143 $ 1,542,708 $ 334,435 $802,249 $681,911 $613,720 ($135,267) $478,453 4 Environmental Envrionmental Review & Permitting $ 92,474 $ 426,562 $ 519,035 $ 441,180 $ 44,118 $ 397,062 $ 312,446 $ 84,616 $215,116 $182,849 $164,564 ($126,595) $37,969 5 ROW Acquisition $ 252,437 $ 5,000 $ 257,437 N/A N/A N/A $ ‐ N/A (Post Add to SPFC) $0 $0 $0 $0 $0 6 Construction, Mitigation, & Other Project $ 50,000 $ ‐ $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ ‐ $ 38,250 Activites $0 $0 $0 $0 $0 7 Closeout Process $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 970,806 $ 2,924,946 $ 3,895,753 $ 3,092,568 $ 309,257 $ 2,783,312 $ 2,324,010 $ 459,301 (Post Add to SPFC) $0 $0 $0 $0 $0 Total $1,266,202 $1,076,272 $968,645 ($294,222) $674,423 [1] Reference Table 9‐1, Total Subject to DWR Review Covers period from 4/1/2018 through 9/30/2018 (Q3 and Q4) [2] Reference Previously Approved DWR Statement of Costs for QTR1‐5 [3} Payments received through March 2019 Table 10‐2 Table 10-2. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding Quarters 1 & 2 (to date) Advance Element Description True‐Up Costs (State Share) Witheld Retention Payments Received True‐Up Funding (Excess) A [1] B B C = A ‐ B 1 Grant Application $0 $0 $0 $0 2 Program Management $170,074 $17,007 $185,425 ($32,359) 3 Design & ROW Support $632,013 $63,201 $704,079 ($135,267) 4 Envrionmental Review & Permitting $39,266 $3,927 $161,935 ($126,595) 5 ROW Acquisition (Post Add to SPFC) $0 $0 $0 $0 6 Construction, Mitigation, & Other Project Activ $0 $0 $0 $0 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 Total $841,352 $84,135 $1,051,439 ($294,222) [1] Repre sents Quarter 1 and 2 combined True‐Up costs (October 4, 2017 through March 31, 2018) reported on the Quarterly Statement of Costs subject to DWR review and final approval. Reference Table 9‐1 from re port Q1 and this Q2 re port. Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Summary of Payment Request and Comparison to State Share Budget Element Description Prior State Element Description Payments (Advances and True Ups) [1] State Share Budget Remaining Budget (Prior State Share Budget Pending Payments) Advanced Request [2] State Share of Projection Quarter 9 Quarters 2 & 3 Remaining State Share Budget A B C = B ‐ A C=B‐A D E F = C ‐ D E=B‐A‐D 1 Grant Application $ ‐ $ 21,335 $ 21,335 $ ‐ $ ‐ $ 21,335 $0 $19,829 $19,829 $0 $19,829 2 Program Management $ 704,668 $ 1,912,500 $ 1,207,832 $ ‐ $ ‐ $ 1,207,832 $185,425 $1,777,501 $1,592,076 $158,002 $1,434,074 3 Design & ROW Support $ 1,881,554 $ 4,802,500 $ 2,920,946 $ ‐ $ ‐ $ 2,920,946 $704,079 $4,654,920 $3,950,840 $478,453 $3,472,388 4 Environmental Envrionmental Review & Permitting $ 538,840 $ 1,105,000 $ 566,160 $ ‐ $ ‐ $ 566,160 $161,935 $802,403 $640,469 $37,969 $602,500 5 ROW Acquisition $ ‐ $ 6,098,338 $ 6,098,338 $ ‐ $ ‐ $ 6,098,338 (Post Add to SPFC) $0 $6,578,413 $6,578,413 $0 $6,578,413 6 Construction, Mitigation, & Other Project $ 5,072,906 $ 31,843,647 $ 26,770,741 $ ‐ $ ‐ $ 26,770,741 Activites $0 $18,691,331 $18,691,331 $0 $18,691,331 7 Closeout Process $ ‐ $ 81,345 $ 81,345 $ ‐ $ ‐ $ 81,345 [1] Includes all State Payments (Post Add to Date $ 8,197,968 $ 45,864,665 $ 37,666,697 $ ‐ $ ‐ $ 37,666,697 [2] All pending requests SPFC) $0 $75,603 $75,603 $0 $75,603 Total $1,051,439 $32,600,000 $31,548,561 $674,423 $30,874,138 Table 10-34. TRLIA - 200-Year Goldfields Levee Project: Payment Requests Request and State Disbursements Report Justifying Payment Payment Total Payment Report Request Date Payment Type Payment Receipt Date Credit Portion State Portion Payment Amount Notes QPR1 Q1 2/23/2018 Advance 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 Q2 3/28/2018 Advance 9/17/2018 $52,037 $489,201 $541,238 XXX XXX Q3 Advance, Q1 Local True‐Up QPR3 6/12/2018 Advance 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True‐Up QPR4 12/28/2018 Advance 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True‐Up QPR5 1/23/2019 Advance 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True‐Up QPR6 7/1/2019 Advance 8/22/2019 $80,551 $5,310,251 $5,390,802 Q8 Advance, Q5 Local True‐Up QPR7 8/1/2019 Advance In Progress *$107,775 $0 *$107,775 Q9 Advance, Q6 Local True‐Up XXX XXX Cumulative Payments $454,758 $7,743,209 $8,197,967 1,051,439 Total Grant Amount [1] $8,093,765 $45,864,665 $53,958,430 32,600,000 Xxxxx Xxxxxx Remaining $7,639,006 $38,121,456 $45,760,463 * Pending DWR Approval31,548,561 11. Tracking Tables and Deliverables Table 11.1. Earned Value Report by Element TRLIA 200-Year Goldfields Levee Project Quarter 3 Report June 12, 2018 Table 11-1 on the following page, provides a summary of the costs expended to date, as compared to earned value.

Appears in 1 contract

Samples: cms9files1.revize.com

AutoNDA by SimpleDocs

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 State’s share was $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 Total Expenses associated with the supplemental request is $561,909.92688,476.32 and the State’s share is $585,204.87. Table 9-1 on the following page provides a summary of the previously projected costs for Quarter 6 (January – March 2019) (reference the Quarter 5 report) Quarters 1 & 2 as compared to the actual Costs for Quarter 6 (refer to SOC included with this report dated September 121 based on TRLIA’s March 28, 2019)2017 Statement of Cost. Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during for Quarter 6 (January – March 2019)1. 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 Projected Cost Comparison and True-Up Element Description State Cost Share Previosly Previously Projected Costs [1] Actual Costs for Quarter 6 [2] 1 Difference between QTR and Actual Actual State Cost Share 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% G = E ‐ F H = C x (1 ‐ A) [1] [2] 1 Grant Applicatoin Application 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $0 $0 $0 $0 $0 2 Program Management 85% $ 123,592 $ 114,569 $ 9,023 $ 97,383 $ 9,738 $ 87,645 $ 17,185 $242,386 $69,933 $172,453 $59,443 $10,490 3 Design & ROW Support 85% $ 155,252 $ 461,327 $ (306,075) $ 392,128 $ 39,213 $ 352,915 $ 69,199 $920,365 $272,322 $648,043 $231,474 $40,848 4 Environmental Envrionmental Review & Permitting 85% $ 75,059 $ 92,474 $ (17,415) $ 78,603 $ 7,860 $ 70,742 $ 13,871 $211,679 $22,467 $189,212 $19,097 $3,370 5 ROW Acquisition (Post Add to SPFC) 85% $ ‐ $ 252,437 $ (252,437) N/A N/A N/A N/A $0 $0 $0 $0 $0 6 Construction, Mitigation, & Other Project A 85% $ ‐ $ 50,000 $ (50,000) $ 42,500 $ 4,250 $ 38,250 $ 7,500 $0 $0 $0 $0 $0 7 Closeout Process (Post Add to SPFC) 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 353,903 $ 970,806 $ (616,904) $ 610,614 $ 61,061 $ 549,553 $ 107,755 $0 $0 $0 $0 $0 Total $1,374,430 $364,722 $1,009,708 $310,014 $54,708 [1] Projected costs for Quarter 6 (refer to QPR5) Quarters 1 & 2 from Q1 Report [2] Reference SOC dated September 12, 2019 Quarter 1 Statement of Cost (subject to DWR Review review) Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit Reconciliation Description Amount Total Use of Credit Amount for Local Share this quarter $250,049 Total Local Share Eligible for Credit with Advance Total Use of Credit Initial Starting Credit Request $575,808 677,421 pending Supplemental Credit Request $561,910 688,476 Authorized Local Credit by DWR (to date) $1,137,718 677,421 less Credit Payments received (Credit Payment No. 1) N/A Quarter 1 local share paid by State $52,037 Quarter 2 local share paid by State $96,436 Quarter 3 local share Paid by State $104,449 Quarter 4 local share Paid by State $121,286 Quarter 5 local share Paid by State $80,551 Pending Quarter 6 local share $107,755 Remaining Authorized Local Credit $575,204 677,421 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 7 2 Report September 12March 29, 2019 2018 This section of the report has been updated (relative to the Quarter 1 report) to include an accounting of quarterly costs incurred from the prior quarter as documented within the submitted quarterly Statements Statement of Cost and any requested true-up funding. This requested funding is summarized in the following four tables listed below. Based on the projected costs for Quarter 2 and Quarter 3, TRLIA requests an advance of $533,825 covering 90% of the State’s share for the next two-quarters less funding received from the advance received from the prior Quarter Report (reference Tables 10-1 & 10-2 on the following page). 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 7 report for the 9th quarter]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 retention) documented within TRLIA’s Statement of CostsPayment less Quarter 1 State share True-up. 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-1. 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 6 Projected Costs [1] QTR 1‐5 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 = D ‐ E G H = F ‐ G 1 Grant Applicatoin $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ Application $0 $0 $0 $0 $0 2 Program Management $ 114,569 $ 500,930 $ 615,498 $ 523,173 $ 52,317 $ 470,856 $ 468,856 $ 2,000 $249,585 $212,147 $190,933 ($125,982) $64,950 3 Design & ROW Support $ 461,327 $ 1,992,455 $ 2,453,782 $ 2,085,715 $ 208,571 $ 1,877,143 $ 1,542,708 $ 334,435 $1,168,604 $993,314 $893,982 ($472,605) $421,377 4 Environmental Envrionmental Review & Permitting $ 92,474 $ 426,562 $ 519,035 $ 441,180 $ 44,118 $ 397,062 $ 312,446 $ 84,616 $248,803 $211,483 $190,335 ($142,837) $47,497 5 ROW Acquisition $ 252,437 $ 5,000 $ 257,437 N/A N/A N/A $ ‐ N/A (Post Add to SPFC) $0 $0 $0 $0 $0 6 Construction, Mitigation, & Other Project $ 50,000 $ ‐ $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ ‐ $ 38,250 Activites (Pos $0 $0 $0 $0 $0 7 Closeout Process $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 970,806 $ 2,924,946 $ 3,895,753 $ 3,092,568 $ 309,257 $ 2,783,312 $ 2,324,010 $ 459,301 (Post Add to SPFC) $0 $0 $0 $0 $0 Total $1,666,993 $1,416,944 $1,275,250 ($741,425) $533,825 [1] Reference Table 9‐1, Total Subject to DWR Review Covers period from 1/1/2018 through 6/30/2018 (Q2 and Q3) [2] Reference Previously Approved DWR Statement of Costs for QTR1‐5 [3} Payments received through March 2019 Table 10-2 Table 10-2. TRLIA - TRLIA- 200-Year Goldfields Levee Project: Summary of Payment Request and Comparison True-Up Costs to State Share Budget Prior State Advances Quarters 1 & 2 (to date) Advance Element Description True-Up Costs (State Share) Payments Received True-Up Funding (Advances and True UpsExcess) [1] State Share Budget Remaining State Share Budget Pending Advanced Request [2] State Share of Projection Quarter 9 Remaining State Share Budget A B C = A - B ‐ A D E F = C ‐ D 1 Grant Application $ ‐ $ 21,335 $ 21,335 $ ‐ $ ‐ $ 21,335 $0 $0 $0 2 Program Management $ 704,668 $ 1,912,500 $ 1,207,832 $ ‐ $ ‐ $ 1,207,832 $59,443 $185,425 ($125,982) 3 Design & ROW Support $ 1,881,554 $ 4,802,500 $ 2,920,946 $ ‐ $ ‐ $ 2,920,946 $231,474 $704,079 ($472,605) 4 Environmental Envrionmental Review & Permitting $ 538,840 $ 1,105,000 $ 566,160 $ ‐ $ ‐ $ 566,160 $19,097 $161,935 ($142,837) 5 ROW Acquisition $ ‐ $ 6,098,338 $ 6,098,338 $ ‐ $ ‐ $ 6,098,338 (Post Add to SPFC) $0 $0 $0 6 Construction, Mitigation, & Other Project $ 5,072,906 $ 31,843,647 $ 26,770,741 $ ‐ $ ‐ $ 26,770,741 Activ $0 $0 $0 7 Closeout Process $ ‐ $ 81,345 $ 81,345 $ ‐ $ ‐ $ 81,345 [1] Includes all State Payments (Post Add to Date $ 8,197,968 $ 45,864,665 $ 37,666,697 $ ‐ $ ‐ $ 37,666,697 [2] All pending requests SPFC) $0 $0 $0 Total $310,014 $1,051,439 ($741,425) Table 10-3. TRLIA - TRLIA- 200-Year Goldfields Levee Project: Budget and Payment Reconciliation Element Description Prior State Payments State Share Budget Remaining Budget (Prior State Payments) Advanced Request Quarters 2 & 3 Remaining Budget A B C=B-A D E=B-A-D 1 Grant Application $0 $19,829 $19,829 $0 $19,829 2 Program Management $185,425 $1,777,501 $1,592,076 $64,950 $1,527,125 3 Design & ROW Support $704,079 $4,654,920 $3,950,840 $421,377 $3,529,463 4 Envrionmental Review & Permitting $161,935 $802,403 $640,469 $47,497 $592,972 5 ROW Acquisition (Post Add to SPFC) $0 $6,578,413 $6,578,413 $0 $6,578,413 6 Construction, Mitigation, & Other Project Activites $0 $18,691,331 $18,691,331 $0 $18,691,331 7 Closeout Process (Post Add to SPFC) $0 $75,603 $75,603 $0 $75,603 Total $1,051,439 $32,600,000 $31,548,561 $533,825 $31,014,736 Table 10-4. TRLIA- 200-Year Goldfields Levee Project: Payment Requests and Request & State Disbursements Report Justifying Payment Payment Total Payment Report Request Date Payment Type Payment Receipt Date Credit Portion State Portion Payment Amount Notes QPR1 Q1 2/23/2018 Advance 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 Q2 3/28/2018 Advance 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True‐Up QPR3 6/12/2018 Advance 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True‐Up QPR4 12/28/2018 Advance 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True‐Up QPR5 1/23/2019 Advance 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True‐Up QPR6 7/1/2019 Advance 8/22/2019 $80,551 $5,310,251 $5,390,802 Q8 Advance, Q5 Local True‐Up QPR7 8/1/2019 Advance In Progress *$107,775 $0 *$107,775 Q9 Advance, Q6 Local True‐Up XXX XXX Cumulative Payments $454,758 $7,743,209 $8,197,967 1,051,439 Total Grant Amount [1] $8,093,765 $45,864,665 $53,958,430 32,600,000 Xxxxx Xxxxxx Remaining $7,639,006 $38,121,456 $45,760,463 * Pending DWR Approval31,548,561 11. Tracking Tables and Deliverables Table 11.1. Earned Value Report by Element TRLIA 200-Year Goldfields Levee Project Quarter 2 Report March 29, 2018 Table 11-1 on the following page, provides a summary of the costs expended to date, as compared to earned value.

Appears in 1 contract

Samples: cms9files1.revize.com

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-1 on the following page provides a summary of the previously projected costs for Quarter 6 (January – March 2019) (reference the Quarter 5 report) Quarters 1 & 2 as compared to the actual Costs for Quarter 6 (refer to SOC included with this report dated September 121 based on TRLIA’s March 28, 2019)2017 Statement of Cost. Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during for Quarter 6 (January – March 2019)1. 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 Projected Cost Comparison and True-Up Element Description State Cost Share Previosly Previously Projected Costs [1] Actual Costs for Quarter 6 [2] 1 Difference between QTR and Actual Actual State Cost Share 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% G = E ‐ F H = C x (1 ‐ A) [1] [2] 1 Grant Applicatoin Application 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $0 $0 $0 $0 $0 2 Program Management 85% $ 123,592 $ 114,569 $ 9,023 $ 97,383 $ 9,738 $ 87,645 $ 17,185 $242,386 $69,933 $172,453 $59,443 $10,490 3 Design & ROW Support 85% $ 155,252 $ 461,327 $ (306,075) $ 392,128 $ 39,213 $ 352,915 $ 69,199 $920,365 $254,517 $665,848 $216,339 $38,178 4 Environmental Envrionmental Review & Permitting 85% $ 75,059 $ 92,474 $ (17,415) $ 78,603 $ 7,860 $ 70,742 $ 13,871 $211,679 $22,467 $189,212 $19,097 $3,370 5 ROW Acquisition (Post Add to SPFC) 85% $ ‐ $ 252,437 $ (252,437) N/A N/A N/A N/A $0 $0 $0 $0 $0 6 Construction, Mitigation, & Other Project A 85% $ ‐ $ 50,000 $ (50,000) $ 42,500 $ 4,250 $ 38,250 $ 7,500 $0 $0 $0 $0 $0 7 Closeout Process (Post Add to SPFC) 85% $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 353,903 $ 970,806 $ (616,904) $ 610,614 $ 61,061 $ 549,553 $ 107,755 $0 $0 $0 $0 $0 Total $1,374,430 $346,917 $1,027,513 $294,880 $52,038 [1] Projected costs for Quarter 6 (refer to QPR5) Quarters 1 & 2 from Q1 Report [2] Reference SOC dated September 12, 2019 Quarter 1 Statement of Cost (subject to DWR Review review) Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit Reconciliation Description Amount Total Use of Credit Amount for Local Share this quarter $250,049 Total Local Share Eligible for Credit with Advance Total Use of Credit Initial Starting Credit Request $575,808 677,421 pending Supplemental Credit Request $561,910 688,476 Authorized Local Credit by DWR (to date) $1,137,718 677,421 less Credit Payments received (Credit Payment No. 1) N/A Quarter 1 local share paid by State $52,037 Quarter 2 local share paid by State $96,436 Quarter 3 local share Paid by State $104,449 Quarter 4 local share Paid by State $121,286 Quarter 5 local share Paid by State $80,551 Pending Quarter 6 local share $107,755 Remaining Authorized Local Credit $575,204 677,421 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 7 2 Report September 12March 28, 2019 2018 This section of the report has been updated (relative to the Quarter 1 report) to include an accounting of quarterly costs incurred from the prior quarter as documented within the submitted quarterly Statements Statement of Cost and any requested true-up funding. This requested funding is summarized in the following four tables listed below. Based on the projected costs for Quarter 2 and Quarter 3, TRLIA requests an advance of $489,202 covering 90% of the State’s share for the next two-quarters less funding received from the advance received from the prior Quarter Report (reference Tables 10-1 & 10-2 on the following page). 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 7 report for the 9th quarter]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-1. 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 6 Projected Costs [1] QTR 1‐5 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 = D ‐ E G H = F ‐ G 1 Grant Applicatoin $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ Application $0 $0 $0 $0 $0 2 Program Management $ 114,569 $ 500,930 $ 615,498 $ 523,173 $ 52,317 $ 470,856 $ 468,856 $ 2,000 $249,585 $212,147 $190,933 ($131,927) $59,006 3 Design & ROW Support $ 461,327 $ 1,992,455 $ 2,453,782 $ 2,085,715 $ 208,571 $ 1,877,143 $ 1,542,708 $ 334,435 $1,168,604 $993,314 $893,982 ($509,374) $384,609 4 Environmental Envrionmental Review & Permitting $ 92,474 $ 426,562 $ 519,035 $ 441,180 $ 44,118 $ 397,062 $ 312,446 $ 84,616 $248,803 $211,483 $190,335 ($144,747) $45,587 5 ROW Acquisition $ 252,437 $ 5,000 $ 257,437 N/A N/A N/A $ ‐ N/A (Post Add to SPFC) $0 $0 $0 $0 $0 6 Construction, Mitigation, & Other Project $ 50,000 $ ‐ $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ ‐ $ 38,250 Activites $0 $0 $0 $0 $0 7 Closeout Process $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ ‐ $ 970,806 $ 2,924,946 $ 3,895,753 $ 3,092,568 $ 309,257 $ 2,783,312 $ 2,324,010 $ 459,301 (Post Add to SPFC) $0 $0 $0 $0 $0 Total $1,666,993 $1,416,944 $1,275,250 ($786,047) $489,202 [1] Reference Table 9‐1, Total Subject to DWR Review Covers period from 1/1/2018 through 6/30/2018 (Q2 and Q3) [2] Reference Previously Approved DWR Statement of Costs for QTR1‐5 [3} Payments received through March 2019 Table 10‐2 Table 10-2. TRLIA - TRLIA- 200-Year Goldfields Levee Project: Summary of Payment Request and Comparison True-Up Costs to State Share Budget Prior State Advances Quarters 1 & 2 (to date) Advance Element Description True‐Up Costs (State Share) Witheld Retention Payments Received True‐Up Funding (Advances and True UpsExcess) [1] State Share Budget Remaining State Share Budget Pending Advanced Request [2] State Share of Projection Quarter 9 Remaining State Share Budget A B C C = B A A D E F = C ‐ D B 1 Grant Application $ ‐ $ 21,335 $ 21,335 $ ‐ $ ‐ $ 21,335 $0 $0 $0 $0 2 Program Management $ 704,668 $ 1,912,500 $ 1,207,832 $ ‐ $ ‐ $ 1,207,832 $59,443 $5,944 $185,425 ($131,927) 3 Design & ROW Support $ 1,881,554 $ 4,802,500 $ 2,920,946 $ ‐ $ ‐ $ 2,920,946 $216,339 $21,634 $704,079 ($509,374) 4 Environmental Envrionmental Review & Permitting $ 538,840 $ 1,105,000 $ 566,160 $ ‐ $ ‐ $ 566,160 $19,097 $1,910 $161,935 ($144,747) 5 ROW Acquisition $ ‐ $ 6,098,338 $ 6,098,338 $ ‐ $ ‐ $ 6,098,338 (Post Add to SPFC) $0 $0 $0 $0 6 Construction, Mitigation, & Other Project $ 5,072,906 $ 31,843,647 $ 26,770,741 $ ‐ $ ‐ $ 26,770,741 Activ $0 $0 $0 $0 7 Closeout Process $ ‐ $ 81,345 $ 81,345 $ ‐ $ ‐ $ 81,345 [1] Includes all State Payments (Post Add to Date $ 8,197,968 $ 45,864,665 $ 37,666,697 $ ‐ $ ‐ $ 37,666,697 [2] All pending requests SPFC) $0 $0 $0 $0 Total $294,880 $29,488 $1,051,439 ($786,047) Table 10-3. TRLIA - TRLIA- 200-Year Goldfields Levee Project: Budget and Payment Reconciliation Element Description Prior State Payments State Share Budget Remaining Budget (Prior State Payments) Advanced Request Quarters 2 & 3 Remaining Budget A B C=B‐A D E=B‐A‐D 1 Grant Application $0 $19,829 $19,829 $0 $19,829 2 Program Management $185,425 $1,777,501 $1,592,076 $59,006 $1,533,070 3 Design & ROW Support $704,079 $4,654,920 $3,950,840 $384,609 $3,566,232 4 Envrionmental Review & Permitting $161,935 $802,403 $640,469 $45,587 $594,881 5 ROW Acquisition (Post Add to SPFC) $0 $6,578,413 $6,578,413 $0 $6,578,413 6 Construction, Mitigation, & Other Project Activites $0 $18,691,331 $18,691,331 $0 $18,691,331 7 Closeout Process (Post Add to SPFC) $0 $75,603 $75,603 $0 $75,603 Total $1,051,439 $32,600,000 $31,548,561 $489,202 $31,059,359 Table 10-4. TRLIA- 200-Year Goldfields Levee Project: Payment Requests and Request & State Disbursements Report Justifying Payment Payment Total Payment Report Request Date Payment Type Payment Receipt Date Credit Portion State Portion Payment Amount Notes QPR1 Q1 2/23/2018 Advance 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 Q2 3/28/2018 Advance 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True‐Up QPR3 6/12/2018 Advance 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True‐Up QPR4 12/28/2018 Advance 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True‐Up QPR5 1/23/2019 Advance 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True‐Up QPR6 7/1/2019 Advance 8/22/2019 $80,551 $5,310,251 $5,390,802 Q8 Advance, Q5 Local True‐Up QPR7 8/1/2019 Advance In Progress *$107,775 $0 *$107,775 Q9 Advance, Q6 Local True‐Up XXX XXX Cumulative Payments $454,758 $7,743,209 $8,197,967 1,051,439 Total Grant Amount [1] $8,093,765 $45,864,665 $53,958,430 32,600,000 Xxxxx Xxxxxx Remaining $7,639,006 $38,121,456 $45,760,463 * Pending DWR Approval31,548,561 11. Tracking Tables and Deliverables Table 11.1. Earned Value Report by Element TRLIA 200-Year Goldfields Levee Project Quarter 2 Report March 28, 2018 Table 11-1 on the following page, provides a summary of the costs expended to date, as compared to earned value.

Appears in 1 contract

Samples: cms9files1.revize.com

Draft better contracts in just 5 minutes Get the weekly Law Insider newsletter packed with expert videos, webinars, ebooks, and more!