Please show formulas using excel
Build a spreadsheet: Construct an Excel spreadsheet to solve allof the preceding requirements. Show how the solution will change ifthe following data change: the April 1 work-in-process costs were$66,000 for direct material and $18,000 for conversion.
Work in process, April 1—10,000 units: Direct material: 100%complete, cost of.........................................................................................................$22,000
Conversion: 20% complete, cost of.................................................................................................................4,500
Balance in work in process, April 1..................................................................................................................$?26,500
Units started during April......................................................................................................................................100,000
Units completed during April and transferred out tofinished-goods inventory.................................................80,000
Work in process, April 30:
Direct material: 100% complete
Conversion: 33 1 ? 3 % complete
Costs incurred during April:
Direct material..................................................................................................................................................$?198,000
Conversion costs: Direct labor...................................................................................................................................................$52,800
Applied manufacturing overhead................................................................................................................105,600
Total conversion costs.................................................................................................................................$158,400
