Suppliers frequently provide quantity discounts to customers who place large orders. An all-units quantity discount applies a discount to all units purchased once the applicable price breaks have been reached. Consider the following all-units quantity discount schedule:

Size of Order ................................. Price per Unit
0−499 ............................................... units $40.00
500−1199 ........................................ units $38.00
≥ 1200 ............................................. units $35.00

(a) Using IF functions, build an Excel model that returns the price per unit and the total purchase amount for any supplied order size.

(b) Modify your model from part (a) to find the product price using the VLOOKUP function.