Question

Consider the following information from Manufacturing Inc., then see the instructions that
follow.
Manufacturing Inc. manufactures plastic thing-a-majigs. Materials are added at the beginning
of the production process and conversion costs are incurred uniformly. Production and cost
data for the month of June, 2016 are as follows.
	Production data				Units		Percent Complete
	Work in process units, June 1				2,600		61%
	Units started into production				6,285
	Work in process units, June 30				3,000		38%
	Cost data
	Work in process, June 1
	Materials			$7,250
	Coversion costs			6,050	$13,300
	Direct materials				23,600
	Direct labor				15,850
	Manufacturing overhead				12,750
Instructions:
Prepare a production cost report for the month of June, making sure to show equivalent
units of production for materials and conversion costs, unit costs of production for materials
and conversion costs, and the assignment of costs to units transferred out and in process at
the end of June. I HAVE THE LAYOUT POSTED BUT JUST NEED THE NUMBERS FILLED IN!!!
THIS ASSIGNMENT MUST BE COMPLETED IN EXCEL. You should develop an efficient and
customizable production cost report, using formulas whenever possible instead of keyed in values. No numeric values except the ones shown above should need to be keyed in. I HAVE THE LAYOUT POsTED UNDERNEATH AND JUST NEED THE NUMBERS FILLED IN!!!! MANUFACTORING INC. Production Cost Report For the Month Ended June 30, 2016 Equivalent Units Physical Units Materials Conversion Costs Quantities Units to be accounted for Work in process, June 1 Started units into production Total Units Units accounted for Transferred out Work in process, June 30 Toal Units Costs Unit Costs Materials Conversion Cost Total Total cost Equivalent units Unit cost [(a) / (b)] Costs to be accounted for Work in process, June 1 Started into production Total costs Cost Reconciliation Schedule Costs accounted for Tranferred out Work in process, June 30 Materials Conversion costs Total costs

Answer 1

Production Cost Report is as prepared below:

MANUFACTORING INC.
Production Cost Report
For the Month Ended June 30, 2016
		Equivalent Units
	Physical Units	Materials	Conversion Costs
Quantities
Units to be accounted for
Work in process, June 1	2,600
Started units into production	6,285
Total Units	8,885
Units accounted for
Transferred out	5,885	5,885	5,885
Work in process, June 30	3,000	3,000	1140
Total Units	8,885	8,885	7,025
Costs
Unit Costs	Materials	Conversion Cost	Total
Total cost	23,600	28600	52,200
Equivalent units	8,885	7,025
Unit cost [(a) / (b)]	2.66	4.07
Costs to be accounted for
Work in process, June 1	7,250	6,050	13,300
Started into production	23,600	28600	52,200
Total costs	30,850	34,650	65,500
Cost Reconciliation Schedule
Costs accounted for
Transferred out	15,632	23,959	39,590
Work in process, June 30	7,968	4,641	12,610
Materials			7,250
Conversion costs			6,050
Total costs			65,500