Appendix A_Crosswalk Worksheet.xls

Resource Justification Model

Appendix A_Crosswalk Worksheet.xls

OMB: 1205-0430

Document [xlsx]

Download: xlsx | pdf

Overview

STARTUPCW
CROSS PSPB
CROSS NPS
1-AST INC
1-IC INC
1-WK INC
1-NMD INC
1-APP INC
1-WR INC
1-TAX INC
1-BPC INC
1-UIP INC
1-SUP INC
PS CONT CROSS

Sheet 1: STARTUPCW

SYSTEM START UP			RJM
Crosswalk Version: 2.5.1			Version
RESOURCE JUSTIFICATION MODEL			2.5.1

			OMB No.: 1205-0430 OMB Expiration Date: XX/XX/XXXX Estimated Average Response Time: 94.5 Hours Public Burden Statement: These reporting instructions have been approved under the Paperwork Reduction Act of 1995. Persons are not required to respond to this collection of information unless it displays a valid OMB control number. Public reporting burden for this collection of information includes the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Submission is required to obtain or retain benefits under SSA 303(a)(6). This is public information and there is no assurance of confidentiality. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: U.S. Department of Labor, Office of Unemployment Insurance, Room S-4231, 200 Constitution Ave., NW, Washington, DC, 20210
STATE NAME
State Abbreviation

ACCOUNTING SYSTEM	COST ACCOUNTING

BUDGET YEAR		FY

HOURS PER WORKDAY

PREVIOUS YEAR		FY
Standard Hours	0.00

CURRENT YEAR		FY
Standard Hours	0.00

NEXT YEAR		FY
Standard Hours	0.00


Date Data Submitted
Contact Person's Name
Contact Person's Phone Number
Contact Person's Email Address
Enter Code for Type of Submission	Type of Submission









STATE TABLE				Submission Codes

STATE/ POSSESSION	ABBREVIATION	STATE ID		Type of Submission
1	2	3		S - Original State submission
ALABAMA	AL	6		B - State submission 1st Amendment
ALASKA	AK	10		C - State submission 2nd Amendment
ARIZONA	AZ	11		D - State submission 3rd Amendment
ARKANSAS	AR	12		E - State submission 4th Amendment
CALIFORNIA	CA	13		V - Original Regional Office validated submission
COLORADO	CO	14		Y - Amended Regional Office 2nd submission
CONNECTICUT	CT	15		Z - Amended Regional Office 3rd submission
DELAWARE	DE	16		ZZ - Amended Regional Office 4th submission
DISTRICT OF COLUMBIA	DC	61		W - Wage and benefits increases - final
FLORIDA	FL	17		R - Special Requirements File
GEORGIA	GA	18
HAWAII	HI	19
IDAHO	ID	20
ILLINOIS	IL	21
INDIANA	IN	22
IOWA	IA	23
KANSAS	KS	24
KENTUCKY	KY	25
LOUISIANA	LA	26
MAINE	ME	27
MARYLAND	MD	28
MASSACHUSETTS	MA	29
MICHIGAN	MI	30
MINNESOTA	MN	31
MISSISSIPPI	MS	32
MISSOURI	MO	33
MONTANA	MT	34
NEBRASKA	NE	35
NEVADA	NV	36
NEW HAMPSHIRE	NH	37
NEW JERSEY	NJ	38
NEW MEXICO	NM	39
NEW YORK	NY	40
NORTH CAROLINA	NC	41
NORTH DAKOTA	ND	42
OHIO	OH	1
OKLAHOMA	OK	8
OREGON	OR	45
PENNSYLVANIA	PA	46
PUERTO RICO	PR	59
RHODE ISLAND	RI	47
SOUTH CAROLINA	SC	48
SOUTH DAKOTA	SD	49
TENNESSEE	TN	50
TEXAS	TX	51
UTAH	UT	52
VERMONT	VT	53
VIRGIN ISLANDS	VI	63
VIRGINIA	VA	54
WASHINGTON	WA	55
WEST VIRGINIA	WV	56
WISCONSIN	WI	57
WYOMING	WY	58
YOUR STATE	None	65


The Following Table is used in calculated standard hours for each year:
*Fiscal Year*	*Number of Work Days*
2002	261
2003	261
2004	262
2005	261
2006	260
2007	260
2008	262
2009	261
2010	261
2011	261
2012	260
2013	261
2014	261
2015	261
2016	262
2017	260
2018	260
2019	261
2020	262
2021	261
2022	261
Above row is last line in table.

Sheet 2: CROSS PSPB

