Top-Rated Free Essay
Preview

E CH06 EXPV2 H1 Instructions

Good Essays
659 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
E CH06 EXPV2 H1 Instructions
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 cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a one-variable data table in cells F2, G2, and 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 (in cells E3:E18), 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 cell 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
10
Apply a Red, Accent 2, Lighter 60% fill color to the cells closest to break-even without creating a deficit.
2
11
Apply custom number format to cell E21 to display #Attend.
2
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. Enter these values for the scenario: 500, 15.95, 75, and 12500.
5
13
Create a second scenario named 400 Attend, using the same changing cells. Enter these values for the scenario: 400, 17.95, 85, and 12500.
5
14
Create a third scenario named 300 Attend, using the same changing cells. Enter these values for the scenario: 300, 19.95, 90, and 11995, respectively.
5
15
Create a fourth scenario named 200 Attend, using the same changing cells. Enter these values for the scenario: 200, 22.95, 95, and 11995, respectively.
5
16
Generate a scenario summary report using the Total Revenue, Total Expenses, and Balance as the results.
6
17
Load the Solver add-in if it is not already loaded. Click the Budget worksheet and set the objective to calculate the highest balance possible.
5
18
Use the Number of Attendees and the Ticket Price per Person as changing variable cells.
5
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
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
21
Set an appropriate integer constraint.
5
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 Vehicle.
5
23
Solve the problem, but keep the original values in the Budget worksheet. Generate the Answer Report.
5
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

Total Points
100

You May Also Find These Documents Helpful

  • Good Essays

    Read the instructions in the University of Phoenix Material: Accounting System Paper located on the student website and complete the assignment for:…

    • 865 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    PT1420 Unit 8 Lab 8

    • 365 Words
    • 2 Pages

    Incrementing by Values Other than 1, page 190): Display numbers starting at 0 through 10 by increments of 2. 0,2,4,6,8,10…

    • 365 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    | The rules of how to set up and report financial information, including the formulas and format…

    • 275 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Ac550 Course Project

    • 579 Words
    • 3 Pages

    • Determine which accounts belong to the Balance Sheet and which accounts belong to the Income Statement…

    • 579 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    EIC and Tax Tables

    • 13897 Words
    • 56 Pages

    $1 50 100 150 200 250 300 350 400 450 500 550 600 650 700 750 800 850 900 950 1,000 1,050 1,100 1,150 1,200 1,250 1,300 1,350 1,400 1,450 1,500 1,550 1,600 1,650 1,700 1,750 1,800 1,850 1,900 1,950 2,000 2,050 2,100 2,150 2,200 2,250 2,300 2,350 2,400 2,450…

    • 13897 Words
    • 56 Pages
    Satisfactory Essays
  • Powerful Essays

    Taxation and Home Tab

    • 1215 Words
    • 5 Pages

    | In cell J5, insert a formula that will add the numbers in cells F5:I5. Use the fill handle to copy the formula into cells J6 through J8.Hint: To insert the formula, in cell J5, type =F5+G5+H5+I5 and then press ENTER. To copy the formula, use the fill handle in the bottom right corner of the cell.…

    • 1215 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Chid Abuse

    • 829 Words
    • 4 Pages

    For the purpose of grading the project you are required to perform the following tasks:…

    • 829 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    range B9:F9 and calculate the apartment complex totals in the range G5:G8. In cell G9, enter a grand…

    • 369 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Accounting and Financial Reporting . From Chapter 1 complete Exercise 1-6 and Exercise 1-9. From chapter 2 complete Exercise 2-2 and post the answers to the discussion board. Do not forget to show all necessary steps and explain how you attained the outcome. Respond to at least two of your classmates’ postings.…

    • 690 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Finance

    • 1032 Words
    • 5 Pages

    2. Also in Exhibit 1, compute net income/net revenue (sales) for each of the four years. Begin with 2009.…

    • 1032 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    • Develop at least two tables, using the same step of the accounting cycle selected for your previous Learning Team assignments, that could be used in a database for your selected accounting cycle.…

    • 103 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    cold pizza

    • 420 Words
    • 3 Pages

    The document was created in an earlier version of Word, so you will convert it to Office 2013. Click the FILE tab, and then click Info, if necessary. Convert the document.…

    • 420 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Spyder Active Sports

    • 486 Words
    • 8 Pages

    Advertisement, brand marketing, competition, brand value, scope of expansion, goodwill, supply channel the product portfolio.…

    • 486 Words
    • 8 Pages
    Satisfactory Essays
  • Satisfactory Essays

    For the purpose of grading the project you are required to perform the following tasks:…

    • 440 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Program Plan: Once we have gotten the numbers from the user and converted them to numbers. We can make a row by multiplying a string containing a single asterisk by the number of asterisks in a row. If we add the string "\n" to the end of this (Remember the new line stops the current line when printed) we have a complete line. Now multiply all this (put it in parentheses and mul the parentheses) by the number of rows. Print this expression.…

    • 789 Words
    • 4 Pages
    Good Essays