The average weekly demand of an item is 200 units, and the standard deviation ofweekly demand is 150. The inventory manager places orders of 750 units each time,and the replenishment lead time is 2 weeks. Management says it will tolerate onlyone stockout per two years. How much safety stock should be carried? Round youranswer to the nearest integer.Question 2What is the average inventory per year? Round your answer to the nearest integer.Question 3What is the order point? Round your answer to the nearest integer. Suppose now inventory is reviewed every week, safety stock is 300, and at time ofreview the inventory level is 400. What should the order quantity be?

Answered: The average weekly demand of an item is…

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 regional supermarket is open 360 days a year. Daily use of cash register tapes is 15 rolls. The purchase price of the tape is $ 2 and inventory carrying cost is 60 cents per roll a year. Ordering cost is $ 20 per order. The order replenishment lead time is 7 days. What is the Order Point (re-order point) assuming demand is known and constant?
52 Demand for an item is 3,800 units per year. Each order placed costs $15; the annual cost to carry items in inventory is $10 each. In what quantities should the item be ordered? Note: Round your answer to the nearest whole number.
EOQ, reorder point, and safety stock Alexis Company uses 937units of a product per year on a continuous basis. The product has a fixed cost of $44 per order, and its carrying cost is $4 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note: Use a 365-day year to calculate daily usage.) c. Determine the reorder point. d. Indicate which of the following variables change if the firm does not hold the safety stock: (1) order cost, (2) carrying cost, (3) total inventory cost, (4) reorder point, (5) economic order quantity.
11.7 For an SKU, the standard deviation of demand during the lead time is 150 units, the annual demand is 10,000 units, and the order quantity is 750 units. Management says it will tolerate only one stockout per year. What safety stock should be carried? What is the average inventory? If the lead time is 2 weeks, what is the order point?
1. Michael Traci, the new inventory manager at Magyar Golf Supplies, is considering using the economic order quantity for controlling inventory. He wants you to apply the EOQ to a sample product, the Super-Z Wedge. The Super-Z Wedge has an average demand of 30 units/period with an ordering cost of $30/order. The cost of carrying a Super-Z Wedge in inventory is $2.00/unit/ period. No safety stock is carried for this item. a. Calculate the economic order quantity. b. Calculate the average cycle stock for this item using the order quantity in question a. c. Assuming there are 12 periods per year, calculate total cost per year.
The electrolyte drink for our beloved NMSU soccer team average normally distributed demand of 5 units and a standard deviation of 1 unit. Lead time for replenishment is fixed at four days. (a) What is the reorder point if there is no safety stock? (b) What is the reorder point if the service level is 80 percent? (c) How much more safety stock is required if the service level is raised from 80 percent to 90 percent?
A microbrewery purchases malt for production. The supplier charges $35 for delivery (no matter how much is delivered) and $1.20 per gallon. Annual holding cost is 35% of the price per gallon. Usage is 250 gallons/week. d) If order quantity is 2500 gallons, what is the sum of the ordering and holding costs PER GALLON? e) If orders are for EOQ amount, what is the annual cost of the inventory system as a percentage of the annual purchase cost?
A manufacturer buys cardboard boxes from a supplier. The annual demand is 40,000 boxes and is uniformly distributed. The boxes cost $5 each. The estimated order cost is $10, and the carrying cost rate is 20% per year. What is the EOQ and what is the annual order and carrying cost? How many times a year are orders placed, and what is the average time, in weeks, between orders? Using the answer from (b), if you round the average time between orders to the nearest week, what should the order quantity be? Would you recommend using this order quantity and time interval? Suppose that the actual demand turns out to be 80,000 boxes instead of 40,000 boxes.If you had used the EOQ from the (a), what would be the annual order and carrying cost be?
K William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics: Demand D 19,400 units/year Ordering cost S $27/order Holding cost H $5/unit/year a) The EOQ for the workbooks is 458 (round your response to the nearest whole number) b) What are the annual holding costs for the workbooks? $ (round your response to the nearest whole number).
explain the characteristics of inventory situations: 1. lead time 2. sources and level of risk 3. Static versus dynamic problems
XYZ Pharmaceuticals sells COVID testing kits. Calculate the Economic Order Quantity, or EOQ, if annual demand is 20,000 testing kits, inventory storage costs average 20 percent, the unit price per kit is $50, and ordering costs are $25.
Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. Thomas’s fastest-moving inventory item has a demand of 6,000 units a year. The purchasing cost of each unit is $16 (additional 5% discount applies if at lease 150 units ordered a time), and the inventory carrying cost is $3 per unit per year. The average ordering cost is $10 per order. It takes about 3 working days for an order to arrive. (This is a corporate operation, and there are 300 working days per year.) Answer the following questions, Q1~Q5. Note that you must include Excel formulas/calculations showing how you arrive at the answer. Q1: Assume that the demand is consistent throughout the year. What is the ROP? Note that stockouts and unnecessary inventory holding should be avoided at any times. Q2: Assume that the demand is consistent throughout the year. Based on the EOQ model, to minimize the costs of purchasing, ordering and inventory holding…

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