EX16_XL_CH06_GRADER_CAP_AS – Valentine Budget 1.0
Project Description:
In the following project, you will perform WhatIf 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_Capstone2.xlsx. 
0.000 
2 
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person. 
6.000 
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.000 
4 
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a onevariable data table in cells F2, G2, and H2 respectively. 
3.000 
5 
Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 – Expenses, H2 – Balance. 
3.000 
6 
Create a onevariable 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.000 
7 
Copy the Number of Attendees substitution values from the onevariable data table (in cells E3:E18), and then paste the values starting in cell E22. 
4.000 
8 
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments. 
2.000 
9 
Enter the cell reference to the Balance formula (C34) in the cell E21 for a twovariable 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.000 
10 
Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to breakeven without creating a deficit. 
2.000 
11 
Apply custom number format to cell E21 to display # Attend. 
2.000 
12 
Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500. 
5.000 
13 
Create a second scenario named 400 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 400, 17.95, 85, and 12500. 
5.000 
14 
Create a third scenario named 300 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively. 
5.000 
15 
Create a fourth scenario named 200 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively. 
5.000 
16 
Generate a scenario summary report using the Total Income, Total Expenses, and Balance as the results. 
6.000 
17 
Load the Solver addin if it is not already loaded. Click the Budget worksheet and launch Solver. Set the objective to calculate the highest balance possible. 
5.000 
18 
Use the Number of Attendees and the Ticket Price per Person as changing variable cells. 
5.000 
19 
Set a constraint so that the Number of Attendees entered in the Input Section of the workbook does not exceed the specified limitation in cell B12. 
5.000 
20 
Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A14:B15. 
5.000 
21 
Set an appropriate integer constraint. 
5.000 
22 
Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Car (in that order). 
5.000 
23 
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report. 
5.000 
24 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
EX16_XL_CH06_GRADER_CAP_AS – Valentine Budget 1.0
Project Description:
In the following project, you will perform WhatIf 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_Capstone2.xlsx. 
0.000 
2 
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person. 
6.000 
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.000 
4 
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a onevariable data table in cells F2, G2, and H2 respectively. 
3.000 
5 
Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 – Expenses, H2 – Balance. 
3.000 
6 
Create a onevariable 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.000 
7 
Copy the Number of Attendees substitution values from the onevariable data table (in cells E3:E18), and then paste the values starting in cell E22. 
4.000 
8 
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments. 
2.000 
9 
Enter the cell reference to the Balance formula (C34) in the cell E21 for a twovariable 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.000 
10 
Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to breakeven without creating a deficit. 
2.000 
11 
Apply custom number format to cell E21 to display # Attend. 
2.000 
12 
Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500. 
5.000 
13 
Create a second scenario named 400 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 400, 17.95, 85, and 12500. 
5.000 
14 
Create a third scenario named 300 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively. 
5.000 
15 
Create a fourth scenario named 200 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively. 
5.000 
16 
Generate a scenario summary report using the Total Income, Total Expenses, and Balance as the results. 
6.000 
17 
Load the Solver addin if it is not already loaded. Click the Budget worksheet and launch Solver. Set the objective to calculate the highest balance possible. 
5.000 
18 
Use the Number of Attendees and the Ticket Price per Person as changing variable cells. 
5.000 
19 
Set a constraint so that the Number of Attendees entered in the Input Section of the workbook does not exceed the specified limitation in cell B12. 
5.000 
20 
Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A14:B15. 
5.000 
21 
Set an appropriate integer constraint. 
5.000 
22 
Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Car (in that order). 
5.000 
23 
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report. 
5.000 
24 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
EX16_XL_CH06_GRADER_CAP_AS – Valentine Budget 1.0
Project Description:
In the following project, you will perform WhatIf 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_Capstone2.xlsx. 
0.000 
2 
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person. 
6.000 
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.000 
4 
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a onevariable data table in cells F2, G2, and H2 respectively. 
3.000 
5 
Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 – Expenses, H2 – Balance. 
3.000 
6 
Create a onevariable 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.000 
7 
Copy the Number of Attendees substitution values from the onevariable data table (in cells E3:E18), and then paste the values starting in cell E22. 
4.000 
8 
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments. 
2.000 
9 
Enter the cell reference to the Balance formula (C34) in the cell E21 for a twovariable 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.000 
10 
Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to breakeven without creating a deficit. 
2.000 
11 
Apply custom number format to cell E21 to display # Attend. 
2.000 
12 
Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500. 
5.000 
13 
Create a second scenario named 400 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 400, 17.95, 85, and 12500. 
5.000 
14 
Create a third scenario named 300 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively. 
5.000 
15 
Create a fourth scenario named 200 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively. 
5.000 
16 
Generate a scenario summary report using the Total Income, Total Expenses, and Balance as the results. 
6.000 
17 
Load the Solver addin if it is not already loaded. Click the Budget worksheet and launch Solver. Set the objective to calculate the highest balance possible. 
5.000 
18 
Use the Number of Attendees and the Ticket Price per Person as changing variable cells. 
5.000 
19 
Set a constraint so that the Number of Attendees entered in the Input Section of the workbook does not exceed the specified limitation in cell B12. 
5.000 
20 
Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A14:B15. 
5.000 
21 
Set an appropriate integer constraint. 
5.000 
22 
Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Car (in that order). 
5.000 
23 
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report. 
5.000 
24 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
EX16_XL_CH06_GRADER_CAP_AS – Valentine Budget 1.0
EX16_XL_CH06_GRADER_CAP_AS – Valentine Budget 1.0EX16_XL_CH06_GRADER_CAP_AS – Valentine Budget 1.0EX16_XL_CH06_GRADER_CAP_AS – Valentine Budget 1.0
Project Description:
Project Description: Project Description: Project Description:
In the following project, you will perform WhatIf Analysis to calculate budget information for your university’s Valentine’s Day formal.
In the following project, you will perform WhatIf Analysis to calculate budget information for your university’s Valentine’s Day formal.In the following project, you will perform WhatIf Analysis to calculate budget information for your university’s Valentine’s Day formal.In the following project, you will perform WhatIf Analysis to calculate budget information for your university’s Valentine’s Day formal.
Instructions:
Instructions: Instructions: Instructions:
For the purpose of grading the project you are required to perform the following tasks:
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_Capstone2.xlsx. 
0.000 
2 
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person. 
6.000 
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.000 
4 
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a onevariable data table in cells F2, G2, and H2 respectively. 
3.000 
5 
Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 – Expenses, H2 – Balance. 
3.000 
6 
Create a onevariable 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.000 
7 
Copy the Number of Attendees substitution values from the onevariable data table (in cells E3:E18), and then paste the values starting in cell E22. 
4.000 
8 
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments. 
2.000 
9 
Enter the cell reference to the Balance formula (C34) in the cell E21 for a twovariable 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.000 
10 
Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to breakeven without creating a deficit. 
2.000 
11 
Apply custom number format to cell E21 to display # Attend. 
2.000 
12 
Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500. 
5.000 
13 
Create a second scenario named 400 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 400, 17.95, 85, and 12500. 
5.000 
14 
Create a third scenario named 300 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively. 
5.000 
15 
Create a fourth scenario named 200 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively. 
5.000 
16 
Generate a scenario summary report using the Total Income, Total Expenses, and Balance as the results. 
6.000 
17 
Load the Solver addin if it is not already loaded. Click the Budget worksheet and launch Solver. Set the objective to calculate the highest balance possible. 
5.000 
18 
Use the Number of Attendees and the Ticket Price per Person as changing variable cells. 
5.000 
19 
Set a constraint so that the Number of Attendees entered in the Input Section of the workbook does not exceed the specified limitation in cell B12. 
5.000 
20 
Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A14:B15. 
5.000 
21 
Set an appropriate integer constraint. 
5.000 
22 
Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Car (in that order). 
5.000 
23 
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report. 
5.000 
24 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0.000 

