Richardson Ski Racing $($RSR$)$ sells equipment needed for downhill ski racing. One of RSR$\text{'}$s products is fencing used on downhill courses. The fence product comes in $150-$foot rolls and sells for $$210$ 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 $($$$)$

$1100210$

$101150185$

$151250170$

$251$ and up $150$

The file RSR$\_$alt.xlsx contains $172$ orders that have arrived for the coming six weeks.

$($a$)$

Use the XLOOKUP function with the preceding pricing table to determine the total revenue $($in dollars$)$ from these orders.

$

$($b$)$

Use the COUNTIF function to determine the number of orders in each price bin.

Quantity Ordered

From To Price per Roll $($$$)$ Number of Orders

$1100210$

$28$

Correct: Your answer is correct.

$101150185$

$18$

Incorrect: Your answer is incorrect.

$151250170$

$31$

Incorrect: Your answer is incorrect.

$251$ and up $150$

$95$

Incorrect: Your answer is incorrect.

Need Help? Read It

$4.$

$[1\mathrm{.}52/20$ Points$]$

DETAILS

PREVIOUS ANSWERS

CAMMBA$512.$E$\mathrm{.}020.$MI$.$