Functions: SUM; Formula: Multiply; Cell Referencing BE4.10- Using Excel to Calculate Equivalent Units of Production PROBLEM The smelting department of Massaro Manufacturing Company has the following production and cost 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 to the work area for totals. Units in beginning work in process 2,000 Units transferred out 8,000 Compute the equivalent units of production for (a) materials and (b) conversion costs for the month of November. Units in ending work in process 7,000 Percentage complete, beginning work in process Conversion Materials Costs Materials 100% Units transferred out Conversion costs 20% Percentage complete, ending work in process Materials 100% Work in process, November 30 Materials Conversion costs 40% Conversion costs Total equivalent units