Here's the question

Here's the Excel

Please only answer if you'll give an answer and not just write paragraphs about solving it. Save your time because I'll thumbs down. thanks

Consider the transportation problem having the unit shipping costs shown in the following table. Click here for the Excel Data File Formulate and solve a spreadsheet model for this problem. a. Determine the shipping costs. Note: Leave no cells blank. Enter " 0 " wherever required. b. Determine the total cost. A8 \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline A & A & B & C & D & E & F & G & H & 1 & j & K \\ \hline 1 & From & To & Ship & Unit Cost & & & & \multicolumn{3}{|c|}{ Supply/Demand } & \\ \hline 2 & Source 1 & Destination 1 & & $6 & & & & & 40 & & \\ \hline 3 & Source 1 & Destination 2 & & $7 & & & & & 60 & & \\ \hline 4 & Source 1 & Destination 3 & & $4 & & & & & -30 & & \\ \hline 5 & Source 2 & Destination 1 & & $5 & & & & & -40 & & \\ \hline 6 & Source 2 & Destination 2 & & $8 & & & & & -30 & & \\ \hline 7 & Source 2 & Destination 3 & & $6 & & & & & & & \\ \hline \multicolumn{12}{|c|}{8} \\ \hline \multicolumn{12}{|c|}{9} \\ \hline \multicolumn{12}{|c|}{10} \\ \hline \multicolumn{12}{|l|}{11} \\ \hline \multicolumn{12}{|l|}{12} \\ \hline 13 & & & & & & & & & & & \\ \hline 14 & & & & & & & & & & & \\ \hline \end{tabular}