200412221st Response of Resort Water to Staff.pdf

Dean J. Miller (ISB No. 1968)
McDevitt & Miller LLP
420 West Bannock Street
O. Box 2564-83701
Boise, Idaho 83702
208-343- 7500 (T)
208-336-6912 (F)
ioe~mcdevitt - mi ller .com
Attorneys/or Resort Water Co., Inc.
'-"'"'
I'Jr
, ;~ '. :~, j " !.:. :-.
1 ,
F n
~ .. 1CO' ,
l.,
font; nT~c 22 t\11 to: 2t3
" :' "'-"
1' '1jJI0Nur \ L \ \ \ L.;) L'
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF THE APPLICATION OF
RESORT WATER CO., INC, FOR THE
ISSUANCE OF A CERTIFICATE OF PUBLIC
CONVENIENCE AND NECESSITY, FOR
APPROV AL OF RATES AND CHARGES FOR
WATER SERVICE, FOR APPROVAL OF
RULES AND REGULATIONS GOVERNING
THE RENDERING OF WATER SERVICE
Case No. RES...W...RES...W...O4...1
APPLICATION FOR THE
ISSUANCE OF A CERTIFICATE
OF PUBLIC CONVENIENCE AND
NECESSITY AND TO ESTABLISH
RATES AND CHARGES FOR
WATER SERVICE AND REQUEST
FOR MODIFIED PROCEDURE
RESPONSES TO FIRST PRODUCTION REQUEST OF COMMISSION STAFF
Request No.1: The Application states that Resort Water s billing is based upon
an equivalent residential use (ERU) calculation. Please provide all formulae and
assumptions used in the ERU calculation. Include all calculations and
assumptions used to consistently apply all factors to the various customer types
and/or classes.
Answer: We have enclosed a spreadsheet titled "Commercial ERU Calculations
that shows these calculations. The basic strategy we used is as follows:
1. Take overall water usage from a known time period when a virtual 100%
capacity of our users are present, and subtract all known water use from
metered users , i.e. Mill Building and Lakeview Lodge.
2. Estimate the amount of water use from the various restaurants on the
system using IDAPA 58.01.03.007.08 (Wastewater Flows from Various
Establishments In Gallons per Day).
3. Subtract this quantity of water from overall water usage. After subtracting
commercial usage, we should be left with residential users.4. Divide (total water used - commercial use) by known residential users to
develop a gallon per day (gpd) per ERU.
5. Apply this gpd per ERU to each of the commercial uses to determine new
ERU's for each business.
6. Use historical data for Lakeview Lodge and Mill Building to determine
ERU's attributable to each of those uses.
7. Change the number of customers (ERU's) in the rate calculation to
determine a new calculation of rate per month per ERU.
8. Total ERU's changed from 383.5 to 378.5 due to new commercial ERU'
Individual commercial ERU's changed slightly as shown.
Witness at Hearing: Tim Elsea, P.
Equivalent Residential Units
Chimney Rock Date Gross Food Sales Avg. Meal Price Estimated Patrons12/24/2003 4351 12 362.
12/25/2003 4474 372.
12/26/2003 5809 484.
12/27/2004 6128 510.
12/28/2003 5606 467.
12/29/2003 5437 453.
12/30/2003 3849 320.
12/31/2003 6073 506.
avg. customers 444.
1/7/2004 1815 151.
1/8/2004 921 76.
1/9/2004 2781 231.
1/10/2004 3582 298.
1/11/2004 2228 185.
1/12/2004 1129 94.
1/13/2004 1063 88.
2/4/2004 1583 131 .
2/5/2004 1713 142.
2/6/2004 3713 309.42
2/7/2004 5102 425.
2/8/2004 2478 206.
2/9/2004 1753 146.
2/10/2004 1962 163.
Mojo Coyote 12/24/2003 1090 136.
12/25/2003 702 87.
12/26/2003 985 123.
12/27/2004 1164 145.
12/28/2003 1573 196.
12/29/2003 1696 212.
12/30/2003 1502 187.
12/31/2003 1480 185.
avg. customers 162.
1/7/2004 487 60.
1/8/2004 416 52.
1/9/2004 484 60.
1/10/2004 956 119.
1/11/2004 985 123.
1/12/2004 421 52.
1/13/2004 313 39.
2/4/2004 332 41.
2/5/2004 373 46.
2/6/2004 684 85.
2/7/2004 1414 176.
2/8/2004 1224 153.
2/9/2004 387 48.
2/10/2004 491 61.
Cantina 2/4/2004
2/5/2004
2/6/2004
2/7/2004
2/8/2004
2/9/2004
2/10/2004
325
308
717
320
40.
38.
89.
40.
Alpenglow - estimate it to be the same as Mojo Coyote 163.
Thor s Pizza - estimated to be the same as Mojo Coyote
Selkirk Laundry
Lakeview Usage
Mill Building Usage
Total Usage
Total Usage minus Restaurants and other measurable commercial units
Original New
Estimated gallons gallons Attributed Attributed
gallons per patron per day ERU's ERU'
13 4713.583
4846.833
6293.083
6638.667
6073.167
5890.083
4169.
6579.083
40490.
Estimated gallons gallons
gallons per patron per day
2 272.1.4
175.
246.
291
393.
424
375.
370
2275.
121.
104
121
239
246.
105.
78.
93.
171
353.
306
96.
122.
81.
179.
2275.
2275.
9240
79303
13496
600688
449791.
1.4
47.
gallon per day per eru
383.223.7616
New Gallon per day per ERU
272 236.4699
Therefore, original estimate of 220 gpd per ERU
appears to be low for our estimates
and 235 gpd will be used to determine the ERU's of
restaurants and other non-metered non-
residentail units
New Total ERU'
377.
Equivalent Residential Units
Chimney Rock Date Gross Food Sales Avg. Meal Price Estimated Patrons12/24/2003 4351 12 362.
12/25/2003 4474 372.
12/26/2003 5809 484.
12/27/2004 6128 510.
12/28/2003 5606 467.
12/29/2003 5437 453.
12/30/2003 3849 320.
12/31/2003 6073 506.
avg. customers 444.
1/7/2004 1815 151.
1/8/2004 921 76.
1/9/2004 2781 231.
1/10/2004 3582 298.
1/11/2004 2228 185.
1/12/2004 1129 94.
1/13/2004 1063 88.
2/4/2004 1583 131 .
2/5/2004 1713 142.
2/6/2004 3713 309.42
2/7/2004 5102 425.
2/8/2004 2478 206.
2/9/2004 1753 146.
2/10/2004 1962 163.
Mojo Coyote 12/24/2003 1090 136.
12/25/2003 702 87.
12/26/2003 985 123.
12/27/2004 1164 145.
12/28/2003 1573 196.
12/29/2003 1696 212.
12/30/2003 1502 187.
12/31/2003 1480 185.
avg. customers 162.
1/7/2004 487 60.
1/8/2004 416 52.
1/9/2004 484 60.
1/10/2004 956 119.
1/11/2004 985 123.
1/12/2004 421 52.
1/13/2004 313 39.
2/4/2004 332 41.
2/5/2004 373 46.
2/6/2004 684 85.
2/7/2004 1414 176.
2/8/2004 1224 153.
2/9/2004 387 48.
2/10/2004 491 61.
Cantina 2/4/2004
2/5/2004
2/6/2004
2/7/2004
2/8/2004
2/9/2004
2/10/2004
325
308
717
320
40.
38.
89.
40.
Alpenglow - estimate it to be the same as Mojo Coyote 163.
Thor s Pizza - estimated to be the same as Mojo Coyote
Lakeview Usage
Selkirk Laundry
Mill Building Usage
Total Usage
Total Usage minus Restaurants and other measurable commercial units
Request No.2: Please provide your hook-up fee calculation based on the actual
hook-up expenses and proportional recovery of storage and supply investments.
Answer: Due to this request, we analyzed our system , and the investments
made to provide additional water source capacity and additional water storage
capacity. In our analysis, we have determined that while a water source
development is directly relatable to the number of customers that can be served
by the investment, it is not possible to make the same relation between water
storage and number of customers. This is due to the fact that the amount of
storage needed is directly related to the capacity of the water source. i.e. If your
water source provides 125 gallons per minute, you would need a finite number of
storage gallons to serve the customers that can be served with your water source
capacity (this number would depend on your peaking factor), but if your water
source provides 60 gallons per minute you would need a different finite number
of gallons to serve your customers , but neither of these numbers would take into
account the fire flows needed for your particular system. Our analysis
determined that due to these factors, it would make sense to develop hook-up
fees for an investment made to develop a water source, but that the investment
needed to provide water storage would need to be recouped through the rates
because each customer needs the storage equally.
We further looked into what hook-up fees we would be able to recoup the
investment made to put our new well into service. This analysis is shown on a
new tab in the spreadsheet entitled "TEST YEAR NUMBERS FINAL -12-21-04"
The new tab is entitled "Hook-up Fee . After subtracting the hook-up fees
already paid, and subtracting depreciation , the hook-up fee would be $98 per
customer for 781 customers. If we were to assume 20 new hook-ups per year
(this is an extremely high estimate and is used for demonstration purposes only)
it would take 39 years to recoup the original investment. This figure does not
include depreciation, but we felt that this gave us enough information to show
that a hook-up fee is not feasible or desirable.
Witness at Hearing: Tim Elsea, P.
Request No.3: Please provide your current 5-year customer growth projections.
Answer: We do not have anYthing that could be called a firm five year growth
projection. However, we have some customers that have projects in our service
area that will provide 4 new ERU's per year for the 2005, 2006, 2007 seasons.
Harbor may provide an additional 13 ERU's within this same time frame , and we
would guess that we could add an additional 4 units per year for years 2008
2009. This estimate adds an additional 33 ERU's in the next five years. I cannot
speak to the reasonableness of this estimate.
Witness at Hearing: Tim Elsea , P.
Request No.4: Please provide the bankruptcy accounting information that
discloses the financial information related to the plant that was placed in service
for the water system by the predecessor of the current owner.
Answer: This documentation is enclosed.
Witness at Hearing: Tim Elsea , P.
December 16 , 2004
McDevitt & Miller
P . O. Box 2564-
Boise, Idaho 83702
RE: Mountain Utility PUC Application
Dear Mr. McDevitt:
Here is the information you requested regarding the financial statements at the
time of the bankruptcy. This information was sent to me by Curtis Clark a CPA in
coeur d Alene who did the books for Recreation Utilities which was the former
name of Resort Water. If you have any further questions please feel free to call.
ncerel
/'
Debra A. Harper
Account Manager
dharper~ schweitzer.com
RECREATIONS'
FINANCIAL
DECEMBER
UTILITY COMPANY,
STATEMENTS
31,1997 AND 1996
INC.
I iii
- ~~~ '-=o.=,-"'2~5'!':.q~", ;r,~f
~.-~" "'" """""""",,"",,~. ~, ";!L~~~~ i".:5,tf'.ff;f2 i1: i~?:2: ~xl1i:W 'Z!:
' ~ ~~,':"/;
iE'. C'1i GJ::;lli~ ~~/:;ill
RECREATIONS' UTILITY COMPANY, INC.
December 31, 1997 and 1996
Table of Contents
Accountant's Report
......................................
Pag~
Balance Sheet s .............
.....................
....... 2 -
tat emen t s 0 f Opera t ions
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Statements of Stockholders ' Equity
.................
Statements of Cash Flows
....................
Notes to Financial Statements
...............
. 7 - 10
/1')\ ~ON
'--1l1\. McNELIS & CO.
CERTIFIED PUBLIC ACCOUNTANTS
QJRI1S A. CIARK, CPA
M. LYNN ANDERSON, CPA
D. BRIAI'i Mc!'II"ELIS, CPA
-IDA M. WPER, CPA
STEVEN T. McCAUGHAN. CPA
DANA M. ROBSON. CPA
SHANNON SPRAKER, CPA
L\NCE PARKER WOODALL, CPA
PROFESSIONAL ASSOCIATION
ACCOUNTANT'S REPORT
Board of DirectorsRecreations' Utility Company, Inc.
Sand point, Idaho
We have compiled the accompanying balance sheets of RecreationsUtility Company, Inc. as of December 31, 1997 and 1996 and the
related statements of operations, stockholders ' equity, and cash
flows for the years then ended, in accordance with Statements on
Standards for Accounting and Review Services issued by the
American Insti tute of Certified Public Accountants.
A compilation is limited to presenting in the form of financial
statements information that is the representation of management.
We have not audited or reviewed the accompanying financialstatements, and accordingly, do not express an opinion or any
other form of assurance on them.
CLARK , ANDERSON McNELIS & CO., P .
June 25, 1998
-1-~f)O \Vl~~T C'.i~NFTFT.n AVE:'oJUE. SUITE 100. COEUR D'ALEl\;r., IDAHO 83815 "PHON"E [phone]. FAX [phone]
RECREATIONS' UTILITY COMPANY, INC.
Balance Sheets
December 31, 1997 and 1996
NOTE
REFERENCE
ASSETS
Current Assets:
Cash
Accounts Receivable
Total Current Assets
Property and Equipment:
Sewage System
Water System
Cable Television System
Other Equipment
Construction in Progress
Total Property and Equipment
Less Accumula ted Depreciation
Net Property and Equipment
Other Assets:
Due from Affiliates
TOTAL ASSETS
1997 1996
844
220,097
24,107
134,780
267,941 158,887
245,080 892,130
539,775 539,775
168,528 168,528
41,040 33,609
641 62,909
995,064 696,951
(1,155 610)986,525)
839,454 710,426
24,886
132 281 $ 1,869,313
(Balance Sheets Ca~~inue on Page
1i---.J;"'.J."""",J:"",",,"""'J;r,;;'~~,o,,,;";~"~;;--"S!iiW,,"':;"""""""'----'-"""""-",""
,,"" ",,,""""'-"' ",""",' .
",~, "';:""""='~-'~""""'."'.F"'!"";;;i"~".L,,Jjj?,,h1~'i;.~'-"i'.=""'k~"':i5f,--"""iE""""",i.-."""#..""";;'-""
" '
~;.""c ,,'~""4,'.;id"'"jt """""""","1"""""",,~""~ ""~ 'Y"'~-i' ;"
"'"\"""'"-~",,
b";:~
RECREATIONS' UTILITY COMPANY, INC.
Balance Sheets (Continued)
December 31, 1997 and 1996
- I
NOTE
REFERENCE 1997 1996
LIABILITIES AND STOCKHOLDERS' EQUITY
Current Liabilities:
Total Liabilities
442 24,475
501 527
081 021
13,024 30,023
107,914
13,024 137,937
Accounts Payable
Accrued Taxes
Advance Deposits
Total Current Liabilities
Due to Affiliates
Stockholders ' Equity:
Cornmon stock, $10 par value;
500 shares authorized,
3 shares issued and outstanding
Addi tional Paid In Capital
Retained Earnings
687 042
432,185
268,698
462,648
Total Stockholders ' Equity 119,257 731,376
TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY $ 2,132,281 $ 1,869,313
See Accompanyi~g Notes and Acco~ntant' s Reoor~
RECREATIONS' UTILITY COMPANY, INC.
Statements of Operations
For the Years Ended December 31, 1997 and 1996
NOTE
REFERENCE 1997 1996
Revenues:
Hoo kup Fees
Sewer Usage Fees
Water Usage Fees
Cable Telev~sion Usage Fees
Other Income
Finance Charges and Interest Income
Total Revenues
112,208
163,160
79,716
68,119
12,065
19,031
454,299
234,498
153,848
77,424
64,432
13,644
421
553,267
Direct Expenses:
Sewer System
Water System
Cable Televis~on System
Total Direct Expenses
105, 500
44,368
54,898
204,766
90,871
30,496
52,415
173,782
Gross Margin 249,533 379,485
General and Adrninistrati ve Expenses:
Salaries and Wages
. Payroll Taxes and Benefits
Rent
Management Fee
Professional Fees
Auto and Travel
Maintenance and Repairs
Supplies
Telephone
Insurance
Taxes and Licenses
Bad Debts
Total General and
Administrative Expenses
34,472
472
12,000
12,000
822
412
065
337
701
517
023
402
53,950
, 644
12,000
12,000
2, 000
926
850
430
641
1, 336
1, 267
028
88,223 107 072
Income Before Other Expenses 161,310 272,413
Other Expenses:
Interest Expense
Depreclation
Total Other Expenses
688
169,085
191,773
810
145,095
154,905
1'Je-::' I:-,come (Loss)
$ (
463 )117 508
RECREATIONS' UTILITY COMPANY, INC.
Statements of Stockholders ' Equity
For the Years Ended December 31, 1997 and 1996
Stockholders ' Equity at
January 1, 1996
Capi tal Contributed By
Stockholders
1996 Net Income
Stockholders ' Equity at
December 31, 1996
Capi tal Contribu~ed By
Stockholders
1997 Net Income (Loss)
Stockholders ' Equity at
December 31, 1997
COMMON
STOCK
$ 30
ADDITIONAL
PAID IN CAPITAL
$ 1,040,698
228, 000
268,698
418,344
$ 1,687,042
RETAINED
EARNINGS
$ 345,140
117,508
462,648
( 30,463)
432 185
TOTAL
$ 1,385,868
228,000
117,508
731,376
418,344
30,463)
$ 2,119,257
,."
RECREATIONS' UTILITY COMPANY, INC.
Statements of Cash Flows
For the Years Ended December 31, 1997 and, 1996
Cash Flows from Operating Activities:
Cash Received from Customers
Cash Paid to Suppliers
Interest Received
Interest Paid
Net Cash Provided by
Operating Acti vi ties
Cash Flows from Investing Activities:
Capi tal Expenditures
Cash Flows from Financing Activities:
Net Cash Transfers From (To) Affiliates
Contributed Capital
Net Cash Provided by
Financing Acti vi ties
Net Increase in Cash
Cash at Beginning of Year
Cash at End of Year
Reconciliation of Net Income to Net Cash
Provided by Operating Acti vi ties:
Net Income (Loss)
Adj ustments :
Deprecia tion
Accrued Interest Assumed by Shareholders
Changes in Assets and Liabilities:
Recei vables
Accounts Payable and Advance Deposi
Accrued Expenses
Total Adj ustments
Net Cash Prc~ided by Cperacing Activities
1997 1996
$ 364,375
( 309,646)
2, 732
986)
$ 461,653
( 297,358)
242
278)
48,475 156,259
( 298,112)( 409,230)-
522)
279,896
32,255
228,000
273,374 260,255
23,737 284
24,107 16,823
47,844 24,107
$ (
117 50830,463)
169,085
14,524
145,095
86,850)
16,973)
848 )
86,277)
20,478)
411
78,938 38,751
156,25948,475
RECREATIONS' UTILITY COMPANY, INC.
Notes to Financial Statements
December 31, 1997 and 1996
NOTE 1 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
GENERAL
Recreations ' Utility Company, Inc. (RECU or the Company)provides sewer, water and cable television services forproperty owners at Schweitzer Mountain Resort, located
north of Sandpoint, Idaho. The Company uses the accrual
method of accounting and reports its operations on calendar year basis.
PROPERTY AND EQUIPMENT
Property and equipment are stated at cost. Depreciationis provided substantially on the straight line method
over the useful lives of the assets. Major improvementsthat extend the useful lives of the assets are
capi tali zed ' and depreciated. Improvements and routine
maintenance that do not extend the useful lives of the
assets are charged against earnings in the year incurred.
INCOME TAXES
The Company has elected to be taxed under the provisionsof subchapter S of the Internal Revenue Code. Underthose provisions, the Company does not pay Federal or
sta te corpora te income taxes on its taxable income.
Instead, 'the stockholders report the taxable income or
loss on their individual returns. Accordingly, there hasbeen no provision for income taxes in these financialstatements.
0 )USE OF ESTIMATES
The preparation of financial statements In conformitywith generally accepted accounting principles requires
management to make estimates and assumptions that affectcertain reported amouilts and disclosures. Accordingly,
actual results could differ from those estimates.
'--'-- "'---..._-'-__
. -
RECREATIONS' UTILITY COMPANY, INC.
Notes to Financial Statements
December 31, 1997 and 1996
NOTE 2 RELATED PARTY TRANSACTIONS
In the normal course of business, the Company conductsbusiness with three affiliated entities, Schweitzer
Mountain Resort (Schweitzer), VP, Inc. and the Pack RiverLtd. Co. (PRLC)RECU and the three affiliates are all
owned by members of the Jean O. Brown family of Sandpoint,
Idaho.
Schweitzer operates the ski, lodging, and food and beverage
establishments in RECU' s service area. The management of
Schweitzer also manages the facilities of RECU. Sch~eitzer
charged office rent of $12, 000 for each of the years ended
December 31, 1997 and 1996.
VP, Inc. is corporation which includes PRLC as
shareholder. It operates a sewer and water facility at agolf course near Sandpoint, Idaho. RECU provides certain
sewer construction services to VP, Inc. which are charged
at prevailing rates.
PRLC is a limited liability company which provides various
administrative services. During 1997, Pack River employedthe individuals who provide maintenance and construction
services for RECU. Pack River charged the cost of those
employees, including taxes and benefi ts to RECU. Pack
River also charged a management fee of $12, 000 for each ofthe years ending December 31, 1997 and 1996. Pack Riveralso charged interest of $6,048 on amounts owed by RECUduring 1997.
Throughout the year, certain expenses and capi tal
improvements are paid by Schweitzer on behalf of RECU, and
these are charged to RECU through intercompany charges. well, RECU provides sewer, water and cable television
services to Schweitzer, which are charged at prevailingrates. Interest at an annual rate of 9.25% is charged onthe net balance resul ting from these transactions.Schweitzer charged RECU interest of $16,330 and $6,299during the years ending December 31, 1997 and 1996,respectively.
(Note 2 Continues on Page
C::oo ~rrI'""\1'r"!f-::lr.t-',.... 8,.."....,,~.....
RECREATIONS' UTILITY COMPANY, INC.
Notes to Financial Statements
December 31, 1997 and 1996
NOTE 2 RELATED PARTY TRANSACTIONS (Continued)
On December 31, 1997, Pack River charged the entire amounts
owed by RECU to affiliates to the shareholders. This
assumption of debt by the shareholders is reported as acontribution to capi tal by the shareholders on the
statements of stockholders equity. Amounts assumed are
scheduled as follows:
$298,827
119,517
Owed to Schweitzer
Owed to Pack River
Total As sumed 344
Amounts owed to (from) affiliates are scheduled as follows:
Total
1997 1996
123,847
899
( 24,886)16,832)
$ (
886)107 914
Schweitzer Mountain Resort
Pack River Ltd. Co.
VP I I nc .
, f
NOTE 3 COMMITMENTS AND CONTINGENCIES
The Company is a co-maker on certain notes payable owedto U. S. Bank of Washington, which are also obligations of
Schweitzer Mountain Resort and Pack River Ltd. Co. Theentire amount owing on these notes are reflected on the
books and records of Schweitzer and Pack River, with noliabili ty reflected on the books and records
Recreations Utility Company, Inc. portion of the
funds borrowed were used to construct improvements in the
sewer I water and cable television systems.
(Nate 3 Continues on Page 10)
C:;pp Arr,nl1nr,;:J,-r,-t-I q R~nnrt-
RECREATIONS' UTILITY COMPANY, INC.
Notes to Financial Statements
December 31, 1997 and 1996
NOTE 3 COMMITMENTS AND CONTINGENCIES (Continued)
Funds provided by these loans were charged to theshareholders, and have been recorded on the balance sheetas addi tional paid in capital received from theshareholders.
Both Schweitzer and Pack River are in default on thepayment of these notes. As described in Note 4, theCompany and its affiliates were recently placed intoreceivership. In November 1997, both Schweitzer and Pack
River filed for protection under Chapter 11 of the U. S.Bankruptcy Code.
The Company is directly liable, as a co-maker, for theentire obligations which approximate $24.million and$22.million as of December 31, 1997 and 1996respectively.
NOTE RECEIVERSHI P
In October 1996, the management of the Company,
Schwei tzer and Pack River, Ltd. was placed in the controlof Ford Elsaesser, a Court appointed receiver. Effortsto sell the Company assets have been made by thereceiver, and certain legal actions have been initiatedby some shareholders to prevent the sale. The Ii tigationin this matter is currently under review , and the outcomeis not certain as of the date of these financialstatements.
See Acccunt~nt' ~ Rpnnrt
These were cham!es after the ori2:inal application. as advised hv Joe Leckie
Known and Measurable
Known and Measurable
Known and Measurable
Known and Measurable
Known and Measurable
Known and Measurable
Number of Customers
Known and Measurable
Known and Measurable
And Adjustment to Bookeeping
Known and Measurable
Known and Measurable
Wages were updated using FY05 Projected Amounts
Telephone Ops account had included a once only set up charge, this h,
Electricity Cost Ops: on the detail sheet the calculation missed a cell
Account 72500 as Per J.L request, $100 has been added for taxes and
Bad debt has been changed to calculate to 1 % of revenues
Administrative services: the price of JDE accounting software package
Updated from 2003 customer list to 2004 customer list
Reduced Management Fee from $12 000 to $5 910. This accounts for'
IPUC expenses have increased to include actual spent during 2004
Because of the fonnula for amortization I have added the 2
Office rent, including utilities (sewer, water cable) has been added. Tht
An office telephone charge has been added. Account number 65180. T
The method is under TELEPHONE page
Electricity cost for the office has been allocated. Account number 681
These were the chan2:es made due to the First Production Request
Known and Measurable
Number ofERU's has been changed based on new calculations of com
Request No.5: Please provide the financial information that is the basis for the
rates that are requested in the Company s Application or as amended by the
Company. Please provide in electronic format.
Answer: This information has been provided in electronic format as requested.
Witness at Hearing: Tim Elsea, P.
1S been backed out
ontaining an invoice total of$139.28. This has been added.
Licences
~ has dropped significantly since IPue application.
the company s controller only: Method is detailed under MIse page
W04 total to the 2003 total in this column: $15 288.70 + $5 138.
method used is detailed under MIse page
his account now has cell phones and Mill Building office usage.
00. The method is under the UTILITIES page.
lI1lercial ERU's - The number ofERU's went from 383.5 to 378.
Known andAdiustment to Correct Measurable ChanGOBook...,;nq Errors Adjustment Notes Test Year As AdjustedTest Year 2003
Per Books Incremental IncrementaJ
~--jjll!t;Njijij~';,
;/,;'"
I,S'156:_;,!:S,(iGi378Y1 I.S",11i(.Of1lJ1 !:$i: ;,);Li";/i"I22!056~;129730,55050 Salaries & Waqes 39,981 828 FY2005 BudAeted Amount 49,81029730,55965 Payroll Taxes 068 913 FY2005 BudAOted Amount 98129730,56465 Group Health Insurance 381 344 FY2005 BudAeted Amount 72529730,55985 Workers Camp 241 653 FY2005 BudAeted Amount 894OPERATIONS
29730,60010 OIIeratinll Supplies 116 051 16729730,60150 Rmtal Equipment
29750,60800 Autorrruck Pans '" Repair 648 (2,648)29730,60182 Vehicle Maintenance 202 000 The Shop" Historical BudAeted Amount 20229730,60870 Water System MaIntenance 294 (7,294)29750,60880 Operating Maintenance 6Z1 (627)29730,60880 OIIeratinq Maintenance 303 487 11,79129730,68900 Outback Maintenance 164 (164)29750,68900 SM Water Oth.:r (DB WPL)60875 Chemicals 570 57060895ODs Rental Ex-
61600 Uniforms 500 Uniforms have not been used beforo 50029730,68050 Utility MarkinA29730,62620 UIIIII)' Morldn&Roundil1ll29710,68220 Gasoline29750,68220 Gasoline 533 (533)62630 Fuel Cost Opo 033 03362010EIectridty Opo 934 93462640Snow Removal
29730,6875 Mon~orinA 466 (466)62650 Monilorinq 281 759 Operations ManaAer Prolection 2004 = $2040 04062660Telephone Ops 739 (3,280)Phone set up charAe was incorrectly included 459
ADMINISTRATION29730,64100 Dues '" Subscriptions 418 393 $645 for DEO . $120 for Useen...81164300Employee Relations (98)64310 Employee Meal DIscoW1l RoundinA64700Ed....dou 409 050)240 60065105Controct Lobor29750,60010 Operating Supplies 869 (2,869)65150 OIIIa Supplies 592 60065160P...... '" Frel&hI (4)We havon~ paid for postaAe before
Remove Ops phooe into SOP""" ca"'gory, Budget for cell29750,6518 Telephone 286 (2,735)370 phone '" office use onlv 92065300Bank Sonia Chorg..65400 0I'IIce Spa Rent 110 11029750,65500 Professiooal Fees 086 (31086)29730,65500 Professional Fees 13,610 (2,977)634)00065540Proresslonol Fees Other
65560 _e Soni...648 807)83965900T.....eI 670 (1,138)60065905Meola892(592)30065920BusIness ReIodo..65925 CommDDlty Relodo..29750,68100 Electricity Cost (48)29730,68100 Electricity Cost 962 (2,962)235 Office electricity cost onlv 23568950Transfer to SCHW
68955 Transfer HMUCIRW
70100 Manocement Fee 910 Rod EnAel: Controller Services 91072100Real Estole T....23,927 (17,228)This will be determined by tho stale, Need survev done to 70072200Pe...no! Property T....72500 Mbc. Tn.. '" lie.....(4,630)738 100 IPUC Assessment has been added 20672700tPUCE.........20.427 (16,342)To be "amortized" over 5 vears 06573010Insnrona062(7,062)379 37929750,74250 SM Interest Exp. Trade74200InIerat Expense (47)74320 Bad Debt Ex-840 (8.167)(210)To 1% of revenues 48375100BulldlnC '" Improve...n"76000 AD.. 10 C.pltal Prolect
000000000000'I1ONi1!Xl!ENSES:+,/:1 O4:J:307i52Hr..PSI:'(22;181:;1IOll PS,21,;128!19700
,"'"
Book to IPUC Life; Less Unquaiified Assets
IOTtIERWXJi!It"
'."..' ,'.". ,'.." ..,..
Interest Expense (not applicable)Income Taxes. FederalIncome Taxes . State
INI!1iiINVEStMl!NT,
' ,....,...
765582,Book to IPUC Life; Less Unqualified Assets 655,780Working Capital (451365) . not including laxes 19,268,Change in working capital 15,048Less Contributions Received (Hookup Fees)764871,670,829Cost of Capital x Net Investment r:::JE) $335,73,791Net Incomo 8 343.3069REVENUE DEFICIENCY (Grossed up for Tax)PS:,1551&86'1 PS"':H&.H9H
CURRENT OPERATING REVENUES 206,103,(61851,25)Hookup fees should be Contributions 148,2522003 CONTRIBUTIONS TO CAPITAL 61,851,which lessen the investments baseTOTAL OPERATING REVENUES P$
. '
208:103,1:$'
, ,
1i16.252/,,1
Number of Users 378 378Monthly Rate Increase 34,Additional Rovenue Per ERU Per Month 25,New Monthly Fee Per ERU 58.
TAX GROSS-UP
100 Pe""'ot 01 '"",me
Less..3" 01_""
Less 32,975" of Fede",' Tox
Pe'Ceot Net 'ooome
100.000%'-6,300%-32796%60,905"
M," lie, 1/,60905 1642
ve
s
t
m
e
n
t

