min: IF, SUM; Formula: Multiply; Cell Referencing BE5.5 - Using Excel to Evaluate a Make-VersusBuy De Ision Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Input the Grunar Industries produces the component parts needed for its popular required mathematical formulas or functions with cell references to the Problem non-commercial-use drones. One of the key parts has become more costly area or work area as indicated. to produce than first planned, however, so management is considering outsourcing that part. If the company decides not to manufacture this part, a portion of its fixed manufacturing overhead costs would continue. The Complete the schedule to support the decision of whether to make or buy the part. costs to produce one such part internally and to purchase on part from the suppler are given here. Relevant Costs Relevant Cost to Make to Buyr Costs to produce internally Direct materials Direct materials S 2.80 Direct labor ' Direct labor 1.70 Variable manufacturing overhead ' Variable manufacturing overhead 0.50 Fixed manufacturing overhead ' Fixed manufacturing overhead 2.00 Total cost Cost to purchase from a supplier 6.25 Portion of fixed manufacturing cost to continue 80% Should Grunar continue to make the part or buy it from the supplier? ' Grunar should