Printable Versions

TANF Caseload Reduction Report FY 2013 (pdf)

Excess MOE Calculation Worksheet (xls)

  • Date of Completion: 12/7/2012
  • State: Illinois
  • Fiscal Year to which credit applies: 2013
  • Overall Report: Yes
  • Apply the overall credit to the two-parent participation rate? Yes

PART 1 - Eligibility Changes Made Since FY 2005

(Complete this section for EACH change)

Table 1

1 Name of Eligibility Change Two Parent Families Paid for with State Only Funds
2 Implementation date of eligibility change: October 1, 2006
3 Description of policy, including the change from prior policy: All two parent families are now paid for out of state only funds (not claimed as MOE) and no longer included in the participation rate.
4 Description of the methodology used to calculate the estimated impact of this eligibility change (attach supporting materials to this form): Since the entire universe of two parent cases was shifted to state only funds the actual number of two parent cases were averaged for the year to determine the average monthly impact.
5 Estimated average monthly impact of this eligibility change on caseload in comparison year: -1,181

Table 2

1 Name of eligibility change: First Time Pregnant Women paid with State Only funds
2 Implementation date of eligibility change: October 1, 2006
3 Description of policy, including the change from prior policy: All cases containing a pregnant woman with no other members are now paid for out of State only funds (not claimed as MOE) and no longer included in the participation rate.
4 Description of the methodology used to calculate the estimated impact of this eligibility change (attach supporting materials to this form): Since the entire universe of First Time Pregnant Women cases was shifted to state only funds the actual monthly number of First Time Pregnant Women cases were averaged for the year to determine the average monthly impact.
5 Estimated average monthly impact of this eligibility change on caseload in comparison year: -1,297

Table 3

1 Name of eligibility change: Refugee Cases paid with State Only Funds
2 Implementation date of eligibility change: October 1, 2006
3 Description of policy, including the change from prior policy: All Refugee cases (single parent cases with an A or Y in the first position of the basic number) are now paid for out of state only funds (not claimed as MOE) and no longer included in the participation rate.
4 Description of the methodology used to calculate the estimated impact of this eligibility change (attach supporting materials to this form): Since the entire universe of Refugee cases was shifted to state only funds the actual monthly number of Refugee cases were averaged for the year to determine the average monthly impact.
5 Estimated average monthly impact of this eligibility change on caseload in comparison year: -80

Table 4

1 Name of eligibility change: Child Under One Cases paid with State Only Funds
2 Implementation date of eligibility change: October 1, 2006
3 Description of policy, including the change from prior policy: All single parent cases containing a Child Under Age One are now paid out of State Only funds (not claimed as MOE) and no longer included in the participation rate.
4 Description of the methodology used to calculate the estimated impact of this eligibility change (attach supporting materials to this form): Since the entire universe of single parent cases with a child under age one was shifted to state only funds the actual monthly number of Child Under One cases were averaged for the year to determine the average monthly impact.
5 Estimated average monthly impact of this eligibility change on caseload in comparison year: -8,712

Table 5

1 Name of eligibility change Caseload Reduction Attributed To Excess MOE Spending
2 Implementation date of eligibility change: October 1, 2007
3 Description of policy, including the change from prior policy: Excess MOE that was spent was used to increase the caseload reduction in accordance with TANF rule 261.43(b).
4 Description of the methodology used to calculate the estimated impact of this eligibility change (attach supporting materials to this form): The methodology is in compliance with the ACF requirements outlined in the Caseload Reduction Credit form Part II.
5 Estimated average monthly impact of this eligibility change on caseload in comparison year: 4,831

PART 2 - Estimate of Caseload Reduction Credit

Part 1 - Excess MOE Calculation Worksheet FY 2013

  • State: Illinois
  • Fiscal Year to which credit applies:  2013
  • Date of Completion: 12/7/2012

Caseload Data

FY 2005 TANF Caseload 38,391
FY 2005 SSP Caseload 878
Total FY 2005 Caseload 39,269
FY 2012 TANF Caseload 33,715
FY 2012 SSP Caseload 0
Total FY 2012 Caseload 33,715

 2-Parent Caseload Data 

