$10-28$ Consider the Music Mania problem described in Problem $10-27\{\{\{$Music Mania sells MP$3$ players to its customers. Music Mania orders $300$ MP$3$ players from its sup$-$ plier when its inventory reaches $80$ units. Daily demand for MP$3$ players is discrete, uniformly dis$-$ tributed between $30$ and $60($both inclusive$).$ The lead time from the supplier also varies for each or$-$ der and is discrete, uniformly distributed between $1$ and $3$ days $($both inclusive$).$ The cost to hold $1$ unit in inventory for one day is $$0\mathrm{.}50.$ The cost to place an order is $$100.$ Stockout cost per unit is estimated at $$20.$ Initial inventory is $300$ units.

Simulate this inventory policy for a quarter $(90$ days$)$ and calculate the total quarterly cost. Also calculate the percentage of stockouts for the quar$-$ ter. Replicate these calculations N times each to calculate the average values for these measures.$\}\}\}$

$($a$)$ Music Mania would like to evaluate ordering $250,300,350,$ and $400$ MP$3$ players when the reorder point of $80$ is reached. Based on the av$-$ erage total quarterly cost, which order quantity would you recommend?

$($b$)$ Music Mania would like to evaluate reorder points of $60,80,$ and $100$ MP$3$ players, with an order quantity of $300$ players. Based on the av$-$ erage total cost for the quarter, which reorder point would you recommend? EXCEL FORMAT $($see template$)$ Mention all formulas used in the yellow, green and blue fields of the excel template