Total Points 
100.000 
Step
Instructions
Points Possible
Step
Instructions
Points Possible
Step
Step
StepStepStep
Instructions
Instructions
InstructionsInstructionsInstructions
Points Possible
Points Possible
Points PossiblePoints PossiblePoints Possible
1
Download and open the file named exploring_e06_grader_Capstone2.xlsx.
0.000
2
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person.
6.000
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.000
4
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a onevariable data table in cells F2, G2, and H2 respectively.
3.000
5
Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 – Expenses, H2 – Balance.
3.000
6
Create a onevariable 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.000
7
Copy the Number of Attendees substitution values from the onevariable data table (in cells E3:E18), and then paste the values starting in cell E22.
4.000
8
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments.
2.000
9
Enter the cell reference to the Balance formula (C34) in the cell E21 for a twovariable 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.000
10
Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to breakeven without creating a deficit.
2.000
11
Apply custom number format to cell E21 to display # Attend.
2.000
12
Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500.
5.000
13
Create a second scenario named 400 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 400, 17.95, 85, and 12500.
5.000
14
Create a third scenario named 300 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively.
5.000
15
Create a fourth scenario named 200 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively.
5.000
16
Generate a scenario summary report using the Total Income, Total Expenses, and Balance as the results.
6.000
17
Load the Solver addin if it is not already loaded. Click the Budget worksheet and launch Solver. Set the objective to calculate the highest balance possible.
5.000
18
Use the Number of Attendees and the Ticket Price per Person as changing variable cells.
5.000
19
Set a constraint so that the Number of Attendees entered in the Input Section of the workbook does not exceed the specified limitation in cell B12.
5.000
20
Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A14:B15.
5.000
21
Set an appropriate integer constraint.
5.000
22
Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Car (in that order).
5.000
23
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report.
5.000
24
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0.000
Total Points
100.000
1
Download and open the file named exploring_e06_grader_Capstone2.xlsx.
0.000
1
1
111
Download and open the file named exploring_e06_grader_Capstone2.xlsx.
Download and open the file named exploring_e06_grader_Capstone2.xlsx.
Download and open the file named exploring_e06_grader_Capstone2.xlsx.exploring_e06_grader_Capstone2.xlsx.
0.000
0.000
0.000
2
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person.
6.000
2
2
222
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person.
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person.
Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person.$0
6.000
6.000
6.000
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.000
3
3
333
Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E.
Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E.
Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E.20050020
3.000
3.000
3.000
4
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a onevariable data table in cells F2, G2, and H2 respectively.
3.000
4
4
444
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a onevariable data table in cells F2, G2, and H2 respectively.
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a onevariable data table in cells F2, G2, and H2 respectively.
Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a onevariable data table in cells F2, G2, and H2 respectively.
3.000
3.000
3.000
5
Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 – Expenses, H2 – Balance.
3.000
5
5
555
Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 – Expenses, H2 – Balance.
Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 – Expenses, H2 – Balance.
Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 – Expenses, H2 – Balance.Apply custom number formats to make the formula references appear as the following: F2 Revenue, G2 Revenue– Expenses Expenses, H2 – Balance.Balance
3.000
3.000
3.000
6
Create a onevariable 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.000
6
6
666
Create a onevariable 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.
Create a onevariable 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.
Create a onevariable 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.000
7.000
7.000
7
Copy the Number of Attendees substitution values from the onevariable data table (in cells E3:E18), and then paste the values starting in cell E22.
4.000
7
7
777
Copy the Number of Attendees substitution values from the onevariable data table (in cells E3:E18), and then paste the values starting in cell E22.
Copy the Number of Attendees substitution values from the onevariable data table (in cells E3:E18), and then paste the values starting in cell E22.
Copy the Number of Attendees substitution values from the onevariable data table (in cells E3:E18), and then paste the values starting in cell E22.
4.000
4.000
4.000
8
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments.
2.000
8
8
888
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments.
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments.
Type $50 in cell F21 and complete the series of substitution values from $50 to $100 at $10 increments.$5010010
2.000
2.000
2.000
9
Enter the cell reference to the Balance formula (C34) in the cell E21 for a twovariable 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.000
9
9
999
Enter the cell reference to the Balance formula (C34) in the cell E21 for a twovariable 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.
Enter the cell reference to the Balance formula (C34) in the cell E21 for a twovariable 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.
Enter the cell reference to the Balance formula (C34) in the cell E21 for a twovariable 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.000
7.000
7.000
10
Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to breakeven without creating a deficit.
2.000
10
10
101010
Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to breakeven without creating a deficit.
Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to breakeven without creating a deficit.
Apply a Red, Accent 2, Lighter 60% fill color to the three cells closest to breakeven without creating a deficit.
2.000
2.000
2.000
11
Apply custom number format to cell E21 to display # Attend.
2.000
11
11
111111
Apply custom number format to cell E21 to display # Attend.
Apply custom number format to cell E21 to display # Attend.
Apply custom number format to cell E21 to display # Attend.# Attend
2.000
2.000
2.000
12
Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500.
5.000
12
12
121212
Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500.
Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500.
Create a scenario named 500 Attend using the Number of Attendees, Caterer’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500.Create a scenario named 500 Attend using the Number of Attendees, Caterer500 Attend’s Meal Cost per Person, Ticket Price per Person, and Ballroom Rental variables as the changing cells. Deselect Prevent changes. Enter these values for the scenario: 500, 15.95, 75, and 12500.50015.957512500
5.000
5.000
5.000
13
Create a second scenario named 400 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 400, 17.95, 85, and 12500.
5.000
13
13
131313
Create a second scenario named 400 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 400, 17.95, 85, and 12500.
Create a second scenario named 400 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 400, 17.95, 85, and 12500.
Create a second scenario named 400 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 400, 17.95, 85, and 12500.400 Attend40017.958512500
5.000
5.000
5.000
14
Create a third scenario named 300 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively.
5.000
14
14
141414
Create a third scenario named 300 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively.
Create a third scenario named 300 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively.
Create a third scenario named 300 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively. 300 Attend30019.959011995
5.000
5.000
5.000
15
Create a fourth scenario named 200 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively.
5.000
15
15
151515
Create a fourth scenario named 200 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively.
Create a fourth scenario named 200 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively.
Create a fourth scenario named 200 Attend, using the same changing cells. Deselect Prevent changes. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively. 200 Attend20022.959511995
5.000
5.000
5.000
16
Generate a scenario summary report using the Total Income, Total Expenses, and Balance as the results.
6.000
16
16
161616
Generate a scenario summary report using the Total Income, Total Expenses, and Balance as the results.
Generate a scenario summary report using the Total Income, Total Expenses, and Balance as the results.
Generate a scenario summary report using the Total Income, Total Expenses, and Balance as the results.
6.000
6.000
6.000
17
Load the Solver addin if it is not already loaded. Click the Budget worksheet and launch Solver. Set the objective to calculate the highest balance possible.
5.000
17
17
171717
Load the Solver addin if it is not already loaded. Click the Budget worksheet and launch Solver. Set the objective to calculate the highest balance possible.
Load the Solver addin if it is not already loaded. Click the Budget worksheet and launch Solver. Set the objective to calculate the highest balance possible.
Load the Solver addin if it is not already loaded. Click the Budget worksheet and launch Solver. Set the objective to calculate the highest balance possible.
5.000
5.000
5.000
18
Use the Number of Attendees and the Ticket Price per Person as changing variable cells.
5.000
18
18
181818
Use the Number of Attendees and the Ticket Price per Person as changing variable cells.
Use the Number of Attendees and the Ticket Price per Person as changing variable cells.
Use the Number of Attendees and the Ticket Price per Person as changing variable cells.
5.000
5.000
5.000
19
Set a constraint so that the Number of Attendees entered in the Input Section of the workbook does not exceed the specified limitation in cell B12.
5.000
19
19
191919
Set a constraint so that the Number of Attendees entered in the Input Section of the workbook does not exceed the specified limitation in cell B12.
Set a constraint so that the Number of Attendees entered in the Input Section of the workbook does not exceed the specified limitation in cell B12.
Set a constraint so that the Number of Attendees entered in the Input Section of the workbook does not exceed the specified limitation in cell B12.
5.000
5.000
5.000
20
Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A14:B15.
5.000
20
20
202020
Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A14:B15.
Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A14:B15.
Set constraints so that the Ticket Price per Person entered in the Input Section meets the requirements set in the range A14:B15.
5.000
5.000
5.000
21
Set an appropriate integer constraint.
5.000
21
21
212121
Set an appropriate integer constraint.
Set an appropriate integer constraint.
Set an appropriate integer constraint.
5.000
5.000
5.000
22
Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Car (in that order).
5.000
22
22
222222
Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Car (in that order).
Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Car (in that order).
Set a constraint that ensures the Valet Parking expense is less than or equal to the product of the Maximum Parking Stalls and the Valet Parking per Car (in that order).
5.000
5.000
5.000
23
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report.
5.000
23
23
232323
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report.
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report.
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report.
5.000
5.000
5.000
24
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0.000
24
24
242424
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Budget. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0.000
0.000
0.000
Total Points
100.000
Total Points
Total Points
Total PointsTotal PointsTotal Points
100.000
100.000
100.000100.000100.000