calculated financial maneuver, E-Power Inc. has acquired a new manufacturing facility for producing small electric motors. You have been asked to provide an answer to the following question: How many new personnel should be hired and trained, or laid off, over each of the next six months? The labor requirements and monthly wage rates for trained employees are given in the following table.
In a calculated financial maneuver, E-Power Inc. has acquired a new manufacturing facility for producing small electric motors. You have been asked to provide an answer to the following question: How many new personnel should be hired and trained, or laid off, over each of the next six months? The labor requirements and monthly wage rates for trained employees are given in the following table.
Trainees can be hired at the beginning of each month. One consideration to take into account is that workers must have one month of classroom instruction before they can work in manufacturing. Therefore, a trainee must be hired a month before the worker is actually needed. Each classroom student uses 60 hours of a trained employee’s time, so there are 60 fewer hours available for manufacturing. Each trained employee can work up to 180 hours a month (total time, instructing plus in manufacturing). Management may lay off at most 15% of the trained employees at the beginning of the month, but must pay one-half-month’s wage for severance pay. A trainee is paid 40% of regular wages for a trained employee during their training month. There are 46 trained employees available at the beginning of January. Formulate this hiring-andtraining-and-layoffs model as a linear programming spreadsheet model using EXCEL SOLVER.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
