Please Show Excel Formulas for a Like $!$ Question Set $1.$ You are an inventory management consultant. You have been hired by Walmart to help optimize inventory management for their Dairy department. Your immediate task is building a Monte Carlo simulation for sales of Milk, Eggs and Cheese. The probabilities of monthly demand levels are: The unit revenues and costs are given in the table below. Each product has a separate display with an associated fixed monthly cost: $1.$ Build a table for the cumulative probability distribution for demand. It should be set up for use with the VLOOKUP function, with the cumulative probabilities on the left. $2.$Build a table for tracking sales over one year $($Jan $2021-$Dec $2021)$ with separate columns for Milk, Eggs and Cheese. This will just be the randomized demand value for each item for each month $($like in $10\mathrm{.}1\mathrm{.}2$ from the lab exercise on Monte Carlo simulations$).$ For this assignment, assume all demand is actually met $($that is$,$ sales $=$ demand $)$ and there is no other inventory loss except through sales. $3.$ Build a table for tracking total revenues, costs, and profit for the year. This table should use the information provided in your answer to $2.,$ above. Your table should calculate values for: $-$ Total Revenue $($based on the combined sales of all three products over the year$)-$ Total Cost $($also based on combined sales, and including cost of goods sold and fixed costs$)-$ Profit$/$Loss $($total revenue minus total costs$)4.$ Create a data table to generate $50$ runs of the simulation and calculate the average profit of the $50$ simulation runs. As in previous assignments, this must be an actual data table structure to earn full credit. Calculate the average profit over the $50$ simulation runs.