20111019UWI to Staff 29,31,42,43,45,46.pdf

[phone]
[phone] (Fax)
Via Hand Delivery
Jean Jewell, Secreta
Idaho Public Utities Commssion
472 W. Washigton St.
Boise, Idaho 83720
McDevitt & Miller LLP
Lawyers nEe!:i r'ìl\ _l t,._ L "d
420 W. Bannock Str.f#, OCT I 9 PM 3: 09
P.O. Box 2564-8376i I
Boise, Idaho 83702 ¡' (' ~, !,J n. ."-rtï Iv
UT!LlTIES
October 19, 2011
Re: Case No. UWI-W-11-02
General Rate Case Filng
Dear Ms. Jewell:
Enclosed for fig, please fid thee (3) copies of United Water Idaho's Responses to the
Commssion Staffs Second Production Request No's 29, 31, 42, 43, 45, and 46.
Kidly retu a fie stamped copy to me.
DJM/hh
Encl.
Very Truy Yours,
McDevitt & Mier lL
~WLDean J. Mier
Chas. F. McDevitt
Dean J. (Joe) Miler
"
UNITED WATER IDAHO INC.
CASE UWI-W-II-02
SECOND PRODUCTION REQUEST OF THE COMMISSION STAFF
Preparer: Jarila Cary
Sponsoring Witness: Jeremiah Healy
REQUEST NO. 29:
For each of the past three calendar years (2008-2010), please provide by rate schedule: (a) the
monthly and anual total dollR1s written off (gross), and (b) the monthly and anual total dollars
written off due to customer banptcy.
RESPONSE NO. 29
Attached are the 2008-2010 monthly and anual total dollars wrtten off (gross) and offsetting
collections resulting from regular bad debt wrte-offs, banptcies, and miscellaneous bad debts
from miscellaneous services such as fire hydrant rentals, etc. The Company does not maintain
bad debt and write off information by rate schedules.
.. UNITED WATER IDAHO
CASE NO. UWI-W-LL-02
MONTHLY AND ANNUAL TOTAL DOLLARS WRITTEN OFF 2008-2010
Second Production Request No. 29
Writeoff Writeoff Water Collections Adjust Miscellaneous
Water due to - Bad Debts on Bad Debt Reserve for Bad Debt Total GL
Bankruptcy Bad Debt
Jan-08 $$21,035 $(3,176)$1,665
Feb-08 $$29,166 $(10,886)$(1,906)
Mar-08 $$25,958 $(13,772)$(736)
Apr-08 $$19,288 $(12,468)
May-08 $$12,642 $(14,614)$(911)
Jun-08 $$16,350 $(14,115)
Jul-08 $$5,851 $(10,453)
Aug-08 $$10,091 $(11,448)$(18,000)
Sep-08 $$6,514 $(6,685)
Oct-08 $$11,668 $(7,580)$(670)
Nov-08 $$12,776 $(6,128)
Dec-08 $$4,814 $(6,429)$(13,600) $(629)
Total $$176,155 $(117,752)$(31,600) $(3,187) $23,615 $23,615
Jan-09 $$19,630 $(2,372)$9,010
Feb-09 $6.00 $19,983.58 $(3,659)$214
Mar-09 $3,318 $44,395 $(4,989)
Apr-09 $452 $18,140 $(3,894)$(1,427)
May-09 $7,011 $15,666 $(3,278)$(481)
Jun-09 $306 $22,473 $(2,993)$(100) $(603)
Jul-09 $1,823 $11,223 $(4,724)$(535)
Al)g-09 $3,800 $12,304 $(3,618)$(333)
Sep-09 $1,223 $9,319 $(3,867)
Oct-09 $2,202 $11,847 $(3,766)$(990)
Nov"09 $177 $10,076 $(3,281) $(2,200)
Dec-09 $457 $15,479 $(3,730)$3,224
Total $20,776 $210,534 $(44,171)$(2,300) $8,079 $ 192,918 $192,918
Jan-10 $1,489 $29,637 $(2,541)$(433)
Feb-lO $205 $30,890 $(10,820)$(993)
Mar-10 $1,832 $27,061 $(7,753)$(602)
Apr-10 $548 $22,070 $(6,887)$5,940
May-10 $387 $18,891 $(4,379)$(413)
Jun-10 $219 $14,381 $(3,557)$(417)
Jul-10 $174 $32,572 $(5,380)$(398)
Aug-10 $292 $30,809 $(4,491)$(838)
Sep-10 $1,145 $20,368 $(4,412)$(533)
Oct-10 $630 $26,138 $(5,637)$(27)
Nov-10 $163 $9,490 $(4,643)$(612)
Dec-10 $205 $23,094 $(3,911)$(189)
Total $7,289 $285,400 $(64,411)$$484 $ 228,762 $228,762
UNITED WATER IDAHO INC.
CASE UWI-W-II-02
SECOND PRODUCTION REQUEST OF THE COMMISSION STAFF
Preparer: Jarila Car
Sponsoring Witness: Greg Wyatt
REQUEST NO. 31:
Please provide an update on the United Water Cares program, including fuding to date by
Company, customer contributions, total dollar amount awarded to customers, total number of
customers assisted, and total amount provided to CAP AI for administration. Please provide
fuher explanation of the UW Cares program details including any changes to the program since
initiated and when the change was initiated. Please provide the corresponding analysis in
electronic executable format on a monthly basis for calendar years 2009, 2010 and 2011 to date.
RESPONSE NO. 31:
The attached Excel fie titled "#3 I UW Cares Sumar 2009-11.xlsx" contains the general
ledger amounts by month for Company fuding, customer contributions, total dollar amount
awarded to customers, total number of customers assisted, and total amount provided to CAP AI
for administration for the years 2009,2010, and 201 I though September.
The only changes to the UW Cares program since its inception in 2005 is the increase in the
annual assistace a qualified customer can receive went from $50 to $65, and the removal of the
matching "cap" which was initially set at $20,000 anually. These changes took effect on
October 1,2011.
UNITED WATER IDAHO INC.
CASE UWI-W-II-02
SECOND PRODUCTION REQUEST OF THE COMMISSION STAFF
Preparer: Jeremiah Healy
Sponsoring Witness: Paul Herbert
REQUEST NO. 42:
Please provide a detailed accounting oftest year revenues biled under Schedule No.5,
Miscellaneous Fees and Charges for each of the following:
1. Retu Check Charge
2. Reconnection Charge for Nonpayment Terminations
3. Field Collection Trip Charge
4. Service Connection Charge for Other than Normal Business Hours
5. Temporar Disconnection at Customer Request Charge
6. Meter Test at Customer Request Charge
7. Meter Rental Charge for Constrction
Please provide your answer in a format similar to the following:
Date Fee or amount charged Number of checks, charges, rentas, etc. Total Revenue
RESPONSE NO. 42:
The enclosed Excel fie titled "#42 Sch 5 Misc Charges Test Year.xlsx" contains the test year
Schedule 5 miscellaneous charges as requested totaling $64,745 from accounts 40200 & 40205.
The test year GL for accounts 40200 & 40205 is $161,304. It included fire hydrant meter rental
& consumption fees of $96,243 that are coded to the same accounts but are not par of the
Schedule 5 tariff, and a miscode of $316 of write-off fees that were transferred to account 90400
after the test year.
UNITED WATER IDAHO INC.
CASE UWI-W-II-02
SECOND PRODUCTION REQUEST OF THE COMMISSION STAFF
PreparerlSponsoring Witness: Greg Wyatt
REQUEST NO. 43:
Please provide a sample copy of any brochure or other printed material regarding the Company's
Water Conservation program. How and when is this material provided to customers?
RESPONSE NO. 43:
Conservation Bil Insert: The summer conservation bil insert is included in every customer's
paper bil, and it is electronically included with all e-bils. The sumer conservation insert ran
in customer bils from May 5-July 5, 2011. (See enclosed file titled "#43 Summer Cons Bil
Insert.pdf')
Annual Conservation Guide: The Guide is issued durng mid-June every year. The 2011
edition came out Sunday, June 19. Approximately 46,500 copies were distributed in the Sunday
edition of the Idaho Statesman, targeted to home delivery and newsstad editions withn United
Water Idaho's service area. It is also available for pick-up at the United Water Idaho Victory
Road office, Boise WaterShed Education Center, Boise City Hall, the Foothils Learing Center
and the Ada County Extension Offce. It is also distributed at community events United Water
Idaho participates in, including "green" fairs, neighborhood association meetings and other
presentations. (See enclosed fie titled "#43 Conservation Guide 201 L.pdf')
Green Expo Ad: The ad is used in printed materials created by the Idaho Green Expo. The ad
is par of the name recognition package when sponsoring the Expo. The past few years the Expo
occurred in May. (See enclosed fie titled "#43 Green Expo Ad.pdf')
Idaho Rivers United Ads: The ads are a result of a parnership with Idaho Rivers United. The
ads ru in the Idaho Statesman during August. (See enclosed fie titled "#43 IRU 6 Sumer
Ads.pdf')
ß
,
UNITED WATER IDAHO INC.
CASE UWI-W-II-02
SECOND PRODUCTION REQUEST OF THE COMMISSION STAFF
PreparerlSponsoring Witness: Greg Wyatt
REQUEST NO. 45:
Please describe in detail any planed brochures, kits, devices or other physical items curently
planed for but not yet distributed to customers. Please include within your response the timing
of distribution(s), draft brochures, kits, devices or other physical items underway, the status of
the items, and the expected result from said distributions.
RESPONSE NO. 45:
Annual Conservation Guide: Planed for June 2012. There is no draft at this time. The Guide
also includes the coupons for free water saving devices as in past Guides. United Water expects
customers to use the Guide to lear and be reminded to use water more wisely both inside and
outside the home, thus saving water and money.
Summer Bil Insert: Planed for spring 2012. There is no draft at this time. Expected result is
for customers to use water more wisely both inside and outside the home, thus saving water and
money.
Rain Sensor, Hose Timer and Hose Nozzle Give-away Program: Planed for Sumer 2012
in conjunction with Anual Conservation Guide. Expected result is for customers to use water
more wisely outside the home, thus saving water and money.
Commercial Kitchen Spray Retrofit Program: Continue promotion and change-out of high-
efficiency commercial kitchen pre-rinse spray fixtures though communications with food
industry and other organizations with registered commercial kitchens. Expected result is for
customers to use less water in their commercial kitchen pre-rinse stations, thus saving water and
money.
"
,
Idaho Green Expo Booth: Planed for June 2012. The Company anticipates paricipating in
the Idaho Green Expo as a sponsor, with printed information in the event's program and a booth
presence. Anticipate some sort of consumer conservation give-away, but that has not been
selected at this time. Expected result is for customers to use water more wisely both inside and
outside the home, thus saving water and money.
UNITED WATER IDAHO INC.
CASE UWI-W-II-02
SECOND PRODUCTION REQUEST OF THE COMMISSION STAFF
Preparer/Sponsoring Witness: Jeremiah Healy
REQUEST NO. 46:
Regarding the conservation guide produced by the Company and distributed as a supplement to
the Idaho Statesman and at events throughout the year, please provide a breakdown of costs to
produce, print and distribute the guide for calendar years 2009, 2010 and 2011 to date.
RESPONSE NO. 46:
Below are the costs for production, printing and distribution of the Company's anual
Conservation Guide for the calendar years of2009, 2010, and 2011. The majority of production
costs were not incurred directly by United Water Idaho in 2011 for the Guide as design and
production were performed at the corporate level for use by other sister companies as well.
These costs would have been allocated via the M&S Fee allocation method, but have not yet
been fully researched.
2009 2010 2011
Production $5,000.00 $4,975.52 $320.24
Printing & Distribution $4,925.00 $5,000.00 $4,950.00
Performed by The Idaho Statesman
Total Cost $9,925.00 $9,975.52 $5,270.24