J-27 (Wage Comparability Tool).xlsx

XLSX spreadsheet 69 KB Posted Oct 5, 2023

Attached to: Operation of the Los Angeles Job Corps Center
Solicitation number: 1605JW-23-R-00009
Issued by: Department of Labor Employment and Training Administration

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains instructions and templates for a monthly staff vacancy and separation report and quarterly salary supplement report for a Job Corps center operator. It includes templates for tracking authorized positions, on-board staff counts, separations, vacant positions, and salary details. Position categories and titles are provided in dropdown lists. The related federal contract opportunity is solicitation number 1605JW-23-R-00009 from the Department of Labor Employment and Training Administration to operate the Los Angeles Job Corps Center. Reporting requirements include a monthly staffing report and quarterly salary supplement report capturing staffing levels, vacancies, and salary details for center operator and subcontractor personnel.

View the file

Other files

File	Type	Posted
Amendment 3.pdf	PDF	Oct 16, 2023
J-12 (Utilities and Fuel Usage for April 2021-March 2022).pdf	PDF	Oct 12, 2023
Requests for Clarification and Government Responses (Final 10-12-2023).xlsx	XLSX spreadsheet	Oct 12, 2023
J-12 (Utilities and Fuel Usage for April 2023-YTD).pdf	PDF	Oct 12, 2023
J-12 (Utilities and Fuel Usage for April 2022-March 2023).pdf	PDF	Oct 12, 2023
Amendment 2 Los Angeles.pdf	PDF	Oct 12, 2023
J-12 (Utilities and Fuel Usage for April 2020- March 2021).pdf	PDF	Oct 12, 2023
J-11 (Inventory for BLDG 1031).xlsx	XLSX spreadsheet	Oct 5, 2023
J-7 (Past Performance Questionnaire).docx	DOCX document	Oct 5, 2023
J-11 (Food Inventory Dated Dec. 2022).xlsx	XLSX spreadsheet	Oct 5, 2023
J-25 (Frequently Asked Questions).pdf	PDF	Oct 5, 2023
J-24 (Career Transition Services Workload Statistics).xls	XLS spreadsheet	Oct 5, 2023
J-12 (Utilities and Fuel Usage for FY2022).pdf	PDF	Oct 5, 2023
J-11 (Inventory for BLDG 1049).xlsx	XLSX spreadsheet	Oct 5, 2023
J-10 (Electronic Property Management Listing).pdf	PDF	Oct 5, 2023
J-11 (Student Uniform Dated 1.31.2023).pdf	PDF	Oct 5, 2023
J-19 (Modification Number 1 to Lease Agreement).pdf	PDF	Oct 5, 2023
J-4 (Staffing Chart).xlsx	XLSX spreadsheet	Oct 5, 2023
J-20 (Sample Invoice).xlsx	XLSX spreadsheet	Oct 5, 2023
J-9 (Facility Survey Vol. 2_Part 1).pdf	PDF	Oct 5, 2023
J-6 (Subcontracting Plan Summary Sheet).docx	DOCX document	Oct 5, 2023
J-11 (COVID-19 Supplies Dated 12.30.2022).xls	XLS spreadsheet	Oct 5, 2023
J-8 (Statement and Acknowledgment).pdf	PDF	Oct 5, 2023
J-12 (Utilities and Fuel Usage for FY2021).pdf	PDF	Oct 5, 2023
J-9 (Facility Survey Vol. 1_Part 1).pdf	PDF	Oct 5, 2023
J-19 (Lease Agreement).pdf	PDF	Oct 5, 2023
J-11 (Inventory for BLDG 215).xlsx	XLSX spreadsheet	Oct 5, 2023
J-23 (Utility Cost Trend).pdf	PDF	Oct 5, 2023
J-19 (Modification Number 4 to Lease Agreement).pdf	PDF	Oct 5, 2023
J-11 (Kitchen Equipment).xlsx	XLSX spreadsheet	Oct 5, 2023
J-12 (Utilities and Fuel Usage for FY2020).pdf	PDF	Oct 5, 2023
J-28 (Updated Staff Compensation Plan).xlsx	XLSX spreadsheet	Oct 5, 2023
J-5 (List of Career Technical Skills Training Slots).docx	DOCX document	Oct 5, 2023
J-1 (Price Detail Template).xlsx	XLSX spreadsheet	Oct 5, 2023
J-22 (GSA Vehicle List).pdf	PDF	Oct 5, 2023
J-11 (Inventory for BLDG 1020).xls	XLS spreadsheet	Oct 5, 2023
J-2 (Statement of Financial Capability).docx	DOCX document	Oct 5, 2023
J-11 (Inventory for BLDG 221).xlsx	XLSX spreadsheet	Oct 5, 2023
Amendment 1.pdf	PDF	Sep 29, 2023
Solicitation for Los Angeles Job Corps Center.pdf	PDF	Sep 5, 2023

Show all 40

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Notes- Center Operators, please follow the steps below to complete the monthly Staff Vacancy and Separation Report (2110S), and quarterly Salary Supplement Report

Please see and follow instructions for each Section (1-3). Salary Supplement (Section 3) is presented in a separate Tab. Please fill this worksheet out in its entirety.

2110S Tab
Section 1-	Instructions for Completing the Center Staff Vacancy and Separation Report.
	COLUMN	ACTION
	Auth Positions	For each position category, enter the number of authorized staff. The source for Auth Positions is your J-28 Staff Compensation Plan. (Include Prime Contractor, Subcontractor, and National Training Contractor FTE).
	On-Board	Enter the On-Board EOM (End of Month) staff count for each category
	Separations	Enter the number of staff who separated from each category this month

Section 2-	Instructions for Completing the Report of Vacancies.
	COLUMN	ACTION
	Vacant Position Title	Include a row for each of the above positions that is vacant at the end of this month and use the position title drop-down listing. See the Universe List tab for all available position title options.
	Employee Number	Enter Employee Number of last employee who vacated the position
	Position Number	Obtain from Contract, attachment J.28 or from Modification to the Contract recognizing each position by number.
	Date Vacated	Enter the date that the position became vacant
	Calendar Days Vacant	Enter the number of calendar days that the position has been vacant
	Monthly Salary Value	Enter the Monthly Salary Value as identified in your J-28 Attachment. If employee separated during the month for which the Report is entered, enter N/A.

Salary Supplement Tab
Section 3-	Instructions for completing the Salary Supplement Report (due quarterly): Obtain the following information for each employee from your payroll system or other pertinent source:
	COLUMN	ACTION
	Employee Number	Obtain from payroll system; mask any PII-related values
	Position Category	Choose Position Category from drop-down list (Academic, CTT, Career Success, Support Service, Health and Wellness, CP/CTR, Administrative, Facilities Maint, Security, O/A, or CTS)
	Position Number	Obtain from Contract or from Modification to the Contract recognizing each position by number.
	Position Title	Select from dropdown menu in Column D
	Additional Title	Only input a position title if you cannot find an acceptable title in the dropdown
	Annualized Actual Salary	Obtain from payroll system
	Actual Average Benefits Ratio	Corporation's average benefits ratio is acceptable.
	FTE	Align to 2110S, excluding NTC positions
	Actual Hourly Rate	Obtain from payroll system

2110S - Vacancy Report

Job Corps Monthly Center Staff Vacancy and Separation Report

Center Name

Current Center Operator

Report for Month Ending

		Position Categories		Auth Positions
(From J-4 Staffing Plan)	On Board	Vacancies	Separations

Academic Staff
Academic Supervisor			- 0
Academic Instructors			- 0
Other Academic Staff			- 0
Career Technical Training Staff
Career Tech Instructor-Ctr			- 0
Career Tech lnstructors-NTC			- 0
Other Career Tech Staff			- 0
Career Success Staff
Sr. Residential Counselor or Advisor			- 0
Counselor			- 0
Residential Advisors			- 0
Art/Recreation Specialist			- 0
Other Career Success Staff			- 0
Support Services Staff
Food Service			- 0
Other Support Staff			- 0
Health and Wellness Staff
Nurses			- 0
Other Medical Staff			- 0
Career Prep/Transition Readiness Staff
CP/CTR Staff			- 0
Administration Staff
Center Director			- 0
Other Administration Staff			- 0
Maintenance Staff
Maintenance Staff			- 0
Security Staff
Security Staff			- 0
Outreach/Admissions Staff
Admissions Counselor			- 0
Other O/A Staff			- 0
Career Transition Services Staff
Career Transition Counselor			- 0
Other CTS Staff			- 0
Total	- 0	- 0	- 0	- 0
4% of Authorized Positions=	- 0		- 0

Report of Vacancies

Vacant Position Title Employee Number Position Number Date Vacated Calendar Days Vacant Monthly Salary Value

Salary Supplement

Center Name

Current Center Operator

Report for Month Ending

NOTE: You must select position titles from the drop down options in Column D for each employee; position titles are grouped by Category. If you cannot find a suitable title within the Category, you may select "Academic Other" or "Admin Other" or "CP/CTR Other" or "Career Success Other", etc., and enter the position title next to it in column E. Please do NOT copy and paste entries into column D.

