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

$160$ $$215$

$61120$ $$195$

$121240$ $$175$

$241$ 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

$160$ $$215$

$61120$ $$195$

$121240$ $$175$

$241$ and up $$155$

$172$