|
CITY OF ELK RIVER
<br /> ENTERPRISE FUNDS-BUDGET TO ACTUAL
<br /> MONTH ENDED JANUARY 31,2017
<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 $ 7,004,150 $ 455,111 $ 6,549,039 6.50%
<br /> Cost of sales (5,008,100) (36,158) (4,971,942) 0.72%
<br /> Gross profit 1,996,050 418,953 1,577,097 20.99%
<br /> Operating revenues:
<br /> User charges $ - $ - $ - 0.00% $ 1,915,000 $ - $ 1,915,000 0.00% $ 1,366,000 $ 100 $ 1,365,900 0.01% $ 445,000 $ - $ 445,000 0.00%
<br /> Delinquency collections - - - 0.00% 2,000 - 2,000 0.00% 10,500 - 10,500 0.00% - (139) 139 0.00%
<br /> Other 1,700 - 1,700 0.00% 2,000 - 2,000 0.00% 2,500 191 2,309 7.64% - - - 0.00%
<br /> Total operating revenues 1,700 - 1,700 0.00% 1,919,000 - 1,919,000 0.00% 1,379,000 291 1,378,709 0.02% 445,000 (139) 445,139 -0.03%
<br /> Operating expenses:
<br /> Personal services 663,300 42,471 620,829 6.40% 555,800 36,285 519,515 6.53% 24,450 1,447 23,003 5.92% 86,000 4,683 81,317 5.45%
<br /> Supplies 20,700 97 20,603 0.47% 206,800 132 206,668 0.06% 21,400 - 21,400 0.00% 2,000 - 2,000 0.00%
<br /> Other service charges 241,500 3,846 237,654 1.59% 552,000 5,853 546,147 1.06% 1,457,200 - 1,457,200 0.00% 458,200 750 457,450 0.16%
<br /> Depreciation* 125,000 - 125,000 0.00% 1,425,000 - 1,425,000 0.00% - - - 0.00% 448,000 - 448,000 0.00%
<br /> Total operating expenses 1,050,500 46,414 1,004,086 4.42% 2,739,600 42,270 2,697,330 1.54% 1,503,050 1,447 1,501,603 0.10% 994,200 5,433 988,767 0.55%
<br /> Operating income(loss) 947,250 372,539 574,711 39.33% (820,600) (42,270) (778,330) 5.15% (124,050) (1,156) (122,894) 0.93% (549,200) (5,572) (543,628) 1.01%
<br /> Nonoperating revenues(expenses):
<br /> Interest income 35,000 - 35,000 0.00% 80,000 - 80,000 0.00% 8,000 - 8,000 0.00% 4,000 - 4,000 0.00%
<br /> Interest expense - - - 0.00% (264,350) - (264,350) 0.00% - - - 0.00% - - - 0.00%
<br /> Total nonoperating revenues(expenses) 35,000 - 35,000 0.00% (184,350) - (184,350) 0.00% 8,000 - 8,000 0.00% 4,000 - 4,000 0.00%
<br /> Income(loss)before contributions and transfers 982,250 372,539 609,711 37.93% (1,004,950) (42,270) (962,680) 4.21% (116,050) (1,156) (114,894) 1.00% (545,200) (5,572) (539,628) 1.02%
<br /> Contributions-connection fees - - - 0.00% 500,000 28,875 471,125 5.78% - - - 0.00% 53,000 - 53,000 0.00%
<br /> Transfers in - - - 0.00% - - - 0.00% 44,600 - 44,600 0.00% - - - 0.00%
<br /> Transfers out (762,850) - (762,850) 0.00% (125,000) - (125,000) 0.00% 46,150 - 46,150 0.00% 15,000 - 15,000 0.00%
<br /> NET INCOME(LOSS) 219,400 372,539 153,139 169.80% (629,950) (13,395) (616,555) 2.13% 117,600 1,156 116,444 0.98% 5079200 5,572 501,628 1.10%
<br /> Items reclassified to balance sheet at year end:
<br /> Capital Outlay (100,500) - (100,500) 0.00% 150,000 - 150,000 0.00%
<br /> Bond Payment (405,000) - (405,000) 0.00%
<br /> Revenues over/(under)expenditures 219,400 372,539 (153,139) (1,135,450) (13,395) (1,122,055) (117,600) (1,156) (116,444) (657,200) (5,572) (651,628) 0.85%
<br /> *Recorded at yearend
<br />
|