I JUST NEED HELP WITH PART C FOR THE FORMULAS TO BE ENTERED

30. Go to the Premiums worksheet, which lists data about premiums Flamingo Guitars occasionally offers to include an accessory along with the sale of three types of deluxe guitars. The company wants to keep the total costs low when running the premium offers. Isabella wants to know how many premiums to offer of each type to minimize C. Determine and enter the constraints based on the information provided in Table 2. Use Simplex LP as the solving method to find a global optimal solution. d. Hill Table 2: Solver Constraints Cell or Range B7:07 Constraint The company offers at least one premium per category The number of premiums is an integer The company offers up to 3 premiums in the Premium 1 category The company offers up to 3 premiums in the Premium 2 category The company offers up to 3 premiums in the Premium 3 category The company offers at least 5 premiums per year B7:07 Premium_1 (cell B7) Premium_2 (cell C7) Premium_3 (cell D7) E7 E f G H Premium Analysis Nm 1 FLAMINGO GUITARS 2 Premium 1 Premium 2 Premium 3 3 Prospects per premium 500 450 600 4 Cost per premium $ 724.99 $ 726.99 $ 729.99 5 Cost per prospect $ 1.45 $ 1.62 $ 1.22 6 7 Premiums offered 8 Total prospects 9 Total cost $ 10 Conversion rate: 11 Number of sales: Totals $ 20% 12 13 14 30. Go to the Premiums worksheet, which lists data about premiums Flamingo Guitars occasionally offers to include an accessory along with the sale of three types of deluxe guitars. The company wants to keep the total costs low when running the premium offers. Isabella wants to know how many premiums to offer of each type to minimize C. Determine and enter the constraints based on the information provided in Table 2. Use Simplex LP as the solving method to find a global optimal solution. d. Hill Table 2: Solver Constraints Cell or Range B7:07 Constraint The company offers at least one premium per category The number of premiums is an integer The company offers up to 3 premiums in the Premium 1 category The company offers up to 3 premiums in the Premium 2 category The company offers up to 3 premiums in the Premium 3 category The company offers at least 5 premiums per year B7:07 Premium_1 (cell B7) Premium_2 (cell C7) Premium_3 (cell D7) E7 E f G H Premium Analysis Nm 1 FLAMINGO GUITARS 2 Premium 1 Premium 2 Premium 3 3 Prospects per premium 500 450 600 4 Cost per premium $ 724.99 $ 726.99 $ 729.99 5 Cost per prospect $ 1.45 $ 1.62 $ 1.22 6 7 Premiums offered 8 Total prospects 9 Total cost $ 10 Conversion rate: 11 Number of sales: Totals $ 20% 12 13 14