A producer of pleasure boats wants to maximize revenue during the next season. Two types of boats are sold i.e. speedboat (X1) and pontoon (X2). The speedboat sells for RM40,000 and the pontoon sells for RM30,000. The speedboat takes 10 weeks to manufacture and the pontoon takes 3 weeks. One speedboat uses 600 meters of board and the pontoon uses 1000 meters of board. Each speedboat requires 500 square meters of fiberglass, while each pontoon requires 200 square meters of fiberglass. There are 30 weeks of labor, 3,600 meters of board, and 1,800 square meters of fiberglass available. Due to space constraints not more than 3 pontoons and not more than 4 speedboats can be made.

1. Formulate the LP model for this model with the non-negative constraints as Xi => 0

2. Develop this model in Excel and copy paste the model in your answer sheet showing the formulae clearly.

3. Solve this problem and recommend the optimal number of speedboats and pontoons to make and the maximum revenue.

4. Explain why answers proposed in (c) cannot be implemented by the producer of the boats.

5. Propose a better solution to the producer of the boats that can be implemented by the producer. State the number of speedboats and pontoons and revenue for this new proposal.

6. All balance materials at the end of the seasons will be sold as scrap at a price of RM10 per meter for board and RM12 per square meter for fiberglass. Calculate the value of scrap sold at the end of the season if proposal (e) is implemented.