S Save the workbook. Submit the re Use Goal Seek to determine the Monthly Payment and oan Payoff Mot ao Options table, reducing the total interest paid to $2500. Which variable did you o change? What other variable could you change to reach a total interest of $2,500 o, Lab 2: Finding the Optimal Product Mix instructor for information about accessing the Data Files. and grocery stores complete this assignment, you will be required to use the Data Files. Please contact vo Michaels Chocolates sells chocolates in single bars, 6-packs, and 12-packs to conven three configurations of their product while maximizing profit as best they can. hey are expanding to a national chain big box store where they have square feet of shelf s showcase all eice. Ihey want to optimize the use of that shelf space to ensure that thd able 94 shows the pertinent information for the three product configurations ace. T Item Profit per Item Square Feet per Item Display Constraints 0 0675 0 4 1. Open the workbook Lab 9.2 Michaels Chocolates from the Data Files and then save the workbook with the file name, Lab 9-2 Michaels Chocolates Complete 2. Enter the data in Table 9-4 into the worksheet to determine the mis of items that masimizes profit, subject to the constraints shown in Table 9-4. Use the Simples LP option in Solver. Instruct Solver to create an A Report if it can find a sol use the Save Scenario button in the Solver Results dialog box) Rename the Anower Report containing the scenario as Maximize Profit 1.Figure 9-83 shows the values Solver should ution to the problem. Save the scenario as Maximize Profie 1.Hin find. S Save the workbook. Submit the re Use Goal Seek to determine the Monthly Payment and oan Payoff Mot ao Options table, reducing the total interest paid to $2500. Which variable did you o change? What other variable could you change to reach a total interest of $2,500 o, Lab 2: Finding the Optimal Product Mix instructor for information about accessing the Data Files. and grocery stores complete this assignment, you will be required to use the Data Files. Please contact vo Michaels Chocolates sells chocolates in single bars, 6-packs, and 12-packs to conven three configurations of their product while maximizing profit as best they can. hey are expanding to a national chain big box store where they have square feet of shelf s showcase all eice. Ihey want to optimize the use of that shelf space to ensure that thd able 94 shows the pertinent information for the three product configurations ace. T Item Profit per Item Square Feet per Item Display Constraints 0 0675 0 4 1. Open the workbook Lab 9.2 Michaels Chocolates from the Data Files and then save the workbook with the file name, Lab 9-2 Michaels Chocolates Complete 2. Enter the data in Table 9-4 into the worksheet to determine the mis of items that masimizes profit, subject to the constraints shown in Table 9-4. Use the Simples LP option in Solver. Instruct Solver to create an A Report if it can find a sol use the Save Scenario button in the Solver Results dialog box) Rename the Anower Report containing the scenario as Maximize Profit 1.Figure 9-83 shows the values Solver should ution to the problem. Save the scenario as Maximize Profie 1.Hin find