CH $10$ Business analytics Please please dont copy and paste an answer, I$\text{'}$m so lost and every answer on chegg is wrong 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 $180$ $$21581160$ $$195161320$ $$175321$ and up $$155$ Click on the datafile logo to reference the data. 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 $\backslash (\backslash$$ $215\backslash )$ per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Click on the datafile logo to reference the data. DATA $($a$)$ Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $\backslash (\backslash$$ $\backslash )($b$)$ Use the COUNTIF function to determine the number of orders in each price bin.