Quantity design
Posted: Fri Jan 10, 2014 5:51 am
Hi All
I'm trying to build a design in order to manager discount prices...
I'm treating Nb of units as alternative, and using the Unit Price and Discount Policy as attributes
add2.prix2 is the price for 2 quantities given the price for 1 Unit Add1.prix1 and discount policy
Design
;alts = add1,add2,add3,add4,add5,add6,none;
;rows = 210
;block= 30
;eff = (mnl,d)
;cond:
if (add1.prix1=8 and add1.discount=1, add2.prix2=16),
if (add1.prix1=8 and add1.discount=2, add2.prix2=12),
if (add1.prix1=8 and add1.discount=3, add2.prix2=11),
if (add1.prix1=10 and add1.discount=1, add2.prix2=20),
if (add1.prix1=10 and add1.discount=2, add2.prix2=15),
if (add1.prix1=10 and add1.discount=3, add2.prix2=13),
if (add1.prix1=12 and add1.discount=1, add2.prix2=24),
.....
if (add1.prix1=8 and add1.discount=1, add6.prix6=48),
if (add1.prix1=8 and add1.discount=2, add6.prix6=28),
if (add1.prix1=8 and add1.discount=3, add6.prix6=23),
if (add1.prix1=10 and add1.discount=1, add6.prix6=60),
if (add1.prix1=10 and add1.discount=2, add6.prix6=35),
if (add1.prix1=10 and add1.discount=3, add6.prix6=25),
if (add1.prix1=12 and add1.discount=1, add6.prix6=72),
if (add1.prix1=12 and add1.discount=2, add6.prix6=42),
if (add1.prix1=12 and add1.discount=3, add6.prix6=27)
;model:
U(add1) = a1 * prix1[8,10,12] + dis1 * discount[1,2,3] /
U(add2) = a2 * prix2[11,12,13,14,15,16,18,20,24] + dis2 * discount[discount] /
U(add3) = a3 * prix3[14,16,18,20,24,30,36] + dis3 * discount[discount] /
U(add4) = a4 * prix4[17,19,20,21,25,30,32,40,48] + dis4 * discount[discount] /
U(add5) = a5 * prix5[20,22,24,30,36,40,50,60] + dis5 * discount[discount] /
U(add6) = a6 * prix6[23,25,27,28,35,42,48,60,72] + dis6 * discount[discount] $
I'm getting too errors, 1st fact=X% should be placed.. and An attribute level for an attribute associated with constraints (;cond) could not be placed. There may not be enough rows, or the constraints might be too tight.
Thanks for your comments
Nassar
I'm trying to build a design in order to manager discount prices...
I'm treating Nb of units as alternative, and using the Unit Price and Discount Policy as attributes
add2.prix2 is the price for 2 quantities given the price for 1 Unit Add1.prix1 and discount policy
Design
;alts = add1,add2,add3,add4,add5,add6,none;
;rows = 210
;block= 30
;eff = (mnl,d)
;cond:
if (add1.prix1=8 and add1.discount=1, add2.prix2=16),
if (add1.prix1=8 and add1.discount=2, add2.prix2=12),
if (add1.prix1=8 and add1.discount=3, add2.prix2=11),
if (add1.prix1=10 and add1.discount=1, add2.prix2=20),
if (add1.prix1=10 and add1.discount=2, add2.prix2=15),
if (add1.prix1=10 and add1.discount=3, add2.prix2=13),
if (add1.prix1=12 and add1.discount=1, add2.prix2=24),
.....
if (add1.prix1=8 and add1.discount=1, add6.prix6=48),
if (add1.prix1=8 and add1.discount=2, add6.prix6=28),
if (add1.prix1=8 and add1.discount=3, add6.prix6=23),
if (add1.prix1=10 and add1.discount=1, add6.prix6=60),
if (add1.prix1=10 and add1.discount=2, add6.prix6=35),
if (add1.prix1=10 and add1.discount=3, add6.prix6=25),
if (add1.prix1=12 and add1.discount=1, add6.prix6=72),
if (add1.prix1=12 and add1.discount=2, add6.prix6=42),
if (add1.prix1=12 and add1.discount=3, add6.prix6=27)
;model:
U(add1) = a1 * prix1[8,10,12] + dis1 * discount[1,2,3] /
U(add2) = a2 * prix2[11,12,13,14,15,16,18,20,24] + dis2 * discount[discount] /
U(add3) = a3 * prix3[14,16,18,20,24,30,36] + dis3 * discount[discount] /
U(add4) = a4 * prix4[17,19,20,21,25,30,32,40,48] + dis4 * discount[discount] /
U(add5) = a5 * prix5[20,22,24,30,36,40,50,60] + dis5 * discount[discount] /
U(add6) = a6 * prix6[23,25,27,28,35,42,48,60,72] + dis6 * discount[discount] $
I'm getting too errors, 1st fact=X% should be placed.. and An attribute level for an attribute associated with constraints (;cond) could not be placed. There may not be enough rows, or the constraints might be too tight.
Thanks for your comments
Nassar