LEARN MORE...

Need an Excel expert to modify the existing spreadsheet with the instructions in the power point documents.

User Generated

gubznf2018

Business Finance

Description

It is time to build the formulas needed to complete the income statement. Begin working on the Income Statement worksheet and complete formulas for all of the cells marked in gray.

  1. Enter the formula to calculate the Condo Rentals Revenue in C13 Multiple the Quantity of Condo Rental Days * the Price for Condo Rental.
  2. Enter the formula to calculate the Ski Lift Revenue in C14 Multiple the Quantity of Ski Lift Tickets * the Price for Ski Lift Tickets.
  3. Enter the formula to calculate the Winter X Games Revenue in C17 Multiple the Quantity of X Games Tickets * the Price for X Games Tickets.
  4. Enter the formula to calculate the Total Revenues in C20 and Total Expenses in C34.
  5. Make sure the cell references for Total Revenues and Total Expenses are placed in cells C37 and C38 respectively.
  6. Enter the formula to calculate the Net Income in cell C39.
  7. Apply professional formatting to all of this data using the image below as a guide.

Step 2: Build the One-Variable Data Tables

Now that the Income Statement is complete, begin to address the questions about the condo rentals and ski lift tickets.

  1. Build a one-variable data table based on condo rental days. The initial values for Revenue and Net Income for cells I6 and I7 should be cell references from the income statement.
  2. Build a one-variable data table based on the quantity of ski lift tickets. The initial values for Revenue and Net Income for cells I14 and I15 should be cell references from the income statement.
  3. Apply conditional formatting to highlight Net Income of at least $250,000 for each of the one-variable data tables.
  4. In cell G17, a question exists. "If management has a target net income of at least $250,000, which of the above SPECIFIC scenarios in the condo rentals or ski tickets one-variable data table would you recommend using? Explain your reasoning." Make sure you place your answer in the text box beginning in cell G20.
  5. Apply professional formatting to all of this data using the image below as a guide.

    Step 3: Build the Two-Variable Data Table

    Once the one-variable data tables are complete, begin to address the questions about the X Games tickets sold.
  6. Build a two-variable data table based on the quantity and price of the X Games tickets sold. Enter a reference to Net Income in cell I27 from the income statement.
  7. Apply conditional formatting to highlight Net Income of at least $250,000 for each of the two-variable data table.
  8. In cell G37, a question exists. "If management has a target net income of at least $250,000. Which of the above SPECIFIC combinations of price and quantity of X Games Tickets in the two-variable data table would you recommend using? Explain your reasoning."
  9. Make sure you place your answer in the text box beginning in cell G40.
  10. Apply professional formatting to all of this data using the image below as a guide.

    Step 4: Create the Scenario Summary

    You addressed quite a few questions. Now it is time to create a Scenario Summary.
  11. Assign names to all of the income statement cell values in column C in the assumptions, revenues, expenses, and summary sections using the labels in column B. For example, select cells B5:C10, and then on the Formula tab in the Defined Names Group, select "Create from Selection" and use the left column as the name (repeat on lower sections).
  12. Build three scenarios by changing cells C8, C15, C16, C29, and C30 using the following data: Optimistic, Mid-range, and Pessimistic
  13. Generate the Scenario Summary using C37:C39 as the result cells.
  14. Move the Scenario Summary sheet after the Income Statement and apply professional formatting to all of this data using the image below as a guide.

    Step 5: Create Pivot Tables From Warming Hut Data

    Select the Warming Hut Sales Worksheet. You notice the data are not formatted or organized well.
  15. Use the Warming Hut Sales data to build Pivot Tables.
  16. Build the first Pivot Table to summarize total sales by category and by location. Name this sheet Pivot Table 1.
  17. Build the second Pivot Table to summarize total sales by category and by season for only the Summit View location. Name this sheet Pivot Table 2.
  18. Build the third Pivot Table to summarize total sales by month and by product for only the Mogul Hill location. Name this sheet Pivot Table 3.
  19. Choose one of the created Pivot Tables and add a professional chart to the same worksheet. Make sure you explain the chart and what it shows in your Documentation sheet.
  20. Apply professional formatting to all of this data using the image below as a guide.

    Step 6: Create a Documentation Sheet

    Clean up the formatting of your Excel workbook, taking into account professional appearance.

    Insert a new spreadsheet into the workbook. The documentation sheet should be the first sheet in the workbook.
  21. Make certain all contents of the workbook are properly noted on the documentation sheet. For the sheet with chart, add an explanation of the chart you selected and what this chart shows.
  22. Make certain each tab has a descriptive name for each tab (sheet) in the workbook.
  23. Create the professional documentation worksheet. Be sure to include a description of each worksheet. An image is provided below.

    Finish and Submit

    Save your Excel file. Make sure you are aware as to where your files are physically saved. Saving your file often is good practice (Ctrl + s).
    Your Excel file should contain seven worksheets.
  24. Documentation Page
  25. Income Statement
  26. Scenario Summary
  27. WarmingHutSales
  28. Pivot Table 1
  29. Pivot Table 2
  30. Pivot Table 3

