This is an individual assignment due at the end of the week, Sunday @ 11:59 PM

Complete the customer demand and manufacturing tab per the directions in the data set tab.    Attach that completed spreadsheet for your upload.

In addition, answer these questions:

1.  Will holding 2 days of safety meet a 95% service level (Yes or No)

2.   If your warehouse can physically only hold a max of 400 units, can you use a 99% service level (Yes or No)

3.   For manufacturing, will holding 4 hours of safety stock using 2 8-hour shifts meet the 95% service level (Yes or No)

4.   If your budget for safety stock is $30,000, can you have a 99% service level? (Yes or No)

   

Transcribed Image Text:

Period Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Average Volume Statistical Safety Stock Calculation Forecast Actual Desired Service Level 95% 99% 99.93% 100.00% #DIV/0! Days Safety Stock Daily volume Safety Stock Z-value Safety Stock 1.65 2.33 3.2 4 Time Based Safety Stock Calculation #DIV/0! #DIV/0! #DIV/0! 0 0 OOO 0 Variance 0 0 0 0 0 0 0 0 0 0 0 0 Sum Sq. Var Sq. Rt of Sum Sq. Var/(n-1) Inventory Value Safety Stock Value $0.00 $0.00 $0.00 $0.00 Variance Sq 0 OOO OO 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Todd Brundrett: Square root of the sum of the squared variances from the forecast divided by the number of periods - 1 Enter information in areas shaded in green only Period Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Average Volume Statistical Safety Stock Calculation Forecast Actual Desired Service Level 95% 99% 99.93% 100.00% #DIV/0! Days Safety Stock Daily volume Safety Stock Z-value Safety Stock 1.65 2.33 3.2 4 Time Based Safety Stock Calculation #DIV/0! #DIV/0! #DIV/0! 0 0 OOO 0 Variance 0 0 0 0 0 0 0 0 0 0 0 0 Sum Sq. Var Sq. Rt of Sum Sq. Var/(n-1) Inventory Value Safety Stock Value $0.00 $0.00 $0.00 $0.00 Variance Sq 0 OOO OO 0 0 0 0 0 0 0 0 0 0 0 0 0.00 Todd Brundrett: Square root of the sum of the squared variances from the forecast divided by the number of periods - 1 Enter information in areas shaded in green only

Answer rating: 100% (QA)

The Data menu also contains many important functions in Excel including i... View the full answer