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

Your company has the following items in inventory: Unit Cost $9 $90 $6 Item A B с D E F G H Annual Demand 1200 100 4500 400 35 250 1000 100 $150 $2000 $120 $90 $75 a) What is the annual dollar volume for all items b) Perform an ABC analysis on the data. Which are the A items, the B items and the C item: c) Why is it desirable to classify items into groups, as the ABC classification scheme does? d) Define and discuss the term "productivity" with help of productivity equation.
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?
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
Please do not give solution in image formate thanku. Race One Motors is an Indonesian car manufacturer. At its largest manufacturing facility, in Jakarta, the company produces subcomponents at a rate of 300 per day, and it uses these subcomponents at a rate of 12,500 per year (of 250 working days). Holding costs are $22 per item per year, and ordering costs are $32 per order. a) What is the economic production quantity b) how many production runs will be made each year c) what is the max inventory level d) what percentage of time will the facility be producing components e) what is the annual cost of ordering and holding inventory
Your objective is to help company by determining EOQ* (Economic Order Quantity) that minimizes the totalinventory cost for a company that sells ceiling fans. Your worksheet provides information about the currentorder quantity, demand quantity and other costs.Questions: Answer A and Ba. With the current order quantity, what is the total cost of inventory?b. Implement the problem in Excel and find the order quantity (EOQ) (round to nearest integer) that givesminimum inventory cost. Note: this is a Non-linear programming, hence select “GRG Nonlinear” method inSolver- How much money would company save by switching to optimum quantity from current orderquantity?
Suppose that we would like to determine Reorder Point for the product. From the historical data the manager determined demand during lead-time for that product fits Normal distribution with a mean of 200 and standard deviation of 10 products. The maximum stock out risk is 10%. Answer the following questions according to the (Q, R) system. a) Find the safety stock if the lead time is 2 weeks. b) Find the reorder point. c) Find the reorder point if the stock out risk decreases to 1%. Comment on the result.

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