Fichardson Ski Racing (RSR) sells equipment needed for downhili ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150 -foot rolls and selis for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per rolf depending on order slze: Click on the datafile logo to reference the data. DATA (a) Use the XLookup function with the preceding pricing table to determine the total revenue from these orders: 1 (b) Use the coUNTIF function to determine the number of orders in each price bin. Formatting as Table A1 xfx Order 5 0 6 . 410 B c D E F 0 K L M N 0 P Q R 1. Order Quantity Quantify Ordered 45286 From \begin{tabular}{|r|r|} \hline Te & Price per Roll \\ \hline 30 & $215 \\ \hline 60 & $195 \\ \hline 120 & $175 \\ \hline and ve & $155 \\ \hline \end{tabular} 492 191 356 148 342 32 276 118 464 188 25 427 30 111 161 314 442 429 451 32 181 163 336 240 68 317 435 211 76 374 415 408 19 302 312 31 317 394 348 49 50 490 44 297 101 53 257 77) 41) 346 133 Data Al :fx Order - = - - * r Fichardson Ski Racing (RSR) sells equipment needed for downhili ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150 -foot rolls and selis for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per rolf depending on order slze: Click on the datafile logo to reference the data. DATA (a) Use the XLookup function with the preceding pricing table to determine the total revenue from these orders: 1 (b) Use the coUNTIF function to determine the number of orders in each price bin. Formatting as Table A1 xfx Order 5 0 6 . 410 B c D E F 0 K L M N 0 P Q R 1. Order Quantity Quantify Ordered 45286 From \begin{tabular}{|r|r|} \hline Te & Price per Roll \\ \hline 30 & $215 \\ \hline 60 & $195 \\ \hline 120 & $175 \\ \hline and ve & $155 \\ \hline \end{tabular} 492 191 356 148 342 32 276 118 464 188 25 427 30 111 161 314 442 429 451 32 181 163 336 240 68 317 435 211 76 374 415 408 19 302 312 31 317 394 348 49 50 490 44 297 101 53 257 77) 41) 346 133 Data Al :fx Order - = - - * r