1. Go to the New Fees worksheet. DeShawn is considering whether to change the fees for the small-group training sessions. He has created three scenarios on the New Fees worksheet showing the profit with a $10 or $15 fee increase or a $5 fee decrease.
   
   Compare the average profit per program based on the scenarios as follows:
   1. Create a Scenario Summary report using the average profit per program (range B10:F10) as the result cells to show how the average profit changes depending on the fee changes.

b. Use New Fees Scenario Report as the name of the worksheet containing the report

I need help with question number 9

  

Transcribed Image Text:

H1 Home 15 16 17 18 19 20 Paste 21 22 23 24 25 26 27 28 1 2 3 Trainer cost per day 4 Materials cost 4 5 Total cost 6 7 Maximum trainees per day Insert Page Layout Century Sch..... B I U Wrap Text Merge & Center Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates x ✓ fx A 8 Enrolled trainees per day 9 Training fee per person 10 Average profit per program 11 Average profit per trainee 12 13 14 Maxwell Training Ready Documentation 2T 11 $ $ Formulas Data Review A- A- $ $ $ B Orientation Tech Skills Soft Skills Product Mandatory 480 $ 480 $ 35 $ 55 8 $ 535 $ с 360 $ 65 $ 425 $ Blended Training 515 View Developer D 24 8 15 6 75 S 125 $ 700 $ 235 $ 46.67 $ 39.17 $ 77.71 Tutorial Fees 32 24 100 $ E New Fees 375 S 120 $ $ 495 24 16 80 $ 1,865 $ 785 $ $49.06 8 F Webinars 400 100 500 32 12 95 640 53.33 + Last saved by user General 5-%9 G H Cell Conditional Format Formatting as Table Styles I J K H1 Home 15 16 17 18 19 20 Paste 21 22 23 24 25 26 27 28 1 2 3 Trainer cost per day 4 Materials cost 4 5 Total cost 6 7 Maximum trainees per day Insert Page Layout Century Sch..... B I U Wrap Text Merge & Center Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates x ✓ fx A 8 Enrolled trainees per day 9 Training fee per person 10 Average profit per program 11 Average profit per trainee 12 13 14 Maxwell Training Ready Documentation 2T 11 $ $ Formulas Data Review A- A- $ $ $ B Orientation Tech Skills Soft Skills Product Mandatory 480 $ 480 $ 35 $ 55 8 $ 535 $ с 360 $ 65 $ 425 $ Blended Training 515 View Developer D 24 8 15 6 75 S 125 $ 700 $ 235 $ 46.67 $ 39.17 $ 77.71 Tutorial Fees 32 24 100 $ E New Fees 375 S 120 $ $ 495 24 16 80 $ 1,865 $ 785 $ $49.06 8 F Webinars 400 100 500 32 12 95 640 53.33 + Last saved by user General 5-%9 G H Cell Conditional Format Formatting as Table Styles I J K