B
a
s
e

C
a
l
c
u
l
a
t
i
o
n
s
:

E
S
T
I
M
AT
E
PR
O
J
E
C
T
I
O
N
S

TE
S
T

Y
E
A
R
Bo
o
k
Mo
n
t
h
s

i
n

IP
U
C
IP
U
C

D
e
re
c
i
a
t
e
d
Va
l
u
e

o
n

J
o
b

A
u
d
i
t

re
c
i
a
t
i
o
n

Mo
n
t
h
l
re
c
i
a
t
e
d

A
m
o
u
n
t

Se
r
v
i
c
e

a
t

re
c
i
a
t
i
o
n

Am
o
u
n
t

E
n
d

o
f
Re
p
o
r
t
s

(Y
e
a
r
s
)
In

S
e
r
v
i
c
e

D
a
t
e

re
c
i
a
t
i
o
n

E
n
d

of

8
/
3
1
/
0
4

en
d

0
4

(Y
e
a
r
s
)
IP
U
C
M
o
n
t
h
l
8/
3
1
/
(
)
4
,T
E
D

$
3
5
5
,
00
0
.
00

25

12
/
8
/
1
9
9
8

$

1
18
3
.
33

$

8
1
64
9
,
99

69

50

59
1
.
6
7

$

82
5
,
$
1
7
4
73
4
.
EN
T

