The data is D = 50,000/year, S= $500 per order, H = $0.25 per unit per year. Assume a lead time of 3 days.

Fill in the following table. Write out the formulas you are using.

Annual demand
Holding cost (units per year)
Ordering cost
Ordering quantity (EOQ)
Number of orders per year
Average inventory
Maximum inventory
Reorder level
Length of order cycle
Annual holding cost
Annual ordering cost
Annual Affected Inventory Cost

b. Suppose a mistake was made in the data and the correct data is D = 60,000 per year, S = $400 per order, H = $0.20 per unit per year. Calculate the correct EOQ and affected inventory cost.
c. Now suppose we used the incorrect EOQ (based on the first set of data) instead of the correct EOQ. Calculate the affected inventory cost.
d. Compute the percentage error in the EOQ and in the inventory cost.
e. Moral of the story is that incorrect estimation of costs or demand (does or does not) result in substantial deviation from the optimal cost (circle the right answer).

Respuesta :

Answer:

Annual demand 50,000 units

Holding cost $0.25 per year

Ordering Cost $500 per order

EOQ : 14,142

Number of orders per year 4

Average inventory 14,142 units

Maximum inventory 14,500 units

Reorder level 410 units

Length of order cycle 3 days

Annual Holding cost $12,500

Annual ordering cost $2000

Annual affected inventory cost $14,500

Explanation:

EOQ = [tex]\sqrt{\frac{2 * D * S}{H} }[/tex]

EOQ = [tex]\sqrt{\frac{2 * 50000 * 500}{0.25} }[/tex]

EOQ = 14,142 units

Number of Order : Annual demand / EOQ

Number of order : 50,000 / 14,142 = 3.53 or approximately 4

Annual Ordering cost : No. of order * cost per order

Annual ordering cost : 4 * $500 = $2,000

Annual Holding Cost : Demand * Holding cost per unit

Annual holding cost = 50,000 * $0.25 per unit = $12,500

Reorder level : Daily demand * lead time

Reorder level : [ 50000 / 365 ] * 3 = 410 units