[Solution Library] A producer of pleasure boats wants to maximize revenue during the next month. Two types of boats are sold, xi and x2. Type x, sells for
Question: A producer of pleasure boats wants to maximize revenue during the next month. Two types of boats are sold, xi and x2. Type x, sells for $40,000 and type x2 sells for $30,000. The x, boats require 10 weeks of labor and 600 board feet of lumber each. The x2 boats need 3 weeks of labor and 1,000 board feet of lumber. There are 30 weeks of labor and 3,000 board feet of lumber available this season. Because of the desire to avoid ending up with uncompleted boats, the manager has specified that only integer solutions will be accepted. Use Excel to obtain the optimal solution.
Deliverable: Word Document 