|
<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$ 468,705$ 6,632,595$ 6.60%
<br /> Cost of sales (5,059,100) (36,502) (5,022,598) 0.72%
<br /> Gross profit 2,042,200 432,203 1,609,997 21.16%
<br />Operating revenues:
<br /> User charges - - - 0.00%2,020,000$ -$ 2,020,000$ 0.00%1,550,000$ 6$ 1,549,994$ 0.00%468,000$ -$ 468,000$ 0.00%
<br /> Delinquency collections - - - 0.00%2,000 22 1,978 1.10%8,000 491 7,509 6.14%- (42) 42 0.00%
<br /> Other 1,700 - 1,700 0.00%100,000 14,000 86,000 14.00%- - - 0.00%- - - 0.00%
<br /> Total operating revenues 1,700 - 1,700 0.00%2,122,000 14,022 2,107,978 0.66%1,558,000 497 1,557,503 0.03%468,000 (42) 468,042 -0.01%
<br />Operating expenses:
<br /> Personal services 729,050 44,326 684,724 6.08%640,500 36,470 604,030 5.69%23,400 1,356 22,044 5.79%84,100 4,885 79,215 5.81%
<br /> Supplies 20,400 166 20,234 0.81%195,000 2,625 192,375 1.35%21,400 - 21,400 0.00%2,000 - 2,000 0.00%
<br /> Other service charges 259,550 5,413 254,137 2.09%626,950 30,921 596,029 4.93%1,553,650 4,400 1,549,250 0.28%187,050 - 187,050 0.00%
<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 49,905 1,084,095 4.40%2,887,450 70,016 2,817,434 2.42%1,598,450 5,756 1,592,694 0.36%721,150 4,885 716,265 0.68%
<br />Operating income (loss)909,900 382,298 527,602 42.02%(765,450) (55,994) (709,456) 7.32%(40,450) (5,259) (35,191) 13.00%(253,150) (4,927) (248,223) 1.95%
<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) - (256,150) 0.00%- - - 0.00%- - - 0.00%
<br /> Total nonoperating revenues (expenses)35,000 - 35,000 0.00%(176,150) - (176,150) 0.00%8,000 - 8,000 0.00%5,000 - 5,000 0.00%
<br />Income (loss) before contributions and transfers 944,900 382,298 562,602 40.46%(941,600) (55,994) (885,606) 5.95%(32,450) (5,259) (27,191) 16.21%(248,150) (4,927) (243,223) 1.99%
<br />Contributions - connection fees - - - 0.00%500,000 20,250 479,750 4.05%- - - 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 382,298 (179,398) 188.42%(591,600) (35,744) (555,856) 6.04%(32,700) (5,259) (27,441) 16.08%(256,150) (4,927) (251,223) 1.92%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (366,250) (41,107) (325,143) 11.22%
<br /> Bond Payment (415,000) - (415,000) 0.00%
<br />Revenues over/(under) expenditures 202,900 382,298 (179,398) (1,372,850) (76,851) (1,295,999) (32,700) (5,259) (27,441) (256,150) (4,927) (251,223) 1.92%
<br /> * Recorded at yearend
<br />Stormwater
<br />CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED JANUARY 31, 2018
<br />Liquor Sewer Garbage
|