A. The Managing Director of Shoprite Company 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 1 2 3 4 5 6 A 73 91 87 82 78 80 B 81 85 69 76 74 85 C 75 72 83 84 78 91 D 93 96 86 91 83 82 E 93 91 79 89 69 76 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. Cell Name Original Value Final Value $C$4 A region1 0 0 $D$4 A region 2 0 0 $E$4 A region 3 1 1 $F$4 A region 4 0 0 $G$4 A region 5 0 0 $H$4 A region 6 0 0 $C$5 B region 1 0 0 8 $D$5 B region 2 1 1 $E$5 B region 3 0 0 $F$5 B region 4 0 0 $G$5 B region 5 0 0 $H$5 B region 6 0 0 $C$6 C region 1 0 0 $D$6 C region 2 0 0 $E$6 C region 3 0 0 $F$6 C region 4 0 0 $G$6 C region 5 0 0 $H$6 C region 6 1 1 $C$7 D region 1 0 0 $D$7 D region 2 0 0 $E$7 D region 3 0 0 $F$7 D region 4 1 1 $G$7 D region 5 0 0 $H$7 D region 6 0 0 $C$8 E region 1 1 1 $D$8 E region 2 0 0 $E$8 E region 3 0 0 $F$8 E region 4 0 0 $G$8 E region 5 0 0 $H$8 E region 6 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. c) Advice the management about objective function value corresponding to your answer in. d) Explain to the management the reason why some of the regions cannot be assigned.
Question 2
A. The Managing Director of Shoprite Company 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
1 2 3 4 5 6
A 73 91 87 82 78 80
B 81 85 69 76 74 85
C 75 72 83 84 78 91
D 93 96 86 91 83 82
E 93 91 79 89 69 76
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.
Cell Name
Original
Value
Final
Value
$C$4 A region1 0 0
$D$4 A region 2 0 0
$E$4 A region 3 1 1
$F$4 A region 4 0 0
$G$4 A region 5 0 0
$H$4 A region 6 0 0
$C$5 B region 1 0 0
8
$D$5 B region 2 1 1
$E$5 B region 3 0 0
$F$5 B region 4 0 0
$G$5 B region 5 0 0
$H$5 B region 6 0 0
$C$6 C region 1 0 0
$D$6 C region 2 0 0
$E$6 C region 3 0 0
$F$6 C region 4 0 0
$G$6 C region 5 0 0
$H$6 C region 6 1 1
$C$7 D region 1 0 0
$D$7 D region 2 0 0
$E$7 D region 3 0 0
$F$7 D region 4 1 1
$G$7 D region 5 0 0
$H$7 D region 6 0 0
$C$8 E region 1 1 1
$D$8 E region 2 0 0
$E$8 E region 3 0 0
$F$8 E region 4 0 0
$G$8 E region 5 0 0
$H$8 E region 6 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.
c) Advice the management about objective
d) Explain to the management the reason why some of the regions cannot be assigned.
Step by step
Solved in 2 steps with 4 images