Please omit NTC personnel and vacant positions from this report.

Salary Supplement (FTE total should agree with that reported in 2110S tab), excluding NTC

Employee Number Position Category Position Number Position Title Additional Title Annualized Actual Salary (not incl. fringe) Actual Average Benefits Ratio FTE Actual Hourly Rate

Version 2 August 2021

List by CatSS

Academic Staff	(-ACADEMIC CATEGORY-)
Academic Staff	Academic Instructor
Academic Staff	Academic Manager
Academic Staff	Drivers Education Instructor
Academic Staff	ESL Instructor
Academic Staff	Secretary/Admin Assistant
Academic Staff	Testing Coordinator
Academic Staff	Academic Other
Career Technical Training Staff	(-CTT CATEGORY-)
Career Technical Training Staff	CTT Instructor
Career Technical Training Staff	CTT Manager
Career Technical Training Staff	Secretary/Admin Assistant
Career Technical Training Staff	Work-Based Learning Coordinator
Career Technical Training Staff	CTT Other
Career Success Staff	(-CAREER SUCCESS CATEGORY-)
Career Success Staff	Career Success Director
Career Success Staff	Center Standards Officer
Career Success Staff	Counselor
Career Success Staff	Recreation Specialist
Career Success Staff	Recreation Supervisor
Career Success Staff	Residential Advisor
Career Success Staff	Secretary/Admin Assistant
Career Success Staff	Supervisory Residential Advisor
Career Success Staff	Career Success Other
Support Services Staff	(-SUPPORT SERVICES CATEGORY-)
Support Services Staff	Cook
Support Services Staff	Cook Helper
Support Services Staff	Dining Hall Manager
Support Services Staff	Dining Hall/Food Service Aide
Support Services Staff	Driver
Support Services Staff	Senior/Lead Cook
Support Services Staff	Support Services Other
Health and Wellness Staff	(-HEALTH AND WELLNESS CATEGORY-)
Health and Wellness Staff	Clerk/Receptionist
Health and Wellness Staff	Dental Assistant
Health and Wellness Staff	Dental Hygienist
Health and Wellness Staff	Dentist
Health and Wellness Staff	Health Services Administrator
Health and Wellness Staff	Laboratory Personnel
Health and Wellness Staff	Mental Health Consultant
Health and Wellness Staff	Registered Nurse
Health and Wellness Staff	Licensed Practical Nurse
Health and Wellness Staff	Optometrist
Health and Wellness Staff	Physician
Health and Wellness Staff	TEAP Specialist
Health and Wellness Staff	Health and Wellness Other
Career Prep/Transition Readiness Staff	(-CP/CTR CATEGORY-)
Career Prep/Transition Readiness Staff	Career Development Manager
Career Prep/Transition Readiness Staff	CP/CTR Instructor
Career Prep/Transition Readiness Staff	Secretary/Admin Assistant
Career Prep/Transition Readiness Staff	CP/CTR Other
Administration Staff	(-ADMIN CATEGORY-)
Administration Staff	Accountant
Administration Staff	Administration Manager/Director
Administration Staff	Bookkeeper/Accounting Clerk
Administration Staff	Bus/Community Liaison Specialist
Administration Staff	Center Director
Administration Staff	Deputy Center Director
Administration Staff	Executive Secretary/Office Manager
Administration Staff	Finance Manager
Administration Staff	HR Specialist/Benefits Assistant
Administration Staff	Human Resources (HR) Manager
Administration Staff	IT System Administrator
Administration Staff	Property/Supply Clerk
Administration Staff	Property/Supply Manager
Administration Staff	Purchasing Agent/Buyer
Administration Staff	Purchasing Clerk
Administration Staff	Secretary/Admin Assistant
Administration Staff	Student Records Clerk
Administration Staff	Student Records Manager
Administration Staff	Admin Other
Maintenance Staff	(-FACILITIES MAINTENANCE CATEGORY-)
Maintenance Staff	Clerk/Receptionist
Maintenance Staff	Groundskeeper
Maintenance Staff	Janitor/Custodian
Maintenance Staff	Maintenance Engineer
Maintenance Staff	Maintenance Manager
Maintenance Staff	Maintenance Technician
Maintenance Staff	Maintenance Worker
Maintenance Staff	Maintenance Other
Security Staff	(-SECURITY CATEGORY-)
Security Staff	Safety/Security Advisor
Security Staff	Security Guard/Officer
Security Staff	Security Manager
Security Staff	Sr. Security Officer
Security Staff	Security Other
Outreach/Admissions Staff	(-OA Staff Category)
Outreach/Admissions Staff	Admissions Counselor
Outreach/Admissions Staff	OA/CTS Director
Outreach/Admissions Staff	OA Manager
Outreach/Admissions Staff	Secretary/Admin Assistant
Outreach/Admissions Staff	OA Other
Career Transition Services Staff	(CTS Staff Category)
Career Transition Services Staff	Career Transition Counselor
Career Transition Services Staff	OA/CTS Director
Career Transition Services Staff	CTS Manager
Career Transition Services Staff	Secretary/Admin Assistant
Career Transition Services Staff	CTS Other