PS/PB CROSS WALK - PREVIOUS YEAR								Crosswalk Version																																															30
Crosswalk Version: 2.5.1							2.5.1
			CROSS PSPB
0								OMB Approval No. 1205-0430
							Expires xx/xx/xxxx
PREVIOUS YEAR			TOTAL				AS&T				INITIAL CLAIMS (IC)				WEEKS CLAIMED (WC)				NON-MONETARY DETERMINATIONS (NMD)				APPEALS (APP)				WAGE RECORDS (WR)				TAX				BENEFIT PAYMENT CONTROL (BPC)				UI PERFORMS (UIP)				SUPPORT (SUP)				NON RJM (NRJM)				BALANCE
FY			HOURS				HOURS				HOURS				HOURS				HOURS				HOURS				HOURS				HOURS				HOURS				HOURS				HOURS				HOURS				HOURS
	FAC	Alloc	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.	PAID	PS$	PB$	WORK HRS.
AGENCY TOTALS LESS NON-RJM			0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00

LEDGER/FUNCTIONAL ACTIVITY
FEDERAL SOURCES		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
STATE SOURCES		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
		0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
TOTAL			0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00

ALLOCATED			0.00	0	0	0.00

DIFFERENCE			0.00	0	0	0.00


ADJUSTMENTS	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
GAL 4-91																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
																																																			0.00	0	0	0.00
	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
TOTAL ADJUSTMENTS			0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00

RJM COSTS			0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00	0.00	0	0	0.00




SHEET IS DESIGNED TO ALLOW ADDITIONAL ROWS TO BE INSERTED - IF DONE MANUALLY INSTEAD OF BY USING BUTTONS AT TOP OF WORKSHEET, COPY FORMULAS IN C13 and FROM H13 through BC13 TO ALL INSERTED ROWS.













STATE TABLE
ALABAMA
ALASKA
ARIZONA
ARKANSAS
CALIFORNIA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
FLORIDA
GEORGIA
HAWAII
IDAHO
ILLINOIS
INDIANA
IOWA
KANSAS
KENTUCKY
LOUISIANA
MAINE
MARYLAND
MASSACHUSETTS
MICHIGAN
MINNESOTA
MISSISSIPPI
MISSOURI
MONTANA
NEBRASKA
NEVADA
NEW HAMPSHIRE
NEW JERSEY
NEW MEXICO
NEW YORK
NORTH CAROLINA
NORTH DAKOTA
OHIO
OKLAHOMA
OREGON
PENNSYLVANIA
PUERTO RICO
RHODE ISLAND
SOUTH CAROLINA
SOUTH DAKOTA
TENNESSEE
TEXAS
UTAH
VERMONT
VIRGIN ISLANDS
VIRGINIA
WASHINGTON
WEST VIRGINIA
WISCONSIN
WYOMING
STATE NAME



SPLIT
SPLIT IT
AS&T
AS&T IT
IC
IC IT
WC
WC IT
NMD
NMD IT
APP
APP IT
WR
WR IT
TAX
TAX IT
BPC
BPC IT
UIP
UIP IT
SUP
SUP IT
NRJM
NRJM IT




																																																			0.00	0	0	0.00

Sheet 3: CROSS NPS

NPS CROSS WALK - PREVIOUS YEAR
Crosswalk Version: 2.5.1
0
FY
												ROO - EOY
STATE CODE	CODE #	Alloc	DOLLARS	IT/COMM.	NON IT	PS CONT	PS CONT IT	NON RJM	NON RJM IT	BALANCE	ROO - P	ROO - EOY
AGENCY TOTALS			0	0	0	0	0	0	0	0	0	0

LEDGER/NPS CODE
ROO - P										0
FEDERAL SOURCES
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
STATE SOURCES
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0
										0

TOTAL			0	0	0	0	0	0	0	0

ALLOCATED			0

DIFFERENCE			0


ADJUSTMENTS

ROO - END OF YEAR										0
										0
										0
										0
										0
										0
										0
										0

TOTAL ADJUSTMENTS			0	0	0	0	0	0	0	0

RJM COSTS			0	0	0	0	0	0	0	0


SHEET IS DESIGNED TO ALLOW ADDITIONAL ROWS TO BE INSERTED - IF DONE MANUALLY INSTEAD OF BY USING BUTTONS AT TOP OF WORKSHEET, COPY FORMULAS IN C12 and FROM E12 through P12 TO ALL INSERTED ROWS.




IT/COMM
NON IT
SPLIT
SPLIT IT
PSCTR
PSCTR IT
NRJM
NRJM IT




										0

Sheet 4: 1-AST INC

