# Excel Solver HELP Linear Programming (product mix)

Watch
Announcements
#1
Would somebody be able to check whether this problem is correct?

if i change the 'make unconstrainted variables non-negative' so it isnt ticked i get a different answer

also if in an transportation problem if the demand (10000) is higher than the supply (9000) are the demand constraints the correct way?

SUPPLY
X11 + X12 + X13 ≥5000
X21 + X22 + X23 ≥4000

DEMAND
X11 + X21 ≥ 3000
X12 + X22 ≥ 4000
X13 + X23 ≥ 3000

thanks
0
4 years ago
#2
(Original post by JoeyA95)
Would somebody be able to check whether this problem is correct?

if i change the 'make unconstrainted variables non-negative' so it isnt ticked i get a different answer
I'm using an older version (2007) of Excel, so may not be of any use, and see no change: x1=30, x2=0 in both cases.
Edit: I'm aware that later versions have changed the wording of that Excel option (it's different in my earlier version), and potentially changed what's behind the scenes.
0
#3
(Original post by ghostwalker)
I'm using an older version (2007) of Excel, so may not be of any use, and see no change: x1=30, x2=0 in both cases.
Edit: I'm aware that later versions have changed the wording of that Excel option (it's different in my earlier version), and potentially changed what's behind the scenes.
ok im guessing that x1=30 x2=0 is the correct answer then?
0
4 years ago
#4
(Original post by JoeyA95)
ok im guessing that x1=30 x2=0 is the correct answer then?
What other solution do you get?
0
#5
(Original post by ghostwalker)
What other solution do you get?
x1=20 x2=20
0
4 years ago
#6
(Original post by JoeyA95)
x1=20 x2=20
Both solutions give the same cost.

And so will any linear combination of the form where , subject to the values being integers.

The Excel parameter is a red herring - just results in different methods behind the scenes, hence the two extreme ends of the viable solutions.
0
#7
(Original post by ghostwalker)
What other solution do you get?
for the transporation problem are the constraints the correct way?
0
#8
(Original post by ghostwalker)
Both solutions give the same cost.

And so will any linear combination of the form where , subject to the values being integers.

The Excel parameter is a red herring - just results in different methods behind the scenes, hence the two extreme ends of the viable solutions.
ok i will use the x1=30 x2=0 as you got this aswell
0
4 years ago
#9
(Original post by JoeyA95)
for the transporation problem are the constraints the correct way?
They are correct for the demand.

But should be the other way around for the supply.

Note: With that there is no feasible solution. You need to add a dummy source to make up the missing supply.
0
X

new posts Back
to top
Latest
My Feed

### Oops, nobody has postedin the last few hours.

Why not re-start the conversation?

see more

### See more of what you like onThe Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

### Poll

Join the discussion

#### Are you tempted to change your firm university choice on A-level results day?

Yes, I'll try and go to a uni higher up the league tables (31)
28.97%
Yes, there is a uni that I prefer and I'll fit in better (10)
9.35%
No I am happy with my choice (59)
55.14%
I'm using Clearing when I have my exam results (7)
6.54%