Q$1$: $30$ points

Company A sells industrial equipment. Price varies based on the quantity ordered as shown in the table below.

Use the VLOOKUP function with the pricing table to determine the price per unit for each order. Then determine the total revenue for the $150$ orders. Using the COUNTIF function, indicate the number of orders for each price level.

$\backslash$table$[[,,],[$From$,$Quantity Ordered,$],[$To$,$Price per Unit,$]]$p