example, if you copy the formula-B$8+B9 from cell C1 to cell C2, the formula in cell C2 will update to be -Bs8 810 remained the same For this project, when using Absolute Cell Referencing, you can also use the auto-fill option, howey Prepare a make or buy analysis Exce HOME INSERTPAGE LAYOUT FORMULASDATA REVIEW VIE Paste d B 1 u . |16- . Alignment Nuber Conditional Format as. Ce. Formating Table Styles Cells Edeng Styles H7 Inc. manufactures a variety of products and is currently maunfacturing all of its own component parts 2 An outside suppler 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 internaly $ 4.00 5 Direct materials 6 Direct labor 7Variable manufacturing overhead 8 Fixed manufacturing overhead, traceable* 9 Fixed manufacturing overhead, common but alocated 10 Total cost 6.00 2.00 5.00 $ 21.00 12 Supplier price 13 14 Units used per year 12,000 e "Fixed manufacturing overhead, traceable is composed of two items 17 Depreclation of equipment (no resale value) 30% 70% 18 | Supervisor salary 20 1. Assuming the company has no alternative use for the facilities now being used to produce the 21 component, complete the following analyss to determine if the outside supplier's offer should be 23 Per Unit Dfferential Cost 12,000 units Sheeti