Unformatted Attachment Preview

Summit Ridge Mountain Resort One Variable Data T Income Statement Current Year Assumptions Quantity of Condo Rental days Price for Condo Rental Quantity of Ski Lift tickets Price for Ski Lift tickets Quantity of X Games tickets 300 1015 4430 83 275 Price for X Games tickets 799 Revenues Condo Rental revenue Ski Lift revenue Ski Resort Restaurant revenue Ski Resort Retail revenue Winter X Games revenue Other revenue Effect of Varying Number of C Commissions Depreciation Insurance Interest Expense IT consultants Maintenance and repairs Payroll Office supplies Utilities One Variable Data T Effect of Varying Number of S Revenue Net Income 437856.93 342721.49 Question ======> If management has a target n ski tickets o Response ======> Type your response here 79516.89 Total Revenues Expenses Advertising Revenue Net Income 125000 32832 86750 85000 69750 150000 142000 790645 15000 76855 Two Variable Data T cell needs a formula Total Expenses Summary Total Revenue Total Expenses Net Income Question ======> Response ======> If management has a targ quantity of X Games Tic Type your response here One Variable Data Table - Condo Rental Days Effect of Varying Number of Condo Rental Days on Revenue and Net Income Initial Values 250 275 300 325 350 375 400 5000 5250 5500 5750 Net Income One Variable Data Table - Ski Lift Tickets Effect of Varying Number of Ski Lift Tickets on Revenue and Net Income Initial Values 4250 4500 4750 Net Income If management has a target net income of at least $250,000 which of the above SPECIFIC scenarios in the condo rentals OR ski tickets one variable data table would you recommend using? Explain your reasoning. Type your response here Two Variable Data Table - X Games Tickets & Price Effect of Varying Price for X Games Tickets on Revenue and Net Income ====> 200 225 250 275 799 849 899 949 999 1049 1099 300 325 If management has a target net income of at least $250,000 which of the above SPECIFIC combinations of price and quantity of X Games Tickets in the two variable data table would you recommend using? Explain your reasoning. Type your response here 350 Summit Ridge Ski Lodge - Warming Hut Monthly Sales Revenue Location Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Category Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Month January January January January January January January February February February February February February February March March March March March March March April April April April April April April May May May May May May May June June June June June June June July Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Bunny Den Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Miscellaneous Food Food Food Food Food Drinks - non-alcoholic July July July July July July August August August August August August August September September September September September September September October October October October October October October November November November November November November November December December December December December December December January January January January January January Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food January January February February February February February February February February March March March March March March March March April April April April April April April April May May May May May May May May June June June June June June June June July July July July July Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Mogul Hill Summit View Summit View Summit View Summit View Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food July July July August August August August August August August August September September September September September September September September October October October October October October October October November November November November November November November November December December December December December December December December January January January January Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food January January January January February February February February February February February February March March March March March March March March April April April April April April April April May May May May May May May May June June June June June June June June July July July Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Summit View Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Breakfast Brunch Lunch Dinner To Go Snacks Non-Alcohol Beverages Alcohol Beverages Miscellaneous Products Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous Food Food Food Food Food Drinks - non-alcoholic Drinks - Alcohol Miscellaneous July July July July July August August August August August August August August September September September September September September September September October October October October October October October October November November November November November November November November December December December December December December December December Total Sales 1125.56 1158.52 2215.38 3125.13 789.56 1616.23 566.76 1361.92 1401.8 2680.61 955.37 1955.69 1955.64 685.78 1496.99 1540.83 2946.45 4156.42 1050.12 2149.57 751.79 1615.13 1662.43 3178.98 4484.44 1133 2319.21 811.12 1049.84 1080.58 2066.34 2914.89 736.45 1507.49 527.23 671.9 691.57 1322.46 1865.53 471.33 964.79 337.43 564.39 Season Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off 580.92 1110.86 1567.04 395.91 810.43 283.44 541.82 557.68 1066.43 1504.36 380.08 778.01 272.1 567.82 584.45 1117.62 1576.57 398.32 815.35 285.16 664.35 683.81 1307.61 1844.59 466.04 953.96 333.64 890.23 916.3 1752.2 2471.75 624.49 1278.31 447.08 1531.2 1576.04 3013.79 4251.41 1074.12 2198.7 768.97 2987.16 2554.36 4278.19 1618.87 879.1 598.79 Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter 2215.25 545.98 3704.08 3167.41 5304.96 2007.4 1090.08 742.5 2746.91 677.02 4333.77 3705.87 6206.8 2348.66 1275.4 868.72 3213.88 792.11 4810.49 4113.51 6889.55 2607.01 1415.69 964.28 3567.41 879.24 1587.46 1357.46 2273.55 860.31 467.18 318.21 1177.25 290.15 1000.1 855.2 1432.34 542 294.32 200.47 741.66 182.79 420.04 359.18 601.58 227.64 123.62 Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off 84.2 311.5 76.77 452.39 386.84 647.9 245.17 133.13 90.68 335.48 82.69 533.81 456.47 764.53 289.3 157.1 107.01 395.87 97.57 912.82 780.57 1307.34 494.7 268.64 182.98 676.94 166.84 1944.31 1662.61 2784.63 1053.71 572.2 389.75 1441.88 355.37 2819.25 2410.78 4037.72 1527.87 829.69 565.13 2090.73 515.29 3128.56 2789.89 4278.19 5789.13 Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter 569.23 1256.19 4326.19 891.54 3389.26 3189.56 4789.23 6725.89 726.26 1689.23 5836.32 1121.99 3456.74 3698.25 5148.73 7256.78 811.46 1756.21 6174.56 1489.23 3291.11 3214.51 4687.53 6354.12 718.11 1599.23 5369.36 1002.25 1109.09 749.26 1298.23 3219.69 418.78 716.82 4412.72 452.13 534.36 224.36 453.24 1583.23 212.36 412.45 1952.23 212.78 415.12 179.45 354.89 Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off 987.65 369.23 364.25 1654.89 257.69 379.85 789.25 489.23 789.23 354.21 312.58 2457.29 311.21 401.25 847.91 501.26 887.91 471.94 478.53 2671.96 253.19 479.27 978.91 529.23 1102.21 522.12 656.19 2934.31 301.09 1965.31 2489.11 3121.21 4856.39 454.59 1154.87 3965.91 795.64 2987.22 3324.12 3978.27 6125.91 672.54 1358.12 4957.89 911.21 Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Off Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Summit Ridge Mountain Resort
Income Statement
Author
Date
Purpose
Analysis
Components
Income Statement
Scenario Summary

