Workforce Training Schedule for Logistics Skills Naval Surface Warfare Center, Crane, IN

1. Workforce Training Schedule for Logistics Skills Naval Surface Warfare Center, Crane, IN and University of Louisville Gail W. DePuy, John S. Usher and Ben Arterburn

2. Problem Description and Terminology • Each code or division of NSWC, Crane has a variety of JOBS to be completed • Total number of JOBS ≈ 100 • Each of these JOBS is made up of one or more TASKS • Total number of TASKS ≈ 500 • Each TASK of each JOB requires a SKILL LEVEL • SKILLS LEVELS = {1(novice), 2, 3, 4, 5(expert)} • Multiple JOBS can require the same TASK at different SKILL LEVELS. • The SKILL LEVEL of each EMPLOYEE for each TASK is determined by their supervisor • Total number of EMPLOYEES ≈ 200

3. Problem Description and Terminology • EMPLOYEES are assigned to TASKS. • Multiple EMPLOYEES can be assigned to the same TASK. • Each EMPLOYEE can be assigned to multiple TASKS. • A SKILLS GAP exists when the EMPLOYEE assigned to a TASK does not have a high enough SKILL LEVEL for that TASK. • There is a TRAINING COST associated with raising an employee’s SKILL LEVEL for a particular TASK. • A TRAINING SCHEDULE must be developed to determine which employees are going to receive training in which TASKS such that all required JOB TASK SKILL LEVELS are met.

4. Employee 1 Task 8: skill level = 2 Task 27: skill level = 1 Task 145: skill level = 2 Employee 2 Task 43: skill level = 5 Task 64: skill level = 3 Task 90: skill level = 5 Task 187: skill level = 5 Employee N Job 1 Task 14: skill level = 4 Task 56: skill level = 1 Task 90: skill level = 3 Task 187: skill level =4 Job 2 Task 3: skill level = 4 Task 27: skill level = 3 Task 90: skill level = 3 Job M Problem Description Skills Gap (T27)

5. Project Objective • Develop an automated tool to assign employees to job tasks based on skills/requirements profiles as well as generate the lowest cost training schedule to resolve current skills gaps

6. Research Activities • Evaluation of commercial off the shelf (COTS) skills management software packages (completed) • Since no COTS software package meets all of Crane’s needs, a software tool will be developed • Assign employees to jobs based on skills/requirements profiles and generate a training schedule to best address identified skills gaps. • A mathematical model will be used to find the optimal training schedule (completed).

7. Research Activities • Verification and validation of developed software tool using data generated by UofL research team. • Generation and analysis of training schedule(s) using data provided by Crane. • Documentation • COTS review • Software • Results and analysis

8. Skills Management Math Model Assign workers to job tasks to minimize training cost Parameters • Sik = worker i’s skill level for task k • Rjk = required skill level for job j’s task k • Tjk = length (# hrs) of job j’s task k • Ai = capacity (# hrs) of worker i • H = total number of hours/worker in planning horizon • Cklm = cost associated with raising a worker’s skill level on task k from level l to level m Decision Variables • Xijk = # hrs worker i spends on job j’s task k • = 1 if worker i receives training on task k to raise skill level from Sik to m

9. Skills Management Math Model

10. Deliverables • Detailed report summarizing the appropriateness of each COTS skills management software package with respect to Crane’s needs. • Develop skills management software tool to assign employees to jobs and generate a training schedule to best address identified skills gaps. • Software documentation. • Software training. • A final project report to contain the results of the skills management tool using the data provided by Crane.

11. Plan of Actions and Milestones