|
<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$ 5,106,133$ 1,898,017$ 72.90%
<br /> Cost of sales (5,008,100) (3,276,480) (1,731,620) 65.42%
<br /> Gross profit 1,996,050 1,829,653 166,397 91.66%
<br />Operating revenues:
<br /> User charges - - - 0.00%1,915,000$ 1,340,065$ 574,935$ 69.98%1,366,000$ 899,401$ 466,599$ 65.84%445,000$ 304,724$ 140,276$ 68.48%
<br /> Delinquency collections - - - 0.00%2,000 612 1,388 30.60%10,500 3,584 6,916 34.13%- 1,273 (1,273) 0.00%
<br /> Other 1,700 3,920 (2,220) 230.59%2,000 34,058 (32,058) 1702.90%2,500 645 1,855 25.80%- - - 0.00%
<br /> Total operating revenues 1,700 3,920 (2,220) 230.59%1,919,000 1,374,735 544,265 71.64%1,379,000 903,630 475,370 65.53%445,000 305,997 139,003 68.76%
<br />Operating expenses:
<br /> Personal services 663,300 487,316 175,984 73.47%550,800 406,000 144,800 73.71%24,450 14,682 9,768 60.05%86,000 55,730 30,270 64.80%
<br /> Supplies 20,700 9,738 10,962 47.04%206,800 108,159 98,641 52.30%21,400 15,818 5,582 73.92%2,000 64 1,936 3.20%
<br /> Other service charges 241,500 180,408 61,092 74.70%552,000 407,979 144,021 73.91%1,457,200 983,633 473,567 67.50%458,200 226,856 231,344 49.51%
<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 677,462 373,038 64.49%2,734,600 922,138 1,812,462 33.72%1,503,050 1,014,133 488,917 67.47%994,200 282,650 711,550 28.43%
<br />Operating income (loss)947,250 1,156,111 (208,861) 122.05%(815,600) 452,597 (1,268,197) -55.49%(124,050) (110,503) (13,547) 89.08%(549,200) 23,347 (572,547) -4.25%
<br />Nonoperating revenues (expenses):
<br /> Interest income 35,000 45,640 (10,640) 130.40%80,000 45,372 34,628 56.72%8,000 4,117 3,883 51.46%4,000 5,622 (1,622) 140.55%
<br /> Grant revenue - - - 0.00%- 163,561 (163,561) 0.00%- - - 0.00%- - - 0.00%
<br /> Interest expense - - - 0.00%(264,350) (152,970) (111,380) 57.87%- - - 0.00%- - - 0.00%
<br /> Total nonoperating revenues (expenses)35,000 45,640 (10,640) 130.40%(184,350) 55,963 (240,313) -30.36%8,000 4,117 3,883 51.46%4,000 5,622 (1,622) 140.55%
<br />Income (loss) before contributions and transfers 982,250 1,201,751 (219,501) 122.35%(999,950) 508,560 (1,508,510) -50.86%(116,050) (106,386) (9,664) 91.67%(545,200) 28,969 (574,169) -5.31%
<br />Contributions - connection fees - - - 0.00%500,000 905,523 (405,523) 181.10%- - - 0.00%53,000 49,140 3,860 92.72%
<br />Transfers in - - - 0.00%- - - 0.00%44,600 - 44,600 0.00%- - - 0.00%
<br />Transfers out (762,850) (710,866) (51,984) 93.19%(130,000) (130,000) - 100.00%(46,150) (46,150) - 100.00%(15,000) (15,000) - 100.00%
<br />NET INCOME (LOSS)219,400 490,885 (271,485) 223.74%(629,950) 1,284,083 (1,914,033) -203.84%(117,600) (152,536) 34,936 129.71%(507,200) 63,109 (570,309) -12.44%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (100,500) (543,657) 443,157 540.95%(150,000) - (150,000) 0.00%
<br /> Bond Payment (405,000) (405,000) - 100.00%
<br />Revenues over/(under) expenditures 219,400 490,885 (271,485) (1,135,450) 335,426 (1,470,876) (117,600) (152,536) 34,936 (657,200) 63,109 (720,309) -9.60%
<br /> * Recorded at yearend
<br />Stormwater
<br />CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED SEPTEMBER 30, 2017
<br />Liquor Sewer Garbage
|