Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management Processes and Supply Chains

Authors: Lee J. Krajewski, Larry P. Ritzman, Manoj K. Malhotra

10th edition

978-013280747, 132807394, 9780132951814, 132807475, 132951819, 978-0132807395

More Books

Students also viewed these General Management questions

Question

4. Is process variability recognised?

Answered: 1 week ago