Module 7 Assignment Instructions 1. For parts a and b, set up the Excel spreadsheet as follows: 2. Enter =SUMPRODUCT(B8:D8,B11:D11) in cell E4 3. Enter = SUMPRODUCT(B5:D5,B11:D11) in cell B14 4. Enter =SUMPRODUCT(B6:D6, B11:D11) in cell B15 5. Enter \\( = \\) SUMPRODUCT(B7:D7, B11:D11) in cell B16 6. Enter \\( =\\mathrm{C} 11 \\) in cell \\( \\mathrm{B} 17 \\) 7. Configure the Analytic Solver add-in as follows. Click Solve and select the Answer and Sensitivity reports. 8. For part \\( \\mathrm{c} \\), change the value in cell D17 to 25 and solve the LP problem. Case Study: A renowned chocolatier, Francesco Schreder, makes three kinds of chocolate confectionery: artisanal truffles, handcrafted chocolate nuggets, and premium gourmet chocolate bars. He uses the highest quality of cacao butter, dairy cream, and honey as the main ingredients. Francesco makes his chocolates each morning, and they are usually sold out by the early afternoon. For a pound of artisanal truffles, Francesco uses 1 cup of cacao butter, 1 cup of honey, and 1/2 cup of cream. The handcrafted nuggets are milk chocolate and take 1/2 cup of cacao, \\( 2 / 3 \\) cup of honey, and 2/3 cup of cream for each pound. Each pound of the chocolate bars uses 1 cup of cacao butter, 1/2 cup of honey, and \\( 1 / 2 \\) cup of cream. One pound of truffles, nuggets, and chocolate bars can be purchased for \\( \\$ 35 \\), \\( \\$ 25 \\), and \\( \\$ 20 \\), respectively. A local store places a daily order of 10 pounds of chocolate nuggets, which means that Francesco needs to make at least 10 pounds of the chocolate nuggets each day. Before sunrise each morning, Francesco receives a delivery of 50 cups of cacao butter, 50 cups of honey, and 30 cups of dairy cream. Step 1: Create an Excel spreadsheet to formulate and solve the linear programming model that maximizes revenue given the constraints. See the Module 7 Assignment Instructions document (available in Canvas) for a step-by-step guide to setting up your spreadsheet. Step 2: Address the following in a Microsoft Word document: A. How much of each chocolate product should Francesco make each morning? B. What is the maximum daily revenue that he can make? C. Report the shadow price and the range of feasibility of each binding constraint. D. If the local store increases the daily order to 25 pounds of chocolate nuggets, how much of each product should Francesco make