1. Michael Traci, the new inventory manager at Magyar Golf Supplies, is considering using theeconomic order quantity for controlling inventory. He wants you to apply the EOQ to a sampleproduct, the Super-Z Wedge. The Super-Z Wedge has an average demand of 30 units/period withan 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.

Approach to solving the question:Let's calculate the Economic Order Quantity (EOQ), the average…

Answered: 1. Michael Traci, the new inventory…

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

Q1) Cannon sells 22mm lens for digital cameras. The manager considers using a continuous review policy to manage the inventory of this product and he is planning for the reorder point and the order quantity in 2021 taking the inventory cost into account. The annual demand for 2021 is forecasted as 400+10*6 and expected to be fairly stable during the year. Other relevant data is as follows: The standard deviation of the weekly demand is 10. Targeted cycle service level is 90% (no-stock out probability) Lead time is 4 weeks Each 22mm lens costs $2000 Annual holding cost is 25% of item cost, i.e. H=$ 500. Ordering cost is $1000 per order Using your student number calculate the annual demand. (e.g., for student numberBBAW190102, the last digit is 2 and the annual demand is 400+10*6=420) Using the annual demand forecast, calculate the weekly demand forecast for 2021 (Assume 52 weeks in a year)? What is the economic order quantity, E0Q? What is the reorder point and safety stock? 5-…
a) What is the economic order quantity? b) Find the annual holding costs.c) Find the annual ordering costs.d) What is the reorder point?
Fisk Corporation is trying to improve its inventory control system and has installed an online system at its retail stores. Fisk anticipates sales of 58,800 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. In the second year, Fisk Corporation finds that it can reduce ordering costs to $1 per order, but carrying costs will stay the same at $1.50 per unit. a-1. What is the economic ordering quantity for the second year? Economic ordering quantity (EOQ) a-2. How many orders will be placed during the second year? Number of orders a-3. What will the average inventory be for the second year? Average inventory Total costs units units a-4. What is the total cost of ordering and carrying inventory for second year? LA
Economic Order QuantityA pipe manufacturer requires a chemical for making plastic at the rate of 6000gallons per year. The cost of keeping the chemical storage is $10 per gallon peryear. Ordering costs are $200 per order. The chemical is bought at $45 pergallon.What is the EOQ and the Annual Total Cost?
Use ABC analysis to determine the items deserving mostattention and tightest inventory control
Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is $30. The cost of holding one unit of inventory for one year is $15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Compute the economic order quantity. Economic order quantity = 1600 Compute the ordering, carrying, and total costs for the EOQ. How much money does using the EOQ policy save the company over the policy of purchasing 4,000 plastic housing units per order?
David's Delicatessen flies in Hebrew National salamis regularly to satisfy a growing demand for the salamis in Silicon Valley. The owner, David Gold, estimates that the demand for the salamis is pretty steady at 175 per month. The salamis cost Gold $1.85 each. The fixed cost of calling his brother in New York and having the salamis flown in is $200. It takes three weeks to receive an order. Gold's accountant, Irving Wu, recommendsan annual cost of capital of 22 percent, a cost of shelf space of 3 percent of the value of the item, and a cost of 2 percent of the value for taxes and insurance. How many salamis should Gold have on hand when he phones his brother to send another shipment?
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.
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…
Peter Sagan is in charge of maintaining hospital supplies at Champs Hospital. During the past year the mean weekly demand for a special type of tubing was 186 packages of this tubing with a standard deviation of 13 packages of tubing. The lead time for receiving this tubing from the supplier is 1.5 weeks. Peter would like to maintain a 95% service level and places an order for 750 packages every time an order is placed. d) If the weekly demand is 186 and there is a 1.5 week lead time - what is the reorder point (99% service level)? e) If the carrying cost per year is $0.50/unit/year - what is the additional cost associate with the 99% service level compared to 95% service level (i.e. cost of safety stock at 99% level - cost of safety stock at 95% service level)?
Manipulation Manufacturing Company uses 1,000 units of Chip annually in its production. Order costs consist of P10 for placing a long-distance call to make the order and P40 for delivering the order by truck to the company warehouse. Each Chip costs P100 and the carrying costs are estimated at 15.625% of the inventory cost. If the EOQ for Chip is 80 and the total ordering cost is P625. Compute for the Total Carrying Costs.
A company has been approached by their supplier who would be willing to offer a discount of 5% on orders over 500 units. Information regarding current inventory costs is as follows: Holding cost per unit per annum 10% of purchase price Ordering costs = $2 per order Annual demand = 15,000 units Purchase price 200 units Identify which option is better for the company. $15 per unit Current EOQ quantity = = =

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