|
Revenues
<br />Water Hook Up Charge
<br />Water Meter Sales
<br />Irrigation Controller Sales
<br />Interest On Investments
<br />Miscellaneous Revenue
<br />Refunds & Reimbursements
<br />Flat Water Charge
<br />Water Sales
<br />Penalty
<br />Total Revenues
<br />Expenditures
<br />Personal Services
<br />Supplies
<br />Services & Charges
<br />Contractual Services
<br />Depreciation
<br />Capital Outlay
<br />Transfers Out
<br />Total Expenditures
<br />Revenues Over
<br />(Under) Expenditures
<br />City of Lino Lakes
<br />Water Fund Budget to Actual (Unaudited)
<br />For the Quarter Ended June 30, 2022
<br />Budget
<br />Actuals
<br />Prior Year
<br />Variance -
<br />Annual
<br />Thru
<br />Thru
<br />Thru
<br />Favorable
<br />Budget
<br />06/30/2022
<br />06/30/2022
<br />06/30/2021
<br />(Unfavorable)
<br />$ 41,250
<br />$ 20,625
<br />$ 14,760
<br />$ 41,750
<br />$ (26,990) (1)
<br />78,260
<br />39,130
<br />32,492
<br />77,917
<br />(45,425) (1)
<br />5,000
<br />2,500
<br />2,925
<br />4,750
<br />(1,825)
<br />50,000
<br />25,000
<br />(212,191)
<br />(6,677)
<br />(205,514) (2)
<br />2,500
<br />1,250
<br />694
<br />1,085
<br />(391)
<br />-
<br />-
<br />1,450
<br />-
<br />1,450
<br />287,680
<br />143,840
<br />143,397
<br />-
<br />143,397 (3)
<br />1,268,772
<br />634,386
<br />346,786
<br />342,169
<br />4,616
<br />22,000
<br />11,000
<br />11,882
<br />7,796
<br />4,086
<br />1,755,462
<br />877,731
<br />342,194
<br />468,790
<br />(126,595)
<br />391,147
<br />195,574
<br />285,000
<br />142,500
<br />306,007
<br />153,004
<br />10,258
<br />5,129
<br />783,605
<br />391,803
<br />1,765,015
<br />882,508
<br />407,680
<br />203,840
<br />3,948,712
<br />1,974,356
<br />157,166
<br />141,433
<br />(15,733)
<br />152,526
<br />108,007
<br />(44,519) (4)
<br />132,843
<br />94,960
<br />(37,883) (5)
<br />4,976
<br />6,227
<br />1,251
<br />39,601
<br />67,273
<br />27,672 (6)
<br />487,111 417,899 (69,212)
<br />$ (2,193,250) $ (1,096,625) $ (144,917) $ 50,890 $ (195,807)
<br />*Depreciation is factored out of contractual services. Depreciation is a non -cash expense calculated at year end.
<br />Item Explanation of items with variance greater than $20,000
<br />(1) Roughly 60 new customers YTD in 2022 compared to 167 in 2021.
<br />(2) Due to rising interest rates unrealized losses on investments are greater than interest earnings.
<br />(3) Previously accounted for in the Area and Unit Fund, the Flat Water Charge was moved to the Water Fund in 2022 as a result of
<br />the rate study performed by Baker Tilly in 2021.
<br />(4) Variance due to the purchase of fire hydrants within maintenance supplies and chemicals.
<br />(5) Variance due to an increase in watermain break repair professional service expenses, IT services & support, and electricity.
<br />Payment processing fees for utility billing payments was accounted for within contracted services in 2021.
<br />(6) Variance from prior year due to timing of capital projects and purchases. Utilities vehicle (50% charged to Sewer) was replaced in
<br />both years, although expenses for Well House No. 1 Rehabilitation were incurred in 2021.
<br />L
<br />
|