|
CITY OF ELK RIVER
<br /> ENTERPRISE FUNDS- BUDGET TO ACTUAL
<br /> MONTH ENDED OCTOBER 31,2012
<br /> Current Year to Date Budget %of Current Year to Date Budget %of Current Year to Date Budget %of
<br /> Budget Actual Variance Budget Budget Actual Variance Budget Budget Actual Variance Budget
<br /> Sales and cost of sales:
<br /> Sales $ 6,250,000 $ 5,242,623 $ 1,007,377 83.88%
<br /> Cost of sales (4,517,250) (3,573,436) (943,814) 79.11%
<br /> Gross profit 1,732,750 1,669,187 63,563 96.33%
<br /> Operating revenues:
<br /> User charges - - - 0.00% $ 1,554,450 $ 1,143,922 $ 410,528 73.59% $ 1,299,000 $ 963,872 $ 335,128 74.20%
<br /> Delinquency collections - - - 0.00% 2,500 (8,858) 11,358 -354.32% 7,000 (7,552) 14,552 -107.89%
<br /> Other 5,000 6,606 (1,606) 132.12% 287,500 3,263 284,237 1.13% 28,600 16,995 11,605 59.42%
<br /> Total operating revenues 5,000 6,606 (1,606) 132.12% 1,844,450 1,138,327 706,123 61.72% 1,334,600 973,315 361,285 72.93%
<br /> Operating expenses:
<br /> Personal services 583,400 477,264 106,136 81.81% 480,550 386,808 93,742 80.49% 52,900 36,185 16,715 68.40%
<br /> Supplies 26,600 14,427 12,173 54.24% 174,900 89,086 85,814 50.94% 10,600 3,842 6,758 36.25%
<br /> Other service charges 226,450 100,759 125,691 44.50% 461,950 376,655 85,295 81.54% 1,260,000 913,176 346,824 72.47%
<br /> Depreciation* 123,150 - 123,150 0.00% 993,600 - 993,600 0.00% - - - 0.00%
<br /> Total operating expenses 959,600 592,450 367,150 61.74% 2,111,000 852,549 1,258,451 40.39% 1,323,500 953,203 370,297 72.02%
<br /> Operating income(loss) 778,150 1,083,343 (305,193) 139.22% (266,550) 285,778 (552,328) -107.21% 11,100 20,112 (9,012) 181.19%
<br /> Nonoperating revenues(expenses):
<br /> Interest income 25,250 10,579 14,671 41.90% 48,550 37,032 11,518 76.28% 5,000 4,192 808 83.84%
<br /> Miscellaneous revenue 0.00% - - 0.00% - 17,902 (17,902) 0.00%
<br /> Interest expense (29,250) (13,425) (15,825) 45.90% (31,050) (17,268) (13,782) 55.61% - - - 0.00%
<br /> Total nonoperating revenues(expenses) (4,000) (2,846) (1,154) 71.15% 17,500 19,764 (2,264) 112.94% 5,000 22,094 (17,094) 441.88%
<br /> Income(loss)before contributions and transfers 774,150 1,080,497 (306,347) 139.57% (249,050) 305,542 (554,592) -122.68% 16,100 42,206 (26,106) 262.15%
<br /> Contributions-connection fees - - - 0.00% 111,400 238,239 (126,839) 213.86% - - - 0.00%
<br /> Transfers in - - - 0.00% - - - 0.00% 37,000 - 37,000 0.00%
<br /> Transfers out (394,350) (408,510) 14,160 103.59% (115,000) (115,000) - 100.00% (25,000) (25,000) - 100.00%
<br /> NET INCOME(LOSS) 379,800 671,987 (292,187) 176.93% (252,650) 428,781 (681,431) -169.71% 28,100 17,206 10,894 61.23%
<br /> Items reclassified to balance sheet at year end:
<br /> Capital Outlay (55,000) (40,690) (14,310) 73.98% (1,041,500) (133,374) (908,126) 12.81%
<br /> Bond Payment (730,000) (730,000) - 100.00% (170,000) (170,000) - 100.00%
<br /> Revenues over/(under)expenditures (405,200) (98,703) (306,497) (1,464,150) 125,407 (1,589,557) 28,100 17,206 10,894
<br /> *Recorded at year end
<br />
|