$2.$ In Problem $13$ in Chapter $6,$ Computers Unlimited sells microcomputers and distributes them from three warehouses to four universities. The available supply at the three warehouses, demand at the four universities, and shipping costs are shown in the following table:

Instead of its original objective of cost minimization, Computers Unlimited has indicated the following goals, arranged in order of their importance:

$(1)$ A$\backslash$&M has been one of its better long$-$term customers, so Computers Unlimited wants to meet all of A$\backslash$&M$\text{'}$s demands.

$(2)$ Because of recent problems with a trucking union, it wants to ship at least $80$ units from the Washington warehouse to Central University.

$(3)$ To maintain the best possible relations with all its customers, Computers Unlimited would like to meet no less than $\backslash (80\backslash \%\backslash )$ of each customer's demand.

$(4)$ It would like to keep total transportation costs to no more than $\backslash (110\backslash \%\backslash )$ of the $\backslash (\backslash$$ $22,470\backslash )$ total cost achieved with the optimal allocation, using the transportation solution method.

$(5)$ Because of dissatisfaction with the trucking firm it uses for the Atlanta$-$to$-$State deliveries, it would like to minimize the number of units shipped over this route.

a$.$ Formulate a goal programming model for this problem to determine the number of microcomputers to ship on each route to achieve the goals.

b$.$ Solve this model by using the computer.

Could you give me the excel in simplest form please something like the second picture