Production Cost Accounting: Weighted Average Method
Maple, Inc. manufactures syrup that goes through three processing stages prior to completion. Information on work in the first department, blending, is given below for August:
|Pounds in process, August 1; materials 100% complete; conversion 70% complete||3,000|
|Pounds started into production during August||85,000|
|Pounds completed and transferred out||?|
|Pounds in process, August 31; materials 80% complete; conversion 30% complete||6,000|
|Work in process inventory, August 1:
|Cost added during May:
The company uses the weighted-average method.
Submit an Excel document, with each tab labeled by item number, which demonstrates the following:
- Compute the equivalent units of production.
- Compute the costs per equivalent unit for the month.
- Determine the cost of ending work in process inventory and of the units transferred out to the next department.
- Prepare a cost reconciliation schedule for the month.
Provide your answers in a clearly organized Excel spreadsheet. Check spelling and formatting for readability. Document your sources. Where applicable, written comments must be in accordance with the CSU-Global Guide to Writing and APA Requirements Be sure to review the Module 3 Critical Thinking grading rubric, which may be accessed through the Course Information page.