A Excel problem

Description

Solve Problem 20-2A, parts 1 and 2 (see PR 20-2A instructions attached). Use the template provided (see attachment). Submit only your template with your completed exercise.

Don't use plagiarized sources. Get Your Custom Assignment on
A Excel problem
From as Little as $13/Page

Unformatted Attachment Preview

Problem 20-2A
Name:
Section:
Score: 0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
ROBUSTA COFFEE COMPANY
Cost of Production Report – Roasting Department
For the Month Ended March 31, 2012
UNITS
Equivalent Units
Whole Units
Direct Materials
Conversion
Direct Materials
Costs
Conversion
Total
Units charged to production:
Inventory in process, March 1
Received from materials storeroom
Total units accounted for by the Roasting Department
Units to be assigned cost:
Inventory in process, March 1 (
Started and completed in March
Transferred to Packing Department in March
Inventory in process, March 31 (
Total units to be assigned cost
complete)
complete)
COSTS
Costs per equivalent unit:
Total costs for March in Roasting Department
Total equivalent units
Cost per equivalent unit
Costs assigned to production:
Inventory in process, March 1


Costs incurred in March
Total costs accounted for by the Roasting Department
Costs allocated to completed and partially completed units:
Inventory in process, March 1
To complete inventory in process, March 1
Cost of completed March 1 work in process
Started and completed in March
Transferred to Packing Department in March
Inventory in process, March 31
Total costs assigned by the Roasting Department
2.
March 1, work in process
Less direct materials
Conversion costs
Conversion cost equivalent units:
Units in process
Percent complete
Equivalent units
Direct Materials
March costs per equivalent unit
February costs per equivalent unit:
Total costs for March in Roasting Department
Total equivalent units
Cost per equivalent unit
Increase (decrease)

Conversion

Purchase answer to see full
attachment