Moravia Company processes and packages cream cheese. The following data have been compiled for the month of April. Conversion activity occurs uniformly throughout the production process.

Work in process, April 1?10,000 units:

Direct material: 100% complete, cost of .........................................................................................................$ 22,000

Conversion: 20% complete, cost of .................................................................................................................4,500

Balance in work in process, April 1 ..................................................................................................................$ 26,500

Units started during April ......................................................................................................................................100,000

Units completed during April and transferred out to finished-goods inventory .................................................80,000

Work in process, April 30:

Direct material: 100% complete

Conversion: 33 1 ? 3 % complete

Costs incurred during April:

Direct material ..................................................................................................................................................$?198,000

Conversion costs:

Direct labor ...................................................................................................................................................$ 52,800

Applied manufacturing overhead ................................................................................................................105,600

Total conversion costs .................................................................................................................................$158,400

Required:

Prepare schedules to accomplish each of the following process-costing steps for the month of April. Use the weighted-average method of process costing.

1. Analysis of physical flow of units.

2. Calculation of equivalent units.

3. Computation of unit costs.

4. Analysis of total costs.

5. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion.

Student Assignment | LCS Learnir X | G how to do screen shot on desk to X managerial_accounting_creating_ x Student Portal | Online Financial X | |Homework Help - Q&A from On x + X C viewer.gcu.edu/mqBcBY D + % 1 X 191 of 848 Q B + 0 Moravia Company processes and packages cream cheese. The following data have been compiled for the Problem 4-29 month of April. Conversion activity occurs uniformly throughout the production process. Straightforward Weighted- Average Process Costing; Step-by-Step Approach Work in process, April 1-10,000 units: (LO 4-3, 4-4, 4-5) Direct material: 100% complete, cost of $ 22,000 Conversion: 20% complete, cost of 4,500 2. Equivalent units, direct Balance in work in process, April 1 ...... $ 26,500 material: 110,000 Units started during April .... 100,000 Units completed during April and transferred out to finished-goods inventory . 80,000 Work in process, April 30: Direct material: 100% complete Conversion: 331/3% complete Costs incurred during April: Direct material ...... $ 198,000 Conversion costs: Direct labor .... $ 52,800 Applied manufacturing overhead . 105,600 Total conversion costs $158,400 Required: Prepare schedules to accomplish each of the following process-costing steps for the month of April. Use the weighted-average method of process costing. 1. Analysis of physical flow of units. 2. Calculation of equivalent units. 3. Computation of unit costs. Activate Windows C G 4. Analysis of total costs. Go to Settings to activate Windows