Please follow the directions below to creat a production cost report for April. Please try to complete it in an excel spreadsheet so it is easy for me to follow and understand. Try to provide one copy showing formulas and one showing the answers for them. Thank you.

Consider the following information from Vesper Company, then see the instructions that 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. duction d Work in process units, April 1 Units started into Work in process units, April 30 Units rcent Complete 2,600 6,235 3,025 64% 38% Cost data Work in process, April 1 Materials $7,400 Coversion costs Direct materials Direct labor Manufacturing overhead 5,750 $13,150 23,800 15,850 12,750 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