Question: Use Problem 6 - 1 5 and Excel to solve Problem 6 - 3 2 please. Thank you :) 2 0 . 6 - 3
Use Problem and Excel to solve Problem please. Thank you :) Consider the staffing situation faced by the Gaubert Marketing Company in Problem Ignore the salary and parttime information given in part b of that problem. Develop a schedule that meets the daily employee requirements and satisfices the following three weighted goals: Goal : Use at most total employees weight Goal : Minimize the excess employees scheduled on Saturday weight Goal : Minimize the excess employees scheduled on Sunday weight The Gaubert Marketing Company needs the following number of telemarketers on the phones during the upcoming week: Monday Tuesday Wednesday Thursday Friday Saturday and Sunday Each employee works five consecutive days followed by days off per week. How many telemarketers should be scheduled each day of the week to begin their fiveday work week? The objective is to minimize the total number of employees needed to fulfill the daily requirements. a Solve as an IP model. b Additional information is now available for Gaubert. Daily pay from Monday through Friday is $ pay for Saturday is $ and Sunday workers earn $ In addition, up to four people can be hired who will work Friday, Saturday, and Sunday. Their pay for this threeday week is $ The new objective is to minimize total weekly labor costs. Revise the IP model and solve it
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
