Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
In the Lab continued
Instructions Part 3: Start Excel. Open Lab 3-3 RockieView Resort and Spa Indirect Expenses Allocations.
1. Using the numbers in Table 3–15, analyze the effect of changing the planned indirect expenses in
the range B18:B23 on the net incomes for each proﬁ t center. You should end with the following
totals in cell J15: Case 1 = $892,684.00 and Case 2 = $869,634.00. Submit the workbook or results
for each case
as requested by
2. Use the What-If
on the Data tab
on the Ribbon
to goal seek.
expense (cell B18) that would result in a total net income of $1,200,000 (cell J15). You should end
up with a planned indirect Administrative expense of $50,159 in cell B18. Submit the workbook
with the new values or the results of the goal seek as requested by your instructor.
Table 3–15 RockieView Resort and Spa Indirect Expense Allocations What-If Data