Loading...
HomeMy WebLinkAbout2005032516th Response of UWI to staff.pdfORIGiNAL ".-. ' r\ L i It, 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 . oe mcdevitt-miller. com 20U5 MAR 24 P11 4: .ft. (! l UEtiC UTILITIES COr"'IHISStON 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-O4- SIXTEENTH RESPONSE OF UWlD TO STAFF'S PRODUCTION REQUESTS COMES NOW United Water Idaho Inc. ("United" , " the Company ) and responds to Request Numbers 139 and 140 of Staffs Fourth Production Requests; Numbers 175, 176, 187 and I &4:1 of Staff s Sixth Production Requests; and Request 198 of Staff s Seventh Requests. Dated this ~l\day of March, 2005. McDEVITT & MILLER LLP \\l ~iQQ---\ Dean J. Miller Attorneys for United Water Idaho Inc. CERTIFICATE OF SERVICE I hereby certify that on the ~ay of March, 2005, I caused to be served, via the method(s) indicated below, true and correct copies ofthe foregoing document, upon: Hand Delivered S. Mail Fax Fed. Express Email Hand Delivered S. Mail Fax Fed. Express Email Hand Delivered S. Mail Fax Fed. Express Email Brad M. Purdy Attorney for the Community Action Partnership Association of Idaho 2019 North 17th Street Boise, Idaho 83702 Fax: 208.384.8511 bm urd hotmail.com Hand Delivered S. Mail Fax Fed. Express Email William M. Eddie Advocates for the West O. Box 1612-83701 1320 West Franklin Street Boise, Idaho 83702 Fax: 208.342.8286 Hand Delivered S. Mail Fax Fed. Express Email Bill Sedivy Idaho Rivers United O. Box 633 Boise, Idaho 83701 Fax: 208.343.9376 iru~idA.horivers.org Sharon Ullman 9627 West Desert Avenue Boise, Idaho 83709 Fax: 362-0843 ~haron u~caQJeone. net Chuck Mickelson Boise City Public Works O. Box 500-83701 150 North Capitol Boulevard Boise, Idaho 83702 Fax: 208.384.7841~ke lson~ci tyo fboise.org Douglas K. Strickling Boise City Attorney s Office O. Box 500-83701 150 North Capitol Boulevard Boise, Idaho 83702 Fax: 208.384.4454 ~ing~cityotboise.org Hand Delivered S. Mail Fax Fed. Express Email Scott L. Campbell Moffatt Thomas 101 South Capitol Blvd., 10th Floor O. Box 829-83701-0829 Boise, Idaho 83702 Fax: 208.385.5384 S1c om .~~ . t:i/i ?~L /' SIXTEENTH RESPONSE OF UWID TO STAFF'S PRODUCTION REQUESTS-2 Hand Delivered S. Mail Fax Fed. Express Email UNITED WATER IDAHO INC. CASE UWI-O4- FOURTH PRODUCTION REQUEST OF THE COMMISSIONST AFF Preparer/RecordholderlSponsoring Witness:Jeremiah Healy Telephone: 208-362-7337 Title: Coordinator of Planning and Rates REQUEST NO. 139: Please provide a detailed breakdown of the total compensation received and allocation to various business units during the test year (August 1, 2003-July 31, 2004) for Greg Wyatt, Jeremiah Healy, Patricia Foss, Scott Rhead and any other individuals with job responsibilities for business units other than United Water Idaho, Inc. regulated operations. Please provide a copy of each individual's job description. RESPONSE NO. 139: Please see the attached schedule. The schedule indicates for the bargaining unit employees (Total UV1) their incentive pay and regular pay. It also indicates to which business unit their time was charged(BU 060: United Water Idaho; BU 308 United Water Operations Idaho; BU 342 Leakguard). Following this, all management direct reports to Greg Wyatt, including Mr. Wyatt, have their time similarly broken out. Business unit 004 is United Water Arkansas. The line entitled "Total UWP" is a breakdown of all non-bargaining employees and includes the management group mentioned above. The bottom line summarizes both pay groups for the test year. Inter-unit allocation of time was taken into consideration in developing Mr. Healy s operating expense adjustment for payroll to United Water Idaho operating and maintenance expense. UNITED WATER IDAHO INC. CASE UWI-04- FOURTH PRODUCTION REQUEST OF THE COMMISSION STAFF Preparer/RecordholderlSponsoring Witness:Jeremiah Healy Telephone: 208-362-7337 Title: Coordinator of Planning and Rates REQUEST NO. 140: Related to the above request, please provide an itemized list of the amount of wages, incentive payments, with details of other compensation that were allocated to affiliates other than United Water Idaho, Inc. for each individual' compensation. RESPONSE NO. 140: The Company believes that the response to Production Request No. 139 is also responsive to this Production Request. UNITED WATER IDAHO INC. CASE UWI-04- SIXTH PRODUCTION REQUEST OF THE COMMISSION STAFF Preparer/RecordholderlSponsoring Witness:Jeremiah Healy Telephone: 208-362-7337 Title: Coordinator of Planning and Rates REQUEST NO. 169: Please list the annual outside laboratory water testing expense for each of the years 1994 through 2004. Please respond in a format similar to page 1 of Mr. Healy s workpapers for Company Adjustment No. 14. RESPONSE NO. 169: Please see the attached schedule that is prepared in the same format as workpapers supporting Company Adjustment No. 14. The Company can provide a fully itemized response from year 2000 through 2004. Outside lab cost were relatively insignificant from 1997 through 2000, with two exceptions. First, the Idaho Public Utilities Commission allowed the Company to amortize over three years in Case UWI-97 -6 testing cost incurred to comply with the EPA Information Collection Rule. Second, in Case UWI-00-, the Company requested and the Commission authorized a six year amortization of synthetic organic chemical testing costs. Prior to July 2000, the Company employed a Certified Chemist who performed many of the required routine water quality tests in house. UNITED WATER IDAHO INC. CASE UWI-04- SIXTH PRODUCTION REQUEST OF THE COMMISSION STAFF Preparer/Recordholder/Sponsoring Witness:Jeremiah Healy Telephone: 208-362-7337 Title: Coordinator of Planning and Rates REQUEST NO. 175: Please provide a detailed narrative justifying the near 500/0 increase requested for corporate and local IT support. Please include in your response all components of the increase and include all contracts or agreements. RESPONSE NO. 175: Mr. Healy s adjustment for information technology and support (Exhibit No. Schedule 1, page 28 of 34) is composed of both a local and corporate component. Local expense is increased from a test year level of $31 ,427 to the expense included in the case, $47,800. Corporate expense is rising from a test year level of $73 667 to $108,340. Combined, the test year level of expense is $105,094 and the level presented in the rate case is $156,140. The increase in expense is $51,046 or 48.570/0. Local information technology maintenance and support is composed of the following responsibilities and functions: . SCADA support and maintenance Oracle: this large, centralized , high performance relational data- base software supports the Company s GIS data-base (mains, valves, hydrants, leaks, etc) as well as the cross connection control, customer complaint and water production data. Local Area Network (LAN) and Wide Area Network 0N AN) Hardware: this includes that ability to transmit and share data between and within the SCADA system , the Victory Road Operations Center, and the Marden and Columbia Water Treatment plants. Printer/Computer break/fix expense . Non-Corporate Supported Software: AutoCad, Hydrological modeling, GIS, etc Corporate information technology maintenance and support is composed of the following responsibilities and functions: Operation of the Help Desk to provide personal computer user su pport Desktop Software support: MS Office suite of programs, anti- virus software, Windows XP, etc PeopleSoft support and maintenance Oracle: PeopleSoft application Wide Area Network hardware and software: Victory Road office to Corporate office: e-mail , internet access, WINS billing system ,etc. Attached is a schedule comparing the test year expense to that requested in the rate case. Drivers of the local increase are as follows: The test year did not include router, printer break/fix or file server support due to timing of invoice payment ($5,700) The Company s new hydraulic modeling software annual maintenance & support is a new expenditure ($7,700) Drivers of the remaining portion of the increase are as follows: In 2003, United Water began a migration of its primary financial system from PeopleSoft 7 to PeopleSoft 8.4. This migration was necessary primarily due to Version 7 no longer being supported by the vendor. In addition to maintaining continued support, the new version provided increased functionality and greater efficiency through improved business processes. The increase in the costs are explained below. Hosting fees: These charges are for hosting the development and production systems (PeopleSoft 8.4), the former production system required for detailed history reporting (PeopleSoft 7.x), and hosting of the PeopleSoft 8.4 budget module. 2005 costs for PeopleSoft 8.4 are based on the number of modules being processed in a production mode. Oracle maintenance: Oracle is the underlying database structure on which to run PeopleSoft. Part of the increase is due to the number of PeopleSoft modules being run on the Oracle database, which required additional capacity. Hardware maintenance: Critical hardware components, such as those on which the Finance system runs require this support to ensure system availability is maximized, consistent with a reasonable level of cost. New, additional hardware was acquired to run PeopleSoft 8., in line with vendor (PeopleSoft) recommendations and consistent with our host outsourcer (Surebridge) recommendations. Therefore, the 2005 charges include the maintenance costs associated with this new hardware. Data communications: Sprint was selected , from among the various communications providers with whom United Waterworks, as the most cost effective solution for internet connectivity, required for the PeopleSoft system. PeopleSoft 8.4 is web based , requiring internet access for its users. Application Support: During 2005, United Water contracted with our hosting vendor to provide application support. The Surebridge personnel are familiar with both United Water s and their own environment. UNITED WATER IDAHO INC. CASE UWI-04- SIXTH PRODUCTION REQUEST OF THE COMMISSION STAFF Preparer/Recordholder/Sponsoring Witness:Jeremiah Healy Telephone: 208-362-7337 Title: Coordinator of Planning and Rates REQUEST NO. 176: Please provide a comparison of actual expenses to budgeted amounts for the months of August through December 2004 for Accounts 921400 (IT Supplies and Expenses) and 923140 (Outside Services-IT). If these accounts no longer exist due to accounting software changes, please show comparative accounts. RESPONSE NO. 176: Please see the attached schedule indicating actual versus budgeted expense for the period August 2004 through December 2004 for the accounts indicated. UNITED WATER IDAHO INC. CASE UWI-04- SIXTH PRODUCTION REQUEST OF THE COMMISSION STAFF Preparer/Recordholder/Sponsoring Witness:Jeremiah Healy Telephone: 208-362-7337 Title: Coordinator of Planning and Rates REQUEST NO. 187: Please provide a schedule of wage expense for 1999 through 2004. Show the proposed test year amounts. At a minimum, the schedules should provide details of wage amounts, incentive payments, pension benefits, health insurance benefits, other benefits, payroll taxes, social security taxes and unemployment taxes by class of employee. RESPONSE NO. 187: In discussions between IPUC Staff Member Donn English and Jeremiah Healy, it was agreed to amend this Production Request. The agreed upon amendment limited the information required to wage amounts and incentive payments by class of employees. Class of employees was defined as bargaining unit and non-bargaining unit. Each of these sub-groups is then further categorized by department. Please see the attached schedules for years 1999, 2000, 2001 2002,2003 and 2004 , as well as the proposed test year amounts. UNITED WATER IDAHO INC. CASE UWI-04- SEVENTH PRODUCTION REQUEST OF THE COMMISSION STAFF Preparer/Recordholder/Sponsoring Witness:Jeremiah Healy Telephone: 208-362-7337 Title: Coordinator of Planning and Rates REQUEST NO. 198: The Company is using the twelve-month period ending July 31 , 2004 as its test year. The Company s case calculates the revenue requirement including adjustments to rate base, revenues and expenses through May 31, 2005. Excluding adjustments specifically associated with the Columbia Water Treatment Plant (CWTP) group of projects, please revise the specific costs/expenses/revenues identified below as was agreed in the meeting between Company representatives and IPUC Staff members that took place on March 4 2005. Please also provide revised exhibits and workpapers that demonstrate the financial effect of the revised adjustments. Please provide all sources and calculations associated with this information in both paper and electronic format (Excel) with all formulas intact. Specifically, please provide the following: With respect to pro forma test year revenue, please use actual customer counts as of December 31,2004 , fully annualized , rather than the projected customer cou nt as of May 31 , 2005 With respect to capital additions, as stated above, please cut off all capital spending as of December 31,2004 except for projects associated with the CWTP. All projects included on Mr. Rhead's Exhibit 8, with the exception of CWTP projects, are to be reflected in rate base at the booked original cost as of December 31 , 2004. With respect to other elements of rate base, such as advances for construction, contributions in aid of construction, accumulated depreciation, utility plant acquisition adjustments, accumulated deferred income taxes, deferred charges and working capital , please make the necessary adjustments that are consistent with December 31 , 2004 year end. With respect to operating expenses, please provide the following: A. Update pro-forma payroll to operating and maintenance expense (Healy Adjustment No.1) to reflect any changes that have occurred since the filing of the case. This would include wage rate and headcount changes. B. Update health care cost (Healy Adjustment No.3) to reflect the results of the Company s November 2004 open enrollment results. C. Update the overhead credit adjustment (Healy Adjustment No.6) to incorporate any payroll or benefit expense changes made as a result of this Production Request. D. Update purchased water expense (Healy Adjustment No. with the latest known and measurable information. E. Update water treatment chemical expense (Healy Adjustment No. 13) using the latest known and measurable pricing information. F. Update transportation expense (Healy Adjustment No. 17) to eliminate the Mechanics wages from the calculation, since these wages are included in the payroll to O&M expense calculation already. G. Healy Adjustments No s. 18 (postage), 19 (customer billing expense) and 20 (lock box and ACH expense) should all be adjusted to reflect the actual customer count as of December , 2004. H. Adjust uncollectible expense (Healy Adjustment No.22) consistent with the change in pro-forma test year revenue. I. Adjust pro-forma depreciation expense (Healy Adjustment No. 39) consistent with the Capital Addition, CIAC and Advance adjustments indicated above. RESPONSE NO. 198: The Company will hereby provide the requested information. However, the provision of this information does not indicate in any way that the Company agrees with Idaho Public Utilities Commission Staff's approach. The Company will continue to update capital additions on a monthly basis, as well as document committed spending. The Company also believes that the position it has taken with respect to pro-forma customer growth to May 31 , 2005 and it's impact on revenue is reasonable, as are all expense adjustments that match this customer projection. Please see the attached schedules that include the information in the manner Staff requested that it be presented: Please note: The Company is making a partial response on March 24 , 2005. The Company addresses revenue with the customer count rolled back to December 31 , 2004. The Company also is addressing certain operating expenses identified above as F, G and H. In the case of perating expense adjustments, each adjustment is presented as originally filed, followed by the revised adjustment. The Company intends to add to this response in the near future. UNITED WATER IDAHO INC. CASE NO. UWI-O4- FOURTH PRODUCTION REQUEST IPUC STAFF TT A C H MEN T RESPONSE TO REQUEST NO. 139 K: \ 2 0 0 4 R a t e C a s e U W I - 04 - 04 \ P r o d u e t i o n R e q u e s t # 4 - 1 1 5 t o 1 4 8 \ ( # 1 3 9 & 1 4 0 w a g e s & b e n e f i t s . xl s ) P i v o t To t a l C o m p e n s a t i o n f o r T e s t Y e a r - A u g . 1 s t 2 0 0 3 - J u l y 3 1 s t 2 0 0 4 - e h e e k d a t e s f r o m 8 / 8 / 2 0 0 3 th r o u g h 7 / 2 3 / 2 0 0 4 Su m o f E a r n A m t Ca t e Q o r v GL U n i t Oe s e r ;: : . . . ;:: . . . ;:: . . . ;:: . . . (i j a. . a. . a. . a. . ;: : . ;:: . a: : a: : (i j (i j (i j (i j ex ) ('t ) ('t ) ;:: . ;: : . -e -e ;:: . . . as .c : .c : a. . en a. . en a. . a: : TO T A L U V 1 40 0 14 , 4 0 0 14 , 4 0 0 33 0 , 62 5 25 , 51 1 15 8 35 7 29 4 37 1 , 69 4 Ca r r , Wi l l i s 68 1 10 , 68 1 68 1 74 , 38 0 29 5 75 , 67 5 86 , 35 6 Ca r y , Ja r m i i a M 86 1 86 1 86 1 43 , 1 1 6 72 6 21 9 50 , 06 2 92 3 Fi c k e s , De n n i s M 60 0 60 0 60 0 84 7 16 8 01 5 73 , 61 5 Fo s s - Ca m e r o n , Pa t r i c i a A 09 9 09 9 09 9 55 2 58 , 93 0 54 5 42 9 67 , 4 5 6 73 , 55 5 He a l y , Je r e m i a h J 97 6 97 6 97 6 33 4 81 0 08 6 14 9 85 , 37 9 95 , 35 5 Rh e a d , H S c o t t 94 3 94 3 94 3 81 2 32 3 13 5 10 1 07 8 Wo o d , H e l e n J 18 5 18 5 18 5 88 9 88 9 50 , 07 4 Wv a t t , Gr e g o r v P 03 4 03 4 19 1 19 1 20 , 22 5 11 , 57 5 12 0 , 04 0 12 0 11 8 13 9 , 85 3 16 0 , 07 8 TO T A L U W P 03 4 03 4 00 0 12 0 , 88 4 13 2 88 4 13 5 , 91 8 18 , 39 5 70 0 , 59 4 33 , 96 9 16 , 4 6 1 76 9 , 4 2 0 1 , 90 5 , 33 8 Gr a n d T o t a l 03 4 03 4 26 , 4 0 0 12 0 , 88 4 14 7 28 4 15 0 , 31 8 39 5 03 1 21 9 59 , 48 0 17 , 62 0 12 6 , 71 4 27 7 , 03 2 UV 1 - B a r g a i n i n g UW P - N o n - Ba r g a i n i n g i n c l u d e s m g m t . UNITED WATER IDAHO INC. CASE NO. UWI-W-O4-04 SIXTH PRODUCTION REQUEST IPUC STAFF ATTACHMENT TO RESPONSE TO REQUEST NO. 169 Un i t e d W a t e r I d a h o Wa t e r T e s t i n g b y O u t s i d e L a b o r a t o r y Hi s t o r y b y T e s t C a t e g o r y 1 9 9 5 t h r o u g h 2 0 0 4 Re s p o n s e t o P r o d u c t i o n R e q u e s t # 16 9 De s c r i p t i o n o f T e s t 20 0 4 20 0 3 20 0 2 20 0 1 20 0 0 19 9 9 19 9 8 19 9 7 Un k n o w n / U n i d e n t i f i e d 07 1 . 38 1 . 35 4 . Ar s e n i c 05 4 . 27 8 . 28 3 . 37 5 . 44 8 . Ba c t e r i a 13 , 36 4 . 13 , 14 2 . 13 , 4 7 4 . 13 , 12 5 . 5, 4 7 8 . Di s i n f e c t i o n B y P r o d u c t s 23 6 . 14 , 4 7 0 . 23 8 . FE / M N 73 7 . 62 3 . 48 9 . 25 2 . 60 8 . GW U D I 54 0 . 08 0 . IO C S 38 6 . 4 0 36 0 . 4 2 36 2 . 31 4 . 89 9 . Le a d / C o p p e r 33 3 . 12 5 . 98 0 . MP A 1, 4 4 0 . 08 0 . 20 0 . Ni t r a t e 95 5 . 20 9 . 74 5 . 73 4 . 4 0 34 8 . Ra d i o n u c l i d e s 02 0 . 14 , 66 9 . 02 2 . 53 6 . 28 8 . sa c ' 66 3 . 88 8 . 81 4 . 12 , 09 6 . 9, 4 6 0 . UC M R 05 0 . va c ' 11 , 39 9 . 29 4 . 31 1 . 25 2 . 73 0 . Ra t e C a s e U W I - 00 - 01 S O C T e s t i n g do n e o n s i x Y e a r I n t e r v a l 62 0 . 99 6 . 99 6 . 35 6 . Ra t e C a s e U W I - 97 - 6; E P A In f o r m a t i o n C o l l e c t i o n R u l e 63 4 . 38 0 . 33 , 33 6 . 16 , 66 8 . To t a l T e s t i n g E x p e n s e 13 2 . 93 , 89 1 . 68 , 93 8 . 58 , 31 6 . 74 , 97 8 . 49 , 40 7 . 21 , 04 9 . 35 4 . UNITED WATER IDAHO INC. CASE NO. UWI-O4- SIXTH PRODUCTION REQUEST IPUC STAFF TT A C H MEN T RESPONSE TO REQUEST NO. 175 ....... III::J ::z::: C)"") ::J"") c( ::-. 0 - ~ ~ g 0 M.c0 N UNenGl::-"" t- - C ::J ::J 0.c "") 0 .-CO"C u~Gl"C S.TI'O.2 ~ .. ~.5:;::o.co coGl GI ~ ... ... III.- III ... GI ::J ::J:)t-enO .:.: QI III .. .. m ! can0: .!!D.m )(- u .- 1/1 ;:: 31 0 LL en .!! . 5 MD.:: ::JGI 1/1 D. g 31 0s::;; LL MCt... GI .5 mU co ! ~ 1::oen.:.: D.N1/1 D.GI ::J c. ::z::: 1::.J 0,....:.: D.N1/1 D.GI ::J D. .... ::z::: ... 1/1 Ui NGI 0U 0 mc - 0) .... ~ en 0 an CQ 0 an an eno)ONCQ~....CQMN~CQancOcQ~"':MNN~cO~cOlIio)M....~~Mo)Oo)~Man........CQ........CQ....CQenCQ,...CQN cD N cD ,..: ..; cD cD ,..: cD Q cD .... r--. 10 "=f: C'1N en 0)r--. M NIO .... .... r--. .... M (0M N . ........,...: r--.r--.r--. .... ..". N 0)"":"=f:~en r--. M.... 0) r--.. :::. N .... r--. "=f: r--. r--. "=f: r--. .... en.... M..".O 0)Menr--.r--.IOr--.ootONNNen r--..... 0) (0 (0r--. o r--. M ........ MIO 0) r--. 010(OMenr--.en(OentOcOocOo..".enlOr--.O)N(0 en. (0. "": 10. 10.... M M N N ON........NIOr--.(O..".IOMr--.r--.r--.cON"":encONen..".MM..".....IOMenM aoen...........: N .."..... ::Een ~ N O/S mt- - OMenenr--.r--...".r--.ao..".MIOenM..".NaolOen..".IOr--.(Oenoen~otON~NNMN"":r--.IO Or--.r--.IO.."...".O) r--.enenenNMoenO)lOoenr--.O)N N ...: ...: ..: N ..: M ' ..: LL 0 ~ N ::E !:!! (O(Or--.r--.aoOOOOOOOaoaoMMONNNNNNN ~~~~~~~~~~~~ 0)0)0)0)10........""""""""""r--.r--.r--.r--.r--.r--.r--. .... .... .... .... ....... ::E MMMMM~~~~~~~ 9 9 9 q q q CiHiHj'I C;IC? 9C)D.'t);:' U C-'2 = = ::-.c-:;::JGI OGlCOGlw-CO::Jc(enOzc"")LL::Ec(::E"") ""),..:,... C'1 r--. ,...,.....; C'! ............ .... iii ..;......". .... .... 0 ao (0 ..". r--. ,..:"":....,.........; ::z::: .."") co "") ::E LL ::-. .. 0D. . ~ ~.... c0 M.c0 N UNenGl ::-. ... - C ::J ::J 0.c "") 0 .-CO"C u~Gl"C !.TI'O.2co .. ~.5~co coGlGI -g ~ E.- ... ... .- III ... GI ::J ::J:Jt-enO ... '1GC .. GI GI ... ... ! c D. 0 D. I!! 1::co 0 ~ ~ m 0 cen .:.: QI III .. .. m ! can0: I.!!D.m )(- u .- 1/1 ;:: GI 0 LLen GI C M -.- D.:: ::Jen-D. c 31 0s::;; LL MCt... GI .5 mU co::E 1::oen.:.: D.Nen D.GI ::J c. ::z::: 1::.J 0,....:.: D.Nen D. GI ::J c. .... ::z::: ... III Ui NGI 0U 0 mc - 000000000000000000000000 ~~~~~~~~~~~~ oooenoooooenoo 0) 0) 0) = 0) en. 0) 0) 0) = 0) 0) 000000000000000000000000000000000000CQ CQ CQ CQ CQ CQ CQ CQ CQ (0 CQ CQ 000000000000000000000000000000000000000000000000. CQ. CQ. CQ. (0. (0. CQ. CQ. CQ. CQ. CQ. CQ .... .... .... .... .... .... .... .... .... .... .... .... 000000000000000000000000 gggggggggggg an 10 an an an an an an an an an an 000000000000000000000000000000000000 .... .... .... .... .... .... .... .... .... .... .... .... MMMMMMMMMMMM 000000000000000000000000000000000000000000000000oooenoooooenooNNN~NNNNN~NN 0000000000000000000000000 0 0 0 0 0 0 0 00 0 0000000000000. o. o. o. o. o. o. o. o. o. o. o .... .... .... .... .... .... .... .... .... .... .... .... ::E en O/S mt- - 000000000000000000000000iii iii iii iii iii iii iii iii iii iii iii iii,... r--. ,... ,... r--. ,... ,... ,... ,... ,... ,... ,.... en. en. en. en. en. en. en~ en. en. en. en .... .... .... .... .... .... .... .... .... .... .... .... LL 0... N.i ::E !:!! 000000000000000000000000000000000000an an an an an an an an an an an an. an. an. an. an. an. an. an. an. an. an. an .... .... .... .... .... .... .... .... .... .... .... ....... ::E GI GI GI GI GI GI GI GI GI GI GI GI ~~~~~~~~~~~~ 000000000000 GI GI GI GI GI GI GI GI GI GI GI GI"Iii "Iii "Iii "Iii "Iii "Iii "Iii "Iii "Iii "Iii "Iii "Iiia:: a:: a:: a:: a:: a:: a:: a:: a:: a:: a:: a:: ....,........ r--. .... r--. .... Un i t e d W a t e r I d a h o Te s t Y e a r E n d e d J u l y 2 0 0 4 Su m m a r y o f A c c o u n t 9 2 1 4 0 0 IT S u p p l i e s & E x p e n s e s S: \ A C C \ J E R R Y \ R a t e s 2 0 0 4 O f f i e i a l \ O P E X \ G e n & A d m i n E x p e n s e s \ ( I T S u p p l i e s & E x p 9 2 1 - 40 0 . xl s I R E V S u m m An n u a l Ha r d w a r e / S o f t w a r e IT s u p p l i e s & S e r v i c e Mo n t h Su p p o r t A g r e e m e n t s & M i s c E x p e n s e s Au g - 54 0 . 22 8 . Se p - Oe t - 88 . No v - De e - 1 , 38 6 . Ja n - Fe b - 52 8 . 72 0 . Ma r - 24 0 . Ap r - Ma y - Ju n - Ju l - 43 4 . 27 , 30 8 . 98 8 . JJ H Au g u s t 5 , 2 0 0 4 Mi s c 13 0 . To t a l I T Su p p l i e s & Ex p e n s e s 76 8 . 11 N o r t e l N e t w o r k s ( a n n u a l H D s u p p o r t ) 88 . 38 6 . Au t o C o n t r o l ( G l o b a l C a r e A g r e e m e n t ) $ 1 0 , 25 6 ; H P A n n u a l 23 , 24 8 . 65 S W S u p p o r t : $ 4 , 4 9 6 & O r a c l e ( a n n u a l s u p p o r t f e e ) $ 6 , 77 6 24 0 . 00 E R I C A n n u a l C o n t r a e t ( M a i n t , pr i m , wi n d o w s , NT - ln t e l ) 69 5 . 13 0 . 42 7 . Un i t e d W a t e r I d a h o Te s t Y e a r E n d e d J u l y 2 0 0 4 - P r o F o r m a Su m m a r y o f A c c o u n t 9 2 1 4 0 0 IT S u p p l i e s & E x p e n s e s S: \ A C C \ J E R R Y \ R a t e s 2 0 0 4 O f f i e i a l \ O P E X \ G e n & A d m i n E x p e n s e s \ ( I T S u p p l i e s & E x p 9 2 1 - 40 0 . xls ) R E V S u m m Mo n t h An n u a l Ha r d w a r e / S o f t w a r e Su p p o r t A g r e e m e n t s Pr i n t e r B r e a k / F i x IT S u p p l i e s & S e r v i c e & M i s c E x p e n s e s Ra t e Y e a r 50 0 . Ra t e Y e a r Ra t e Y e a r Ra t e Y e a r Ra t e Y e a r Ra t e Y e a r 11 , 10 0 . 30 0 . 70 0 . 10 0 . 70 0 . 20 0 . 14 , 00 0 . 90 0 . 20 0 . 40 0 . 80 0 . 1, 4 0 0 . Ra t e Y e a r Ra t e Y e a r Ra t e Y e a r Ra t e Y e a r Ra t e Y e a r Ra t e Y e a r 50 0 . JJ H Ma r c h 2 4 , 2 0 0 5 Mi s c 30 0 . 15 0 . 50 0 . 35 0 . 30 0 . To t a l I T Su p p l i e s & Ex p e n s e s 50 0 . Or a c l e M a i n t & S u p p o r t ( $ 6 , 60 0 ) F i l e S e r v e r & D a t a b a s e 10 0 . 00 ( $ 4 50 0 ) 60 0 . 00 E S R I m a i n t e n a n c e & s u p p o r t ( $ 4 , 30 0 ) 40 0 . 70 0 . 00 H y d r a l i c M o d e l S o f t w a r e m a i n t e n a n c e & s u p p o r t 15 0 . Fi l e S e r v e r & D a t a b a s e s u p p o r t ( $ 2 , 50 0 ) ; R o u t e r m a i n t & 60 0 . 00 s u p p o r t ( $ 1 , 60 0 ) 20 0 . 00 R o u t e r M a i n t & S u p p o r t ( $ 1 , 70 0 ) 20 0 . 00 A u t o C a d U p g r a d e 35 0 . 00 I n t e l l u t i o n M a i n t & S u p p o r t A g r e e m e n t UNITED WATER IDAHO INC. CASE NO. UWI-O4- SIXTH PRODUCTION REQUEST IPUC STAFF TT A C H MEN T RESPONSE TO REQUEST NO. 176 Un i t e d W a t e r I d a h o R a t e C a s e U W I - 04 - Si x t h P r o d u c t i o n R e q u e s t o f IP U C S t a f f - # 1 7 6 IT E x p e n s e s A c t u a l v e r s u s Bu d g e t A u g u s t t h r o u g h D e c e m b e r 20 0 4 Ol d Ne w Fi v e M o n t h Ac c o u n t Ac c o u n t De s c r i p t i o n 20 0 4 - 20 0 4 - 20 0 4 - 20 0 4 - 20 0 4 - Am o u n t 92 3 1 4 0 91 2 5 0 Ou t s i d e s e r v i c e - I S BU D G E T 7, 4 0 0 30 0 30 0 40 0 30 0 36 , 70 0 AC T U A L 86 7 13 , 85 7 59 7 63 2 07 1 40 , 02 3 VA R I A N C E 53 3 (6 , 55 7 ) 70 3 23 2 ) 22 9 (3 , 32 3 ) Ol d Ne w Fi v e M o n t h Ac c o u n t Ac c o u n t De s c r i p t i o n 20 0 4 - 20 0 4 - 20 0 4 - 20 0 4 - 20 0 4 - Am o u n t 92 1 4 0 0 90 7 0 0 IT s u p p l i e s a n d e x p e n s e BU D G E T 60 0 30 0 30 0 40 0 60 0 (p a r t i a l 9 0 7 0 0 ) AC T U A L S 60 8 85 0 (5 6 2 ) 28 5 22 1 VA R I A N C E 60 8 ) (3 , 25 0 ) 25 9 86 2 (8 8 5 ) 62 1 ) UNITED WATER IDAHO INC. CASE NO. UWI-O4- SIXTH PRODUCTION REQUEST IPUC STAFF TT A C H MEN T RESPONSE TO REQUEST NO. 187 Un i t e d W a t e r I d a h o Ra t e C a s e U W I - W- 0 4 - 0 4 Pr o d u c t i o n R e q u e s t N o . 1 8 7 R e s p o n s e Wa g e a n d I n c e n t i v e P a y b y P a y G r o u p ! D e p t K: \ 2 0 0 4 R a t e C a s e U W I - 04 - 04 \ P r o d u c t i o n R e q u e s t # 6 - 16 2 t o 1 9 5 \ ( # 1 8 7 P r o p o s e d . xl s ) S h e e t 1 Pa y g r o u p De p a r t m e n t De p t N o . Ba r g a i n i n g : Pr o d u c t i o n 10 0 Tr a n s m i s s i o n & Di s t r i b u t i o n 11 0 Fie l d S e r v i c e 30 0 Me t e r R e a d e r s 30 5 To t a l B a r g a i n i n g No n B a r g a i n i n g : Pr o d u c t i o n Tr a n s m i s s i o n & Di s t r i b u t i o n En g i n e e r i n g Te c h n i c a l Cu s t o m e r S e r v i c e Ad m i n i s t r a t i o n Ac c o u n t i n g To t a l N o n B a r g a i n i n g Gr a n d T o t a l 10 0 Sh o r t T e r m In c e n t i v e P a y Ba r g a i n i n g U n i t No n - Ba r g a i n i n g To t a l l n c e n t i v e To t a l R e g u l a r (M a n a g e m e n t ) In c e n t i v e AB C D A w a r d s Un i t I n c e n t i v e Pa y Pa y Gr a n d T o t a l P a y 80 0 50 0 30 0 88 8 , 35 9 89 4 , 65 9 60 0 50 0 10 0 18 6 , 17 5 19 4 27 5 80 0 50 0 30 0 26 4 , 92 3 26 7 , 22 3 20 0 50 0 70 0 14 8 , 88 8 15 0 , 58 8 14 , 40 0 00 0 18 , 40 0 48 8 , 34 5 50 6 , 74 5 73 4 2, 4 0 3 10 , 13 7 13 7 , 41 5 14 7 , 55 2 72 4 19 8 92 2 12 2 , 19 6 13 1 , 11 8 16 , 39 6 50 0 15 , 88 7 32 , 78 3 65 0 , 25 1 68 3 , 03 4 87 1 00 0 17 , 01 1 24 , 88 2 49 3 , 96 6 51 8 , 84 8 37 , 05 0 95 8 39 , 00 8 33 3 , 82 4 37 2 , 83 2 50 0 82 9 32 9 12 0 , 73 2 12 6 , 06 1 77 5 00 0 44 , 28 6 12 1 , 06 1 1 , 85 8 , 38 4 97 9 , 44 5 77 5 14 , 40 0 00 0 28 6 13 9 , 46 1 34 6 , 72 9 48 6 , 19 0 11 0 20 5 30 0 40 0 50 5 20 0 4 t o S e p t P i v o t K: \ 2 0 0 4 R a t e C a s e U W I - 04 - 04 \ P r o d u e t i o n R e q u e s t # 6 - 1 6 2 t o 1 9 5 \ ( # 1 8 7 w a g e s & b e n e f i t s . xl s ) 2 0 0 4 t o S e p t P i v o t De p a r t m e n t b y E a r n C o d e Si x t h D a t a R e ( l u e s t # 1 8 7 - T o t a l W a g e s b y B a r g a i n i n g ar g a l n l n g Su m o f E a r n A Ca t e g o r y Oe s e r (i j .. - .. - :;: . . . :;: . . . rn :;: . . . (J ) (J ) L. . . :;: : 0 :;: : 0C: (J ) (J ) (J ) a: : (! ) (J ) :; : : 0 (J ) :;: . . . a:: : L.. . :: r : (J ) (J ) L.. . (! ) :;: : 0 :;: : 0 1: : :;: . . . (J ) (J ) UV 1 06 0 1 0 0 80 0 80 0 60 2 05 1 60 6 , 85 1 06 0 1 1 0 60 0 60 0 79 5 13 1 80 1 73 1 06 0 3 0 0 50 0 50 0 16 2 , 70 1 16 4 20 1 06 0 3 0 5 50 0 50 0 13 8 , 03 1 13 9 , 53 1 UV 1 T o t a l 14 , 4 0 0 14 , 4 0 0 69 7 91 4 71 2 31 4 UW P 06 0 1 0 0 13 , 4 7 4 13 , 4 7 4 95 , 79 4 10 9 26 8 06 0 1 1 0 10 , 24 5 24 5 26 8 95 , 51 3 06 0 2 0 5 95 5 62 6 58 1 45 2 60 5 50 7 18 6 06 0 3 0 0 14 1 32 6 18 , 4 6 7 33 9 , 13 8 35 7 60 5 06 0 4 0 0 38 6 38 6 19 4 14 1 22 6 , 52 7 06 0 5 0 5 90 4 86 1 76 5 50 1 81 , 26 6 UW P T o t a l 00 0 12 3 , 91 8 13 5 , 91 8 24 1 , 4 4 7 37 7 36 5 Gr a n d T o t a l 26 , 4 0 0 12 3 , 91 8 15 0 , 31 8 93 9 36 1 08 9 , 67 9 #1 8 7 w a g e s & b e n e f i t s . xl s 20 0 3 P i v o t K: \ 2 0 0 4 R a t e C a s e U W I - 04 - 04 \ P r o d u e t i o n R e q u e s t # 6 - 1 6 2 t o 1 9 5 \ ( # 1 8 7 w a g e s & b e n e f i t s . xl s ) 2 0 0 3 P i v o t Ea r n C o d e Si x t h D a t a R e c u e s t # 1 8 7 - To t a l W a g e s b y B a r g a i n i n g No n B a r g a i n i n g b y D e p a r t m e n t b Su m o f E a r n A Ca t e g o r y Oe s e r (i j (i j +- ' +- ' ... . . :; : . . :;: . . .. . . . :; : " a. . a. . a. . +- ' L.. . .. . . . :; : : . :;: : . :. ; : : : ; :. ; : : : ; c: : C: : ::J c::L.. . c: : c:: L. . . c: : a. . :;: : . L. . . :.; : : : ; :: J c: : c: : a. . c: : :; : . . L.. . +- 'c: : a. . .c : : a:: : : :: J :: r : a. . L. . . :;: : . C) :'; : : : ; :.; : : : ; c: : :; : . . c: : :: J a. . c: : ( c: : UV 1 06 0 1 0 0 80 0 80 0 83 1 72 0 83 6 52 0 06 0 1 1 0 60 0 60 0 10 9 , 98 5 11 6 58 5 06 0 3 0 0 50 0 50 0 23 0 , 64 9 23 2 14 9 06 0 3 0 5 50 0 50 0 19 1 37 9 19 2 87 9 UV 1 T o t a l 14 , 4 0 0 14 , 4 0 0 36 3 , 73 4 37 8 13 4 UW P 06 0 1 0 0 77 9 56 0 33 9 13 4 11 5 14 3 , 4 5 3 06 0 1 1 0 50 9 01 1 95 3 13 , 4 7 2 11 7 , 54 5 13 1 01 8 06 0 2 0 5 38 8 1 6 , 97 0 9, 4 8 2 84 0 50 3 , 05 8 53 4 89 8 06 0 3 0 0 82 8 5, 4 3 2 18 3 16 , 4 4 3 43 8 , 65 4 45 5 09 7 06 0 4 0 0 50 0 12 4 2 8 94 2 11 , 4 7 0 03 6 40 5 , 05 1 44 7 08 7 06 0 5 0 5 83 7 19 0 02 7 11 4 89 6 11 8 92 2 UW P T o t a l 50 0 68 6 6 5 13 4 3 0 83 7 11 7 15 6 71 3 , 32 0 83 0 , 4 7 6 Gr a n d T o t a l 50 0 08 6 6 5 13 4 3 0 , 83 7 13 1 55 6 07 7 , 05 4 20 8 61 0 #1 8 7 w a g e s & b e n e f i t s . xl s 20 0 2 P i v o t K: \ 2 0 0 4 R a t e C a s e U W I - 04 - 04 \ P r o d u e t i o n R e q u e s t # 6 - 1 6 2 t o 1 9 5 \ ( # 1 8 7 w a g e s & b e n e f i t s . xl s ) 2 0 0 2 P i v o t en t b y E a r n C o d e Si x t h D a t a R e c u e s t # 1 8 7 - T o t a l Wa Q e s b y B a r Q a i n i n g No n B a r g a I n i n g b y ep a r t m Su m o f E a r n Ca t e Q o r v De s e r (i j a. . a. . a. .L.. . ::- :: - :t J :t J c: : C:: :: : 1 c: :L.. . c: : c: : 0: : L.. . c: : a. . :: - L.. . L.. . :t J ::: 1 c: : c: : L.. . a. . c: : c: : a. . .c : : 0: : (f ) ::: 1 L.. . ::- a.. L.. . (! ) :t J :t J c:: c:: :: : 1 a. . c:: (f ) c: ( UV 1 06 0 1 0 0 80 0 80 0 75 7 02 8 76 1 82 8 06 0 1 1 0 80 0 80 0 12 9 , 39 9 13 7 19 9 06 0 3 0 0 50 0 50 0 20 1 , 4 6 0 20 2 96 0 06 0 3 0 5 80 0 80 0 18 9 , 18 8 19 0 98 8 UV 1 T o t a l 90 0 90 0 27 7 07 4 29 2 97 4 UW P 06 0 1 0 0 72 6 94 3 50 0 16 9 14 3 , 75 8 15 2 , 92 7 06 0 1 1 0 98 3 50 0 8, 4 8 3 11 5 , 79 6 12 4 27 9 06 0 2 0 5 84 8 78 3 30 0 15 , 93 1 32 3 , 10 2 33 9 , 03 3 06 0 3 0 0 87 3 69 4 80 0 36 7 39 0 , 16 3 40 5 , 53 0 06 0 4 0 0 01 2 35 , 23 2 50 0 52 , 74 4 59 1 34 0 64 4 08 4 06 0 5 0 5 68 5 00 0 5 0 0 18 5 92 4 10 2 10 9 06 0 7 0 5 71 2 54 6 25 9 18 , 4 9 2 75 0 UW P T o t a l 85 6 63 , 18 2 2 5 , 60 0 5 0 0 11 1 13 8 68 0 , 57 5 79 1 71 3 Gr a n d T o t a l 75 6 63 , 18 2 2 5 , 60 0 5 0 0 12 7 03 8 95 7 64 9 08 4 68 7 #1 8 7 w a g e s & b e n e f i t s . xl s 20 0 1 P i v o t K: \ 2 0 0 4 R a t e C a s e U W I - 04 - 04 \ P r o d u e t i o n R e q u e s t # 6 - 1 6 2 t o 1 9 5 \ ( # 1 8 7 w a g e s & b e n e f i t s . xl s ) 2 0 0 1 P i v o t b E C d Si x t h D a t a R e c u e s t # 1 8 7 - T o t a l W a g e s b y B a r g a i n i n g No n B a r g a i n i n g b y D e p a r t m e n t .y a r n 0 e Su m o f E a r n A Ca t e g o r y Oe s e r . ... . . .. . . . := - - . := - - . := - - . .. . . . L.. . :: : - ::: - L.. . c: : : (! ) rJ ) :: : - ::: - := - - . L.. . :: J c: : : L.. . L.. . :I : L.. . :: : - (! ) C) c -e c := - - . 0 m 0 - .. c .. . . . I a . en UV 1 06 0 1 0 0 76 9 , 4 1 5 76 9 , 4 1 5 06 0 1 1 0 15 5 , 78 5 15 5 78 5 06 0 2 0 5 28 , 08 4 28 , 08 4 06 0 3 0 0 19 6 , 52 6 19 6 52 6 06 0 3 0 5 20 1 68 0 20 1 68 0 06 0 4 2 0 57 3 57 3 UV 1 T o t a l 35 7 06 3 35 7 06 3 UW P 06 0 1 0 0 67 8 4, 4 0 0 07 8 15 0 , 52 6 15 5 60 4 06 0 1 1 0 62 3 62 3 11 8 , 57 0 12 5 , 19 3 06 0 2 0 5 75 0 98 9 50 0 11 , 23 9 30 9 , 4 6 5 32 0 , 70 4 06 0 3 0 0 33 0 10 0 12 , 4 3 0 37 4 , 61 7 38 7 04 7 06 0 4 0 0 50 0 97 8 19 , 4 6 1 60 0 53 9 58 0 , 25 6 62 2 79 5 06 0 4 2 0 97 5 97 5 31 7 29 2 06 0 5 0 5 75 5 80 0 55 5 05 0 10 1 , 60 5 06 0 7 0 5 8, 4 6 5 8, 4 6 5 58 , 30 0 66 , 76 5 UW P T o t a l 25 0 21 , 73 0 92 6 38 , 99 8 90 4 69 5 , 10 0 78 7 00 4 Gr a n d T o t a l 25 0 21 , 73 0 92 6 99 8 90 4 05 2 , 16 3 14 4 06 7 #1 8 7 w a g e s & b e n e f i t s . xl s 20 0 0 P i v o t K: \ 2 0 0 4 R a t e C a s e . U W I - 04 - 04 \ P r o d u e t i o n R e q u e s t # 6 - 1 6 2 t o 1 9 5 \ ( # 1 8 7 w a g e s & b e n e f i t s . xl s ) 2 0 0 0 Pi v o t rt t b E r n Co d e Si x t h D a t a R e e u e s t # 1 8 7 - To t a l W a g e s b y Ba r g a i n i n Q No n B a r g a i n i n g b y D e p a me n . Su m o f E a r n A Ca t e g o r y Oe s e r . ... . . r: . :; : . . . :; : . . . ... . . L.. . += - += - r:: : r:: : ::J r:: : L. . . r:: : r:: : 0: : (! ) (/ J :: J r:: : :;: . . . L. . . r:: : 0: : :: J L.. . r:: : L.. . (! ) += - += - r: : : :; : . . . c: ( r: : : 0: : UV 1 06 0 1 0 0 64 6 , 80 9 64 6 80 9 06 0 1 1 0 23 1 , 04 4 23 1 , 04 4 06 0 2 0 5 44 , 50 3 50 3 06 0 3 0 0 20 7 79 2 20 7 79 2 06 0 3 0 5 21 3 , 19 9 21 3 , 19 9 06 0 4 2 0 16 1 76 7 16 1 76 7 UV 1 T o t a l 50 5 , 11 4 50 5 , 11 4 UW P 06 0 1 0 0 65 0 33 6 8, 4 1 8 14 , 4 0 4 21 1 , 4 7 7 22 5 88 1 06 0 1 1 0 50 0 82 3 32 3 11 4 , 17 2 12 0 , 4 9 5 06 0 2 0 5 22 5 85 3 67 8 18 , 75 6 38 3 , 26 9 40 2 02 5 06 0 3 0 0 32 5 95 0 61 6 89 1 40 8 , 4 9 6 42 3 , 38 7 06 0 4 0 0 75 0 61 7 2 3 , 50 0 70 0 33 , 56 7 34 8 , 95 1 38 2 51 8 06 0 4 2 0 55 0 08 7 67 2 30 9 14 6 , 27 1 15 2 58 0 06 0 5 0 5 54 9 16 2 71 1 96 , 00 1 99 , 71 2 06 0 7 0 5 10 , 86 9 2 2 51 5 38 4 91 0 88 , 29 4 UW P T o t a l 00 0 28 , 26 1 4 6 01 5 4 8 06 9 13 1 34 5 76 3 54 8 89 4 89 3 Gr a n d T o t a l 00 0 26 1 4 6 01 5 4 8 06 9 13 1 34 5 26 8 , 66 2 4, 4 0 0 , 00 7 #1 8 7 w a g e s & b e n e f i t s . xl s 19 9 9 P i v o t K: \ 2 0 0 4 R a t e C a s e U W I - 04 - 04 \ P r o d u e t i o n R e q u e s t # 6 - 1 6 2 t o 1 9 5 \ ( # 1 8 7 w a g e s & b e n e f i t s . xl s ) 1 9 9 9 P i v o t C d Si x t h D a t a R e q u e s t # 1 8 7 - T o t a l W a g e s b y B a r g a i n i n g No n B a r g a i n i n g b y D e p a r t m e n t b y ar n 0 e Su m o f E a r n A m t Ca t e g o r y Oe s e r . (i j ... . . ... . . :; : . . . :;: . . . co :;: ' " a.. . a. . . a. . . .. . . . L. . . L.. . c: : (.! ) (/) :; : . . . a. . . c: : :J :J : a. . . L.. . (. ! ) :;: . . . a.. . a. . . :2 : UV 1 06 0 1 0 0 66 7 , 96 3 66 7 96 3 06 0 1 1 0 29 2 02 6 29 2 02 6 06 0 2 0 5 45 , 60 2 45 , 60 2 06 0 3 0 0 22 3 , 90 3 22 3 , 90 3 06 0 3 0 5 20 5 , 80 5 20 5 , 80 5 06 0 4 2 0 19 4 , 78 0 19 4 78 0 UV 1 T o t a l 63 0 07 9 63 0 07 9 UW P 06 0 1 0 0 16 0 16 0 . 2 2 4 80 8 22 7 96 8 06 0 1 1 0 60 1 60 1 13 8 , 98 4 14 0 , 58 5 06 0 2 0 5 00 0 69 9 69 9 45 6 , 58 2 46 9 , 28 1 06 0 3 0 0 00 0 36 8 36 8 43 6 , 31 7 44 3 68 6 06 0 4 0 0 97 8 37 , 90 5 48 , 88 3 35 9 , 07 6 40 7 , 96 0 06 0 4 2 0 96 1 96 1 14 0 , 79 2 14 2 75 3 06 0 5 0 5 61 8 61 8 10 0 , 78 1 10 2 , 39 9 06 0 7 0 5 18 , 00 0 19 , 11 0 11 0 67 , 4 7 8 10 4 , 58 8 UW P T o t a l 00 0 53 , 38 6 57 , 01 5 11 4 , 4 0 1 92 4 81 9 03 9 21 9 (b l a n k ) (b l a n k ) (b l a n k ) T o t a l Gr a n d T o t a l 00 0 38 6 01 5 11 4 , 4 0 1 55 4 89 8 66 9 29 9 #1 8 7 w a g e s & b e n e f i t s . xl s UNITED WATER IDAHO INC. CASE NO. UWI-O4- SIXTH PRODUCTION REQUEST IPUC STAFF ATTACHMENT TO RESPONSE TO REQUEST NO. 198 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 ) (8 ) (9 ) 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 Or i g i n a l Or i g i a n l 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 An n u a l i z a t i o n Re v e n u e f o r Di f f e r e n c e 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 r o w t h Pr o F o r m a of G r o w t h Pr o F o r m a Or i g i n a l 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 1 2 / 3 1 / 0 4 Ye a r Th r u 5 / 3 1 / 0 5 Ye a r vs R e v i s e d ( E x h 6 S c h 1 P g 1 ) I ( E x h 6 S c h 3 P g 2 1 ) I ( E x h 6 S c h 3 P g 7 13 ) I ( E x h 6 S c h 3 P g 7 , 13 ) I ( E x h 6 S c h 3 P g 7 , 13 ) I I ( 1 ) + ( ( 2 ) . . . (5 ) ) I I E x h 6 S c h 3 P g 7 , 13 ) I ( ( 1 ) + ( ( 2 ) . . (4 ) ( 7 ) ) I (( 5 ) . ( 7 ) I TA R I F F E D S E R V I C E S ME T E R E D W A T E R S A L E S : Re s i d e n t i a l $ 2 1 11 7 24 7 $7 9 , 12 6 ($ 1 4 6 , 4 9 1 ) $ 2 1 8 53 9 $ 2 0 5 36 3 $ 2 1 , 4 7 3 , 7 8 4 $ 3 5 6 , 12 0 $ 2 1 62 4 54 1 ($ 1 5 0 , 75 7 ) Co m m e r c i a l $ 8 , 96 4 12 4 $ 9 27 0 ($ 3 4 21 3 ) $ 5 6 76 8 $ 1 0 6 , 54 9 $ 9 , 10 2 , 4 9 7 $ 9 4 61 3 $ 9 , 09 0 56 2 $ 1 1 93 6 Pu b l i c A u t h o r i t y $ 1 5 9 , 69 8 $ 0 ($ 3 , 65 0 ) $ 0 $ 0 $ 1 5 6 04 9 $ 0 $ 1 5 6 04 9 $ 0 at a l M e t e r e d S a l e s $ 3 0 , 24 1 , 06 9 $ 8 8 , 39 7 ($ 1 8 4 , 35 4 ) $ 2 7 5 , 30 7 $ 3 1 1 , 91 1 $ 3 0 , 73 2 33 0 $ 4 5 0 , 73 3 $ 3 0 , 87 1 , 15 2 ($ 1 3 8 , 82 2 ) 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 , 41 8 $ 5 1 8 , 66 1 $ 1 0 , 41 8 $ 5 1 8 , 66 1 $ 0 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 $ 3 2 2 , 32 9 $ 3 1 , 25 0 , 99 1 $ 4 6 1 , 15 1 $ 3 1 , 38 9 , 81 3 ($ 1 3 8 , 82 2 ) OT H E R R E V E N U Cu s t 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 $ 1 32 9 $ 4 5 , 98 5 $ 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 $ 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 22 0 Un b i l l e d R e v e n u e $ 0 $ 0 10 . O& M C o n t r a c t R e v e n u e $ 4 8 0 $ 4 8 0 48 0 11 . To t a l O t h e r R e v e n u e $ 1 4 3 , 69 0 $ 0 $ 0 $ 1 , 32 9 $ 1 4 5 , 01 9 $ 1 , 32 9 $ 1 4 5 , 01 9 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 $ 3 2 3 , 65 8 $ 3 1 , 39 6 , 01 0 $ 4 6 2 , 48 0 $ 3 1 , 53 4 , 83 2 ($ 1 3 8 , 82 2 ) OR I G I N A L P R O F O R M A RE V E N U E O N M A Y 20 0 5 B A S I S $ 3 1 , 53 4 , 83 2 DI F F E R E N C E O R I G I N A L vs . RE V I S E D ($ 1 3 8 , 82 2 ) UN I T E D W A T E R I D A H O NO R M A L I Z I N G 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 P R E S E N T RA T E S & T O T A L R E 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 Y E A R E N D E D j U L Y 3 1 , 2 0 0 4 & A PR O F O R M A Y E A R E N D E D DE C E M B E R 3 1 , 20 0 4 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 17 Description Adjust Transportation Expense To adjust transportation expense including lease, fuel maintenance, labor and overheads, insurance & lease disposal proceeds at current projections and known & measurable changes Details Lease Cost Fuel Maintenance materials, outside service Mechanic payroll and benefits Insurance Lease disposal proceeds Pro Forma Annual Expense 10.Test Year O&M ratio 68.89% 11.Test Year Expense 12.Adjustment 299,719 130,200 62,000 72,879 56,400 (31,442) 589,756 406,265 362,613 43,652 Amount $ 43,652 Exhibit No. Healy Schedule 1 Page 17 of 34 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Response to Production Request 198 Line No.Description Adjust Transportation Expense To adjust transportation expense including lease, fuel,maintenance. labor and overheads, insurance & lease disposal proceeds at current projections and known & measurable changes Details Lease Cost 299,719 Fuel 130,200 Maintenance materials, outside service 62,000 Mechanic payroll and benefits Insurance 56,400 Lease disposal proceeds (31,442) Pro Forma Annual Expense 516,877 10.Test Year O&M ratio 68.89%356,061 11.Test Year Expense 323,862 12.Adjustment 199 Amount $ 32,199 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 18 Description Adjust Customer Postage Expense To adjust customer postage expense to May 31,2005 customer level and current postal rates Details Annual bills based on May 31,2005 customer count 461,442 Average test year postage cost per bill 3059 Pro Forma bill postage expense 141,136 Local postage machine for locally mailed customer 205 notices, correspondence, etc Pro Forma Annual Expense 178,341 Test Year Expense 170,280 Adjustment 061 Amount 061 Exhibit No. Healy Schedule 1 Page 18 of 34 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Response to Production Request 198 Line No.Description Adjust Customer Postage Expense To adjust customer postage expense to December 31,2004 customer level and current postal rates Details Annual bills based on December 31,2004 customer count 458,328 Average test year postage cost per bill 3059 Pro Forma bill postage expense 140,184 Local postage machine for locally mailed customer 205 notices, correspondence, etc Pro Forma Annual Expense 177,389 Test Year Expense 170,280 Adjustment 109 Amount 109 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 19 Description Adjust Customer Information System (billing) Expense To adjust customer billing expense to May 31,2005 customer level Details Annual bills produced Cost per bill Pro Forma customer billing expense 475,995 7200 342,716 88,635 6000 53,181 000 398,897 384,481 14,416 Annual past due notices produced Cost per notice Pro Forma past due notice expense Misc programming charges based on test year level 10.Pro Forma Annual Expense 11.Test Year Expense 12.Adjustment Amount $ 14,416 Exhibit No. Healy Schedule 1 Page 19 of 34 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Response to Production Request 198 Line No.Description Adjust Customer Information System (billing) Expense To adjust customer billing expense to December 31 2004 customer level Details Annual bills produced - Dec. 2004 actual + final & corrected bills 472 784 Cost per bill 7200 Pro Forma customer billing expense 340,404 Annual past due notices produced 88,635 Cost per notice 6000 Pro Forma past due notice expense 53,181 Misc programming charges based on test year level 000 10.Pro Forma Annual Expense 396,585 11.Test Year Expense 384,481 12.Adjustment 12,104 Amount $ 12,104 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 20 Line No.Description Adjust Customer Outside Collection Expense To adjust expense of collecting and processing customer payments: paid at local office, through lockbox and ACH Details Annual bills produced 475,995 Lockbox transactions at test year level of 72.73%72.73% Lockbox transactions 346,191 Price per unit based on test year 2344 Pro Forma lockbox expense 81,147 ACH transactions 18,658 Price per unit based on test year 3472 10.Pro Forma ACH expense 6,478 11.US Bank local processing charges 20,364 12.Federal Express Charges 1,476 13.Normalizing adjustment for lower lockbox price per unit (30,000) 14.Pro Forma Annual Expense 79,465 15.Test Year Expense 99,590 16.Adjustment (20,125) Amount $ (20,125) Exhibit No. Healy Schedule 1 Page 20 of 34 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Response to Production Request 198 Line No.Description Amount Adjust Customer Outside Collection Expense To adjust expense of collecting and processing customer payments: paid at local office, through lockbox and ACH $ (20,672) Details Annual bills produced - Dec. 2004 actual + final & corrected bills 472,784 Lockbox transactions at test year level of 72.73%72.73% Lockbox transactions 343,856 Price per unit based on test year 2344 Pro Forma lockbox expense 80,600 ACH transactions 18,658 Price per unit based on test year 3472 10.Pro Forma ACH expense 6,478 11.US Bank local processing charges 20,364 12.Federal Express Charges 1,476 13.Normalizing adjustment for lower lockbox price per unit (30,000) 14.Pro Forma Annual Expense 78,918 15.Test Year Expense 99,590 16.Adjustment (20,672) Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 22 Description Adjust Uncollectible Accounts Expense To normalize uncollectible accounts expense based on a four year average Details Year Uncollectibles Revenue Jul-162,706 31,000,222 Jul-124,359 29,884 881 Jul-105,384 30,406,924 Jul-106,277 28,694,018 Sub Total 498,726 $ 119,986,045 41565% Pro Forma Revenue at Existing Rates Pro Forma Annual Expense Test Year Expense Adjustment 31,527,396 131,045 162,706 (31,661) Amount $ (31,661) Exhibit No. Healy Schedule 1 Page 22 of 34 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Response to Production Request 198 Description Adjust Uncollectible Accounts Expense To normalize uncollectible accounts expense based on a four year average Details Year Uncollectibles Revenue Jul- Jul- Jul- Jul- 162,706 124,359 105,384 106,277 31,000,222 29,884,881 30,406,924 28,694,018 Sub Total 498,726 $119,986,045 0.41565% Pro Forma Revenue at Existing Rates 31,396,010 Pro Forma Annual Expense 130,499 Test Year Expense 162,706 Adjustment (32,207) Amount $ (32,207)