Question: The model above was solved using Solver software and part of the output is shown below. Use it to answer the questions that follow Original

The model above was solved using Solver software and part of the output is shown below. Use it to answer the questions that follow Original Value 0 0 1 0 0 Final Value 0 0 Cell Name SC$4 A regioni $D$4 A region 2 $E$4 A region 3 $F$4 A region 4 $G$4 A region 5 0 0 0 0 1 0 0 0 0 SH$4 A region 6 $C$5 B region 1 SD$5 B region 2 SESS B region 3 $F$5 B region 4 $G$5 B regions SH$5 B region 6 $C$6 C region 1 $D$6 C region 2 SE$6 C region 3 $F$6 C region 4 $G$6 C region 5 SH$6 C region 6 $C$7 D region 1 SDS7 D region 2 $E$7 D region 3 $F$7 D region 4 $G$7 D region 5 SH$7 D region 6 $C$8 E region 1 $D$8 E region 2 $E$8 E region 3 $F$8 E region 4 $G$8 E region 5 SH$8 E region 6 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 1 0 0 1 0 0 0 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 EV (7) c) Advice the management about objective function value corresponding to your answer in EV (5) d) Explain to the management the reason why some of the regions cannot be assigned. EV (5) The model above was solved using Solver software and part of the output is shown below. Use it to answer the questions that follow Original Value 0 0 1 0 0 Final Value 0 0 Cell Name SC$4 A regioni $D$4 A region 2 $E$4 A region 3 $F$4 A region 4 $G$4 A region 5 0 0 0 0 1 0 0 0 0 SH$4 A region 6 $C$5 B region 1 SD$5 B region 2 SESS B region 3 $F$5 B region 4 $G$5 B regions SH$5 B region 6 $C$6 C region 1 $D$6 C region 2 SE$6 C region 3 $F$6 C region 4 $G$6 C region 5 SH$6 C region 6 $C$7 D region 1 SDS7 D region 2 $E$7 D region 3 $F$7 D region 4 $G$7 D region 5 SH$7 D region 6 $C$8 E region 1 $D$8 E region 2 $E$8 E region 3 $F$8 E region 4 $G$8 E region 5 SH$8 E region 6 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 0 0 0 0 0 0 0 1 0 0 1 0 0 0 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 EV (7) c) Advice the management about objective function value corresponding to your answer in EV (5) d) Explain to the management the reason why some of the regions cannot be assigned. EV

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

35 $0 | 71% 19:27 1 f MS101 KCC WKEN... 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....

A. The Managing Director of Koala Supermarket is faced with the problem of assigning five senior managers to six regions. From past experience, he knows th the efficiency of the sales and operating...

Question 2 A. The Managing Director of Palace Decor 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...

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

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

Question 2 A. The Managing Director of Palace Decor 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...

Question 2 A. The Managing Director of Shogene Company is faced with the problem of uning five senior managers te sex res. From past experience he was that the efficiency of the sales and operating...

exactly the same as the error sum of squares for the standard ANOVA. (a) True (b) False 3.66 Fisher's LSD procedure is an extremely conservative method for comparing pairs of treatment means...

Gitano Products operates a job-order costing system and applies overhead cost to jobs on the basis of direct materials used in production (not on the basis of raw materials purchased). Its...

Write an essay on Accounting is a Global Business Language: Accounting is becoming a global business language. Provide some evidence of this assertion. What are some of the implications of this trend?

On the banis of the following data for Larson Co . for the year ended December 3 1 , Year 2 , and the preceding year ended Decemby cash flows for War 2 . Use the indirect method of reporting cash...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...