The Smelting Company of Liner Company has the following production data of November...

Clipboard A1 X fc Functions: SUM; Formula: Multiply; Cell Referencing K 1 . G D E F B 4 C 1 Functions: SUM; Formula: Multiply; Cell Referencing 2. 3 Using Excel to Compute Equivalent Units PROBLEM 5 The Smelting Department of Kiner Company has the following 6 production data for November. 7 8 Units in beginning work in process 2,000 Units transferred out 9,000 10 Units in ending work in process 7,000 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. 11 Conversion Costs 12 Materials 13 100% 20% Units transferred out 14 Percentage complete, beginning work in process Materials Conversion costs Percentage complete, ending work in process Materials Conversion costs 15 100% 40% Work in process, November 30 Materials 16 17 Conversion costs 18 19 20 Total equivalent units 21 22 23 24 25