&

D
E
S
I
G
N

$
4
2
67
6
,
Mi
s
s
i
n
g

A
m
o
u
n
t

$
5
56
0
.
2
5
$
2
2
2
,
97
0
.
97

25

12
/
1
/
1
9
9
9

$

7
4
3
.
24

$

4
6
32
8
.
4
2

62

wii
-
'I
"
50

37
1
.
6
2

$

2
3
16
4
,
;W
i
~
'"

,
'
"
"
EN
T

$
2
1
6
26
3
.
AN

$
7
2
04
9
.
3
3
$
2
8
8
,
31
2
.
99

25

12
/
1
/
1
9
9
9

$

96
1
.
0
4

$

5
4
77
9
.
4
6

57

40

$
4
5
0
,
55

$

2
5
68
1
.
3
1
SP
R
I
N
G
S

$
2
,
51
2
.
20

25

12
/
1
/
1
9
9
9

$

8.
3
7

$

47
7
.
3
2

57

50

4.
1
9

$

2
3
8
,
IN

$
1
,
89
6
.
02

25

12
/
1
/
1
9
9
9

$

6.
3
2

$

3
6
0
,
24

57

50

$
3
,
16

$

1
8
0
,
$
I
J
,
39
5
.
65

25

12
/
1
/
1
9
9
9

