Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started