QUESTION 3 Monte Carlo Simulation

Tully Tyres sells cheap imported tyres. The manager believes its profits are in decline. You have just been hired as an analyst by the manager of Tully Tyres to investigate the expected profit over the next 12 months based on current data.
•Monthly demand varies from 100 to 200 tyres – probabilities shown in the partial section of the spreadsheet below, but you have to insert formulas to ge the cumulative probability distribution which can be used in Excel with the VLOOKUP command.
•The average selling price per tyre follows a discrete uniform distribution ranging from $160 to $180 each. This means that it can take on equally likely integer values between $160 and $180 – more on this below.
•The average profit margin per tyre after covering variable costs follows a continuous uniform distribution between 20% and 30% of the selling price.
•Fixed costs per month are $2000.
(a)Using Excel set up a model to simulate the next 12 months to determine the expected average monthly profit for the year. You need to have loaded the Analysis Toolpak Add-In to your version of Excel. You must keep the data separate from the model. The model should show only formulas, no numbers whatsoever except for the month number.
You can use this partial template to guide you:

Ajax Tyres