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 To Price per Roll From 1 70 $215 71 140 $195 141 280 $175 281 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. (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number Orders 1 70 $215 71 140 $195 141 280 $175 281 and up $155 172 Quantity Ordered From To Price per Roll 70 $215 71 140 $195 141 280 $175 281 and up $155 Order Quantity 86 452 492 191 256 356 148 342 382 276 118 464 12 188 13 25 127 427 15 30 16 111 17 161 18 314 314 442 429 21 451 22 32 181 163 336 26 240 68 317 435 21 31 76 374 36 37 415 408 196 302 312 31 317 394 348 49 500 490 94 Ltd 10[ 257 273 115 346 133 53 54 55 56 57 58 54) 60 131 ]13 197 52 328 ]14 207 27 557 15 4{}} 324 5 ET[ 466 71 72 .. 102t ... i.fi 16.4 75 76 252 1 78 7(; 80 233 24] 47343 2( 363 12 42 T[ 391 SZE L&T 11 264 177 193 107 95 96 97 98 99 100 10 10 103 1 320 347 64 130 282 66 457 377 15 333 23 230 378 136 250 377 388 256 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 337 419) 123 124 125 126 127 128 129 130 131 132 133 171 278 184 357 368 409 100 154 160 239 186 383 156 217 452 208 317 60 134 135 1 17 138 1.9 1.11 185 383 53 282 188 | 52 106 74 14/ 147 143 14 145 | 147 | 1-19 277 484 08 22 | 4 14 10 15| 157 1.5.3 14 324 11 4) 41 313 156 J57 1 1 1 15: 48 13: 16 | 13 IfM 15 | 44 338 168 [f 17) 171 172 41 374 437 1 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 $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered To Price per Roll From 1 70 $215 71 140 $195 141 280 $175 281 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. (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number Orders 1 70 $215 71 140 $195 141 280 $175 281 and up $155 172 Quantity Ordered From To Price per Roll 70 $215 71 140 $195 141 280 $175 281 and up $155 Order Quantity 86 452 492 191 256 356 148 342 382 276 118 464 12 188 13 25 127 427 15 30 16 111 17 161 18 314 314 442 429 21 451 22 32 181 163 336 26 240 68 317 435 21 31 76 374 36 37 415 408 196 302 312 31 317 394 348 49 500 490 94 Ltd 10[ 257 273 115 346 133 53 54 55 56 57 58 54) 60 131 ]13 197 52 328 ]14 207 27 557 15 4{}} 324 5 ET[ 466 71 72 .. 102t ... i.fi 16.4 75 76 252 1 78 7(; 80 233 24] 47343 2( 363 12 42 T[ 391 SZE L&T 11 264 177 193 107 95 96 97 98 99 100 10 10 103 1 320 347 64 130 282 66 457 377 15 333 23 230 378 136 250 377 388 256 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 337 419) 123 124 125 126 127 128 129 130 131 132 133 171 278 184 357 368 409 100 154 160 239 186 383 156 217 452 208 317 60 134 135 1 17 138 1.9 1.11 185 383 53 282 188 | 52 106 74 14/ 147 143 14 145 | 147 | 1-19 277 484 08 22 | 4 14 10 15| 157 1.5.3 14 324 11 4) 41 313 156 J57 1 1 1 15: 48 13: 16 | 13 IfM 15 | 44 338 168 [f 17) 171 172 41 374 437 1 455