Hello, I need step by step instructions for this problem.

Autosave ModuleThreeProblemSet_Question2 (1) - E... Search Newsome, Debra ND File Home Insert Page Layout Formulas Data Review View Automate Help A B 1 Function: IF, SUM; Formula: Multiply; Cell Referencing 2 BE5.5 - Using Excel to Evaluate a Make-Versus-Buy Decision PROBLEM Grunar Industries produces the component parts needed for its popular non-commercial-use drones. One of the key parts has become more costly to produce than first planned, however, so management is considering 8 outsourcing that part. If the company decides not to manufacture this part, 9 a portion of its fixed manufacturing overhead costs would continue. The 10 costs to produce one such part internally and to purchase on part from the suppler are given here. \begin{tabular}{l} 11 \\ 12 \\ 13 \\ 14 \\ 15 \\ 16 \\ 17 \\ 18 \\ 19 \\ 20 \\ 21 \\ 22 \\ 23 \\ 24 \\ 25 \\ 26 \\ 27 \\ 28 \\ 29 \\ 30 \\ 31 \\ 32 \\ 33 \\ 34 \\ 35 \\ 36 \\ 37 \\ \hline \end{tabular} Costs to produce internally Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Cost to purchase from a supplier Portion of fixed manufacturing cost to continue $2.80 1.70 0.50 2.00 6.25 80% Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Total cost Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Complete the schedule to support the decision of whether to make or buy the part. Should Grunar continue to make the part or buy it from the supplier? Grunar should Enter Answer Ready Accessibility: Investigate Opening: ModuleThreeProblemSet_Question3.xIsx +100%