2. Consider a retailers inventory problem over multiple time periods. Assume the per- unit holding cost is $10 and the per-unit backlogging cost is $30. Demand in every time period is normally distributed with mean 100 and standard deviation 10. The beginning inventory of period 1 is equal to 100. Assume that at the end of every period, 10% of the leftover inventory (if any) gets expired and discarded. Assume every order placed at the end of each period will arrive at the beginning of the next period.

b) The retailer wants to quantify the average costs under the optimal policy by simulation. Set up the spreadsheet by filling in the empty cells with formulae. [10 pts] ABC

1 A B Beginning Demand Inventory D E Ending Order Total Holding and Inventory Quantity Backlogging Cost in the Period ? ? ? ? ? ? WN 2 3 100 ? ? ? 1 A B Beginning Demand Inventory D E Ending Order Total Holding and Inventory Quantity Backlogging Cost in the Period ? ? ? ? ? ? WN 2 3 100