1. What is the average profit?

2. What is the standard deviation of the profits?

3. what is the minimum simulated profit?

4. what is the maximum simulated profit?

5. What percentage of the simulations show a profit less than $15000?

6. If the standard deviation of the variable cost increases, do you expect the % of simulations with a profit less than $15000 increase or decrease?

7. If the standard deviation of the fixed cost increases, do you expect the % of simulations with a profit less than $15000 increase or decrease?

Part 1 CVP Calculations Complete the table below by calculating the: Contribution Margin Total Contribution Margin Profit for each of the cases. ariable Cost per unit ixed Costs 14.00 $ 75,000 Demand parameter 1 Demand parameter 2 429,600 1.3 Demand Schedule Price Variable Contribution Total Margin Fixed Cost $ 75,000 Marginal Revenue Quantit Cost CM Profit 1,968 $ 63.0014.00 2,009 $ 62.00 $ 14.00 2,052 $ 61.00 14.00 2,096 $ 60.00$ 14.00 2,143 $ 59.00 14.00 2,191 $ 58.0014.00 2,241 $ 57.0014.00 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 (14.42) 14.19 13.96 (13.73) (13.50) (13.27) 431,400 ariable Cost per unit14.00 75,000 Demand parameter1 parameter 2 Demand Schedule Variable Contributior Total Marginal Profit 1,976$ 63.00 $14.00 2,017$ 62.00 $14.00 $75,000 2,105$ 60.00 $14.00 2,152$ 59.00 $ 14.00 2,200 $ 58.00$ 14.00 2,250$ 57.00$14.00 Part 2 Profit Simulation with changing Variable and Fixed Costs imulation parameters $ 9,000 Random Number Generator N1 im 2