Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2021-10-01 BPMC Agenda and docs
BRADLEY LAKE PROJECT MANAGEMENT COMMITTEE REGULAR MEETING AGENDA Friday, October 1, 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 – JULY 30, 2021 7. NEW BUSINESS A. FY 22 Budget Amendment 3 8. EXECUTIVE SESSION – Discuss matters with attorney for the Committee which the immediate knowledge of which could have an adverse effect upon the finances of the Committee. 9. OLD BUSINESS A. GVEA Call Back Recommendation O&D /Budget Subcommittee B. By-Law Amendment Gibson C. Required Project Work Letter to LAW Gibson 10. OPERATORS REPORT HEA 11. O&D REPORT - Capital / required project work CEA 12. COMMITTEE REPORTS A. Budget to Actual Budget Subcommittee 13. COMMITTEE ASSIGNMENTS 14. MEMBERS COMMENTS 15. NEXT MEETING DATE – December 10, 2021 16. ADJOURNMENT ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT FY2022 PROPOSED BUDGET - AMEND 3 DATE: OCTOBER 1, 2021 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT 2022 Budget Contents Schedule Description Page # Summary FY22 Proposed Budget Summary 3 Schedule A Bradley Lake Capital Purchases (not funded by R&C)4 Schedule B Bradley Lake Operations & Maintenance Budget 5 - 13 Schedule C Bradley Lake Monthly Utility Contributions 14 Schedule D R&C Fund Disbursements and Repayments 15 Schedule E Battle Creek Capital Purchases (not funded by R&C)16 Schedule F Battle Creek Operations & Maintenance Budget 17 - 18 Schedule G Battle Creek Monthly Utility Contributions 19 Schedule H SSQ Line Capital Purchases (not funded by R&C)20 Schedule I SSQ Line Operations & Maintenance Budget 21 Schedule J SSQ Line Monthly Utility Contributions 22 ` 9/13/20218:03 AMH:\Accounting\AEA FY22 FS Shared Files\Bradley Lake\Budget\Budget Amend 3\2022-BradleyBudget-Proposed Budget Amend 3.xlsx 2 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Budget Summary FY2021 FY2022 FY2022 FY2022 FY2022 FY2022 Inc(Dec) From FY2019 FY2020 Amended Amend 1 Proposed Amend 2 Proposed Amend 3 FY21 Amended Bradley Lake (excluding Battle Creek & SSQ Line shown below)Actuals Actuals Budget Budget Changes Budget Changes Budget Budget Revenues, Expenses & Changes in surplus Revenues Utility Contributions (sch C)18,132,905 18,507,495 16,403,421 10,553,726 619,733 11,173,459 0 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 0 500 0 500 (749,500) Other Available Funds - - 1,325,513 9,893,771 0 9,893,771 0 9,893,771 8,568,259 20,081,429 20,395,281 20,277,934 20,447,997 619,733 21,067,730 0 21,067,730 789,796 Expenses Operations & Maintenance (sch B)4,019,975 4,773,126 5,798,702 5,947,908 516,444 6,464,352 0 6,464,352 665,650 Renewals/Replacements (R&C Fund Repayments) (sch D)2,774,832 2,278,302 1,184,753 1,256,902 (0)1,256,902 0 1,256,902 72,149 Renewals/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 0 759,000 0 759,000 107,000 Transfer To(From) Operating Reserve 38,816 112,715 84,752 29,841 103,289 133,130 0 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 0 0 - - (354,464) Excess Payment Agreement - - - 12,454,346 0 12,454,346 0 12,454,346 12,454,346 20,081,429 20,395,281 20,277,934 20,447,997 619,733 21,067,730 0 21,067,730 789,796 Surplus (Deficit)0 0 0 0 0 0 0 0 0 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 0 3,564,453 0 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 0 3,564,453 0 3,564,453 (2,448,595) Expenses - Battle Creek Battle Creek Operations & Maintenance (sch F)527,723 580,606 547,714 399,610 0 399,610 0 399,610 (148,104) Renewals/Replacements (R&C Fund Repayments) (sch D)- - 1,104,000 1,104,000 0 1,104,000 0 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 0 115,000 0 115,000 (205,000) Transfer To(From) Operating Reserve 82,038 (11,713)30,926 (29,621)0 (29,621)0 (29,621)(60,547) Debt Service 1,748,534 1,753,324 3,518,317 3,064,883 0 3,064,883 0 3,064,883 (453,434) IRS Subsidy (1,121,010)(1,129,282)- (1,089,419) - (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 0 3,564,453 0 3,564,453 (2,448,595) Surplus (Deficit)0 0 0 0 0 0 0 0 0 Other Project Costs - SSQ Line Revenues, Expenses & Changes in surplus Revenues - SSQ Line Utility Contributions (sch J)- - 360,000 499,428 (0)499,428 750,000 1,249,428 139,428 Other Miscellaneous-R&C Fund Cash Call - - - - - - - - 0 Capital Reserve Contributions - - - - - - - - 0 Other Available Funds - - - 1,559,492 0 1,559,492 0 1,559,492 1,559,492 - - 360,000 2,058,920 (0)2,058,920 750,000 2,808,920 1,698,920 Expenses - SSQ Line SSQ Line Operations & Maintenance (sch I)- - 170,000 444,523 0 444,523 0 444,523 274,523 Renewals/Replacements (R&C Fund Repayments) (sch D)- - - 0 0 0 - - 0 Renewals/Replacements (R&C Fund Cash Call) (sch D)- - - 0 0 0 - - 0 Capital Purchases (sch H)- - 190,000 0 0 0 750,000 750,000 (190,000) Transfer To(From) Operating Reserve - - - 54,905 (0)54,905 0 54,905 54,905 Debt Service - - - 1,559,492 0 1,559,492 0 1,559,492 1,559,492 Capital Reserve Contribution - - - 0 0 0 - - 0 - - 360,000 2,058,920 (0)2,058,920 750,000 2,808,920 1,698,920 Surplus (Deficit)0 0 0 0 (0)0 0 0 0 Other Information Operating Reserve *957,494 1,070,208 1,159,740 1,189,582 103,289 1,292,870 0 1,292,870 Operating Reserve - Battle Creek*90,798 79,085 109,543 79,922 0 79,922 0 79,922 Operating Reserve - SSQ Line*34,000 88,905 0 88,905 0 88,905 Monthly Contributions 1,511,075 1,632,040 1,366,952 879,477 51,644 931,122 0 931,122 Monthly Contributions Battle Creek 109,978 242,670 501,087 297,038 0 297,038 0 297,038 Monthly Contributions SSQ Line 30,000 41,619 0 41,619 62,500 104,119 *Required to be 20% of budgeted operating expense 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSummary Page 3 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Capital Purchases (not funded by R&C Fund) Schedule A FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 Amended Amend 1 Proposed Amend 2 Proposed Amend 3 Actuals Actuals Budget Budget Changes Budget Changes Budget Comments for FY22: Replace/Automate Fish Water Valves & Actuators 17,142 2,931 40,000 - - - - - Upgrade Crews Quarters\Residence Kitchen - - 139,000 - 139,000 - 139,000 was on hold until DOWL is not occupying the Crews Quarters Replace 1988 Suburban Ambulance 5,350 - - - - - - Tire machine 15,246 - - - - - - Replace dump truck and sander - - 170,000 20,000 - 20,000 - 20,000 need new sander Pick 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 - 45,000 Need for Unit 1 KVM 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 - 20,000 Smaller trailer for mini ABB Replace GIS Actuators 240,000 - 240,000 - 240,000 no longer supported Replacement pickup truck 45,000 - 45,000 - 45,000 Replace fuel truck (bad electrics) Needle Valve rebuild 150,000 - 150,000 - 150,000 Used up needle tip and cones in 2020/21 overhaul Start new servo design 100,000 - 100,000 - 100,000 Voith recommends new design Total Non R&C Capital Purchases 37,738 283,425 462,000 759,000 - 759,000 - 759,000 Capital Project Description 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch A Page 4 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Bradley Lake Operations and Maintenance Budget Schedule B HEA 3,145,798 2,436,506 709,292 3,822,764 3,020,964 801,799 4,066,378 4,112,706 - 4,112,706 - 4,112,706 46,328 CEA 183,491 168,393 15,098 109,547 155,656 (46,109) 101,785 134,161 - 134,161 - 134,161 32,377 AEA 1,458,178 1,415,076 43,102 1,418,731 1,596,506 (177,775) 1,641,784 1,891,750 - 2,408,194 - 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 - 6,655,062 835,650 - - - - - - - - - FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20 Amended Budget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY Summary by cost type Labor & Benefits 1,572,497 1,307,518 264,979 1,219,935 1,011,432 208,503 1,257,590 1,307,994 - 1,307,994 - 1,307,994 50,405 Indirect Costs 583,803 579,114 4,689 1,383,388 1,251,241 132,147 1,486,285 1,486,285 - 1,486,285 - 1,486,285 0 Travel 33,950 28,380 5,570 45,950 10,512 35,438 44,950 38,450 - 38,450 - 38,450 (6,500) Training 49,300 20,956 28,344 49,300 14,875 34,425 49,300 49,300 - 49,300 - 49,300 - Contractual 1,033,216 633,893 399,323 869,842 655,575 214,267 903,340 1,044,525 - 1,044,525 - 1,044,525 141,185 Supplies & Materials 204,345 156,339 48,006 346,345 262,370 83,975 389,345 429,345 - 429,345 - 429,345 40,000 Other Costs 69,818 31,293 38,525 67,818 65,648 2,170 70,818 67,318 - 67,318 - 67,318 (3,500) Equipment, Furniture and Machinery 7,000 6,879 121 176,000 127,535 48,465 170,000 73,000 - 73,000 - 73,000 (97,000) Maintenance Projects - 44,926 (44,926) - 314 (314) - - - - - - - Administrative Costs 1,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 - 2,158,844 720,525 Battle Creek O&M - - - - - - (181,245) (190,710) - (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 - 6,464,352 835,650 Bradley Lake O&M 4% charge to Battle Creek Battle Creek O&M - - - - - - (181,245) (190,710) - (190,710) - (190,710) BC (9,465) Bradley Lake O&M 4% charge to Battle Creek FERC 535 - Operation Supervision & Engineering Operations Sup/Eng Bradley Lake Operating Labor & Benefits 189,074 182,059 7,015 107,453 89,713 17,740 107,453 107,604 - 107,604 - 107,604 151 Indirect Costs 77,849 74,535 3,314 155,698 128,545 27,153 155,698 155,698 - 155,698 - 155,698 - Travel 10,450 13,462 (3,012) 10,450 246 10,204 10,450 10,450 - 10,450 - 10,450 - Training 9,300 4,305 4,995 9,300 991 8,309 9,300 9,300 - 9,300 - 9,300 - Contractual 1,000 257 743 1,000 173 827 11,000 11,000 - 11,000 - 11,000 - Supplies & Materials 4,000 2,688 1,312 4,000 3,698 302 4,000 4,000 - 4,000 - 4,000 - Bradley Lake Operating Total 291,673 277,306 14,367 287,901 223,366 64,536 297,901 298,053 - 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 - 298,053 HEA 151 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch B Page 5 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20 Amended Budget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY FERC 537 - Hydraulic Expenses Hydraulic Expenses Bradley Lake Operating Labor & Benefits 88,714 71,767 16,947 84,081 67,694 16,387 84,192 84,192 - 84,192 - 84,192 - Indirect Costs 41,515 42,543 (1,028) 107,519 98,886 8,633 114,320 114,320 - 114,320 - 114,320 - Travel - - - 10,000 - 10,000 10,000 8,000 - 8,000 - 8,000 (2,000) Contractual 2,000 11,524 (9,524) 22,000 - 22,000 22,000 73,000 - 73,000 - 73,000 51,000 Supplies & Materials 2,000 2,636 (636) 19,000 9,806 9,194 59,000 16,000 - 16,000 - 16,000 (43,000) Equipment, Furniture and Machinery - - - 81,000 13,368 67,632 32,000 39,000 - 39,000 - 39,000 7,000 Bradley Lake Operating Total 134,230 128,470 5,760 323,600 189,754 133,846 321,512 334,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 - 334,512 HEA 13,000 FERC 538 - Electric Expenses Electric Expenses Bradley Lake Operating Labor & Benefits 224,811 209,646 15,165 208,745 210,745 (2,000) 218,044 218,044 - 218,044 - 218,044 0 Indirect Costs 102,222 110,544 (8,322) 242,067 257,551 (15,484) 262,004 262,004 - 262,004 - 262,004 (0) Travel 7,000 4,890 2,110 7,000 3,140 3,860 7,000 7,000 - 7,000 - 7,000 - Training 25,000 12,406 12,594 25,000 13,884 11,116 25,000 25,000 - 25,000 - 25,000 - Contractual 2,000 - 2,000 7,000 2,587 4,413 2,000 5,000 - 5,000 - 5,000 3,000 Supplies & Materials 9,732 4,503 5,229 50,732 14,111 36,621 41,732 42,732 - 42,732 - 42,732 1,000 Equipment, Furniture and Machinery - - - 63,000 91,512 (28,512) 73,000 11,000 - 11,000 - 11,000 (62,000) Other Costs - 5,000 - - - - - (5,000) Bradley Lake Operating Total 370,765 341,989 28,776 603,544 593,530 10,014 633,780 570,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 - 570,780 HEA (63,000) 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch B Page 6 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20 Amended Budget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY FERC 539 - Misc. Hydraulic Power Generation Expenses Misc Hydro Power Exp Bradley Lake Operating Labor & Benefits 168,044 116,910 51,134 104,936 70,195 34,741 105,047 104,788 - 104,788 - 104,788 (258) Indirect Costs 41,515 42,396 (881) 107,519 98,544 8,975 114,320 114,320 - 114,320 - 114,320 0 Training 15,000 4,245 10,755 15,000 - 15,000 15,000 15,000 - 15,000 - 15,000 - Contractual 287,525 147,555 139,970 287,525 185,822 101,703 287,525 287,525 - 287,525 - 287,525 - Supplies & Materials 17,900 31,565 (13,665) 17,900 31,569 (13,669) 17,900 17,900 - 17,900 - 17,900 - Bradley Lake Operating Total 529,984 342,671 187,313 532,879 386,130 146,749 539,791 539,533 - 539,533 - 539,533 HEA (258) BRADLEY CIRCUITS/RADIO TO BERNICE LK Other Costs 35,695 35,696 (1) 35,695 35,696 (1) 35,695 35,695 - 35,695 - 35,695 - BRADLEY CIRCUITS/RADIO TO BERNICE LK Total 35,695 35,696 (1) 35,695 35,696 (1) 35,695 35,695 - 35,695 - 35,695 HEA - BRADLEY CIRCUITS BERNICE LK TO ANCH Other Costs 29,773 29,524 249 29,773 29,194 579 29,773 29,773 - 29,773 - 29,773 - BRADLEY CIRCUITS BERNICE LK TO ANCH Total 29,773 29,524 249 29,773 29,194 579 29,773 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 - 605,001 (258) FERC 540 - Rents FERC Land Use Fee Bradley Lake Operating Other 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 & Engineering Maint Supervision/Eng Bradley Lake Operating Labor & Benefits 195,817 181,894 13,923 114,456 84,904 29,552 114,456 114,758 - 114,758 - 114,758 302 Indirect Costs 77,849 74,373 3,476 155,698 121,096 34,602 155,698 155,698 - 155,698 - 155,698 - Bradley Lake Operating Total 273,666 256,267 17,399 270,154 206,000 64,154 270,154 270,456 - 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 - 270,456 HEA 302 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch B Page 7 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20 Amended Budget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY FERC 542 - Maintenance of Structures Maintenance of Structures Bradley Lake Operating Labor & Benefits 85,438 67,934 17,504 76,499 62,612 13,887 77,639 77,639 - 77,639 - 77,639 0 Indirect Costs 37,066 37,809 (743) 97,823 91,244 6,579 105,421 105,421 - 105,421 - 105,421 (0) Contractual 10,000 - 10,000 91,000 3,682 87,318 59,000 89,000 - 89,000 - 89,000 30,000 Supplies & Materials 53,713 46,903 6,810 88,713 39,489 49,224 100,713 243,713 - 243,713 - 243,713 143,000 Equipment, Furniture and Machinery 7,000 6,879 121 32,000 22,552 9,448 52,000 23,000 - 23,000 - 23,000 (29,000) Maintenance Projects - - - - - - - - - - - - - Bradley Lake Operating Total 193,217 159,525 33,692 386,035 219,579 166,456 394,773 538,773 - 538,773 - 538,773 144,000 BRADLEY UPGRADE CREWS QUARTERS/RESIDENCE KITCHEN Contractual 165,000 - - - - - - - - - - - - BRADLEY UPGRADE CREWS QUARTERS/RESIDENCE KITCHEN 165,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 - 538,773 HEA 144,000 FERC 543 - Maintenance of Reservoirs, Dams & Waterways Maint Res, Dams, WWays Bradley Lake Operating Labor & Benefits 45,552 4,723 40,829 45,080 1,335 43,745 40,744 40,744 - 40,744 - 40,744 0 Indirect Costs 19,932 87 19,845 56,322 1,693 54,629 56,689 56,689 - 56,689 - 56,689 (0) Travel 5,000 5,000 - 5,000 - 5,000 - Contractual 6,500 7,600 (1,100) 6,500 - 6,500 6,500 6,500 - 6,500 - 6,500 - Supplies & Materials 15,000 15,000 - 15,000 - 15,000 - Bradley Lake Operating Total 71,984 12,410 59,574 107,902 3,028 104,874 123,933 123,933 - 123,933 - 123,933 - BRADLEY NUKA REPAIR Contractual 15,000 - 15,000 - - - - - - - - - - Supplies & Materials - - - - - - - - - - - - - Equipment, Furniture and Machinery - - - - - - - - - - - - - BRADLEY NUKA REPAIR Total 15,000 - 15,000 - - - - - - - - - - BRADLEY POWER TUNNEL MAINT (Dam) Contractual 15,000 - 15,000 15,000 - 15,000 15,000 15,000 - 15,000 - 15,000 - - BRADLEY POWER TUNNEL MAINT (Dam) Total 15,000 - 15,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 - 138,933 HEA - 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch B Page 8 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20 Amended Budget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY FERC 544 - Maintenance of Electric Plant Maintenance of Elec Plant Bradley Lake Operating Labor & Benefits 342,265 285,366 56,899 273,620 249,706 23,914 309,110 309,110 - 309,110 - 309,110 - Indirect Costs 148,789 156,963 (8,174) 368,424 362,402 6,022 423,178 423,178 - 423,178 - 423,178 - Travel 4,500 216 4,284 4,500 - 4,500 4,500 4,500 - 4,500 - 4,500 - Contractual 70,000 69,475 525 49,000 19,661 29,339 86,000 49,000 - 49,000 - 49,000 (37,000) Supplies & Materials 20,000 16,571 3,429 70,000 66,370 3,630 38,000 30,000 - 30,000 - 30,000 (8,000) Maintenance Projects - 44,926 (44,926) - - - - - - - - - - Bradley Lake Operating Total 585,554 573,517 12,037 765,544 698,139 67,405 860,788 815,788 - 815,788 - 815,788 (45,000) BRADLEY HIGH BAY LIGHTS - Supplies & Materials 30,000 - 30,000 - - - - - - - - - - BRADLEY HIGH BAY LIGHTS Total 30,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 - 815,788 HEA (45,000) FERC 545 - Maintenance of Misc. Hydraulic Plant Maint of Misc Hydr Plant Bradley Lake Operating Labor & Benefits 85,438 70,963 14,475 69,395 62,843 6,552 69,297 69,297 - 69,297 - 69,297 (0) Indirect Costs 37,066 39,864 (2,798) 92,318 91,280 1,038 98,957 98,957 - 98,957 - 98,957 0 Contractual 3,900 - 3,900 3,900 6,763 (2,863) 3,900 3,900 - 3,900 - 3,900 - Supplies & Materials 35,000 33,168 1,832 63,000 93,510 (30,510) 58,000 34,000 - 34,000 - 34,000 (24,000) Maintenance Projects - 314 (314) - - - - - Bradley Lake Operating Total 161,404 143,995 17,409 228,613 254,710 (26,097) 230,154 206,154 - 206,154 - 206,154 (24,000) BRADLEY FISH WATER DSGN/MIDDLE FORK SHACK IMPR Contractual - - - - - - - - - - - - - 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 - 206,154 HEA (24,000) 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch B Page 9 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20 Amended Budget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY FERC 556 - System Control & Load Dispatching System Cntl & Load Disp Bradley Lake Operating Labor & Benefits 21,506 20,920 586 21,140 37,092 (15,952) 21,140 19,708 - 19,708 - 19,708 (1,432) Contractual 53,000 44,800 8,200 53,000 57,365 (4,365) 53,000 53,000 - 53,000 - 53,000 - Supplies & Materials 6,000 613 5,387 6,000 3,204 2,796 6,000 6,000 - 6,000 - 6,000 - Equipment, Furniture and Machinery - - - - - - - - - - - - - Bradley Lake Operating Total 80,506 66,333 14,173 80,140 97,661 (17,521) 80,140 78,708 - 78,708 - 78,708 HEA (1,432) BRADLEY EMERSON ANTIVIRUS UPGRADE Contractual 40,000 41,740 (1,740) - - - - - - - - - HEA - BRADLEY EMERSON ANTIVIRUS UPGRADE Total 40,000 41,740 (1,740) - - - - - - - - - - Snow Measurement Bradley Lake Operating Contractual 12,000 10,000 2,000 10,000 10,000 - 10,000 10,000 - 10,000 - 10,000 AEA - Bradley Lake Operating Total 12,000 10,000 2,000 10,000 10,000 - 10,000 10,000 - 10,000 - 10,000 - Seismic Service Bradley Lake Operating Contractual 62,000 61,569 431 62,000 56,310 5,690 62,000 62,000 - 62,000 - 62,000 AEA - Bradley Lake Operating Total 62,000 61,569 431 62,000 56,310 5,690 62,000 62,000 - 62,000 - 62,000 - Streamguaging Serv Bradley Lake Operating Contractual 206,291 186,291 20,000 209,917 189,917 20,000 183,615 218,000 - 218,000 - 218,000 AEA 34,385 Bradley Lake Operating Total 206,291 186,291 20,000 209,917 189,917 20,000 183,615 218,000 - 218,000 - 218,000 34,385 Permits Bradley Lake Operating Other Costs 350 250 100 350 758 (408) 350 350 - 350 - 350 AEA - Bradley Lake Operating Total 350 250 100 350 758 (408) 350 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 - 369,058 32,953 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch B Page 10 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20 Amended Budget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY FERC 562 - Station Expenses Station Expenses SVC/Substation Maintenance Contract Labor & Benefits 94,718 83,226 11,492 59,774 72,086 (12,312) 55,712 62,388 - 62,388 - 62,388 CEA 6,677 Travel 2,000 1,632 368 4,000 2,596 1,404 4,500 3,500 - 3,500 - 3,500 CEA (1,000) Contractual 32,000 35,207 (3,207) 2,000 51,167 (49,167) 1,800 2,000 - 2,000 - 2,000 CEA 200 Supplies & Materials 21,000 17,692 3,308 12,000 613 11,387 10,000 10,000 - 10,000 - 10,000 CEA - Other Costs 4,000 1,112 2,888 2,000 - 2,000 - 1,500 - 1,500 - 1,500 CEA 1,500 Equipment, Furniture and Machinery - - - - - - - - - - - - CEA - Maintenance Projects - - - - - - - - - - - - CEA - Labor & Benefits - - - 27,298 - 27,298 27,298 71,759 - 71,759 - 71,759 HEA 44,461 Contractual - - - - - - - 59,600 - 59,600 - 59,600 HEA 59,600 Supplies & Materials - - - 10,000 - 10,000 34,000 5,000 - 5,000 - 5,000 HEA (29,000) Equipment, Furniture and Machinery - - - - - - 13,000 - - - - - HEA (13,000) - SVC/Substation Maintenance Contract Total 153,718 138,869 14,849 117,072 126,462 (9,390) 146,309 215,747 - 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 - 215,747 69,438 FERC 563 - Weather Monitoring Power Sup Bradley Lake Operating Contractual - - - - 5,244 (5,244) AEA - Bradley Lake Operating Total - - - - 5,244 (5,244) - FERC 571 - Maintenance of Overhead Lines Maint of OH Lines Bradley Lake Operating Labor & Benefits 31,120 12,110 19,010 27,459 2,507 24,952 27,459 27,963 - 27,963 - 27,963 504 Travel 10,000 8,180 1,820 10,000 4,530 5,470 - - - - - - - Contractual 50,000 17,875 32,125 50,000 66,884 (16,884) 100,000 100,000 - 100,000 - 100,000 - Supplies & Materials 5,000 - 5,000 5,000 - 5,000 5,000 5,000 - 5,000 - 5,000 - Equipment, Furniture and Machinery - - - - 103 (103) - - - - - - - Bradley Lake Operating Total 96,120 38,165 57,955 92,459 74,024 18,435 132,459 132,963 - 132,963 - 132,963 HEA 504 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 - 132,963 504 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch B Page 11 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20 Amended Budget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY FERC 920 & 930 - Administrative Expense AEA Bradley Admin Fees Bradley Lake Operating Administrative Costs 200,000 200,000 - 200,000 200,000 - 201,000 274,000 - 274,000 - 274,000 73,000 Administrative Costs 2,500 2,500 - 2,500 - 2,500 - Travel 3,500 - - - - - (3,500) Bradley Lake Operating Total 200,000 200,000 - 200,000 200,000 - 207,000 276,500 - 276,500 - 276,500 AEA 69,500 Operating Committee Exp-Audit Bradley Lake Operating Administrative Costs 16,500 19,900 (3,400) 19,900 20,298 (398) 19,900 19,900 - 19,900 - 19,900 AEA - Bradley Lake Operating Total 16,500 19,900 (3,400) 19,900 20,298 (398) 19,900 19,900 - 19,900 - 19,900 - Operating Committee Exp-Legal Bradley Lake Operating Administrative Costs 25,000 140,453 (115,453) 30,000 215,162 (185,162) 70,000 70,000 - 70,000 - 70,000 AEA - Bradley Lake Operating Total 25,000 140,453 (115,453) 30,000 215,162 (185,162) 70,000 70,000 - 70,000 - 70,000 - Operat Committee Exp-Arbitrage Bradley Lake Operating Administrative Costs 2,935 2,785 150 3,000 2,685 315 5,000 5,000 - 5,000 - 5,000 AEA - Bradley Lake Operating Total 2,935 2,785 150 3,000 2,685 315 5,000 5,000 - 5,000 - 5,000 - Trust & Account Fees Bradley Lake Operating Administrative Costs 11,918 11,918 - 11,918 12,118 (200) 13,000 13,000 - 13,000 - 13,000 AEA - Bradley Lake Operating Total 11,918 11,918 - 11,918 12,118 (200) 13,000 13,000 - 13,000 - 13,000 - Misc Admin Bradley Lake Operating Administrative Costs 10,350 11,646 (1,296) 11,646 12,000 (354) 18,900 12,000 - 12,000 - 12,000 AEA (6,900) Bradley Lake Operating Total 10,350 11,646 (1,296) 11,646 12,000 (354) 18,900 12,000 - 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 - 396,400 62,600 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch B Page 12 of 22 FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 FY19 Amended Budget Actual (Over) Under Budget to date FY20 Amended Budget Actual (Over) Under Budget to date FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY FERC 924 & 925 - Insurance Premiums Insurance Premiums Bradley Lake Operating Administrative Costs 600,834 599,218 1,616 575,000 613,782 (38,782) 692,019 850,000 516,444 1,366,444 - 1,366,444 AEA 674,425 Administrative Costs 56,000 18,422 37,578 56,000 39,347 16,653 56,000 16,000 16,000 16,000 HEA (40,000) Bradley Lake Operating Total 656,834 617,640 39,194 631,000 653,129 (22,129) 748,019 866,000 516,444 1,382,444 - 1,382,444 634,425 Risk Management Bradley Lake Operating Administrative Costs - - - - - - - 25,000 25,000 25,000 CEA 25,000 - - - Bradley Lake Operating Total - - - - - - - 25,000 - 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 - 1,407,444 659,425 FERC 928 - Regulatory Commission Expenses FERC Admin Fees Administrative Costs 185,000 101,775 83,225 185,000 169,976 15,024 175,000 150,000 150,000 150,000 AEA (25,000) Bradley Lake Operating Total 185,000 101,775 83,225 185,000 169,976 15,024 175,000 150,000 - 150,000 - 150,000 (25,000) FERC Related Prof Services FERC Part 12 Inspection Administrative Costs - - - - - - 75,000 25,000 25,000 25,000 AEA (50,000) Contractual Engineer-FERC license issues Administrative Costs 125,000 104,560 20,440 100,000 88,256 11,744 110,000 180,000 180,000 180,000 AEA 70,000 Bradley Lake Operating Total 125,000 - 125,000 100,000 88,256 11,744 185,000 205,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 - 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 - 6,464,352 835,650 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch B Page 13 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Monthly Utility Contributions Schedule C FY2019 FY2020 FY2021 FY2022 FY2022 FY2022 FY2022 FY2022 FY2021 to Percent Amended Amended Amended Amend 1 Proposed Amend 2 Proposed Amend 3 FY2022 Power Purchaser Share Budget Budget Budget Budget Changes Budget Changes Budget Change Chugach Electric (combined w ML&P)56.3%10,701,072 11,026,056 9,235,126 5,941,748 348,909 6,290,657 - 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 - 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 - 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 - 1,888,315 (883,863) City of Seward 1.0%190,068 195,840 164,035 105,537 6,198 111,735 - 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 - 11,173,459 (5,229,962) Percent FY2019 FY2020 FY2021 FY2022 FY2022 FY2022 FY2022 FY2022 Power Purchaser Share Monthly Monthly Monthly Monthly Proposed Amend 2 Proposed Amend 3 Changes Budget Changes Budget Chugach Electric (combined w ML&P)56.3%891,756 918,838 900,902 495,146 29,076 524,221 0 524,221 (376,681) Homer Electric 12.0%190,072 195,845 192,021 105,537 6,197 111,735 0 111,735 (80,287) Matanuska Electric 13.8%218,583 225,222 220,826 121,368 7,127 128,495 0 128,495 (92,331) Golden Valley Electric 16.9%267,685 275,815 270,431 148,632 8,728 157,360 0 157,360 (113,071) City of Seward 1.0%15,839 16,320 16,002 8,795 516 9,311 0 9,311 (6,690) - 100.0%1,583,935 1,632,040 1,600,181 879,477 51,644 931,122 - 931,122 (669,060) 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch C Page 14 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT R&C Fund Disbursements and Repayments Schedule D Actual ACTUAL Actual ACTUAL PROJECTED PROJECTED PROJECTED PROJECTED TO REPAY TO REPAY TO REPAY TO REPAY Description Disburse at 06/30/19 Disburse at 06/30/20 Disburse at 06/30/21 Disburse at 06/30/22 R&C FUND PROJECTS Governor 0.00 4,052,070.14 0.00 4,052,070.14 0.00 4,052,070.14 0.00 4,052,070.14 Replace RFLS 0.00 251,092.69 0.00 251,092.69 0.00 251,092.69 0.00 251,092.69 Replace Runners 0.00 1,946,732.79 0.00 1,946,732.79 0.00 1,946,732.79 0.00 1,946,732.79 Replace 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.94 Replace power system stabilizer 0.00 619,205.10 0.00 619,205.10 0.00 619,205.10 0.00 619,205.10 Replace 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 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsx Sch D Page 15 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Battle Creek Capital Purchases (not funded by R&C Fund) Schedule E FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 Amended Amend 1 Proposed Amend 2 Proposed Amend 3 Actuals Actuals Budget Budget Changes Budget Changes Budget Comments for FY22: Battle Creek Diversion 149,941 822,327 320,000 - Battle Creek Associated Costs 15,000 - 15,000 - 15,000 Small general parts for repairs Vent Enlargment 50,000 - 50,000 - 50,000 Pressure Sensor w SCADA 25,000 - 25,000 - 25,000 Power feed to LBC Bridge 25,000 - 25,000 - 25,000 Total Non R&C Capital Purchases 149,941 822,327 320,000 115,000 - 115,000 - 115,000 Capital Construction Project Description 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch E Page 16 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Battle Creek Operations & Maintenance Budget Schedule F HEA 262,438 319,073 (56,635) 268,524 332,875 (64,351) 92,569 - - - - - (92,569) CEA - - - - - - - - - - - - - AEA 191,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 FY20 Amended Budget Actual (Over) Under Budget FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) from PY Summary by cost type - - Administrative Costs 453,988 527,724 (73,736) 395,424 580,606 (185,182) 255,469 82,900 - 82,900 - 82,900 (172,569) Battle Creek O&M - Bradley Allocation - - - - - - 181,245 190,710 - 190,710 - 190,710 9,465 Battle Creek O&M 111,000 126,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 - 399,610 (148,104) Bradley Lake O&M 4% charge to Battle Creek - Battle Creek O&M - - - - - - 181,245 190,710 - 190,710 - 190,710 BL 9,465 FERC 537 - Hydraulic Expenses Hydraulic Expenses Battle Creek Operating Labor & Benefits - - - - - - - - - - - Indirect Costs - - - - - - - - - - - Travel - - - - - - - - - - - Training - - - - - - - - - - - Contractual - - - - - - 66,000 81,000 81,000 81,000 AEA 15,000 Supplies & Materials - - - - - - - - - Equipment, Furniture and Machinery - - - - - - - - - - - Bradley Lake Operating Total - - - - - - 66,000 81,000 - 81,000 - 81,000 15,000 FERC 537 - Hydraulic Expenses Total - - - - - - 66,000 81,000 - 81,000 - 81,000 15,000 - - FERC 556 - System Control & Load Dispatching Streamgaging Expenses Battle Creek Operating Labor & Benefits - - - - - - - - - - - Indirect Costs - - - - - - - - - - - Travel - - - - - - - - - - - Training - - - - - - - - - - - Contractual - - - - - - 45,000 45,000 45,000 45,000 AEA - Supplies & Materials - - - - - - - - - - - Equipment, Furniture and Machinery - - - - - - - - - - - - - Bradley Lake Operating Total - - - - - - 45,000 45,000 - 45,000 - 45,000 - FERC 556 - System Control & Load Dispatching Total - - - - - - 45,000 45,000 - 45,000 - 45,000 - FY20 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch F Page 17 of 22 FY19 FY21 FY22 FY19 Amended Budget Actual (Over) Under Budget FY20 Amended Budget Actual (Over) Under Budget FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) from PY FY20 - - FERC 920 & 930 - Administrative Expense Battle Creek Admin Fees Administrative Costs 8,193 7,421 772 12,274 12,274 0 11,419 - - - HEA (11,419) Administrative Costs 168,000 168,000 - 105,000 105,051 (51) 122,000 71,000 71,000 71,000 AEA (51,000) Battle Creek Admin Fees Total 176,193 175,421 772 117,274 117,325 (51) 133,419 71,000 - 71,000 - 71,000 (62,419) Operating Committee Exp-Owners Representative Administrative Costs 254,245 311,652 (57,407) 256,250 320,601 (64,351) 81,150 - - - HEA (81,150) Operating Committee Exp-Owners Representative Total 254,245 311,652 (57,407) 256,250 320,601 (64,351) 81,150 - - - - - (81,150) - Operating Committee Exp-Legal - Administrative Costs 15,000 34,795 (19,795) 15,000 135,880 (120,880) 30,000 5,000 5,000 5,000 AEA (25,000) Operating Committee Exp-Legal Total 15,000 34,795 (19,795) 15,000 135,880 (120,880) 30,000 5,000 - 5,000 - 5,000 (25,000) - Operat Committee Exp-Arbitrage - Administrative Costs 2,000 1,690 310 2,000 1,690 310 2,000 2,000 2,000 2,000 AEA - Operat Committee Exp-Arbitrage Total 2,000 1,690 310 2,000 1,690 310 2,000 2,000 - 2,000 - 2,000 - Trust & Account Fees Administrative Costs 6,550 4,083 2,467 4,800 5,000 (200) 8,800 4,800 4,800 4,800 AEA (4,000) Trust & Account Fees Total 6,550 4,083 2,467 4,800 5,000 (200) 8,800 4,800 - 4,800 - 4,800 (4,000) Operating Committee Exp-Other Administrative Costs - 83 (83) 100 110 (10) 100 100 100 100 AEA - Operating Committee Exp-Other Total - 83 (83) 100 110 (10) 100 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 - 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 - 399,610 (148,104) 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch F Page 18 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Battle Creek Monthly Participating Purchaser Contributions Schedule G FY2019 FY2020 FY2021 FY2022 FY2022 FY2022 FY2022 FY2022 FY2021 to Percent Amended Amended Amended Amend 1 Proposed Amend 2 Proposed Amend 3 FY2022 POWER PURCHASER Share Budget Budget Budget Budget Changes Budget Changes Budget Change Chugach Electric Association 39.38%519,711 1,008,930 2,367,938 1,403,682 - 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,477,109 (1,014,698) Matanuska Electric Association 17.88%235,968 458,092 1,075,133 637,324 - 637,324 - 637,324 (437,809) City of Seward 1.30%17,157 33,306 78,169 46,338 - 46,338 - 46,338 (31,831) Rounding - 100.00%1,319,734 2,562,036 6,013,047 3,564,453 - 3,564,453 - 3,564,453 (2,448,594) FY2021 FY2022 FY2022 FY2022 FY2022 FY2022 FY2021 to Percent FY2019 FY2020 Amended Draft Proposed Amend 1 Proposed Amend 3 FY2022 POWER PURCHASER Share Monthly Monthly Budget Budget Changes Budget Changes Budget Change Chugach Electric Association 39.38%43,309 86,867 220,385 116,974 - 116,974 - 116,974 (103,412) Homer Electric Association 41.44%45,575 91,411 231,913 123,092 - 123,092 - 123,092 (108,821) Matanuska Electric Association 17.88%19,664 39,441 100,063 53,110 - 53,110 - 53,110 (46,953) City of Seward 1.30%1,430 2,868 7,275 3,862 - 3,862 - 3,862 (3,414) - - 100.0%109,978 220,587 559,636 297,038 - 297,038 - 297,038 (262,598) 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch G Page 19 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT SSQ Line Capital Purchases (not funded by R&C Fund) Schedule H FY19 FY20 FY21 FY22 FY22 FY22 FY22 FY22 Amended Amend 1 Proposed Amend 2 Proposed Amend 3 Actuals Actuals Budget Budget Changes Budget Changes Budget Comments for FY22: SQ Line Access Documentation 150,000 - - - - - SQ Line Acquisition Costs 40,000 - - - - - SQ Soldotna-Qtz Ck 230kV Construction 750,000 750,000 Design & Permitting ($2.9M over 2 calendar years) Total Non R&C Capital Purchases - - 190,000 - - - 750,000 750,000 Capital Project Description 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch H Page 20 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT SSQ Line Operations and Maintenance Budget Schedule I HEA 150,000 300,523 - 300,523 - 300,523 150,523 CEA - - - - - - - AEA 20,000 144,000 - 144,000 - 144,000 124,000 170,000 444,523 - 444,523 - 444,523 274,523 - - - FY21 FY22 FY21 Amended Budget FY22 Amend 1 Budget FY22 Proposed Changes FY22 Amend 2 Budget FY22 Proposed Changes FY22 Amend 3 Budget Increase (Decrease) From PY Summary by cost type Labor & Benefits 32,500 85,820 - 85,820 - 85,820 53,320 Indirect Costs - - - - - - - Travel - - - - - - - Training - - - - - - - Contractual 110,000 250,000 - 250,000 - 250,000 140,000 Supplies & Materials 7,500 56,992 - 56,992 - 56,992 49,492 Other Costs - 7,711 - 7,711 - 7,711 7,711 Equipment, Furniture and Machinery - - - - - - - Maintenance Projects - - - - - - - Administrative Costs 20,000 44,000 - 44,000 - 44,000 24,000 170,000 444,523 - 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 - 85,820 HEA 53,320 Travel - - - - - - - Contractual 110,000 150,000 - 150,000 - 150,000 HEA 40,000 Contractual - 100,000 - 100,000 - 100,000 AEA 100,000 Supplies & Materials 7,500 56,992 - 56,992 - 56,992 HEA 49,492 Other Costs - 7,711 - 7,711 - 7,711 HEA 7,711 SQ Line Total 150,000 400,523 - 400,523 - 400,523 250,523 FERC 571 - Maintenance of Overhead Lines Total 150,000 400,523 - 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 42,000 AEA 22,000 Bradley Lake Operating Total 20,000 42,000 - 42,000 - 42,000 22,000 SSQ Line Trust & Account Fees SQ Line Administrative Costs - 2,000 2,000 2,000 AEA 2,000 SQ Line Total - 2,000 - 2,000 - 2,000 2,000 - FERC 920 & 930 - Administrative Expense Total 20,000 44,000 - 44,000 - 44,000 24,000 Total Bradley Lake Budget 170,000 444,523 - 444,523 - 444,523 274,523 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch I Page 21 of 22 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT SSQ Line Monthly Utility Contributions Schedule J FY2021 FY2022 FY2022 FY2022 FY2022 FY2022 FY2021 to Percent Amended Amend 1 Proposed Amend 2 Proposed Amend 3 FY2022 Power Purchaser Share Budget Budget Changes Budget Changes Budget Change Chugach Electric (combined w ML&P)56.3%202,680 281,178 - 281,178 422,250 703,428 78,498 Homer Electric 12.0%43,200 59,931 - 59,931 90,000 149,931 16,731 Matanuska Electric 13.8%49,680 68,921 - 68,921 103,500 172,421 19,241 Golden Valley Electric 16.9%60,840 84,403 - 84,403 126,750 211,153 23,563 City of Seward 1.0%3,600 4,994 - 4,994 7,500 12,494 1,394 Rounding - 100.0%360,000 499,427 - 499,427 750,000 1,249,427 139,427 FY2022 FY2022 FY2022 FY2022 Power Purchaser Percent FY2021 FY2022 Proposed Amend 2 Proposed Amend 3 Share Monthly Monthly Changes Budget Changes Budget Chugach Electric (combined w ML&P)56.3%16,890 23,431 0 23,432 35,187 58,619 6,541 Homer Electric 12.0%3,600 4,994 (0) 4,994 7,500 12,494 1,394 Matanuska Electric 13.8%4,140 5,743 0 5,743 8,625 14,368 1,603 Golden Valley Electric 16.9%5,070 7,034 (0) 7,034 10,563 17,596 1,964 City of Seward 1.0%300 416 (0) 416 625 1,041 116 - 100.0%30,000 41,619 0 41,619 62,500 104,119 11,619 9/13/20218:03 AM2022-BradleyBudget-Proposed Budget Amend 3.xlsxSch J Page 22 of 22 Bradley Lake Operator Report Page 1 Bradley Lake Operator Report BPMC October 1, 2021 Unit Statistics: Generation Unit 1 (MWhrs) Unit 2 (MWhrs) Total (MWhrs) August 2021 September 2021* 21,990 14,245 17,405 10,399 39,218 24,529 Hydraulics Avg. Lake Level (ft.) Usage (ac ft.) Fish water (CFS) August 2021 September 2021* 1141 1147 39,449 28,245 174 AVG 185 AVG Battle Creek Inflows to Bradley Fish Water August 2021 September 2021* 8476 ACF 4,031 ACF 17.3 AVG 18.4 AVG *As of September 20, 2021 Lake Level – 1146.1’ as of September 27, 2021 Activities 1) New building –The architect is working on the final design. We are working toward bidding the project this winter. 2) Bridges –we need to fix the railings and do some final clean up. Parts have arrived on site. 3) Fire system – We have ordered the Pressure controlling valve replacement (PCV). We have a new relief valve on site. A system inspection is planned for October. 4) Battle Creek – last year (July 22 to Oct 17) we had 24,182 ACRE-FT at Battle Creek. In August we passed that and are currently at 32,503 ACRE-FT for this year. Bradley Lake Operator Report Page 2 5) Water Allocation Sheet – we have discovered an error in the way Battle Creek numbers were being reported and logged. We have cleaned up and corrected the process. Revised water tracking sheets have been issued. 6) GIS Inspection – ABB postponed the 10-year inspection on the Bradley SF6 GIS to November 8th through the 19th. 7) New Hire – We are currently looking to hire a full Operator for Bradley, so far, the applicants have not met our requirements. 8) Battle Creek Fish Survey – We have set up a solar, wind generator and battery system to supply power to the ADF&G Battle Creek sonar system. It has been operations for about two weeks 9) D Hittle Report – D Hittle was on site to complete the 25 year look ahead report, they competed a list for “required project work”. 10) Gate Testing – September 26 we preformed Power Tunnel Gate testing, there were some issues during the test, the batteries on the diesel hydraulic pump need replacing and the control switch that closes the gates does not do so, the switch trips both units, however the DCS can close the gates. We are correcting the switch issue. Bradley Lake Operator Report Page 3 NUKA Glacier fly over August 30, 2021 Bradley Lake Operator Report Page 4 Battle Creek Diversion on Friday September 24 Bradley Lake Operator Report Page 5 Bradley Lake the morning of September 26 Bradley O&D Report to the BPMC Friday October 10, 2021 1. Report from the Bradley O&D Committee Meeting September 17, 2021. 2. Present: Pete Sarauer (GVEA); Russell Thornton (CEA); Andy Patrick (HEA); Bob Day (HEA); Josh Crowell (MEA; Lance Roberts (GVEA); Bryan Carey (AEA); David Lockard (AEA); Lance McKimson (MEA) 3. Bradley O&D meeting was held at the AEA and via teleconference. 4. BPMC request, On September 10, 2021 Kirk Gibson requested the O&D Committee provide information on the term and amount of expenditures expected from the R&R report, D. Hittle report to establish bonding for the work. Bob Day provided an update on working with D. Hittle to establish the needed term and amount to provide the BPMC. The information was received and reviewed by the Bradley O&D and was sent 9/22/2021 in response. 5. Bradley O&D discussed a wide range of topics including: a. Battle Creek Bridge Project - Guard rail material received, and contractor should be out to the project to complete the project. 99% complete. b. SVC POD Tuning - SVC’s have been updated with the new settings from the Oscillation report and tested to confirm operation. Testing confirmed issue with Dave’s Creek SVC first reported in an oscillation analysis by EPS two years ago. ABB has documented the issue and is formulating a resolution. POD has been disabled on the SVC pending resolution. c. Dixon - A week ago USGS was at diversion measured approximately 300cfs, 600 acft/ day, approximately 4x the flow at Battle Creek 151 acft that day. They could not install a water gauge. They will attempt to install on later this season. d. Battle Creek Flow Measurement – Backup flow measurement to be installed in the forebay. Dowl is work on an orifice to be installed MIF pipe. Should be installed in the October time frame. 6. ASSIGNMENTS – a. HEA will get budget and SCOPE for implementing the Oscillation Study Results. i. HEA received 3 responses EPS, Power, & TC&E. Evaluation of the proposals and award is next. b. CEA, investigate modifications to BDS to automate HEA Wheeling of power to Bradley participants. i. No update c. CEA, Audit of participant Bradley Usage for BPMC i. No update d. HEA, BPMC assignment work with DOWL to resolve flow meter issue. i. Specification received from Dowl. Construction can proceed. e. CEA Provide motion details to the budget subcommittee on SQ line design. i. Complete f. New Assignment, HEA, investigate options to automate Battle Creek measurements and ICCP reporting. Bradley Lake Budget to Actual Expense Report 07/01/2020 to 06/30/2021 Page 1 of 11 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Schedule A-1 Expenses for the period 07/01/20 to 06/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 - - - 141,368 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 10,375 Emerson Cybersecurity Update - 137,000 138,555 SQ Line Access Documentation 150,000 3,127 SQ Line Acquisition Costs 40,000 46,029 Total Non R&C Capital Purchases 37,738 283,425 652,000 540,500 CAPITAL PURCHASES NOT FUNDED BY R&C FUND Page 2 of 11 ALASKA ENERGY AUTHORITY BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 06/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 - 06/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Summary by expense type Labor & Benefits 1,445,789 1,445,789 1,027,927 29,810 212 1,057,949 387,840 1,219,936 1,011,432 Travel 44,950 44,950 647 53 1,029 1,729 43,221 45,950 10,512 Training 49,300 49,300 23,044 - - 23,044 26,256 49,300 14,875 Contractual 954,340 954,340 411,946 - 266,440 678,386 275,954 869,842 655,575 Contractual - Design Services 59,000 59,000 - - - - 59,000 - - Consulting-Administrative 2,500 2,500 - - 3,095 3,095 (595) - - Supplies & Materials 396,845 396,845 184,345 209 - 184,554 212,291 346,345 262,370 Other Costs 70,818 70,818 34,823 26,732 1,550 63,105 7,713 67,818 65,648 Equipment, Furniture and Machinery 170,000 170,000 43,206 - - 43,206 126,794 176,000 127,535 Maintenance Projects - - - - - - - - 313 Administrative Costs 1,274,574 1,274,574 34,012 - 1,213,870 1,247,882 26,692 1,192,464 1,373,624 Indirect Costs 1,330,587 1,330,587 1,295,342 - - 1,295,342 35,245 1,383,388 1,251,242 5,798,703 5,798,703 3,055,293 56,804 1,486,195 4,598,292 1,200,411 5,351,043 4,773,126 FERC 535 - Operation Supervision & Engineering Operations Sup/Eng Bradley Lake Operating Labor & Benefits 107,453 107,453 90,114 - - 90,114 17,339 107,453 89,713 Travel 10,450 10,450 408 - - 408 10,042 10,450 246 Training 9,300 9,300 2,076 - - 2,076 7,224 9,300 991 Contractual 11,000 11,000 - - - - 11,000 1,000 173 Supplies & Materials 4,000 4,000 2,767 - - 2,767 1,233 4,000 3,698 Administrative Costs - - - - (8,846) (8,846) 8,846 - - Indirect Costs 155,698 155,698 125,787 - - 125,787 29,911 155,698 128,545 Bradley Lake Operating Total 297,901 297,901 221,153 - (8,846) 212,307 85,594 287,901 223,366 FERC 535 - Operation Supervision & Engineering Total 297,901 297,901 221,153 - (8,846) 212,307 85,594 287,901 223,366 FERC 537 - Hydraulic Expenses Hydraulic Expenses Bradley Lake Operating Labor & Benefits 84,192 84,192 71,311 - - 71,311 12,881 84,081 67,694 Travel 10,000 10,000 129 - - 129 9,871 10,000 - Contractual (37,000) (37,000) 32,071 - - 32,071 (69,071) 22,000 - Contractual - Design Services 59,000 59,000 - - - - 59,000 - - Supplies & Materials 59,000 59,000 2,297 - - 2,297 56,703 19,000 9,806 Equipment, Furniture and Machinery 32,000 32,000 - - - - 32,000 81,000 13,368 Administrative Costs - - - - (8,119) (8,119) 8,119 - - Indirect Costs 114,320 114,320 97,168 - - 97,168 17,152 107,519 98,886 Bradley Lake Operating Total 321,512 321,512 202,975 - (8,119) 194,856 126,656 323,600 189,754 Bradley Battle Creek Diversion Bradley Battle Creek Diversion Total - - - - - - - - - FERC 537 - Hydraulic Expenses Total 321,512 321,512 202,975 - (8,119) 194,856 126,656 323,600 189,754 FERC 538 - Electric Expenses Electric Expenses Bradley Lake Operating Labor & Benefits 218,044 218,044 234,061 - - 234,061 (16,017) 208,745 210,745 Travel 7,000 7,000 110 - - 110 6,890 7,000 3,140 Training 25,000 25,000 20,968 - - 20,968 4,032 25,000 13,884 Contractual 2,000 2,000 - - - - 2,000 7,000 2,587 Supplies & Materials 41,732 41,732 23,744 - - 23,744 17,988 50,732 14,111 Other Costs 5,000 5,000 2,102 - - 2,102 2,898 - - Equipment, Furniture and Machinery 73,000 73,000 30,979 - - 30,979 42,022 63,000 91,512 Administrative Costs - - - - (23,312) (23,312) 23,312 - - Indirect Costs 262,004 262,004 270,826 - - 270,826 (8,822) 242,067 257,551 Bradley Lake Operating Total 633,780 633,780 582,789 - (23,312) 559,477 74,303 603,544 593,531 FERC 538 - Electric Expenses Total 633,780 633,780 582,789 - (23,312) 559,477 74,303 603,544 593,531 FERC 539 - Misc. Hydraulic Power Generation Expenses Misc Hydro Power Exp Bradley Lake Operating Labor & Benefits 105,047 105,047 70,287 - - 70,287 34,760 104,936 70,195 Training 15,000 15,000 - - - - 15,000 15,000 - Contractual 287,525 287,525 200,971 - - 200,971 86,554 287,525 185,822 Supplies & Materials 17,900 17,900 26,564 - - 26,564 (8,664) 17,900 31,569 Other Costs 65,468 65,468 - - - - 65,468 - - Administrative Costs - - - - (18,122) (18,122) 18,122 - - Indirect Costs 114,320 114,320 95,770 - - 95,770 18,550 107,519 98,544 Bradley Lake Operating Total 605,260 605,260 393,592 - (18,122) 375,471 229,789 532,880 386,130 BRADLEY CIRCUITS/RADIO TO BERNICE LK Other Costs - - 32,721 - - 32,721 (32,721) 35,695 35,696 BRADLEY CIRCUITS/RADIO TO BERNICE LK Total - - 32,721 - - 32,721 (32,721) 35,695 35,696 BRADLEY CIRCUITS BERNICE LK TO ANCH Other Costs - - - 26,732 - 26,732 (26,732) 29,773 29,194 BRADLEY CIRCUITS BERNICE LK TO ANCH Total - - - 26,732 - 26,732 (26,732) 29,773 29,194 FERC 539 - Misc. Hydraulic Power Generation Expenses Total 605,260 605,260 426,314 26,732 (18,122) 434,924 170,336 598,348 451,020 FERC 541 - Maintenance Supervision & Engineering Maint Supervision/Eng H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\06 2021\06 2021 - FY21 Budget to Actuals - Bradley.xlsx 3 of 11 9/15/2021 ALASKA ENERGY AUTHORITY BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 06/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 - 06/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Bradley Lake Operating Labor & Benefits 270,154 270,154 88,901 - - 88,901 181,253 114,456 84,904 Administrative Costs - - - - (8,603) (8,603) 8,603 - - Indirect Costs - - 126,172 - - 126,172 (126,172) 155,698 121,096 Bradley Lake Operating Total 270,154 270,154 215,073 - (8,603) 206,470 63,684 270,154 206,000 FERC 541 - Maintenance Supervision & Engineering Total 270,154 270,154 215,073 - (8,603) 206,470 63,684 270,154 206,000 FERC 542 - Maintenance of Structures Maintenance of Structures Bradley Lake Operating Labor & Benefits 77,639 77,639 71,573 - - 71,573 6,066 76,499 62,612 Contractual 59,000 59,000 2,010 - - 2,010 56,990 91,000 3,682 Supplies & Materials 100,713 100,713 36,182 - - 36,182 64,531 88,713 39,489 Equipment, Furniture and Machinery 52,000 52,000 12,227 - - 12,227 39,773 32,000 22,552 Administrative Costs - - - - (8,707) (8,707) 8,707 - - Indirect Costs 105,421 105,421 95,689 - - 95,689 9,732 97,823 91,244 Bradley Lake Operating Total 394,773 394,773 217,682 - (8,707) 208,975 185,798 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 394,773 217,682 - (8,707) 208,975 185,798 386,035 219,579 FERC 543 - Maintenance of Reservoirs, Dams & Waterways Maint Res, Dams, WWays Bradley Lake Operating Labor & Benefits 40,744 40,744 217 - - 217 40,527 45,080 1,335 Travel 5,000 5,000 - - - - 5,000 - - Contractual 21,500 21,500 - - - - 21,500 6,500 - Supplies & Materials 15,000 15,000 - - - - 15,000 - - Administrative Costs - - - - (22) (22) 22 - - Indirect Costs 56,689 56,689 336 - - 336 56,353 56,322 1,693 Bradley Lake Operating Total 138,933 138,933 553 - (22) 531 138,402 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 Total 138,933 138,933 553 - (22) 531 138,402 122,902 3,027 FERC 544 - Maintenance of Electric Plant Maintenance of Elec Plant Bradley Lake Operating Labor & Benefits 309,110 309,110 298,880 - - 298,880 10,230 273,620 249,706 Travel 4,500 4,500 - - - - 4,500 4,500 - Contractual 86,000 86,000 18,639 - - 18,639 67,361 49,000 19,661 Supplies & Materials 38,000 38,000 25,336 - - 25,336 12,664 70,000 66,370 Administrative Costs - - - - (29,436) (29,436) 29,436 - - Indirect Costs 423,178 423,178 393,039 - - 393,039 30,139 368,424 362,402 Bradley Lake Operating Total 860,788 860,788 735,894 - (29,436) 706,458 154,330 765,544 698,139 FERC 544 - Maintenance of Electric Plant Total 860,788 860,788 735,894 - (29,436) 706,458 154,330 765,544 698,139 FERC 545 - Maintenance of Misc. Hydraulic Plant Maint of Misc Hydr Plant Bradley Lake Operating Labor & Benefits 69,297 69,297 67,198 - - 67,198 2,099 69,395 62,843 Contractual 3,900 3,900 2,447 - - 2,447 1,453 3,900 6,763 Supplies & Materials 58,000 58,000 66,128 - - 66,128 (8,128) 63,000 93,510 Maintenance Projects - - - - - - - - 313 Administrative Costs - - - - (9,053) (9,053) 9,053 - - Indirect Costs 98,957 98,957 90,555 - - 90,555 8,403 92,318 91,280 Bradley Lake Operating Total 230,154 230,154 226,328 - (9,053) 217,275 12,879 228,613 254,710 FERC 545 - Maintenance of Misc. Hydraulic Plant Total 230,154 230,154 226,328 - (9,053) 217,275 12,879 228,613 254,710 FERC 556 - System Control & Load Dispatching System Cntl & Load Disp Bradley Lake Operating Labor & Benefits 21,140 21,140 14,101 - - 14,101 7,039 21,140 37,091 Contractual 53,000 53,000 4,703 - - 4,703 48,297 53,000 57,365 Supplies & Materials 6,000 6,000 813 - - 813 5,187 6,000 3,204 Administrative Costs - - - - (785) (785) 785 - - Bradley Lake Operating Total 80,140 80,140 19,617 - (785) 18,832 61,308 80,140 97,661 Bradley Battle Creek Diversion Bradley Battle Creek Diversion Total - - - - - - - - - Snow Measurement Bradley Lake Operating Contractual 10,000 10,000 - - 10,000 10,000 - 10,000 10,000 Administrative Costs - - - - (400) (400) 400 - - Bradley Lake Operating Total 10,000 10,000 - - 9,600 9,600 400 10,000 10,000 Seismic Service Bradley Lake Operating Contractual 62,000 62,000 - - 59,801 59,801 2,199 62,000 56,310 H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\06 2021\06 2021 - FY21 Budget to Actuals - Bradley.xlsx 4 of 11 9/15/2021 ALASKA ENERGY AUTHORITY BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 06/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 - 06/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Administrative Costs - - - - (2,392) (2,392) 2,392 - - Bradley Lake Operating Total 62,000 62,000 - - 57,409 57,409 4,591 62,000 56,310 Streamguaging Serv Bradley Lake Operating Contractual 183,615 183,615 - - 193,615 193,615 (10,000) 209,917 189,917 Administrative Costs - - - - (7,745) (7,745) 7,745 - - Bradley Lake Operating Total 183,615 183,615 - - 185,870 185,870 (2,255) 209,917 189,917 Permits Bradley Lake Operating Other Costs 350 350 - - 1,550 1,550 (1,200) 350 758 Administrative Costs - - - - (62) (62) 62 - - Bradley Lake Operating Total 350 350 - - 1,488 1,488 (1,138) 350 758 FERC 556 - System Control & Load Dispatching Total 336,105 336,105 19,617 - 253,583 273,199 62,906 362,407 354,646 FERC 562 - Station Expenses Station Expenses Bradley Lake Operating Labor & Benefits 83,010 83,010 19,707 29,810 212 49,729 33,281 87,072 72,086 Travel 4,500 4,500 - 53 - 53 4,447 4,000 2,596 Contractual 1,800 1,800 51,729 - 3,024 54,752 (52,952) 2,000 51,167 Supplies & Materials 44,000 44,000 515 209 - 724 43,276 22,000 613 Other Costs - - - - - - - 2,000 - Equipment, Furniture and Machinery 13,000 13,000 - - - - 13,000 - - Administrative Costs - - - - (4,210) (4,210) 4,210 - - Bradley Lake Operating Total 146,310 146,310 71,950 30,072 (974) 101,048 45,262 117,072 126,462 FERC 562 - Station Expenses Total 146,310 146,310 71,950 30,072 (974) 101,048 45,262 117,072 126,462 Weather Monitoring Power Sup Bradley Lake Operating Contractual - - - - - - - - 5,244 Bradley Lake Operating Total - - - - - - - - 5,244 FERC 571 - Maintenance of Overhead Lines Maint of OH Lines Bradley Lake Operating Labor & Benefits 27,459 27,459 1,577 - - 1,577 25,882 27,459 2,507 Travel - - - - - - - 10,000 4,530 Contractual 100,000 100,000 99,378 - - 99,378 622 50,000 66,883 Supplies & Materials 5,000 5,000 - - - - 5,000 5,000 - Equipment, Furniture and Machinery - - - - - - - - 103 Administrative Costs - - - - (4,038) (4,038) 4,038 - - Bradley Lake Operating Total 132,459 132,459 100,954 - (4,038) 96,916 35,543 92,459 74,024 SSQ Line Operating Labor & Benefits 32,500 32,500 - - - - 32,500 - - Contractual 110,000 110,000 - - - - 110,000 - - Supplies & Materials 7,500 7,500 - - - - 7,500 - - SSQ Line Operating Total 150,000 150,000 - - - - 150,000 - - FERC 571 - Maintenance of Overhead Lines Total 282,459 282,459 100,954 - (4,038) 96,916 185,543 92,459 74,024 FERC 920 & 930 - Administrative Expense AEA Bradley Fixed Admin Fees Bradley Lake Operating Travel 3,500 3,500 - - 1,029 1,029 2,471 - - Consulting-Administrative 2,500 2,500 - - 3,095 3,095 (595) - - Administrative Costs 19,755 19,755 - - 186,492 186,492 (166,737) 200,000 200,000 Bradley Lake Operating Total 25,755 25,755 - - 190,615 190,615 (164,860) 200,000 200,000 Bradley Battle Creek Diversion Bradley Battle Creek Diversion Total - - - - - - - - - Battle Creek Operating Battle Creek Operating Total - - - - - - - - - SSQ Line Operating Administrative Costs 20,000 20,000 - - 10,194 10,194 9,806 - - SSQ Line Operating Total 20,000 20,000 - - 10,194 10,194 9,806 - - SHARED - AEA Bradley Lake Administrative Costs - - - - 76,230 76,230 (76,230) - - SHARED - AEA Bradley Lake Total - - - - 76,230 76,230 (76,230) - - Operating Committee Exp-Audit Bradley Lake Operating Administrative Costs 19,900 19,900 - - 21,120 21,120 (1,220) 19,900 20,298 Bradley Lake Operating Total 19,900 19,900 - - 21,120 21,120 (1,220) 19,900 20,298 Operating Committee Exp-Legal Bradley Lake Operating Administrative Costs 70,000 70,000 - - 60,098 60,098 9,902 30,000 215,162 Bradley Lake Operating Total 70,000 70,000 - - 60,098 60,098 9,902 30,000 215,162 SSQ Line Operating Administrative Costs - - - - 3,316 3,316 (3,316) - - SSQ Line Operating Total - - - - 3,316 3,316 (3,316) - - Operat Committee Exp-Arbitrage Bradley Lake Operating H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\06 2021\06 2021 - FY21 Budget to Actuals - Bradley.xlsx 5 of 11 9/15/2021 ALASKA ENERGY AUTHORITY BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 06/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 - 06/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Administrative Costs 5,000 5,000 - - 2,818 2,818 2,182 3,000 2,685 Bradley Lake Operating Total 5,000 5,000 - - 2,818 2,818 2,182 3,000 2,685 Trust & Account Fees Bradley Lake Operating Administrative Costs 13,000 13,000 - - 11,441 11,441 1,559 11,918 12,118 Bradley Lake Operating Total 13,000 13,000 - - 11,441 11,441 1,559 11,918 12,118 Misc Admin Bradley Lake Operating Administrative Costs 18,900 18,900 12,360 - 5,842 18,202 698 11,646 12,000 Bradley Lake Operating Total 18,900 18,900 12,360 - 5,842 18,202 698 11,646 12,000 FERC 920 & 930 - Administrative Expense Total 172,555 172,555 12,360 - 381,673 394,033 (221,478) 276,464 462,263 FERC 924 & 925 - Insurance Premiums Insurance Premiums Bradley Lake Operating Administrative Costs 748,019 748,019 21,652 - 656,434 678,086 69,933 631,000 653,129 Bradley Lake Operating Total 748,019 748,019 21,652 - 656,434 678,086 69,933 631,000 653,129 SSQ Line Operating Administrative Costs - - - - 56 56 (56) - - SSQ Line Operating Total - - - - 56 56 (56) - - FERC 924 & 925 - Insurance Premiums Total 748,019 748,019 21,652 - 656,490 678,142 69,877 631,000 653,129 FERC 928 - Regulatory Commission Expenses FERC Admin Fees Bradley Lake Operating Administrative Costs 175,000 175,000 - - 156,071 156,071 18,929 185,000 169,976 Bradley Lake Operating Total 175,000 175,000 - - 156,071 156,071 18,929 185,000 169,976 FERC Related Prof Services Bradley Lake Operating Administrative Costs - - - - (6,567) (6,567) 6,567 - - Bradley Lake Operating Total - - - - (6,567) (6,567) 6,567 - - BRADLEY FERC PART 12 INSPECTION Administrative Costs 75,000 75,000 - - 42,396 42,396 32,604 - - BRADLEY FERC PART 12 INSPECTION Total 75,000 75,000 - - 42,396 42,396 32,604 - - BRADLEY CONTRACTUAL ENGINEER-FERC LICENSE ISSUES Administrative Costs 110,000 110,000 - - 121,783 121,783 (11,783) 100,000 88,256 BRADLEY CONTRACTUAL ENGINEER-FERC LICENSE ISSUES Total 110,000 110,000 - - 121,783 121,783 (11,783) 100,000 88,256 FERC 928 - Regulatory Commission Expenses Total 360,000 360,000 - - 313,682 313,682 46,318 285,000 258,232 Total Bradley Lake Budget 5,798,703 5,798,703 3,055,293 56,804 1,486,195 4,598,292 1,200,411 5,351,043 4,773,126 H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\06 2021\06 2021 - FY21 Budget to Actuals - Bradley.xlsx 6 of 11 9/15/2021 BRADLEY LAKE R&C FUND DISBURSEMENTS AND REPAYMENTS SCHEDULE D Expenses for the period 07/01/20 to 06/30/21 Actual Actual Actual Projected @06/30/20 TO REPAY @ 6/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 64,452.15 105,631.24 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,739,590.93 3,739,590.93 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,482,791.23 1,482,791.23 1,500,000.00 0.00 0.00 412,050.13 27,020,557.99 5,286,834.31 32,307,392.30 5,686,000.00 Current Year R&C Repayment (2,121,396.10)(2,209,060.11) Adjust balance to $5 million 0.00 0.00 Interest in Fund Applied to Repayment (175,199.84)(269,487.40) Net Transfer from Revenue Fund (2,296,595.94)(2,478,547.51) Cumulative Prior Years R&C Repayments (23,240,089.01)(25,518,390.50) Due to (from) Utilities 18,294.45 289,585.71 Adjust Due to R&C Actual 0.00 0.00 (23,221,794.56)(25,228,804.79) NET DUE TO R&C FUND 1,502,167.49 4,600,040.00 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,906,857.12) 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.40 Participants Contributions to R&C Fund 2,121,396.10 2,209,060.11 Ending Investment Balance 3,922,231.19 1,069,522.90 Accrued Due to (from) Utilities (18,294.45)(289,585.71) R&C payable back to the revenue fund 0.00 0.00 Accrued R&C vendor Payable at Year End (406,104.23)(379,977.19) 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,321,708.58 2,278,301.49 2,188,961.80 Page 7 of 11 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Battle Creek Capital Purchases Schedule E Expenses for the period 07/01/20 to 06/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 11 ALASKA ENERGY AUTHORITY BATTLE CREEK OPERATIONS & MAINTENANCE SCHEDULE F BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 06/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 - 06/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) - - Contractual 111,000 111,000 - - 82,481 82,481 28,519 - - Administrative Costs 436,714 436,714 83,351 - 293,204 376,555 60,159 395,424 580,606 547,714 547,714 83,351 - 377,859 461,210 86,504 395,424 580,606 FERC 535 - Operation Supervision & Engineering Operations Sup/Eng Battle Creek Operating Administrative Costs - - - - 8,846 8,846 (8,846) - - Battle Creek Operating Total - - - - 8,846 8,846 (8,846) - - FERC 535 - Operation Supervision & Engineering Total - - - - 8,846 8,846 (8,846) - - FERC 537 - Hydraulic Expenses Hydraulic Expenses Bradley Battle Creek Diversion Bradley Battle Creek Diversion Total - - - - - - - - - Battle Creek Operating Contractual 66,000 66,000 - - 37,481 37,481 28,519 - - Administrative Costs - - - - 8,119 8,119 (8,119) - - Battle Creek Operating Total 66,000 66,000 - - 45,600 45,600 20,400 - - FERC 537 - Hydraulic Expenses Total 66,000 66,000 - - 45,600 45,600 20,400 - - FERC 538 - Electric Expenses Electric Expenses Battle Creek Operating Administrative Costs - - - - 23,312 23,312 (23,312) - - Battle Creek Operating Total - - - - 23,312 23,312 (23,312) - - FERC 538 - Electric Expenses Total - - - - 23,312 23,312 (23,312) - - FERC 539 - Misc. Hydraulic Power Generation Expenses Misc Hydro Power Exp Battle Creek Operating Administrative Costs - - - - 18,122 18,122 (18,122) - - Battle Creek Operating Total - - - - 18,122 18,122 (18,122) - - FERC 539 - Misc. Hydraulic Power Generation Expenses Total - - - - 18,122 18,122 (18,122) - - FERC 541 - Maintenance Supervision & Engineering Maint Supervision/Eng Battle Creek Operating Administrative Costs - - - - 8,603 8,603 (8,603) - - Battle Creek Operating Total - - - - 8,603 8,603 (8,603) - - FERC 541 - Maintenance Supervision & Engineering Total - - - - 8,603 8,603 (8,603) - - FERC 542 - Maintenance of Structures Maintenance of Structures Battle Creek Operating Administrative Costs - - - - 8,707 8,707 (8,707) - - Battle Creek Operating Total - - - - 8,707 8,707 (8,707) - - FERC 542 - Maintenance of Structures Total - - - - 8,707 8,707 (8,707) - - FERC 543 - Maintenance of Reservoirs, Dams & Waterways Maint Res, Dams, WWays Battle Creek Operating Administrative Costs - - - - 22 22 (22) - - Battle Creek Operating Total - - - - 22 22 (22) - - FERC 543 - Maintenance of Reservoirs, Dams & Waterways Total - - - - 22 22 (22) - - FERC 544 - Maintenance of Electric Plant Maintenance of Elec Plant Battle Creek Operating Administrative Costs - - - - 29,436 29,436 (29,436) - - Battle Creek Operating Total - - - - 29,436 29,436 (29,436) - - FERC 544 - Maintenance of Electric Plant Total - - - - 29,436 29,436 (29,436) - - FERC 545 - Maintenance of Misc. Hydraulic Plant Maint of Misc Hydr Plant Battle Creek Operating Administrative Costs - - - - 9,053 9,053 (9,053) - - Battle Creek Operating Total - - - - 9,053 9,053 (9,053) - - FERC 545 - Maintenance of Misc. Hydraulic Plant Total - - - - 9,053 9,053 (9,053) - - FERC 556 - System Control & Load Dispatching System Cntl & Load Disp Bradley Battle Creek Diversion Bradley Battle Creek Diversion Total - - - - - - - - - Battle Creek Operating Administrative Costs - - - - 785 785 (785) - - Battle Creek Operating Total - - - - 785 785 (785) - - Snow Measurement Battle Creek Operating Administrative Costs - - - - 400 400 (400) - - Battle Creek Operating Total - - - - 400 400 (400) - - Seismic Service H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\06 2021\06 2021 - FY21 Budget to Actuals - Bradley.xlsx 9 of 11 9/15/2021 ALASKA ENERGY AUTHORITY BATTLE CREEK OPERATIONS & MAINTENANCE SCHEDULE F BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 06/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 - 06/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Battle Creek Operating Administrative Costs - - - - 2,392 2,392 (2,392) - - Battle Creek Operating Total - - - - 2,392 2,392 (2,392) - - 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 45,000 - - 33,750 33,750 11,250 - - Administrative Costs - - - - 7,745 7,745 (7,745) - - Battle Creek Operating Total 45,000 45,000 - - 41,495 41,495 3,505 - - Permits Battle Creek Operating Administrative Costs - - - - 62 62 (62) - - Battle Creek Operating Total - - - - 62 62 (62) - - FERC 556 - System Control & Load Dispatching Total 45,000 45,000 - - 56,383 56,383 (11,383) - - FERC 562 - Station Expenses Station Expenses Battle Creek Operating Administrative Costs - - - - 4,210 4,210 (4,210) - - Battle Creek Operating Total - - - - 4,210 4,210 (4,210) - - FERC 562 - Station Expenses Total - - - - 4,210 4,210 (4,210) - - FERC 571 - Maintenance of Overhead Lines Maint of OH Lines Battle Creek Operating Administrative Costs - - - - 4,038 4,038 (4,038) - - Battle Creek Operating Total - - - - 4,038 4,038 (4,038) - - FERC 571 - Maintenance of Overhead Lines Total - - - - 4,038 4,038 (4,038) - - 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) - - Administrative Costs 314,664 314,664 1,285 - 54,752 56,037 258,627 - - Battle Creek Operating Total 314,664 314,664 1,285 - 55,326 56,611 258,053 - - SHARED - AEA Battle Creek Administrative Costs - - - - 32,773 32,773 (32,773) - - SHARED - AEA Battle Creek Total - - - - 32,773 32,773 (32,773) - - Operating Committee Exp-Audit Battle Creek Operating Administrative Costs - - - - 880 880 (880) - - Battle Creek Operating Total - - - - 880 880 (880) - - 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 30,000 - - 18,832 18,832 11,168 - - Battle Creek Operating Total 30,000 30,000 - - 18,832 18,832 11,168 - - 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 2,000 - - 1,807 1,807 193 - - Battle Creek Operating Total 2,000 2,000 - - 1,807 1,807 193 - - 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 8,800 - - 8,077 8,077 723 - - Battle Creek Operating Total 8,800 8,800 - - 8,077 8,077 723 - - 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 100 24,103 - 819 24,922 (24,822) - - Battle Creek Operating Total 100 100 24,103 - 2,419 26,522 (26,422) - - Professional consultants Bradley Battle Creek Diversion H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\06 2021\06 2021 - FY21 Budget to Actuals - Bradley.xlsx 10 of 11 9/15/2021 ALASKA ENERGY AUTHORITY BATTLE CREEK OPERATIONS & MAINTENANCE SCHEDULE F BUDGET TO ACTUAL EXPENSES FOR THE PERIOD 07/01/2020 THROUGH 06/30/2021 FY 21 FY 20 FY21 Approved Budget BUDGET % 07/01/2020 - 06/30/2021 HEA Actual CEA Actual AEA Actual Total Actual (Over) Under Budget to Date FY20 Approved Budget FY20 Actual Administrative Costs - - - - - - - 256,250 320,601 Bradley Battle Creek Diversion Total - - - - - - - 256,250 320,601 Battle Creek Operating Administrative Costs 81,150 81,150 57,963 - - 57,963 23,187 - - Battle Creek Operating Total 81,150 81,150 57,963 - - 57,963 23,187 - - FERC 920 & 930 - Administrative Expense Total 436,714 436,714 83,351 - 120,200 203,551 233,163 395,424 580,606 FERC 924 & 925 - Insurance Premiums Insurance Premiums Battle Creek Operating Administrative Costs - - - - 28,256 28,256 (28,256) - - Battle Creek Operating Total - - - - 28,256 28,256 (28,256) - - FERC 924 & 925 - Insurance Premiums Total - - - - 28,256 28,256 (28,256) - - FERC 928 - Regulatory Commission Expenses FERC Admin Fees Battle Creek Operating Administrative Costs - - - - 6,503 6,503 (6,503) - - Battle Creek Operating Total - - - - 6,503 6,503 (6,503) - - FERC Related Prof Services Battle Creek Operating Administrative Costs - - - - 6,567 6,567 (6,567) - - Battle Creek Operating Total - - - - 6,567 6,567 (6,567) - - FERC 928 - Regulatory Commission Expenses Total - - - - 13,070 13,070 (13,070) - - Total Bradley Lake Budget 547,714 547,714 83,351 - 377,859 461,210 86,504 395,424 580,606 H:\Accounting\AEA FY21 FS Shared Files\Bradley Lake\Monthly Reports\06 2021\06 2021 - FY21 Budget to Actuals - Bradley.xlsx 11 of 11 9/15/2021