"BOARDS, AUTHORITIES AND COMMISSIONS" MCB ARRA (11211) FY 11 Financial Report - April 2011 Projections Based on: 12 Mths* 13 Mths** Based on PR Completed 7.0 7.0 Completed 14.1 Remaining 5.0 6.0 Remaining 12.0 PLAN ACTUAL EXPENDITURES PROJECTIONS Adjusted Current YTD thru April 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 " "42,649 " "234,782 " 0 "234,782 " "256,370 " "491,152 " "28,848 " 45.2% 54.2% Longevity & Insurance "9,235 " "70,262 " 0 "70,262 " "3,869 " "26,332 " 0 "26,332 " "23,301 " "49,633 " "20,629 " 37.5% 54.2% Retirement & FICA "56,383 " "145,000 " 0 "145,000 " "10,634 " "56,695 " 0 "56,695 " "65,732 " "122,427 " "22,573 " 39.1% 54.2% Terminal Leave 0 0 0 0 0 0 0 0 0 0 0 0.0% 54.2% " Travel, Out-Of-State**" "2,011 " "5,000 " 0 "5,000 " 0 0 0 0 0 0 "5,000 " 0.0% 58.3% " Travel, In State and Moving Exps**" "7,714 " "10,000 " 0 "10,000 " 481 "5,208 " 0 "5,208 " "4,464 " "9,672 " 328 52.1% 58.3% Communications** 562 "5,000 " 0 "5,000 " 151 897 0 897 641 "1,537 " "3,463 " 17.9% 58.3% Utilities** 0 0 0 0 0 0 0 0 0 0 0 0.0% 58.3% Contractual Services* "41,723 " "850,000 " 0 "850,000 " "174,830 " "502,842 " "233,204 " "736,046 " "100,000 " "836,046 " "13,954 " 59.2% 58.3% Supplies & Materials** "7,211 " "65,000 " 0 "65,000 " "24,462 " "53,330 " 0 "53,330 " "7,500 " "60,830 " "4,170 " 82.0% 58.3% Equipment* 0 0 0 0 0 0 0 0 0 0 0 0.0% 58.3% Grants 0 0 0 0 0 0 0 0 0 0 0 0.0% 58.3% Miscellaneous 0 0 0 0 0 0 0 0 0 0 0 0.0% 58.3% Cost Allocations 20 100 0 100 29 29 0 29 25 53 47 Charges from DIT "3,253 " "5,000 " 0 "5,000 " 0 0 0 0 0 0 "5,000 " 0.0% 58.3% Client Services and BEP "169,891 " "1,075,000 " 0 "1,075,000 " "140,768 " "670,410 " 0 "670,410 " "366,150 " "1,036,560 " "38,440 " 62.4% 58.3% Indirect Salaries "2,272 " "5,000 " 0 "5,000 " 799 "1,464 " 0 "1,464 " "2,000 " "3,464 " "1,536 " 58.3% TOTAL Expenditures "536,474 " "2,755,362 " 0 "2,755,362 " "398,672 " "1,551,989 " "233,204 " "1,785,192 " "826,182 " "2,611,374 " "143,988 " 56.3% Remaining Approp. "1,308,238 " "(543,024)" "765,214 " "909,202 " SUMMARY BY FUNDING SOURCE Balance Lapse SERVS FOR OLDER CLIENTS - 0420 "1,187,100 " "(63,231)" "1,123,869 " "145,972 " "238,891 " "33,668 " "272,560 " "70,000 " "342,560 " "781,310 " CNTRS FOR INDEPEND LVG - 0453 "156,500 " "(5,466)" "151,034 " "2,581 " "6,933 " "7,002 " "13,935 " "15,000 " "28,935 " "122,099 " VOC REHAB STATE GRANT - 0458 "2,720,000 " "(474,327)" "2,245,673 " "250,120 " "1,306,165 " "192,533 " "1,498,698 " "741,182 " "2,239,880 " "5,793 " TOTAL "4,063,600 " "(543,024)" "3,520,576 " "398,672 " "1,551,989 " "233,204 " "1,785,192 " "826,182 " "2,611,374 " "909,202 " CORRECTIVE PLAN None