Change the ordering simulation so that emergency orders are never made. If demand in any week is greater than supply, the excess demand is simply lost. Simulate the same (s, S) policies as in the example.

Change the ordering simulation so that emergency orders are never made. If demand in any week is greater than supply, the excess demand is simply lost. Simulate the same (s, S) policies as in the example.

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

16 Brooke Army Medical Center dispenses 390,000 bottles of brand name pharmaceutical annually. The optimal safety stock (which is on hand initially) is 1,000 bottles. Each bottle costs the center $10, inventory carrying costs are 30%, and the cost of placing an order with its supplier is $175. I What is the economic order quantity? Format is x,xxx (number only) What is the maximum inventory for this medication? Format is x,xxx How often must the center order (in days)? Format is xx days or x days How many orders of this pharmaceutical will need to be placed each year? Format is x or xx (number only)
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.)
44 Which of these statements about the production order quantity model is FALSE? Select one: a. The production order quantity model is appropriate when the assumptions of the basic EOQ model are met, except that receipt is noninstantaneous. b. Because receipt is noninstantaneous, some units are used immediately and not stored in inventory. c. All else equal, the smaller the ratio of demand rate to production rate, the larger is the production order quantity. d. Average inventory is less than one-half of the production order quantity. e. None of the above is false.
Assuming Normal Distribution, what would the optimal (s,Q) policy be for the given parameters below? Given data: Demand daily has mu = 1768, sigma = 5.37, with a unit purchased cost is $15 (annual interest rate is 20%). The order cost is $50 with a back ordering cost of $25. The order lead time is 3 days.
At Matthews Car Repair, customer demand for a certain brand of motor oil is normally distributed with a mean of 15 gallons and a standard deviation of 6 work-days. To be 95% sure that Compact Car Repair will not run out of oil, we should reorder when motor oil in stock is less than _______ gallons. a. 24.9 b. 22.6 c. 23.7 d. 20
With a normal demand and normal lead-time, increasing the order lead-time results in which of the following? Lower expected costs. Higher service levels. Higher stockout probability. All of the above.
Items purchased from a vendor cost $250 each, and the forecast for next year’s demand is 2,000 units. The optimal order size is 100. The firm operates 52 weeks next year and lead time is 3 weeks. It costs $5 every time an order is placed for more units, and the storage cost is $2 per unit per year. What is the number of orders per year? a.35 b.20 c.22 d.25 e.5