I need help figuring out what the excel cell formula are. I can only input formulas to get the answers correct. Thank you!

. Absolute Reference: Allows you to maintain the original cell reference when a formula is copied to another cell formula to another cell the values update based on a relative reference. For example, if you copy the formula references also moved down one cell Conversely, by adding the absolute cell reference "locks" to the equation -SB$8+$BS9". You can also use a mixed cell reference by only "locking" the column or row only ($B8 or B$8) w example, if you copy the formula-B$8+B9 from cell C1 to cell C2, the formula in cell C2 will update to be-BS remained the same. For this project, when using Absolute Cell Referencing, you can also use the auto-fill option Prepare a make or buy analysis-Excel ? 6 HOME|INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In B 1 u . |?. |Cr.?. Aignment Number Conditional Format as-Cell Formatting Table Styles Paste Cells Editing Cipboard A1 1 ? 1 x v fe | | Alanco, Inc. manufactures a variety of products and is currently maunfacturing al 2 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 5 Direct materials 6 Direct labor 7Variable manufacturing overhead 8 Fixed manufacturing overhead, traceable 4.00 6.00 2.00 5.00 8.00 9 Fixed manufacturing overhead, common but allocated 10 Total cost 12 Supplier price 13 $ 21.00 14 Units used per year 12,000 16 "Fixed manufacturing overhead, traceable is composed of two items 17Depreciation of equipment (no resale value) 18 Supervisor salary 19 30% 70% 20 1. Assuming the company has no alternative use for the facilithes now being used to produce the 21 component, complete the following analysis to determine if the outside supplier's offer should be accepted. 23 Per Unit Differential Cost 12,000 units 24 Make Buy Make Sheeti + 100 m Cortana. Ask me anything