List by Cat2110S

(-ACADEMIC CATEGORY-)

Academic Instructor

Academic Manager

Drivers Education Instructor

ESL Instructor

Secretary/Admin Assistant

Testing Coordinator

(-CTT CATEGORY-)

CTT Instructor

CTT Manager

Secretary/Admin Assistant

Work-Based Learning Coordinator

(-CAREER SUCCESS CATEGORY-)

Career Success Director

Center Standards Officer

Counselor

Recreation Specialist

Recreation Supervisor

Residential Advisor

Secretary/Admin Assistant

Supervisory Residential Advisor

(-SUPPORT SERVICES CATEGORY-)

Cook

Cook Helper

Dining Hall Manager

Dining Hall/Food Service Aide

Driver

Senior/Lead Cook

(-HEALTH AND WELLNESS CATEGORY-)

Clerk/Receptionist

Dental Assistant

Dental Hygienist

Dentist

Health Services Administrator

Laboratory Personnel

Mental Health Consultant

Registered Nurse

Licensed Practical Nurse

Optometrist

Physician

TEAP Specialist

(-CP/CTR CATEGORY-)

Career Development Manager

CP/CTR Instructor

Secretary/Admin Assistant

(-ADMIN CATEGORY-)

Accountant

Administration Manager/Director

Bookkeeper/Accounting Clerk

Bus/Community Liaison Specialist

Center Director

Deputy Center Director

Executive Secretary/Office Manager

Finance Manager

HR Specialist/Benefits Assistant

Human Resources (HR) Manager

IT System Administrator

Property/Supply Clerk

Property/Supply Manager

Purchasing Agent/Buyer

Purchasing Clerk

Secretary/Admin Assistant

Student Records Clerk

Student Records Manager

(-FACILITIES MAINTENANCE CATEGORY-)

Clerk/Receptionist

Groundskeeper

Janitor/Custodian

Maintenance Engineer

Maintenance Manager

Maintenance Technician

Maintenance Worker

(-SECURITY CATEGORY-)

Safety/Security Advisor

Security Guard/Officer

Security Manager

Sr. Security Officer

(-OA STAFF CATEGORY-)

Admissions Counselor

OA/CTS Director

OA Manager

Secretary/Admin Assistant

(-CTS Staff Category-)

Career Transition Counselor

OA/CTS Director

CTS Manager

Secretary/Admin Assistant

Personnel Category List for SS

Academic

Career Technical Training

Career Success

Support Services

Health and Wellness

Career Preparation/Career Transition Readiness

Administration

Facilities Maintenance

Security

Outreach and Admissions

Career Transition Services

Universe list