COST PER POSITION - AS&T
Crosswalk Version: 2.5.1
1-AST
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.				$0
2.				$0
3.				$0
CURRENT YEAR
1. Default		12	3.00%	$0	$0
2.				$0	$0
3.				$0	$0
NEXT YEAR
1. Default		12	3.00%		$0
2.					$0
3.					$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA				$0
RETIREMENT MATCH				$0
OTHER PERCENT				$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE				$0	$0
INFLATIONARY INCREASE (DEFAULT)		12	3.00%	$0	$0
PER POSITION INCREASE				$0	$0
NEXT YEAR			%
FICA					$0
RETIREMENT MATCH					$0
OTHER PERCENT					$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE					$0
INFLATIONARY INCREASE (DEFAULT)		12	3.00%		$0
PER POSITION INCREASE					$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 5: 1-IC INC

COST PER POSITION - INITIAL CLAIMS
Crosswalk Version: 2.5.1
1-IC
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.	N/A	0	0.00%	$0
2.	N/A	0	0.00%	$0
3.	N/A	0	0.00%	$0
CURRENT YEAR
1. Default	N/A	12	3.00%	$0	$0
2.	N/A	0	0.00%	$0	$0
3.	N/A	0	0.00%	$0	$0
NEXT YEAR
1. Default	N/A	12	3.00%		$0
2.	N/A	0	0.00%		$0
3.	N/A	0	0.00%		$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA	N/A	0	0.00%	$0
RETIREMENT MATCH	N/A	0	0.00%	$0
OTHER PERCENT	N/A	0	0.00%	$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%	$0	$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%	$0	$0
PER POSITION INCREASE	N/A	0	0	$0	$0
NEXT YEAR			%
FICA	N/A	0	0.00%		$0
RETIREMENT MATCH	N/A	0	0.00%		$0
OTHER PERCENT	N/A	0	0.00%		$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%		$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%		$0
PER POSITION INCREASE	N/A	0	0		$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 6: 1-WK INC

COST PER POSITION - WEEKS CLAIMED
Crosswalk Version: 2.5.1
1-WK
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.	N/A	0	0.00%	$0
2.	N/A	0	0.00%	$0
3.	N/A	0	0.00%	$0
CURRENT YEAR
1. Default	N/A	12	3.00%	$0	$0
2.	N/A	0	0.00%	$0	$0
3.	N/A	0	0.00%	$0	$0
NEXT YEAR
1. Default	N/A	12	3.00%		$0
2.	N/A	0	0.00%		$0
3.	N/A	0	0.00%		$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA	N/A	0	0.00%	$0
RETIREMENT MATCH	N/A	0	0.00%	$0
OTHER PERCENT	N/A	0	0.00%	$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%	$0	$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%	$0	$0
PER POSITION INCREASE	N/A	0	0	$0	$0
NEXT YEAR			%
FICA	N/A	0	0.00%		$0
RETIREMENT MATCH	N/A	0	0.00%		$0
OTHER PERCENT	N/A	0	0.00%		$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%		$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%		$0
PER POSITION INCREASE	N/A	0	0		$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 7: 1-NMD INC

COST PER POSITION - NON-MONETARY DETERMINATIONS
Crosswalk Version: 2.5.1
1-NMD
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.	N/A	0	0.00%	$0
2.	N/A	0	0.00%	$0
3.	N/A	0	0.00%	$0
CURRENT YEAR
1. Default	N/A	12	3.00%	$0	$0
2.	N/A	0	0.00%	$0	$0
3.	N/A	0	0.00%	$0	$0
NEXT YEAR
1. Default	N/A	12	3.00%		$0
2.	N/A	0	0.00%		$0
3.	N/A	0	0.00%		$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA	N/A	0	0.00%	$0
RETIREMENT MATCH	N/A	0	0.00%	$0
OTHER PERCENT	N/A	0	0.00%	$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%	$0	$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%	$0	$0
PER POSITION INCREASE	N/A	0	0	$0	$0
NEXT YEAR			%
FICA	N/A	0	0.00%		$0
RETIREMENT MATCH	N/A	0	0.00%		$0
OTHER PERCENT	N/A	0	0.00%		$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%		$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%		$0
PER POSITION INCREASE	N/A	0	0		$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 8: 1-APP INC

