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 150foot 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 1 100 $215 101 200 $195 201 400 $175 401 and up $155 Click on the datale logo to reference the data. DATAffile (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 1 100 $215 101 200 $195 201 400 $175 C] 401 and up $155 172 A B C D E F G H Order Quantity 86 Quantity Ordered W IN 452 From To Price per Roll UA W 492 100 $215 UI 191 101 200 $195 356 201 400 $175 6 148 401 and up $155 342 8 382 10 9 276 10 118 12 11 464 13 12 188 14 13 25 15 14 427 16 15 30 17 16 111 18 17 161 19 18 314 20 19 442 21 20 429 22 21 451 23 22 32 24 23 181 25 24 163 26 25 336 27 26 240 28 27 68 29 28 317 30 29 435 31 30 211 32 31 76 33 32 374 34 33 415 35 34 408 36 35 196 37 36 302 38 37 312 39 38 31 40 39 317 41 40 394 42 41 348 43 42 49 44 43 500 45 44 490