Solve the following EOQ model problems:1. EachThe cost of placing an order is P 480, and the cost to hold the item in inventory forone year is P 150.year,Y Company purchases 20,000 units of an item that costs P 640 per unit.a. Determine the EOQ.b. What is the average inventory level, assuming that the minimum inventory levelis zero?c. Determine the total annual ordering cost and the total annual holding cost forthe item if the EOQ is used.

Solution of all 3 parts is as follows

Answered: 1. Each year, Y Company purchases…

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

The annual demand for an item is 12 000 units. Ordering cost is $80 per order and carrying cost is 20% of the unit cost of $15. Calculate: The Economic order quantity Annual ordering cost Annual carrying cost Total annual cost
Mac-in-the-Box, Inc., sells computer equipment by mail andtelephone order. Mac sells 1,200 flat-bed scanners per year.Ordering cost is $300, and annual holding cost is 16 percentof the item’s price. The scanner manufacturer offers thefollowing price structure to Mac-in-the-Box: What order quantity minimizes total annual costs?
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,600 cases. A case of the soft drink costs R&B $4. Ordering costs are $22 per order and holding costs are 23% of the value of the inventory. R&B has 250 working days per year, and the lead time is 5 days. Identify the following aspects of the inventory policy: a. Economic order quantity. If required, round your answer to two decimal places.Q = b. Reorder point. If required, round your answer to the nearest whole number.r =c. Cycle time. If required, round your answer to two decimal places.T = daysd. Total annual cost. If required, round your answer to two decimal places.TC = $
3 Which of the following inventory models considers backorder costs? O a. Economic Order Quantity with Quantity Discounts O b. Basic Economic Order Quantity C. Economic Order Quantity with Planned Shortages Od. Economic Production Quantity
A company has a demand for 25,750 units annually. The holding cost is 33% of the item cost which is $10.00. The ordering or set-up cost is $250.00 per order and the lead time is 5 days. Assume that there are 350 days per year Suppose a price break of $50 per order is offered for purchase quantities of 2,000 or greater. Question: What is the reorder point for this inventory strategy? What is the inventory position immediately after an order is placed for the inventory strategy that you have selected?
Intan Store sells 240,000 cabinets per year. Based on the company's policy, a safety stock of 4 percent from yearly sales is to be maintained. The carrying cost is RM0.60 per unit annually and the ordering costs are RM150.00. The delivery time is 10 days. Order should be placed in multiple of 100 units. i. Compute the economic order quantity (assume 360 days per year). ii. Compute the total inventory cost. iii. Compute the reorder inventory level. iv. Compute the average inventory please answer complete
3. Skinner’s Fish Market buys fresh Boston bluefish daily for $4.20 per pound and sells it for $6 per pound. At the end of each business day, any remaining bluefish is sold to a producer of cat food for $3 per pound. Daily demand can be approximated by a normal distribution with a mean of 64 pounds and a standard deviation of 11 pounds. What is the optimal order quantity (stocking level)? Round your answer to 2 decimal places. Answer:_______
Salam's company expects its production of pipes will require 600,000 tons of aluminum over its planning period. Demand for pipes products is stable over time. Ordering costs amount to an average of $15.00 per order. Holding costs are estimated $1.4 per ton of aluminum. Find the following: Total cost of holding inventory at (EOQ)is Answer
AaBbCc AaBbCc AaBbCc No Spacing Normal Reuse Heading 1 Replace Files Paragraph Styles Editing Reuse Files Item SKU A3378 has a demand that is normally distributed during the lead time, with a mean of 360 units and standard deviation of 12. If Hinsdale cannot have stockouts in more than 10% of the time in any order, how much safety stock should be maintained and at what reorder point? 1. SKU F5402: daily demand is normally distributed with a mean of 16, standard deviation of 4, lead time is 4 days, and must operate at a 95% service level. 2. SKU B7319: daily demand is constant at 24 units per day, lead time is normally with a mean of 6 days and standard deviation of 2 days, and must operate at a 95% service level. 3. SKU F9004: daily demand is normally distributed with a mean of 21 units and a standard deviation of 3 days. The lead time is also normally distributed with a mean of 4 days, standard deviation of 2 days, and a service level of 90% is required. dictions: On acer %24 4. % &…

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