Please solve the question above using the spreadsheet format/methodology from the example below

and the travel costs from each potential site are shown in Table 5-4 . Each consultant is expected to take at most 25 trips each year. is the annual cost in terms of the facility and travel? single state? Table 5-4 Travel Costs and Number of Trips for SC Consulting Table 5-1 Capacity, Demand, and Cost Data for TelecomOne and HighOptic 11 Decision Variables \begin{tabular}{ll|rrrrr|r|r|} 12 & & \multicolumn{6}{|c|}{ Demand City - Production Allocation (1000 Units) } & Plants \\ \cline { 3 - 7 } 13 & Supply City & Atlanta & Boston & Chicago & Denver & Omaha & Portland & (1=open) \\ \hline 14 & Baltimore & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ 15 & Cheyenne & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ 16 & Salt Lake & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ 17 & Memphis & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ 18 & Wichita & 0 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline \end{tabular} 20 Constraints 31 Objective Function 32 Cost = \begin{tabular}{|c|l|c|c|} \hline Cell & \multicolumn{1}{|c|}{ Formula } & Equation & Copied to \\ \hline B22 & = I4*H14 - SUM(B14:G14) & 5.1 & B23:B26 \\ \hline B29 & = B9 - SUM(B14:B18) & 5.2 & C29:G29 \\ \hline B32 & =SUMPRODUCT(B4:G8,B14:G18)+SUMPRODUCT(H4:H8,H14:H18) & Objectivefunction & \\ \hline \end{tabular} 11 Decision Variables Solver Parameters Set Target Cel: Equal To: Ey Changing Cells: \$8:14:\$H1818 subject to the Constraints: $8$14;$6$18>=0 siss $8292:56229=0 \$\$14:\$-\$18 = binary 11 Decision Variables 20 Constraints 31 Objective Function 32 Cost =$47,401