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. Units in beginning work in process Units transferred out Units in ending work in process Percentage complete, beginning work in process Materials Conversion costs Percentage complete, ending work in process Materials Conversion costs 2,000 9,000 7,000 100% 20% 100% 40% 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. Compute the equivalent units of production for (a) materials and (b) conversion costs for the month of November. \begin{tabular}{|l|l|l|} \hline & Materials & ConversionCosts \\ \hline Units transferred out & \\ \hline Work in process, November 30 & \\ \hline Materials & \\ \hline Conversion costs & \\ \hline Total equivalent units & \\ \hline \end{tabular}