35 $0 | 71% 19:27 1 f MS101 KCC WKEN... a) Formulate a linear programming model for solving the problem. CR(8) The model above was solved using Solver software and part of the output is shown below. Use it to answer the questions that follow. Original Value 0 0 0 1 Final Value 0 0 1 Cell Name SCS4 A region $D$4 A region 2 SES4 A region 3 $F$4 A region 4 $G$4 A regions $H$4 A region 6 SCSS Bregion 1 0 0 0 0 0 0 0 0 0 7 1 I 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $D$5 B region 2 $ES5 B region 3 $F$5 Bregion 4 $G$5 B region 5 SH$5 B region 6 $CS6 C region 1 $D$6 C region 2 SES6 C region $F$6 C region 4 $G$6 C region 5 $H$6 C region 6 SCS7 D region 1 $D$7 D region 2 SES7 D region 3 $F$7 D region 4 $G$7 D region 5 $H$7 D region 6 SCS8 E region ! $D$8 E region 2 SESS E region 3 $F$8 E region 4 $G$8 E region 5 SH$8 E region 6 1 0 0 0 1 0 0 0 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 b) Management have asked you to determine the optimal assignment rule. Write your answer in a form of a report to be submitted to the management. EV (7) c) Advice the management about objective function value corresponding to you in. EV (5) d) Explain to the management the reason why some of the regions cannot be as EV (5) TOTAL 1251 D 35 $0 | 71% 19:27 1 f MS101 KCC WKEN... a) Formulate a linear programming model for solving the problem. CR(8) The model above was solved using Solver software and part of the output is shown below. Use it to answer the questions that follow. Original Value 0 0 0 1 Final Value 0 0 1 Cell Name SCS4 A region $D$4 A region 2 SES4 A region 3 $F$4 A region 4 $G$4 A regions $H$4 A region 6 SCSS Bregion 1 0 0 0 0 0 0 0 0 0 7 1 I 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $D$5 B region 2 $ES5 B region 3 $F$5 Bregion 4 $G$5 B region 5 SH$5 B region 6 $CS6 C region 1 $D$6 C region 2 SES6 C region $F$6 C region 4 $G$6 C region 5 $H$6 C region 6 SCS7 D region 1 $D$7 D region 2 SES7 D region 3 $F$7 D region 4 $G$7 D region 5 $H$7 D region 6 SCS8 E region ! $D$8 E region 2 SESS E region 3 $F$8 E region 4 $G$8 E region 5 SH$8 E region 6 1 0 0 0 1 0 0 0 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 b) Management have asked you to determine the optimal assignment rule. Write your answer in a form of a report to be submitted to the management. EV (7) c) Advice the management about objective function value corresponding to you in. EV (5) d) Explain to the management the reason why some of the regions cannot be as EV (5) TOTAL 1251 D