Please help! Thank you.

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 To Price per Roll 1 40 $215 41 80 $195 81 160 $175 161 and up $155 Click on the datafile logo to reference the data. DATA file (a) Use VLOOKUP function with the preceding pricing table to determine the revenue from orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 40 $215 41 80 $195 81 160 $175 161 and up $155 172 D E F G H I J Quantity Ordered From To Price per Roll 1 40 $215 41 80 $195 81 160 $175 161 and up $155 161 A B Order Quantity 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 18 314 19 442 20 429 21 451 22 32 23 181 24 163 25 336 26 240 27 68 28 317 29 30 211 31 76 32 374 33 415 34 408 35 36 302 37 312 38 31 39 40 394 41 348 42 49 435 196 317 B D E E H T 43 44 49 500 490 94 45 43 44 45 46 47 48 49 50 285 46 47 48 49 51 GU 52 53 54 237 101 53 257 273 415 346 133 287 431 113 197 55 56 57 56 57 58 59 60 6 60 61 62 63 61 62 328 114 207 273 257 113 63 64 65 66 400 324 67 68 69 70 71 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 500 60 117 466 370 293 72 73 74 75 76 77 78 79 80 81 82 83 84 164 63 252 394 109 233 340 430 210 363 120 D E G J B. 363 120 429 85 86 113 391 87 375 487 88 89 90 91 92 11 264 14 93 177 94 95 193 427 96 97 320 347 64 430 282 66 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 123 124 125 126 127 120 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 457 377 15 333 23 230 378 136 250 377 388 256 337 419 171 278 184 357 368 409 123 124 125 126 127 100 154 160 239 186 202 A B D E 186 127 126 128 127 129 128 130 129 131 130 132 131 133 132 134 133 135 134 136 135 137 136 138 137 139 138 140 139 141 140 142 141 143 142 144 143 145 144 146 145 147 146 148 147 149 148 150 149 151 150 152 151 153 152 154 153 155 154 156 155 157 156 158 157 159 158 160 159 161 160 162 161 163 162 164 163 165 164 166 165 167 166 168 167 169 168 170 169 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 288 454 238 38 451 374 Data + A1 fx Order A D E B ZUZ 188 52 106 140 139 141 140 142 141 143 142 144 143 145 144 146 145 147 146 148 147 149 148 150 149 151 150 152 151 153 152 154 153 155 154 156 155 157 156 158 157 159 158 160 159 161 160 162 161 163 162 164 163 165 164 166 165 167 166 168 167 169 168 170 169 171 170 172 171 173 172 174 175 1761 346 277 484 208 229 311 450 304 379 15 99 324 151 179 460 441 309 37 305 348 85 135 288 454 238 38 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 $215 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 40 $215 41 80 $195 81 160 $175 161 and up $155 Click on the datafile logo to reference the data. DATA file (a) Use VLOOKUP function with the preceding pricing table to determine the revenue from orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 40 $215 41 80 $195 81 160 $175 161 and up $155 172 D E F G H I J Quantity Ordered From To Price per Roll 1 40 $215 41 80 $195 81 160 $175 161 and up $155 161 A B Order Quantity 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 18 314 19 442 20 429 21 451 22 32 23 181 24 163 25 336 26 240 27 68 28 317 29 30 211 31 76 32 374 33 415 34 408 35 36 302 37 312 38 31 39 40 394 41 348 42 49 435 196 317 B D E E H T 43 44 49 500 490 94 45 43 44 45 46 47 48 49 50 285 46 47 48 49 51 GU 52 53 54 237 101 53 257 273 415 346 133 287 431 113 197 55 56 57 56 57 58 59 60 6 60 61 62 63 61 62 328 114 207 273 257 113 63 64 65 66 400 324 67 68 69 70 71 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 500 60 117 466 370 293 72 73 74 75 76 77 78 79 80 81 82 83 84 164 63 252 394 109 233 340 430 210 363 120 D E G J B. 363 120 429 85 86 113 391 87 375 487 88 89 90 91 92 11 264 14 93 177 94 95 193 427 96 97 320 347 64 430 282 66 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 123 124 125 126 127 120 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 457 377 15 333 23 230 378 136 250 377 388 256 337 419 171 278 184 357 368 409 123 124 125 126 127 100 154 160 239 186 202 A B D E 186 127 126 128 127 129 128 130 129 131 130 132 131 133 132 134 133 135 134 136 135 137 136 138 137 139 138 140 139 141 140 142 141 143 142 144 143 145 144 146 145 147 146 148 147 149 148 150 149 151 150 152 151 153 152 154 153 155 154 156 155 157 156 158 157 159 158 160 159 161 160 162 161 163 162 164 163 165 164 166 165 167 166 168 167 169 168 170 169 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 288 454 238 38 451 374 Data + A1 fx Order A D E B ZUZ 188 52 106 140 139 141 140 142 141 143 142 144 143 145 144 146 145 147 146 148 147 149 148 150 149 151 150 152 151 153 152 154 153 155 154 156 155 157 156 158 157 159 158 160 159 161 160 162 161 163 162 164 163 165 164 166 165 167 166 168 167 169 168 170 169 171 170 172 171 173 172 174 175 1761 346 277 484 208 229 311 450 304 379 15 99 324 151 179 460 441 309 37 305 348 85 135 288 454 238 38 451 374 437 184 455