Build a spreadsheet simulation model for the two$$retailer transshipment problem from Section $7\mathrm{.}4.$ Your spreadsheet should include columns for the demand at each location; the inventory at each location at the start of the period, before transshipments, and after transshipments; the amount transshipped; and the costs for the period. Assume that demands are Poisson with mean images per period and that

equation

Use images and images as the base$$stock levels, and assume that both retailers begin the simulation with images units on$$hand $($that is$,$ at the start of period $1,$ retailer i needs to order images units to bring its inventory position to images $).$

Simulate the system for $500$ periods and include the first $10$ rows of your spreadsheet in your report.