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

$1100$ $$215$

$101200$ $$195$

$201400$ $$175$

$401$ and up $$155$

Click on the datafile logo to reference the data.

The datafile logo$.$

$($a$)$ Use the XLOOKUP 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

$1100$ $$215$

$101200$ $$195$

$201400$ $$175$

$401$ and up $$155$

$172$