Excel Oolinn Activity: Totai Supply Chain Cost A global sourding manager for Delta Automotive wants to compute the total supply chain costs for automobile parta purchased from tureeditterent plobal suppliers. The data felated to the supply chain costs associated whth three possible suppliers has been callected in the Microsan Ercel Online Ale belaw. The annual demand D is 400,000 unita- The supplier prices and transportation costs are predicated on an order quantity of 50,000 units (note chat this is not the EQQ). We may assume that parts are transported from Mexica to the United Spates by truck, and by a combination of ships and trucks from Japan and China, and 250 working days per vear, Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Qutertions 1. What are the total supply chain costs for each of the suppliers? Round your answers to the nearest dollar. 2. Which supplier provides the lowest total supply chain cost