Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Chapter 4 Solutions Manual Content
4-1
Chapter 4: Applying Excel
The completed worksheet is shown below.
Chapter 4 Solutions Manual Content
4-2
Chapter 4: Applying Excel (continued)
The completed worksheet, with formulas displayed, is shown below.
Chapter 4 Solutions Manual Content
4-3
Chapter 4: Applying Excel (continued)
1. When the units are changed, the worksheet changes as show below:
Chapter 4 Solutions Manual Content
4-4
Chapter 4: Applying Excel (continued)
All of the amounts involving units were cut in half. The units in
Chapter 4 Solutions Manual Content
4-5
Chapter 4: Applying Excel (continued)
2. With all of the changes in the data, the worksheet should look like:
The cost of the units transferred out is $58,330.
Chapter 4 Solutions Manual Content
4-6
Chapter 4: Applying Excel (continued)
3. Changing the percentage completion with respect to conversion for
beginning inventory from 20% to 40% results in:
Chapter 4 Solutions Manual Content
4-7
Chapter 4: Applying Excel (continued)
The cost per equivalent unit for conversion is not affected by the
