Chapter Problems Question3 - Excel File Home Insert Page Layout Formulas Data Review View ACROBAT Tell me what you want to do.. Cut Liberation San-12 - A A Wrap Text Custom 17 Accent2 Accent3 Copy Paste Formal Painter Clipboard BIU- === **Merge & Center - $-%" Conditional Formal as Accent5 Formatting Table" Accent6 Accent4 Comma AutoSum Sign in Share AT P Insert Delete Formal Fill- Clear Sort & Find & Filter Select For Alignment Number Styles Cells Editing C21 E F H M N P Q R- 1 Function: IF, SUM; Formula: Multiply, Subtract; Cell Referencing 2 3 Using Excel to Assess a Make or Buy Decision 4 PROBLEM 5 Manson Industries makes an assembly part for its finished 6 product. A supplier has offered to produce the assembly part. 7 Information concerning the assembly part follows. 8 9 10 11 12 13 14 15 Unit cost to make product Variable $ 5.00 Fixed 3.00 Per unit 6.00 10,000 Offer by supplier to produce Number of units 16 If the offer is accepted, Manson will save all variable costs but 17 no fixed costs. 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 Buy columns for which there is no cost. Prepare an analysis using Excel's IF function showing the total cost saving, if any, Manson will realize by buying the part. Make Buy Variable manufacturing costs Fixed manufacturing costs Net Income Increase (Decrease) 18 19 20 21 22 23 24 25 26 27 28 Enter Answer Select destination and press ENTER or choose Paste W Purchase price Total Decision to be made 2:53 PM 2/23/2022 100%