Use Excel for the simulation model:

A local Fresh Food store orders a weekly box of Mangos directly from Fiji. Demand varies each week, and historical records show the following distribution:

Number of Mango Boxes

Probability

$21$

$0\mathrm{.}2$

$22$

$0\mathrm{.}3$

$23$

$0\mathrm{.}2$

$24$

$0\mathrm{.}2$

$25$

$0\mathrm{.}1$

Each box of Mangos costs $$3\mathrm{.}50$ and sells for $$5\mathrm{.}50.$ Any Mangos remaining at the end of the week are donated to a local homeless shelter $($for free$).$ Develop a simulation model in Excel and determine the best order quantity $($number of boxes of Mangos$)$ for inventory to maximize the average profit. Also, provide average profits for each inventory level. Simulate the model for $12$ weeks using the Excel formula. Use only the random numbers provided in the attached Excel file $($do not change the data format$)$ to generate demand. Use this information and enter your answers in the corresponding questions$/$edit fields with two decimal places; there are a total of eight questions$/$edit fields.

Develop the Excel simulation model, then report the following with two decimal places for the next eight questions in the edit fields.

What is the demand for week $7?$

What is the demand for week $9?$

What is the average profit for inventory level $21$ units?

What is the average profit for inventory level $22$ units?

What is the average profit for inventory level $23$ units?

What is the average profit for inventory level $24$ units?

What is the average profit for inventory level $25$ units?

What is the optimal inventory level?