Question: please fill in excel sheet answers thanks! and answer question Weekly demand for Motorola cell phones at a Best Buy store is normally distributed with

please fill in excel sheet answers thanks! and answer question

Weekly demand for Motorola cell phones at a Best Buy store is normally distributed with a mean of 300 and a standard deviation of 200. Motorola takes two weeks to supply a Best Buy order. Best Buy is targeting a cycle service level of 95 percent and monitors its inventory continuously. How much safety inventory of cell phones should Best Buy carry? What should their reorder point be? Inputs Average demand per unit time, D = Lead time, L = SD of demand per unit time, oD = Target cycle service level 300 2 200 0.95 Distribution of Demand during Lead Time Mean demand during lead time, DL = SD of demand during lead time, oL = Output Safety inventory, ss = Reorder point, ROP =

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!

Question 4: (34 marks total) Big Machines Corp. has two divisions. Division Y manufactures components that can be sold in the external market place or transferred to Division Z for further...

Question 1 ( for Reference ) Weekly demand for Motorola cell phones at a Best Buy store is normally distributed with a mean of 3 0 0 and a standard deviation of 2 0 0 . Motorola takes two weeks to...

Homework 6 Managing Uncertainty in a Supply Chain Homework Questions Question 1 Weekly demand for Motorola cell phones at a Best Buy store is normally distributed with a mean of 3 0 0 and a standard...

Assume that the Best Buy store has a policy of ordering cell phones from Motorola in lots of 500. Weekly demand for Motorola cell phones at the store is normally distributed with a mean of 300 and a...

Assume that the Best Buy store in Question 1 has a policy of ordering cell phones from Motorola in lots of 5 0 0 0 . Weekly demand for Motorola cell phones at the store is normally distributed with a...

Question 5 ONLY 5 . Assume that the Best Buy store in Exercise 3 has a policy of 3 . Weekly demand for Motorola cell phones at a Best Buy store ordering cell phones from Motorola in lots of 5 0 0 ....

MGT645 Homework Assignment 1 (Due Sept. 5th) 1. A company has two stores located in different regions. Each store holds an inventory of 80 units. Demand in each region can be either high or low and...

A bond with a coupon rate of 8 percent sells at a yield to maturity of 9 percent. If the bond matures in 17 years, what is the Macaulay duration of the bond? What is the modified duration?

Bretts Guitars prices its products using a 40% markup on total variable cost to cover fixed costs and to provide a reasonable return on investment. Using the following data and the contribution...

o 1 7 - 1 3 An auditor would be most likely to identify a contingent liability by obtaining a ( n ) . . .

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...