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)?

Solutions

Expert Solution

In this situation we know that EOQ is provided using the formula

EOQ = sqrt ( 2*Annual demand*Order cost / Holding cost)

Thus with the original given information, the EOQ is

EOQ = sqrt (2*10000*10/0.1) = 1414.214

Let’s keep the number in fraction for the intermediate calculation. In ideal situations this should be rounded to nearest whole number.

Now we know that for orders more than 2000 units, the price of the product drops to 7.3728 from 8. This means at the EOQ, the total annual cost is the sum of product cost, ordering cost and holding cost. These are given by

Annual product cost = 10000*8 = 80000

Annual ordering cost = Annual demand*Order cost/Quantity = 10000*10/1414.214 = 70.71

Annual holding cost = Holding cost*Quantity/2 = 0.1*1414.214/2 = 70.71

The total annual cost will be 80000 + 70.71 +70.71 = 80141.42

Now there is a discount if we order more than 2000 units. However since our EOQ is lesser than 2000, the best price we shall get is when the quantity is at the edge that is nearest to the EOQ. This means even though 2000 or more units will give us a discount, the best annual cost will be incurred at 2000 units. Thus let’s change the above calculation with Quantity = 2000 and check the total annual cost. We have

Total annual cost = 10000*7.3728 + 10000*10/2000 + 0.1*2000/2 = 73878

This cost is lower than the cost incurred at EOQ. This means the optimal quantity to order is 2000 units.

keosha answered 4 months ago

Next > < Previous

Related Solutions

Find the EOQ, the total annual cost associated with the economic order quantity, the reorder point,...

Find the EOQ, the total annual cost associated with the economic order quantity, the reorder point, number of orders per year and the time between orders. Annual Demand 15,600 units Weeks Operating 52 weeks/year Set up Cost $60/order Holding rate 20% Unit cost $80 /unit Lead-Time 5 weeks

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

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....

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

For this item, you are asked to calculate the EOQ – Economic Order Quantity. A good...

For this item, you are asked to calculate the EOQ – Economic Order Quantity. A good place to start is by watching this week’s video. When determining the numbers for the variables needed to perform the calculation, be realistic. Research what the actual numbers could be and provide an explanation/rationale for choosing the numbers. Perform the calculation and explain what the result means to your business.

The simple economic order quantity (EOQ) model shows how much to order (i.e., lot size) in...

The simple economic order quantity (EOQ) model shows how much to order (i.e., lot size) in terms of holding costs, setup (ordering) costs, and total inventory cost. In terms of this model, why is it necessary to reduce setup cost if we desire smaller lot sizes? Draw the inventory cost curves diagram and fully explain.

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...

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

Distinguish between basic Economic Order Quantity (EOQ) and Quantity Discount Models. Your answer should be supported...

Distinguish between basic Economic Order Quantity (EOQ) and Quantity Discount Models. Your answer should be supported with relevant examples and calculations

Subjects