Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this should be in excel spread sheet showing calculation in the cells. Moravia Company processes and packages cream cheese. The following data have been compiled

this should be in excel spread sheet showing calculation in the cells.

image text in transcribed

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. $ 22,000 4,500 $ 26,500 100,000 80,000 Work in process, April 110,000 units: Direct material: 100% complete, cost of Conversion: 20% complete cost of Balance in work in process, April 1 Units started during April Units completed during April and transferred out to finished goods Inventory Work in process, April 30: Direct material: 100% complete Conversion: 33V5% complete Costs incurred during April Direct material Conversion costs: Direct labor Applied manufacturing overhead Total conversion costs $198.000 $ 52,800 105,600 $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

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

The Audit Process Principles Practice And Cases

Authors: Stuart Manson, Iain Gray, Louise Crawford

6th Edition

1408081709, 978-1408081709

Students also viewed these Accounting questions

Question

In Problems 89112, solve each equation. ln e x = 5

Answered: 1 week ago

Question

What is the difference between the truss and frame?

Answered: 1 week ago