Q. A producer of pleasure boats wants to maximize revenue during next month. Two types of boats are sold, x1 also x2. Type x1 sells for $40,000 also type x2 sells for $30,000. x1 boats require 10 weeks of labour also 600 board feet of lumber each. x2 boats need 3 weeks of labour also 1,000 board feet of lumber. There are 30 weeks of labour also 3,000 board feet of lumber available this season. Because of desire to avoid ending up with uncompleted boats, manager has specified that only integer solutions will be accepted. Use Excel to obtain optimal solution using solver.