ACC 3020 - Fall 2017
Excel Case #1 - Process Costing
Consider the following information from Vesper Company, then see the instructions that
follow.
Vesper Company manufactures wooden baseball bats. Materials are added at the beginning
of the production process and conversion costs are incurred uniformly. Production and cost
data for the month of April, 2016 are as follows.
	Production data				Units		Percent Complete
	Work in process units, April 1				2,600		55%
	Units started into production				6,220
	Work in process units, April 30				2,950		38%
	Cost data
	Work in process, April 1
	Materials			$7,450
	Coversion costs			5,850	$13,300
	Direct materials				24,200
	Direct labor				15,850
	Manufacturing overhead				12,750
Instructions:
Prepare a production cost report for the month of April, 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 April.
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.