|
City of Lino Lakes
<br />Water Fund Budet to Actual (Unaudited)
<br />For the Quarter Ended September 30, 2021
<br />Budget Actuals Prior Year Variance -
<br />Annual Thru Thru Thru Favorable
<br />Budget 09/30/2021 09/30/2021 09/30/2021 (Unfavorable)
<br />Revenues
<br />Penalties & Interest -$ -$ 171$ 101$ 70$
<br />Water Hook Up Charge 36,500 27,375 62,250 31,000 31,250 (1)
<br />Water Meter Sales 50,000 37,500 120,003 52,174 67,828 (1)
<br />Irrigation Controller Sales - - 4,750 - 4,750
<br />Interest On Investments 50,000 37,500 (9,959) - (9,959)
<br />Miscellaneous Revenue 2,500 1,875 1,268 281 987
<br />Water Sales 1,080,000 810,000 1,024,211 843,359 180,852 (2)
<br />Penalty 22,000 16,500 13,080 8,617 4,463
<br />Sale of Fixed Assets - - 13,750 - 13,750
<br /> Total Revenues 1,241,000 930,750 1,229,524 935,533 293,991
<br />Expenditures
<br />Personal Services 312,737 234,553 214,608 200,329 (14,279)
<br />Supplies 240,000 180,000 221,633 146,061 (75,572) (3)
<br />Services & Charges 300,181 225,136 166,451 329,792 163,341 (4)
<br />Contractual Services 11,000 8,250 11,299 28,442 17,143
<br />Depreciation*605,000 453,750 - - -
<br />Capital Outlay 55,000 41,250 86,928 293,234 206,306 (5)
<br /> Total Expenditures 1,523,918 1,142,939 700,919 997,857 296,939
<br />Revenues Over
<br />(Under) Expenditures (282,918)$ (212,189)$ 528,605$ (62,324)$ 590,930$
<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 249 new customers YTD in 2021 compared to 124 in 2020. New customers primarily from Watermark.
<br />(2) Quarter 3 2021 is driving the favorable variance due to a 37% increase in consumption compared to 2020. This increase can be
<br />attributed to new customers, but more so to consumption for irrigation. The quarter 3 increase is partially offset by consumption
<br />decreases in quarter 1 & 2 2021 with more water sales in 2020 due to the COVID-19 Pandemic and more people at home.
<br />(3) Increase from prior year is a result of more water meter inventory due to the increase in new customers, the irrigation controller
<br />program was new in 2021, and chemicals are higher due to the increase in water consumption.
<br />(4) A pay voucher for the Well House No. 1 Rehabilitation was incorrectly coded to Municipal Engineer instead of Capital Outlay
<br />in July 2020.
<br />(5) Variance due to capital equipment purchased and capital projects in progress:
<br />2021 - Smart Radio Reader, 50% Utilities Vehicle, 50% Lawn Mower, Well House No. 1 Rehabilitation
<br />2020 - Smart Irrigation Meters, 50% Utilities Vehicle, Well House No. 1 Rehabilitation
<br />5
|