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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!