please show all steps in excel and explain thank u

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 Squirrely Nutz makes three kinds of nut mixes for the holiday season. Their composition and profit per pound are Squirrely Nutz has already received orders for 10,000lbs. of regular mix, 3,000lbs. 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