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 thirdparty warehouse located in Kent, WA CDC is open daily from am to 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
am am
am am
am am
am am
am pm
pm pm
pm pm
pm pm
pm pm
pm pm
pm pm
pm pm
pm pm
pm pm
pm pm
pm pm
Fulltime employees at the CDC warehouse work a hour shift hours of work plus a hour meal break either from am to pm or from pm to pm
Workers on the shift are assigned an hourlong lunch break at either am am or noon. Workers on the shift are assigned an hourlong dinner break at either pm pm or pm
Parttime employees work four consecutive hours per day and their shifts can start any time between am and pm
By corporate policy, which is consistent with local labor law, the company limits parttime hours to of the day's total hours parttime hours plus fulltime hours worked.
Parttime employees earn $ per day, and fulltime employees earn $ per day in salary and benefits.
Create a staffing schedule for the CDC warehouse based on a minimal labor cost using the Excel solver. How dangerous is this timetable? What would you want to see changed? Explain your answers in a note that is a text box included in the Excel sheet.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
