Question

Consider a university that purchases replacement chairs for its classrooms. The purchasing manager knows that the annual demand for replacement chairs is 500. The pricing schedule is as follows: Use the following Excel solution to this quantity discount problem with constant carrying cost. Carrying cost = $ 15 Ordering cost = $ 200 Annual Demand = 500
Quantity Price Q Discount Q Total Cost
100 $130 115.47 115.47 $ 66,732.05
200 $122 115.47 200.00 $ 63,000.00
500 $120 115.47 500.00 $ 63,950.00
What is the inventory ordering cost using the economic order quantity?
A. $1,000
B. $866
C. $500
D. $200

Answer 1

Answer:

b. $866

Explanation:

Annual demand from the question = D = $500

the ordering cost = S = $200

then the cost of carrying H = $15

we have to calculate the economic order quantity

= sqr(2*D*S)/H

= sqr(2 x 500 x 200)/25

= sqr(13333.3333)

this equals 115.469

which is approximately 115.5

next we have to calculate inventory ordering cost

= (D * S)/EOQ

= 200 *500/115.5

= 865.5

When approximated becomes $866