I need to set up my products unit costs from suppliers, and subsequently, my unit prices to my customers with different prices, based upon the quantity that my customer orders.

For instance, Vendor XYZ prices his cost to me for say 100 to 199 widgets at $5.00 each, and for 200 to 499 widgets at $4.00, and so forth. I need to record these in my product table at these costs, with a different markup % for each quantity range, say at 50% markup for 100-199 and 40% markup for 200-499, and so forth.

I have not seen this problem addressed in the Lessons up through Expert Level 25.  everything thing in the lessons seems to have just one fixed cost and sale price, regardless of quantity ordered.

Can anyone assist me with this?  Thanks in advance.