please add formulas

20 eBook FILE Paste Clipboard A1 P 5 6 7 8 9 10 11 HOME Calibri BIU INSERT Direct materials Direct labor I 12 Supplier price 13 Font 14 Units used per year 15 X 11 Sheet1 PAGE LAYOUT -A A A fxx reparo a mano or way anarysia Lavor LAVVI FORMULAS % Alignment Number A B D E F G 1 Alanco, Inc. manufactures a variety of products and is currently maunfacturing all of its own component parts. 2 An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following 3 information has been gathered relating to the cost of producing the component internally: 4 Variable manufacturing overhead Fixed manufacturing overhead, traceable* Fixed manufacturing overhead, common but allocated Total cost DATA $ REVIEW Conditional Format as Cell Formatting Table Styles Styles Alanco, Inc. manufactures a variety of products and is currently maunfacturing all *Fixed manufacturing overhead, traceable is composed of two items: Depreciation of equipment (no resale value) Supervisor salary 21.00 12,000 30% 70% VIEW $ Per Unit Differential Cost $ 16 17 18 19 20 1. Assuming the company has no alternative use for the facilities now being used to produce the 21 component, complete the following analysis to determine if the outside supplier's offer should be accepted. 22 23 Cells Editing 4.00 6.00 2.00 5.00 8.00 25.00 H 12,000 units Sign In I A 20 eBook Paste FILE Clipboard Al 23 X 32 33 HOME Calibri INSERT B I U 24 25 26 Cost of purchasing 27 Direct materials 28 Direct labor - 11 DO Font Sheet1 Alanco should PAGE LAYOUT 29 Variable manufacturing overhead 30 Fixed manufacturing overhead, traceable 31 Fixed manufacturing overhead, common Total costs A A A. A B D E 16 *Fixed manufacturing overhead, traceable is composed of two items: 17 Depreciation of equipment (no resale value) 18 Supervisor salary 19 20 1. Assuming the company has no alternative use for the facilities now being used to produce the 21 component, complete the following analysis to determine if the outside supplier's offer should be accepted. 22 FORMULAS + DATA % Alignment Number Conditional Format as REVIEW F the component Cell Formatting Table Styles Styles fxx Alanco, Inc. manufactures a variety of products and is currently maunfacturing all 30% 70% Per Unit Differential Cost Make Buy VIEW G 4 A Cells Editing = 34 Based on this analysis, write an if statement to determine if Alanco should make or buy the component. 35 36 37 38 Make 12,000 units H Buy Sign In