Savannah Textiles Company manufactures a variety of natural fabrics for the clothing industry. The following data pertain to the Weaving Department for the month of September.

Exercise $4-22$

Analysis of Total Costs; Weighted$-$Average $($LO $4-5)$

Equivalent units of direct material $($weighted$-$average method$)$

$60,000$

Equivalent units of conversion $($weighted$-$average method$)$

$52,000$

Units completed and transferred out during September

$50,000$

$8$

Chapter $4$ Process Costing and Hybrid Product$-$Costing Systems

The cost data for September are as follows:

Work in process, September $1$

Direct mat

$100$

Conversior

$100$

Costs incurreo dunng septemoer

Direct ma

$00$

Conversic

$00$

There were $20,000$ units in process in the Weaving Department on September $1(100\%$ complete as to direct material and $40\%$ complete as to conversion$).$

Required:

Compute each of the following amounts using weighted$-$average process costing.

Cost of goods completed and transferred out of the Weaving Department.

Cost of the September $30$ work$-$in$-$process inventory in the Weaving Department.

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 costs incurred in September were $$328,000$ for direct material and $$818,400$ for conversion.