|
CITY OF ELK RIVER
<br /> ENTERPRISE FUNDS- BUDGET TO ACTUAL
<br /> MONTH ENDED NOVEMBER 30,2012
<br /> H
<br /> is f
<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,793,481 $ 456,519 92.70%
<br /> Cost of sales (4,517,250) (4,002,546) (514,704) 88.61%
<br /> Gross profit 1,732,750 1,790,935 (58,185) 103.36%
<br /> Operating revenues:
<br /> User charges - - - 0.00% $ 1,554,450 $ 1,273,387 $ 281,063 81.92% $ 1,299,000 $ 1,073,218 $ 225,782 82.62%
<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,786 (1,786) 135.72% 287,500 3,263 284,237 1.13% 28,600 17,030 11,570 59.55%
<br /> Total operating revenues 5,000 6,786 (1,786) 135.72% 1,844,450 1,267,792 576,658 68.74% 1,334,600 1,082,696 251,904 81.13%
<br /> Operating expenses:
<br /> Personal services 583,400 522,260 61,140 89.52% 480,550 423,214 57,336 88.07% 52,900 38,490 14,410 72.76%
<br /> Supplies 26,600 14,867 11,733 55.89% 174,900 93,730 81,170 53.59% 10,600 3,892 6,708 36.72%
<br /> Other service charges 226,450 125,112 101,338 55.25% 461,950 412,427 49,523 89.28% 1,260,000 1,019,657 240,343 80.93%
<br /> Depreciation* 123,150 - 123,150 0.00% 993,600 - 993,600 0.00% - - - 0.00%
<br /> Total operating expenses 959,600 662,239 297,361 69.01% 2,111,000 929,371 1,181,629 44.03% 1,323,500 1,062,039 261,461 80.24%
<br /> Operating income(loss) 778,150 1,135,482 (357,332) 145.92% (266,550) 338,421 (604,971) -126.96% 11,100 20,657 (9,557) 186.10%
<br /> Nonoperating revenues(expenses):
<br /> Interest income 25,250 11,588 13,662 45.89% 48,550 41,055 7,495 84,56% 5,000 4,643 357 92.86%
<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) (1,837) (2,163) 45.93% 17,500 23,787 (6,287) 135.93% 5,000 22,545 (17,545) 450.90%
<br /> Income(loss)before contributions and transfers 774,150 1,133,645 (359,495) 146.44% (249,050) 362,208 (611,258) -145.44% 16,100 43,202 (27,102) 268.34%
<br /> Contributions-connection fees - - - 0.00% 111,400 255,379 (143,979) 229.25% - - - 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 725,135 34( 5,335) 190.93% (252,650) 502,587 (755,237) -198.93% 28,100 18,202 9,898 64.78%
<br /> Items reclassified to balance sheet at year end:
<br /> Capital Outlay (55,000) (43,875) (11,125) 79.77% (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) (48,740) (356,460) (1,464,150) 199,213 (1,663,363) 28,100 18,202 9,898
<br /> *Recorded at year end
<br />
|