Answer:
1,304 copies
Explanation:
Overage cost (Co) means like cost of over ordering
Co = Cost price - Salvage value
Co = $1.50 - $0 (No salvage value)
Co = $1.50
Underage cost (Cu) means like cost of under ordering
Cu = Selling price - Cost price
Cu = $5.00 - $1.50
Cu = $3.50
Service level = Cu / (Cu + Co)
Service level = $3.50 / ($3.50 + $1.50)
Service level = $3.50 / $5.00
Service level = 0.7
Z-value = NORMSINV (Service level), Using Ms Excel
Z-value = NORMSINV (0.7)
Z-value = 0.52
Optimal Order Quantity (Q) = Mean Demand + (Z-value*Standard deviation)
Optimal Order Quantity Q = 1,200 + (0.52*200)
Optimal Order Quantity Q = 1,200 + 104
Optimal Order Quantity Q = 1,304 copies
