ETA 9221 Construction and Rehab Report (CRA)

---

Overview

CRA STATUS REPORT
INSTRUCTIONS (CRA)
ERF STATUS REPORT
INSTRUCTIONS (ERF)
B1 CRA ETA 2110 RECONCILIATION
INSTRUCTIONS (RECON)
Fund Codes

---

Sheet 1: CRA STATUS REPORT

(1)	CENTER NAME	Hilltop Job Corps Center					(2)	FOR QUARTER ENDING		09/30/14		(3)	CY END		12/31/14
(4)	CENTER NUMBER	00101					(5)	CONTRACT NUMBER		DOLJ1300017		(6)	CENTER OPERATOR		ABC Corportation
(7)	(8)	(9)	(10)	(11)		(12)	(13)	(14)	(15)	(16)	(17)	(18)		(19)	(20)	(21)
				Contract Modification								Project Dates
Deficiency ID# or FOP#	Project Description and Location	FUND CODE	Fund Expiration	Number	Date	Amount Funded	Amount Expensed	Undelivered Commitments	Cost to Complete	Estimated Project Cost Total Cost	Balance	Start	End	Percent Complete	Remarks	Approved Complete RO/ESC
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
			-							$-	$-
Add rows if necessary - Right Click - Insert Row Above.			-							$-	$-
TOTAL						$-	$-	$-	$-	$-	$-

---

Sheet 2: INSTRUCTIONS (CRA)

LINE	TITLE	DESCRIPTION
1	CENTER NAME	Enter the full name of the center.
2	FOR QUARTER ENDING	Enter the last day of the calendar quarter for which the report is being submitted i.e. 3/31, 6/30, 9/30, 12/31.
3	CY END	Enter the current contract year end date.
4	CENTER NUMBER	Enter the full center number
5	CONTRACT NUMBER	Enter the full contract number
6	CENTER OPERATOR	Enter the Center’s ID number. Each Job Corps Center is assigned a unique DOL identification number. This number is listed on the top right hand corner of the cover page on the facility survey. It is also listed on the monthly Design and Construction Status Reports
7	DEFICIENCY ID# OR FOP #	Enter the CRA Deficiency ID # if available. If it is not available. Enter the FOP# in which the amounts were funded. Once the Deficiency ID is known, update the report.
8	PROJECT DESCRIPTION AND LOCATION	Enter a complete description of the project including building number.
9	FUND CODE	Enter or select the Fund Code (part of the appropriation string) from the Contract Modification. The Fund Code is located in Block 12 of the Contract Modification and is usually the four digits in positions 7-10. It is the same number recorded in Funded Not Corrected when funds are received.
10	FUND EXPIRATION	Automatic - Calculates the Expiration Date of the funds based on the fund code.
11	CONTRACT MODIFICATION # AND DATE	Enter the contract modification number and date of the mod approval by the Contracting Officer.
12	AMOUNT FUNDED	Enter the amount funded for each project. If funding is deobligated the expiration of a contract year, the funded amount will be reduced and remarks should be included.
13	AMOUNT EXPENSED	Enter the amount Expensed. The amount expensed must equal the sum of vouchered reimbursable, unvouchered reimbursable, and unvouchered accounts payable listed on the ETA 2110.
14	UNDELIVERED COMMITMENTS	Enter the total amount undelivered commitments (open purchase orders). This should also reconcile with the ETA 2110
15	COST TO COMPLETE	Enter the amount of funding needed to complete the project. This amount is the anticipated costs that have not been paid or otherwise commited to the project. For instance, if funds were just received, the entire amount should be listed in "Cost to Complete."
16	ESTIMATED PROJECT TOTAL COST	Automatic - This column automatically calculates the sum of columns 12 through 15 to determine the total costs of the project.
17	BALANCE	Automatic - This column automatically calculates the difference between the Amount Funded (12) and the Estimated Project Total Cost (16).
18	PROJECT START AND END DATES	Enter the subcontract award or start date and anticipated completion date or completion date.
19	PERCENT COMPLETE	Enter the percentage of work in place (actual work completed). Do not enter the percentage of funds obligated to date.
20	REMARKS	Enter the description of the status of the project and any pertinent data related to the project.
21	APPROVED COMPLETED RO/ESC	When the project is complete the center should notify the region and the engineering support contractor (ESC) (PBDewberry) to schedule inspection. Enter the initials of the ESC or RO project manager who confirmed completion.

