TO 1 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 Price per Roll 50 $215 51 100 $195 200 $175 201 and up $155 Click on the datafile logo to reference the data. DATA file 101 (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. To (b) Use the COUNTIF function to determine the number of orders in each price bin. From Price per Roll Number of Orders $215 $195 1 50 51 100 101 200 $175 201 and up $155 172 fx Order D E F G H I J K I. M N 0 Q R S T U Quantity Ordered From To Price per Roll 1 50 $215 51 100 $195 101 200 $175 201 and up $155 A Name Box Order Quantity 1 1 86 2 452 2 3 492 4 101 4 191 5 356 256 6 120 148 - 240 7 342 8 200 382 9 276 10 10 118 119 11 464 16A 12 188 12 13 as 25 14 427 741 15 15 30 JU 12 16 10 111 17 12 161 18 19 314 19 442 20 20 40 429 21 451 22 20 32 23 23 181 24 163 25 336 26 240 27 68 28 317 29 435 30 211 31 76 32 374 33 415 34 408