(1) Build the linear programming model and solve it in Excel

I am not sure how to do so. So, far the only explamations that I have foudn for this problem are to use algorthms. That does not help me though! Since my professor is requiring that we build the linear programming model and solving it in Excel.

The Donna Mosier Clothing Group owns factories in three towns (W, Y, and Z), which distribute to three retail dress shops in three other cities (A, B, and C). The following table summarizes factory availabilities, projected store demands, and unit shipping costs:

The Donna Mosier Clothing Group owns factories in three towns (W, Y, and Z), which distribute to three retail dress shops in three other cities (A, B, and C). The following table summarizes factory availabilities, projected store demands, and unit shipping costs: To Dress Shop Dress Shop Dress Shop Facto 0T Factory W Factory Y Factory Z From availability $4 $3 $3 35 $6 $7 $6 50 $8 $2 $5 50 Store demand 30 65 40 135 Building the linear programming model and solve it in Excel