Discover answers to your most pressing questions at Westonci.ca, the ultimate Q&A platform that connects you with expert solutions. Our platform provides a seamless experience for finding reliable answers from a network of experienced professionals. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.
Sagot :
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
We appreciate your visit. Hopefully, the answers you found were beneficial. Don't hesitate to come back for more information. Thank you for your visit. We're committed to providing you with the best information available. Return anytime for more. Stay curious and keep coming back to Westonci.ca for answers to all your burning questions.