$

3
7
,
99

$

2
16
5
.
19

57

50

$
1
8
.
99

$

08
2
,
t:
:
N
T

&

D
E
S
I
G
N

$
5
03
7
.
74

25

2/2
9
/
2
0
0
0

$
1
6
,
79

$

9
0
6
,
80

54

50

$
8
,
40

$

4
5
3
.
AN

$
6
,
08
8
.
95

25

2/
2
9
/
2
0
0
0

$
2
0
,
30

$

1
09
6
,
02

54

85
2
.
4
6

50

SP
R
I
N
G
S

$
1
,
42
9
.
71

25

5/3
1
/
2
0
0
0

$
4
,
77

$

2
4
3
,
05

51

50

2.
3
8

$

12
1
.
5
3
IN

$
4
9
6
.
85

25

2/
2
9
/
2
0
0
0

1.
6
6

$

89
.
4
1

54

50

$
0
,
83

$

4
4
,
EN
T

$
5
,
79
3
.
57

25

2/
2
9
/
2
0
0
0

19
.
3
1

$

1
04
2
,
83

54

50

$
9
.
66

$

52
1
.
4
2
$
1
0
,
01
4
.
32

25

4/
3
0
/
2
0
0
0

33
.
3
8

$

73
5
,
80

52

50

$
1
6
,
69

