You manage the inventory of bed frames that are sold through retail stores. The
ID: 347880 • Letter: Y
Question
You manage the inventory of bed frames that are sold through retail stores. The most popular model sells at wholesale for $400 per bed frame. It costs $300 to make each unit. Historical data shows that it fits a normal distribution with an average monthly demand of 1,000 bed frames and a standard deviation of 200. Your company uses an annual interest rate of 20% to estimate inventory holding cost. 1) Suppose the backorder cost is $20 per unit. (4 points) What optimal base stock level should you use? (6 points) What base stock level should you use if you want the fill rate to be at least 90%? what is the average number of backorders, B(r)? a. b. 2) Suppose any order that cannot be fulfilled through stock is, instead, fulfilled by purchasing from a competitor at $350 per unit. (4 points) What optimal base stock level should be used? (6 points) What base stock level should be used in order for the fill rate to be at least 95%? what is the average number of backorders, B(r)? a. b. 3) (5 points) Explain the difference between the answers in part 1a and 2a.Explanation / Answer
p = 400; c=300
mean = 1000; Std dev = 200
a) critical factor = ( p - c ) / p = 0.25
Optimal base stock = mean + std Dev . Z@(0.25) = 1000 + 200 * (-0.67449) = 865.1
b) For service level of 90%
mean + Std Dev * Z@90% = 1000 + 200 * 1.28155 = 1256.1
Average number of backorders will be 10% of total orders
2)
p = 400; c=350
mean = 1000; Std dev = 200
a) critical factor = ( p - c ) / p = 0.125
Optimal base stock = mean + std Dev . Z@(0.75) = 769.93 ~ 770
b) For service level of 95%
mean + Std Dev * Z@95% = 1328.97
Average number of backorders will be 5% of total orders
3) Comparing for answer to part a) it indicates since if purchase cost is higheroptimal base stock is less to balance overage loss with underage gain
If we want to fulfill demand with high level of service then in stock quantity needs to be on higher side. This is evident from 95% to 90% service level comparison.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.