COST PER POSITION - APPEALS
Crosswalk Version: 2.5.1
1-APP
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.	N/A	0	0.00%	$0
2.	N/A	0	0.00%	$0
3.	N/A	0	0.00%	$0
CURRENT YEAR
1. Default	N/A	12	3.00%	$0	$0
2.	N/A	0	0.00%	$0	$0
3.	N/A	0	0.00%	$0	$0
NEXT YEAR
1. Default	N/A	12	3.00%		$0
2.	N/A	0	0.00%		$0
3.	N/A	0	0.00%		$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA	N/A	0	0.00%	$0
RETIREMENT MATCH	N/A	0	0.00%	$0
OTHER PERCENT	N/A	0	0.00%	$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%	$0	$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%	$0	$0
PER POSITION INCREASE	N/A	0	0	$0	$0
NEXT YEAR			%
FICA	N/A	0	0.00%		$0
RETIREMENT MATCH	N/A	0	0.00%		$0
OTHER PERCENT	N/A	0	0.00%		$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%		$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%		$0
PER POSITION INCREASE	N/A	0	0		$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 9: 1-WR INC

COST PER POSITION - WAGE RECORDS
Crosswalk Version: 2.5.1
1-WR
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.	N/A	0	0.00%	$0
2.	N/A	0	0.00%	$0
3.	N/A	0	0.00%	$0
CURRENT YEAR
1. Default	N/A	12	3.00%	$0	$0
2.	N/A	0	0.00%	$0	$0
3.	N/A	0	0.00%	$0	$0
NEXT YEAR
1. Default	N/A	12	3.00%		$0
2.	N/A	0	0.00%		$0
3.	N/A	0	0.00%		$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA	N/A	0	0.00%	$0
RETIREMENT MATCH	N/A	0	0.00%	$0
OTHER PERCENT	N/A	0	0.00%	$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%	$0	$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%	$0	$0
PER POSITION INCREASE	N/A	0	0	$0	$0
NEXT YEAR			%
FICA	N/A	0	0.00%		$0
RETIREMENT MATCH	N/A	0	0.00%		$0
OTHER PERCENT	N/A	0	0.00%		$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%		$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%		$0
PER POSITION INCREASE	N/A	0	0		$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 10: 1-TAX INC

COST PER POSITION - TAX
Crosswalk Version: 2.5.1
1-TAX
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.	N/A	0	0.00%	$0
2.	N/A	0	0.00%	$0
3.	N/A	0	0.00%	$0
CURRENT YEAR
1. Default	N/A	12	3.00%	$0	$0
2.	N/A	0	0.00%	$0	$0
3.	N/A	0	0.00%	$0	$0
NEXT YEAR
1. Default	N/A	12	3.00%		$0
2.	N/A	0	0.00%		$0
3.	N/A	0	0.00%		$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA	N/A	0	0.00%	$0
RETIREMENT MATCH	N/A	0	0.00%	$0
OTHER PERCENT	N/A	0	0.00%	$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%	$0	$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%	$0	$0
PER POSITION INCREASE	N/A	0	0	$0	$0
NEXT YEAR			%
FICA	N/A	0	0.00%		$0
RETIREMENT MATCH	N/A	0	0.00%		$0
OTHER PERCENT	N/A	0	0.00%		$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%		$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%		$0
PER POSITION INCREASE	N/A	0	0		$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 11: 1-BPC INC

COST PER POSITION - BENEFIT PAYMENT CONTROL
Crosswalk Version: 2.5.1
1-BPC
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.	N/A	0	0.00%	$0
2.	N/A	0	0.00%	$0
3.	N/A	0	0.00%	$0
CURRENT YEAR
1. Default	N/A	12	3.00%	$0	$0
2.	N/A	0	0.00%	$0	$0
3.	N/A	0	0.00%	$0	$0
NEXT YEAR
1. Default	N/A	12	3.00%		$0
2.	N/A	0	0.00%		$0
3.	N/A	0	0.00%		$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA	N/A	0	0.00%	$0
RETIREMENT MATCH	N/A	0	0.00%	$0
OTHER PERCENT	N/A	0	0.00%	$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%	$0	$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%	$0	$0
PER POSITION INCREASE	N/A	0	0	$0	$0
NEXT YEAR			%
FICA	N/A	0	0.00%		$0
RETIREMENT MATCH	N/A	0	0.00%		$0
OTHER PERCENT	N/A	0	0.00%		$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%		$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%		$0
PER POSITION INCREASE	N/A	0	0		$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 12: 1-UIP INC

