Loading...
HomeMy WebLinkAbout20041201Gradilone Exhibits.pdfDean J. Miller McDEVITT & MILLER LLP 420 West Bannock Street O. Box 2564-83701 Boise, ill 83702 Tel: 208.343.7500 Fax: 208.336.6912 loe(g) mcdevitt -miller .com Idaho Public Utilities Commission Office of the SecretaryRECEIVED NOV 3 0 2004 Boise, Idaho Attorneys for Applicant BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF UNITED WATER IDAHO INC. FOR AUTHORITY TO INCREASE ITSRA TES AND CHARGES FOR WATER SERVICE IN THE STATE OF IDAHO Case No. UWI..O4- BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION EXHIB IT 6 TO THE DIRECT TESTIMONY OF FRANK GRADILONE III Ex h i b i t 6 , S c h e d u l e 1 , P a g e 1 o f 2 UN I T E D WA T E R I D A H O SU M M A R Y O F A D J U S T M E N T S T O O P E R A T I N G RE V E N U E U N D E R PR E S E N T R A T E S FO R T H E T W E L V E MO N T H S E N D E D JU L Y 3 1 , 2 0 0 4 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 ) Re v e n u e P e r El i m i n a t i o n 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 Pr o F o r m a Bo o k s f o r of C a r r i a g e Bo o k s l e s s BI L L A N A L Y S I S Bi l 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 Hi l l s & U n b i l l e d 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 7/ 3 1 / 0 4 Re v e n u e s & R e c l a s s Am o u n t Pe r c e n t En d e d 7 / 3 1 / 0 4 En d e d 7 / 3 1 / 0 4 IU W I O I n c o m e S1 ; J t e m e n t ) (S e e n o t e s ) r ( 1 ) + ( 2 ) ) (( 3 ) 0 ( 6 ) ) ( ( 4 ) (3 ) ) (E x h 6 S c h 3 P g 2 0 J IC o l ( 6 ) ) AR 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 : 46 1 1 0 0 Re s i d e n t i a l $ 2 1 16 1 38 4 ($ 5 , 60 5 ) (A ) $ 2 1 , 15 5 , 77 9 $ 3 8 53 2 18 % $2 1 , 11 7 , 24 7 $2 1 11 7 24 7 46 1 2 0 0 Co m m e r c i a l $ 8 , 94 7 66 5 $ 8 94 7 , 66 5 ($ 1 6 45 9 ) 18 " 1 0 $ 8 96 4 12 4 $ 8 96 4 12 4 46 1 4 0 0 Pu b l i c A u t h o r i t y $ 1 6 1 88 3 $ 1 6 1 88 3 $ 2 , 18 5 35 " ! o $ 1 . 69 8 $ 1 5 9 69 8 al a i M e t e r e d S a l e s $ 3 0 , 27 0 , 93 2 ($ 5 , 60 5 ) $ 3 0 , 26 5 , 32 7 $ 2 4 25 8 08 " 1 0 $ 3 0 , 24 1 , 0 6 9 $ 3 0 , 24 1 06 9 FI R E PR O T E O 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 $ 4 9 0 , 05 8 $ 4 9 0 , 05 8 ($ 5 , 68 3 ) 16 " 1 0 $ 4 9 5 , 74 1 $ 4 9 5 , 74 1 To t a l T a r i f f e d S e r v i c e s $ 3 0 , 76 0 , 99 0 ($ 5 , 60 5 ) $ 3 0 , 75 5 , 38 5 $ 1 8 , 57 5 06 % $ 3 0 , 73 6 , 81 0 $ 3 0 , 73 6 , 81 0 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 4 65 6 $ 4 4 65 6 $ 4 4 65 6 $ 4 4 , 65 6 47 1 0 0 0 Bu l k H y d r a n t S a l e s $ 8 6 33 4 $ 8 6 , 33 4 $ 8 6 , 33 4 $ 8 6 , 33 4 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 , 22 0 $ 1 2 22 0 $ 1 2 22 0 $ 1 2 22 0 10 . 47 4 9 0 0 Un b i l l e d R e v e n u e $ 9 5 , 54 2 (9 5 54 2 ) ( 8 ) $ 0 $ 0 $ 0 11 . 47 5 2 0 0 O& M C o n t r a c t R e v e n u e $ 4 8 0 $ 4 8 0 $ 4 8 0 $ 4 8 0 12 . To t a l O t h e r R e v e n u e $ 2 3 9 , 23 2 ($ 9 5 , 54 2 ) $ 1 4 3 , 69 0 $ 1 4 3 , 69 0 $ 1 4 3 , 69 0 TO T A L R E V E N U E 13 . To t a l R e v e n u e $ 3 1 00 0 22 2 ($ 1 0 1 , 14 7 ) $ 3 0 89 9 , 07 5 $ 1 8 , 57 5 06 % $ 3 0 88 0 , 50 0 $ 3 0 , 88 0 , 50 0 NO T E S : (A ) E l i m i n 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 s (8 ) 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 ;: ' i': ' . , , NO R M A L I Z I N G A D J U S T M E N T S T O OP E R A T I N G R E V E N U E UN D E R PR E S E N T R A T E S & T O T A L RE V E N U E S U N D E R F I N A L RA T E S FO R T H E T E S T YE A R E N D E D J U L Y 3 1 20 0 4 & T H E PR O F O R M A Y E A R E N D E D M A Y 3 1 , 20 0 5 (1 ) (2 ) (3 ) (4 ) (5 \ (6 ) (7 ) (8 ) (! J ) Ad j u s t e d AD J U S T M E N T S T O R E V E N U E No r m a l i z e d 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 Fu l l P r i c i n g We a t h e r An n u a l i z a t i o n 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 of S o u t h No r m a l i z i n g of G r o w t h of G m w t h Pr o F o r m a fo r P r o 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 7/ 3 1 / 0 4 Co u n t y Ad j u s t m e n t s Du r i n g Y e a r Th r u 5 1 3 1 / 0 5 Ye a r Fo r m a Y e a r by C a t e g o r y in R e v e n u e I E x h b s , : h 1 P g U I I h M Se . h ; i P I : 2 1 ) I I h l l 6 S e l l 3 P g 7 , 13 ) I ! E x l t f , S e l l 3 P g 7 13 ) J \h h ( , S c h 3 P g 7 13 ) . ! ! ( 1 ) + ( ( 2 ) . . . (S ) ) J \ E x h 6 S e h 3 P g 2 4 . 25 ) J ! ( 6 ) - ( 7 ) I (( 8 ) (7 ) J T A R I F F E D SE R V I C E S ME T E R E D W A T E R SA L E S : Re s i d e n t i a l $ 2 1 11 7 24 7 $ 7 9 11 6 ($ 1 4 6 , 4 9 1 ) $2 1 8 53 9 $ 3 5 6 , 12 0 $ 2 1 62 4 54 1 $ 2 6 , 4 5 7 55 6 $ 4 83 3 , 01 5 22 . 35 ' J\, Co m m e r c i a l 96 4 12 4 $ 9 27 0 ($ : ~ 4 21 3 ) $ 5 6 76 8 $ 9 4 61 3 $ 9 09 0 56 2 86 8 28 5 77 7 72 3 19 , 56 % Pu b l i c A u t h o r i t y $ 1 5 9 69 8 $ 0 ($ 3 65 0 ) $ 0 $ 1 5 6 04 9 $ 1 8 5 , 7 1 7 $ 2 9 66 8 19 . 01 ' To t a l M e t e r e d S a l e s S 3 0 , 24 1 , 06 9 $ 8 8 39 7 ($ 1 8 4 , 35 4 ) $ 2 7 5 , 30 7 $ 4 5 0 , 73 3 30 , 87 1 15 2 $ 3 7 , 51 1 , 55 8 $ 6 , 64 0 , 40 6 21 . 51 % 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 t e c t i o n $ 4 9 5 , 74 1 $ 1 2 , 50 2 $ 1 0 , 4 1 8 $ 5 1 8 , 66 1 $ 6 3 0 43 6 $ 1 1 1 , 77 5 21 . 5.' ; % To t a l T a r i f f e d S e r v i c e s $ 3 0 , 73 6 , 81 0 $ 8 8 , 39 7 ($ 1 8 4 , 35 4 ) $ 2 8 7 , 80 9 $ 4 6 1 15 1 $ 3 1 , 38 9 . 81 2 $ 3 8 , 14 1 99 4 $ 6 , 75 2 , 18 2 21 . 51 % OT H E R R E V E N U E Cu ~ 1 o m e r F e e s R e v e n u e $ 4 4 65 6 $ 1 32 9 $ 4 5 98 5 $6 1 67 0 $1 5 68 5 34 . 11 % Bu l k H y d r i 1 l 1 t S a l e s $8 6 33 4 $ 8 6 33 4 $ 8 6 13 4 OO o Re n t s - C o l l s t r u c t i o n M e t e r s $ 1 2 22 0 $ 1 2 , 2 2 0 $ 1 2 22 0 $ 0 00 % Un b i l l e d R e v e n u e $ 0 $ 0 $ 0 $ 0 00 % 10 . O& M Co n t r a c t R e v e n u e $ 4 8 0 $ 4 6 0 $ 4 8 0 $ 0 OO ' 11 . To t a l O t h e r R e v e n u e $ 1 4 : \ , 69 0 $ 1 , 32 9 $ 1 4 5 , 01 9 $ 1 6 0 , 70 4 $ 1 5 , 68 5 10 . 82 % TO T A L R E V E N U E 12 . To t a l R e v e n u e $ 3 0 88 0 50 0 $ 8 8 39 7 ($ 1 8 4 35 4 ) $ 2 8 7 80 9 $ 4 6 2 , 48 0 $ 3 1 , 53 4 83 2 $ 3 8 , 30 2 69 9 $ 6 , 76 7 86 7 21 . 4& ' RE V E N U E R E Q U I R E M E N T $ 3 8 , 30 2 , 70 2 $ 6 , 76 7 , 87 0 21 . 4 6 % DI F F E R E N C E R E V E N U E R E Q U I R M E N T v s R A T E PR O O F ($ 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 M E N T v s RA T E P R O O F OO O k ) l~ . ~: ' : i .~ : : "" ; , , i~ : : REPORT ON WATER SERVICE REVEN UES FOR UNITED WATER IDAHO FOR TH E TEST YEAR August 1 , 2003 through July 31 , 2004 INTRODUCTION This report assesses historical water consumption use patterns for United Water Idaho (United or Company), and derives pro forma: (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 August 1 , 2003 through July 31 , 2004. Since the capital projects in this case are projected through May 2005, the analysis was extended to account for expected growth from the end of the test year through May 31 2005. The 12-month period ending May 31 , 2005 is referred to as the pro forma year herein. For this assessment, the historical record for the period January 1986 through July 2004 was analyzed. The data, which came from the Company s billing system and other records, included: monthly-billed consumption and customers served by class data, for each of the three sectors in the United Water Idaho system-residential commercial and public; fire service counts by 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 Exhibit No. Case No. UWI~O4~O4 F. Gradilone, United Water Schedule 2, Page 1 of 19 pro forma water consumption and revenue estimates for the test 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 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, and 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 wou Id 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 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 multiplied by the coefficient ", and the temperature in the month is multiplied by " Exhibit No. Case No. UWI,W,O4, F. Gradilone, United Water Schedule 2, Page 2 of 19 and then this result is added to the value for the constant ". For example, if the actual regression equation was: Consumption (ccf) = 10 000 + 20 * number of customers - 50 * average temperature Then consumption for a month in a system that has 50 000 customers and the average temperature was 70 degrees would be predicted to be 006 500 CCF (i., 10 000 + (20 * 50 000) - (50 * 70) ). 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 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 the number of customers served. Hence the first variable assessed was the number of customers served in United's service area. 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 fou nd 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 , 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. Exhibit No. Case No. UWI,W,O4, F. Gradilone, United Water Schedule 2, Page 3 of 19 Substantial changes in the underlying characteristics of the customer base also affect water use patterns. Since 1980 a key factor that has been effecting water use in the UWID service area, and indeed across the nation, was the passage of Federal Standards that mandated lower water 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 United'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. For the purposes of this analysis it was assumed that 750/0 of all new customers added to the system during the tear year and through the pro forma period had access to, and are using alternate water supply for lawn watering. 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 was 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 more stable results.The month Exhibit No. Case No. UWI~O4~ F. Gradilone, United Water Schedule 2, Page 4 of 19 pattern index developed for each sector is shown in Exhibit 6, Schedule 3 , Page 1 of 25. Model Verification Regression analysis provides the analyst with measures of how good the model is at explaining the variable the analyst is trying to project, 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 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, the 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 No. Case No. UWI,O4,O4 F. Gradilone, United Water Schedule 2, Page 5 of 19 showing variances in each year, on an average basis for the entire base period should yield low absolute total and percentage variances The regression modeling was performed on an IBM PC compatible computer using the Microsoft Excel 2000 Version of the software package. A number of iterations and combinations of weather variables were tried; the results 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 also 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 December through May were established as the winter/base period, while June through November was established as the summer/peak period (Exhibit 6, Exhibit 3 , Page 1 of 25). The evident shifting forward in time of the periods is the result of the lag in billing customers every two months.For example, this results in including months such as May 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. WINTER PERIOD ANAL YSIS: The number of residential customers served by month in United's service area is shown in Exhibit 6, Schedule 3, Page 2 of 25. As shown on Exhibit No. Case No. UWI, W ,04, F. Gradilone, United Water Schedule 2, Page 6 of 19 this table, number of residential customers has been exhibiting a steady upward trend with the trend being disturbed on three occasions due to recoding of customers and acquisitions. 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. In 1999, South County, Barber and Raintree were added. These systems added 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 (see Exhibit 6, Schedule 3, Page 3 of 25). In the end it was found that for the winter period, a regression of residential water use per customer versus time and a dummy variable to account for the addition of the 4 800 customers in 1999, resulted in the best fit, even though the R-squared for the equation representing residential water use for the winter season was a relatively low 18.5% (Exhibit 6, Schedule 3 , Page 4 of 25). On closer examination it was found that in this case, the low R-squared was to be expected because the trend in residential water use per customer in the winter/base months in the system was virtually flat. (In regression analysis, the statistical goal is to minimize the squares of the differences between the actual data and the trend line. In the case where the data and trend line are essentially a flat line, the differences will sum to zero, yielding an R-squared of zero, even if there is a perfect fit. This situation is illustrated in Exhibit 6, Schedule 3 Exhibit No. Case No. UWI~O4~ F. Gradilone, United Water Schedule 2, Page 7 of 19 Page 5 of 25.) In these cases the analyst relies on the general fit of the data to the line and the magnitude of the standard error. The standard error should be low, and in this case it is only 1.47. SUMMER PERIOD: For the summer period, the number of customers, average monthly temperature, total monthly rainfall and dummy variables to account for the monthly pattern of use over the summer months, proved to be the best combination of variables. The statistics for the regression analyses for the residential sedor are summarized in Exhibit 6, Schedule 3, Page 4 of 25. The R-squared for the equation for peak use per customer was quite good - 93.2%-particularly given the complexity of the phenomena being measured. While variances were of course greater in individual months, over the entire period 1986 through 2004 (as shown in Exhibit 6 Schedule 3, Page 6 of 25) the annual residential consumption estimated by the regression equation for winter period varied by only 0.24%, while the variance for the summer period was only 1.75%. As shown in Exhibit 6, Schedule 3, Page 6 of 25 the regression estimates of annual residential water demand per customer has exhibited a steady downward trend , while overall water demands have been increasing due to the underlying growth in the number of customers served. NORMALIZING ADJUSTMENTS: The next step in the analysis was to normalize metered sales revenues for the weather conditions during the summer/peak period and the change in the customers in the winter/base period. This normalization was accomplished by continuing the dummy variable for the addition of customers through the test year and computing the regression results for the summer/peak period using the long run (1986-2003) average weather conditions for the months June through November. The total normalizing adjustment as shown in Exhibit 6, Schedule , Page 7 of 25, amounts to 144 922 units or $146 491 ; i., if the weather had been normal" during the test year revenues would have been this much lower under the existing rate structure. Exhibit No. Case No. UWI,O4, F. Gradilone, United Water Schedule 2, Page 8 of 19 GROWTH ADJUSTMENTS: During the test year the number of customers served increased. In order to account for a full year of fixed service charges for these customers it was assumed that these additional customers were added to the system in the same proportion with respect to the size of the meter as customers in the existing system (Exhibit 6, Schedule 3 , Page 9 of 25). The assessment of the amount of water these customers used was complicated by the fact that a large proportion of new customers that have been added to the system since 1997 have had use of alternate irrigation water supplies; these customers clearly use less water than customers that use United Water Idaho supply for irrigation purposes. To account for this bifurcation, it was decided to assume that 25% of the customers added during the test year used United Water Idaho supply for irrigation, and that 75% had access to, and used alternate supply. For new customers that use United Water Idaho supply for irrigation water use was assumed to be equivalent to the 5 year average of the United Water Idaho system for the period 1992 to 1996; i.e., the 5 years before the rule was changed. On average customers in the system before the rule changed, used 165 per year (Exhibit 6 Schedule 3, Page 7 of 25). To assess the amount of water for customers that utilize alternative irrigation supplies the Company was able to identify and isolate 5 areas in the system (based on meter reading books) that used alternate supply exclusively for irrigation. As shown in Exhibit 6, Schedule 3 , Page 8 of 25, over the past 4 years this group of customers consumed only 118 KG of water on average per year.As also shown in the Exhibit, these customers also had a different seasonal distribution of use from the customer bases as a whole. For this type of customer nearly 42% of all water use occurred during the winter months (versus 35% for the system as a whole). And conversely summer use for these customers only accounted for 58% of total annual use, versus 66% for the system as a whole. So using a half year convention to assess the use for the 1 841 customer added during the test year, a total of 119 804 KG of water was consumed; and pricing this use out at the prevailing rates results in an additional $135 525 in revenues. Adding this amount to the added fixed Exhibit No. Case No. UWI~O4~ F. Gradilone, United Water Schedule 2, Page 9 of 19 service charges of $83 014 yields a total adjustment for customer growth in the test year of $218 539 (Exhibit 6, Schedule 3, Page 7 of 25) For the twelve months following the end of the test year (August 2004 through July 2005) the number of customers added to the system was projected to total 1 800 , about the same as that which was added during the test year. To account for the impact of this expected growth through May 2005 , 1 0/12ths of these customers were added to the analysis (representing the number of months from August 2004 to May 2005) and since these customers represent the full count of customers expected at May , 2005 for rate making purposes the expected revenues for these customers was priced on a full year basis. As calculated on Exhibit 6, Schedule 3, Page 7 of 25 and summarized in Exhibit 6, Schedule 3, Page 7 of 25 an adjustment of an additional $356 120 was made to pro forma revenues to account for these customers. Commercial Sector Consumption Analysis:In 1996 Micron Technologies United's largest customer at the time informed the Company that it had embarked on a major efficiency and water reuse program. Given the expected magnitude of the shift in demand and the overall large size of Micron it was decided to treat Micron separately from the rest of the commercial sector in the proir rate case. Micron no longer is the single largest user in the system. Indeed in the test year its demand was less than 15% of its peak demand of 451 ,000 KG in 1995-, and barely 1/3 of what it was as recently as 2002-2003. During the test year Micron consumption amounted to only 68 593 KG (Exhibit 6, Schedule 3, Page 10 of 25). While Micron would seem to no longer require a separate analysis in order to make comparisons between the prior case and this case easier, 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 sedor, later in the analysis.) The effect is to lease test year consumption unchanged. The assessment of the commercial sector s consumption for the test year showed that a regression model of total monthly consumption, versus the number of Exhibit No. Case No. UWI,W,O4, F. Gradilone, United Water Schedule 2, Page 10 of 19 commercial customers, average monthly temperature, total rainfall, and monthly pattern variables to account for the variability in billing patterns and seasonal economic activity for the months June through December, proved to be the best model (Exhibit 6 Schedule 3 , Page 11 of 25). The R-squared for this equation was just under 96%. On an annual basis the regression estimates for the commercial sector were within 0.5% of actual results on a normalized basis (Exhibit 6, Schedule 3, Page 12 of 25). NORMALIZING ADJUSTMENTS: The next step in the analysis was to normalize metered sales revenues for the weather conditions during the test year. This normalization was accomplished by computing the regression results for the summer/peak period using the long run average weather conditions for the months June through December. The total normalizing adjustment as shown in Exhibit 6 Schedule 3 , Page 13 of 25, amounts to 30 253 KG or $34 213; i., if the weather had been "normal" during the test year revenues would have been 0.38% lower in the test year under the existing rate structure. GROWTH ADJUSTMENTS: During the test year 130 new commercial customers were added to the system. In order to account for a full year of fixed service charges for these customers it was assumed that these additional customers were added to the system in the same proportion with respect to the size of the meter as customers in the existing system (Exhibit 6, Schedule 3, Page 9 of 25). On average commercial customers in the system consumed 636 KG of water on a normalized basis during the test year (Exhibit 6, Schedule 3, Page 14 of 25). The distribution of billed water use by season for the commercial sector was 40% during the winter period and 60% for the summer period. Using the half-year convention methodology to assess the water use for the 130 commercial customers added during the test year, yields a total of additional 41 351 KG of water use for the sector. Pricing this use out at the prevailing rates results in an additional $46 764 in revenues. Adding this mount to the added fixed service charges of $10 004 yields a total adjustment for customer growth in the test year of $56 768 (Exhibit 6, Schedule 3, Page 13 of 25) Exhibit No. Case No. UWI~O4~ F. Gradilone, United Water Schedule 2, Page 11 of 19 For the twelve months following the end of the test year (August 2004 through July 2005) the number of customers added to the system was projected to total the same as during the test year, Le., 130 customers. T 0 account for the impact of this expected growth through May 2005, 1 0/12ths of these customers (108) were added to the analysis (representing the number of months from August 2004 to May 2005) and since these customers represent the full count of customers expected at May 31 , 2005 for rate making purposes the expected revenues for these customers was priced on a full year basis. As calculated on Exhibit 6, Schedule 3 , Page 13 of 25 and summarized in Exhibit 6, Schedule 1 , Page 2 of 2 an adj ustment of an additional $94 613 was made to account for this growth through May 2005. Public Sector Consumption Analysis:The analysis of the public sector paralleled the analysis of the residential and commercial sectors. Again , a regression equation that incorporated the average daily temperature and the total rainfall, and monthly pattern variables for the months of May through December, were included in the model (Exhibit 6, Schedule 3, Page 15 of 25). The R-squared for the public sector model was also quite good at just over 87%. On average the regression estimates of annual public sector consumption were within two-tenths of a percent of actual consumption on a normalized basis. The total weather normalization for the public sector amounted to -119 CCF (Exhibit 6, Schedule 3, Page 16 of 25). Based on the distribution of use by billing period (summer versus winter) this results in a revenue adjustment of ($3 650) for the sector in the test year. No change in the number of public sector customers occurred during the test year, and no changes are expected through May 2005, so there was no need to make adjustments for growth. PRIVATE FI RE PROTECTION SERVICES REVEN UE Private Fire Protection revenues at current rates collected during the test year totaled $495 741 , as shown in Exhibit 6, Schedule 3, Page 17 of 25. Due to growth in the number of private fire services during the year and anticipated through May 2005 Exhibit No. Case No. UWI,O4, F. Gradilone, United Water Schedule 2, Page 12 of 19 an additional $22 920 in revenues were added to the total to derive annualized private fire revenues of $518 661 for the pro forma year (Exhibit 6, Schedule 3, Page 18 of 25). OTHER REVENUES The Company receives revenues from a number of customer service related charges (including miscellaneous service revenues, rents for construction meters, and other water revenue). During the test year these revenues totaled $143 690, or less then 0.50% of total revenues. In addition , $95 542 in unbilled revenues was recorded on the books during the test year. The first adjustment to other revenues was to eliminate unbilled revenues, since the analysis for the test year assumes that all fixed service charges and consumption for all customers were billed and collected. Other Revenues for the test year were adjusted upwards by $1 329 to account for customer growth during the test year. In addition United Water Idaho proposes to increase a number of customer service charges to bring them more in line with the actual cost to deliver the service and the pricing of such fees of other utilities in the State. These additional charges are projected to increase customer service fees by $15 685 going forward (Exhibit 6, Schedule 3 , Page 19 of 25). Bill ANALYSIS AND PRO FORMA REVENUE ESTIMATE FOR TEST YEAR: Total revenue for metered sales booked during the test year for the basic United Water Idaho system amounted to $30 270 932 (Exhibit 6, Schedule 1 Page 1 of 2). One adjustment was made to these revenues for the test year to account for the pending sale of Carriage Hills to the City of Nampa, IPUC Order No. 29625. During the test year these Carriage Hills customers generated $5 605 in revenues that will not be realized going forward. Subtracting these revenues yields an adjusted test year billed revenue total of $30 265 327. Revenues as per the determinants in the bill analysis for the test year as billed amounted to $30 241 069; $24 258 or 0.08% less than the book total (Exhibit 6, Schedule 1 , Page 1 of 2). The bill analysis determinants (Exhibit 6, Schedule 3, Page 20 of 25) were thus established as the basis for the pro Exhibit No. Case No. UWI~O4~ F. Gradilone, United Water Schedule 2, Page 13 of 19 forma analysis (Exhibit 6, Schedule 1 , Page 1 of 2, Column 7). (Exhibit 6, Schedule 4 Pages 1-4 show the derivation of the bill determinants for each subsystem and the system as a whole. Fire protection revenue as per the books amounted to $490 058 (Exhibit 6 Schedule 1 , Page 1 of 2, Column 1). Revenues as per the determinants (Exhibit 6 Schedule 3 , Page 17 of 25) in the bill analysis were slightly higher at $495 741 or 16% (Exhibit 6, Schedule 1 , Page 1 of 2, Column 6). The bill determinants as per the bill analysis were used moving forward (Exhibit 6, Schedule 1 , Page 1 of 2, Column 7). Four adjustments were made to metered sales revenues for the test year. First an adjustment was made to account for the increase in revenues that would have been realized if the customers in South County that were under the last step of a rate phase- in for part of the test year, were priced at United's existing rate structure. As shown in Exhibit 6, Schedule 3, Page 21 of 25 pricing all customers at the prevailing United rates for the test year would have yield an additional $88 397 in revenues; $79 126 in the residential sector and $9 270 in the commercial sector. Second, the decrease consumption indicated by the weather normalization was deducted from the bill determinants. Next, the increase in the number of customers served by meter size and the amount of additional consumption calculated for the annualization adjustment for customer growth during the test year and to account for growth in the system through May 2005 were added to the bill determinants. The resulting bill determinants for United through May 2005 are shown in Exhibit 6, Schedule 3, Page 22 of 25. These adjustments (which are summarized in Exhibit 6, Schedule 1 , Page 2 of 2) result in net metered sales revenue of $31 389 812 for the United system for the adjusted test year. Exhibit No. Case No. UWI,O4, F. Gradilone, United Water Schedule 2, Page 14 of 19 REVENUE ANALYSIS SUMMARY & PROPOSED RATE SCHEDULE CHANGES The test year in this case has been established as August 1 , 2003 through July , 2004. Total pro forma revenues for United Water Idaho for the test year after annualizing for growth were $31 634 797 (Exhibit 6, Schedule 1 , Page 2 of 2). Based on this filing the Company is asking for an increase in revenues of $6 767 870, for a total revenue requirement of $38 302 702 , or an overall increase of 21.46%. Based on the results of the cost of service study conducted in conjunction with this case, the Company proposes to increase rates to meet its revenue requirements on the following manner: Fixed service charges, plus 36.4%: The cost of service study found that fixed charges should be increased by 51.1 %. It was decided that making such a large change in this component of the rate structure at one time would be too disruptive. Hence, it was decided to split the difference between the 51.1 % increase as called for in the cost of service study, and the overall increase required. Fire protection charges, plus 21.5%: The cost of service study found that fire protection charges could be decreased. However, it was decided to not move rates in this direction at this time, but simply to increase the fire protection sector approximately the same amount as the overall Increase req uested. Water Use / commodity charges, plus 16.9%: Based on the decision to increase fixed service charges by 36., and fire protection charges by 21., water use charges would need to be increase by 16.9% to meet the revenue requirement.In terms of rate design it was also decided to maintain the summer/winter rate structure and keep the differential at 25%. Exhibit No. Case No. UWI~O4~ F. Gradilone, United Water Schedule 2, Page 15 of 19 In order to generate the revenue requirement tariffed rates would have to be increased by 21.51 % (this is slightly higher than the overall increase to compensate for the categories of other revenues- Rents and Other Revenue-that will not be affected by the tariff change.) The derivation of the proposed rate schedule is shown in Exhibit 6 Schedule 3 , Page of 23 of 25. The rate proof for the residential, commercial and public sectors for the United Water Idaho service area is shown in Exhibit 6, Schedule 3 , Page 24 of 25. And finally, the proof of fire rates is shown in Exhibit 6, Schedule 3 , Page 25 of 25. Total revenues generated by the proposed tariffs are $38 302 699, $3.00 less than the revenue requirement. The proposed tariff schedule is included as Exhibit 7 of the filing. TARIFF CHANGES Upon review of the United Water Idaho tariff, it was decided to take the opportunity presented by this proceeding to update the tariff to conform to current IPUC standards, and remove a number of tariff pages associated with the phase in of rates for a number of system that were acquired in prior years. Most of the changes were cosmetic in nature and/or involve correcting grammatical or unclear language. The only change made to the tariff that is of substance is in Section 71 of the Rules and Regulations. The words "and/or Commercial" was inserted after "Industrial" on the fourth line of the section in reference to situations where developers of subdivisions pay for services when the size and location of the service cannot be initially determined. We believe the rule should also include the commercial sector because this is the most common type of development after residential; we do not typically see any purely industrial developments. In the past we were not collecting service line cost CIAC on commercial developments where the service size and location could not be determined up front and thus we were paying to install them later. This change in the tariff will insure that developers of both industrial and commercial projects pay this cost. The remaining changes made and the reasons for the change are as follows: Exhibit No. Case No. UWI,O4, F. Gradilone, United Water Schedule 2, Page 16 of 19 Table of Contents: Updated and renumbering to reflect changes made elsewhere in the tariff Schedule 1: Proposed changes to tariff rates Schedule 1 A: Change in wording to conform to IPUC standards Schedule 1 B: Deletion of a page that referred to a page that had previously been withdrawn Schedule 1 C: Deletion of a page that referred to a page that had previously been withdrawn Schedule 1 D: Deletion of tariff page for a rate schedule no longer in effect Schedule 1 E: Renumbering of page due to changes elsewhere Schedule 1 F: Deletion of a page that referred to a page that had previously been withdrawn Schedule 1 G: Deletion of tariff page for a rate schedule no longer in effect Schedule 1 H: Deletion of tariff page for a rate schedule no longer in effect Schedule 2: Deletion of a page that referred to a page that had previously been withdrawn Schedule 3: Renumbering of page and proposed changes to tariff rates Schedule 4: Renumbering of page and proposed changes to tariff rates Schedule 4A: Deletion of tariff page for a rate schedule no longer in effect Schedule 5: Deletion of a page that referred to a page that had previously been withdrawn Schedule 6: Renumbering of page and proposed changes to tariff rates Schedule 7: Consolidation of all Miscellaneous Service fees into one schedule in the tariff. In the existing tariff a number of miscellaneous charges were specified within a number of Rules and Regulations. To improve the clarity of the tariff and to facilitate simpler updates in the future, the numeric fees in the Rules and Regulations were eliminated and moved to Schedule 5. Schedule 8: Renumbering of page and proposed changes to tariff rates Rules and Regulations 1: Rewording of tariff to enhance clarity and readability Rules and Regulations 4: Deletion of numeric miscellaneous charge in Rule and note of move of numeric charge to Schedule 5 Exhibit No. Case No. UWI,O4, F. Gradilone, United Water Schedule 2, Page 17 of 19 Rules and Regulations 8: Correction in references to Rules and Regulations in the City of Boise Municipal and the Uniform Plumbing Codes Rules and Regulations 9: Rewording of tariff to enhance clarity and readability Rules and Regulations 10: Deletion of numeric miscellaneous charge in Rule and note of move of numeric charge to Schedule 5 Rules and Regulations 15: Change in wording to clarify or reflect changes made elsewhere in the tariff Rules and Regulations 17: Change in wording to clarify or reflect changes made elsewhere in the tariff Rules and Regulations 28: Deletion of numeric miscellaneous charge in Rule and note of move of numeric charge to Schedule 5 Rules and Regulations 30: Correction in reference tolPUC Rules and Regulations as revised Rules and Regulations 32: Rewording of tariff to enhance clarity and readability Rules and Regulations 33: Rewording of tariff to enhance clarity and readability Rules and Regulations 35: Correction in reference to IPUC Rules and Regulations as revised Rules and Regulations 39: Deletion of numeric miscellaneous charge in Rule and note of move of numeric charge to Schedule 5 Rules and Regulations 42B: Deletion of numeric miscellaneous charge in Rule and note of move of numeric charge to Schedule 5 Rules and Regulations 42E: Rewording of tariff to enhance clarity and readability Rules and Regulations 43: Change in wording to clarify or reflect changes made elsewhere in the tariff Rules and Regulations 45: Rewording of tariff to enhance clarity and readability Rules and Regulations 46: Correction to office hours to reflect change in opening time, from 9:00 AM to 8:00 Rules and Regulations 49: Correction company name form Boise Water Corporation to United Water Idaho Rules and Regulations 61: Increase in the number of days developers have to adjust any difference between the amount deposited and the actual cost of relocating facilities, from ten to thirty days. Exhibit No. Case No. UWI,O4, F. Gradilone, United Water Schedule 2, Page 18 of 19 Rules and Regulations 63: Rewording of tariff to enhance clarity and readability Rules and Regulations 73: Change in internal reference to reflect renumbering of the tariff Exhibit No. Case No. UWI,O4,O4 F. Gradilone, United Water Schedule 2, Page 19 of 19 UNITED WATER IDAHO ndex of Use by Month BOLD SEASONAL MONTHS Residential Commerial August 188%166% September 211%157% October 159%162% November 114%110% December 60%83% January 45%58% February 39%61% March 46%59% April 46%68% May 49%58% June 89%99% July 155%120% Public 237% 228% 231% 124% 58% 14% 34% 74% 180% 250% 200% 150% 100% 50% Base Months 0 0~ 0 -r 0 ')-:f ~ ~ ~~ ~((;- ~ -t ~~ ~v 200% " 150% 100%Base Months 50% 0 ~~ o-r ~ .j- ~ ~ ((;- 0 ~ os (( ~~ ~ 250% - 200% 150% 100%Base Months50% 0 ~~ o-r ~ .j- ~ ~ ~ ((;- .f ~0 ~ os (( ~ ~ ~ Exhibit 6 F. Gradilone Schedule 3 PaQe 1 of 25 UN I T E D WA T E R I D A H O Re s i d e n t i a l C u s t o m e r S e c t o r A d j u s t m e n t s Au g u s t Cu s t o m e r Ch a n g e i n to J u l y Co u n t Cu s t o m e r s 86 - 99 9 67 4 87 - 37 , 7 1 9 79 1 88 - 17 1 (1 0 8 ) -c : : : M u l t i - fa m i l y t o C o m m e r c i a l 89 - 77 5 39 7 90 - 20 3 34 2 91 - 55 7 50 6 92 - 01 6 34 7 93 - 51 4 67 7 94 - 08 8 32 2 95 - 16 7 09 6 96 - 52 0 80 1 -c : : : Ad d i t i o n o f G a r d e n C i t y + 97 - 22 1 05 5 98 - 76 0 50 5 -c : : : A d d i t i o n o f S o u t h Co u n t y + 99 - 78 2 10 0 00 - 23 3 79 4 01 - 89 5 51 9 02 - 17 2 71 2 03 - 21 0 84 1 "'U C/) Q. ) . :o n CD : : J ' " ., m '" C D Q . ) Co a . : : J ' " oc : = .. . . . . - 0 - . I\ ) : J - Ot V J C D 0 ' ) 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 1 , 00 0 Q) " . . . : - n :0 v , CD g. ~ m wC D Q ) x r:: :a. 9 : ~ -" ' - I\ . ) C D g ; : ; : O1 W C D 0 ) UN I T E D WA T E R I D A H O Ch a n g e i n C u s t o m e r & W a t e r Us e Nu m b e r & C h a n g e i n C u s t o m e r s -- - Ad d i t i o n o f S o u t h C o u n t y 87 - 8 8- 8 9 - 90 - 9 1 - 92 - 9 3 - 94 - 95 - 9 6 - 97 - 9 8 - 99 - 0 0 - 01 - 0 2 - 03 - 88 89 90 91 92 93 94 95 96 97 98 99 00 02 03 1- Cu s t o m e r s A d d e d Nu m b e r o f C u s t o m e r s Ch a n g e i n C u s t o m e r s v s U s e p e r C u s t o m e r 87 - 88 - 8 9 - 90 - 91 - 92 - 93 - 94 - 95 - 96 - 97 - 98 - 99 - 00 - 01 - 02 - 03 - -g ' g- - g( r 9 1 ~ - !r : r - - g~ ~ - 96 9 ( - ' - ~ 98 9 9 --o c r - - o - 1 0 2 Cu s t o m e r s A d d e d Nu m b e r o f C u s t o m e r s UN I T E D W A T E R I D A H O SU M M A R Y R E G R E S S I O N A N A L Y S I S O U T P U T R E S I D E N T I A L S E C T O R "'UIl ) c n ~ :0 ( ' ) CD : T ~C D i U x Q. c . : T c: : -' - ' .. . . . - - I\ . ) CD g ;:: : : ; : CJ 1 C J , ) C D WI N T E R P E R I O D R E G R E S S I O N A N A L Y S I S 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 18 . 4 6 % R S q u a r e 3.4 1 % Ad j u s t e d R S q u a r e 65 % St a n d a r d E r r o r 1. 4 7 Ob s e r v a t i o n s 11 3 AN O V A Sic m i f i c a n c e F Re g r e s s i o n 8. 4 4 E + 0 0 22 E + 0 0 Re s i d u a l 11 0 39 E + 0 2 17 E + 0 0 To t a l 11 2 2. 4 7 E + 0 2 Va r i a b l e s 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 % In t e r c e p t 8. 4 2 16 . Ti m e Ne w s y s t e m s a d d e d 0. 4 3 1. 4 2 SU M M E R P E R I O D R E G R E S S I O N A N A L Y S I S 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 93 . 16 % R S q u a r e 86 . 79 % Ad j u s t e d R S q u a r e 85 . 75 % St a n d a r d E r r o r 12 0 40 6 Ob s e r v a t i o n s 11 0 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 62 E + 1 2 20 E + 1 2 Re s i d u a l 10 1 1. 4 6 E + 1 2 1. 4 5 E + 1 0 To t a l 10 9 11 E + 1 3 Va r i a b l e s 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 % In t e r c e p t 46 1 38 8 32 7 34 0 1.4 1 11 0 74 3 18 7 96 6 Cu s t o m e r s Te m p e r a t u r e 67 6 23 3 31 1 04 0 Ra i n f a l l 15 3 53 3 39 3 21 3 82 5 24 2 Ju n e 13 3 95 5 66 9 25 4 30 7 60 4 Ju l y 51 4 65 0 0. 4 8 12 5 18 0 26 6 20 8 Au g u s t 15 1 35 4 12 7 72 8 10 2 02 4 40 4 73 3 Se p t e m b e r 28 1 72 3 12 2 93 3 85 7 52 5 58 8 Oc t o b e r 76 7 52 2 96 8 25 2 50 1 UNITED WATER IDHAO SIMULATION OF ROTATING A DATASET TIME ACTUAL ROTATIONAL ROTATED PERIOD DATA SET FACTOR DATA SET 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 10. 20. ROTATED DA ASET 15. ORIGINAL DA ASET 10. y = 0.0009x + 9.992 2 = 0.0159 1 2 3 4 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 - 5 . 0 j""~W_---'-'-'-----' Exhibit 6 F. Gradilone Schedule 3 Paqe 5 of 25 "'U C/ ) ro :0 ( " ) G ) CD : : : r - . CD r o x a. a . : : : r c: = _ . ... . . . - 0 '" C D : J ; : : : : ; : CJ 1 ( . o J C D 0 ) 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 W a t e r C o n s u m p t i o n An a l y s i s AN N U A L TO T A L W A T E R U S E WI N T E R P E R I O D W A T E R U S E SU M M E R P E R I O D W A T E R U S E PE R I O D S CU S T O M E R S AC T U A L RE G R E S S I O N AC T U A L RE G R E S S I O N TO T A L Au g u s t An n u a l Av e r a g e Us e p e r An n u a l Us e p e r An n u a l Us e p e r An n u a l Us e p e r An n u a l Us e p e r NO R M A L I Z E D Us e p e r to J u l y Co n s u m p t i o n Nu m b e r Cu s t o m e r Co n s u m p t i o n Cu s t o m e r Co n s u m p t i o n Ac t u a l v s E s t i m a t e Cu s t o m e r Co n s u m p t i o n Cu s t o m e r Co n s u m p t i o n Ac t u a l v s E s t i m a t e Cu s t o m e r CO N S U M P T I O N Ac t u a l v s E s t i m a t e Cu s t o m e r (K G ) Cu s t o m e r s (K G / Y R ) (K G ) (K G / Y R ) (K G ) Am o u n t Pe r c e n t (K G / Y R ) (K G ) (K G / Y R ) (K G ) Am o u n t Pe r c e n t (K G / Y R ) (K G ) Am o u n t Pe r c e n t (K G / Y R ) 86 - 81 2 68 8 99 9 18 4 58 7 57 5 56 7 , 00 8 20 , 56 7 1. 3 0 % 22 5 , 11 3 14 1 35 6 , 54 9 13 1 43 6 52 % 14 5 92 3 , 55 8 11 0 87 0 1.6 3 % 18 7 87 - 16 3 , 46 5 71 9 19 0 65 6 , 69 2 59 7 86 7 58 , 82 5 55 % 50 6 , 77 3 14 6 41 0 , 13 7 96 , 63 6 75 % 14 3 00 8 , 00 4 15 5 , 4 6 1 17 % 18 5 88 - 10 5 , 59 9 38 , 17 1 18 6 61 8 , 61 0 59 8 , 59 7 20 , 01 3 1. 2 4 % 48 6 , 98 9 14 3 44 8 , 49 6 49 3 70 % 14 2 04 7 , 09 4 58 , 50 5 -0 . 82 % 18 4 89 - 9 0 48 9 , 16 9 38 , 77 5 16 7 64 8 , 28 0 63 1 08 3 19 7 1. 0 4 % 84 0 , 88 9 12 5 48 1 , 52 1 -6 4 0 , 63 2 13 . 23 % 14 2 11 2 60 3 62 3 , 43 4 61 % 18 4 90 - 9 1 57 1 45 4 20 3 16 3 62 4 , 88 3 68 8 , 78 1 -6 3 , 89 8 93 % 94 6 , 57 1 12 4 58 6 , 99 3 -6 4 0 , 42 2 12 . 95 % 13 9 27 5 , 77 4 70 4 32 0 10 . 72 % 18 1 91 - 9 2 81 1 17 1 55 7 18 8 91 9 , 86 2 74 6 , 20 0 17 3 66 2 05 % 89 1 , 30 9 14 2 68 9 , 25 9 20 2 05 0 43 % 13 7 43 5 , 45 9 37 5 , 71 2 -4 . 81 % 17 9 92 - 9 3 96 0 90 3 01 6 16 2 68 1 , 29 8 80 3 , 33 8 12 2 , 04 0 26 % 27 9 , 60 5 12 3 79 9 , 46 6 51 9 , 86 1 85 % 13 5 60 2 80 4 64 1 90 1 22 % 17 7 93 - 9 4 52 8 , 30 3 51 4 16 9 98 8 , 11 2 86 0 19 7 12 7 , 91 5 6.4 3 % 54 0 , 19 1 12 5 90 9 , 50 9 36 9 31 8 -6 . 67 % 13 3 76 9 , 70 6 24 1 40 3 21 % 17 5 94 - 9 5 84 9 , 80 7 46 , 08 8 17 0 78 2 , 00 5 90 7 01 3 12 5 , 00 8 02 % 06 7 80 2 13 2 03 0 , 62 3 37 , 17 9 61 % 13 1 93 7 63 7 83 0 1.1 2 % 17 3 95 - 45 9 , 09 0 47 , 16 7 15 8 87 0 , 98 0 94 7 75 0 77 0 -4 . 10 % 58 8 , 11 0 11 9 11 4 , 50 5 52 6 39 5 9.4 2 % 13 0 06 2 25 5 60 3 , 16 5 09 % 17 1 96 - 9 7 13 0 , 55 1 48 , 52 0 16 8 94 9 , 32 5 99 4 , 61 1 -4 5 , 28 6 32 % 18 1 , 22 6 12 8 21 4 22 9 33 , 00 3 -0 . 53 % 12 8 20 8 , 84 0 78 , 28 9 96 % 17 0 97 - 57 3 09 6 50 , 22 1 15 1 02 4 , 36 7 06 7 , 98 3 -4 3 , 61 6 15 % 54 8 , 72 9 11 1 34 1 00 4 79 2 , 27 5 14 . 28 % 12 7 40 8 98 7 83 5 , 89 1 11 . 0 4 % 16 8 98 - 83 2 , 92 4 53 , 76 0 16 4 24 1 , 46 6 12 8 , 60 7 11 2 85 9 04 % 59 1 . 4 5 8 12 5 53 4 , 47 9 56 , 97 9 86 % 12 5 66 3 08 6 16 9 , 83 8 92 % 16 4 99 - 0 0 86 0 , 85 4 78 2 17 1 42 5 , 08 8 22 5 , 51 9 19 9 , 56 9 23 % 43 5 , 76 6 13 0 87 9 , 08 6 55 6 , 68 0 7. 4 9 % 12 0 10 4 60 6 75 6 , 24 9 67 % 15 9 00 - 0 1 33 3 , 01 3 60 , 23 3 15 5 17 1 , 00 8 28 2 24 9 11 1 , 24 1 12 % 16 2 , 00 5 11 9 08 7 , 10 1 90 4 05 % 11 8 36 9 , 35 0 33 7 39 % 15 6 01 - 67 9 , 80 7 61 , 89 5 15 6 31 6 , 82 1 34 0 , 19 0 23 , 36 9 1.0 1 % 36 2 , 98 6 11 9 21 2 , 89 9 15 0 , 08 7 04 % 11 7 55 3 , 08 9 12 6 , 7 1 8 31 % 15 5 02 - 35 8 , 55 5 63 , 17 2 14 8 24 0 , 70 2 40 3 , 31 1 16 2 60 9 26 % 11 7 , 85 3 11 3 31 5 , 70 4 19 7 , 85 1 78 % 11 6 71 9 , 01 5 36 0 , 46 0 85 % 15 4 03 - 0 4 10 , 08 3 , 85 7 65 , 21 0 15 5 60 7 64 3 47 9 , 43 7 12 8 , 20 6 92 % 47 6 , 21 4 11 5 45 9 , 49 8 16 , 71 6 22 % 11 5 93 8 , 93 5 14 4 92 2 1.4 4 % 15 3 Av e r a g e 03 3 , 57 3 96 4 15 1 95 9 , 43 0 72 0 . 24 % 06 9 , 42 2 12 7 21 5 , 05 9 14 5 , 63 7 2.4 0 % 17 4 , 48 9 14 0 , 91 6 1.7 5 % ADJUSTMENT FOR WEATHER & USE PATTERN CHANGES ACTUAL NORMALIZED NORMALIZING TARRIFF REVENUE CONSUMPTION CONSUMPTION ADJUSTMENT RATE ADJUSTMENT WINTER 607 643 479 437 (128 206)$ 0.9825 ($ 125 962) SUMMER 476 214 459 498 (16 716)$ 1.2281 ($ 20 529) TOTAL 083 857 938 935 (144 922)($ 146,491) ADJUSTMENT FOR GROWTH DURING TEST YEAR TOTAL BASE ALTERNATE CUSTOMERS CUSTOMERS SUPPLY TOTAL NEW CUST ADDED 841 25%75% 1/2 YEAR CONVENTION 921 230 690 USE PER CUST (Avg 92-93 to 96-97)165 118 (Exh) TOTAL USE 062 742 119 804 WINTER SUMMER PERIOD PERIOD UWID BASE S/W SHARE 34.29%65.71% UWID BASE USE 052 010 AL TERNA TE S/W SHARE 41.84%58.16% AL TERNA TE USE 201 541 (Ex h) TOTAL USE 253 551 T ARRIF RATES $ 0.9825 $ 1.2281 REVENUE $ 46 426 $ 89 099 $ 135,525 TOTAL FIXED CHARGES $ 83,014 TOTAL ADJUSTMENT $ 218 539 ADJUSTMENT FOR GROWTH THROUGH MAY 2005 TOTAL BASE AL TERNA TE CUSTOMERS CUSTOMERS SUPPLY NEW CUST ADDED (Aug-May)500 25%75% CUSTOMER BY TYPE 375 125 USE PER CUST 165 118 TOTAL USE 023 133 203 WINTER SUMMER PERIOD PERIOD UWID BASE S/W SHARE 34.29%65.71% UWID BASE USE 268 755 AL TERNA TE S/W SHARE 41.84%58.16% AL TE RNA TE USE 733 77,470 TOTAL USE 001 118 225 T ARRIF RATES $ 0.9825 $ 1.2281 REVENUE 653 145 192 $ 220 845 FIXED CHARGES $ 135 275 TOTAL ADJUSTMENT $ 356 120 UNITED WATER IDAHO Residential Customer Sector Adjustments Exhibit 6 F. Gradilone Schedule 3 Page 7 of 25 UN I T E D WA T E R I D A H O Wa t e r U s e b y Re s i d e n t i a l C u s t o m e r s i n A l t e r n a t e I r r i g a t i o n A r e a s Re d w o o d C r e e k Ho b b l e C r e e k Br i s t o l H e i g h t s Ro c k H a m p t o n Su r p r i s e V a l l e y TO T A L S SE A S O N A L D I S T SU M M US E P E R WI N T Cu s t o m e r Cu s t o m e r Cu s t o m e r Cu s t o m e r Cu s t o m e r Cu s t o m e r CU S T O M E R Co u n t Co n s Co u n t Co n s Co u n t Co n s Co u n t Co n s Co u n t Co n s Co u n t Co n s Wi n t e r Su m m e r Oc t - 09 6 44 8 05 6 37 5 13 , 31 0 89 8 46 2 De e - 60 5 47 2 13 3 37 6 94 8 92 7 68 6 Ja n - 32 0 48 5 50 2 37 6 94 8 94 1 77 0 Ma r - 32 0 48 9 54 0 37 5 72 2 92 5 44 1 01 4 48 7 52 1 Ma y - 29 9 50 2 62 8 37 5 40 0 10 2 99 1 44 4 99 0 52 0 28 , 30 8 Ju l - 10 3 38 1 50 4 10 . 72 5 37 5 13 , 72 6 12 2 68 7 44 4 69 3 54 8 21 2 97 7 98 2 11 5 Se p - 10 9 89 6 50 8 12 , 33 0 37 5 18 , 29 3 12 6 76 3 44 4 99 8 56 2 42 , 28 0 Ja n - 11 0 91 3 50 6 19 6 37 4 81 5 15 7 20 8 44 5 12 5 59 2 25 7 No v - 11 1 72 8 50 8 10 , 4 2 5 37 4 81 5 15 7 20 8 44 5 12 5 59 5 30 1 Ma r - 11 5 76 1 50 7 17 9 37 5 50 2 20 0 03 7 44 6 68 1 64 3 16 0 Ma y - 11 9 28 4 50 8 10 , 32 9 37 7 13 , 56 0 20 6 98 7 44 6 67 3 65 6 83 3 Ju l - 12 8 18 1 50 8 11 , 59 1 37 7 14 3 2 9 21 5 26 0 43 9 22 6 66 7 40 , 58 7 71 8 11 7 70 0 13 1 Se p - 12 3 38 9 44 6 28 5 35 3 56 5 21 3 17 7 44 1 12 8 57 6 35 , 54 4 No v - 13 3 76 4 44 6 06 9 35 1 14 5 21 8 20 7 44 4 65 4 59 2 83 9 Ja n - 14 1 39 1 50 5 46 5 35 1 14 5 21 8 20 7 44 4 65 4 65 9 86 2 Ma r - 14 3 22 4 50 7 24 4 37 4 64 0 22 4 2, 4 7 1 44 5 5, 4 1 9 69 3 99 8 Ma y - 15 0 42 5 50 4 76 7 37 4 76 0 21 6 35 5 44 6 02 9 69 0 33 6 Ju l - 15 4 34 7 52 2 62 8 37 1 83 4 22 5 23 3 44 5 83 3 71 7 87 5 69 9 10 6 , 75 5 11 3 Se p - 15 9 65 4 52 6 37 1 34 4 10 , 85 9 22 4 08 4 46 8 19 7 72 1 16 5 No v - 16 5 36 0 53 3 61 7 37 3 16 9 22 8 16 3 46 7 87 0 76 6 17 9 Ja n - 17 5 86 4 53 4 73 0 37 3 16 9 22 8 16 3 46 7 87 0 77 7 79 6 Ma r - 18 4 93 5 53 7 7, 4 6 1 37 7 58 7 25 7 77 6 46 5 20 5 82 0 96 4 Ma y - 19 4 84 9 54 0 50 0 37 2 60 2 27 4 42 9 46 6 39 6 84 6 77 6 Ju l - 19 5 24 7 53 7 10 , 39 4 37 3 10 3 27 7 94 8 46 1 68 9 84 3 43 , 38 1 93 9 11 8 , 32 2 11 5 TO T A L B Y S E A S O N 31 1 33 3 43 2 , 15 9 11 8 DI S T R I B U T I O N B Y S E A S O N 41 . 84 % 58 . 16 % "' U "T I en CD g . ~ m (X ) ~ ~ ~ 0 c = - . ... . . - 0 '" C D : J ; : : ; : 01 c . J CD 0 ) UNITED WATER IDAHO BillS RENDERED & FIXED SERVICE CHARGES RESIDENTIAL COMMERCIAL PUBLIC FIXED SERVICE CHARGES Bill IN DlSTRI-Bill IN DlSTRI-Bill IN DlSTRI- TEST YEAR BUTION TEST YEAR BUTION TEST YEAR BUTION 5/8"540 20.29%919 23%70% 3/4"273 960 70.77%332 26.32%10.65% 33,540 66%113 30.12%152 28.63% 1/2"679 18%796 18.77%105 19.86% 384 10%885 16.83%202 38.06% 00%593 27%10% 00%201 43%00% 00%04%00% 00%01%00% TOTAL 387,110 46,863 531 FIXED SERVICE CHARGES FOR CUSTOMERS ADDED DURING YEAR New services in test year 841 130 1/2 year convention 921 Added bills rendered 523 390 BILLS FIXED BillS FIXED BILLS FIXED SIZE RATE RENDERED REVENUE RENDERED REVENUE RENDERED REVENUE 5/8"$ 14.121 $ 16326 $ 354 $ 0 3/4"$ 14.909 949 103 1,495 $ 19.479 183 117 254 11/2"$ 31.301 273 $ 44.246 945 $ 82.407 $ 131.219 $ 252. $ 381. Total 523 $ 83,014 390 $ 10 004 $ 0 TOTAL ANNUALIZED BILLS RENDERED BILLS BillS BillS SIZE RENDERED RENDERED RENDERED 5/8"79,660 943 3/4"277 869 435 018 231 152 1/2"689 869 105 389 951 202 598 202 Total 392 633 253 531 FIXED SERVICE CHARGES FOR CUSTOMERS ADDED THRU 5/05 New services test year + 1 800 130 New services thru 5/05 500 108 Added bills rendered 000 650 BILLS FIXED BILLS FIXED BillS FIXED SIZE RATE RENDERED REVENUE RENDERED REVENUE RENDERED REVENUE 5/8"$ 14.826 605 590 3/4"$ 14.369 802 171 492 $19.780 964 196 756 1/2"$ 31.05 490 122 788 $ 44.401 109 909 $ 82.679 $ 131.28 365 $ 252. $ 381. Total 000 135,275 650 673 TOTAL BILLS RENDERED THRU 5/05 BILLS BillS BILLS SIZE RENDERED RENDERED RENDERED 5/8"486 931 984 944 3/4"284 239 149,752 606 988 34,798 147 426 011 152 1/2"705 791 991 061 105 398 647 060 854 202 606 086 205 585 Total 401 633 47.903 531 Exhibit 6 F. Gradilone Schedule 3 PaQe 9 of 25 UNITED WATER IDAHO Micron Industries Water Sales Period from August to July 86- 87 - 88- 89- 90- 91- 92- 93- 94- 95- 96- 97 - 98- 99- 00 -0 1 01- 02- 03- 04- Water Sales to Micron in 952 140 289 208 444 343 943 265 503 126 869 352 111 661 246 804 451 025 439 347 283 595 180 978 251 647 303 747 204 543 1 21 ,143 68,593 593 Exhibit 6 F. Gradilone Schedule 3 Pa!:je 10 of 25 UN I T E D W A T E R I D A H O SU M M A R Y RE G R E S S I O N A N A L Y S I S O U T P U T CO M M E R C I A L S E C T O R 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 . 76 % R S q u a r e 91 . 69 % Ad j u s t e d R S q u a r e 91 . 30 % St a n d a r d E r r o r 54 9 Ob s e r v a t i o n s 22 2 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 5. 4 9 E + 1 2 5. 4 9 E + 1 1 23 3 Re s i d u a l 21 1 97 E + 1 1 36 E + 0 9 To t a l 22 1 99 E + 1 2 Va r i a b l e 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 % In t e r c e p t 11 8 29 6 59 0 17 8 59 7 99 4 Cu s t o m e r s 16 . Te m p e r a t u r e 91 0 62 6 67 6 14 4 Ra i n f a l l 90 7 21 7 13 3 68 1 Ju n e 12 3 16 5 13 8 38 2 15 6 94 8 Ju l y 15 0 91 3 26 4 10 8 99 7 19 2 82 9 Au g u s t 30 1 , 4 1 1 83 5 12 . 25 2 , 4 5 4 35 0 36 8 Se p t e m b e r 25 9 06 0 52 2 10 . 21 0 72 0 30 7 , 4 0 0 Oc t o b e r 30 6 06 0 38 9 15 . 26 5 86 7 34 6 25 2 No v e m b e r 13 5 90 7 19 5 10 5 95 3 16 5 86 1 De c e m b e r 97 7 56 4 6. 4 5 21 0 10 5 74 5 "" Uro "'T I CJ ) . CD ( " ) G ) -- " : : r .. . , m ... . . CD r o x c. . c . : : r c: =- . ... . . . . - 0 ;:+ CJ 1 W CD 0 ' ) UN I T E D WA T E R I D A H O Co m m e r c i a l W a t e r U s e An a l y s i s "'U en : - n CD ( " ) G ) ... . . . . : : r .. . , m NC D W X o~ 9 : : ! . -= - - I\. ) C D g ;:: : ; : 01 c . v CD Q ) (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 ) No r m a l i z e d Pe r c e n t No r m a l i z e d Pe r c e n t Pe r i o d f r o m Ac t u a l W a t e r U s e Wa t e r U s e w i t h Di f f e r e n c e A c t u a l Di f f e r e n c e A c t u a l Wa t e r U s e w i t h Di f f e r e n c e A c t u a l Di f f e r e n c e A c t u a l Au g u s t t o Ju l y as B o o k e d ( K G I ) Ac t u a l W e a t h e r vs R e g r e s s i o n vs R e g r e s s i o n No r m a l W e a t h e r vs R e g r e s s i o n vs R e g r e s s i o n ( U W I D Bo o k s ) ( R e g E s t ) (( 2 ) - ( 1 ) ) ( ( 3 ) / ( 1 ) ) ( R e g E s t ) ( ( 5 ) - ( 1 ) ) (( 6 ) / ( 1 ) ) 86 - 96 9 , 29 1 93 5 56 8 72 3 14 % 95 0 , 27 0 02 0 64 % 87 - 12 3 87 4 05 4 63 4 24 0 22 % 04 9 98 2 89 2 2. 3 7 % 88 - 28 3 52 7 27 5 93 9 58 7 23 % 33 8 96 9 44 2 69 % 89 - 43 6 , 73 7 68 6 74 7 25 0 01 0 27 % 75 4 72 8 31 7 99 1 25 % 90 - 73 9 13 2 83 5 , 90 4 77 2 59 % 85 5 , 34 1 11 6 20 9 11 % 91 - 06 4 62 4 05 3 23 4 39 0 28 % 95 5 , 95 4 10 8 66 9 67 % 92 - 67 4 86 0 91 6 47 6 24 1 61 6 57 % 05 6 56 7 38 1 70 7 10 . 3 9 % 93 - 97 4 80 8 17 4 54 5 19 9 73 7 03 % 15 6 43 3 18 1 62 6 57 % 94 - 16 3 , 56 1 16 4 68 7 12 6 03 % 23 2 38 8 82 7 65 % 95 - 18 4 05 0 21 4 77 6 72 6 73 % 29 7 13 5 11 3 08 5 70 % 96 - 42 9 97 5 32 4 55 6 10 5 41 9 2. 3 8 % 37 9 81 6 15 9 13 % 97 - 29 2 62 3 42 9 74 8 13 7 12 5 19 % 51 1 08 3 21 8 46 0 09 % 98 - 97 7 94 2 64 2 74 3 33 5 19 9 6. 7 3 % 65 8 , 38 6 31 9 55 6 6. 4 2 % 99 - 04 8 , 04 1 82 1 47 4 22 6 56 8 4. 4 9 % 77 4 08 7 27 3 95 5 5. 4 3 % 00 - 05 2 43 0 83 5 , 90 3 21 6 52 7 29 % 84 1 71 7 21 0 , 7 1 3 17 % 01 - 93 6 49 2 98 1 , 32 6 83 4 91 % 90 9 , 34 7 14 5 55 % 02 - 80 5 97 3 99 4 64 6 18 8 67 3 93 % 97 6 97 8 17 1 00 5 56 % 03 - 07 4 86 1 08 5 18 2 32 1 20 % 04 4 , 60 8 30 , 25 3 60 % Av e r a g e 17 9 60 0 19 0 44 9 10 , 84 9 26 % 20 7 98 8 38 8 68 % UNITED WATER IDAHO Commercial Customer Sector Adjustments ADJUSTMENT FOR WEATHER & USE PATTERN CHANGES USAGE ADJUSTMENT AOUAL USE 074 861 NORMALIZED USE 044 608 ADJUSTMENT 253 SHARE USE BY TARIFF REVENUE OF USE PERIOD RATE ADJUSTMENT WINTER 39.58%973 $ 0.9825 ($ 11 763) SUMMER 60.42%18,280 $ 1.2281 ($ 22 450) TOTAL 253 ($ 34 213) ADJUSTMENT FOR GROWTH DURING TEST YEAR AN N UALIZA TION OF USE NEW CUSTOMERS ADDED 130 1/2 YEAR CONVENTION USE PER CUST 636 ADDED BILLED USE 351 SHARE USE BY TARIFF REVENUE OF USE PERIOD RATE ADJUSTMENT WINTER 39.58%365 9825 16,079 SUMMER 60.42%986 2281 30,685 TOTAL 46,764 TOTAL FIXED CHARGES 10,004 TOTAL ADJUSTMENT 56,768 ADJUSTMENT FOR GROWTH THROUGH MAY 2005 USAGE ADJUSTMENT NEW CUST THRU 5/05 108 USE PER CUST 636 ADDED BILLED USE 918 SHARE USE BY TARIFF REVENUE OF USE PERIOD RATE ADJUSTMENT WINTER 39.58%275 9825 798 SUMMER 60.42%41.643 2281 51 142 TOTAL 940 TOTAL FIXED CHARGES 16,673 TOTAL ADJUSTMENT 613 Exhibit 6 F. Gradilone Schedule 3 PaQe 13 of 25 UN I T E D W A T E R I D A H O Co m m e r c i a l W a t e r U s e p e r C u s t o m e r An a l y s i s ~c n : - n CD ( ' ) G ) -.. . . : J ' " .. . . , m -l : : o o C D I D X c. C . : J ' " 0 C = = - . 00 ' " CD : J ; : ; : 01 ' - " C D 0 ) (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 ) No r m a l i z e d No r m a l i z e d Pe r i o d f r o m Ac t u a l B i l l e d Wa t e r U s e p e r Pe r c e n t Wa t e r U s e p e r Pe r c e n t Au g u s t t o Wa t e r U s e p e r Cu s t o m e r w i t h Di f f e r e n c e A c t u a l D i f f e r e n c e Ac t u a l Cu s t o m e r w i t h Di f f e r e n c e A c t u a l D i f f e r e n c e Ac t u a l Ju l y Cu s t o m e r Ac t u a l W e a t h e r vs R e g r e s s i o n vs R e g r e s s i o n No r m a l W e a t h e r vs R e g r e s s i o n vs R e g r e s s i o n ( K G N R Re g E s t ) (( 2 ) - ( 1 ) ) ( ( 3 ) (1 ) Re g E s t ) (5 ) - ( 1 ) (6 ) (1 ) 86 - 75 7 74 9 14 % 75 3 64 % 87 - 76 6 74 9 22 % 74 7 2. 3 7 % 88 - 70 2 70 0 23 % 71 4 69 % 89 - 63 2 67 8 27 % 69 1 25 % 90 - 66 4 68 2 59 % 68 5 11 % 91 - 70 6 70 4 28 % 68 8 67 % 92 - 62 1 66 2 57 % 68 6 10 . 3 9 % 93 - 63 9 67 2 03 % 66 9 57 % 94 - 64 2 64 2 03 % 65 3 1. 6 5 % 95 - 62 8 63 2 73 % 64 5 70 % 96 - 65 3 63 7 38 % 64 5 13 % 97 - 62 5 64 5 19 % 65 6 09 % 98 - 68 9 64 3 73 % 64 5 6. 4 2 % 99 - 67 9 64 8 4. 4 9 % 64 2 5. 4 3 % 00 - 67 2 64 3 29 % 64 4 17 % 01 - 64 4 65 0 91 % 64 1 55 % 02 - 60 9 63 3 93 % 63 1 56 % 03 - 64 0 64 1 20 % 63 6 60 % D.I :c e n : - n CD ... . . . g. G ) CJ 1 C D ~ X 0 g - e: : : ! . ~C D O 2 : "" :: I " ' " O1 W C D ( ) ) UN I T E D W A T E R I D A H O SU M M A R Y RE G R E S S I O N A N A L Y S I S O U T P U T PU B L I C S E C T O R 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 87 . 09 % R S q u a r e 75 . 85 % Ad j u s t e d R S q u a r e 74 . 59 % St a n d a r d E r r o r 19 1 Ob s e r v a t i o n s 22 3 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 75 E + 0 9 14 E + 0 8 Re s i d u a l 21 1 15 E + 0 9 02 E + 0 7 To t a l 22 2 90 E + 0 9 Va r i b l e s 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 % In t e r c e p t 64 4 34 0 0. 4 8 25 8 97 0 Cu s t o m e r s Te m p e r a t u r e 0. 4 5 14 4 Ra i n f a l l 18 5 47 6 2. 4 9 12 2 24 8 Ma y 21 1 36 4 2, 4 1 1 Ju n e 79 5 59 7 35 3 94 3 Ju l y 08 6 00 1 14 1 03 1 Au g u s t 39 6 31 1 84 2 95 1 Se p t e m b e r 20 7 27 4 72 4 69 0 Oc t o b e r 62 7 87 2 93 7 31 7 No v e m b e r 79 5 31 2 20 9 38 2 De c e m b e r 65 3 91 2 14 6 45 1 UN I T E D W A T E R I D A H O Pu b l i c A u t h o r i t y W a t e r C o n s u m p t i o n An a l y s i s Ac t u a l Ac t u a l Ac t u a l RE G R E S S I O N ES T I M A T E S An n u a l Av e r a g e Us e p e r Us i n g A c t u a l W e a t h e r D a t a Us i n g N o r m a l i z e d W e a t h e r D a t a Co n s u m p t i o n N u m b e r o f Cu s t o m e r Re g r e s s i o n Di f f e r e n c e A c t u a l v s E s t i m a t e Us e p e r Re g r e s s i o n Di f f e r e n c e A c t u a l v s E s t i m a t e Us e p e r (K G ) Cu s t o m e r s (K G ) Es t i m a t e Am o u n t Pe r c e n t Cu s t o m e r Es t i m a t e Am o u n t Pe r c e n t Cu s t o m e r 86 - 11 6 60 , 13 4 1,7 5 1 . 5 90 . 91 % 24 6 11 2 . 19 % 87 - 24 1 83 8 71 6 . 4 33 . 85 % 94 0 89 7 . 3 1. 4 3 % 88 - 24 9 89 6 80 3 . 28 . 07 % 39 6 50 0 . 50 % 89 - 17 3 31 0 76 1 . 4 38 . 77 % 33 2 02 2 . 01 % 90 - 80 5 29 4 37 4 . 25 . 13 % 69 , 32 3 97 0 . 1. 3 8 % 91 - 71 5 85 6 23 8 . 10 5 . 18 % 77 6 08 0 . 5. 4 5 % 92 - 62 1 49 2 17 7 . 4 16 9 . 3 3 % 45 0 95 8 . 20 % 93 - 12 3 76 , 21 0 76 . 20 5 . 71 % 62 0 59 0 . 3.4 0 % 94 - 03 3 10 3 70 , 03 3 00 0 . 25 . 10 % 19 6 16 2 . 52 % 95 - 61 9 63 7 74 8 . 90 . 26 % 68 , 47 6 83 9 . 94 % 96 - 13 7 97 9 84 6 . 52 . 4 5 % 95 1 97 2 . 4 60 % 97 - 03 8 53 4 45 8 . 27 . 65 % 73 , 62 0 08 5 . 4 7.4 2 % 98 - 89 1 10 3 33 4 62 9 . 61 % 53 5 20 1 . 2 36 % 99 - 15 5 31 0 17 9 . 49 . 4 4 % 93 0 38 0 . 4 53 % 00 - 19 4 89 , 30 2 74 . 19 8 . 85 % 26 4 03 7 . 1.1 6 % 01 - 10 3 76 7 11 1 43 3 61 1 . 25 7 . 39 % 68 2 75 1 . 0 89 % 02 - 20 9 12 7 93 , 61 2 36 6 . 92 . 95 % 93 , 52 9 82 . 09 % 03 - 0 4 38 3 12 5 08 6 19 1 . 4 13 . 91 % 88 , 26 4 82 1 . 3 92 % Di f f e r e n c e i n B i l l e d C o n s u m p i t o n : A c t u a l t o N o r m a l i z e d f o r t h e T e s t Y e a r 16 9 C C F "" U :a :n CD g. ~ m O) C D I D X o. 9 : 2 : ... . . . - - CD g ;:: ; : Ol W C D 0 ) UN I T E D W A T E R I D A H O Pr i v a t e F i re P r o t e c t i o n Re v e n u e a t Cu r r e n t Ra t e s Nu m b e r Cu r r e n t Bi M o n t h l y Pr i v a t e F i of S e r v i c e s Mo n t h l y Bi l l s An n u a l Se r v i c e S i z e as o f 7 / 0 4 Ra t e pe r Y e a r Re v e n u e 22 2 $ 1 1 . $ 3 1 51 5 34 8 $ 1 7 . 9 3 $ 7 4 87 6 43 5 $ 4 4 . $ 2 3 2 , 4 4 7 13 0 $ 7 3 . $ 1 1 4 , 1 4 5 10 " $ 1 1 4 . 1 1 $ 1 3 69 3 12 " $ 1 7 0 . $ 1 2 30 7 SU B T O T A L 15 1 Fi r e H y d r a n t s 17 0 $ 7 . 1 6 $ 1 4 60 6 SU B T O T A L S E R V I C E S 32 1 Nu m b e r Cu r r e n t Bi M o n t h l y of S e r v i c e s Mo n t h l y Bi l l s An n u a l Ot h e r as o f 7 / 0 4 Ra t e pe r Y e a r Re v e n u e Ad a C o u n t y H i Q h w a y $ 1 7 9 . $ 2 15 2 SU B T O T A L S E R I C E S TO T A L F I R E S E R V I C E S 32 2 TO T A L $ 4 9 5 74 1 NO T E : * A c c e s s t o h y d r a n t s f o r s t r e e t c l e a n i n g b y A d a C o u n t y D P W BI L L A N A L Y S I S $ 4 9 5 67 5 DI F F E R E N C E $ 6 6 '1 J en : - n CD ( ' ) G ) ... . . . . :: r ., m -. . . j CD r o x a. a . : : r Q, ~ : : ; I' V C D g ;: ; : O'I ( . . . ' ) C D 0 ) Ex h i b i t 6 , S c h e d u l e 3 , P a g e 1 8 o f 2 5 UN I T E D W A T E R I D A H O Pr i v a t e F i r e P r o t e c t i o n R e v e n u e a t Ma y 2 0 0 5 ~( J ) CD ( " ) G ' ) ... . . : : r . . . , CX I & . ~ X c: = ;; r . r: : T CD : : J ; ; : ; : 01 t o ) CD ( I ) Nu m b e r Cu r r e n t Bi M o n t h l y Pr i v a t e F i r e of S e r v i c e s Mo n t h l y Bi l l s An n u a l Se r v i c e S i z e as o f 5 / 0 5 Ra t e pe r Y e a r Re v e n u e 23 4 $ 1 1 . $ 3 3 21 9 36 5 $ 1 7 . $ 7 8 53 3 45 8 $ 4 4 . $ 2 4 4 73 7 13 6 $ 7 3 . $ 1 1 9 , 4 1 3 10 " $ 1 1 4 . $ 1 3 69 3 12 " $ 1 7 0 . $ 1 2 30 7 SU B T O T A L 20 9 Fi r e H y d r a n t s 17 0 $ 7 . $ 1 4 60 6 SU B T O T A L S E R V I C E S 1 , 37 9 Nu m b e r Cu r r e n t Bi M o n t h l y of S e r v i c e s Mo n t h l y Bi l l s An n u a l Ot h e r as o f 5 / 0 5 Ra t e pe r Y e a r Re v e n u e Ad a C o u n t y H i g h w a y 17 9 : 3 2 . . $ 2 15 2 SU B T O T A L S E R I C E S TO T A L F I R E S E R V I C E S 38 0 TO T A L $ 5 1 8 66 1 Re v e n u e i n c r e a s e d u e t o g r o w t h t h r o u g h 5/ 0 5 $ 2 2 92 0 "" U en : - n CD ( ' ) G ) ... . . . .. . , m CD Q ) X a. c . ~ Q, s . = c; : CD g ; : : ; : O1 W C D C ) UN I T E D WA T E R ID A H O Mi s c e l l a n e o u s S e r v i c e C h a r g e s # o f E v e n t s i n Cu r r e n t # o f E v e n t s i n To t a l Ra t e Y e a r Pr o p o s e d To t a l P r o p o s e d TY P E O F C H A R G E Ch a r g e Te s t Y e a r Re v e n u e (3 % I n c ) Ch a r g e Re v e n u e Re c o n n e c t i o n D u r i n g No r m a l Bu s i n e s s H o u r s $ 2 0 . 87 8 $ 1 7 56 0 90 4 $ 2 2 . $ 2 0 , 34 0 Re c o n n e c t i o n b e t w e e n 4: 3 1 p m t o 8 : 0 0 p m $ 3 0 . 37 1 $ 1 1 13 0 27 9 $ 4 0 . $ 1 1 16 0 Re c o n n e c t t i o n b e t w e e n 8: 0 1 pm t o 7 : 5 9 a m $ 3 0 . $ 0 10 3 $ 8 0 . $ 8 , 24 0 Re t u r n e d C h e c k C h a r g e $ 1 5 . 53 6 $ 8 04 1 55 2 $ 2 0 . $ 1 1 04 0 Fi e l d C o l l e c t i o n C h a r g e $ 1 5 . 52 9 $ 7 93 5 54 5 $ 2 0 . $ 1 0 , 90 0 TO T A L 31 4 $ 4 4 66 6 38 3 $ 6 1 68 0 DI F F E R E N C E $ 1 7 01 4 IN C R E A S E D U E T O N E W R A T E D $ 1 5 , 68 5 IN C R E A S E D U E T O G R O W T H $ 1 32 9 "'U :0 en :- n CD ( " ) r\ ) =r ~ J CD Q ) X a. a . = r c: - - - - .. . . . - - r\ ) CD g ;:; : 01 W CD ( J ' ) UN I T E D WA T E R ID A H O Su m m a r y B i l l An a l y s i s a s B i l l e d TO T A L A S BI L L E D 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 To t a l B i l l s To t a l F i x e d Ch a r g e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bil l s R e n d e r e d Fi x e d R e v e n u e Bil l s R e n d e r e d Fi x e d R e v e n u e Re n d e r e d Re v e n u e tl X t U - CH A 11 ( " ' . 1 = ' - Me t e r 5 / 8 " 54 0 $ 1 14 4 18 3 91 9 $ 4 2 52 3 $ 1 3 1 46 8 $ 1 18 6 83 8 Si z e 3 / 4 " 27 3 96 0 98 0 95 6 33 2 17 9 55 6 82 4 28 6 34 9 16 1 33 6 54 0 63 7 33 8 11 3 27 0 62 8 15 2 91 7 80 5 91 0 88 4 11 / 2 " 67 9 08 6 79 6 27 2 91 9 10 5 27 3 58 0 29 7 27 8 38 4 20 5 88 5 35 3 43 6 20 2 06 8 47 1 37 9 71 0 61 8 59 3 86 1 48 3 60 7 96 2 20 1 14 9 20 1 14 9 42 6 42 6 32 0 32 0 Fla t R a t e S e r v i c e 26 9 60 4 26 9 60 4 Su b t o t a l F i x e d C h a r g e s 38 7 11 0 $ 5 81 5 , 99 1 86 3 $ 1 20 0 81 9 53 1 $ 1 6 69 7 43 4 77 3 $ 7 03 3 , 50 7 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 R e v e n u e To t a l B i l l e d U s e To t a l U s e Wa t e r Re v e n u e CO M M O D I T Y C H A R G E S Wi n t e r b i l l e d i n C C F 60 5 50 4 51 6 40 0 71 9 58 3 67 0 55 9 77 3 26 9 35 3 86 0 21 5 22 8 Su m m e r b i l l e d i n C C F 82 5 31 8 78 4 85 6 15 2 21 8 09 2 74 6 42 2 11 4 73 2 07 0 95 8 99 2 33 4 Su b t o t a l U s e C h a r g e s 13 , 43 0 82 2 $ 1 5 , 30 1 25 6 87 1 80 1 $ 7 76 3 30 5 12 2 19 5 $ 1 4 3 00 1 42 4 81 8 $ 2 3 , 20 7 56 2 TO T A L S E C T O R R E V E N $ 2 1 11 7 , 24 7 $ 8 96 4 12 4 $ 1 5 9 , 69 8 $ 3 0 , 24 1 06 9 ~C / ) ~ CD ( " ) ' " " I\ ) :: J ' " !:! , J -.. . CD ! l ) a. a . : : J " " 0 C - . - . .. . . . - - I\) CD g ; : : ; : CJ 1 v . J C D 0 ) UN I T E D WA T E R ID A H O Su m m a r y B i l l An a l y s i s a t Ex i s t i n g R a t e s AL L UW I D RA T E S RE S I DE 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 To t a l B i l l s To t a l F i x e d Ch a r g e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bil l s R e n d e r e d Fi x e d R e 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 . 54 0 14 4 32 1 91 9 $ 4 2 53 0 $ 1 3 1 46 8 $ 1 18 6 98 2 Siz e 3 / 4 " $ 1 4 . 27 3 96 0 99 1 60 4 33 2 17 9 67 7 82 4 28 6 34 9 17 2 10 5 $ 1 9 . 54 0 64 3 62 7 11 3 27 0 83 1 15 2 91 7 80 5 91 7 37 5 11 1 2 " $ 3 1 . 0 5 67 9 08 6 79 6 27 3 11 5 10 5 27 3 58 0 29 7 47 4 $ 4 4 . 38 4 23 3 88 5 35 3 89 8 20 2 06 8 8,4 7 1 38 0 19 9 $ 8 2 . 61 8 59 3 93 1 48 3 60 7 03 2 $ 1 3 1 . 20 1 33 8 20 1 33 8 $ 2 5 2 . 42 6 42 6 $ 3 8 1 . 32 0 32 0 Fl a t R a t e S e r v i c e $ 5 4 . 26 9 60 4 26 9 60 4 Su b t o t a l F i x e d C h a r g e s 38 7 11 0 $ 5 83 3 09 2 86 3 $ 1 20 2 06 5 53 1 $ 1 6 69 7 43 4 77 3 $ 7 05 1 85 4 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 R e v e n u e To t a l B i l l e d U s e To t a l U s e Wa t e r Re v e n u e CO M M O D I T Y C H A R G E S Wi n t e r b i l l e d i n C C F $0 . 98 2 5 60 5 50 4 52 4 90 7 71 9 58 3 67 1 99 1 77 3 26 9 35 3 86 0 22 5 16 8 Su m m e r b i l l e d i n C C F $1 . 22 8 1 82 5 31 8 83 8 37 3 15 2 21 8 09 9 33 9 42 2 11 4 73 2 07 0 95 8 05 2 44 4 Su b t o t a l U s e C h a r g e s 43 0 , 82 2 $ 1 5 36 3 , 28 1 87 1 80 1 $ 7 77 1 33 0 12 2 19 5 $ 1 4 3 00 1 42 4 81 8 $ 2 3 , 27 7 61 1 TO T A L S E C T O R R E V E N $ 2 1 19 6 , 37 3 $ 8 97 3 39 4 $ 1 5 9 69 8 $ 3 0 32 9 , 46 5 Ad j u s t m e n t $ 7 9 12 6 $ 9 , 27 0 $ 0 $ 8 8 , 39 7 Ex h i b i t 6 , S c h e d u l e 3 , P a g e 2 2 o f 2 5 UN I T E D WA T E R ID A H O Su m m a r y Bil l An a l y s i s a t Ex i s t i n g R a t e s TH R U MA Y 2 0 0 5 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 To t a l B i l l s To t a l F i x e d Ch a r g e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bi l l s R e n d e r e d Fi x e d R e 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 . 48 6 $ 1 18 7 25 1 98 4 $ 4 3 47 3 $ 1 3 1 47 9 $ 1 23 0 85 6 Si z e 3 / 4 " $ 1 4 . 28 4 23 9 14 1 35 5 1 2 60 6 18 3 66 4 82 4 29 6 90 1 32 5 84 3 $ 1 9 . 79 8 66 7 77 3 42 6 27 6 84 1 15 2 91 7 37 6 94 7 53 2 11 / 2 " $ 3 1 . 70 5 87 7 99 1 27 9 17 6 10 5 27 3 80 1 30 4 32 6 $ 4 4 . 39 8 88 0 06 0 36 1 75 2 20 2 06 8 66 1 38 8 69 9 $ 8 2 . 64 1 60 6 01 7 48 3 62 0 14 1 $ 1 3 1 . 20 5 92 2 20 5 92 2 $ 2 5 2 . 18 . 52 4 52 4 $ 3 8 1 . 37 1 37 1 Fl a t R a t e S e r v i c e $ 5 4 . 26 9 60 4 26 9 60 4 Su b t o t a l F i x e d C h a r g e s 40 1 63 3 $ 6 05 1 38 1 90 3 $ 1 22 8 74 1 53 1 $ 1 6 , 69 7 45 0 33 6 $ 7 , 29 6 , 82 0 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 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 To t a l B i l l e d U s e To t a l U s e Wa t e r Us e R e v e n u e Re v e n u e CO M M O D I T Y C H A R G E S Wi n t e r b i l l e d i n C C F $0 . 98 2 5 60 1 55 2 52 1 02 5 75 1 25 1 70 3 10 4 03 9 54 8 38 0 84 1 25 1 67 7 Su m m e r b i l l e d i n C C F $1 . 22 8 1 99 9 37 7 05 2 13 5 20 0 56 7 c 15 8 71 7 03 8 11 1 80 3 29 0 98 2 32 2 65 5 Su b t o t a l U s e C h a r g e s 13 , 60 0 92 9 $ 1 5 57 3 16 0 95 1 , 81 8 $ 7 86 1 82 0 11 9 07 6 $ 1 3 9 , 35 1 67 1 , 82 3 $ 2 3 , 57 4 , 33 2 TO T A L S E C T O R R E V E N U E $ 2 1 62 4 54 1 $ 9 09 0 , 56 2 $ 1 5 6 04 9 $ 3 0 , 87 1 15 2 DI F F E R E N C E T E S T Y E A R v s TH R U M A Y 2 0 0 5 RE V E N U E I N T E S T Y E A R $ 2 1 , 19 6 , 37 3 $ 8 97 3 , 39 4 $ 1 5 9 69 8 $ 3 0 , 32 9 46 5 RE V E N U E I N C R E A S E T H R U M A Y 20 0 5 $ 4 2 8 16 8 $1 1 7 16 7 ($ 3 65 0 ) $ 5 4 1 , 68 6 "'t JQ) 'T I D ( J ) . CD o G ) I\ ) :: r ~ I\ ) ! ~ ; c: = : - . r: : : T I\ ) ;: ; : () 1 ( . . ) C D Exhibit 6, Schedule 3, Page 23 of 25 UNITED WATER IDAHO Existing & Final Tariffs METER EXISTING NOMINAL PROPOSED PERCENT SIZE CHARGE CHARGE CHARGE CHANGE METERED SERVICE TARIFFS Fixed Service Charges 5/8"$ 14.19.8647 $ 19.36.31 % 3/4"$ 14.19.8647 $ 19.36.31 % $ 19.26.1636 $ 26.36.32% 1 1/4"$ 31.42.3336 $ 42.36.46% 1 1/2"$ 31.42.3336 $ 42.36.46% $ 44.61.1894 $ 61.36.45% $ 82.112.4669 $ 112.36.39% $ 131.178.9872 $ 179.36.37% $ 252.344.4357 $ 344.36.35% $ 381.519.7281 $ 519.36.35% 10"$ 532.726.4877 $ 726.36.35% Street Sprinkler Rate $ 179.244.3622 $ 244.39 36.36% Flat Rate Service $ 54.74.0190 . $ 74.05 36.40% Commodity Rates (CCF) WINTER PERIOD $0.9825 1 .148837 $1.1487 16.92% SUMMER PERIOD $1.2281 1.436047 $1.4360 16.93% Commodity Rates (KG) WINTER PERIOD $1.3134 535759 $1.5358 16.93% SUMMER PERIOD $1.6418 919698 $1.9197 16.93% PRIVATE FIRE PROTECTION TARIFFS Fixed Service Charges $ 11.14.3735 $ 14.21.47% $ 17.21.7850 $ 21.21.47% $ 44.54.1040 $ 54.1 0 21.49% $ 73.88.9016 $ 88.21 .50% 10"$114.138.6437 $ 138.21.50% 12"$ 170.207.6800 $ 207.21 .50% Private Hydrant $ 7.6994 $ 8.21.51 % Exhibit 6 \i F. Gradilone Schedule 3 Paoe 23 of 25 UN I T E D WA T E R ID A H O Su m m a r y Bi l l An a l y s i s a t Pr o p o s e d Ra t e s TH R U M A Y 20 0 5 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 To t a l B i l l s To t a T F l x e a Ch a r g e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bil l s R e n d e r e d Fi x e d R e v e n u e Bil l s R e n d e r e d Fi x e d R e 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 9 . 48 6 $ 1 61 8 31 3 98 4 $ 5 9 25 8 $ 1 7 9 47 9 $ 1 67 7 74 9 Siz e 3/ 4 " $ 1 9 . 28 4 23 9 64 4 97 7 60 6 25 0 34 8 12 3 29 6 90 1 89 6 44 8 $ 2 6 . 79 8 91 0 31 5 42 6 37 7 39 3 15 2 97 7 37 6 29 1 68 5 11 / 2 " $ 4 2 . 70 5 85 3 99 1 38 0 95 6 10 5 4, 4 6 7 80 1 41 5 27 5 $ 6 1 . 39 8 39 7 06 0 49 3 62 0 20 2 37 3 66 1 53 0 39 1 $ 1 1 2 . 87 4 60 6 21 9 65 9 62 0 75 3 $ 1 7 9 . 20 5 71 3 20 5 71 3 $ 3 4 4 . 16 9 16 9 $ 5 1 9 . 23 3 23 3 Fl a t R a t e S e r v i c e $ 7 4 . 26 9 91 9 26 9 91 9 Su b t o t a l F i x e d C h a r g e s 40 1 , 63 3 $ 8 , 24 8 64 8 47 , 90 3 $ 1 , 67 5 90 9 53 1 $ 2 2 , 77 9 45 0 , 33 6 $ 9 , 94 7 , 33 5 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 R e v e n u e To t a l B i l l e d U s e To t a l U s e Wa t e r Re v e n u e CO M M O D I T Y C H A R G E S Wi n t e r b i l l e d i n C C F $1 . 14 8 7 60 1 55 2 28 5 80 3 75 1 25 1 16 0 36 2 03 9 20 8 38 0 84 1 8,4 7 8 37 3 Su m m e r b i l l e d i n C C F $1 . 43 6 0 99 9 37 7 92 3 10 6 20 0 56 7 03 2 01 4 03 8 13 0 73 0 29 0 98 2 08 5 85 0 Su b t o t a l U s e C h a r g e s 60 0 92 9 $ 1 8 , 20 8 90 8 95 1 , 81 8 $ 9 19 2 37 6 11 9 07 6 $ 1 6 2 93 8 20 , 67 1 , 82 3 $ 2 7 , 56 4 22 3 TO T A L S E C T O R R E V E N U E $ 2 6 45 7 55 6 $ 1 0 , 86 8 28 5 $ 1 8 5 , 71 7 $ 3 7 51 1 55 8 DI F F E R E N C E T E S T Y E A R v s TH R U M A Y 2 0 0 5 RE V E N U E I N T E S T YE A R $ 2 1 62 4 54 1 $ 9 , 09 0 , 56 2 $ 1 5 6 , 04 9 $ 3 0 87 1 15 2 RE V E N U E I N C R E A S E T H R U M A Y 20 0 5 $ 4 , 83 3 01 5 $ 1 77 7 , 72 3 $ 2 9 , 66 8 $ 6 64 0 40 6 ~( J ) CD O G ' ) :: r . . . ~8 . ~ ~ 0 c : : . : - - cr - CD : : J ; : : : ; : O1 ( " ) C D 0 ) UN I T E D W A T E R I D A H O Pr i v a t e F i r e P r o t e c t i o n R e v e n u e a t Fi n a l R a t e s "t J ~( J ) CD g . (j ) CD i i 3 01 0 . C . : : r 0 c : . : - . 0 a - CD : : : I ; : : ; : OI ( " ) C D d ) Nu m b e r Pr o p o s e d Bi M o n t h l y Pr i v a t e F i r e of S e r v i c e s Mo n t h l y Bi l l s An n u a l Se r v i c e S i z e as o f 5 / 0 5 Ra t e pe r Y e a r Re v e n u e 23 4 $ 1 4 . $ 4 0 35 1 36 5 $ 2 1 . $ 9 5 39 6 45 8 $ 5 4 . 1 0 $ 2 9 7 33 4 13 6 $ 8 8 . $ 1 4 5 08 5 10 " $ 1 3 8 . $ 1 6 63 7 12 " $ 2 0 7 . $ 1 4 95 3 SU B T O T A L 20 9 Fi r e H y d r a n t s 17 0 $8 . $ 1 7 , 74 8 " " SU B T O T A L S E R V I C E S 37 9 " " Nu m b e r Pr o p o s e d Bi M o n t h l y of S e r v i c e s Bi M o n t h l y Bi l l s An n u a l Ot h e r as o f 5 / 0 5 Ra t e pe r Y e a r Re v e n u e Ad a C o u n t y H i q h w a y " $ 2 4 4 . $ 2 , 93 3 SU B T O T A L S E R I C E S TO T A L F I R E S E R V I C E S 38 0 TO T A L $ 6 3 0 43 6 Re v e n u e i n c r e a s e d u e t o c h a n g e i n r a t e s $1 1 1 77 5 "U ( J ) : - n (' ) G ) CD ~ ~ ~ .. . . . . C o C o ::J ' " c: = Q, ;:: + ~~ C D (j ) UN I T E D WA T E R ID A H O Su m m a r y Bil l An a l y s i s Ba s e S y s t e m A r e a MA I N SY 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 To t a l B i l l s To t a l F i x e d Ch a r g e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bi l l s R e n d e r e d Fi x e d R e v e n u e Re n d e r e d Re v e n u e tl X t U c. . : H ; \ l l c l - ' - O Me t e r 5 / 8 " $ 1 4 . 52 6 $ 1 14 4 11 7 91 2 $ 4 2 43 5 $ 1 3 1 44 7 $ 1 18 6 68 3 Siz e 3 / 4 " $ 1 4 . 25 8 15 5 76 1 31 5 20 6 17 7 84 7 82 4 27 0 41 8 93 9 98 7 $ 1 9 . 65 1 54 9 80 6 94 8 26 7 66 3 15 2 91 7 75 1 82 0 38 7 11 / 2 " $ 3 1 . 67 3 90 0 70 1 27 0 17 6 10 5 27 3 48 0 29 4 34 9 $ 4 4 . 37 6 88 5 73 0 34 6 92 9 20 2 06 8 30 8 37 2 88 2 $ 8 2 . 61 8 58 0 85 9 48 3 59 4 96 0 $ 1 3 1 . 17 9 47 7 17 9 47 7 $ 2 5 2 . 42 6 42 6 $ 3 8 1 . 32 0 32 0 Fl a t R a t e S e r v i c e $ 5 4 . 26 9 60 4 26 9 60 4 Su b t o t a l F i x e d C h a r g e s 36 6 38 8 $ 5 50 8 24 4 46 , 28 1 $ 1 18 3 13 3 53 1 $ 1 6 69 7 41 3 46 9 $ 6 70 8 07 5 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 R e v e n u e To t a l B i l l e d U s e To t a l 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 Wa t e r CT 1 M M ( I I I I I Y c . . : H . 4I l C I = I i i : Wi n t e r b i l l e d i n T C $1 . 31 3 4 $ 0 27 5 $ 4 30 1 $ 0 27 5 $ 4 30 1 Wi n t e r b i l l e d i n C C F $0 . 98 2 5 31 5 04 2 23 9 52 9 67 4 98 6 62 8 17 4 77 3 26 9 01 8 80 1 89 5 97 2 Su m m e r b i l l e d i n T C $1 . 6 4 1 8 Su m m e r b i l l e d i n C C F $1 . 22 8 1 30 9 01 8 20 4 30 5 09 1 84 9 02 5 20 0 42 2 11 4 73 2 49 4 28 9 34 4 23 6 Su b t o t a l U s e C h a r g e s 62 4 06 0 $ 1 4 44 3 , 83 4 77 0 11 0 $ 7 65 7 67 5 12 2 19 5 $ 1 4 3 00 1 19 , 51 6 36 5 $ 2 2 24 4 51 0 TO T A L S E C T O R R E V E N $ 1 9 95 2 07 8 $ 8 84 0 80 8 $ 1 5 9 69 8 $ 2 8 95 2 58 5 '1 J en ~g . G ) C1 ) C 1 ) I D Ng - 9 - . 2 : Q. r o O g : " ~ - ~~ C 1 ) UN I T E D WA T E R ID A H O Su m m a r y B i l l An a l y s i s S o u t h C o u n t y BI L L E D RE S I DE 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 To t a l B i l l s To t a l F i x e d AS B I L L E D Ch a r g e Bil l s R e n d e r e d Fi x e d R e v e n u e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bi l l s R e n d e r e d Fi x e d R e 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 " 15 1 $ 2 06 3 $ 0 15 7 $ 2 15 1 Si z e 3 / 4 " 86 4 14 7 64 3 12 6 70 9 99 0 14 9 35 2 88 3 41 7 15 9 85 0 04 2 26 7 11 / 2 " 74 3 2, 7 4 3 32 0 15 5 50 7 16 3 82 7 00 1 00 1 67 2 67 2 Su b t o t a l F i x e d C h a r g e s 90 6 $ 2 3 7 44 3 57 6 $ 1 7 57 1 $ 0 16 , 48 2 $ 2 5 5 , 01 4 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 R e v e n u e To t a l B i l l e d U s e To t a l U s e Wa t e r Re v e n u e ('0 , \ , 4 , \ , 4 1 " 1 1 I I I Y CH ; \ I l l : F I o , ; Wi n t e r 1 b i l l e d i n C C F 26 9 $ 7 0 09 8 57 7 89 0 $ 0 84 6 $ 8 2 98 8 Wi n t e r 2 b i l l e d i n C C F 15 7 26 8 $ 1 5 4 51 6 62 8 18 0 18 2 89 6 17 9 69 5 Su m m e r 1 b i l l e d i n C C F 43 0 65 8 $ 4 7 6 00 6 68 3 33 6 48 4 34 1 53 5 34 2 Su m m e r 2 b i l l e d i n C C F 72 2 $ 4 3 86 7 67 7 19 9 39 9 06 6 Su b t o t a l U s e C h a r g e s 70 2 91 7 $ 7 4 4 48 6 10 0 , 56 5 $ 1 0 5 60 5 $ 0 80 3 , 48 2 $ 8 5 0 09 1 I U I A L ~t L I U K ~l : v l : l " j U E $ 9 8 1 92 9 $ 1 2 3 17 6 $ 0 $ 1 10 5 10 5 Cf) - : n (') G ) ", , :: r - , '" ( 1 ) Q) x c. v Q . Q . : : r c: : = 0 ' 0 - 0 - . -( 1 ) :: J ~~ ( 1 ) UN I T E D WA T E R ID A H O Su m m a r y B i l l An a l y s i s S y s t e m 0 9 SY S T E M (W a t e r 0 9 ) RE S I DE 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 To t a l B i l l s To t a l F i x e d Ch a r g e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bil l s R e n d e r e d Fi x e d R e v e n u e Bi l l s R e n d e r e d Fi x e d R e 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 Si z e 3 / 4 " $ 1 4 . 94 2 99 8 94 2 99 8 $ 1 9 . 11 5 11 5 23 0 1/ 2 " $ 3 1 . 18 6 18 6 $ 4 4 . $ 8 2 . $ 1 3 1 . $ 2 5 2 . $ 3 8 1 . 2 0 Su b t o t a l F i x e d C h a r g e s 95 4 $ 7 2 29 9 $ 1 1 5 $ 0 96 0 $ 7 2 41 4 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 R e v e n u e To t a l B i l l e d U s e To t a l U s e Wa t e r Re v e n u e l: L II I ! I Y C H , 4K I . t- . . . Wi n t e r b i l l e d i n T G $1 . 31 3 4 $ 0 $ 0 $ 0 $ 0 Wi n t e r b i l l e d i n C C F $0 . 98 2 5 87 0 87 5 88 4 88 9 Su m m e r b i l l e d i n T G $1 . 64 1 8 Su m m e r b i l l e d i n C C F $1 . 22 8 1 92 0 67 8 92 8 68 8 Su b t o t a l U s e C h a r g e s 10 6 79 0 $ 1 1 6 55 3 $ 2 5 $ 0 10 6 81 3 $ 1 1 6 57 8 TO T A L S E C T O R R E V E N U E $ 1 8 8 85 2 $ 1 4 0 $ 0 $ 1 8 8 99 2 '1 J e n : n ~g . ( j ) (1 ) ( 1 ) ~ ~ ~a . a . : : r c: - . - . (1 ) g ; : ; : ~~ ( 1 ) (j) UN I T E D WA T E R ID A H O Su m m a r y B i l l An a l y s i s a s B i l l e d TO T A L A S BI L L E D RE S I DE 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 To t a l B i l l s To t a l F i x e d Ch a r g e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bi l l s R e n d e r e d Fi x e d R e v e n u e Bil l s R e n d e r e d Fi x e d R e v e n u e Re n d e r e d Re v e n u e t- I X I : U C H ; 1 I l r . I = ~ Me t e r 5 / 8 " 54 0 $ 1 14 4 18 3 91 9 $ 4 2 52 3 $ 1 3 1 46 8 $ 1 18 6 83 8 Siz e 3 / 4 " 27 3 96 0 98 0 95 6 33 2 17 9 55 6 82 4 28 6 34 9 16 1 33 6 54 0 63 7 33 8 11 3 27 0 62 8 15 2 91 7 80 5 91 0 88 4 11 / 2 " 67 9 08 6 8, 7 9 6 27 2 91 9 10 5 27 3 58 0 29 7 27 8 38 4 20 5 88 5 35 3 43 6 20 2 06 8 47 1 37 9 , 7 1 0 61 8 59 3 86 1 48 3 60 7 96 2 20 1 14 9 20 1 14 9 42 6 42 6 32 0 32 0 Fl a t R a t e S e r v i c e 26 9 60 4 26 9 60 4 Su b t o t a l F i x e d C h a r g e s 38 7 11 0 $ 5 81 5 , 99 1 86 3 $ 1 20 0 81 9 53 1 $ 1 6 69 7 43 4 77 3 $ 7 03 3 50 7 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 R e v e n u e To t a l B i l l e d U s e To t a l U s e Wa t e r Re v e n u e CO M M O D I T Y C H A R G E S Wi n t e r b i l l e d i n C C F 60 5 50 4 51 6 40 0 71 9 58 3 67 0 55 9 77 3 26 9 35 3 86 0 21 5 22 8 Su m m e r b i l l e d i n C C F 82 5 31 8 78 4 85 6 15 2 21 8 09 2 74 6 42 2 11 4 , 7 3 2 07 0 95 8 99 2 33 4 Su b t o t a l U s e C h a r g e s 43 0 82 2 $ 1 5 , 30 1 25 6 87 1 80 1 $ 7 , 76 3 , 30 5 12 2 19 5 $ 1 4 3 , 00 1 42 4 81 8 $ 2 3 20 7 56 2 TO T A L S E C T O R R E V E N U E $ 2 1 11 7 24 7 $ 8 96 4 , 12 4 $ 1 5 9 , 69 8 $ 3 0 24 1 06 9 Dean J. Miller McDEVITT & MILLER LLP 420 West Bannock Street O. Box 2564-83701 Boise, ill 83702 Tel: 208.343.7500 Fax: 208,336.6912 ioe (g) mcdevitt-miller .com Attorneys for Applicant BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER 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 - W -04- BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION EXHIBIT 7 TO THE DIRECT TESTIMONY OF FRANK GRADILONE III Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. GENERAL METERED SERVICE Availabili ty: To all metered customers not served under a separate schedule. Customer Charges: Meter Size 5/8" 3/4" 1 " 1-1/4" and 1-1/2" 2" or multiple meters 3" or multiple meters 4" or mul tiple meters 6" or multiple meters 8" or multiple meters 1 0" or mul tiple meters of equivalent of equivalent of equivalent of equivalent of equivalent of equivalent capaci ty capaci ty capaci ty capaci ty capaci ty capaci ty Volume Charge:Winter Rates For all water used per 100 cubic feet (CCF): $0.9825 For all water used per 1 000 gallons $1.3134 Bi-Monthly Per Meter Charge $14. 14. 19. 31. 44. 82 . 131. 252. 381. 532. S umme Ra te s $1.2281 $1.6418 Condi tions of Contract: The customer shall pay the total of the customer charge plus the volume charge. The volume charge 1S based on all metered Water for the billing period. Consumption 1S expressed 1n 100 hundred cubic foot uni ts or one thousand gallon uni ts 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 Per iod: The summer rate will apply to water consumed between May September 30. Meter readings straddling these dates willrated. Issued: September 5, 2000 Effective: 2000 Under authority of I.C. Order No. 28505 Issued by:UNITED WATER IDAHO INC. By: Benj amin Hepler, Vice President 1 and be pro September 5, Exhibit No. Case No. UWI-O4- F. Gradilone, United Water Schedule 1 , Page 1 of 6 Sheet No. 40 Replacing All Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. lE 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 Charges: Based on Uni ted Water Idaho residential consumption for the year ending June 1998 of 208.75 ccf, the average residentialbill, assumlng a ~" meter and 65%/35% summer/winter split, lS $325.74. Billed bi-monthly, equals $54.29. Bi-monthly Charge:$54. Condi tions 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 serVlce pursuant to Subparagraphs (b) or (c) of Paragraph 11 as follows: (b)If Company should determine that a flat rate customer using water In excess of the average residential customer, the Comp~ny will provide a m~ter 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 meteredtariff rates, the customer shall pay the installation and material costs associated wi th the installation of a metersetting. Issued:September 5, 2000 Effecti ve:September 5, 2000 Under Authority of I.C. Order No. 28505 Issued by:UNITED WATER IDAHO INC.Exhibit No. Case No. UWI-O4- F. Gradilone, United Water Schedule 1 , Page 2 of 6By:Benj amin Hepler , Vice President Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. PUBLIC HYDRANTS AND STREET SPRINKLING Availabili ty: To the Ci ty of Boise and Ada County Highway District. Rates: Street Sprinkling Service Flat Charge $179.23/Month Miscellaneous: Bills will be rendered monthly, bi-monthly, or at other intervals upon mutual agreement of the Company and the customer. Hydrants and serVlce pipes from the fi tting on the Company maln to the hydrants are to be installed and maintalned by and at the expense of the Ci ty of Boise or Ada County HighwayDistrict. Issued: September 5, 2000 Effective: September 5, 2000 Under Authority of I.C. Order No. 28505 Issued by:UNITED WATER IDAHO INC. By: Benj amin Hepler, Vice President Exhibit No. Case No. UWI-O4- F. Gradilone, United Water Schedule 1 , Page 3 of 6 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. PRIVATE FIRE SPRINKLER AND SERVICE Availabili ty: To all customers who have sprinkler systems and/or inside hose connections for fire fighting purposes. Rate: For serVlce through a separate line for fire fighting purposes. For 3" serVlce or smaller, For 4" serVlce per monthFor 6" serVlce per month For 8" serVlce per month For 10" service per month For 12" service per month per month $ 11. 17. 44. 73. 114. 170. Miscellaneous: Provided that if the installation of a private fire serVlce shallrequlre an extension of the existing malns of the company, the cost of such extension shall be borne by the customer. All private fire serVlces shall be valves or thermal automatic openlngs. equipped wi sealed gate Meters may be placed on fire serVlces by the utility at any time; however, metered rates will not apply unless lmproper use of water lS disclosed, and if such be the case, usage will be billed to the consumer under Rate Schedule No. Issued: September 5, 2000 2000 Effective:September 5, Under Authority of I.C. Order No. 28505 Issued by:UNITED WATER IDAHO INC. By: Benjamin Hepler, Vice President Exhibit No. Case No. UWI-O4- F. Gradilone, United Water Schedule 1 , Page 4 of 6 Sheet No.1 0 UNITED WATER IDAHO INC. SCHEDULE NO. PRIVATE FIRE HYDRANT SERVICE Availabili ty: To all customers hav1ng private fire hydrant installations. Rate: For fire hydrants installed and ma1ntained by the customer athi s expense: Each fire hydrant, per month $7. Miscellaneous: Service p1pe from the fi tting on the company water main to the fire hydrant 1S to be 1nstalled and ma1ntained by the customer. Issued:September 5, 2000 Effective: September 5, 2000 Under Authority of I.C. Order No. 28505 Issued by:UNITED WATER IDAHO INC. By: Benj amin Hepler, Vice President Exhibit No. Case No. UWI-O4- F. Gradilone, United Water Schedule 1 , Page 5 of 6 Sheet No.1 OA Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. MISCELLANEOUS FEES AND CHARGES 1 .Return Check Charge Application: This charge lS applicable to all customers where the customer check or bank draft lS returned by the Bank for insufficientfunds, closed account, or some other appropriate reason. Ra te: Returned check charge Each Occurrence $15. 2 .Reconnection Charge for Nonpayment Terminations Application: This charge lS applicable to all customers where water has been physically turned off for nonpayment of a delinquent bill. Ra tes : Each Occurrence Reconnection Charge (during normal business hours) Reconnection Charge (other than normal business hours) $20. $30. 3 .FIELD COLLECTION TRIP CHARGE: APPLICATION: This charge lS applicable to all customers who pay outstanding bills for serVlce at the time that Company personnel arrlve at the customers ' premlses to terminate serVlce. Rates: Field Collection Trip Charge Each Occurrence $15. Issued:July 6, 1998 Effecti ve:July 6, 1998 Under Authority of I.C. Order No. 27630 Issued by:UNITED WATER IDAHO INC. By:William C. Linam, Vice President Exhibit No. Case No. UWI-O4- F. Gradilone, United Water Schedule 1 , Page 6 of 6 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. GENERAL METERED SERVICE Availability To all metered customers not served under a separate schedule. Customer Charqes Meter Size 5/8" 3/4" 1 " Bi-Monthly Per Meter Charqe $ 19. 19. 26. 42. 61. 112. 179. 344.4 7 519. 726. 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 Wi nter Rates Summer Rates For all water used per 100 cubic feet (CCF)(1 CCF=748 gallons): For all water used per 1 000 gallons $1.1487 $1.5358 $1 .4360 $1.9197 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 No. Case No. UWI-O4- F. Gradilone, United Water Schedule 2, Page 1 of 8 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 June 1998 of 208.75 ccf, the average .residential bill , assuming a %" meter and 650/0/350/0 summer/winter split, is $444.30. Billed bi-monthly, equals $74.05. Bi-monthly Charqe $74. 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, the customer shall pay the installation and material costs associated with the installation of a meter setting. UN ITED Issued Per IPUC Order No. Effective - Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road, Boise, Idaho Exhibit No. Case No. UWI-O4- F. Gradilone, United Water Schedule 2, Page 2 of 8 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 Sprinklinq Service Flat Charge $244.39/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 No. Case No. UWI-O4- F. Gradilone, United Water Schedule 2, Page 3 of 8 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. PRIVATE FIRE SPRINKLER AND SERVICE Availabilitv 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 $ 14. 21. 54. 88. 138. 207. 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 IPue Order No. Effective - Issued by UNITED WATER IDAHO INC. Gregory P. Wyatt, Vice President 8248 West Victory Road , Boise, Id~ho Exhibit No. Case No. UWI-O4- F. Gradilone, United Water Schedule 2 , Page 4 of 8 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 expense: Each fire hydrant, per month $8. 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 No. Case No. UWI-O4- F. Gradilone, United Water Schedule 2, Page 5 of 8 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. SCHEDULE NO. MISCELLANEOUS FEES AND CHARGES Return Check Charqe Application This charge is applicable to all customers where the customer s check or bank draft is returned by the bank for insufficient funds, closed account, or some other appropriate reason. Rate: Returned check charge Each Occurrence $20. Reconnection Charqe for Nonpavment Terminations Application This charge is applicable to all customers where water has been physically turned off for nonpayment of a delinquent bill. Rates: Each Occurrence Reconnection Charge (during normal business hours: 8:00 AM to 4:30 PM) Reconnection Charge (other than normal business hours) 1: 4:31 PM to 8:00 PM 2: 8:01 PM to 7:59 AM $22. $40. $80. Field Collection Trip CharQ& Application This charge is applicable to all customers who pay outstanding bills for service at the time that Company personnel arrive at the customers' premises to terminate servIce. Rate: Field Collection Trip Charge Each Occurrence $20. 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 No. Case No. UWI-O4- F. Gradilone, United Water Schedule 2, Page 6 of 8 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. MISCELLANEOUS FEES AND CHARGES (cont' Service Connection Chan~:Je for Other Than Normal Business Hours Application This charge is applicable to all customers who request service after regular office hours, weekends or holidays. Rate: Service Charge Each Occurrence $25. Temporary Disconnection at Customer Request Charq~ Application This charge is applicable when the Company is requested by customer to shut off the water at the meter for repairs to customer s plumbing. Rates: Water Disconnection at Customer Request (during normal business hours) Water Disconnection at Customer Request (other than normal business hours) Each Occurence $15. $25. Meter Test at Customer Request Charqe Application This charge is applicable when the customer requests the Company to test the accuracy of a meter in the case of a disputed bill. Rate: Error in registration of 1-1/20/0 or less Each Occurrence $10. 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 No. Case No. UWI-O4- F. Gradilone, United Water Schedule 2 , Page 7 of 8 Sheet No. Replacing all Previous Sheets UNITED WATER IDAHO INC. MISCELLANEOUS FEES AND CHARGES (cont' Meter Rental CharQe for Construction Application This charge is applicable when contractors , builders , or others request temporary service from a fire hydrant. Rate: Temporary Meter Charge Each Occurrence $20. 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 No. Case No. UWI-O4- F. Gradilone, United Water Schedule 2, Page 8 of 8