How do you excel to solve this problem Overview Problem B 18

How do you excel to solve this problem???

Overview Problem B. 18 Exercise Scones 10 of 10 pts Assignment Score: 100%(60 60 pts) 3 of 3 complete Wichita\'s famous Sethi Restaurant is open 24 hours a day. Servers report for duty at 3 AM, 7 AM, 11 AM. 3 PM, 7 PM, or 11 P.M, and each works an 8-hour shift. The folowing table shows A the minimum umber of workers needed during the 6 periods into which the day is divided Decision vairable: x,=mmber of workers reporting for the start of working period i, where i = 1, 2, 3, 4,5, or 6 Period Time Number of Servers Required 13 AM.-7 AM 2 7AM.-11 A M 3 11AM.-3PM 3 P.M.-7PM 5 7 P.M.-11 P.M 1P.M-3 AM 15 10 13 57PM-1 should report for work at the start of each time period in der to miize the total staff required for one day\'s operation. Owner Avanti Sethi\'s scheduling problem is to determine how many servers (Hint: Let X, equal the number of servers beginning work in tine period i, where 1 1,2, 3,4, 5,6) Objective function Minimize z = x1+x2 + x, +x,+x,+x, Subject to (7 A.M-11 A.M) 11A M-1PM) x+ X2 212 Question is complete Simdar E Simdar Exercise O Ask me anything

Solution

X1+X2 >12

X1+X2 + X3>15

X1+X2 + X3 + X4>10

X1+X2 + X3 + X4+X5>13

X1+X2 + X3 + X4+X5+ X6 >4

X1+X2 + X3 + X4+X5+ X6 + X1>4

6(X1+X2 + X3 + X4+X5+ X6 ) < 12,15, 10,13,4,4

X1+X2 + X3 + X4+X5+ X6 <0

REDUCE THE WORKER

7AM TO 11 AM = 6 (12*1/2=6)

11AM TO 3 PM=5(15*1/3=5)

3PM TO7 PM=5(10*1/2=5)

7PM TO 11PM = 12(13-1=12)

11PM TO 3AM =2(4*1/2=2)

3 AM TO 7 AM =2(4*1/2=2)

6+5+5+12+2+2=32

__________________________________________________________________________________________