LP_CyberLinks - CyberLinks workforce training model Inputs...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
TRAINING EMPLOYEES AT CYBERLINKS (Dynamic Workforce Planning) Cyberlinks is a chain of computer stores. During the next 5 months, the following numbers of ski hours will be needed: 6000 in January; 7000 in February; 8000 in March; 9500 in April; 11000 in beginning of January, Cyberlinks employs 50 skilled technicians. Each skilled technician can wo hours per month. To meet future demand, new technicians must be trained. It takes 1 month to t technician. During the month of training, a traniee must be supervised for 50 hours by an experie technician. Experienced technicians are paid $2000 per month and trainees are paid $1000 per their month of training. Historical data indicate that 5% of the compony's skilled technicians quit e Cyberlinks wants to use linear programming to determine a tarining schedule that minimizes the meeting the demands for the next 5 months.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
illed repair May. At the rk up to 160 train a new ienced month during each month. cost of
Background image of page 2
Exhibit 15
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CyberLinks workforce training model Inputs January skilled technicians 50 Hours/month/skilled technician 160 Supervision hours/trainee/month 50 Monthly pay/skilled technician $2,000 Monthly pay/trainee $1,000 Percentage quitters/month 5% Planning schedule Month 1 2 3 4 5 # of trainees 9 12 9 # of skilled technicians 50 47 54 63 69 # of quitters at end of month 3 2 3 3 3 Constraints on hours Available hours for repair 8000 7070 8040 9630 11040 >= >= >= >= >= Required hours for repair 6000 7000 8000 9500 11000 Cost summary Skilled technician costs $566,000 Trainee costs $30,000 Total cost $596,000 Range names used: InitTechs - B4 HrsPerTech - B5 HrsPerTrainee - B6 UnitTechCost - B7 UnitTraineeCost - B8 PctQuitters - B9 Trainees - B13:F13 Technicians - B14:F14 HrsAvailable - B18:F18 HrsReqd - B20:F20 TechCost - B23 TraineeCost - B24 TotCost - B25 A B C D E F G H I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25...
View Full Document

This note was uploaded on 05/31/2009 for the course MBA 4500 taught by Professor Eyupcetin during the Spring '09 term at Istanbul Technical University.

Page1 / 3

LP_CyberLinks - CyberLinks workforce training model Inputs...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online