Chegg Home Expert Q&A My solutions These factories distribute three (3) products to their key customers (5 retailers) directly as well as through four (4) warehouses. Formulate and solve a linear programming model for the data set (given in a separate Excel file) to produce the optimal distribution cost of the product. Provide a critical evaluation of the model and the results obtained. Develop your optimisation model further by incorporating additional constraint of carbon tax on transportation of products and find the new optimal solution. Explain your approach. Assume data logically, where required. 2 5 Route: Factories to Warehouses 6 7 Factory 1 Product 1 Warehouse 1 1.30 Warehouse 2 1.20 Warehouse 3 Warehouse 4 0.75 0.50 Total Factory Capacity Factory 1 Product 1 Product 2 Units 50000 47500 Total customer demand Retailer 1 Product 1 Product 2 10000 7500 8 Product 2 2.00 2.20 2.50 3.00 Product 3 47500 Product 3 10000 9 Product 3 0.80 1.20 0.50 0.50 10 Factory 2 Product 1 11 Factory 2 Product 1 1.50 37500 Retailer 2 Product 1 27500 1.55 200 3.00 Product 2 30000 Product 2 12500 12 Product 2 2.40 2.60 2.00 1.75 Product 3 30000 Product 3 22500 13 Product 3 3.00 3.50 2.00 2.80 T 14 Factory 3 15 Factory 3 Product 1 0.95 0.75 0.50 0.50 16 Product 2 0.50 0.50 0.50 0.50 Product 1 Product 2 Product 3 100000 97500 100000 Retailer 3 Product 1 25000 Product 2 25000 Product 3 25000 17 Product 3 0.70 0.70 0.70 0.70 78 Retailer 4 Product 1 32500 19 Route: Factories to Relailers 20 Retailer 1 Retailer 2 Retailer 3 Retailer 4 Retailer 5 Warehouse Capacity Warehouse 1 Product 1 Units Product 2 32500 32500 Product 3 35000 21 Factory 1 Product 1 3.50 4.00 5.00 3.75 4.00 Product 2 32500 22 Product 2 4.50 5.00 3.75 4.00 E3 80 Product 3 32500 Retailer 5 Product 1 27500 23 Product 3 5.00 5.50 3.75 4.25 4.00 Product 2 27500 24 Warehouse 2 Product 1 25000 Product 3 30000 25 Factory 2 Product 1 5.00 5.50 6.00 4.75 3.75 Product 2 25000 26 Product 2 6.00 7.00 6.00 5.75 5.75 Product 3 25000 27 Product 3 5.80 6.00 5.80 6.50 5.00 28 Warehouse 3 Product 1 20000 29 Factory 3 Product 1 6.50 8.00 5.30 5.00 6.20 Product 2 20000 30 Product 2 5.50 5.50 5.50 5.50 5.50 Product 3 20000 31 Product 3 6.00 6.00 6.00 6.00 6.00 32 Warehouse 4 Product 1 32500 33 Route: Warehouses to Retailers Product 2 32500 34 Retialer 1 Relialer 2 Relialer 3 Retialer 4 Relialer 5 Product 3 32500 35 Warehouse 1 Product 1 2.30 3.00 4.20 3.00 125 36 Product 2 2.20 3.00 2.50 2.80 3.00 37 Product 3 4.00 3.20 5.00 3.20 400 38 39 Warehouse 2 Product 1 2.50 2.50 3.00 2.80 3.00 40 Product 2 3.20 3.50 3.20 3.20 4.00 41 Product 3 5.00 4.00 3.80 210 195 Skip question Start Solving Exit C Guide Me Notification