11.7 For an SKU, the standard deviation of demand during the lead time is 150 units, theannual demand is 10,000 units, and the order quantity is 750 units. Management says itwill tolerate only one stockout per year. What safety stock should be carried? What is theaverage inventory? If the lead time is 2 weeks, what is the order point?

To calculate the safety stock and average inventory, we'll use the following formulas: Safety Stock…

Answered: 11.7 For an SKU, the standard deviation…

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 museum of natural history is having problems managing their inventories. Low inventory turnover is squeezing profit margins and causing cash-flow problems. A Class A item, a birdfeeder is also a top-selling item. See information for this item in the table below. Management has been ordering in lots of 390 units. 1) What is the annual cost of the current policy (hint: find the current total cost with the current order size, Q)? 2) What is the Economic Order Quantity or the optimum order quantity (EOQ) for the birdfeeders? 3) What is the total annual cost of ordering at the EOQ? How much could be saved if the museum ordered at the EOQ opposed to their current order size of 390 units? 4) When should the museum place an order, at how many units (i.e.: what is their reorder point or lead time demand)? Sales per week (demand) Purchase cost Order cost Annual holding cost Birdfeeder: Operating weeks per year Lead time for orders (weeks) Order size EOQ (calculated) 18 $ $ 60.00 45.00 25% of…
Can someone please help me with the folowing problems on excel with the formulas. Thank you
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.
Joe Henry's machine shop uses 2,500 brackets during the course of a year. These brackets are purchased from a supplier 90 miles away. The fo llowing information is known about the brackets: a) Given the information, what would be the economic order quantity (EOQ)?b) Given the EOQ, what would be the average inventory? What would be the annual inventory holding cost?c) Given the EOQ, how many orders would be made each year? What would be the annual order cost?d) Given the EOQ, what is the total annual cost of managing the inventory?e) What is the time between orders?f) What is the reorder point (ROP)?
2. Find out the EOQ, Annual ordering cost and annual holding cost from the following information. The demand is 19500 units per year, holding cost is RO 4 per unit for a year and ordering cost is RO 25 order.
Question 1 For supply item ABC, Andrews Company has been ordering 400 units per week. A new purchasing agent has been hired by the company who wants to start using the economic-order- quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units Lead time, in days Ordering costs Insurance and handling costs Purchase price per unit Return on cash investment 20,800 5 $22 $7 $15 15% Required
snip
The Allianz Company produces a specialty wood furniture product, and has the following information available concerning its inventory items: Relevant ordering costs per purchase $550 order Relevant carrying costs per year for each package: Required annual return on investment Required other costs per year 17% $7 Annual demand is 30,000 packages per year. The purchase price per package is $53. Which of the following statements is true of Allianz's EOQ system costs? O At EOQ, the annual relevant ordering costs is exactly the half of annual relevant carrying costs. O At EOQ, the annual relevant carrying costs is exactly the half of the annual relevant total costs. O At EOQ, the annual relevant carrying costs is higher than the annual relevant ordering costs. O At EOQ, the annual relevant carrying costs is equal to the annual relevant total costs.
Given: Demand is 1984 items per month. The order frequency is 8 per quarter. The reorder point is 0. What is the lot size (Q)?

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