Super City Discount Department Store is open 24 hours a day. The number of cashi

Question

Super City Discount Department Store is open 24 hours a day. The number of cashiers needed in each four-hour period of a day is listed below. Period Number of Cashiers Needed 00:00-04:00 3 04:00-08:00 5 08:00-12:00 7 12:00-16:00 8 16:00-20:00 8 20:00-00:00 5 The cashiers are scheduled to work for eight consecutive hours (they work 8-hour shifts) and the shifts can start at 0:00, 4:00, 8:00, 12:00, 16:00, or 20:00. You are asked to find a daily staffing plan to minimize the total number of cashiers scheduled while covering the number of cashiers needed in each period? Solve the problem with Excel Solver and report the optimal solution (minimum total number of cashiers scheduled over the 24-hour period.)

Explanation / Answer

X1, X2, X3, X4, X5, X6 0

There is infinitely many values of X1, X2, X3, X4, X5, X6 for the optimal value Z = 36, which are contained in the region of the space 0 X1 + 1 X2 + 1 X3 + 1 X4 + 1 X5 + 1 X6 = 36 that satisfies the constraints of the problem. One is:
X1 = 8
X2 = 0
X3 = 12
X4 = 3
X5 = 13
X6 = 0

MINIMIZE: 1 X1 + 1 X2 + 1 X3 + 1 X4 + 1 X5 + 1 X6 1 X1 + 1 X2 8
1 X2 + 1 X3 12
1 X3 + 1 X4 15
1 X4 + 1 X5 16
1 X5 + 1 X6 13
1 X1 + 1 X6 8

X1, X2, X3, X4, X5, X6 0

There is infinitely many values of X1, X2, X3, X4, X5, X6 for the optimal value Z = 36, which are contained in the region of the space 0 X1 + 1 X2 + 1 X3 + 1 X4 + 1 X5 + 1 X6 = 36 that satisfies the constraints of the problem. One is:
X1 = 8
X2 = 0
X3 = 12
X4 = 3
X5 = 13
X6 = 0

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.