Formulate on paper and solve in excel.

Consider a supplier order allocation problem under multiple sourcing, where it is required to buy 2000 units of a certain product from three different suppliers. The fixe set-up cost (independent of the order quantity), variable cost (unit price), and the maximum capacity of each supplier are given in the following table (two suppliers offer quantity discounts). The objective is to minimize the total cost of purchasing (fixed plus variable cost). Formulate this as a linear integer programming problem. You must define all your variables cle arly, write out the constraints to be satisfied with a brief explanation of each and develop the objective function Formulate under the assumption that both suppliers 1 and 3 offer "all units" discount, as described in the following: supplier 1 charges $10/unit for orders up to 300 units and for orders more than 300 units, the entire order will be priced at $7/unit. Supplier 3 charges $6/u for orders up to 500 units and for orders more than 500 units, the entire order is priced at $4/unit. Supplier Fixed Cost Capacity Unit price $100 600 units $10/u for up to 300 units $7/u entire order for more than 300 units $2/unit for all 800 units $6/unit for up to 500 units $4/unit entire order for more than 700 units $500 800 units $300 1200 units