Complete problem 4-29 in Excel. Please note, you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail.

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. Required: 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 nished-goods inventory Work in process, April 30: Direct material: 100% complete Conversion: 331/396 complete Costs incurred during April: Direct material Conversion costs: Direct labor Applied manufacturing overhead Total conversion costs of April. Use the weighted-average method of process costing. 1. 2 3. 4 5 Analysis of physical ow of units. Calculation of equivalent units. Computation of unit costs. Analysis of total costs. $ 22,000 4,500 is 26,500 1 00,000 80,000 Prepare schedules to accomplish each of the following process-costing steps for the month 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-inprocess costs were $66,000 for direct material and $18,000 for conversion. I Problem 4-29 Straightforward Weighted Average Process Costing; Step-byStep Approach (L0 4-3, 4-4, 4-5) 2. Equivalent units, direct material: 110,000