What formulas should be used and when should they be used? I'm not sure when to put things in make or buy.

A1 X fx Function: IF, SUM; Formula: Multiply, Subtract; Cell Referencing E F G H M N B D 1 Function: IF, SUM; Formula: Multiply, Subtract; Cell Referencing 2 3 BE7.5 - Using Excel to Assess a Make or Buy Decision 7. PROBLEM 5 Emil Manufacturing makes a sub-assembly part for its finished 6 product. A supplier offers to make the parts. If Emil accepts the offer, 7 Emil will save all variable costs and some of the fixed costs. 3 Information concerning the sub-assembly part follows. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or work area as indicated. Type the number zero in any field in the Make or Buv columns for which there is no cost. Use the IF function in the Decision to be Made answer field. Prepare an analysis showing the total cost savings, if any, that Emil will realize by buying the part. 0 1 $ 4.50 3.00 2 3 Unit cost to make product Variable Fixed Offer by supplier to produce Per unit Number of units Unit savings of fixed costs if offer accepted Net Income Increase (Decrease) Make Buy 4 5 5.00 10,000 1.00 Per Unit Variable manufacturing costs $ 4.50 .6 .7 Fixed manufacturing costs 3.00 8 9 Purchase price 5.00 CO 1 Total 2 3 Decision to be made 4 5 -6 -7