Process costing

Mirvac Company Processes and packages cream cheese. The following data have been complied for the month of April. Conversion activity occurs uniformly throughout the process.

Work in process, April 1-10,000 units

Direct Material: 100% complete, cost of ……………………………………$	22,000
Conversion: 20% complete, cost of ………………………………………….	4500
Balance in work in process, April 1 ………………………………………….	26,500
Units started during April 1 ………………………………………………………….	100,000
Units completed during April and transferred out to finished goods inventory………Work in process, April 30: Direct materials 100% complete Conversion 33⅓% complete Costs incurred during April:	80,000
Direct material ……………………………………………………………………….	$198,000
Conversion costs:Direct labour…………………………………………………………………. $              Applied manufacturing overhead……………………………………………… Total conversion costs…………………………………………………………	52,800105,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. (10 Marks)

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 and 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 $18000 for conversion. (5 Marks)