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: