Question: I need help (with #5, Build spreadsheet) the excel portion of my homework, Moravia Company, Problem 4-29 from the Managerial Accounting 11th ed. My homework

 I need help (with #5, Build spreadsheet) the excel portion of

I need help (with #5, Build spreadsheet) the excel portion of my homework, Moravia Company, Problem 4-29 from the Managerial Accounting 11th ed. My homework is due tonight but would like to see the excel by this afternoon at 5pm is possible.

Thank you

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 4500 $26.500 100.000 80.000 Work in process. Apr 1-10,000 unts: Direct material 100% complete, cost of Conversion 20% complete, cost of Balance in work in process, April 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 33% 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 I work-in-process costs were $66,000 for direct material and S18.000 for conversion

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!