The Managing Director of Koala Supermarket is faced with the problem of assigning five senior managers to six regions. From past experience, he knows that the efficiency of the sales and operating cost, depends on manager-region combination. The sales (in GH) recorded under the different managers are given below: Manager Region 123456 A 739187827880 B 818569767485 C 757283847891 D 939686918382 E 939179896976 EV(10 marks) [Total: 25 Marks] 3 B. (i) Formulate a linear programming model for solving the problem. The model above was solved using Solver software and part of the output is shown below. Use it to answer the questions that follow. Cell Name $C$ 4 A region1 $D $4 A region 2 $E$ 4 A region 3 $F$ 4 A region 4 $G $4 A region 5 $H $4 A region 6 $C$ 5 B region 1 $D $5 B region 2 $E$ 5 B region 3 $F$ 5 B region 4 $G $5 B region 5 $H $5 B region 6 $C$ 6 C region 1 Original Value Final Value 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 AN(5 marks ) 4 $D $6 $E$ 6 $F$ 6 $G $6 $H $6 $C$ 7 $D $7 $E$ 7 $F$ 7 $G $7 $H $7 $C$ 8 $D $8 $E$ 8 $F$ 8 $G $8 $H $8 (i) (ii) C region 2 C region 3 C region 4 C region 5 C region 6 D region 1 D region 2 D region 3 D region 4 D region 5 D region 6 E region 1 E region 2 E region 3 E region 4 E region 5 E region 6 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 1 1 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 AN(5 marks) AP(5 marks) Management have asked you to determine the optimal assignment rule. Write your answer in a form of Memo to be submitted to the management. Advice the management about objective function value corresponding to your answer in (i) 5 (iii) Explain to the management the reason why some of the regions cannot be assigned