|
City of LaPorte
<br />N-R/E Mater h Seller Rate Study
<br />21-Aug-85 Summary of Revenues h Expenditures
<br />9 RUN 1« HATER FUND
<br />1 50.OOX
<br /> 1982-83 1983-84 1984-85 1985-86 1986-87 1987-88
<br />ACCOUNT
<br />----------------------
<br />----- ACTUAL ACTUAL BUDGET PLANNED PLANNED PLANNED
<br />-
<br />REVENUES: -------- -------- -------- -------- ------- --------
<br />Hater Sales - Existing
<br />H
<br />t
<br />I 884,102
<br />0 1,560,167
<br />0 1,496,444
<br />0 1,541,337 1,587,577
<br />3
<br />6
<br />284 1,635,205
<br />5
<br />3
<br />8
<br />2
<br />er
<br />ncrease
<br />a D 3
<br />, 1
<br />,
<br />8
<br />Hater line Charges 24,288 11,217 10,000 10,300 10,609 10,921
<br />Hater Taps 74,134 101,645 135,000 35,000 36,050 37,132
<br />Hater Reconnect Charges 7,053 10,205 8,000 11,000 11,330 11,670
<br />Hater Neter Sales 0 4,986 2,500 2,500 2,515 2,652
<br />Hater Penalties 15,873 31,223 13,250 6,500 6,695 6,896
<br />Interest Income 32,859 55,866 21,500 21,500 22,145 22,809
<br />liscellaneous Income
<br />P
<br />b
<br />bl
<br />C
<br />it
<br />l R
<br />F 8,410
<br />0 8,312
<br />0 1,450
<br />a 1,775
<br />a 0
<br />38 0
<br />ro
<br />a
<br />e
<br />ecovery
<br />ap
<br />a
<br />ees
<br />---------
<br />---------
<br />---------
<br />--------- 1
<br />,400
<br />--------- 138,400
<br />---------
<br />t TOTAL REVENUES t 1,056,383 1,184,281 1,688,144 1,629,912 2,151,665 2,374,572
<br />
<br />EXPENDITURES: --------- --------- --------- --------- --------- ---------
<br />Personnel Services 383,088 479,775 522,019 570,195 658,513 732,767
<br />Materials h Supplies 47,820 64,557 28,943 26,835 84,477 89,775
<br />Maintenance 96,338 74,062 128,996 708,667 150,545 157,627
<br />Services 136,069 176,714 251,402 227,506 311,676 360,013
<br />Increase D erating Exp. 0 0 0 4 0 0
<br />Capital Outlay 43,325 71,584 101,456 66,120 61,065 65,375
<br />Capital Projects 50,000 122,524 ]58,354 100,000 100,000 100,000
<br />Miscellaneous 0 24,259 0 0 0 0
<br />Bad Debt Expense
<br />G h A Ch 39,222
<br />30
<br />483 28,943
<br />66
<br />205 44,962 46,311 47,701 49,132
<br />arge , , 0 0 0 0
<br />Debt Service - Principal 14,583 14,583 14,583 0 0 0
<br />Debt Service - Interest 2,960 2,428 1,888 0 0 0
<br />New Debt - Principal 0 0 0 136,830 136,830 136,830
<br />New Debt -Interest 0 0 0 266,819 253,478 446,539
<br />Trans. to 6D - Principal 92,120 42,120 135,090 135,590 136,044 141,190
<br />Trans. to GD - Interest 68,201 68,201 155,735 146,200 136,644 126,928
<br />Reserve Requirement 0
<br />--------- 0
<br />--------- 201,824
<br />--------- 100,912
<br />--------- 182,412
<br />--------- 82,000
<br />---------
<br />t TOTAL C05TS ~ 1,004,204
<br />--------- 1,294,951
<br />--------- 1,745,252
<br />--------- 1,932,584
<br />--------- 2,259,990
<br />--------- 2,488,115
<br />---------
<br />TRANSFER IN FROM GENERAL FUND 0 0 115,587 111,869 108,325 148,603
<br />CHANGE IN NORKIN6 CAPITAL 52,174 493,330 58,479 {190,803) {0} 0
<br />BEGINNING NORKIN6 CAPITAL 370,328 422,502 915,832 914,311 783,508 783,508
<br />ENDING NDRKINfi CAPITAL 422,502
<br />=..ec=: 915,832
<br />==.ac... 974,311
<br />:=a...e. 783,50E
<br />.ea. .== 783,508
<br />c..eeaec 783,508
<br />.oac====
<br />NDRKING CAP. COMPONENTS: -
<br />Cash h Investments 434,503 901,391 816,796 574,414 550,488 565,912
<br />Accounts Receiaable 90,126 382,151 197,459 246,575 289,612 213,706
<br />Accrued Interest Rec. 6,981 6,973 8,810 9,807 9,801 8,633
<br />Inventory 945 1,000 1,355 1,509 1,509 1,328
<br />Due From Other Funds 4 4,440 4 0 0 0
<br />Accounts Payable
<br />D
<br />t
<br />Oth
<br />F
<br />d {70,766)
<br />897)
<br />(1 (15,957)
<br />{89
<br />774} 550,109}
<br />D (53,147} 167,908) (66,071}
<br />ue
<br />o
<br />er
<br />un
<br />s , , 0 0 D
<br />Advances from Customers (1,429]
<br />--------- 1173,9181
<br />---- 0 0 0 0
<br />
<br />ENDING NDRKING CAPITAL
<br />517,962 -----
<br />1,016,907 ---------
<br />474,311 ---------
<br />783,508 ---------
<br />783,508 ---------
<br />783,50E
<br />DAYS IN NDRKING CAPITAL 144.08 184.20 197.65 166.00 126.54 114.94
<br />AVERAGE N.C. RESERVE 39.4BX 51.84X 54.15X 45.4BX 34.b1X 31.49X
<br />LEGAL DEBT COVERAGE RATIO 18.43 50.84 37.48 1.64 2.11 1.74
<br />FINANCIAL COVERAGE RATIO 1.05 1.38 1.03 0.90 1.00 1.00
<br />RATE INCREASE NEEDED O.OOX O.OOX O.OOX O.OOX 21.18X 8.50X
<br />
|