# Trouble with linear programming using solver excelWatch

#1
Hi, no matter what I do I can't seem to get solver excel to work.. I'm always getting the linear function wrong. I hope any kind soul that's familiar with solver can help me.. I've been cracking my skull for days over this..

So in this excel sheet..

Selling price (Cell C10) can only be from \$150-\$180
Units sold (Cell C9) will decrease by percentage increase in selling price of Cell C10

I want to maximize the value of cash flow in cell G11

I can only change the VC(Others) (Cell C2) between \$27 and \$33..

I've been currently using the following in solver:
Set objective: \$G\$11
To: Max
By changing variable cells: \$C\$2,\$C\$9
Subjected to following constraints:
\$C\$2 <= 33,
\$C\$2 >= 27,
\$C\$10 <=180,
\$C\$9 = (1-((\$C\$10-150/150))*\$C\$9

Could anyone help me with this please using the solver function?
0
1 year ago
#2
(Original post by spicyscreamer)
Hi, no matter what I do I can't seem to get solver excel to work.. I'm always getting the linear function wrong. I hope any kind soul that's familiar with solver can help me.. I've been cracking my skull for days over this..

So in this excel sheet..

Selling price (Cell C10) can only be from \$150-\$180
Units sold (Cell C9) will decrease by percentage increase in selling price of Cell C10

I want to maximize the value of cash flow in cell G11

I can only change the VC(Others) (Cell C2) between \$27 and \$33..

I've been currently using the following in solver:
Set objective: \$G\$11
To: Max
By changing variable cells: \$C\$2,\$C\$9
Subjected to following constraints:
\$C\$2 <= 33,
\$C\$2 >= 27,
\$C\$10 <=180,
\$C\$9 = (1-((\$C\$10-150/150))*\$C\$9

Could anyone help me with this please using the solver function?
To be honest, this looks rather a mess. I'm not clear what you're trying to achieve, and can't make head nor tail of the spreadsheet.

There are no formulae in any of the cells, apart from text in one.
And there's nothing in the Solver itself to go on.

Do you have anything further that might help?
X

new posts
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.

### University open days

• University of Birmingham
Wed, 20 Mar '19
• King's College London
Wed, 20 Mar '19
• University of East Anglia
All Departments Open 13:00-17:00. Find out more about our diverse range of subject areas and career progression in the Arts & Humanities, Social Sciences, Medicine & Health Sciences, and the Sciences. Postgraduate
Wed, 20 Mar '19

### Poll

Join the discussion

#### Where do you need more help?

Which Uni should I go to? (42)
13.77%
How successful will I become if I take my planned subjects? (26)
8.52%
How happy will I be if I take this career? (61)
20%
How do I achieve my dream Uni placement? (44)
14.43%
What should I study to achieve my dream career? (36)
11.8%
How can I be the best version of myself? (96)
31.48%