Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2021-06-25 BPMC Agenda and docs
BRADLEY LAKE PROJECT MANAGEMENT COMMITTEE REGULAR MEETING AGENDA- AMENDED Friday, June 25, 2021 Immediately Following the 9:00 AM IMC Meeting To participate dial 1-888-585-9008 and use code 212-753-619# 1. CALL TO ORDER 2. ROLL CALL (for Committee members) 3. PUBLIC ROLL CALL (for all others present) 4. AGENDA APPROVAL 5. PUBLIC COMMENTS 6. APPROVAL OF MEETING MINUTES – May 21, 2021 7. EXECUTIVE SESSION – Discuss Budget Matters which the immediate knowledge of which would clearly have an adverse effect upon the finances of the Authority or the Project. 8. OLD BUSINESS A. By-Law Work Gibson B. Transmission Issues 9. NEW BUSINESS A. FY22 Proposed Budget Amend 2 10. OPERATORS REPORT HEA 11. O&D REPORT CEA 12. COMMITTEE REPORTS A. FY21 Budget to Actual Budget Subcommittee B. GVEA Call Back Notice Budget Subcommittee 13. COMMITTEE ASSIGNMENTS 14. MEMBERS COMMENTS 15. NEXT MEETING DATE – July 30, 2021 16. ADJOURNMENT ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTFY2022 PROPOSED BUDGET - AMEND 2DATE: JUNE 25, 2021 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECT2022 Budget ContentsScheduleDescriptionPage #Summary FY22 Proposed Budget Summary3Schedule A Bradley Lake Capital Purchases (not funded by R&C) 4Schedule B Bradley Lake Operations & Maintenance Budget 5 - 13Schedule C Bradley Lake Monthly Utility Contributions14Schedule D R&C Fund Disbursements and Repayments 15Schedule E Battle Creek Capital Purchases (not funded by R&C) 16Schedule F Battle Creek Operations & Maintenance Budget 17 - 18Schedule G Battle Creek Monthly Utility Contributions19Schedule H SSQ Line Capital Purchases (not funded by R&C) 20Schedule I SSQ Line Operations & Maintenance Budget 21Schedule J SSQ Line Monthly Utility Contributions22`6/22/202111:47 AMH:\Accounting\AEA FY22 FS Shared Files\Bradley Lake\Budget\Budget Amend 2\2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsx 2 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTBudget Summary FY2021 FY2022 FY2022 FY2022 Inc(Dec) FromFY2019 FY2020 Amended Amend 1 Proposed Amend 2 FY21 AmendedBradley Lake (excluding Battle Creek & SSQ Line shown below)Actuals Actuals Budget Budget Changes Budget Budget Revenues, Expenses & Changes in surplusRevenuesUtility Contributions (sch C) 18,132,905 18,507,495 16,403,421 10,553,726 619,733 11,173,459 (5,229,962)Other Miscellaneous-R&C Fund Cash Call 2,501 - 1,799,000 - - - (1,799,000)Interest Income 1,946,023 1,887,786 750,000 500 - 500 (749,500)Other Available Funds - - 1,325,513 9,893,771 - 9,893,771 8,568,25920,081,429 20,395,281 20,277,934 20,447,997 619,733 21,067,730 789,796ExpensesOperations & Maintenance (sch B) 4,019,975 4,773,126 5,798,702 5,947,908 516,444 6,464,352 665,650Renewals/Replacements (R&C Fund Repayments) (sch D) 2,774,832 2,278,302 1,184,753 1,256,902 (0) 1,256,902 72,149Renewals/Replacements (R&C Fund Cash Call) (sch D) - - 750,000 - - - (750,000)Non R&C Capital Purchases (sch A-1) 37,738 283,425 652,000 759,000 - 759,000 107,000 Transfer To(From) Operating Reserve 38,816 112,715 84,752 29,841 103,289 133,130 48,378 Debt Service 12,778,588 12,778,775 11,453,263 - - - (11,453,263) Arbitrage Transfer 431,480 168,938 354,464 0 - - (354,464) Excess Payment Agreement - - - 12,454,346 - 12,454,346 12,454,346 20,081,429 20,395,281 20,277,934 20,447,997 619,733 21,067,730 789,796 Surplus (Deficit)0000000 Other Project Costs - Battle Creek Revenues, Expenses & Changes in surplus Revenues - Battle Creek Utility Contributions (sch G) 1,319,734 1,967,642 6,013,048 3,564,453 - 3,564,453 (2,448,595) Other Miscellaneous-R&C Fund Cash Call - - - - - - 0 Interest Income 67,492 47,620 - - - - 0 Capital Reserve Contributions - - - - - - 0 Other Available Funds - - - - - - 0 1,387,226 2,015,262 6,013,048 3,564,453 - 3,564,453 (2,448,595) Expenses - Battle Creek Battle Creek Operations & Maintenance (sch F) 527,723 580,606 547,714 399,610 - 399,610 (148,104) Renewals/Replacements (R&C Fund Repayments) (sch D) - - 1,104,000 1,104,000 - 1,104,000 0 Renewals/Replacements (R&C Fund Cash Call) (sch D) - - - - - - 0 Capital Purchases (sch E)- - - - - - 0 Capital Purchases - Revenue Fund (sch E) 149,941 822,327 320,000 115,000 - 115,000 (205,000) Transfer To(From) Operating Reserve 82,038 (11,713)30,926 (29,621)- (29,621) (60,547) Debt Service 1,748,534 1,753,324 3,518,317 3,064,883 - 3,064,883 (453,434) IRS Subsidy (1,121,010) (1,129,282)- (1,089,419) - (1,089,419) (1,089,419) Cost of Issuance 9th Series - - - - - - 0 Capital Reserve Contribution - - 492,091 - - - (492,091) 1,387,226 2,015,262 6,013,048 3,564,453 - 3,564,453 (2,448,595) Surplus (Deficit)0000000 Other Project Costs - SSQ Line Revenues, Expenses & Changes in surplus Revenues - SSQ Line Utility Contributions (sch J)- - 360,000 499,428 (0)499,428 139,428 Other Miscellaneous-R&C Fund Cash Call - - - - - - 0 Capital Reserve Contributions - - - - - - 0 Other Available Funds - - - 1,559,492 - 1,559,492 1,559,492 - - 360,000 2,058,920 (0)2,058,920 1,698,920 Expenses - SSQ Line SSQ Line Operations & Maintenance (sch I) - - 170,000 444,523 0 444,523 274,523 Renewals/Replacements (R&C Fund Repayments) (sch D) - - - 0 - - 0 Renewals/Replacements (R&C Fund Cash Call) (sch D) - - - 0 - - 0 Capital Purchases (sch H)- - 190,000 0 - - (190,000) Transfer To(From) Operating Reserve - - - 54,905 (0)54,905 54,905 Debt Service - - - 1,559,492 - 1,559,492 1,559,492 Capital Reserve Contribution - - - 0 - - 0 - - 360,000 2,058,920 (0)2,058,920 1,698,920 Surplus (Deficit) 0 0 0 0 (0)00 Other Information Operating Reserve *957,494 1,070,208 1,159,740 1,189,582 1,292,870 Operating Reserve - Battle Creek* 90,798 79,085 109,543 79,922 79,922 Operating Reserve - SSQ Line*34,000 88,905 88,905 Monthly Contributions 1,511,075 1,632,040 1,366,952 879,477 931,122 Monthly Contributions Battle Creek 109,978 242,670 501,087 297,038 297,038 Monthly Contributions SSQ Line 30,000 41,619 41,619 *Required to be 20% of budgeted operating expense 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSummary Page 3 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTCapital Purchases (not funded by R&C Fund)Schedule AFY19 FY20 FY21 FY22 FY22 FY22Amended Amend 1 Proposed Amend 2ActualsActualsBudgetBudgetChangesBudgetComments for FY22:Replace/Automate Fish Water Valves & Actuators 17,142 2,931 40,000 - - - Upgrade Crews Quarters\Residence Kitchen - - 139,000 - 139,000 was on hold until DOWL is not occupying the Crews QuartersReplace 1988 Suburban Ambulance 5,350 - - - - Tire machine 15,246 - - - - Replace dump truck and sander - - 170,000 20,000 - 20,000 need new sanderPick up truck - 41,484 - - - UPS Replacement - 65,696 37,000 - - - Rough terrain fork lift (with plow for snow) - 131,594 - - - IRIS Air gap monitoring system (computer) - 41,720 45,000 45,000 - 45,000 Need for Unit 1KVM switch for Emerson - 3,000 - - - Spare Trash Pump - 20,000 - - - Housing Preliminary Design 10,000 - - - Emerson Cybersecurity Update 137,000 - - - Heavy Duty trailer for equipment - - 20,000 - 20,000 Smaller trailer for miniABB Replace GIS Actuators 240,000 - 240,000 no longer supportedReplacement pickup truck 45,000 - 45,000 Replace fuel truck (bad electrics)Needle Valve rebuild 150,000 - 150,000 Used up needle tip and cones in 2020/21 overhaulStart new servo design 100,000 - 100,000 Voith recommends new designTotal Non R&C Capital Purchases 37,738 283,425 462,000 759,000 - 759,000 Capital Project Description6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch APage 4 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTBradley Lake Operations and Maintenance BudgetSchedule BHEA3,145,798 2,436,506 709,292 3,822,764 3,020,964 801,799 4,066,378 4,112,706 - 4,112,706 46,328 CEA183,491 168,393 15,098 109,547 155,656 (46,109) 101,785 134,161 - 134,161 32,377 AEA1,458,178 1,415,076 43,102 1,418,731 1,596,506 (177,775) 1,641,784 1,891,750 - 2,408,194 766,410 BC- - - - - - (181,245) (190,710) - (190,710) (9,465) 4,787,467 4,019,975 767,492 5,351,042 4,773,126 577,915 5,628,702 5,947,908 - 6,464,352 835,650 - - - - - - - - - FY19 FY20 FY21 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20AmendedBudget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2Budget Increase (Decrease) From PY Summary by cost typeLabor & Benefits1,572,497 1,307,518 264,979 1,219,935 1,011,432 208,503 1,257,590 1,307,994 - 1,307,994 50,405 Indirect Costs583,803 579,114 4,689 1,383,388 1,251,241 132,147 1,486,285 1,486,285 - 1,486,285 0 Travel33,950 28,380 5,570 45,950 10,512 35,438 44,950 38,450 - 38,450 (6,500) Training49,300 20,956 28,344 49,300 14,875 34,425 49,300 49,300 - 49,300 - Contractual1,033,216 633,893 399,323 869,842 655,575 214,267 903,340 1,044,525 - 1,044,525 141,185 Supplies & Materials204,345 156,339 48,006 346,345 262,370 83,975 389,345 429,345 - 429,345 40,000 Other Costs69,818 31,293 38,525 67,818 65,648 2,170 70,818 67,318 - 67,318 (3,500) Equipment, Furniture and Machinery7,000 6,879 121 176,000 127,535 48,465 170,000 73,000 - 73,000 (97,000) Maintenance Projects- 44,926 (44,926) - 314 (314) - - - - - Administrative Costs1,233,537 1,210,677 22,860 1,192,464 1,373,624 (181,160) 1,438,319 1,642,400 516,444 2,158,844 720,525 Battle Creek O&M- - - - - - (181,245) (190,710) - (190,710) (9,465) 4,787,467 4,019,975 767,492 5,351,042 4,773,126 577,915 5,628,702 5,947,908 516,444 6,464,352 835,650 Bradley Lake O&M 4% charge to Battle CreekBattle Creek O&M- - - - - - (181,245) (190,710) - (190,710) BC(9,465) Bradley Lake O&M 4% charge to Battle CreekFERC 535 ‐ Operation Supervision & EngineeringOperations Sup/EngBradley Lake OperatingLabor & Benefits189,074 182,059 7,015 107,453 89,713 17,740 107,453 107,604 - 107,604 151 Indirect Costs77,849 74,535 3,314 155,698 128,545 27,153 155,698 155,698 - 155,698 - Travel10,450 13,462 (3,012) 10,450 246 10,204 10,450 10,450 - 10,450 - Training9,300 4,305 4,995 9,300 991 8,309 9,300 9,300 - 9,300 - Contractual1,000 257 743 1,000 173 827 11,000 11,000 - 11,000 - Supplies & Materials4,000 2,688 1,312 4,000 3,698 302 4,000 4,000 - 4,000 - Bradley Lake Operating Total291,673 277,306 14,367 287,901 223,366 64,536 297,901 298,053 - 298,053 151 FERC 535 ‐ Operation Supervision & Engineering Total 291,673 277,306 14,367 287,901 223,366 64,536 297,901 298,053 ‐ 298,053 HEA151 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch BPage 5 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20AmendedBudget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2Budget Increase (Decrease) From PY FERC 537 ‐ Hydraulic ExpensesHydraulic ExpensesBradley Lake OperatingLabor & Benefits88,714 71,767 16,947 84,081 67,694 16,387 84,192 84,192 - 84,192 - Indirect Costs41,515 42,543 (1,028) 107,519 98,886 8,633 114,320 114,320 - 114,320 - Travel- - - 10,000 - 10,000 10,000 8,000 - 8,000 (2,000) Contractual2,000 11,524 (9,524) 22,000 - 22,000 22,000 73,000 - 73,000 51,000 Supplies & Materials2,000 2,636 (636) 19,000 9,806 9,194 59,000 16,000 - 16,000 (43,000) Equipment, Furniture and Machinery- - - 81,000 13,368 67,632 32,000 39,000 - 39,000 7,000 Bradley Lake Operating Total134,230 128,470 5,760 323,600 189,754 133,846 321,512 334,512 - 334,512 13,000 FERC 537 ‐ Hydraulic Expenses Total 134,230 128,470 5,760 323,600 189,754 133,846 321,512 334,512 ‐ 334,512 HEA13,000 FERC 538 ‐ Electric ExpensesElectric ExpensesBradley Lake OperatingLabor & Benefits224,811 209,646 15,165 208,745 210,745 (2,000) 218,044 218,044 - 218,044 0 Indirect Costs102,222 110,544 (8,322) 242,067 257,551 (15,484) 262,004 262,004 - 262,004 (0) Travel7,000 4,890 2,110 7,000 3,140 3,860 7,000 7,000 - 7,000 - Training25,000 12,406 12,594 25,000 13,884 11,116 25,000 25,000 - 25,000 - Contractual2,000 - 2,000 7,000 2,587 4,413 2,000 5,000 - 5,000 3,000 Supplies & Materials9,732 4,503 5,229 50,732 14,111 36,621 41,732 42,732 - 42,732 1,000 Equipment, Furniture and Machinery- - - 63,000 91,512 (28,512) 73,000 11,000 - 11,000 (62,000) Other Costs- 5,000 - - - (5,000) Bradley Lake Operating Total370,765 341,989 28,776 603,544 593,530 10,014 633,780 570,780 - 570,780 (63,000) FERC 538 ‐ Electric Expenses Total 370,765 341,989 28,776 603,544 593,530 10,014 633,780 570,780 ‐ 570,780 HEA(63,000) 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch BPage 6 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20AmendedBudget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2Budget Increase (Decrease) From PY FERC 539 ‐ Misc. Hydraulic Power Generation ExpensesMisc Hydro Power ExpBradley Lake OperatingLabor & Benefits168,044 116,910 51,134 104,936 70,195 34,741 105,047 104,788 - 104,788 (258) Indirect Costs41,515 42,396 (881) 107,519 98,544 8,975 114,320 114,320 - 114,320 0 Training15,000 4,245 10,755 15,000 - 15,000 15,000 15,000 - 15,000 - Contractual287,525 147,555 139,970 287,525 185,822 101,703 287,525 287,525 - 287,525 - Supplies & Materials17,900 31,565 (13,665) 17,900 31,569 (13,669) 17,900 17,900 - 17,900 - Bradley Lake Operating Total529,984 342,671 187,313 532,879 386,130 146,749 539,791 539,533 - 539,533 HEA(258) BRADLEY CIRCUITS/RADIO TO BERNICE LKOther Costs35,695 35,696 (1) 35,695 35,696 (1) 35,695 35,695 - 35,695 - BRADLEY CIRCUITS/RADIO TO BERNICE LK Total35,695 35,696 (1) 35,695 35,696 (1) 35,695 35,695 - 35,695 HEA- BRADLEY CIRCUITS BERNICE LK TO ANCHOther Costs29,773 29,524 249 29,773 29,194 579 29,773 29,773 - 29,773 - BRADLEY CIRCUITS BERNICE LK TO ANCH Total29,773 29,524 249 29,773 29,194 579 29,773 29,773 - 29,773 CEA - FERC 539 ‐ Misc. Hydraulic Power Generation Expenses Total 595,452 407,891 187,561 598,347 451,020 147,327 605,259 605,001 ‐ 605,001 (258) FERC 540 ‐ RentsFERC Land Use FeeBradley Lake OperatingOther Costs- (35,289) 35,289 - - - - - - - - Bradley Lake Operating Total- (35,289) 35,289 - - - - - - - - FERC 540 ‐ Rents Total ‐ (35,289) 35,289 ‐ ‐ ‐ ‐ ‐ ‐ ‐ AEA‐ FERC 541 ‐ Maintenance Supervision & EngineeringMaint Supervision/EngBradley Lake OperatingLabor & Benefits195,817 181,894 13,923 114,456 84,904 29,552 114,456 114,758 - 114,758 302 Indirect Costs77,849 74,373 3,476 155,698 121,096 34,602 155,698 155,698 - 155,698 - Bradley Lake Operating Total273,666 256,267 17,399 270,154 206,000 64,154 270,154 270,456 - 270,456 302 - FERC 541 ‐ Maintenance Supervision & Engineering Total 273,666 256,267 17,399 270,154 206,000 64,154 270,154 270,456 ‐ 270,456 HEA302 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch BPage 7 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20AmendedBudget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2Budget Increase (Decrease) From PY FERC 542 ‐ Maintenance of StructuresMaintenance of StructuresBradley Lake OperatingLabor & Benefits85,438 67,934 17,504 76,499 62,612 13,887 77,639 77,639 - 77,639 0 Indirect Costs37,066 37,809 (743) 97,823 91,244 6,579 105,421 105,421 - 105,421 (0) Contractual10,000 - 10,000 91,000 3,682 87,318 59,000 89,000 - 89,000 30,000 Supplies & Materials53,713 46,903 6,810 88,713 39,489 49,224 100,713 243,713 - 243,713 143,000 Equipment, Furniture and Machinery7,000 6,879 121 32,000 22,552 9,448 52,000 23,000 - 23,000 (29,000) Maintenance Projects- - - - - - - - - - - Bradley Lake Operating Total193,217 159,525 33,692 386,035 219,579 166,456 394,773 538,773 - 538,773 144,000 BRADLEY UPGRADE CREWS QUARTERS/RESIDENCE KITCHENContractual165,000 - - - - - - - - - - BRADLEY UPGRADE CREWS QUARTERS/RESIDENCE KITCHEN165,000 - - - - - - - - - - FERC 542 ‐ Maintenance of Structures Total 358,217 159,525 198,692 386,035 219,579 166,456 394,773 538,773 ‐ 538,773 HEA144,000 FERC 543 ‐ Maintenance of Reservoirs, Dams & WaterwaysMaint Res, Dams, WWaysBradley Lake OperatingLabor & Benefits45,552 4,723 40,829 45,080 1,335 43,745 40,744 40,744 - 40,744 0 Indirect Costs19,932 87 19,845 56,322 1,693 54,629 56,689 56,689 - 56,689 (0) Travel5,000 5,000 - 5,000 - Contractual6,500 7,600 (1,100) 6,500 - 6,500 6,500 6,500 - 6,500 - Supplies & Materials15,000 15,000 - 15,000 - Bradley Lake Operating Total71,984 12,410 59,574 107,902 3,028 104,874 123,933 123,933 - 123,933 - BRADLEY NUKA REPAIRContractual15,000 - 15,000 - - - - - - - - Supplies & Materials- - - - - - - - - - - Equipment, Furniture and Machinery- - - - - - - - - - - BRADLEY NUKA REPAIR Total15,000 - 15,000 - - - - - - - - BRADLEY POWER TUNNEL MAINT (Dam)Contractual15,000 - 15,000 15,000 - 15,000 15,000 15,000 - 15,000 - - BRADLEY POWER TUNNEL MAINT (Dam) Total15,000 - 15,000 15,000 - 15,000 15,000 15,000 - 15,000 - - FERC 543 ‐ Maintenance of Reservoirs, Dams & Waterways Total 101,984 12,410 89,574 122,902 3,028 119,874 138,933 138,933 ‐ 138,933 HEA‐ 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch BPage 8 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20AmendedBudget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2Budget Increase (Decrease) From PY FERC 544 ‐ Maintenance of Electric PlantMaintenance of Elec PlantBradley Lake OperatingLabor & Benefits342,265 285,366 56,899 273,620 249,706 23,914 309,110 309,110 - 309,110 - Indirect Costs148,789 156,963 (8,174) 368,424 362,402 6,022 423,178 423,178 - 423,178 - Travel4,500 216 4,284 4,500 - 4,500 4,500 4,500 - 4,500 - Contractual70,000 69,475 525 49,000 19,661 29,339 86,000 49,000 - 49,000 (37,000) Supplies & Materials20,000 16,571 3,429 70,000 66,370 3,630 38,000 30,000 - 30,000 (8,000) Maintenance Projects- 44,926 (44,926) - - - - - - - - Bradley Lake Operating Total585,554 573,517 12,037 765,544 698,139 67,405 860,788 815,788 - 815,788 (45,000) BRADLEY HIGH BAY LIGHTS- Supplies & Materials30,000 - 30,000 - - - - - - - - BRADLEY HIGH BAY LIGHTS Total30,000 - 30,000 - - - - - - - - FERC 544 ‐ Maintenance of Electric Plant Total 615,554 573,517 42,037 765,544 698,139 67,405 860,788 815,788 ‐ 815,788 HEA(45,000) FERC 545 ‐ Maintenance of Misc. Hydraulic PlantMaint of Misc Hydr PlantBradley Lake OperatingLabor & Benefits85,438 70,963 14,475 69,395 62,843 6,552 69,297 69,297 - 69,297 (0) Indirect Costs37,066 39,864 (2,798) 92,318 91,280 1,038 98,957 98,957 - 98,957 0 Contractual3,900 - 3,900 3,900 6,763 (2,863) 3,900 3,900 - 3,900 - Supplies & Materials35,000 33,168 1,832 63,000 93,510 (30,510) 58,000 34,000 - 34,000 (24,000) Maintenance Projects- 314 (314) - - - Bradley Lake Operating Total161,404 143,995 17,409 228,613 254,710 (26,097) 230,154 206,154 - 206,154 (24,000) BRADLEY FISH WATER DSGN/MIDDLE FORK SHACK IMPRContractual- - - - - - - - - - - Supplies & Materials- - - - - - - - - - - BRADLEY FISH WATER DSGN/MIDDLE FORK SHACK IMPR Total- - - - - - - - - - - FERC 545 ‐ Maintenance of Misc. Hydraulic Plant Total 161,404 143,995 17,409 228,613 254,710 (26,097) 230,154 206,154 ‐ 206,154 HEA(24,000) 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch BPage 9 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20AmendedBudget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2Budget Increase (Decrease) From PY FERC 556 ‐ System Control & Load DispatchingSystem Cntl & Load DispBradley Lake OperatingLabor & Benefits21,506 20,920 586 21,140 37,092 (15,952) 21,140 19,708 - 19,708 (1,432) Contractual53,000 44,800 8,200 53,000 57,365 (4,365) 53,000 53,000 - 53,000 - Supplies & Materials6,000 613 5,387 6,000 3,204 2,796 6,000 6,000 - 6,000 - Equipment, Furniture and Machinery- - - - - - - - - - - Bradley Lake Operating Total80,506 66,333 14,173 80,140 97,661 (17,521) 80,140 78,708 - 78,708 HEA(1,432) BRADLEY EMERSON ANTIVIRUS UPGRADEContractual40,000 41,740 (1,740) - - - - - - - HEA- BRADLEY EMERSON ANTIVIRUS UPGRADE Total40,000 41,740 (1,740) - - - - - - - - Snow MeasurementBradley Lake OperatingContractual12,000 10,000 2,000 10,000 10,000 - 10,000 10,000 - 10,000 AEA- Bradley Lake Operating Total12,000 10,000 2,000 10,000 10,000 - 10,000 10,000 - 10,000 - Seismic ServiceBradley Lake OperatingContractual62,000 61,569 431 62,000 56,310 5,690 62,000 62,000 - 62,000 AEA- Bradley Lake Operating Total62,000 61,569 431 62,000 56,310 5,690 62,000 62,000 - 62,000 - Streamguaging ServBradley Lake OperatingContractual206,291 186,291 20,000 209,917 189,917 20,000 183,615 218,000 - 218,000 AEA34,385 Bradley Lake Operating Total206,291 186,291 20,000 209,917 189,917 20,000 183,615 218,000 - 218,000 34,385 PermitsBradley Lake OperatingOther Costs350 250 100 350 758 (408) 350 350 - 350 AEA- Bradley Lake Operating Total350 250 100 350 758 (408) 350 350 - 350 - FERC 556 ‐ System Control & Load Dispatching Total 401,147 366,183 34,964 362,407 354,646 7,761 336,105 369,058 ‐ 369,058 32,953 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch BPage 10 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20AmendedBudget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2Budget Increase (Decrease) From PY FERC 562 ‐ Station ExpensesStation ExpensesSVC/Substation Maintenance ContractLabor & Benefits94,718 83,226 11,492 59,774 72,086 (12,312) 55,712 62,388 - 62,388 CEA6,677 Travel2,000 1,632 368 4,000 2,596 1,404 4,500 3,500 - 3,500 CEA(1,000) Contractual32,000 35,207 (3,207) 2,000 51,167 (49,167) 1,800 2,000 - 2,000 CEA200 Supplies & Materials21,000 17,692 3,308 12,000 613 11,387 10,000 10,000 - 10,000 CEA- Other Costs4,000 1,112 2,888 2,000 - 2,000 - 1,500 - 1,500 CEA1,500 Equipment, Furniture and Machinery- - - - - - - - - - CEA- Maintenance Projects- - - - - - - - - - CEA- Labor & Benefits- - - 27,298 - 27,298 27,298 71,759 - 71,759 HEA44,461 Contractual- - - - - - - 59,600 - 59,600 HEA59,600 Supplies & Materials- - - 10,000 - 10,000 34,000 5,000 - 5,000 HEA(29,000) Equipment, Furniture and Machinery- - - - - - 13,000 - - - HEA(13,000) - SVC/Substation Maintenance Contract Total153,718 138,869 14,849 117,072 126,462 (9,390) 146,309 215,747 - 215,747 69,438 FERC 562 ‐ Station Expenses Total 153,718 138,869 14,849 117,072 126,462 (9,390) 146,309 215,747 ‐ 215,747 69,438 FERC 563 ‐ Weather Monitoring Power SupBradley Lake OperatingContractual‐ ‐ - ‐ 5,244 (5,244) AEA‐ Bradley Lake Operating Total ‐ ‐ ‐ ‐ 5,244 (5,244) ‐ FERC 571 ‐ Maintenance of Overhead LinesMaint of OH LinesBradley Lake OperatingLabor & Benefits31,120 12,110 19,010 27,459 2,507 24,952 27,459 27,963 - 27,963 504 Travel10,000 8,180 1,820 10,000 4,530 5,470 - - - - - Contractual50,000 17,875 32,125 50,000 66,884 (16,884) 100,000 100,000 - 100,000 - Supplies & Materials5,000 - 5,000 5,000 - 5,000 5,000 5,000 - 5,000 - Equipment, Furniture and Machinery- - - - 103 (103) - - - - - Bradley Lake Operating Total96,120 38,165 57,955 92,459 74,024 18,435 132,459 132,963 - 132,963 HEA504 FERC 571 ‐ Maintenance of Overhead Lines Total 96,120 38,165 57,955 92,459 74,024 18,435 132,459 132,963 ‐ 132,963 504 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch BPage 11 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20AmendedBudget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2Budget Increase (Decrease) From PY FERC 920 & 930 ‐ Administrative ExpenseAEA Bradley Admin FeesBradley Lake OperatingAdministrative Costs200,000 200,000 - 200,000 200,000 - 201,000 274,000 - 274,000 73,000 Administrative Costs2,500 2,500 - 2,500 - Travel3,500 - - - (3,500) Bradley Lake Operating Total200,000 200,000 - 200,000 200,000 - 207,000 276,500 - 276,500 AEA69,500 Operating Committee Exp‐AuditBradley Lake OperatingAdministrative Costs16,500 19,900 (3,400) 19,900 20,298 (398) 19,900 19,900 ‐ 19,900 AEA ‐ Bradley Lake Operating Total16,500 19,900 (3,400) 19,900 20,298 (398) 19,900 19,900 - 19,900 - Operating Committee Exp‐LegalBradley Lake OperatingAdministrative Costs25,000 140,453 (115,453) 30,000 215,162 (185,162) 70,000 70,000 ‐ 70,000 AEA ‐ Bradley Lake Operating Total25,000 140,453 (115,453) 30,000 215,162 (185,162) 70,000 70,000 - 70,000 - Operat Committee Exp‐ArbitrageBradley Lake OperatingAdministrative Costs2,935 2,785 150 3,000 2,685 315 5,000 5,000 ‐ 5,000 AEA ‐ Bradley Lake Operating Total2,935 2,785 150 3,000 2,685 315 5,000 5,000 - 5,000 - Trust & Account FeesBradley Lake OperatingAdministrative Costs11,918 11,918 - 11,918 12,118 (200) 13,000 13,000 - 13,000 AEA - Bradley Lake Operating Total11,918 11,918 - 11,918 12,118 (200) 13,000 13,000 - 13,000 - Misc AdminBradley Lake OperatingAdministrative Costs10,350 11,646 (1,296) 11,646 12,000 (354) 18,900 12,000 - 12,000 AEA (6,900) Bradley Lake Operating Total10,350 11,646 (1,296) 11,646 12,000 (354) 18,900 12,000 - 12,000 (6,900) FERC 920 & 930 ‐ Administrative Expense Total 266,703 386,702 (119,999) 276,464 462,263 (185,799) 333,800 396,400 ‐ 396,400 62,600 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch BPage 12 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20AmendedBudget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2Budget Increase (Decrease) From PY FERC 924 & 925 ‐ Insurance PremiumsInsurance PremiumsBradley Lake OperatingAdministrative Costs600,834 599,218 1,616 575,000 613,782 (38,782) 692,019 850,000 516,444 1,366,444 AEA674,425 Administrative Costs56,000 18,422 37,578 56,000 39,347 16,653 56,000 16,000 16,000 HEA(40,000) Bradley Lake Operating Total656,834 617,640 39,194 631,000 653,129 (22,129) 748,019 866,000 516,444 1,382,444 634,425 Risk Management Bradley Lake OperatingAdministrative Costs- - - - - - - 25,000 25,000 CEA25,000 Bradley Lake Operating Total- - - - - - - 25,000 - 25,000 25,000 FERC 924 & 925 ‐ Insurance Premiums Total 656,834 617,640 39,194 631,000 653,129 (22,129) 748,019 891,000 516,444 1,407,444 659,425 FERC 928 ‐ Regulatory Commission ExpensesFERC Admin FeesAdministrative Costs185,000 101,775 83,225 185,000 169,976 15,024 175,000 150,000 150,000 AEA (25,000) Bradley Lake Operating Total185,000 101,775 83,225 185,000 169,976 15,024 175,000 150,000 - 150,000 (25,000) FERC Related Prof ServicesFERC Part 12 InspectionAdministrative Costs- - - - - - 75,000 25,000 25,000 AEA (50,000) Contractual Engineer‐FERC license issuesAdministrative Costs125,000 104,560 20,440 100,000 88,256 11,744 110,000 180,000 180,000 AEA 70,000 Bradley Lake Operating Total125,000 - 125,000 100,000 88,256 11,744 185,000 205,000 - 205,000 20,000 FERC 928 ‐ Regulatory Commission Expenses Total 310,000 206,335 103,665 285,000 258,232 26,768 360,000 355,000 ‐ 355,000 (5,000) Total Bradley Lake Budget 4,787,467 4,019,975 767,492 5,351,042 4,773,126 577,915 5,628,702 5,947,908 516,444 6,464,352 835,650 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch BPage 13 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTMonthly Utility Contributions Schedule CFY2019 FY2020 FY2021 FY2022 FY2022 FY2022 FY2021 toPercent Amended Amended Amended Amend 1 Proposed Amend 1 FY2022Power PurchaserShareBudgetBudgetBudgetBudgetChangesBudgetChangeChugach Electric (combined w ML&P) 56.3%10,701,072 11,026,056 9,235,126 5,941,748 348,909 6,290,657 (2,944,469) Homer Electric 12.0%2,280,864 2,350,140 1,968,409 1,266,446 74,368 1,340,814 (627,595) Matanuska Electric 13.8%2,622,996 2,702,664 2,263,673 1,456,415 85,523 1,541,938 (721,735) Golden Valley Electric 16.9%3,212,220 3,309,780 2,772,178 1,783,580 104,735 1,888,315 (883,863) City of Seward 1.0%190,068 195,840 164,035 105,537 6,198 111,735 (52,300) Rounding(1) 5 - 100.0%19,007,219 19,584,485 16,403,421 10,553,726 619,733 11,173,459 (5,229,962) Percent FY2019 FY2020 FY2021 FY2022 FY2022 FY2022Power PurchaserShareMonthlyMonthlyMonthlyMonthlyProposedAmend 1ChangesBudgetChugach Electric (combined w ML&P) 56.3%891,756 918,838 900,902 495,146 29,076 524,221(376,681) Homer Electric 12.0%190,072 195,845 192,021 105,537 6,197 111,735(80,287) Matanuska Electric 13.8%218,583 225,222 220,826 121,368 7,127 128,495(92,331) Golden Valley Electric 16.9%267,685 275,815 270,431 148,632 8,728 157,360(113,071) City of Seward 1.0%15,839 16,320 16,002 8,795 516 9,311(6,690) - 100.0%1,583,935 1,632,040 1,600,181 879,477 51,644 931,122 (669,060) 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch CPage 14 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTR&C Fund Disbursements and RepaymentsSchedule D Actual ACTUAL Actual ACTUAL PROJECTED PROJECTED PROJECTED PROJECTED TO REPAY TO REPAY TO REPAY TO REPAYDescription Disburse at 06/30/19 Disburse at 06/30/20 Disburse at 06/30/21 Disburse at 06/30/22R&C FUND PROJECTSGovernor 0.00 4,052,070.14 0.00 4,052,070.14 0.00 4,052,070.14 0.00 4,052,070.14Replace RFLS 0.00 251,092.69 0.00 251,092.69 0.00 251,092.69 0.00 251,092.69Replace Runners 0.00 1,946,732.79 0.00 1,946,732.79 0.00 1,946,732.79 0.00 1,946,732.79Replace cable from dam to power house 0.00 2,321,922.94 0.00 2,321,922.94 0.00 2,321,922.94 0.00 2,321,922.94Replace power system stabilizer 0.00 619,205.10 0.00 619,205.10 0.00 619,205.10 0.00 619,205.10Replace two RTUs 0.00 86,905.27 0.00 86,905.27 0.00 86,905.27 0.00 86,905.27 Culvert Repairs 0.00 675,966.79 0.00 675,966.79 0.00 675,966.79 0.00 675,966.79 Trans Towers Frost Jacking Repairs 0.00 887,596.62 0.00 887,596.62 0.00 887,596.62 0.00 887,596.62 Replace Plant and SCADA Controls 0.00 1,344,683.05 0.00 1,344,683.05 0.00 1,344,683.05 0.00 1,344,683.05 Vibration Monitoring System 0.00 490.00 0.00 490.00 0.00 490.00 0.00 490.00 Battle Creek Feasibility 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fire Alarm System Replacement 0.00 0.00 41,179.09 41,179.09 150,000.00 191,179.09 150,000.00 341,179.09 Battle Creek Diversion 0.00 1,170,000.00 0.00 1,170,000.00 0.00 1,170,000.00 0.00 1,170,000.00 Replace Electro-Mechanical Relays 0.00 1,277,197.06 0.00 1,277,197.06 0.00 1,277,197.06 0.00 1,277,197.06 Fishwater Screen Debris Removal 0.00 312,236.43 0.00 312,236.43 0.00 312,236.43 0.00 312,236.43 Turbine Nozzle Repair 0.00 1,428,861.07 0.00 1,428,861.07 0.00 1,428,861.07 0.00 1,428,861.07 Spillway Raise 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 SVC replacement Daves Creek | Soldotna 0.00 8,517,991.11 0.00 8,517,991.11 0.00 8,517,991.11 0.00 8,517,991.11 Equipment Storage Shed 510,550.13 510,550.13 0.00 510,550.13 0.00 510,550.13 0.00 510,550.13 Emerson Operating System Upgrade 622,665.00 622,665.00 0.00 622,665.00 0.00 622,665.00 0.00 622,665.00 Generator #2 Relacement 582,341.67 582,341.67 370,871.04 953,212.71 0.00 953,212.71 0.00 953,212.71 Road Grader 0.00 0.00 0.00 0.00 370,000.00 370,000.00 0.00 370,000.00 Battle Creek Construction 0.00 3,666,000.00 3,666,000.00 0.00 3,666,000.00 Battle Creek Cash Call 0.00 750,000.00 750,000.00 0.00 750,000.00 Repayment through Cash Call 0.00 (750,000.00) (750,000.00) 0.00 (750,000.00) Needle Rapairs 0.00 1,500,000.00 1,500,000.00 0.00 1,500,000.00 Construct additional residence 0.00 0.00 980,000.00 980,000.00 Spillway Raise & Expansion Project 500,000.00 500,000.00 1,715,556.80 26,608,507.86 412,050.13 27,020,557.99 5,686,000.00 32,706,557.99 1,630,000.00 34,336,557.99 Current Year R&C Repayment (2,746,068.00) (2,121,396.10) (2,288,753.22) (2,360,901.73) Adjust bal to $5 mill (won't be corrected until year end) 0.00 0.00 0.00 0.00 Less Interest in Fund Applied to Repayment (117,149.21) (175,199.84) (269,486.35) 0.00 Net Transfer from Revenue Fund (2,863,217.21) (2,296,595.94) (2,558,239.57) (2,360,901.73) Cumulative Prior Years R&C Repayments (20,465,255.55) (23,240,089.01) (25,518,390.50) (28,076,630.07) Due back to Utilities 88,383.75 18,294.45 0.00 0.00 R&C Cumulative Interest (Retained) Applied As Part of Repayment 0.00 0.00 0.00 0.00 Net R&C Repayments (20,376,871.80) (23,221,794.56) (25,518,390.50)(28,076,630.07) NET DUE TO R&C FUND 3,368,418.85 1,502,167.49 4,629,927.92 3,899,026.19 R&C FUND CASH FLOW PROJECTION Beginning Investment Balance 1,013,291.03 2,435,913.25 3,922,231.19 370,072.08 Disbursements-current year (999,608.45) (412,050.13) (5,686,000.00) (1,630,000.00) Disbursements-prior year accrued 0.00 (309,844.12) (406,104.23) 0.00 R&C Repayment to utilities (440,986.54) (88,383.75) (18,294.45) 0.00 Net other cash inflow(outflow) 0.00 0.00 0.00 0.00 Current year interest earnings 117,149.21 175,199.84 269,486.35 0.00 Current year Participants Contributions to R&C 2,746,068.00 2,121,396.10 2,288,753.22 2,360,901.73 Ending Investment Balance 2,435,913.25 3,922,231.19 370,072.08 1,100,973.82 Accrued R&C Payable at year end-Due to Utilities (88,383.75) (18,294.45) 0.00 0.00 Accrued R&C vendor Payable at year end (715,948.35) (406,104.23) 0.00 0.00 PROJECTED NET DUE + ENDING INVESTMENT BALANCE 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 REPAYMENT AMOUNT $3,330,802.80 X 25% yr 1 | 32% yr 2 |25% yr 3 | 18% yr 4 4th yr 599,544.50 $5,644,193.08 x 25% all 4 years 3rd yr 1,411,048.27 4th yr 1,411,048.27 $1,341,405.96 x 25% all 4 years 2nd yr 335,351.49 3rd yr 335,351.49 4th yr 335,351.49 $1,715,556.80 x 25% all 4 years 1st yr 428,889.20 2nd yr 428,889.20 3rd yr 428,889.20 4th yr 428,889.20 $150,000 x 25% all 4 years 1st yr 103,012.53 2nd yr 103,012.53 3rd yr 103,012.53 $520,000 x 25% all 4 years 1st yr 1,421,500.00 2nd yr 1,421,500.00 1st yr 407,500.00 2,774,833.46 2,278,301.49 2,288,753.22 2,360,901.73 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsx Sch D Page 15 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTBattle CreekCapital Purchases (not funded by R&C Fund)Schedule EFY19 FY20 FY21 FY22 FY22 FY22Amended Amend 1 Proposed Amend 2ActualsActualsBudgetBudgetChangesBudgetComments for FY22:Battle Creek Diversion 149,941 822,327 320,000 - Battle Creek Associated Costs 15,000 - 15,000 Small general parts for repairsVent Enlargment 50,000 - 50,000 Pressure Sensor w SCADA 25,000 - 25,000 Power feed to LBC Bridge 25,000 - 25,000 Total Non R&C Capital Purchases 149,941 822,327 320,000 115,000 - 115,000 Capital Construction Project Description6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch EPage 16 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTBattle Creek Operations & Maintenance BudgetSchedule FHEA262,438 319,073 (56,635) 268,524 332,875 (64,351) 92,569 - - - (92,569) CEA- ‐ - - ‐ - - - - - - AEA191,550 208,651 (17,101) 126,900 247,731 (120,831) 273,900 208,900 - 208,900 (65,000) BL- - - - - - 181,245 190,710 - 190,710 9,465 453,988 527,724 (73,736) 395,424 580,606 (185,182) 547,714 399,610 ‐ 399,610 (148,104) ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ FY19 FY21 FY22 FY19 Amended Budget Actual (Over) Under Budget FY20AmendedBudget Actual (Over) Under Budget FY21AmendedBudget FY22Amend 1 Budget FY22Proposed Changes FY22Amend 2Budget Increase (Decrease) from PY Summary by cost type- - Administrative Costs453,988 527,724 (73,736) 395,424 580,606 (185,182) 255,469 82,900 - 82,900 (172,569) Battle Creek O&M ‐ Bradley Allocation- - - - - - 181,245 190,710 - 190,710 9,465 Battle Creek O&M111,000 126,000 - 126,000 15,000 453,988 527,724 (73,736) 395,424 580,606 (185,182) 547,714 399,610 ‐ 399,610 (148,104) Bradley Lake O&M 4% charge to Battle Creek - Battle Creek O&M- - - - - - 181,245 190,710 - 190,710 BL9,465 FERC 537 ‐ Hydraulic ExpensesHydraulic ExpensesBattle Creek OperatingLabor & Benefits- - - - - - - - - - Indirect Costs- - - - - - - - - - Travel- - - - - - - - - - Training- - - - - - - - - - Contractual- - - - - - 66,000 81,000 81,000 AEA15,000 Supplies & Materials- - - - - - - - Equipment, Furniture and Machinery- - - - - - - - Bradley Lake Operating Total- - - - - - 66,000 81,000 ‐ 81,000 15,000 FERC 537 ‐ Hydraulic Expenses Total- - - - - - 66,000 81,000 ‐ 81,000 15,000 FERC 556 ‐ System Control & Load DispatchingStreamgaging ExpensesBattle Creek OperatingLabor & Benefits- - - - - - - - - - Indirect Costs- - - - - - - - - - Travel- - - - - - - - - - Training- - - - - - - - - - Contractual- - - - - - 45,000 45,000 45,000 AEA- Supplies & Materials- - - - - - - - - - Equipment, Furniture and Machinery- - - - - - - - - - Bradley Lake Operating Total- - - - - - 45,000 45,000 ‐ 45,000 - FERC 556 ‐ System Control & Load Dispatching Total- - - - - - 45,000 45,000 ‐ 45,000 - FY20 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch FPage 17 of 22 FY19 FY21 FY22 FY19 Amended Budget Actual (Over) Under Budget FY20AmendedBudget Actual (Over) Under Budget FY21AmendedBudget FY22Amend 1 Budget FY22Proposed Changes FY22Amend 2Budget Increase (Decrease) from PY FY20 - FERC 920 & 930 ‐ Administrative ExpenseBattle Creek Admin FeesAdministrative Costs8,193 7,421 772 12,274 12,274 0 11,419 - - HEA(11,419) Administrative Costs168,000 168,000 - 105,000 105,051 (51) 122,000 71,000 71,000 AEA(51,000) Battle Creek Admin Fees Total176,193 175,421 772 117,274 117,325 (51) 133,419 71,000 - 71,000 (62,419) Operating Committee Exp‐Owners RepresentativeAdministrative Costs254,245 311,652 (57,407) 256,250 320,601 (64,351) 81,150 ‐ ‐ HEA(81,150) Operating Committee Exp‐Owners Representative Total254,245 311,652 (57,407) 256,250 320,601 (64,351) 81,150 - - - (81,150) - Operating Committee Exp‐Legal- Administrative Costs15,000 34,795 (19,795) 15,000 135,880 (120,880) 30,000 5,000 5,000 AEA (25,000) Operating Committee Exp‐Legal Total15,000 34,795 (19,795) 15,000 135,880 (120,880) 30,000 5,000 - 5,000 (25,000) - Operat Committee Exp‐Arbitrage- Administrative Costs2,000 1,690 310 2,000 1,690 310 2,000 2,000 2,000 AEA - Operat Committee Exp‐Arbitrage Total2,000 1,690 310 2,000 1,690 310 2,000 2,000 - 2,000 - Trust & Account FeesAdministrative Costs6,550 4,083 2,467 4,800 5,000 (200) 8,800 4,800 4,800 AEA (4,000) Trust & Account Fees Total6,550 4,083 2,467 4,800 5,000 (200) 8,800 4,800 - 4,800 (4,000) Operating Committee Exp‐Other Administrative Costs- 83 (83) 100 110 (10) 100 100 100 AEA- Operating Committee Exp‐Other Total- 83 (83) 100 110 (10) 100 100 - 100 - - - FERC 920 & 930 ‐ Administrative Expense Total 453,988 527,724 (73,736) 395,424 580,606 (185,182) 255,469 82,900 ‐ 82,900 (172,569) Total Bradley Lake Budget 453,988 527,724 (73,736) 395,424 580,606 (185,182) 547,714 399,610 ‐ 399,610 (148,104) 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch FPage 18 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTBattle Creek Monthly Participating Purchaser ContributionsSchedule GFY2019 FY2020 FY2021 FY2022 FY2022 FY2022 FY2021 toPercent Amended Amended Amended Amend 1 Proposed Amend 2 FY2022POWER PURCHASERShareBudgetBudgetBudgetBudgetChangesBudgetChangeChugach Electric Association 39.38%519,711 1,008,930 2,367,938 1,403,682 - 1,403,682 (964,256) Homer Electric Association 41.44%546,898 1,061,708 2,491,807 1,477,109 - 1,477,109 (1,014,698) Matanuska Electric Association 17.88%235,968 458,092 1,075,133 637,324 - 637,324 (437,809) City of Seward 1.30%17,157 33,306 78,169 46,338 - 46,338 (31,831) Rounding- 100.00%1,319,734 2,562,036 6,013,047 3,564,453 - 3,564,453 (2,448,594) FY2021 FY2022 FY2022 FY2022 FY2021 toPercentFY2019 FY2020Amended Draft ProposedAmend 1 FY2022POWER PURCHASERShareMonthlyMonthlyBudgetBudgetChangesBudgetChangeChugach Electric Association 39.38%43,309 86,867 220,385 116,974 - 116,974 (103,412) Homer Electric Association 41.44%45,575 91,411 231,913 123,092 - 123,092 (108,821) Matanuska Electric Association 17.88%19,664 39,441 100,063 53,110 - 53,110 (46,953) City of Seward 1.30%1,430 2,868 7,275 3,862 - 3,862 (3,414) - - 100.0%109,978 220,587 559,636 297,038 - 297,038 (262,598) 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch G Page 19 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTSSQ Line Capital Purchases (not funded by R&C Fund)Schedule HFY19 FY20 FY21 FY22 FY22 FY22Amended Amend 1 Proposed Amend 2ActualsActualsBudgetBudgetChangesBudgetComments for FY22:SQ Line Access Documentation 150,000 - - - SQ Line Acquisition Costs 40,000 - - - Total Non R&C Capital Purchases - - 190,000 - - - Capital Project Description6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch HPage 20 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTSSQ Line Operations and Maintenance BudgetSchedule I HEA 150,000 300,523 - 300,523 150,523 CEA - - - - - AEA 20,000 144,000 - 144,000 124,000 170,000 444,523 ‐ 444,523 274,523 ‐ ‐ ‐ FY21 FY22 FY21 Amended Budget FY22 Amend 1Budget FY22 ProposedChanges FY22 Amend 2Budget Increase (Decrease) From PY Summary by cost type Labor & Benefits 32,500 85,820 - 85,820 53,320 Indirect Costs - - - - - Travel - - - - - Training - - - - - Contractual 110,000 250,000 - 250,000 140,000 Supplies & Materials 7,500 56,992 - 56,992 49,492 Other Costs - 7,711 - 7,711 7,711 Equipment, Furniture and Machinery - - - - - Maintenance Projects - - - - - Administrative Costs 20,000 44,000 - 44,000 24,000 170,000 444,523 - 444,523 274,523 FERC 571 ‐ Maintenance of Overhead Lines Maint of OH Lines SQ Line Labor & Benefits 32,500 85,820 - 85,820 HEA 53,320 Travel - - - - - Contractual 110,000 150,000 - 150,000 HEA 40,000 Contractual - 100,000 - 100,000 AEA 100,000 Supplies & Materials 7,500 56,992 - 56,992 HEA 49,492 Other Costs - 7,711 - 7,711 HEA 7,711 SQ Line Total 150,000 400,523 - 400,523 250,523 FERC 571 ‐ Maintenance of Overhead Lines Total 150,000 400,523 ‐ 400,523 250,523 FERC 920 & 930 ‐ Administrative Expense AEA Bradley Admin Fees Bradley Lake Operating Administrative Costs 20,000 42,000 42,000 AEA 22,000 Bradley Lake Operating Total 20,000 42,000 - 42,000 22,000 SSQ Line Trust & Account Fees SQ Line Administrative Costs - 2,000 2,000 AEA 2,000 SQ Line Total - 2,000 - 2,000 2,000 - FERC 920 & 930 ‐ Administrative Expense Total 20,000 44,000 ‐ 44,000 24,000 Total Bradley Lake Budget 170,000 444,523 ‐ 444,523 274,523 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch I Page 21 of 22 ALASKA ENERGY AUTHORITYBRADLEY LAKE HYDROELECTRIC PROJECTSSQ LineMonthly Utility Contributions Schedule JFY2021 FY2022 FY2022 FY2022 FY2021 toPercent Amended Amend 1 Proposed Amend 2 FY2022Power PurchaserShareBudgetBudgetChangesBudgetChangeChugach Electric (combined w ML&P) 56.3%202,680 281,178 - 281,178 78,498 Homer Electric 12.0%43,200 59,931 - 59,931 16,731 Matanuska Electric 13.8%49,680 68,921 - 68,921 19,241 Golden Valley Electric 16.9%60,840 84,403 - 84,403 23,563 City of Seward 1.0%3,600 4,994 - 4,994 1,394 Rounding- 100.0%360,000 499,427 - 499,427 139,427 FY2022 FY2022Power PurchaserPercent FY2021 FY2022 ProposedAmend 1ShareMonthlyMonthlyChangesBudgetChugach Electric (combined w ML&P) 56.3%16,890 23,431 0 23,432 6,541 Homer Electric 12.0%3,600 4,994 (0) 4,994 1,394 Matanuska Electric 13.8%4,140 5,743 0 5,743 1,603 Golden Valley Electric 16.9%5,070 7,034 (0) 7,034 1,964 City of Seward 1.0%300 416 (0) 416 116 - 100.0%30,000 41,619 0 41,619 11,619 6/22/202111:47 AM2022-BradleyBudget-Proposed Budget Amend 2 - Draft 1.xlsxSch J Page 22 of 22 Bradley Lake Operator Report Page 1 Bradley Lake Operator Report BPMC June 25, 2021 Unit Statistics: Generation Unit 1 (MWhrs) Unit 2 (MWhrs) Total (MWhrs) May 2021 June 2021* 21,145 7,996 15,5420 6,420 36,687 14,417 Hydraulics Avg. Lake Level (ft.) Usage (ac ft.) Fish water (CFS) May 2021 June 2021* 1095 1098.2 36,487 14,974 142 AVG** 191 AVG** Battle Creek Inflows to Bradley Fish Water May 2021 June 2021* 319.3 ACF 1,525.5 ACF 24.4 AVG 15.5 AVG • As of June 14, 2021 • **this is with the fish water release at the dam at zero Lake Level – 1104.7’ as of June 18, 2021 The lake has come up 4’ in the last week Capital Projects: 1) Needle cone re-use – we are continuing the investigation into the ability to re- furbish and re-use the needle cones during overhaul. New the cones cost about $12K each, we hope to be able to make repairs and re-use them at a fraction of the cost. 2) New building – We have worked on clearing the site and hope to place the foundation this year. With completion the next year. With the cost of materials, we are likely to see an increase in the building cost. 3) Bridges – the bridge structural wood is in very poor shape, we have a new lighter bridge design replacing the 12 by 12’s on 12” centers with 12 by 12’s on 32” centers with reinforce decking. The additional wood will drive the price beyond the budgeted 220,000 but we should be within 240,000 (10%). A contract is being let and the wood is being delivered to Bradley on the 24th. Bradley Lake Operator Report Page 2 4) IRIS Generator Monitoring – IRIS attempted commissioning but the key phasor in the machinery monitoring system is not working. IRIS needs this to be working. This implies problems with the CSI system even though the indicator lights on the CSI system indicate proper operation. We are going to install a new key phasor native to IRIS ($575) and then investigate the CSI system. 5) Fire system – The fire system piping with the leaks was cut out and we found extensive corrosion and silt build up. This is a big problem as the entire fire water sprinkling and fire hydrant system could be compromised. Further investigation and repair will be required. 6) Battle Creek – We opened Battle creek on May 18, the flows into the lake have been small so far but are rising every day. When we arrived, we found damage to the forebay level sensor and the guard rails apparently due to the weight of snow. As of June 18, we still cannot get to the diversion due to heavy drifts on the road. 7) Battle Creek MIF flowmeter - Bob met with DOWL and they discussed option for correcting the problem. Further study and considerations need to be made before we embark on a plan of action. Bob asked that the O&D request Bryan Carey to direct DOWL to pursue the alternatives already discussed. I understand DOWL is looking over the alternatives. 8) 69Kv Line pole is on the ground – near mile 265 of the Sterling Highway a 69Kv pole is on the ground. It has tipped on its side until the crossarm is about 1 foot from the surface of the earth. This line is (I believe) the property of the Project after the sale of the SSQ line. The O&D recommended that the O&D Chair contact the BPMC Chair to 1) determine what to do immediately with the pole and 2) provide guidance as to what, if anything, the O&D should do in regards to the future of the 69Kv line. 9) Invasive Weeds – The invasive weed people made a survey of Bradley lake, actions taken in years past seem to have done well and some new infestations were sprayed and pulled. Work will continue. 10) TESLA Recorders – The installation and calibration has been completed. 11) Road Opened - On Thursday June 3 we finally were able to get to the dam. 12) Recloser at Battle Creek – Programming of the recloser was accomplished. 13) GIS Inspection – ABB will be performing the 10-year inspection on the Bradley SF6 GIS substation the week of July 19th. 14) Retirement – Tim Quirk, Bradley operator has submitted his retirement effective June 28. We are moving ahead with obtaining an additional person. Bradley Lake Operator Report Page 3 15) Barge to Bradley - Because the septic system at Bradley is backed up we need to bring a septic pumping truck to Bradley. This requires a large Barge. We are scrambling to get everything big on this barge so that we maximize the use of the vessel. The trip is now scheduled for June 24th. 16) FERC Part 12 Inspection - We completed the 5-year inspection with FERC June 9th and 10th. A section of the 8” fire water pipe that was removed (bad news) Bradley Lake Operator Report Page 4 Battle Creek Diversion The forebay Bradley Lake Operator Report Page 5 We have a sleuth of Bears this year Bradley Lake Operator Report Page 1 Bradley Lake Operator Report BPMC June 25, 2021 Unit Statistics: Generation Unit 1 (MWhrs) Unit 2 (MWhrs) Total (MWhrs) May 2021 June 2021* 21,145 7,996 15,5420 6,420 36,687 14,417 Hydraulics Avg. Lake Level (ft.) Usage (ac ft.) Fish water (CFS) May 2021 June 2021* 1095 1098.2 36,487 14,974 142 AVG** 191 AVG** Battle Creek Inflows to Bradley Fish Water May 2021 June 2021* 319.3 ACF 1,525.5 ACF 24.4 AVG 15.5 AVG • As of June 14, 2021 • **this is with the fish water release at the dam at zero Lake Level – 1104.7’ as of June 18, 2021 The lake has come up 4’ in the last week Capital Projects: 1) Needle cone re-use – we are continuing the investigation into the ability to re- furbish and re-use the needle cones during overhaul. New the cones cost about $12K each, we hope to be able to make repairs and re-use them at a fraction of the cost. 2) New building – We have worked on clearing the site and hope to place the foundation this year. With completion the next year. With the cost of materials, we are likely to see an increase in the building cost. 3) Bridges – the bridge structural wood is in very poor shape, we have a new lighter bridge design replacing the 12 by 12’s on 12” centers with 12 by 12’s on 32” centers with reinforce decking. The additional wood will drive the price beyond the budgeted 220,000 but we should be within 240,000 (10%). A contract is being let and the wood is being delivered to Bradley on the 24th. Bradley Lake Operator Report Page 2 4) IRIS Generator Monitoring – IRIS attempted commissioning but the key phasor in the machinery monitoring system is not working. IRIS needs this to be working. This implies problems with the CSI system even though the indicator lights on the CSI system indicate proper operation. We are going to install a new key phasor native to IRIS ($575) and then investigate the CSI system. 5) Fire system – The fire system piping with the leaks was cut out and we found extensive corrosion and silt build up. This is a big problem as the entire fire water sprinkling and fire hydrant system could be compromised. Further investigation and repair will be required. 6) Battle Creek – We opened Battle creek on May 18, the flows into the lake have been small so far but are rising every day. When we arrived, we found damage to the forebay level sensor and the guard rails apparently due to the weight of snow. As of June 18, we still cannot get to the diversion due to heavy drifts on the road. 7) Battle Creek MIF flowmeter - Bob met with DOWL and they discussed option for correcting the problem. Further study and considerations need to be made before we embark on a plan of action. Bob asked that the O&D request Bryan Carey to direct DOWL to pursue the alternatives already discussed. I understand DOWL is looking over the alternatives. 8) 69Kv Line pole is on the ground – near mile 265 of the Sterling Highway a 69Kv pole is on the ground. It has tipped on its side until the crossarm is about 1 foot from the surface of the earth. This line is (I believe) the property of the Project after the sale of the SSQ line. The O&D recommended that the O&D Chair contact the BPMC Chair to 1) determine what to do immediately with the pole and 2) provide guidance as to what, if anything, the O&D should do in regards to the future of the 69Kv line. 9) Invasive Weeds – The invasive weed people made a survey of Bradley lake, actions taken in years past seem to have done well and some new infestations were sprayed and pulled. Work will continue. 10) TESLA Recorders – The installation and calibration has been completed. 11) Road Opened - On Thursday June 3 we finally were able to get to the dam. 12) Recloser at Battle Creek – Programming of the recloser was accomplished. 13) GIS Inspection – ABB will be performing the 10-year inspection on the Bradley SF6 GIS substation the week of July 19th. 14) Retirement – Tim Quirk, Bradley operator has submitted his retirement effective June 28. We are moving ahead with obtaining an additional person. Bradley Lake Operator Report Page 3 15) Barge to Bradley - Because the septic system at Bradley is backed up we need to bring a septic pumping truck to Bradley. This requires a large Barge. We are scrambling to get everything big on this barge so that we maximize the use of the vessel. The trip is now scheduled for June 24th. 16) FERC Part 12 Inspection - We completed the 5-year inspection with FERC June 9th and 10th. A section of the 8” fire water pipe that was removed (bad news) Bradley Lake Operator Report Page 4 Battle Creek Diversion The forebay Bradley Lake Operator Report Page 5 We have a sleuth of Bears this year Bradley Lake Budget to Actual Expense Report 07/01/2020 to 04/30/2021 Page 1 of 9 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Schedule A-1 Expenses for the period 07/01/20 to 04/30/21 FY19 FY20 FY21 FY21 ACTUALS ACTUALS BUDGET ACTUALS Replace/Automate Fish Water Valve Actuators 17,142 2,931 40,000 Replace 1988 Suburban Ambulance 5,350 - Tire Machine 15,246 - Battle Creek Bridge Repair - - - 99,302 UPS Replacement 65,696 37,000 34,438 IRIS Air Gap Monitoring System (computer) 41,720 45,000 Replace Dump Truck and Sander 170,000 166,608 Rough Terrain Fork Lift (with Plow) 131,593 - Pick up Truck 41,484 - KVM switch for Emerson - 3,000 Spare Trash Pump - 20,000 Housing Preliminary Design - 10,000 9,500 Emerson Cybersecurity Update - 137,000 138,555 SQ Line Access Documentation 150,000 852 SQ Line Acquisition Costs 40,000 46,029 Total Non R&C Capital Purchases 37,738 283,425 652,000 495,283 CAPITAL PURCHASES NOT FUNDED BY R&C FUND Page 2 of 9 ALASKA ENERGY AUTHORITY BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 04/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 ‐ 04/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Summary by expense type AIDEA Staff Professional Services (Direct)‐ ‐ ‐ ‐ 103,418 103,418 (103,418) ‐ ‐ Labor & Benefits 1,445,789 1,204,824 935,260 20,068 212 955,539 249,285 1,219,936 1,011,432 Travel 44,950 37,458 610 53 ‐ 663 36,795 45,950 10,512 Training 49,300 41,083 21,285 ‐ ‐ 21,285 19,798 49,300 14,875 Contractual 954,340 795,283 384,553 ‐ 201,517 586,069 209,214 869,842 655,575 Contractual ‐ Design Services 59,000 49,167 ‐ ‐ ‐ ‐ 49,167 ‐ ‐ Consulting‐Administrative 2,500 2,083 ‐ ‐ 2,293 2,293 (209) ‐ ‐ Supplies & Materials 396,845 330,704 173,453 ‐ ‐ 173,453 157,251 346,345 262,370 Other Costs 70,818 59,015 31,848 24,302 350 56,500 2,515 67,818 65,648 Equipment, Furniture and Machinery 170,000 141,667 20,805 ‐ ‐ 20,805 120,862 176,000 127,535 Maintenance Projects ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 313 Administrative Costs 1,274,574 1,055,478 31,939 ‐ 770,941 802,880 252,599 1,192,464 1,373,624 Indirect Costs 1,330,587 1,108,823 1,179,101 ‐ ‐ 1,179,101 (70,278) 1,383,388 1,251,242 5,798,703 4,825,586 2,778,853 44,423 1,078,730 3,902,006 923,580 5,351,043 4,773,126 FERC 535 ‐ Operation Supervision & Engineering Operations Sup/Eng Bradley Lake Operating Labor & Benefits 107,453 89,544 83,657 ‐ ‐ 83,657 5,887 107,453 89,713 Travel 10,450 8,708 408 ‐ ‐ 408 8,300 10,450 246 Training 9,300 7,750 2,076 ‐ ‐ 2,076 5,674 9,300 991 Contractual 11,000 9,167 ‐ ‐ ‐ ‐ 9,167 1,000 173 Supplies & Materials 4,000 3,333 2,444 ‐ ‐ 2,444 889 4,000 3,698 Indirect Costs 155,698 129,748 116,733 ‐ ‐ 116,733 13,015 155,698 128,545 Bradley Lake Operating Total 297,901 248,251 205,318 ‐ ‐ 205,318 42,932 287,901 223,366 FERC 535 ‐ Operation Supervision & Engineering Total 297,901 248,251 205,318 ‐ ‐ 205,318 42,932 287,901 223,366 FERC 537 ‐ Hydraulic Expenses Hydraulic Expenses Bradley Lake Operating Labor & Benefits 84,192 70,160 65,444 ‐ ‐ 65,444 4,716 84,081 67,694 Travel 10,000 8,333 129 ‐ ‐ 129 8,204 10,000 ‐ Contractual (37,000) (30,833) 32,071 ‐ ‐ 32,071 (62,904) 22,000 ‐ Contractual ‐ Design Services 59,000 49,167 ‐ ‐ ‐ ‐ 49,167 ‐ ‐ Supplies & Materials 59,000 49,167 2,297 ‐ ‐ 2,297 46,870 19,000 9,806 Equipment, Furniture and Machinery 32,000 26,667 ‐ ‐ ‐ ‐ 26,667 81,000 13,368 Indirect Costs 114,320 95,267 88,983 ‐ ‐ 88,983 6,284 107,519 98,886 Bradley Lake Operating Total 321,512 267,927 188,924 ‐ ‐ 188,924 79,003 323,600 189,754 Bradley Battle Creek Diversion Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ FERC 537 ‐ Hydraulic Expenses Total 321,512 267,927 188,924 ‐ ‐ 188,924 79,003 323,600 189,754 FERC 538 ‐ Electric Expenses Electric Expenses Bradley Lake Operating Labor & Benefits 218,044 181,703 216,531 ‐ ‐ 216,531 (34,828) 208,745 210,745 Travel 7,000 5,833 73 ‐ ‐ 73 5,761 7,000 3,140 Training 25,000 20,833 19,209 ‐ ‐ 19,209 1,624 25,000 13,884 Contractual 2,000 1,667 ‐ ‐ ‐ ‐ 1,667 7,000 2,587 Supplies & Materials 41,732 34,777 23,744 ‐ ‐ 23,744 11,033 50,732 14,111 Other Costs 5,000 4,167 2,102 ‐ ‐ 2,102 2,065 ‐ ‐ Equipment, Furniture and Machinery 73,000 60,833 8,578 ‐ ‐ 8,578 52,256 63,000 91,512 Indirect Costs 262,004 218,337 249,964 ‐ ‐ 249,964 (31,627) 242,067 257,551 Bradley Lake Operating Total 633,780 528,150 520,200 ‐ ‐ 520,200 7,950 603,544 593,531 FERC 538 ‐ Electric Expenses Total 633,780 528,150 520,200 ‐ ‐ 520,200 7,950 603,544 593,531 FERC 539 ‐ Misc. Hydraulic Power Generation Expenses Misc Hydro Power Exp Bradley Lake Operating Labor & Benefits 105,047 87,539 64,421 ‐ ‐ 64,421 23,119 104,936 70,195 Training 15,000 12,500 ‐ ‐ ‐ ‐ 12,500 15,000 ‐ Contractual 287,525 239,604 185,379 ‐ ‐ 185,379 54,225 287,525 185,822 Supplies & Materials 17,900 14,917 20,944 ‐ ‐ 20,944 (6,027) 17,900 31,569 Other Costs 65,468 54,557 ‐ ‐ ‐ ‐ 54,557 ‐ ‐ Indirect Costs 114,320 95,267 87,585 ‐ ‐ 87,585 7,682 107,519 98,544 Bradley Lake Operating Total 605,260 504,383 358,329 ‐ ‐ 358,329 146,054 532,880 386,130 BRADLEY CIRCUITS/RADIO TO BERNICE LK Other Costs ‐ ‐ 29,747 ‐ ‐ 29,747 (29,747) 35,695 35,696 BRADLEY CIRCUITS/RADIO TO BERNICE LK Total ‐ ‐ 29,747 ‐ ‐ 29,747 (29,747) 35,695 35,696 BRADLEY CIRCUITS BERNICE LK TO ANCH Other Costs ‐ ‐ ‐ 24,302 ‐ 24,302 (24,302) 29,773 29,194 BRADLEY CIRCUITS BERNICE LK TO ANCH Total ‐ ‐ ‐ 24,302 ‐ 24,302 (24,302) 29,773 29,194 FERC 539 ‐ Misc. Hydraulic Power Generation Expenses Total 605,260 504,383 388,075 24,302 ‐ 412,377 92,006 598,348 451,020 FERC 541 ‐ Maintenance Supervision & Engineering Maint Supervision/Eng Bradley Lake Operating Labor & Benefits 270,154 225,128 82,444 ‐ ‐ 82,444 142,685 114,456 84,904 Indirect Costs ‐ ‐ 117,118 ‐ ‐ 117,118 (117,118) 155,698 121,096 H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\04 2021\04 2021 ‐ FY21 Budget to Actuals ‐ Bradley.xlsx 3 of 9 6/14/2021 ALASKA ENERGY AUTHORITY BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 04/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 ‐ 04/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Bradley Lake Operating Total 270,154 225,128 199,561 ‐ ‐ 199,561 25,567 270,154 206,000 FERC 541 ‐ Maintenance Supervision & Engineering Total 270,154 225,128 199,561 ‐ ‐ 199,561 25,567 270,154 206,000 FERC 542 ‐ Maintenance of Structures Maintenance of Structures Bradley Lake Operating Labor & Benefits 77,639 64,699 59,406 ‐ ‐ 59,406 5,293 76,499 62,612 Contractual 59,000 49,167 140 ‐ ‐ 140 49,027 91,000 3,682 Supplies & Materials 100,713 83,928 34,488 ‐ ‐ 34,488 49,439 88,713 39,489 Equipment, Furniture and Machinery 52,000 43,333 12,227 ‐ ‐ 12,227 31,106 32,000 22,552 Indirect Costs 105,421 87,851 81,091 ‐ ‐ 81,091 6,759 97,823 91,244 Bradley Lake Operating Total 394,773 328,978 187,353 ‐ ‐ 187,353 141,624 386,035 219,579 BRADLEY CIRCUITS/RADIO TO BERNICE LK BRADLEY CIRCUITS/RADIO TO BERNICE LK Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ BRADLEY CIRCUITS BERNICE LK TO ANCH BRADLEY CIRCUITS BERNICE LK TO ANCH Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ FERC 542 ‐ Maintenance of Structures Total 394,773 328,978 187,353 ‐ ‐ 187,353 141,624 386,035 219,579 FERC 543 ‐ Maintenance of Reservoirs, Dams & Waterways Maint Res, Dams, WWays Bradley Lake Operating Labor & Benefits 40,744 33,953 160 ‐ ‐ 160 33,793 45,080 1,335 Travel 5,000 4,167 ‐ ‐ ‐ ‐ 4,167 ‐ ‐ Contractual 21,500 17,917 ‐ ‐ ‐ ‐ 17,917 6,500 ‐ Supplies & Materials 15,000 12,500 ‐ ‐ ‐ ‐ 12,500 ‐ ‐ Indirect Costs 56,689 47,241 249 ‐ ‐ 249 46,992 56,322 1,693 Bradley Lake Operating Total 138,933 115,778 409 ‐ ‐ 409 115,368 107,902 3,027 BRADLEY POWER TUNNEL MAINT (Dam) Contractual ‐ ‐ ‐ ‐ ‐ ‐ ‐ 15,000 ‐ BRADLEY POWER TUNNEL MAINT (Dam) Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ 15,000 ‐ FERC 543 ‐ Maintenance of Reservoirs, Dams & Waterways Tota 138,933 115,778 409 ‐ ‐ 409 115,368 122,902 3,027 FERC 544 ‐ Maintenance of Electric Plant Maintenance of Elec Plant Bradley Lake Operating Labor & Benefits 309,110 257,592 269,066 ‐ ‐ 269,066 (11,474) 273,620 249,706 Travel 4,500 3,750 ‐ ‐ ‐ ‐ 3,750 4,500 ‐ Contractual 86,000 71,667 14,690 ‐ ‐ 14,690 56,977 49,000 19,661 Supplies & Materials 38,000 31,667 23,333 ‐ ‐ 23,333 8,334 70,000 66,370 Indirect Costs 423,178 352,648 354,425 ‐ ‐ 354,425 (1,776) 368,424 362,402 Bradley Lake Operating Total 860,788 717,323 661,513 ‐ ‐ 661,513 55,810 765,544 698,139 FERC 544 ‐ Maintenance of Electric Plant Total 860,788 717,323 661,513 ‐ ‐ 661,513 55,810 765,544 698,139 FERC 545 ‐ Maintenance of Misc. Hydraulic Plant Maint of Misc Hydr Plant Bradley Lake Operating Labor & Benefits 69,297 57,748 61,707 ‐ ‐ 61,707 (3,959) 69,395 62,843 Contractual 3,900 3,250 2,447 ‐ ‐ 2,447 803 3,900 6,763 Supplies & Materials 58,000 48,333 64,876 ‐ ‐ 64,876 (16,542) 63,000 93,510 Maintenance Projects ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 313 Indirect Costs 98,957 82,464 82,953 ‐ ‐ 82,953 (489) 92,318 91,280 Bradley Lake Operating Total 230,154 191,795 211,983 ‐ ‐ 211,983 (20,188) 228,613 254,710 FERC 545 ‐ Maintenance of Misc. Hydraulic Plant Total 230,154 191,795 211,983 ‐ ‐ 211,983 (20,188) 228,613 254,710 FERC 556 ‐ System Control & Load Dispatching System Cntl & Load Disp Bradley Lake Operating Labor & Benefits 21,140 17,617 14,101 ‐ ‐ 14,101 3,515 21,140 37,091 Contractual 53,000 44,167 4,526 ‐ ‐ 4,526 39,641 53,000 57,365 Supplies & Materials 6,000 5,000 813 ‐ ‐ 813 4,187 6,000 3,204 Bradley Lake Operating Total 80,140 66,783 19,440 ‐ ‐ 19,440 47,343 80,140 97,661 Bradley Battle Creek Diversion Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Snow Measurement Bradley Lake Operating Contractual 10,000 8,333 ‐ ‐ 10,000 10,000 (1,667) 10,000 10,000 Bradley Lake Operating Total 10,000 8,333 ‐ ‐ 10,000 10,000 (1,667) 10,000 10,000 Seismic Service Bradley Lake Operating Contractual 62,000 51,667 ‐ ‐ 43,282 43,282 8,385 62,000 56,310 Bradley Lake Operating Total 62,000 51,667 ‐ ‐ 43,282 43,282 8,385 62,000 56,310 Streamguaging Serv Bradley Lake Operating Contractual 183,615 153,013 ‐ ‐ 145,211 145,211 7,801 209,917 189,917 Bradley Lake Operating Total 183,615 153,013 ‐ ‐ 145,211 145,211 7,801 209,917 189,917 Permits Bradley Lake Operating Other Costs 350 292 ‐ ‐ 350 350 (58) 350 758 Bradley Lake Operating Total 350 292 ‐ ‐ 350 350 (58) 350 758 FERC 556 ‐ System Control & Load Dispatching Total 336,105 280,088 19,440 ‐ 198,843 218,283 61,804 362,407 354,646 H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\04 2021\04 2021 ‐ FY21 Budget to Actuals ‐ Bradley.xlsx 4 of 9 6/14/2021 ALASKA ENERGY AUTHORITY BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 04/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 ‐ 04/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual FERC 562 ‐ Station Expenses Station Expenses Bradley Lake Operating Labor & Benefits 83,010 69,175 17,779 20,068 212 38,058 31,117 87,072 72,086 Travel 4,500 3,750 ‐ 53 ‐ 53 3,697 4,000 2,596 Contractual 1,800 1,500 45,922 ‐ 3,024 48,946 (47,446) 2,000 51,167 Supplies & Materials 44,000 36,667 515 ‐ ‐ 515 36,152 22,000 613 Other Costs ‐ ‐ ‐ ‐ ‐ ‐ ‐ 2,000 ‐ Equipment, Furniture and Machinery 13,000 10,833 ‐ ‐ ‐ ‐ 10,833 ‐ ‐ Bradley Lake Operating Total 146,310 121,925 64,216 20,121 3,236 87,572 34,353 117,072 126,462 FERC 562 ‐ Station Expenses Total 146,310 121,925 64,216 20,121 3,236 87,572 34,353 117,072 126,462 #N/A Weather Monitoring Power Sup Bradley Lake Operating Contractual ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 5,244 Bradley Lake Operating Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 5,244 #N/A ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 5,244 FERC 571 ‐ Maintenance of Overhead Lines Maint of OH Lines Bradley Lake Operating Labor & Benefits 27,459 22,883 544 ‐ ‐ 544 22,339 27,459 2,507 Travel ‐ ‐ ‐ ‐ ‐ ‐ ‐ 10,000 4,530 Contractual 100,000 83,333 99,378 ‐ ‐ 99,378 (16,044) 50,000 66,883 Supplies & Materials 5,000 4,167 ‐ ‐ ‐ ‐ 4,167 5,000 ‐ Equipment, Furniture and Machinery ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ 103 Bradley Lake Operating Total 132,459 110,383 99,922 ‐ ‐ 99,922 10,461 92,459 74,024 SSQ Line Operating Labor & Benefits 32,500 27,083 ‐ ‐ ‐ ‐ 27,083 ‐ ‐ Contractual 110,000 91,667 ‐ ‐ ‐ ‐ 91,667 ‐ ‐ Supplies & Materials 7,500 6,250 ‐ ‐ ‐ ‐ 6,250 ‐ ‐ SSQ Line Operating Total 150,000 125,000 ‐ ‐ ‐ ‐ 125,000 ‐ ‐ FERC 571 ‐ Maintenance of Overhead Lines Total 282,459 235,383 99,922 ‐ ‐ 99,922 135,461 92,459 74,024 FERC 920 & 930 ‐ Administrative Expense AEA Bradley Fixed Admin Fees Bradley Lake Operating AIDEA Staff Professional Services (Direct)‐ ‐ ‐ ‐ 94,811 94,811 (94,811) ‐ ‐ Travel 3,500 2,917 ‐ ‐ ‐ ‐ 2,917 ‐ ‐ Consulting‐Administrative 2,500 2,083 ‐ ‐ 2,293 2,293 (209) ‐ ‐ Administrative Costs 19,755 16,463 ‐ ‐ 25,819 25,819 (9,357) 200,000 200,000 Bradley Lake Operating Total 25,755 21,463 ‐ ‐ 122,922 122,922 (101,460) 200,000 200,000 Bradley Battle Creek Diversion Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ SSQ Line Operating AIDEA Staff Professional Services (Direct)‐ ‐ ‐ ‐ 8,607 8,607 (8,607) ‐ ‐ Administrative Costs 20,000 10,000 ‐ ‐ 14 14 9,986 ‐ ‐ SSQ Line Operating Total 20,000 10,000 ‐ ‐ 8,621 8,621 1,379 ‐ ‐ Operating Committee Exp‐Audit Bradley Lake Operating Administrative Costs 19,900 16,583 ‐ ‐ 22,000 22,000 (5,417) 19,900 20,298 Bradley Lake Operating Total 19,900 16,583 ‐ ‐ 22,000 22,000 (5,417) 19,900 20,298 Operating Committee Exp‐Legal Bradley Lake Operating Administrative Costs 70,000 58,333 ‐ ‐ 60,013 60,013 (1,680) 30,000 215,162 Bradley Lake Operating Total 70,000 58,333 ‐ ‐ 60,013 60,013 (1,680) 30,000 215,162 Operat Committee Exp‐Arbitrage Bradley Lake Operating Administrative Costs 5,000 4,167 ‐ ‐ ‐ ‐ 4,167 3,000 2,685 Bradley Lake Operating Total 5,000 4,167 ‐ ‐ ‐ ‐ 4,167 3,000 2,685 Trust & Account Fees Bradley Lake Operating Administrative Costs 13,000 10,833 ‐ ‐ 11,918 11,918 (1,085) 11,918 12,118 Bradley Lake Operating Total 13,000 10,833 ‐ ‐ 11,918 11,918 (1,085) 11,918 12,118 Misc Admin Bradley Lake Operating Administrative Costs 18,900 15,750 12,360 ‐ 6,600 18,960 (3,210) 11,646 12,000 Bradley Lake Operating Total 18,900 15,750 12,360 ‐ 6,600 18,960 (3,210) 11,646 12,000 FERC 920 & 930 ‐ Administrative Expense Total 172,555 137,129 12,360 ‐ 232,074 244,434 (107,305) 276,464 462,263 FERC 924 & 925 ‐ Insurance Premiums Insurance Premiums Bradley Lake Operating Administrative Costs 748,019 623,349 19,579 ‐ 571,111 590,690 32,659 631,000 653,129 Bradley Lake Operating Total 748,019 623,349 19,579 ‐ 571,111 590,690 32,659 631,000 653,129 FERC 924 & 925 ‐ Insurance Premiums Total 748,019 623,349 19,579 ‐ 571,111 590,690 32,659 631,000 653,129 FERC 928 ‐ Regulatory Commission Expenses FERC Admin Fees H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\04 2021\04 2021 ‐ FY21 Budget to Actuals ‐ Bradley.xlsx 5 of 9 6/14/2021 ALASKA ENERGY AUTHORITY BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 04/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 ‐ 04/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Bradley Lake Operating Administrative Costs 175,000 145,833 ‐ ‐ ‐ ‐ 145,833 185,000 169,976 Bradley Lake Operating Total 175,000 145,833 ‐ ‐ ‐ ‐ 145,833 185,000 169,976 FERC Related Prof Services BRADLEY FERC PART 12 INSPECTION Administrative Costs 75,000 62,500 ‐ ‐ 6,398 6,398 56,102 ‐ ‐ BRADLEY FERC PART 12 INSPECTION Total 75,000 62,500 ‐ ‐ 6,398 6,398 56,102 ‐ ‐ BRADLEY CONTRACTUAL ENGINEER‐FERC LICENSE ISSUES Administrative Costs 110,000 91,667 ‐ ‐ 67,068 67,068 24,598 100,000 88,256 BRADLEY CONTRACTUAL ENGINEER‐FERC LICENSE ISSUES Tot 110,000 91,667 ‐ ‐ 67,068 67,068 24,598 100,000 88,256 FERC 928 ‐ Regulatory Commission Expenses Total 360,000 300,000 ‐ ‐ 73,466 73,466 226,534 285,000 258,232 Total Bradley Lake Budget 5,798,703 4,825,586 2,778,853 44,423 1,078,730 3,902,006 923,580 5,351,043 4,773,126 H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\04 2021\04 2021 ‐ FY21 Budget to Actuals ‐ Bradley.xlsx 6 of 9 6/14/2021 BRADLEY LAKE R&C FUND DISBURSEMENTS AND REPAYMENTS SCHEDULE D Expenses for the period 07/01/20 to 04/30/21 Actual Actual Actual Projected @06/30/20 TO REPAY @ 4/30/21 TO REPAY Budget Description Expense @6/30/20 Expense @6/30/21 FY21 R&C FUND PROJECTS Governor 0.00 4,052,070.14 0.00 4,052,070.14 0.00 Replace RFLS 0.00 251,092.69 0.00 251,092.69 0.00 Replace Runners 0.00 1,946,732.79 0.00 1,946,732.79 0.00 Replace cable from dam to power house 0.00 2,321,922.94 0.00 2,321,922.94 0.00 Replace power system stabilizer 0.00 619,205.10 0.00 619,205.10 0.00 Replace two RTUs 0.00 86,905.27 0.00 86,905.27 0.00 Culvert Repairs 0.00 675,966.79 0.00 675,966.79 0.00 Tower Repair for Jack Frost Heaves 0.00 887,596.62 0.00 887,596.62 0.00 Replace Plant and SCADA Controls 0.00 1,344,683.05 0.00 1,344,683.05 0.00 Vibration Monitoring System 0.00 490.00 0.00 490.00 0.00 Fire Alarm System Replacement 41,179.09 41,179.09 29,531.83 70,710.92 150,000.00 Battle Creek Diversion 0.00 1,170,000.00 0.00 1,170,000.00 0.00 Bradley Replace Electro-Mechanical Relays 0.00 1,277,197.06 0.00 1,277,197.06 0.00 Fishwater Screen Debris Removal 0.00 312,236.43 0.00 312,236.43 0.00 Turbine Nozzel Repair 0.00 1,428,861.07 0.00 1,428,861.07 0.00 Spillway Raise 0.00 0.00 0.00 0.00 0.00 SVC replacement Daves Creek | Soldotna 0.00 8,517,991.11 0.00 8,517,991.11 0.00 Equipment Storage Shed 0.00 510,550.13 0.00 510,550.13 0.00 Emerson Operating System Upgrade 0.00 622,665.00 0.00 622,665.00 0.00 Generator #2 Replacement 370,871.04 953,212.71 0.00 953,212.71 0.00 Road Grader 0.00 0.00 0.00 370,000.00 Battle Creek Construction 0.00 3,715,477.67 3,715,477.67 3,666,000.00 Battle Creek Cash Call-Expended 0.00 750,000.00 750,000.00 750,000.00 Battle Creek Cash Call-Paid by Utilities 0.00 (750,000.00) (750,000.00) (750,000.00) Needle Repairs 0.00 1,430,048.17 1,430,048.17 1,500,000.00 0.00 0.00 412,050.13 27,020,557.99 5,175,057.67 32,195,615.66 5,686,000.00 Current Year R&C Repayment (2,121,396.10) (1,592,897.11) Adjust balance to $5 million 0.00 0.00 Interest in Fund Applied to Repayment (175,199.84) (269,487.16) Net Transfer from Revenue Fund (2,296,595.94) (1,862,384.27) Cumulative Prior Years R&C Repayments (23,240,089.01) (25,518,390.50) Due to (from) Utilities 18,294.45 (298,633.37) Adjust Due to R&C Actual 0.00 0.00 (23,221,794.56) (25,817,023.87) NET DUE TO R&C FUND 1,502,167.49 4,516,207.52 R&C FUND CASH FLOW PROJECTION Beginning Investment Balance 2,435,913.25 3,922,231.19 Disbursements-current year -Accrual (721,894.25) (4,115,402.64) Disbursements-prior year accrued 0.00 (406,104.23) Utilities' R&C Refund (88,383.75) (18,294.45) Net other cash inflow(outflow)0.00 0.00 Current year interest earnings 175,199.84 269,487.16 Participants Contributions to R&C Fund 2,121,396.10 1,592,897.11 Ending Investment Balance 3,922,231.19 1,244,814.14 Accrued Due to (from) Utilities (18,294.45) 298,633.37 R&C payable back to the revenue fund 0.00 0.00 Accrued R&C vendor Payable at Year End (406,104.23) (1,059,655.03) PROJECTED NET DUE + ENDING INVESTMENT BALANCE 5,000,000.00 5,000,000.00 REPAYMENT AMOUNT $1,649,677 X 25% $4,139,810 X 25% $238,606.15 X 25% $954,181.79 x 25% $756,665.11 x 25% all 4 years $1,455,830.05 x 25% all 4 years $1,401,948.53 x 25% all 4 years $1,834,499.92 x 25% yr 1 | 25% yr 2 | 50% yr 3 $3,330,802.80 x 25% yr 1 | 32% yr 2 | 25% yr 3 |18% yr4 $5,644,193.08 x 25% all 4 years 4th 1,411,048.27 $1,341,405.96 x 25% all 4 years 3rd 335,351.49 4th 335,351.49 $1,715,556.80 x 25% all 4 years 2nd 428,889.20 3rd 428,889.20 $412,050.13 x 25% all 4 years 1st 103,012.53 2nd 103,012.53 $5,270,000 x 25% all 4 years 1st 1,293,764.42 2,278,301.49 2,161,017.64 Page 7 of 9 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Battle Creek Capital Purchases Schedule E Expenses for the period 07/01/20 to 04/30/21 FY19 FY20 FY21 FY21 Actuals Actual Budget Actual Used 2007 Chevrolet Silverado - Used 2006 Chevrolet Silverado - Battle Creek Diversion - 822,327 320,000 7,913 Total capital revenue fund purchases - 822,327 320,000 7,913 Battle Creek Capital Purchases Page 8 of 9 ALASKA ENERGY AUTHORITY BATTLE CREEK OPERATIONS & MAINTENANCE SCHEDULE F BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 04/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 ‐ 04/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Summary by expense type Direct Purchases/Travel ‐ ‐ ‐ ‐ 2,174 2,174 (2,174) ‐ ‐ AIDEA Staff Professional Services (Direct)‐ ‐ ‐ ‐ 22,840 22,840 (22,840) ‐ ‐ Contractual 111,000 92,500 ‐ ‐ 71,231 71,231 21,269 ‐ ‐ Administrative Costs 436,714 363,887 83,351 ‐ 31,551 114,902 248,985 395,424 580,606 547,714 456,387 83,351 ‐ 127,796 211,147 245,240 395,424 580,606 FERC 537 ‐ Hydraulic Expenses Hydraulic Expenses Bradley Battle Creek Diversion Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Battle Creek Operating Contractual 66,000 55,000 ‐ ‐ 37,481 37,481 17,519 ‐ ‐ Battle Creek Operating Total 66,000 55,000 ‐ ‐ 37,481 37,481 17,519 ‐ ‐ FERC 537 ‐ Hydraulic Expenses Total 66,000 55,000 ‐ ‐ 37,481 37,481 17,519 ‐ ‐ FERC 556 ‐ System Control & Load Dispatching Streamguaging Serv Bradley Battle Creek Diversion Contractual ‐ ‐ ‐ ‐ 11,250 11,250 (11,250) ‐ ‐ Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ 11,250 11,250 (11,250) ‐ ‐ Battle Creek Operating Contractual 45,000 37,500 ‐ ‐ 22,500 22,500 15,000 ‐ ‐ Battle Creek Operating Total 45,000 37,500 ‐ ‐ 22,500 22,500 15,000 ‐ ‐ FERC 556 ‐ System Control & Load Dispatching Total 45,000 37,500 ‐ ‐ 33,750 33,750 3,750 ‐ ‐ FERC 920 & 930 ‐ Administrative Expense AEA Bradley Fixed Admin Fees Bradley Battle Creek Diversion Administrative Costs ‐ ‐ ‐ ‐ ‐ ‐ ‐ 117,274 117,325 Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ 117,274 117,325 Battle Creek Operating Direct Purchases/Travel ‐ ‐ ‐ ‐ 574 574 (574) ‐ ‐ AIDEA Staff Professional Services (Direct)‐ ‐ ‐ ‐ 22,840 22,840 (22,840) ‐ ‐ Administrative Costs 314,664 262,220 1,285 ‐ 7,614 8,900 253,320 ‐ ‐ Battle Creek Operating Total 314,664 262,220 1,285 ‐ 31,028 32,314 229,906 ‐ ‐ Operating Committee Exp‐Legal Bradley Battle Creek Diversion Administrative Costs ‐ ‐ ‐ ‐ 86 86 (86) 15,000 135,880 Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ 86 86 (86) 15,000 135,880 Battle Creek Operating Administrative Costs 30,000 25,000 ‐ ‐ 16,190 16,190 8,810 ‐ ‐ Battle Creek Operating Total 30,000 25,000 ‐ ‐ 16,190 16,190 8,810 ‐ ‐ Operat Committee Exp‐Arbitrage Bradley Battle Creek Diversion Administrative Costs ‐ ‐ ‐ ‐ ‐ ‐ ‐ 2,000 1,690 Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ 2,000 1,690 Battle Creek Operating Administrative Costs 2,000 1,667 ‐ ‐ ‐ ‐ 1,667 ‐ ‐ Battle Creek Operating Total 2,000 1,667 ‐ ‐ ‐ ‐ 1,667 ‐ ‐ Trust & Account Fees Bradley Battle Creek Diversion Administrative Costs ‐ ‐ ‐ ‐ ‐ ‐ ‐ 4,800 5,000 Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ 4,800 5,000 Battle Creek Operating Administrative Costs 8,800 7,333 ‐ ‐ 7,600 7,600 (267) ‐ ‐ Battle Creek Operating Total 8,800 7,333 ‐ ‐ 7,600 7,600 (267) ‐ ‐ Misc Admin Bradley Battle Creek Diversion Administrative Costs ‐ ‐ ‐ ‐ ‐ ‐ ‐ 100 110 Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ 100 110 Battle Creek Operating Direct Purchases/Travel ‐ ‐ ‐ ‐ 1,600 1,600 (1,600) ‐ ‐ Administrative Costs 100 42 24,103 ‐ 60 24,164 (24,122) ‐ ‐ Battle Creek Operating Total 100 42 24,103 ‐ 1,660 25,764 (25,722) ‐ ‐ Professional consultants Bradley Battle Creek Diversion Administrative Costs ‐ ‐ ‐ ‐ ‐ ‐ ‐ 256,250 320,601 Bradley Battle Creek Diversion Total ‐ ‐ ‐ ‐ ‐ ‐ ‐ 256,250 320,601 Battle Creek Operating Administrative Costs 81,150 67,625 57,963 ‐ ‐ 57,963 9,662 ‐ ‐ Battle Creek Operating Total 81,150 67,625 57,963 ‐ ‐ 57,963 9,662 ‐ ‐ FERC 920 & 930 ‐ Administrative Expense Total 436,714 363,887 83,351 ‐ 56,565 139,916 223,971 395,424 580,606 Total Bradley Lake Budget 547,714 456,387 83,351 ‐ 127,796 211,147 245,240 395,424 580,606 H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\04 2021\04 2021 ‐ FY21 Budget to Actuals ‐ Bradley.xlsx 9 of 9 6/14/2021 Date # Periods Preconstruction Costs Series 7 Debt (Net) Series 8 Debt (Net)O&M Capital Purchases R&C Repayment Total Costs Future Value @ 1.6150% 12/26/2017 4.43 1,133,860.00 1,133,860.00 1,217,313.76 6/1/2018 4.00 137,456.00 16,500.00 153,956.00 164,152.27 7/1/2018 3.92 314,214.92 9,732.80 323,947.73 344,947.77 1/1/2019 3.42 306,836.58 9,504.26 316,340.84 334,138.24 6/1/2019 3.00 527,723.00 149,941.00 677,664.00 711,061.06 7/1/2019 2.92 301,833.82 9,349.30 311,183.12 326,089.37 1/1/2020 2.42 305,083.49 9,449.96 314,533.45 326,948.95 6/1/2020 2.00 580,606.00 822,327.00 1,402,933.00 1,448,613.55 7/1/2020 1.92 300,225.21 9,283.14 309,508.35 319,165.62 1/1/2021 1.41 303,914.76 9,413.76 313,328.52 320,506.00 6/1/2021 1.00 547,714.00 320,000.00 1,104,000.00 1,971,714.00 2,003,557.11 7/1/2021 0.92 1,634,771.20 50,637.02 1,685,408.22 1,710,373.81 1/1/2022 0.41 291,389.29 9,025.78 300,415.07 302,412.79 6/1/2022 0.00 399,610.00 115,000.00 1,104,000.00 1,618,610.00 1,618,610.00 1,133,860.00 3,758,269.27 116,396.03 2,193,109.00 1,423,768.00 2,208,000.00 10,833,402.30 11,147,890.31 Calculation of Applicable Weighted Yield;$11,147,890.31 Principal Yield Factor $40,000,000 1.5337%613,476.00 16.90% $1,239,000 4.2399%52,532.36 $41,239,000 1.6150%666,008.36 $1,883,993.46 GVEA Projected Future Costs:@ 16.9% Share * Annual O&M (estimated)$400,000.00 $67,600.00 * Debt Service after 6/1/22 $48,099,554.48 $8,128,824.71 Assumptions: 4) Preconstruction Costs are assumed to have occurred on the 12/26/2017 closing date of the Series 7 and Series 8 Bonds. 5) GVEA participation is assumed to commence on 6/1/2022. Golden Valley Electric Association Project Buy-In 6/1/22 GVEA Buy-In Cost @ 16.9% Participation: 2) Applicable discount rate for determination of future value of costs at anticipated 6/1/2022 buy-in settlemnt date is derived as the weighted average of actuarial yields of the AEA Bradley Lake Hydroelectric Project Series 7 and Series 8 Bonds. 1) Participant buy-in cost is determined as provided in BPMC Resolution 2017-02, First Amendment, Attachment 1, Section B, paragraph 11. 3) Golden Valley Electric Association participant buy-in share determined to be 16.9% per BPMC Resolution 2018-01. Exhibit A. Alaska Energy Authority Battle Creek Diversion Project Determination of Adjusted Development Costs & * Series 7 * Series 8 BCD Project Adjusted Development Costs as of 6/1/2022: GVEA Projected Participation Percentage Share: Page 1 5/17/2021 Alaska Energy Authority Battle Creek Diversion Project Debt Service Schedule EXHIBIT A 12/26/2017 7/1/2050 32.51 4.14% Date Principal Interest Debt Service Subsidy Subsidy Sequestration Net Subsidy Net Debt Service Principal Interest Debt Service Subsidy Subsidy Sequestration Net Subsidy Net Debt Service 12/26/2017 7/1/2018 868,909.59 868,909.59 (593,891.51)39,196.84 (554,694.67)314,214.92 26,914.47 26,914.47 (18,395.79)1,214.12 (17,181.67)9,732.80 1/1/2019 854,969.86 854,969.86 (584,363.84)36,230.56 (548,133.28)306,836.58 26,482.69 26,482.69 (18,100.67)1,122.24 (16,978.43)9,504.26 7/1/2019 841,030.14 841,030.14 (574,836.16)35,639.84 (539,196.32)301,833.82 26,050.91 26,050.91 (17,805.55)1,103.94 (16,701.61)9,349.30 1/1/2020 854,969.86 854,969.86 (584,363.84)34,477.47 (549,886.37)305,083.49 26,482.69 26,482.69 (18,100.67)1,067.94 (17,032.73)9,449.96 7/1/2020 845,676.71 845,676.71 (578,012.05)32,560.55 (545,451.50)300,225.21 26,194.84 26,194.84 (17,903.92)992.22 (16,911.70)9,283.14 1/1/2021 854,969.86 854,969.86 (584,363.84)33,308.74 (551,055.10)303,914.76 26,482.69 26,482.69 (18,100.67)1,031.74 (17,068.93)9,413.76 7/1/2021 1,333,334 848,000.00 2,181,334.00 (579,600.00)33,037.20 (546,562.80)1,634,771.20 41,300 26,266.80 67,566.80 (17,953.11)1,023.33 (16,929.78)50,637.02 1/1/2022 819,733.32 819,733.32 (560,279.99)31,935.96 (528,344.03)291,389.29 25,391.24 25,391.24 (17,354.67)989.22 (16,365.46)9,025.78 7/1/2022 1,333,334 819,733.32 2,153,067.32 (560,279.99)31,935.96 (528,344.03)1,624,723.29 41,300 25,391.24 66,691.24 (17,354.67)989.22 (16,365.46)50,325.78 1/1/2023 791,466.64 791,466.64 (540,959.98)30,834.72 (510,125.26)281,341.38 24,515.68 24,515.68 (16,756.24)955.11 (15,801.13)8,714.55 7/1/2023 1,333,334 791,466.64 2,124,800.64 (540,959.98)30,834.72 (510,125.26)1,614,675.38 41,300 24,515.68 65,815.68 (16,756.24)955.11 (15,801.13)50,014.55 1/1/2024 763,199.96 763,199.96 (521,639.97)29,733.48 (491,906.49)271,293.47 23,640.12 23,640.12 (16,157.80)920.99 (15,236.80)8,403.32 7/1/2024 1,333,334 763,199.96 2,096,533.96 (521,639.97)29,733.48 (491,906.49)1,604,627.47 41,300 23,640.12 64,940.12 (16,157.80)920.99 (15,236.80)49,703.32 1/1/2025 734,933.28 734,933.28 (502,319.96)28,632.24 (473,687.72)261,245.56 22,764.56 22,764.56 (15,559.36)886.88 (14,672.48)8,092.08 7/1/2025 1,333,334 734,933.28 2,068,267.28 (502,319.96)28,632.24 (473,687.72)1,594,579.56 41,300 22,764.56 64,064.56 (15,559.36)886.88 (14,672.48)49,392.08 1/1/2026 706,666.60 706,666.60 (482,999.95)27,531.00 (455,468.95)251,197.65 21,889.00 21,889.00 (14,960.93)852.77 (14,108.15)7,780.85 7/1/2026 1,333,334 706,666.60 2,040,000.60 (482,999.95)27,531.00 (455,468.95)1,584,531.65 41,300 21,889.00 63,189.00 (14,960.93)852.77 (14,108.15)49,080.85 1/1/2027 678,399.92 678,399.92 (463,679.94)26,429.76 (437,250.19)241,149.73 21,013.44 21,013.44 (14,362.49)818.66 (13,543.83)7,469.61 7/1/2027 1,333,334 678,399.92 2,011,733.92 (463,679.94)26,429.76 (437,250.19)1,574,483.73 41,300 21,013.44 62,313.44 (14,362.49)818.66 (13,543.83)48,769.61 1/1/2028 650,133.23 650,133.23 (444,359.93)25,328.52 (419,031.42)231,101.81 20,137.88 20,137.88 (13,764.05)784.55 (12,979.50)7,158.38 7/1/2028 1,333,334 650,133.23 1,983,467.23 (444,359.93)25,328.52 (419,031.42)1,564,435.81 41,300 20,137.88 61,437.88 (13,764.05)784.55 (12,979.50)48,458.38 1/1/2029 621,866.55 621,866.55 (425,039.92)24,227.28 (400,812.65)221,053.90 19,262.32 19,262.32 (13,165.61)750.44 (12,415.17)6,847.15 7/1/2029 1,333,334 621,866.55 1,955,200.55 (425,039.92)24,227.28 (400,812.65)1,554,387.90 41,300 19,262.32 60,562.32 (13,165.61)750.44 (12,415.17)48,147.15 1/1/2030 593,599.87 593,599.87 (405,719.91)23,126.04 (382,593.88)211,005.99 18,386.76 18,386.76 (12,567.18)716.33 (11,850.85)6,535.91 7/1/2030 1,333,334 593,599.87 1,926,933.87 (405,719.91)23,126.04 (382,593.88)1,544,339.99 41,300 18,386.76 59,686.76 (12,567.18)716.33 (11,850.85)47,835.91 1/1/2031 565,333.19 565,333.19 (386,399.90)178,933.29 17,511.20 17,511.20 (11,968.74)5,542.46 7/1/2031 1,333,333 565,333.19 1,898,666.19 (386,399.90)1,512,266.29 41,300 17,511.20 58,811.20 (11,968.74)46,842.46 1/1/2032 537,066.53 537,066.53 (367,079.91)169,986.62 16,635.64 16,635.64 (11,370.30)5,265.34 7/1/2032 1,333,333 537,066.53 1,870,399.53 (367,079.91)1,503,319.62 41,300 16,635.64 57,935.64 (11,370.30)46,565.34 1/1/2033 508,799.87 508,799.87 (347,759.91)161,039.96 15,760.08 15,760.08 (10,771.87)4,988.21 7/1/2033 1,333,333 508,799.87 1,842,132.87 (347,759.91)1,494,372.96 41,300 15,760.08 57,060.08 (10,771.87)46,288.21 1/1/2034 480,533.21 480,533.21 (328,439.92)152,093.29 14,884.52 14,884.52 (10,173.43)4,711.09 7/1/2034 1,333,333 480,533.21 1,813,866.21 (328,439.92)1,485,426.29 41,300 14,884.52 56,184.52 (10,173.43)46,011.09 1/1/2035 452,266.55 452,266.55 (309,119.92)143,146.63 14,008.96 14,008.96 (9,574.99)4,433.97 7/1/2035 1,333,333 452,266.55 1,785,599.55 (309,119.92)1,476,479.63 41,300 14,008.96 55,308.96 (9,574.99)45,733.97 1/1/2036 423,999.89 423,999.89 (289,799.93)134,199.96 13,133.40 13,133.40 (8,976.56)4,156.85 7/1/2036 1,333,333 423,999.89 1,757,332.89 (289,799.93)1,467,532.96 41,300 13,133.40 54,433.40 (8,976.56)45,456.85 1/1/2037 395,733.23 395,733.23 (270,479.93)125,253.30 12,257.84 12,257.84 (8,378.12)3,879.72 Interest Subsidy Basis Series 7 Series 8 Issue Date Final Maturity Term Page 2 5/17/2021 Alaska Energy Authority Battle Creek Diversion Project Debt Service Schedule EXHIBIT A Date Principal Interest Debt Service Subsidy Subsidy Sequestration Net Subsidy Net Debt Service Principal Interest Debt Service Subsidy Subsidy Sequestration Net Subsidy Net Debt Service Series 7 Series 8 7/1/2037 1,333,333 395,733.23 1,729,066.23 (270,479.93)1,458,586.30 41,300 12,257.84 53,557.84 (8,378.12)45,179.72 1/1/2038 367,466.57 367,466.57 (251,159.94)116,306.63 11,382.28 11,382.28 (7,779.68)3,602.60 7/1/2038 1,333,333 367,466.57 1,700,799.57 (251,159.94)1,449,639.63 41,300 11,382.28 52,682.28 (7,779.68)44,902.60 1/1/2039 339,199.92 339,199.92 (231,839.94)107,359.98 10,506.72 10,506.72 (7,181.24)3,325.48 7/1/2039 1,333,333 339,199.92 1,672,532.92 (231,839.94)1,440,692.98 41,300 10,506.72 51,806.72 (7,181.24)44,625.48 1/1/2040 310,933.26 310,933.26 (212,519.95)98,413.31 9,631.16 9,631.16 (6,582.81)3,048.35 7/1/2040 1,333,333 310,933.26 1,644,266.26 (212,519.95)1,431,746.31 41,300 9,631.16 50,931.16 (6,582.81)44,348.35 1/1/2041 282,666.60 282,666.60 (193,199.95)89,466.65 8,755.60 8,755.60 (5,984.37)2,771.23 7/1/2041 1,333,333 282,666.60 1,615,999.60 (193,199.95)1,422,799.65 41,300 8,755.60 50,055.60 (5,984.37)44,071.23 1/1/2042 254,399.94 254,399.94 (173,879.96)80,519.98 7,880.04 7,880.04 (5,385.93)2,494.11 7/1/2042 1,333,333 254,399.94 1,587,732.94 (173,879.96)1,413,852.98 41,300 7,880.04 49,180.04 (5,385.93)43,794.11 1/1/2043 226,133.28 226,133.28 (154,559.96)71,573.32 7,004.48 7,004.48 (4,787.50)2,216.98 7/1/2043 1,333,333 226,133.28 1,559,466.28 (154,559.96)1,404,906.32 41,300 7,004.48 48,304.48 (4,787.50)43,516.98 1/1/2044 197,866.62 197,866.62 (135,239.97)62,626.65 6,128.92 6,128.92 (4,189.06)1,939.86 7/1/2044 1,333,333 197,866.62 1,531,199.62 (135,239.97)1,395,959.65 41,300 6,128.92 47,428.92 (4,189.06)43,239.86 1/1/2045 169,599.96 169,599.96 (115,919.97)53,679.99 5,253.36 5,253.36 (3,590.62)1,662.74 7/1/2045 1,333,333 169,599.96 1,502,932.96 (115,919.97)1,387,012.99 41,300 5,253.36 46,553.36 (3,590.62)42,962.74 1/1/2046 141,333.30 141,333.30 (96,599.98)44,733.32 4,377.80 4,377.80 (2,992.19)1,385.62 7/1/2046 1,333,333 141,333.30 1,474,666.30 (96,599.98)1,378,066.32 41,300 4,377.80 45,677.80 (2,992.19)42,685.62 1/1/2047 113,066.64 113,066.64 (77,279.98)35,786.66 3,502.24 3,502.24 (2,393.75)1,108.49 7/1/2047 1,333,333 113,066.64 1,446,399.64 (77,279.98)1,369,119.66 41,300 3,502.24 44,802.24 (2,393.75)42,408.49 1/1/2048 84,799.98 84,799.98 (57,959.99)26,839.99 2,626.68 2,626.68 (1,795.31)831.37 7/1/2048 1,333,333 84,799.98 1,418,132.98 (57,959.99)1,360,172.99 41,300 2,626.68 43,926.68 (1,795.31)42,131.37 1/1/2049 56,533.32 56,533.32 (38,639.99)17,893.33 1,751.12 1,751.12 (1,196.87)554.25 7/1/2049 1,333,333 56,533.32 1,389,866.32 (38,639.99)1,351,226.33 41,300 1,751.12 43,051.12 (1,196.87)41,854.25 1/1/2050 28,266.66 28,266.66 (19,320.00)8,946.66 875.56 875.56 (598.44)277.12 7/1/2050 1,333,333 28,266.66 1,361,599.66 (19,320.00)1,342,279.66 41,300 875.56 42,175.56 (598.44)41,577.12 40,000,000 30,560,521.80 (20,887,828.33)50,412,702.61 1,239,000 946,612.29 (647,000.57)1,561,517.16 Page 3 5/17/2021