Note: You will find the Example videos in the module very helpful in answering these questions. Please type in the space provided.

Busch Gardens Sweets is preparing for Halloween. They prepare two sizes of Spooky Trail Mix and need to calculate how many bags of deluxe and standard mixes they can produce.

$-$ The grand mix takes $\mathrm{.}9$ pound of raisins and $0\mathrm{.}65$ of a pound of peanuts.

$-$ The standard mix takes $0\mathrm{.}55$ of a pound of raisins and $0\mathrm{.}45$ of a pound of peanuts.

The shop has $90$ pounds of raisins and $70$ pounds of peanuts.

The profit on the deluxe mix is $$3\mathrm{.}25$ and the standard mix profit is $$2\mathrm{.}60.$ The owner wants no more than $100$ bags of each type prepared.

Do not forget the non$-$negativity constraint and remember that you cannot sell partial bags $($whole numbers only$).$

Use Excel Solver $($as demonstrated in the lecture$)$ to determine the:

a$.$ The optimal number of Deluxe Mix to prepare

b$.$ The optimal number of Standard Mix to prepare

c$.$ What is the optimal profit? Include the formula using actual numeric values, NOT cell location

d$.$ How many pounds of raisins are needed to achieve optimal profit?

e$.$ How many pounds of peanuts are needed to achieve optimal profit?

f$.$ If the profit on the deluxe bags was increased to $$4\mathrm{.}00,$ would the number of deluxe bags increase or decrease? By how many?