Answered step by step
Verified Expert Solution
Link Copied!

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 6-15 and Excel to solve Problem 6-32 please. Thank you :) 20.6-32 Consider the staffing situation faced by the Gaubert Marketing Company in Problem 6-15. Ignore the salary and part-time 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 1: Use at most 27 total employees weight =50 Goal 2: Minimize the excess employees scheduled on Saturday weight =30 Goal 3: Minimize the excess employees scheduled on Sunday weight =203.6-15 The Gaubert Marketing Company needs the following number of telemarketers on the phones during the upcoming week: Monday 23, Tuesday 16, Wednesday 21, Thursday 17, Friday 20, Saturday 12, and Sunday 15. Each employee works five consecutive days followed by 2 days off per week. How many telemarketers should be scheduled each day of the week to begin their five-day 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 $90, pay for Saturday is $110, and Sunday workers earn $125. In addition, up to four people can be hired who will work Friday, Saturday, and Sunday. Their pay for this three-day week is $250. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these General Management questions