write answers as formulas

Alanco, Incorporated manufactures a variety of products and is currently manufacturing all of its own component parts. An outside suppller has offered to sell one of those components to Alanco. The Controller has asked you to heip evaluate this offer to determine if the company should make or buy the compons." Required: 1. Assuming the company has no alternative use for the facilities now being used to procuce the component, complete the following anelysis to determine if the outside supplier's offer should be accepted. 2. Based on this analysis, determine if Alanco should make or bwy the component. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to retum to Connect. 21 Required: 1. Assuming the company has no alternative use for the facilities now being used to produce the component, complete the following analysis to determine if the outside supplier's offer should be accepted. (Use cells A6 to B19 from the given information to complete this question. Blank or zero value answers should be entered as =0.) an. 2. Based on this analysis, determine if Alanco should make or buy the component. Alanco should the component. Aanco, incoporates macufactures a variefy of products and is currentiy mauntacturing all of ith own component parts An outside suspliet has offered to sel one of those composents to Alanco. To evaluate this offec, the folowing irforination hai been gathered retarice to the cost of producing the cemponent intenaly Bequised determine youse ontsife kepler's offer shsuia be accepied