E16 \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{A} & B & C & D & E & F & G & \multirow[t]{2}{*}{ H } \\ \hline 1 & New So & ware & & & & & & \\ \hline 2 & & & Monthly & & Current & Proposed & & \\ \hline 3 & & Demand, D & 2000 & 12 & 2000 & 2000 & & \\ \hline 4 & & Unit cost per computer, \$C & & & 750 & 750 & & \\ \hline 5 & & Set up order cost, \$S & & & 5,000 & 3,750 & 75% savings & \\ \hline 6 & & Holding cost per year, h & & & 20% & 20% & & \\ \hline 7 & & & & & & & & \\ \hline 8 & & EOQ & & Q & 365 & 316 & & \\ \hline 9 & & & & & & & & \\ \hline 10 & & Cycle inventory & & Q/2 & 183 & 158 & & \\ \hline 11 & & & & & & & & \\ \hline 12 & & Number of orders per year & & D/Q & 5 & 13 & & \\ \hline 13 & & & & & & & & \\ \hline 14 & & Material cost & D$C & & 1,500,000 & $1,500,000 & & \\ \hline 15 & & Ordering cost & $SD/Q & & 27,386 & 23,716 & 3,669 & Savings \\ \hline 16 & & Holding cost & Avg invt * \% & & & & & \\ \hline 17 & & Total supply chain cost & & & & & & \\ \hline 18 & & & & & & & & \\ \hline 19 & & & & & & Investment & $100,000 & \\ \hline 20 & & & & & & Savings & $3,669 & \\ \hline 21 & & & & & & Invest pay back & & years \\ \hline 22 & & & & & & & & \\ \hline 23 & & & & & & & & \\ \hline 24 & & & & & & & & \\ \hline 25 & & & & & & & & \\ \hline 26 & & & & & & & & \\ \hline 27 & & & & & & & & \\ \hline 28 & & & & & & & & \\ \hline 29 & & & & & & & & \\ \hline 30 & & & & & & & & \\ \hline 31 & & & & & & & & \\ \hline \end{tabular}