AutoSave OFF 19 . C ... an ModuleThreeProblemSet_Question2 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) v 12 v A" A " E ab Wrap Text v Custom Paste BIUVV DVAv = Merge & Centre $ ~ % " Conditional Format Formatting as Table E23 x v fx A B C D E F H Function: IF, SUM; Formula: Multiply; Cell Referencing BES.5 - Using Excel to Evaluate a Make-Versus-Buy Decision Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Input the required Grunar Industries produces the component parts needed for its popular non- mathematical formulas or functions with cell references to the Problem area or work area icommercial-use drones. One of the key parts has become more costly to produce " as indicated. than first planned, however, so management is considering outsourcing that part. If 8 the company decides not to manufacture this part, a portion of its fixed 9 manufacturing overhead costs would continue. The costs to produce one such part Complete the schedule to support the decision of whether to make or buy the part. 10 internally and to purchase on part from the suppler are given here. Relevant Costs to Relevant Cost to 11 Make Buy 12 Costs to produce internally Direct materials 13 Direct materials $ 2.80 Direct labor 14 Direct labor 1.70 Variable manufacturing overhead 15 Variable manufacturing overhead 0.50 Fixed manufacturing overhead 16 Fixed manufacturing overhead 2.00 Total cost 17 Cost to purchase from a supplier 5.25 18 Portion of fixed manufacturing cost to continue 80% Should Grunar continue to make tisf part or buy it from the supplier? 19 20 Grunar should 21 22 23 24 25 26 27 28 30 31 32