8:24 Done 2 of 2 13. You have been hired by Squirrely Nutz, Inc. to help them plan to deliver nut mixes to grocery stores for the upcoming holiday season. In preparation for the upcoming holidays, Squirrely Nutz has spent $24,925 to acquire the following nuts Type of Nut Amount on Hand (lbs) Almond 6000 Brazil 7500 Filbert 7500 Pecan 6000 Walnut 7500 Squirrely Nutz makes three kinds of nut mixes for the holiday season. Their composition and profit per pound are Mix Type Almonds Brazil Filbert Pecan Walnut Profit/1b Regular 15% 25% 25% 10% 25% 1.65 Deluxe 20% 20% 20% 20% 20% 2.00 Holiday 25% 15% 15% 25% 20% 2.25 Squirrely Nutz has already received orders for 10,000 lbs. of regular mix, 3,000 lbs. of deluxe mix, and 5,000 lbs of holiday mix which the CEO has pledged to honor. Finally, any unused nuts can be donated to the local food bank for a tax deduction of $0.05/lb which the company considers to be profit. a. Develop a spreadsheet model that can be used with solver to plan to maximize profit b. How many pounds of each type of mix should they make? What profit does this achieve? (note: remember to subtract the initial outlay for purchasing the nuts] c. How much of that profit is attributed to the tax deduction? d. You are at a board meeting without your laptop, but you have the sensitivity report from your model run. The CEO suggests he might be able to acquire an additional 500 lbs. of almonds from a store that is going out of business for $0.75 per pound. He asks you if that is a good idea, and if so, how much would it increase profits? Can you answer him without re- running your model? How? What is your answer? e. The CEO's evil son suggests that they could make more money if the cancelled the existing orders and started from a clean slate. Is he right? If so, how much more could be made