Assignment $5$: Using Simulations for Inventory ManagementImagine you are the manager of a small supermarket, and you need to determine how much of a popular brand of breakfast cereal to stock on your shelves each week to maximize profit while minimizing waste. The cereal has a shelf life of only ten days. Therefore, you plan on holding theinventory only for a maximum of a week.The weekly demand for this cereal follows the probability distribution below:Demand $($Boxes$)$ Probability$100\mathrm{.}10200\mathrm{.}20300\mathrm{.}25400\mathrm{.}20500\mathrm{.}15600\mathrm{.}10$Each cereal box costs $$2\mathrm{.}00,$ and you sell it for $$4\mathrm{.}00.$ Any unsold cereal boxes at the end of the week are sold for $$0\mathrm{.}50$ per box.Your task is determining the optimal number of cereal boxes to stock on your shelves at the beginning of each week to maximize your profit over a $50-$week simulation period. Consider the costs, demand probabilities, and selling prices when making your decision.Please conduct the simulation for $50$ weeks and present your findings in an MS Excel file. Include relevant calculations and explanations to support your recommendation for the optimal stocking quantity. $($NOTE$)$ solve this In execl and upload snapshot.