|
CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED MAY, 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 $ 2,574,737 $ 4,359,263 37.13%
<br /> Cost of sales (4,957,300) (1,445,063) (3,512,237)29.15%
<br /> 1,976,700 1,129,674
<br /> Gross profit 847,026 57.15%
<br />Operating revenues:
<br /> User charges$ - $ - $ - 0.00%$ 1,860,000 $ 463,432 $ 1,396,568 24.92%$ 1,310,000 $ 443,988 $ 866,012
<br /> 33.89%$ 420,000 $ 112,208 $ 307,792 26.72%
<br /> Delinquency collections - - -0.00% 1,300 - 1,3000.00% 13,000
<br /> - 13,000 0.00% - - -0.00%
<br /> Other 1,700 1,034 66660.82% 2,000 - 2,0000.00% 3,500 1,089
<br /> 2,41131.11% - - -0.00%
<br /> 1,700 1,034 1,863,300 463,432 1,326,500 445,077 420,000 112,208
<br /> Total operating revenues 66660.82% 1,399,868 24.87% 881,423 33.55% 307,792 26.72%
<br />Operating expenses:
<br /> Personal services 659,850 243,300 416,550 36.87% 532,650 194,807 337,843 36.57% 22,900 8,220 14,680
<br /> 35.90% 80,650 29,821 50,829 36.98%
<br /> Supplies 53,700 7,895 45,805 14.70% 217,800 25,757 192,043 11.83% 6,300 1,884 4,41629.90%
<br /> 7,000 26 6,9740.37%
<br /> Other service charges 231,950 77,482 154,468 33.40% 517,200 161,386 355,814 31.20% 1,340,700 460,453 880,247
<br /> 34.34% 403,150 73,494 329,656 18.23%
<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 328,677 2,692,000 381,950 1,369,900 470,557 924,550 103,341
<br /> Total operating expenses 739,823 30.76% 2,310,050 14.19% 899,343 34.35% 821,209 11.18%
<br /> 909,900 802,031 (828,700) 81,482 (43,400) (25,480) (504,550) 8,867
<br />Operating income (loss) 107,869 88.14% (910,182)-9.83% (17,920)58.71% (513,417)-1.76%
<br />Nonoperating revenues (expenses):
<br />
<br /> Interest income 25,000 14,445 10,555 57.78% 80,000 28,996 51,004 36.25% 6,250 2,536
<br /> 3,71440.58% 1,500 977 52365.13%
<br /> Grant revenue - - -0.00% 800,000 187,020 612,980 23.38% -
<br /> - -0.00% - - -0.00%
<br /> Interest expense - - -0.00% (272,400) (23,033) (249,367)8.46% -
<br /> - -0.00% - - -0.00%
<br /> 25,000 14,445 607,600 192,983 6,250 2,536 1,500 977
<br /> Total nonoperating revenues (expenses) 10,555 57.78% 414,617 31.76% 3,71440.58% 52365.13%
<br />Income (loss) before contributions and transfers 934,900 816,476 118,424 87.33% (221,100) 274,465 (495,565)-124.14% (37,150)
<br /> (22,944) (14,206)61.76% (503,050) 9,844 (512,894)-1.96%
<br />Contributions - connection fees - - -0.00% 492,700 185,868 306,832 37.72%
<br /> - - -0.00% 51,500 5,506 45,994 10.69%
<br />Transfers in - - -0.00% - - -0.00% 36,600
<br /> - 36,600 0.00% - - -0.00%
<br />Transfers out (718,950) - (718,950)0.00% (100,000) - (100,000)0.00% (45,000) -
<br /> (45,000)0.00% - - -0.00%
<br />NET INCOME (LOSS) 215,950 816,476 (600,526)378.09% 171,600 460,333 (288,733)268.26% (45,550) (22,944) (22,606)50.37%
<br /> (451,550) 15,350 (466,900)-3.40%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (5,012,000) (1,576,776) (3,435,224)31.46% (180,000) -
<br /> Bond Payment (400,000) (400,000) -100.00%
<br />Revenues over/(under) expenditures 215,950 816,476 (600,526) (5,240,400) (1,516,443) (3,723,957) (45,550) (22,944) (22,606)
<br /> (631,550) 15,350 (466,900)
<br /> * Recorded ar yearend
<br />
|