production data maple inc 424562

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:

The company uses the weighted average method.

Submit an Excel document, which each tab labeled by item number in good form that demonstrates the following:

1. Compute the equivalent units of production.
2. Compute the costs per equivalent unit for the month.
3. Determine the cost of ending work in process inventory and of the units transferred out to the next department.
4. Prepare a cost reconciliation schedule for the month.