What-If Analysis, Charting, And Working With Large Worksheets Page 81
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 217
Instructions Part 3: Start Excel. Open Lab 3-2 ReachOut Neighbor Analysis of Indirect Expenses.
1. Using the numbers in Table 3– 12, analyze the effect of changing the planned indirect expenses in
the range B18:B23 on the net incomes for each branch offi ce. You should end with the following
totals in cell I15: Case 1 = $5,846.00 and Case 2 = $124,346.00. Submit the workbook or results
for each case as requested by your instructor.
2. Use the What-If Analysis button (Data tab | Data Tools group) to goal seek. Determine a planned
indirect Marketing expense (cell B23) that would result in a total net income of $50,000 (cell I15).
You should end up with a planned indirect Marketing expense of $225,586 in cell B23. Submit the
workbook with the new values or the results of the goal seek as specifi ed by your instructor.
Table 3 – 12 ReachOut Neighbor Indirect Expense Allocations What-If Data
Case 1
Case 2
Administrative
124000
66500
Depreciation
156575
75000
Energy
72525
56000
Insurance
46300
67000
Maintenance
75000
48000
Marketing
39000
82400
In the Lab
Lab 3: Modifying a Weekly Inventory Worksheet
Problem: As a summer intern at Dinah’s Candle Depot, you have been asked to modify the weekly
inventory report shown in Figure 3–91a on the following page. The workbook, Lab 3-3 Dinah’s Weekly
Inventory Report, is included with the Data Files for Students. See the inside back cover of this book
for instructions for downloading the Data Files for Students, or see your instructor for information on
accessing the fi les required for this book.
The major modifi cations to the payroll report to be made in this exercise include: (1) reformatting
the worksheet; (2) adding computations of quantity to order based on reorder level and weeks to arrive;
(3) adding calculations to suggest changes in ordering; (4) adding current and last month sales for
inventory items; (5) adding and deleting inventory items; and (6) changing inventory item information.
The fi nal inventory report is shown in Figure 3–91b on the following page.
Continued >
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education