Question 7 A. An Electrical Company has three workshops in Koforidua, Accra and Kumasi. These workshops produce the following quantities of electric fan. Workshops Monthly production (units) Koforidua 130 Accra 70 Kumasi 100 The monthly demand for these fans in three towns: Sunyani, Cape Coast and Ho is given below: Destination Weekly Demand (units) Sunyani 80 Cape Coast 110 Ho 60 The unit transportation costs per unit (in GH¢000) from the sources to the destinations are as shown: a) Formulate a linear programming (LP) model. B. The model in (A) was solved using Solver and part of the Solver output is shown below. Use it to answer the questions that follow. b) As a management, science student the MD of the company seeks your expert advice on ways in which to determine the optimal transportation rule. Write your answer in a form of a report to the MD c) Advise the MD, providing detailed explanation using the table above. Write your answer in a form of a report to the MD.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Question 7
A. An Electrical Company has three workshops in Koforidua, Accra and
Kumasi. These workshops produce the following quantities of electric fan.
Workshops Monthly production (units)
Koforidua 130
Accra 70
Kumasi 100
The monthly demand for these fans in three towns: Sunyani, Cape Coast and Ho is given below:
Destination Weekly Demand (units)
Sunyani 80
Cape Coast 110
Ho 60
The unit transportation costs per unit (in GH¢000) from the sources to the
destinations are as shown:

 

a) Formulate a linear programming (LP) model. 

 

B. The model in (A) was solved using Solver and part of the Solver output is shown below. Use it to answer the questions that follow.

 

b) As a management, science student the MD of the company seeks your
expert advice on ways in which to determine the optimal transportation rule.
Write your answer in a form of a report to the MD

 

c) Advise the MD, providing detailed explanation using the table above.
Write your answer in a form of a report to the MD. 

Adjustable Cells
Original
Cell
Name
Value
Final Value
SC$4 Koforidua Sunyani
80
80
Koforidua Cape
$D$4 Coast
SE$4 Koforidua Ho
$C$S Accra Sunyani
$D$S Accra Cape Coast
10
10
SE$S Accra Ho
60
60
SC$6 Kumasi Sunyani
$D$6 Kumasi Cape Coast
100
100
SE$6 Kumasi Ho
Transcribed Image Text:Adjustable Cells Original Cell Name Value Final Value SC$4 Koforidua Sunyani 80 80 Koforidua Cape $D$4 Coast SE$4 Koforidua Ho $C$S Accra Sunyani $D$S Accra Cape Coast 10 10 SE$S Accra Ho 60 60 SC$6 Kumasi Sunyani $D$6 Kumasi Cape Coast 100 100 SE$6 Kumasi Ho
From
То
Sunyani
Cape Coast
Но
Koforidua
9.
14
12
Аccra
11
10
Kumasi
12
8
15
Transcribed Image Text:From То Sunyani Cape Coast Но Koforidua 9. 14 12 Аccra 11 10 Kumasi 12 8 15
Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY