Using MS Excel Solver, use linear programming to solve the following problem. Chose the problem associated with the first letter of your last name. Submit an Excel spreadsheet showing how you set up the problem, and your solution. Make sure the objective function and constraints are clearly noted. Include in the spreadsheet a screenshot of your Solver input page. A company makes three types of candy and packages them in three assortments. Assortment I contains 8 sour, 5 lemon, and 10 lime candies, and sells for \$10.20. Assortment II contains 10 sour, 6 lemon, and 6 lime candies, and sells for $9.30. Assortment III contains 7 sour, 10 lemon, and 8 lime candies, and sells for $11.80. Manufacturing costs per piece of candy are $0.35 for sour, $0.40 for lemon, and $0.45 for lime. They can make 5,500 sour, 4,000 lemon, and 6,600 lime candies weekly. How many boxes of each type should the company produce each week in order to maximize its profit? What is the maximum profit