Question: Every day, Starbucks sources its supplies from a third - party warehouse located in Kent, WA . CDC is open daily from 7 am to

Every day, Starbucks sources its supplies from a third-party warehouse located in Kent, WA. CDC is open daily from 7 am to 11 pm, subject to local laws permitting them to be closed later. The chart below, which shows the bare minimum of Pickers required on the warehouse floor for every hour of the day, has been supplied by the planners:
Time Period Minimum number of employees
7 am -8 am 25
8 am -9 am 25
9 am -10 am 25
10 am -11 am 20
11 am -12 pm 20
12 pm -1 pm 10
1 pm -2 pm 10
2 pm -3 pm 10
3 pm -4 pm 10
4 pm -5 pm 20
5 pm -6 pm 20
6 pm -7 pm 20
7 pm -8 pm 20
8 pm -9 pm 25
9 pm -10 pm 25
10 pm -11 pm 25
Full-time employees at the CDC warehouse work a 9-hour shift (8 hours of work plus a 1 hour meal break) either from 7 am to 4 pm or from 2 pm to 11 pm.
Workers on the 7-4 shift are assigned an hour-long lunch break at either 10 am,11 am or 12 noon. Workers on the 2-11 shift are assigned an hour-long dinner break at either 5 pm,6 pm or 7 pm.
Part-time employees work four consecutive hours per day and their shifts can start any time between 7 am and 7 pm.
By corporate policy, which is consistent with local labor law, the company limits part-time hours to 50% of the day's total hours (part-time hours plus full-time hours) worked.
Part-time employees earn $300 per day, and full-time employees earn $750 per day in salary and benefits.
Create a staffing schedule for the CDC warehouse based on a minimal labor cost using the Excel solver.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!