Please show formulas using excel
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.
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...