id:18-0350

For doing this assignment, first you need to study the lecture of Location-allocation problem with excel file (Prb 6-39_CoolAire). As you see we designed a 2-stage logistics networks for coolAire company including plants, 4 warehouse, and customers . Therefore, you are tasked to design a similar logistics network with different parameters and number of nodes (plants warehouse, and customers to have different networks and prevent cheating, each student is expected to change the number of elements in the required sets of plants, warehouse and customers in the interval (3-9) using your student ID. Although you can use similar values for parameters as you can see in the lectures slight modifications are needed. For submitting this signment you should submit 2 Miles: 1) one word file where you formulate the model by introducing parameters, variables, objective functions and constraints similar definition are required as you see in lecture and depicting cel solution in same word nie by drawing a schematic network of nodes and flows 2 Worksheet model (Excel). No excuse is acceptable for last second issue in Excel file Pb 6 39 CoolAire (1) - Excel Data View Tell me what you want File Insert Page Layout Formules Xin - 10 -AA Copy- BIU. Format Paint Ciptar Yon Normal C.S. Conditional Format as Good Formatting Table 129 f -SG534H20-629 $50 300 A D G H 3 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Fured Cost By changing 819 E24H19 H24 4 Plant 1 $700 $1.000 5900 $1.200 $55.000 B28 F31 H28 31 5 Plant 2 $800 $500 $600 $700 Subject to: 119 1240 Plant 3 $850 $40,000 $600 $700 G28.631825 E25 $500 $65.000 7 128 1310 Plant 4 $600 $800 $500 5600 $50.000 B32 F32833 F33 8 Plant 5 $500 $600 $450 5700 9 B19 E20 Plant 6 $42.000 $700 $600 $750 $500 B28 F310 $40.000 10 H19 24 H28 H31 binary 11 Customer 1 Customer 2 Customer Customer Customer 5 Fixed Cost 12 Warehouse 1 $40 $80 $60 $90 $50 $40.000 13 Warehouse 2 $60 $50 $75 $40 $35 14 Warehouse 3 $50.000 $55 $40 565 $60 $80 15 Warehouse 4 $80 $30 $35,000 $80 $60 $60,000 18 17 18 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Plant 1 Shipped 19 Capacity Build? extra plant capacity 0.0 00 0.0 00 0.0 20 Plant 2 0.0 0.0 0.0 0.0 50.0 50.0 200 1.0 21 Plant 3 0.0 0.0 00 150.0 300.0 22 Plant 4 300 0.0 300.0 1.0 0.0 0.0 0.0 0.0 0.0 23 250 00 Plant 5 0.0 0.0 350.0 0.0 350.0 350 Plant 1.0 0.0 0.0 0.0 00 400.0 400.0 400 25 Received 0.0 10 00 0.0 400.0 7000 26 27 Customer 1 Customer 2 Customers Customer 4 Customers 28 Warehouse 1 Shipped Build? warehouse opening 0.0 0.0 0.0 29 Warehouse 2 0.0 0.0 0.0 0.0 0,0 0.0 0.0 0.0 30 Warehouse 3 0.0 200.0 0.0 200.0 0.0 0.0 0.0 31 Warehouse 4 0.0 400 300.0 1.0 0.0 1500 700,0 2500 32 700 Received 200.0 10 300.0 1000 33 200.0 1500 12500 Demand 200 300 200 34 150 250 35 Plant to Warehouse total derud 1100 $ 537,500.00 36 Warehouse to Customer $ 55,500.00 37 Plant Fued Costs $ 167 000.00 38 Warehouse Foxed Costs $ 95,000 00 39 Total Costs $ 855.000.00 40 F Logistics Analysis Type here to search E For doing this assignment, first you need to study the lecture of Location-allocation problem with excel file (Prb 6-39_CoolAire). As you see we designed a 2-stage logistics networks for coolAire company including plants, 4 warehouse, and customers . Therefore, you are tasked to design a similar logistics network with different parameters and number of nodes (plants warehouse, and customers to have different networks and prevent cheating, each student is expected to change the number of elements in the required sets of plants, warehouse and customers in the interval (3-9) using your student ID. Although you can use similar values for parameters as you can see in the lectures slight modifications are needed. For submitting this signment you should submit 2 Miles: 1) one word file where you formulate the model by introducing parameters, variables, objective functions and constraints similar definition are required as you see in lecture and depicting cel solution in same word nie by drawing a schematic network of nodes and flows 2 Worksheet model (Excel). No excuse is acceptable for last second issue in Excel file Pb 6 39 CoolAire (1) - Excel Data View Tell me what you want File Insert Page Layout Formules Xin - 10 -AA Copy- BIU. Format Paint Ciptar Yon Normal C.S. Conditional Format as Good Formatting Table 129 f -SG534H20-629 $50 300 A D G H 3 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Fured Cost By changing 819 E24H19 H24 4 Plant 1 $700 $1.000 5900 $1.200 $55.000 B28 F31 H28 31 5 Plant 2 $800 $500 $600 $700 Subject to: 119 1240 Plant 3 $850 $40,000 $600 $700 G28.631825 E25 $500 $65.000 7 128 1310 Plant 4 $600 $800 $500 5600 $50.000 B32 F32833 F33 8 Plant 5 $500 $600 $450 5700 9 B19 E20 Plant 6 $42.000 $700 $600 $750 $500 B28 F310 $40.000 10 H19 24 H28 H31 binary 11 Customer 1 Customer 2 Customer Customer Customer 5 Fixed Cost 12 Warehouse 1 $40 $80 $60 $90 $50 $40.000 13 Warehouse 2 $60 $50 $75 $40 $35 14 Warehouse 3 $50.000 $55 $40 565 $60 $80 15 Warehouse 4 $80 $30 $35,000 $80 $60 $60,000 18 17 18 Warehouse 1 Warehouse 2 Warehouse 3 Warehouse 4 Plant 1 Shipped 19 Capacity Build? extra plant capacity 0.0 00 0.0 00 0.0 20 Plant 2 0.0 0.0 0.0 0.0 50.0 50.0 200 1.0 21 Plant 3 0.0 0.0 00 150.0 300.0 22 Plant 4 300 0.0 300.0 1.0 0.0 0.0 0.0 0.0 0.0 23 250 00 Plant 5 0.0 0.0 350.0 0.0 350.0 350 Plant 1.0 0.0 0.0 0.0 00 400.0 400.0 400 25 Received 0.0 10 00 0.0 400.0 7000 26 27 Customer 1 Customer 2 Customers Customer 4 Customers 28 Warehouse 1 Shipped Build? warehouse opening 0.0 0.0 0.0 29 Warehouse 2 0.0 0.0 0.0 0.0 0,0 0.0 0.0 0.0 30 Warehouse 3 0.0 200.0 0.0 200.0 0.0 0.0 0.0 31 Warehouse 4 0.0 400 300.0 1.0 0.0 1500 700,0 2500 32 700 Received 200.0 10 300.0 1000 33 200.0 1500 12500 Demand 200 300 200 34 150 250 35 Plant to Warehouse total derud 1100 $ 537,500.00 36 Warehouse to Customer $ 55,500.00 37 Plant Fued Costs $ 167 000.00 38 Warehouse Foxed Costs $ 95,000 00 39 Total Costs $ 855.000.00 40 F Logistics Analysis Type here to search E