ACC 3020 - Fall 2017 Excel Case #1 - Process Costing Enter your WSU Access ID below. Access ID: 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 Enter your Access ID Units started into production in cell B2 above for Work in process units, April 30 values to appear. Cost data Work in process, April 1 Materials Coversion costs $0 Direct materials Direct labor Manufacturing overhead 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.

ACC 3020 - Fall 2017 Excel Case #1 - Process Costing Enter your WSU Access ID below. Access ID: 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 Work in process units, April 1 Units started into production Work in process units, April 30 Cost data Work in process, April 1 Materials Coversion costs Direct materials Direct labor Manufacturing overhead Units Percent Complete Enter your Access ID in cell B2 above for values to appear. $0 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