Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the...

70.2K

Verified Solution

Question

Accounting

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

Answer & Explanation Solved by verified expert

4.5 Ratings (913 Votes)

If opening WIP cost changesFormulas SHeetUnits Charged to production Inventory in Progress April 1Received from materials storeroom Total units accounted for 10000100000 110000 Units to be assigned costs Inventory inProgress April 1 Started and completed in April Transferred toDepartment in April Inventory in process April 30 Total units tobe assigned costs Equivalent Units Whole units Direct MaterialsConversion 10000 0 8000 70000 70000 70000 80000 See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member