|
<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$ 4,003,848$ 3,097,452$ 56.38%
<br /> Cost of sales (5,059,100) (2,574,409) (2,484,691) 50.89%
<br /> Gross profit 2,042,200 1,429,439 612,761 70.00%
<br />Operating revenues:
<br /> User charges - - - 0.00%2,020,000$ 1,054,723$ 965,277$ 52.21%1,550,000$ 771,960$ 778,040$ 49.80%468,000$ 241,136$ 226,864$ 51.52%
<br /> Delinquency collections - - - 0.00%2,000 354 1,646 17.70%8,000 1,276 6,724 15.95%- 224 (224) 0.00%
<br /> Other 1,700 622 1,078 36.59%100,000 109,063 (9,063) 109.06%1,500 327 1,173 0.00%- - - 0.00%
<br /> Total operating revenues 1,700 622 1,078 36.59%2,122,000 1,164,140 957,860 54.86%1,559,500 773,563 785,937 49.60%468,000 241,360 226,640 51.57%
<br />Operating expenses:
<br /> Personal services 729,050 410,371 318,679 56.29%640,500 324,938 315,562 50.73%23,400 12,761 10,639 54.53%84,100 45,590 38,510 54.21%
<br /> Supplies 20,400 10,885 9,515 53.36%195,000 146,596 48,404 75.18%21,400 2,138 19,262 9.99%2,000 130 1,870 6.50%
<br /> Other service charges 259,550 128,731 130,819 49.60%626,950 351,429 275,521 56.05%1,553,650 760,814 792,836 48.97%187,050 30,796 156,254 16.46%
<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 549,987 584,013 48.50%2,887,450 822,963 2,064,487 28.50%1,598,450 775,713 822,737 48.53%721,150 76,516 644,634 10.61%
<br />Operating income (loss)909,900 880,074 29,826 96.72%(765,450) 341,177 (1,106,627) -44.57%(38,950) (2,150) (36,800) 5.52%(253,150) 164,844 (417,994) -65.12%
<br />Nonoperating revenues (expenses):
<br /> Interest income 35,000 42,720 (7,720) 122.06%80,000 38,621 41,379 48.28%8,000 2,642 5,358 33.03%5,000 5,905 (905) 118.10%
<br /> Interest expense - - - 0.00%(256,150) (21,693) (234,457) 8.47%- - - 0.00%- - - 0.00%
<br /> Total nonoperating revenues (expenses)35,000 42,720 (7,720) 122.06%(176,150) 16,928 (193,078) -9.61%8,000 2,642 5,358 33.03%5,000 5,905 (905) 118.10%
<br />Income (loss) before contributions and transfers 944,900 922,794 22,106 97.66%(941,600) 358,105 (1,299,705) -38.03%(30,950) 492 (31,442) -1.59%(248,150) 170,749 (418,899) -68.81%
<br />Contributions - connection fees - - - 0.00%500,000 771,815 (271,815) 154.36%- - - 0.00%27,000 34,688 (7,688) 128.47%
<br />Transfers in - - - 0.00%- - - 0.00%45,000 - 45,000 0.00%- - - 0.00%
<br />Transfers out (742,000) (689,174) (52,826) 92.88%(150,000) (150,000) - 100.00%(46,750) (46,750) - 100.00%(35,000) (35,000) - 100.00%
<br />NET INCOME (LOSS)202,900 233,620 (30,720) 115.14%(591,600) 979,920 (1,571,520) -165.64%(32,700) (46,258) 13,558 141.46%(256,150) 170,437 (426,587) -66.54%
<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 233,620 (30,720) (1,372,850) 365,268 (1,738,118) (32,700) (46,258) 13,558 (256,150) 170,437 (426,587) -66.54%
<br /> * Recorded at yearend
<br />Stormwater
<br />CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED JULY 31, 2018
<br />Liquor Sewer Garbage
|