|
<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$ 2,005,297$ 4,998,853$ 28.63%
<br /> Cost of sales (5,008,100) (1,046,509) (3,961,591) 20.90%
<br /> Gross profit 1,996,050 958,788 1,037,262 48.03%
<br />Operating revenues:
<br /> User charges - - - 0.00%1,915,000$ 478,214$ 1,436,786$ 24.97%1,366,000$ 333,805$ 1,032,195$ 24.44%445,000$ 114,011$ 330,989$ 25.62%
<br /> Delinquency collections - - - 0.00%2,000 - 2,000 0.00%10,500 - 10,500 0.00%- - - 0.00%
<br /> Other 1,700 1,300 400 76.47%2,000 - 2,000 0.00%2,500 364 2,136 14.56%- - - 0.00%
<br /> Total operating revenues 1,700 1,300 400 76.47%1,919,000 478,214 1,440,786 24.92%1,379,000 334,169 1,044,831 24.23%445,000 114,011 330,989 25.62%
<br />Operating expenses:
<br /> Personal services 663,300 198,180 465,120 29.88%555,800 165,467 390,333 29.77%24,450 5,667 18,783 23.18%86,000 22,597 63,403 26.28%
<br /> Supplies 20,700 3,786 16,914 18.29%206,800 26,441 180,359 12.79%21,400 54 21,346 0.25%2,000 - 2,000 0.00%
<br /> Other service charges 241,500 57,510 183,990 23.81%552,000 137,927 414,073 24.99%1,457,200 352,543 1,104,657 24.19%458,200 209,147 249,053 45.65%
<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 259,476 791,024 24.70%2,739,600 329,835 2,409,765 12.04%1,503,050 358,264 1,144,786 23.84%994,200 231,744 762,456 23.31%
<br />Operating income (loss)947,250 700,612 246,638 73.96%(820,600) 148,379 (968,979) -18.08%(124,050) (24,095) (99,955) 19.42%(549,200) (117,733) (431,467) 21.44%
<br />Nonoperating revenues (expenses):
<br /> Interest income 35,000 16,566 18,434 47.33%80,000 16,857 63,143 21.07%8,000 1,473 6,527 18.41%4,000 2,067 1,933 51.68%
<br /> Grant revenue - - - 0.00%- 40,887 (40,887) 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 16,566 18,434 47.33%(184,350) 35,376 (219,726) -19.19%8,000 1,473 6,527 18.41%4,000 2,067 1,933 51.68%
<br />Income (loss) before contributions and transfers 982,250 717,178 265,072 73.01%(1,004,950) 183,755 (1,188,705) -18.28%(116,050) (22,622) (93,428) 19.49%(545,200) (115,666) (429,534) 21.22%
<br />Contributions - connection fees - - - 0.00%500,000 373,705 126,295 74.74%- - - 0.00%53,000 27,837 25,163 52.52%
<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 717,178 (497,778) 326.88%(629,950) 557,460 (1,187,410) -88.49%(117,600) (22,622) (94,978) 19.24%(507,200) (87,829) (419,371) 17.32%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (100,500) (821,370) 720,870 817.28%(150,000) - (150,000) 0.00%
<br /> Bond Payment (405,000) (405,000) - 100.00%
<br />Revenues over/(under) expenditures 219,400 717,178 (497,778) (1,135,450) (668,910) (466,540) (117,600) (22,622) (94,978) (657,200) (87,829) (569,371) 13.36%
<br /> * Recorded at yearend
<br />Stormwater
<br />CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED APRIL 30, 2017
<br />Liquor Sewer Garbage
|