Loading...
HomeMy WebLinkAboutTab 1: 2012 Year-End ResultsVillage of Mount Prospect, Illinois General Fund - Revenues and Expenditures 2012 End -of -Year Results (a) Revenues: Property Taxes Sales Taxes - ROT Portion Sales Taxes - HMR Portion Food and Beverage Tax Real Estate Transfer Tax Telecommunications Tax Other Utility Taxes Other Taxes Vehicle Licenses Other Licenses, Permits, Fees State Income Tax Other Intergovernmental Charges for Services Fines and Forfeits Investment Income Other Revenue Total Revenues Expenditures Public Representation Village Manager's Office Television Services Division Village Clerk's Office Finance Department Community Development Dept. Human Services Dept. Police Department Fire Department Public Works Department Emergency Events Miscellaneous Total Expenditures Excess of Revenues over Expend. Other Financing Sources /Uses Transfers In Transfers Out Total Other Financing Uses Excess of Revenues over Expend. and Other Financing Uses: 2011 Actual 11,750,522 10,614,601 1,195,178 867,630 363,194 2,875,668 1,749,010 112,572 1,376,506 1,861,724 4,328,196 1,592,714 1,486,223 559,173 23,066 417,007 41,172,984 454,868 2,645,350 149,954 144,417 1,561,764 2,109,428 981,386 14,649,653 11,444,291 6,050,055 549,077 45,862 40, 786,105 386.879 8 no (b) 2012 Amended Budget 12,291,500 11,047,000 1,215,000 695,000 516,000 3,230,000 1,802,000 192,000 1,405,000 2,160,000 4,590,000 1,441,619 1,508,125 757,000 25,000 437,300 43,312,544 528,525 2,777,240 169,485 153,718 1,531,029 2,165,082 1,129,094 15,397,424 11,972,153 6,708,889 6,505 46,005 42,585,149 727,395 0 0 0 (c) (d) Budget Variance - 2012 Favorable Actual (Unfavorable) Notes 12,184,094 11,040,403 1,212,506 710,328 515,330 3,034,829 1,623,436 205,537 1,383,836 2,143,263 4,759,513 1,386,713 1,539,503 410,371 29,927 438,133 42,617,723 509,625 2,799,917 158,051 148,893 1,505,297 2,064,816 1,086,049 15,286,395 11,946,075 6,302,933 4,213 46,004 41,858,267 759,456 0 (107,406) (6,597) (2,494) 15,328 (670) (195,171) (178,564) 13,537 (21,165) (16,737) 169,513 (54,906) 31,378 (346,629) 4,927 833 (694,821) A B C Al 18,900 (22,677) 11,435 4,825 25,732 100,266 43,045 111,029 26,078 405,956 2,292 1 726,882 E 386,879 727,395 759,456 1 of 2 0 2012 End of Year Summary - GF.xlsx Village of Mount Prospect, Illinois General Fund - Revenues and Expenditures 2012 End -of -Year Results Notes A The original budget for this revenue item was amended upwards by $705,000. While monthly receipts were tracking ahead of the prior year, a slowing at year -end resulted in the shortfall from the revised amount. Year -end revenue was $509,829 over the original budget amount. B Revenue from Other Utility Taxes (Gas and Electric) fell short, primarily due to lower gas usage from a milder than expected winter. A slight premium was added to the projection for Electric utility taxes to account for the extremely warm summer to -date. C A decline in the Circuit Court fines, Parking fines and an adjustment to the Forfeited Escrow Funds accounts is responsible for the variance in this category of revenue. D Total revenues for 2012 were off $694,821 or 1.6% from the amended budget amount. Excluding the shortfall in Fines & Forfeits the variance drops to $348,192 or 0.8 %. The original budget for revenues was $41,547,482. E Total expenditures came in below budget by $726,882 or 1.7 %. The Public Works Department saw the largest savings from budget accounting for $405,956 or 56% of the total. F The amended budget projected a surplus of $727,395 on revenues of $43,312,544 and expenses of $42,585,149. Although there was a shortfall in budget to actual revenues, savings in budget to actual expenses resulted in a final General Fund surplus of $759,456. 2 of 2 2012 End of Year Summary - GF.xlsx