Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions