Question: Please show formulas in excel Weekly demand for a particular product averages 160 units, with a standard deviation of 6. This item is managed with

Please show formulas in excel

Weekly demand for a particular product averages 160 units, with a standard deviation of 6. This item is managed with a fixed-order-interval model. The order interval is 4 weeks and has a certain lead time of one week. The desired service level is 95 percent. Assume it is now time to place an order, and there are 32 units on hand. How many units should be ordered? (10 pts)

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!

must use excel & show formulas #5 5) Weekly demand for a particular product averages 120 units, with a standard deviation of 6. This item is managed with a fixed-order-interval model. The order...

HW 3- Submit work in 1 excel file with answer cells that contain the formulas for your calculations and indicate units as necessary 1) A firm has 77 units of a product on hand. Forecasts of demand...

please show excel formulas 5) Weekly demand for a particular product averages 120 units, with a standard deviation of 6. This item is managed with a fixed-order-interval model. The order interval is...

SHOW EXCEL FORMULAS FOR CROSS REFERENCING Weekly demand for a particular product averages 120 units, with a standard deviation of 8. This item is managed with a fixed-order-interval model. The order...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Weekly demand for a...

Please complete all work in excel. Use excel to make the calculations Weekly demand for a particular product averages 120 units, with a standard deviation of 6. This item is managed with a...

4) Weekly demand for a particular product averages 500 units, with a standard deviation of 30. This item is managed with a fixed-order-interval model. The order interval is 4 weeks, and this item has...

Which one of the following is implied by a lead time service level of 95 percent? Approximately 95 percent of demand during lead time will be satisfied. 95% of the time, demand during lead time will...

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

The binomial probability distribution is a family of probability distributions with each single distribution depending on the values of n and p. Assume that x is a binomial random variable with n =...

Let ff be a function from {1,3,7}{1,3,7) to (2, 4, 6, 8}(2, 4, pairs f = {(7,4), (1, 2), (3,8)}. 2. Let f: Z Zf: Z Z be defined by the equation f(x) = 5x - 2.f(x) = 5x - 2. Find the range of f. 3....

Calculating Financial Ratios (LO3) Find the following financial ratios for Earl Grey Golf Corp. (use year-end figures rather than average values where appropriate): Short-term solvency ratios a....

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...