Question: QUESTION 3: Create a table in Microsoft Excel illustrating how the weighted average and total number of visits for break-even changes based on a given


QUESTION 3: Create a table in Microsoft Excel illustrating how the weighted average and total number of visits for break-even changes based on a given percentage change in the visits after 5pm. Create this table based on the assumptions for the Swansons in Table 1. For example, decrease the number of times the Swansons go after 5 b}? 1% and increase the number of times the Swansons go before 5 by 1%, then 2% up to 5%. Then, increase the number of times the Swanson go to the pool after 5% and decrease the number of times the Swansons go to the pool before 5 by 1%, then 2%, up to 5%. The purpose of this table is to illustrate how the weighted average contribution margin per unit and the break-even point change as the usage mist changes. The percentage of visits after 5pm should range from 20% to 313% and the percentage from Table 1 for two people (50%) should remain constant. Your table should appear like Figure LW'hen completing your table, use appropriate formulas to make your table as flexible as possible (use formulas and no-hard coding}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
