Question: We are open 9 am - 7 pm monday - saturday and 1 0 am - 6 pm sunday. You want to maximize performance. Your

We are open 9am -7pm monday - saturday and 10am -6pm sunday.
You want to maximize performance. Your workers have different capabilities (skill levels). So, give each worker a skill level.
Variables:
You must identify at least 3 different job types. (e.g. Managers, Sales, and Technicians)
Each job type has at least 3 different skill levels. (e.g. senior, mid-career, entry)
You must have 50 employees. Think about this. How many of each make sense in your business?
Such that:
No partial days worked. (integer solution)
Your employees can only work the jobs they are designated for. (a driver cannot be a sales clerk)
You can decide if your company works 5 days a week or 7.
You can decide if your company works 1,2, or 3 shifts a day.
You must try to have everyone work an equal number of days. It is OK to have someone in each job type work one day more or less than another, but not 2 days.
Every job type must work every day. ( you can't have a day with no workers or no managers )
If you need more clarification while doing this assignment, ask.
Explain your problem and solution with comments or text.
Solve and attach code (LINGO or Excel) and results (the two report types).
BONUS: design an objective formula that accounts for BOTH performance and cost.
You want to maximize performance,
You want to minimize costs paid (salaries)
There are varying salaries based on job types and skill levels

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!