FY 2005 2-p TANF Caseload 0
FY 2005 2-p SSP Caseload 0
Total FY 2005 Caseload 0
FY 2012 2-p TANF Caseload 0
FY 2012 2-p SSP Caseload 0
Total FY 2012 Caseload 0

Adjusted Caseload Data

Adjusted FY 2012 Overall Caseload 28,884
Adjusted FY 2011 2-parent Caseload 0

Expenditure Data

Total Expenditures
FY 2012 Total Federal Expenditures $585,056,960
FY 2012 Total MOE Expenditures $599,886,716
Total Expenditures (Federal + MOE) $1,184,943,676
 Assistance Expenditures
FY 2012 Federal Expenditures on Assistance $89,842,598
FY 2012 MOE Expenditures on Assistance $37,667,206
Total Expenditures on Assistance (Federal + MOE) $127,509,804
Percentage of Expenditures on Assistance 10.76%
Expenditures Per Case
Average Expenditures per Case $35,146
Average Expenditures per Case on Assistance $3,782
MOE and Excess MOE
Required MOE (80% or 75%) $430,088,193
Excess MOE Expenditures $169,798,523
Excess MOE Expenditures on Assistance $18,271,735
Cases Funded by Excess MOE
Assistance Cases Funded by Excess MOE 4,831
2-Parent Assistance Cases Funded by Excess MOE 0

PART 2 - Estimate of Caseload Reduction Credit

Impact of All Changes

Two Parent Families Paid With State only Funds -1,181
First Time Pregnant Women Paid With State Only Funds -1,297
Refugee Cases Paid With State Only Funds -80
Child Under One Cases Paid With State Only Funds -8,712
Net Impact -11,270

Caseload Reduction Calculation

FY 2005 TANF Caseload 38,391
FY 2005 SSP Caseload 878
Total FY 2005 Caseload 39,269
FY 2012 TANF Caseload 33,715
FY 2012 SSP Caseload 0
Total FY 2012 Caseload 33,715
Excess MOE Cases in FY 2012 4,831
Adjusted FY 2012 Caseload 28,884
Caseload Decline 10,385 26.4%
Decline - Net Impact -885
Caseload Reduction Credit -2.3%

PART 2 - Estimate of Caseload Reduction Credit - 2-Parent Caseload

Caseload Reduction Calculation

FY 2005 TANF 2-Parent Caseload
FY 2005 SSP 2-Parent Caseload
Total FY 2005 Caseload 0
FY 2012 TANF 2-Parent Caseload
FY 2012 SSP 2-Parent Caseload
Total FY 2012 2-Parent Caseload 0
Excess MOE 2-Parent Cases in FY 2012 0
Adjusted FY 2012 Caseload 0
Caseload Decline 0 0.0%
Decline - Net Impact 0
2-Parent Caseload Reduction Credit 0.0%

Two Parent Families Paid With State Only Funds Impact on Each Month in FY 2012

FY 2012 Monthly Average: 1,181

Time of Closure
Prior years carryover Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Grand Total
Oct 1,112
Nov 1,137
Dec 1,170
Jan 1,190
Feb 1,201
Mar 1,179
Apr 1,168
May 1,208
Jun 1,202
Jul 1,209
Aug 1,184
Sep 1,213
Total 1,112 1,137 1,170 1,190 1,201 1,179 1,168 1,208 1,202 1,209 1,184 1,213 14,173

First Time Pregnant Women Paid With State Only Funds Impact on Each Month in FY 2012

FY 2012 Monthly Aveage: 1,297

Time of Closure
Prior years carryover Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Grand Total
Oct 1,303
Nov 1,284
Dec 1,292
Jan 1,273
Feb 1,326
Mar 1,286
Apr 1,289
May 1,344
Jun 1,388
Jul 1,322
Aug 1,201
Sep 1,257
Total 1,303 1,284 1,292 1,273 1,326 1,286 1,289 1,344 1,388 1,322 1,201 1,257 15,565

PART 3 - Certification

I certify that we have provided the public an appropriate opportunity to comment on the estimates and methodology used to complete this report and considered those comments in completing it. Further, I certify that this report incorporates all reductions in the caseload resulting from State eligibility changes and changes in Federal requirements since Fiscal Year 2005.

Ken Durst
Chief, Bureau of Program and Performance Management