Pls use Excel$$s Solver to solve the linear program!

Elversberg Manufacturing has three factories $(1,2,$ and $3)$ and three warehouses $($A$,$ B$,$ and C$).$ The following table shows the shipping costs between each factory and warehouse, the factory manufacturing capabilities $($in thousands$),$ and the warehouse capacities $($in thousands$).$ Note that the costs below are not in thousands.

Management would like to keep the warehouses filled to capacity in order to generate demand. Formulate a linear program in order to find the optimal flow of items from factories to

warehouses such that total shipping cost is lowest. Ensure that the constraints of your linear program are such that factories produce at most their production capability and capacity at each warehouse is met exactly. Clearly write out your linear program $($objective function and constraints$)$ in your PDF$.$

Next, use Excel$$s Solver to solve the linear program. Your PDF must state the following: The

optimal solution $($the values that the decision variables take$)$ and the optimal value of the

objective function $($the value of the objective function at the optimal solution$).$ You must also submit an Excel file containing the linear programming formulation. Note that your optimal

objective function value will be in $$1000$s since the quantity of items is in $1000$s$.$ For example, if your solution in Excel is $55,$ that would mean that the optimal cost is $$55,000.$