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: From 1 Quantity Ordered To Price per Roll 100 $215 101 200 $195 201 400 $175 401 and up $155 Click on the datafile logo to reference the data. DATA file (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 Orders 100 $215 200 $195 201 400 $175 1 101 401 and up $155 172 Quantity Ordered From To Price per Roll 1 100 $215 101 200 $195 201 400 $175 401 and up $155 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 B Order Huantity 1 86 2 452 3 492 4 191 5 356 6 148 7 342 8 382 9 276 10 118 11 464 12 188 13 25 14 427 15 30 16 111 17 161 18 314 19 442 20 429 21 451 22 32 23 181 24 163 25 26 240 336 27 28 29 30 31 32 33 34 35 36 37 38 39 40 28 28 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 48 SO 51 52 53 54 SS S6 57 41 42 43 44 45 46 47 48 49 50 51 52 53 54 SS 56 68 317 435 211 76 374 415 408 196 302 312 31 317 394 348 49 500 490 94 285 237 101 53 257 273 415 346 133 287 431 113 197 6 328 58 57 59 60 58 SS 61 61 62 63 64 65 66 67 63 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 04 114 207 273 257 113 400 324 500 60 117 466 370 293 14 63 252 394 109 233 340 430 210 363 120 429 113 391 375 487 11 264 14 177 193 95 96 97 98 430 282 100 0 02 03 04 105 106 07 08 109 110 2 113 114 16 16 11F 116 119 20 21 122 23 24 125 126 2 28 129 130 131 12 153 134 135 17S 137 138 139 $ 457 5 333 23 230 376 6 250 377 38 256 337 49 171 278 184 35 368 409 100 54 160 239 186 383 56 217 452 11 208 37 6D 185 ? 52 22 188 41 142 143 144 145 46 47 | 148 49 50 51 52 53 54 55 SS 158 9 60 6 162 63 64 16S 166 ES TES 40 41 42 43 44 45 46 47 48 149 SD 51 152 153 54 55 156 157 158 59 160 161 8 Us 346 277 484 208 229 31 450 304 379 5 9 324 11 179 460 441 309 37 30S 348 85 105 288 454 23 451 374 437 164 455 63 164 16S IEE be 169 1 170 171 172 72 173 174 17S