2110 Category	2110 Sub Category	Position Title
Academic Staff	Academic Instructors	Academic Instructor
Academic Staff	Academic Supervisor	Academic Manager
Academic Staff	Academic Instructors	Drivers Education Instructor
Academic Staff	Academic Instructors	ESL Instructor
Academic Staff	Other Academic Staff	Secretary/Admin Assistant
Academic Staff	Other Academic Staff	Testing Coordinator
Academic Staff	Other Academic Staff	Academic Other
Career Technical Training Staff	Career Tech Instructor-Ctr	CTT Instructor
Career Technical Training Staff	Career Tech Instructor-Ctr	CTT Manager
Career Technical Training Staff	Other Career Tech Staff	Secretary/Admin Assistant
Career Technical Training Staff	Other Career Tech Staff	Work-Based Learning Coordinator
Career Technical Training Staff	Other Career Tech Staff	CTT Other
Career Success Staff	Other Career Success Staff	Career Success Director
Career Success Staff	Other Career Success Staff	Center Standards Officer
Career Success Staff	Counselor	Counselor
Career Success Staff	Art/Recreation Specialist	Recreation Specialist
Career Success Staff	Art/Recreation Specialist	Recreation Supervisor
Career Success Staff	Residential Advisors	Residential Advisor
Career Success Staff	Other Career Success Staff	Secretary/Admin Assistant
Career Success Staff	Sr. Residential Counselor or Advisor	Supervisory Residential Advisor
Career Success Staff	Other Career Success Staff	Career Success Other
Support Services Staff	Food Service	Cook
Support Services Staff	Food Service	Cook Helper
Support Services Staff	Food Service	Dining Hall Manager
Support Services Staff	Food Service	Dining Hall/Food Service Aide
Support Services Staff	Other Support Staff	Driver
Support Services Staff	Food Service	Senior/Lead Cook
Support Services Staff	Other Support Staff	Support Services Other
Health and Wellness Staff	Other Medical Staff	Clerk/Receptionist
Health and Wellness Staff	Other Medical Staff	Dental Assistant
Health and Wellness Staff	Other Medical Staff	Dental Hygienist
Health and Wellness Staff	Other Medical Staff	Dentist
Health and Wellness Staff	Other Medical Staff	Health Services Administrator
Health and Wellness Staff	Other Medical Staff	Laboratory Personnel
Health and Wellness Staff	Other Medical Staff	Mental Health Consultant
Health and Wellness Staff	Nurses	Registered Nurse
Health and Wellness Staff	Nurses	Licensed Practical Nurse
Health and Wellness Staff	Other Medical Staff	Optometrist
Health and Wellness Staff	Other Medical Staff	Physician
Health and Wellness Staff	Other Medical Staff	TEAP Specialist
Health and Wellness Staff	Other Medical Staff	Health and Wellness Other
Career Prep/Transition Readiness Staff	CP/CTR Staff	Career Development Manager
Career Prep/Transition Readiness Staff	CP/CTR Staff	CP/CTR Instructor
Career Prep/Transition Readiness Staff	CP/CTR Staff	Secretary/Admin Assistant
Career Prep/Transition Readiness Staff	CP/CTR Staff	CP/CTR Other
Administration Staff	Other Administration Staff	Accountant
Administration Staff	Other Administration Staff	Administration Manager/Director
Administration Staff	Other Administration Staff	Bookkeeper/Accounting Clerk
Administration Staff	Other Administration Staff	Bus/Community Liaison Specialist
Administration Staff	Center Director	Center Director
Administration Staff	Other Administration Staff	Deputy Center Director
Administration Staff	Other Administration Staff	Executive Secretary/Office Manager
Administration Staff	Other Administration Staff	Finance Manager
Administration Staff	Other Administration Staff	HR Specialist/Benefits Assistant
Administration Staff	Other Administration Staff	Human Resources (HR) Manager
Administration Staff	Other Administration Staff	IT System Administrator
Administration Staff	Other Administration Staff	Property/Supply Clerk
Administration Staff	Other Administration Staff	Property/Supply Manager
Administration Staff	Other Administration Staff	Purchasing Agent/Buyer
Administration Staff	Other Administration Staff	Purchasing Clerk
Administration Staff	Other Administration Staff	Secretary/Admin Assistant
Administration Staff	Other Administration Staff	Student Records Clerk
Administration Staff	Other Administration Staff	Student Records Manager
Administration Staff	Other Administration Staff	Admin Other
Maintenance Staff	Maintenance Staff	Clerk/Receptionist
Maintenance Staff	Maintenance Staff	Groundskeeper
Maintenance Staff	Maintenance Staff	Janitor/Custodian
Maintenance Staff	Maintenance Staff	Maintenance Engineer
Maintenance Staff	Maintenance Staff	Maintenance Manager
Maintenance Staff	Maintenance Staff	Maintenance Technician
Maintenance Staff	Maintenance Staff	Maintenance Worker
Maintenance Staff	Maintenance Staff	Maintenance Other
Security Staff	Security Staff	Safety/Security Advisor
Security Staff	Security Staff	Security Guard/Officer
Security Staff	Security Staff	Security Manager
Security Staff	Security Staff	Sr. Security Officer
Security Staff	Security Staff	Security Other
Outreach/Admissions Staff	Admissions Counselor	Admissions Counselor
Outreach/Admissions Staff	Other O/A Staff	OA/CTS Director
Outreach/Admissions Staff	Other O/A Staff	OA Manager
Outreach/Admissions Staff	Other O/A Staff	Secretary/Admin Assistant
Outreach/Admissions Staff	Other O/A Staff	OA Other
Career Transition Services Staff	Career Transition Counselor	Career Transition Counselor
Career Transition Services Staff	Other CTS Staff	OA/CTS Director
Career Transition Services Staff	Other CTS Staff	CTS Manager
Career Transition Services Staff	Other CTS Staff	Secretary/Admin Assistant
Career Transition Services Staff	Other CTS Staff	CTS Other

File details come from the government source that posted it. Updated Oct 5, 2023.