Microsoft Office Tutorials and References
In Depth Information
In the Lab
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 profi 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
your instructor.
2. Use the What-If
Analysis button
on the Data tab
on the Ribbon
to goal seek.
Determine a
planned indirect
Administrative
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
Case 1
Case 2
Administrative
234000
210000
Depreciation
123500
152000
Energy
67750
48000
Insurance
26200
53000
Maintenance
42000
38000
Marketing
57000
72500
 
Search JabSto ::




Custom Search