Option #1: 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:

Production Data:
	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
Cost Data:
	Work in process inventory, August 1: Materials cost	$900
	Conversion cost	$5,900
	Cost added during May: Materials cost	$151,000
	Conversion cost	$161,700

The company uses the weighted-average method.

Instructions: Submit an Excel document, with each tab labeled by item number, which 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. Prepareacostreconciliationscheduleforthemonth

Answer: 1 Material=3000+850006000+6000*.8=86800pounds Conversion=3000+850006000+6000*.2=83800pound 2 Conversion=(5900+161700)/83800=2perpound 3 Transferredtonextdepartment=82000*3.75=307500 EndingWorkInProgess=4800*1.75+1800*2=12000 4 CostOpeningWorkInProgress=6800 IncurredDuringmonth=312700 Transferred=307500 ClosingWorkingInProgress=12000 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 Pounds started into production during August Pounds in process, August 31; materials 80% complete; conversion 30% complete Material=(900+151000)/86800=1.75perpound Total cost to account for=319500 Total=319500

How would I put that into Excel?