what is the constraint i would use?

this is the correct information

is of his Goal 4. Select cell G7. Use Goal Seek (Data tab i Forecast go you will need to pay off the loan if you pay $450.00 per month by setting cell G7 to this 450 and changing cell G6. Update the Loan Payoff Options table with the results of the Seek. 5. Use Goal Seek to determine how many months you would need to pay off the loan if $350.00 per month. Update the Loan Payoff Options table with the results of this Goals, Pay 6. Reduce the loan term to 42 months and record the monthly payment and total interest the Loan Payoff Options table. 7. If requested by your instructor, enter your name in cell 12. 8. Save the workbook Submit the revised workbook as specified by your instructor. 9. Use Goal Seek to determine the Monthly Payment and Months for the final option in Loan Payoff Options table, reducing the total interest paid to $2500. Which variable di choose to change? What other variable could you change to reach a total interest of S2.com Lab 2: Finding the optimal Product Mix Note: To complete this assignment, you will be required to use the Data Files. Please contact you instructor for information about accessing the Data Files. ProNem: Michaels Chocolates sells chocolates in single bars, 6-packs, and 12-packs to convenien and grocery stores. They are expanding to a national chain big box store where they have purchased 45 square feet of shelf space. They want to optimize the use of that shelf space to ensure that they showcase all three configurations of their product while maximizing profit as best they can Table 9-4 shows the pertinent information for the three product configurations. Table 9-4 Michaels Chocolates Information Item Profit per Item Single bars 0.08 6-packs 0,45 12-packs 0.88 Square Feet per Item 0.0625 0.4 0.75 Display Constraints 50 maximum 30 minimum 30 minimum Perform the following tasks: 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. 3. Use Solver to determine the mix of items that maximizes profit, subject to the constraints shown in Table 9-4. Use the Simplex LP option in Solver. Instruct Solver to create an Answer Report if it can find a solution to the problem. Save the scenario as Maximize Profit 1. (Hint: use the Save Scenario button in the Solver Results dialog box.) Rename the Answer Report containing the scenario as Maximize Profit 1. Figure 9-83 shows the values Solver should find. Formula Auditing, Data Validation and Complex Problem Solving em Solving Excel Module 9 EX Michaels Chocolates stock plan, Big Box Store Singles Packs 0.0625 Prir per em $0. e Taken in Square Feet 10 .Paci 04 al Number of Each Item 50 Teal Profit per Item $4.00 $13.50 Space per om in Square Feet Figure 9-83 If the company decides to set the maximum number of 12-packs at 30, how would this affect the mix of items? Use Solver to determine the new mix. Instruct Solver to create an Answer Report if it can find a solution to the problem. Save the scenario as Maximize Profit 2, and rename the Answer Report containing the scenario as Maximize Profit 2. 5. Create a Scenario Summary showing the two scenarios you saved in the Scenario Manager. 6. If requested by your instructor, change the name of the store in cell A2 from Big Box Store to Store, where is the name of the street you lived on in high school. 1. Save the workbook. Submit the workbook as specified by your instructor. 2. What changes would you sugg changes would you suggest to the company to maximize profit, other than raising ** How could you use scenarios to make your point ab 3: Consider This: Your Turn Id problem-solving skills to design and implement a 10 VAA Ge of Cut De Copy aste Format Painter Clipboard VES Wrap Text Merge & Center - $ Alignment Michaels Chocolates Stock Plan, Big Box Store Singles 6-Packs 12-Packs 5 Profit per Item $0.45 $0.88 6 Space Taken in Square Feet 0.0625 0.4 0.75 3 Optimal Number of Each Item 5030 10 Total Profit per Item $4.00 11 Total Space per Item in Square Feet233 $13.50 12 Totals $43.90 38 $26.40 23 0 Michaels Chocolates