[nfbmi-talk] mcb financials posted aug 22
joe harcz Comcast
joeharcz at comcast.net
Mon Aug 27 11:38:41 UTC 2012
Table with 15 columns and 84 rows
EMPLOYMENT SERVICES
Commission For The Blind (11210)
FY 2012 Financial Report - July
Projections Based on:
12 Mths*
13 Mths**
Based on PR
17
Completed
10.0
10.0
Completed
20.0
Remaining
2.0
3.0
Remaining
6.0
PLAN
ACTUAL EXPENDITURES
PROJECTIONS
Adjusted
Current
YTD thru July 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)
(3,906,693)
(3,906,693)
OPEB funding increase
553,000
553,000
Available Approp.
22,236,190
27,281,500
(3,906,693)
23,374,807
EXPENDITURES:
Salaries & Wages
5,597,803
6,221,075
0
6,221,075
482,161
4,730,370
0
4,730,370
1,449,852
6,180,222
40,853
76.0%
76.9%
Longevity & Insurance
1,250,099
1,423,856
0
1,423,856
98,688
1,073,239
0
1,073,239
303,382
1,376,621
47,235
75.4%
76.9%
Retirement & FICA
2,820,233
3,839,817
0
3,839,817
373,138
2,975,292
0
2,975,292
892,246
3,867,538
(27,721)
77.5%
76.9%
Terminal Leave
48,370
49,636
0
49,636
4,522
39,658
0
39,658
6,357
46,014
3,622
79.9%
76.9%
Travel
360,560
361,168
0
361,168
44,495
288,613
6,636
295,249
86,584
381,832
(20,664)
79.9%
76.9%
Communications**
142,549
172,361
0
172,361
12,182
121,188
0
121,188
36,356
157,544
14,817
70.3%
83.3%
Utilities**
75,182
60,716
0
60,716
6,255
41,050
0
41,050
12,315
53,365
7,351
67.6%
83.3%
Contractual Services*
4,679,535
3,595,345
0
3,595,345
259,172
3,361,029
333,816
3,694,844
641,858
4,336,702
(741,357)
93.5%
76.9%
Consulting Services
0
445,594
0
445,594
58,109
221,953
94,530
316,483
44,391
360,874
84,720
49.8%
76.9%
Supplies & Materials**
540,630
632,703
0
632,703
76,710
550,981
0
550,981
147,937
698,917
(66,214)
87.1%
83.3%
Equipment*
786,616
786,769
0
786,769
10,857
324,086
176,394
500,481
74,817
575,298
211,471
41.2%
83.3%
Grants*
125,176
152,775
0
152,775
24,789
99,939
0
99,939
19,988
119,927
32,848
65.4%
83.3%
Fiscal and Interest Payments
20
0
0
0
0
0
0
0
0
0
0
0.0%
83.3%
Miscellaneous**
5,528
22,437
0
22,437
0
13,088
0
13,088
0
13,088
9,349
58.3%
83.3%
Legal Services and Settlements
374,631
250,000
(250,000)
0
0
0
0
0
0
0
0
0.0%
83.3%
Cost Allocations**
538,368
540,000
0
540,000
0
236,992
0
236,992
302,992
539,985
15
43.9%
76.9%
IT Costs
290,306
289,874
0
289,874
64,522
385,491
0
385,491
25,000
410,491
(120,617)
133.0%
76.9%
Auditor Gen Charges
14,985
15,000
0
15,000
0
0
0
0
15,000
15,000
0
0.0%
83.3%
OWD & WF Prgms Cost Allocations
0
0
0
0
(4,344)
0
0
0
0
0
0
0.0%
83.3%
Client Services and BEP
4,419,956
4,347,924
0
4,347,924
332,626
3,284,557
274,132
3,558,689
656,911
4,215,600
132,324
75.5%
76.9%
Indirect Salaries
20,317
25,003
0
25,003
6,905
21,490
0
21,490
4,298
25,788
(785)
86.0%
76.9%
TOTAL Expenditures
22,090,863
23,232,053
(250,000)
22,982,053
1,850,787
17,769,015
885,508
18,654,523
4,720,284
23,374,807
(392,754)
77.3%
Remaining Approp.
4,049,447
392,754
(0)
SUMMARY BY FUNDING SOURCE
Balance
Balance/Lapse
FEDERAL - 0715
20,709,900
(3,080,793)
17,629,107
14,308,585
743,589
15,052,174
2,576,933
17,629,107
(0)
PRIVATE - 0905
Donations
111,800
(105,800)
6,000
0
0
0
6,000
6,000
0
RESTRICTED - 1195
553,600
(276,100)
277,500
242,195
0
242,195
35,305
277,500
0
LOCAL - 1337
529,000
(444,000)
85,000
0
0
0
85,000
85,000
0
GF/GP - 7001
5,377,200
5,377,200
3,218,235
141,919
3,360,154
2,017,046
5,377,200
0
TOTAL
27,281,500
(3,906,693)
23,374,807
0
17,769,015
885,508
18,654,523
4,720,284
23,374,807
(0)
Federal 0715 - 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
table end
More information about the NFBMI-Talk
mailing list