SOLVE IT USING EXCEL DATA SOLVER LINEAR PROGRAMMING AND WRITE DOWN CONSTRAINTS

Problem 7 A firm producing a single product has three plants and four customers. The three plants will produce 2800, 2000 and 2700 units, respectively, during the next time period. The firm has made a commitment to sell 2400 units to customer 1, 2350 units to customer 2, and at least 690 units to customer 3. Both customers 3 and 4 also want to buy as many of the remaining units as possible. The profit associated with shipping a unit from plant i to customerj is given in the table below. From Plant 1 Plant 2 Plant 3 1 50 40 30 To Customer () 2 3 50 40 25 45 35 4 40 30 40 40 What is the maximal profit which the company can achieve using an optimal transportation plan