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. PREPARE AS A PRODUCTION COST REPORT!!!!!
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.

Answer 1

	Beggining units	2600	Transferred out	5,885
	Started into production	6285	Ending units	3,000			Cost of goods sold	Material	convertion cost
		8885		8885			Beginning inventory completed
							Completion	0%	39%
	Equivalent units	Material	Conversion				Per unit cost	3.75	5.26
	Beginning units	2600	2600				Units	2600	2600
	Completion in current period	0%	39%				Total cost   A	0.00	5332	5332
	A	0	1014
							Units started and completed
	Units started and completed	3285	3285				Completion	100%	100%
	Completion	100%	100%				Per unit cost	3.75	5.26
	B	3285	3285				Units	3285	3285
							Total cost    B	12335	17274	29609
	Ending Units	3,000	3,000
	Completion	100%	38%				Beginning work in progress C	7250	6050	13300
	C	3000	1140
	Total units A+B+C	6285	5439				Total cost A+B+C			48241
							Ending work in progress
	Cost per equivalent units						Completion	100%	38%
	Per unit cost	Cost	Total units	Per unit cost			Per unit cost	3.75	5.26
	Material cost	23600	6285	3.75			Units	3,000	3,000
	Conversion cost	28600	5439	5.26			Total cost	11265	5994	17259
	Total	52200		9.01				Total cost accounted for		65500