Loading...
HomeMy WebLinkAbout20060210Gradilone direct.pdfDean J. Miller (ISB #1968) McDEVITI & MILLER LLP 420 West Bannock Street o. Box 2564-83701 Boise, ID 83702 Tel: 208.343.7500 Fax: 208.336.6912 oe~mcdevitt -mill er .com i(J P:J2:19 !Jr!!fr;L. (~;~; " ' i il S S :cr' Attorneys for Applicant BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MA TIER OF THE APPLICATION OF UNITED WATER IDAHO INC. FOR AUTHORITY TO INCREASE ITS RATES AND CHARGES FOR WATER SERVICE IN THE STATE OF IDAHO Case No. UWI-O6- DIRECT TESTIMONY OF FRANK GRADILONE III Please state your name and business address. Frank Gradilone III, Pleasant Valley Analytics (PV A), 9 Crestfield Road, Boonton New Jersey 07005. Please state your educational and professional background. I hold Master Degrees in Business Administration and in City and Regional Planning from Rutgers, the State University of New Jersey. As an undergraduate, I majored in environmental studies and political science, and received a BA from the State University of New York at Stony Brook. While a graduate student in the City and Regional Planning program at Rutgers University, I was a Research Associate at the Center for Urban Policy Research where I was involved in a number of research projects for local government agencies and organizations, and for the U.S. Department of Housing and Urban Development. My responsibilities included survey research, computer based quantitative analyses, and fiscal impact analysis. I am a contributing author to the 1980, Center for Urban Policy Research publication entitled, The Adaptive Reuse Handbook. I have been a Licensed Professional Planner in the State of New Jersey since June of 1981. I was a member of the Vernon Township (NJ) Environmental Commission, and served as chairperson of that body from 1993 through 1995. I have authored and presented a number of technical papers at national and regional conferences in the field. These papers and presentations include: " Perspective on Outdoor Water Conservation Programs at United Water , jointly with R. Henning, United Water New Jersey and M. Cahoon, United Water Idaho, at Gradilone, DI United Water Idaho Conserv '99,Water Conservation Program for the Spring Valley Water Company , Proceedings of Conserv ', Las Vegas, NV, 1993; "Seasonal Rates- the Pros and Cons: A Case Study , a paper presented at the American Society of Civil Engineers, Water Resources and Planning & Management 193 Conference, in Seattle, Washington May 1993; Automatic Meter Reading for the Water Industry, co-authored with Donald L. Sch1enger, American Water Works Association Research Foundation, Denver, Colorado, 1992; "Some Questions on Cost and Benefits of Rate Regulation " co-authored with Drs. Michael Crew and Donald L. Schlenger, published in NA WC Water, Summer 1986; "Water Conservation: A Case Study," a paper presented at the Water for the 21st Century conference in Dallas, Texas, 1984; "Impact of SummerlWinter Differential Rate Structure " a paper presented at the ASCE, Urban Water 1984 Conference in Baltimore, Maryland; and the "AWWA Survey of Remote Metering Practices " a paper presented jointly with Donald L. Schlenger at the 1984 A WW A Annual Conference in Dallas, Texas. Please describe your employment experience. I was employed by United Water Resources (UWR), and its predecessor companies from August 1979 through August 2005. From 1979 to 1983 , I was a Special Projects Researcher in the Research and Development Division of the Hackensack Water Company (now known as United Water New Jersey). My responsibilities included research design and quantitative analysis, system operation analysis, and survey research for the Company and its Gradilone, DI United Waterldaho subsidiary, Spring Valley Water Company (now known as United Water New York). From 1983 through 1987, I was Manager of Demand Forecasting. My responsibilities included demographic and economic forecasting, capital projects planning, liaison with government agencies and regulatory bodies, and management of research personnel.I also provided testimony before the New York State Department of Environmental Conservation on the need and timing for a proposed reservoir and water filtration plant project for the United Water New York system known as the Ambrey Project. In 1988 I transfelTed to United Water Resources as Manager-Resources Planning in the Regulatory Department for United Water Resources.In this capacity, I was responsible for water demand, demographic and economic forecasts for United Water s operating units. With respect to my involvement in water demand forecasting, to date, I have conducted basic research to determine the appropriate forecasting methods. I have created forecasting databases, and I continued to provide long-range forecasts for both United Water New York and United Water New Jersey. I produced short-run water consumption and revenue forecasts for United Water Idaho in its last three rate cases (UWI-97-, UWI-00-, and UW-04-04). I have also provided short-run water consumption and revenue forecasts for a number of other United Water operations including: United Water New York in its last two rate cases (NYS PSC Case 92-0645 and Case 94-0486); United Water New Jersey (NJ BPU Case WR-90080792J); United Water Toms River (NJ BPU Case WR-95050219); Gradilone, DI United Waterldaho United Water New Rochelle (NYS PSC. Case 96-1168 and Case 99-0948), United Water Florida (FPSC Case 960451-WS), United Water Delaware (DPSc. Case 96-164), United Water Pennsylvania (PPUC. Docket No. R-00973947), and United Water Arkansas (APSC Case 960451-WS). In 2001 I took over the management of United Water s LeakGuard program. LeakGuard, which has been offered in the United Water Idaho service area, provides coverage for the repair or replacement of the customer owned portion of the water service line connecting that customer s home to the water system. In addition to my responsibilities here, I continued to provide the short run revenue forecasts for United Water New Jersey and have had a continuing liaison with the United Water M&S Rate Department on the revenue side of rate cases. I resigned my position at UWR in 2005 to pursue alternate employment opportunities as a consultant to the water industry. In this capacity I have been retained by United Water Idaho to provide the revenue analysis for this regulatory proceeding. Could you describe your responsibilities in connection with this rate filing? The purpose of my testimony is to present an assessment of revenues for metered water sales, private fire protection service revenues, and other revenues for a base year covering the twelve month period ended October 31 , 2005 for United Water Idaho ("United Water" or "Company ), and to assess revenues that would be realized on a pro forma basis for a test year period defined as May 31 , 2005 through April 30, 2006. How did you prepare these projections? Gradilone, DI United Water Idaho Separate assessments of metered water consumption and revenues were made for each customer sector in the system; residential, commercial, and public authority. Revenues for private fire protection services and other revenues were also analyzed. This analysis, and supporting tables and figures detailing this assessment, is contained in Exhibit 1 , Schedules 1 through 4. What was the level of metered water sales for the base year in this case based on the Company s financial records? Base year metered water sales revenue for the twelve-month period ended October , 2005 under existing tariff schedules totaled $29 399 223. Private fire protection services for the base year were $527 417. Other revenue sources, including miscellaneous revenues from customer fees and charges, rents, and unbilled revenues totaled $317 732 for the base year.Overall as shown in Exhibit 1 Schedule 1 , Page 1 of 2, Column 1 , total revenue per the income statement for the Company for the base year was $30 244 372. Was it necessary to adjust the base year revenues as shown on the income statement of United Water Idaho? Yes. Unbilled revenues of $173 650 were deducted from the revenue stream since once total billed consumption for the base year is assessed, all water used is priced and assumed to be billed, and collected, during the pro forma test period. In addition the amortization of revenues for the Carnage Hills system as stipulated in IPUC Order No. 29625 was added to the revenue stream. The amount of this amortization was set at $5 628 in revenues per year for a 5 year period starting in 2005. Gradilone, DI United Water Idaho Did you obtain a bill analysis for the base year period? Yes.Overall, the level of revenue in the bill analysis for billed services to the residential, commercial and public sectors in the base year was $47 141 more than the books, or in percentage terms only 0.16%, as shown in Exhibit 1 , Schedule 1 Page 1 of 2, Column 4. Accordingly the bill determinants as per the bill analysis were used as the basis for the analysis of metered sales in the United Water Idaho system in the base year. Did you have to make any adjustments to revenues as per the bill analysis to normalize revenues for the test period? Yes. These adjustments fell into three areas. First was a weather normalization, to colTect for the impact of deviations in weather conditions from normal that affected consumption in the base year. Second, was an adjustment to account for underlying changes in the trend of water use per customer that have been precipitated by community growth patterns, customer behavior changes and pricing. Third, were adjustments to account for anticipated growth in the system through April 2006, to ensure that pro forma revenues are in synch with the capital additions through the end of the test year in this rate proceeding. How did you proceed with the weather normalization and the change in usage patterns due to the additions of new system areas and the change in irrigation water regulations? To assess the impact of theses factors on demand during the base year a detailed analysis of the usage trends in the residential, commercial and public sectors in the system was conducted.These analyses, which involved the use of multiple Gradilone, DI United Waterldaho regression modeling of historical consumption patterns versus weather data, the price of water and additions to the system are detailed in Exhibit 1 , Schedules 2 through 4 accompanying my testimony. As developed in this analysis a weather normalizing adjustment of $909 512 was indicated for the base year. A $9 517 adjustment was indicated for the trend factor. Could you discuss the adjustments that were made to account for anticipated growth through April 2006? First, there were adjustments for anticipated growth in the number ofYes. customers in the United system through April 2006. During the base year 2 278 residential customers were added to United system. An additional 1 013 customer are expected to be added to the system through April 2006. For the commercial sector 84 customers were added during the base year; and an addition 52 commercial customers are anticipated through April 2006. Based on existing rates this represents $171 645 in additional revenues. United Water Idaho received rate relief in August and September of 2005, how did you assess the impact of these rate changes on pro forma revenue? To assess the impact of these rate changes the bill determinants associated with total adjusted test year were priced at the rates currently in effect in the United Water Idaho service area. Pricing these bill determinants at current rates yields an additional $1 794 644 in metered sales revenue. Total pro forma metered sales revenues for the United Water Idaho for the 12 month period ending April 2006 are therefore $32 331 682. Gradilone, DI United Water Idaho Could you please discuss your assessment of private fire service revenues for the base year? United provides private fire protection services to about 1,430 customers through separate service lines and hydrants. Base year revenues for these services based on data in the bill analysis were $523 723. Due to growth in the number of private fire services anticipated through April 2006 an additional $10 066 in revenues were added to the total to derive normalized base year private fire revenues of $533 789 the base year (Exhibit 6, Schedule 1 , Page 2 of 2, Column 5). Pricing these services under the current rate schedule yield test year fire protection revenues of$568 417. Could you please discuss your assessment of the proper level of Other Revenues that should be considered on a pro forma basis for the base year? Looking ahead the Company can be reasonably expected to receive revenues from three additional sources-bulk water sales through hydrants, rents of water meters to construction sites, and miscellaneous customer service charge revenues (reconnection charges, bad check fees, etc. Customer service charges for returned checks and reconnection fees amounted to $46 131 in the base year. The fee for returned checks was increased from $15 to $20 per item in August 2005 as per IPUC Order No. 29838. Base year customer service fee revenue was adjusted upwards by $1 397 to account for this increase. Based on the average rate of returned checks and reconnections per customer during the base year, customer service fee revenue was increased another $629 to account for growth through the end of the test year. Gradilone, DI United Water Idaho The Company received $12 095 in revenues from construction meter rents and $85 856 from bulk water sales. Construction meter rents were also increased under Order 29838 , from $20 to $25 per permit. Under the current rate structure construction meter rents would have totaled $14 775 during the base year, so these revenues were adjusted upwards by $2 680. For the pro forma period no adjustment was made since the rental of construction meters is tied to the rate of growth in the service area and no change in the underlying growth rate is anticipated (hence it is expected that the same number of construction meters would be rented during the pro forma period). Bulk water sales are billed under the basic United Water meter service tariff that is, fixed service charges based on meter size and commodity charges based on usage. Metered service rates were increased twice during the base year. Once under IPUC Order 29838, on August 2, 2005 and next under IPUC Order No.29871 , on September 28, 2005. Assuming all bulk water sales had been billed under the culTent tariff as per Order 29871 , an additional $5 010 in revenues would have been realized in the base year. Other Revenues as adjusted for the test year therefore amounted to $159 428. Based on your analysis what conclusions do you draw for adjusted pro forma revenues for the base year? Pro forma metered water sales, fire service and other revenues under the existing tariff schedule for the twelve month test year period ended April 30, 2006 total $33 059 527 (as shown in Exhibit 1 , Schedule 1 , Page 2 of 2, Column 7); 815 155 more than booked during the base year. Gradilone, DI United Waterldaho How does the Company propose to change its tariffs to reflect the change in rates proposed in this rate case? The Company proposes to increase rates to meet its revenue requirements on an across the board basis. Based on a revenue requirement of $38 981 217 fixed service charges, metered use charges and private fire service rates would need to be increase 17.91 %. Have you developed a rate proof to show that the proposed tariffs will generate the revenues needed to meet the revenue requirement? Yes. The rate proof for metered sales in the residential, commercial and public sectors is shown in Exhibit 1 , Schedule 4 Page 11 of 11. The rate proof for private fire protection services is shown in Exhibit 1 , Schedule 3 Page 37 of 37. The proposed tariff structure generates $38 980 844 in revenues; a difference of ($373) with respect to the revenue requirement. Have you prepared any other schedules for this Application for Rate Increase? Yes. I also prepared Exhibit 2, which shows the existing tariffs and proposed tariffs for this case. Does this conclude your testimony? Yes it does. Gradilone, DI United Water Idaho UN I T E D W A T E R I D A H O SU M M A R Y O F D E R I V A T I O N O F B A S E Y E A R O P E R A T I N G R E V E N U E FO R T H E T W E L V E M O N T H S E N D E D O C T O B E R 3 1 , 2 0 0 5 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 1 Re v e n u e P e r Re v e n u e P e r DI F F E R E N C E Re v e n u e P e r Ba s e Y e a r Bo o k s f o r El i m i n a t i o n s Bo o k s l e s s BI L L A N A L Y S I S Bil l A n a l y s i s f o r Re v e n u e f o r LI N E 12 M o n t h s & A d d i t i o n s El i m i n a t i o n s TO B O O K S 12 M o n t h s 12 M o n t h s NO . AC C O U N T AC C O U N T T I T L E En d e d 1 0 / 3 1 / 0 5 to R e v e n u e s & A d d i t i o n s Am o u n t Pe r c e n t En d e d 1 0 / 3 1 / 0 5 En d e d 1 0 / 3 1 / 0 5 (U W l D I n c o m e S t a t e m e n t ) (S e e n o t e s ) (( 1 ) + ( 2 ) ) (( 6 ) - ( 3 ) ) (( 4 ) 1 ( 3 ) ) (E x 1 S c h 4 P g 9 ) (C o l ( 6 ) ) TA R I F F E D S E R V I C E S ME T E R E D W A T E R S A L E S : 46 1 1 0 0 Re s i d e n t i a l $ 2 0 41 2 65 1 $ 2 0 , 4 1 2 65 1 $ 1 9 , 09 0 09 % $ 2 0 43 1 74 1 $ 2 0 , 4 3 1 74 1 46 1 2 0 0 Co m m e r c i a l $ 8 84 3 , 49 2 $ 8 84 3 , 4 9 2 $ 2 9 69 6 34 % $ 8 , 87 3 , 18 8 $ 8 , 87 3 , 18 8 46 1 4 0 0 Pu b l i c A u t h o r i t y $ 1 4 3 , 08 0 $ 1 4 3 , 08 0 ($ 1 64 5 ) 15 % $ 1 4 1 , 4 3 5 $ 1 4 1 , 43 5 To t a l M e t e r e d S a l e s $ 2 9 , 39 9 , 22 3 $ 0 $ 2 9 , 39 9 , 22 3 $ 4 7 , 14 1 16 % $ 2 9 , 44 6 , 36 4 $ 2 9 , 44 6 , 36 4 FI R E P R O T E C T I O N : 46 2 0 0 0 Pr i v a t e F i r e P r o t e c t i o n $ 5 2 7 41 7 $ 5 2 7 , 41 7 ($ 3 , 69 4 ) -0 . 70 % $ 5 2 3 , 72 3 $ 5 2 3 , 72 3 To t a l T a r i f f e d S e r v i c e s $ 2 9 , 92 6 , 64 0 $ 0 $ 2 9 , 92 6 64 0 $ 4 3 , 44 7 15 % $ 2 9 , 97 0 , 08 7 $ 2 9 , 97 0 , 08 7 OT H E R R E V E N U E 47 1 0 0 0 Cu s t o m e r F e e s R e v e n u e $4 6 , 13 1 $4 6 , 13 1 00 % $ 4 6 , 13 3 $ 4 6 , 13 3 47 2 0 0 0 Re n t s - Co n s t r u c t i o n M e t e r s $ 1 2 09 5 $ 1 2 , 09 5 00 % $ 1 2 , 09 5 $ 1 2 09 5 47 1 0 0 0 Bu l k H y d r a n t S a l e s $ 8 5 85 6 $ 8 5 , 85 6 ($ 2 8 5 ) 33 % $ 8 5 , 57 1 $ 8 5 85 6 10 , 47 4 9 0 0 Un b i l l e d R e v e n u e $ 1 7 3 , 65 0 (1 7 3 , 65 0 ) ( A ) $ 0 $ 0 00 % $ 0 $ 0 11 , 47 5 2 0 0 Ca r r i a g e H i l l $ 0 62 8 ( 8 ) $ 5 , 62 8 $ 0 00 % $ 5 , 62 8 $ 5 62 8 12 , To t a l O t h e r R e v e n u e $ 3 1 7 , 73 2 ($ 1 6 8 02 2 ) $ 1 4 9 , 71 0 ($ 2 8 3 ) ($ 0 ) $ 1 4 9 , 42 7 $ 1 4 9 , 71 2 TO T A L R E V E N U E 13 , To t a l R e v e n u e $ 3 0 , 24 4 , 37 2 ($ 1 6 8 , 02 2 ) $ 3 0 , 07 6 , 35 0 $ 4 3 , 16 4 14 % $ 3 0 , 11 9 , 51 4 $ 3 0 , 11 9 , 79 9 NO T E S : (A ) E l i m i n a t i o n o f u n b i l l e d r e v e n u e e s t i m a t e s i n c e a l l c o n s u m p t i o n i s a s s u m e d t o b e b i l l e d o n a p r o f o r m a b a s i s (B ) I m p u t a t i o n o f r e v e n u e s f r o m C a r r i a g e H i l l "U e n T I m ~ g . G ) ~ CD C D D 3 c ; : .. . . . . g - Q - . ; : ; : CD 0 " ... . . . ~. . . . . . f f i Id a h o P u b l i c U t i l i t i e s C o m m i s s i o n Of f i c e o f t h e S e c r e t a r y RE C E I V E D FE B 1 0 2 0 0 6 Bo i s e , I d a h o UN I T E D W A T E R I D A H O NO R M A L I Z I N G AD J US T M E N T S T O O P E R A T I N G R E V E N U E U N D E R P E S E NT R A T E S & T O T A L R E V E N U E S U N D E R P R O P O S E D R A T E S FO R T H E B A S E Y E A R E N D E D D e T O B E R 3 1 20 0 5 & T H E T E S T Y E A R E N D E D A P R I L 3 0 20 0 6 (3 1 (4 ) (5 ) (') (7 ) (8 ) (0 ) (1 0 ) Ba s e Y e a r AD ! U S T M E N T S T O R E V E N U E Ad j u s l e d Te s t Y e a r RE V E N U E A T P R O P O S E D R A T E S Re v e n u e f o r We a t h e r Wa t e r U s e Te s t An n u a l i z a t i o n Re v e n u e f o r Re v e n u e s Re v e n u e Pe r c e n t LI N E 12 M o n t h s No r m a l i z i n g Tr e n d Ch a n g e ea r of R a t e C h a n g e s 12 M o n t h s fo r T e s l Ch a n g e Ch a n g e NO . AC C O U N T T I T L E En d e d 1 0 / 3 1 / 0 5 Ad j u s t m e n t s Ad j u s t m e n l s Th r u 4 / 3 1 / 0 6 ve n Du r i n g B a s e Y e a r En d e d 4 / 3 0 / 0 6 Ye a r by C a t e g o r y in R e v e n u e I" h 1 So h 2 P o 1 1 l" h 1 S o h ' P o 1 2 . 22 , 27 1 ,.h 1 S o h ' P O ' 2 22 , 27 ) 1,. h 1 s o h ' P o 1 2 , 22 , 27 ) (( " . . l" h " r h 4 P o ' O ! 1(5 ) + ( 6 ) I l" h " r h 4 P o l 1 l I ( 8 ) o ( ~ I ,,0 ) / ( 7 ) I TA R I F F E D S E R V I C E S ME T E R E D W A T E R SA L E S : Re s K i e n t i a l $ 2 0 , 4 3 1 , 7 4 1 $ 6 7 2 , 65 1 ($ 5 1 29 9 1 14 0 , 7 3 6 ## # $ 1 14 0 , 38 4 I A I $ 2 2 , 33 4 21 4 $ 2 6 , 34 2 , 28 3 $ 4 , 00 8 06 9 17 , 95 % Co m m e r c i a l $ 6 , 67 3 , 18 8 $ 2 1 7 65 2 $ 6 0 , 7 6 7 $3 0 61 5 ## # $ 6 4 3 77 8 I A I $ 9 82 5 , 99 9 $ 1 1 59 0 , 49 8 $ 1 , 7 6 4 , 4 9 9 17 , 96 % Pu b l i c A u l h o r " r $ 1 4 1 43 5 $ 1 9 , 20 9 $ 4 9 $ 2 9 3 # # # $ 1 0 , 4 8 2 I A I $ 1 7 1 , 46 8 $ 2 0 2 , 25 8 $ 3 0 , 76 9 17 , 96 % To t a l Me t e r e d S a l e s $ 2 9 , 44 6 36 4 S 9 0 9 , 51 2 $ 9 , 51 7 $ 1 7 1 , 64 5 U # $ 1 , 79 4 64 4 $ 3 2 , 33 1 68 2 $ 3 8 13 5 03 9 $ 5 , 80 3 35 7 11 . 95 % FI R E P R O T E C T I O N : Pr i v a t e F i r e P r o l e c l i o n $ 5 2 3 12 3 $ 1 0 , 06 6 # # # $ 3 4 62 8 1 8 1 $ 5 6 8 41 7 $ 6 1 0 , 05 8 $ 1 0 1 64 1 11 , 88 % To t a l T a r i f f e d S e r v i c e s $ 2 9 91 0 08 7 $9 0 9 , 51 2 $ 9 51 7 $1 8 1 71 1 $ 1 82 9 , 27 2 $ 3 2 , 90 0 09 9 $ 3 8 80 5 09 7 $ 5 90 4 99 8 17 . 95 % OT H E R RE V E N U E Cu S l o m e r F e e s R e v e n u e $ 4 6 13 3 $ 6 2 9 # # # $ 1 39 7 1 0 1 $ 4 8 15 9 $ 4 8 , 15 9 $ 0 00 % Re n t s . Co n S l r u c t i o n M e I e r s $ 1 2 , 09 5 ## # $ 2 68 0 1 0 1 $ 1 4 , 7 7 5 $ 1 4 77 5 $ 0 00 % Bu i k H y d r a n t S a l e s $ 8 5 85 6 ## # $ 5 , 01 0 1 0 1 $ 9 0 86 6 $1 0 7 18 5 $ 1 6 31 9 17 , 96 % Un b i l l e d R e v e n u e $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 00 % 10 . Ca r r i a g e H i l l $ 5 62 8 ## # $ 0 $ 5 62 8 $ 5 62 8 $ 0 00 % 11 . To t a l O t h e r R e v e n u e $ 1 4 9 71 2 $ 0 $ 0 $6 2 9 08 7 $ 1 5 9 42 8 $ 1 7 5 , 74 6 $ 1 6 31 9 10 , 24 % TO T A L RE V E N U E 12 , To t a l R e v e n u e $ 3 0 11 9 79 9 $ 9 0 9 51 2 $ 9 , 51 7 $ 1 8 2 , 33 9 $ 1 , 83 8 35 9 $ 3 3 , 05 9 , 52 7 $ 3 8 , 98 0 , 84 4 $ 5 , 92 1 31 7 11 , 91 % RE V E N U E RE Q U I R E M E N T $ 3 8 98 1 21 7 DI F F E R E N C E R E V E N U E R E Q U I R E M E N T ' s R A T E P R O O F ($ 3 7 3 ) PE R C E N T D I F F E R E N C E R E V E N U E R E Q U I R E M E N T ' s R A T E P R O O F 00 % NO T E S : (A I A n n u a l i z a l i o n o f m e t e r e d s e r v i c e r a t e i n c r e a s e s d u r i n g b a s e y e a r (B J A n n u a l i z a l i o n o f f i r e s e r v i c e s r a t e i n c r e a s e s d u r i n g b a s e y e a r (e ) A n n u a l i z a t i o n o f m i s c e l l a n e o u s s e r v i c e f e e s i n c r e a s e s d u r i n g b a s e y e a r ,,- - .: . ' '1 J e n ' T I m ~ g . ( j ) ~ CD C D i i J Ng - Q - . ; : : ; : 0 C D 0 - ' - -' - f f i :' , . c: -" , ~) , c ; , .. . . . , . l" . . (~ , 1. . 0 . ::" J REPORT .' ' ' I' , ,~: ' I ' : ;', - '~, '.:i WATER SERVICE REVENU..It:r' )"':"""_..,),. UNITED WATER IDAHO FOR TH E TEST YEAR May 2005 through April 30, 2006 INTRODUCTION This report assesses historical water consumption use patterns for United Water Idaho (United Water or Company), and derives: (1) billed water consumption and revenues; (2) fire protection service revenues; and (3) other miscellaneous revenues, for the Test Year defined as the period from May 31, 2005 through April 30, 2006. The assessment of revenues for this forward looking period was based on the 12-month period November 1, 2004 through October 31, 2005, which is referred to as the Base Year herein, BASE YEAR & TEST YEAR REVENUE: Total revenues booked during the base year totaled $30,244 372 (Exhibit 1, Schedule 1, Page 1 of 2), which are broken down into three categories: Metered Water Sales, Private Fire Protection services and Other Revenue. Total revenue booked during the base year for Metered Water Sales in the United Water Idaho system amounted to $29,399,223 (Exhibit 1, Schedule 1, Page of 2). Revenues as per the determinants in the bill analysis for the base year amounted to $29,446,364; only $47,141 or 0,16% more than the book total (Exhibit Exhibit 1 F. Gradilone Schedule 2 Page 1 of 20 1, Schedule 1, Page 1 of 2, Column 6). The bill analysis determinants were thus established as the basis for the analysis (Exhibit 1, Schedule 1, Page 1 of 2, Column 7), (A complete set of bill analysis reports were obtained for the base year from Untied Water Idaho s billing system. The data from these reports are summarized in Exhibit 1, Schedule 4. Pages 1 to 9 of the Schedule provide detailed tables showing the derivation of the bi II determ i nants for metered sales for the base year, as bi lied and as re-priced under the current tariff. Fire protection revenue as per the books amounted to $527,417 (Exhibit 1, Schedule 1, Page 1 of 2, Column 1). Revenues as per the determinants (Exhibit 1, Schedule 1, Page 1 of 2, Column 6) in the bill analysis were slightly lower at $523,723, The bill determinants as per the bill analysis were used moving forward (Exhibit 1, Schedule 1 , Page 1 of 2, Column 7), Other Revenues, which include customer service fees, bulk water sales, and unbilled revenue totaled $317,732, After eliminating unbilled revenue and adding imputed revenue for Carriage Hill, total base year revenues were $149,712 from these sources.Thus the starting point for the analysis of total base year revenue was $30,119,799 as shown in Exhibit 1, Schedule 1, Page 1 of 2, Column 7. Four adjustments were made to base year revenues: weather normalization, base trend adjustment, growth through April 2006, and full pricing of the resulting bill determinants under the current rate structure. These adjustments (which are summarized in Exhibit 1 , Schedule 1, Page 2 of 2) result in net metered sales revenue of $32,331,682 for the United Water system for the test year. Private fire revenues for the test year total $568,417. Other revenues total $159,428. Therefore total revenue under current rates for the test year were assessed herein to be $33,059,527 (Exhibit 1, Schedule 2, Page 2 of 2), an increase of just over $2.8 million versus revenue booked in the base year. The adjustments that result in this increase are discussed in detail below. The report also contains the calculation of the proposed rate structure to meet the revenue requirement of $38,981 217, and a proof that these rates will generate the revenue required. Exhibit 1 F. Gradilone Schedule 2 Page 2 of 20 REVENUE ANALYSIS: For this assessment, the historical record for the period January 1986 through November 2005 was analyzed. The data, which came from the Company s billing system and other records, included: monthly-billed consumption and the number of customers served by class for each of the three sectors in the United Water Idaho system-residential, commercial and public; fire service counts by service size and type; and, customer service fees and other miscellaneous revenue sources. Linear regression models were developed to assess residential, commercial and public sector water consumption patterns. Trending analysis was employed to project fire protection services and other revenues, These were combined to produce the total billed water consumption and revenue estimates for the base year and the pro forma period. Before reporting the results of these analyses, the following section will describe the linear regression modeling technique, and why it was used in the analysis, LINEAR REGRESSION MODELING Multiple linear regression analysis is a statistical data modeling technique that is used to describe in mathematical terms the relationships between variables. In this case a regression model was developed to assess the relationship between the amount of water consumed by customers in each sector, and a number of factors that are known to affect water use. The result of a regression analysis is an equation that defines the relationship between the variable the analyst wishes to predict (in this case, water consumption) and other variables that are correlated in a systematic way to that variable (in this case, weather conditions, seasonal patterns, water price, and Exhibit 1 F. Gradilone Schedule 2 Page 3 of 20 the addition of new customers to the system). These correlated variables are also known as explanatory variables, A multiple linear regression equation is expressed in general form as: Y = a + bX + cZ + ... + An example of a simple equation that could be used to predict water consumption as explained by the number of customers and the average daily temperature in the system area would be expressed in the form: Consumption = a + b * number of customers + c * average temperature The regression analysis provides values for ", which is a constant (a fixed number), and "b" and ", which are known as coefficients (there is one coefficient generated for each variable that is correlated to the variable that is being modeled). Coefficients can be positive or negative depending upon the relationship between the variable one is predicting and the explanatory variables, To use this equation to predict water consumption for any month, the number of customers to be served in the month is multiplied by the coefficient ", and the temperature in the month is multiplied by and then this result is added to the value for the constant ". For example, if the actual regression equation was: Consumption (CCF) = 70 000 + 20 * number of customers + 50 * average temperature Then consumption for a month in a system that had 50,000 customers and where the average temperature was 70 degrees, would be predicted to be 1,713,500 CCF (Le., 70,000 + (20 * 50,000) + (50 * 70) = 70,000 + 1,000,000 + 3,500), The first step in regression analysis is the creation of a database of historical data that accurately reflects the phenomenon the analyst would like to model. In the process of developing a regression model database, the analyst may use the data in its raw form (for example, the number of customers served), may transform it (for example, take the log of the variable), or may find that it is necessary to add extra variables (referred to as dummy variables) to take into account events or patterns in the time series that are known to have affected the data, but that are not readily Exhibit 1 F. Gradilone Schedule 2 Page 4 of 20 quantifiable (such as a recession, or, changes in non-weather related water use patterns).The data included in the database used in the analysis of billed consumption are described below. Variables Included in Modeling Database:A primary determinant of water demand is the number of customers served. Hence the first variable included in the database was the number of customers served in United Water s service area, Next water use per customer variables were created by dividing the amount of water use by the number of customers served. For the residential and commercial sectors these factors were created using the data as recorded on a monthly basis from United Water Idaho s billing system. For the public sector it was decided to calculate an average customer count number based on the number of customers in service during the summer period, rather than use the actual monthly numbers recorded. A large portion of the customers in the public sector are seasonal, and over the years varying numbers of these customers canceled and restored service each year. As result the number of customers in the winter period are allover the map, some years barely a quarter of the summer count, and in others almost identical to the summer count. Basing the customer count on the summer numbers created a consistent base to work from, and resulted in a more stable analysis. Weather conditions have been shown to effect water consumption patterns in numerous studies of water demand behavior.Based on the underlying climatic regime in an area, and the nature of the customer base, a number of weather related variables have been found to be correlated with water consumption; these include: average temperature, cooling degree days, number of days over 90 degrees Fahrenheit, total rainfall, number of days with rainfall, and the amount of rain per rainfall event. These weather data for the official U,S. Weather Service station for Boise, Idaho (Station CXUS56 KBOI 010933) was obtained for this analysis. Substantial changes in the underlying characteristics of the customer base and customer water use patterns also affect water use patterns, Since 1980 a key factor that has been effecting water use in the United Water Idaho service area, and indeed across the nation, was the passage of Federal Standards that mandated lower water Exhibit 1 F. Gradilone Schedule 2 Page 5 of 20 use for all water using fixtures in households, These standards, affecting toilets, faucets and showerheads, have resulted in a long run decrease in the amount of water used per customer across the U,S. The customers in United Water s service area have also been subject to this trend. In addition, one other factor has resulted in a more pronounced downward pressure on use per customer in the residential sector; the passage of regulations in the mid-1990s that required all new construction to use alternate lawn water supplies, if such supply was available. Customers that must use available irrigation water for lawn watering clearly do not use as much water during the summer months as customers that rely on United Water Idaho s supply. Another key factor effecting water use is the price of the service. United Water Idaho has made significant changes to the structure, and overall price of its tariffs, and these changes have had an impact on water use in the service area. The major structural change was the implementation of summer/winter pricing in 1993. Summer/winter pricing has proven to be an effective tool to manage peak period sales in numerous water systems, and have proven to be effective in the United Water Idaho system as well. Since 1986 the Company has also received a number of rate increases that has seen the average customer bill increase by over 135% on an inflation adjusted basis, These price changes have also had an impact on customer usage during the historical period of record. Two pricing variables were created both assuming a typical customer with a % meter and fixed amount of water for each tariff structure in effect over the period (Exhibit 1, Schedule 3, Page 1 of 37),The first variable was an estimated "Annual Price" which assumed 200 CCF per year for water use.For use under the rate structures that include minimum charges that were in effect prior to 1993 100 CCF was included under the minimum and the remaining 100 CCF was priced at the single commodity rate in the tariff. For use under the rate structures with the summer/winter component, the price included the fixed service charge for a %" meter plus pricing of 200 CCF of use on a pro-rated basis using a Y2 month convention for each rate changeover. (That is, for January through April, and November through December, use was priced wholly at the winter rate; June through September were Exhibit 1 F. Gradilone Schedule 2 Page 6 of 20 priced wholly at the summer rate; and May and October were priced half at the winter rate and half at the summer rate). The second variable was a "Marginal Price that also assumed 200 CCF per year, but pricing all use at the highest marginal rate (for the tariffs in effect prior to 1993 this was the single commodity rate in the tariff, and for the tariffs in effect after1993 this was the summer rate); the assumption being that customers ultimately modified behavior based on the highest price signal received during a year. Note however, that the pricing variables do not correspond to a typical bill, since there is no typical bill for the full range of residential, commercial and public customers in the United Water Idaho service area, Rather the variables constructed represent the relative change in rates that customers experienced since 1986, Based on marginal cost pricing theory each customer would have reacted to these price changes individually; some would have not changed their behavior at all, some would have changed their behavior dramatically. By capturing the relative change in rates in these variables, regression modeling is able to assign a value for the aggregate change in the behavior of all customers in the service area due to the change in rates over time. Finally, the changing seasons and economic activity patterns also need to be accounted for. For example, in the summer months, warmer temperatures and drier conditions in general, result in higher water use due to increased lawn watering, outdoor activities and business uses-for example, air conditioning make-up water and evaporative cooling systems. (Specific weather conditions in a month will either suppress or enhance the basic pattern, hence monthly weather data is included in the analysis to help develop a better predictive model of water demand behavior. The specific months included in the database to measure these pattern effects were determined by an indexing procedure. The indices were developed using a medial averaging methodology. Arithmetic averages are sensitive to outliers; that is, extreme data points either on the high or low end. The medial average is the arithmetic average of a data set, excluding the high and low values in it. Using a medial average is a systematic way to remove extremes from a data set, thus yielding Exhibit 1 F. Gradilone Schedule 2 Page 7 of 20 more stable results. The monthly pattern index developed for each sector is shown in Exhibit 1, Schedule 3, Page 2 of 37, Model Verification Regression analysis provides the analyst with measures of how good the model is at explaining the variable the analyst is trying to predict, and defines in statistical terms how accurate the model is. The first step in verifying the validity of a regression model is to determine the goodness-of-fit of the equation as defined by the statistics generated in the process. The overall goodness of fit is represented by a statistic called R-squared. R-squared is a measure of the total variance explained by the regression equation, If there were no relationship between the explanatory variables and the predicted variable, then R- squared would be 0%; if there were a perfect relationship between the variables, then R-squared would be 100%. In general, higher r-squares are associated with better predictive ability, although a high R-squared is no guarantee of absolute predictive ability. In any regression analysis there remains a danger that the R-squared value may reflect nothing more than spurious correlation, For this reason, in addition to determining the "goodness-of-fit", as measured by the R-squared statistic, it is necessary to test the logic and believability of the regression equation both as to the size and the direction of any apparent causality, and to verify the accuracy of the model by comparing actual consumption in past periods against the estimates generated by the model, The second step in the verification process is therefore to determine if the equation makes intuitive sense, For example, a coefficient representing the number of days over 90 degrees Fahrenheit should be positive, confirming the intuitive notion that as the temperature increases, so to does water consumption. Likewise, the number of days with precipitation, as logically expected, should be negatively correlated with water demand. The final step in the verification process is using the model to estimate consumption over the same time period as the original database. The model, while Exhibit 1 F. Gradilone Schedule 2 Page 8 of 20 showing variances in each year, on an average basis for the entire base period should yield low absolute and percentage variances, The regression modeling was performed on a Compaq computer using the Microsoft Excel 2000 Version of the software package. A number of iterations and combinations of weather variables were tried; the results presented here represent the best-fit models for each sector. METERED SALES CONSUMPTION ANALYSIS Residential Sector Consumption Analysis: Exploratory data analysis revealed that weather conditions, as expected, affected water use in the United Water Idaho service territory. The residential sector also exhibited a strong seasonal pattern, with consumption in the summer months being up to four times as high as the winter months. Therefore, regression models were developed that took into account the impact of weather conditions and the change in the seasons. Given the large difference in the demand patterns between the summer and winter seasons, and the fact that weather variables have a negligible impact on water use patterns in the winter (and that therefore, weather fluctuations are not highly correlated with water use in the winter) it was decided to assess water consumption separately for the winter and summer periods.Based on an analysis of water use patterns over the course of the year, the months of January through April were established as the winter/base period, while May through December was established as the summer/peak period (Exhibit 1, Schedule 3, Page 2 of 37). The evident shifting forward in timing of the peaks and valleys of the water use pattern is the result of the lag in billing customers every two months. For example, this results in including months such as April in the winter/base period, even though intuitively one would think it should be included in the summer/peak period. And, vice versa November is in the summer/peak period rather than the winter/base period. Exhibit 1 F. Gradilone Schedule 2 Page 9 of 20 WINTER PERIOD ANAL YSIS: The number of residential customers served by month in United Water s service area is shown in Exhibit 1, Schedule 3, Page 3 of 37. shown on this table, the number of residential customers has been exhibiting a steady upward trend, but that the trend was disturbed on three occasions due to recoding of customers and acquisitions of new system areas. In early 1989 apartment buildings in the service area were reclassified as commercial customers resulting in a loss of 897 "residential" customers in the dataset, resulting in "negative" growth in the sector for that year. In the 1996-97 period about 000 customers in Garden City, Warm Springs Mesa, Redwood Creek, Island Woods and Banbury were added to the system, bumping up the growth for that year. The recoding of customers in 1989 and the addition of customers in the 1996-97 period did not seem to appreciably affect the amount of water used per customer; use per customers continued to decrease at about the same rate as it had been since the early 1990s, owing to the introduction of water saving plumbing fixture standards at the Federal level and other local factors. In 1999, South County, Barber and Raintree were added. The acquisition of these service areas added 4,800 customers to the system, representing a large one- time increase of over 9% in the residential customer base, and more importantly induced a further decrease in the trend in the amount of water used per customer. The addition of this block of customers put downward pressure on the use per customer trend for two reasons. One, alternate irrigation water was readily available and used extensively in these areas, and two, in the case of South County, water rates were much lower than United's rates, and these lower rates were increased to the United water tariff over a 5 year phase-in period, Hence, the customers experienced a substantial increase in water bills over this period, and reacted accordingly and reduced water use. In the end it was found that for the winter period, a regression of residential water use per customer versus time, a variable representing the marginal price of water, and a dummy variable to account for the addition of South County in 1999 Exhibit 1 F. Gradilone Schedule 2 Page 10 of 20 and the phase-in of United Water rates, resulted in the best fit, even though the squared for the equation representing residential water use for the winter season was a relatively low 27% (Exhibit 1, Schedule 3, Page 4 of 37, and shown graphically in Exhibit 1, Schedule 3, Page 5 of 37). Mitigating against the low R-squared was the fit of the equation to actual results, As shown in Exhibit 1, Schedule 3, Page 6 of 37, the regression estimates for winter water use were on average within 0,01 % of the actual, and the highest individual year variance was only 6,5%, Based on this analysis, winter consumption for the test was adjusted upwards by 47 851 CCF. Actual consumption in the base year was 1,829,627 CCFi the regression estimate was 1,877,478 CCF. SUMMER PERIOD ANAL YSIS: For the summer period, average monthly temperature, total monthly rainfall, the marginal price of water and dummy variables to account for the addition of South County to the service area and the monthly pattern of use over the summer months, proved to be the best combination of variables to predict summer water use per customer. The statistics for the regression analyses for the residential sector are summarized in Exhibit 1, Schedule 3, Page 7 of 37. The R- squared for the equation for peak use per customer was quite good - 91.8% - particularly given the complexity of the phenomena being measured. The variability from year-to-year for summer use is a bit higher than the winter model owing to the volatility of use during the summer as shown in Exhibit 1, Schedule 3, Page 8 of 37, however on average the regression estimates differed from actual results by only 33%. NORMALIZING ADJUSTMENTS: The next step in the analysis was to normalize metered sales revenues to account for the weather conditions during the summer/peak period during the base year, and the projected change in the number of customers through the end of the test year. The weather normalization was accomplished by recomputing the regression results for the summer/peak period using the long run medial average of the weather Exhibit 1 F. Gradilone Schedule 2 Page 11 of 20 conditions for the period 1986 to 2005 for the months May through December, rather than the actual weather during the period, This provides an estimate of what water sales would have been if weather conditions had been "normal", rather than being cooler and wetter as they actual were. In order to provide a better match between the weather conditions that influenced customers during the bi-month billing cycle used by United Water Idaho, a new weather variable was created that took the two month lag in billing into effect. This was accomplished by using a standard pro ration technique for a bi-monthly cycle where the weather in any given month was calculated to be of the actual weather (i.e., temperature, rainfall, etc.) for two months prior, 1/2 of the actual for the month immediately prior and ~ of the current month, The actual, and lagged, temperature and rainfall dataset is shown in Exhibit 1, Schedule 3, Page 9. The lag, resulting from bi-monthly billing, is clearly evident on these graphs, Comparing the lagged actual weather conditions for the summer 2005 period versus the lagged normalized conditions shows that in the first three months of the summer period (May, June and July) weather conditions were generally cooler and wetter than normal, as indicated by the bolding in the table below. September the temperature was at or above normal , but In August and Actual VS. Normalized Weather Conditions Summer 2005 PARAMETER MAY JUN JUL AUG SEP Da 5 with Preci itation rainfall totals were very close to the norm, which for these two months were only 0.32 and 0.27 inches respectively. Based on these conditions the weather adjustment was expected to be positive, as indeed it was. The total weather normalizing adjustment as shown in Exhibit 1, Schedule 3, Page 8 of 37, amounts to 431,426 CCF, or, 4,2% higher than actual use. Total normalized peak/summer use in the base Exhibit 1 F. Gradilone Schedule 2 Page 12 of20 year was therefore calculated to be 10,748,285 CCF versus actual use of 10,316,859 CCF, To calculate the dollar value of the base/winter and peak/summer variances, total normalized use for the base year was then allocated to the months in the base year based on the long run average index of billings in the residential sector as shown in Exhibit 1, Schedule 3, Page 2 of 37, These calculations are summarized in Exhibit 1, Schedule 3, Page 10 of 37 in the column headed "Indexed Use The next step in the analysis was to derive the revenue impact of these variances. This was accomplished by pricing total actual use, versus the adjusted base year totals based on current rates. For these calculations an effective monthly rate was calculated assuming normal billing lags and the pro ration of bills that occur over the course of a year. The derivation of the Effective Rates is shown in Exhibit 1, Schedule 3, Page 11 of 37. As shown in Exhibit 1, Schedule, Page 10 of 37 the trend and weather normalization adjustments were (47,011) CCF and 526,289 CCF respectively. The total adjustment in dollar terms as shown in Exhibit 1, Schedule 3, Page 12 of 37 amounted to $621,353, with ($51,299) being the trend adjustment during the winter/base period, and $672 651 being the weather normalization adjustment during the peak/summer period. TEST YEAR GROWTH ADJUSTMENTS: For the six months following the end of the base year (November 2005 through April 2006) the number of customers added to the system is projected to total 1 031. That is, growth in this six month period would be the same as experienced during the 6 month period immediately prior, which corresponds to the last 6 months of the base year. To account for the impact of this anticipated growth through April 2006, these customers were priced on a month by month basis. As shown in Exhibit 1, Schedule 3, Page 12 of 37 an adjustment of an additional $94,902 was made to pro forma revenues to account for metered sales, Given United Water s bi-monthly billing cycle it would also be expected that the customers added to the system during the 6 month period from November 2005 through April 2006 would be billed 3 times on average (i,e., Y2 of Exhibit 1 F. Gradilone Schedule 2 Page 13 of 20 the 6 bills normally rendered to customers).These customers would therefore be expected to generate an additional 3,039 bills. It was assumed that the customers added to the system (and hence the bills generated) would be in proportion to the existing mix of customer by meter size as shown in Exhibit 12, Schedule 3, Page 13 of 37.As shown in Exhibit 1, Schedule 4, Page 10 of 11, these added bills would produce $45,834 in new fixed service charges at current rates. Therefore the total test year adjustment for the residential sector amounts to $140,736 (Exhibit 1, Schedule 1, Page 2 of 2, Column 4). Total adjusted test year revenue for the residential sector was thus evaluated to be $21,193,830, or $762,089 higher than booked, Commercial Sector Consumption Analysis:During the late 1980's and early 1990's Micron Technology was United Water Idaho s largest single customer (Exhibit , Schedule 3, Page 14 of 37). Indeed, in 1989, and again in the 1994-1996 period, Micron accounted for over 3% of total water sales.Beginning in 1996 Micron Technologies embarked on a major efficiency and water reuse program, and has experienced a changed business environment, and as a result water sales to Micron have dropped precipitously. Micron no longer is the single largest user in the system. Indeed in the base year its demand was less than 20% of its peak demand of nearly 605,000 CCF in 1995-96, During the base year Micron consumption amounted to only 118,873 CCF, While Micron would seem to no longer require a separate analysis, in order to make comparisons between the prior case and the two prior cases, and leaving open the possibility that Micron s usage pattern may yet change again, it was decided to continue to back out Micron s use from the commercial sector s consumption history before the regression analysis proceeded, (The consumption for Micron was added back into the commercial sector, later in the analysis, The assessment of the commercial sector s consumption per customer for the winter period (defined as january through March), showed that a regression model of total monthly consumption per customer during versus time and the addition of South Exhibit 1 F. Gradilone Schedule 2 Page 14 of 20 County proved to be the best model (Exhibit 1, Schedule 3, Page 15 of 37 and graphically in Exhibit 1, Schedule 3, Page 16 of 37). While the overall trend in water use per customer is down, as shown in Exhibit 1, Schedule 3, Page 17 of 37, for the base year the analysis indicates an upward trend adjustment of 27,081 CCF. For the summer period consumption per customer was regressed against the time, average monthly temperature, total rainfall, price, the addition of South County, and monthly pattern variables to account for seasonal economic activity for the months of May through December (Exhibit 1, Schedule 3, Page 18 of 37), The R- squared for this equation was just over 91.4%. The average annual variance was a little over 11,000 CCF, only 0.22% (Exhibit 1, Schedule 3, Page 19 of 37), NORMALIZING ADJUSTMENTS: The next step in the analysis was to normalize metered sales revenues for the weather conditions during the base year. The commercial sector was also effected by the cooler and wetter weather conditions that prevailed during the summer of 2005, and hence an upwards normalizing adjustment of 215,285 CCF was made as shown in Exhibit 1, Schedule 3, 19 of 37. Total adjusted base year consumption was therefore assessed to be 6,691,204 CCF versus actual consumption of 6,648,838 CCF (Exhibit 1, Schedule 3, Page 20 of 37). For the test year commercial consumption was projected to total 6,712,571 CCF. To enable a direct comparison to the pattern of use in the base year and test year, adjusted consumption totals were allocated by month using the same indexing technique used in the residential analysis as shown in Exhibit 1, Schedule 3, Page 10 of 37. At this point Micron was added back into the analysis. Given Micron volatility, it was decided to assume that for the normalized base year and pro form year that the amount of use for Micron would be set at the same level as recorded during the base year, that is, 118,873 CCF. Total commercial sector water sales were therefore assessed to be 6,810,077 CCF for the normal ized base year, and 6,831,444 CCF for the test year (Exhibit 1, Schedule 3, Page 21 of 37). In revenue terms these levels of use translate into a total base year adjustment of $278,418; $60,676 of Exhibit 1 F. Gradilone Schedule 2 Page 15 of 20 which was the trend adjustment and $217,652 being the weather adjustment (Exhibit 1, Schedule 3, Page 22 of 37). GROWTH ADJUSTMENTS: For the test year an additional $256,653 in billed revenues are projected for the commercial sector, During the base year 84 new commercial customers were added to the system. An additional 52 are projected to be added by April 2006, Assuming these customers are billed 3 times on average over the six month period following the base year, an additional 157 bills would be rendered (Exhibit 1, Schedule 3, Page 13 of 37). It was also assumed that these additional customers would be added to the system in the same proportion with respect to the size of the meter as customers in the existing system. Additional fixed service charges therefore totaled $3,962 (Exhibit 1, Schedule 4, Page 10 of 11). Adjusted test year revenues for the commercial sector at prevailing rates were therefore evaluated to be $9,182,222. (Exhibit 1, Schedule 1, Page 2 of 2). Public Sector Consumption Analysis:The analysis of the public sector paralleled the analysis of the residential and commercial sectors. The winter period for the public sector was defined as January through April. To assess public use during the winter period a simple trend of the use per customer during the winter months was calculated (Exhibit 1, Schedule 3, Page 23 of 37). This yielded a 45 CCF trend adjustment for the base year (Exhibit 1, Schedule 3, Page 24 of 37). For the summer period, a regression equation that incorporated the number of customers, total rainfall, and monthly pattern variables for the months of May through November, were included in the model (Exhibit 1, Schedule 3, Page 25 of 37). The R-squared for the public sector model was also quite good at 64%. The average normalized variance for the model was only 1 %, Following the experience of the residential and commercial sectors the weather adjustment for the public sedor was also positive at 16,216 CCF (Exhibit 1, Schedule 3, Page 26 of 37).The total adjustment to base year revenues as shown in Exhibit 1, Schedule 3, Page 27 of 37 Exhibit 1 F. Gradilone Schedule 2 Page 16 of 20 were therefore $19,259 (consisting of a $49 trend adjustment, and a $19,209 weather normalization adjustment). No change in the number of public sector customers occurred during the base year, and no changes in the number of public customers, and hence customer service fees, are expected through April 2006, However, the underlying growth trends and weather normalization resulted in a billed water use adjustment of $293, yielding total adjusted test year revenues of $160,987 for the public sector (Exhibit 1 , Schedule 1, Page 2 of 2). PRIVATE FIRE PROTECTION SERVICES REVENUE Private Fire Protection revenues at current rates collected during the base year based on the bill determinants totaled $523,723 as shown in Exhibit 1, Schedule 3, Page 28 of 37. Pricing these bill determinants under the current rate schedule yields total revenues of $557,819 (Exhibit 1, Schedule 3, Page 29 of 37). Due to growth in the number of private fire services during the year and anticipated through April 2006 an additional $10,066 in revenues were added to the total to derive total private fire revenues of $567,884 for the test year (Exhibit 1, Schedule 3, Page 30 of 37). OTHER REVENUES The Company receives revenues from a number of customer service related charges (including customer service fees, rents for construction meters, and bulk water sales) as shown in Exhibit 1, Schedule 1, Page 1 of 2. During the base year these revenues totaled $144,082, or less then 0.50% of total revenues.In addition, $173,650 in unbilled revenues was recorded on the books during the base year. The first adjustment to other revenues was to eliminate unbilled revenues, since the analysis for the base year assumes that all fixed service charges and consumption for all customers were billed and collected. Exhibit 1 F. Gradilone Schedule 2 Page 17 of 20 Customer service fees for returned checks and reconnection fees totaled $46,133 during the base year (Exhibit 1, Schedule 3, Page 31 of 37). The returned check fee was increased from $15 per item to $20 per item in August 2005. Assuming all returned checks during the base year were charged at the new tariff rate, an additional $1,397 in customer service revenue would have been collected (Exhibit 1, Schedule 3, Page 32 of 37). Next, assuming that customers added to the system incur return check fees and request meter reconnections at the same rate as the existing customer base, another $629 in customer service revenue are projected for the test year (Exhibit 1, Schedule 3, Page 33 of 37). Rents for temporary construction meters totaled $12,095 during the base year (Exhibit 1, Schedule 3, Page 34 of 37), The tariffed rate for this service was also increased in August of 2005; from $20 to $25, Assuming all rentals were billed at the $25 rate rentals would have totaled $14,775 in the base year. No adjustment was made for the test year since the level of construction activity is expected to be about the same as during the base year. Bulk water sales though hydrants generated $85,856 in revenue during the base year (Exhibit 1, Schedule 3, Page 35 of 37). These services are billed under the general metered sales rate structure for United Water Idaho (Le" a fixed charge based on meter size, and then commodity charges based on usage). United Water rates were increased doing the base year. Pricing the bulk hydrant sales bill determinant for the base year under the current rate structure would have generated an additional $5,010 in revenue, Other Revenues for the test year as adjusted total $159,428 (Exhibit 1, Schedule 1, Page 2 of 2). ADJUSTMENTS DUE TO RATE CHANGES Exhibit 1 F. Gradilone Schedule 2 Page 18 of 20 United Water Idaho tariffed rates were increased twice during the base year. Once under IPUC Order 29838, on August 2, 2005, and next under IPUC Order No. 29871, on September 28, 2005. In order to evaluate the total revenues that would be generated for the test year, the bill determinants, as adjusted, for metered sales, fire protection and other revenues were priced at the rates currently in effect, that is those that were effective as per Order No. 29871 Total adjusted pro forma metered sales revenue as billed as shown in Exhibit 1, Schedule 1 , Page 2 of 2, Column 5 were $30,537,038. Metered water sales for the test year priced at current rates total $32,331,682, that is, pricing the bill determinants for the test year as adjusted yielded an additional $1,794,644 in revenue as shown in Exhibit 1, Schedule 4 page 10 of 11. Fire protection revenue for the test year are projected to be $44,695 higher if these services are billed at current rates (Exhibit 1, Schedule 3, Page 30 of 37), for a total of $567,884. And, in the Other Revenue category, pricing the anticipated bulk rate sales at current rates yields an additional $9,087 in revenue (Exhibit 1, Schedule 3, Page 35 of 37), boosting Other Revenues to a total of $159,428. In total, therefore, test year revenues for United Water Idaho for this rate proceeding amounts to $33,059,527 as shown in Exhibit 1, Schedule 1, Page 2 of 2, Column 7. REVENUE SUMMARY & PROPOSED RATE SCHEDULE The base year in this case has been established as November 1, 2004 through October 31, 2005. Total pro forma revenues for United Water Idaho for the test year (May 31, 2005 through April 30, 2006) after considering anticipated growth through April 2006, were assessed at $33,059,527 (Exhibit 1, Schedule 1, Page 2 of 2). Based on this filing the Company is asking for an increase in revenues of $5,921,690, for a total revenue requirement of $38,981,217, or an overall increase of 17.91 %. The Exhibit 1 F. Gradilone Schedule 2 Page 19 of 20 Company proposes to increase rates to meet its revenue requirements on an across the board basis. In order to generate the revenue requirement tariff rates for metered water use and private fire protection services would have to be increased by 17.95% (this is slightly higher than the overall increase to compensate for the categories of other revenues-Customer Service Fees and Construction Meter Rentals-that will not be affected by the tariff change,) The derivation of the proposed rate schedule is shown in Exhibit 1, Schedule 3, Page of 36 of 37. The rate proof for the residential, commercial and public sectors for the United Water Idaho service area is shown in Exhibit 1, Schedule 4, Page 11 of 11. And finally, the proof of fire rates is shown in Exhibit 1, Schedule 3, Page 37 of 37. Total revenues generated by the proposed tariffs are $38,980,844, $373 less than the revenue requirement. (It was not possible to reduce the difference to a lesser number due to rounding fixed services charges to the nearest penny,) The proposed tariff schedule is included as Exhibit 2, Schedule 2 of the filing. Exhibit 1 F. Gradilone Schedule 2 Page 20 of 20 EF F E C T I V E Mi n i m u m f o r Al l W a t e r MA R G I N A L ES T I M A T E D DA T E O F Fi r s t 1 00 0 Us e O v e r CU S T O M E R CU S T O M E R TA R I F F 10 0 C F PR I C E * PR I C E * * Ja n u a r y 7 , 1 9 8 3 $ 1 5 , 50 9 6 $ 6 7 $ 6 7 Ja n u a r y 2 , 1 9 8 6 $ 1 7 . 4 1 56 5 8 $ 7 4 $ 7 4 Au g u s t 1 5 , 1 9 8 7 $ 1 6 . 54 3 0 $ 7 1 $ 7 1 No v e m b e r 9 , 1 9 9 0 $ 1 6 , 63 8 0 $ 8 1 $ 8 1 Au g u s t 1 3 , 1 9 9 4 $ 1 6 , 83 7 0 $ 1 8 4 $ 1 8 4 Fi x e d Su m m e r Se r v i c e Su m m e r Ra t e p e r 1 Ch a r g e f o r Wi n t e r R a t e Ra t e f i r s t CF O v e r 3 3/4 " Me t e r pe r 1 0 0 C F 3C C F CC F Ju l y 2 5 , 1 9 9 4 $ 1 2 . 80 9 0 $1 , 01 1 0 $ 2 1 4 $ 2 1 4 Oc t o b e r 2 8 , 1 9 9 6 $ 1 2 . 4 3 83 8 3 $ 1 , 04 7 6 $ 2 2 2 $ 1 8 0 Ja n u a r y 6 , 1 9 9 8 $ 1 3 , $0 , 91 1 3 $ 1 . 13 8 8 $ 2 4 1 $ 2 4 1 Se p t e m b e r 5 20 0 0 $ 1 4 , 98 2 5 $ 1 . 22 8 1 $ 2 6 0 $ 2 6 0 Au g u s t 2 20 0 5 $ 1 4 , $ 1 , 08 6 5 $ 1 . 08 6 5 $ 1 . 35 8 1 $ 2 8 6 $ 2 8 6 Se p t e m b e r 2 8 20 0 5 $ 1 4 , $ 1 , 09 1 2 $1 , 09 1 2 $ 1 . 36 4 1 $ 2 8 7 $ 2 6 0 NO T E : Pr i c e s b a s e d o n a c u s t o m e r w i t h 3 / 4 " m e t e r a n d a s s u m i n g 20 0 CC F o f w a t e r u s e i ' * M a r g i n a l p r i c e a s s u m e s a l l w a t e r p r i c e d a t h i g h e s t r a t e ; L e " t h e h i g h e s t p r i c e a c u s t o m e r w o u l d s e e d u r i n g a Y~ I Fo r r a t e s t r u c t u r e s w i t h M i n i m u m p r i c e = M i n i m u m + R a t e * 10 0 ... Fo r S u m m e r / W i n t e r r a t e s t r u c t u r e p r i c e = F i x e d + S u m m e r R a t e * 20 0 .. . ** E s t i m a t e d p r i c e a s s u m e s p r o r a t i o n o f p r i c e f o r s u m m e r a n d w i n t e r p e r i o d s b a s e d o n 1 / 2 m o n t h c o n v e n t i o n .. ' Fo r r a t e s t r u c t i u r e w i t h M i n i m u m p r i c e = M i n i m u m + R a t e * 10 0 Fo r S u m m e r / W i n t e r r a t e s t r u c t u r e p r i c e = F i x e d + S u m m e r R a t e * 8 3 + W i n t e r R a t e * 1 1 7 ,- , , , UN I T E D W A T E R I D A H O Re l a t i v e W a t e r P r i c e f o r T y p i c a l Cu s t o m e r "U en "T I m ~ g . G ) ~ CD C D D 3 O : .. . . . . g - Q - . ; : ; : CD 0" " " " c.. . . J C D u; , . en - '- . . . . UNITED WATER IDAHO Index of Use by Month BOLD = SEASONAL MONTHS Residential Sector Commercial Sector Public Sector November December January February March April May June July August September October 112% 66% 44% 42% 41% 42% 60% 94% 150% 185% 205% 157% 108% 89% 53% 60% 50% 63% 62% 104% 118% 170% 159% 165% 122% 57% 13% 49% 88% 185% 219% 234% 208% 250%Residential Sector 200% 150% 100%~,Winter Months 50% NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT Commercial Sector 200% 150% 100%Winter Months 50% NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT 250%Public Sector 200% 150% Winter Months 100% 50% NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT Exhibit No. F. Gradilone Schedule 3 Page 2 of 37 UN I T E D W A T E R I D A H O Re s i d e n t i a l S e c t o r C u s t o m e r C o u n t "U e n " T l m ~ g . G ) ~ (J ) ( J ) i i J c . : "" g - Q - . ; : : + 0 C D 0" " " " .. . . . . :: : J ~ " " (J ) No v e m b e r Cu s t o m e r Ch a n g e i n to O c t o b e r Co u n t Cu s t o m e r s Si g n i f i c a n t E v e n t s 86 - 16 8 70 4 87 - 91 8 79 9 88 - 15 6 (2 4 ) C : : M u l t i - fa m i l y t o C o m m e r c i a l 89 - 13 4 1 , 4 2 9 90 - 53 0 29 3 91 - 94 0 52 8 92 - 35 5 37 7 93 - 95 0 75 8 94 - 37 6 09 1 95 - 47 , 4 3 7 04 2 96 - 01 5 01 8 c: : A d d i t i o n o f G a r d e n C i t y + 97 - 50 , 4 6 3 95 3 98 - 14 0 55 1 c: : A d d i t i o n o f S o u t h Co u n t y + 99 - 58 3 21 6 00 - 66 8 75 8 01 - 21 7 17 3 02 - 64 4 98 1 03 - 70 9 11 6 04 - 88 6 27 8 Th r u 4 / 0 6 68 , 89 9 01 3 UN I T E D W A TE R I D A H O Re s i d e n t i a l Se c t o r : W i n t e r Us e Re g r e s s i o n A n a l y s SU M M A R Y O U T P U T Re g r e s s i o n S t a t i s t i c s Mu l t i p l e R 52 . 00 % R S q u a r e 27 , 04 % Ad j u s t e d R S q u a r e 24 , 16 % St a n d a r d E r r o r Ob s e r v a t i o n s AN O V A Si g n i f i c a n c e F Re g r e s s i o n 16 , Re s i d u a l 76 , 44 . To t a l 79 , 61 . 4 5 Co e f f i c i e n t s St a n d a r d E r r o r t S t a t P- v a l u e Lo w e r 95 % Up p e r 95 % Co n s t a n t 13 , 12 0 4 5 23 , Ti m e 00 0 1 5 Pr i c e 00 0 0 1 So . C o u n t y 0. 4 9 1 0 6 0. 4 5 0. 4 0 "U e n . , . , m ~ g . G ) ~ (1 ) ( 1 ) O J 5 ' -1 ' 0 - g . Q- . ; : + CD 0 " " ' " .. . . ~c . . ; I (1 ) lJ c n T l m ~ g . ( j ) ~ CD C D D J C : 01 g - Q- . ; : : ; : CD 0 " " " " :: J ~c . v j: : : Li : Re s i d e n t i a l W i n t e r Us e p e r C u s t o m e r S6 J - S7 J- S S J - S 9 J - 90 J - 91 J- 9 2 J - 9 3 J - 94 J - 95 J- 9 6 J - 9 7 J- 9 S J - 99 J - OO J - O1 J - O2 J- O 3 J - O 4 J - O5 J - .. . - A c t u a l - - - A v e r a g e .. - T r e n d UN I T E D W A T E R I D A H O Re s i d e n t i a l W i n t e r W a t e r U s e Pe r c e n t Di f f e r e n c e Di f f e r e n c e Ja n t o A p r i n a N o v Re g r e s s i o n Re g r e s s i o n Ac t u a l v s . Ac t u a l v s . Oc t B a s e Y e a r i n Ac t u a l W i n t e r U s e Es t i m a t e o f W i n t e r Es t i m a t e o f W i n t e r Re g r e s s i o n Re g r e s s i o n CC F Ac t u a l W i n t e r U s e pe r C u s t o m e r Us e p e r C u s t o m e r Us e Es t i m a t e Es t i m a t e 22 6 , 79 5 33 , 33 , 22 7 50 2 70 8 06 % 22 0 96 0 33 , 33 , 24 3 , 08 8 12 9 81 % 29 2 16 2 34 , 33 , 25 9 , 61 5 54 7 52 % 25 2 03 4 33 , 33 , 26 3 , 86 4 82 9 94 % 25 8 75 3 32 , 33 , 28 1 91 7 16 4 84 % 31 5 04 8 32 , 32 , 32 2 04 2 99 4 53 % 36 1 40 9 32 , 32 , 35 6 78 3 62 6 34 % 39 6 32 7 32 . 4 32 . 4 39 5 , 12 4 20 3 09 % 53 4 54 7 34 . 4 32 , 1, 4 3 4 92 1 99 , 62 6 6. 4 9 % 1, 4 1 0 79 2 30 , 32 , 1, 4 7 4 , 17 3 63 , 38 0 4. 4 9 % 50 4 73 8 31 , 31 , 1, 4 9 7 80 4 93 5 0. 4 6 % 1, 4 9 1 63 3 30 . 31 , 52 8 , 73 9 10 6 2. 4 9 % 59 4 28 6 31 , 31 , 57 4 04 5 24 1 27 % 77 6 90 3 32 , 31 , 72 3 , 95 9 94 4 98 % 79 5 18 8 30 , 30 , 77 7 08 8 10 0 01 % 69 3 63 7 28 , 29 , 80 4 32 0 11 0 68 3 54 % 80 1 77 9 29 . 29 , 81 5 88 8 10 8 78 % 81 0 03 0 28 , 28 , 81 1 , 4 4 7 1, 4 1 7 08 % 93 4 83 1 29 , 28 , 83 4 , 4 0 3 10 0 , 4 2 8 19 % 82 9 62 7 27 , 27 , 87 7 47 8 85 1 62 % AV E R A G E 52 5 , 07 4 31 . 31 . 52 5 , 21 0 13 6 01 % "U e n ' T I m ~ g . G ) ~ CD C D 0 3 5 ' 0' ) g . 9 - . ;:: ; : 0 C D 0 " " " .. . . VJ V J C D -. J UN I T E D W A T E R I D A H O Re s i d e n t i a l S e c t o r : S u m m e r U s e R e g r e s s i o n A n a l y s i s -a c n - " m ~ g . G ) ~ CD C D Q 3 C ' " g - Q- . ; : : ; : CD 0 " " " ::: J VJ V J C D SU M M A R Y O U T P U T Re g r e s s i o n S t a t i s t i c s Mu l t i p l e R 95 . 82 % R S q u a r e 91 , 82 % Ad j u s t e d R S q u a r e 91 , 21 % St a n d a r d E r r o r Ob s e r v a t i o n s 15 9 AN O V A Si g n i f i c a n c e F Re g r e s s i o n 11 . 94 5 , 35 8 , 15 0 , Re s i d u a l 14 7 , 33 0 , To t a l 15 8 , 27 6 . 4 2 Co e f f i c i e n t s St a n d a r d E r r o r t S t a t P- v a l u e Lo w e r 95 % Up p e r 95 % Co n s t a n t 27 1 0 2 5. 4 6 14 , Pr i c e 01 4 0 2 So Co u n t y 28 8 1 7 Ay g T e m p 35 2 8 0 Ra i n f a l l 23 8 0 6 5. 4 8 4. 4 1 Ma y 01 2 3 9 Ju n 24 4 9 9 Ju l 39 8 9 4 3. 4 4 13 , Au g 12 2 2 9 17 , Se p 13 . 18 3 2 4 21 , Oc t 7. 4 1 6 9 0 2. 4 4 1. 4 1 13 . 4 3 No y 4. 4 0 0 2 8 UN I T E D W A T E R I D A H O Re s i d e n t i a l Su m m e r W a t e r Us e Pe r c e n t No r m a l i z e d Di f f e r e n c e Pe r c e n t Re g r e s s i o n Di f f e r e n c e Di f f e r e n c e Re g r e s s i o n No r m a l i z e d Ac t u a l v s , Di f f e r e n c e Ma y t o D e c i n a Ac t u a l Es t i m a t e o f Re g r e s s i o n Ac t u a l v s , Ac t u a l v s . Es t i m a t e o f Re g r e s s i o n No r m a l i z e d Ac t u a l v s . No v - Oc t B a s e Ac t u a l Su m m e r U s e Su m m e r U s Es t i m a t e o f Re g r e s s i o n Re g r e s s i o n Su m m e r U s e Es t i m a t e o f Re g r e s s i o n No r m a l i z e d Ye a r i n C C F Su m m e r U s e pe r C u s t o m e r pe r C u s t o m e r Su m m e r U s e Es t i m a t e Es t i m a t e pe r C u s t o m e r Wi n t e r U s e Es t i m a t e Es t i m a t e 86 - 7, 7 4 8 , 90 2 20 7 . 21 0 . 3 86 3 67 8 11 4 77 6 1. 4 6 % 20 5 , 68 7 27 9 62 3 80 % 87 - 52 4 31 2 22 3 . 4 21 0 , 03 6 96 5 48 7 34 7 06 % 20 5 , 85 5 12 1 66 9 19 1 85 % 88 - 94 1 67 1 20 7 , 20 5 , 84 3 07 3 98 , 59 9 26 % 20 5 . 87 5 , 26 8 66 , 4 0 3 84 % 89 - 7, 4 0 2 35 7 18 7 , 19 6 , 7, 7 6 1 64 2 35 9 28 5 63 % 20 5 . 11 7 17 4 71 4 , 81 7 66 % 90 - 74 4 82 0 18 9 , 20 2 , 27 2 06 3 52 7 , 24 3 6. 3 7 % 20 4 . 35 0 21 5 60 5 , 39 6 82 % 91 - 92 2 , 4 5 5 21 1 , 20 9 , 83 4 81 4 64 1 99 % 20 4 , 65 1 99 6 27 0 , 4 5 9 03 % 92 - 77 7 08 9 17 8 , 18 6 . 4 13 4 96 4 35 7 , 87 5 4. 4 0 % 20 1 , 80 6 , 51 6 02 9 , 4 2 7 13 , 24 % 93 - 36 2 , 4 6 2 20 6 , 20 1 , 12 9 04 0 23 3 , 4 2 2 56 % 19 1 , 69 2 09 9 67 0 , 36 2 16 % 94 - 8, 4 6 0 81 1 18 1 . 17 7 . 4 27 2 , 4 5 5 18 8 35 5 28 % 18 9 , 84 6 , 4 1 9 38 5 , 60 8 56 % 95 - 92 2 37 5 18 7 , 18 6 . 4 89 1 18 6 31 , 18 9 35 % 18 9 . 04 7 50 7 12 5 , 13 2 1. 4 0 % 96 - 95 8 19 8 18 1 . 1 18 3 , 07 3 80 9 11 5 61 1 27 % 18 8 . 34 6 17 2 38 7 97 4 33 % 97 - 62 8 64 5 17 0 , 17 7 . 7 00 3 , 7 8 3 37 5 , 13 8 17 % 18 7 , 51 4 04 0 88 5 , 39 5 10 , 26 % 98 - 99 4 17 6 19 8 , 19 0 , 58 3 22 4 41 0 , 95 3 88 % 18 6 , 35 7 53 1 63 6 , 64 5 79 % 99 - 11 , 4 2 7 86 1 19 3 , 19 2 , 37 1 , 7 4 8 11 3 0. 4 9 % 18 2 , 10 , 7 4 9 , 7 4 9 67 8 , 11 2 93 % 00 - 58 3 , 10 3 17 3 . 4 18 1 . 1 04 9 22 9 46 6 12 6 22 % 17 5 . 4 69 6 , 12 2 11 3 , 01 9 07 % 01 - 24 5 37 6 18 0 . 18 4 , 11 , 4 8 5 55 6 24 0 , 18 0 09 % 17 0 , 10 , 62 0 , 57 5 62 4 80 0 56 % 02 - 94 7 05 6 17 0 , 17 8 . 4 11 , 4 3 5 25 6 48 8 20 0 27 % 16 4 , 10 , 56 9 12 0 37 7 93 6 3. 4 5 % 03 - 01 5 22 5 16 6 . 17 2 . 3 37 9 , 7 5 5 36 4 53 0 20 % 15 9 , 54 9 06 3 46 6 , 16 2 23 % 04 - 31 6 85 9 15 0 . 15 8 , 85 8 52 6 54 1 66 7 99 % 15 7 , 10 , 7 4 8 28 5 43 1 , 4 2 6 18 % AV E R A G E 31 1 , 77 6 18 7 . 18 9 . 43 5 , 83 0 12 4 05 3 33 % 18 8 . 32 0 , 01 3 23 7 09 % "' U c n - n m ~ g . G ) ~ CD C D Q 3 C ' (X ) g - 9 - . ; : ; : CD 0 " .. . . . .. . . c.. v C D Average Daily Temperature 100 0:: II) ... C'I NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT I~Actual I 39.31.31.36.44.50.58.67.75.74.64.52. l-Lagged I 33. ... 32.37.44.51.59.67.73.72.64.52.40. Total Rainfall II) ..5 NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP OCT ~Actual ,-- -Lagged 0.43 Exhibit 1 F Gradil one Schedule 3 Page 9 of 37 UNITED WATER IDAHO Residential Sector Use by Month NORMALIZED BASE YEAR TEST YEAR INCCF Actual Base Year Use Normalized Use Indexed Use Normalized Use Indexed Use 11.085 563 129 030 181 599 12.695,277 481,819 699 047 431 841 467 818 463,995 208 468 695 443 464 469,997 431,792 470 969 443 365 492 238 627 290 492 238 924 644 990,364 924 644 645,633 580 262 645,633 049,579 950 472 049,579 325 123 158,003 325 123 10.743 912 700 220 656,111 700,220 665 11.139,948 188,633 12,471 857 703 209 486,524 466,757 487,447 488 399 489 318 WINTER SUMMER 1 ,829,627 10,316 859 877,478 10,748 285 782 615 951,688 10,749,242 700,929625,763 CHANGE: BASE vs. NORMALIZED YEAR vs. TEST YEAR WINTER SUMMER TOTAL 011 526,289 36,399 590,842 Exhibit 1 F Gradilone Schedule 3 Page 10 of 37 UNITE D WATE R IDAHO Calculation of Effective Rate Month Actual Rate Effective Rate * JAN $1.0912 0912 FER $1.0912 0912 MAR $1.0912 0912 APR $1.0912 0912 MAY $1.3641 1594 J UN $1.3641 2959 J UL $1.3641 3641 AUG $1.3641 3641 SEP $1.3641 3641 OCT $1.0912 2959 NOV $1.0912 1594 DEC $1.0912 0912 NOTE: * RATE in MO =RATE in M0-2/4 +RATE in M0-1 /2 +RATE in MO/4 Exhibit 1 F Gradilone Schedule 3 Page 11 of 37 "' U e n " ' T l m ~ g . G ) ~ CD C D i i 3 6 ' c. c . - , N ~ = CD 0 .. . . 0 , . , : J .. , . , -.. . J UN I T E D W A T E R I D A H O Re s i d e n t i a l S e c t o r U s e b y M o n t h AC T U A L B A S E Y E A R B i l L I N G S NO R M A L I Z E D B A S E Y E A R B i l L I N G S TE S T Y E A R B I L L I N G S Ef f e c t i v e R a t e Bi l l e d ( S ) , , 3 C C F Bi l l e d ( S ) " , 3 C C F No m i n a l Bi l l e d ( S ) , , 3 C C F Bi l l e d ( S ) " , 3 C C F No m i n a l Bi l l e d ( S ) , , 3 C C F Bi l l e d ( S ) " , 3 C C F No m i n a l IN C C F Re v e n u e Re v e n u e Re v e n u e 11 , $1 . 15 9 4 05 9 , 18 6 26 , 37 6 $ 1 25 6 , 82 9 15 2 88 9 28 , 71 0 $1 , 36 8 , 01 7 12 , $1 , 09 1 2 67 8 , 38 4 16 , 89 3 $ 7 5 8 , 68 6 68 2 , 06 2 16 , 98 5 $7 6 2 , 80 1 $ 1 . 0 9 1 2 43 1 , 84 1 $4 7 1 , 22 5 46 3 , 99 5 $ 5 0 6 , 31 1 $1 . 09 1 2 48 9 , 12 0 $ 5 3 3 , 72 8 44 3 , 46 4 $ 4 8 3 , 90 8 $ 1 . 0 9 1 2 39 4 , 54 0 $4 3 0 , 52 2 43 1 , 79 2 $4 7 1 , 17 1 $1 , 09 1 2 51 4 , 12 6 $6 6 1 , 01 4 44 3 , 36 5 $ 4 8 3 , 79 9 $1 , 15 9 4 53 5 , 54 8 13 , 33 6 $ 6 3 5 , 48 0 61 2 , 04 8 15 , 24 2 $ 7 2 6 , 25 6 61 5 , 69 2 33 2 73 1 1 , 57 ' . $1 . 29 5 9 79 3 , 72 8 19 , 76 6 $1 , 05 0 , 14 1 96 6 , 30 0 24 , 06 3 27 8 , 46 2 97 2 05 3 24 , 20 7 28 6 , 07 : 0 $1 . 36 4 1 17 9 , 01 4 29 , 36 0 64 0 , 33 1 54 1 86 6 38 , 39 6 $ 2 , 14 5 , 15 8 55 1 , 04 5 38 , 62 5 15 7 , 92 8 $1 . 36 4 1 94 6 , 48 , 46 2 $ 2 , 70 7 , 51 1 90 3 , 08 1 47 , 39 1 $2 , 64 7 , 70 6 91 4 , 41 0 67 4 66 3 , 46 9 $1 . 36 4 1 17 2 , 72 0 54 , 10 6 $ 3 , 02 2 , 84 8 10 5 , 56 9 52 , 43 4 $ 2 , 92 9 , 4 2 3 11 8 , 10 4 52 , 74 6 94 6 , 10 . $ 1 , 29 5 9 70 1 , 54 0 42 , 37 3 $ 2 , 25 1 , 22 0 61 5 , 87 2 40 , 23 9 $2 , 13 7 , 87 7 62 5 , 49 2 40 , 47 9 15 0 , 11 , $1 , 15 9 4 15 9 , 75 3 28 , 88 1 37 6 , 16 1 12 . $ 1 . 0 9 1 2 68 6 , 12 3 17 , 08 6 76 7 $1 . 09 1 2 46 6 , 75 7 50 9 , 32 1 $ 1 . 0 9 1 2 44 6 10 4 48 6 , 78 9 $1 , 09 1 2 43 4 , 36 2 47 3 , 97 8 $1 . 0 9 1 2 25 0 , 26 3 , 44 6 , 00 4 48 6 , 68 t 1 WI N T E R 82 9 , 62 7 78 2 61 5 79 3 , 22 8 $1 , 95 6 , 77 0 SU M M E R 10 , 06 6 , 18 7 57 9 68 8 10 , 64 2 , 67 2 26 5 , 02 9 $1 4 , 07 9 , 01 9 TO T A L 89 5 , 81 3 25 0 , 67 3 $1 5 31 9 53 5 12 , 3 6 2 , 3 0 0 ' 6 3 , 43 5 , 90 0 26 5 , 02 9 $1 6 , 03 5 , 79 0 WI N T E R Tr e n d N o r m a l i z a t i o n SU M M E R We a t h e r N o r m a l i z a t i o n $ 6 7 2 65 1 TO T A L $ 6 2 1 , 35 3 Te s t Y e a r C h a n g e UN I T E D W A T E R ID A H O In c r e a s e i n B il l s R e n d e r e d & C o n s um p t i o n t h r o u g h A p r i l 20 0 6 RE S I D E N T I A L SE C T O R CO M M E R C I A L SE C T O R PU B L I C S E C T O R AD D E D B I L L S AD D E D B I L L S AD D E D B I L L S BI L L S TO B E TO T A L B I L L S BI L L S TO B E TO T A L B I L L S BI L L S TO B E TO T A L B I L L S RE N D E R E D DI S T R I B U T I O RE N D E R E D RE N D E R E D RE N D E R E D DI S T R I B U T I O N RE N D E R E D RE N D E R E D RE N D E R E D DI S T R I B U T I O N RE N D E R E D RE N D E R E D DU R I N G NO F B I L L S FR O M 1 1 - DU R I N G T E S T DU R I N G OF B I L L S FR O M 1 1 - DU R I N G T E S T DU R I N G B A S E OF B I L L S FR O M 1 1 - DU R I N G T E S T ME T E R S I Z E BA S E Y E A R RE N D E R E D TO 4 - YE A R BA S E Y E A R RE N D E R E D TO 4 - YE A R YE A R RE N D E R E D TO 4 - YE A R 5/ 8 " 81 , 65 5 20 , 18 % 61 4 82 , 26 9 95 1 26 % 96 0 86 % 31 4 " 28 5 83 4 70 , 64 % 14 7 28 7 , 98 1 12 , 20 4 25 , 90 % 12 , 24 5 79 % 57 1 79 % 26 7 35 , 83 8 03 8 29 , 79 % 14 , 08 6 14 6 27 , 22 % 14 6 11 / 2 " 98 9 24 % 99 6 96 2 19 , 02 % 99 2 10 1 18 , 93 % 10 1 55 2 14 % 55 6 05 1 17 , 08 % 07 8 22 3 41 , 56 % 22 3 01 % 67 3 1. 4 3 % 67 5 65 % 00 % 22 9 49 % 22 9 00 % 00 % 03 % 00 % 00 % 01 % 00 % TO T A L 40 4 , 62 2 03 9 40 7 , 66 1 12 9 15 7 28 6 53 6 53 6 CU S T O M E R S A D D E D T H R O U G H 4 01 3 NU M B E R O F B I L L S R E N D E R E D I N PE R I O D P E R C U S T O M E R NU M B E R O F B I L L S R E N D E R E D I N PE R I O D 03 9 15 7 RE S ID E N T I A L SE C T O R CO M M E R C I A L SE C T O R PU B L I C S E C T O R BI L L E D u s E DI S T R I B U T I O BI L L E D U S E BI L L E D U S E DI S T R I B U T I O N BI L L E D U S E BI L L E D U S E DI S T R I B U T I O N B I L L E D U S E DU R I N G NO F B I L L E D DU R I N G T E S T DU R I N G OF B I L L E D DU R I N G T E S T DU R I N G B A S E OF B I L L E D DU R I N G T E S T BA S E Y E A R US E PE R I O D BA S E Y E A R US E PE R I O D YE A R US E PE R I O D Wi n t e r R a t e 85 5 84 4 31 . 7 4 % 03 1 , 84 9 50 7 , 53 0 38 , 18 % 60 8 , 22 3 93 7 18 . 59 % 21 , 85 3 Su m m e r R a t e ~C C F 20 1 44 1 1. 6 6 % 21 0 , 63 6 26 , 40 9 39 % 42 9 28 1 28 % 32 4 Su m m e r R a t e 08 9 20 1 66 , 60 % 45 8 , 44 4 03 4 , 77 3 61 , 43 % 19 6 , 79 3 82 , 66 4 81 . 1 4 % 95 , 39 5 TO T A L 12 , 14 6 48 6 12 , 70 0 , 92 9 56 7 , 71 1 83 1 , 44 4 10 1 88 2 11 7 57 2 In c r e a s e i n U s e t h r u 4 - 55 4 , 44 3 26 3 , 73 3 15 , 69 0 "U c n . , . , m ~ g . ( j ) ~ CO C O Q J O ' a. a . - ' ~! ; . . = CO O "" " 8. (, . ) : J (,. ) UNITE DWATER IDAHO Micron Technology s Water Sales Period from November to Octobe 86-87 87-88 88-89 89-90 90-91 91-92 92- 93-94 94-95 95-96 96- 97- 98-99 99- 00~1 01~2 02~3 03~4 04~5 Water Sales to Micron in CCF BAS E YEAR ;:.. 770 187 552 278 669 459 817 354 951 146 196 674 149 279 329 952 602 975 587 362 379 138 296,477 349 378 408 678 195 278 143 377 660 118 873 Exhibit 1 F Gradilone Schedule 3 Page 14 of 37 "U e n 'T 1 m ~ g . G ) ~ CD C D i i 3 C ' .. . . . . g - Q - . ; : + U1 - - ... . . . CD 0 -. W ~ -. , J UN I T E D W A T E R ID A H O Co m m e r i a l S e c t o r : W i n t e r Us e Re g r e s s i o n A n a l y s SU M M A R Y O U T P U T Re g r e s s i o n S t a t i s t i c s Mu l t i p l e R 34 , R S q u a r e 11 , Ad j u s t e d R S q u a r e St a n d a r d E r r o r 6. 4 5 Ob s e r v a t i o n s AN O V A Si g n i f i c a n c e F Re g r e s s i o n 31 9 , 15 9 , Re s i d u a l 57 , 36 8 , 41 , To t a l 59 , 68 8 , Co e f f i c i e n t s St a n d a r d E r r o r St a t P- v a l u e Lo w e r 95 % Up p e r 95 % Co n s t a n t 58 , 73 9 1 21 , 16 , 10 1 . 4 0 Ti m e 00 0 5 0. 4 5 So C n t y 16 6 4 11 , 3. 4 6 iJ e n 'T l m g. C i ) ~ CD C D i i l C ' c. . c . . - . m~ = CD 0 .. . . ~c . u ~ c.u -.. . . I 10 0 j: : : Co m m e r c i a l S e c t o r : W i n t e r U s e p e r C u s t o m e r ~ , ~ ~ ~ , ~ b ~ ~ ~ ~ ~ ? ~ ~ ? ~ ~ ~ ~ ~ ? ~ ~ ~ Ac t u a l -- - A v e r a g e Tr e n d "" ( J ( J ) " m ~ 9 - G ) ~ CD C D i 1 J O ' a. - ' :: : J ~ = CD 0 ... . . . 9. w ~ -.. . J UN I T E D W A TE A I D A H O Co m m e r c i a l W i n t e r W a t e r U s e Pe r c e n t Ja n t o M a r i n Re g r e s s i o n Di f f e r e n c e Di f f e r e n c e a N o v - Oc t Ac t u a l W i n t e r Es t i m a t e o f Re g r e s s i o n Ac t u a l v s . Ac t u a l v s . Ba s e Y e a r i n Ac t u a l W i n t e r Us e p e r Wi n t e r U s e Es t i m a t e o f Re g r e s s i o n Re g r e s s i o n CC F Us e Cu s t o m e r pe r C u s t o m e r Wi n t e r U s e Es t i m a t e Es t i m a t e 51 2 91 9 46 . 43 . 48 6 , 51 6 26 , 40 3 15 % 55 4 85 2 48 . 43 , 50 2 , 4 7 3 37 9 9. 4 4 % 54 3 , 38 9 44 . 43 . 4 53 2 92 8 10 , 4 6 1 93 % 58 2 56 3 41 . 43 . 60 4 86 2 29 9 83 % 63 8 , 04 1 39 . 43 . 69 0 , 53 6 52 , 4 9 5 23 % 68 6 , 22 2 41 . 42 . 71 7 54 7 32 5 56 % 69 8 , 28 7 41 . 42 . 72 5 84 5 55 8 95 % 70 2 72 7 40 . 42 . 74 3 , 80 0 07 3 84 % 78 1 00 8 42 . 4 42 . 4 78 0 , 20 4 80 4 10 % 78 2 73 1 40 . 42 . 81 0 , 88 0 28 , 14 9 60 % 81 2 34 0 41 . 4 42 . 82 6 , 00 9 13 , 66 9 68 % 82 6 , 60 0 41 . 41 . 84 2 57 4 15 , 97 3 93 % 83 5 , 22 8 41 . 41 . 84 6 , 67 5 44 7 37 % 01 3 , 24 5 46 . 41 . 89 8 , 93 6 11 4 31 0 11 . 28 % 90 5 90 6 41 . 40 . 89 2 74 6 13 , 16 0 1 . 4 5 % 89 5 , 15 5 40 . 4 39 . 87 5 , 93 8 19 , 21 7 15 % 87 4 06 0 38 . 38 . 87 2 22 7 83 2 21 % 91 7 32 8 38 . 37 . 88 7 83 4 29 , 4 9 4 22 % 85 7 62 1 36 . 36 . 86 7 14 0 51 9 11 % 85 0 , 4 9 9 35 . 36 . 87 7 57 9 08 1 18 % AV E R A G E 76 3 53 6 41 , 41 . 76 4 , 16 3 62 6 08 % UNITED WATER IDAHO Commercial Sector: Summer Use Regression Analysis SUMMARY OUTPUT Regression Statistics Multiple R 95.61 % R Square 91.42% Adjusted R Square 90.61 % Standard Error Observations 152 ANOV A Significance F Regression 13.119,471 190 113 Residual 138,217 Total 151.130 688 Coefficients Standard Error t Stat P-value Lower 95%Upper 95% Constant 38.8779 58.76.154. SO CNTY 5013 0.46 12. PRICE 0018 TEMP 2389 0.46 RAIN 3549 2.46 TIME 0001 MAY 7099 0.41 JUNE 24.3470 17.31.40 JULY 33.0890 24.41. AUGUST 69.1021 16.60.77. SEPTEMBER 64.3874 17.57.71. OCTOBER 69.5491 21.63.76. NOVEMBER 32.3743 25.38.DECEMBER 17.5215 10.24. Exhibit 1 F Gradilone Schedule 3 Page 18 of 37 "" ( J ( J ) ' T 1 m S g . ( j ) ~ (1 ) ( 1 ) P 3 0 = a. a . - ' tD s - = (1 ) 0 ... . . . Q. w f f i -. . J UN I T E D W A T E R I D A H O Co m m e r c i a l S u m m e r W a t e r U s e Pe r c e n t Di f f e r e n c e Pe r c e n t Ap r t o D e c i n Di f f e r e n c e Di f f e r e n c e No r m a l i z e d Ac t u a l v s . Di f f e r e n c e a N o v - Oc t Re g r e s s i o n Ac t u a l v s . Ac t u a l v s . Re g r e s s i o n No r m a l i z e d Ac t u a l v s . Ba s e Y e a r i n Ac t u a l Es t i m a t e o f Re g r e s s i o n Re g r e s s i o n Es t i m a t e o f Re g r e s s i o n No r m a l i z e d CC F Su m m e r U s e Su m m e r U s e Es t i m a t e Es t i m a t e Su m m e r U s e Es t i m a t e Es t i m a t e 88 - 98 5 08 8 88 2 82 0 10 2 26 8 63 % 89 9 76 1 32 8 14 % 89 - 12 4 67 4 19 1 67 0 99 6 60 % 20 3 21 5 54 2 90 % 90 - 36 7 31 3 10 0 , 36 8 26 6 94 5 51 % 25 4 90 6 11 2 , 4 0 7 57 % 91 - 65 9 67 3 52 5 25 1 13 4 , 4 2 2 97 % 4, 4 2 3 , 31 4 23 6 35 8 07 % 92 - 16 9 58 6 51 3 86 9 34 4 28 3 63 % 57 3 , 11 0 40 3 52 4 68 % 93 - 9 4 88 0 64 4 80 2 53 5 10 9 63 % 80 7 41 4 23 0 50 % 94 - 72 8 22 6 92 5 , 4 0 4 19 7 17 8 00 % 98 2 17 2 25 3 94 6 37 % 95 - 9 6 95 3 36 5 08 1 85 3 12 8 , 4 8 9 53 % 10 0 86 7 14 7 50 2 98 % 96 - 96 8 27 7 14 1 97 4 17 3 69 7 38 % 15 4 32 9 18 6 05 2 74 % 97 - 13 6 69 6 23 7 00 6 10 0 31 0 92 % 25 0 34 8 11 3 65 2 21 % 98 - 82 1 78 5 51 2 07 3 30 9 71 2 62 % 52 9 63 0 29 2 15 5 02 % 99 - 92 3 79 5 62 2 , 4 2 3 30 1 , 37 3 36 % 61 4 , 4 5 4 30 9 34 1 22 % 00 - 0 1 76 5 23 8 61 9 57 5 14 5 66 4 59 % 62 8 95 3 13 6 28 5 36 % 01 - 73 8 74 9 68 4 88 2 86 6 95 % 68 7 57 2 17 7 89 % 02 - 59 6 88 5 76 3 44 7 16 6 56 2 89 % 73 4 88 4 13 7 99 9 2. 4 7 % 03 - 91 4 83 4 73 8 14 8 17 6 68 6 08 % 73 7 39 6 17 7 , 4 3 8 00 % 04 - 59 8 34 0 80 0 , 36 3 20 2 02 3 3. 4 8 % 81 3 , 62 5 21 5 , 28 5 85 % AV E R A G E 07 8 , 42 2 06 7 27 4 14 7 22 % 08 2 11 5 69 3 07 % "U c n T l m ~ g . G ) ~ CD C D i i 3 O = I\ ) Q . Q . ;:: : : ; : S. = CD 0 .. . . . . Q. w f f i UN I T E D W A T E R I D A H O Co m m e r c i a l S e c t o r U s e b y Mo n t h BA S E Y E A R NO R M A L I Z E D B A S E Y E A R TE S T Y E A R Ac t u a l B a s e Y e a r A c t u a l B a s e Y e a r To t a l B a s e Y e a r No r m a l i z e d In d e x e d B a s e Ba s e Y e a r U s e To t a l B a s e Te s t Y e a r U s e In d e x e d T e s t Te s t Y e a r U s e To t a l T e s t Y e a r Us e p e r B o o k s i n U s e f o r M i c r o n i n U s e l e s s M i c r o n i n Ba s e Y e a r U s e Ye a r U s e i n fo r M i c r o n i n Ye a r w i t h in C C F Ye a r U s e i n fo r M i c r o n i n Us e i n C C F CC F CC F CC F in C C F CC F CC F Mi c r o n i n C C F CC F CC F 11 , 56 2 81 7 56 2 , 81 7 61 6 , 69 5 60 4 , 05 6 60 4 , 05 6 12 , 44 3 , 99 6 12 0 42 9 , 87 6 47 5 , 35 4 49 4 , 45 4 14 , 12 0 50 8 , 57 4 29 2 52 5 29 2 , 52 5 29 2 , 61 7 29 3 , 30 3 29 3 , 30 3 30 4 , 95 9 18 , 49 1 28 6 , 46 9 29 2 , 46 2 33 6 , 08 9 18 , 49 1 35 4 , 58 0 27 1 , 50 5 27 1 50 5 29 2 , 50 0 27 6 , 79 5 27 6 , 79 5 32 9 , 49 2 14 , 27 5 31 5 , 21 6 33 8 , 91 2 35 0 , 05 6 27 5 36 4 , 33 1 38 0 , 93 6 38 0 , 93 6 33 0 , 92 1 34 4 , 86 3 34 4 86 3 33 0 , 92 1 34 5 , 96 4 34 5 , 96 4 50 2 , 20 6 15 , 12 8 48 7 , 07 8 56 5 , 86 2 57 9 , 04 7 15 , 12 8 59 4 , 17 5 56 5 , 86 2 58 0 , 89 6 15 , 12 8 59 6 , 59 7 , 74 3 59 7 74 3 65 5 , 94 3 65 6 , 09 0 65 6 , 09 0 65 5 , 94 3 65 8 , 18 5 65 8 18 5 97 4 10 5 30 , 12 4 94 3 , 98 1 96 1 , 53 0 95 0 , 28 4 30 , 12 4 98 0 , 40 8 96 1 , 53 0 95 3 , 31 9 30 , 12 4 98 3 44 3 99 6 , 63 3 99 6 , 63 3 92 1 , 21 9 88 4 , 98 9 88 4 , 98 9 92 1 , 21 9 88 7 , 81 5 88 7 , 81 5 10 , 91 0 , 79 3 26 , 73 4 88 4 , 05 9 94 7 18 9 92 1 , 17 9 26 , 73 4 94 7 , 91 3 94 7 , 18 9 92 4 12 1 26 , 73 4 95 0 85 5 11 , 62 2 64 8 60 5 , 98 5 60 5 , 98 5 12 . 47 8 , 19 2 49 6 , 03 3 12 0 51 0 , 15 3 29 5 , 05 4 29 4 , 23 9 29 4 23 9 29 5 , 07 9 33 7 16 2 18 , 49 1 35 5 , 65 3 29 5 , 33 1 27 7 , 01 9 27 7 , 34 3 , 60 3 35 1 , 17 3 27 5 36 5 , WI N T E R U S E 86 8 , 98 9 49 1 85 0 , 49 9 87 7 57 9 90 6 , 18 7 49 1 92 4 67 7 88 5 , 46 4 90 9 08 0 18 , 49 1 92 7 57 1 SU M M E R U S E 69 8 , 72 2 10 0 , 38 2 59 8 , 34 0 81 3 62 5 78 5 , 01 7 10 0 , 38 2 88 5 , 40 0 82 7 10 7 80 3 , 49 1 10 0 , 38 2 90 3 87 3 TO T A L U S E 56 7 71 1 11 8 87 3 44 8 83 8 69 1 20 4 69 1 20 4 11 8 , 87 3 81 0 07 7 71 2 57 1 71 2 57 1 11 8 , 87 3 83 1 44 4 UNITED WATER I D AH Commercial Sector Use NORMALIZED BASE YEAR TEST YEAR Actual Base Normalized Use Indexed Use Normalized I Indexed UseINCCFYear Use Use 11.562,817 616,695 604 056 12.443,996 489,474 508,574 292 617 293,303 310 953 354,5801 292 500 276,7951 353,187 364,331 330,921 344,863 330,921 345,964 580,990 594,175 580 990 596,0241 655,943 656,090 655,943 991,654 980,408 991,654 996,633 921 219 884,989 921,2191 10.910,793 973,923 947,913 973,923 11.622 648 12.492,313 295,054' 313 569 295,331 357,878 WINTER USE 868,989 896,070 924 677 903,955 SUMMER USE 698 722 914 007 927 489 r~Jt1j~i,~~~i~~I~i1f.810 077 CHANGE: BASE WINTER SUMMER TOTAL Exhibit 1 F Gradilone Schedule 3 Page 21 of 37 -o c n T l m ~ g . G ) ~ CD C D D J O ' N c . . c . . ;:: ; : So = CD 0 ... . . 0 , . , : : J .. . . . . C D c.. u -.. . J UN I T E D W A T E R I D A H O Co m m e r c i a l S e c t o r U s e b y M o n t h BA S E Y E A R B i l L I N G S NO R M A L I Z E D B A S E Y E A R B i l L I N G S TE S T Y E A R B i l L I N G S Ef f e c t i v e R a t e Bi l l e d ( g 1 ; : . 3 C C F Bi l l e d ( g 1 c : 3 C C F No m i n a l Bi l l e d ( g 1 ; : . 3 C C F Bi l l e d ( g 1 c : 3 C C F No m i n a l Bi l l e d ( g 1 ; : . 3 C C F Bi l l e d ( g 1 c : 3 C C F No m i n a l IN C C F Re v e n u e Re v e n u e Re v e n u e 11 , $1 , 15 9 4 55 9 , 78 0 65 2 , 60 0 , 7B ! 70 0 , 10 1 12 . $1 , 09 1 2 44 0 , 18 3 48 4 , 48 8 50 5 , 39 1 18 3 55 4 , $1 , 09 1 2 29 2 , 5 2 5 31 9 , 21 1 ' 29 3 , 32 0 , $1 . 09 1 2 30 4 , 33 2 , 35 4 , 5B ! 38 6 , $1 . 09 1 2 27 1 , 29 6 , 26 1 27 6 , 30 2 , 03 1 $1 , 09 1 2 32 7 2B ! 35 9 , 54 1 36 2 , 05 1 28 C 1 39 7 , 55 1 $1 . 15 9 4 37 8 , 15 8 44 1 , 52 0 34 2 , 7D ' I 15 8 39 9 , 69 5 34 3 , 79 9 16 5 $ 4 0 0 , 97 1 $1 , 29 5 9 49 8 , 48 1 71 1 65 0 , 03 5 59 0 , 71 1 76 9 , 21 6 59 2 , 29 4 73 0 $ 7 7 1 , 61 0 $1 . 3 6 4 1 59 3 , 10 6 81 4 , 26 1 65 1 98 4 10 6 89 3 , 65 4 , 06 6 11 9 $ 8 9 6 , 70 6 $1 , 36 4 1 96 7 97 0 13 5 32 7 , 10 3 97 4 , 27 3 13 5 33 5 , 70 1 97 7 , 28 8 15 4 $ 1 , 33 9 , 83 5 $1 , 36 4 1 99 1 , 09 5 53 8 35 7 99 6 87 9 , 45 1 53 8 20 5 , 70 2 88 2 , 25 9 55 6 $1 , 20 9 , 55 2 10 , $ 1 , 29 5 9 90 4 , 86 1 93 2 17 9 , 06 0 94 1 , 98 1 93 2 22 7 , 94 4 , 90 5 95 0 $1 , 23 0 , 97 1 11 , $1 , 15 9 4 60 2 , 19 3 79 2 $ 7 0 2 , 33 5 12 . $1 . 09 1 2 50 6 , 96 0 19 3 $ 5 5 6 , 67 9 $1 , 09 1 2 29 4 , 2 3 9 $ 3 2 1 , 07 4 $1 . 09 1 2 35 5 , 65 3 $ 3 8 8 , 08 9 $1 . 09 1 2 27 7 , 67 9 $ 3 0 3 , 00 3 $1 , 09 1 2 36 3 , 16 2 28 7 $ 3 9 8 , 77 8 WI N T E R 86 8 , 98 9 36 ' 92 4 , 67 7 92 7 , 57 1 $1 , 01 2 , 16 6 SU M M E R 66 1 89 1 84 8 , 56 9 86 6 , 92 7 94 6 $ 7 50 7 43 8 TO T A L 53 0 , 88 1 36 , 83 1 $ 8 21 4 53 2 77 3 , 2 4 6 3 6 ' 79 4 , 49 8 36 , 94 6 $ 8 , 51 9 , 60 4 WI N T E R Tr e n d N o r m a l i z a t i o n SU M M E R We a t h e r N o r m a l i z a t i o n $ 2 1 7 , 65 2 TO T A L $ 2 7 8 , 41 8 Te s t Y e a r C h a n g e "U e n T I m ~ g . G ) ~ CD C D Q J O ' a. ; : ; : !; ; . . = CD 0 ... . . . Q, w f f i -.. . J j: : : i: i : Pu b l i c W i n t e r U s e p e r C u s t o m e r Eq u a t i o n f o r T r e n d L i n e y = 07 3 4 x + 6 . 86 0 9 0 8 6 - 87 8 7 - 88 8 8 - 89 8 9 - 90 9 0 - 91 9 1 - 92 9 2 - 93 9 3 - 94 9 4 - 95 9 5 - 96 9 6 - 97 9 7 - 98 9 8 - 99 9 9 - 00 0 0 - 01 0 1 - 02 0 2 - 03 0 3 - 04 0 4 - 05 0 5 - -+ - A c t u a l 8 13 11 12 -T r e n d -+ - A c t u a l -- - T r e n d Li n e a r ( A c t u a l ) UNITED WATER IDAHO Public Sector Use NORMALIZED BASE YEAR TEST YEAR Actual Base Normalized Use I Normalized Use I Indexed UseYear Use Indexed UseINCCF 11.12414 12414 12.5732 5732 1025 1025 1025 1025 1025 1025 025 025 5511 5588 5588 5588 4423 9352 9352 9352 17 640 18785 18785 18785 14932 20227 20227 227 30544 21 984 21 984 21 984 10.937 502 502 19,502 11.12340 12.5658 1034 1034 1034 034 WINTER USE 030 3075 3075 3103 114609 114470 117 684 117.572TOTAL USE CHANGE: BASE WINTER SUMMER TOTAL Exhibit 1 F Gradilone Schedule 3 Page 24 of 37 UN I T E D W A T E R ID A H O Pu b l i c S e c t o r : S u m m e r W a t e r Us e R e g r e s s i o n A n a l y s i s SU M M A R Y O U T P U T Re g r e s s i o n S t a t i s t i c s Mu l t i p l e R 80 . R S q u a r e 64 . Ad j u s t e d R S q u a r e 61 . St a n d a r d E r r o r 22 4 Ob s e r v a t i o n s 12 7 AN O V A Si g n i f i c a n c e F Re g r e s s i o n 9 5 , 67 0 , 4 6 3 , 89 8 63 0 , 05 1 54 4 Re s i d u a l 11 7 3 , 19 2 63 0 96 4 28 7 , 4 4 4 To t a l 12 6 8 86 3 09 4 86 2 Co e f f i c i e n t s St a n d a r d E r r o r t S t a t P- v a l u e Lo w e r 95 % Up p e r 95 % Ca N S T A N T 83 1 . 24 7 15 0 36 8 03 1 CU S T O M E R S 73 . 95 0 15 3 RA I N 39 8 0 . 72 0 15 8 3. 4 4 27 3 68 8 MA Y 72 9 . 77 4 89 3 02 0 4, 4 7 9 J U N 40 7 5 . 4 8 3 89 8 31 6 83 5 J U L 11 7 3 3 . 29 6 89 9 97 3 15 , 4 9 4 AU G 11 4 8 0 . 4 3 0 06 5 39 0 57 0 S E P 13 0 3 9 . 84 3 11 9 84 2 23 7 OC T 11 2 1 4 . 96 7 03 6 18 3 15 , 24 7 NO V 52 7 5 , 57 0 92 1 1, 4 7 1 08 0 "U e n " m ~ g . G ) ~ (1 ) ( 1 ) i i 3 5 ' N c . . c . . ;: + U1 C - . CD 0 " " " " g, w ff i -- . . j "U e n "T 1 m ~ g . G ) ~ CD C D i i 3 C ' a. a . ; : : ; : IJ ) c : - , (5 " 0 - " g, w -.. . J UN I T E D W A T E R I D A H O Pu b l i c S u m m e r W a t e r U s e Pe r c e n t Di f f e r e n c e Pe r c e n t Ja n t o A p r i n Di f f e r e n c e Di f f e r e n c e No r m a l i z e d Ac t u a l v s . Di f f e r e n c e a N o v - Oc t Re g r e s s i o n Ac t u a l v s . Ac t u a l v s . Re g r e s s i o n No r m a l i z e d Ac t u a l v s . Ba s e Y e a r i n Ac t u a l Es t i m a t e o f Re g r e s s i o n Re g r e s s i o n Es t i m a t e o f Re g r e s s i o n No r m a l i z e d CC F Su m m e r U s e Su m m e r U s e Es t i m a t e Es t i m a t e Su m m e r U s e Es t i m a t e Es t i m a t e 90 - 56 3 64 9 08 6 28 % 95 , 24 4 68 1 22 , 80 % 91 - 90 4 99 , 80 7 90 4 92 % 75 8 85 5 74 % 92 - 11 1 , 4 7 4 10 3 05 2 8, 4 2 2 17 % 99 , 82 9 11 , 64 5 10 . 4 5 % 93 - 09 4 80 2 29 2 31 % 10 0 , 86 4 77 0 35 % 94 - 11 0 , 4 8 4 11 1 66 5 18 1 06 % 10 1 , 4 5 6 02 8 17 % 95 - 53 6 95 , 06 4 4, 4 7 1 70 % 10 1 60 4 06 8 08 % 96 - 10 2 71 0 10 0 00 2 70 8 71 % 10 2 , 4 9 1 21 9 21 % 97 - 10 1 91 0 94 , 4 1 6 7, 4 9 4 94 % 10 2 78 7 87 7 86 % 98 - 78 , 54 6 89 , 16 3 61 8 11 . 91 % 10 3 , 67 4 12 9 31 , 99 % 99 - 12 6 , 88 0 12 0 95 5 92 4 90 % 11 3 73 1 14 8 10 , 36 % 00 - 12 2 14 4 12 3 , 89 6 75 2 1. 4 1 % 11 7 , 4 2 9 71 5 86 % 01 - 11 2 97 8 11 7 23 1 25 3 63 % 11 4 02 7 04 9 93 % 02 - 14 1 21 2 12 3 , 25 0 96 2 14 , 57 % 11 4 17 5 03 7 19 . 15 % 03 - 11 3 , 01 4 11 8 14 5 13 1 34 % 11 4 17 5 16 1 03 % 04 - 11 1 06 0 11 5 , 26 0 20 0 64 % 11 4 02 7 96 7 67 % 05 - 97 , 36 8 10 4 77 5 7, 4 0 7 07 % 11 3 , 58 4 16 , 21 6 16 , 65 % AV E R A G E 10 5 61 7 10 5 , 82 1 20 4 19 % 10 6 , 67 8 06 1 00 % "U ( n T l m ~ g . G ) ~ CD C D Q j e : I\ : ) c . . c . . ; : ; : -- . j ! ; . = CD a .. . . . . g, U J -- . j UN I T E D W A T E R I D A H O Pu b l i c S e c t o r U s e b y M o n t h BA S E Y E A R B I L L I N G S NO R M A L I Z E D B A S E Y E A R B I L L I N G S TE S T Y E A R B I L L I N G S Ef f e c t i v e Bi l l e d Bi l l e d No m i n a l Bi l l e d Bi l l e d No m i n a l Bi l l e d Bi l l e d No m i n a l IN C C F Ra t e (g J ; . 3 C C F (g J . . : : : 3 C C F Re v e n u e (g J ; . 3 C C F (g J . . : : : 3 C C F Re v e n u e (g J ; . 3 C C F (g J . . : : : 3 C C F Re v e n u e 11 , $1 , 15 9 4 11 6 3 C 13 5 2 12 3 7 2 14 , 34 5 12 , $1 . 09 1 2 27 0 3 29 5 9 57 1 3 62 3 4 $1 , 09 1 2 10 5 5 11 5 1 10 2 5 11 1 ! $1 , 09 1 2 73 3 80 l 10 2 5 11 1 ! $1 . 09 1 2 12 4 2 13 5 6 10 2 5 11 1 ! $1 , 09 1 2 48 4 62 1 02 5 11 ! $1 , 15 9 4 54 9 2 63 8 S 55 6 9 64 5 55 6 9 $6 4 7 8 $1 , 29 5 9 44 0 8 57 2 S 93 2 12 0 7 7 93 2 0 $1 2 1 1 2 $1 , 36 4 1 17 5 8 0 24 0 4 6 18 7 2 2 25 5 3 S 18 7 2 2 $2 5 6 0 8 $1 , 36 4 1 14 8 8 2 20 3 5 5 20 1 5 8 27 4 9 S 20 1 5 8 $2 7 5 7 3 $1 , 36 4 1 30 4 4 0 10 3 41 6 3 21 9 0 9 29 8 8 6 21 9 0 9 $2 9 9 6 8 10 . $1 , 29 5 9 90 3 87 0 19 , 43 5 18 6 19 , 43 5 $ 2 5 25 8 11 , $1 , 15 9 4 12 2 9 8 $ 1 4 3 0 5 12 , $1 . 09 1 2 56 3 9 $ 6 1 7 4 $1 , 09 1 2 10 3 4 $1 1 2 8 $1 , 09 1 2 10 3 4 $1 1 2 8 $1 . 09 1 2 10 3 4 $1 1 2 8 $1 , 09 1 2 03 4 12 8 WI N T E R 30 3 0 07 5 10 3 $ 3 , 38 5 SU M M E R 98 5 2 2 11 4 2 2 4 38 5 $ 1 4 8 , 34 0 11 4 . 08 6 38 4 $ 1 4 8 6 0 3 TO T A L 10 1 , 55 2 33 0 $ 1 3 2 , 43 7 11 7 , 29 9 3 8 5 "" ' " 11 7 , 18 8 38 4 $1 5 1 , 98 9 WI N T E R Tr e n d N o r m a l i z a t i o n SU M M E R We a t h e r N o r m a l i z a t i o n $1 9 , 20 9 TO T A L $ 1 9 . 25 9 Te s t Y e a r C h a n c e UNITED WATER IDAHO Private Fire Protection Revenue in Base Year as Billed Service Size Type Bi-Monthly Rates Numberot Bills Rendered RevenueServices PRIVATE FIRE SERVICE LINES $ 23.266 346 $ 31 836 $ 25.206 $ 5,245 $ 25.215 $ 35.400 999 $ 71 667 $ 38.307 $11 847 $ 38.$ 3 619 $ 89.456 270 $ 202 210 $ 95.343 $ 32 890 $ 96.114 $ 10 977 $ 146.122 598 $ 87 548 $ 157.$ 15 154 $ 158.$ 6,080 10"$ 228.$ 12 815 $ 245.$ 2 198 $ 246.$ 689 12"$ 341.$ 8 818 $ 368,$ 1 235 $ 369.$207 TOTAL 260 556 $ 506,249 PRIVATE HYDRANTS Hydrants $ 14.170 849 $ 12 156 $ 15.129 $ 1 996 $ 15.$ 637 TOTAL 170 019 $ 14 789 OTHE R Annual Rate Ada County Highway *$ 2,150,$ 2 151 TOTAL FIRE SERVICES 431 575 $ 523 189 BILL ANALYSIS $ 523,725 DIFFERENCE ($ 536) BOOKS $ 527 417 DIFFERENCE ($ 4 228) NOTE: * Access to hydrants for street cleaning by Ada County DPW Exhibit 1 F Gradilone Schedule 3 Page 28 of 37 UNITED WATER IDAHO Private Fire Protection Revenue in Base Year at Current Rates Service Size Type Bi-Monthly Rates Numberof Bills Rendered RevenueServices PRIVATE FIRE SERVICE LINES $ 25.266 599 $ 40,868 $ 38.400 399 $ 92,925 $ 96.456 728 $ 262,497 $158.122 733 $ 115 881 10"$ 246.$ 16,742 12"$ 369.$ 10 974 TOTAL 260 556 $ 539,886 PRIVATE HYDRANTS Hydrants $ 15.48 170 019 $ 15 782 TOTAL 170 019 $ 15,782 OTHE R Annual Rate Ada County Highway *$ 2,150.$2,151 TOTAL FIRE SERVICES 431 575 $ 557,819 REVENUE AT PREVAILING RATES $ 523,189 INCREASE $ 34 630 Exhibit 1 F Gradilone Schedule 3 Page 29 of 37 UNITED WATER IDAHO Private Fire Protection Revenue for the Test Year Service Size Type Bi-Monthly Rates Numberof Bills Rendered RevenueServices PRIVATE FIRE SERVICE LINES $ 25.271 629 $ 41 635 $ 38.407 2,441 $ 94 552 $ 96,466 788 $ 268 271 $ 158.124 745 $117,779 10"$ 246.$ 16 742 12"$ 369.$ 10 974 TOTAL 284 700 $ 549 952 PRIVATE HYDRANTS Hydrants $ 15.170 019 $ 15 782 TOTAL 170 019 $ 15 782 OTHE R Annual Rate Ada County Highway *$ 2,150.$ 2 151 TOTAL FIRE SERVICES 455 719 $ 567 884 REVENUE AT PREVAILING RATES $ 557 819 INCREASE $ 10,066 Exhibit 1 F Gradilone Schedule 3 Page 30 of 37 CI) :I: )- C1J ~ = u..I cI-- .- ~ ~ u.. u..I CIJ I-- . ;;;. :J C1J tI'J "'C C1J M.... It)OOOIt)OOIt)CDCO'lt~M M ... CO CD 0 N CO 0 CO N CO en en .... It)It)........ N 'It ...... CD 'It 'It 'It 'It 'It N CD ...... ...... cD -iJ ' ~ tit tit tit tit tit tit tit tit tit tit tit tit tit ~C')'Ot 'Ottit tit 0:= -Oa:JN"Na:JO"I\Da:J-q-"\I') (J) W f1J ",,-q-NMNMN-MMMa'I I-~CJ ... .et: 0 WZmD:: t- ~D::c:.:: W 1oUQ.-I- CIoU (J)oct ....I W....I :J- ZCQ W c:.:: ::;::. IoU W D:: \I') D:: .et: oct IoU W:J )- tt:z W IoU (J) ;;.. octIoU ms::.s::000 c:.::.J~ 0 ......... OOOOOOOONCOa:J ;:. c:.:: octS::...fh fh fh fh fh fh fh fh LO I'- CO CISG) G)fhfhfh o:: .et: I-;:. Q.IoU &! ~ ... I-II.. IoU f1J \I') .... '0 J!!.et:I/) ... ~ ... s::G) U OOOOOOOO~~;:1;G) G) .c G)en .c "C C')....I E.s::It).et:~ 0 s::Z - ;:) tt: G) .s::It)s:: ~8~&3~&3~~goo~ 0 s:: ...'It G) G) """ I'- co """ """ """ """ """ N ..- fh fh .j' f1J 0:: .... fh fh fh fh fh fh fh fh fh C');:. Q. to)G) It)CI)0::....II.. s::: (,) ..s::: .... '0 J!! (.,) I/) ....... ~""'" ... s::G) U U;~~~~~~~~OO G) G) .c G)C")to).c "C C')E.s:: (,).... ~ 0 s:: ;:) s:::0:= z - s::: ~~~~~~~LO~~~ ...J ...J c:I:to)c::( ""'" ::. uc.c.!-.!-;!"c26c....!.0) CO 0) CO Q.CO:J:J:J 0)80""') LL. :2: c::( :2: ""') ""') c::( U) C1J .... fIJ Exhibit 1 F Gradilone Schedule 3 Page 31 of 37 UN I T E D W A T E R ID A H O Cu s t o m e r S e r v i c e Fe e s i n B a s e Y e a r U n d e r C u r r e n t R a t e s Re t u r n e d C h e c k s Un d e r C u r r e n t T a r i f f To t a l Nu m b e r o f Re v e n u e Re v e n u e Ch e c k s $2 0 p e r C h e c k No v - $6 4 0 $6 4 0 De c - 02 0 $1 , 02 0 Ja n - $8 0 0 $8 0 0 Fe b - $5 6 0 $5 6 0 Ma r - $6 4 0 $6 4 0 Ap r - $5 4 0 $5 4 0 Ma y - $6 4 0 $6 4 0 Ju n - $5 6 0 $5 6 0 Ju l - $3 8 0 $3 8 0 Au g - $7 2 0 $7 2 0 Se p - $7 6 0 $7 6 0 Oc t - $6 8 0 $6 8 0 TO T A L 39 7 $7 , 94 0 94 0 Re c o n n e c t i o n s Re c o n n c t i o n s Fi e l d V i s i t s Nu m b e r o f Nu m b e r o f In c i d e n t s Fe e R e v e n u e In c i d e n t s Fe e R e v e n u e TO T A L 13 6 0 $3 1 , 52 0 53 8 $8 , 07 0 $3 9 , 59 0 TO T A L B A S E Y E A R R E V E N U E A T C U R R E N T R A T E S $4 7 53 0 TO T A L B A S E Y E A R R E V E N U E A S B I L L E D $4 6 , 13 3 IN C R E A S E 39 7 "U en 'T I m ~ g . G ) ~ CD C D i i J O ' a. ; : : ; : N c : - . CD 5 " " ' " -0 , w f f i -. . . . J UN I T E D W A T E R ID A H O Cu s to m e r Se r v i c e F e e s i n Te s t Y e a r Re t u r n e d C h e c k s Un d e r C u r r e n t T a r i f f To t a l Nu m b e r o f Re v e n u e Re v e n u e Ch e c k s $1 5 p e r C h e c k Ma y - $6 4 0 $6 4 0 Ju n - $5 6 0 $5 6 0 Ju l - $3 8 0 $3 8 0 Au g - $7 2 0 $7 2 0 Se p - $7 6 0 $7 6 0 Oc t - $6 8 0 $6 8 0 Na v - $7 0 0 $7 0 0 De e - $7 0 0 $7 0 0 Ja n - $7 0 0 $7 0 0 Fe b - $7 2 0 $7 2 0 Ma r - $7 2 0 $7 2 0 Ap r - $7 2 0 $7 2 0 TO T A L 40 0 00 0 $8 , 00 0 Re c o n n e c t i o n s Re c o n n c t i o n s Fi e l d V i s i t s Nu m b e r o f Nu m b e r o f In c i d e n t s Fe e R e v e n u e In c i d e n t s Fe e R e v e n u e TO T A L 38 0 $3 1 , 98 4 54 5 $8 , 17 5 $4 0 , 15 9 TO T A L B A S E Y E A R R E V E N U E AT CU R R E N T R A T E S $4 8 , 15 9 TO T A L T E S T Y E A R R E V E N U E AT CU R R E N T R A T E S $4 7 53 0 IN C R E A S E $6 2 9 "U en 'T 1 m ~ g . ( j ) ~ CD C D W C T a. ; : ; : w S . = .. . . . CD 0 - w ~ --. J UNITE D WATE R IDAHO Cons truction Meter Rentals PREVAILING RATES CURRENT RATES Monthly $25 per Date Rentals $20 Permits $25 Permits Permit November- December- January- February- March- April- May- June- July- August- Septem ber - October- Total Rentals 591 536 591 Tariffed Rates $ 20.$ 25.$ 25. Subtotal Revenue $ 10 720 $ 1 375 $ 14 775 Total Rental Charge $ 12,095 $ 14 775 BOOK REVENUE $ 12 095 DIFFERENCE $ 0 TOTAL REVENUE DURING BASE YEAR $ 12 095 NUALIZED INCREASE DUE TO TARIFF CHANGES IN BASE YEAR $ 2 680 Exhibit 1 F Gradilone Schedule 3 Page 34 of 37 II) coco 't""'t""~ C")to- ~ 't"" 't"" ~ ~ :J ~..- I;;~ffi8~C'") ~COc: 5; ~I'-COI'-C'")OCOmoooI'-- .LO -C'")LO.LO.LO. ::00 ... C'") ..-..-..- N..- V7 V7 V7 ..- ..-::00 ~ tft tft tft tft tft tft tft tft tft tft LO'Ot 't"" CD ...-. N CO..- to- 0 N mLON II) to- II) CD ..- LO ~ CD 't"" I'- CD CD CO to- II) CO CO m 1'-0 ~O CO I'-LO ...t~ an an N ~ cDM ~ ~ mN"..- 'Ot CO CO ~..- ..- LO en II) ..- ..- tft tft tft tft tft tft 0 0 tft tft tft en I- Z e:( e:(c:: J: w w en e:( a.. c::0 ec:: w a.. I- 0e:( a..w 0:J c::a..w 0 ::- I- c:: w c:: :Je:( ew w )- :J I- Z en W ::-COO~ N C':! CO CD ..J I.&. I;;~~e:(~ tft tft0 I- e:(e W c::e:( 0c:: z C) en c::W e:(I- e:( )-c:: W I- e:(W m c:: C)c:: Z:J c:: I- :Je:( e W W :J C)z zW e:(::- J:W 0c:: W c:: l- e:( e:(W c::)- 0W I- en e:( :J LOCD~I'-N..J~CO e:(LO ...: C'")C") Ztfttft0I- ::- e W c::e:( c:: C) W e:( c:: en W ~ 0..J 0 :::! 0 m m c:: en c:: ~e:( W 11.W a.. e ::J e:(W W ::- ::JW Zc:: W c:: ::- e:( WW c:: )- c::W e:( en e:( )-m W ..J e:( e:(I- m "-CDZ~~;;e:(~C::co C'") C") C)tft tft 0 ~ ..-CONmCD coffiNLOa;C'")~mC'")o oooo C'") CO. LO m. 1'-C'"). m. ~ CO. u1 ~C'") ..-..-..- N ..- ..- ..- 0 tft .s LLClJC a:: :I:~U ~ )- E C I- E ~:J ~Cen~ :! ~ 0 ~ U E E 0:J 0 m mI'-CD .. N ..- ~ tft tft ..- N CO N C'") . CO ..- C'")tft tft ..- ..-mN C'")C'")000000 N ~ ~ ~ "-M CDtfttfttfttfttfttftLO . . - 0 .tft N ~ I'- ..- I'- C'")tft tft tft tft tft tft (\') tft 0 ~ :I: n; c:( ... a:: .... I- :Ec:( ....~ ~ W ~I- :I: JiI::Z -::J ~ CO ..-(\,)l'-com~oOOOOO(\')NOCO~OmcoC'")No . ....: M cD cO ' ~ ..- tft 0 ~ ..-CONm(\')LOco COo~..-0 LO"-(\')~m(\')coco(\')NCOCON LO ffi m I'- (\') 0 co co 0 "!. (\') . "- . CD :! M "":"":"":N"N"~cO~~~~ CIJ a:: :I: a:: CIJ::J 5; I'-(\,)OOI'-..-LOOCOO..-Og~ ~N~NN(\,)C'")~(\,)~~LO 1: I'- co 2 (\,)LO(\,)CD(\,)l'-LOLO~(O ~ ~ .... ..- ..- ..- ..- ..-..- ..- ..-..- ..- .... ..- ..- Ntft tft C") N NN I'- r-..: I'-..- Ntft tft ..- co LO (\') ..- Ntft tft w w WI-:J:Jc:(zz - ~ C ~ ~W W W O...J ...J c:( c:(c.1-1-000~I-I-C. a:J w WWI-:J:Jc:(zz~ ww C) ~ ~ ...J ...J ...J c:( c:(..... I- WOO~I-I-C. a:J ~ ~ LO LO LO LO LO LO LO LO LO LO en w w w999999999999...J I-:J:J ID ID ~~.c:c :;.., 0) ~ii) ID ID c:( c:( Z .c.c co co ~ c..CO C:::J :J.c.c l- ~ ww E E:J:J co.ct~~" C)E 00 ~ O)O)ffi.c~ ~0)t51- .... ::00 0) '5.0 - ... 00) lJ.. 0) ~...J...JI-ZO c.c:(c:( 1-1- 1-1- a:J Exhibit 1 F Gradilone Schedul e 3 Page 35 of 37 UNITE D WA TE R IDAHO E xis ling Final Tariffs E XIS TlNG UNR OUNDE D PROPOSED PE RCE NT CHARGE CHARGE CHARGE CHANGE METERED SERVICE TARIFFS Fixed Service Charges METER SIZE OJ-Monthly OJ-Monthly 5/8"$ 14.17,22289 $ 17 .17,95% 3/4"$ 14.17,22289 $17.17,95% $ 19.22,64928 $ 22.17,97% 1 1/4"$31.36,68712 $ 36.17.97% 1 1/2"$ 31.36.68712 $ 36.17,97% $ 44.52,96629 $ 52.17.97% $ 82.97.32113 $ 97.17,96% $ 131.154,88805 $ 154.17.97% $ 252.298,09756 $ 298.17,97% $ 381.449,68258 $ 449.17,96% 10"$ 532.628,63549 $ 628.17,97% Flat Rate Service $ 58.62.05800 $ 62.27% Commodity Rates (CCF) WINTER PERIOD $1.0912 2872341 $1.2872 17,96% SUMMER PERIOD ~CCF $1.0912 $1.2872 SUMMER PERIOD :::BCCF $1.3641 1.6090426 $1.6090 17,95% Commodity Rates (KG) WINTER PERIOD $1.4587 1.7207815 $1.7208 17,97% SUMMER PERIOD ~CCF $1.4587 $1.7208 SUMMER PERIOD :::BCCF $1.8235 1509769 $2.1510 17,96% PRIVATE FIRE PROTECTION TARIFFS Fixed Service Charges METE R SIZE Monthly Monthly $ 12.15,07593 $ 15.17,92% $ 19.22.84982 $ 22.17,97% $ 48.56,76476 $ 56.17,96% $ 79.93,26313 $ 93.17,96% 10"$ 123.145.45085 $ 145.17,96% 12"$ 184.217,86956 $ 217.17,97% Private Hydrant $ 7.13049 $ 9.17.96% Sprinkler Rate $ 193.228.45102 $ 228.17,96% Exhibit 1 F Gradilone Schedule 3 Page 36 of 37 UNITED WATER IDAHO Private Fire Protection Revenue at Proposed Rates Service Size Type Bi-Monthly Numberof Bills Rendered RevenueRatesServices P R IV ATE FIR E SE R V IC E LI N E S $ 30.271 629 $ 49 095 $ 45.407 2,441 $ 111 539 $ 113.466 2,788 $ 316,439 $ 186.124 745 $ 138 933 10"$ 290.$ 19,750 12"$ 435.$ 12 945 TOTAL 284 700 $ 648,701 PRIVATE HYDRANTS Hydrants $ 18.170 019 $ 18 616 TOTAL 170 019 $ 18,616 OTHE R Annual Rate Ada County Highway *$ 2 741.$ 2,741 TOTAL FIRE SERVICES 455 719 $ 670 058 REVENUE AT PROPSED RATES $ 567 884 INCREASE $ 102 174 Exhibit 1 F Gradilone Schedule 3 Page 37 of 37 UN I T E D W A T E R I D A H O Bi l l A n a l y s i s f o r Ba s e Y e a r P r i c e d a t P r e v a i l i n g R a t e s "U e n "T I m ~ g . G ) ~ CD C D i i J 6 ' .. . . . . g - Q - . ;:: ; : CD 0 " " ' " :: J .. . . . . ... . . . MA I N S Y S T E M ( W a t e r 1 8 ) RE S I D E N T I A L CO M M E R C I A L PU B L I C A U T H O R I T Y TO T A L A L L S E C T O R S Bi - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me t e r 5/ 8 " $ 1 4 , 77 8 03 1 23 8 55 6 $ 3 7 24 3 $1 1 9 73 , 34 3 $ 1 , 06 8 60 1 $ 1 4 , 56 1 $ 1 5 4 19 0 38 9 $ 5 , 68 3 $ 2 6 95 2 $ 1 5 9 89 9 Siz e 3/ 4 " $ 1 4 , 23 4 01 8 $ 3 40 9 64 1 10 , 4 2 2 $ 1 5 1 84 3 $4 2 1 24 4 46 9 $ 3 56 1 90 6 $ 1 4 , 59 7 $ 5 3 4 32 2 67 5 $ 2 4 , 4 5 3 $ 3 4 3 38 , 29 6 $5 5 9 11 8 $ 1 9 , 27 , 67 4 $ 5 3 1 , 06 0 88 9 $ 2 2 8 15 3 12 4 $ 2 , 37 3 68 7 $ 7 6 1 58 7 $ 1 9 , 09 6 $ 7 8 64 7 00 0 $ 3 8 39 2 $4 2 5 11 8 $ 1 1 7 46 4 11 / 2 " $ 3 1 , 82 9 $ 2 5 75 5 62 4 $ 2 3 6 , 73 1 $ 2 63 1 53 8 $2 6 5 11 6 $ 3 1 , 15 4 $ 4 77 5 25 2 $ 3 8 93 2 $ 5 1 7 42 2 $ 4 4 22 4 $ 4 4 , 46 3 $ 2 0 77 0 76 7 $3 0 3 71 1 18 5 $ 8 , 28 3 7, 4 1 5 $ 3 3 2 76 5 $ 4 4 , $ 3 84 1 13 9 $ 5 1 12 3 70 5 26 2 $ 5 6 66 9 $ 8 2 , 34 6 57 0 $ 4 7 , 02 6 $ 2 4 9 58 9 $ 4 8 62 1 $ 8 2 , $ 3 4 8 $ 7 52 3 $ 3 8 $ 7 , 90 9 $ 1 3 1 , $ 0 17 8 $ 2 3 34 1 17 8 $ 2 3 , 34 1 $ 1 3 1 , $ 0 $ 3 63 5 $ 0 $ 3 , 63 5 $ 2 5 2 , $ 0 $ 2 , 79 5 $ 0 $ 2 , 79 5 $ 2 5 2 , $ 0 $4 9 0 $ 0 $ 4 9 0 $ 3 8 1 , $ 0 $ 2 28 8 $ 0 $ 2 , 28 8 $ 3 8 1 , $ 0 $ 0 $ 0 $ 0 Fla t R a t e S e r v i c e $ 5 4 , 23 3 12 , 65 1 23 3 65 1 $ 5 8 , 71 3 71 3 Su b t o t a l F i x e d C h a r g e s 38 5 53 9 $ 5 81 0 29 6 59 8 $ 1 20 3 36 4 53 6 $ 1 7 , 13 0 43 2 67 3 $ 7 , Q.~ 0 , . 7 9 0 Un i t C o s t Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e To t a l B i l l e d To t a l ; U s e fo r W a t e r Re v e n u e Us e Re v e nu e ' , ' US E C H A R G E S .~ " , ,: : Wi n t e r R a t e 0 0 $0 . 98 2 5 63 1 35 4 56 7 80 5 2, 4 7 7 , 50 6 43 4 15 0 93 7 60 6 12 7 79 7 ,~ p ; 5 6 0 Su m m e r R a t e 0 0 $1 , 22 8 1 94 6 , 68 9 07 5 02 9 2, 4 1 9 00 4 97 0 77 9 52 , 86 4 92 2 7,4 1 8 55 7 ~1 0 73 0 Wi n t e r R a t e 8 / 0 5 $1 , 08 6 5 Su m m e r R a t e c : 3 C C F 8 / 0 5 $1 , 08 6 5 18 7 53 5 20 3 , 75 7 31 0 32 6 28 1 30 5 21 1 12 6 '2 2 9 ~ 3 8 8 en : Su m m e r R a t e 8 / 0 5 $1 , 35 8 1 75 1 , 74 0 73 7 13 8 55 6 62 9 11 4 , 05 8 80 0 47 1 33 8 16 9 5i! j 9 , n , 66 7 , - . . Wi n t e r R a t e 9 / 0 5 $1 , 09 1 2 35 8 1,4 8 2 58 2 63 5 94 0 C: 2 , 11 7 Su m m e r R a t e c : 3 C C F 9 / 0 5 $1 , 09 1 2 72 2 78 8 81 8 98 4 54 0 77 2 Su m m e r R a t e 9 / 0 5 $1 , 36 4 1 Su b t o t a l U s e C h a r g e s 51 9 39 8 $ 1 3 58 5 99 9 47 8 85 3 54 6 93 6 10 1 88 2 $ 1 2 4 30 5 10 0 13 3 $ 2 1 , 25 7 23 9 TO T A L S E C T O R R E V E N U E $ 1 9 39 6 , 29 5 $ 8 , 75 0 , 30 0 $1 4 1 43 5 $ 2 8 , 28 8 , 03 0 , i .. . . :" . 1 ". 0 UN I T E D W A T E R I D A H O Bi l l A n a l y s i s f o r Ba s e Y e a r P r i c e d a t C u r r e n t R a t e s "U e n "' T l m ~ g . ( j ) ~ CD C D O J 0 ' a. ; : : ; : !: : - , CD 0 " ... . . . -. .. . . . . ... . . . MA I N S Y S T E M ( W a t e r 1 8 ) RE S I D E N T I A L CO M M E R C I A L PU B L I C A U T H O R I T Y TO T A L A L L S E C T O R S Bi - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me t e r 51 8 " $ 1 4 . 70 , 77 8 $ 1 03 3 36 1 55 6 $ 3 7 32 0 $ 1 2 0 34 3 $ 1 07 0 80 1 $ 1 4 . 56 1 $1 5 4 19 0 38 9 $ 5 68 3 $ 2 6 95 2 $ 1 5 9 , 89 9 Siz e 31 4 " $ 1 4 . 23 4 01 8 $ 3 , 4 1 6 66 2 10 , 4 2 2 $ 1 5 2 , 15 6 $ 4 2 2 24 4 46 9 $ 3 56 9 24 0 $ 1 4 . 59 7 $ 5 3 4 32 2 67 5 $ 2 4 , 4 5 3 $ 3 4 3 29 6 $5 5 9 , 11 8 $ 1 9 . 27 , 67 4 $ 5 3 1 , 33 7 88 9 $ 2 2 8 , 27 2 12 4 $ 2 , 37 4 68 7 $ 7 6 1 98 4 $ 1 9 . 09 6 $ 7 8 , 64 7 00 0 $ 3 8 39 2 $ 4 2 5 11 8 $ 1 1 7 , 4 6 4 11 1 2 " $ 3 1 . 82 9 $ 2 5 79 6 62 4 $ 2 3 7 , 11 2 $ 2 , 63 5 53 8 $ 2 6 5 54 3 $ 3 1 . 15 4 $ 4 77 5 25 2 $ 3 8 93 2 $ 5 1 7 42 2 $ 4 4 , 22 4 $ 4 4 , 46 3 $ 2 0 78 0 76 7 $ 3 0 3 84 7 18 5 $ 8 28 7 7, 4 1 5 $ 3 3 2 91 3 $ 4 4 . $ 3 84 1 13 9 $ 5 1 12 3 70 5 26 2 $ 5 6 66 9 $ 8 2 , $ 1 , 34 6 57 0 $ 4 7 , 03 2 $ 2 4 9 58 9 $ 4 8 62 7 $ 8 2 . $ 3 4 8 $ 7 , 52 3 $ 3 8 $ 7 , 90 9 $ 1 3 1 . $ 0 17 8 $ 2 3 , 34 5 $ 0 17 8 $ 2 3 34 5 $ 1 3 1 . $ 0 $ 3 63 5 $ 0 $ 3 63 5 $ 2 5 2 . $ 0 $ 2 79 6 $ 0 $ 2 79 6 $ 2 5 2 . $ 0 $ 4 9 0 $ 0 $ 4 9 0 $ 3 8 1 . $ 0 $ 2 , 28 8 $ 0 $ 2 , 28 8 $ 3 8 1 . $ 0 $ 0 $ 0 $ 0 Fl a t R a t e S e r v i c e $ 5 8 . 23 3 56 2 23 3 56 2 $ 5 8 . 71 3 71 3 Su b t o t a l F i x e d C h a r g e s 38 5 , 53 9 $ 5 , 82 0 , 67 9 46 , 59 8 $ 1 , 20 4 , 39 9 53 6 $1 7 , 14 0 43 2 , 67 3 $ 7 , 04 2 , 21 8 Un i t C o s t f o r Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e U s e R e v e n u e Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e Wa t e r Re v e n u e Us e Re v e n u e US E C H A R G E S Wi n t e r R a t e 0 0 $1 . 09 1 2 63 1 35 4 96 2 , 53 3 2,4 7 7 50 6 70 3 , 4 5 4 93 7 20 , 66 4 12 7 79 7 68 6 65 2 Su m m e r R a t e 0 0 $1 . 36 4 1 94 6 68 9 74 7 , 77 8 2,4 1 9 00 4 29 9 , 76 4 86 4 72 , 11 2 41 8 55 7 10 , 11 9 65 4 Wi n t e r R a t e 8 1 0 5 $1 . 09 1 2 Su m m e r R a t e c : 3 C C F 81 0 5 $1 . 09 1 2 18 7 53 5 20 4 63 8 31 0 25 , 4 3 6 28 1 30 7 21 1 12 6 23 0 38 1 Su m m e r R a t e 8 1 0 5 $1 , 36 4 1 75 1 74 0 75 3 , 64 9 55 6 62 9 12 3 39 7 80 0 65 0 33 8 , 16 9 91 7 , 69 6 Wi n t e r R a t e 9 1 0 5 $1 . 09 1 2 35 8 1, 4 8 2 58 2 63 5 94 0 11 7 Su m m e r R a t e c : 3 C C F 91 0 5 $1 , 09 1 2 72 2 78 8 81 8 98 4 54 0 77 2 Su m m e r R a t e 9 1 0 5 $1 . 36 4 1 Su b t o t a l U s e C h a r g e s 11 , 51 9 , 39 8 $ 1 4 , 67 0 , 86 8 47 8 , 85 3 $ 8 , 15 4 , 67 5 10 1 , 88 2 $ 1 3 3 , 73 3 18 , 10 0 , 13 3 $ 2 2 , 95 9 , 27 6 TO T A L S E C T O R R E V E N U E $ 2 0 49 1 , 54 7 $ 9 , 35 9 07 4 $ 1 5 0 , 87 3 $ 3 0 , 00 1 49 4 UN I T E D W A TE R I D A H O Bi l l A n a l y s i s f o r Ba s e Y e a r Pr i c e d a t P r e v a i l i n g R a t e s "' C C / ) " m ~ g . G ) ~ CD C D i i 3 6 ' VJ a . a . ; : : : ; : !: : - , CD 0 " ... . . . -h .. . . . . . r : . ... . . . MA I N S Y S T E M ( W a t e r 0 9 ) RE S I D E N T i A l CO M M E R C I A l PU B L I C A U T H O R I T Y TO T A L A l l SE C T O R S B i - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me t e r 5/ 8 " $ 1 4 , $ 0 $ 0 $ 0 $ 0 $ 1 4 . $ 0 $ 0 $ 0 $ 0 Si z e 3/ 4 " $ 1 4 . 22 0 $ 6 1 , 4 9 3 $ 0 $ 0 22 0 $6 1 , 4 9 3 $ 1 4 . 71 5 $ 1 0 , 4 3 5 $ 0 $ 0 71 5 $ 1 0 , 4 3 5 $1 9 . $ 9 8 $ 9 8 $ 0 $ 1 9 5 $ 1 9 . $ 1 7 $ 1 7 $ 0 $ 3 4 1 1 / 2 " $ 3 1 . $ 1 5 9 $ 0 $ 0 $ 1 5 9 $ 3 1 . $ 2 8 $ 0 $ 0 $ 2 8 $ 4 4 . $ 0 $ 0 $ 0 $ 0 $ 4 4 . $ 0 $ 0 $ 0 $ 0 $ 8 2 . $ 0 $ 0 $ 0 $ 0 $ 8 2 . $ 0 $ 0 $ 0 $ 0 $ 1 3 1 . $ 0 $ 0 $ 0 $ 0 $ 1 3 1 . $ 0 $ 0 $ 0 $ 0 $ 2 5 2 . $ 0 $ 0 $ 0 $ 0 $ 2 5 2 . $ 0 $ 0 $ 0 $ 0 $ 3 8 1 . $ 0 $ 0 $ 0 $ 0 $ 3 8 1 . $ 0 $ 0 $ 0 $ 0 Fl a t R a t e S e r v i c e $ 5 8 . Su b t o t a l F i x e d C h a r g e s 94 7 $ 7 2 22 9 $ 1 1 5 95 3 $ 7 2 34 4 Un i t C o s t Bi l l e d U s e Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e fo r W a t e r Bi l l e d U s e Us e R e v e n u e Us e R e v e n u e Re v e n u e Us e Re v e n u e US E C H A R G E S WI n t e r R a t e 0 0 $ 0 . 98 2 5 33 1 49 , 4 5 0 34 6 49 , 4 6 5 Su m m e r R a t e 0 0 $ 1 . 22 8 1 22 6 98 0 22 8 98 2 WI n t e r R a t e 8 / 0 5 $ 1 . 08 6 5 Su m m e r R a t e - : 3 C C F 8 / 0 5 $ 1 . 08 6 5 15 9 34 6 16 6 35 3 Su m m e r R a t e 8 / 0 5 $ 1 . 35 8 1 06 3 09 9 14 , 0 6 5 10 1 WI n t e r R a t e 9 / 0 5 $ 1 , 09 1 2 Su m m e r R a t e -: 3 C C F 9 / 0 5 $ 1 . 09 1 2 Su m m e r R a t e 9 / 0 5 $ 1 , 36 4 1 Su b t o t a l U s e C h a r g e s 79 7 $ 1 0 1 89 5 $ 2 6 $ 0 91 , 82 2 $ 1 0 1 92 1 TO T A L S E C T O R R E V E N U E $ 1 7 4 , 12 4 $ 1 4 1 $ 0 $ 1 7 4 26 5 UN I T E D W A TE R I D A H O Bi l l A n a l y s i s f o r Ba s e Y e a r Pr i c e d a t C u r r e n t Ra t e s "U en 'T 1 m ~ g . ( j ) ~ CD C D i i J 6 ' .j : : . . a . a. ; : ; : c: : - , 0 C D 0" ... . . . .. . . . ::J .. . . . . . j : : . . ... . . . MA I N S Y S T E M (W a t e r 0 9 ) RE S I D E N T i A L CO M M E R C I A L PU B L I C A U T H O R I T Y TO T A L A L L S E C T O R S Bi - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me t e r 5 / 8 " $ 1 4 . $ 0 $ 0 $ 0 $ 0 $ 1 4 , $ 0 $ 0 $ 0 $ 0 Siz e 3 / 4 " $ 1 4 . 22 0 $ 6 1 61 9 $ 0 $ 0 22 0 $ 6 1 61 9 $ 1 4 . 71 5 $ 1 0 , 4 3 5 $ 0 $ 0 71 5 $ 1 0 , 4 3 5 $ 1 9 , $ 9 8 $ 9 8 $ 0 $ 1 9 5 $ 1 9 . $ 1 7 $ 1 7 $ 0 $ 3 4 11 / 2 " $ 3 1 . $ 1 5 9 $ 0 $ 0 $ 1 5 9 $ 3 1 . $ 2 8 $ 0 $ 0 $ 2 8 $ 4 4 , $ 0 $ 0 $ 0 $ 0 $ 4 4 . $ 0 $ 0 $ 0 $ 0 $ 8 2 . $ 0 $ 0 $ 0 $ 0 $ 8 2 . $ 0 $ 0 $ 0 $ 0 $ 1 3 1 . $ 0 $ 0 $ 0 $ 0 $ 1 3 1 . 3 0 $ 0 $ 0 $ 0 $ 0 $ 2 5 2 . $ 0 $ 0 $ 0 $ 0 $ 2 5 2 . $ 0 $ 0 $ 0 $ 0 $ 3 8 1 . $ 0 $ 0 $ 0 $ 0 $ 3 8 1 . $ 0 $ 0 $ 0 $ 0 Fl a t R a t e S e r v i c e $ 5 8 . Su b t o t a l F i x e d C h a r g e s 94 7 $ 7 2 , 35 6 $ 1 1 5 $ 0 95 3 $ 7 2 , 4 7 1 Un i t C o s t f o r Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e Wa t e r Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e U s e R e v e n u e Re v e n u e Us e Re v e n u e US E C H A R G E S Wi n t e r R a t e 0 0 $1 . 09 1 2 33 1 92 1 50 , 34 6 93 8 Su m m e r R a t e 0 0 $1 , 36 4 1 22 6 34 , 4 1 1 22 8 34 , 4 1 3 Wi n t e r R a t e 8/ 0 5 $1 , 09 1 2 Su m m e r R a t e ..: 3 C C F 8/ 0 5 $1 , 09 1 2 15 9 35 6 16 6 36 3 Su m m e r R a t e 8 / 0 5 $1 . 36 4 1 06 3 18 3 06 5 18 6 Wi n t e r R a t e 9 / 0 5 $1 . 09 1 2 Su m m e r R a t e .. : 3 C C F 9 / 0 5 $1 . 09 1 2 Su m m e r R a t e 9 / 0 5 $1 . 36 4 1 Su b t o t a l U s e C h a r g e s 91 , 79 7 $1 1 0 89 1 $ 2 8 $ 0 91 , 82 2 $ 1 1 0 , 91 9 TO T A L S E C T O R R E V E N U E $ 1 8 3 24 7 $ 1 4 3 $ 0 $ 1 8 3 , 39 0 UN I T E D W A T E R ID A H O Bi l l A n a l y s i s f o r Ba s e Y e a r Pr i c e d a t P r e v a i l i n g R a t e s 'U e n 'T 1 m ~ g . G ) ~ CD C D i i 3 6 ' 01 g . Q- . ; + 0 r o o " " " ::J .. . . . . " ' " ... . . . MA I N S Y S T E M (W a t e r S RE S I D E N T i A L CO M M E R C I A L PU B L I C A U T H O R I T Y TO T A L A L L S E C T O R S Bi - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me i e r 5 1 8 " $ 1 1 . 6 6 $ 0 $ 0 $ 0 $1 4 , 25 9 $ 3 77 0 $7 4 $ 0 26 4 $ 3 84 4 $1 4 , $ 8 3 4 $ 1 4 $ 0 $ 8 4 8 Si z e 3 1 4 " $1 1 , $ 0 $ 0 $ 0 $ 0 $1 4 . 51 6 $ 1 2 4 08 1 $ 1 36 1 $ 0 61 0 $ 1 2 5 44 1 $1 4 , 76 7 $ 2 5 80 2 $ 2 0 9 $ 0 78 2 $ 2 6 01 1 $1 3 , $ 0 $ 0 $ 0 $ 0 $1 9 . 13 6 $ 6 0 18 8 12 2 $ 2 33 4 $ 0 25 8 $ 6 2 52 2 $1 9 , 65 9 $ 1 2 64 6 $ 4 2 3 $ 0 68 1 $ 1 3 06 9 11 / 2 " $ 2 0 , $ 0 $ 0 $ 0 $ 0 $ 3 1 . 0 5 $ 0 $ 2 30 9 $ 0 $ 2 30 9 $3 1 . 1 0 $ 0 $ 3 7 4 $ 0 $ 3 7 4 $ 3 5 , $ 0 $ 0 $ 0 $ 0 $ 4 4 , $ 1 5 1 12 3 $ 5 54 2 $ 0 12 7 $ 5 69 3 $ 4 4 , $ 1 5 $ 9 5 4 $ 0 $ 9 6 9 $ 6 5 , $ 0 $ 0 $ 0 $ 0 $ 8 2 , $ 0 $ 8 7 0 $ 0 $ 8 7 0 $ 8 2 , $ 0 $ 1 2 0 $ 0 $ 1 2 0 $ 1 0 5 , $ 0 $ 0 $ 0 $ 0 $ 1 3 1 . $ 0 $ 2 , 7 5 2 $ 0 $ 2 , 7 5 2 $ 1 3 1 . 3 0 $ 0 $ 3 9 9 $ 0 $ 3 9 9 $ 2 5 2 , $ 0 $ 0 $ 0 $ 2 5 2 , $ 0 $ 0 $ 0 $ 0 $ 3 8 1 , $ 0 $ 0 $ 0 $ 0 $ 3 8 1 , $ 0 $ 0 $ 0 $ 0 Fl a t R a t e S e r v i c e Su b t o t a l F i x e d C h a r g e s 39 8 $ 2 2 7 48 7 52 5 $1 7 73 6 $ 0 92 3 $ 2 4 5 22 3 Un i t C o s t Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e fo r W a t e r Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e R e v e n u e Re v e n u e Us e Re v e n u e US E C H A R G E S WI n t e r R a t e 0 0 $ 0 . 98 2 5 17 2 , 7 8 3 16 9 , 7 5 9 42 3 90 8 20 2 20 6 19 8 66 7 Su m m e r R a t e 0 0 $1 , 22 8 1 19 4 25 0 23 8 55 8 67 6 58 6 22 8 92 6 28 1 14 4 WI n t e r R a t e 8 / 0 5 $ 1 . 0 8 6 5 Su m m e r R a t e - : 3 C C F 81 0 5 $ 1 . 0 8 6 5 85 2 79 1 27 4 29 8 12 6 08 8 Su m m e r R a t e 8 / 0 5 $1 , 35 8 1 15 7 23 3 21 3 53 8 46 0 21 9 18 1 69 3 24 6 , 7 5 7 WI n t e r R a t e 9 / 0 5 $ 1 . 0 9 1 2 Su m m e r R a t e - : 3 C C F 9 / 0 5 $ 1 . 0 9 1 2 17 3 18 9 17 3 18 9 Su m m e r R a t e 9 / 0 5 $1 . 3 6 4 1 Su b t o t a l U s e C h a r g e s 53 5 29 1 $ 6 3 3 83 5 83 3 $1 0 5 01 1 62 4 12 4 $ 7 3 8 84 6 TO T A L S E C T O R R E V E N U E $ 8 6 1 32 2 $ 1 2 2 , 74 7 $ 0 $ 9 8 4 06 9 UN I T E D W A T E R ID A H O Bi l l A n a l y s i s f o r Ba s e Y e a r P r i c e d a t C u r r e n t Ra t e s "U e n ' T I m ~ g . G ) ~ CD C D O J 0 ' 0) g - 9- . ; : : ; . : CD 0 " " " :: J ... . . . . j : : o . C D .. . . . . MA I N S Y S T E M ( W a t e r S C ) RE S I D E N T I A L CO M M E R C I A L PU B L I C A U T H O R I T Y TO T A L A l l SE C T O R S Bj - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E 0 C H A R G E S Me t e r 5/ 8 " $1 4 . $ 0 $ 0 $ 0 $ 0 $1 4 , 25 9 $ 3 77 8 $7 4 $ 0 26 4 $ 3 85 2 $1 4 , $ 8 3 4 $ 1 4 $ 0 $ 8 4 8 Si z e 3 / 4 " $ 1 4 , $ 0 $ 0 $ 0 $ 0 $ 1 4 , 51 6 $ 1 2 4 33 6 $ 1 36 4 $ 0 61 0 $ 1 2 5 , 7 0 0 $1 4 , 1, 7 6 7 $ 2 5 80 2 $ 2 0 9 $ 0 1, 7 8 2 $ 2 6 01 1 $1 9 , $ 0 $ 0 $ 0 $ 0 $1 9 , 13 6 $6 0 21 9 12 2 $ 2 33 6 25 8 $ 6 2 55 5 $1 9 , 65 9 $ 1 2 64 6 $ 4 2 3 $ 0 68 1 $ 1 3 06 9 11 / 2 " $ 3 1 . 1 0 $ 0 $ 0 $ 0 $ 0 $ 3 1 . 1 0 $ 0 $ 2 31 3 $ 0 $ 2 31 3 $ 3 1 . 1 0 $ 0 $ 3 7 4 $ 0 $ 3 7 4 $ 4 4 , $ 0 $ 0 $ 0 $ 0 $ 4 4 , $ 1 5 1 12 3 $ 5 54 5 $ 0 12 7 $ 5 69 6 $ 4 4 , $ 1 5 $ 9 5 4 $ 0 $ 9 6 9 $ 8 2 , $ 0 $ 0 $ 0 $ 0 $ 8 2 , $ 0 $ 8 7 1 $ 0 $ 8 7 1 $ 8 2 , $ 0 $ 1 2 0 $ 0 $ 1 2 0 $1 3 1 , $ 0 $ 0 $ 0 $ 0 $1 3 1 , $ 0 $ 2 . 7 5 3 $ 0 $ 2 75 3 $ 1 3 1 , $ 0 $ 3 9 9 $ 0 $ 3 9 9 $ 2 5 2 , $ 0 $ 0 $ 0 $ 0 $ 2 5 2 , $ 0 $ 0 $ 0 $ 0 $ 3 8 1 . 2 0 $ 0 $ 0 $ 0 $ 0 $ 3 8 1 . 2 0 $ 0 $ 0 $ 0 $ 0 Fl a t R a t e S e r v i c e $ 0 , Su b t o t a l F i x e d C h a r g e s 39 8 $ 2 2 7 78 1 52 5 $ 1 7 74 7 92 3 $ 2 4 5 52 8 Un i t C o s t f o r Bi l l e d U s e Bi l l e d U s e Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e Wa t e r Us e R e v e n u e Us e R e v e n u e Re v e n u e Us e Re v e n u e US E C H A R G E S Wi n t e r R a t e 0 0 $1 . 0 9 1 2 17 2 , 7 8 3 18 8 54 1 42 3 10 6 20 2 20 6 22 0 64 7 Su m m e r R a t e 0 0 $1 . 3 6 4 1 19 4 25 0 26 4 97 6 67 6 30 2 22 8 92 6 31 2 27 8 Wi n t e r R a t e 8 / 0 5 $1 . 0 9 1 2 Su m m e r R a t e ~ C C F 8 / 0 5 $1 . 0 9 1 2 85 2 84 2 27 4 29 9 12 6 14 1 Su m m e r R a t e 8 / 0 5 $1 . 36 4 1 15 7 23 3 21 4 . 4 8 2 46 0 36 6 18 1 69 3 24 7 84 7 Wi n t e r R a t e 9 / 0 5 $1 . 0 9 1 2 Su m m e r R a t e ~ C C F 9 / 0 5 $1 . 0 9 1 2 17 3 18 9 17 3 18 9 Su m m e r R a t e 9 / 0 5 $1 . 3 6 4 1 Su b t o t a l U s e C h a r g e s 53 5 29 1 $ 6 8 0 02 9 83 3 $ 1 1 3 , 07 3 62 4 12 4 $ 7 9 3 10 2 TO T A L S E C T O R R E V E N U E $ 9 0 7 81 0 $ 1 3 0 , 82 0 $ 0 $ 1 , 03 8 , 63 0 UN I T E D W A T E R ID A H O Bi l l A n a l y s i s f o r Ba s e Y e a r Pr i c e d a t P r e v a i l i n g R a t e s "' C e n . " ~ g . G ) ~ CD C D Q J O ' ~g . Q - . ; : : ; : 0 C D 0" ... . . . .. . . . . - i ' o - ... . . . MA I N S Y S T E M RE S I D E N T I A L CO M M E R C I A l PU B L I C A U T H O R I T Y TO T A L A l l SE C T O R S B i - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me t e r 5 / 8 " $ 1 4 . 03 7 $ 1 03 5 00 8 56 1 $ 3 7 31 7 $ 1 1 9 60 6 $ 1 07 2 44 5 $1 4 . 61 8 $ 1 5 5 02 4 39 0 $ 5 69 7 $ 2 6 01 0 $ 1 6 0 , 7 4 7 Si z e 3 / 4 " $ 1 4 . 24 6 , 7 5 5 $ 3 59 5 21 5 51 5 $ 1 5 3 20 4 $ 4 2 1 25 7 29 9 $ 3 74 8 84 0 $1 4 , 07 9 $ 5 7 0 55 9 68 9 $ 2 4 66 2 $ 3 4 3 40 , 7 9 2 $ 5 9 5 56 4 $ 1 9 . 81 5 $ 5 9 1 34 6 01 6 $ 2 3 0 58 6 12 4 $ 2 37 3 95 5 $ 8 2 4 30 4 $ 1 9 . 4,7 5 6 $ 9 1 31 0 02 3 $ 3 8 83 2 $ 4 2 5 80 0 $1 3 0 56 7 11 / 2 " $ 3 1 . 83 5 $ 2 5 91 4 69 9 $ 2 3 9 04 0 $ 2 63 1 61 8 $ 2 6 7 58 5 $ 3 1 . 15 4 $ 4 80 3 1,2 6 4 $ 3 9 30 6 $ 5 1 7 43 5 $ 4 4 62 6 $ 4 4 . 46 6 $ 2 0 92 1 89 1 $ 3 0 9 25 4 18 5 $ 8 28 3 54 1 $ 3 3 8 45 9 $ 4 4 . $ 3 85 6 16 0 $ 5 2 07 7 $ 1 , 7 0 5 28 4 $ 5 7 63 8 $ 8 2 , $ 1 34 6 58 1 $ 4 7 89 7 $ 2 4 9 60 0 $ 4 9 49 2 $ 8 2 , $ 3 4 8 $ 7 64 3 $ 3 8 $ 8 02 9 $ 1 3 1 . 2 8 $ 0 19 9 $ 2 6 09 4 $ 0 19 9 $ 2 6 09 4 $ 1 3 1 . $ 0 $ 4 03 4 $ 0 $ 4 03 4 $ 2 5 2 . $ 0 $ 2 , 7 9 5 $ 0 $ 2 , 7 9 5 $ 2 5 2 . $ 0 $ 4 9 0 $ 0 $ 4 9 0 $ 3 8 1 . $ 0 $ 2 28 8 $ 0 $ 2 28 8 $ 3 8 1 . $ 0 $ 0 $ 0 $ 0 Fl a t R a t e S e r v i c e $ 5 4 , 23 3 $ 1 2 65 1 $ 0 $ 0 23 3 $ 1 2 65 1 $ 5 8 . 71 3 1,7 1 3 Su b t o t a l F i x e d C h a r g e s 40 4 , 88 4 11 0 01 2 12 9 $ 1 22 1 21 5 53 6 $1 7 13 0 45 2 , 54 8 $ 7 34 8 , 35 7 Un i t C o s t Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e fo r W a t e r Re v e n u e Us e Re v e n u e US E CH A R G E Wi n t e r R a t e 0 0 $ 0 , 98 2 5 85 4 46 8 3, 7 8 7 01 5 50 6 94 4 2, 4 6 3 07 2 93 7 60 6 38 0 34 9 26 8 69 3 Su m m e r R a t e 0 0 $1 . 22 8 1 16 6 16 5 34 4 56 7 45 3 68 2 01 3 36 7 86 4 92 2 67 2 71 1 42 2 , 85 6 Wi n t e r R a t e 8 / 0 5 $ 1 . 08 6 5 Su m m e r R a t e .. : 3 C C F 8 / 0 5 $ 1 . 08 6 5 20 0 54 6 21 7 89 3 23 , 59 1 63 1 28 1 30 5 22 4 41 8 24 3 83 0 Su m m e r R a t e 8 / 0 5 $ 1 . 35 8 1 92 3 03 6 96 9 77 5 58 1 09 1 14 7 27 9 80 0 47 1 53 3 92 7 15 7 52 6 Wi n t e r R a t e 9 / 0 5 $1 . 09 1 2 37 6 50 1 58 2 63 5 95 8 13 7 Su m m e r R a t e .. : 3 C C F 9 / 0 5 $1 . 09 1 2 89 5 97 7 81 8 98 4 2, 7 1 3 96 0 Su m m e r R a t e 9 / 0 5 $ 1 . 36 4 1 Su b t o t a l U s e C h a r g e s 12 , 14 6 48 6 $ 1 4 32 1 72 9 56 7 , 71 1 $ 7 , 65 1 97 3 10 1 88 2 $ 1 2 4 30 5 81 6 07 9 $ 2 2 09 8 00 6 IT O T A L S tL l U K R E V r n $ 2 0 , 43 1 , 74 1 $ 8 , 87 3 , 18 8 $ 1 4 1 , 43 5 $ 2 9 , 44 6 , 36 4 UN I T E D W A T E R ID A H O Bi l l A n a l y s i s f o r Ba s e Y e a r Pr i c e d a t C u r r e n t Ra t e s "U C / ) ' T I m g. ( j ' ) ~ CD C D Q J O ' co c . c . ; : ; : c: - , 0 C D 0" " " " -. , :: J .. . . . . ~ .. . . . . MA I N S Y S T E M RE S I D E N T I A L CO M M E R C I A l PU B L I C A U T H O R I T Y TO T A L A l l SE C T O R S B i - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me t e r 5 / 8 " $ 1 4 . 03 7 $ 1 03 7 13 9 56 1 $ 3 7 39 4 $ 1 2 0 60 6 $ 1 07 4 65 3 $ 1 4 . 61 8 $ 1 5 5 02 4 39 0 $ 5 69 7 $ 2 6 01 0 $ 1 6 0 , 7 4 7 Siz e 3 / 4 " $ 1 4 . 24 6 75 5 $ 3 60 2 61 7 51 5 $ 1 5 3 51 9 $ 4 2 2 25 7 29 9 $ 3 , 75 6 55 9 $ 1 4 . 07 9 $ 5 7 0 55 9 68 9 $ 2 4 66 2 $ 3 4 3 40 , 7 9 2 $ 5 9 5 56 4 $ 1 9 . 81 5 $ 5 9 1 65 4 01 6 $ 2 3 0 , 70 6 12 4 $ 2 37 4 95 5 $ 8 2 4 , 7 3 4 $ 1 9 . 75 6 $ 9 1 31 0 02 3 $ 3 8 83 2 $ 4 2 5 80 0 $ 1 3 0 56 7 11 / 2 " $ 3 1 . 83 5 $ 2 5 , 95 5 69 9 $ 2 3 9 , 4 2 5 $ 2 63 5 61 8 $ 2 6 8 01 5 $ 3 1 . 15 4 $ 4 80 3 26 4 $ 3 9 , 30 6 $ 5 1 7 1, 4 3 5 $ 4 4 62 6 $ 4 4 . 46 6 $ 2 0 93 1 89 1 $ 3 0 9 39 2 18 5 $ 8 , 28 7 54 1 $ 3 3 8 , 60 9 $ 4 4 . $ 3 , 85 6 16 0 $ 5 2 07 7 $ 1 70 5 28 4 $ 5 7 63 8 $ 8 2 , $ 1 34 6 58 1 $ 4 7 90 2 $ 2 4 9 60 0 $ 4 9 49 8 $ 8 2 . $ 3 4 8 $ 7 64 3 $ 3 8 $ 8 02 9 $ 1 3 1 , $ 0 19 9 $ 2 6 09 8 $ 0 19 9 $ 2 6 09 8 $ 1 3 1 , $ 0 $ 4 03 4 $ 0 $ 4 03 4 $ 2 5 2 . $ 0 $ 2 , 7 9 6 $ 0 $ 2 79 6 $ 2 5 2 , $ 0 $ 4 9 0 $ 0 $ 4 9 0 $ 3 8 1 . $ 0 $ 2 28 8 $ 0 $ 2 28 8 $ 3 8 1 . $ 0 $ 0 $ 0 $ 0 Fl a t R a t e S e r v i c e $ 5 8 . 23 3 $ 1 3 56 2 $ 0 $ 0 23 3 $ 1 3 , 56 2 $ 5 8 , 71 3 71 3 Su b t o t a l F i x e d C h a r g e s 40 4 88 4 $6 , 12 0 81 7 47 , 12 9 $ 1 , 22 2 26 1 53 6 $1 7 14 0 45 2 54 8 $ 7 , 36 0 , 21 8 Un i t C o s t f o r Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e Wa t e r Re v e n u e Us e Re v e n u e US E C H A R G E S Wi n t e r R a t e 0 0 $1 . 09 1 2 85 4 , 4 6 8 20 5 99 5 50 6 94 4 73 5 57 7 93 7 66 4 38 0 34 9 96 2 23 7 Su m m e r R a t e 0 0 $1 . 36 4 1 16 6 16 5 04 7 16 6 2,4 5 3 68 2 34 7 , 06 8 86 4 11 2 67 2 71 1 10 , 4 6 6 34 5 Wi n t e r R a t e 8/ 0 5 $1 . 09 1 2 Su m m e r R a t e -c 3 C C F 8/ 0 5 $1 . 09 1 2 20 0 54 6 21 8 83 6 59 1 74 2 28 1 30 7 22 4 , 4 1 8 24 4 88 5 Su m m e r R a t e 8/ 0 5 $1 . 36 4 1 92 3 03 6 98 7 31 3 58 1 09 1 15 6 , 76 6 80 0 65 0 53 3 92 7 18 4 72 9 Wi n t e r R a t e 9/ 0 5 $1 , 09 1 2 37 6 50 1 58 2 63 5 95 8 13 7 Su m m e r R a t e -c 3 C C F 9/ 0 5 $1 . 09 1 2 89 5 97 7 81 8 98 4 71 3 96 0 Su m m e r R a t e 9/ 0 5 $1 . 36 4 1 Su b t o t a l U s e C h a r g e s 14 6 , 48 6 $ 1 5 , 46 1 78 8 56 7 , 71 1 $ 8 , 26 7 , 77 6 10 1 , 88 2 $ 1 3 3 , 73 3 18 , 81 6 07 9 $ 2 3 , 86 3 , 29 7 TO T A L S E C T O R R E V E N U E $ 2 1 58 2 60 5 $ 9 , 49 0 03 7 $ 1 5 0 , 87 3 $ 3 1 , 22 3 , 51 5 UN I T E D W A T E R ID A H O Bi l l A n a l y s i s f o r Ba s e Y e a r P r i c e d a t C u r r e n t Ra t e s ." e n "T I m ~ g . G ) ~ CD C D i i J 0 ' co a . a . ; : ; : t: - , 0 r o Q " - " .. . . . . : J -, , MA I N S Y S T E M (W a t e r 0 9 ) RE S I D E N T I A L CO M M E R C I A L PU B L I C A U T H O R I T Y TO T A L A L L S E C T O R S Bi - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me t e r 5 / 8 " $ 1 4 . 65 5 $ 1 19 2 16 4 95 1 $ 4 3 09 1 $ 1 4 5 61 6 $ 1 23 5 , 4 0 0 Siz e 3 / 4 " $ 1 4 . 28 5 83 4 $ 4 17 3 17 6 20 4 $ 1 7 8 18 2 $ 7 6 5 29 8 09 1 $ 4 35 2 12 3 $ 1 9 . 57 1 $ 6 8 2 96 4 03 8 $ 2 6 9 53 8 14 6 $ 2 , 7 9 9 75 5 $ 9 5 5 30 1 1/ 2 " $ 3 1 . 98 9 $ 3 0 , 7 5 8 96 2 $2 7 8 , 7 3 1 10 1 $ 3 15 2 05 3 $ 3 1 2 64 1 $ 4 4 . 55 2 $ 2 4 , 7 8 7 05 1 $ 3 6 1 , 4 6 9 22 3 $ 9 99 2 82 5 $ 3 9 6 24 7 $ 8 2 . $ 1 69 4 67 3 $ 5 5 54 5 $ 2 8 7 69 7 $ 5 7 52 6 $ 1 3 1 . $ 0 22 9 $ 3 0 13 2 $ 0 22 9 $ 3 0 13 2 $ 2 5 2 . $ 0 $ 3 28 6 $ 0 $ 3 28 6 $ 3 8 1 . $ 0 $ 2 28 8 $ 0 $ 2 28 8 Fl a t R a t e S e r v i c e $ 5 8 . 26 2 27 5 23 3 27 5 Su b t o t a l F i x e d C h a r g e s 40 4 88 4 $ 6 12 0 81 7 12 9 $ 1 22 2 26 1 53 6 $ 1 7 , 14 0 45 2 51 9 $ 7 , 36 0 21 8 Un i t C o s t Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e fo r W a t e r Re v e n u e Us e Re v e n u e US E C H A R G E S Wi n t e r R a t e 9 / 0 5 09 1 2 85 5 84 4 20 7 , 4 9 7 50 7 53 0 2,7 3 6 21 7 93 7 66 4 38 3 06 6 96 4 37 8 Su m m e r R a t e . : 3 C C F 9 / 0 5 09 1 2 20 1 , 4 4 1 21 9 81 2 25 , 4 0 9 72 6 28 1 30 7 22 7 13 1 24 7 84 5 Su m m e r R a t e 9 / 0 5 3& 4 1 08 9 20 1 03 4 , 4 7 9 03 4 77 3 50 3 83 3 66 4 11 2 76 2 20 6 63 8 65 1 07 4 Su b t o t a l U s e C h a r g e s 12 , 14 6 48 6 $ 1 5 46 1 , 78 8 56 7 71 1 $ 8 , 26 7 77 6 10 1 88 2 $ 1 3 3 , 73 3 81 6 , 83 4 $ 2 3 86 3 , 29 7 TO T A L S E C T O R R E V E N U E $ 2 1 58 2 60 5 $ 9 , 49 0 03 7 $ 1 5 0 , 87 3 $ 3 1 , 22 3 , 51 5 WI N T E R U S E 85 5 84 4 46 . 50 7 53 0 61 . 93 7 22 , 38 3 06 6 51 . SU M M E R U S E 29 0 64 2 68 . 06 0 18 1 61 . 82 , 94 5 81 , 43 3 76 8 66 . TO T A L U S E 14 6 48 6 56 7 71 1 10 1 88 2 81 6 , 83 4 SU M M E R B I L L E D 0( 3 C C F 20 1 , 44 1 40 9 28 1 22 7 13 1 SU M M E R B I L L E D :0 3 C C F 08 9 20 1 97 , 03 4 77 3 99 . 66 4 99 . 12 , 20 6 63 8 98 . TO T A L S U M M E R U S E 29 0 64 2 06 0 18 1 94 5 43 3 76 8 "'C e n " T I m ~ g . G ) ~ CD C D i i J O ' c: - , ... . . 0 C D 0 " " " -. , ~ ff i ... . . . ... . . . UN I T E D W A T E R ID A H O Bi l l A n a l y s i s f o r T es t Y e a r P r i c e d at C u r r e n t Ra t e s RE S I D E N T I A l CO M M E R C I A l PU B L I C A U T H O R I T Y TO T A L A l l SE C T O R S Bi - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me t e r 5 / 8 " $ 1 4 . 26 9 $ 1 20 1 12 8 96 0 $ 4 3 22 3 $ 1 4 5 23 9 $ 1 24 4 49 6 Si z e 3 / 4 " $ 1 4 . 28 7 98 1 20 4 52 2 12 , 2 4 5 17 8 , 7 8 0 76 5 30 0 27 9 38 4 06 8 $ 1 9 . 83 8 68 8 09 1 08 6 27 0 45 9 14 6 2, 7 9 9 07 0 96 1 34 9 11 / 2 " $ 3 1 . 99 6 97 6 99 2 27 9 66 4 10 1 15 2 09 0 31 3 79 2 $ 4 4 . 55 6 96 6 07 8 36 2 68 1 22 3 99 2 85 6 39 7 63 9 $ 8 2 . 69 4 67 5 55 , 7 1 0 28 7 69 9 69 1 $ 1 3 1 . 3 0 22 9 13 2 22 9 13 2 $ 2 5 2 . 3, 2 8 6 28 6 $ 3 8 1 . 28 8 2, 2 8 8 Fl a t R a t e S e r v i c e $ 5 8 . 26 2 27 5 26 2 15 , 2 7 5 Su b t o t a l F i x e d C h a r g e s 40 7 66 1 $ 6 , 16 6 65 1 47 , 28 6 $ 1 22 6 22 2 53 6 $ 1 7 , 14 0 45 5 , 74 4 $ 7 , 41 0 , 01 4 Un i t C o s t Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e R e v e n u e Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e fo r W a t e r Re v e n u e Us e Re v e n u e US E C H A R G E S Wi n t e r R a t e 9 / 0 5 $1 . 09 1 2 03 1 84 9 39 9 55 4 60 8 22 3 84 6 09 2 85 3 84 6 66 1 92 5 26 9 49 3 Su m m e r R a t e o: 3 C C F 9 / 0 5 $1 . 09 1 2 21 0 63 6 22 9 84 6 42 9 83 9 32 4 35 4 23 7 38 9 25 9 03 9 Su m m e r R a t e 9 / 0 5 $1 . 36 4 1 45 8 44 4 53 8 16 3 19 6 , 7 9 3 72 4 84 5 95 , 39 5 13 0 12 8 75 0 63 1 39 3 13 6 Su b t o t a l U s e C h a r g e s 12 , 70 0 , 92 9 $1 6 , 16 7 56 3 83 1 44 4 $ 8 59 9 , 77 7 11 7 , 57 2 $ 1 5 4 32 8 19 , 64 9 94 6 $ 2 4 92 1 , 66 8 TO T A l SE C T O R R E V E N U E $ 2 2 33 4 , 21 4 $ 9 82 5 , 99 9 $ 1 7 1 46 8 $ 3 2 , 33 1 68 2 DI F F E R E N C E B a s e Y E A R v s T H R U A P R I L 2 0 0 6 FI X E D S E R V I C E C H A R G E S 55 4 44 3 $ 4 5 83 4 26 3 73 3 $ 3 , 96 2 15 , 69 0 $ 0 $ 4 9 79 6 WA T E R U S E C H A R G E S $ 7 0 5 77 5 $ 3 3 2 00 1 $ 2 0 , 59 5 $ 1 05 8 , 37 1 TO T A L R E V E N U E $ 7 5 1 60 9 $ 3 3 5 , 96 3 $ 2 0 , 59 5 $ 1 , 10 8 16 7 RE S I D E N T i A L CO M M E R C I A L PU B L I C A U T H O R I T Y TO T A L A L L S E C T O R S B i - m o n t h l y Bi l l s Fi x e d Bi l l s Fi x e d Bi l l s Fi x e d To t a l B i l l s To t a l F i x e d Ch a r g e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e Re n d e r e d Re v e n u e FI X E D C H A R G E S Me t e r 5/ 8 " $ 1 7 . 26 9 $ 1 , 4 1 6 67 3 96 0 $ 5 0 97 9 $ 1 7 1 85 , 23 9 $ 1 , 4 6 7 82 3 Si z e 3/ 4 " $ 1 7 . 28 7 98 1 95 9 03 2 24 5 21 0 86 3 90 3 30 0 27 9 17 0 , 7 9 8 $ 2 2 . 83 8 81 1 , 7 3 2 08 6 31 9 05 7 14 6 30 2 07 0 13 4 09 1 11 / 2 " $ 3 6 . 99 6 54 3 99 2 32 9 93 2 10 1 3, 7 1 8 10 , 09 0 37 0 19 4 $ 5 2 . 55 6 29 , 4 5 4 07 8 42 7 86 6 22 3 78 8 85 6 46 9 10 8 $ 9 7 . 99 8 67 5 71 8 33 9 69 9 05 4 $ 1 5 4 . 22 9 54 5 22 9 54 5 $ 2 9 8 . 87 6 87 6 $ 4 4 9 . 69 9 69 9 Fl a t R a t e S e r v i c e $ 6 2 . 26 2 16 2 8 8 26 2 16 2 8 8 Su b t o t a l F i x e d C h a r g e s 40 7 66 1 $ 7 27 1 71 9 28 6 $ 1 , 4 4 6 , 53 5 53 6 $ 2 0 22 1 45 5 , 74 4 $ 8 73 8 , 47 5 Un i t C o s t Bi l l e d U s e Bi l l e d U s e Bi l l e d U s e Us e To t a l B i l l e d To t a l U s e fo r W a t e r Us e R e v e n u e Us e R e v e n u e Re v e n u e Us e Re v e n u e US E \ C H A R G E S Wi n t e r R a t e 9 / 0 5 $1 . 28 7 2 03 1 84 9 18 9 , 7 9 6 60 8 22 3 35 7 30 4 85 3 13 0 66 1 92 5 57 5 , 23 0 Su m m e r R a t e -: 3 C C F 9 / 0 5 $1 . 28 7 2 21 0 63 6 27 1 13 1 42 9 01 9 32 4 41 7 23 7 38 9 30 5 56 7 Su m m e r R a t e 9 / 0 5 $1 . 60 9 0 8 4 5 8 4 4 4 13 6 0 9 6 3 6 41 9 6 7 9 3 6. 7 5 2 6 4 0 95 3 9 5 15 3 4 9 0 12 7 5 0 6 3 1 20 5 1 5 7 6 6 Su b t o t a l U s e C h a r g e s 70 0 , 92 9 $ 1 9 , 07 0 56 3 83 1 44 4 $ 1 0 , 14 3 , 96 3 11 7 57 2 $ 1 8 2 03 7 19 , 64 9 94 6 $ 2 9 39 6 , 56 3 TO T A L S E C T O R R E V E N U E $ 2 6 34 2 28 3 $ 1 1 59 0 , 49 8 $ 2 0 2 , 25 8 $ 3 8 13 5 , 03 9 DI F F E R E N C E B A S E Y E A R v s T H R U A P R I L 2 0 0 6 RE V E N U E I N B A S E Y E A R $ 2 2 33 4 21 4 $ 9 , 82 5 99 9 $ 1 7 1 46 8 $ 3 2 , 33 1 68 2 RE V E N U E I N C R E A S E T H R U A P R I L 2 0 0 6 $ 4 00 8 , 06 9 $ 1 , 76 4 49 9 $ 3 0 , 78 9 $ 5 , 80 3 35 7 UN I T E D W A T E R I D A H O Bi l l A n a l y s i s f o r T es Ye a r P ri e e d a t P r o p o s ed R a t e s "U e n - n m ~ g . G ) ~ CD C D i i J C ' .. . . . . g - Q - . ; : ; : "" " mo " " " Q, ~ ~ ... . . . ... . . . :~ U SCHEDULE NO. GENERAL METERED SERVICE - ~:- - \ 0 F: i 2: \ 9 Availability To all metered customers not served under a separate schedule. - ' -, ,,. , "" jT\Ui\,~~ CUi ii,!;):JiUi'Cu~omer Chames: B~Mo~h~ Per Meter CharQ $ 14. 14, 19, 31. 44. 82. 131. 252. 381. 532. Meter Size 5/8" 3/4" 1/4" and 1-1/2" 2" or multiple meters of equivalent capacity 3" or multiple meters of equivalent capacity 4" or multiple meters of equivalent capacity 6" or multiple meters of equivalent capacity 8" or multiple meters of equivalent capacity 10" or multiple meters of equivalent capacity Volume Char Winter Summer Rates Rates For all water used less than 3CCF (100 cubic Feet) (CCF)(1 CCF=748 gallons):$1.0912 $1.0912 For all water used greater than 3CCF $1.0912 $1.3641 Conditions of Contract: The customer shall pay the total of the customer charge plus the volume charge, The volume charge is based on all metered water for the billing period. Consumption is expressed in hundred cubic foot units or thousand gallon units as determined by the meter installed by the Company. The customer charge will be prorated whenever the customer has not been a customer for the entire billing period. Summer Period The summer rate will apply to water consumed between May 1 and September 30. Meter readings straddling these dates will be prorated. UNITED Issued Per IPUC Order No. 29871 Effective - September 28, 2005 Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road, Boise, Idaho Exhibit 2 F. Gradilone Schedule 1 Page 1 of 5 SCHEDULE NO. FLAT RATE SERVICE Availability To non-metered residential customers pursuant to Residential or Multi-Family Housing Non-Contiguous Water Systems Agreement Paragraph 11 (a) addressing flat rate systems. Customer Charqes Based on United Water Idaho residential consumption for the year ending June 1998 of 208.75 ccf, the average residential bill, assuming a %" meter and 65%/35% summer/winter split, is $350.43. Billed bi-monthly, equals $58.40. Bi-monthly Charqe $58.40 Conditions of Contract: The bi-monthly charge will be prorated whenever the customer has not been a customer for the entire billing period. The Company or the customer may convert to metered service pursuant to Subparagraphs (b) or (c) of Paragraph 11 as follows: (b)If Company should determine that a flat rate customer is using water in excess of the average residential customer, the Company will provide a meter setting and meter. Customer will then pay Company s metered tariff rates as approved by the IPUG, which rates may be amended from time to time. (c)If a customer prefers to pay Company s approved metered tariff rates, the customer shall pay the installation and material costs associated with the installation of a meter setting. UNITED Issued Per IPUG Order No. 29871 Effective - September 28,2005 Issued by UNITED WATER IDAHO ING. Gregory P. Wyatt, Vice President 8248 West Victory Road, Boise, Idaho Exhibit 2 F. Gradilone Schedule 1 Page 2 of 5 SCHEDULE NO. PUBLIC HYDRANTS AND STREET SPRINKLING Availability To the City of Boise and Ada County Highway District. Rates: Street SprinklinQ Service Flat Charge $193.66/Month Miscellaneous: Bills will be rendered monthly, bi-monthly, or at other intervals upon mutual agreement of the Company and the customer. Hydrants and service pipes from the fitting on the Company main to the hydrants are to be installed and maintained by and at the expense of the City of Boise or Ada County Highway District. UNITED Issued Per IPUC Order No. 29871 Effective - September 28 , 2005 Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road, Boise, Idaho Exhibit 2 F. Gradilone Schedule 1 Page 3 of 5 SCHEDULE NO. PRIVATE FIRE SPRINKLER AND SERVICE Availability To all customers who have sprinkler systems and/or inside hose connections for fire fighting purposes. Rate For service through a separate line for fire fighting purposes. For 3" service or smaller, per month For 4" service per month For 6" service per month For 8" service per month For 10" service per month For 12" service per month $ 12. 19. 48. 79. 123, 184. Miscellaneous: Provided that if the installation of a private fire service shall require an extension of the existing mains of the company, the cost of such extension shall be borne by the customer. All private fire services shall be equipped with sealed gate valves or thermal automatic openings. Meters may be placed on fire services by the utility at any time; however, metered rates will not apply unless improper use of water is disclosed, and if such be the case, usage will be billed to the consumer under Rate Schedule No. UNITED Issued Per IPUG Order No. 29871 Effective - September 28, 2005 Issued by UNITED WATER IDAHO lNG, Gregory P. Wyatt, Vice President 8248 West Victory Road , Boise, Idaho Exhibit 2 F. Gradilone Schedule 1 Page 4 of 5 SCHEDULE NO. PRIVATE FIRE HYDRANT SERVICE Availability: To all customers having private fire hydrant installations. Rate For fire hydrants installed and maintained by the customer at customer expense: Each fire hydrant, per month $7. Miscellaneous: Service pipe from the fitting on the company water main to the fire hydrant is to be installed and maintained by the customer. UNITED Issued Per IPUC Order No. 29871 Effective - September 28, 2005 Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road , Boise, Idaho Exhibit 2 F. Gradilone Schedule 1 Page 5 of 5 Sheet No. Replacing all Previous Sheets , ,, " ,- , UNITED WATER IDAHO INC. ::'--- , !:'j r::! 9 " , '- ( JTiL_iT!:~~, C'~;il'!:)S:C:, SCHEDULE NO. GENERAL METERED SERVICE Availability To all metered customers not served under a separate schedule. Customer Charqes Bi-Monthly Per Meter Charqe $ 17. 17. 22. 36. 52, 97. 154. 298. 449. 628. Meter Size 5/8" 3/4" 1/4" and 1-1/2" 2" or multiple meters of equivalent capacity 3" or multiple meters of equivalent capacity 4" or multiple meters of equivalent capacity 6" or multiple meters of equivalent capacity 8" or multiple meters of equivalent capacity 10" or multiple meters of equivalent capacity Volume Charqe Winter Rates Summer Rates For all water used less than 3CCF (100 cubic Feet) (CCF)(1 CCF=748 gallons): For all water used greater than 3CCF $1.2872 $1.2873 $1.2872 $1.6090 Conditions of Contract: The customer shall pay the total of the customer charge plus the volume charge. The volume charge is based on all metered water for the billing period. Consumption is expressed in hundred cubic foot units or thousand gallon units as determined by the meter installed by the Company. The customer charge will be prorated whenever the customer has not been a customer for the entire billing period. Summer Period The summer rate will apply to water consumed between May 1 and September 30. Meter readings straddling these dates will be prorated. UNITED Issued Per IPUC Order No. Effective - Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road , Boise , Idaho Exhibit 2 F. Gradilone Schedule 2 Page 1 of 5 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. FLAT RATE SERVICE Availability To non-metered residential customers pursuant to Residential or Multi-Family Housing Non-Contiguous Water Systems Agreement Paragraph 11 (a) addressing flat rate systems. Customer CharQes Based on United Water Idaho residential consumption for the year ending October 2005 of 186ccf, the average residential bill , assuming a :X" meter and 55% / 45% summer/winter split, is $ 374.76. Billed bi-monthly, equals $ 62.46. Bi-monthly CharQe $ 62.46 Conditions of Contract: The bi-monthly charge will be prorated whenever the customer has not been a customer for the entire billing period. The Company or the customer may convert to metered service pursuant to Subparagraphs (b) or (c) of Paragraph 11 as follows: (b)If Company should determine that a flat rate customer is using water in excess of the average residential customer, the Company will provide a meter setting and meter. Customer will then pay Company s metered tariff rates as approved by the IPUC , which rates may be amended from time to time. (c)If a customer prefers to pay Company s approved metered tariff rates , thecustomer shall pay the installation and material costs associated with the installation of a meter setting. UNITED Issued Per IPUC Order No. Effective - Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road, Boise , Idaho Exhibit 2 F. Gradilone Schedule 2 Page 2 of 5 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. PUBLIC HYDRANTS AND STREET SPRINKLING Availability To the City of Boise and Ada County Highway District. Rates: Street Sprinklina Service Flat Charge $228.45/Month Miscellaneous: Bills will be rendered monthly, bi-monthly, or at other intervals upon mutual agreement of the Company and the customer. Hydrants and service pipes from the fitting on the Company main to the hydrants are to be installed and maintained by and at the expense of the City of Boise or Ada County Highway District. UNITED Issued Per IPUC Order No, Effective - Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road, Boise, Idaho Exhibit 2 F. Gradilone Schedule 2 Page 3 of 5 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. PRIVATE FIRE SPRINKLER AND SERVICE Availability To all customers who have sprinkler systems and/or inside hose connections for fire fighting purposes. Rate For service through a separate line for fire fighting purposes. For 3" service or smaller, per month For 4" service per month For 6" service per month For 8" service per month For 10" service per month For 12" service per month $ 15, 22. 56. 93. 145.45 217. Miscellaneous: Provided that if the installation of a private fire service shall require an extension of the existing mains of the company, the cost of such extension shall be borne by the customer. All private fire services shall be equipped with sealed gate valves or thermal automatic openings. Meters may be placed on fire services by the utility at any time; however, metered rates will not apply unless improper use of water is disclosed , and if such be the case, usage will be billed to the consumer under Rate Schedule No. UNITED Issued Per IPUC Order No. Effective - Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road, Boise, Idaho Exhibit 2 F. Gradilone Schedule 2 Page 4 of 5 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. PRIVATE FIRE HYDRANT SERVICE Availability: To all customers having private fire hydrant installations. Rate For fire hydrants installed and maintained by the customer at customer s expense: Each fire hydrant, per month $ 9. Miscellaneous: Service pipe from the fitting on the company water main to the fire hydrant is to be installed and maintained by the customer. UNITED Issued Per IPUC Order No. Effective - Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road , Boise, Idaho Exhibit 2 F. Gradilone Schedule 2 Page 5 of 5