Homework answers / question archive / How do i write the constraints for this? a

How do i write the constraints for this? a

MS Excel

Share With

How do i write the constraints for this? a. Use the total cost of the premiums (cell E9, named Total_cost) as the objective cell in the Solver model, with the goal of minimizing the value. b. Use the number of premiums offered (range B7:D7) as the changing variable cells. c. Determine and enter the constraints based on the information provided in Table 2. d. Use Simplex LP as the solving method to find a global optimal solution. e. Solve the model, keeping the Solver solution. Table 2: Solver Constraints Constraint Cell or Range The company offers at least one premium per category B7:D7 The number of premiums is an integer B7:D7 The company offers up to 3 premiums in the Premium 1 category Premium_1 (cell B7) The company offers up to 3 premiums in the Premium 2 category Premium_2 (cell C7) The company offers up to 3 premiums in the Premium 3 category Premium_3 (cell D7) The company offers at least 5 premiums per year E7