Given the following information, complete the Solver form on the next page for a Multiple-Objective, Linear Programming model using the MINIMAX OBJECTIVE

Blue Ridge Hot Tubs makes two types of SPA X1 and X2. For accounting purposes, Blue Ridge has a monthly production cycle. Blue Ridge earns the following profit for each type of tub it sells $350 on each X1 and $300 on every X2. Blue Ridge wants to maximize profit. It earned a profit of $64,000 in the last production cycle and it would like to earn at least as much in the next production cycle. [Hint for target value t1].

To keep their plants running at an efficient level, Blue Ridge must produce at least 200 Hot Tubs in each production cycle.

The production of hot tubs requires a toxic resin that must be minimized to keep government regulators happy. The X1 hot tub requires 15 pounds of the toxic resin and the X2 requires 10 pounds of this resin. In the last production cycle, Blue Ridge generated 2800 pounds of toxic resin and blue ridge hopes to keep to this target this year [Hint for target value t2].

X1 requires 9 hours of labor per unit and X2 requires 6 hours. There will be 1566 hours of labor

X1 requires 12 feet of tubing per unit and X2 requires 16 feet. There will be 2880 feet of tubing available.

US Auto has identified two different objectives that apply to this problem: they can maximize profit or minimize toxic resin.

WRITE OUT THE FORMULA THAT SHOULD BE IN CELL F9 1 2 & 4 & Number to make: b Weighted 7 |Goals: Target e| % Deviation |Weights| Deviation 8 | Profit per unit $350 $64,000 1 1 $64,000 9 | Pollution per unit 15 2800 -1 1 -2800 10 11 |Constraints: Available 12 | Pumps Required 1 200 13 | Labor Required 1566 14 | Tubing Required 12 2880 15 16 |MiniMax Objective: 0 17 Part 1: Write formula for the F? cell on the previous page. Part 1: Write formula for the F9 cell on the previous page. Part 2: Complete the Objective Cell block, check Max or Min, then complete the Changing cell block, and the Constraints block using the cell addresses from the spreadsheet. Solver Parameters X Set Objective: To: Max Min O Value Of: 0 By Changing Variable Cells: 5 Subject to the Constraints: Add Change