Show the solution as a table Using excel with explanation.

Consider the problem attached. But instead of minimizing total cost of production and transportation in Exercise $5.$ This time try to achieve the following goals in the given order.P$1.$ Try to manufacture only in three factories;P$2.$ Do not exceed the $80\%$ of the production capacity $($for example for Plant $1$ the capacity is $12000$ units, then aim not to produce more than $9600$ units at this factory if you do produce$)$ for each plant, if you decide to produce;P$3.$ Total transportation cost should not be more than $940,000$$;Model the problem as a Goal Programming to minimize the necessary deviations from goals P$1,$ P$2$ and P$3$ in this order. Then report your output as follows:Next year production will take in Plants $.....$ with amounts $...$ in plant $...$ etcand then transfered to Warehouses A to D with respect to this table $($A from to transportation table$)$ and achieved to goals with such $($or non$)$ descripencies.During the war with Iraq in $1991,$ the Terraco Motor Company produced a lightweight, allterrain vehicle code$-$named $"$J$99$ Terra" for the military. The company is now planning to sell the Terra to the public. It has five plants that manufacture the vehicle and four regional distribution centers. The company is unsure of public demand for the Terra, so it is considering reducing its fixed operating costs by closing one or more plants, even though it would incur an increase in transportation costs. The relevant costs for the problem are provided in the following table. The transportation costs are per thousand vehicles shipped; for example, the cost of shipping $1,000$ vehicles from plant $1$ to warehouse $C$ is $$32,000.$

$\backslash$table$[[\backslash$table$[[$From$],[$Plant$]],\backslash$table$[[$Transportation Costs $($$$1,000$s$)],[$to Warehouse$]],\backslash$table$[[$Annual$],[$Production$],[$Capacity$]],\backslash$table$[[$Annual$],[$Fixed$],[$Operating Costs$]]],[$A$,$B$,C,D$