Write a VBA program that will step through the range named CostScenarios, taking each value, setting the range VCost equal to that value. That updates the range (a single cell) named Profit. Then we want to put profit in the range MyProfit in the same row as the corresponding cost in CostScenarios. We will also compute Break Even volume in Col E using Goal Seek. This program mimics the functionality of a Data Table. Also write another subroutine that will clear the computed MyProfit and Break Even values. Create form control buttons to run the subroutines

File Home Insert Draw Page Layout Formulas Data Record Macro | Use Relative References Add- Excel COM A Macro Security ins Add-ins Add-ins Code Add-ins Review View Developer Help Properties Insert Design View Code Source Mode Run Dialog Controls Map Properties Expansion Packs Refresh Data Import Export Visual Macros Basic XML H24 fx F K M N CostScenario BreakEven ModellSB$29.$B$43 FCost =BreakEven ModellsB$4 MyProfit =BreakEven Modell$D$29:50543 Price =BreakEven Modell$B$6 Profit =BreakEven Modell$B$13 Revenue =BreakEven Modell$B$11 TotalCost =BreakEven ModellSBS12 VCost BreakEven ModellSB55 Volume BreakEven Modellses? B C D E 1 Break even analysis model 2 3 Inputs 4 Fixed Cost $100,000 5 Variable costunit $1.25 6 Price $2.00 7 Volume 300.000 8 9 10 Profit Model 11 Revenue $800,000 12 Total Cost $475,000 13 Profit $125,000 Question 1. What is the expected profit before taxes? 14 15 16 17 18 19 Question 2. Volume 20 Solve the following equation with Goal Seek, using Volume as the changing cell 21 Profit $125,000 22 Break Even Volume BBHB%9mm888%# 25 Question 3 - What is the profit before tax if the variable cost goes changes? 26 27 Cost Profit 28 $ 125.000 MyProfit 29 $1.25 $ 125,000 30 $1.30 $ 110,000 31 $1.35 $ 95,000 32 $1.40 $ 80.000 33 $1.45 $ 65,000 34 $1.50 $ 50.000 35 $1.55 $ 35,000 36 $1.60 $ 20,000 37 $1.65 $ 5,000 38 $1.70 $ (10,000) 39 $1.75 $ (25.000) 40 $1.80 $ (40.000) 41 $1.85 $ (55.000) 42 $1.90 $ (70,000) 43 $1.95 $ (85.000) 44 45 46 BreakEven Model + File Home Insert Draw Page Layout Formulas Data Record Macro | Use Relative References Add- Excel COM A Macro Security ins Add-ins Add-ins Code Add-ins Review View Developer Help Properties Insert Design View Code Source Mode Run Dialog Controls Map Properties Expansion Packs Refresh Data Import Export Visual Macros Basic XML H24 fx F K M N CostScenario BreakEven ModellSB$29.$B$43 FCost =BreakEven ModellsB$4 MyProfit =BreakEven Modell$D$29:50543 Price =BreakEven Modell$B$6 Profit =BreakEven Modell$B$13 Revenue =BreakEven Modell$B$11 TotalCost =BreakEven ModellSBS12 VCost BreakEven ModellSB55 Volume BreakEven Modellses? B C D E 1 Break even analysis model 2 3 Inputs 4 Fixed Cost $100,000 5 Variable costunit $1.25 6 Price $2.00 7 Volume 300.000 8 9 10 Profit Model 11 Revenue $800,000 12 Total Cost $475,000 13 Profit $125,000 Question 1. What is the expected profit before taxes? 14 15 16 17 18 19 Question 2. Volume 20 Solve the following equation with Goal Seek, using Volume as the changing cell 21 Profit $125,000 22 Break Even Volume BBHB%9mm888%# 25 Question 3 - What is the profit before tax if the variable cost goes changes? 26 27 Cost Profit 28 $ 125.000 MyProfit 29 $1.25 $ 125,000 30 $1.30 $ 110,000 31 $1.35 $ 95,000 32 $1.40 $ 80.000 33 $1.45 $ 65,000 34 $1.50 $ 50.000 35 $1.55 $ 35,000 36 $1.60 $ 20,000 37 $1.65 $ 5,000 38 $1.70 $ (10,000) 39 $1.75 $ (25.000) 40 $1.80 $ (40.000) 41 $1.85 $ (55.000) 42 $1.90 $ (70,000) 43 $1.95 $ (85.000) 44 45 46 BreakEven Model +