Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 12 (July – September 2020) (reference the Quarter 10 report) as compared to the actual Costs for Quarter 12 (refer to SOC included with this report dated February 16, 2021). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 12 (July –September 2020). Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 $ 132,936 $ (53,672) $ 112,995 $ 11,300 $ 101,696 $ 19,940 3 Design & ROW Support 85% $ 265,815 $ 11,166 $ 254,649 $ 9,491 $ 949 $ 8,542 $ 1,675 4 Environmental Review & Permitting 85% $ 161,981 $ 191,945 $ (29,964) $ 163,154 $ 16,315 $ 146,838 $ 28,792 5 ROW Acquisition 85% N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 $ 2,774,381 $ 7,920,985 $ 2,358,224 $ 235,822 $ 2,122,401 $ 416,157 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 11,202,425 $ 3,110,428 $ 8,091,997 $ 2,643,864 $ 264,386 $ 2,379,478 $ 466,564 [1] Projected costs for Quarter 12 (refer to QPR10) [2] Reference SOC dated February 16, 2021 subject to DWR Review 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 12 Local Share to be Paid by State $18,824 Remaining Authorized Local Credit $0 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-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost 1 Grant Application $ - $ - $ - $ - $ - $ - 2 Program Management $ 132,936 $ 1,392,804 $ 1,525,739 $ 1,296,878 $ 129,688 $ 1,167,191 3 Design & ROW Support $ 11,166 $ 3,885,653 $ 3,896,820 $ 3,312,297 $ 331,230 $ 2,981,067 4 Environmental Review & Permitting $ 191,945 $ 754,732 $ 946,677 $ 804,675 $ 80,468 $ 724,208 5 ROW Acquisition N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project $ 2,774,381 $ 1,314,326 $ 4,088,706 $ 3,475,400 $ 347,540 $ 3,127,860 7 Closeout Process $ - $ - $ - $ - $ - $ - $ 3,110,428 $ 7,347,514 $ 10,457,942 $ 8,889,251 $ 888,925 $ 8,000,326 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-11 QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 QPR5 1/23/2019 3/28/2019 $121,286 $217,895 $339,181 QPR6 7/1/2019 8/22/2019 $80,551 $5,310,252 $5,390,803 QPR7 8/1/2019 7/6/2020 $107,683 $0 $107,683 QPR8 12/20/2019 7/6/2020 $64,826 $0 $64,826 QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 QPR10 5/4/2020 7/30/2020 $84,531 $4,805,725 $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 $1,137,718 $27,192,698 $28,330,415 [1] Subject to DWR Review 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $21,284 2 Program Management $185,425 $59,006 $158,002 $132,847 $17,802 $204,613 $278,209 $112,948 $390,000 $1,538,852 $170,984 $235,039 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $211,693 $815,819 $1,203,799 $223,927 $21,600 $3,995,112 $443,901 $572,415 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $7,850 $59,107 $177,351 $152,615 $180,000 $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 $0 $0 $0 $0 [1] Funding received through QPR12 [2] Retention held on Total Advance Request [3] Authorized Initial & Supplemental Credit complete as of QPR13
Appears in 1 contract
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 12 10 (July January – September March 2020) (reference the Quarter 10 8 report) as compared to the actual Costs for Quarter 12 10 (refer to SOC included with this report dated February 16August 4, 20212020). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 12 10 (July –September January – March 2020). Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 89,872 $ 132,936 169,849 $ (53,67279,977) $ 112,995 144,372 $ 11,300 14,437 $ 101,696 129,935 $ 19,940 25,477 3 Design & ROW Support 85% $ 265,815 152,639 $ 11,166 141,051 $ 254,649 11,589 $ 9,491 119,893 $ 949 11,989 $ 8,542 107,904 $ 1,675 21,158 4 Environmental Review & Permitting 85% $ 161,981 24,828 $ 191,945 31,109 $ (29,9646,281) $ 163,154 26,442 $ 16,315 2,644 $ 146,838 23,798 $ 28,792 4,666 5 ROW Acquisition 85% N/A $ - N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 282,535 $ 2,774,381 202,894 $ 7,920,985 79,640 $ 2,358,224 172,460 $ 235,822 17,246 $ 2,122,401 155,214 $ 416,157 30,434 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 11,202,425 549,874 $ 3,110,428 544,903 $ 8,091,997 4,971 $ 2,643,864 463,167 $ 264,386 46,317 $ 2,379,478 416,851 $ 466,564 81,735 [1] Projected costs for Quarter 12 10 (refer to QPR10QPR8) [2] Reference SOC dated February 16August 4, 2021 2020 subject to DWR Review 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 64,827 Quarter 8 local share Paid by State $100,052 Quarter 9 local share Paid by State $84,531 Pending Quarter 10 Local share Paid by State Share Subject to DWR Review $81,302 Quarter 11 Local share Paid by State $225,741 Pending Quarter 12 Local Share to be Paid by State $18,824 81,735 Remaining Authorized Local Credit $0 244,132 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-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 13 Quarter 14 State Share (85%) on Advance (10%) Requested A B [1] C D = B x A E = D x 10% F = D - E 1 Grant Application 85% $ - $ - $ - $ - $ - 2 Program Management 85% $ 147,644 $ - $ 125,497 $ 12,550 $ 112,948 3 Design & ROW Support 85% $ 292,715 $ - $ 248,808 $ 24,881 $ 223,927 4 Environmental Review & Permitting 85% $ 199,496 $ - $ 169,572 $ 16,957 $ 152,615 5 ROW Acquisition 85% $ 863,237 $ - N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 2,635,571 $ - $ 2,240,236 $ 224,024 $ 2,016,212 7 Closeout Process 85% $ - $ - $ - $ - $ - [1] Covers period from 10/1/20 to 12/31/20 (Q13) [2] Refer to Table 10-2 $ 4,138,663 $ - $ 2,784,112 $ 278,411 $ 2,505,701 Grant Application $ - $ - $ - $ - $ - $ - 2 Program Management $ 132,936 169,849 $ 1,392,804 1,035,527 $ 1,525,739 1,205,376 $ 1,296,878 1,024,569 $ 129,688 102,457 $ 1,167,191 3 922,112 Design & ROW Support $ 11,166 141,051 $ 3,885,653 3,626,112 $ 3,896,820 3,767,163 $ 3,312,297 3,202,088 $ 331,230 320,209 $ 2,981,067 4 2,881,879 Environmental Review & Permitting $ 191,945 31,109 $ 754,732 588,919 $ 946,677 620,028 $ 804,675 527,024 $ 80,468 52,702 $ 724,208 5 474,321 ROW Acquisition N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project $ 2,774,381 202,894 $ 1,314,326 50,000 $ 4,088,706 252,894 $ 3,475,400 214,960 $ 347,540 21,496 $ 3,127,860 7 193,464 Closeout Process $ - $ - 3 $ - 3 $ - 3 $ - 0 $ - 2 $ 3,110,428 544,903 $ 7,347,514 5,300,561 $ 10,457,942 5,845,464 $ 8,889,251 4,968,644 $ 888,925 496,864 $ 8,000,326 4,471,780 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-11 9 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,390,803 5,471,354 Q8 Advance, Q5 Local True-Up QPR7 8/1/2019 7/6/2020 $107,683 $0 $107,683 No Q9 Advance, Q6 Local True-Up QPR8 12/20/2019 7/6/2020 $64,826 64,827 $0 $64,826 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 7/30/2020 $84,531 $4,805,725 $4,890,256 Q12 Advance, Q9 Local True-Up *QPR11 8/3/2020 10/30/2020 This Report $81,302 81,735 $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 2,587,436 Q13 Advance, Q10 Local True-Up Cumulative Payments $1,137,718 893,586 $27,192,698 24,281,649 $28,330,415 25,175,235 * 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] Subject to DWR Review QPR10 Total [2] Budget Remaining Budget 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $0 19,783 $0 $0 $21,284 19,783 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $17,802 43,324 $204,613 $278,209 $112,948 1,061,426 $390,000 1,773,417 $1,538,852 $170,984 $235,039 711,991 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $211,693 255,315 $815,819 $1,203,799 $223,927 3,793,208 $21,600 4,453,248 $3,995,112 $443,901 $572,415 660,040 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $7,850 19,257 $59,107 $177,351 $152,615 635,121 $180,000 1,024,641 $956,328 $106,259 $308,980 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 $0 $0 $0 $0 $0 $0 $0 $0 $5,654,849 $5,654,849 6 Construction, Mitigation, & Other Project A $0 $0 $0 $0 $5,072,906 5,072,907 $8,066,923 $3,146,365 $2,016,212 16,286,196 $2,400,000 29,527,883 $20,702,407 $2,300,267 $0 13,241,687 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $0 75,429 $0 $0 $0 75,429 [1] Funding received through QPR12 QPR10 [2] Retention held on Total No Advance Request [3] Authorized Initial requested QPR4, QPR7, & Supplemental Credit complete as of QPR13QPR8
Appears in 1 contract
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 12 13 (July October – September December 2020) (reference the Quarter 10 11 report) as compared to the actual Costs for Quarter 12 13 (refer to SOC included with this report dated February 16May 18, 2021). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 12 13 (July –September October – December 2020). Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 147,644 $ 132,936 179,003 $ (53,67231,360) $ 112,995 152,153 $ 11,300 15,215 $ 101,696 136,938 $ 19,940 26,851 3 Design & ROW Support 85% $ 265,815 292,715 $ 11,166 165,692 $ 254,649 127,023 $ 9,491 140,838 $ 949 14,084 $ 8,542 126,754 $ 1,675 24,854 4 Environmental Review & Permitting 85% $ 161,981 199,496 $ 191,945 924 $ (29,964) 198,572 $ 163,154 785 $ 16,315 79 $ 146,838 707 $ 28,792 139 5 ROW Acquisition 85% N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 2,635,571 $ 2,774,381 9,939,803 $ 7,920,985 (7,304,232) $ 2,358,224 8,448,833 $ 235,822 844,883 $ 2,122,401 7,603,950 $ 416,157 1,490,971 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 11,202,425 3,275,426 $ 3,110,428 10,285,422 $ 8,091,997 (7,009,997) $ 2,643,864 8,742,609 $ 264,386 874,261 $ 2,379,478 7,868,348 $ 466,564 1,542,813 [1] Projected costs for Quarter 12 13 (refer to QPR10QPR11) [2] Reference SOC dated February 16May 18, 2021 subject to DWR Review 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 12 Local Share to be Paid by State $18,824 17,644 Remaining Authorized Local Credit $0 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-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost 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 $ 132,936 179,003 $ 1,392,804 1,645,386 $ 1,525,739 1,824,390 $ 1,296,878 1,550,731 $ 129,688 $ 1,167,191 155,073 3 Design & ROW Support $ 11,166 $ 3,885,653 165,692 $ 3,896,820 $ 3,312,297 4,062,511 $ 331,230 3,453,135 $ 2,981,067 345,313 4 Environmental Review & Permitting $ 191,945 $ 754,732 924 $ 946,677 $ 804,675 947,601 $ 80,468 805,461 $ 724,208 80,546 5 ROW Acquisition N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project $ 2,774,381 9,939,803 $ 1,314,326 4,088,718 $ 4,088,706 14,028,522 $ 3,475,400 11,924,244 $ 347,540 $ 3,127,860 1,192,424 7 Closeout Process $ - $ - $ - $ - $ - $ - 10,285,422 $ 3,110,428 10,577,602 $ 7,347,514 20,863,024 $ 10,457,942 17,733,570 $ 8,889,251 $ 888,925 $ 8,000,326 1,773,357 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-11 12 QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 QPR5 1/23/2019 3/28/2019 $121,286 122,466 $217,895 216,715 $339,181 QPR6 7/1/2019 8/22/2019 $80,551 $5,310,252 $5,390,803 QPR7 8/1/2019 7/6/2020 $107,683 $0 $107,683 QPR8 12/20/2019 7/6/2020 $64,826 $0 $64,826 QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 QPR10 5/4/2020 7/30/2020 $84,531 $4,805,725 $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 QPR13 2/16/2021 4/2/2021 $18,824 17,644 $0 $18,824 17,644 [1]QPR14 This Report None Due $0 $0 $0 Cumulative Payments $1,137,718 $27,192,698 $28,330,415 [1] Subject to DWR Review $1,137,718 $27,191,518 $28,329,235 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 21,284 $21,284 $0 2 Program Management $185,425 $59,006 $158,002 $132,847 $17,802 $204,613 $278,209 $112,948 $390,000 $1,538,852 $170,984 235,039 $235,039 1,773,891 $155,073 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 -$50,046 $211,693 $815,819 $1,203,799 $223,927 $21,600 $3,995,112 $443,901 3,993,932 $572,415 $4,566,347 $345,313 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $7,850 $59,107 $177,351 $152,615 $180,000 $956,328 $106,259 308,980 $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 $2,300,267 0 $0 20,702,407 $1,192,424 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 [1] Funding received through QPR12 [2] Retention held on Total Advance Request [3] Authorized Initial & Supplemental Credit complete as of QPR13QPR13 [3] Retention Held on Cost to Date
Appears in 1 contract
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 12 14 (July January – September 2020March 2021) (reference the Quarter 10 12 report) as compared to the actual Costs for Quarter 12 14 (refer to SOC included with this report dated February 16July 26, 2021). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 12 14 (July –September 2020January – March 2021). Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 509,804 $ 132,936 240,179 $ (53,672) 269,625 $ 112,995 204,152 $ 11,300 20,415 $ 101,696 183,737 $ 19,940 36,027 3 Design & ROW Support 85% $ 265,815 28,235 $ 11,166 1,984 $ 254,649 26,252 $ 9,491 1,686 $ 949 169 $ 8,542 1,518 $ 1,675 298 4 Environmental Review & Permitting 85% $ 161,981 235,294 $ 191,945 5,785 $ (29,964) 229,509 $ 163,154 4,917 $ 16,315 492 $ 146,838 4,426 $ 28,792 868 5 ROW Acquisition 85% N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 3,137,255 $ 2,774,381 3,065,125 $ 7,920,985 72,130 $ 2,358,224 2,605,356 $ 235,822 260,536 $ 2,122,401 2,344,821 $ 416,157 459,769 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 11,202,425 3,910,588 $ 3,110,428 3,313,072 $ 8,091,997 597,516 $ 2,643,864 2,816,111 $ 264,386 281,611 $ 2,379,478 2,534,500 $ 466,564 496,961 [1] Projected costs for Quarter 12 14 (refer to QPR10QPR12) [2] Reference SOC dated February 16July 26, 2021 subject to DWR Review 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 12 Local Share to be Paid by State $18,824 17,644 Remaining Authorized Local Credit $0 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-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost 1 Grant Application $ - $ - $ - $ - $ - $ - 2 Program Management $ 132,936 240,179 $ 1,392,804 1,824,390 $ 1,525,739 2,064,569 $ 1,296,878 1,754,883 $ 129,688 $ 1,167,191 175,488 3 Design & ROW Support $ 11,166 1,984 $ 3,885,653 4,062,511 $ 3,896,820 4,064,495 $ 3,312,297 3,454,821 $ 331,230 $ 2,981,067 345,482 4 Environmental Review & Permitting $ 191,945 5,785 $ 754,732 947,601 $ 946,677 953,386 $ 804,675 810,378 $ 80,468 $ 724,208 81,038 5 ROW Acquisition N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project $ 2,774,381 3,065,125 $ 1,314,326 14,028,522 $ 4,088,706 17,093,647 $ 3,475,400 14,529,600 $ 347,540 $ 3,127,860 1,452,960 7 Closeout Process $ - $ - $ - $ - $ - $ - 3,313,072 $ 3,110,428 20,863,024 $ 7,347,514 24,176,096 $ 10,457,942 20,549,682 $ 8,889,251 $ 888,925 $ 8,000,326 2,054,968 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-11 13 QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 QPR5 1/23/2019 3/28/2019 $121,286 122,466 $217,895 216,715 $339,181 QPR6 7/1/2019 8/22/2019 $80,551 $5,310,252 $5,390,803 QPR7 8/1/2019 7/6/2020 $107,683 $0 $107,683 QPR8 12/20/2019 7/6/2020 $64,826 $0 $64,826 QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 QPR10 5/4/2020 7/30/2020 $84,531 $4,805,725 $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 QPR13 2/16/2021 4/2/2021 $18,824 17,644 $0 $18,824 17,644 QPR14 6/9/2021 None Due $0 $0 $0 [1]QPR15 This Report None Due $0 $0 $0 Cumulative Payments $1,137,718 $27,192,698 $28,330,415 [1] Subject to DWR Review $1,137,718 $27,191,518 $28,329,235 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 21,284 $21,284 $0 2 Program Management $185,425 $59,006 $158,002 $132,847 $17,802 $204,613 $278,209 $112,948 $390,000 $1,538,852 $170,984 235,039 $235,039 1,773,891 $175,488 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 -$50,046 $211,693 $815,819 $1,203,799 $223,927 $21,600 $3,995,112 $443,901 3,993,932 $572,415 $4,566,347 $345,482 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $7,850 $59,107 $177,351 $152,615 $180,000 $956,328 $106,259 308,980 $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 $2,300,267 0 $0 20,702,407 $1,452,960 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 [1] Funding received through QPR12 [2] Retention held on Total Advance Request [3] Authorized Initial & Supplemental Credit complete as of QPR13QPR13 [3] Retention Held on Cost to Date
Appears in 1 contract
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 12 11 (July April – September June 2020) (reference the Quarter 10 9 report) as compared to the actual Costs for Quarter 12 11 (refer to SOC included with this report dated February 16November 23, 20212020). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 12 11 (July –September April – June 2020). Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 166,736 $ 132,936 188,450 $ (53,67221,715) $ 112,995 160,183 $ 11,300 16,018 $ 101,696 144,164 $ 19,940 28,268 3 Design & ROW Support 85% $ 265,815 427,495 $ 11,166 120,646 $ 254,649 306,850 $ 9,491 102,549 $ 949 10,255 $ 8,542 92,294 $ 1,675 18,097 4 Environmental Review & Permitting 85% $ 161,981 47,338 $ 191,945 134,704 $ (29,96487,366) $ 163,154 114,498 $ 16,315 11,450 $ 146,838 103,049 $ 28,792 20,206 5 ROW Acquisition 85% N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 20,366,778 $ 2,774,381 1,061,531 $ 7,920,985 19,305,247 $ 2,358,224 902,301 $ 235,822 90,230 $ 2,122,401 812,071 $ 416,157 159,230 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 11,202,425 21,008,347 $ 3,110,428 1,505,331 $ 8,091,997 19,503,016 $ 2,643,864 1,279,531 $ 264,386 127,953 $ 2,379,478 1,151,578 $ 466,564 225,800 [1] Projected costs for Quarter 12 11 (refer to QPR10QPR9) [2] Reference SOC dated February 16November 18, 2021 2020 subject to DWR Review 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 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 11 Local share Paid by State Share $225,741 Pending Quarter 12 Local Share to be Paid by State $18,824 225,800 Remaining Authorized Local Credit $0 18,765 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. 1 Grant Application 85% $ - $ - $ - $ - 2 Program Management 85% $ 509,804 $ 433,333 $ 43,333 $ 390,000 3 Design & ROW Support 85% $ 28,235 $ 24,000 $ 2,400 $ 21,600 4 Environmental Review & Permitting 85% $ 235,294 $ 200,000 $ 20,000 $ 180,000 5 ROW Acquisition 85% $ 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. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost 2 1 Grant Application $ - $ - $ - $ - $ - $ - 2 Program Management $ 132,936 188,450 $ 1,392,804 1,205,066 $ 1,525,739 1,184,489 $ 1,296,878 118,449 $ 129,688 $ 1,167,191 1,066,040 3 Design & ROW Support $ 11,166 120,646 $ 3,885,653 3,764,583 $ 3,896,820 3,302,444 $ 3,312,297 330,244 $ 331,230 $ 2,981,067 2,972,200 4 Environmental Review & Permitting $ 191,945 134,704 $ 754,732 620,028 $ 946,677 641,522 $ 804,675 64,152 $ 80,468 $ 724,208 577,370 5 ROW Acquisition N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project $ 2,774,381 1,061,531 $ 1,314,326 252,894 $ 4,088,706 1,117,262 $ 3,475,400 111,726 $ 347,540 $ 3,127,860 1,005,535 7 Closeout Process $ - $ - $ - $ - $ - $ - 1,505,331 $ 3,110,428 5,842,571 $ 7,347,514 6,245,717 $ 10,457,942 624,572 $ 8,889,251 $ 888,925 $ 8,000,326 5,621,145 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-11 10 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,310,252 5,390,803 $5,390,803 5,471,354 Q8 Advance, Q5 Local True-Up QPR7 8/1/2019 7/6/2020 $107,683 $0 $107,683 No Q9 Advance, Q6 Local True-Up QPR8 12/20/2019 7/6/2020 $64,826 64,827 $0 $64,826 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 7/30/2020 $84,531 $4,805,725 $4,890,256 Q12 Advance, Q9 Local True-Up *QPR11 8/3/2020 10/30/2020 In progress $81,302 $2,505,701 $2,587,003 Q13 Advance, Q10 Local True-Up *QPR12 11/9/2020 12/28/2020 This Report $225,741 225,800 $2,991,600 $3,217,341 [1]QPR13 This Report In Progress $18,824 $0 $18,824 3,217,400 Q14 Advance, Q11 Local True-Up Cumulative Payments $1,137,718 1,118,952 $27,192,698 28,410,966 $28,330,415 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] Subject to DWR Review QPR11 QPR12 [2] Total Retention Held [3] Budget 1 Grant Application $0 21,284 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $21,284 $0 $19,783 2 Program Management $112,735 $122,304 $185,425 $59,006 $158,002 $132,847 $17,802 43,324 $204,613 $278,209 $112,948 $390,000 $1,538,852 1,799,413 $170,984 173,819 $235,039 1,773,417 3 Design & ROW Support $265,271 $307,144 $704,079 $384,609 $478,453 -$48,866 $211,693 255,315 $815,819 $1,203,799 $223,927 $21,600 $3,995,112 4,611,149 $443,901 448,748 $572,415 4,453,248 4 Envrionmental Review & Permitting $176,518 $132,461 $161,935 $45,587 $37,969 $133,914 $7,850 19,257 $59,107 $177,351 $152,615 $180,000 $956,328 1,276,715 $106,259 107,526 $308,980 1,024,641 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 $5,072,906 0 $0 $5,072,907 $8,066,923 $3,146,365 $2,016,212 $2,400,000 $20,702,407 20,702,408 $2,300,267 2,300,268 $0 29,527,883 7 Closeout Process (Post Add to SPFC) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $75,429 [1] Funding received through QPR12 QPR10 [2] Pending DWR Review [3] Retention held on Total Advance Request [3] Authorized Initial & Supplemental Credit complete as of QPR13QPR1 - QPR12
Appears in 1 contract
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 12 9 (July October – September 2020December 2019) (reference the Quarter 10 7 report) as compared to the actual Costs for Quarter 12 9 (refer to SOC included with this report dated February 16May 4, 20212020). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 12 9 (July –September 2020October – December 2019). Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 97,410 $ 132,936 134,874 $ (53,67237,464) $ 112,995 114,643 $ 11,300 11,464 $ 101,696 103,179 $ 19,940 20,231 3 Design & ROW Support 85% $ 265,815 251,375 $ 11,166 398,271 $ 254,649 (146,897) $ 9,491 338,530 $ 949 33,853 $ 8,542 304,677 $ 1,675 59,741 4 Environmental Review & Permitting 85% $ 161,981 99,891 $ 191,945 31,102 $ (29,964) 68,789 $ 163,154 26,437 $ 16,315 2,644 $ 146,838 23,793 $ 28,792 4,665 5 ROW Acquisition 85% N/A N/A N/A $ 1,379,122 $ 1,219,655 $ 159,466 N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 195,969 $ 2,774,381 - $ 7,920,985 195,969 $ 2,358,224 - $ 235,822 - $ 2,122,401 - $ 416,157 - 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 11,202,425 2,023,767 $ 3,110,428 1,783,903 $ 8,091,997 239,864 $ 2,643,864 479,610 $ 264,386 47,961 $ 2,379,478 431,649 $ 466,564 84,637 [1] Projected costs for Quarter 12 9 (refer to QPR10QPR7) [2] Reference SOC dated February 16May 4, 2021 2020 subject to DWR Review Initial Starting Credit Request $575,808 Supplemental Credit Request $561,910 Authorized Local Credit by DWR (to date) $1,137,718 less Credit Payments received (Credit Payment No. 1) N/A Quarter 1 local share paid by State $52,037 Quarter 2 local share paid by State $96,436 Quarter 3 local share Paid by State $104,449 Quarter 4 local share Paid by State $121,286 Quarter 5 local share Paid by State $80,551 Pending Quarter 6 local share Paid by State Local (subject to DWR review) $107,683 108,513 Pending Quarter 7 local share Paid by State Local Share (subject to DWR Review) $64,826 64,813 Quarter 8 local share Paid by State Local Share (paid on 5/4/2020) $100,052 Pending 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 12 Local Share (subject to be Paid by State DWR Review) $18,824 84,637 Remaining Authorized Local Credit $0 324,945 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-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 H = G + F 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 132,936 79,263 $ 1,392,804 67,374 $ 1,525,739 6,737 $ 1,296,878 60,636 $ 129,688 217,572 $ 1,167,191 278,209 3 Design & ROW Support 85% $ 11,166 265,815 $ 3,885,653 225,943 $ 3,896,820 22,594 $ 3,312,297 203,349 $ 331,230 1,000,451 $ 2,981,067 1,203,799 4 Environmental Review & Permitting 85% $ 191,945 161,981 $ 754,732 137,684 $ 946,677 13,768 $ 804,675 123,915 $ 80,468 53,436 $ 724,208 177,351 5 ROW Acquisition N/A 85% $ 4,348,557 N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 2,774,381 10,695,365 $ 1,314,326 9,091,061 $ 4,088,706 909,106 $ 3,475,400 8,181,955 $ 347,540 (5,034,657) $ 3,127,860 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 1 Grant Application $ - $ - $ - $ - $ - $ - $ 3,110,428 - $ 7,347,514 - 2 Program Management $ 10,457,942 134,874 $ 8,889,251 905,879 $ 888,925 1,040,753 $ 8,000,326 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-11 8 [3} Payments received through December 2019 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,390,803 5,471,354 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 7/6/2020 In Progress $107,683 108,513 $0 $107,683 108,513 No Q9 Advance, Q6 Local True-Up *QPR8 12/20/2019 7/6/2020 In Progress $64,826 64,813 $0 $64,826 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 7/30/2020 This Report $84,531 84,637 $4,805,725 $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 4,890,362 Q12 Advance, Q9 Local True-Up Cumulative Payments $1,137,718 812,773 $27,192,698 21,775,948 $28,330,415 22,588,721 * 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] Subject to DWR Review QPR10 Total [2] Budget Remaining Budget 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $0 19,783 $0 $0 $21,284 19,783 2 Program Management @80.72% $185,425 $59,006 $158,002 $132,847 $17,802 43,324 $204,613 $278,209 $112,948 1,061,426 $390,000 1,773,417 $1,538,852 $170,984 $235,039 711,991 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $211,693 255,315 $815,819 $1,203,799 $223,927 3,793,208 $21,600 4,453,248 $3,995,112 $443,901 $572,415 660,040 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $7,850 19,257 $59,107 $177,351 $152,615 635,121 $180,000 1,024,641 $956,328 $106,259 $308,980 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 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 [1] Funding received through QPR12 QPR9 [2] Retention held on Total No Advance Request [3] Authorized Initial requested QPR4, QPR7, & Supplemental Credit complete as of QPR13QPR8
Appears in 1 contract
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 12 (July – September 2020) (reference the Quarter 10 report) as compared to the actual Costs for Quarter 12 15 & 16 (refer to SOC SOC’s included with this report dated February 16November 10, 2021). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 12 (July –September 2020)the quarters. Table 9-2 provides a reconciliation of the approved credit and approved and projected credit payments. 1 Grant Application 85% $ - $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 79,263 562,079 $ 132,936 477,767 $ (53,672) 47,777 $ 112,995 429,990 $ 11,300 $ 101,696 $ 19,940 84,312 3 Design & ROW Support 85% $ 265,815 23,581 $ 11,166 20,044 $ 254,649 2,004 $ 9,491 18,040 $ 949 $ 8,542 $ 1,675 3,537 4 Environmental Review & Permitting 85% $ 161,981 15,822 $ 191,945 13,449 $ (29,964) 1,345 $ 163,154 12,104 $ 16,315 $ 146,838 $ 28,792 2,373 5 ROW Acquisition 85% N/A N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project Aspects 85% $ 10,695,365 4,471,774 $ 2,774,381 3,801,008 $ 7,920,985 380,101 $ 2,358,224 3,420,907 $ 235,822 $ 2,122,401 $ 416,157 670,766 7 Closeout Process 85% $ - $ - $ - $ - $ - 8 500-Year Project 85% $ - 665,745 $ - 565,883 $ 11,202,425 56,588 $ 3,110,428 509,295 $ 8,091,997 99,862 $ 2,643,864 5,739,000 $ 264,386 4,878,150 $ 2,379,478 487,815 $ 466,564 4,390,335 $ 860,850 [1] Projected costs for Quarter 12 (refer to QPR10) [2] Reference the 16th & 17th SOC dated February 16November 10, 2021 subject to DWR Review 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 12 Local Share to be Paid by State $18,824 17,644 Remaining Authorized Local Credit $0 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-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost 1 Grant Application $ - $ - $ - $ - $ - $ - 2 Program Management $ 132,936 $ 1,392,804 $ 1,525,739 $ 1,296,878 $ 129,688 $ 1,167,191 3 Design & ROW Support $ 11,166 $ 3,885,653 $ 3,896,820 $ 3,312,297 $ 331,230 $ 2,981,067 4 Environmental Review & Permitting $ 191,945 $ 754,732 $ 946,677 $ 804,675 $ 80,468 $ 724,208 5 ROW Acquisition N/A N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project $ 2,774,381 $ 1,314,326 $ 4,088,706 $ 3,475,400 $ 347,540 $ 3,127,860 7 Closeout Process $ - $ - $ - $ - $ - $ - $ 3,110,428 $ 7,347,514 $ 10,457,942 $ 8,889,251 $ 888,925 $ 8,000,326 [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-11 QPR1 2/23/2018 3/9/2018 $0 $1,051,439 $1,051,439 QPR2 3/28/2018 9/17/2018 $52,037 $489,201 $541,238 QPR3 6/12/2018 8/21/2018 $96,436 $674,422 $770,858 QPR4 12/28/2018 2/7/2019 $104,449 $0 $104,449 QPR5 1/23/2019 3/28/2019 $121,286 $217,895 $339,181 QPR6 7/1/2019 8/22/2019 $80,551 $5,310,252 $5,390,803 QPR7 8/1/2019 7/6/2020 $107,683 $0 $107,683 QPR8 12/20/2019 7/6/2020 $64,826 $0 $64,826 QPR9 2/7/2020 5/4/2020 $100,052 $9,146,462 $9,246,514 QPR10 5/4/2020 7/30/2020 $84,531 $4,805,725 $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 $1,137,718 $27,192,698 $28,330,415 [1] Subject to DWR Review 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $21,284 2 Program Management $185,425 $59,006 $158,002 $132,847 $17,802 $204,613 $278,209 $112,948 $390,000 $1,538,852 $170,984 $235,039 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $211,693 $815,819 $1,203,799 $223,927 $21,600 $3,995,112 $443,901 $572,415 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $7,850 $59,107 $177,351 $152,615 $180,000 $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 $0 $0 $0 $0 [1] Funding received through QPR12 [2] Retention held on Total Advance Request [3] Authorized Initial & Supplemental Credit complete as of QPR130
Appears in 1 contract
Actual and Projected Costs. Table 9-1 provides a summary of the previously projected costs for Quarter 12 8 (July – September 20202019) (reference the Quarter 10 6 report) as compared to the actual Costs for Quarter 12 8 (refer to SOC included with this report dated February 1612, 20212019). Table 9-1 also shows the State Share True-Up amount and Local Credit True-Up amounts for the actual costs incurred during Quarter 12 8 (July –– September 20202019). Table 9-2 provides a reconciliation of the approved credit 1. TRLIA - 200-Year Goldfields Levee Project Prior Quarter Actual Cost Comparison and approved True-Up Element Description State Cost Share Previosly Projected Costs [1] Actual Costs for Quarter 8 [2] Difference between QTR and projected credit payments. Actual Actual State Cost Share Retention 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% $ 79,263 100,864 $ 132,936 154,521 $ (53,67253,658) $ 112,995 131,343 $ 11,300 13,134 $ 101,696 118,209 $ 19,940 23,178 3 Design & ROW Support 85% $ 265,815 268,941 $ 11,166 484,312 $ 254,649 (215,372) $ 9,491 411,666 $ 949 41,167 $ 8,542 370,499 $ 1,675 72,647 4 Environmental Review & Permitting 85% $ 161,981 79,652 $ 191,945 28,180 $ (29,964) 51,472 $ 163,154 23,953 $ 16,315 2,395 $ 146,838 21,558 $ 28,792 4,227 5 ROW Acquisition 85% N/A N/A N/A $ 4,694,419 $ 949,827 $ 3,744,592 N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 10,695,365 6,631,250 $ 2,774,381 - $ 7,920,985 6,631,250 $ 2,358,224 - $ 235,822 - $ 2,122,401 - $ 416,157 - 7 Closeout Process 85% $ - $ - $ - $ - $ - $ - $ - $ 11,202,425 11,775,126 $ 3,110,428 1,616,841 $ 8,091,997 10,158,285 $ 2,643,864 566,962 $ 264,386 56,696 $ 2,379,478 510,266 $ 466,564 100,052 [1] Projected costs for Quarter 12 8 (refer to QPR10QPR6) [2] Reference SOC dated February 1612, 2021 2020 subject to DWR Review Initial Starting Credit Request $575,808 Supplemental Credit Request $561,910 Authorized Local Credit by DWR (to date) $1,137,718 less Credit Payments received (Credit Payment No. 1) N/A Quarter 1 local share paid by State $52,037 Quarter 2 local share paid by State $96,436 Quarter 3 local share Paid by State $104,449 Quarter 4 local share Paid by State $121,286 Quarter 5 local share Paid by State $80,551 Pending Quarter 6 local share Paid by State (subject to DWR Review) $107,683 108,513 Pending Quarter 7 local share Paid by State Local Share (subject to DWR Review) $64,826 64,813 Pending Quarter 8 local share Paid by State Local Share (subject to DWR Review) $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 12 Local Share to be Paid by State $18,824 Remaining Authorized Local Credit $0 409,582 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-2. TRLIA - 200-Year Goldfields Levee Project: 12th Quarter Projected Cost 1 Grant Application 85% $ - $ - $ - $ - $ - $ - 2 Program Management 85% $ 132,936 166,736 $ 1,392,804 141,725 $ 1,525,739 14,173 $ 1,296,878 127,553 $ 129,688 139,916 $ 1,167,191 267,469 3 Design & ROW Support 85% $ 11,166 427,495 $ 3,885,653 363,371 $ 3,896,820 36,337 $ 3,312,297 327,034 $ 331,230 739,396 $ 2,981,067 1,066,429 4 Environmental Review & Permitting 85% $ 191,945 47,338 $ 754,732 40,237 $ 946,677 4,024 $ 804,675 36,213 $ 80,468 41,051 $ 724,208 77,265 5 ROW Acquisition N/A 85% $ 2,025,876 N/A N/A N/A N/A N/A 6 Construction, Mitigation, & Other Project 85% $ 2,774,381 20,366,778 $ 1,314,326 17,311,762 $ 4,088,706 1,731,176 $ 3,475,400 15,580,585 $ 347,540 (5,034,656) $ 3,127,860 10,545,929 7 Closeout Process 85% $ - $ - $ - $ - $ (932) $ (932) $ 23,034,224 $ 17,857,095 $ 1,785,710 $ 16,071,386 $ (4,115,226) $ 11,956,160 [1] Covers period from 4/1/20 to 7/31/20 (Q11) [2] Refer to Table 10-2 1 Grant Application $ - $ - $ - $ - $ - $ - $ 3,110,428 - 2 Program Management $ 7,347,514 154,521 $ 10,457,942 751,358 $ 8,889,251 769,997 $ 888,925 77,000 $ 8,000,326 692,998 $ 553,082 $ 139,916 3 Design & ROW Support $ 484,312 $ 2,743,613 $ 2,743,737 $ 274,374 $ 2,469,363 $ 1,729,968 $ 739,396 4 Environmental Review & Permitting $ 28,180 $ 531,695 $ 475,894 $ 47,589 $ 428,305 $ 387,253 $ 41,051 5 ROW Acquisition $ 949,827 $ 262,437 N/A N/A N/A $ - N/A 6 Construction, Mitigation, & Other Project $ - $ 50,000 $ 42,500 $ 4,250 $ 38,250 $ 5,072,906 $ (5,034,656) 7 Closeout Process $ - $ (1,218) $ (1,035) $ (104) $ (932) $ - $ (932) $ 1,616,841 $ 4,337,886 $ 4,031,093 $ 403,109 $ 3,627,984 $ 7,743,209 $ (4,115,226) [1] Reference Table 9-1, Total Subject to DWR Review [2] Reference Previously Approved DWR Statement of Costs for QTR1-11 7 [3} Payments received through September 2019 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,310,251 $5,390,803 5,390,802 Q8 Advance, Q5 Local True-Up *QPR7 8/1/2019 7/6/2020 In Progress $107,683 107,775 $0 $107,683 107,775 No Q9 Advance, Q6 Local True-Up *QPR8 12/20/2019 7/6/2020 In Progress $64,826 64,813 $0 $64,826 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 QPR10 5/4/2020 7/30/2020 $84,531 $4,805,725 $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 12,056,212 Q11 Advance, Q8 Local True-Up Cumulative Payments $1,137,718 727,398 $27,192,698 19,699,368 $28,330,415 [1] Subject to 20,426,767 * Pending DWR Review 1 Grant Application $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $21,284 2 Program Management $185,425 $59,006 $158,002 $132,847 $17,802 $204,613 $278,209 $112,948 $390,000 $1,538,852 $170,984 $235,039 3 Design & ROW Support $704,079 $384,609 $478,453 -$48,866 $211,693 $815,819 $1,203,799 $223,927 $21,600 $3,995,112 $443,901 $572,415 4 Envrionmental Review & Permitting $161,935 $45,587 $37,969 $133,914 $7,850 $59,107 $177,351 $152,615 $180,000 $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 $0 $0 $0 $0 [1] Funding received through QPR12 [2] Retention held on Total Advance Request [3] Authorized Initial & Supplemental Credit complete as of QPR13Approval
Appears in 1 contract
