part (a) solution is provided. Use Lingo program please :).

A company manufactures seven different products: A, B, C, D, E, F, and G. Each product can be manufactured using two types of machines: M1 and M2. In addition, each product is made from three different raw materials RM1, RM2, and RM3. Moreover, the demand of: (1) product A should be at least 200 units, (ii) products B and E is limited to 800 and 400, respectively, and (iii) remaining products is unlimited. Relevant data is given in the table below. Item input in units) to make one unit of Item Max availability B F G per day RM1 RM2 RM3 M1-time (hours) M2-time (hours) Profit (5/unit) A 0.1 0.1 0.1 0.04 0.02 0.2 0.4 0.1 0.03 0.04 14 0.3 0.3 0.1 0.04 0.02 D 0.3 0.1 0.1 0.01 0.05 20 E 0.2 0.1 0.1 0.03 0 0.2 0.4 0.1 0.02 0.02 17 0.2 0.2 0.2 0.02 0.04 20 600 650 550 80 70 12 9 16 Decision Variables: Assume that, Number of product A = A Number of product B=B Number of product C = C Number of product D=D Number of product E = E Number of product F=F Number of product G = G Objective function: Objective is to maximize Profit. Hence, Maximize Profit = Maximize Z = 12A + 14B + 9C + 20D + 16E + 17F +20G Constraints: Constraint for Row Material 1 (RM1), 0.1A +0.2B + 0.3C + 0.3D +0.2E +0.2F +0.26 = 200 Constraint for Product B, B = 0 Above LP model can be solved by using Excel solver as follows, b. Solve the formulated LP model in part a using one of the available software packages to obtain primal and dual optimum solutions