"BOARDS, AUTHORITIES AND COMMISSIONS" MCB ARRA (11211) FY 11 Financial Report - May 2011 Projections Based on: 12 Mths* 13 Mths** Based on PR 12 Completed 8.0 8.0 Completed 16.1 Remaining 4.0 5.0 Remaining 10.0 PLAN ACTUAL EXPENDITURES PROJECTIONS Adjusted Current YTD thru May 2011 Projected Anticipated FY 10 Financial Financial Month Remaining Full Year Anticipated Percent Percent Categories Totals Plan Adj. Plan Expend. Expenses Encumb. Total Expenditures Expenditures Balance Of Plan Guideline Authorized Approp. "4,063,600 " "4,063,600 " "4,063,600 " Expenditures spent in FY10 "(6,550)" "(543,024)" "(543,024)" Available Approp. "4,057,050 " "4,063,600 " "(543,024)" "3,520,576 " EXPENDITURES: Salaries & Wages "236,197 " "520,000 " 0 "520,000 " "44,399 " "279,181 " 0 "279,181 " "214,587 " "493,768 " "26,232 " 53.7% 61.9% Longevity & Insurance "9,235 " "70,262 " 0 "70,262 " "3,883 " "30,215 " 0 "30,215 " "11,138 " "41,353 " "28,909 " 43.0% 61.9% Retirement & FICA "56,383 " "145,000 " 0 "145,000 " "11,235 " "67,930 " 0 "67,930 " "55,342 " "123,272 " "21,728 " 46.8% 61.9% Terminal Leave 0 0 0 0 0 0 0 0 0 0 0 0.0% 61.9% " Travel, Out-Of-State**" "2,011 " "5,000 " 0 "5,000 " 0 0 0 0 0 0 "5,000 " 0.0% 66.7% " Travel, In State and Moving Exps**" "7,714 " "10,000 " 0 "10,000 " 650 "5,858 " 0 "5,858 " "3,000 " "8,858 " "1,142 " 58.6% 66.7% Communications** 562 "5,000 " 0 "5,000 " 122 "1,019 " 0 "1,019 " 500 "1,519 " "3,481 " 20.4% 66.7% Utilities** 0 0 0 0 0 0 0 0 0 0 0 0.0% 66.7% Contractual Services* "41,723 " "850,000 " 0 "850,000 " "59,889 " "562,731 " "233,204 " "795,934 " "243,279 " "1,039,214 " "(189,214)" 66.2% 66.7% Supplies & Materials** "7,211 " "65,000 " 0 "65,000 " 76 "53,406 " 0 "53,406 " "4,400 " "57,806 " "7,194 " 82.2% 66.7% Equipment* 0 0 0 0 0 0 0 0 0 0 0 0.0% 66.7% Grants 0 135 0 135 135 135 0 135 0 135 0 99.7% 66.7% Miscellaneous 0 0 0 0 0 0 0 0 0 0 0 0.0% 66.7% Cost Allocations 20 100 0 100 (0) 29 0 29 50 79 21 28.8% 66.7% Charges from DIT "3,253 " "5,000 " 0 "5,000 " 0 0 0 0 0 0 "5,000 " 0.0% 66.7% Client Services and BEP "169,891 " "1,075,000 " 0 "1,075,000 " "128,945 " "799,355 " 0 "799,355 " "218,000 " "1,017,355 " "57,645 " 74.4% 66.7% Indirect Salaries "2,272 " "5,000 " 0 "5,000 " 0 "1,464 " 0 "1,464 " "2,000 " "3,464 " "1,536 " 29.3% 66.7% TOTAL Expenditures "536,474 " "2,755,497 " 0 "2,755,497 " "249,334 " "1,801,323 " "233,204 " "2,034,527 " "752,296 " "2,786,823 " "(31,326)" 65.4% 66.7% Remaining Approp. "1,308,103 " "(543,024)" "765,079 " "733,753 " SUMMARY BY FUNDING SOURCE Balance Lapse SERVS FOR OLDER CLIENTS - 0420 "1,187,100 " "(63,231)" "1,123,869 " "16,697 " "255,588 " "33,668 " "289,257 " "70,279 " "359,536 " "764,333 " CNTRS FOR INDEPEND LVG - 0453 "156,500 " "(5,466)" "151,034 " "5,613 " "12,546 " "7,002 " "19,548 " "25,200 " "44,748 " "106,286 " VOC REHAB STATE GRANT - 0458 "2,720,000 " "(474,327)" "2,245,673 " "227,024 " "1,533,189 " "192,533 " "1,725,722 " "656,817 " "2,382,539 " "(136,866)" TOTAL "4,063,600 " "(543,024)" "3,520,576 " "249,334 " "1,801,323 " "233,204 " "2,034,527 " "752,296 " "2,786,823 " "733,753 " CORRECTIVE PLAN If needed the Encumbrance set up for the renovations project under fund 0458 can be moved to the other funds.