Warming Hut Sales
Pivot Table 1
Pivot Table 2
Pivote Table 3

Summit Ridge Mountain Resort
Income Statement
Student Name
Wednesday, February 7, 2018
To analyze sales to determie the best combinations for desired income.
The chart shows the sales by category and total sale by location.
Contains the income statement, Onde data variable table and two data variable table.
This helps in the analysis on the best combinations.
Contains the optimistic, Mid-range and pessimistic values of total revenue, total
expenses and net income.
Conrtains data for monthly sales revenue by season, category, product and location.
Contains Pivot table that summarizes the total sales by category and location
Contains the pivot table that summarizes the total sales by category and by season for
the summit view location.
Contains pivot table that summarizes the total sales by month and by product for the
Mogul hill location.

Summit Ridge Mountain Resort
One Variable Data

Income Statement
Current Year
Assumptions
Quantity of Condo Rental days
Price for Condo Rental
Quantity of Ski Lift tickets
Price for Ski Lift tickets
Quantity of X Games tickets
Price for X Games tickets

Effect of Varying Number of
$
$
$

300
1,015
4,430
83
275

One Variable Data

799

Revenues
Condo Rental revenue
Ski Lift revenue
Ski Resort Restaurant revenue
Ski Resort Retail revenue
Winter X Games revenue
Other revenue

$
$
$
$
$
$

304,500
367,690
437,857
342,721
219,725
79,517

Total Revenues

$

1,752,010

Expenses
Advertising

$

125,000

$
$
$
$
$
$
$
$
$

32,832
86,750
85,000
69,750
150,000
142,000
790,645
15,000
76,855

Total Expenses

$

1,573,832

Summary
Total Revenue
Total Expenses
Net Income

$
$
$

1,752,010
1,573,832
178,178

Commissions
Depreciation
Insurance
Interest Expense
IT consultants
Maintenance and repairs
Payroll
Office supplies
Utilities

Revenue
Net Income

Effect of Varying Number of
Revenue
Net Income
Question ======>

If management has a target
Games Ticket

Response ======>

