|
<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$ 4,564,002$ 2,440,148$ 65.16%
<br /> Cost of sales (5,008,100) (2,963,048) (2,045,052) 59.17%
<br /> Gross profit 1,996,050 1,600,954 395,096 80.21%
<br />Operating revenues:
<br /> User charges - - - 0.00%1,915,000$ 1,165,630$ 749,370$ 60.87%1,366,000$ 786,506$ 579,494$ 57.58%445,000$ 266,481$ 178,519$ 59.88%
<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 1,600 100 94.12%2,000 24,166 (22,166) 1208.30%2,500 638 1,862 25.52%- - - 0.00%
<br /> Total operating revenues 1,700 1,600 100 94.12%1,919,000 1,190,408 728,592 62.03%1,379,000 790,728 588,272 57.34%445,000 267,754 177,246 60.17%
<br />Operating expenses:
<br /> Personal services 663,300 435,403 227,897 65.64%550,800 364,224 186,576 66.13%24,450 13,021 11,429 53.26%86,000 49,559 36,441 57.63%
<br /> Supplies 20,700 9,125 11,575 44.08%206,800 90,504 116,296 43.76%21,400 15,818 5,582 73.92%2,000 64 1,936 3.20%
<br /> Other service charges 241,500 159,179 82,321 65.91%552,000 354,849 197,151 64.28%1,457,200 854,563 602,637 58.64%458,200 224,362 233,838 48.97%
<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 603,707 446,793 57.47%2,734,600 809,577 1,925,023 29.60%1,503,050 883,402 619,648 58.77%994,200 273,985 720,215 27.56%
<br />Operating income (loss)947,250 998,847 (51,597) 105.45%(815,600) 380,831 (1,196,431) -46.69%(124,050) (92,674) (31,376) 74.71%(549,200) (6,231) (542,969) 1.13%
<br />Nonoperating revenues (expenses):
<br /> Interest income 35,000 35,601 (601) 101.72%80,000 35,199 44,801 44.00%8,000 3,298 4,702 41.23%4,000 4,173 (173) 104.33%
<br /> Grant revenue - - - 0.00%- 129,339 (129,339) 0.00%- - - 0.00%- - - 0.00%
<br /> Interest expense - - - 0.00%(264,350) (152,520) (111,830) 57.70%- - - 0.00%- - - 0.00%
<br /> Total nonoperating revenues (expenses)35,000 35,601 (601) 101.72%(184,350) 12,018 (196,368) -6.52%8,000 3,298 4,702 41.23%4,000 4,173 (173) 104.33%
<br />Income (loss) before contributions and transfers 982,250 1,034,448 (52,198) 105.31%(999,950) 392,849 (1,392,799) -39.29%(116,050) (89,376) (26,674) 77.02%(545,200) (2,058) (543,142) 0.38%
<br />Contributions - connection fees - - - 0.00%500,000 842,148 (342,148) 168.43%- - - 0.00%53,000 44,753 8,247 84.44%
<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 323,582 (104,182) 147.48%(629,950) 1,104,997 (1,734,947) -175.41%(117,600) (135,526) 17,926 115.24%(507,200) 27,695 (534,895) -5.46%
<br />Items reclassified to balance sheet at year end:
<br /> Capital Outlay (100,500) (1,344,672) 1,244,172 1337.98%(150,000) - (150,000) 0.00%
<br /> Bond Payment (405,000) (405,000) - 100.00%
<br />Revenues over/(under) expenditures 219,400 323,582 (104,182) (1,135,450) (644,675) (490,775) (117,600) (135,526) 17,926 (657,200) 27,695 (684,895) -4.21%
<br /> * Recorded at yearend
<br />Stormwater
<br />CITY OF ELK RIVER
<br />ENTERPRISE FUNDS - BUDGET TO ACTUAL
<br />MONTH ENDED AUGUST 31, 2017
<br />Liquor Sewer Garbage
|