D18 fx D E G H HN Order 1 2 3 4 5 6 7 00 g 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 B Quantity 86 452 492 191 356 148 342 382 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 196 302 312 31 317 394 11 B C D E F G 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 89 A 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 + 38 348 49 500 490 94 285 237 101 53 257 273 415 346 133 287 431 113 197 6 328 114 207 273 257 113 400 324 500 60 117 466 370 293 164 63 252 394 109 233 340 430 w88mmmaumwa #1 #2 #3 -- D m F G 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 B 210 363 120 429 113 391 375 487 11 264 14 177 193 427 320 347 64 430 282 66 457 377 15 333 23 230 378 136 250 377 388 256 337 419 171 278 18+ 357 368 409 100 D E F G 123 124 125 126 127 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 154 160 239 186 383 156 217 452 111 208 317 60 185 383 52 282 188 52 106 346 277 484 208 229 311 450 304 379 15 99 324 151 179 460 441 309 37 305 348 85 135 160 161 162 163 164 165 166 167 168 169 270 171 288 72 73 74 164 165 166 454 238 38 25 26 77 78 79 BO 81 B2 83 84 167 168 169 170 171 172 451 374 437 184 455 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 $210 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 $210 101 150 $185 151 250 $170 251 and up $145 The file RSR contains 172 orders that have arrived for the coming six weeks. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue (in dollars) from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. Quantity Ordered From To Price per Roll Number of Orders 1 100 $210 101 150 $185 151 250 $170 251 and up $145