The URL can be used to link to this page

Home My WebLink AboutAgenda Packet 02/27/2019 City Council / Utility Advisory Committee Joint Meeting City Council Chambers Port Angeles, WA 98362 February 27, 2019 3:00 p.m. AGENDA I. Call To Order II. Roll Call III. Approval Of Minutes for November 13, 2018 IV. Late Items V. 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). VI. Discussion Items: VII. Information Only Items: A. Community Solar Project Update B. Water Cost-Of-Service-Analysis (COSA) presentation VIII. Next UAC Meeting Date: March 12, 2018 IX. Adjournment UTILITY ADVISORY COMMITTEE City Council Chambers Port Angeles, WA 98362 November 13, 2018 3:00p.m I.Call To Order Vice Chair William Atkinsoncalled the meeting to order at 3:00pm. II.Roll Call UAC Assigned Councilmembers Present:Deputy Mayor Kate Dexterand Councilmember Michael Merideth (alternative for Lindsey Schromen-Wawrin) Councilmembers Absent:Councilmember Cherie Kidd UAC Members Present:Vice Chair WilliamAtkinson, Mattias Järvegren, Rob Feller, and Paul Collins UAC Members Absent: Laura Dodd Staff Present:Gregg King, Shailesh Shere,Nathan West, James Burke, and WilliamBloor Others Present: III.Approval Of Minutes Vice Chair William Atkinson requested that the October 9, 2018 minutes be amendedto reflect his abstention on the 2019 utility rates.The minutes will reflect 3 ayesand 1 abstention. Councilmember Kate Dexterrequested a motion for approval of the October 9, 2018 Minutesas amended.William Atkinsonseconded the motion. Motion carried 6-0. IV.Late Items:Vice Chair William Atkinson proposed discussing attendance of the committee members. Some members had been absent of late and Mr. Atkinson made a motion to summarize the attendance of all members over the last twelve months. Other members pointed out this information was already available in the minutes. The motion died for lack of a second. V.Public Comment: None pg 2 VI.Discussion Items: A.Community Solar Project ShaileshShere, Deputy Director of Power Systems, reported that an RFP for a community solar project was issued and two (2) proposals were received. The proposals called for a third party to finance, construct, and operate the project. The City would purchase the output under a powerpurchase agreement (PPA) and offer to Port Angeles residents at a green power rate. The residents would then be eligible for a state subsidy.Discussion followed. Councilmember Kate Dextermade a motion that the UAC forward a favorable recommendation to the City Council to approve City staff to review and evaluate the submitted proposals.Mattias Järvegrenseconded. Motion carried 6-0 VII.Next Meeting Date: December 11, 2018 VIII.Adjournment:4:57p.m. ___________________________ __________________________________ Chair Cherie Kidd Gregg King, Power Resources Manager pg 3 UTILITY ADVISORY COMMITTEE MEMO Date: February 12, 2019 To: Utility Advisory Committee From: Gregg King, Power Resource Manager Subject: Community Solar Project Update Summary:The community solar projectwill not be moving forward due to sensitive time restrictions for implementing the project. Funding:N/A Recommendation:Information only. Background / Analysis: Port Angeles received two proposals to plan, construct, and operate a community solar program. However, due to the sensitive time restrictions set forth by the State, the City will not be moving forward with the Community Solar Project. Funding Overview: N/A pg 4 UTILITY ADVISORY COMMITTEE MEMO Date: February 12, 2019 To: Utility Advisory Committee From: Glen Goodworth, Senior Accountant Subject:Water Cost 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 Water COSA 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 decision was made to adjust water rates for the residential customers only. This was designed to bring those rates more in line with the calculations made in the Water COSA model. The offer was made to present the COSA model to the City Council early in 2019 so that a greater understanding of the process could be achieved, leading to more informed and involved rate setting. This presentation will first, create an understanding of basic COSA and rate setting principles, and second, review the 2019 Water COSA model. Funding Overview:N/A pg 5 , the city is required by Water Utility Whether you use it or not The City of Port Angeles Explanation of Base Rate Charges Having a water meter essentially reserves the amount of water in our system that your meter is capable of carrying. state regulations to provide you with that capacity and your account is charged accordingly….The BASE RATE CHARGE is for reservation of capacity which means that you havereserved use of a given amount of water based on your meter size. All premises, whether occupied or vacant, shall be charged a base rate, based on meter size, for reservation of capacity. - from The City of Port Townsend - Utility Services explanation 11:01 AM 2/28/2019 Port of Port AngelesBHGAH PA LLCClallam TransitParks DepartmentFiero Marine Life CenterJefferson ElementaryPort Angeles Golf CourseClallam County RoadSuper 8 MotelHousing AuthorityIvy Hut RealityOlympic LodgeHamilton ElementaryDays InnN Olympic Peninsula SkillsHousing AuthorityHousing AuthorityWilliam Shore Memorial PoolAngeles CompositeAngeles CompositeOlympic Medical CenterWastewater DeptWalMartPort of Port AngelesPort of Port AngelesMcKinley 3" Meter Size 801 Boathaven Dr221 N Lincoln St830 W Lauridsen Blvd1901 L St315 N Lincoln218 E 12th St824 S Lindberg Rd1033 W Lauridsen Blvd2104 E 1st St401 E 5th St2215 S Chase St140 Del Guzzi Dr1822 W 7th St1510 E Front St905 W 9th St114 E 6th St323 E 2nd St225 E 5th St1010 W 18th St (2140 Bldg)1020 W 18th st (2140 Bldg)907 Georgiana St1700 A St3471 E Kolonels Way1225 Marine Dr439 Marine Dr1902 Marine Dr 2 of 6 Water Utility City of Port Angeles Customers by Meter Size AirportPort of Port AngelesOlympic Medical CenterOlympic Medical CenterPort Angeles High SchoolCoast GuardHousing AuthorityClallam County Court HouseDept of TransportationPort Angeles Golf CourseCivic FieldWastewater Treatment PlantClallam County PUDPeninsula CollegePuget Sound PilotFranklin Elementary SchoolOlympic National ParkK PlyAngeles CompositeAngeles CompositeClallam County PUDMcKinley 8" Meter Size6" Meter Size 4 " Meter Size 1402 Fairchild Airport Rd 1301 Marine Dr - billed as 1" meter939 Caroline St939 Caroline St Water304 E Park Ave99 Ediz Hook Rd2603 S Francis St315 S Lincoln1712 B St824 S Lindberg Rd307 S Race St1509 Columbia St300 N Baker St1502 East Lauridsen Blvd305 Ediz Hook Rd2505 S Washington St600 E Park Ave435 Marine Dr1030 W 18th St (2140 Bldg)1040 W 18th St (2138 Bldg)75 Round Tree Rd1902 Marine Dr G:\\CNCLPKT\\PACKET ITEMS\\2019\\022719\\Part 3 Presentation apendixComm Meters 11:01 AM 2/28/2019 0.023130.07351 Rate 344,389 5,989,3616,333,750 3 of 6 Dollars 1,398,9735,757,331 45,848,05414,887,34028,470,73496,362,43281,475,092 Water Utility City of Port Angeles Impact of Consumption only rate ConsumptionResidentialPUDCommercialMunicipalIrrigationTotalWithout PUD G:\\CNCLPKT\\PACKET ITEMS\\2019\\022719\\Part 3 Presentation apendixRate Calc 18.4%46.3% 11:01 AM 2/28/2019 0.5% 38.1% 119.18147.24 100.63 Total 0.1%6.2% -0.6% 65.67 66.03 90.71 19.48 19.88 36.98 -60.5% Total Consumption 7.527.67 37.93 37.72 15.00 51.75 51.83 54.99 17.20 16.07 16.39 36.76 TotalTotal Dollars Consumption Consumption Dollars 5.185.29 15.00 19.00 19.40 54.99 25.41 25.93 73.51 25.41 25.93 73.51 DollarsDollars ConsumptionConsumptionConsumption Consumption ---- 32.7532.4332.7532.4332.7532.4339.6856.98 BaseBaseBaseBase 4 of 6 2019 Budget Residential Water Rate Options 0.073510.025410.025930.073510.032130.032780.073510.039520.07351 0.025410.025930.03873 City of Port Angeles ConsumptionConsumptionConsumptionConsumption RatesRatesRatesRates 0 --- 39.6856.98 32.7532.4332.7532.4332.7532.43 ase BaseBaseBaseB 204748 1,2342,003 UsageUsageUsageUsage MeterMeterMeterMeter 5/8 "5/8 "5/8 "1" ResidentialLow usage20192019 COSA2019 Consumption onlyResidentialMedium usage20192019 COSA2019 Consumption onlyResidentialHigh usage20192019 COSA2019 Consumption onlyResidentialLarge meter20192019 COSA2019 Consumption only G:\\CNCLPKT\\PACKET ITEMS\\2019\\022719\\Part 3 Presentation apendixResidential 11:01 AM 2/28/2019 2.8% -1.3% 12.6%21.4% -18.7%-26.5%-42.4% 173.0% 64.9952.8047.78 192.61190.02111.00254.43261.51308.75 1,076.651,212.402,938.99 TotalTotalTotalTotal 14.9417.2747.7834.7040.1396.52 111.00308.75 918.74111.62 DollarsDollarsDollarsDollars 1,062.512,938.99 ConsumptionConsumptionConsumptionConsumption ---- 50.0535.53 BaseBase 157.91149.89 Base 157.91149.89 Base 157.91149.89 5 of 6 0.022980.026580.073510.022980.026580.073510.022980.026580.073510.022980.026580.07351 ConsumptionConsumptionConsumptionConsumption 2019 Budget Commercial RatesRatesRatesRates - - - - Utility Rate Options 50.0535.53 City of Port Angeles 157.91149.89157.91149.89157.91149.89 BaseBaseBaseBase 650 1,5104,200 39,980 UsageUsageUsageUsage MeterMeterMeterMeter 5/8 "2"2"2" CommercialLow usage20192019 COSA2019 Consumption onlyCommercialLarge meter-High usage20192019 COSA2019 Consumption onlyCommercialLarge meter-Low usage20192019 COSA2019 Consumption onlyCommercialLarge meter-Ave usage20192019 COSA2019 Consumption only G:\\CNCLPKT\\PACKET ITEMS\\2019\\022719\\Part 3 Presentation apendixCommercial 11:01 AM 2/28/2019 -4.3%-3.0%-5.5%-4.2% 151.7%167.4%146.7% 131.8% 586.79561.62401.89389.91931.39801.89768.54 1,476.85 4,115.51 3,888.54 1,978.20 TotalTotalTotalTotal 11,005.42 500.64464.92315.74293.21931.39670.60622.75 DollarsDollarsDollarsDollars 1,476.85 3,730.77 3,464.59 1,978.20 11,005.42 ConsumptionConsumptionConsumptionConsumption ---- 86.1596.7086.1596.70 BaseBaseBaseBase 384.74 423.95 131.29 145.79 6 of 6 0.02492 0.02314 0.07351 0.02492 0.02314 0.07351 0.02492 0.02314 0.07351 0.02492 0.02314 0.07351 ConsumptionConsumptionConsumptionConsumption Irrigation 2019 Budget RatesRatesRatesRates - - - - Utility Rate Options 86.1596.7086.1596.70 City of Port Angeles 384.74423.95131.29145.79 BaseBaseBaseBase 20,090 12,670 26,910 UsageUsageUsageUsage 149,710 MeterMeterMeterMeter 1.5"1.5"4"2" IrrigationAve meter-high usage20192019 COSA2019 Consumption onlyIrrigationAve meter-high usage20192019 COSA2019 Consumption onlyIrrigationLarge meter-high usage20192019 COSA2019 Consumption onlyIrrigationMunicpal-high usage20192019 COSA2019 Consumption only G:\\CNCLPKT\\PACKET ITEMS\\2019\\022719\\Part 3 Presentation apendixIrrigation 1:25 PM 2/22/2019 Glen Goodworth - Senior AccountantGregg King - Power Resources ManagerJason Hart - Deputy Director Water and WastewaterJeff Young - Water Treatment Plant Superintendent 2019 Budget Basis Prepared by: Water COSA Model Actual model used in rate evaluations CITY of PORT ANGELES 1 of 19 G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingCover 1:25 PM 2/22/2019 2 of 19 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 competitiveConform to generally accepted rate setting techniquesBe cost based - COSAEncourage Economic Development/Conservation etc. Traditional Rate Setting Principles Financial PrinciplesCustomer RequirementsOther G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingPrinciples 1:25 PM 2/22/2019 Budgetdiff 982 1,692,9821,692,000 - - - - - - - - - - - - - - - - - - - - - - - 400 7.36% 1,600 44,13613,64521,00043,800 Admin 100.00% 124,582 - - - - - - - - - - - - - - - - - - 4.22% 3,198 8,313 1,948 9,194 8,928 9,204 9,204 8,251 1,957 1,238 Fire 10,07271,506 ------------- 9,5958,3131,9483,7142,7988,9519,7271,206 39.18% 10,17371,38110,592 101,496 100,407 102,784 101,928 118,258 663,271 Treatment ------------ 8,951 49.24% 51,17166,50610,17315,58190,64582,74380,35282,83282,83274,25763,29019,80915,85810,59255,12222,910 833,623 Distribution - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 0.00% Customer 100%100%100%100%100%100% Admin Percent 5%3%5% 10%10%10%10%10%10%10%10% Fire 5% 15%10%50%10%15%15%50%50%15% 100%100%100%100%100%100% Treatment 80%80%50%80%90%90%90%90%90%90%97%80%85%50%50%85%95% Distribution 3 of 19 Customer 2019 Budget 50.00%50.00%50.00%20.00%25.00%25.00%20.00%20.00%50.00%25.00% 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% Labor Cost Breakout City of Port Angeles 400.00 1,600.00 Total 83,131.9820,345.9244,136.3819,476.6491,936.2589,280.1092,035.8492,035.8482,507.6868,226.7699,043.4674,624.4989,507.5696,462.6421,000.0043,800.00 127,928.02100,716.72101,496.12100,406.76102,783.64101,928.29118,258.21130,493.96142,761.48105,921.74129,699.21 2,371,945.69 400.00 1,445.923,136.381,384.121,600.00 34,879.6114,368.5130,179.6928,584.2530,178.2533,862.2328,683.8428,683.8421,614.0630,434.4432,811.3230,610.4237,997.5942,230.8942,739.6512,207.8029,812.6125,789.5831,077.7228,250.6640,162.1032,152.802 1,000.0043,800.00 Benefits 740,078.28 ---------------------------- OT 41,000.0041,000.00 ----- 93,048.4168,763.4718,900.0018,092.5270,537.0363,352.0071,317.8755,417.8763,352.0063,352.0060,893.6269,972.3269,972.3271,317.8780,260.6288,263.0756,018.9669,230.8548,834.9174,844.0261,256.9089,537.116 4,309.84 Wages 100,021.83 1,590,867.41 111111111111111111111111 24 # Payroll System Employee AEmployee BBudgeted on CallBudgeted OvertimeLabor Seasonal WorkerEmployee CEmployee DEmployee EEmployee FEmployee GEmployee HEmployee IEmployee JEmployee KEmployee LEmployee MEmployee NEmployee OEmployee PEmployee QEmployee REmployee SEmployee TEmployee UEmployee V Other Benefits G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingLabor1 1:25 PM 2/22/2019 ------------- 400 (100)(100) 0.00% 4,4005,0003,2002,700 (1,000)(8,800) 11,700 Diff Fire (18,100)(16,300)(17,000) ---- 400 9,400 8,400 5,000 6,000 1,750 42.88% 41,30022,20012,80018,10071,70079,50041,40072,90010,00015,00015,00015,00067,750 115,500276,000769,600 2018 Treatment ----- 8,400 8,300 6,000 7,500 2,500 2,500 1,750 51.96%57.12% 24,72022,60017,20049,86089,04050,70044,60075,60010,00015,00030,00015,00090,250 391,020 Other Distribution ----------------------- 5.59%0.00% 8,240 33,80042,040 Customer Treatment -------- 400 8,240 5,540 42.46% 38,160 267,200319,540 Other BudgetBudget Customer Percent 60%40%90%70%60%50%50%50%50%50% 100%100%100%100%100%100%100%100% 4 of 19 Other Treatment Percent 20%40%50%50%50%50%50% 100%100%100%100% City of Port Angeles Admin, Professional Services 2019 Budget - Water Utility Treatment Distribution 20%60%10%30% 100%100% CustomerCustomer - 400 8,400 8,300 5,000 7,500 2,500 2,500 3,500 41,20022,60017,20055,40084,50044,60075,60020,00030,00015,00012,00030,00030,000 127,200267,200752,600158,000 20192019 Administrative Services City CouncilCity ManagerCustomer Com.Human ResourcesClerks OfficeRecordsFinance AdminAccountingCustomer ServiceRepographicsAttorneyPlanningFacility Maintenance Professional Services Technical Assistance-EngWater Quality LabPAWTP SecurityRanney Well PerformancePump EvaluationReservoir InspectionLeak DetectionArchaeological ServicesCrane ServicesCathodic ProtectionWater System Plan G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingAdmin ------- 4.8% 0.00 1:25 PM -15.0% 2/22/2019 -100.0%-100.0% 202520252035 168,471.63444,050.00612,521.63612,521.63 3,670,970.00 - 0.1%0.3% 0.00 -18.9%-40.4% 633.44 202420242034 17,513.40 179,577.63277,650.00457,227.63126,687.31127,320.75584,548.38412,080.00429,593.40429,593.40 4,115,020.00 -1.3%-0.2% -19.0%-40.6% 1,266.87 202320232033 34,254.15 190,199.63265,550.00455,749.63126,687.31127,954.18126,687.31583,703.81393,900.00428,154.15412,080.00428,154.15 4,392,670.00 0.1% -0.1% -18.0%-40.5% 1,900.31 202220222032 50,351.03 200,679.63262,000.00462,679.63126,687.31128,587.62253,374.62591,267.25378,750.00429,101.03805,980.00429,101.03 4,658,220.00 0.3% -9.4% -18.0%-40.4% 2,533.75 202120212031 65,804.03 210,715.63250,900.00461,615.63126,687.30129,221.05380,061.93590,836.68363,600.00429,404.03429,404.03 4,920,220.001,184,730.00 -7.0%-9.5%-0.3% 2035 -40.6% 3,793.60 202020202030 79,742.03 220,267.63238,800.00459,067.63189,329.72193,123.32506,749.23652,190.95348,450.00428,192.03428,192.03 5,171,120.001,548,330.00 5 of 19 Public Works Trust Fund Loans Debt Service Water Utility 2016 through -2.7%-2.7% -30.2%-40.4% Revenue Bonds & Revenue Refunding BondsRevenue Bonds & Revenue Refunding Bonds 5,053.47 93,195.23 201920192029 CITY of PORT ANGELES 231,801.63274,850.00506,651.63189,329.70194,383.17696,078.95701,034.80336,330.00429,525.23429,525.23 5,409,920.001,896,780.00 0.5% -0.1% -14.7% 6,313.33 201820182028 243,581.63281,500.00525,081.63189,329.71195,643.04885,408.65720,724.67113,263.63501,710.00614,973.63614,973.63 5,684,770.002,233,110.00 0.7% -1.1% -15.1% 7,573.19 201720172027 254,397.63270,400.00524,797.63189,329.70196,902.89721,700.52132,442.03479,460.00611,902.03611,902.03 5,966,270.001,074,738.362,734,820.00 -0.8% -15.7% 8,833.05 201620162026 265,053.63266,400.00531,453.63189,329.70198,162.75729,616.38150,709.63456,690.00607,399.63607,399.63 6,236,670.001,264,068.063,214,280.00 InterestPrincipalTotalRemainingInterestPrincipalTotalRemainingTotalchg from prev yrchg from 2018InterestPrincipalTotalRemainingTotalchg from prev yrchg from 2018 G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingDebt Service 1 1:25 PM 2/22/2019 -- 2024 592,000592,000135,000120,000 (700,000) Forecast 1,292,0001,292,0002,149,4011,037,0001,292,000 -- 10,000 586,000586,000212,400212,400373,600202,400212,400 2023 Forecast 2,849,401 -- 2022 580,000580,000905,000905,000905,000905,000 (325,000) Forecast 2,475,801 -- 87,000 574,000574,000487,000487,000311,000176,000487,000 2021 Forecast 2,800,801 -- 57,200 6 of 19 2020 568,000568,000723,200723,200355,000311,000723,200 (155,200) Forecast 2,713,801 -- 83,80066,00057,200 562,000562,000478,200478,200355,000478,200 2019 Forecast 2,869,001 Capital 2019 Budget Capital Portion Water Utility -- 5,000 66,00040,00060,000 556,000556,000185,000175,000575,000106,000307,000 (963,000) CITY of PORT ANGELES 2018 1,519,0001,519,0002,785,2011,519,000 Budget Revenue & Expenditure Summary -- 20,80020,800 2017 400,000400,000379,200 Actual 3,748,201 Rate RevenuesNon-Rate Revenues: Timing AR/APTotal RevenueCapital ProjectTransfers/MiscTotal ExpendituresDifferenceCummulative All Distribution E Street Pressure ValveLiberty Street Water MainRanney Well RoofMarine Dr Channel Crossing ReplReservoir Repairs24 Inch Trans Main ReplacementWidby Ave Main ReplacementCraig Ave Water Main10th Street Water MainEast 4th Street Water main3rd Street and Vine Street MainEast 6th Street Water Main10th Street Water MainWest 4th Street Water MainPeabody Res BuildingRace/Caroline Street Fire Flow RevenuesExpenses/Expenditures Detail G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingCapital 1:25 PM 2/22/2019 From Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Labor1 tabFrom Admin tabFrom Admin tabFrom Admin tab Fixed/ Variable FixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedVariableFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixed 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%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00% 7.36%7.36%7.36%7.36%7.36%7.36%7.36%7.36%7.36%7.36%7.36%7.36%7.36%0.00%0.00% As All 51.96% Others 100.00%100.00%100.00%100.00%100.00% 4.22%4.22%4.22%4.22%4.22%4.22%4.22%4.22%4.22%4.22%4.22%4.22%4.22%0.00%0.00% 10.00%10.00%35.00%10.00% Fire Protection 5.59%0.00% 39.18%39.18%39.18%39.18%39.18%39.18%39.18%39.18%39.18%39.18%39.18%39.18%39.18%50.00%20.00%90.00%30.00%10.00%25.00%55.00%42.88%50.00%50.00%50.00%30.00%20.00%50.00%70.00% 100.00% Treatment Allocation Percent 0.00% 49.24%49.24%49.24%49.24%49.24%49.24%49.24%49.24%49.24%49.24%49.24%49.24%49.24%50.00%80.00%10.00%60.00%80.00%40.00%45.00%57.12%50.00%50.00%50.00%70.00%80.00%50.00%20.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%0.00%0.00% 42.46% Customer - 400 4,2001,4001,6002,8005,3004,0007,8001,0006,200 18,10041,00085,90043,80021,00028,30023,00063,50016,30015,60080,00025,50020,50017,50017,00060,00061,20053,300 EntryCosts 136,500238,400752,600158,000185,000215,300201,500343,500 1,096,900 7 of 19 - 400 2019 Budget 4,2001,4001,6002,8005,3004,0007,8001,0006,200 18,10041,00085,90043,80021,00028,30023,00063,50016,30015,60080,00025,50020,50017,50017,00060,00061,20053,300 Total 136,500238,400752,600158,000185,000215,300201,500343,500 Water Utility 1,096,900 CITY of PORT ANGELES 29 Cost Functional Allocation ------------------- 309103118206 1,3323,0176,3213,2231,5457,8001,000 80,71810,04517,543 391,020185,000215,300201,500 As All Others 596817 --------------------- 764 177 887 118 400 1,7323,6285,7651,8501,6305,330 46,32910,06928,000 Fire Protection -------- 548 627 157 400 7,0911,6458,2271,0974,7704,8908,7508,5001,240 Cost Allocation 16,06333,65453,47817,16093,40014,15023,00012,70020,00014,02542,04067,75010,25018,36037,310 429,740171,750 Treatment -------- 689 788 197 530 8,9122,0681,3799,7803,2008,7508,5004,960 20,18842,29767,21321,56710,34014,15050,80015,60032,00011,47590,25010,25060,00042,84010,660 540,113117,388171,750 Distribution ------------------------------------- 319,540 Customer Full-Time EmployeesPart-Time EmployeesOvertime/Call-back PayFICAPersWorkers CompLTDSupplemental LifeFMLA PremiumIns - Medical/DentalHealth ReimbursementState UnemploymentICMA Matching FundsOffice/Operating SuppliesChemicalsBldg and Maint SuppliesComp EquipmentFuel ConsumedDiesel FuelDry Creek Resale WaterMaterials - Job CostSmall Tools/Minor EquipAdministrativeEmergency ManagementProf/Contract ServicesProf/Contract Services-ElwhaPW Administrative ChargesIT ChargesCommunication ExpensesNetwork ServicesTravel and TrainingAdvertising/Legal NoticesEq Serv Chg (Replacement)Eq Serv Operating ChargesOper Rentals/LeasesInsuranceUtilities ExpenseSoftware/Hardware Maint Personnel CostsAdministrative ChargesContractual Services G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingCost alloc 1 1:25 PM 2/22/2019 NTDistributionReservoir, DT WatermainAll Distribution FixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedFixedSNTSSSNTNT-ExciseSNTSNT-Excise & CityNT 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% 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% 10.00% Fire Protection Allocation Percent 65.00% 100.00% Treatment 25.00% 100.00%100.00%100.00%100.00% Distribution Customer 0 -- (500) 2,800 (5,000)(1,500)(2,000) 27,100 28,600 45,000 59,500 39,000 (28,000)(38,000)(72,000)(10,000)(15,500)(37,900) 172,500274,850189,400236,400117,500562,000 EntryCosts (129,700)(100,400)(440,500) 8 of 19 5,808,5505,368,050 0 ---- (500) 2,800 (5,000)(1,500)(2,000) 27,10028,60045,00059,50039,000 (28,000)(38,000)(72,000)(10,000)(15,500)(37,900) 172,500 274,850 189,400 236,400 117,500 562,000 Total (129,700)(100,400)(440,500) 5,808,5505,808,5505,368,050 0 2019 Budget --------- (500) Water Utility 2,800 (5,000)(1,500)(2,000) 27,10028,60045,00059,50039,000 (28,000) (38,000) (72,000) (10,000) (15,500) (37,900) 117,500 440,500 As All (129,700)(100,400)(440,500) Others 1,445,630 (1,445,630) CITY of PORT ANGELES Cost Functional Allocation - - - - - - - - - - - - - - - - - - - - - - - - - - - 17,25041,111 Fire (12,527) 124,074165,186152,659 Protection - - - - - - - - - - - - - - - - - - - - - - - - - - - Cost Allocation 112,125409,176 (124,681) 1,234,896 1,644,072 1,519,392 Treatment ----------------------- 43,125 274,850189,400236,400562,000889,464 (271,030) 2,684,4103,573,8743,302,844 Distribution - - - - - - - - - - - - - - - - - - - - - - - - - - - - (32,262) 319,540105,878425,418393,156 Customer Repairs and MaintDues/SubscriptionsMiscellaneous ServicesBad Debt ExpenseInterdepartmental Revenue Bond Prin (DS)Inergovt Loan Prin (DS)Interest Expense (DS)Machinery & EquipmentTransfers/CapitalTran sfers/Debt Service (DS)Fund Balance Increase (ratios)Intra-Fund Transfers (Capital)Alloc of "All Other"TotalRevenueService & Hookup FeesResale WaterOther Service ChargesWatermain InstallationSystem User FeeUncoll Amts RecoverdInvestment InterestDelinquent InterestInterdeptIndustrial RevenueSale of Scrap & JunkDebt Service TransfersAMI TransferFrom Fund BalanceAllocation of "As All Other"Net expenditure G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingCost alloc 2 1:25 PM 2/22/2019 - 1.184.104.101.55 Cost/month - 3.983.983.983.98 27.8166.4981.5579.5833.43 2,019 50,225 0.016090.014010.016090.016090.016090.01577100,415152,659 $ Share Unit Cost/cf Cost/monthCost/month 9 of 19 1.32%0.00% 1,9584,250 40,12184,987 65.78%32.90% 48,70922,50992,632 813,873 100.00% 338,239393,156737,671208,501458,079 2,363,863 $ Share$ Share$ Share % Share 3,302,8441,519,392 - 0.50%1.08%1.21%2.57%1.48%6.10% 8,544 86.03%12.39%71.57%24.64%48.55%13.72%30.15% 100.00%100.00%100.00% 424,980212,565646,090 % Share% Share% Share (1,000 gpm) Fire Flow Req 418960 - 123260121121 7,083 1,020 8,233 7,223 2,487 10,093 Use 1,398,9735,757,331 2019 Budget 45,848,05412,958,83428,470,73494,433,926 Duration(minutes Weighted Allocation factors - 1.001.001.001.001.022.442.992.921.000.871.001.001.00 CITY of PORT ANGELES (gpm) FactorFactorFactor 1,000.001,719.451,719.45 Fire Flow 418941894189 Water COSA - tax consumption - 60% 7,0831,0208,2337,0831,0208,2337,0831,0208,233 393,156152,659 1,398,9735,757,331 3,302,8441,519,3925,368,050 AccountsAccountsAccounts Total Use 45,848,05414,887,34028,470,73496,362,432 Customer ResidentialCommercialMunicipalIrrigation Distribution ResidentialCommercialMunicipalIrrigation Treatment ResidentialPUDCommercialMunicipalIrrigation Fire ResidentialCommercialMunicipalIrriga tion Total G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingCustomer allocation 97 547 414 333 608 310 216 243 1:25 PM 1.23 7,324 2/22/2019 10,093 Ratio 82 Total 98 31 14 421218117 7,3248,233 Accounts 9 313827943031 - - 260 2.924.53 Ratio 7832 31201889 --- Irrigation 1.001.281.764.065.798.61 12.7830.81 Accounts Comp 60% 43 1617472015 1.01.52.36.19.0 --- 123 13.720.650.7 2.992.93 Ratio Comp 391921 1641 -- N/A Municipal Cost factors 60.0088.00 136.00366.00539.00821.00 1,238.003,041.00 Act Cost Accounts 97 550 131 279 289 468 260 169 243 2.442.93 2,487 Ratio 10 of 19 Source - General Pacific Quote - 8/23/17Size5/8"3/4"1"1.5"2"3"4"6"8" 8 2 85 90 26 11 2019 Budget 550 101 147 Commercial 1,020 Meter Size Equivalency Water Utility Factors Accounts City of Port Angeles 8014 - - - - - 403 1.001.301.903.405.20 1.021.02 6,7277,22310.0015.4030.4048.40 60% Used Ratio Comp 4 42 ----- 310 1.001.502.505.008.00 Residential 6,7277,083 16.0025.0050.0080.00 Ratio CONT Accounts MSEFCS 1.32.03.36.7 1.001.301.903.405.2010.721.433.466.8 10.0015.4030.4048.40107.0 Ratio CONT cf/min 1015255080 160250500800 1.30 2.00 3.30 6.70 10.70 21.40 33.40 66.80 107.00 Flow CONT cf/min Gal/min Meter 5/8"3/4"1"1.5"2"3"4"6"8"TotalSource - AWWA Manual M1Size5/8"3/4"1"1.5"2"3"4"6"8" G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingMeter factors 1:25 PM 2/22/2019 6293684844 446452441860 - 548248142126830121 2.042.02 1,3402,170 Total Hours - 6,7502,7509,7503,5007,5008,0004,2509,0005,0006,000 33,00056,00052,00055,00018,000 11 of 19 479,500248,000106,500110,250622,500 1,858.071,719.45 Total 1,220,7501,843,250 gal/min Minutes 222222222233334444442 Hours Duration Average Average 1,7502,0001,5001,7501,5001,7502,0002,2502,5002,7503,0003,2503,5003,7504,0004,2504,5004,7505,0006,0001,500 gal/min Fire-Flow TotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotalTotal Assume no sprinklers 3 1 6 3 1 2 2 1 2 1 1 716322322622 Assume sprinklers (Wood) 274124398657415 City of Port Angeles Assume sprinklers (Steel, etc) 1,072 Commercial Businesses for use in the 2019 Water COSA Number ofBusinesses Average Fire Flow & Flow Duration 69,12134,30857,62786,589 677,318507,967608,398256,819468,279503,006606,418252,341148,988135,171151,183204,693124,752222,330 Total 1,118,449 1,795,767 6,233,757 Square Feet 3600-48004800-62506250-82008201-1090010901-1270012701-1700017001-2180021801-2420024201-3320033201-3970039701-4710047101-5490054901-6340063401-7240072401-8210082101-9240092401-103100103100-11460011460 1-126700166501-GreaterLess than 3600TotalSource for gal/min & duration -Fire-Flow Requirements for Buildings-2015 International Fire Code G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingFire flow 1:25 PM 2/22/2019 56,16537,661 1,124,626 1,218,452 Dollars Using 10% tiers 0.026330.028960.031590.02633 Rate 2,133,310 1,430,459 1,218,452 42,716,63246,280,401 Base Rate 1.0001.1001.200 63,57147,112 1,107,769 1,218,452 Dollars 10 % Tiers 0.025930.032780.039520.025930.025930.032780.03952 2,451,3671,816,6831,218,452 Rate Total 42,716,632 46,984,682 Using 2018 Budget tiers Base Rate 1 1.2641.524 51,54131,680 Tax Tiers 0.010230.012930.01559 Dollars 1,135,2321,218,452 12 of 19 59,10243,795 0.026580.026580.026580.015700.019850.02393 2019 Budget Rate 1,029,599 1,132,496 Water Utility Dollars Combined City of Port Angeles Residential Usage Tier Rates 26.4%20.6%52.4% 51,54131,680 Tax 0.010490.010490.010490.02593 Total 1,135,2321,218,452 Percentage 20,33712,500 Tax Rate 0.016090.016090.01609447,944480,7810.01023 0.0063720.0062640.012636 2019 COSA Increments 31,20319,179 687,288737,6710.01570 0.0241030.0304750.036739 Rate 1,939,3731,192,049 42,716,63245,848,054 2018 Budget Consumption Usage Block 1 (0-1,000 cf)Block 2 (1,001-1,500 cf)Block 3 (1,501+) Total Usage Block 1 (0-1,000 cf)Block 2 (1,001-1,500 cf)Block 3 (1,501+)Block 1 (0-1,000 cf)Block 2 (1,001-1,500 cf)Block 3 (1,501+) G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingRes Tiers 1:25 PM 2/22/2019 - 4,698 28,71663,57147,11252,76487,60756,50380,36331,872 151,081180,111164,281344,392344,400233,335105,659102,820161,883912,807756,634 2,618,0222,802,5171,107,7691,218,4524,365,3611,669,441 RevenueRevenueRevenue 32.4340.6156.9897.8835.3543.5359.90 13 of 19 146.97100.80149.89280.79428.05837.12 TotalTotal Tiered 0.025930.032780.039520.023650.02259 1,327.99 Round 1.18 1.18 1.18 1.18 1.18 4.10 4.10 4.10 4.10 4.10 4.10 4.10 4.10 4.10 FireFire 0.02658 0.02658 0.02658 0.02365 0.02259 0.02658 Combined to Non-Rate Revenue Combined 27.2735.4551.8192.7227.2735.4551.8192.72 141.81141.81272.71419.97829.04 TaxTax 0.01049 0.01049 0.01049 0.00933 0.00891 0.01049 1,319.91 Distribution Distribution 3.983.983.983.983.983.983.983.983.983.983.983.983.983.98 2019 Budget RateRate Rate Design 0.016090.016090.016090.014320.013680.01609 CustomerCustomer 482 City of Port Angeles 4285902611 - 310 550 101 147 6,7277,0831,020 1,939,3731,192,0497,614,8757,272,465 Water COSA - tax consumption -60% 42,716,63245,848,05414,887,34028,470,734 AccountsAccounts Consumption Consumption ResidentialMeter Size 5/8"3/4"1"1.5"2" Total Usage Block 1 (0-1,000 cf)Block 2 (1,001-1,500 cf)Block 3 (1,501+) Total PUD Gales AdditionBaker Street TotalTotal Residential CommercialMeter Size 5/8"3/4"1"1.5"2"3"4"6"8" Total Usage Total Commercial G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingRate Design 1 1:25 PM 2/22/2019 - - 6,7881,5676,4691,2106,7395,1373,3129,2839,961 16,18844,09832,37576,47311,62513,39131,49010,17589,237 133,238222,475 RevenueRevenue 14 of 19 - - 35.3543.5359.9031.2539.4355.7996.70 TotalTotal 100.80149.89280.79428.05145.79276.69423.95 - - - - - - - - - 4.10 4.10 4.10 4.10 4.10 4.10 4.10 FireFire 0.023140.02314 Combined Combined -- 27.2735.4551.8192.7227.2735.4551.8192.72 141.81272.71419.97141.81272.71419.9776,473 TaxTax 0.007050.00705344,392222,475 Total 4,020,9691,669,4416,333,750 DistributionDistribution - - 3.98 3.98 3.98 3.98 3.98 3.98 3.98 3.98 3.98 3.98 3.98 3.98 3.98 3.98 32,375 RateRate 0.016090.01609344,392756,634133,238 Usage 1,218,4522,485,092 CustomerCustomer 2019 Budget Rate Design 3 9 1 9 2 1 7 8 3 2 164131201889 --- City of Port Angeles 44,09889,237 912,807 Base 1,398,9735,757,3312,802,5173,848,658 AccountsAccounts ConsumptionConsumption Water COSA - tax consumption -60% Revenue Summary MunicipalMeter Size 5/8"3/4"1"1.5"2"3"4"6"8" Total Usage Total Municipal IrrigationMeter Size 5/8"3/4"1"1.5"2"3"4" Total Usage Total IrrigationResidentialPUDCommercialMunicipalIrrigation G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingRate Design 2 1:25 PM 2/22/2019 -2.47% 5,989,3506,333,750 - 500 5,0001,5002,000 28,00038,00072,00010,00015,50037,90098,50045,000 344,400 129,700 536,000 261,500 937,600 419,100 302,000 663,700 974,700 818,150 562,000 (100,400)(100,400) 2019 5,989,3506,673,8501,156,0006,774,250 COSA 500 5,0001,5002,000 27,00035,00070,00010,00015,50037,90068,000 300,000 129,300 542,100 268,000 959,300 982,500 291,200 670,600 849,600 838,700 132,500 556,000 (476,300) 2018 6,141,1006,774,8001,092,6007,251,100 Budget AMI Transfer - 1,7742,3612,4603,303 26,57345,58955,69590,40010,56915,50038,10042,09548,226 314,327 126,792 550,250 318,618 885,690 801,004 264,796 644,574 964,272 837,805 400,000 (398,464) 2017 5,697,9426,431,3841,072,5176,829,847 Actual 15 of 19 - 2,2451,866 28,60336,31549,72031,03811,84353,11942,80068,002 251,030 937,121 436,890 485,362 918,236 727,511 253,012 591,987 918,132 406,224 (986,732) 2016 5,473,4275,939,2051,140,6606,925,937 Actual 20 -- 356 4,7161,3125,6561,074 29,44039,13481,86153,31971,17469,959 295,723 126,697 843,928 390,778 340,754 985,839 479,849 248,920 595,678 809,295 439,934 111,618 386,873 206,985 2015 5,342,2755,981,5835,774,598 Actual 2019 Budget Water Utility 493 CITY of PORT ANGELES 3,4011,5125,5852,687 27,50927,31824,16067,80013,41653,51925,00074,161 280,776 145,045 800,646 369,331 238,559 499,672 226,693 552,820 832,665 452,105 (703,520) Revenue & Expenditure Summary 2014 4,968,5995,621,8191,038,5391,215,1476,325,339 Actual Rate Revenues (exc Resale)Non-Rate Revenues: Elwa Mitigation Service & Hookup Fees Resale Water Other Service Charges Watermain Installation System User Fee Uncoll Amts Recoverd Investment Interest Delinquent Interest Interdept Industrial Revenue Sale of Scrap & Junk Judgements & Settlements Miscellaneous Revenues Debt Service TransfersTotal RevenueCash Operating Expenses: Salaries & Wages Personnel Benefits Supplies Administrative Charges Contractual Services Taxes City Utility Taxes Miscellaneous Debt Service Capital Intrafund Transfer Prior Period Adjustment InterdepartmentalTotal ExpendituresDifference RevenuesExpenses/Expenditures G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingRev Requirement 1:25 PM 2/22/2019 0.00% (0) - 5,386 35,94176,47315,50015,500 204,408 344,392 222,475 Total Total 3,775,2334,020,9694,020,9694,365,3611,669,4416,349,2506,333,7506,349,250 27 -- 279 2,062 44,74447,11232,375 344,392 756,634 133,238 Over 1,218,4521,562,8442,485,092 Industrial Consumption 2019 Budget Difference 36 - 377 2,782 60,37663,57144,09815,50089,237 912,807 Next Base Revenue 2,802,517 2,802,517 3,864,158 -- 626 6,569 48,483 cf 1st 1,052,0911,107,7691,398,9735,757,331 45,848,05414,887,34060,735,39428,470,73496,362,432 21 4189 - 4,6987,0837,0851,0208,236 28,716 Base 151,081 2,618,0222,802,517 Accounts Rate 3.95223.95223.95223.95223.9522 14.02 14.02 14.02 14.02 14.02 Ave cf 2.60% Residential CityPUD Subtotal CommercialMunicipalIndustrialIrrigation TotalDefinition: Base Accounts - 12/31/15 customer accounts by meter sizeCF Accounts - average customer accounts for 2015Ave CF - Total CF/CF accounts/12 over 1,500 cf 4 16 of 19 42 - 310 6,727 7,083 Accounts -- 3,9361,9998,3185,926 3.2779 3.2779 3.2779 3.2779 3.2779 64,663 86,298 33,355 19,422 13,576 23,295 76,473 58,034 13,792 43,332 21,260 58,437 14,452 13,169 Rate TotalTotalTotal 641,324127,686214,704165,873228,645106,894222,475 2019 Budget Revenue Test 1,669,441 Water Utility City of Port Angeles -- 790790 22.8222.8222.8222.8222.828,1605,9341,4842,3697,1077,1071,5794,4912,994 CfCfCf 74,922 63,053 66,762 19,287 12,634 32,375 46,409 10,479 29,941 11,976 26,947 407,989109,044756,634133,238 Ave cf4.23% RevenueRevenueRevenue next 500 cf 4 42 --- 310 6,7277,0836,7881,5676,4691,2106,7395,1373,3129,2839,961 52,764 87,607 56,503 80,363 31,872 16,188 44,098 11,625 13,391 31,490 10,175 89,237 BaseBaseBase 233,335105,659102,820161,883912,807 Accounts RateRateRateRate 2.59332.59332.59332.59332.59332.65762.65762.65762.65762.65762.65762.65762.65762.65762.31422.31422.31422.31422.31422.31422.31422.31422.31422.31422.31422.31422.31422.31422.31422.3142 - 502.57 502.57 502.57 502.57 502.57 15,500 180,111164,281344,392 All cfAll cfAll cf 2,326.042,326.042,326.042,326.042,326.042,326.042,326.042,326.042,326.042,843.442,843.442,843.442,843.442,843.442,843.442,843.442,843.442,843.445,390.765,390.765,390.765,390.765,390.765,390.765,390.7 6 Ave cfAve cfAve cfAve cf 93.17% 1,398,9735,757,331 Revenue 45,848,054 28,470,734 1st 1,000 cf Total CF Revenue Total CFTotal CFTotal CF 4 8 2 3 9 1 9 2 1 7 8 3 2 4285902611164131201889 --- 310550101147 2.075 6,727 7,083 1,020 RateRate 2.36532.2589 Accounts Accounts Accounts Accounts - - 32.4340.6156.9897.8835.3543.5359.9035.3543.5359.9031.2539.4355.7996.70 146.97100.80149.89280.79428.05837.12100.80149.89280.79428.05145.79276.69423.95 RateRateRateRate 1,327.99 Ave cfAve cf 634,572.86606,038.8014,887,34014,887,340 Total CF All cf % Base 4.38%0.61%0.06%0.00%Base 9.82%8.23%8.70%2.53%1.03%0.75%0.19%Base 7.32%2.44%4.88%2.44%0.00%0.00%Base 8.14%9.30%3.49%2.33% 94.96%51.15%48.85%54.44%14.31%39.02%21.95%21.95%34.88%22.09%19.77% 100.00%100.00%100.00%100.00% 111 423919217832 42 16 41 41 31 20 18 8989 8.0 2.0 --- 310 85.090.026.011.0 6,7277,0837,083550.0101.0147.01,0201,020 AccountsAccountsAccountsAccountsAccountsAccounts 5/8"3/4"1"1.5"2"Total5/8"3/4"1"1.5"2"3"4"6"8"5/8"3/4"1"1.5"2"3"4"6"8"CFBase5/8"3/4"1"1.5"2"3"4" Residential CityPUD Gales Addition Baker Street Commercial City Municipal City IndustrialElwaIrrigation G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingCOSA Rev Test 1:25 PM 2/22/2019 (0) (4,223)(6,329) 27,44815,118 (32,014) Category Difference 2.08%2.02%2.04%0.69%4.59%1.69%1.69%0.71%0.00% -0.98%-2.85%-5.08%-0.90%-7.56%-8.23%-8.47%-1.88%-2.85%-5.08%-0.90%-7.56%-5.23%-7.13%-2.77% 14.15%43.59%33.22%15.65%14.03%12.25%11.04%17.51%10.19% -29.36%-18.41%-29.36%-18.41%-24.79%-12.70% PercentPercentPercentPercentPercent (0) (35)(61) 944108227941 (792)(354)(866)(420)(482) 8,7181,1721,2581,7601,6471,0133,1321,485 (3,015)(8,660)(4,623)(7,207)(2,950)(2,822)(4,223)(3,831)(6,329) 18,73122,54027,44815,118 (25,913)(96,995)(11,908)(32,014)(10,233) 102,377 DifferenceDifferenceDifferenceDifferenceDifference 4,698 6,788 1,567 6,469 1,210 6,739 5,137 3,312 9,283 9,961 DollarsDollarsDollarsDollars 28,71663,57147,11252,76487,60756,50380,36331,87216,18832,37576,47311,62513,39131,49010,175 151,081344,389233,335105,659102,820161,883756,634133,241222,478 2,618,0221,107,7694,020,9691,669,4416,333,750 17 of 19 COSA RateCOSA RateCOSA RateCOSA RateCOSA Rate 3,5279,6101,9216,3611,2456,8005,5573,7948,2708,4769,234 19,99862,31446,16864,67288,39961,12787,57034,82217,05432,14880,69615,45711,74328,359 132,350329,271330,330103,900105,835170,543654,257143,474228,807 2,643,9361,085,2293,993,5211,701,4556,333,750 2019 Rate2019 Rate2019 Rate2019 Rate2019 Rate 2.08%2.02%2.04%4.59%1.69%1.69%0.71% -0.98%-2.85%-5.08%-0.90%-7.56%-8.23%-8.47%-2.85%-5.08%-0.90%-7.56%-7.14% 14.15%43.59%33.22%15.65%14.03%12.25%11.04%17.51%10.19% -29.36%-18.41%-29.36%-18.41%-24.79%-12.70% PercentPercentPercentPercentPercent Total 5.041.001.006.86 (0.32) (9.83) (2.96) (8.02) (2.54) (9.83) (2.96) (8.02) (2.54) (5.74) 17.3024.4110.5514.5041.2439.21 (14.70)(35.03)(75.07)(14.70)(35.03)(10.30) (122.92) 0.0005280.0006480.0007920.0010160.0035960.000162 (0.001778) DifferenceDifferenceDifferenceDifferenceDifference Water Utility Rate Comparison BaseBaseBaseBase UsageUsageUsageUsage City of Port Angeles 32.43 40.61 56.98 97.88 35.35 43.53 59.90 35.35 43.53 59.90 31.25 39.43 55.79 96.70 100.80149.89280.79428.05837.12100.80149.89280.79428.05145.79276.69423.95 0.023133 1,327.99 0.0259330.0327790.0395220.0265760.0231420.023142 COSA RateCOSA RateCOSA RateCOSA RateCOSA Rate 32.7535.5839.6873.4850.0553.3658.9050.0553.3658.9041.5545.1748.9386.15 103.76157.91283.33463.08912.19103.76157.91283.33463.08131.29235.45384.74 0.0229800.0229800.024920 1,450.91 0.02540530.03213080.03872990.0221175 2019 Rate2019 Rate2019 Rate2019 Rate2019 Rate 4%1%0%4%3%8%9%3%1%1%0%7%2%5%2%8%9%3%2% %%%% 95%93%54%10%14%39%22%22%35%22%20% 100%100%100%100%100% 4823919217832 4285902611164131201889 310550101147 6,7277,0831,020 1,939,3731,192,0491,398,9735,757,331 42,716,63245,848,05414,887,34028,470,734 Account/VolumeAccount/VolumeAccount/VolumeAccount/VolumeAccount/Volume Residential 5/8"3/4"1"1.5"Block 1 (0-1,000 cf)Block 2 (1,001-1,500 cf)Block 3 (1,501+)PUDCommercial 5/8"3/4"1"1.5"2"3"4"6"8"All Municipal 5/8"3/4"1"1.5"2"3"4"All Irrigation 5/8"3/4"1"1.5"2"3"4"All G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingCompare 1:25 PM 5.86 67.82 8" 2/22/2019 1,450.911,327.991,933.911,894.00 5.86 37.63 6" 912.19837.12366.04 1,216.20 1,184.50 5.86 17.14 4" 463.08428.05309.10618.09593.80 1,070.17 5.86 3" 283.33280.79247.62256.25378.86636.82357.00 3.89 2" 157.91149.89132.03195.23211.39323.01191.29 3.89 82.47 1.5" 103.76100.80111.84139.62181.24120.00 Commercial 3.89 1" 58.90 59.90 41.36 61.02 79.82 61.40 100.39 3.89 3/4" 53.3643.5324.7724.4043.9140.2325.65 3.89 5/8" 50.0535.3524.7743.91 All 2.302.660.862.552.682.054.014.214.625.554.00 18 of 19 City of Port Angeles - over 600 cf - 0-5000 cf - 5001-10000 cf - over 15000 cf Water Rate Comparison Port Angeles Budget Consumption/100 cf Port Angeles COSA Consumption/100 cf Sequim Consumption/100 cf - up to 600 cf Forks Consumption/100 cf - 400-1000 cf - over 1000 cf Port Townsend Consumption/1000 gal Clallam PUD(Gales)Fire protect chgConsumption/100 cf - 10000-15000 cf Jefferson PUD Consumption/100 gal 73.48 97.88 1.5" 111.84139.62180.85 2019 Budget compared to other local rates 1" 39.6856.9861.0279.8285.06 3/4" 35.5840.6124.4043.9140.23 5/8" 32.7532.4343.91 2.54 3.21 3.87 2.59 3.28 3.95 0.86 2.55 3.18 2.68 2.05 3.38 4.01 4.21 4.62 5.55 2.90 4.00 5.40 All 24.7725.65 Residential Low Inc DiscN/AN/AN/A18.29 (25%)2.01 (25%)1.53 (25%23.28 (47%)N/A$10 Credit (39%) Port Angeles Budget Consumption/100 cf - up to 1000 cf - 1001 - 1500 cf - over 1500 cf Port Angeles COSA Consumption/100 cf - up to 1000 cf - 1001 - 1500 cf - over 1500 cf Sequim Consumption/100 cf - up to 600 cf - 601 to 1600 cf - over 1600 cf Forks - 2018 Consumption/100 cf - 400-1000 cf - over 1000 cf 2018 rates - rates for 2019 not on web sitePort Townsend Consumption/1000 gal Clallam PUD(Gales)Consumption/100 cf - 0-1000 cf - 1001-2000 cf - 2001-3000 cf - over 3000 cf Jefferson PUD Consumption/100 gal - 0-5000 gal - 5001-10000 gal - over 10000 gal 2018 rates - new rates (unknown) will be effective 5/1/19 G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingRate Compare 1:25 PM 2/22/2019 33.3724.8821.5633.3733.3733.37 with Disc Combined 4 7742 284310 6,3667,083 498,419 1,939,3731,192,0491,838,324 40,379,88945,848,054 Volume Discount 0.63%2.08%2.02%2.05%4.59%2.80%0.32%2.80%0.32%0.70% -7.36%-1.72%-3.94%-6.41%-7.08%-7.32%-1.72%-3.94%-6.41%-7.14% 15.65%15.37%13.62%12.42%18.98%11.57% -16.93%-55.14%-28.67%-33.10%-28.67%-33.10%-23.95%-30.04% PercentPercentPercentPercentPercent 0.211.650.921.650.927.52 (2.62)(6.72)(1.78)(6.22)(1.78)(6.22)(9.95) 11.7316.3044.6944.53 (40.52)(14.35)(17.66)(29.70)(64.57)(14.35)(17.66)(29.70)(13.57) (106.19) Base Base Base Base 0.0005280.0006480.0007920.0010160.0035960.000162 UsageUsageUsageUsage (0.001778) DifferenceDifferenceDifferenceDifferenceDifference One Residential Rate 32.9632.9632.9632.9635.7035.7060.5535.7035.7060.5531.6031.6056.4597.88 101.98151.69284.25433.38847.62101.98151.69284.25433.38147.59280.14429.27 0.023133 1,344.72 0.0259330.0327790.0395220.0265760.0231420.023142 One Rate Combo RateCombo RateCombo RateCombo Rate 1.30%1.87%1.80%1.83%4.51%4.04%1.52%4.04%1.52%2.05% -6.74%-0.54%-2.79%-5.30%-5.97%-6.22%-0.54%-2.79%-5.30%-5.90% 47.01%36.43%17.41%16.76%14.97%13.76%20.40%12.90% -24.04%-34.17%-27.81%-32.29%-27.81%-32.29%-23.03%-29.20% PercentPercentPercentPercentPercent 0.432.384.302.384.308.20 (7.87)(2.40)(0.56)(4.41)(0.56)(4.41)(9.57) 18.6526.7612.9018.0648.0349.64 (11.19)(13.92)(17.23)(24.55)(54.49)(90.22)(13.92)(17.23)(24.55)(13.19) 0.000475 0.000579 0.000710 0.000997 0.004000 0.000470 (0.001470) BaseBaseBaseBase Difference Usage DifferenceDifference Usage Difference Usage Difference Usage 33.1824.8821.5633.1858.3336.1336.1361.2836.1336.1361.2831.9831.9857.1399.05 100.24103.20153.50287.63438.53857.70103.20153.50287.63438.53149.35283.48434.38 0.023114 1,360.69 0.0258800.0327100.0394400.0225000.0208800.0269800.0234500.023450 5/8 & 3/4 Rate Combination- with disc Combo RateCombo RateCombo RateCombo RateCombo Rate 0.08%2.08%2.02%2.05%4.59%2.80%0.32%2.80%0.32%0.70% -7.86%-1.72%-3.94%-6.41%-7.08%-7.32%-1.72%-3.94%-6.41%-7.14% 45.24%34.82%15.65%15.37%13.62%12.42%18.98%11.57% -28.67%-33.10%-28.67%-33.10%-23.95%-30.04% PercentPercentPercentPercentPercent 19 of 19 0.031.650.921.650.927.52 (2.80)(1.78)(6.22)(1.78)(6.22)(9.95) 17.9525.5811.7316.3044.6944.53 (14.35)(17.66)(29.70)(64.57)(14.35)(17.66)(29.70)(13.57) (106.19) 0.0005280.0006480.0007920.0010160.0035960.000162 (0.001778) BaseBaseBaseBase DifferenceDifferenceDifferenceDifferenceDifference UsageUsageUsageUsage Water Utility Rate Options City of Port Angeles 32.7832.7857.6399.0635.7035.7060.5535.7035.7060.5531.6031.6056.4597.88 101.98151.69284.25433.38847.62101.98151.69284.25433.38147.59280.14429.27 5/8 & 3/4 Rate Combination 0.023133 1,344.72 0.0259330.0327790.0395220.0265760.0231420.023142 Combo RateCombo RateCombo RateCombo RateCombo Rate 2.08%2.02%2.04%4.59%1.69%1.69%0.71% -0.98%-2.85%-5.08%-0.90%-7.56%-8.23%-8.47%-2.85%-5.08%-0.90%-7.56%-7.14% 14.15%43.59%33.22%15.65%14.03%12.25%11.04%17.51%10.19% -29.36%-18.41%-29.36%-18.41%-24.79%-12.70% PercentPercentPercentPercentPercent 5.041.001.006.86 (0.32)(9.83)(2.96)(8.02)(2.54)(9.83)(2.96)(8.02)(2.54)(5.74) 17.3024.4110.5514.5041.2439.21 (14.70)(35.03)(75.07)(14.70)(35.03)(10.30) (122.92) 0.0005280.0006480.0007920.0010160.0035960.000162 BaseBaseBaseBase (0.001778) UsageUsageUsageUsage DifferenceDifferenceDifferenceDifferenceDifference COSA Option 32.4340.6156.9897.8835.3543.5359.9035.3543.5359.9031.2539.4355.7996.70 100.80 149.89 280.79 428.05 837.12 100.80 149.89 280.79 428.05 145.79 276.69 423.95 0.023133 1,327.99 0.0259330.0327790.0395220.0265760.0231420.023142 COSA RateCOSA RateCOSA RateCOSA RateCOSA Rate 32.7535.5839.6873.4850.0553.3658.9050.0553.3658.9041.5545.1748.9386.15 103.76157.91283.33463.08912.19103.76157.91283.33463.08131.29235.45384.74 BaseBaseBaseBase UsageUsageUsageUsage 0.0229800.0229800.024920 1,450.91 0.02540530.03213080.03872990.0221175 2019 Rate2019 Rate2019 Rate2019 Rate2019 Rate 4823919217832 4285902611164131201889 310550101147 6,7277,0831,020 1,939,3731,192,0491,398,9735,757,331 42,716,63245,848,05414,887,34028,470,734 Account/VolumeAccount/VolumeAccount/VolumeAccount/VolumeAccount/Volume Residential 5/8"25% Discount35% Discount3/4"1"1.5"Block 1 (0-1,000 cf)Block 2 (1,001-1,500 cf)Block 3 (1,501+)25% Discount35% Discount PUDCommercial 5/8"3/4"1"1.5"2"3"4"6"8"All Municipal 5/8"3/4"1"1.5"2"3"4"All Irrigation 5/8"3/4"1"1.5"2"3"4"All G:\\FINANCE\\COSA\\COSA\\Water\\CC COSA training\\Training Packet\\Water - COSA - 2019 Budget City Council trainingRate Options