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.

1. 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.
2. Apply conditional formatting to highlight Net Income of at least $250,000 for each of the two-variable data table.
3. 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."
4. Make sure you place your answer in the text box beginning in cell G40.
5. Apply professional formatting to all of this data using the image below as a guide.

Here is the income statement.

Summit Ridge Mountain Resort
Income Statement
		Current Year
Assumptions
	Quantity of Condo Rental days	300
	Price for Condo Rental	$ 1,015
	Quantity of Ski Lift tickets	4430
	Price for Ski Lift tickets	$ 83
	Quantity of X Games tickets	275
	Price for X Games tickets	$ 799
Revenues
	Condo Rental revenue	$ 304,500
	Ski Lift revenue	$ 367,690
	Ski Resort Restaurant revenue	$ 437,857
	Ski Resort Retail revenue	$ 342,721
	Winter X Games revenue	$ 219,725
	Other revenue	$ 79,517
Total Revenues		$ 1,752,010
Expenses
	Advertising	$ 125,000
	Commissions	$ 32,832
	Depreciation	$ 86,750
	Insurance	$ 85,000
	Interest Expense	$ 69,750
	IT consultants	$ 150,000
	Maintenance and repairs	$ 142,000
	Payroll	$ 790,645
	Office supplies	$ 15,000
	Utilities	$ 76,855
Total Expenses		$ 1,573,832
Summary
	Total Revenue	$ 1,752,010
	Total Expenses	$ 1,573,832
	Net Income	$ 178,178

Thank you so much. Please include step by step formula explaination too.