One way to increase profits is to run the GymWear trade show for an extra day. Another way is to add exhibits. Fernanda has already created a scenario named Extra Day and wants to create another for adding exhibits. In the Scenario Manager, add a scenario named using the data shown in bold in Table 1. The changing cells are the nonadjacent cells C4, C10, and C13.
Table 1: GymWear Scenario Values
| Scenario Name | Add Exhibits |
|---|---|
| Attendees (C4) | 2200 |
| Variable_cost_per_attendee (C10) | 53 |
| Total_fixed_cost (C13) | 52,400 |
Reading books is a great way to learn. Here are some of the books we recommend.
Go to the Data tab > Under Forecast group, select What-if Analysis > Select Scenario Manager > Click Add...
Enter "Add Exhibits" as the Scenario name. Enter C4, C10, C13 in the changing cells and hit Ok.
After that, as given in the question, enter 2200 in Attendees, 53 in Variable_cost_per_attendee, and 52,400 in Total_fixed_cost. After that click Ok and close the Scenario Manager pop-up container.