Question 1

>=5000	$ 150.00
[1000,5000)	$ 230.00
[500,1000)	$ 330.00
[300, 500)	$ 450.00
<300	$ 600.00

The quantity discount policy is shown above. For example, if order quantity is >=300 but <500 then unit price is $450.

Build a model to calculate unit price in three different ways, given order quantity entered in cell B5.

More specifically, in cell B7 use nested IF function to calculate unit price.

in cell B8 use IFS function to calculate unit price.

in cell B9 use vlookup function to calculate unit price.