Hello You could also use the optimizer The variables would be the quatity to assign to each customer (A, B and C) You could assign to each customer a property wich is the priority: such as priority 1 will get the highest weight so in this example, a will be assigned the weight of 3, B the weight of 2 and C the weight of 1 the objective function will then be maximize weight * Variable The constraint is sum of variable <= to the available quatity (100 in this example). we could write A+B+C=100 but it is safer to write <= to avoid any errors Variable <= Demand (in your example A<= 50,...) I guess your solution works too, but this one alternative for the ones who are fond of the optimizer
... View more