Please answer using the format below

Consider the following information from Manufacturing Inc, then see the instructions that follow. Manufactuling 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. oduction da Work in process units, June 1 Units started into production Work in process units, June 30 Units rcent Complete 2,525 6,285 3,040 55% 35% Cost data Work in process, June 1 Material:s $7,450 Coversion costs Direct materials Direct labor Manufacturing overhead 6,050$13,500 23,900 15,850 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. 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