Use excel in completing the following The candy making department at MyChocoCrush Company provides you with the following information for October. All direct materials are placed in process at the beginning of production. The facts are: Amount Beginning Work in Process 5,000 units (50% Completed) $40,000 Purchases of Direct materials for the month 312,000 unit $1,000,000 Direct labor Costs incured $200,000 Factory Overhead Allocated $100,000 Units Completed (and transferred out) this month 305,000 units Ending Work in Process Unfinished units are 20% complete REQUIRED: Use the weighted average process cost method to identify and classify the costs below: HINT: Prepare a Production Cost Report first! 1. Determine the number of units of work in process inventory at the end of the month. 2. Determine the equivalent units of productions for direct materials and conversion costs. 3. Determine direct materials cost per equivalent unit 4. Determine conversion cost per equivalent unit 5. Cost of beginning work in process completed during October 6. Cost of units started and completed during October 7. Cost of ending work in process