"BOARDS, AUTHORITIES AND COMMISSIONS" MCB ARRA (11211) FY 11 Financial Report - June 2011 Projections Based on: 12 Mths* 13 Mths** Based on PR 14 Completed 9.0 9.0 Completed 18.1 Remaining 3.0 4.0 Remaining 8.0 PLAN ACTUAL EXPENDITURES PROJECTIONS Adjusted Current YTD thru June 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 " "40,725 " "319,906 " 0 "319,906 " "190,103 " "510,009 " "9,991 " 61.5% 69.6% Longevity & Insurance "9,235 " "70,262 " 0 "70,262 " "2,852 " "33,067 " 0 "33,067 " "14,089 " "47,156 " "23,106 " 47.1% 69.6% Retirement & FICA "56,383 " "145,000 " 0 "145,000 " "10,271 " "78,201 " 0 "78,201 " "50,311 " "128,512 " "16,488 " 53.9% 69.6% Terminal Leave 0 0 0 0 0 0 0 0 0 0 0 0.0% 69.6% " Travel, Out-Of-State**" "2,011 " "5,000 " 0 "5,000 " 0 0 0 0 0 0 "5,000 " 0.0% 75.0% " Travel, In State and Moving Exps**" "7,714 " "10,000 " 0 "10,000 " 105 "5,963 " 0 "5,963 " "2,000 " "7,963 " "2,037 " 59.6% 75.0% . Communications** 562 "5,000 " 0 "5,000 " 123 "1,142 " 0 "1,142 " 375 "1,517 " "3,483 " 22.8% 75.0% Utilities** 0 0 0 0 0 0 0 0 0 0 0 0.0% 75.0% Contractual Services* "41,723 " "1,050,000 " 0 "1,050,000 " "225,463 " "788,194 " "68,086 " "856,280 " "191,710 " "1,047,990 " "2,010 " 75.1% 75.0% Supplies & Materials** "7,211 " "65,000 " 0 "65,000 " 189 "53,595 " 0 "53,595 " "3,400 " "56,995 " "8,005 " 82.5% 75.0% Equipment* 0 0 0 0 0 0 0 0 0 0 0 0.0% 75.0% Grants 0 135 0 135 (0) 135 0 135 0 135 0 99.7% 75.0% Miscellaneous 0 0 0 0 0 0 0 0 0 0 0 0.0% 75.0% Cost Allocations 20 100 0 100 (0) 29 0 29 50 79 21 28.8% 75.0% Charges from DIT "3,253 " "5,000 " 0 "5,000 " 0 0 0 0 0 0 "5,000 " 0.0% 75.0% Client Services and BEP "169,891 " "1,400,000 " 0 "1,400,000 " "139,924 " "939,279 " 0 "939,279 " "453,000 " "1,392,279 " "7,721 " 67.1% 75.0% Indirect Salaries "2,272 " "5,000 " 0 "5,000 " 0 "1,464 " 0 "1,464 " "1,800 " "3,264 " "1,736 " 29.3% 75.0% TOTAL Expenditures "536,474 " "3,280,497 " 0 "3,280,497 " "419,652 " "2,220,975 " "68,086 " "2,289,061 " "906,838 " "3,195,899 " "84,598 " 67.7% 75.0% Remaining Approp. "783,103 " "(543,024)" "240,079 " "324,678 " SUMMARY BY FUNDING SOURCE Balance Lapse SERVS FOR OLDER CLIENTS - 0420 "1,187,100 " "(63,231)" "1,123,869 " "35,509 " "291,097 " "24,139 " "315,237 " "79,710 " "394,947 " "728,923 " CNTRS FOR INDEPEND LVG - 0453 "156,500 " "(5,466)" "151,034 " "5,735 " "18,281 " "2,008 " "20,289 " "28,200 " "48,489 " "102,545 " VOC REHAB STATE GRANT - 0458 "2,720,000 " "(474,327)" "2,245,673 " "378,408 " "1,911,597 " "41,938 " "1,953,535 " "798,928 " "2,752,463 " "(506,790)" TOTAL "4,063,600 " "(543,024)" "3,520,576 " "419,652 " "2,220,975 " "68,086 " "2,289,061 " "906,838 " "3,195,899 " "324,678 " CORRECTIVE PLAN