Hi! Please use the IF Function to display make or buy in the decision to be made box!!

Function: IF, SUM; Formula: Multiply, Subtract: Cell Referencing Student Work Area Required: Provide input into cells shaded in yollow in this template. Use mathematical formulas with col references to the Problem area or work area as indicated. Type the number zero in any field in the Make or Bw.columns for which there is no cost Using Excel to Assess a Make or Buy Decision PROBLEM Manson Industries makes an assembly part for its finished product. A supplier has offered to produce the assembly part. Information concerning the assembly part foliows. Unt cost to make product Variable $ 5.00 Fixed 3.00 Offer by suppler to produce Perunt 6,00 Number of units 10,000 Prepare an analysis using Excel's IF function showing the total cost saving, if any, Manson wa reakze by buying the part. Not Income Increaso (Decreaso Buy Variable manufacturing costs Make 507000 5 if the offer is accepted, Manson will save all variable costs but no fixed costs Fixed manufacturing costs 30.000 30.000 Purchase price 60.000 Total Decision to be made