Richardson Ski Racing $($RSR$)$ sells equipment needed for downhill ski racing. One of RSR$$s products is fencing used on downhill courses. The fence product comes in $150-$foot rolls and sells for $$215$ per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size:

Quantity Ordered

From To Price per Roll

$150$ $$215$

$51100$ $$195$

$101200$ $$175$

$201$ and up $$155$

Click on the datafile logo to reference the data.

$($a$)$ Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders.

$

$($b$)$ Use the COUNTIF function to determine the number of orders in each price bin.

From To Price per Roll Number of Orders

$150$ $$215$

$51100$ $$195$

$101200$ $$175$

$201$ and up $$155$

$172$

Check My Work $(5$ remaining$)$