Format as Table Paste BI U A % ) 6.0 .00 00 .0 E- Cell Styles N30 x fx A B C D E F G H J L M N 0 Q 1 Formula: Add, Subtract; Cell Referencing 2 3 Using Excel to Calculate Manufacturing Costs PROBLEM 5 Presented below are incomplete manufacturing cost data. 4 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 when indicated. 6 Determine the missing amounts for three different situations. 7 8 9 10 11 12 Direct Materials Used 1. $ 40,000 2. ? 3. 55,000 Direct Labor Used $ 61,000 75,000 ? Factory Overhead $ 50,000 140,000 111,000 Total Manufacturing Costs ? $ 296,000 310,000 1. Total manufacturing costs 13 2. Direct materials used 14 15 3. Direct labor used 16 17 18 19