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? \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, C & $585.00 & $390.00 & $950.00 \\ \hline Holding cost per unit, Ch & $1.30 & $1.30 & $1.30 \\ \hline Lead time, L (days) & 50 & 7 & 115 \\ \hline & & & \\ \hline \begin{tabular}{c} Annual Demand, D \\ Order Quantity \end{tabular} & \begin{tabular}{r} 450,000 \\ 45,000 \end{tabular} & & \\ \hline \begin{tabular}{r} Order Quantity, Q \\ Working days in a year \end{tabular} & \begin{tabular}{r} 45,000 \\ 250 \end{tabular} & & \\ \hline \begin{tabular}{l} Working days in a year \\ Average number of orders/year \end{tabular} & & \#N/A & \\ \hline Average daily demand & r & \#N/A & \\ \hline & Japanese & Mexican & Chinese \\ \hline Cost Calculations & Supplier & Supplier & Supplier \\ \hline \begin{tabular}{l} Total procurement cost \\ Total management oversight cost \end{tabular} & & & \\ \hline Total annual transportation cost & & & \\ \hline Annual order cost & & & \\ \hline \begin{tabular}{l} Annual holding cost \\ Average annual pipeline inventory cost \end{tabular} & & & \\ \hline \begin{tabular}{l} Average annual pipeline inventory cost \\ Total supply chain costs \end{tabular} & & & \\ \hline Lowest Supply Chain Cost & 7 & \#N/A & \\ \hline & & & \\ \hline & Japanese & Mexican & Chinese \\ \hline Formulas & Supplier & Supplier & Supplier \\ \hline Total procurement cost & \#N/A & \#N/A & #N/A \\ \hline Total management oversight cost & \#N/A & # \#/A & #N/A \\ \hline Total annual transportation cost & #N/A & #N/A & #N/A \\ \hline Annual order cost & #N/A & #N/A & \#N/A \\ \hline Annual holding cost & #N/A & #N/A & #N/A \\ \hline Average annual pipeline inventory cost & \#N/A & \#N/A & \#N/A \\ \hline Total supply chain costs & \#N/A & \#N/A & \#N/A \\ \hline \end{tabular}