Suppose that a company offers quantity discounts. If up to 1,000 units are purchased, the unit price is $12; if more than 1,000 and up to 5,000 units are purchased, the unit price is $9.50; and if more than 5,000 units are purchased, the unit price is $6.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. 38 ME 81 1234597 Purchase Quantity Unit Price 1 to 1000 1001 to 5000 5001 or more 6 Quantity Ordered 2500 Unit Price VLOOKUP(B6,$A$2:$D4,4,1) mm 9 Total Cost B8'86