|
<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$ 6,206,892$ 797,258$ 88.62%
<br /> Cost of sales (5,008,100) (4,103,444) (904,656) 81.94%
<br /> Gross profit 1,996,050 2,103,448 (107,398) 105.38%
<br />Operating revenues:
<br /> User charges - - - 0.00%1,915,000$ 1,683,979$ 231,021$ 87.94%1,366,000$ 1,126,079$ 239,921$ 82.44%445,000$ 381,234$ 63,766$ 85.67%
<br /> Delinquency collections - - - 0.00%2,000 612 1,388 30.60%10,500 3,584 6,916 34.13%- 1,273 (1,273) 0.00%
<br /> Other 1,700 4,220 (2,520) 248.24%2,000 51,799 (49,799) 2589.95%2,500 919 1,581 36.76%- - - 0.00%
<br /> Total operating revenues 1,700 4,220 (2,520) 248.24%1,919,000 1,736,390 182,610 90.48%1,379,000 1,130,582 248,418 81.99%445,000 382,507 62,493 85.96%
<br />Operating expenses:
<br /> Personal services 663,300 597,748 65,552 90.12%550,800 493,183 57,617 89.54%24,450 18,123 6,327 74.12%86,000 68,134 17,866 79.23%
<br /> Supplies 20,700 11,243 9,457 54.31%206,800 146,399 60,401 70.79%21,400 16,048 5,352 74.99%2,000 188 1,812 9.40%
<br /> Other service charges 241,500 221,769 19,731 91.83%552,000 495,405 56,595 89.75%1,457,200 1,233,571 223,629 84.65%458,200 236,338 221,862 51.58%
<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 830,760 219,740 79.08%2,734,600 1,134,987 1,599,613 41.50%1,503,050 1,267,742 235,308 84.34%994,200 304,660 689,540 30.64%
<br />Operating income (loss)947,250 1,276,908 (329,658) 134.80%(815,600) 601,403 (1,417,003) -73.74%(124,050) (137,160) 13,110 110.57%(549,200) 77,847 (627,047) -14.17%
<br />Nonoperating revenues (expenses):
<br /> Interest income 35,000 51,774 (16,774) 147.93%80,000 51,523 28,477 64.40%8,000 4,451 3,549 55.64%4,000 6,513 (2,513) 162.83%
<br /> Grant revenue - - - 0.00%- 163,561 (163,561) 0.00%- - - 0.00%- - - 0.00%
<br /> Interest expense - - - 0.00%(264,350) (152,970) (111,380) 57.87%- - - 0.00%- - - 0.00%
<br /> Total nonoperating revenues (expenses)35,000 51,774 (16,774) 147.93%(184,350) 62,114 (246,464) -33.69%8,000 4,451 3,549 55.64%4,000 6,513 (2,513) 162.83%
<br />Income (loss) before contributions and transfers 982,250 1,328,682 (346,432) 135.27%(999,950) 663,517 (1,663,467) -66.36%(116,050) (132,709) 16,659 114.36%(545,200) 84,360 (629,560) -15.47%
<br />Contributions - connection fees - - - 0.00%500,000 993,273 (493,273) 198.65%- - - 0.00%53,000 51,344 1,656 96.88%
<br />Transfers in - - - 0.00%- - - 0.00%44,600 - 44,600 0.00%- - - 0.00%
<br />Transfers out (762,850) (710,866) (51,984) 93.19%(130,000) (130,000) - 100.00%(46,150) (46,150) - 100.00%(15,000) (15,000) - 100.00%
<br />NET INCOME (LOSS)219,400 617,816 (398,416) 281.59%(629,950) 1,526,790 (2,156,740) -242.37%(117,600) (178,859) 61,259 152.09%(507,200) 120,704 (627,904) -23.80%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (100,500) (563,409) 462,909 560.61%(150,000) - (150,000) 0.00%
<br /> Bond Payment (405,000) (405,000) - 100.00%
<br />Revenues over/(under) expenditures 219,400 617,816 (398,416) (1,135,450) 558,381 (1,693,831) (117,600) (178,859) 61,259 (657,200) 120,704 (777,904) -18.37%
<br /> * Recorded at yearend
<br />Stormwater
<br />CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED NOVEMBER 30, 2017
<br />Liquor Sewer Garbage
|