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 Odered From To Price per Roll 1 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. 73894 (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 23 101 200 $195 25 201 400 $175 58 401 and up $155 66 172 Hide Feedback Incorrect C x fx =VLOOKUP(B2,SF$3:$H$7,3,TRUE) A B C D E F G H 1 Order Quantity 2 1 86 N/A Quantity Ordered 3 2 452 From To Price per Roll 4 3 492 1 100 $215 5 4 191 101 200 $195 6 7 8 9 10 6000 5658 a 356 201 400 $175 148 401 and up $155 7 342 382 9 276 11 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 4 Ready Data + C2 X B 394 fx =VLOOKUP(B2,$F$3:$H$7,3,TRUE) D E F G 41 40 42 41 43 42 44 43 45 44 46 45 47 46 48 47 49 48 50 49 51 50 52 53 54 55 56 57 58 59 60 <99999999resses552285863236832fffffffee > 348 49 500 490 94 285 237 101 53 257 273 415 346 54 133 287 431 57 113 197 6 61 60 328 62 114 63 207 64 273 65 64 257 66 113 67 400 68 67 324 69 500 70 60 71 70 117 72 71 466 73 72 370 74 73 293 75 74 164 76 63 77 76 252 78 394 79 78 109 80 79 233 Data + Ready C2 Clipboard Font fx =VLOOKUP(BZ,$F$3:$H$7,3,TRUE) A B C D B F G H 81 80 3401 82 81 430) 83 82 210 84 83 363 85 84 120 86 85 429 87 86 113 88 87 391 89 88 375 90 89 487 91 90 11 92 91 264 93 92 14 94 93 177 95 94 193 96 95 427 97 96 320 98 97 347 99 98 64 100 99 430 101 100 282 102 101 66 103 102 457 104 103 377 105 104 15 106 105 333 107 106 23 108 107 230 109 108 378 110) 109 136 111 110. 250 112 111 377 113 112 388 114] 113 113 256 115 114 337 117 118 819 116 115 419 116 171 117 278 119 118 184 120 119 357 Data + Ready AutoSave OFF Paste Clipboard Home Insert Draw Page Layout Formulas Data Times New Roman 12 AA BIU 16 AM Font 0 C2 xfx VLOOKUP(82,SFS3:SH$7,3,TRUE) A B C D E F G 120 119 357 121 120 -368 122 121 409 123 122 100 124 123 154 125 124 160 126 125 239 127 126 186 128 127 383 129 128 156 130 129 217 131 130 452 132 131 111 133 132 208 134 133 317 135 134 60 136 135 185 137 136 383 138 137 52 139 138 282 140 139 188 141 140 52 142 141 106 143 142 346 144 143 277 145 144 484 146 145 208 147 1461 229 148 147 311 149 148 450 150 149 304 151 150 379 152 151 15 153 152 99 154 153 324 155 154 151 156 155 179 157 156 460 158 157 441 159 158 309 4> Data + Ready Paste > 14 BIUA C2 Clipboard Font XVfx =VLOOKUP(B2,$F$3:$H$7,3,TRUE) A B D E F G 155 154 151 156 155 179 157 156 460 158 157 441 159 158 309 160 159 37 161 160 305 162 161 348 163 162 85 164 163 135 165 164 288 166 165 454 167 166 238 168 167 38 169 168. 451 170 169 374 171 170 437 172 171 184 173 172 455 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189