Scribd
Upload
25 views3 pages

Linear Programming Computer Solution

The document discusses the advantages and disadvantages of using Excel to solve linear programming problems. The main advantages are that Excel makes computations easier through its features and built-in formulas. This allows data to be organized and formulated in an easily understandable way. The main disadvantage is that Excel requires a personal computer or laptop and a Microsoft subscription, which can be costly. It also may be complicated for those with limited Excel experience. The document then provides two examples of linear programming problems solved through both graphical and Excel computer solutions.

Uploaded by

KRISTALYN REGASPI
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
25 views3 pages

Linear Programming Computer Solution

The document discusses the advantages and disadvantages of using Excel to solve linear programming problems. The main advantages are that Excel makes computations easier through its features and built-in formulas. This allows data to be organized and formulated in an easily understandable way. The main disadvantage is that Excel requires a personal computer or laptop and a Microsoft subscription, which can be costly. It also may be complicated for those with limited Excel experience. The document then provides two examples of linear programming problems solved through both graphical and Excel computer solutions.

Uploaded by

KRISTALYN REGASPI
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Assignment #2: Linear Programming: Computer Solution

1. What are the advantages of using Excel in solving linear programming? What is the
disadvantage?
The advantage of using Excel is that it makes your computation easier. Because of its
features and build-in formulas it makes your data organize and the formulation of it is easily
understand. The disadvantage of it is that Excel is only accessible for those who have personal
computer or laptops, and the subscription of Microsoft is costly. And also, sometimes the use of
Excel is complicated especially when you have a limited knowledge using it.

2. Solve using the graphical solution the compare your answer using a computer solution. 
Show your graph with the feasible region and coordinates of the vertices and the solver (excel)
output.
A.

Graphing Solution
Objective Function:

Solution Values:
a. (0,9) → 3(0) + 6(9) = 54
b. (0,5) → 3(0) + 6(5) = 30
c. (4,3) → 3(4) + 6(3) = 30
d. (4,1) → 3(4) + 6(1) = 18
Computer Solution:

B.

Graphing
Solution:
Objective Function:

Solution Values:
a. (0,10) → 5(0) + 8(10) = 80
b. (8, 5.2) → 5(8) + 8(5.2) = 81.6
c. (8,0) → 5(8) + 8(0) = 40
Computer Solution

You might also like