|
CITY OF ELK RIVER
<br /> ENTERPRISE FUNDS-BUDGET TO ACTUAL
<br /> MONTH ENDED MAY,2015
<br /> Liquor Sewer Garbage Stormwater
<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,865,650 $ 2,584,654 $ 4,280,996 37.65%
<br /> Cost of sales (4,898,950) (1,551,067) (3,347,883) 31.66%
<br /> Gross profit 1,966,700 1,033,587 933,113 52.55%
<br /> Operating revenues:
<br /> User charges $ - $ - $ - 0.00% $ 1,758,200 $ 585,560 $ 1,172,640 33.30% $ 1,302,000 $ 434,756 $ 867,244 33.39% $ 418,000 $ 37,176 $ 380,824 8.89%
<br /> Delinquency collections - - - 0.00% 1,300 - 1,300 0.00% 12,000 - 12,000 0.00% - - -
<br /> Other 1,900 822 1,078 43.26% 2,000 500 1,500 25.00% 3,500 1,130 2,370 32.29% - - -
<br /> Total operating revenues 1,900 822 1,078 43.26% 1,761,500 586,060 1,175,440 33.27% 1,317,500 435,886 881,614 33.08% 418,000 37,176 380,824 8.89%
<br /> Operating expenses:
<br /> Personal services 624,900 244,604 380,296 39.14% 526,560 165,070 361,490 31.35% 26,650 10,285 16,365 38.59% 87,150 28,397 58,753 32.58%
<br /> Supplies 53,400 40,409 12,991 75.67% 217,700 19,272 198,428 8.85% 5,900 200 5,700 3.39% 14,600 1,103 13,497 7.55%
<br /> Other service charges 221,250 70,346 150,904 31.79% 470,550 144,260 326,290 30.66% 1,315,250 417,759 897,491 31.76% 243,000 129,725 113,275 53.38%
<br /> Depreciation* 123,000 - 123,000 0.00% 977,950 - 977,950 0.00% - - - 0.00% 433,750 - 433,750 0.00%
<br /> Total operating expenses 1,022,550 355,359 667,191 34.75% 2,192,760 328,602 1,864,158 14.99% 1,347,800 428,244 919,556 31.77% 778,500 159,225 619,275 20.45%
<br /> Operating income(loss) 946,050 679,050 267,000 71.78% (431,260) 257,458 (688,718) -59.70% (30,300) 7,642 (37,942) -25.22% (360,500) (122,049) (238,451) 33.86%
<br /> Nonoperating revenues(expenses):
<br /> Interest income 25,000 12,349 12,651 49.40% 100,000 29,321 70,679 29.32% 6,250 2,818 3,432 45.09% 900 848 52 94.22%
<br /> Grant revenue - - - 0.00% 2,800,000 - 2,800,000 0.00% - - - 0.00% - - - 0.00%
<br /> Interest expense - - - 0.00% (261,050) (23,364) (237,686) 8.95% - - - 0.00% - - - 0.00%
<br /> Total nonoperating revenues(expenses) 25,000 12,349 12,651 49.40% 2,638,950 5,957 2,632,993 0.23% 6,250 2,818 3,432 45.09% 900 848 52 94.22%
<br /> Income(loss)before contributions and transfers 971,050 691,399 279,651 71.20% 2,207,690 263,415 1,944,275 11.93% (24,050) 10,460 (34,510) -43.49% (359,600) (121,201) (238,399) 33.70%
<br /> Contributions-connection fees - - - 0.00% 630,700 124,290 506,410 19.71% - - - 0.00% 50,000 5,940 44,060 0.00%
<br /> Transfers in - - - 0.00% 1,000,000 - 1,000,000 0.00% 14,600 - 14,600 0.00% - 280,761 (280,761)
<br /> Transfers out (656,000) - (656,000) 0.00% (120,000) (20,000) (100,000) 16.67% (43,950) - (43,950) 0.00% - - -
<br /> NET INCOME(LOSS) 315,050 691,399 (376,349) 219.46% 3,718,390 367,705 3,350,685 9.89% (53,400) 10,460 (63,860) -19.59% (309,600) 165,500 (475,100) -53.46%
<br /> Items reclassified to balance sheet at year end:
<br /> Bond Proceeds - - -
<br /> Capital Outlay (10,875,100) (2,898,453) (7,976,647) 26.65% (180,000) (27,821)
<br /> Bond Payment - - -
<br /> Revenues over/(under)expenditures 315,050 691,399 (376,349) (7,156,710) (2,530,748) (4,625,962) (53,400) 10,460 (63,860) (489,600) 137,679 (475,100)
<br /> *Recorded at year end
<br />
|