|
CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED OCTOBER, 2016
<br />
<br />LiquorSewerGarbageStormwater
<br />
<br />Current Year to Date Budget % of Current Year to Date Budget % of Current Year to Date Budget % of Current Year to Date Budget % of
<br /> Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget
<br />Sales and cost of sales:
<br /> Sales$ 6,934,000 $ 5,659,445 $ 1,274,555 81.62%
<br /> Cost of sales (4,957,300) (3,766,684) (1,190,616)75.98%
<br /> 1,976,700 1,892,761
<br /> Gross profit 83,939 95.75%
<br />Operating revenues:
<br /> User charges$ - $ - $ - 0.00%$ 1,860,000 $ 1,427,882 $ 432,118 76.77%$ 1,310,000 $ 1,005,426 $ 304,574
<br /> 76.75%$ 420,000 $ 338,208 $ 81,792 80.53%
<br /> Delinquency collections - - -0.00% 1,300 1,479 (179) 113.77% 13,000
<br /> 4,584 8,41635.26% - 544 (544) 0.00%
<br /> Other 1,700 1,647 5396.88% 2,000 - 2,0000.00% 3,500 1,412
<br /> 2,08840.34% - 11 (11) 0.00%
<br /> 1,700 1,647 1,863,300 1,429,361 1,326,500 1,011,422 420,000 338,763
<br /> Total operating revenues 5396.88% 433,939 76.71% 315,078 76.25% 81,237 80.66%
<br />Operating expenses:
<br /> Personal services 659,850 520,002 139,848 78.81% 532,650 417,705 114,945 78.42% 22,900 17,940
<br /> 4,96078.34% 80,650 63,651 16,999 78.92%
<br /> Supplies 53,700 15,366 38,334 28.61% 217,800 66,593 151,207 30.58% 6,300 2,046 4,25432.48%
<br /> 7,000 90 6,9101.29%
<br /> Other service charges 231,950 195,352 36,598 84.22% 517,200 391,648 125,552 75.72% 1,340,700 1,088,540 252,160
<br /> 81.19% 403,150 90,714 312,436 22.50%
<br /> Depreciation * 123,000 - 123,000 0.00% 1,424,350 - 1,424,350 0.00% -
<br /> - -0.00% 433,750 - 433,750 0.00%
<br /> 1,068,500 730,720 2,692,000 875,946 1,369,900 1,108,526 924,550 154,455
<br /> Total operating expenses 337,780 68.39% 1,816,054 32.54% 261,374 80.92% 770,095 16.71%
<br /> 909,900 1,163,688 (828,700) 553,415 (43,400) (97,104) (504,550) 184,308
<br />Operating income (loss) (253,788)127.89% (1,382,115)-66.78% 53,704 223.74% (688,858)-36.53%
<br />Nonoperating revenues (expenses):
<br />
<br /> Interest income 25,000 38,184 (13,184)152.74% 80,000 68,653 11,347 85.82% 6,250 6,189
<br /> 6199.02% 1,500 3,300 (1,800) 220.00%
<br /> Grant revenue - - -0.00% 800,000 380,057 419,943 47.51% -
<br /> - -0.00% - - -0.00%
<br /> Interest expense - - -0.00% (272,400) (157,686) (114,714)57.89% -
<br /> - -0.00% - - -0.00%
<br /> 25,000 38,184 607,600 291,024 6,250 6,189 1,500 3,300
<br /> Total nonoperating revenues (expenses) (13,184)152.74% 316,576 47.90% 6199.02% (1,800) 220.00%
<br />Income (loss) before contributions and transfers 934,900 1,201,872 (266,972)128.56% (221,100) 844,439 (1,065,539)-381.93% (37,150)
<br /> (90,915) 53,765 244.72% (503,050) 187,608 (690,658)-37.29%
<br />Contributions - connection fees - - -0.00% 492,700 386,764 105,936 78.50%
<br /> - - -0.00% 51,500 12,362 39,138 24.00%
<br />Sale of assets - - -0.00% - 36,500 (36,500)0.00% -
<br /> - -0.00% - - -0.00%
<br />Transfers in - - -0.00% - - -0.00% 36,600
<br /> - 36,600 0.00% - - -0.00%
<br />Transfers out (718,950) (704,567) (14,383)98.00% (100,000) (100,000) -100.00% (45,000) (45,000)
<br /> -100.00% (5,000) (5,000) -100.00%
<br />NET INCOME (LOSS) 215,950 497,305 (281,355)230.29% 171,600 1,167,703 (996,103)680.48% (45,550) (135,915) 90,365
<br /> 298.39% (456,550) 194,970 (651,520)-42.71%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (5,012,000) (3,129,874) (1,882,126)62.45%
<br /> Bond Payment (400,000) (400,000) -100.00%
<br />Revenues over/(under) expenditures 215,950 497,305 (281,355) (5,240,400) (2,362,171) (2,878,229) (45,550) (135,915) 90,365
<br /> (456,550) 194,970 (651,520)
<br /> * Recorded at yearend
<br />
|