Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 (October – December 2019) (reference the Quarter 7 report) as compared to the actual Costs for Quarter 9 (refer to SOC included with this report dated May 4, 2020). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 (October – December 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 9 [2] Difference between QTR and Actual Actual State Cost Share Retention on Actual State Cost Share (10%) True Up 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 Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 97,410 $ 134,874 $ (37,464) $ 114,643 $ 11,464 $ 103,179 $ 20,231 3 Design & ROW Support 85% $ 251,375 $ 398,271 $ (146,897) $ 338,530 $ 33,853 $ 304,677 $ 59,741 4 Environmental Review & Permitting 85% $ 99,891 $ 31,102 $ 68,789 $ 26,437 $ 2,644 $ 23,793 $ 4,665 5 ROW Acquisition 85% $ 1,379,122 $ 1,219,655 $ 159,466 N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 195,969 $ - $ 195,969 $ - $ - $ - $ - 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 2,023,767 $ 1,783,903 $ 239,864 $ 479,610 $ 47,961 $ 431,649 $ 84,637 [1] Projected costs for Quarter 9 (refer to QPR7) [2] Reference SOC dated May 4, 2020 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 (subject to DWR review) $108,513 Pending Quarter 7 Local Share (subject to DWR Review) $64,813 Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 Remaining Authorized Local Credit $324,945 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 10 Report May 11, 2020 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). 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 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-4 presents the requested State Share advance payments by Project element. Table 10-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost Element Description State Cost Share Projected Costs Quarter 12 State Share (85%) State Witholding on Advance (10%) Advance State Share Funding Requested Difference from Prior Advances [2] Remaning Advanced Request A B [1] D = B x A E = D x 10% F = D - E G H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 $ 67,374 $ 6,737 $ 60,636 $ 217,572 $ 278,209 3 Design & ROW Support 85% $ 265,815 $ 225,943 $ 22,594 $ 203,349 $ 1,000,451 $ 1,203,799 4 Environmental Review & Permitting 85% $ 161,981 $ 137,684 $ 13,768 $ 123,915 $ 53,436 $ 177,351 5 ROW Acquisition 85% $ 4,348,557 N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 $ 9,091,061 $ 909,106 $ 8,181,955 $ (5,034,657) $ 3,147,297 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 $ 9,522,061 $ 952,206 $ 8,569,855 $ (3,764,130) $ 4,805,725 [1] Covers period from 7/1/20 to 9/30/20 (Q12) [2] Refer to Table 10-2 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 onState Share of True Up Costs State Share of True Up Costs to be Immediately Payments 1 Grant Application $ - $ - $ - $ - $ - $ - $ - $ - 2 Program Management $ 134,874 $ 905,879 $ 1,040,753 $ 884,640 $ 88,464 $ 796,176 $ 578,604 $ 217,572 3 Design & ROW Support $ 398,271 $ 3,227,926 $ 3,626,197 $ 3,082,267 $ 308,227 $ 2,774,041 $ 1,773,590 $ 1,000,451 4 Environmental Review & Permitting $ 31,102 $ 559,875 $ 590,978 $ 502,331 $ 50,233 $ 452,098 $ 398,662 $ 53,436 5 ROW Acquisition $ 1,219,655 $ 1,212,264 $ 2,431,919 N/A N/A N/A $ - N/A 6 Construction, Mitigation, & Other Project $ - $ 50,000 $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ 5,072,907 $ (5,034,657) 7 Closeout Process $ - $ (1,218) $ (1,218) $ (1,035) $ (104) $ (932) $ - $ (932) $ 1,783,903 $ 5,954,726 $ 7,738,629 $ 4,510,703 $ 451,070 $ 4,059,633 $ 7,823,763 $ (3,764,130) [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 [3} Payments received through December 2019 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,390,803 $5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress $108,513 $0 $108,513 No Q9 Advance, Q6 Local True-Up *QPR8 12/20/2019 In Progress $64,813 $0 $64,813 No Q10 Advance, Q7 Local True-Up QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report $84,637 $4,805,725 $4,890,362 Q12 Advance, Q9 Local True-Up Cumulative Payments $812,773 $21,775,948 $22,588,721 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 Xxxxx Xxxxxx Remaining $10,616,406 $20,753,303 $31,369,709 * Pending DWR Approval Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 [1] QPR10 Total [2] Budget Remaining Budget 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $19,783 $19,783 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $43,324 $204,613 $278,209 $1,061,426 $1,773,417 $711,991 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $255,315 $815,819 $1,203,799 $3,793,208 $4,453,248 $660,040 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $19,257 $59,107 $177,351 $635,121 $1,024,641 $389,520 5 ROW Acquisition (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ $0 $0 $0 $0 $5,072,907 $8,067,636 $3,147,297 $16,287,840 $29,527,883 $13,240,043 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $75,429 $77,074 Total $1,051,439 $489,202 $674,423 $217,895 $5,390,803 $9,146,462 $4,805,725 $21,775,948 $42,529,251 $20,753,304 [1] Funding received through QPR9 [2] No Advance requested QPR4, QPR7, & QPR8
Appears in 1 contract
Samples: www.trlia.org
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 10 (October January – December 2019March 2020) (reference the Quarter 7 8 report) as compared to the actual Costs for Quarter 9 10 (refer to SOC included with this report dated May August 4, 2020). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 10 (October January – December 2019March 2020). 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 9 10 [2] Difference between QTR and Actual Actual State Cost Share Retention on Actual State Cost Share (10%) True Up 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 Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 97,410 89,872 $ 134,874 169,849 $ (37,46479,977) $ 114,643 144,372 $ 11,464 14,437 $ 103,179 129,935 $ 20,231 25,477 3 Design & ROW Support 85% $ 251,375 152,639 $ 398,271 141,051 $ (146,897) 11,589 $ 338,530 119,893 $ 33,853 11,989 $ 304,677 107,904 $ 59,741 21,158 4 Environmental Review & Permitting 85% $ 99,891 24,828 $ 31,102 31,109 $ 68,789 (6,281) $ 26,437 26,442 $ 2,644 $ 23,793 23,798 $ 4,665 4,666 5 ROW Acquisition 85% $ 1,379,122 $ 1,219,655 $ 159,466 - N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 195,969 282,535 $ - 202,894 $ 195,969 79,640 $ - 172,460 $ - 17,246 $ - 155,214 $ - 30,434 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 2,023,767 549,874 $ 1,783,903 544,903 $ 239,864 4,971 $ 479,610 463,167 $ 47,961 46,317 $ 431,649 416,851 $ 84,637 81,735 [1] Projected costs for Quarter 9 10 (refer to QPR7QPR8) [2] Reference SOC dated May August 4, 2020 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 Quarter 6 local share Paid by State $107,683 Quarter 7 local share Paid by State $64,827 Quarter 8 local share Paid by State $100,052 Quarter 9 local share Paid by State $84,531 Pending Quarter 6 10 Local (subject Share Subject to DWR review) Review $108,513 Pending Quarter 7 Local Share (subject to DWR Review) $64,813 Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 81,735 Remaining Authorized Local Credit $324,945 244,132 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 10 11 Report May 11September 4, 2020 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). 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 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-4 presents the requested State Share advance payments by Project element. Table 10-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost Element Description State Cost Share Advance State Projected Costs Projected Costs State Witholding Share Funding Quarter 12 13 Quarter 14 State Share (85%) State Witholding on Advance (10%) Advance State Share Funding Requested Difference from Prior Advances [2] Remaning Advanced Request A B [1] C D = B x A E = D x 10% F = D - E G H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 147,644 $ 67,374 - $ 6,737 125,497 $ 60,636 12,550 $ 217,572 $ 278,209 112,948 3 Design & ROW Support 85% $ 265,815 292,715 $ 225,943 - $ 22,594 248,808 $ 203,349 24,881 $ 1,000,451 $ 1,203,799 223,927 4 Environmental Review & Permitting 85% $ 161,981 199,496 $ 137,684 - $ 13,768 169,572 $ 123,915 16,957 $ 53,436 $ 177,351 152,615 5 ROW Acquisition 85% $ 4,348,557 N/A N/A 863,237 $ - N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 2,635,571 $ 9,091,061 - $ 909,106 2,240,236 $ 8,181,955 224,024 $ (5,034,657) $ 3,147,297 2,016,212 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 $ 9,522,061 $ 952,206 $ 8,569,855 $ (3,764,130) $ 4,805,725 - [1] Covers period from 7/1/20 10/1/20 to 9/30/20 12/31/20 (Q12Q13) [2] Refer to Table 10-2 $ 4,138,663 $ - $ 2,784,112 $ 278,411 $ 2,505,701 Table 10-1. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding Retention on State Share of State Share of True Up Costs to Description True Up Costs QTR 10 [1] True Up Cost QTR 1-9 [2] Total True Up State Share of Retention onState Share of True Up Costs State Share of True Up Costs to True Up Costs (10%) be Immediately Payments 1 Funded A B C = A + B D = 0.85 * C E = D x 10% F = D - E Grant Application $ - $ - $ - $ - $ - $ - $ - $ - 2 Program Management $ 134,874 169,849 $ 905,879 1,035,527 $ 1,040,753 1,205,376 $ 884,640 1,024,569 $ 88,464 102,457 $ 796,176 $ 578,604 $ 217,572 3 922,112 Design & ROW Support $ 398,271 141,051 $ 3,227,926 3,626,112 $ 3,626,197 3,767,163 $ 3,082,267 3,202,088 $ 308,227 320,209 $ 2,774,041 $ 1,773,590 $ 1,000,451 4 2,881,879 Environmental Review & Permitting $ 31,102 31,109 $ 559,875 588,919 $ 590,978 620,028 $ 502,331 527,024 $ 50,233 52,702 $ 452,098 $ 398,662 $ 53,436 5 474,321 ROW Acquisition $ 1,219,655 $ 1,212,264 $ 2,431,919 N/A N/A N/A $ - N/A 6 N/A N/A Construction, Mitigation, & Other Project $ - 202,894 $ 50,000 $ 50,000 252,894 $ 42,500 214,960 $ 4,250 21,496 $ 38,250 $ 5,072,907 $ (5,034,657) 7 193,464 Closeout Process $ - $ (1,218) 3 $ (1,218) 3 $ (1,035) 3 $ (104) 0 $ (932) 2 $ - 544,903 $ (932) 5,300,561 $ 1,783,903 5,845,464 $ 5,954,726 4,968,644 $ 7,738,629 496,864 $ 4,510,703 $ 451,070 $ 4,059,633 $ 7,823,763 $ (3,764,130) 4,471,780 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 [3} Payments received through December 2019 9 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,390,803 $5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress 7/6/2020 $108,513 107,683 $0 $108,513 107,683 No Q9 Advance, Q6 Local True-Up *QPR8 12/20/2019 In Progress 7/6/2020 $64,813 64,827 $0 $64,813 64,827 No Q10 Advance, Q7 Local True-Up QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report 7/30/2020 $84,637 84,531 $4,805,725 $4,890,362 4,890,256 Q12 Advance, Q9 Local True-Up *QPR11 8/3/2020 This Report $81,735 $2,505,701 $2,587,436 Q13 Advance, Q10 Local True-Up Cumulative Payments $812,773 893,586 $21,775,948 24,281,649 $22,588,721 25,175,235 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 Xxxxx Xxxxxx Remaining $10,616,406 10,535,593 $20,753,303 18,247,602 $31,369,709 28,783,195 * Pending DWR Approval Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 [1] QPR10 Total [2] Budget Remaining Budget 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $19,783 $19,783 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $43,324 $204,613 $278,209 $1,061,426 $1,773,417 $711,991 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $255,315 $815,819 $1,203,799 $3,793,208 $4,453,248 $660,040 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $19,257 $59,107 $177,351 $635,121 $1,024,641 $389,520 5 ROW Acquisition (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ A $0 $0 $0 $0 $5,072,907 $8,067,636 8,066,923 $3,147,297 3,146,365 $16,287,840 16,286,196 $29,527,883 $13,240,043 13,241,687 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $0 $0 $0 $75,429 $77,074 75,429 Total $1,051,439 $489,202 $674,423 $217,895 $5,390,803 $9,146,462 $4,805,725 $21,775,948 $42,529,251 $20,753,304 [1] Funding received through QPR9 QPR10 [2] No Advance requested QPR4, QPR7, & QPR8
Appears in 1 contract
Samples: cms9files1.revize.com
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 8 (October July – December September 2019) (reference the Quarter 7 6 report) as compared to the actual Costs for Quarter 9 8 (refer to SOC included with this report dated May 4February 12, 20202019). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 8 (October July – December September 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 9 8 [2] Difference between QTR and Actual Actual State Cost Share Retention on Actual onActual State Cost Share (10%) True Up 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 Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 97,410 100,864 $ 134,874 154,521 $ (37,46453,658) $ 114,643 131,343 $ 11,464 13,134 $ 103,179 118,209 $ 20,231 23,178 3 Design & ROW Support 85% $ 251,375 268,941 $ 398,271 484,312 $ (146,897215,372) $ 338,530 411,666 $ 33,853 41,167 $ 304,677 370,499 $ 59,741 72,647 4 Environmental Review & Permitting 85% $ 99,891 79,652 $ 31,102 28,180 $ 68,789 51,472 $ 26,437 23,953 $ 2,644 2,395 $ 23,793 21,558 $ 4,665 4,227 5 ROW Acquisition 85% $ 1,379,122 4,694,419 $ 1,219,655 949,827 $ 159,466 3,744,592 N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 195,969 6,631,250 $ - $ 195,969 6,631,250 $ - $ - $ - $ - 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 2,023,767 11,775,126 $ 1,783,903 1,616,841 $ 239,864 10,158,285 $ 479,610 566,962 $ 47,961 56,696 $ 431,649 510,266 $ 84,637 100,052 [1] Projected costs for Quarter 9 8 (refer to QPR7QPR6) [2] Reference SOC dated May 4February 12, 2020 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 local share (subject to DWR reviewReview) $108,513 Pending Quarter 7 Local Share (subject to DWR Review) $64,813 Pending Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 100,052 Remaining Authorized Local Credit $324,945 409,582 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 10 9 (Oct – Dec 2019) Report May 11February 14, 2020 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). 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. (N/A this quarter) 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-4 presents the requested State Share advance payments by Project element. Table 10-2. TRLIA - 200-Year Goldfields Levee Project: 12th 8th Quarter Projected Cost Element Description State Cost Share Projected Costs Quarter 12 11 State Share (85%) State Witholding on Advance (10%) Advance State Share Funding Requested Difference from Prior Advances [2] Remaning Advanced Request A B [1] D = B x A E = D x 10% F = D - E G H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 166,736 $ 67,374 141,725 $ 6,737 14,173 $ 60,636 127,553 $ 217,572 139,916 $ 278,209 267,469 3 Design & ROW Support 85% $ 265,815 427,495 $ 225,943 363,371 $ 22,594 36,337 $ 203,349 327,034 $ 1,000,451 739,396 $ 1,203,799 1,066,429 4 Environmental Review & Permitting 85% $ 161,981 47,338 $ 137,684 40,237 $ 13,768 4,024 $ 123,915 36,213 $ 53,436 41,051 $ 177,351 77,265 5 ROW Acquisition 85% $ 4,348,557 2,025,876 N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 20,366,778 $ 9,091,061 17,311,762 $ 909,106 1,731,176 $ 8,181,955 15,580,585 $ (5,034,6575,034,656) $ 3,147,297 10,545,929 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 23,034,224 $ 9,522,061 17,857,095 $ 952,206 1,785,710 $ 8,569,855 16,071,386 $ (3,764,1304,115,226) $ 4,805,725 11,956,160 [1] Covers period from 7/1/20 4/1/20 to 9/30/20 7/31/20 (Q12Q11) [2] Refer to Table 10-2 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 onState on State Share of True Up Costs State Share of True Up Costs to be Immediately Payments Element Description QTR 8 [1] QTR 1-7 [2] True Up Costs (10%) Funded Received [3] True Up Funding A B D = 0.85 * C E = D x 10% F = D - E G H = F - G 1 Grant Application $ - $ - $ - $ - $ - $ - $ - $ - 2 Program Management $ 134,874 154,521 $ 905,879 751,358 $ 1,040,753 769,997 $ 884,640 77,000 $ 88,464 692,998 $ 796,176 553,082 $ 578,604 $ 217,572 139,916 3 Design & ROW Support $ 398,271 484,312 $ 3,227,926 2,743,613 $ 3,626,197 2,743,737 $ 3,082,267 274,374 $ 308,227 2,469,363 $ 2,774,041 1,729,968 $ 1,773,590 $ 1,000,451 739,396 4 Environmental Review & Permitting $ 31,102 28,180 $ 559,875 531,695 $ 590,978 475,894 $ 502,331 47,589 $ 50,233 428,305 $ 452,098 387,253 $ 398,662 $ 53,436 41,051 5 ROW Acquisition $ 1,219,655 949,827 $ 1,212,264 $ 2,431,919 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 $ 5,072,907 5,072,906 $ (5,034,6575,034,656) 7 Closeout Process $ - $ (1,218) $ (1,218) $ (1,035) $ (104) $ (932) $ - $ (932) $ 1,783,903 1,616,841 $ 5,954,726 4,337,886 $ 7,738,629 4,031,093 $ 4,510,703 403,109 $ 451,070 3,627,984 $ 4,059,633 $ 7,823,763 7,743,209 $ (3,764,1304,115,226) [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 7 [3} Payments received through December September 2019 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,390,803 5,310,251 $5,471,354 5,390,802 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress $108,513 107,775 $0 $108,513 107,775 No Q9 Advance, Q6 Local True-Up *QPR8 12/20/2019 In Progress $64,813 $0 $64,813 No Q10 Advance, Q7 Local True-Up *QPR9 2/7/2020 5/4/2020 This Report $100,052 $9,146,462 11,956,160 $9,246,514 12,056,212 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report $84,637 $4,805,725 $4,890,362 Q12 Advance, Q9 Local True-Up Cumulative Payments $812,773 727,398 $21,775,948 19,699,368 $22,588,721 20,426,767 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 Xxxxx Xxxxxx Remaining $10,616,406 10,701,781 $20,753,303 22,829,883 $31,369,709 33,531,663 * Pending DWR Approval Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 [1] QPR10 Total [2] Budget Remaining Budget 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $19,783 $19,783 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $43,324 $204,613 $278,209 $1,061,426 $1,773,417 $711,991 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $255,315 $815,819 $1,203,799 $3,793,208 $4,453,248 $660,040 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $19,257 $59,107 $177,351 $635,121 $1,024,641 $389,520 5 ROW Acquisition (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ $0 $0 $0 $0 $5,072,907 $8,067,636 $3,147,297 $16,287,840 $29,527,883 $13,240,043 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $75,429 $77,074 Total $1,051,439 $489,202 $674,423 $217,895 $5,390,803 $9,146,462 $4,805,725 $21,775,948 $42,529,251 $20,753,304 [1] Funding received through QPR9 [2] No Advance requested QPR4, QPR7, & QPR8Approval
Appears in 1 contract
Samples: www.trlia.org
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 (October – December 2019) (reference the Quarter 7 report) as compared to the actual Costs for the Quarter 9 (refer to SOC SOC’s included with this report dated May 413, 20202022). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 (October – December 2019)the prior quarter. Table 9-2 provides For a reconciliation of the approved credit and approved and projected credit payments, refer to QPR13. As of QPR13 the authorized initial and supplemental credit of $1,137,718 in state dollars has been complete. TRLIA 200-Year Goldfields Levee Project Quarter 19 Report May 2022 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 9 [2] Difference between QTR and Actual the Request Actual State Cost Share Retention on Actual State Cost Share (10%) True Up 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 Application 85% $ - ‐ $ - ‐ $ - ‐ $ - ‐ $ - $ - $ - ‐ 2 Program Management 85% $ 97,410 793,015 $ 134,874 674,062 $ (37,464) 67,406 $ 114,643 606,656 $ 11,464 $ 103,179 $ 20,231 118,952 3 Design & ROW Support 85% $ 251,375 3,711 $ 398,271 3,154 $ (146,897) 315 $ 338,530 2,839 $ 33,853 $ 304,677 $ 59,741 557 4 Environmental Review & Permitting 85% $ 99,891 4,327 $ 31,102 3,678 $ 68,789 368 $ 26,437 3,310 $ 2,644 $ 23,793 $ 4,665 649 5 ROW Acquisition 85% $ 1,379,122 $ 1,219,655 $ 159,466 N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project Aspects 85% $ 195,969 601,673 $ - 511,422 $ 195,969 51,142 $ - 460,280 $ - $ - $ - 90,251 7 Closeout Process 85% $ - ‐ $ - ‐ $ - ‐ $ - ‐ $ - ‐ 8 500‐Year Project 85% $ - 516,698 $ - 439,194 $ 2,023,767 43,919 $ 1,783,903 395,274 $ 239,864 77,505 $ 479,610 1,919,424 $ 47,961 1,631,510 $ 431,649 163,151 $ 84,637 1,468,359 $ 287,914 [1] Projected costs for Quarter 9 (refer to QPR7) [2] Reference the 19 QPR SOC dated May 413, 2020 2022 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 (subject to DWR review) $108,513 Pending Quarter 7 Local Share (subject to DWR Review) $64,813 Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 Remaining Authorized Local Credit $324,945 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 10 19 Report May 11, 2020 2022 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)retention held to date. 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 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-4 presents the requested State Share advance payments by Project elementelement as well as retention held. In addition, in letter dated February 21, 2022, TRLIA requested the outstanding local share of $854,774 for real estate, which includes relocation costs previously requested. Table 10-1. TRLIA - 200-Year Goldfields Levee Project: Held Retention Element Description True Up Costs This Request [1] True Up Cost QTR 1‐18 [2] Total True Up Costs State Share of True Up Costs A B C = A + B D = 0.85 * C 1 Grant Application $ ‐ $ ‐ $ ‐ $ ‐ 2 Program Management $ 793,015 $ 2,551,821 $ 3,344,836 $ 2,843,110 3 Design & ROW Support $ 3,711 $ 4,113,190 $ 4,116,900 $ 3,499,365 4 Environmental Review & Permitting $ 4,327 $ 972,464 $ 976,791 $ 830,273 5 ROW Acquisition N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project Aspects $ 601,673 $ 23,740,409 $ 24,342,082 $ 20,690,770 7 Closeout Process $ ‐ $ ‐ $ ‐ $ ‐ 8 500‐Year Project $ 516,698 $ 858,713 $ 1,375,411 $ 1,169,100 $ 1,919,424 $ 32,236,597 $ 34,156,021 $ 29,032,618 [1] Reference Table 9‐1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1‐18 Table 10-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost True-Up Funding Element Description State Total True Up Costs This Request [1] A True Up Cost Share Projected Costs Quarter 12 State Share (85%) State Witholding on Advance (10%) Advance State Share Funding Requested Difference from Prior Advances QTR 1‐18 [2] Remaning Advanced Request A B [1] Initial & Supplemental Costs C Total Costs to Date D = A + B x A + C State Share of True Up Costs E = 0.85 * D x 10% DWR Payments Received to Date E True‐Up Funding Due F = D - ‐ E G H = G + F 1 Grant Application 85% $ - ‐ $ - ‐ $ - 25,040 $ - 25,040 $ - 21,284 $ - 21,284 $ ‐ 2 Program Management 85% $ 79,263 793,015 $ 67,374 2,551,821 $ 6,737 276,517 $ 60,636 3,621,353 $ 217,572 3,078,150 $ 278,209 1,773,891 $ 1,304,258 3 Design & ROW Support 85% $ 265,815 3,711 $ 225,943 4,113,190 $ 22,594 673,429 $ 203,349 4,790,329 $ 1,000,451 4,071,780 $ 1,203,799 4,566,347 $ (494,567) 4 Environmental Review & Permitting 85% $ 161,981 4,327 $ 137,684 972,464 $ 13,768 363,506 $ 123,915 1,340,297 $ 53,436 1,139,252 $ 177,351 1,265,308 $ (126,056) 5 ROW Acquisition 85% $ 4,348,557 N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% Aspects $ 10,695,365 601,673 $ 9,091,061 23,740,409 $ 909,106 ‐ $ 8,181,955 24,342,082 $ 20,690,770 $ 21,555,854 $ (5,034,657) $ 3,147,297 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 $ 9,522,061 $ 952,206 $ 8,569,855 $ (3,764,130) $ 4,805,725 [1] Covers period from 7/1/20 to 9/30/20 (Q12) [2] Refer to Table 10-2 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 onState Share of True Up Costs State Share of True Up Costs to be Immediately Payments 1 Grant Application $ - $ - $ - $ - $ - $ - $ - $ - 2 Program Management $ 134,874 $ 905,879 $ 1,040,753 $ 884,640 $ 88,464 $ 796,176 $ 578,604 $ 217,572 3 Design & ROW Support $ 398,271 $ 3,227,926 $ 3,626,197 $ 3,082,267 $ 308,227 $ 2,774,041 $ 1,773,590 $ 1,000,451 4 Environmental Review & Permitting $ 31,102 $ 559,875 $ 590,978 $ 502,331 $ 50,233 $ 452,098 $ 398,662 $ 53,436 5 ROW Acquisition $ 1,219,655 $ 1,212,264 $ 2,431,919 N/A N/A N/A $ - N/A 6 Construction, Mitigation, & Other Project $ - $ 50,000 $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ 5,072,907 $ (5,034,657865,084) 7 Closeout Process $ - ‐ $ (1,218) ‐ $ (1,218) ‐ $ (1,035) ‐ $ (104) ‐ $ (932) ‐ $ - ‐ 8 500‐Year Project $ (932) 516,698 $ 1,783,903 858,713 $ 5,954,726 ‐ $ 7,738,629 1,375,411 $ 4,510,703 1,169,100 $ 451,070 ‐ $ 4,059,633 1,169,100 $ 7,823,763 1,919,424 $ (3,764,130) 32,236,597 $ 1,338,491 $ 35,494,512 $ 30,170,335 $ 29,182,684 $ 987,652 [1] Reference Table 9-19‐1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 [3} Payments received through December 2019 QTR 1‐18 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 122,466 $217,895 216,715 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,310,252 $5,390,803 $5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress 7/6/2020 $108,513 107,683 $0 $108,513 No Q9 Advance, Q6 Local True-Up *107,683 QPR8 12/20/2019 In Progress 7/6/2020 $64,813 64,826 $0 $64,813 No Q10 Advance, Q7 Local True-Up 64,826 QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report 7/30/2020 $84,637 84,531 $4,805,725 $4,890,362 Q12 Advance, Q9 Local True-Up 4,890,256 QPR11 8/3/2020 10/30/2020 $81,302 $2,505,701 $2,587,003 QPR12 11/9/2020 12/28/2020 $225,741 $2,991,600 $3,217,341 QPR13 2/16/2021 4/2/2021 $17,644 $0 $17,644 QPR14‐18 6/9/2021 ‐ 3/14/2022 None Due $0 $0 $0 Ag Mitigation 2/2/2022 2/17/2022 $0 $853,449 $853,449 QPR18 This Report In Progress $0 $888,886 $888,886 Cumulative Payments [1] Subject to DWR Review $812,773 1,137,718 $21,775,948 28,933,853 $22,588,721 30,071,571 State Payments Received Less ROW $30,071,571 Spent to Date Less ROW $30,170,335 Current $ Held In Retention $98,765 Real Estate Payments Received $6,514,716 Total Payments Received $36,586,287 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 [1] Xxxxx Xxxxxx Remaining $10,616,406 $20,753,303 $31,369,709 * Pending DWR Approval 5,942,965 Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 [1] QPR10 Total QPR11 QPR12 Ag Mitig [2] Budget Remaining Budget Advance Payments Received Init & Supp Credit [2] Total Received 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $19,783 0 $19,783 0 $0 $21,284 $21,284 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $43,324 17,802 $204,613 $278,209 $1,061,426 112,948 $1,773,417 390,000 $711,991 0 $1,538,852 $235,039 $1,773,891 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 ‐$50,046 $255,315 211,693 $815,819 $1,203,799 $3,793,208 223,927 $4,453,248 21,600 $660,040 0 $3,993,932 $572,415 $4,566,347 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $19,257 7,850 $59,107 $177,351 $635,121 152,615 $1,024,641 180,000 $389,520 0 $956,328 $308,980 $1,265,308 5 ROW Acquisition (Post Add to SPFC) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A $6,514,716 6 Construction, Mitigation, & Other Project A $0 $0 $0 $0 $5,072,906 $8,066,923 $3,146,365 $2,016,212 $2,400,000 $853,449 $21,555,856 $0 $21,555,856 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ 0 $0 $0 $0 $0 $5,072,907 $8,067,636 $3,147,297 $16,287,840 $29,527,883 $13,240,043 7 Closeout Process (Post Add to SPFC) 8 500‐Year Project $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $75,429 0 $77,074 0 $0 $0 $0 $0 $0 Total $1,051,439 $489,202 $674,423 $217,895 216,715 $5,390,803 5,310,251 $9,146,462 $4,805,725 $21,775,948 2,505,701 $42,529,251 2,991,600 $20,753,304 853,449 $28,044,967 $1,137,718 $35,697,400 [1] Advanced Funding received through QPR9 to Date [2] No Advance requested QPR4, QPR7, Authorized Initial & QPR8Supplemental Credit complete as of QPR13
Appears in 1 contract
Samples: cms9files1.revize.com
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 11 (October April – December 2019June 2020) (reference the Quarter 7 9 report) as compared to the actual Costs for Quarter 9 11 (refer to SOC included with this report dated May 4November 23, 2020). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 11 (October April – December 2019June 2020). 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 9 11 [2] Difference between QTR and Actual Actual State Cost Share Retention on Actual State Cost Share (10%) True Up 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 Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 97,410 166,736 $ 134,874 188,450 $ (37,46421,715) $ 114,643 160,183 $ 11,464 16,018 $ 103,179 144,164 $ 20,231 28,268 3 Design & ROW Support 85% $ 251,375 427,495 $ 398,271 120,646 $ (146,897) 306,850 $ 338,530 102,549 $ 33,853 10,255 $ 304,677 92,294 $ 59,741 18,097 4 Environmental Review & Permitting 85% $ 99,891 47,338 $ 31,102 134,704 $ 68,789 (87,366) $ 26,437 114,498 $ 2,644 11,450 $ 23,793 103,049 $ 4,665 20,206 5 ROW Acquisition 85% $ 1,379,122 $ 1,219,655 $ 159,466 N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 195,969 20,366,778 $ - 1,061,531 $ 195,969 19,305,247 $ - 902,301 $ - 90,230 $ - 812,071 $ - 159,230 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 2,023,767 21,008,347 $ 1,783,903 1,505,331 $ 239,864 19,503,016 $ 479,610 1,279,531 $ 47,961 127,953 $ 431,649 1,151,578 $ 84,637 225,800 [1] Projected costs for Quarter 9 11 (refer to QPR7QPR9) [2] Reference SOC dated May 4November 18, 2020 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 Quarter 6 local share Paid by State $107,683 Quarter 7 local share Paid by State $64,827 Quarter 8 local share Paid by State $100,052 Quarter 9 local share Paid by State $84,531 Quarter 10 Local share Paid by State $81,302 Pending Quarter 6 Local (subject to DWR review) $108,513 Pending Quarter 7 11 Local Share (subject to DWR Review) $64,813 Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 225,800 Remaining Authorized Local Credit $324,945 18,765 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 10 12 Report May 11, November 2020 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). 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 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-4 presents the requested State Share advance payments by Project elementelement as well as retention held on advances. Table 10-21. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost Advance State Element Description State Cost Share Projected Costs Quarter 12 14 State Share (85%) State Witholding on Advance (10%) Advance State Share Funding Requested Difference from Prior Advances [2] Remaning Advanced Request A B [1] D = B x A E = D x 10% F = D - E G H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 509,804 $ 67,374 433,333 $ 6,737 43,333 $ 60,636 $ 217,572 $ 278,209 390,000 3 Design & ROW Support 85% $ 265,815 28,235 $ 225,943 24,000 $ 22,594 2,400 $ 203,349 $ 1,000,451 $ 1,203,799 21,600 4 Environmental Review & Permitting 85% $ 161,981 235,294 $ 137,684 200,000 $ 13,768 20,000 $ 123,915 $ 53,436 $ 177,351 180,000 5 ROW Acquisition 85% $ 4,348,557 150,000 N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 3,137,255 $ 2,666,667 $ 266,667 $ 2,400,000 7 Closeout Process 85% $ - $ - $ - $ - [1] Covers period from 1/1/21 to 3/31/21 (Q14) $ 4,060,588 $ 3,324,000 $ 332,400 $ 2,991,600 [2] Refer to Table 10-2 Table 10-2. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding True Up Costs True Up Cost State Share of Retention on State Share of True Up Costs State Share of True Up Costs to be Immediately Element Description QTR 11 [1] QTR 1-10 [2] True Up Costs (10%) Funded A B D = 0.85 * C E = D x 10% F = D - E 1 Grant Application $ - $ - $ - $ - $ - 2 Program Management $ 188,450 $ 1,205,066 $ 1,184,489 $ 118,449 $ 1,066,040 3 Design & ROW Support $ 120,646 $ 3,764,583 $ 3,302,444 $ 330,244 $ 2,972,200 4 Environmental Review & Permitting $ 134,704 $ 620,028 $ 641,522 $ 64,152 $ 577,370 5 ROW Acquisition N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 1,061,531 $ 9,091,061 252,894 $ 909,106 1,117,262 $ 8,181,955 111,726 $ (5,034,657) $ 3,147,297 1,005,535 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 $ 9,522,061 $ 952,206 $ 8,569,855 $ (3,764,130) $ 4,805,725 [1] Covers period from 7/1/20 to 9/30/20 (Q12) [2] Refer to Table 10-2 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 onState Share of True Up Costs State Share of True Up Costs to be Immediately Payments 1 Grant Application $ - $ - $ - $ - $ - $ - 1,505,331 $ - 5,842,571 $ - 2 Program Management 6,245,717 $ 134,874 624,572 $ 905,879 $ 1,040,753 $ 884,640 $ 88,464 $ 796,176 $ 578,604 $ 217,572 3 Design & ROW Support $ 398,271 $ 3,227,926 $ 3,626,197 $ 3,082,267 $ 308,227 $ 2,774,041 $ 1,773,590 $ 1,000,451 4 Environmental Review & Permitting $ 31,102 $ 559,875 $ 590,978 $ 502,331 $ 50,233 $ 452,098 $ 398,662 $ 53,436 5 ROW Acquisition $ 1,219,655 $ 1,212,264 $ 2,431,919 N/A N/A N/A $ - N/A 6 Construction, Mitigation, & Other Project $ - $ 50,000 $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ 5,072,907 $ (5,034,657) 7 Closeout Process $ - $ (1,218) $ (1,218) $ (1,035) $ (104) $ (932) $ - $ (932) $ 1,783,903 $ 5,954,726 $ 7,738,629 $ 4,510,703 $ 451,070 $ 4,059,633 $ 7,823,763 $ (3,764,130) 5,621,145 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 [3} Payments received through December 2019 10 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes Init. 10/23/2017 2/14/2018 $0 $575,808 $575,808 Initial Credit Request Supp. 3/29/2018 9/4/2018 $0 $561,910 $561,910 Supplemental Credit Request QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,390,803 $5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress 7/6/2020 $108,513 107,683 $0 $108,513 107,683 No Q9 Advance, Q6 Local True-Up *QPR8 12/20/2019 In Progress 7/6/2020 $64,813 64,827 $0 $64,813 64,827 No Q10 Advance, Q7 Local True-Up QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report 7/30/2020 $84,637 84,531 $4,805,725 $4,890,362 4,890,256 Q12 Advance, Q9 Local True-Up *QPR11 8/3/2020 In progress $81,302 $2,505,701 $2,587,003 Q13 Advance, Q10 Local True-Up *QPR12 11/9/2020 This Report $225,800 $2,991,600 $3,217,400 Q14 Advance, Q11 Local True-Up Cumulative Payments $812,773 1,118,952 $21,775,948 28,410,966 $22,588,721 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 Xxxxx Xxxxxx Remaining $10,616,406 $20,753,303 $31,369,709 29,529,919 * Pending DWR Approval Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description Init. Cred Suppl. Cred QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 QPR10 [1] QPR10 Total QPR11 QPR12 [2] Budget Remaining Total Retention Held [3] Budget 1 Grant Application $21,284 $0 $0 $0 $0 $0 $0 $0 $0 $19,783 0 $0 $21,284 $0 $19,783 2 Program Management @80.72% $112,735 $122,304 $185,425 $59,006 $158,002 $132,847 $43,324 $204,613 $278,209 $1,061,426 112,948 $390,000 $1,799,413 $173,819 $1,773,417 $711,991 3 Design & ROW Support $265,271 $307,144 $704,079 $384,609 $478,453 -$48,866 $255,315 $815,819 $1,203,799 $3,793,208 223,927 $21,600 $4,611,149 $448,748 $4,453,248 $660,040 4 Envrionmental Review & Permitting $176,518 $132,461 $161,935 $45,587 $37,969 $133,914 $19,257 $59,107 $177,351 $635,121 152,615 $180,000 $1,276,715 $107,526 $1,024,641 $389,520 5 ROW Acquisition (Post Add to SPFC) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A $5,654,849 6 Construction, Mitigation, & Other Project A $0 $0 $0 $0 $0 $0 $5,072,907 $8,066,923 $3,146,365 $2,016,212 $2,400,000 $20,702,408 $2,300,268 $29,527,883 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ 0 $0 $0 $0 $0 $5,072,907 75,429 Total $8,067,636 575,808 $3,147,297 $16,287,840 $29,527,883 $13,240,043 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $75,429 $77,074 Total 561,910 $1,051,439 $489,202 $674,423 $217,895 $5,390,803 $9,146,462 $4,805,725 $21,775,948 2,505,701 $2,991,600 $28,410,967 $3,030,359 $42,529,251 $20,753,304 [1] Funding received through QPR9 QPR10 [2] No Pending DWR Review [3] Retention held on Advance requested QPR4, QPR7, & QPR8Request QPR1 - QPR12
Appears in 1 contract
Samples: www.trlia.org
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 14 (October January – December 2019March 2021) (reference the Quarter 7 12 report) as compared to the actual Costs for Quarter 9 14 (refer to SOC included with this report dated May 4July 26, 20202021). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 14 (October January – December 2019March 2021). 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 9 14 [2] Difference between QTR and Actual Actual State Cost Share Retention on Actual State Cost Share (10%) True Up 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 Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 97,410 509,804 $ 134,874 240,179 $ (37,464) 269,625 $ 114,643 204,152 $ 11,464 20,415 $ 103,179 183,737 $ 20,231 36,027 3 Design & ROW Support 85% $ 251,375 28,235 $ 398,271 1,984 $ (146,897) 26,252 $ 338,530 1,686 $ 33,853 169 $ 304,677 1,518 $ 59,741 298 4 Environmental Review & Permitting 85% $ 99,891 235,294 $ 31,102 5,785 $ 68,789 229,509 $ 26,437 4,917 $ 2,644 492 $ 23,793 4,426 $ 4,665 868 5 ROW Acquisition 85% $ 1,379,122 $ 1,219,655 $ 159,466 N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 195,969 3,137,255 $ - 3,065,125 $ 195,969 72,130 $ - 2,605,356 $ - 260,536 $ - 2,344,821 $ - 459,769 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 2,023,767 3,910,588 $ 1,783,903 3,313,072 $ 239,864 597,516 $ 479,610 2,816,111 $ 47,961 281,611 $ 431,649 2,534,500 $ 84,637 496,961 [1] Projected costs for Quarter 9 14 (refer to QPR7QPR12) [2] Reference SOC dated May 4July 26, 2020 2021 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 122,466 Quarter 5 local share Paid by State $80,551 Quarter 6 local share Paid by State $107,683 Quarter 7 local share Paid by State $64,826 Quarter 8 local share Paid by State $100,052 Quarter 9 local share Paid by State $84,531 Quarter 10 Local share Paid by State $81,302 Quarter 11 Local share Paid by State $225,741 Pending Quarter 6 Local (subject to DWR review) $108,513 Pending Quarter 7 12 Local Share (subject to DWR Review) be Paid by State $64,813 Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 17,644 Remaining Authorized Local Credit $324,945 0 10. Payment Requested and State Disbursements Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 10 15 Report May 11August 4, 2020 2021 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). No advance this quarter, table not included. 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 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-4 presents the requested State Share advance payments by Project elementelement as well as retention held on advances. Table 10-2. TRLIA - 200-Year Goldfields Levee Project: 12th 17th Quarter Projected Cost Element Description State Cost Share Projected Costs No Advance this Quarter 12 State Share (85%) State Witholding on Advance (10%) Advance State Share Funding Requested Difference from Prior Advances [2] Remaning Advanced Request A B [1] D = B x A E = D x 10% F = D - E G H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 $ 67,374 $ 6,737 $ 60,636 $ 217,572 $ 278,209 3 Design & ROW Support 85% $ 265,815 $ 225,943 $ 22,594 $ 203,349 $ 1,000,451 $ 1,203,799 4 Environmental Review & Permitting 85% $ 161,981 $ 137,684 $ 13,768 $ 123,915 $ 53,436 $ 177,351 5 ROW Acquisition 85% $ 4,348,557 N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 $ 9,091,061 $ 909,106 $ 8,181,955 $ (5,034,657) $ 3,147,297 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 $ 9,522,061 $ 952,206 $ 8,569,855 $ (3,764,130) $ 4,805,725 [1] Covers period from 7/1/20 to 9/30/20 (Q12) [2] Refer to Table 10-2 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 onState Share of True Up Costs on State Share of True Up Costs to be Immediately Payments Element Description QTR 14 [1] QTR 1-13 [2] Costs True Up Costs (10%) A B C = A + B D = 0.85 * C E = D x 10% 1 Grant Application $ - $ - $ - $ - $ - $ - $ - $ - 2 Program Management $ 134,874 240,179 $ 905,879 1,824,390 $ 1,040,753 2,064,569 $ 884,640 1,754,883 $ 88,464 $ 796,176 $ 578,604 $ 217,572 175,488 3 Design & ROW Support $ 398,271 1,984 $ 3,227,926 4,062,511 $ 3,626,197 4,064,495 $ 3,082,267 3,454,821 $ 308,227 $ 2,774,041 $ 1,773,590 $ 1,000,451 345,482 4 Environmental Review & Permitting $ 31,102 5,785 $ 559,875 947,601 $ 590,978 953,386 $ 502,331 810,378 $ 50,233 $ 452,098 $ 398,662 $ 53,436 81,038 5 ROW Acquisition $ 1,219,655 $ 1,212,264 $ 2,431,919 N/A N/A N/A $ - N/A N/A 6 Construction, Mitigation, & Other Project $ - 3,065,125 $ 50,000 14,028,522 $ 50,000 17,093,647 $ 42,500 14,529,600 $ 4,250 $ 38,250 $ 5,072,907 $ (5,034,657) 1,452,960 7 Closeout Process $ - $ (1,218) $ (1,218) $ (1,035) $ (104) $ (932) - $ - $ (932) - $ 1,783,903 - $ 5,954,726 3,313,072 $ 7,738,629 20,863,024 $ 4,510,703 24,176,096 $ 451,070 20,549,682 $ 4,059,633 $ 7,823,763 $ (3,764,130) 2,054,968 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 [3} Payments received through December 2019 13 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 122,466 $217,895 216,715 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,310,252 $5,390,803 $5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress 7/6/2020 $108,513 107,683 $0 $108,513 No Q9 Advance, Q6 Local True-Up *107,683 QPR8 12/20/2019 In Progress 7/6/2020 $64,813 64,826 $0 $64,813 No Q10 Advance, Q7 Local True-Up 64,826 QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report 7/30/2020 $84,637 84,531 $4,805,725 $4,890,362 Q12 Advance, Q9 Local True-Up 4,890,256 QPR11 8/3/2020 10/30/2020 $81,302 $2,505,701 $2,587,003 QPR12 11/9/2020 12/28/2020 $225,741 $2,991,600 $3,217,341 QPR13 2/16/2021 4/2/2021 $17,644 $0 $17,644 QPR14 6/9/2021 None Due $0 $0 $0 [1]QPR15 This Report None Due $0 $0 $0 Cumulative Payments [1] Subject to DWR Review $812,773 1,137,718 $21,775,948 27,191,518 $22,588,721 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 Xxxxx Xxxxxx Remaining $10,616,406 $20,753,303 $31,369,709 * Pending DWR Approval 28,329,235 Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 QPR10 QPR11 QPR12 [1] QPR10 Total Advance Payments Received Init & Supp Credit [2] Budget Remaining Budget Total Received Retention Held [3] 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $19,783 0 $19,783 0 $21,284 $21,284 $0 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $43,324 17,802 $204,613 $278,209 $1,061,426 112,948 $1,773,417 390,000 $711,991 1,538,852 $235,039 $1,773,891 $175,488 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 -$50,046 $255,315 211,693 $815,819 $1,203,799 $3,793,208 223,927 $4,453,248 21,600 $660,040 3,993,932 $572,415 $4,566,347 $345,482 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $19,257 7,850 $59,107 $177,351 $635,121 152,615 $1,024,641 180,000 $389,520 956,328 $308,980 $1,265,308 $81,038 5 ROW Acquisition (Post Add to SPFC) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project A $0 $0 $0 $0 $5,072,906 $8,066,923 $3,146,365 $2,016,212 $2,400,000 $20,702,407 $0 $20,702,407 $1,452,960 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ $0 $0 $0 $0 $5,072,907 $8,067,636 $3,147,297 $16,287,840 $29,527,883 $13,240,043 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $75,429 $77,074 Total $1,051,439 $489,202 $674,423 $217,895 216,715 $5,390,803 5,310,251 $9,146,462 $4,805,725 $21,775,948 2,505,701 $42,529,251 2,991,600 $20,753,304 27,191,518 $1,137,718 $28,329,235 $2,054,968 [1] Funding received through QPR9 QPR12 [2] No Advance requested QPR4, QPR7, Authorized Initial & QPR8Supplemental Credit complete as of QPR13 [3] Retention Held on Cost to Date
Appears in 1 contract
Samples: cms9files1.revize.com
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 (October – December 2019) (reference the Quarter 7 report) as compared to the actual Costs for Quarter 9 (refer to SOC included with this report dated May 4, 2020). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 (October – December 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 A Previosly Projected Costs [1] B Actual Costs for Quarter 9 [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%) True Up Payment By State Local Creditable Cost Share A B C D = B -C E = C x A F = E x 10% True Up Payment By State G = E - F Local Creditable Cost Share H = C x (1 - A) 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 97,410 $ 134,874 $ (37,464) $ 114,643 $ 11,464 $ 103,179 $ 20,231 3 Design & ROW Support 85% $ 251,375 $ 398,271 $ (146,897) $ 338,530 $ 33,853 $ 304,677 $ 59,741 4 Environmental Review & Permitting 85% $ 99,891 $ 31,102 $ 68,789 $ 26,437 $ 2,644 $ 23,793 $ 4,665 5 ROW Acquisition 85% $ 1,379,122 $ 1,219,655 $ 159,466 N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 195,969 $ - $ 195,969 $ - $ - $ - $ - 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 2,023,767 $ 1,783,903 $ 239,864 $ 479,610 $ 47,961 $ 431,649 $ 84,637 [1] Projected costs for Quarter 9 (refer to QPR7) [2] Reference SOC dated May 4, 2020 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 (subject to DWR review) $108,513 Pending Quarter 7 Local Share (subject to DWR Review) $64,813 Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 Remaining Authorized Local Credit $324,945 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 10 Report May 11, 2020 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). 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 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-4 presents the requested State Share advance payments by Project element. Table 10-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost Element Description State Cost Share A Projected Costs Quarter 12 B [1] State Share (85%) D = B x A State Witholding on Advance (10%) E = D x 10% Advance State Share Funding Requested F = D - E Difference from Prior Advances [2] G Remaning Advanced Request A B [1] D = B x A E = D x 10% F = D - E G H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 $ 67,374 $ 6,737 $ 60,636 $ 217,572 $ 278,209 3 Design & ROW Support 85% $ 265,815 $ 225,943 $ 22,594 $ 203,349 $ 1,000,451 $ 1,203,799 4 Environmental Review & Permitting 85% $ 161,981 $ 137,684 $ 13,768 $ 123,915 $ 53,436 $ 177,351 5 ROW Acquisition 85% $ 4,348,557 N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 $ 9,091,061 $ 909,106 $ 8,181,955 $ (5,034,657) $ 3,147,297 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 $ 9,522,061 $ 952,206 $ 8,569,855 $ (3,764,130) $ 4,805,725 [1] Covers period from 7/1/20 to 9/30/20 (Q12) [2] Refer to Table 10-2 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 onState on State Share of True Up Costs State Share of True Up Costs to be Immediately Payments Element Description QTR 9 [1] QTR 1-8 [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 Application $ - $ - $ - $ - $ - $ - $ - $ - 2 Program Management $ 134,874 $ 905,879 $ 1,040,753 $ 884,640 $ 88,464 $ 796,176 $ 578,604 $ 217,572 3 Design & ROW Support $ 398,271 $ 3,227,926 $ 3,626,197 $ 3,082,267 $ 308,227 $ 2,774,041 $ 1,773,590 $ 1,000,451 4 Environmental Review & Permitting $ 31,102 $ 559,875 $ 590,978 $ 502,331 $ 50,233 $ 452,098 $ 398,662 $ 53,436 5 ROW Acquisition $ 1,219,655 $ 1,212,264 $ 2,431,919 N/A N/A N/A $ - N/A 6 Construction, Mitigation, & Other Project $ - $ 50,000 $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ 5,072,907 $ (5,034,657) 7 Closeout Process $ - $ (1,218) $ (1,218) $ (1,035) $ (104) $ (932) $ - $ (932) $ 1,783,903 $ 5,954,726 $ 7,738,629 $ 4,510,703 $ 451,070 $ 4,059,633 $ 7,823,763 $ (3,764,130) [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 [3} Payments received through December 2019 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,390,803 $5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress $108,513 $0 $108,513 No Q9 Advance, Q6 Local True-Up *QPR8 12/20/2019 In Progress $64,813 $0 $64,813 No Q10 Advance, Q7 Local True-Up QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report $84,637 $4,805,725 $4,890,362 Q12 Advance, Q9 Local True-Up Cumulative Payments $812,773 $21,775,948 $22,588,721 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 Xxxxx Xxxxxx Remaining $10,616,406 $20,753,303 $31,369,709 * Pending DWR Approval Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 [1] QPR10 Total [2] Budget Remaining Budget 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $19,783 $19,783 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $43,324 $204,613 $278,209 $1,061,426 $1,773,417 $711,991 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $255,315 $815,819 $1,203,799 $3,793,208 $4,453,248 $660,040 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $19,257 $59,107 $177,351 $635,121 $1,024,641 $389,520 5 ROW Acquisition (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ $0 $0 $0 $0 $5,072,907 $8,067,636 $3,147,297 $16,287,840 $29,527,883 $13,240,043 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $75,429 $77,074 Total $1,051,439 $489,202 $674,423 $217,895 $5,390,803 $9,146,462 $4,805,725 $21,775,948 $42,529,251 $20,753,304 [1] Funding received through QPR9 [2] No Advance requested QPR4, QPR7, & QPR8
Appears in 1 contract
Samples: cms9files1.revize.com
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 13 (October – December 20192020) (reference the Quarter 7 11 report) as compared to the actual Costs for Quarter 9 13 (refer to SOC included with this report dated May 418, 20202021). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 13 (October – December 20192020). 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 9 13 [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%) True Up Payment By State Local Creditable Cost Share A B C D = B -C E = C x A F = E x 10% True Up Payment By State G = E - F Local Creditable Cost Share H = C x (1 - A) 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 97,410 147,644 $ 134,874 179,003 $ (37,46431,360) $ 114,643 152,153 $ 11,464 15,215 $ 103,179 136,938 $ 20,231 26,851 3 Design & ROW Support 85% $ 251,375 292,715 $ 398,271 165,692 $ (146,897) 127,023 $ 338,530 140,838 $ 33,853 14,084 $ 304,677 126,754 $ 59,741 24,854 4 Environmental Review & Permitting 85% $ 99,891 199,496 $ 31,102 924 $ 68,789 198,572 $ 26,437 785 $ 2,644 79 $ 23,793 707 $ 4,665 139 5 ROW Acquisition 85% $ 1,379,122 $ 1,219,655 $ 159,466 N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 195,969 2,635,571 $ - 9,939,803 $ 195,969 (7,304,232) $ - 8,448,833 $ - 844,883 $ - 7,603,950 $ - 1,490,971 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 2,023,767 3,275,426 $ 1,783,903 10,285,422 $ 239,864 (7,009,997) $ 479,610 8,742,609 $ 47,961 874,261 $ 431,649 7,868,348 $ 84,637 1,542,813 [1] Projected costs for Quarter 9 13 (refer to QPR7QPR11) [2] Reference SOC dated May 418, 2020 2021 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 122,466 Quarter 5 local share Paid by State $80,551 Quarter 6 local share Paid by State $107,683 Quarter 7 local share Paid by State $64,826 Quarter 8 local share Paid by State $100,052 Quarter 9 local share Paid by State $84,531 Quarter 10 Local share Paid by State $81,302 Quarter 11 Local share Paid by State $225,741 Pending Quarter 6 Local (subject to DWR review) $108,513 Pending Quarter 7 12 Local Share (subject to DWR Review) be Paid by State $64,813 Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 17,644 Remaining Authorized Local Credit $324,945 0 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 10 14 Report May 11, 2020 June 2021 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). No advance this quarter, table not included. 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 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-4 presents the requested State Share advance payments by Project elementelement as well as retention held on advances. Table 10-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost Element Description State Cost Share Projected Costs No Advance this Quarter 12 State Share (85%) State Witholding on Advance (10%) Advance State Share Funding Requested Difference from Prior Advances [2] Remaning Advanced Request A B [1] D = B x A E = D x 10% F = D - E G H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 $ 67,374 $ 6,737 $ 60,636 $ 217,572 $ 278,209 3 Design & ROW Support 85% $ 265,815 $ 225,943 $ 22,594 $ 203,349 $ 1,000,451 $ 1,203,799 4 Environmental Review & Permitting 85% $ 161,981 $ 137,684 $ 13,768 $ 123,915 $ 53,436 $ 177,351 5 ROW Acquisition 85% $ 4,348,557 N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 $ 9,091,061 $ 909,106 $ 8,181,955 $ (5,034,657) $ 3,147,297 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 $ 9,522,061 $ 952,206 $ 8,569,855 $ (3,764,130) $ 4,805,725 [1] Covers period from 7/1/20 to 9/30/20 (Q12) [2] Refer to Table 10-2 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 onState Share of True Up Costs on State Share of True Up Costs to be Immediately Payments Element 1 Description QTR 13 [1]A Grant Application $ - $ QTR 1-12 [2] B - $ Costs C = A + B - True Up Costs D = 0.85 * C $ - $ - $ - $ - $ - $ (10%)E = D x 10% - 2 Program Management $ 134,874 179,003 $ 905,879 1,645,386 $ 1,040,753 1,824,390 $ 884,640 1,550,731 $ 88,464 $ 796,176 $ 578,604 $ 217,572 155,073 3 Design & ROW Support $ 398,271 165,692 $ 3,227,926 3,896,820 $ 3,626,197 4,062,511 $ 3,082,267 3,453,135 $ 308,227 $ 2,774,041 $ 1,773,590 $ 1,000,451 345,313 4 Environmental Review & Permitting $ 31,102 924 $ 559,875 946,677 $ 590,978 947,601 $ 502,331 805,461 $ 50,233 $ 452,098 $ 398,662 $ 53,436 80,546 5 ROW Acquisition $ 1,219,655 $ 1,212,264 $ 2,431,919 N/A N/A N/A $ - N/A N/A 6 Construction, Mitigation, & Other Project $ - 9,939,803 $ 50,000 4,088,718 $ 50,000 14,028,522 $ 42,500 11,924,244 $ 4,250 $ 38,250 $ 5,072,907 $ (5,034,657) 1,192,424 7 Closeout Process $ - $ (1,218) $ (1,218) $ (1,035) $ (104) $ (932) - $ - $ (932) - $ 1,783,903 - $ 5,954,726 10,285,422 $ 7,738,629 10,577,602 $ 4,510,703 20,863,024 $ 451,070 17,733,570 $ 4,059,633 $ 7,823,763 $ (3,764,130) 1,773,357 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 [3} Payments received through December 2019 12 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 122,466 $217,895 216,715 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,310,252 $5,390,803 $5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress 7/6/2020 $108,513 107,683 $0 $108,513 No Q9 Advance, Q6 Local True-Up *107,683 QPR8 12/20/2019 In Progress 7/6/2020 $64,813 64,826 $0 $64,813 No Q10 Advance, Q7 Local True-Up 64,826 QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report 7/30/2020 $84,637 84,531 $4,805,725 $4,890,362 Q12 Advance, Q9 Local True-Up 4,890,256 QPR11 8/3/2020 10/30/2020 $81,302 $2,505,701 $2,587,003 QPR12 11/9/2020 12/28/2020 $225,741 $2,991,600 $3,217,341 QPR13 2/16/2021 4/2/2021 $17,644 $0 $17,644 [1]QPR14 This Report None Due $0 $0 $0 Cumulative Payments [1] Subject to DWR Review $812,773 1,137,718 $21,775,948 27,191,518 $22,588,721 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 Xxxxx Xxxxxx Remaining $10,616,406 $20,753,303 $31,369,709 * Pending DWR Approval 28,329,235 Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 QPR10 QPR11 QPR12 [1] QPR10 Total Advance Payments Received Init & Supp Credit [2] Budget Remaining Budget Total Received Retention Held [3] 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $19,783 0 $19,783 0 $21,284 $21,284 $0 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $43,324 17,802 $204,613 $278,209 $1,061,426 112,948 $1,773,417 390,000 $711,991 1,538,852 $235,039 $1,773,891 $155,073 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 -$50,046 $255,315 211,693 $815,819 $1,203,799 $3,793,208 223,927 $4,453,248 21,600 $660,040 3,993,932 $572,415 $4,566,347 $345,313 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $19,257 7,850 $59,107 $177,351 $635,121 152,615 $1,024,641 180,000 $389,520 956,328 $308,980 $1,265,308 $80,546 5 ROW Acquisition (Post Add to SPFC) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project A $0 $0 $0 $0 $5,072,906 $8,066,923 $3,146,365 $2,016,212 $2,400,000 $20,702,407 $0 $20,702,407 $1,192,424 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ $0 $0 $0 $0 $5,072,907 $8,067,636 $3,147,297 $16,287,840 $29,527,883 $13,240,043 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $75,429 $77,074 Total $1,051,439 $489,202 $674,423 $217,895 216,715 $5,390,803 5,310,251 $9,146,462 $4,805,725 $21,775,948 2,505,701 $42,529,251 2,991,600 $20,753,304 27,191,518 $1,137,718 $28,329,235 $1,773,357 [1] Funding received through QPR9 QPR12 [2] No Advance requested QPR4, QPR7, Authorized Initial & QPR8Supplemental Credit complete as of QPR13 [3] Retention Held on Cost to Date
Appears in 1 contract
Samples: cms9files1.revize.com
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 11 (October April – December 2019June 2020) (reference the Quarter 7 9 report) as compared to the actual Costs for Quarter 9 11 (refer to SOC included with this report dated May 4November 23, 2020). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 11 (October April – December 2019June 2020). 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 9 11 [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%) True Up Payment By State Local Creditable Cost Share A B C D = B -C E = C x A F = E x 10% True Up Payment By State G = E - F Local Creditable Cost Share H = C x (1 - A) 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 97,410 166,736 $ 134,874 188,450 $ (37,46421,715) $ 114,643 160,183 $ 11,464 16,018 $ 103,179 144,164 $ 20,231 28,268 3 Design & ROW Support 85% $ 251,375 427,495 $ 398,271 120,646 $ (146,897) 306,850 $ 338,530 102,549 $ 33,853 10,255 $ 304,677 92,294 $ 59,741 18,097 4 Environmental Review & Permitting 85% $ 99,891 47,338 $ 31,102 134,704 $ 68,789 (87,366) $ 26,437 114,498 $ 2,644 11,450 $ 23,793 103,049 $ 4,665 20,206 5 ROW Acquisition 85% $ 1,379,122 $ 1,219,655 $ 159,466 N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 195,969 20,366,778 $ - 1,061,531 $ 195,969 19,305,247 $ - 902,301 $ - 90,230 $ - 812,071 $ - 159,230 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 2,023,767 21,008,347 $ 1,783,903 1,505,331 $ 239,864 19,503,016 $ 479,610 1,279,531 $ 47,961 127,953 $ 431,649 1,151,578 $ 84,637 225,800 [1] Projected costs for Quarter 9 11 (refer to QPR7QPR9) [2] Reference SOC dated May 4November 18, 2020 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 Quarter 6 local share Paid by State $107,683 Quarter 7 local share Paid by State $64,827 Quarter 8 local share Paid by State $100,052 Quarter 9 local share Paid by State $84,531 Quarter 10 Local share Paid by State $81,302 Pending Quarter 6 Local (subject to DWR review) $108,513 Pending Quarter 7 11 Local Share (subject to DWR Review) $64,813 Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 225,800 Remaining Authorized Local Credit $324,945 18,765 10. Payment Requested and State Disbursements TRLIA 200-Year Goldfields Levee Project Quarter 10 12 Report May 11, November 2020 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). 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 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-4 presents the requested State Share advance payments by Project elementelement as well as retention held on advances. Table 10-21. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost Advance State Element Description State Cost Share Projected Costs Quarter 12 14 State Share (85%) State Witholding on Advance (10%) Advance State Share Funding Requested Difference from Prior Advances [2] Remaning Advanced Request A B [1] D = B x A E = D x 10% F = D - E G H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 509,804 $ 67,374 433,333 $ 6,737 43,333 $ 60,636 $ 217,572 $ 278,209 390,000 3 Design & ROW Support 85% $ 265,815 28,235 $ 225,943 24,000 $ 22,594 2,400 $ 203,349 $ 1,000,451 $ 1,203,799 21,600 4 Environmental Review & Permitting 85% $ 161,981 235,294 $ 137,684 200,000 $ 13,768 20,000 $ 123,915 $ 53,436 $ 177,351 180,000 5 ROW Acquisition 85% $ 4,348,557 150,000 N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 3,137,255 $ 2,666,667 $ 266,667 $ 2,400,000 7 Closeout Process 85% $ - $ - $ - $ - [1] Covers period from 1/1/21 to 3/31/21 (Q14) $ 4,060,588 $ 3,324,000 $ 332,400 $ 2,991,600 [2] Refer to Table 10-2 Table 10-2. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding True Up Costs True Up Cost State Share of Retention on State Share of True Up Costs State Share of True Up Costs to be Immediately Element Description QTR 11 [1] QTR 1-10 [2] True Up Costs (10%) Funded A B D = 0.85 * C E = D x 10% F = D - E 1 Grant Application $ - $ - $ - $ - $ - 2 Program Management $ 188,450 $ 1,205,066 $ 1,184,489 $ 118,449 $ 1,066,040 3 Design & ROW Support $ 120,646 $ 3,764,583 $ 3,302,444 $ 330,244 $ 2,972,200 4 Environmental Review & Permitting $ 134,704 $ 620,028 $ 641,522 $ 64,152 $ 577,370 5 ROW Acquisition N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 1,061,531 $ 9,091,061 252,894 $ 909,106 1,117,262 $ 8,181,955 111,726 $ (5,034,657) $ 3,147,297 1,005,535 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 $ 9,522,061 $ 952,206 $ 8,569,855 $ (3,764,130) $ 4,805,725 [1] Covers period from 7/1/20 to 9/30/20 (Q12) [2] Refer to Table 10-2 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 onState Share of True Up Costs State Share of True Up Costs to be Immediately Payments 1 Grant Application $ - $ - $ - $ - $ - $ - 1,505,331 $ - 5,842,571 $ - 2 Program Management 6,245,717 $ 134,874 624,572 $ 905,879 $ 1,040,753 $ 884,640 $ 88,464 $ 796,176 $ 578,604 $ 217,572 3 Design & ROW Support $ 398,271 $ 3,227,926 $ 3,626,197 $ 3,082,267 $ 308,227 $ 2,774,041 $ 1,773,590 $ 1,000,451 4 Environmental Review & Permitting $ 31,102 $ 559,875 $ 590,978 $ 502,331 $ 50,233 $ 452,098 $ 398,662 $ 53,436 5 ROW Acquisition $ 1,219,655 $ 1,212,264 $ 2,431,919 N/A N/A N/A $ - N/A 6 Construction, Mitigation, & Other Project $ - $ 50,000 $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ 5,072,907 $ (5,034,657) 7 Closeout Process $ - $ (1,218) $ (1,218) $ (1,035) $ (104) $ (932) $ - $ (932) $ 1,783,903 $ 5,954,726 $ 7,738,629 $ 4,510,703 $ 451,070 $ 4,059,633 $ 7,823,763 $ (3,764,130) 5,621,145 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 [3} Payments received through December 2019 10 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes Init. 10/23/2017 2/14/2018 $0 $575,808 $575,808 Initial Credit Request Supp. 3/29/2018 9/4/2018 $0 $561,910 $561,910 Supplemental Credit Request QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,390,803 $5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress 7/6/2020 $108,513 107,683 $0 $108,513 107,683 No Q9 Advance, Q6 Local True-Up *QPR8 12/20/2019 In Progress 7/6/2020 $64,813 64,827 $0 $64,813 64,827 No Q10 Advance, Q7 Local True-Up QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report 7/30/2020 $84,637 84,531 $4,805,725 $4,890,362 4,890,256 Q12 Advance, Q9 Local True-Up *QPR11 8/3/2020 In progress $81,302 $2,505,701 $2,587,003 Q13 Advance, Q10 Local True-Up *QPR12 11/9/2020 This Report $225,800 $2,991,600 $3,217,400 Q14 Advance, Q11 Local True-Up Cumulative Payments $812,773 1,118,952 $21,775,948 28,410,966 $22,588,721 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 Xxxxx Xxxxxx Remaining $10,616,406 $20,753,303 $31,369,709 29,529,919 * Pending DWR Approval Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description Init. Cred Suppl. Cred QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 QPR10 [1] QPR10 Total QPR11 QPR12 [2] Budget Remaining Total Retention Held [3] Budget 1 Grant Application $21,284 $0 $0 $0 $0 $0 $0 $0 $0 $19,783 0 $0 $21,284 $0 $19,783 2 Program Management @80.72% $112,735 $122,304 $185,425 $59,006 $158,002 $132,847 $43,324 $204,613 $278,209 $1,061,426 112,948 $390,000 $1,799,413 $173,819 $1,773,417 $711,991 3 Design & ROW Support $265,271 $307,144 $704,079 $384,609 $478,453 -$48,866 $255,315 $815,819 $1,203,799 $3,793,208 223,927 $21,600 $4,611,149 $448,748 $4,453,248 $660,040 4 Envrionmental Review & Permitting $176,518 $132,461 $161,935 $45,587 $37,969 $133,914 $19,257 $59,107 $177,351 $635,121 152,615 $180,000 $1,276,715 $107,526 $1,024,641 $389,520 5 ROW Acquisition (Post Add to SPFC) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A $5,654,849 6 Construction, Mitigation, & Other Project A $0 $0 $0 $0 $0 $0 $5,072,907 $8,066,923 $3,146,365 $2,016,212 $2,400,000 $20,702,408 $2,300,268 $29,527,883 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ 0 $0 $0 $0 $0 $5,072,907 75,429 Total $8,067,636 575,808 $3,147,297 $16,287,840 $29,527,883 $13,240,043 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $75,429 $77,074 Total 561,910 $1,051,439 $489,202 $674,423 $217,895 $5,390,803 $9,146,462 $4,805,725 $21,775,948 2,505,701 $2,991,600 $28,410,967 $3,030,359 $42,529,251 $20,753,304 [1] Funding received through QPR9 QPR10 [2] No Pending DWR Review [3] Retention held on Advance requested QPR4, QPR7, & QPR8Request QPR1 - QPR12
Appears in 1 contract
Samples: cms9files1.revize.com
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 9 12 (October July – December 2019September 2020) (reference the Quarter 7 10 report) as compared to the actual Costs for Quarter 9 12 (refer to SOC included with this report dated May 4February 16, 20202021). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 9 12 (October – December 2019July –September 2020). 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 9 12 [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%) True Up Payment By State Local Creditable Cost Share A B C D = B -C E = C x A F = E x 10% True Up Payment By State G = E - F Local Creditable Cost Share H = C x (1 - A) 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 97,410 79,263 $ 134,874 132,936 $ (37,46453,672) $ 114,643 112,995 $ 11,464 11,300 $ 103,179 101,696 $ 20,231 19,940 3 Design & ROW Support 85% $ 251,375 265,815 $ 398,271 11,166 $ (146,897) 254,649 $ 338,530 9,491 $ 33,853 949 $ 304,677 8,542 $ 59,741 1,675 4 Environmental Review & Permitting 85% $ 99,891 161,981 $ 31,102 191,945 $ 68,789 (29,964) $ 26,437 163,154 $ 2,644 16,315 $ 23,793 146,838 $ 4,665 28,792 5 ROW Acquisition 85% $ 1,379,122 $ 1,219,655 $ 159,466 N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 195,969 10,695,365 $ - 2,774,381 $ 195,969 7,920,985 $ - 2,358,224 $ - 235,822 $ - 2,122,401 $ - 416,157 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 2,023,767 11,202,425 $ 1,783,903 3,110,428 $ 239,864 8,091,997 $ 479,610 2,643,864 $ 47,961 264,386 $ 431,649 2,379,478 $ 84,637 466,564 [1] Projected costs for Quarter 9 12 (refer to QPR7QPR10) [2] Reference SOC dated May 4February 16, 2020 2021 subject to DWR Review Table 9-2. TRLIA - 200-Year Goldfields Levee Project Remaining Authorized Local Credit TRLIA - 200-Year Goldfields Levee Project Local Credit Reconciliation 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 Quarter 6 local share Paid by State $107,683 Quarter 7 local share Paid by State $64,826 Quarter 8 local share Paid by State $100,052 Quarter 9 local share Paid by State $84,531 Quarter 10 Local share Paid by State $81,302 Quarter 11 Local share Paid by State $225,741 Pending Quarter 6 Local (subject to DWR review) $108,513 Pending Quarter 7 12 Local Share (subject to DWR Review) be Paid by State $64,813 Quarter 8 Local Share (paid on 5/4/2020) $100,052 Pending Quarter 9 Local Share (subject to DWR Review) $84,637 18,824 Remaining Authorized Local Credit $324,945 10. Payment Requested and State Disbursements 0 TRLIA 200-Year Goldfields Levee Project Quarter 10 13 Report May 11, 2020 10. Payment Requested and State Disbursements 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). No advance this quarter; table not included. 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 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-4 presents the requested State Share advance payments by Project elementelement as well as retention held on advances. Table 10-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost No Advance this Quarter Table 10-1. TRLIA - 200-Year Goldfields Levee Project: True-Up Funding Retention on State Share of State Share of True Up Costs to Element Description State True Up Costs QTR 12 [1] True Up Cost Share Projected QTR 1-11 [2] Total True Up Costs Quarter 12 State Share (85%) State Witholding on Advance of True Up Costs True Up Costs (10%) Advance State Share Funding Requested Difference from Prior Advances [2] Remaning Advanced Request be Immediately Funded A B [1] C = A + B D = B x A 0.85 * C E = D x 10% F = D - E G H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 132,936 $ 67,374 1,392,804 $ 6,737 1,525,739 $ 60,636 1,296,878 $ 217,572 129,688 $ 278,209 1,167,191 3 Design & ROW Support 85% $ 265,815 11,166 $ 225,943 3,885,653 $ 22,594 3,896,820 $ 203,349 3,312,297 $ 1,000,451 331,230 $ 1,203,799 2,981,067 4 Environmental Review & Permitting 85% $ 161,981 191,945 $ 137,684 754,732 $ 13,768 946,677 $ 123,915 804,675 $ 53,436 80,468 $ 177,351 724,208 5 ROW Acquisition 85% $ 4,348,557 N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 2,774,381 $ 9,091,061 1,314,326 $ 909,106 4,088,706 $ 8,181,955 3,475,400 $ (5,034,657) 347,540 $ 3,147,297 3,127,860 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 15,550,982 $ 9,522,061 $ 952,206 $ 8,569,855 $ (3,764,130) $ 4,805,725 [1] Covers period from 7/1/20 to 9/30/20 (Q12) [2] Refer to Table 10-2 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 onState Share of True Up Costs State Share of True Up Costs to be Immediately Payments 1 Grant Application $ - $ - $ - $ - $ - $ - $ - 3,110,428 $ - 2 Program Management 7,347,514 $ 134,874 10,457,942 $ 905,879 8,889,251 $ 1,040,753 888,925 $ 884,640 $ 88,464 $ 796,176 $ 578,604 $ 217,572 3 Design & ROW Support $ 398,271 $ 3,227,926 $ 3,626,197 $ 3,082,267 $ 308,227 $ 2,774,041 $ 1,773,590 $ 1,000,451 4 Environmental Review & Permitting $ 31,102 $ 559,875 $ 590,978 $ 502,331 $ 50,233 $ 452,098 $ 398,662 $ 53,436 5 ROW Acquisition $ 1,219,655 $ 1,212,264 $ 2,431,919 N/A N/A N/A $ - N/A 6 Construction, Mitigation, & Other Project $ - $ 50,000 $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ 5,072,907 $ (5,034,657) 7 Closeout Process $ - $ (1,218) $ (1,218) $ (1,035) $ (104) $ (932) $ - $ (932) $ 1,783,903 $ 5,954,726 $ 7,738,629 $ 4,510,703 $ 451,070 $ 4,059,633 $ 7,823,763 $ (3,764,130) 8,000,326 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-8 [3} Payments received through December 2019 11 Table 10-3. TRLIA - 200-Year Goldfields Levee Project: Payment Requests and State Disbursements Report Payment Request Date Payment Receipt Date Credit Portion State Portion Total Payment Amount Notes QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 Q1&Q2 Advance QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 Q3 Advance, Q1 Local True-Up QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 Q4 Advance, Q2 Local True-Up QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 Q5&Q6 Advance, Q3 Local True-Up QPR5 1/23/2019 3/28/2019 $121,286 $217,895 $339,181 Q6&Q7 Advance, Q4 Local True-Up QPR6 7/1/2019 8/22/2019 $80,551 $5,310,252 $5,390,803 $5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 In Progress 7/6/2020 $108,513 107,683 $0 $108,513 No Q9 Advance, Q6 Local True-Up *107,683 QPR8 12/20/2019 In Progress 7/6/2020 $64,813 64,826 $0 $64,813 No Q10 Advance, Q7 Local True-Up 64,826 QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 Q11 Advance, Q8 Local True-Up *QPR10 5/4/2020 This Report 7/30/2020 $84,637 84,531 $4,805,725 $4,890,362 Q12 Advance, Q9 Local True-Up 4,890,256 QPR11 8/3/2020 10/30/2020 $81,302 $2,505,701 $2,587,003 QPR12 11/9/2020 12/28/2020 $225,741 $2,991,600 $3,217,341 [1]QPR13 This Report In Progress $18,824 $0 $18,824 Cumulative Payments $812,773 1,137,718 $21,775,948 27,192,698 $22,588,721 Total Grant Amount $11,429,179 $42,529,251 $53,958,430 Xxxxx Xxxxxx Remaining $10,616,406 $20,753,303 $31,369,709 * Pending 28,330,415 [1] Subject to DWR Approval Review Table 10-4. TRLIA - 200-Year Goldfields Levee Project: State Advance Payments by Element Element Description QPR1 QPR2 QPR3 QPR5 QPR6 QPR9 QPR10 QPR11 QPR12 [1] QPR10 Total Advance Payments Received Retention Held [2] Budget Remaining Budget Init + Supp Credit [3] 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $19,783 0 $19,783 0 $0 $21,284 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $43,324 17,802 $204,613 $278,209 $1,061,426 112,948 $1,773,417 390,000 $711,991 1,538,852 $170,984 $235,039 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $255,315 211,693 $815,819 $1,203,799 $3,793,208 223,927 $4,453,248 21,600 $660,040 3,995,112 $443,901 $572,415 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $19,257 7,850 $59,107 $177,351 $635,121 152,615 $1,024,641 180,000 $389,520 956,328 $106,259 $308,980 5 ROW Acquisition (Post Add to SPFC) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project A $0 $0 $0 $0 $5,072,906 $8,066,923 $3,146,365 $2,016,212 $2,400,000 $20,702,407 $2,300,267 $0 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project Activ $0 $0 $0 $0 $5,072,907 $8,067,636 $3,147,297 $16,287,840 $29,527,883 $13,240,043 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 -$713 -$932 -$1,645 $75,429 $77,074 Total $1,051,439 $489,202 $674,423 $217,895 $5,390,803 5,310,251 $9,146,462 $4,805,725 $21,775,948 2,505,701 $42,529,251 2,991,600 $20,753,304 27,192,699 $3,021,411 $1,137,718 [1] Funding received through QPR9 QPR12 [2] No Retention held on Total Advance requested QPR4, QPR7, Request [3] Authorized Initial & QPR8Supplemental Credit complete as of QPR13 TRLIA 200-Year Goldfields Levee Project Quarter 13 Report 11. Tracking Tables and Deliverables Table
Appears in 1 contract
Samples: cms9files1.revize.com