are purchased, the unit price is $$7\mathrm{.}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.

Complete the formulas in the spreadsheet below. Select the correct VLOOKUP function in cell C$8$ to find the unit price for the order quantity.

$($Type integers or decimals rounded to two decimal places as needed.$)$

$\backslash$table$[[,$A$,$B$,$C$,$D$],[1,,$Purchase Quantity,,Unit Price$],[2,1,$to$,1000,$$