|
<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,101,300$ 942,181$ 6,159,119$ 13.27%
<br /> Cost of sales (5,059,100) (417,981) (4,641,119) 8.26%
<br /> Gross profit 2,042,200 524,200 1,518,000 25.67%
<br />Operating revenues:
<br /> User charges - - - 0.00%2,020,000$ 172,941$ 1,847,059$ 8.56%1,550,000$ 127,944$ 1,422,056$ 8.25%468,000$ 38,483$ 429,517$ 8.22%
<br /> Delinquency collections - - - 0.00%2,000 - 2,000 0.00%8,000 - 8,000 0.00%- - - 0.00%
<br /> Other 1,700 22 1,678 1.29%100,000 14,000 86,000 14.00%- - - 0.00%- - - 0.00%
<br /> Total operating revenues 1,700 22 1,678 1.29%2,122,000 186,941 1,935,059 8.81%1,558,000 127,944 1,430,056 8.21%468,000 38,483 429,517 8.22%
<br />Operating expenses:
<br /> Personal services 729,050 98,745 630,305 13.54%640,500 82,261 558,239 12.84%23,400 3,105 20,295 13.27%84,100 11,117 72,983 13.22%
<br /> Supplies 20,400 742 19,658 3.64%195,000 23,906 171,094 12.26%21,400 858 20,542 4.01%2,000 - 2,000 0.00%
<br /> Other service charges 259,550 24,079 235,471 9.28%626,950 55,623 571,327 8.87%1,553,650 129,044 1,424,606 8.31%187,050 2,063 184,987 1.10%
<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,134,000 123,566 1,010,434 10.90%2,887,450 161,790 2,725,660 5.60%1,598,450 133,007 1,465,443 8.32%721,150 13,180 707,970 1.83%
<br />Operating income (loss)909,900 400,656 509,244 44.03%(765,450) 25,151 (790,601) -3.29%(40,450) (5,063) (35,387) 12.52%(253,150) 25,303 (278,453) -10.00%
<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%5,000 - 5,000 0.00%
<br /> Interest expense - - - 0.00%(256,150) (21,693) (234,457) 8.47%- - - 0.00%- - - 0.00%
<br /> Total nonoperating revenues (expenses)35,000 - 35,000 0.00%(176,150) (21,693) (154,457) 12.32%8,000 - 8,000 0.00%5,000 - 5,000 0.00%
<br />Income (loss) before contributions and transfers 944,900 400,656 544,244 42.40%(941,600) 3,458 (945,058) -0.37%(32,450) (5,063) (27,387) 15.60%(248,150) 25,303 (273,453) -10.20%
<br />Contributions - connection fees - - - 0.00%500,000 49,475 450,525 9.90%- - - 0.00%27,000 - 27,000 0.00%
<br />Transfers in - - - 0.00%- - 0.00%46,500 - 46,500 0.00%- - - 0.00%
<br />Transfers out (742,000) - (742,000) 0.00%(150,000) - (150,000) 0.00%(46,750) - (46,750) 0.00%(35,000) - (35,000) 0.00%
<br />NET INCOME (LOSS)202,900 400,656 (197,756) 197.46%(591,600) 52,933 (644,533) -8.95%(32,700) (5,063) (27,637) 15.48%(256,150) 25,303 (281,453) -9.88%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (366,250) (52,577) (313,673) 14.36%
<br /> Bond Payment (415,000) (415,000) - 100.00%
<br />Revenues over/(under) expenditures 202,900 400,656 (197,756) (1,372,850) (414,644) (958,206) (32,700) (5,063) (27,637) (256,150) 25,303 (281,453) -9.88%
<br /> * Recorded at yearend
<br />Stormwater
<br />CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED FEBRUARY 28, 2018
<br />Liquor Sewer Garbage
|