$1.$ Using the financial model example like the one done in the videos. Implement a financial model for a new product proposal and determine a distribution of profits using the discrete distributions below for the unit cost, demand fixed costs. Price is fixed at $$1,000.$ Unit costs are unknown and follow the distribution:

Unit Cost Probability

$$4000\mathrm{.}2$

$$6000\mathrm{.}4$

$$7000\mathrm{.}25$

$$8000\mathrm{.}15$

Demand is also variable and has the following distribution:

Demand Probability

$1200\mathrm{.}25$

$1400\mathrm{.}5$

$1600\mathrm{.}25$

Fixed Costs are estimated to follow a normal distribution with mean $$50,000$ and standard deviation of $$5,000.$

Simulate this model for $500$ trials. Assume your production quantity is equal to demand. What is the average profit? PLEASE DO IT ON EXCEL AND SHOW ALL YOU WORK AND FORMULAS, I WILL GIVE YOU A GOOD REVIEW, thanksss