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.

The cost data for September are as follows:

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.
1. Cost of goods completed and transferred out of the Weaving Department.
2. Cost of the September 30 work-in-process inventory in the Weaving Department.
3. 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.

Transcribed Image Text:

Equivalent units of direct material (weighted-average method) Equivalent units of conversion (weighted-average method) Units completed and transferred out during September 60,000 52,000 50,000