please help, very confused!!

Part 2: Excel Solver (10 Points) Given: You are provided the model formulation below. Decision Variables: W= gallons of white wine to purchase and use in the production of a wine cooler blend R - gallons of rose wine to purchase and use in the production of a wine cooler blend F gallons of fruit juice to purchase and use in the production of a wine cooler blend Objective function: MAX: 1.52W+1.20R+2.65F Subject to: Constraints: C1(useatleast38%whitewine):C2(useatleast23%rosewine):C3(usenomorethan31%fraitjuice):C4(Max.availablewhite):C5(Max.availablerose):C6(Max.availablefruitjuice):C7(non-negativity):0.62W0.38R0.38F00.23W+0.77R0.23F00.31W0.31R+0.69F01W12,0001R15,000F7,100W,R,F0 Instructions: 1. Use an existing spreadsheet posted on canvas and revise it to create a Solver model and to generate a sensitivity report. 2. Answer the questions below in your Excel spreadsheet. 3. Submit your Excel spreadsheet with your answers to the Canvas Assignment. Part a) How many of each ingredient should be purchased, and what is the value of the objective function (Total Profit)? List "Part a" by your answers. 4 points Note: You must answer all Sensitivity Analysis questions below in the upper right hand part of your spreadsheet (as shown in all Sensitivity examples posted on Canvas). Part b) Use the Sensitivity Report that you generated and refer to your original answer. Assume that we will decrease the Net Profit per gallon of F to $2.58. Label your answers, "Part b." Amount of the Decrease equals what value? 0.5 points Allowable Decrease equals what value? 0.5 points Is this change within the Allowable Decrease? Yes or No? 0.5 points What will the new objective function value equal? Note: You must calculate this value in your Excel spreadsheet using the SUMPRODUCT formula that we used in all spreadsheets posted on Canvas. If all you do is to revise your model and re-run it, you will receive 0 points 1.5 points Part e) Use the Sensitivity Report that you generated and refer to your original answer. Assume that we will decrease the right-hand-side value of C6 to 6,500. Label your answers, "Part c." Amount of the Decrease equals what value? 0.5 points 600 Allowable Decrease equais what value? 0.5 points Is this change within the Allowable Decrease? Yes or No? 0.5 points What will the new objective function value equal? Note: You must calculate this value in your Excel spreadsheet using the simple formula that we used in all spreadsheets posted on Canvas. 1.5 points