R AutoSave OM ExcelAssignment Question - Protected View Search File Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain ruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing A1 fo Formula: Add Subtract: Cell Referencing C. F G H K M 1 Formula: Add, Subtract: Cell Referencing 2 3 Using Excel to Calculate Manufacturing Costs Student Work Area 4 PROBLEM Required: Provide input into cells shaded in yellow in this 5 Presented below are incomplete manufacturing cost data template Use mathematical formulas with cell references to the 6 Problem area Use the SUM function when indicated 1 Dured Total Material Direct Factory Manufacturing 9 Used Labor Used Overhead Costi Determine the missing amounts for three different situations 10 1. $ 40.000 $ 61,000 $50,000 2 11 2 75.000 140.000 $ 296,000 + Total manufacturing costs 3 55,000 ? 111,000 310,000 13 2 Direct materials used 14 15 3 Direct labor used 16 10 19 20 21 22 23 24 26 29 Enter Answer Ready Tuner