|
<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$ 3,337,998$ 3,763,302$ 47.01%
<br /> Cost of sales (5,059,100) (2,119,220) (2,939,880) 41.89%
<br /> Gross profit 2,042,200 1,218,778 823,422 59.68%
<br />Operating revenues:
<br /> User charges - - - 0.00%2,020,000$ 877,968$ 1,142,032$ 43.46%1,550,000$ 641,801$ 908,199$ 41.41%468,000$ 200,521$ 267,479$ 42.85%
<br /> Delinquency collections - - - 0.00%2,000 - 2,000 0.00%8,000 - 8,000 0.00%- - - 0.00%
<br /> Other 1,700 622 1,078 36.59%100,000 60,208 39,792 60.21%- 306 (306) 0.00%- - - 0.00%
<br /> Total operating revenues 1,700 622 1,078 36.59%2,122,000 938,176 1,183,824 44.21%1,558,000 642,107 915,893 41.21%468,000 200,521 267,479 42.85%
<br />Operating expenses:
<br /> Personal services 729,050 344,532 384,518 47.26%640,500 274,252 366,248 42.82%23,400 10,880 12,520 46.50%84,100 38,945 45,155 46.31%
<br /> Supplies 20,400 10,297 10,103 50.48%195,000 121,739 73,261 62.43%21,400 2,030 19,370 9.49%2,000 130 1,870 6.50%
<br /> Other service charges 259,550 103,841 155,709 40.01%626,950 256,969 369,981 40.99%1,553,650 622,261 931,389 40.05%187,050 22,285 164,765 11.91%
<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 458,670 675,330 40.45%2,887,450 652,960 2,234,490 22.61%1,598,450 635,171 963,279 39.74%721,150 61,360 659,790 8.51%
<br />Operating income (loss)909,900 760,730 149,170 83.61%(765,450) 285,216 (1,050,666) -37.26%(40,450) 6,936 (47,386) -17.15%(253,150) 139,161 (392,311) -54.97%
<br />Nonoperating revenues (expenses):
<br /> Interest income 35,000 37,258 (2,258) 106.45%80,000 33,335 46,665 41.67%8,000 2,302 5,698 28.78%5,000 5,039 (39) 100.78%
<br /> Interest expense - - - 0.00%(256,150) (21,693) (234,457) 8.47%- - - 0.00%- - - 0.00%
<br /> Total nonoperating revenues (expenses)35,000 37,258 (2,258) 106.45%(176,150) 11,642 (187,792) -6.61%8,000 2,302 5,698 28.78%5,000 5,039 (39) 100.78%
<br />Income (loss) before contributions and transfers 944,900 797,988 146,912 84.45%(941,600) 296,858 (1,238,458) -31.53%(32,450) 9,238 (41,688) -28.47%(248,150) 144,200 (392,350) -58.11%
<br />Contributions - connection fees - - - 0.00%500,000 470,276 29,724 94.06%- - - 0.00%27,000 34,688 (7,688) 128.47%
<br />Transfers in - - - 0.00%- - - 0.00%46,500 - 46,500 0.00%- - - 0.00%
<br />Transfers out (742,000) (197,174) (544,826) 26.57%(150,000) - (150,000) 0.00%(46,750) - (46,750) 0.00%(35,000) (20,000) (15,000) 57.14%
<br />NET INCOME (LOSS)202,900 600,814 (397,914) 296.11%(591,600) 767,134 (1,358,734) -129.67%(32,700) 9,238 (41,938) -28.25%(256,150) 158,888 (415,038) -62.03%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (366,250) (199,652) (166,598) 54.51%
<br /> Bond Payment (415,000) (415,000) - 100.00%
<br />Revenues over/(under) expenditures 202,900 600,814 (397,914) (1,372,850) 152,482 (1,525,332) (32,700) 9,238 (41,938) (256,150) 158,888 (415,038) -62.03%
<br /> * Recorded at yearend
<br />Stormwater
<br />CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED JUNE 30, 2018
<br />Liquor Sewer Garbage
|