Question
Please, before you answer, READ THIS NOTE I need this to be solved using excel and solver. If you can't do it by using excel
Please, before you answer, READ THIS NOTE
I need this to be solved using excel and solver. If you can't do it by using excel please don't waste your time. Thank you Kindly
Starbucks uses a third-party warehouse in Kent, WA to supply its stores daily. Throughout the day to the extent permitted by local law, CDC is open from 7 am - 11 pm every day. Planners have provided the following table, which identifies the minimum number of Pickers needed on the floor of the warehouse each hour of the day: 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.
Use excel solver to set up a minimum labor cost staffing schedule for the CDC warehouse. How risky is this schedule? Would you want to change anything? Justify your responses in a note embedded in the excel sheet as a text box.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started