P06_35.xlsx Shoe demand distribution Demand (100s of pairs) Probability 1 0.025 2 0.050 3 0.075 4 0.100 5 0.150 6 0.200 7 0.175 8 0.100 9 0.075 10 0.050 A buyer for a large department store chain must place orders with an athletic shoe manufacturer six months prior to the time the shoes will be sold in the department stores. The buyer must decide on November 1 how many pairs of the manufacturer’s newest model of tennis shoes to order for sale during the coming summer season. Assume that each pair of this new brand of tennis shoes costs the department store chain $65 per pair. Furthermore, assume that each pair of these shoes can then be sold to the chain’s customers for $90 per pair. Any pairs of these shoes remaining unsold at the end of the summer season will be sold in a closeout sale next fall for $20 each. The probability distribution of consumer demand for these tennis shoes during the coming summer season has been assessed by market research specialists and is provided in the file P06_35.xlsx. Finally, assume that the department store chain must purchase these tennis shoes from the manufacturer in lots of 100 pairs. Identify the strategy that maximizes the department store chain’s expected profit earned by purchasing and subsequently selling pairs of the new tennis shoes. The optimal decision is to purchase _____ pairs of shoes prior to the coming summer season. By doing so, the buyer achieves an EMV of $ _____ . Perform a sensitivity analysis on the optimal decision, letting the three monetary inputs vary one at a time over reasonable ranges, and summarize your findings. Which of the inputs appears to have the largest effect on the best solution?
P06_35.xlsx
| Shoe demand distribution | |||
| Demand (100s of pairs) | Probability | ||
| 1 | 0.025 | ||
| 2 | 0.050 | ||
| 3 | 0.075 | ||
| 4 | 0.100 | ||
| 5 | 0.150 | ||
| 6 | 0.200 | ||
| 7 | 0.175 | ||
| 8 | 0.100 | ||
| 9 | 0.075 | ||
| 10 | 0.050 |
A buyer for a large department store chain must place orders with an athletic shoe manufacturer six months prior to the time the shoes will be sold in the department stores. The buyer must decide on November 1 how many pairs of the manufacturer’s newest model of tennis shoes to order for sale during the coming summer season. Assume that each pair of this new brand of tennis shoes costs the department store chain $65 per pair. Furthermore, assume that each pair of these shoes can then be sold to the chain’s customers for $90 per pair. Any pairs of these shoes remaining unsold at the end of the summer season will be sold in a closeout sale next fall for $20 each. The probability distribution of consumer demand for these tennis shoes during the coming summer season has been assessed by
-
Identify the strategy that maximizes the department store chain’s expected profit earned by purchasing and subsequently selling pairs of the new tennis shoes.
The optimal decision is to purchase _____ pairs of shoes prior to the coming summer season. By doing so, the buyer achieves an EMV of $ _____ .
Perform a sensitivity analysis on the optimal decision, letting the three monetary inputs vary one at a time over reasonable ranges, and summarize your findings. Which of the inputs appears to have the largest effect on the best solution?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
