Excel Online 5tructured Rctivity: Total Cost of Oanershio Kusentan AT, Inc, assembles five dafferent models of all-terain vehicies (ATVs) from various resdy-made components to serve the tas Vegas, Nevado, market. The company wes the samie engine for all its ATVs. The purchasing manager, Ms. Jane kim, needs to choose a supplier for engines for the coming yeac. Due so the tixe of the narehouse and other administrative restrictions, she muct order the engines in lot sizes of 1,000 each, The unique characteristics of the standardiaed engine require igecial tosing to be used ifuriog Ge manufocturing brecess. Kuantan ATN agrees to reimburse the supplee for the tooling This is a critical purchase, vince late delivery of engines would dernpt peoduction and cause so percent lost sales and 50 percest back orders of the ATVs. Jane has obtained quotes from ted reliable supplers but needs to know which supplier is more cott-efective. The terms of sale are 4/10 net 30 for 5 uppler 1 and 3/10 net 30 for Supplier 2 . The data related to the costs of ownership astociated mith trop reliable tuppliers has been coltected in the Microsoft Goce Online Ne below. Open the spreadsheet and perform the regured analysis to antwer the guestiont beion. Questions answers to the nearest cent. 2. Whach subplier is mare coiteeffective? Excel Online 5tructured Rctivity: Total Cost of Oanershio Kusentan AT, Inc, assembles five dafferent models of all-terain vehicies (ATVs) from various resdy-made components to serve the tas Vegas, Nevado, market. The company wes the samie engine for all its ATVs. The purchasing manager, Ms. Jane kim, needs to choose a supplier for engines for the coming yeac. Due so the tixe of the narehouse and other administrative restrictions, she muct order the engines in lot sizes of 1,000 each, The unique characteristics of the standardiaed engine require igecial tosing to be used ifuriog Ge manufocturing brecess. Kuantan ATN agrees to reimburse the supplee for the tooling This is a critical purchase, vince late delivery of engines would dernpt peoduction and cause so percent lost sales and 50 percest back orders of the ATVs. Jane has obtained quotes from ted reliable supplers but needs to know which supplier is more cott-efective. The terms of sale are 4/10 net 30 for 5 uppler 1 and 3/10 net 30 for Supplier 2 . The data related to the costs of ownership astociated mith trop reliable tuppliers has been coltected in the Microsoft Goce Online Ne below. Open the spreadsheet and perform the regured analysis to antwer the guestiont beion. Questions answers to the nearest cent. 2. Whach subplier is mare coiteeffective