Excel Online Activity: Total Suppir Chain Cosk associated with three possible suppliers has been collected in the Microson fxcel Coline file below. quertions beliow. Open sprenstheet Questions 1. What are the total supply chain costs for each of the suppliers? Round your -answers to the nearest doltar: 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, Ch & $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}