XU H5 le - X Prepare a make or buy analysis - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Calibri 11 P Paste BIU % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard 2 Font A1 fac Alanco, Inc. manufactures a variety of products and is currently maunfacturing all B C D E F G H 1 22 23 Per Unit Differential Cost Make Buy 12,000 units Make Buy 24 25 26 Cost of purchasing 27 Direct materials 28 Direct labor 29 Variable manufacturing overhead 30 Fixed manufacturing overhead, traceable 31 Fixed manufacturing overhead, common 32 Total costs 33 34 Based on this analysis, write an if statement to determine if Alanco should make or buy the component. 35 36 Alanco should the component 37 38 39 40 Sheet1 READY + 100% Attempt(s) Hint Show Me