Question

In: Operations Management

Set up the Economic Order Quantity model given the information below. Annual Demand 50,000 units Order...

Set up the Economic Order Quantity model given the information below.


Annual Demand	50,000 units
Order Cost	$150 per order
Unit Cost	$100 per unit
Inventory Holding	15% of unit cost

What is the Economic Order Quantity of the product?

What is the total annual cost when EOQ is ordered each time?

Solutions

Expert Solution

Given are following details :

Annual demand of bath towels = D = 175 /month x 12 months =2100

Order placement cost = Co =$12

Annual unit inventory carrying cost = Ch = 27% of $2.50 = $0.675

Optimal order quantity

= Square root ( 2 x Co x D/ Ch )

= Square root ( 2 x 12 x 2100 / 0.675 )

= 273.25 ( 273 rounded to nearest whole number )

Order frequency = Optimal order quantity / Annual demand x 365 = 274/2100 x 365 = 47.62 days

Annual set up ( order placement) cost

= Ordering cost x Number of orders

= Co x annual demand / Optimal order quantity

= $12 x 2100 / 273

= $92.30

Annual inventory carrying cost

= annual unit inventory carrying cost x Average inventory

= Ch x Optimal order quantity / 2

= $0.675 x 273/2

= $92.13

Annual holding and set up cost = $92.30 + $92.13 = $184.43

Given are following data :

Annual demand = D = 50,000 units

Order cost = Co = $150

Annual unit inventory holding cost = Ch = 15% of $100 per unit =$15

Economic order quantity = Square root ( 2 x Co x D / Ch ) = Square root ( 2 x 150 x 50000/15) =1000

Annual Ordering cost

= Ordering cost x Number of orders

= Ordering cost x annual demand / EOQ

= Co x D/EOQ

= $ 150x 50,000/1000

= $7500

Annual inventory holding cost

= Annual unit inventory holding cost x Average inventory

= Ch x EOQ/2

= $15 x 1000/2

= $7500

Annual procurement cost = $100/ unit x 50,000 units = $5,000000

Total annual cost when EOQ is ordered

= Annual ordering cost + annual inventory holding cost + annual procurement cost

= $7500 + $7500 + $5000000

= $5015000

keosha answered 8 months ago

Next > < Previous

Related Solutions

The assumptions of the production order quantity model are met in a situation where annual demand is 3650 units

The assumptions of the production order quantity model are met in a situation where annual demand is 3650 units, the setup cost is $50, holding cost is $12 per unit per year, the daily demand rate is 10 and the daily production rate is 100. The production order quantity for this problem is approximate.

One company operates 300 days per year. The economic order quantity (EOQ) is 250 units. Annual demand is 5000 units.

One company operates 300 days per year. The economic order quantity (EOQ) is 250 units. Annual demand is 5000 units. The expected time between orders will be: 15 days20 days1.2 days16.6 daysNone of the above

Using the EOQ model, if a firm's order quantity is 500 units and its annual holding...

Using the EOQ model, if a firm's order quantity is 500 units and its annual holding cost is greater than its annual setup cost, then what can we say about the optimal order quantity? A. Optimal order quantity = 500 units B. Optimal order quantity < 500 units C. Optimal order quantity > 500 units D. Not enough information is given to answer the question

PoMA Ltd uses the Economic Order Quantity Model to determine order quantities. The following information is...

PoMA Ltd uses the Economic Order Quantity Model to determine order quantities. The following information is given for the next year: Order costs 20 per order Delivery costs 5 per order Holding costs 10% of purchase price per annum Annual demand 19,000 units Purchase price 40 per unit No safety stocks are held. a. What is the EOQ? b. What are the total annual costs of stock if the company uses EOQ to determine quantity ordered every time (i.e. the...

1. Create a new Problem 1 worksheet and build up the Economic Order Quantity (EOQ) model...

1. Create a new Problem 1 worksheet and build up the Economic Order Quantity (EOQ) model as discussed in the slides. Use the following values for the model variables: Annual Demand: 105,000 Cost Per Unit: $27.38 Holding Costs: 7.5% Ordering Costs: $273.00 Make sure that your model calculates the Unit Holding Costs, EOQ and Orders to Place per Year. 2. Create a new Problem 2 worksheet and build up the Earned Value Management (EVM) model as discussed in the slides....

Suppose we have an Economic Order Quantity (EOQ) problem with discounts. A (annual demand)= 10000, k...

Suppose we have an Economic Order Quantity (EOQ) problem with discounts. A (annual demand)= 10000, k (order cost)= 10, c1 (item cost)= 8, h (holding cost)= 0.1 For orders of 2000 or more, the cost is discounted from 8 to 7.3728. What is the optimal TAC (total annual cost, including order and holding, and also including the purchase costs)?

The information given in the below table pertains to Brigham Company for last month. 50,000 units...

The information given in the below table pertains to Brigham Company for last month. 50,000 units are sold for $220 per unit. The fixed expenses are $3,000,000 per month, and the variable expenses per unit include the items given in the below table. Item: Amount Direct Materials $60 per unit Direct Labor $35 per unit Variable Manufacturing Overhead $25 per unit Variable Selling and Administrative Expenses $20 per unit 16. What is the unit contribution margin? $80 per unit $125...

The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying...

The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages are allowed. Suppose we relax the first assumption and...

Which of the following is NOT an assumption of the traditional economic order quantity (EOQ) model?...

Which of the following is NOT an assumption of the traditional economic order quantity (EOQ) model? a. Holding and ordering costs are stable and known. b. Demand is constant and known. c. Supply lead time is constant and known. d. Quantity discounts are possible. Kim’s Nail Salon uses a weighted moving average method to forecast demand. She assigns a weight of 5 to the previous month’s demand, 3 to demand two months ago, and 2 to demand three months ago....

the primary purpose of the Economic Order Quantity (EOQ) model is to: A. Maximize the customer...

the primary purpose of the Economic Order Quantity (EOQ) model is to: A. Maximize the customer service level B. Calculate the reorder point, so that replenishment take place at the proper time C. Calculate the optimum safety stock level D. None of these answers

Subjects