Solve the below product mix problem using LINGO’s modeling language. The Weigelt Corporation has three branch plants with excess production capacity. Fortunately, the corporation has a new product ready to begin production, and all three plants have this capability, so some of the excess capacity can be used in this way. This product can be made in three sizes – large, medium, and small – that yield a net unit profit of $420, $360, and $300, respectively. Plants 1, 2 and 3 have the excess capacity to produce 750, 900 and 450 units per day of this product, respectively, regardless of the size or combination of sizes involved. The amount of available in-process storage space also imposes a limitation on the production rates of the new product. Plants 1, 2 and 3 have 13,000, 12,000, and 5,000 square feet, respectively, of in-process storage space available for a day’s production of this product. Each unit of the large, medium, and small sizes produced per day requires 20, 15 and 12 square feet, respectively. Sales forecasts indicate that if available, 900, 1,200, and 750 units of the large, medium, and small sizes, respectively, would be sold per day. At each plant, some employees will need to be laid off unless most of the plant’s excess production capacity can be used to produce the new product. To avoid layoffs if possible, management has decided that the plants should use the same percentage of their excess capacity to produce the new product. Management wishes to know how much of each of the sizes should be produced by each of the plants to maximize profit. This problem is similar to the cargo loading problem. The set of product sizes is analogous to the set of cargo types and the set of plants is analogous to the set of plane compartments. The variables are of course the number of units of each size made at each plant; for example Product(i,j) could be the number of units of sizej made in plant i. a) Develop a LINGO modeling language code that includes the data in the DATA section. It is helpful to edit the LINGO program for the cargo loading problem (see file cargo_loading.lg4). b) Repeat the above question but with data retrieval and storage from/to a spreadsheet. Construct a spreadsheet similar to cargo_ole_spreadsheet.xlsx and modify the data section of the model so that it takes the data from and stores the result in that spreadsheet after the LINGO model is executed. c) Provide the LINGO code for (a) and (b) above, the solution output in (a) and the excel spreadsheet in (b) with all information.