Loading...
HomeMy WebLinkAboutUAC Packet 05/08/2019 City Council / Utility Advisory CommitteeJoint Meeting City Council Chambers Port Angeles, WA 98362 May 08, 2019 3:00 p.m. AGENDA I.Call To Order II.Roll Call III.Late Items IV.Public Comment–The Utility Advisory Committee desires to allow the opportunity for Public Comment. However, the business of the City must proceed in an orderly, timely manner. At its most restrictive, Public Comment shall be limited to a total of 15 minutes. Individuals may speak for three (3) minutes or less, depending on the number of people wishing to speak. If more than 20 people are signed up to speak, each speaker may be allocated two (2) minutes. (Taken from Council Rules of Procedure Section 12). V.Information Only Items: A.Electric Cost of Service Analysis (COSA)presentation VI.Next UACMeeting Date:May 14, 2019 VII.Adjournment UTILITY ADVISORY COMMITTEE MEMO Date:May 8, 2019 To:Utility Advisory Committee From:Glen Goodworth,Senior Accountant Subject:ElectricCost of Service Analysis (COSA)Presentation Summary:At therequest of the City Council a presentation is being made to strengthen the understanding of the Cost of Service Analysis (COSA)process and to review the 2019 ElectricCOSA model worksheet. This is a joint presentation to City Council and the UAC. Funding:N/A Recommendation:Informational only Background / Analysis:During the 2019 rate setting process the offer was made to present the COSA modelsto the City Council early in 2019so that a greater understanding of the process could be achieved, leading to more informed and involved rate setting. This presentation will review the 2019 ElectricCOSA models. Funding Overview:N/A 2:00 PM 5/1/2019 Glen Goodworth - Senior AccountantGregg King - Power Resources ManagerShailesh Shere - Deputy Dirctor Power SystemsMarySue French - Senior Accountant Building of Model Prepared by: 2019 Budget Basis Electric COSA Model CITY of PORT ANGELES 1 of 35 C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Cover 2:00 PM 5/1/2019 2 of 35 Meet revenue requirementsProvide revenue stability to the utilityBe easy to administerProvide rate stability to the customerBe "just, reasonable, fair and equitable"- "not unduly discriminatory or preferential"Be easy to understandBe competitive/affordableConform to generally accepted rate setting techniquesBe cost based - COSAEncourage Economic Development/Conservation etc. Traditional Rate Setting Principles Financial PrinciplesCustomer RequirementsOther C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Principles 2:00 PM 5/1/2019 -- 800,000800,000200,000200,000600,000200,000200,000 2024 3,016,964 Forecast -- 800,000800,000200,000200,000650,000 2023 (250,000) 1,050,0001,050,0002,416,9641,050,000 Forecast --- 800,000800,000800,000800,000200,000600,000800,000 2022 2,666,964 Forecast -- 800,000800,000200,000 2021 (600,000) 1,400,0001,400,0002,666,9641,200,0001,400,000 Forecast -- 800,000800,000200,000200,000200,000650,000500,000500,000 2020 2,250,0002,250,0003,266,9642,250,000 Forecast (1,450,000) 3 of 35 - 800,000250,000200,000260,000200,000 2019 (260,000) 3,600,000 4,650,000 4,910,000 4,910,000 4,716,964 3,250,000 1,000,000 4,910,000 Forecast Capital Capital Portion Electric Utility 2017 through 2024 -- CITY of PORT ANGELES 900,000900,000173,700 2018 1,073,7001,073,7004,976,964 Revenue & Expenditure Summary Budget -- 20,80020,800 604,200 625,000625,000 2017 Actual 4,803,264 Feeder Tie Hwy 101, Porter to Golf Course Rd Transfers/MiscDifferenceCummulativeUnderground Cable ReplcementConstruct New Light Ops BuildingReplace "A" St and Laurel St Substation SwithchgearCity/PUD Service Area AgreementOverhead ReconductingPole Replacement ProgramCollege Street Substation SwitchgearWashington Street Substation Switchgear"F" Street Transformer"I" Street Substation Switchgear Rate RevenuesLate changeNon-Rate Revenues: From reservesTotal RevenueCapital ProjectTotal Expenditures RevenuesExpenses/ExpendituresProjects C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Capital 2:00 PM 5/1/2019 - - - 20252035202520252035 5,400.00 14,400.0014,400.00 124,307.50210,000.00334,307.50320,000.00334,400.00135,000.00140,400.00129,707.50345,000.00474,707.50320,000.00334,400.00 2,635,000.00 2,635,000.00 20242034202420242034 28,125.0013,400.0028,125.00 132,592.50200,000.00332,592.50305,000.00333,125.00320,000.00200,000.00213,400.00135,000.00145,992.50400,000.00545,992.50305,000.00333,125.00320,000.00 2,845,000.00 2,980,000.00 20232033202320232033 41,175.0021,000.0041,175.00 140,460.00190,000.00330,460.00290,000.00331,175.00625,000.00190,000.00211,000.00335,000.00161,460.00380,000.00541,460.00290,000.00331,175.00625,000.00 3,045,000.00 3,380,000.00 20222032202220222032 53,775.0035,000.0053,775.00 148,102.50185,000.00333,102.50280,000.00333,775.00915,000.00350,000.00385,000.00525,000.00183,102.50535,000.00718,102.50280,000.00333,775.00915,000.00 3,235,000.00 3,760,000.00 20212031202120212031 65,700.0048,600.0065,700.00 155,360.00175,000.00330,360.00265,000.00330,700.00340,000.00388,600.00875,000.00203,960.00515,000.00718,960.00265,000.00330,700.00 3,420,000.00 1,195,000.00 4,295,000.00 1,195,000.00 20202030202020202030 4 of 35 76,537.5061,800.0076,537.50 Total Debt Service 162,392.50170,000.00332,392.50255,000.00331,537.50330,000.00391,800.00224,192.50500,000.00724,192.50255,000.00331,537.50 3,595,000.00 1,460,000.00 1,215,000.00 4,810,000.00 1,460,000.00 Debt Service 2010 Electric Revenue Bonds2015 Electric Revenue Bonds Electric Utility 2014 through 2025 20192029201920192029 CITY of PORT ANGELES 86,950.0071,250.0086,950.00 168,992.50165,000.00333,992.50245,000.00331,950.00315,000.00386,250.00240,242.50480,000.00720,242.50245,000.00331,950.00 3,765,000.001,715,000.001,545,000.005,310,000.001,715,000.00 20182028201820182028 96,937.5080,550.0096,937.50 175,192.50155,000.00330,192.50235,000.00331,937.50310,000.00390,550.00255,742.50465,000.00720,742.50235,000.00331,937.50 3,930,000.001,960,000.001,860,000.005,790,000.001,960,000.00 20172027201720172027 89,700.00 181,192.50150,000.00331,192.50106,500.00225,000.00331,500.00305,000.00394,700.00270,892.50455,000.00725,892.50106,500.00225,000.00331,500.00 4,085,000.002,195,000.002,170,000.006,255,000.002,195,000.00 20162026201620162026 95,500.00 185,542.50145,000.00330,542.50115,637.50215,000.00330,637.50290,000.00385,500.00281,042.50435,000.00716,042.50115,637.50215,000.00330,637.50 4,235,000.002,420,000.002,475,000.006,710,000.002,420,000.00 InterestPrincipalTotalRemainingInterestPrincipalTotalRemainingInterestPrincipalTotalRemainingInterestPrincipalTotalRemainingInterestPrincipalTotalRemaining C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Debt Service 2:00 PM 5/1/2019 7180 7120718071807180718071807180 ----------- 700100 7,500 6,1007,8002,2003,300 (4,700)(7,300) DiffDiff 57,50048,500 (24,700) 500 1,0003,2003,7002,0002,500 11,30049,70031,40015,50024,70097,80011,50080,80082,90010,00018,00015,00055,400 20182018 156,400 330,500 153,800 1,046,800 -------- 3,200 53.55%56.32% 31,200 11,30033,48032,10023,30079,13514,80048,54075,60010,00018,000 106,950 161,300 586,505 OtherOther -------------------- 0.00% 3,7002,5006,200 11.19% DistributionDistribution ----------------------- 0.00%0.00% DemandDemand -------------- 8.30% 4,6551,0002,000 32.49% 11,16042,78032,36090,95515,00018,000 EnergyEnergy -- --------------- 500 0.00% 9,310 38.15% 11,16064,170 417,840 332,700 CustomerCustomer 60%40%85%50%60% 100%100%100%100%100%100%100%100%100%5 of 35 OtherOther PercentPercent 100%100% City of Port Angeles Admin, Professional Services DistributionDistribution 2019 Budget - Electric Utility DemandDemand 5% 20%20%40% 100%100%100% EnergyEnergy 20%60%10%30% 100%100% CustomerCustomer - 500 1,0003,2003,7002,0002,500 11,30055,80032,10023,30093,10014,80080,90075,60010,00018,00015,00055,400 161,300 213,900332,700 20192019 1,095,300 BudgetBudget Administrative Services City CouncilCity ManagerCustomer Com.Human ResourcesClerks OfficeRecordsFinance AdminAccountingCustomer ServiceRepographicsAttorneyPlanningFacility Maintenance Professional Services Power Resource OutreachJanitorial Contract- Lt OpsSecurity ServicesOlympic LaundrySafety Training- REAGenerator Testing- Lt OpsArchaeological ServicesElectric Plan Review C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Admin 2:00 PM 5/1/2019 600.00600.00600.00 1,800.00 Healthcare 48 298.48298.48298.48298.48298.48298.48298.48298.48298.48298.298.48298.48298.48298.48298.48 4,477.20 Other - 4,559.74 12,100.1610,386.9827,046.88 Medical Reimb -------------------- 471.21 4,124.76 1,108.82 2,855.08 8,559.86 Adj for % --------------- Electric 4,124.76 2,356.04 5,544.08 2,855.08 14,879.96 Longevity -- 400.00 (691.26) 3,100.00 8,200.00 2,000.00 3,100.00 Total 76,151.4217,901.5121,184.3586,991.1598,630.3671,910.2527,700.0038,400.0038,27,700.0023,200.00 157,305.74141,568.70122,132.45152,051.35150,621.57152,296.54152,396.13134,515.43132,372.97125,194.20140,002.63132,372.97132,372.97133,233.07140,436.12137,774.04145,799.73124,993.09154,500.00258,900.0 0318,000.00834,000.00 2,949,408.742,950,100.00 - 4.6%1.0%0.2%0.4%3.3%0.0%2.8% 18.5%31.0%38.1% 100.0% (236.75) 5,650.136,215.545,110.253,100.00 20,465.72 27,824.05 24,395.88 37,536.71 47,257.56 23,527.07 40,982.67 38,855.08 43,632.69 43,732.28 37,896.58 35,754.12 24,015.61 43,383.78 35,754.12 35,754.12 21,409.24 38,999.27 41,155.19 44,362.88 40,892.70 27,700.00 38,400.00 Benefits 833,763.25834,000.00 ------------------------- - OT 66,800.00 66,800.00 66,800.00 6 of 35 -- 2019 Budget (454.51) 55,685.7012,251.3814,968.8059,167.1074,234.4894,311.1498,605.3896,618.8596,618.8596,618.8596,618.8596,618.8596,618.8584,100.39 Electric Utility Wages 119,769.03 111,068.68 111,766.49 108,663.85 108,663.85 101,178.59 111,823.83 101,436.85 101,436.85 Staffing Allocation 2,048,845.492,049,300.00 FICAPersWorkers CompLTDSupplemental LifeFMLAIns - Medical/DentalHealth ReimbursementState UnemploymentICMA Matching Funds CITY of PORT ANGELES 20.00%20.00% 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00% Percent Difference 2019 Budget - 3,100.00 Total 76,151.4289,507.5686,991.1598,630.3671,910.2527,700.0038,400.00 105,921.74157,305.74141,568.70122,132.45152,051.35150,621.57152,296.54152,396.13134,515.43132,372.97125,194.20140,002.63132,372.97132,372.97133,233.07140,436.12137,774.04145,799.73124,993.09 3,105,752.18 - 5,110.253,100.00 20,465.72 28,250.66 31,077.72 27,824.05 24,395.88 37,536.71 47,257.56 23,527.07 40,982.67 38,855.08 43,632.69 43,732.28 37,896.58 35,754.12 24,015.61 43,383.78 35,754.12 35,754.12 21,409.24 38,999.27 41,155.19 44,362.88 40,892.70 27,700.00 38,400.00 Benefits 881,225.95 -- - - - - -- - - - - -- - - - - --- - - OT 66,800.0066,800.00 311.14823.83 55,685.7061,256.9074,844.0259,167.1074,234.4894,98,605.3896,618.8596,618.8596,618.8596,618.8596,618.8596,618.8584,100.39 Wages 119,769.03111,068.68111,766.49108,663.85108,663.85101,178.59111,101,436.85101,436.85 2,157,726.23 11111111111111111111111 # 24 Payroll System Employee GUnemploymentWorkers Comp Employee AEmployee BEmployee CEmployee DEmployeeEEmployee FBudgeted OvertimeEmployee HEmployee IEmployee JEmployee KEmployee LEmployee MEmployee NEmployee OEmployee PEmployee QEmployee REmployee SEmployee TEmployee UEmployee VEmployee WFMLA PremiumHealth Reimbursement C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Staffing 2:00 PM 5/1/2019 Difference from Staffing - 2,949,4092,949,409 --- - - - - - - - - - - - - - - - - - - - 5.48% 3,100 53,30617,90221,18427,70038,400 Other 161,592 --------- 71.49% 69,59378,90478,65368,31579,94082,66487,480 116,026 121,641 105,435 137,067 137,157 127,790 125,754 118,934 133,002 125,754 119,136 124,993 2,108,456 Distribution ----------------------------- 0.00% Demand -------- ------------------ 7.47% 78,653 141,569 220,222 Energy ---------- 3,596 6,107 6,726 6,619 6,260 7,000 6,619 15.57% 22,845 17,39819,72630,41045,18615,23015,24013,23753,29355,11058,320 459,139 Customer 70% 100%100%100%100%100%100% Other Percent 80%80%50%95%95%80%70%90%90%95%95%95%95%95%90%60%90%60%60% 100% Distribution Demand 50% 7 of 35 100% Energy 5%5%5%5%5%5%5%0% 30%20%20%20%30%10%10%10%40%10%40%40% Customer 2019 Budget Electric Utility 20.00%20.00% Labor Cost Breakout Percent 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00% 100.00%100.00% City of Port Angeles -- 3,100.00 Total 76,151.4289,507.5686,991.1598,630.3671,910.2527,700.0038,400.00 105,921.74157,305.74141,568.70122,132.45152,051.35150,621.57152,296.54152,396.13134,515.43132,372.97125,194.20140,002.63132,372.97132,372.97133,233.07137,774.04145,799.73124,993.09 3,105,752.18 -- 5,110.253,100.00 20,465.7228,250.6631,077.7227,824.0524,395.8837,536.7147,257.5623,527.0740,982.6738,855.0843,632.6943,732.2837,896.5835,754.1224,015.6143,383.7835,754.1235,754.1221,409.2441,155.1944,362.8840,892.702 7,700.0038,400.00 Benefits 881,225.95 ----- ---------------------- OT 66,800.0066,800.00 ------ 55,685.7061,256.9074,844.0259,167.1074,234.4894,311.1498,605.3896,618.8596,618.8596,618.8596,618.8596,618.8596,618.8584,100.39 Wages 119,769.03111,068.68111,766.49108,663.85108,663.85101,178.59111,823.83101,436.85 2,157,726.23 11111111111111111111111 24 # Payroll System Employee AEmployee BEmployee CEmployee DEmployeeEEmployee FEmployee GBudgeted OvertimeEmployee HEmployee IEmployee JEmployee KEmployee LEmployee MEmployee NEmployee OEmployee PEmployee QEmployee REmployee SEmployee GEmployee UEmployee VEmployee WFMLA PremiumHealth ReimbursementUnemploymentWorkers Comp C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Labor1 2:00 PM 5/1/2019 917,972791,104581,971672,575674,006609,827671,434934,131742,418924,487 Total 1,001,2351,063,2459,584,406 - H (11,983) -0.01298145,193133,210 KWHKWHKW True upTrue up True up (11,185,890)(11,185,890) Load Shaping Load ShapingLoad Shaping --- 14,66762,123 16,64714,61816,190 pill SpillSpill 0.000710.000710.000710.00071 S 8 of 35 SurchargeSurchargeSurcharge 23,447,13820,588,55522,802,64920,658,293 87,496,635 111111111111 12 REP REPREP (57,715) (57,715) (57,767)(57,767)(57,767)(57,767)(57,767)(57,767)(57,767)(57,767)(57,767)(57,715)(57,767)(57,767)(57,767)(57,767)(57,767)(57,767)(57,767)(57,767)(57,767)(57,715)(57,715)(57,715) (693,048) RefundRefundRefund CustomerCustomerCustomer -------------- -------- 9.287.686.498.339.87 10.6511.83 11.4511.1510.9810.9110.45 3,0433,043 35,99935,999 KWKWKW DemandDemandDemand 0.0266 0.0208 (9,714) 89,852 63,286 34,379 16,851 11,78179,434 0.023940.023940.017540.011250.009310.019050.022610.022190.022490.02474 (43,399)(17,757)(38,055)(12,074) 749,247476,191116,895291,479 (509,916)(544,132) 3,753,2194,882,8413,042,6061,960,0402,986,2519,348,200 KWHKWHKWH (3,857,711)(1,907,346)(1,683,090) Shaping ShapingShaping LLH Load LLH LoadLLH Load 2018 BPA Bills (Power Portion) 0.0293 17,168 18,454 55,420 36,839 0.03028 0.028540.023750.019670.016630.017710.024660.028110.027940.026740.02727 (77,855)(82,437)(82,699)(22,997) 872,924690,123159,843194,811103,147 (843,296)(126,169)(119,848) 5,455,3926,825,8874,343,0211,830,250 KWHKWH KWH (7,586,832)(4,396,082)(3,342,949)(4,263,529)(2,959,861) (3,374,952) ShapingShapingShaping HLH Load HLH LoadHLH Load 0.443770.443770.443770.443770.443770.443770.443770.443770.443770.444890.444890.44489 DOLDOLDOL (299,405)(299,405)(299,405)(299,405)(299,405)(299,405)(299,405)(299,405)(299,405)(299,405)(299,405)(299,405)(132,867)(132,867)(132,867)(132,867)(132,867)(133,202) (132,867)(132,867)(132,867)(132,867)(133,202)(133,202) Charge ChargeCharge (3,592,860)(1,595,409) Non Slice Non SliceNon Slice 0.44489 0.443770.443770.443770.443770.443770.443770.443770.443770.443770.444890.44489 942,173942,173942,173942,173942,173944,551 942,173942,173942,173942,173944,551944,551 DOLDOL DOL 2,123,1122,123,1122,123,1122,123,1122,123,1122,123,1122,123,1122,123,1122,123,1122,123,1122,123,1122,123,112 ChargeChargeCharge 25,477,344 11,313,215 CompositeCompositeComposite Dec AmountJanFebMarAprMayJunJulAugSepOctNovDecRateJanFebMarAprMayJunJulAugSepOctNovDollarsJanFebMarAprMayJunJulAugSepOctNovDec C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Power 18 2:00 PM 5/1/2019 920,026651,839757,522740,228679,266737,062830,387 Total 1,142,9631,223,0311,056,2891,023,0841,093,473 Combined 10,855,171 69,86884,94766,22269,43965,62888,95287,969 141,729159,786138,317128,922168,986 Total 1,270,765 11114 (1) 9 of 35 ------- - 792108 (1.00) 792.32107.7218,38219,281 MoMoMo MiscMiscMisc 920,026 651,839 757,522 740,228 679,266 737,062 830,387 18,382.001,142,9631,223,0311,056,2891,023,0841,093,473 857837843858 914 1,5461,4751,4231,1541,1151,2711,514 100.0%100.0% 13,806 0.000050.000050.000050.000050.000050.000050.000050.000050.000050.000050.000050.00005 920,026651,839757,522740,228679,266737,062830,387 1,142,9631,223,0311,056,2891,023,0841,093,473 KWHKWHKWH Total Charge 30,917,20029,505,560 28,456,430 23,084,970 ChargeCharge 18,273,99017,143,71016,735,69016,850,57017,154,30022,299,54025,414,48030,288,48010,855,17111,089,172 276,124,920 WECC DuesWECC DuesWECC Dues 857837843858 914 90.2%88.3% 1,5461,4751,4231,1541,1151,2711,514 13,806 0.000050.000050.000050.000050.000050.000050.000050.000050.000050.000050.000050.00005 943,569 811,869598,408 687,995 689,060 624,988 686,864 954,189 765,278 915,732 1,029,0441,089,785 9,796,7819,796,781 KWHKWHKWH 30,917,20029,505,56028,456,43023,084,97016,850,570 18,273,99017,143,71016,735,69017,154,30022,299,54025,414,48030,288,480 ChargeChargeChargeEnergy 276,124,920 Peak DuesPeak DuesPeak Dues based on KWH 9.4% 9.2% 9,3768,9488,6307,0015,5425,199 5,075 5,112 5,202 6,762 7,707 9,185 53,43069,52751,16954,27850,19868,89465,109 83,738 945,138901,984869,914705,708515,1220.009920.009920.009920.009920.009920.009920.009920.009920.009920.009920.009920.00992113,920133,246112,721108,157141,742 558,636524,084511,610524,406681,696776,920925,918 KWHKWHKWH 8,441,1361,022,3911,022,391 Summary Adjusted for Normal Demand Supp ResSupp ResSupp Res Distribution RequirementRequirementRequirement based on KW ----------- 0.3%2.4% 8,4546,6926,2796,1296,1736,2828,1679,308 11,32310,80610,42211,09235,99935,999 0.011980.011980.011980.011980.011980.011980.011980.011980.011980.011980.011980.01198 945,138901,984869,914705,708558,636524,084511,610515,122524,406681,696776,920925,918101,127270,000 KWHKWHKWH 8,441,136 Spin ResSpin ResSpin Res Demand RequirementRequirementRequirement based on KW 0001300013 4,0193,8363,6993,0012,3762,2292,1762,1912,2302,8993,3043,938 35,896 0.000130.000130.000130.000130.000130.000130.000130.000130.000130.000130.0. 288,480 KWHKWHKWH 30,917,20029,505,56028,456,43023,084,97018,273,99017,143,71016,735,69016,850,57017,154,30022,299,54025,414,48030, Response 276,124,920 ResponseResponse Reg & FreqReg & FreqReg & Freq 000000000000 ------------ - 100.0% 54,170 63,360 53,600 51,430 25,810 25,03024,32024,28023,87032,76030,96067,400 476,990977,793709,606815,289797,995737,033794,829888,102 KWKWKW 1,200,7301,280,7981,114,0561,080,7991,151,188 Total 2018BPA Bills (Transmission Portion) LT FirmLT FirmGSR NTLT Firm 11,548,219 GSR NTGSR NT 2019 BudgetAve 2014 & 2015 0.3760.3760.3760.3760.3760.3760.3760.3760.3760.3760.3760.376 90.8% 9,4119,1449,1299,7058,975 54,17063,36053,60051,43025,81020,36823,82320,15419,33812,31811,64125,342 25,03024,32024,28023,87032,76030,96067,400 476,990179,348869,636656,175745,762746,827682,755744,631822,993973,447 KW KWKW Energy 1,086,8111,147,5521,001,3361,011,904 SCD NTLT FirmSCD NTLT FirmSCD NTLT Firm 10,489,829 based on KWH Summary w/o REP 894 9.2% 1.7271.7271.7271.7271.7271.7271.7271.7271.7271.7271.7271.727 54,17063,36053,60051,43025,81093,55292,56788,82043,22742,00141,93244,57441,22356,57753,46853,43069,52751,16954,27850,19868,65,109 25,03024,32024,28023,87032,76030,96067,400 476,990109,423116,400823,762113,920133,246112,721108,157177,741 KWKWKW 1,058,390 ChargeChargeCharge Demand NT ServiceNT ServiceNT Service based on KW AmountJanFebMarAprMayJunJulAugSepOctNovDecRateJanFebMarAprMayJunJulAugSepOctNovDecDollarsJanFebMarAprMayJunJulAugSepOctNovDecJanFebMarAprMayJunJulAugSepOctNovDec C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Transmission 18 2:00 PM 5/1/2019 10 of 35 56,40030,13745,39456,400 55,00955,71055,16057,39053,07763,62965,81559,96467,32062,05047,23257,809 55,00955,71055,16057,39053,07763,62965,81559,964 756,564 832,094 850,617806,436641,330678,933 139,398 209,968 349,366 700,164 3,443,070 3,499,4703,848,836 Est. CostEst. Cost $ $$$$$$$$$$$$$$$$$$$$$$$$$ 36.968541.450937.119639.853935.670344.186644.230640.298246.750041.700032.800038.850036.968541.450937.119639.853935.670344.186644.230640.298247.256543.356835.580036.5018 $$$$$$$$$$$$$$$$$$$$$$$$ $4,700/mo kWhkWh 1,488,000 1,344,000 1,486,000 1,440,000 1,488,000 1,440,000 1,488,000 1,488,000 1,440,000 1,488,000 1,440,000 1,488,000 1,488,000 1,344,000 1,486,000 1,440,000 1,488,000 1,440,000 1,488,000 1,488,000 17,518,00018,000,00018,600,00018,025,00018,600,00084,887,000 Add onMcKinley bill - pre-taxExcise TaxCity TaxTotal Revenue 1,4881,3441,4861,4401,4881,4401,4881,4881,4401,4881,4401,4881,4881,3441,4861,4401,4881,4401,4881,488 Original Budget 17,51818,00018,60018,02518,60084,887 MWhMWh Revised Estimate Electric Utility City of Port Angeles 744672743720744720744744720744721744744672743720744720744744720744721744 Industrial Transmission Hrs/MonthHrs/Month 22222222222222222222 25252525 aMWaMW MonthMonth Industrial Transmission (IT): 2019 ESTJanuary FebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotalsJan-Aug 219 use 2 aMW at rate 2018-19 rates. Sep-Dec uses 25 aMW. Sep-Dec 2019rates uses 2017 rate increased by 2% (avg increase between 2017 and 218 rates) thenincreased by another 5% for estimated 2019 BPA rates.Industrial Transmission (IT): 2019 ESTJanuary FebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotals C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Ind Transmission 2:00 PM 5/1/2019 From Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Admin tab From Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Transmission tabFrom Admin tab Fixed/ Variable FixedFixedFixedFixedFixedFixedFixedFixedFixed FixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixed Total 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100 .00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00% 5.48%5.48%5.48%5.48%5.48%5.48%5.48%5.48%5.48%5.48%5.48%5.48%5.48% As All 53.55%56.32% Others 100.00%100.00%100.00%100.00%100.00% 9.22%0.00% 71.49%71.49%71.49%71.49%71.49%71.49%71.49%71.49%71.49%71.49%71.49%71.49%71.49%34.00%20.00%34.00%80.00%90.00%11.19%70.00%70.00%80.00%90.00%90.00%75.00%80.00% 100.00%100.00%100.00% Distribution ??????? 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%2.43%0.00%0.00% Demand Allocation Percent 7.47%7.47%7.47%7.47%7.47%7.47%7.47%7.47%7.47%7.47%7.47%7.47%7.47%0.00%0.00%0.00%8.30%5.00%5.00% 33.00%80.00%33.00%10.00%88.35%32.49%20.00%20.00%20.00%20.00%20.00% 100.00% Energy 0.00%5.00%5.00%5.00% 15.57%15.57%15.57%15.57%15.57%15.57%15.57%15.57%15.57%15.57%15.57%15.57%15.57%33.00%33.00%10.00%10.00%38.15%10.00%10.00% Customer - - 8,200 2,000 3,100 5,000 1,500 7,800 2,100 66,80038,40027,70023,20040,50027,40033,60030,00060,10055,40024,00018,50048,70062,90079,40060,00026,600 154,500258,900318,000450,000261,400378,000125,000151,900 EntryCosts 2,049,3001,095,300 11 of 35 16,502,900 - - 2019 Budget 8,200 2,000 3,100 5,000 1,500 7,800 2,100 66,80038,40027,70023,20040,50027,40033,60030,00060,10055,40024,00018,50048,70062,90079,40060,00026,600 154,500258,900318,000450,000261,400378,000125,000151,900 Total Electric Utility 2,049,3001,095,300 16,502,900 CITY of PORT ANGELES Cost Functional Allocation ------ ------------- 449110170 3,6608,4652,1041,5181,2717,8002,100 14,185 17,423 31,200 79,400 112,277586,505261,400378,000 As All Others - - - - - - - - - 5,8621,4302,2161,0009,3161,5006,200 47,75427,45119,80216,58513,77026,88054,09016,80012,95038,96062,90045,00021,280 110,448 185,081 227,330 450,000 112,500 136,710 1,464,9921,521,522 Distribution ??????? --------- - - - - - - - - - - - - - - - - - - - - - - - - - - - Cost Allocation 401,814 Demand ---- ------- 612149231 4,988 2,867 2,068 1,732 4,000 9,042 3,360 4,800 3,700 9,740 6,250 7,595 5,320 11,53619,33123,74413,36530,00090,95518,00012,000 153,014 Energy 14,579,564 ----------- - - - - - 311483 5,9781,2774,3123,6129,0423,3606,0102,4001,8506,2507,5953,000 10,39924,05140,30349,50413,365 319,018 417,840 Customer per Rentals/Leases Full-Time EmployeesPart-Time EmployeesOvertime/Call-back PayFICAPersWorkers CompLTDSupplemental LifeFLMA PremiumIns - Medical/DentalHealth ReimbursementState UnemploymentICMA Matching FundsOffice/Operating SuppliesBldg and Maint SuppliesComp EquipmentFuel ConsumedPropaneBPA Purchased PowerPUD Purchased PowerMaterials - Job CostSmall Tools/Minor EquipAdministrativeEmergency ManagementProf/Contract ServicesPW Administrative ChargesIT ChargesCommunication ExpensesNetwork ServicesTravel and TrainingAdvertising/Legal NoticesEq Serv Chg (Replacement)Eq Serv Operating ChargesOInsuranceUtilities ExpenseSoftware/Hardware Maint Personnel CostsAdministrative ChargesContractual Services C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Cost alloc 1 2:00 PM 5/1/2019 NTDistributionAll Distribution FixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedSSNTSSSNTNT-ExciseSNTSNT-Excise & CityNT 0.00%0.00% Total 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100 .00% 0.00%0.00%0.00% As All Others 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00% 0.00% 100.00%100.00%100.00%100.00% Distribution ??????? Allocation Percent Demand Energy 100.00% Customer --- (250) 9,500 (9,000)(2,000)(3,000)(1,500) 48,40068,30012,50040,20021,50020,350 (15,000)(80,000)(20,000)(40,000)(21,500)(90,000) 12 of 35 256,500120,000480,000240,300 Entry Costs (718,200)(120,000)(241,600)(102,600)(152,000) 1,050,000 (1,596,300) 24,845,30024,845,30023,249,000 ----- (250) 9,500 (9,000)(2,000)(3,000)(1,500) 48,40068,30012,50040,20021,50020,350 (15,000)(80,000)(20,000)(40,000)(21,500)(90,000) 256,500120,000480,000240,300 Total (718,200)(120,000)(241,600)(102,600)(152,000) 1,050,000 (1,596,300) 24,845,300 24,845,300 24,845,300 23,249,000 2019 Budget ---------- (250) Electric Utility 9,500 (9,000)(3,000)(1,500) (2,000) 48,40012,50040,20021,50020,350 (15,000)(80,000)(20,000)(40,000)(21,500)(90,000) 120,000 As All (718,200)(120,000)(241,600)(102,600)(152,000) Others 1,760,1351,760,1351,596,300 (1,760,135) (1,596,300) CITY of PORT ANGELES Cost Functional Allocation ---------------------------- 256,500480,000240,300 508,337 (461,021) 1,050,0006,667,1286,667,1287,175,4656,714,445 Distribution ??????? -------------------------------- Cost Allocation 30,63604,666 (27,785) 401,814401,814432,450 4 Demand ------ - - ----------- - - - ----- - - - -- Energy 1,145,049 3,443,069 (1,038,467) 15,017,96515,017,96516,163,01315,124,54711,681,478 ------------------------------- 68,30076,112 (69,028) 998,258998,258 1,074,3711,005,343 Customer Repairs and MaintDues/SubscriptionsConservation IncentivesMiscellaneous ServicesBad Debt ExpenseInterdepartmental Revenue Bond Prin (DS)Interest Expense (DS)Transfers/CapitalTransfers/Debt Service (DS)Fund Balance Increase (ratios)Intra-Fund TransfersExcise TaxesCity TaxesAlloc of "All Other"TotalRevenueJudgements & SettlementsTelecable PermitsElectrical PermitsRoad/Street Maint SvcsUncoll Amts RecoverdService & Hookup FeesConnection FeesPlan Checking FeesInvestment InterestDelinquent InterestPole Contract RentalsInterdeptSale of Scrap & JunkMiscellaneous RevenuesConstruction ContributionAMI Transfer - from reserveFrom Fund BalanceAllocation of "As All Other"Net expenditureIndustrial Transmission C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Cost alloc 2 2:00 PM 5/1/2019 52.8352.8352.8352.8352.8352.8352.83 52.8352.83 0.046330.04633 0.046330.046330.04633 0.04633 0.04633 0.04633 0.04633 0.04633 Cost/month Unit Cost/kwh 5,071 12,67855,15121,55357,68610,143 42,66692,420 364,861172,007229,219735,343112,837 5,622,8231,413,8592,045,5565,703,9826,714,445 1,698,067 11,681,478 $ Share$ Share 3.12%1.96%1.68%0.08%0.82%0.32%0.86% 0.37%0.79%1.47%0.19%0.15% 48.13%12.10%17.51%14.54%84.95%10.95% 100.00% 100.00% % Share% Share 8 2087349116 178 8,9981,160 10,592 921,000948,000 Use 7,876,0003,713,0004, 1,995,000 30,520,00044,156,00036,655,000 Weighted 121,376,000252,160,000 1.001.001.001.001.001.001.001.001.001.001.001.001.001.00 1.001.001.001.00 FactorFactor 8 2087349116 178 8,9981,160 10,592 921,000 7,876,0003,713,000 1,995,0004,948,000 6,714,445 30,520,00044,156,00036,655,00023,249,000 11,681,478 121,376,000252,160,000 Accounts Total Use 13 of 35 Total 2019 Budget Energy ResidentialGeneral ServiceGeneral Service DemandGeneral Service Demand PrimaryStreet LightsGovernmentGovernment DemandMunicipalMunicipal Demand Distribution ResidentialGeneral ServiceGeneral Service DemandGeneral Service Demand PrimaryStreet LightsGovernmentGovernment DemandMunicipalMunicipal Demand Electric Utility Allocation factors CITY of PORT ANGELES 1.231.231.231.231.23 7.917.917.917.917.917.917.917.917.91 0.04056 Cost/month Unit Cost/kw Unit Cost/kwh 759 1,8988,2583,2278,6371,519 40,42233,558 16,895 210,742119,944 854,048110,102404,666 $ Share$ Share$ Share 1,005,3433,443,069 1.68%0.08%0.19%0.82%0.32%0.86%0.15%9.99%8.29% 84.95%10.95%52.08%29.64% 100.00%100.00%100.00% % Share% Share% Share 8 34 91 208716 178 8,9981,160 10,592 97,68032,919 27,329 171,624329,552 Use 3,286,998 1,895,127 84,887,000 WeightedWeighted 1.00 1.00 1.001.001.001.001.00 1.001.001.001.00 1.001.00 1.00 FactorFactorFactor 8 34 91 208716 178 8,9981,160 10,59297,68032,919 27,329 KW 171,624329,552 404,666 1,005,343 3,443,069 Accounts Total Use 84,887,000 Customer ResidentialGeneral ServiceGeneral Service DemandGovernment DemandMunicipal Demand General Service DemandGeneral Service Demand PrimaryGovernment DemandMunicipal Demand Energy - Industrial Transmission Industrial Transmission General Service Demand PrimaryStreet LightsGovernmentMunicipal Demand C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Customer allocation 2:00 PM 5/1/2019 5%2%5%2% 67%19% 14 of 35 100% Percent Distribution 42,17942,179 105,448105,448400,701 1,412,997 2,108,951 Number Electric Utility Labor Allocation City of Port Angeles LinesMeteringStreet LightingSubstationTransformerServicesTotal C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Dist Labor Alloc 2:00 PM 5/1/2019 100%100%100%100%100%100%100%100%100%100%100%100% Total 100% Power 2%2%2%0%2%2%2%0%2%2%2% St Lights 2%2%0%1%0%2%2%0%2%2%2% Services 5%0%5%9%5%0%5%5% 19%10%19% Transformer 5%5%0%1%0%5%1%5%5%5% 28% Metering 5%5%5%0%5%5%5%5% 78%28%74% Substation 67%81%83%20%37%87%81%25%67%81%81% Lines 44 211 276319151 3,9502,2151,8205,1127,452 14,96710,79847,316 Alloc 6,714,445 6,200 29,75038,96045,00021,280 556,556312,110256,500720,300050,000 Entry 1, 2,108,9511,521,522 6,667,128 Total 319 15 of 35 6,244 29,96139,23645,21,431 Total 560,506 314,325 258,320 725,412 1,057,452 2,123,9181,532,3206,714,445 Electric Utility City of Port Angeles Distribution Costs Allocation Power 1,532,3201,532,320 - - 125785906 6,287 5,166 42,47811,21014,50821,149 102,615 St Lights --- 300906 6,2875,166 42,47811,21014,50821,149 102,005289,073 250,046 602,935 102,005 102,615 Services 1,532,3203,835,4506,714,445 Total --- 624 1,9622,266 28,025 28,289 49,081 36,271 52,873 26,393 40,802 403,544602,935410,291150,318199,487 1,532,3202,359,611 Transformer Demand --- 300214 2,266 28,02510,98612,91636,27152,87361,203 106,196 250,046138,755 223,654 403,448 102,615 3,425,1604,354,834 Metering Customer 0% - 11%52%11%33%40% 312 100% 2,266 28,02523,37010,98615,85912,91636,27152,873 106,196289,073 Substation % Demand 89%48%89%67%60% 100% 5,1835,9925,358 14,51836,709 454,010273,463173,075587,584856,536 Lines 1,423,025 3,835,450 % Cust LaborTools/SuppliesBPA Purchased PowerContract ServicesComm/NetworkTravel & TrainingEquip Serv ChgUtilitiesComp MaintRepairs & MaintDebt ServiceIntrafund Transfers BPALinesSubstationMeteringTransform erServicesSt Lights C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Dist Costs 2:00 PM 5/1/2019 1,038,6703,830,938 KWH 116,506,392121,376,000 0.9%3.2% 96.0% 100.0% KWH Percent 0.9%3.2% 96.0% 100.0% Customers 6%7% 72%28%50%50%70%30%94%25%75%93%32%68% 100%100%100% 16 of 35 Includes RS,RD,RMD5D6CM,COCM3,CO3GOGO3MUMU3TSMSCD,CNCD3,CN3GDGD3MDMD3MU-MEMSMU-CMRA,MU-WAPSNPNP3CED Lights40 Watts or LessMore than 40 Less than 70 WattsMore than 70 Less than 110 WattsMore than 110 Watts40 Watts or LessMore than 40 Less than 70 WattsMore than 70 Less than 110 WattsMore than 110 WattsRWPDPD3PM 8,1631,096 Note: 11,00124,75615,00111,23211,23230,17530,17567,50567,505 160,623220,640 329,552 KVA 70,000 991,276813,679347,321921,000336,821972,617 KWH 1,038,6703,830,9387,825,1561,003,7242,830,3091,953,1225,922,8784,611,1792,084,3833,057,0002,482,0002,482,0007,826,0007,826,000 19,637,84431,610,00041,325,69156,980,00028,829,00028,829,000 116,506,392121,376,000252,160,000 4444 9 3 3 1 2 2 2 776522591920383112352055 284911194140230 Electric Utility 8,6378,9981,299 10,592 for use in the 2019 Budget CITY of PORT ANGELES Customers Summary of Accounts and Consumption 100 Watts or LessMore than 100 Less than 150 WattsMore than 150 Less than 200 WattsMore than 200 WattsSingle PhaseThree PhaseThree Phase 100 Watts or LessMore than 100 Less than 150 WattsMore than 150 Less than 200 WattsMore than 200 Watts unicipal Three Phase Municipal Emergency ManagementMunicipal Unmetered SecuritySingle PhaseThree PhaseOwned by CityOwned by CustomersRegularCustomer OwnedCity Owned Regular25% Discount35% DiscountSingle PhaseThree PhaseGovernment Single PhaseGovernment Three PhaseMunicipal Single PhaseMunicipal Three PhaseMunicipal Traffic SignalMunicipal Street LightSingle PhaseThree PhaseGovernment Single PhaseGovernment Three PhaseMunicipal Single PhaseM rd Lights General ServiceGeneral Service DemandNonprofitYaMunicpal Water PumpingPrimary ServiceTotal Residential C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Total Customers (3) 477 2:00 PM 5/1/2019 1,1211,598 1,762.8 Total 31,492.033,254.8 5,373,5929,240,591 14,614,183 9 9 -- TS 6,8656,865 55 RW 1,162.61,162.6 238,700238,700 44 PM 6,492.0 6,492.0 2,378,1002,378,100 55 PD 3,432.03,432.0 751,800751,800 302050 85.2 806.2 891.4 NP 109,488234,640344,128 1919 -- MS 2,629,2662,629,266 611879 - -- MU 79,12833,776 112,904 3 1316 Total 17 of 35 104.4 MD 35,840 Three Phase 1,802.61,907.0 Single Phase 490,660526,500 Electric Utility 641680 - -- City of Port Angeles GO 97,64596,434 194,079 Commercial Customer breakout 5 2732 670.2 GD 2,752.6 3,422.8 809,440 266,920 1,076,360 - 751208959 82.282.2 CO 727,077 1,695,8092,422,886 1111 - CN 1,150.01,150.0 274,240274,240 14 - -- 152166 CM 35,004 216,693251,697 27 136163 903.0 CD 235,938 13,811.814,714.8 3,170,7203,406,658 CountKWHKWHCountKWHKWHCountKWHKWHfrom Kathyellen report 8/29 C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Commercial 2:00 PM 5/1/2019 8,760 123,633 12.09 4,8963,864 8,760 36,87737,93938,48636,561 123,633195,042 130,970,022136,883,384 0.290.92 400344 744 21.000.8790.812 29,80530,66431,10528,61725,15425,2450.0432 103,741 16,208,51716,940,340 Dec 0.330.94 400321 720 0.730 19.000.876 70,75423,36624,03924,38522,92216,73321,3500.0432 9,679,083 10,116,098 Nov 0.370.96 416328 744 18.000.941 0.726 47,74017,87418,38918,65417,90716,85113,5430.0432 6,393,3146,681,975 Oct 0.240.88 400320 720 0.887 22.909,3499,6199,7578,5867,6160.7026,847 38,9560.0432 6,422,7876,712,779 Sep 0.240.89 432312 744 0.860 23.666,9707,1717,2746,4745,5670.7505,456 29,0410.0432 5,111,2845,342,061 Aug 0.210.89 400344 744 25.796,0186,1916,2805,5890.7874,3990.7634,793 28,6560.0432 5,498,7955,747,068 Jul 0.220.92 416304 720 24.210.6706,8040.5826,419 48,07910,57710,88211,03910,1560.0432 8,379,5538,757,894 Jun 0.250.95 416328 744 23.940.6478,0500.996 18 of 35 50,20012,55012,91113,09712,44313,0510.0432 8,939,7249,343,357 May Electric Utility 0.230.90 400320 720 25.370.9760.693 Residential Factors City of Port Angeles 65,35515,03215,46515,68714,11913,78010,8710.0432 11,936,31112,475,241 Apr 0.270.91 432311 744 19.980.9560.878 33,04834,00034,48931,38530,00430,2760.0432 122,400 18,196,15619,017,722 Mar 0.270.94 384288 672 20.000.9310.686 33,76034,73335,23333,11930,83424,1780.0432 123,633 16,616,26417,366,497 Feb 0.300.95 400344 744 19.23 0.8000.837 36,87737,93938,48636,56129,24932,2290.0432 122,924 17,588,23418,382,352 Jan 2.88%1.44% 2017 Hours in the month HLHLLHResidential kWh Sales at the Meter Load Factor Indiv. Noncoincident Peak(NCP)(kW) Group Coincidence Factor NCP at the Meter for the Group (kW) NCP at Primary (kW) NCP at Input (kW) System Coincidence Factor Coincident Peak (CP) at Input (kW) BPA Generation Coincidence Factor Contribution to BPA Generation Peak BPA Transmission Coincidence Factor Contribution to BPA Transmission Peak kWh at Input VoltageSource: 2014 PA Electric FINAL - 5 year phase in - FCS (Load tab) C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Res Load 2:00 PM 5/1/2019 1.01851.0115 Gregg????Factors 0.39 8,760 10,59262,5500.087164,43958,870 161,031 Total 21,959,804 252,160,000259,778,447 3 - 525 8,760 Other 9 37 35353637 1.001.004.064.060.03 8,760 0.225270,00030,7170.4388648.1572,115 Traffic Signal 20 257129131132132 0.501.006.626.620.03 8,760 0.40900.1255 921,000115,572948,826 3,837.50 Street Lights 2 1.000.880.03 0984 8,7601,1821,1821,2031,2171,071 0.23980.608.62535.58 244,308 2,482,0002,556,988 103,416.67 Water Pump 8 0.820.900.03 8,7608,0256,5816,7026,7806,102 0.52140.0591847.44762.70 2,166,965 Primary 36,655,000381,822.9237,762,448 227 0.730.91 0.03 8,76065.2059.34 0.330519,68114,3670.077714,63314,80113,469 4,429,12520,917.77 56,980,00058,701,522 GS Demand 0.540.916.796.180.03 8,7601,2708,3678,5218,6197,844 0.232915,4940.0928 2,009.12 2,842,137 30,619,00031,544,084 19 of 35 General Service 55 946 964 975 887 0.54 0.91 0.03 8,7601,75317.7316.13 Electric Utility 0.19910.0881 269,342 Load Data Detail 4,631.82 3,057,0003,149,360 City of Port Angeles Non Profit 77 981265270273251 0.27 0.923.543.26 0.03 8,760 0.120958,0630.0559 1,124.10 1,038,6701,070,051 Discount 25% 284 977 995 926 0.27 0.92 3.54 3.26 0.03 8,7603,6171,006 0.12090.0530 202,974 1,124.10 3,830,9383,946,682 Discount 35% 0.27 0.92 3.543.260.03 8,7608,637 0.120929,7020.099630,25130,59928,151 110,007 1,124.10 11,600,078 116,506,392120,026,370 Residential Customer Load Profile HoursNo of CustomersLoad Factor - GroupIndividual NCPGroup Coincidence FactorNCP at meter for groupSystem Coincidence Factor Adjusted Billing Statistics Energy at MeterRevenueCost per kWH Current RatesCost per kWH Cost of ServiceRate Adjustment Usage Profile - NCP Average Monthly kWH usage per customerNCP at Primary for groupNCP at input for groupEstimated Peak usage per Customer - kW Usage Profile - Energy Production Coincidence peak at input voltageDiversified CP per customer - kW System Losses KWH's at input voltageAverage system losses in percent C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Load 2:00 PM 5/1/2019 KW 11,232 97,680 Sales 220,640329,552 - 0.65% 70,000 921,000 KWH Usage 3,830,9381,038,6703,057,0002,482,000 30,619,00036,655,000 56,980,000 116,506,392252,160,000 829 3 775520 284 227 1.0%0.3%1.2%0.4%1.0%0.0%0.0% 46.5% 12.2%22.7%14.6% 8,6371,270 100.0% 10,592 Percent Customers Number of -- 20 of 35 72,11572,115 948,826 948,826802,538 3,946,6821,070,0513,149,3602,556,9882,565,3433,149,3602,556,988 Total 31,544,084 58,701,522 37,762,448 31,544,08458,701,52237,762,448 Energy Energy Revised 120,026,370259,778,447120,026,370258,129,596 111111111 0.650.75 525 58,06330,717 202,974269,342115,572244,308 2,842,1374,429,1252,166,965 Electric Utility Load Summary Factor 11,600,07821,959,804 Revenues City of Port Angeles 37 -- 273975132 1,006 8,619 6,780 1,217 30,59914,80164,43972,115 948,826 NCP Max Total 3,946,6821,070,0513,149,3602,556,988 Energy 31,544,08458,701,52237,762,448 120,026,370259,778,447 Customer ClassResidentialResidential - Disc 35%Residential - Disc 25%Non ProfitGeneral ServiceStreet LightingGeneral Service DemandGS Demand PrimaryWater PumpTraffic SignalsOtherTotalResidentialResid ential - Disc 35%Residential - Disc 25%Non ProfitGeneral ServiceStreet LightingGeneral Service DemandGS Demand PrimaryWater PumpTraffic SignalsOtherTotal C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Load Summary 2:00 PM 5/1/2019 Non-DemandDemand 100%100% 100% 6,379 5,842 33,98266,41176,29314,42212,01757,271 239,252872,809351,367362,237695,636269,930 1,605.841,605.84 1,687,9375,759,132 10,505,07510,505,07510,505,075 Cost Total Total Total 21 of 35 Replacement Cost 17%26%11% 993 1,029.761,277.131,399.621,458.851,696.861,974.682,326.932,384.163,696.303,886.233,697.673,605.504,005.675,727.106,379.001,798.20 2,718,3611,123,763 7,786,7149,381,312 10,505,075 Cost Demand Demand Replacement Cost Poles 431 335232987310 83%74%89% 164442151179 1,2063,3945,8424,849 4,8495,842 Pole Costs Electric Utility 7,786,7149,381,312 Number Number Customer Customer City of Port Angeles 20'25'30'35'40'45'50'55'60'65'70'75'80'85'90'TotalAllocationPolesPercentDollarsPercentAverage Cost Non DemandTotal PolesTotal Replacement CostsDemand C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Poles 2:00 PM 5/1/2019 9,848 168,334499,198 1,512,4623,029,4831,264,0451,011,3991,197,2568,692,026 Total Replacement Cost 8 456043 165897319 2,856 1,319 Number 41% 4,614 39,219 208,475318,771346,209462,825 1,001,0591,197,2563,578,428 Replacement Cost Demand Cost 2,307.002,307.004,009.143,935.446,411.28 12,179.60 17,259.64 27,843.17 2 17528154385843 345 Number - 59% 22 of 35 100% 5,234 36,373 10,340 129,115917,835 2,036.482,036.48 1,303,9872,710,7125,113,5978,692,026 8,692,026 Electric Utility Total Total Transformer Costs City of Port Angeles Replacement Cost Cost 41%33%52%11%30%33%40%20% 872.40 872.40 1,543.182,189.593,463.535,196.125,170.00 Cost Non-Demand 10,340.003,578,4285,113,5975,816,1828,692,0262,875,843 Demand DemandDemand Replacement 672 - 59%67%48%89%70%67%60%80% 148845265 2,511 1,2382,5112,856 Number 5,113,597 5,816,182 Customer CustomerCustomer Number llocation ine Transformers kVa 1.5 - 56 - 1516 - 2526 - 5051 - 100101 - 200201 - 500501+TotalATotalReplacement CostMinimum System AnalysisStation EquipmentPolesOverhead Conductors LServicesUnderground Conduits, etc. DollarsPercentNon-Demand C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Transformers 2:00 PM 5/1/2019 - 55.09 63.57 84.7684.7684.7637.0037.00 352.04278.04689.07689.07462.04 Cost Total Install 77 284 - 37.0037.0037.0051.0037.0037.00 Cost 235.00235.00 125.00235.00 Meter - - - 20% 9.90 9.90 9.90 87.3% 12.6% 75.6075.6075.60 151.20151.20 with OH Equipment CustomerDemand --- 41% 37.8637.8637.86 151.44151.44302.87302.87151.44 Labor with OH 23 of 35 --- 1.2%0.4%1.5%0.1%0.4%0.1%0.0%0.0% 0.500.500.502.002.004.004.002.00 56.8%27.4%12.1% 100.00% Factor Weighting Time/hr Equipment - 740 924333 100% 16.5016.5016.5031.5031.5016.5031.5031.5031.5016.5016.504,8955,5131,257 110.11110.11123.08 15,647 19,362 Total 732,063353,105156,419 Dollars 1,289,0011,287,7441,289,001 Rate/hr Meter Costs Electric Utility 9 823 585520 - - - 11% 185227 0.50 0.50 0.50 2.00 2.00 4.00 4.00 2.00 8,6371,270 City of Port Angeles 10,473 136,056 136,056 1,125,8121,151,6881,287,744 Demand Customers Number of Time/hr - 89% Labor 53.7653.7653.7653.7653.7653.7653.7653.7653.7653.7653.7684.7684.7684.7637.0037.001,257 352.04278.04689.07689.07462.0410,22410,45910,462 1,151,688 1,152,945 Cost Meter Customer Rate/hr ResidentialResidential - Disc 35%Residential - Disc 25%Non ProfitGeneral ServiceStreet LightingGeneral Service DemandGS Demand PrimaryWater PumpTraffic SignalsOtherResidentialResidential - Disc 35%Residential - Disc 25%Non ProfitGeneral ServiceStreet LightingGeneral Service DemandGS Demand PrimaryWater PumpTraffic SignalsOtherGeneral ServiceTotal MetersInstall Costs C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Meters 2:00 PM 5/1/2019 82 5855 ---- 185227 1.8%0.6%0.5%0.0%2.2%0.1%0.0%0.0%0.0% 1.000.650.751.001.001.001.001.00 82.7%12.2% 8,6371,270 100.0% 10,441 Billing BillingFactorFactorBillingFactor WeightedWeightedWeighted 2 58 83 80 ---- 185681 1.6%0.5%0.7%0.0%5.9%0.7%0.0%0.0%0.0% 1.000.650.751.501.503.001.00 74.3%16.4% 10.008,6371,905 100.0% 11,630 metermetermeter to Read ato Read ato Read a Weighted Time Weighted TimeWeighted Time 2 2 588380 -- -- 185681 1.6%0.5%0.7%0.0%5.9%0.7%0.0%0.0%0.0% 1.000.650.751.501.500.103.001.00 74.3%16.4% 10.00 8,637 1,905 100.0% 11,632 ServicesServicesServices CustomerCustomerCustomer -- 740924333 1.2%0.4%1.5%0.1%0.4%0.1%0.0%0.0% 56.8%27.4%12.1% 84.76 55.09 63.57 37.00 37.00 4,895 5,513 100.0% 352.04278.04689.07689.07462.0415,64719,362 732,063353,105156,419 1,289,001 CostsCostsCosts MeterMeterMeter 2 5883 -------- 185681 1.6%0.5%0.7%0.0%5.9%0.0%0.0%0.0%0.0% 1.000.650.751.501.500.103.00 74.8%16.5% 8,6371,905 100.0% 11,550 ServicesServicesServices 585520 ---- 185227 1.8%0.6%0.5%0.2%2.2%0.0%0.0%0.0%0.0% 1.000.650.751.001.001.001.00 82.6%12.2% 8,6371,270 100.0% 10,451 24 of 35 NCPNCPNCP CustomerCustomerCustomer SecondarySecondarySecondary 775520 -------- 284227 2.7%0.7%0.5%0.2%2.1%0.0%0.0%0.0%0.0% 1.001.001.001.001.001.001.00 81.7%12.0% 8,6371,270 100.0% 10,570 Electric Utility CustomerCustomerCustomer SecondarySecondarySecondary City of Port Angeles 82 9 3 5855 Customer Weighting Factors 20 185227 1.8%0.6%0.5%0.2%2.2%0.1%0.0%0.1%0.0% 1.000.650.751.001.001.001.001.001.001.001.00 82.5%12.1% 8,6371,270 100.0% 10,473 WeightingWeightingWeighting SubstationSubstationSubstation 22 5883 80 ---- 185681 1.6%0.5%0.7%0.0%5.9%0.7%0.0%0.0%0.0% 1.000.650.751.501.500.103.001.00 74.3%16.4% 8,6371,905 10.00 100.0% 11,632 CustomerCustomerCustomer WeightingWeightingWeighting 8293 585520 185227 1.8%0.6%0.5%0.2%2.2%0.1%0.0%0.1%0.0% 0.751.001.001.001.001.001.00 1.00 0.65 1.00 1.00 82.5%12.1% 8,6371,270 100.0% 10,473 ExpenseExpenseExpense CustomerCustomerCustomer WeightingWeightingWeighting 82938293 775520775520 284227284227 2.7%0.7%0.5%0.2%2.1%0.1%0.0%0.1%0.0% 81.5%12.0% 8,6371,2708,6371,270 100.0% 10,592 CustomersCustomersCustomers Number ofNumber ofNumber of Weighting Factors Customer ClassResidentialResidential - Disc 35%Residential - Disc 25%Non ProfitGeneral ServiceStreet LightingGeneral Service DemandGS Demand PrimaryWater PumpTraffic SignalsOtherCustomer ClassResidentialResidential - Disc 35%Residential - Disc 25%Non ProfitGeneral ServiceStreet LightingGeneral Service DemandGS Demand PrimaryWater PumpTraffic SignalsOther Allocators Customer ClassResidentialResidential - Disc 35%Residential - Disc 25%Non ProfitGeneral ServiceStreet LightingGeneral Service DemandGS Demand PrimaryWater PumpTraffic SignalsOther C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Cust Weighting 1.8%0.6%0.5%0.0%2.2%0.1%0.0%0.0%0.0% 2:00 PM 82.7%12.2% 5/1/2019 100.0% BillingFactor Weighted 1.6%0.5%0.7%0.0%5.9%0.7%0.0%0.0%0.0% 74.3%16.4% 100.0% meter to Read a Weighted Time 1.6%0.5%0.7%0.0%5.9%0.7%0.0%0.0%0.0% 74.3%16.4% 100.0% Services Customer 1.2%0.4%1.5%0.1%0.4%0.1%0.0%0.0% 56.8%27.4%12.1% 100.0% Costs Meter 1.6%0.5%0.7%0.0%5.9%0.0%0.0%0.0%0.0% 74.8%16.5% 100.0% Services 1.8%0.6%0.5%0.2%2.2%0.0%0.0%0.0%0.0% 82.6%12.2% 100.0% stomer x.65x.75 Cu Secondary 1.8%0.6%0.5%0.2%2.2%0.1%0.0%0.1%0.0% 82.5%12.1% 100.0% Weighting Substation 1 1 1.6%0.5%0.7%0.0%5.9%0.7%0.0%0.0%0.0% 74.3%16.4% 100.0% Street Lighting Customer Weighting 3.4% 67.0%29.6% 100.0% 97,680 11,232 220,640329,552 Demand Demand 8293 775520 284227 2.7%0.7%0.5%0.2%2.1%0.1%0.0%0.1%0.0% 81.5%12.0% 8,6371,270 100.0% 10,592 CustomersCustomers Number ofNumber of 25 of 35 Allocators - 1.0%0.3%1.2%0.4%1.0%0.0%0.0% Electric Utility 46.5%12.2%22.7%14.6% 100.0% 72,115 802,538948,826 City of Port Angeles 2,565,3433,149,3602,556,988 TotalTotal 31,544,08458,701,52237,762,448 EnergyEnergy 120,026,370 258,129,596 525 0.9%0.3%1.2%0.5%9.9%1.1%0.1%0.0% 52.8%12.9%20.2% 100.0% 58,063 30,717 115,572 202,974269,342244,308 2,842,1372,166,965 4,429,125 11,600,07821,959,804 RevenuesRevenues 37 - 602188887132 1.0%0.3%1.5%0.2%1.8%0.1%0.0% 48.1%13.4%23.0%10.4% 7,8446,1021,071 100.0% 28,15113,46958,483 PeakPeak TotalTotal (Conincidental)(Conincidental) ---- 132 654205975 1.2%0.4%1.7%0.2%0.0%0.0%0.0%0.0% 54.7%15.4%26.4% 8,619 100.0% Sec 30,599 14,801 55,986 Sec NCP NCP 37 - 654205132 975 1.0%0.3%1.5%0.2%1.9%0.1%0.0% 47.8%13.5%23.1%10.6% 1,217 8,6196,780 100.0% 30,59914,801 64,019 NCPNCP Substation Substation 37 - 654205132 975 1.0%0.3%1.5%0.2%1.9%0.1%0.0% 47.8%13.5%23.1%10.6% 6,7801,217 8,619 100.0% 30,59914,801 64,019 NCP NCP MaxMax eneral ServiceS Demand Primary Weighting Factors ResidentialResidential - Disc 35%Residential - Disc 25%Street LightingGeneral Service DemandGS Demand PrimaryWater Pump Customer ClassNon ProfitGeneral ServiceTraffic SignalsOther Allocators Customer ClassResidentialResidential - Disc 35%Residential - Disc 25%Non ProfitGStreet LightingGeneral Service DemandGWater PumpTraffic SignalsOther C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Allocators 36%14%50% 100% 2:00 PM 5/1/2019 Kathyellen 26,393 40,802 61,203 60,900 404,666410,291150,318138,755102,005361,924140,748502,672 289,073223,654250,046102,615199,487403,448602,935 Total 3,443,0691,532,3203,425,1603,835,4505,182,1251,005,343 11,681,47817,061,532 23,249,00023,309,900 404040 40 ------------------ Other -- 3,443,0693,443,0693,443,069 Industrial Transmission Yard Lights 5858 ------ ------ 428 119 119 177 3,6923,869 3,264 Traffic Signals 26622786 -- 589 176 900160 5,1235,1501,391 1,0606,7996,7991,391 15,17913,79213,98414,57328,972 Pump Water 144,686 115,715 173,833 -- 106108 956 2,4903,4576,055 7,8238,779 23,557 44,55544,661 59,128 59,128 12,094 12,094 224,167119,944121,611145,168269,831 Primary 2,053,025 1,708,9142,328,910 GS Demand 3,0078,7633,6093,060 GS 30,92621,19329,42953,682 17,67027,14044,81127,317 348,466270,930274,696200,530475,226100,640103,648133,560142,322796,932 Demand 2,656,497 3,275,893 4,126,508 11118686 -- 589 589 265 265 128128772772 5,632 42,93848,571 Street 104,380 102,615 153,037 Lighting 095 16,82516,82561,26761,26749,02549,02510,09510,59,28417,11982,325 187,253560,954560,954698,166158,728 Service General 1,614,759 1,427,506 2,471,653 26 of 35 729729437437741 3,3593,3592,1232,1232,5673,5656,874 18,69524,29324,29330,942 Non 142,522161,218199,033 Profit Electric Utility City of Port Angeles 765765306778 849849306 Rate Requirement Summary 4,764 1,7972,4965,071 2,2292,229 36,31841,08217,00517,00521,15567,309 25% Disc Residential 978978 2,4462,4462,7152,7157,1267,1265,7452,4887,978 15,22854,35854,35867,62316,211 116,093131,321215,155 35% Disc Residential 427 45,76845,768 712,506 114, 114,427 268,785 116,426 373,249 758,460 127,020127,020333,410333,410 6,144,2172,543,2843,163,908 5,431,7112,543,284 10,066,584 Residential 26,39340,80261,203 404,666 410,291 150,318 138,755 289,073 223,654 250,046 361,924 140,748 502,672 102,615199,487403,448602,935102,005 3,443,0691,532,3203,425,1603,835,4505,182,1251,005,343 Total 11,681,47817,061,53223,249,000 Dollars Alloc IndustrialTotal EnergyDemand (TCP)Demand (NCP Max)Weighted CustDemand (NCP Substation)Substation WeightingDemand (Meters)Meter CostsMeter ReadingBillingCS Total EnergyStreet LightingDemand (NCP Sec)Cust SecDemand (NCP Sec)Services EnergyIndustrial TransPower DistrDemandTotalDemandCustomerDemandCustomerDemandCustomerDemandCustomerDemandCustomerTotalMeter ReadingBillingCustomer ServicesTotal Purchased PowerDistribution System LinesSubstations Customer Services Grand Total MeteringStreet LightingTransformerServices C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5COS Exp - 5.49 2:00 PM 22.9028.38 5/1/2019 0.0396 75% - 5.49 22.9028.38 0.0396 Rate 77 77 77 Base TotalUnits 1,231,956 4,354,834 1,005,343 1,038,670 13,213,79819,805,931 4040 ---- 5,071 41,08221,15567,309 Other Dollars - - - - - Other kWhCustomerCustomerCustomer 0%0% - - 177 100%100% 3,6923,869 Traffic Signals Res-Discount 25%EnergyDemandDistributionCustomer --- 776176 4.76 24.60 19.84 0.0343 41,988 30,94230,942 65% 698,166 130,894173,833698,166 Pump Water Includes Gov ---- 4.76 6,05519.8424.6075.8410.4286.2589.6510.4289.6510.42 24,6200.03430.05270.0527100.060.0527100.06 365,155 RateRateRateRate 1,933,081 2,328,910 Primary GS Demand 202020191919 284 284284216216216 BaseBaseBaseBase 53,682 GS 824,813243,049347,321 UnitsUnitsUnitsUnits 3,004,9644,126,508 3,830,938 2,084,3838,816,432 Demand 86 ----- 2,5002,375 48,57167,62316,21118,20126,99618,31720,43941,131 104,380153,037131,321215,155109,924130,625464,954232,363724,313 27 of 35 Street DollarsDollarsDollarsDollars Lighting - 698,166158,728 Service General 1,614,759 2,471,653 Electric Utility kWhCustomerCustomerCustomerkWhCustomerCustomerCustomerkWhCustomerCustomerCustomerkWhCustomerCustomerCustomer City of Port Angeles - 6,874 30,942 161,218199,033 Non Profit emand nergy Rate Requirement Summary - Pre-Tax Res-Discount 35%EnergyDDistributionCustomer Non Profit 3 Phase EnergyDemandDistributionCustomer General Service 3 Phase EDemandDistributionCustomer Municipal 3 Phase EnergyDemandDistributionCustomer ---- 5,07175.8489.6589.65 41,08221,15567,309 x 2.5x 2.5x 2.5 25% Disc Residential ----- 7.32 37.8435.86 30.5330.3410.4240.7510.4246.2735.8610.4246.27 67,623 16,211 0.0527 0.05270.05270.0527 RateRateRateRate 131,321215,155 35% Disc Residential 353535595959 - 976 976 976 BaseBaseBaseBase 8,6378,6378,637 758,460972,617813,679 6,144,2173,163,908 UnitsUnitsUnitsUnits 10,066,584 20,641,568 116,506,392 Residential ---- 4,3747,374 51,29312,74168,40842,91125,38875,673 758,460 419,975 121,983 Total 1,231,9564,354,8341,005,3436,144,2173,163,9081,088,5781,630,536 Dollars DollarsDollarsDollarsDollars 13,213,79819,805,93110,066,584 CustomerCustomerCustomerCustomer kWhkWhCustomerCustomerkWhCustomerCustomerCustomerkWhCustomerCustomerCustomer Customer EnergyDemandDistributionCustomer Residential EnergyDemandDistribution Non Profit 1 Phase EnergyDemandDistributionCustomer General Service 1 Phase EnergyDemandDistributionCustomer Municipal 1 Phase EnergyDemandDistributionCustomer C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5PreTax Rate 1 2:00 PM 5/1/2019 Inc Gov - 3.74 3.74 19.7163.07 0.0527100.97120.670.0527319.52 256.45 RateRateRate n/an/an/an/a 88 - - - - 171171 BaseBaseBase 97,6800.05243.93027.9096 185,379 34.2617 Rate Total UnitsUnitsUnits 1,231,9564,354,7941,005,343 13,213,79819,805,89147,248,57036,655,000 4040 ------ 6,055 40,43924,62060,90060,90060,900 692,997207,185365,155 2,491,756 3,432,377 1,933,081 2,328,910 1,231,956 4,354,794 1,005,343 3,443,069 Other DollarsDollarsDollarsDollars 13,213,79819,805,89123,309,860 ----- 10,59210,592 313,455 Units Other 252,160,000 kWhkWCustomerCustomerkWhWt CustCustomerkWhCustomerCustomerCustomer Customer -- 177 3,6923,869 Traffic Signals GS Demand 3 Phase EnergyDemandDistributionCustomer GS Primary EnergyDemandCustomer Yard Lights EnergyDemandDistributionCustomer Summary EnergyDemandDistributionCustomerYard LightsIndustrial Transmission Distribution 776176 41,988 100.97 x 2.5 130,894173,833 Pump Water --- 3.74 3.74 1.64 1.64 6,05519.7160.0919.71 40.39 24,620 0.05270.0527100.97120.670.0527 365,155 RateRateRateRate 1,933,081 2,328,910 Primary GS Demand n/an/an/an/a 999 41411212 ---- BaseBaseBaseBase 53,68219,16415,00170,000 GS 824,813243,049 UnitsUnitsUnitsUnits 3,004,964 4,126,508 4,783,430 4,611,179 Demand 86 ------ 177 9,6962,8383,6923,869 48,57171,64119,87056,07914,539 104,380153,037252,265353,472243,180316,636 3,443,069 3,443,069 28 of 35 Street DollarsDollarsDollarsDollars Lighting - Electric Utility 698,166158,728 Service General 1,614,759 2,471,653 City of Port Angeles kWhkWCustomerCustomerkWhkWCustomerCustomerkWhCustomerCustomerCustomerkWhCustomerCustomerCustomer - 6,874 30,942 Rate Requirement Summary - Pre-Tax 161,218199,033 Non Profit GS Demand 1 Phase EnergyDemandDistributionCustomer Municipal GS Dem 3 Phase EnergyDemandDistributionCustomer Traffic Signals EnergyDemandDistributionCustomer Industrial EnergyDemandDistributionCustom er - 9.35 5,071 41,08221,15567,309100.97 x 2.5 25% Disc Residential ------- 0.363.743.747.32 40.3919.7160.0932.3239.64 67,62316,211 0.0527 434.91 435.28 0.0527 0.0527 RateRateRateRate 131,321215,155 35% Disc Residential 3322333 20 20 20 -- BaseBaseBaseBase 1,096 11,232 758,460921,000336,821 6,144,2173,163,9082,482,000 UnitsUnitsUnitsUnits 10,066,584 Residential 86 - - - - - - 709 776 176 4,0961,454 48,57117,76324,02341,988 104,380153,037130,894173,833 Total 1,231,9564,354,8341,005,343 DollarsDollarsDollarsDollarsDollars 13,213,79819,805,931 kWhCustomerCustomerCustomerkWhkWCustomerCustomerkWhkWCustomerCustomerkWhCustomerCustomerCustomer EnergyDemandDistributionCustomer Street Lighting EnergyDemandDistributionCustomer Municipal GS Dem 1 Phase EnergyDemandDistributionCustomer Water Pumps EnergyDemandDistributionCustomer Other EnergyDemandDistributionCustomer C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5PreTax Rate 2 2:00 PM 5/1/2019 Rate rev calc0.118020.118020.118020.156620.127560.061010.036940.140150.089160.160500.051880.087640.11107 #DIV/0! 0.010200.006630.007650.010200.010200.006140.006140.010200.006140.010200.010200.006140.00614 Rate 25,943,725 vol calc #DIV/0! w/o Mun - 70,000 921,000 Vol 3,830,9381,038,6703,057,0001,161,0004,948,0002,482,000 29,458,00052,032,00036,655,00017,518,000 116,506,392269,678,000241,539,330 - 70,000 779,002921,000 2,490,1103,057,0001,161,0004,948,0002,482,000 29,458,00052,032,00036,655,00017,518,000 Alloc Vol 116,506,392268,077,504 240,198,502 - 430 7,9447,1275,653 25,39231,17330,37315,236 300,391 530,584 373,781 178,636 Tax 1,188,0462,694,765 - 428 4,7667,1035,634 15,23418,70230,27015,184 712,743180,213318,313 224,242107,169 6.00% 1,639,090 1,640,000 1,640,034 City Ut Tax - 4,546 79,090 252,813233,870137,248179,823400,284204,259 2,767,0134,448,4762,736,5334,045,700 11,828,512 27,318,165 City tax base 1 52 16 64 24 19 52 - 612103762364 2,4211,0815,5705,5706,2204,317 380,141130,341170,774193,981879,554 1,640,000 1.50% B&O Tax Factored ------ (210) 3,162 3,869 10,10712,40871,10324,02375,67341,131 472,882119,566211,190148,777980,500316,636457,463153,037173,833788,202 974,930958,165969,804 3.873% Refuse Tax close enough 32 9 12591920 (10)- (294)(386)(859)(438) 74,136 236,979219,222169,863 2,593,712 4, 2,565,1413,792,314 29 of 35 Subtotal 11,087,68024,737,060 11,324,659 Rounding Tax Test 62 - 2019 Budget 1.50% 3,4371,0753,1791,8662,4445,4412,7775,570 37,61360,470 37,19954,995 160,791371,350 Electric Utility Service Tax and Customer Rates CITY of PORT ANGELES - 804 2,5702,378 4,317 28,12945,22327,81941,128 130,341170,774380,141268,300 120,248193,981 Deduct 1,147,854 City SalesGS Demand Municipal Single PhaseMunicipal Three Phase General Service Municipal Single PhaseMunicipal Three PhaseStreet LightsWater PumpTraffic Signals - 192 3,335 9,861 5,787 7,582 8,613 10,66016,878 116,674187,575 498,762 115,389170,591 1,151,900 Not Taxable remaining - 244 4,2407,3589,641 13,554 12,539 21,461 10,951 68,30080,000 634,180148,352238,503146,718216,908879,554120,000 1,464,6501,147,854 Allowed Deductions Non Rate Rev -- 4,3173,000 75,110 21,50090,000 240,091222,101130,341170,774380,141193,981693,200241,600102,600 2,627,7774,224,6292,598,8303,842,1211,151,900 1.1159 11,233,302 25,943,515 Non-Tax Factored Reductions - 3,8691,500 67,309 25,000 40,00090,00060,900 (68,300) 215,155199,033116,804153,037340,659173,833120,250102,000371,350 2,354,850 3,785,849 2,328,9103,443,069 Service 10,066,584 23,248,960 Revenue Rate Rev 81293 77552015 78 -- 284212 8,6371,1929,0003,0001,500 10,59315,00040,00021,50090,000 718,200120,250102,000241,600102,600 1,464,650 Total Tax Calculation Factors Customers Industrial ? Dollars ResidentialResidential Disc 35%Residential Disc 25%Non ProfitGeneral ServiceGeneral Service-MunicpalStreet LightingGS DemandGS Demand - MunicpalGS Demand PrimaryIndustrialWater PumpTraffic SignalsOther Non Rate Revenue Judgements & SettlementsPermitsRoad/Street Maint SvcsUncoll Amts RecoverdFeesInvestment InterestDelinquent InterestPole Contract RentalsInterdeptSale of Scrap & JunkMisc RevenuesConstruction ContributionAMI TransferFrom Fund BalanceYard LightingBad DebtsCity SalesPublic EntityConservation Initatives C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Taxes (2) 2:00 PM 5/1/2019 - 5.49 22.9028.38 0.03960.0076 75% 28.38 0.0472 Rate - 5.49 22.9028.38 0.03960.0076 7777 77 Base Units 1,038,670 1,038,670 - 7,944 5,071 41,08221,15575,252 Total Dollars 2,516,1291,231,9564,354,8341,005,343 13,213,79822,322,060 0%0% 4040 ---- 100%100% Other kWhkWhCustomerCustomerCustomer -------- 30,94230,942 698,166 698,166 Other Res-Discount 25%EnergyTaxDemandDistributionCustomer --- 430177 4.76 3,6924,29819.8424.6086.25 0.03430.0066 0.06290.0629100.060.0589100.06 65% Traffic Signals RateRateRate - - - 776 176 24.60 75.84 89.65 89.65 10.4286.2510.4210.42 15,23641,9880.04090.05270.01020.05270.01020.05270.0061 100.06100.06 Pump 130,894 189,069 Water Rate 202020191919 - 216216216 Base BaseBase 4.76 6,055 19.84 24.60 24,6200.03430.0066 373,781365,155282,808282,808 UnitsUnitsUnits Primary 1,933,0812,702,6901,111,6361,111,6366,819,4116,819,411 GS Demand --- 284284 284 Base 2,500 1,736 2,375 53,682 58,625 11,33618,201 69,53926,996 14,914 20,439 90,66139,465 GS 30 of 35 560,957824,813243,049359,636232,363688,535 Units DollarsDollarsDollars 3,004,9643,830,9383,830,938 Demand 4,687,465 86 -- 5,653 48,571 25,392 67,623 16,211 104,380158,690131,321240,547 Street Dollars Lighting kWhkWhCustomerCustomerCustomerkWhkWhCustomerCustomerCustomerkWhkWhCustomerCustomerCustomer - 307,518698,166 158,728 Service General 1,614,759 2,779,171 Electric Utility kWhkWhCustomerCustomerCustomer Non Profit 3 Phase EnergyTaxDemandDistributionCustomer General Service 3 Phase EnergyTaxDemandDistributionCustomer Municipal 3 Phase EnergyTaxDemandDistributionCustomer City of Port Angeles ---- 6,87475.8489.6589.65 Rate Requirement Summary 31,17330,942 Non 161,218230,206 x 2.5x 2.5x 2.5 Profit Res-Discount 35%EnergyTaxDemandDistributionCustomer - 7,9445,07137.8440.7546.2746.27 41,08221,15575,2520.06290.06290.06290.0589 25% Disc Residential RateRateRateRate - - - - - 7.32 30.5337.8430.3410.4240.7535.8610.4246.2735.8610.4246.27 25,39267,62316,2110.05270.01020.05270.01020.05270.01020.05270.0061 131,321240,547 35% Disc Residential 353535595959 - 976976976 BaseBase BaseBase 8,637 8,637 8,637 758,460878,192878,192 6,144,2171,188,0463,163,9081,945,3641,945,364 UnitsUnitsUnitsUnits 11,254,63122,638,58922,638,589 116,506,392116,506,392 Residential ---- 4,3745,3917,374 19,83712,74146,31325,38884,466 758,460102,593139,545230,852419,975121,983 Total 2,516,129 1,231,956 4,354,834 1,005,3436,144,2171,188,0463,163,908 1,193,8951,966,705 DollarsDollarsDollarsDollarsDollars 13,213,79822,322,060 11,254,631 kWhkWhCustomerCustomerCustomerkWhkWhCustomerCustomerCustomerkWhkWhCustomerCustomerCustomerkWhkWhCustomerCustomerCustomer EnergyTaxDemandDistributionCustomer Residential EnergyTaxDemandDistributionCustomer Non Profit 1 Phase EnergyTaxDemandDistributionCustomer General Service 1 Phase EnergyTaxDemandDistributionCustomer Municipal 1 Phase EnergyTaxDemandDistributionCustomer C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Rate 1 2:00 PM 5/1/2019 3.743.74 0.0627120.670.0629319.52 RateRateRate ------ 3.74 3.74 63.07 19.71 100.97256.45 0.05270.0100120.670.05270.0102319.52 88 ----- 171171 BaseBaseBase 97,6800.05240.01003.93027.9096 185,379 Rate 34.2617 UnitsUnitsUnits 42,923,26042,923,26036,655,00036,655,000 - - -- 6,055 24,62060,900 40,43960,90060,900 427,971692,997207,185373,781365,155 2,263,6511,933,0812,702,6904,354,7943,621,705 3,632,244 2,516,129 1,231,956 1,005,343 DollarsDollarsDollarsDollars 22,322,020 26,004,625 13,213,798 10,592 10,592 313,455 Total Units 2,516,1291,231,9564,354,8341,005,343 13,213,79822,322,060 252,160,000252,160,000 kWhkWhkWCustomerCustomerkWhkWhWt CustCustomerCustomerkWhkWhCustomerCustomerCustomer 4040 ---- Other TaxDemandDistributionTaxDemandDistributionTaxDistributionYard LightsIndustrial Transmission GS Demand 3 Phase EnergyCustomer GS Primary EnergyCustomer Yard Lights EnergyDemandCustomer Summary EnergyTaxDemandDistributionCustomer ------- x 2.5 Other 100.97 -- 430177 3.743.741.64 3,69260.09 4,298 0.06270.0608120.670.0589 Traffic Signals RateRateRate - - - - - - - - 776 176 3.74 3.74 1.641.64 40.3919.7160.0919.71 15,23641,9880.05270.01000.05270.0081100.97120.670.05270.0061 130,894189,069 Rate Pump Water 999 41411212 ----- BaseBaseBaseBase 6,055 24,62019,16415,00170,00070,000 373,781365,155 UnitsUnitsUnitsUnits Primary 1,933,0812,702,6903,012,1593,012,159 10,291,54210,291,542 GS Demand ----- 430177 31 of 35 9,696 2,838 3,692 4,298 71,641 19,87024,298 14,539 53,682 GS 542,747102,613746,567158,853256,607 560,957824,813243,049178,636 DollarsDollarsDollarsDollars 56,078.78 Demand 3,004,9644,687,4653,443,0693,621,705 86 - 5,653 48,571 104,380158,690 Street Lighting kWhkWhkWCustomerkWhkWhkWCustomerCustomerkWhkWhCustomerCustomerCustomer CustomerCustomerkWhkWhCustomerCustomer - 307,518698,166158,728 Service Electric Utility General 1,614,7592,779,171 GS Demand 1 Phase EnergyTaxDemandDistributionCustomer Municipal GS Dem 3 Phase EnergyTaxDemandDistributionCustomer Traffic Signals EnergyTaxDemandDistributionCustomer Industrial EnergyTaxDemandDistri butionCustomer City of Port Angeles -- Rate Requirement Summary 6,874 Non x 2.5 31,17330,942100.97 Profit 161,218230,206 - - 3.74 3.74 7,9445,07160.0939.64 41,08221,15575,2520.0589435.280.06080.0589 25% Disc Residential RateRateRateRate - - - - - - - - 0.36 3.74 3.74 7.32 40.3919.7160.0932.3239.64 25,39267,62316,2110.05270.0061434.91435.280.05270.00810.05270.0061 131,321240,547 35% Disc Residential 3322333 202020 --- BaseBaseBaseBase 1,096 11,232 758,460921,000921,000753,040753,040 6,144,2171,188,0463,163,9082,482,0002,482,000 UnitsUnitsUnitsUnits 11,254,631 Residential 86 - - - - - - - 709 776 176 5,6536,0751,454 48,57139,71352,04715,23641,988 104,380158,690130,894189,069 4,096.24 Total 2,516,1291,231,9564,354,8341,005,343 DollarsDollarsDollarsDollarsDollars 13,213,798 22,322,060 kWhkWhCustomerCustomerCustomerkWhkWhkWhCustomerCustomerkWhkWhCustomerCustomerCustomerCustomer kWhkWhCustomerCustomer EnergyTaxDemandDistributionCustomer Street Lighting EnergyTaxDemandDistributionCustomer Municipal GS Dem 1 Phase EnergyTaxDemandDistributionCustomer Water Pumps EnergyTaxDemandDistributionCustomer Other EnergyTaxDemandDistributionCustomer C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Rate 2 2:00 PM 5/1/2019 0.06290.04090.04720.06290.06290.06290.06290.05890.0589 0.0627 0.0627 0.0608 0.0608 0.0629 Energy 3.743.743.743.743.74 COSA Demand 32 of 35 37.8424.6028.3840.7586.2546.2746.2760.0960.09 100.06100.06120.67120.67319.52 Base 0.08090.05260.06070.07980.07980.07640.07640.07640.07640.05410.05410.05410.0541 Energy varies 5.2 4.624.62 4.624.62 2019 Demand Electric Utility Rate Comparison City of Port Angeles 20.1013.0715.0824.9062.2325.8464.6125.8464.6154.3454.34 Base 135.91135.91331.49 ResidentialResidential 35% DiscResidential 25% DiscNon Profit 1 PhaseNon Profit 3 PhaseGeneral Service 1 PhaseGeneral Service 3 PhaseGS Municipal 1 PhaseGS Municipal 3 PhaseGS Demand 1 PhaseGS Demand 3 PhaseGS Dem Municipal 1 PhaseGS Dem Municipal 3 PhaseGeneral Service Primary C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Compare 2:00 PM 5/1/2019 15.01% 25,879,300 2018 rates - 250 9,0002,0003,0001,500 15,000 80,000 20,000 40,00021,50090,00040,20012,50020,350 718,200 120,000241,600102,600 834,000 108,000 510,100 483,700 980,500 741,800 (131,650)(131,650) (152,000) 2019 2,116,1001,356,7001,640,0001,059,3001,050,000 COSA 25,869,50027,334,15016,532,90027,465,800 - 9,0002,0003,0001,500 90,00014,00080,00020,00040,00021,50090,00093,50034,00012,500 718,200 180,000 109,400 836,100 570,100 485,000 850,500 951,900 742,500 (152,000) 2018 2,120,4001,323,6001,441,5001,073,700 Budget 22,493,80023,872,40013,489,10024,024,400 33 of 35 AMI Transfer - - 250 1,3161,8093,177 14,025 10,641 73,073 21,230 40,90999,93416,75071,291 978,753 116,687 168,024111,989 113,594 732,388 439,787 731,365 896,022 742,743 167,814 625,000 2017 1,887,5791,346,9761,521,4911,067,1143,214,429 Actual 23,971,18925,740,17412,292,99822,525,745 250 9,3631,930 4,2727,4149,104 14,02511,34570,99314,74033,80342,21167,18073,800 11,391 122,983 713,466 468,722 511,973 874,912 733,359 102,233111,006233,196 2016 1,000,6231,876,2521,669,2581,048,4601,856,1071,072,181 1,750,000 Actual 29,185,94730,977,72118,252,947 29,905,540 11 250 7,8722,7249,199 14,025 72,185 23,540 27,600 79,66714,96085,23235,00070,50656,500 111,294 100,521102,676 710,883 401,123 579,383 942,574 797,127 876,218 300,000 2015 1,225,1731,867,3551,521,0051,311,0881,833,4311,026,236 Actual 29,141,80631,044,53518,741,90730,018,299 2019 Budget Electric Utility - 250 CITY of PORT ANGELES 9,4001,205 5,9346,354 with Industrial Transmission 14,02578,63819,14845,409 80,548 10,672 30,000 84,613 25,000 101,839 123,060 100,140149,224708,742501,834863,173768,344236,893519,200 Revenue & Expenditure Summary 2014 1,032,390 1,948,6121,606,5211,311,6662,202,3961,150,0491, Actual (1,405,197) 34,231,19936,033,082 24,504,88337,438,279 Rate RevenuesNon-Rate Revenues:Judgements & SettlementsTelecable PermitsElectrical PermitsGrantsRoad/Street Maint SvcsUncoll Amts RecoverdService & Hookup FeesConnection FeesPlan Checking FeesInvestment InterestDelinquent InterestPole Contract RentalsInterdeptSale of Scrap & JunkMiscellaneous RevenuesConstruction ContributionOther - Fund IncreasesMisc TransfersTotal RevenueCash Operating Expenses: Salaries & Wages Personnel Benefits Supplies Purchased Power Material/Tools Administrative Charges Contractual Services Taxes City Utility Taxes Miscellaneous Debt Service Capital Intrafund Transfer Transfers InterdepartmentalTotal ExpendituresDifference RevenuesExpenses/Expenditures C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Rev Requirement with IT 2:00 PM 5/1/2019 44 60 422308946 5,915 10,85450,55917,05719,57114,73114,93530,71757,33658,06327,56060,900 213,651228,398205,848133,355580,134172,573344,011115,572106,995254,407508,488984,566244,247,340673,911367,732202,028 2,768,012 2,094,922 1,223,832 9,980,955 3,848,800 Total 10,098,68911,861,114 25,869,50425,869,500 21,959,80425,808,604 Dollars ---------------------------- 43,02674,36856,72294,382 KW 655,495 152,086 124,925 186,347 164,679 Dollars 1,552,029 1,552,029 Budget ------------ 789 5,747 75,61488,70049,58444,12923,218 183,436154,997426,092152,418267,687243,949377,213786,285178,456138,280505,254283,312868,785157,642 KWH Dollars 2,095,564 1,865,153 7,594,428 8,341,518 9,719,393 17,313,821 IndustrialTotal LightingTotal 4460 422 046157 7,8251,9566,3509,1317,7525,9153,9784,342 1,956 16,95444,96210,85450,55920,15517,05719,57139,95818,29510,45814,93511,93424,97014,67884,42013,93444,386 14,731 213,651229,769133,355 952,233 355, 34 of 35 Base 1,639,436 2,141,7213,093,954 Dollars 4.624.624.624.624.145.205.054.625.20 KW Rates 0.07640.05410.07640.07640.05410.08210.07640.07980.04820.04480.07190.08210.05410.07640.04480.08090.08090.08090.06070.05260.08090.0526 0.05410.0541 KWH Rates 3.645.00 54.3425.8464.6154.3425.8464.6154.3425.8464.6154.3425.8464.6135.1324.9062.2325.8461.6120.1020.1020.1015.0813.0720.1013.07 Base 135.91 135.91 135.91 166.49 132.30 331.49 380.44 231.20 135.91 331.49 Rates ---------------------------- 2019 Budget 9,313 16,09730,17535,83611,23220,42931,669 32,919 KW 329,552329,552 141,882 3 yr Ave City of Port Angeles ------------- Revenue Based on 2018 Rates 000 15,000 70,000 921,000649,000727,000287,000 525,142,000472,000 2,401,0002,865,0007,876,0001,995,0004,948,0001,161,0003,057,0007,826,0001,343,0002,556,0003,502,0002,997,000 KWH 38,735,000 24,413,000 17,551,000 11,278,000 10,739,000 130,784,000 103,109,000 121,376,000252,160,000 3 yr Ave 3.003.001.001.001.004.003.002.009.009.008.001.001.00 26.0014.0012.0031.0065.0022.0012.0020.0059.0019.0035.0020.0025.0077.0018.00 131.00145.00741.00172.00350.00283.00 1,472.00 6,797.00 1,594.008,998.00 3 yr Ave Accounts10,592.00 BDSPBDTPBaseBase3BaseBaseBase3BDSPBDTPBaseBase3BDSPBDTPBaseBaseBase3CMRAMEMSWAPSBaseBase3BDTPBaseBaseKWHSKWHWKWLSKWLWBaseBDTPBaseBase3BaseBaseBaseBaseBaseBaseBaseBase D MUNICIPAL DEMAND CD COMMERCIAL DEMANDCM COMMERCIAL MULTI FAMCN COMMERCIAL MULTI DEMCO COMMERCIALGD GOVERNMENT DEMANDGO GOVERNMENTMMS MUNICIPAL STREET LIGMU MUNICIPALNP NONPROFITPD PRIMARY METEREDPM PRIMARY SERVICERW MUNICIPAL WATER PUMP WUGA CD COMMERCIAL DEMANDCO COMMERCIALPM PRIMARY SERVICE Subtotal Change %RD RESIDENTIAL DUPLEXRM RESIDENTIAL MULTI FAMILYRS RESIDENTIAL SINGLE FAMILYD5 LOW INCOME 25% DISCD6 LOW INCOME 35% DISC WUGA D6 LOW INCOME 35% DISC SubtotalChange %Grand TotalChange % TS MUNICIPAL TRAFFIC SI C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 52019 Rev with IT 9:13 AM 5/2/2019 5.205.635.166.00 varies 331.490.0629184.890.0479115.830.0515 277.67 contract GS Primary 4.625.636.30 135.910.0541105.920.0627115.000.0524 GS Demand 3 4.625.633.325.506.30 54.3454.1970.0060.0057.00 0.05410.06270.05900.08520.0524 GS Demand 1 1 of 1 --- 64.6187.0672.9134.0053.00 0.07640.06290.07360.10070.0731 GS Phase 3 --- PA - COSA PA - Budget Jefferson PUD 25.8441.0736.4518.5030.00 Clallam Co PUD 0.07640.06290.07360.10070.0731 City of Ellensburg Electric Utility Rate Comparison GS Phase 1 City of Port Angeles --- 20.1037.8433.1418.5028.00 0.08090.06290.07400.08820.0737 Residential BaseDemandEnergyBaseDemandEnergyBaseDemandEnergyBaseDemandEnergyBaseDemandEnergy C:\\Users\\gking\\Desktop\\Copy of Electric - COSA - 2019 Budget-2024 final 5Rate Compare