include cell references thanks!

E G fx Accessibility tab summary: Financial information for Alanco, Incorporated, is presented in rows 6 to 19. A statement B D F cost of producing the component internally: 5 Direct materials $4.00 Direct labor 6.00 B Variable manufacturing overhead 2.00 Fixed manufacturing overhead, traceable 5.00 10 Fixed manufacturing overhead, common but allocated 8.00 1 Total cost $25.00 2 3 Supplier price $21.00 4 5 Units used per year 12,000 6 7 * The fixed manufacturing overhead, traceable 8 Depreciation of equipment (no resale value) 30% 9 Supervisor salary 70% 0 1 Required: 21. Assuming the company has no alternative use for the facilities now being used to produce the component, 3 complete the following analysis to determine if the outside supplier's offer should be accepted + s (Use cells A6 to B19 from the given information to complete this question. Blank or zero value answers should be entered as =0) Per Unit Differential Cost Make Buy 12,000 units Make Buy 2 Cost of purchasing Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead, traceable Fixed manufacturing overhead, common Total costs 3 5 6 = Graded Worksheet +