Supply chain management X is a final product. Three different parts of X such as A, B, C are obtained from suppliers. These parts are assembled in the factories of a company with multiple factories. The supply chain of the end product X until it reaches the customer is indicated in order : Suppliers -> Factories -> Distribution centers -> Customers The product tree is as follows: A (2 pieces) Part 1 B (1 piece) Part 2 C(3 pieces Part 3 Below are the tables that give shipping costs from suppliers to factories, from factories to distribution centers, and from distribution centers to customers: Suppliers Parts 2 6 Factories 3 5 1 4 7 6 4 5 1 4 6 3 2 3 4 5 6 & 6 5 8 2 7 2 3 1 in 4 6 8 3 2 5 6 3 3 3 7 4 6 Factories 1 4 Distribution Center 2 3 5 8 1 5 5 5 8 IC 8 2 8 6 3 4 7 4 5 4 4 3 5 3 5 3 5 5 6 6 8 3 Distribution Center Customers 2 1 7 3 5 6 + 2 3 5 7 3 4 6 7 6 4 5 5 4 61 6 5 Factory 1 The capacity and fixed costs of the factories and distribution centers are as follows: Capacity Fixed Cost 400 1800 2 550 900 3 490 2100 4 300 1100 5 500 900 Distribution Center Capacity Fixed Cost 1 1000 900 2 3 4 5 530 590 400 370 580 1600 1500 1400 Parts capacities of suppliers are as follows: Suppliers 1 1 Parts 2 650 730 490 1200 1350 880 3 1750 2350 1175 2 3 Customers' demands for the final product are as follows: Customers Demand 1 460 2 330 3 450 4 300 Project scope: Modeling using the 0-1 decision variable, taking into account the product movement from the suppliers to the end user (0-1 decision variable will be used to decide which factories and distribution centers to use) and the solution based on the given numerical values. (solution with excel solver) Supply chain management X is a final product. Three different parts of X such as A, B, C are obtained from suppliers. These parts are assembled in the factories of a company with multiple factories. The supply chain of the end product X until it reaches the customer is indicated in order : Suppliers -> Factories -> Distribution centers -> Customers The product tree is as follows: A (2 pieces) Part 1 B (1 piece) Part 2 C(3 pieces Part 3 Below are the tables that give shipping costs from suppliers to factories, from factories to distribution centers, and from distribution centers to customers: Suppliers Parts 2 6 Factories 3 5 1 4 7 6 4 5 1 4 6 3 2 3 4 5 6 & 6 5 8 2 7 2 3 1 in 4 6 8 3 2 5 6 3 3 3 7 4 6 Factories 1 4 Distribution Center 2 3 5 8 1 5 5 5 8 IC 8 2 8 6 3 4 7 4 5 4 4 3 5 3 5 3 5 5 6 6 8 3 Distribution Center Customers 2 1 7 3 5 6 + 2 3 5 7 3 4 6 7 6 4 5 5 4 61 6 5 Factory 1 The capacity and fixed costs of the factories and distribution centers are as follows: Capacity Fixed Cost 400 1800 2 550 900 3 490 2100 4 300 1100 5 500 900 Distribution Center Capacity Fixed Cost 1 1000 900 2 3 4 5 530 590 400 370 580 1600 1500 1400 Parts capacities of suppliers are as follows: Suppliers 1 1 Parts 2 650 730 490 1200 1350 880 3 1750 2350 1175 2 3 Customers' demands for the final product are as follows: Customers Demand 1 460 2 330 3 450 4 300 Project scope: Modeling using the 0-1 decision variable, taking into account the product movement from the suppliers to the end user (0-1 decision variable will be used to decide which factories and distribution centers to use) and the solution based on the given numerical values. (solution with excel solver)