Chapter 9 Solutions Manual Content
9-1
Chapter 9: Applying Excel
The completed worksheet is shown below.
Chapter 9 Solutions Manual Content
9-2
Chapter 9: Applying Excel (continued)
The completed worksheet, with formulas displayed, is shown below.
Chapter 9 Solutions Manual Content
9-3
Chapter 9: Applying Excel (continued)
1. With the changes in data, the result is:
Chapter 9 Solutions Manual Content
9-4
a. The activity variance for revenue is $1,600 U. This variance is the
difference between the revenue under the planning budget and under
Chapter 9 Solutions Manual Content
9-5
Chapter 9: Applying Excel (continued)
2. With the revised data, the worksheet should look like this:
Actual activity exceeded planned activity by 100 meals served, which