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 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 production and cause 50 percent lost sales and 50 percent back orders of the atvs. jane has obtained quotes from two reliable suppliers but needs to know which supplier is more cost-effective. the terms of sale are 3/10 net 30 for supplier 1 and 1/10 net 30 for supplier 2. the data related to the costs of ownership associated with two reliable suppliers has been collected in the microsoft excel online file below. open the spreadsheet and perform the required analysis to answer the questions below. total cost of ownership analysis unit price supplier 1 supplier 2 $510.00 $510.00 requirements (annual forecast units) 1 to 999 units per order 12,000 503.00 lot size (q) 1000 to 2999 units per order $504.00 1,000 $498.00 $497.00 weight per engine (lbs) 25 3000+ units per order 24,000 order processing cost (per order) 145.00 $25,000 tooling cost 22% inventory carrying rate (per year) terms (net 30) 3% 196 105 cost of working capital (per year) 5% distance (miles) supplier quality rating (defects) supplier delivery rating (lateness) 145 profit margin 18% 2% 3% price of finished atv $4,500 2% 3% $16.00 back-order cost (per unit) back-order lost sales 50% supplier1 supplier2 50% late delivery lost sales total engine cost cash discount (net 30) other information cash discount (early payment) $0.80 per ton-mile tooling cost $1.20 per ton-mile transportation cost truckload (tl> -40,000 lbs) less-than-truckload (ltl) per ton-mile 2,000 lbs per mile ordering cost days per year 365 carrying cost invoice payment period (days) discount period (days) 30 quality cost 10 backorder cost lost sales cost total cost lowest cost 1. what is the total cost of ownership for supplier 1? assume the buyer will take advantage of the largest discount. do not round intermediate calculations. round your answers to the nearest cent. 2. what is the total cost of ownership for supplier 2? assume the buyer will take advantage of the largest discount. do not round intermediate calculations. round your answers to the nearest cent. which supplier is more cost-effective? supplier 1 supplier 2