Please do not give solution in image format thanku To simulate inventory management for a particularproduct, assume that the per period demand is aninteger value quantity which follows the normaldistribution with mean and standard deviation 50and 15, respectively.If the demand exceeds the starting inventory, thenthe ending inventory would be zero, that is, the"extra" demand is lost. Therefore, the endinginventory level is never negative.Ordering will take place at the end of the period,based on the ending inventory, and the order arrivesat the beginning of the next period.23456789101112131415161718Inventory ProblemMean DemandDemand Std DevOrder QuantityReorder PointPeriod1234567B50158030unitsunitsunitsunitsStarting Inv Demand60DEnding InvEOrder CostHolding Cost=round(norm.inv(rand(),$B$7,$B$8),0)=binom.inv($B$3,$B$4,rand())Order Qty Order + Inv Cost=norm.inv(rand(),$B$3,$B$4)=round(norm.inv(rand(),$B$3,$B$4),1)FTo simulate random demand for this problem in cellC12, a command that would work is:None of the answers are correct.$250$5Gper orderper unit-periodH

We need to Generate a random number between 0,1 to show the probability of area under the normal…

Answered: To simulate inventory management for a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Co probability distribution with μ = 25 and σ = 5. (a) What is the recommended order quantity? (Round your answer to the nearest integer.) = $23.50 and C = $9. The demand exhibits some variability such that the lead-time demand follows a normal (b) What are the reorder point and safety stock if the store desires at most a 4% probability of stock-out on any given order cycle? (Round your answers to the nearest integer.) reorder point safety stock (c) If a manager sets the reorder point at 30, what is the probability of a stock-out on any given order cycle? (Round your answer to four decimal places.) How many times would you expect a stock-out during the year if this reorder point were used? (Round your answer to the nearest integer.)
The Fast Service Food Mart stocks frozen pizzas in a refrigerated display case. The average daily demand for the pizzas is normally distributed, with a mean of 8 pizzas and a standard deviation of 2.5 pizzas. A vendor for a packaged food distributor checks the market’s inventory of frozen foods every 10 days, and during a particular visit, there were no pizzas in stock. The lead time to receive an order is 3 days. Determine the order size for this order period that will result in a 99% service level. During the vendor’s following visit, there were 5 frozen pizzas in stock. What is the order size for the next order period?
Suppose that the owner of the campus bar, Nick’s, has determined that demand for beer during leadtime averages 5000 bottles. Nick, the owner, believes the demand during lead time can be describedby a normal distribution with a mean of 5000 bottles and a standard deviation of 300 bottles. Nick iswilling to accept a stockout risk of approximately 4 percent. Determine the appropriate z value to use.Calculate how much safety stock Nick should hold. Also determine the reorder point.
XYZ Company must order tires from its warehouse. It costs $10550 to place an order and to review the inventory level. Annual tire sales are normally distributed with mean 20000 and variance 4,000,000. It costs $10 per year to hold a tire in inventory, and each order arrives two weeks after being placed. The Company uses periodic review (R, S) policy. What is the review interval R (in years), estimated using EOQ.? Select one: a. 1.027 O b.0.1083 c. 0.2297 d. 0.1624 e. 0.3248
A health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Co = $24.50 and Ch = $7.The demand exhibits some variability such that the lead-time demand follows a normal probability distribution with ? = 25 and ? = 5. (a)What is the recommended order quantity? (Round your answer to the nearest integer.) (b)What are the reorder point and safety stock if the store desires at most a 4% probability of stock-out on any given order cycle? (Round your answers to the nearest integer.) reorder pointsafety stock (c)If a manager sets the reorder point at 30, what is the probability of a stock-out on any given order cycle? (Round your answer to four decimal places.) How many times would you expect a stock-out during the year if this reorder point were used? (Round your answer to the nearest integer.)
A lawn and garden shop that is open for business seven days a week orders bags of grass seed every OTHER Monday. Lead time for seed orders is 5 days. On Monday, at ordering time, a clerk found 112 bags of seed in stock, and so he ordered 198 bags. Daily demand for grass seed is normally distributed with a mean of 15 bags and a standard deviation of four bags.The manager would like to know what the probability is that a grass seed stockout will occur before the next order arrives. Please show a correct solution and answer. Thank you.
One item a computer store sells is supplied by a vendor who handles only that item. Demand forthat item recently changed, and the store manager must determine when to replenish it. The managerwants a probability of at least 96 percent of not having a stockout during lead time. The managerexpects demand to average a dozen units a day and have a standard deviation of two units a day.Lead time is variable, averaging four days with a standard deviation of one day. Assume normalityand that seasonality is not a factor.a. When should the manager reorder to achieve the desired probability?b. Why might the model not be appropriate if seasonality were present?
The amount of denim used daily by the Southwest ApparelCompany in its manufacturing process to make jeans isnormally distributed with an average of 4000 yards ofdenim and a standard deviation of 600 yards. The lead timerequired to receive an order of denim from the textile mill is a constant 7 days. Determine the safety stock and re-order point if the company wants to limit the probability of a stockout and work stoppage to 5%.
Please answer questions 9 and 10 based on this data. Daily demand for packages of five videotapes at a warehouse store is found to be normally distributed with a mean of 50 and a standard deviation of 5. When the store orders more tapes, the orders take four days to arrive. Assume the store is open 360 days a year. If the store wants the probability of stocking out to be no more than 5%, and demand each day is independent of the day before, what should be the safety stock? Please round your answer to two decimals. Safety stock= 17 Question 10 4 pts If the store wants the probability of stocking out to be no more than 5%, and demand each day is independent of the day before, what reorder point should be set? Please round your answer to two decimals. Reorder point=
Daily demand for a product is 10 units. The standard deviation of demand during the review and lead time is 20 units. The review period is 30 days and the lead time is 14 days. At the time of review there are 150 units in stock. If the probability of stockout should not exceed 2%, how many units should be ordered?
The Mediterranean Restaurant stocks a red Chilean tablewine it purchases from a wine merchant in a nearby city.The daily demand for the wine at the restaurant is normally distributed, with a mean of 18 bottles and a standard deviation of 4 bottles. The wine merchant sends arepresentative to check the restaurant’s wine cellar every30 days, and during a recent visit there were 25 bottles instock. The lead time to receive an order is two days. Therestaurant manager has requested an order size that willenable him to limit the probability of a stockout to 5%.
A newsvendor orders 8000 units. Demand is normally distributed with a mean of9000 and a standard deviation of 2000. What is the stockout probability?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS