EMPLOYMENT SERVICES Commission For The Blind (11210) FY 2012 Financial Report - February Projections Based on: 12 Mths* 13 Mths** Based on PR 6 Completed 5.0 5.0 Completed 9.0 Remaining 7.0 8.0 Remaining 17.0 PLAN ACTUAL EXPENDITURES PROJECTIONS Adjusted Current YTD thru February 2012 Projected Anticipated FY 11 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. "26,819,700 " "26,728,500 " "26,728,500 " Unavailable funds "(4,583,510)" "(13,004,300)" "(13,004,300)" Federal 0715 Carryforward "8,825,197 " "8,825,197 " OPEB funding increase "553,000 " "553,000 " Available Approp. "22,236,190 " "36,106,697 " "(13,004,300)" "23,102,397 " EXPENDITURES: Salaries & Wages "5,597,803 " "6,200,238 " 0 "6,200,238 " "482,923 " "2,062,692 " 0 "2,062,692 " "4,137,545 " "6,200,238 " 0 33.3% 34.6% Longevity & Insurance "1,250,099 " "1,404,511 " 0 "1,404,511 " "108,376 " "522,607 " 0 "522,607 " "881,905 " "1,404,511 " (0) 37.2% 34.6% Retirement & FICA "2,820,233 " "3,810,660 " 0 "3,810,660 " "299,669 " "1,320,044 " 0 "1,320,044 " "2,490,616 " "3,810,660 " 0 34.6% 34.6% Terminal Leave "48,370 " "50,000 " 0 "50,000 " 0 "14,789 " 0 "14,789 " "35,211 " "50,000 " (0) 29.6% 38.5% Travel "360,560 " "361,507 " 0 "361,507 " "27,337 " "114,139 " "6,746 " "120,885 " "240,622 " "361,507 " 0 31.6% 38.5% Communications** "142,549 " "143,916 " 0 "143,916 " "12,433 " "55,352 " 0 "55,352 " "88,564 " "143,916 " (0) 38.5% 41.7% Utilities** "75,182 " "76,634 " 0 "76,634 " "4,902 " "12,551 " 0 "12,551 " "64,082 " "76,634 " 0 16.4% 41.7% Contractual Services* "4,679,535 " "3,599,594 " 0 "3,599,594 " "683,939 " "1,325,820 " "381,626 " "1,707,446 " "1,892,148 " "3,599,594 " 0 36.8% 38.5% Consulting Services 0 "447,625 " 0 "447,625 " "54,497 " "93,673 " "222,810 " "316,483 " "131,142 " "447,625 " (0) 20.9% 38.5% Supplies & Materials** "540,630 " "512,646 " 0 "512,646 " "71,473 " "185,621 " 32 "185,653 " "326,994 " "512,646 " (0) 36.2% 41.7% Equipment* "786,616 " "787,567 " 0 "787,567 " "40,756 " "88,080 " "58,174 " "146,255 " "641,312 " "787,567 " (0) 11.2% 41.7% Grants* "125,176 " "134,871 " 0 "134,871 " 215 "25,916 " "72,673 " "98,589 " "36,282 " "134,871 " 0 19.2% 41.7% Fiscal and Interest Payments 20 0 0 0 0 0 0 0 0 0 0 0.0% 41.7% Miscellaneous** "5,528 " "31,412 " 0 "31,412 " "13,088 " "13,088 " 0 "13,088 " "18,324 " "31,412 " 0 41.7% 41.7% Legal Services and Settlements "374,631 " "250,000 " 0 "250,000 " 0 0 0 0 "250,000 " "250,000 " 0 0.0% 41.7% Cost Allocations** "538,368 " "540,000 " 0 "540,000 " "81,445 " "81,445 " 0 "81,445 " "458,555 " "540,000 " (0) 15.1% 38.5% Charges From DIT "290,306 " "289,874 " 0 "289,874 " "70,367 " "228,874 " 0 "228,874 " "61,000 " "289,874 " 0 79.0% 38.5% Auditor Gen Charges "14,985 " "15,000 " 0 "15,000 " 0 0 0 0 "15,000 " "15,000 " (0) 0.0% 41.7% OWD & WF Prgms Cost Allocations 0 "4,344 " 0 "4,344 " "4,344 " "4,344 " 0 "4,344 " 0 "4,344 " 0 100.0% 41.7% Client Services and BEP "4,419,956 " "4,420,837 " 0 "4,420,837 " "693,221 " "1,595,189 " "542,384 " "2,137,573 " "2,283,264 " "4,420,837 " 0 36.1% 38.5% Indirect Salaries "20,317 " "21,161 " 0 "21,161 " "5,276 " "5,276 " 0 "5,276 " "15,886 " "21,161 " (0) 24.9% 38.5% TOTAL Expenditures "22,090,863 " "23,102,397 " 0 "23,102,397 " "2,654,260 " "7,749,501 " "1,284,445 " "9,033,945 " "14,068,452 " "23,102,397 " 0 33.5% Remaining Approp. "13,004,300 " 0 0 SUMMARY BY FUNDING SOURCE Balance Balance/Lapse FEDERAL - 0715 "29,510,397 " "(11,979,539)" "17,530,858 " "5,956,696 " "1,077,488 " "7,034,184 " "10,496,674 " "17,530,858 " 0 PRIVATE - 0905 Donations "114,100 " "(108,100)" "6,000 " 0 0 0 "6,000 " "6,000 " 0 RESTRICTED - 1195 "565,100 " "(299,100)" "266,000 " "132,699 " "1,250 " "133,949 " "132,051 " "266,000 " 0 LOCAL - 1337 "539,900 " "(474,900)" "65,000 " 0 0 0 "65,000 " "65,000 " 0 GF/GP - 7001 "5,377,200 " "(142,661)" "5,234,539 " "1,660,105 " "205,707 " "1,865,812 " "3,368,727 " "5,234,539 " 0 TOTAL "36,106,697 " "(13,004,300)" "23,102,397 " 0 "7,749,501 " "1,284,445 " "9,033,945 " "14,068,452 " "23,102,397 " 0 "Federal 0715 includes approximately $8,825,197.29 in carryforward from last fiscal year." "Equipment includes $36,000 for a tractor and $6,500 for a sound booth"