Chapter 7
What-If Analysis
Project Description:
In the following project, you will perform What-IF Analysis to calculate budget information for your University’s Valentine’s Day formal.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Download and open the file named exploring_e06_grader_h1.xlsx, and then save the file as exploring_e06c1Dance_LastFirst, replacing “LastFirst” with your name. 0
2 Use Goal Seek to achieve a $0 balance by changing the ticket price per person. 6
3 Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E 3
4 Enter references to the total income, total expenses, and balance formulas in that order for a one-variable data table in Cell F2, Cell G2, Cell H2 respectively. 3
5 Apply custom number formats to make the formula references appear as the following: F2- Revenue, G2 – Expenses, H2 – Balance. 3
6 Create a one-variable data table for the range E2:H18 using the number of attendees as the Column input cell. Format the results with Accounting Number Format with two decimal places. 7
7 Copy the number of attendees substitution values from the one-variable data table, and then paste the values starting in cell E22. 4
8 Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments. 2
9 Enter the reference to the balance formula (C34) in the Cell E21 for a two variable data table, then complete the table using cell B9 as the row input cell and B4 as the column input cell. Format the results with Accounting Number Format with two decimal places. 7
Project Description:
In the following project, you will perform What-IF Analysis to calculate budget information for your University’s Valentine’s Day formal.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Download and open the file named exploring_e06_grader_h1.xlsx, and then save the file as exploring_e06c1Dance_LastFirst, replacing “LastFirst” with your name. 0
2 Use Goal Seek to achieve a $0 balance by changing the ticket price per person. 6
3 Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E 3
4 Enter references to the total income, total expenses, and balance formulas in that order for a one-variable data table in Cell F2, Cell G2, Cell H2 respectively. 3
5 Apply custom number formats to make the formula references appear as the following: F2- Revenue, G2 – Expenses, H2 – Balance. 3
6 Create a one-variable data table for the range E2:H18 using the number of attendees as the Column input cell. Format the results with Accounting Number Format with two decimal places. 7
7 Copy the number of attendees substitution values from the one-variable data table, and then paste the values starting in cell E22. 4
8 Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments. 2
9 Enter the reference to the balance formula (C34) in the Cell E21 for a two variable data table, then complete the table using cell B9 as the row input cell and B4 as the column input cell. Format the results with Accounting Number Format with two decimal places. 7