In: Statistics and Probability
Apply the EOQ model to the following quantity discount situation in which D = 400 units per year, Co = $36, and the annual holding cost rate is 25%.
Discount Category |
Order Size |
Discount (%) |
Unit Cost |
1 | 0 to 99 | 0 | $10.00 |
2 | 100 or more | 4 | $9.60 |
What order quantity do you recommend? If required, round your answer to the nearest whole number.
***answer is not 4
SOLUTION:
From given data,
Apply the EOQ model to the following quantity discount situation in which D = 400 units per year, Co = $36, and the annual holding cost rate is 25%.
D = 400 units per year
Co = $36
holding cost rate = 25% = 25/100 = 0.25
Discount Category | Order Size | Discount(%) | Unit Cost |
1 | 0 to 99 | 0 | $ 10.00 |
2 | 100 or more | 4 | $ 9.60 |
We have to find order quantity.
Economic order quantity (Qodt) = sqrt (20 * k / h)
Annual carrying cost per unit (h) = P * (h/p)
= $10 * 0.25
= $ 2.5
(Qodt) = sqrt (20 *400*36 / 2.5)
(Qodt) = sqrt (288000 / 2.5)
(Qodt) = sqrt (115200)
(Qodt) = 339.41
The number of order per year is = D / Qodt
= 400 / 339.41
= 1.17
2
That is 2 orders.
The order of quantity for first one is 2 orders.
Economic order quantity (Qopt) = sqrt (20 * k / h)
D = 400 units per year
Co = $36
p = $ 9.60
holding cost rate = 25% = 25/100 = 0.25
Annual carrying cost per unit (h) = P * (h/p)
= $ 9.60* 0.25
= $ 2.4
(Qopt) = sqrt (20 *400*36 / 2.4)
(Qopt) = sqrt (288000 / 2.4)
(Qopt) = sqrt (120000)
(Qopt) = 346.41
The number of order per year is = D / Qopt
= 400 / 339.41
= 1.154
2
That is 2 orders.
The order of quantity for second one is 2 orders.
Therefore economic order quantity is recommend .