Solver

[Adrae]

Does anyone know how to make Solver take into account a ratio when determining profit maximization. I have four items and the ratio of Item 1 to 2 should be 7 to 5.

Any ideas?

Thanks Adrae
This message was edited by Adrae on 2002-10-24 10:18

 

[Mark W.]

Okay, my hunger is satiated... and, I took some more time to reflect on the semantics of your constraints. Perhaps, this is a better model...

Juice.xls
	A	B	C	D	E	F	G	H	I	J
1		Quantity
2	Juice	Produced	Sold	Price	Cost	Profit		Model:
3	OJ	70.0	20.0	$1.00	$0.50	$10.00		$125.00
4	GJ	75.0	25.0	$0.90	$0.40	$12.50		4
5	PJ	50.0	0.0	$0.80	$0.35	$0.00		TRUE
6	All-in-One	150.0	150.0	$1.10	$0.42	$102.50		FALSE
7	Total	345.0	195.0			$125.00		TRUE
8	30%ofOutput	103.5						FALSE
9	5/7ofOJ	50.0						TRUE
10								TRUE
11								100
12
Sheet2

This message was edited by Mark W. on 2002-10-24 17:49