please do all parts to this one question and do it in excel not hand written thanks

Required information Howard Co., a manufacturing firm, utilizes a process manufacturing system. During April, the first production department of Howard Co. completed its work on 395,000 units of a product and transferred them to the next department of these transferred units, 79,000 were in process in the production department at the beginning of April and 316,000 were started and completed in April. April's beginning inventory units were 80% complete with respect to materials and 20% complete with respect to conversion. At the end of April, 101,000 additional units were in process in the production department and were 85% complete with respect to materials and 35% complete with respect to conversion The production department of Hodge Co. had $1,336.480 of direct materials and $970,047 of conversion costs charged to it during April. Also, Its April beginning inventory of $270,083 consists of $250,325 of direct materials cost and $19,758 of conversion costs. 1. Compute the direct materials cost per equivalent unit for April. (Round "Cost per EUP" to 2 decimal places.) 2. Compute the conversion cost per equivalent unit for April (Round "Cost per EUP" to 2 decimal places.) 3. Using the weighted average method, assign April's costs to the department's output-specifically, its units transferred to the next department and its ending work in process inventory. (Round "Cost per EUP" to 2 decimal places.) Required 1. and 2 Equivalent Units of Production (EUP)-Welghted Average Method Units % Materials EUP-Materials % Conversion EUP-Conversion Equivalent units of production Cost per Equivalent Unit of Production Materials Conversion Costs Costs Total costs - Equivalent units of production Cost per equivalent unit of production (rounded to 2 decimals) Total Costs to Account for: EUP EUP 0 0 $ 0.00 Total costs to account for: Total costs accounted for Difference due to rounding costunit $ 0.00 EUP Cost per EUP Total cost + Required 3. Cost Assignment and Reconciliation Cost of units transferred out Direct materials Conversion Total costs transferred out Costs of ending work in process Direct materials Conversion Total cost of ending work in process Total costs accounted for EUP Cost per EUP Total cost $ 0.00 $ 0.00 $ 0.00 0.00