Suppose that a company offers quantity discounts. if up to 1,000 units are purchased, the unit price is $1010; if more than 1,000 and up to 5,000 units are purchased, the unit price is $9.509.50; and if more than 5,000 units are purchased, the unit price is $5.505.50. develop an excel template using the vlookup function to find the unit price associated with any order quantity and compute the total cost of the order.

Ans. Ready to download, please see the file attached to this document

Explanation:

Note. Consider changing the cell in yellow, does not make sense, it could be 10100 instead of 1010

Hi, to design this sheet, I also used the and(...) function of MS excel, in which you declate that in order to select a certain answer, 2 or more conditions must be true, in our case, if a purchase is up to 1000, the price would be $1010 (consider changing this value, maybe to 10100), if the purchase is more than 1000 and less than 5000, the price is $9,509.50, and if is more than 5000 units, the price would be $5,5005.50.

Please check the formula for further clarifications.

Best of luck.