Question 1. Product Mix Problem Lakeside Boatworks is planning to manufacture three types of molded berglass recreational boats: a shing [bassj boat, a ski boat, and a small speedboat The estimated selling price and variable cost for each type of boat are summarized in the following table: The company has incurred xed costs of $2,30 to set up its manufacturing operations and begin production. Lakeside has also entered into agreements with several boat dealers in the region to provide a minimum of WI] bass boats, 50 slci boatsI and 50 speedboats. Alternatively, the company is unsure of what the actual demand will be, so it has decided to limit production to no more than 120 of any one boat. The company wants to determine the number of boats that it must sell to break even while minimizing its total variable cost. a. Formulate a linear programming model for this problem. b. Solve the model by using the Excel Solver