Answer for question d and e

MIDI Transport is to move goods from two factories to three distribution centers at minimum costs. The supply from factories A and B are 30 units and 20 units respectively. The demand from distribution centers P. Q and Rare 25 units, 15 units and 10 units respectively. Transport costs are shown in the Table 1 Table 1: Transport Cost Transport Costin RM P Q R 7 8 10 5 A (a) Develop the linear programming model. (use the Xij notation to define your variables) (4 marks (b) Develop the excel model for this problem and copy paste the model in your answer sheet showing the formule clearly (4 marks) (c) Fill up table 2 below showing clearly the quantities transported from each factory to each distribution centers and the minimum total transportation costs. Table 2 Quantity Shipped P Q R A B Total Transportation costs (2 marks) Page 3 of PEB 27303 MANAGEMENT SCIENCE PXB20203 MANAGEMENT SCIENCE JANUARY 2020 CONFIDENTIAL (d) Route BR can only handle a maximum weight of 10 units. Write the new LP model for this new problem and solve this problem. Fil table 3 below with the quantity shipped and the total transportation cost Table 3 Quantity Shipped P 0 R B Total transportation costs (7 marks) (e) If the values given in Table 1 are profit per unit, what will be the optimal profit? Question 2 MIDI Transport is to move goods from two factories to three distribution centers at minimum costs. The supply from factories A and B are 30 units and 20 units respectively. The demand from distribution centers P. O and Rare 2 units. 15 units and 10 units respectively. Transport costs are shown in the Table 1. Table 1: Transport Cost Transport Cost in 1497 a) Develop the line programming model use the intation to define your variables) b) Develop the excel model for this problem and copy paste the model in your answer sheet showing the formule clearly (4 marks) (c) Flup table 2 below showing clearly the quantities transported from each factory to each distribution centers and the minimum total transportation costs Quantity Shipped P 10 R Total Transportation costs (2 marks] PEB 27385 MANAGEMENT SCIENCE PXB 20200 MANAGEMENT SCIENCE Page 317 JANUARY 2020 CONFIDENTIAL (d) Route BR can only handle a maximum weight of 10 units. Wite the new LP model for this new problem and solve this problem. Fillable 3 below with the quantity shipped and the total transportation cost Quantity Shipped P R A B Total transportation costs (7 marts le) the values given in Table 1 are profit per unit what will be the optimal profit? 3 mars MIDI Transport is to move goods from two factories to three distribution centers at minimum costs. The supply from factories A and B are 30 units and 20 units respectively. The demand from distribution centers P. Q and Rare 25 units, 15 units and 10 units respectively. Transport costs are shown in the Table 1 Table 1: Transport Cost Transport Costin RM P Q R 7 8 10 5 A (a) Develop the linear programming model. (use the Xij notation to define your variables) (4 marks (b) Develop the excel model for this problem and copy paste the model in your answer sheet showing the formule clearly (4 marks) (c) Fill up table 2 below showing clearly the quantities transported from each factory to each distribution centers and the minimum total transportation costs. Table 2 Quantity Shipped P Q R A B Total Transportation costs (2 marks) Page 3 of PEB 27303 MANAGEMENT SCIENCE PXB20203 MANAGEMENT SCIENCE JANUARY 2020 CONFIDENTIAL (d) Route BR can only handle a maximum weight of 10 units. Write the new LP model for this new problem and solve this problem. Fil table 3 below with the quantity shipped and the total transportation cost Table 3 Quantity Shipped P 0 R B Total transportation costs (7 marks) (e) If the values given in Table 1 are profit per unit, what will be the optimal profit? Question 2 MIDI Transport is to move goods from two factories to three distribution centers at minimum costs. The supply from factories A and B are 30 units and 20 units respectively. The demand from distribution centers P. O and Rare 2 units. 15 units and 10 units respectively. Transport costs are shown in the Table 1. Table 1: Transport Cost Transport Cost in 1497 a) Develop the line programming model use the intation to define your variables) b) Develop the excel model for this problem and copy paste the model in your answer sheet showing the formule clearly (4 marks) (c) Flup table 2 below showing clearly the quantities transported from each factory to each distribution centers and the minimum total transportation costs Quantity Shipped P 10 R Total Transportation costs (2 marks] PEB 27385 MANAGEMENT SCIENCE PXB 20200 MANAGEMENT SCIENCE Page 317 JANUARY 2020 CONFIDENTIAL (d) Route BR can only handle a maximum weight of 10 units. Wite the new LP model for this new problem and solve this problem. Fillable 3 below with the quantity shipped and the total transportation cost Quantity Shipped P R A B Total transportation costs (7 marts le) the values given in Table 1 are profit per unit what will be the optimal profit? 3 mars