Formulate model for part $($a$),$ answer questions $($b$)$ and $($c$)$ below. Use your result to type answers into the Hawkes Homework Assignment

$3\mathrm{.}3$ Stocking Warehouses: The Nicklaus Razor Blade Company plans to test market a new blade next month. The blades will be stocked in their three warehouses in the following quantities.

$\backslash$table$[[$Warchouse$,$A$,$B$,$C$],[$Stock $($cartons$),50,50,50]]$

Meanwhile, the carton quantities required by the distributors in the four test markets are as follows.

$\backslash$table$[[$Distributor$,$D$,$E$,$F$,$G$],[$Requirement$,45,15,25,20]]$

The unit costs $($in dollars per carton$)$ of shipping the blades from warehouses to distributors are given in the table below.

$\backslash$table$[[,$D$,$E$,$F$,$G$],[$A$,8,10,6,3],[$B$,9,15,8,6],[$C$,5,12,5,7]]$

$($a$)$ NRBC wishes to meet the distributor's requirements at the minimum total transportation cost. Find the optimal plan.

using excel solver answer the following

$1.$ How many units should be shipped from warehouse F to distributor B$?$

$2.$ How many units should be shipped from warehouse G to distributor C$?$

$3.$which warehouse ship all their product?

$4.$what is the minimized total cost?