$6.$ Go to the Private Lessons worksheet. This worksheet analyzes financial data for private and semi$-$private lessons, which the camp runs throughout the day. Takara has already created a scenario named Current Campers that calculates profit based on the current number of campers enrolled for each session. She also wants to calculate profit based on the maximum number of campers.

Add a new scenario to compare the profit with maximum enrollments as follows:

a$.$ Use Max Campers as the scenario name.

b$.$ Use the enrolled campers per day data $($range C$9$:G$9)$ as the changing cells.

c$.$ Enter cell values for the Max Campers scenario as shown in bold in Table $1,$ which are the same values as in the range C$8$:G$8.$

Table $1$: Cell Values for the Max Campers Scenario

Cell Value

Baseball$\_$Campers $($cell C$9)10$

Basketball$\_$Campers $($cell D$9)12$

Lacrosse$\_$Campers $($cell E$9)10$

Soccer$\_$Campers $($cell F$9)12$

Volleyball$\_$Campers $($cell G$9)15$