$

8
6
7
.
$
7
,
16
5
.
99

25

5/
3
1
/
2
0
0
0

$
2
3
,
89

$

1
21
8
,
22

51

50

11
.
9
4

$

6
0
9
,
-I
T
S

-

S
E
L
K
I
R
K

$
4
5
8
.
85

25

1/
1
/
2
0
0
0

$

1.
5
3

$

8
5
,
63

56

$
6
7
.
28

$
1
5
,
08
2
.
20

8/
3
1
/
2
0
0
0

$
1
7
9
,
55

$

8
61
8
.
4
0

48

$
6
,
4
6
3
,
80

7
$
-I
G

$
9
,
01
4
.
62

25

10
/
3
1
/
2
0
0
0

$

3
0
.
05

$

1
38
2
.
27

46

$
1
02
1
.
6
9

50

$
1
6
61
3
.
01

25

10
/
3
1
/
2
0
0
0

$

55
.
3
8

$

2
54
7
.
3
2

46

_l
B
I
f
i

25

55
.
3
8

$

2
54
7
.
32

fl
l
f
~
f
l
t
f
~
m
l
~
lI
N
E
E
R
I
N
G

(
O
u
t
b
a
c
k
)

$
1
8
,
53
9
.
4
6

25

10
/
3
1
/
2
0
0
0

