The price structure for a particular product is: 60.00 for 0 - 9 units, for 10 - 49 units a price of 50.00, for 50-99 units a price of 40.00 then from the 100th unit onwards 30.00 each.

We would like the Sales Person to be able to enter a single line quote for the quantity required, then for something like a Sales Kit to populate the relevant number of lines for the quantity ordered: e.g. for an order of 101

                     9  x  60

                    40  x  50

                     50  x  40

                      2   x  30

If possible, how would you set something like this and how would you create the Price list to reflect this.

Many thanks

graham