See image for Question. Please only provide the working to part c. Please show all steps/formulas for the excel solver solution.Solution to b for reference: LINEAR PROGRAMMING PROBLEMMIN 4X14 + 7X15 + 8X24 + 5X25 + 5X34 + 6X35 + 6X46 + 4X47 + 8X48 + 4X49 + 3X56 + 6X57 + 7X58 + 7X59S.T.(1) X14 + X15 < 450(2) X24 + X25 < 600(3) X34 + X35 < 380 (4) X46 + X47 + X48 + X49 - X14 - X24 - X34 = 0(5) X56 + X57 + X58 + X59 - X15 - X25 - X35 = 0(6) X46 + X56 = 300(7) X47 + X57 = 300(8) X48 + X58 = 300(9) X49 + X59 = 400Soution to c for reference: OPTIMAL SOLUTIONObjective Function Value =11850.000 Variable Value Reduced Costs------------ ------------ ---------------X14 450.000 0.000 X15 0.000 3.000 X24 0.000 3.000 X25 600.000 0.000 X34 250.000 0.000 X35 0.000 1.000 X46 0.000 3.000 X47 300.000 0.000 X48 0.000 1.000 X49 400.000 0.000 X56 300.000 0.000 X57 0.000 2.000 X58 300.000 0.000 X59 0.000 3.000 11. The distribution system for the Herman Company consists of three plants, two warehouses,and four customers. Plant capacities and shipping costs per unit (in $) from each plant toeach warehouse are as follows:WarehousePlant12Сараcity45060038014728535Customer demand and shipping costs per unit (in $) from each warehouse to each customerare as follows:a. Develop a network representation of this problem.b. Formulate a linear programming model of the problem.c. Solve the linear program to determine the optimal shipping plan.с.CustomerWarehouse12346.3148426.77Demand300300300400 11. a. Network ModelDemand300Supply450PI4WI300C28.2600P25W2 730036380P3400C4

Given that: Following LPP- MIN 4X14 + 7X15 + 8X24 + 5X25 + 5X34 + 6X35 + 6X46 + 4X47 + 8X48 + 4X49 +…

Answered: See image for Question. Please only…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Concept explainers

Question

See image for Question. Please only provide the working to part c. Please show all steps/formulas for the excel solver solution.

Solution to b for reference:

LINEAR PROGRAMMING PROBLEM
MIN 4X14 + 7X15 + 8X24 + 5X25 + 5X34 + 6X35 + 6X46 + 4X47 + 8X48 + 4X49 + 3X56 + 6X57 + 7X58 + 7X59
S.T.
(1) X14 + X15 < 450
(2) X24 + X25 < 600
(3) X34 + X35 < 380
(4) X46 + X47 + X48 + X49 - X14 - X24 - X34 = 0
(5) X56 + X57 + X58 + X59 - X15 - X25 - X35 = 0
(6) X46 + X56 = 300
(7) X47 + X57 = 300
(8) X48 + X58 = 300
(9) X49 + X59 = 400

Soution to c for reference:

OPTIMAL SOLUTION

Objective Function Value =11850.000
Variable Value Reduced Costs
------------ ------------ ---------------
X14 450.000 0.000
X15 0.000 3.000
X24 0.000 3.000
X25 600.000 0.000
X34 250.000 0.000
X35 0.000 1.000
X46 0.000 3.000
X47 300.000 0.000
X48 0.000 1.000
X49 400.000 0.000
X56 300.000 0.000
X57 0.000 2.000
X58 300.000 0.000
X59 0.000 3.000

11. The distribution system for the Herman Company consists of three plants, two warehouses,
and four customers. Plant capacities and shipping costs per unit (in $) from each plant to
each warehouse are as follows:
Warehouse
Plant
1
2
Сараcity
450
600
380
1
4
7
2
8
5
3
5
Customer demand and shipping costs per unit (in $) from each warehouse to each customer
are as follows:
a. Develop a network representation of this problem.
b. Formulate a linear programming model of the problem.
c. Solve the linear program to determine the optimal shipping plan.
с.
Customer
Warehouse
1
2
3
4
6.
3
1
4
8
4
2
6.
7
7
Demand
300
300
300
400

11. a. Network Model
Demand
300
Supply
450
PI
4
WI
300
C2
8.
2
600
P2
5
W2 7
300
3
6
380
P3
400
C4

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions