IMPORTANT: Show your work in Excel (i.e. functions used) and use Solver add-in to find your solution. This is a linear programming problem. Provide Excel screenshots, if possible.

Solver Parameters You can produce 4 types of products that need 5 parts each. In the table on the laft you have the production cost per product. its revenue. the availability of each part, and Se Objective: in the boxed cells the number of parts needed for each product. You must produce at least 10 units of each To: Max Min Value Of: product. Maximize profit by selecting the number to products of each type to produce. Solution does not have Ey Changing Variable Cells: to be integer. Subbject to the Constraints: Make Unconstrained Varables 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