Problem $2$

The Mill Mountain Coffee Shop blends coffee on the premises for its customers. It sells three basic blends in $1-$pound bags: Special, Mountain Dark, and Mill Regular. It uses four different types of coffee to produce the blends$-$Brazilian, mocha, Colombian, and mild. The shop has the following blend recipe requirements:

$\backslash$table$[[$Blend$,$Mix Requirements,Selling Price $($per Pound$)],[$Special$,$At least $40\%$ Columbian, at least $30\%$ mocha,$6\mathrm{.}5],[$Dark$,$At least $60\%$ Brazilian, no more than $10\%$ mild,$5\mathrm{.}25],[$Regular$,$No more than $60\%$ mild, at least $30\%$ Brazilian,$3\mathrm{.}75]]$

The cost of Brazilian coffee is $2\mathrm{.}00$perpound,thecostofmochais $2\mathrm{.}75$ per pound, the cost of Colombian is $2\mathrm{.}90$ perpound, andthecostofmildis $1\mathrm{.}70$ per pound. The shop has $110$ pounds of Brazilian coffee, $70$ pounds of mocha, $80$ pounds of Colombian, and $150$ pounds of mild coffee available per week. The shop wants to know the amount of each blend it should prepare each week to maximize profit.

$($a$)$ Formulate a linear programming model for this problem.

$($b$)$ Solve the model by using the Excel Solver.

PLEASE SEND SCREEN SHOT OR PICTURE OF THE EXCEL SHEET with FORMULAS AND SEND PICTUREs OR SCREEN SHOT of SOLVER WITH FORMULAS