Please be descriptive and show all work/formulas step-by-step. Preferably using Microsoft Excel!

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: 3343% 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