Decision Modelling with Spreadsheets Solution 2022

Running head: DESCISION MODELING WITH SPREADSHEETS
Decision Modelling with Spreadsheets
Name of the Student:
Name of the University:
Author Note:

DESCISION MODELING WITH SPREADSHEETS
1
Yes, a linear programming problem (LPP) have more than one optimal solution.
An optimal solution is a solution of feasible type, in which the objective function gain
their maximum or minimum value. In other words it is a solution, which either minimise or
maximise the objective function. Moreover it is also a solution of linear programming
problem which satisfies the constraints and also it gets the value of the objective function.
This kind of solution has been seen, when there are more than one basic solution of the linear
programming problem. Thus this maximize or minimize the objective function. In general the
optimal solution may not unique, when the non-basic variables have the zero coefficient in
the row of index. In other words the index row (Zj - Cj)
There are different methods to solve multiple optimal solution, like simplex method,
graphic method and so on. In this type of solution bringing the variable which is non basic,
which increase or decrease the basic variable and in to the value of the objective function.
For example,
Maximize
2000X1 +3000X2
Subject to
6x1 + 9x2 ≤ 100
2X1 +X2 ≤ 20
Where
X1, X2 ≥ 0
Solution: