Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 |
The model above was solved using Solver software and part
|
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 |
$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 |
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
Advice the management about objective function value corresponding to your answer in Explain to the management the reason why some of the regions cannot be assigned
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started