---

Sheet 3: ERF STATUS REPORT

(1)	CENTER NAME	Hilltop Job Corps Center					(2)	FOR QUARTER ENDING		09/30/14		(3)	CY END DATE		12/31/14
(4)	CENTER NUMBER	00101					(5)	CONTRACT NUMBER		DOLJ1300017		(6)	CENTER OPERATOR		ABC Corportation
(7)	(8)	(9)	(10)	(11)		(12)	(13)	(14)	(15)	(16)	(17)		(18)	(19)		(20)
				Modification or Approval			Amount Expensed	Undelivered Commitments	Cost to Complete	Estimated Project Costs	Project Dates		Percent Complete	Remarks		Approved Complete RO/ESC
Deficiency ID# or FOP#	Project Description and Location	FUND CODE	Fund Expiration	Number	Date	Amount Funded					Start	End
	INITIAL FUNDING		-
	REPLENISHMENT		-
			-
			-
			-
			-
			-
TOTAL						$-
				RD Approval Date
		LEAVE BLANK				LEAVE BLANK				$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
										$-
TOTALS							$-	$-	$-	$-	FUND BALANCE			$0

---

Sheet 4: INSTRUCTIONS (ERF)

LINE

TITLE

DESCRIPTION

1

CENTER NAME

Enter the full name of the center.

2

FOR QUARTER ENDING OR REPORT DATE

Enter the report date or if a quarterly report, enter the last day of the calendar quarter for which the report is being submitted i.e. 3/31, 6/30, 9/30, 12/31.

3

CY END

Enter the current contract year end date.

4

CENTER NUMBER

Enter the full contract number

5

CONTRACT NUMBER

Enter the full contract number

6

CENTER OPERATOR

Enter the Center’s ID number. Each Job Corps Center is assigned a unique DOL identification number. This number is listed on the top right hand corner of the cover page on the facility survey. It is also listed on the monthly Design and Construction Status Reports

7

DEFICIENCY ID# OR FOP #

Enter the CRA Deficiency ID # if available. If it is not available. Enter the FOP# in which the amounts were funded. Once the Deficiency ID is known, update the report.

8

PROJECT DESCRIPTION AND LOCATION

Enter the funding provided or deobligated in the top portion. Enter a complete description of the project including building number in the bottom portion.

9

FUND CODE

Enter or select the Fund Code (part of the appropriation string) from the Contract Modification. The Fund Code is located in Block 12 of the Contract Modification and is usually the four digits in positions 7-10. It is the same number recorded in Funded Not Corrected when funds are received.

10

FUND EXPIRATION

Automatic - Calculates the Expiration Date of the funds based on the fund code.

11

CONTRACT MODIFICATION # AND DATE

Enter the contract modification number and date of the mod approval by the Contracting Officer.

12

AMOUNT FUNDED

Enter the amount funded for each project. If funding is deobligated the expiration of a contract year, the funded amount will be reduced and remarks should be included.

13

AMOUNT EXPENSED

Enter the amount Expensed. The amount expensed must equal the sum of vouchered reimbursable, unvouchered reimbursable, and unvouchered accounts payable listed on the ETA 2110.

14

UNDELIVERED COMMITMENTS

Enter the total amount undelivered commitments (open purchase orders). This should also reconcile with the ETA 2110

15

COST TO COMPLETE

Enter the amount of funding needed to complete the project. This amount is the anticipated costs that have not been paid or otherwise commited to the project. For instance, if funds were just received, the entire amount should be listed in "Cost to Complete."

16

ESTIMATED PROJECT TOTAL COST

Automatic - This column automatically calculates the sum of columns 12 through 15 to determine the total costs of the project.

17

PROJECT START AND END DATES

Enter the subcontract award or start date and anticipated completion date or completion date.

18

PERCENT COMPLETE

Enter the percentage of work in place (actual work completed). Do not enter the percentage of funds obligated to date.

19

REMARKS

Enter the description of the status of the project and any pertinent data related to the project.

20

APPROVED COMPLETED RO/ESC

When the project is complete the center should notify the region and the engineering support contractor (ESC) (PBDewberry) to schedule inspection. Enter the initials of the ESC or RO project manager who confirmed completion.

---

Sheet 5: B1 CRA ETA 2110 RECONCILIATION

(1)	CENTER NAME	Hilltop Job Corps Center		(5)	CONTRACT NUMBER		DOLJ1300017
(2)	FOR QUARTER ENDING	09/30/14		(6)	CENTER OPERATOR		ABC Corportation
(3)	CY END	12/31/14		(7)	ETA 2110 DATE		09/30/14
(5)	CENTER NUMBER	00101
(8)		(9)	(10)	(11)	(12)	(13)	(14)
							Balance
Category		Amount Funded	Amount Expensed	Undelivered Commitments	Cost to Complete	Estimated Project Cost
CRA FUNDS		$0	$0	$0	$0	$0	$0
EMERGENCY FUNDS		$0	$0	$0	$0	$0	$0
TOTAL B1 FUNDS		$0	$0	$0	$0	$0	$0
(15)		(16)	(17)	(18)	(19)	(20)	(21)
ETA 2110, Page 4, Section E. Conractor Obligations							Balance
		Contract Funding	Vouchered Reimbursable	Unvouchered Reimbursable	Undelivered Commitements	Total Obligations
		Row E.2. Column (f)	Row E.2. Column (a)	Row E.2. Column (b)	Row E.2. Column (d)	Row E.2. Column (e)
CONSTRUCTION/FACILITY REHAB		$213,200	$150,000	$34,250	$12,000	$196,250	$16,950
Less: COST TO COMPLETE						(22)	$0
BALANCE						(23)	$16,950
BALANCE CHECK						(24)	NO

---

Sheet 6: INSTRUCTIONS (RECON)

LINE	TITLE	DESCRIPTION
1	CENTER NAME	Enter the full name of the center.
2	FOR QUARTER ENDING OR REPORT DATE	Enter the report date or if a quarterly report, enter the last day of the calendar quarter for which the report is being submitted i.e. 3/31, 6/30, 9/30, 12/31.
3	CY END	Enter the current contract year end date.
4	CENTER NUMBER	Enter the full contract number
5	CONTRACT NUMBER	Enter the full contract number
6	CENTER OPERATOR	Enter the Center’s ID number. Each Job Corps Center is assigned a unique DOL identification number. This number is listed on the top right hand corner of the cover page on the facility survey. It is also listed on the monthly Design and Construction Status Reports
7	ETA 2110 DATE	Enter the data of the ETA 2110 month end report used for the reconciliation.
8	CATEGORY	Automatic - Describes the funding type for all B1 funds. No entry required.
9	AMOUNT FUNDED	Automatic - Pulls the funding data from the Quarterly CRA Status Report and the Emergency Funding Request Report.
10	AMOUNT EXPENSED	Automatic - The amount expensed is pulled from the Quarterly CRA Status Report and the Emergency Funding Request Report.
11	UNDELIVERED COMMITMENTS	Automatic - The undelivered commitments are pulled from the Quarterly CRA Status Report and the Emergency Funding Request Report.
12`	COST TO COMPLETE	Automatic - The cost to complete figures are pulled from the Quarterly CRA Status Report and the Emergency Funding Request Report.
13	ESTIMATED PROJECT TOTAL COST	Automatic - This column automatically calculates the sum from the Quarterly CRA Status Report and the Emergency Funding Request Report.
14	BALANCE	Automatic - This column automatically calculates balance of funds available that are not expensed, committed or otherwise reserved for approved projects.
15 - 20	ETA 2110 CONTRACTOR OBLIGATIONS	Enter the applicable information in columns 16 thorugh 20 from the ETA 2110 report. The column headings show where to pull the data from the report.
21	BALANCE	Automatic - Calculates the difference between expenses (vouchered, unvouchered, and commitments) versus funding levels. This block does not consider "cost to complete."
22	LESS: COST TO COMPLETE	Automatic - Adjustment to capture cost to complete of CRA and Emergency Funded Projects
23	BALANCE	Automatic - Calculates the difference between the ETA 2110 (21) less the cost to complete (22).
24	BALANCE CHECK	Automatic - "Yes" if in balance, "No" if out of balance.

---

Sheet 7: Fund Codes

Code	Expiration
1316	6/30/2016
1417	6/30/2017
1518	6/30/2018
1619	6/30/2019
1720	6/30/2020
1821	6/30/2021
1922	6/30/2022
2023	6/30/2023
2124	6/30/2024
2225	6/30/2025
2326	6/30/2026
2427	6/30/2027
2528	6/30/2028
2629	6/30/2029
2730	6/30/2030
2831	6/30/2031
2932	6/30/2032
3033	6/30/2033