A B C D E F G Functions: SUM; Formula: Multiply; Cell Referencing Using Excel to Compute Equivalent Units PROBLEM The Smelting Department of Kiner Company has the following production data for November. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. Use the SUM function with cell references for the totals. Units in beginning work in process Units transferred out Units in ending work in process 2,000 9,000 7.000 Compute the equivalent units of production for (a) materials and (b) conversion costs for the month of November. Conversion Costs Materials 100% 20% Units transferred out Percentage complete, beginning work in process Materials Conversion costs Percentage complete, ending work in process Materials Conversion costs 100% 40% Work in process, November 30 Materials Conversion costs Total equivalent units