Please answer question 12 through Excel just like the example excel screenshot below:

Question 12 25 pts 5-22 A supply chain consists of three plants (A, B, and C), three distributors (J, K, and L), and three stores (X, Y, and Z). The relevant supply, demand, and unit shipping cost information are given in the the table below. Set up and solve the transshipment model to minimize total shipping costs. Table for Problem 5-22 TO Plant Supply Store Demand From J L From Y z J K L A 400 400 A $4 $7 $5 J B 500 Y 325 B $8 $5 $4 K $6 54 58 so s5 $3 S6 S7 S6 S7 sa so so si 350 Z 400 $5 S6 $7 L $2 $7 Hint: Similar to Problem 5-21. YOU MUST SUBMIT YOUR WORK ON THIS PROBLEM TO RECEIVE FULL CREDIT O $8.200 O $9,825 O $6,875 O $9,125 Shipments: From Des Moines Evansville Fort Lauderdale Flow in Albuquerque Boston Cleveland Flow out =SUM(B5:05) =SUM(B6:06) I=SUM(B7:07) =SUM(B5:B7) =SUM(C5:C7) =SUM(D5:07) Location Des Moines Evansville Fort Lauderdale Albuquerque Boston Cleveland Flow balance equations Flow in Flow out Net flow =E5 =H5-15 =E6 =H6-16 =E7 =H7-17 =B8 =H8-18 =C8 =H9-19 =D8 =H10-110 LHS -100 -300 -300 300 200 200 Sign RHS = = Boston Cleveland Unit costs: From Albuquerque Des Moines 5 Evansville 8 Fort Lauderdale 9 4 4 7 3 3 5 Total cost = =SUMPRODUCT(B12:D14,B5:07)