A company manufactures its most popular product at three plants.Four major retail customers demand this product.The cost of producing one unit of the product at each plant and shipping it to each of the customers is given in the spreadsheet.Moreover, the fixed (setup) cost of production at each plant, capacity of each plant, and the demand of each customer are also provided in this file.The company wants to determine the least-cost method for meeting the demands of their four customers.Formulate and solve an appropriate integer programming model in the spreadsheet.

C D E F G H I J K L To Fixed charges for production Customer 1 Customer 2 Customer 3 Customer 4 Setup cost Capacity 10 Network formulation Flow balance constraints 11 Origin' Destination' Unit cost Flow Capacity constraints 12 1 1 580 Plant Outow Effective capacity Operate plant? 13 1 2 $60 1 14 1 3 $100 2 15 1 4 $90 3 16 2 1 $70 1? 2 2 $100 Demand constraints 18 2 3 5110 Customer Inflow Demand 19 2 4 $50 1 20 3 1 $100 2 21 3 2 $90 3 22 3 3 $160 4 23 3 4 $50 24 25 26 2? Shipping cost 28 Set up cost 29 Total Cost 30