Question: must use excel & show formulas #5 5) Weekly demand for a particular product averages 120 units, with a standard deviation of 6. This item

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 Interval is 5 weeks and has a certain lead time of one week. The desired service level is 98 percent. Assume it is now time to place an order, and there are 23 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 Accounting Questions!

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

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

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

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

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

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

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

The chair of the operations management department at Quality University wants to construct a control-chart for determining whether the four faculty teaching the basic OM course are in control with...

Weekly demand for a particular item averages 30 units, with a standard deviation of 4. This item is managed with a fixed-order-interval (periodic review) policy. The order interval (review period) is...

QUESTION 3 2 Weekly demand for a particular item averages 3 0 units, with a standard deviation of 4 . This item is managed with a fixed - order - interval model. The order interval is three weeks,...

Suppose A is one observation from a population with beta(0,1) pdf. (a) For testing H0: 1 versus H1: > 1, find the size and sketch the power function of the test that rejects H0 if X > 1/2 (b) Find...

Below there is sample of heights of men from certain area in cm 177, 160, 165, 182, 190, 177, 180 (a) Determine 95% confidence interval for expected value of height. (b) Determine 99% confidence...

what type of control is subsidary ledgers to the assoicated general ledger account

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Does my outline offer a complete list of references for all of the research I cite in my speech?

Effective Delivery Effective

3. When creating the outline for your speech, write each main point on a separate index card. Spread the cards out on a table, and then pick them up in the most logical order. Does this order match...