61
.
8
0

$

2
84
2
,
73

46

$
2
10
1
.
1
5

50

LE
Y
'
$
1
2
,
32
0
.
70

25

10
/
3
1
/
2
0
0
0

$

41
.
0
7

$

1
88
9
.
1
9

46

$
1
39
6
.
36

$
7
74
1
.
6
5

10
/
3
1
/
2
0
0
2

$

2
1
5
.
05

$

4
73
1
.
0
1

22

"
11
*
,
;
:
-
'"
/

,
,
"
I
'
$
2
1
5
,
05

$

4
73
1
.
0
1
AN
N
U
A
L

D
E
P
R
E
C
I
A

T
I
O
N
:
99
7
,
88
5

AC
C
U
M

DE
P
R
E
C
I
A
T
I
O
N
:

$

2
0
9
45
8
.
29

$
1
0
1
,
06
8
IN
V
E
S
T
M
E
N
T

B
A
S
E

B
E
F
O
R
E

D
E
P
R
E
C
I
A
T
I
O
N
:
IN
V
E
S
T
M
E
N
T

B
A
S
E

L
E
S
S

AC
C
U
M

DR
E
P
R
E
C
I
A

T
I
O
N
:

$

7
8
8
,
42
7
.
16

$
8
5
9
,
40
9
LE
S
S

