Question 2 (25 marks) While Company ABC involves both in manufacturing process and retail service, their products are always stored in two warehouses before shipped to three retail outlets. Shipping Cost Shipping Capacity From To Output Warehouse A Warehouse B Warehouse A Warehouse B 200 360 125 175 300 Factory A Factory B Table 2a. 320 270 150 200 200 shipping cost (in dollars) and capacity (in units) to each warehouse, monthly output from each factory Shipping Cost Shipping Capacity From To Outlet A Outlet B Outlet C Outlet A Outlet B Outlet C Warehouse A 470 505 490 100 150 100 Warehouse B 390 410 440 125 150 75 Demand 175 200 125 175 200 125 Table 2b. shipping cost (in dollars) and capacity (in units) to each retail outlet, monthly demand to each customer According to Table 2a and 2b, you are required to: (a) Formulate a distribution network which aims at minimizing the total shipping cost up from factories down to outlets, (b) Draw the network represent this distribution problem and indicate/ label all information needed for this distribution network. (c) Solve the formulated model with a spreadsheet. Question 2 (25 marks) While Company ABC involves both in manufacturing process and retail service, their products are always stored in two warehouses before shipped to three retail outlets. Shipping Cost Shipping Capacity From To Output Warehouse A Warehouse B Warehouse A Warehouse B 200 360 125 175 300 Factory A Factory B Table 2a. 320 270 150 200 200 shipping cost (in dollars) and capacity (in units) to each warehouse, monthly output from each factory Shipping Cost Shipping Capacity From To Outlet A Outlet B Outlet C Outlet A Outlet B Outlet C Warehouse A 470 505 490 100 150 100 Warehouse B 390 410 440 125 150 75 Demand 175 200 125 175 200 125 Table 2b. shipping cost (in dollars) and capacity (in units) to each retail outlet, monthly demand to each customer According to Table 2a and 2b, you are required to: (a) Formulate a distribution network which aims at minimizing the total shipping cost up from factories down to outlets, (b) Draw the network represent this distribution problem and indicate/ label all information needed for this distribution network. (c) Solve the formulated model with a spreadsheet