$($All answers were generated using $1,000$ trials and native Excel functionality.$)$

Galaxy Co$.$ sells virtual reality $($VR$)$ oogoles targeted to customers who like to play video games, chalaxy procures each pair of googles for Siso from its supplier and sells each pair of gopoles for $$300.$ Monthly demand for the ve gopgles is a format random variable with a mean of $160$ units and a standard deviation of $40$ units. At the beginning of each month, Galaxy onders enough gogoles from its subplier to bring the inventory level up to $140$ gopoles, If the monthly demand is less than $140,$ Galuxy pars $$20$ per pair of goggles that remains in inventory at the end of the month. If the monthly dernand exceeds $140,$ Galaxy sells only the $140$ pairs of pogot's in stock. Galaxy assigns a shortage cost of $$40$ for each upit of demund that is unsatied to reprecent a loss of goodmil among its oustomers. Management would like to use a simulation modet to analyze this situation.

The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required anal rsis to answer the questions below, Generate trials on a new workshees.