|
Revenues
<br />Penalties & Interest
<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 September 30, 2022
<br />Budget Actuals Prior Year Variance -
<br />Annual Thru Thru Thru Favorable
<br />Budget 09/30/2022 09/30/2022 09/30/2021 (Unfavorable)
<br />$ - $
<br />-
<br />$ 23 $
<br />171 $
<br />(149)
<br />41,250
<br />30,938
<br />28,270
<br />62,250
<br />(33,980)
<br />(1)
<br />78,260
<br />58,695
<br />61,113
<br />120,003
<br />(58,890)
<br />(1)
<br />5,000
<br />3,750
<br />3,420
<br />4,750
<br />(1,330)
<br />50,000
<br />37,500
<br />(287,035)
<br />(9,959)
<br />(277,076)
<br />(2)
<br />2,500
<br />1,875
<br />919
<br />1,268
<br />(349)
<br />-
<br />-
<br />10,894
<br />-
<br />10,894
<br />287,680
<br />215,760
<br />215,643
<br />-
<br />215,643
<br />(3)
<br />1,268,772
<br />951,579
<br />929,385
<br />1,024,211
<br />(94,826)
<br />(4)
<br />22,000
<br />16,500
<br />20,809
<br />13,080
<br />7,729
<br />1,755,462
<br />1,316,597
<br />983,441
<br />1,215,774
<br />(232,333)
<br />391,147
<br />293,360
<br />285,000
<br />213,750
<br />306,007
<br />229,505
<br />10,258
<br />7,694
<br />783,605
<br />587,704
<br />1,765,015
<br />1,323,761
<br />407,680
<br />305,760
<br />3,948,712
<br />2,961,534
<br />233,861
<br />214,608
<br />(19,253)
<br />250,919
<br />221,633
<br />(29,286)
<br />(5)
<br />250,188
<br />166,451
<br />(83,737)
<br />(6)
<br />7,007
<br />11,299
<br />4,292
<br />1,049,841
<br />86,928
<br />(962,913)
<br />(7)
<br />1,791,816
<br />700,919
<br />(1,090,897)
<br />$ (2,193,250) $ (1,644,938) $ (808,375) $ 514,855 $ (1,323,230)
<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 115 new customers YTD in 2022 compared to 249 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) While customers and rates have increased in 2022, the unfavorable variance is a result of higher than average consumption in
<br />Q3 2021 were a 37% increase in consumption was mainly driven by irrigation.
<br />(5) Variance due to the purchase of fire hydrants within maintenance supplies and more water meters purchased YTD in 2022.
<br />(6) 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 />(7) Variance from prior year due to timing of capital projects and purchases. Utilities vehicle (50% charged to Sewer) was replaced in
<br />both years, while final expenses for Well House No. 1 Rehabilitation were incurred in 2021, and Water Tower #2 Rehabilitation
<br />expenses have been incurred in 2022.
<br />L
<br />
|