A A B $$ D D E F $$ H $1$ J K L M $$ N N $$ Not Nutts Ingredients Chocolate Chips Granola Peanuts Sunflower Seeds $11$ Trail Mix Varieties Deluxe Traditional $101111111$ Sweet Tooth $1100$ Cost $$0\mathrm{.}30$ $$0\mathrm{.}30$ $$0\mathrm{.}40$ $$0\mathrm{.}3001$ Demand Total to Make $4,000,000115,000,00012,000,00013,000,0001$ Price$/$Bag Cost$/$Bag Gross Profit$/$Bag $$2\mathrm{.}99$ $ $$0\mathrm{.}90$ $$2\mathrm{.}09$ $$2\mathrm{.}99$ $$1\mathrm{.}30$ $$1\mathrm{.}69$ $$2\mathrm{.}99$ $$1\mathrm{.}00$ $$1\mathrm{.}99$ $$2\mathrm{.}99$ $$0\mathrm{.}60$ $$2\mathrm{.}39$ Gross Profit$/$Type $$2$ $$2$ $$2$ $$2$ Total Profit $$8123456718$ a $910114121314151617181920212223202425262627282930313233243435236373738394041$ Ingredients Chocolate Granola Peanuts Sunflower Seeds Material Totals Used $3423$ Available $12,000,00014,000,0005,000,00011,000,000$ Concerts FoodSales Trail Past Events Event Profit $+$ Ready $13\mathrm{.}1$ Set up solver to determine how many of each variety of trail mix to make to maximize total profit subject to the following constraints: a$.$ The number of bags of trail mix made $($range C$10$:F$10)$ should not exceed the demand $($range $09$:F$9)$ for that type of mix. b$.$ You must make at least $1$ million of each type of trail mix. c$.$ Note that you should not use the comma separator when you create this constraint $($use $1000000$ instead of $1,000,000)$ d$.$ The ingredients consumed in making the mixes $($range C$22$:C$25)$ should not exceed what is available $($range D$22$:D$25).$ e$.$ There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts. f$.$ Make only whole number amounts of mixes. g$.$ Before solving make the solving method Simplex LP and checkmark the Make Unconstrained Variables Non$-$negative option. $4514)$ Given the problem constraints, which Gross Profit amount is closest to the maximum profit possible for this problem? $$22,800,000$ $$23,700,000$ $$24,600,000$ $$25,500,000$ $$26,400,000$ O $$27,300,00015$ Production would fall short of demand for which variety of trail mix? Not Nutts Deluxe Traditional O Sweet Tooth