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.
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.
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 function value corresponding to your answer in. d) Explain to the management the reason why some of the regions cannot be assigned.
Expression, rule, or law that gives the relationship between an independent variable and dependent variable. Some important types of functions are injective function, surjective function, polynomial function, and inverse function.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
