Caseload Reduction Documentation Process, AC-202

---

Overview

Part 2 - Calculation Worksheet
Impact template
Sample impact table
Excess MOE Worksheet

---

Sheet 1: Part 2 - Calculation Worksheet

State?			Fiscal Year to which credit applies:
PART 2 – Estimate of Caseload Reduction Credit
Impact of All Changes			Caseload Reduction Calculation
			FY 2005 TANF Caseload
			FY 2005 SSP Caseload
			Total FY 2005 Caseload	0
			FY TANF Caseload
			FY SSP Caseload
			Total FY Caseload	0
			Excess MOE Cases in FY	0
			Adjusted FY Caseload	0
			Caseload Decline	0	0.0%
			Decline – Net Impact	0
				Caseload Reduction Credit =	0.0%
Net Impact	0

---

Sheet 2: Impact template

Policy Name

Impact on Each Month in FY ?

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Time of Closure

Prior years carryover

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Grand

Total

Total

0

0

0

0

0

0

0

0

0

0

0

0

0

FY ? monthly average

0

---

Sheet 3: Sample impact table

Columbia
Impact #3, Full Family Sanction
	Impact on Each Month in FY 2007
	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep
Time of Closure
Prior years carryover	-81	-76	-72	-69	-67	-65	-63	-61	-60	-59	-57	-56
Oct	-33	-30	-28	-26	-24	-21	-18	-16	-15	-13	-10	-8
Nov		-42	-39	-36	-34	-32	-29	-27	-25	-23	-21	-20
Dec			-55	-53	-51	-48	-46	-43	-41	-40	-38	-37
Jan				-64	-61	-59	-56	-53	-52	-51	-49	-47
Feb					-27	-25	-25	-24	-24	-24	-22	-21
Mar						-22	-20	-20	-20	-19	-18	-18
Apr							-16	-16	-12	-11	-11	-11
May								-26	-23	-21	-21	-19
Jun									-24	-20	-18	-17
Jul										-31	-26	-26
Aug											-29	-23
Sep												-26	Grand
													Total
Total	-114	-148	-194	-248	-264	-272	-273	-286	-296	-312	-320	-329	-3,056
												FY 2007 monthly average	-255

---

Sheet 4: Excess MOE Worksheet

				Fiscal Year to which credit applies:
Excess MOE Calculation Worksheet
Caseload Data			Expenditure Data
FY 2005 TANF Caseload	0		Total Expenditures
FY 2005 SSP Caseload	0		FY Total Federal Expenditures
Total FY 2005 Caseload	0		FY Total MOE Expenditures
FY TANF Caseload	0		Total Expenditures (Federal + MOE)		$0
FY SSP Caseload	0
Total FY Caseload	0		Assistance Expenditures
			FY Federal Expenditures on Assistance
			FY MOE Expenditures on Assistance
Adjusted Caseload Data			Total Expenditures on Assistance (Federal + MOE)		$0
Adjusted FY Caseload	0		Percentage of Expenditures on Assistance		0.00%
			Expenditures Per Case
			Average Expenditures per Case		$0
			Average Expenditures per Case on Assistance		$0
			MOE and Excess MOE
			Required MOE (80% or 75%)
			Excess MOE Expenditures		$0
			Excess MOE Expenditures on Assistance		$0
			Assistance Cases Funded by Excess MOE		0