I would prefer a scenario wh
required an increase in sales
$250,000 is achieved.

Two Variable Data
cell needs a formula

Question ======>

If management has a target
Games Ticket

Response ======>

I will stick to 350 X games tic
Therefore I would be able to
become easy to sell the ticke

One Variable Data Table - Condo Rental Days
Effect of Varying Number of Condo Rental Days on Revenue and Net Income
Initial Values
250
275
300
325
350
375
$ 1,752,010 $1,701,260 $1,701,260 $1,752,010 $1,777,385 $1,802,760 $1,828,135
Net Income
$
178,178
$127,428
$152,803
$178,178
$203,553
$228,928
$254,303

One Variable Data Table - Ski Lift Tickets
Effect of Varying Number of Ski Lift Tickets on Revenue and Net Income
Initial Values
4250
4500
4750
5000
5250
5500
$ 1,752,010 $1,737,070 $1,757,820 $1,778,570 $1,799,320 $1,820,070 $1,840,820
Net Income
$
178,178
$163,238
$183,988
$204,738
$225,488
$246,238
$266,988
If management has a target net income of at least $250,000 which of the above SPECIFIC combinations of price and quantity of X
Games Tickets in the two variable data table would you recommend using? Explain your reasoning.
I would prefer a scenario where 5,500 ski lift tickets are sold. This is because to achieve a net income more than $250,000 will
required an increase in sales of the tickets. Varying the Rental days on the other side will exeed a year before the net income of
$250,000 is achieved.

Two Variable Data Table - X Games Tickets & Price
Effect of Varying Price for X Games Tickets on Revenue and Net Income
====> $
178,178
200
225
250
275
799 $118,253
$138,228
$158,203
$178,178
849
$28,253
$149,478
$170,703
$191,928
899 $138,253
$160,728
$183,203
$205,678
949 $148,253
$171,978
$195,703
$219,428
999 $158,253
$183,228
$208,203
$233,178
1049 $168,253
$194,478
$220,703
$246,928
1099 $178,253
$205,728
$233,203
$260,678

300
$198,153
$213,153
$118,253
$243,153
$258,153
$273,153
$258,153

325
$218,128
$234,378
$250,628
$266,878
$283,128
$299,378
$315,628

If management has a target net income of at least $250,000 which of the above SPECIFIC combinations of price and quantity of X
Games Tickets in the two variable data table would you recommend using? Explain your reasoning.
I will stick to 350 X games ticket at a price of 899. This is becase the price of the ticket would not be too much for the buyers.
Therefore I would be able to sell more tickets at a lower price and a minimum net income of $250,000. This is because it will
become easy to sell the tickets at an average price than to sell at higher price.

400
$1,853,510
$279,678

5750
$1,861,570
$287,738

of price and quantity of X
easoning.

re than $250,000 will
fore the net income of

350
$238,103
$255,603
$273,103
$290,603
$308,103
$325,603
$343,103

of price and quantity of X
easoning.

much for the buyers.
his is because it will

Scenario summary
Current value:

Optimistic

Mid-r...

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

MGT 322 SEU Logistics Management Supply Chain Management Questions
...
RTSUNJNBP Sustainability Coca Cola Discussion
1. Is Sustainability a company strategy, aligned, or just an afterthought at Coca-Cola? Is management committed? Please e...
Ashford University Gracism Rather than Racism Replies
**Original Discussion Thread** Discussion Thread: Gracism For the last several weeks, you read through Gracism by David An...
"Looking Forward", law homework help
"Looking Forward" Please respond to the following:Imagine yourself as an employee in the criminal justice field. Dete...
United Arab Emirates University Descriptive Statistics SPSS Task
attached is my research proposal, the questionnaire, the results received from questionnaire. I need SPSS help to do the f...
Westcliff University Comprehensive Learning Assessment Presentation
1. Provide general discussion on predeterminedvariable overhead criterion and its possible dependence on the activity for ...
Information technology management class lectures_81689597-Information-Technology
uploads/services/161584/Information technology management class lectures_81689597-Information-Technology.pdf...
Knowledge management class lectures_238349259-Java-lectures-1-11
uploads/services/161584/Knowledge management class lectures_238349259-Java-lectures-1-11.pdf...
MOTIVATION AS A TOOL FOR EFFECTIVE STAFF PRODUCTIVITY IN THE PUBLIC & PRIVATE ORGANIZATION
Introduction: Motivation is a kind of force which energizes people to achieve some common goals. Every organization eithe...

Related Tags

albany technical Summary accountant "J.D Salinger" "J.D Salinger" Income Statement excel excel math financial analysis homework excel excel