Assignment
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.
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
|
Production data
|
Units
|
Percent Complete
|
|
Work in process units, April 1
|
2,375
|
58%
|
|
Units started into production
|
6,250
|
|
|
Work in process units, April 30
|
3,040
|
39%
|
|
Cost data
|
|
|
|
Work in process, April 1
|
|
|
|
Materials
|
$7,600
|
|
|
Conversion costs
|
6,200
|
$13,800
|
|
Direct materials
|
|
23,900
|
|
Direct labor
|
|
15,850
|
|
Manufacturing overhead
|
|
12,750
|