IMPORTANT: Show your work in Excel (i.e. functions used) and use Solver add-in to get your solution. You will use linear programming. Include Excel screenshots, if possible.

There are four factories producing a product that is needed in six destinations. In the table on the left there are the number of products available at the factories, their production costs. For the desinations the selling price of an item and the maximum needed quanntity in each destination is given. In the framed boxes the transporation cost of one item from factory to destination are given. Find the number of items to ship from each factory to each destination to maximize profit.

There are four factories producing a product that is needed in six destinations. In the table on the left there are the Se Objective: number of products available at the factories, their To: production costs. For the desinations the selling price of an Value Of: item and the maximum needed quanntity in each destination is given. In the framed boxes the transporation cost of one item from factory to destination are given. Find the number of items to ship from each factory to each Subbject to the Constraints: Make Unconstrained Variables Non-Negative Select a Solving Method: Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth