Answered step by step
Verified Expert Solution
Link Copied!

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
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

$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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accountability Ethics And Sustainability Of Organizations

Authors: Sandro Brunelli, Emiliano Di Carlo

3rd Edition

3030311929, 9783030311926

More Books

Students also viewed these Accounting questions

Question

=+a. Compute the mean for this data set.

Answered: 1 week ago

Question

=+Is this metric really applicable to what I want to accomplish?

Answered: 1 week ago

Question

=+How does this metric connect to my objectives?

Answered: 1 week ago