solve this as soon as possible

Excel Online Structured Activity: Total Cost of Ownership Kuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various ready-made components to serve the Las Vegas, Nevada, market. The company uses the same engine for all its ATVs: The purchasing manager, Ms. Jane Kim, needs to choose a supplier for engines for the coming year. Due to the size of the warehouse and other administrative restrictions, she must order quotes from two reliable suppliers but needs to know which supplier is more costeffective. The production and cause 50 percent lost sales and 50 percent back orders of the ATVs. Jane has obtained costs of ownership associated with two reliable suppliers has been collected in the Microsoft below. 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 calculations. Round your answers to the nearest cent. 2. Which supplier is more cost-effective? Excel Online Structured Activity: Total Cost of Ownership Kuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various ready-made components to serve the Las Vegas, Nevada, market. The company uses the same engine for all its ATVs: The purchasing manager, Ms. Jane Kim, needs to choose a supplier for engines for the coming year. Due to the size of the warehouse and other administrative restrictions, she must order quotes from two reliable suppliers but needs to know which supplier is more costeffective. The production and cause 50 percent lost sales and 50 percent back orders of the ATVs. Jane has obtained costs of ownership associated with two reliable suppliers has been collected in the Microsoft below. 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 calculations. Round your answers to the nearest cent. 2. Which supplier is more cost-effective