Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Chapter 8 Solutions Manual Content
8-1
Chapter 8: Applying Excel
The completed worksheet is shown below.
Chapter 8 Solutions Manual Content
8-2
Chapter 8: Applying Excel (continued)
The completed worksheet, with formulas displayed, is shown below.
Chapter 8 Solutions Manual Content
8-3
Chapter 8: Applying Excel (continued)
1. When the budgeted unit sales in the second quarter are increased from
60,000 units to 75,000 units, the result is:
Chapter 8 Solutions Manual Content
8-4
Chapter 8: Applying Excel (continued)
Chapter 8 Solutions Manual Content
8-5
Chapter 8: Applying Excel (continued)
2. With the revised sales budget, the worksheet should look like this:
Chapter 8 Solutions Manual Content
8-6
Chapter 8: Applying Excel (continued)
a. The total expected cash collections for the year under this revised
budget are $2,165,000.
