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 1 2 Factories 3 5 1 5 6 4 7 6 4 5 1 4 6 3 4 2 3 1 2 3 1 5 7 & 6 2 6 6 5 5 3 5 8 5 8 4 6 5 3 2 3 7 4 4 6 6 3 Factories 4 1 5 8 Distribution Center 2 3 5 8 1 8 5 5 8 2 6 3 4 7 4 5 4 4 3 5 3 5 3 5 5 6 6 8 3 Distribution Center 1 7 2 3 5 7 3 4 Customers 2 3 + 5 + 6 5 5 6 61 5 4 6 7 6 4 7 Factory The capacity and fixed costs of the factories and distribution centers are as follows: Capacity Fixed Cost 1 400 1800 2 550 900 3 490 2100 4 300 1100 5 500 900 Distribution Center Capacity Fixed Cost 1000 1 2 3 900 530 590 400 370 580 1600 1500 4 5 1400 Parts capacities of suppliers are as follows: Parts Suppliers 1 1 2 2 3 1200 1350 880 2 650 730 490 3 1750 2350 1175 Customers' demands for the final product are as follows: Customers Domand 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)