|
<br />
<br />Current
<br /> Budget
<br />
<br /> Year to Date
<br />Actual
<br /> Budget
<br />Variance
<br /> % of
<br /> Budget
<br />
<br /> Current
<br /> Budget
<br />
<br /> Year to Date
<br />Actual
<br /> Budget
<br />Variance
<br /> % of
<br /> Budget
<br />
<br /> Current
<br /> Budget
<br />
<br /> Year to Date
<br />Actual
<br /> Budget
<br />Variance
<br /> % of
<br /> Budget
<br />
<br /> Current
<br /> Budget
<br />
<br /> Year to Date
<br />Actual
<br /> Budget
<br />Variance
<br /> % of
<br /> Budget
<br />Sales and cost of sales:
<br /> Sales 7,004,150$ 3,334,637$ 3,669,513$ 47.61%
<br /> Cost of sales (5,008,100) (1,953,176) (3,054,924) 39.00%
<br /> Gross profit 1,996,050 1,381,461 614,589 69.21%
<br />Operating revenues:
<br /> User charges - - - 0.00%1,915,000$ 843,712$ 1,071,288$ 44.06%1,366,000$ 560,102$ 805,898$ 41.00%445,000$ 234,921$ 210,079$ 52.79%
<br /> Delinquency collections - - - 0.00%2,000 - 2,000 0.00%10,500 - 10,500 0.00%- - - 0.00%
<br /> Other 1,700 1,600 100 94.12%2,000 - 2,000 0.00%2,500 590 1,910 23.60%- - - 0.00%
<br /> Total operating revenues 1,700 1,600 100 94.12%1,919,000 843,712 1,075,288 43.97%1,379,000 560,692 818,308 40.66%445,000 234,921 210,079 52.79%
<br />Operating expenses:
<br /> Personal services 663,300 328,012 335,288 49.45%555,800 276,054 279,746 49.67%24,450 9,713 14,737 39.73%86,000 37,218 48,782 43.28%
<br /> Supplies 20,700 7,849 12,851 37.92%206,800 49,018 157,782 23.70%21,400 648 20,752 3.03%2,000 - 2,000 0.00%
<br /> Other service charges 241,500 100,332 141,168 41.55%552,000 322,371 229,629 58.40%1,457,200 597,730 859,470 41.02%458,200 217,451 240,749 47.46%
<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 436,193 614,307 41.52%2,739,600 647,443 2,092,157 23.63%1,503,050 608,091 894,959 40.46%994,200 254,669 739,531 25.62%
<br />Operating income (loss)947,250 946,868 382 99.96%(820,600) 196,269 (1,016,869) -23.92%(124,050) (47,399) (76,651) 38.21%(549,200) (19,748) (529,452) 3.60%
<br />Nonoperating revenues (expenses):
<br /> Interest income 35,000 29,966 5,034 85.62%80,000 29,217 50,783 36.52%8,000 2,779 5,221 34.74%4,000 3,436 564 85.90%
<br /> Grant revenue - - - 0.00%- 118,838 (118,838) 0.00%- - - 0.00%- - - 0.00%
<br /> Interest expense - - - 0.00%(264,350) (22,368) (241,982) 8.46%- - - 0.00%- - - 0.00%
<br /> Total nonoperating revenues (expenses)35,000 29,966 5,034 85.62%(184,350) 125,687 (310,037) -68.18%8,000 2,779 5,221 34.74%4,000 3,436 564 85.90%
<br />Income (loss) before contributions and transfers 982,250 976,834 5,416 99.45%(1,004,950) 321,956 (1,326,906) -32.04%(116,050) (44,620) (71,430) 38.45%(545,200) (16,312) (528,888) 2.99%
<br />Contributions - connection fees - - - 0.00%500,000 689,172 (189,172) 137.83%- - - 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) (228,016) (534,834) 29.89%(125,000) - (125,000) 0.00%(46,150) - (46,150) 0.00%(15,000) - (15,000) 0.00%
<br />NET INCOME (LOSS)219,400 748,818 (529,418) 341.30%(629,950) 1,011,128 (1,641,078) -160.51%(117,600) (44,620) (72,980) 37.94%(507,200) (16,312) (490,888) 3.22%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (100,500) (1,005,184) 904,684 1000.18%(150,000) - (150,000) 0.00%
<br /> Bond Payment (405,000) (405,000) - 100.00%
<br />Revenues over/(under) expenditures 219,400 748,818 (529,418) (1,135,450) (399,056) (736,394) (117,600) (44,620) (72,980) (657,200) (16,312) (640,888) 2.48%
<br /> * Recorded at yearend
<br />Stormwater
<br />CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED JUNE 30, 2017
<br />Liquor Sewer Garbage
|