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

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
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. a) How much safety stock should be used for a 95% service level? b) If the weekly demand is 186 and there is a 1.5 week lead time - what is the reorder point (95% service level)? c) How much safety stock should be used for a 99% service level? solve using excel
Define each of the following terms: c. Economic Ordering Quantity (EOQ); EOQ model; EOQ range
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 97,200 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. What is the economic ordering quantity? How many orders will be placed during the year? What will the average inventory be? What is the total cost of ordering and carrying inventory?
K Cesar Rego Computers, a Mississippi chain of computer hardware and software retail outlets, supplies both educational and commercial customers with memory and storage devices. It currently faces the following ordering decision relating to purchases of disks: Quantity needed to qualify for the discount = 6,000 disks. What is the EOQ? EOQ = units (round your response to the nearest whole number). D S I Purchase price Discount price 36,100 disks $28 21% $0.89 $0.84
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?
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, recommends an 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.a. How many salamis should Gold have flown in and how often should he order them?b. How many salamis should Gold have on hand when he phones his brother to send another shipment?c. Suppose that the salamis sell for $3 each. Are these salamis a profitable item for Gold? If so, what annual profit can he expect to realize from this item? (Assume that he operates the system optimally.)d. If the salamis…
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round individual dollar volumes to two decimal places. Also round percentage of dollar volume to two decimal places.) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value ($/unit) Dollar % of Dollar Volume Volume 1289 360 4.00 2347 300 4.00 1,200 36.20 2349 120 2.50 300 9.05 2363 75 1,50 2394 60 1.75 105 3.17 2395 35 2.00 6782 20 1.15 23 0.69 7844 12 2.05 24.6 0.74 8210 5 1.60 8310 7 2.00 14 0.42 9111 3.00 18 0.54 3,315.1 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item number…
Why do the basic EOQ model variations not include theprice of an item?
Maroons Medical Supplies, Inc. must order masks from its supplier in lots of 1 dozen boxes. Given the information provided below, complete the following table: Annual demand 26,000 dozen Cost per order placed P30 Carrying cost 20% Price per dozen P7.80 Order Size (Dozen) 250 500 1,000 2,000 13,000 26,000 Number of orders Average inventory Carrying cost Order cost Total cost 1. What is the EOQ? Please include/fill the table and solve for EOQ. Thank you so much!
Why do we use "Specifications or bill of material" in the dependent inventory model?
Exercise on EOQ and TAIC: Data: D = 7000 flyers, Q = 500 flyers S = $100, k = 28%, C = $2, number of days/year = 350 days Calculate the total cost and the total inventory cost to see if the company's ordering policy needs to be changed. If yes, how should it be changed? Question 2: This year's forecast for D is 8000 flyers/year. The following price list is given according to quantity: Quantity Price 599- 999 2,5$ 1000- 1999 2$ > 2000 1,5 $ How should the ordering policy be changed? (Note: questions about ordering policies like this require finding two factors: when to order and how much to order each time.)

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