Problem: Demand data and supply data of the company TelecomOptic are given in the following table. Determine, using Excel Solver, how to meet all the demands at a minimum cost. Your Excel file should clearly indicate how the problem is formulated and solved (for example: see Figure 5 12 of the textbook). If your solution does not match with the one given in the textbook, then make sure that your decision variables have no more than 2 decimal places and then run Solver again (to have no more than 2 decimal places, go to Format > Format Cells > Number). \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|} \hline Cheyenne & 1,460 & 1,940 & 970 & 100 & 495 & 1,200 & 24 & 3,500 \\ \hline SaltLakeCity & 1,925 & 2,400 & 1,425 & 500 & 950 & 800 & 27 & 5,000 \\ \hline Memphis & 380 & 1,355 & 543 & 1,045 & 665 & 2,321 & 22 & 4,100 \\ \hline Wichita & 922 & 1,646 & 700 & 508 & 311 & 1,797 & 31 & 2,200 \\ \hline Annualdemand.Dy(thousandunits) & 10 & 8 & 14 & 6 & 7 & & & & \\ \hline \end{tabular} Problem: Demand data and supply data of the company TelecomOptic are given in the following table. Determine, using Excel Solver, how to meet all the demands at a minimum cost. Your Excel file should clearly indicate how the problem is formulated and solved (for example: see Figure 5 12 of the textbook). If your solution does not match with the one given in the textbook, then make sure that your decision variables have no more than 2 decimal places and then run Solver again (to have no more than 2 decimal places, go to Format > Format Cells > Number). \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|} \hline Cheyenne & 1,460 & 1,940 & 970 & 100 & 495 & 1,200 & 24 & 3,500 \\ \hline SaltLakeCity & 1,925 & 2,400 & 1,425 & 500 & 950 & 800 & 27 & 5,000 \\ \hline Memphis & 380 & 1,355 & 543 & 1,045 & 665 & 2,321 & 22 & 4,100 \\ \hline Wichita & 922 & 1,646 & 700 & 508 & 311 & 1,797 & 31 & 2,200 \\ \hline Annualdemand.Dy(thousandunits) & 10 & 8 & 14 & 6 & 7 & & & & \\ \hline \end{tabular}