HO
O
K
U
P

FE
E
S

C
O
L
L
E
C
T
E
D

S
I
N
C
E

A
C
Q
U
I
S
I
T
I
O
N
:

20
0
3

o
n
l
y

$
1
2
8
,
60
9
IN
V
E
S
T
M
E
N
T

B
A
S
E
:

$
7
3
0
80
1
Re
s
o
r
t

W
a
t
e
r

C
o
m
p
a
n
y

H
o
o
k
u
Q
!
j
C
o
n
t
r
i
b
u
t
i
o
n
s

t
o

C
a
p
it
a
l
Ca
l
e
n
d
a
r
19
9
9
20
0
0
20
0
1
20
0
2
20
0
3
20
0
4
80
0
.
66
0
.
$
7
20
0
.
57
2
.
18
0
.
$
1
3
05
6
.
66
5
.
2,
4
6
0
.
$
1
0
84
0
.
07
8
.
$
2
1
28
0
.
$
1
50
0
.
07
7
.
$
1
6
50
0
.
74
3
.
75
)
$
1
2
90
5
.
92
0
.
$
(
4
83
3
.
75
)
33
0
.
16
0
.
19
,
85
6
.
$
8
,
70
0
.
10
,
91
0
.
$
3
3
,
34
1
.
$
4
8
,
62
0
.
18
0
.
00

12
8
,
60
8
.
54

J
6
1
.
85
1
.
Document
Number Current
Balance
FY2003
Balance