Question
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
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 110,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 to finished-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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started