Part $2$: Solver

Solver is a useful tool built into Excel that allows us to take a system of equations that is dependent on multiple variables and evaluate a desirable solution. Often applied in terms of inventory, or basic supply chain and optimization, Solver proves to be a useful tool for minimizing cost in many different industries.

Remember the company in Part $1-$ they are still in the process of identifying how to reduce their costs and eliminate any unnecessary expenditure. From your knowledge of the utilization of Solver, find the optimized minimum acquisition cost of some of their produce from the supplier, given some set of constraints provided below:

$\backslash$table$[[\backslash$table$[[$Packaged$],[$Produce$],[$Category$]],\backslash$table$[[$Quantity from$],[$Supplier $1],[($Units$)]],\backslash$table$[[$Quantity from$],[$Supplier $2],[($Units$)]],\backslash$table$[[$Quantity$],[$from$],[$Supplier $3],[($Units$)]],\backslash$table$[[$Minimum$],[$Goods$],[$Requiremen$],[$t$]]],[$Crackers$,80,45,60,200],[$Cookies$,50,35,120,190],[$Snacks$,80,80,50,150],[\backslash$table$[[$Cost$],[($cents$)]],120,90,100,]]$

Note: All quantities are in thousands

Tasks and Requirements:

Use the Solver tool to minimize the cost $($objective function$)$ and find the optimal quantities of goods they should purchase daily.

Use the template $($provided$)$ to ensure proper cell referencing and correct results.