Formulate this as a covering problem and solve it with the Excel solver.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter5: Network Models
Section: Chapter Questions
Problem 1C
icon
Related questions
Question
Exercise 6.13 The required staffing in a call center, from 9am to 9pm in 30-minute
intervals, is as follows:
10, 11, 13, 16, 16, 13, 11, 10, 10, 11, 12, 13, 14, 14, 13, 11, 10, 9, 9, 10, 9, 8, 8, 8.
There are 2 types of shifts:
- 8 hours working time, with a 30-minute unpaid break in the middle, wage 20
108
100
Koole – Business Analytics
Euro/hr, possible starting times every half hour from 9am to 12:30pm;
-4 hours consecutive, wage 24 Euro/hr, possible starting times every half hour from
9am to 5pm.
Formulate this as a covering problem and solve it with the Excel solver.
Machine scheduling is another important class of ILO problems. However,
because it involves some modeling tricks that are discussed in Section 6.7,
we defer discussing it to that section.
The next two exercises concern problems that can be solved with appro-
priately chosen binary decision variables.
Th
Transcribed Image Text:Exercise 6.13 The required staffing in a call center, from 9am to 9pm in 30-minute intervals, is as follows: 10, 11, 13, 16, 16, 13, 11, 10, 10, 11, 12, 13, 14, 14, 13, 11, 10, 9, 9, 10, 9, 8, 8, 8. There are 2 types of shifts: - 8 hours working time, with a 30-minute unpaid break in the middle, wage 20 108 100 Koole – Business Analytics Euro/hr, possible starting times every half hour from 9am to 12:30pm; -4 hours consecutive, wage 24 Euro/hr, possible starting times every half hour from 9am to 5pm. Formulate this as a covering problem and solve it with the Excel solver. Machine scheduling is another important class of ILO problems. However, because it involves some modeling tricks that are discussed in Section 6.7, we defer discussing it to that section. The next two exercises concern problems that can be solved with appro- priately chosen binary decision variables. Th
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,