Question

6. Create two scenarios as follows to compare the costs of hiring fitness instructors with those for hiring certified personal trainers while increasing the number of hours provided: a. In the Scenario Manager, add two scenarios using the data shown in bold in Table 1 below. b. The changing cells for both scenarios are the nonadjacent cells C4, C11, and C14. c. Close the Scenario Manager without showing any of the scenarios.

Values Scenario 1 Scenario 2
Scenario Name Instructors Trainers
Hours_Sold_Consulting (C4) 1500 1800
Variable_Cost_Per_Hour_Consulting (C11) 53 55
Total_Fixed_Cost_Consulting (C14) 34,500 35,500

Answer 1

The given question is about comparing the costs of hiring fitness instructors with those for hiring certified personal trainers while increasing the number of hours provided. Two scenarios are presented with different values for variables, allowing for a comparison of costs using the Scenario Manager.

Step-by-step explanation:

In this scenario, we are comparing the costs of hiring fitness instructors with those for hiring certified personal trainers while increasing the number of hours provided. Two scenarios are presented, Scenario 1 and Scenario 2, with different values for variables such as Hours_Sold_Consulting, Variable_Cost_Per_Hour_Consulting, and Total_Fixed_Cost_Consulting. The changing cells for both scenarios are nonadjacent cells C4, C11, and C14.

Scenario 1 represents the cost of hiring fitness instructors, while Scenario 2 represents the cost of hiring certified personal trainers. The values for Hours_Sold_Consulting, Variable_Cost_Per_Hour_Consulting, and Total_Fixed_Cost_Consulting differ between the two scenarios, which allows for a comparison of costs. By adding these scenarios to the Scenario Manager, you can analyze and compare the costs between the two options without creating any actual scenarios.