How do I do this?

Prepare a make or buy analysis. Prepare a make or buy analysis - Excel FILE Paste Clipboard H26 HOME Calibri INSERT PAGE LAYOUT FORMULAS DATA Conditional Formatting REVIEW VIEW Sign In Alignment Number Format as Cell Table SMes Styles Cells Editing Alanco, Inc. manufactures a variety of products and is currently maunfacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following_ information has been gathered relating to the cost of producing the component internally: 8 10 12 14 Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead, traceable* Fixed manufacturing overhead, common but allocated Total cost Sgpplier rice Units used per year 4.00 5.00 2.00 5.00 8.00 21.00 12,000