• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

solver solution

jhon

New Member
hi, i am trying to develop a solver solution to a problem, but it seems the problems descriptions are too restrictive. is there a way to identify which constraint is causing the issue? can anyone review to see if there is an issue with my setup?
 
specifically, i am trying to achieve the following:

[pre]
Code:
Objective:
Minimize: B + PB + S + G + M + O

Item	F	T	C	P	$
B	9	65	0	3	.17
PB	65	85	0	4	.12
S	0	45	3	0	.10
G	20	60	0	1	.09
M	8.5	19	.25	1	.035
O	0	12.5	15	.13	.058

Decision Variables:
B
PB
S
G
M
O
(All in Item column)

Constraints:

a)	B + PB + S + G + M + O >= 450 T
b)	B + PB + S + G + M + O  <= 600 T
c)	Max F should be less than 20% Total T
d)	C >= 70
e)	P >= 17
f)	B = 2
g)	PB >= 70% of PB + J
h)	J >= .45
i)	M >= 4
j)	O >= 4
[/pre]
any help is appreciated.
 
Jhon


You have supplied a Table of Values, but typically there will be some sort of model/relationship between at least some of the variables, besides the Sum of the variables


You mention a variable J but it is not listed anywhere except in Constraints g & h


What are columns F..$ for ?
 
Back
Top