Please solve in "EXCEL"

PROBLEM 9-4 Determining Whether to Make or Buy(LO1CC5) CHECK FIGURE

(1) The part can be made inside the company for $6 less per unit.

Troy Engines Ltd. manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to produce and sell one type of carburetor to Troy Engines Ltd. for a cost of $35 per unit. To evaluate this offer, Troy Engines Ltd. has gathered the following information relating to its own cost of producing the carburetor internally:

*Table attached for the figures required ( look in attachment tabnine60_lg) Required:

1. Assuming that the company has no alternative use for the facilities that are now being used to produce the carburetors, should the outside supplier's offer be accepted? Show all computations.
2. Supposethatifthecarburetorswerepurchased,TroyEnginesLtd.couldusethefreedcapacitytolaunchanewproduct.Thesegmentmarginofthenewproductwouldbe$150,000peryear.ShouldTroyEnginesLtd.accepttheoffertobuythecarburetorsfor$35perunit?Showallcomputations.

***********************************************************************************************************************

PROBLEM 9-4 Determining Whether to Make or Buy(LO1CC5) CHECK FIGURE

(1) The part can be made inside the company for $6 less per unit.

Troy Engines Ltd. manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to produce and sell one type of carburetor to Troy Engines Ltd. for a cost of $35 per unit. To evaluate this offer, Troy Engines Ltd. has gathered the following information relating to its own cost of producing the carburetor internally:

Required:

1. Assuming that the company has no alternative use for the facilities that are now being used to produce the carburetors, should the outside supplier's offer be accepted? Show all computations.
2. Suppose that if the carburetors were purchased, Troy Engines Ltd. could use the freed capacity to launch a new product. The segment margin of the new product would be $150,000 per year. Should Troy Engines Ltd. accept the offer to buy the carburetors for $35 per unit? Show all computations.