1, On the SalesGoal worksheet, you have been asked to predict how much to raise the cost of classes to reach the total sales goal of $40,000. You will increase all classes by the same percentage. In cell C3, type =SalesData!C3*(1+$D$22) Copy the formula through cell D8.

2. In cell C12, enter a formula similar to cell C3 using the correct cell references. Copy the formula through cell C18. Because the results on the SalesData worksheet indicated that the low-selling courses should be discontinued, change the yearly sessions sold for Racquetball in cell B15 to 0.

3. Through trial and error, determine the recommended percentage of increase in the cost per class session in cell D22 to reach the 2022 sales goal of at least $40,000.

 

Transcribed Image Text:

B 1 2022 Predicted Sales Data Yearly Sessions Sold 2 Adult Classes Offered 3 Yoga 4 Pilates 5 Body Pump 6 Spinning 7 Water Aerobics 8 Triathlon Training 9 Total 10 11 A Youth Classes Offered 12 Swimming 13 Basketball 14 Volleyball 15 Racquetball 16 Lacrosse 17 Soccer 18 Baseball 19 Total 20 21 22 23 257 310 195 218 152 98 1,230 Yearly Sessions Sold 210 231 178 78 143 217 160 1,217 C 2022 Cost per class session 2022 Cost per class session Total Sales of Exercise Classes Sales Increase Percentage Recommendation Sales Total $ GA GA GA GA GA $ $ $ $ $ 69 69 69 69 69 69 $ Sales Total $ $ $ $ D $ $ 1 I 1 I I I I E LU B 1 2022 Predicted Sales Data Yearly Sessions Sold 2 Adult Classes Offered 3 Yoga 4 Pilates 5 Body Pump 6 Spinning 7 Water Aerobics 8 Triathlon Training 9 Total 10 11 A Youth Classes Offered 12 Swimming 13 Basketball 14 Volleyball 15 Racquetball 16 Lacrosse 17 Soccer 18 Baseball 19 Total 20 21 22 23 257 310 195 218 152 98 1,230 Yearly Sessions Sold 210 231 178 78 143 217 160 1,217 C 2022 Cost per class session 2022 Cost per class session Total Sales of Exercise Classes Sales Increase Percentage Recommendation Sales Total $ GA GA GA GA GA $ $ $ $ $ 69 69 69 69 69 69 $ Sales Total $ $ $ $ D $ $ 1 I 1 I I I I E LU

Answer rating: 100% (QA)

Solution 1 Calculate the increased cost per class In cell C3 type the following formula SalesDataC31... View the full answer