|
CITY OF ELK RIVER
<br /> ENTERPRISE FUNDS-BUDGET TO ACTUAL
<br /> MONTH ENDED APRIL,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 $ 1,969,877 $ 4,895,773 28.69%
<br /> Cost of sales (4,898,950) (1,198,431) (3,700,519) 24.46%
<br /> Gross profit 1,966,700 771,446 1,195,254 39.23%
<br /> Operating revenues:
<br /> User charges $ - $ - $ - 0.00% $ 1,758,200 $ 438,472 $ 1,319,728 24.94% $ 1,302,000 $ 324,164 $ 977,836 24.90% $ 418,000 $ - $ 418,000 0.00%
<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 853 2,647 24.37% - - -
<br /> Total operating revenues 1,900 822 1,078 43.26% 1,761,500 438,972 1,322,528 24.92% 1,317,500 325,017 992,483 24.67% 418,000 - 418,000 0.00%
<br /> Operating expenses:
<br /> Personal services 624,900 195,909 428,991 31.35% 526,560 132,321 394,239 25.13% 26,650 8,203 18,447 30.78% 87,150 22,387 64,763 25.69%
<br /> Supplies 53,400 26,856 26,544 50.29% 217,700 15,869 201,831 7.29% 5,900 150 5,750 2.54% 14,600 1,103 13,497 7.55%
<br /> Other service charges 221,250 56,969 164,281 25.75% 470,550 110,414 360,136 23.46% 1,315,250 308,098 1,007,152 23.43% 243,000 128,476 114,524 52.87%
<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 279,734 742,816 27.36% 2,192,760 258,604 1,934,156 11.79% 1,347,800 316,451 1,031,349 23.48% 778,500 151,966 626,534 19.52%
<br /> Operating income(loss) 946,050 492,534 453,516 52.06% (431,260) 180,368 (611,628) -41.82% (30,300) 8,566 (38,866) -28.27% (360,500) (151,966) (208,534) 42.15%
<br /> Nonoperating revenues(expenses):
<br /> Interest income 25,000 5,317 19,683 21.27% 100,000 13,762 86,238 13.76% 6,250 1,225 5,025 19.60% 900 489 411 54.33%
<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 5,317 19,683 21.27% 2,638,950 (9,602) 2,648,552 -0.36% 6,250 1,225 5,025 19.60% 900 489 411 54.33%
<br /> Income(loss)before contributions and transfers 971,050 497,851 473,199 51.27% 2,207,690 170,766 2,036,924 7.74% (24,050) 9,791 (33,841) -40.71% (359,600) (151,477) (208,123) 42.12%
<br /> Contributions-connection fees - - - 0.00% 630,700 77,940 552,760 12.36% - - - 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 497,851 (182,801) 158.02% 3,718,390 228,706 3,489,684 6.15% (53,400) 9,791 (63,191) -18.34% (309,600) 135,224 (444,824) -43.68%
<br /> Items reclassified to balance sheet at year end:
<br /> Bond Proceeds - - -
<br /> Capital Outlay (10,875,100) (1,593,322) (9,281,778) 14.65% (180,000) -
<br /> Bond Payment - - -
<br /> Revenues over/(under)expenditures 315,050 497,851 (182,801) (7,156,710) (1,364,616) (5,792,094) (53,400) 9,791 (63,191) (489,600) 135,224 (444,824)
<br /> *Recorded at year end
<br />
|