Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Excel 4-29

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.

in process, April 110,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 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For Undergraduates

Authors: Wallace

4th Edition

1618533088, 9781618533081

More Books

Students also viewed these Accounting questions

Question

=+ Is the information source free from bias on the subject?

Answered: 1 week ago

Question

=+ Is the information source knowledgeable about the subject?

Answered: 1 week ago

Question

=+2. How will it be used?

Answered: 1 week ago