please solve for both suppliers

Kuantan ATV, the, assembles five different models of all-terrain vehides (ATVs) from yarlous ready-made compnnents to serve the Las Vegas, Novado, market. The cempany uses the same engine for all its ATys. The purchasing manager, Ms. Jane Kim, needs to choose a supplier for angines for the coming year. Due to the size of the warehouse and other. atministrative restrictions, she must order the engines in lot sizes of 1,000 each. The unique characteristics of the standardized engine require special tooling to be used during the manufacturing process. Kuantan ATV agrees to reimburse the supplier for the tooling. This is a critical purchase, since late delivery of engines would disrupt aroduction and cause so. percent lost sales and 50 percent back orders of the ATVs. Jane has obtained quotes from two reliable suppliers but needs to know which wpplier is more cost-effective. The terms of sale are 2/10 net 30 for 5 upplier 1 and 1/10 net 30 for Supplier 2 . The data retated to the costs of ownership associated with two reliable suppliers has been collected in the Microsoft Excel Online file beiow, Open the sareadsheet and perform the required analysis to answer the questions below. Open spreadsheet Questions 1. What is the total cost of ownership for each of the suppliers? Assume the buyer will take advantage of the largest discount. Do not round intermediate calculaticns. Round your answers to the nearest cent. 2. Which supplier is more cost-effective