Goal seek, break-even analysis 3) When the unit ticket price is $50, how many weeks will the play have to run for us to break even? (Directly enter your answer to the cell. no cell reference) 4) How many weeks will the play have to run so that the Total Profit is exactly equal to $10 million? (Directly enter your answer to the cell. no cell reference) Sensitivity analysis, 1-way and 2-way data table 5) Fix the Number of weeks at 100, set up a one-way data table to determine how a change in Unit ticket price affect the Total Profit, by changing Unit ticket price from $20 to $100 with increments of $10. 6) Display the data from table in 5) using a scatter chart (horizontal axis: variations in unit ticket prices, vertical axis: total profits). Add axis titles and a chart title 7) Set-up a two-way data table to determine how changes in Unit ticket price AND the Number of weeks the play runs affect Total Profit. (Changing Unit ticket price from $20 to $100 with increments of $10; Changing Number of weeks from 50 to 400 with increments of 50 weeks.) INDEX and MATCH 8) Use MAX, INDEX, MATCH function to find the Number of weeks that gives the maximum Total Profit for each value of the Unit ticket price in your two-way table. OPTIMAL DECISION VARIABLES 9) Identify the optimal decision variables, i.e., the best combination of Number of weeks AND the Unit ticket price that provide the maximum Total Profit in your two-way table. Directly enter your answer in the cell. Percent seats filled 65.00% Total Profit $39,228,000 Part 3 \begin{tabular}{|l|l|} \hline number of weeks to break even (do not use cell reference. Enter your answer directly) & 30 \\ \hline \end{tabular} Part 4 Goal seek, break-even analysis 3) When the unit ticket price is $50, how many weeks will the play have to run for us to break even? (Directly enter your answer to the cell. no cell reference) 4) How many weeks will the play have to run so that the Total Profit is exactly equal to $10 million? (Directly enter your answer to the cell. no cell reference) Sensitivity analysis, 1-way and 2-way data table 5) Fix the Number of weeks at 100 , set up a one-way data table to determine how a change in Unit ticket price affect the Total Profit, by changing Unit ticket price from $20 to $100 with increments of $10. 6) Display the data from table in 5) using a scatter chart (horizontal axis: variations in unit ticket prices, vertical axis: total profits). Add axis titles and a chart title 7) Set-up a two-way data table to determine how changes in Unit ticket price AND the Number of weeks the play runs affect Total Profit. (Changing Unit ticket price from \$20 to $100 with increments of $10; Changing Number of weeks from 50 to 400 with increments of 50 weeks.) INDEX and MATCH 8) Use MAX, INDEX, MATCH function to find the Number of weeks that gives the maximum Total Profit for each value of the Unit ticket price in your two-way table. OPTIMAL DECISION VARIABLES 9) Identify the optimal decision variables, i.e., the best combination of Number of weeks AND the Unit ticket price that provide the maximum Total Profit in your two-way table. Directly enter your answer in the cell. Goal seek, break-even analysis 3) When the unit ticket price is $50, how many weeks will the play have to run for us to break even? (Directly enter your answer to the cell. no cell reference) 4) How many weeks will the play have to run so that the Total Profit is exactly equal to $10 million? (Directly enter your answer to the cell. no cell reference) Sensitivity analysis, 1-way and 2-way data table 5) Fix the Number of weeks at 100, set up a one-way data table to determine how a change in Unit ticket price affect the Total Profit, by changing Unit ticket price from $20 to $100 with increments of $10. 6) Display the data from table in 5) using a scatter chart (horizontal axis: variations in unit ticket prices, vertical axis: total profits). Add axis titles and a chart title 7) Set-up a two-way data table to determine how changes in Unit ticket price AND the Number of weeks the play runs affect Total Profit. (Changing Unit ticket price from $20 to $100 with increments of $10; Changing Number of weeks from 50 to 400 with increments of 50 weeks.) INDEX and MATCH 8) Use MAX, INDEX, MATCH function to find the Number of weeks that gives the maximum Total Profit for each value of the Unit ticket price in your two-way table. OPTIMAL DECISION VARIABLES 9) Identify the optimal decision variables, i.e., the best combination of Number of weeks AND the Unit ticket price that provide the maximum Total Profit in your two-way table. Directly enter your answer in the cell. Percent seats filled 65.00% Total Profit $39,228,000 Part 3 \begin{tabular}{|l|l|} \hline number of weeks to break even (do not use cell reference. Enter your answer directly) & 30 \\ \hline \end{tabular} Part 4 Goal seek, break-even analysis 3) When the unit ticket price is $50, how many weeks will the play have to run for us to break even? (Directly enter your answer to the cell. no cell reference) 4) How many weeks will the play have to run so that the Total Profit is exactly equal to $10 million? (Directly enter your answer to the cell. no cell reference) Sensitivity analysis, 1-way and 2-way data table 5) Fix the Number of weeks at 100 , set up a one-way data table to determine how a change in Unit ticket price affect the Total Profit, by changing Unit ticket price from $20 to $100 with increments of $10. 6) Display the data from table in 5) using a scatter chart (horizontal axis: variations in unit ticket prices, vertical axis: total profits). Add axis titles and a chart title 7) Set-up a two-way data table to determine how changes in Unit ticket price AND the Number of weeks the play runs affect Total Profit. (Changing Unit ticket price from \$20 to $100 with increments of $10; Changing Number of weeks from 50 to 400 with increments of 50 weeks.) INDEX and MATCH 8) Use MAX, INDEX, MATCH function to find the Number of weeks that gives the maximum Total Profit for each value of the Unit ticket price in your two-way table. OPTIMAL DECISION VARIABLES 9) Identify the optimal decision variables, i.e., the best combination of Number of weeks AND the Unit ticket price that provide the maximum Total Profit in your two-way table. Directly enter your answer in the cell
