A health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Coprobability 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 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.)

Co: Cost per orderCh: Holding cost per unit per yearμ: Average lead-time demandσ: Standard deviation…

Answered: A health and nutrition store stocks 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 = $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 health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Co = $26.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 6% 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.):________
A warehouse checks inventory and places an order from a supplier for a particular product once a month. The monthly demand for the product is independent and normally distributed with a mean of 500 and a standard deviation of 100. If the warehouse targets a 90% service level for this product, and the supplier’s lead time is one month, how much safety stock should be held? PLEASE SHOW CALCULATIONS/EXCEL WITH FORMULAS
Demand during lead time for one brand of TV is normally distributed with a mean of 36 TVs and a standard deviation of 15 TVs. What safety stock should be carried for Dennis Yu's Appliance Outlet to provide a 90% service level? What is the appropriate reorder point? Use a Z standard deviation table as well What safety stock should be carried for a 90% service level? Safety stock =units (round your response to the nearest whole number). What is the appropriate reorder point? Reorder Point = units
Hayes Electronics assumed with certainty that the ordering cost is $450 per order and the inventory carrying cost is $170 per unit per year. However, the inventory model parameters are frequently only estimates that are subject to some degree of uncertainty. Consider four cases of variation in the model parameters: (a) Both ordering cost and carrying cost are 10% less than originally estimated, (b) both ordering cost and carrying cost are 10% higher than originally estimated, (c) ordering cost is 10% higher and carrying cost is 10% lower than originally estimated, and (d) ordering cost is 10% lower and carrying cost is 10% higher than originally estimated. Determine the optimal order quantity and total inventory cost for each of the four cases. Prepare a table with values from all four cases and compare the sensitivity of the model solution to changes in parameter values.
Annual demand is 16000 units, cost per order is $75 and carrying cost per unit as a percentage is 10%. The company works 250 weeks a year; the lead-time on all orders placed is 6 working days. Assuming constant lead-time demand, and a unit cost of $45 what is the economic order quantity? What is the reorder point. If lead-time demand shows variability that follows a normal distribution with a mean μ =420 and a standard deviation σ =20, what will the revised reorder point if two stock-outs (shortages) are allowed? What is the company’s reorder point if the probability of a stock-out on any cycle is restricted to 0.05?
Custom Computers, Inc. assembles custom home computer systems. The heat sinks needed are bought for $12 each and are ordered in quantities of 1300 units. Annual demand is 5200 heat sinks, the annual inventory holding cost rate is $3 per unit, and the cost to place an order is estimated to be $50. Calculate the following: (a) Average inventory level (b) The number of orders placed per year (c) The total annual inventory holding cost (d) The total annual ordering cost (e) The total annual cost
Jim recently acquired a designer shoe store in downtown silver spring. The former owner always ordered 100 pairs of shoes. Jim wants to reevaluate this policy. Based on his analysis, the cost to place each order is $40 and the holding cost is $12 per shampoo bottle per year. The annual demand for this product is 2500 pairs. Should Jim change the current order policy and, if so, how much can she save? Answer in two decimal places. (Hint: Calculate annual total cost using the old and the new policy and compare)
A local service station is open 7 days per week, 365 days per year. Sales of 10W40 grade premium oil average 20 cans per day. Inventory holding costs are $0.50 per can per year. Ordering costs are $10 per order. The lead time is two weeks. Backorders are not practical— the motorist drives away.a. Based on these data, choose the appropriate inventory model and calculate the economic order quantity and reorder point. Describe in a sentence how the plan would work. Hint: Assume demand is deterministic.b. The boss is concerned about this model because the demand really varies. The standarddeviation of demand was determined from a data sample to be 6.15 cans per day. Themanager wants a 99.5 percent service probability. Determine a new inventory planbased on this information and the data in part (a). Use Qopt from part (a).
Given this information:Lead-time demand = 615 poundsStandard deviation of lead time demand = 48 pounds (Assume normality.)Acceptable stockout risk during lead time = 4 percentUse Table. a. What amount of safety stock is appropriate? (Round your answer to the nearest whole number.) Safety stock units b. How much of this item should be reordered? (Round your answer to the nearest whole number.) ROP units c. What risk of stockout would result from a decision not to have any safety stock? (Omit the "%" sign in your response.) Stockout risk %
Polymorph Promotions finds that demand for an item is Normally distributed with a mean of 2,000 units a year and a standard deviation of 400 units. Unit cost is $100, reorder cost is $200, holding cost is 20% of value a year and lead time is fixed at 3 weeks. Compute the (s,Q) ordering policy that gives a 95% service level and the annual cost of the safety stock.
Your firm uses a continuous review system and operates 52 weeks per year. One of the Stock-Keeping Units (SKUs) has the following characteristics:Demand = 20000 units/year = 385 units/weekOrdering cost = $40/orderHolding cost = $2/unit/yearService level = 95 percentz=1.65Lead time = 2 weeksDemand is normally distributed, with a standard deviation of weekly demand of 100 units. a)Calculate the item's EOQ. b)Find the safety stock and reorder point that provide a 95 percent service level. c)For these policies, what are the annual costs of (i) holding the cycle inventory and (ii) placing orders?

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