Please provide all calculations, preferably in Excel.
1. A large toy company Müttel currently allows toy retailers to place orders with delivery in 2 weeks. The Gigantic Pocket Monster (Gipokmon) is a new toy that Müttel has introduced. Demand per week for the toy at one of their stores is estimated to be normally distributed with a mean of 25 units and standard deviation of 5 units. Assume TOYS-are-MINE uses the order-up-to model to plan orders and deliveries to this store.
a. Suppose TOYS-are-MINE uses an order-up-to level of 20. After receiving their delivery for this week, they have 2 units on-hand. Last week's order was for 5 units. How many units will they order this week?
b. Again, suppose they use an order-up-to level of 20 for this store. On average, how many units will this store have on-order?
c. Suppose an order-up-to level of 90 is established. What is the resulting instock probability?
d. Suppose an order-up-to level of 100 is established. What would be the expected end-of-period on-hand inventory of Gipokmons?