What-If Analysis, Charting, And Working With Large Worksheets Page 87
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 223
During the meeting, one manager lobbied to reduce marketing expenditures by 1.25% and
payroll costs by 2.75%. Perform a what-if analysis refl ecting the proposed changes in expenditures.
The changes should result in an operating income of $22,425,581 for the year. Using the original
assumptions shown in Table 3– 20, another manager asked to what extent marketing would have to
be reduced to generate an annual operating income of $21,000,000. Marketing would to be reduced
from 13.50% by 1.92% to 11.58%.
Submit the workbook and results of the what-if analysis as specifi ed by your instructor.
Table 3 – 20 Notable Website Design Operating Income Projection by Quarter
Revenues
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Site Design
12,247,999
15,234,813
16,567,102
10,619,201
Web Hosting
1,678,153
5,901,988
4,718,231
1,569,378
Expenditures
Administrative
10.50%
Bonus
250,000.00
Equipment
17.75%
Marketing
13.50%
Payroll
22.50%
Production
6.30%
Revenue for Bonus
14,000,000.00
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education