Hi can you make sure to include all formulas so i can do it on my own in excel as well. Thank you!

Case $2.(50$ p$.)$ Lost Maples Winery makes three varieties of contemporary Texas Hill Country

wines: Austin Formation $($a fine red$),$ Ste. Genevieve $($a table white$),$ and Los Alamos $($a hearty

pink Zinfandel$).$ The raw materials, labor, and contribution per case of each of these wines is

summarized below.

The winery has $2800$ bushels of Variety A grapes, $2040$ bushels of Variety B grapes, $800$ pounds

of sugar, and $1060$ man$-$hours of labor available during the next week. The firm operates to

achieve maximum contribution.

Answer the following questions $($use Excel's add$-$in Solver$).$

a$.$ p$.)$ For maximum contribution, how much of each wine should be produced?

b$.(10$ p$.)$ How much contribution will be made by selling the above optimal production of wine?

c$.$ p$.)$ Will the optimal solution change if the contribution per case of Austin Formation wine

increases by $$6?$ Will the total contribution change? Fully justify your answer.

d$.(10$ p$.)$ Will $($and how$)$ the total contribution change if the amount of sugar available increases

to $810$ pounds? Fully justify your answer.