Excel Online Activity: Total Suppir Chain Cost associated with three possible suppliers has been collected in the Microsoft Excel Coline file below. quertions beiow, Open sprensiheet Questions 1. What are the total supply chain costs for each of the suppliers? Round your answers to the cearest dollar: 2. Which suppler provides the lowest total supply chain cost? Total Supply Chain Cost Analysis \begin{tabular}{|c|c|c|c|} \hline & Japanese & Mexican & Chinese \\ \hline Data & Supplier & Supplier & Supplier \\ \hline Procurement cost/unit, P & $7.30 & $7.45 & $7.10 \\ \hline Management oversight cost/unit, 0 & $0.50 & $0.65 & $1.05 \\ \hline Unit transportation cost, Ct & $0.65 & $0.40 & $0.80 \\ \hline Order cost/order, C0 & $585.00 & $390.00 & $950.00 \\ \hline Holding cost per unit, Cn & $1.30 & $1.30 & $1.30 \\ \hline Lead time, L (days) & 50 & 70 & 115 \\ \hline & * & & \\ \hline Annual Demand, D & 450,000 & & \\ \hline Order Quantity, Q & 45,000 & & \\ \hline Working days in a year & 250 & & \\ \hline Average number of orders/year & & \#N/A & \\ \hline Average daily demand & & #N/A & \\ \hline \end{tabular}