COST PER POSITION - UI PERFORMS
Crosswalk Version: 2.5.1
1-UIP
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.	N/A	0	0.00%	$0
2.	N/A	0	0.00%	$0
3.	N/A	0	0.00%	$0
CURRENT YEAR
1. Default	N/A	12	3.00%	$0	$0
2.	N/A	0	0.00%	$0	$0
3.	N/A	0	0.00%	$0	$0
NEXT YEAR
1. Default	N/A	12	3.00%		$0
2.	N/A	0	0.00%		$0
3.	N/A	0	0.00%		$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA	N/A	0	0.00%	$0
RETIREMENT MATCH	N/A	0	0.00%	$0
OTHER PERCENT	N/A	0	0.00%	$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%	$0	$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%	$0	$0
PER POSITION INCREASE	N/A	0	0	$0	$0
NEXT YEAR			%
FICA	N/A	0	0.00%		$0
RETIREMENT MATCH	N/A	0	0.00%		$0
OTHER PERCENT	N/A	0	0.00%		$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%		$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%		$0
PER POSITION INCREASE	N/A	0	0		$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 13: 1-SUP INC

COST PER POSITION - SUPPORT
Crosswalk Version: 2.5.1
1-SUP
0
NEXT YEAR
FY
	FY			FY	FY
	PREVIOUS			CURRENT	NEXT
	FISCAL YEAR			FISCAL YEAR	FISCAL YEAR

TOTAL PERSONAL SERVICE COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PS COST PER POSITION				$0	$0
PRIOR YEAR - PARTIAL	EFF. DATE	MOS.	DOLETA: Example: 1.00% should be entered as .01 %
1.	N/A	0	0.00%	$0
2.	N/A	0	0.00%	$0
3.	N/A	0	0.00%	$0
CURRENT YEAR
1. Default	N/A	12	3.00%	$0	$0
2.	N/A	0	0.00%	$0	$0
3.	N/A	0	0.00%	$0	$0
NEXT YEAR
1. Default	N/A	12	3.00%		$0
2.	N/A	0	0.00%		$0
3.	N/A	0	0.00%		$0
PS COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

TOTAL PERSONNEL BENEFIT COST	$0
TOTAL POSITIONS PAID	0.00
STRAIGHT LINE PB COST PER POSITION				$0	$0
CURRENT YEAR			%
FICA	N/A	0	0.00%	$0
RETIREMENT MATCH	N/A	0	0.00%	$0
OTHER PERCENT	N/A	0	0.00%	$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%	$0	$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%	$0	$0
PER POSITION INCREASE	N/A	0	0	$0	$0
NEXT YEAR			%
FICA	N/A	0	0.00%		$0
RETIREMENT MATCH	N/A	0	0.00%		$0
OTHER PERCENT	N/A	0	0.00%		$0
	EFF. DATE	MOS.	INC.
BENEFIT RATE INCREASE	N/A	0	0.00%		$0
INFLATIONARY INCREASE (DEFAULT)	N/A	12	3.00%		$0
PER POSITION INCREASE	N/A	0	0		$0
PB COST PER POSITION	$0			$0	$0
INCREASE PER YEAR				$0	$0

PS/PB COST PER POSITION	$0			$0	$0

Sheet 14: PS CONT CROSS

PS CONTRACTS CROSSWALK															15
Crosswalk Version: 2.5.1
0
FY
			INITIAL	WEEKS	NONMONETARY		WAGE						NOT
TOTAL PS CONTRACTS	Alloc	DOLLARS	CLAIMS	CLAIMED	DETER.	APPEALS	RECORDS	TAX	BPC	UI PERFORMS	SUPPORT	AS&T	CONVERTED	Balance
		0												DOL: This should equal the total amount converted. 0
TOTAL		0	0	0	0	0	0	0	0	0	0	0	0	0
CONTRACT IDENTIFIER
FEDERAL SOURCES
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
STATE SOURCES
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0
														0

TOTAL		0	0	0	0	0	0	0	0	0	0	0	0	0

ALLOCATED		0

DIFFERENCE-ALL TO CODES		0

DIFFERENCE-TOTAL PS CONT		0

SHEET IS DESIGNED TO ALLOW ADDITIONAL ROWS TO BE INSERTED - IF DONE MANUALLY INSTEAD OF BY USING BUTTONS AT TOP OF WORKSHEET, COPY FORMULAS IN B11 and FROM D11 through O11 TO ALL INSERTED ROWS.



SPLIT
SPLIT IT
IC
IC IT
WC
WC IT
NMD
NMD IT
APP
APP IT
WR
WR IT
TAX
TAX IT
BPC
BPC IT
UIP
UIP IT
SUP
SUP IT
AS&T
AS&T IT
NOT CONV
NO CNVT IT





														0

File Type	application/vnd.ms-excel
Author	Guest
Last Modified By	Thompson, Miriam - ETA
File Modified	2021-09-13
File Created	2002-09-18