Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSRs 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 | 80 | $215 |
| 81 | 160 | $195 |
| 161 | 320 | $175 |
| 321 | and up | $155 |
| (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 | 80 | $215 | | | 81 | 160 | $195 | | | 161 | 320 | $175 | | | 321 | and up | $155 | | | | | | 172 | |
15 2 3 Order 1 2 3 4 Quantity 490 94 285 237 101 52 257 4 5 6 3 8 9 10 5 Order 130 131 132 133 134 135 136 132 138 139 Order 44 45 46 47 48 49 50 51 52 53 54 SS 56 57 58 59 60 61 140 141 142 143 144 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 12 13 14 15 16 17 18 19 20 21 22 23 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 433 211 76 374 273 415 346 133 287 431 113 197 6 328 114 207 273 257 113 400 324 500 60 117 466 Order Quantity 87 391 88 375 89 487 90 11 91 264 92 14 93 177 94 193 95 427 96 320 97 347 98 64 99 100 101 66 102 457 103 377 104 15 IOS 333 106 23 101 230 108 378 109 136 110 250 111 377 112 388 113 256 114 337 ITS 419 116 171 119 278 118 184 62 63 64 65 66 67 68 69 70 71 72 73 74 775 145 146 147 148 149 150 ISI 152 153 154 15$ 156 152 158 159 160 161 2 28 29 30 31 32 33 34 30 31 32 Data Ready MacB6 Times New Roman 12 ili u L115 D F A D 28 29 30 71 72 13 74 75 75 76 10 20 XX 114 115 116 117 118 119 120 121 122 317 435 211 76 374 415 40R 406 196 302 312 31 317 394 348 49 500 466 370 293 164 63 252 4 394 294 109 233 340 78 31 32 33 34 34 35 36 30 37 38 39 40 41 42 43 37 37 38 39 40 41 42 79 80 81 82 430 210 83 84 8S 363 120 429 123 124 125 126 127 128 129 86 113 61 15 2 3 Order 1 2 3 4 Quantity 490 94 285 237 101 52 257 4 5 6 3 8 9 10 5 Order 130 131 132 133 134 135 136 132 138 139 Order 44 45 46 47 48 49 50 51 52 53 54 SS 56 57 58 59 60 61 140 141 142 143 144 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 12 13 14 15 16 17 18 19 20 21 22 23 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 433 211 76 374 273 415 346 133 287 431 113 197 6 328 114 207 273 257 113 400 324 500 60 117 466 Order Quantity 87 391 88 375 89 487 90 11 91 264 92 14 93 177 94 193 95 427 96 320 97 347 98 64 99 100 101 66 102 457 103 377 104 15 IOS 333 106 23 101 230 108 378 109 136 110 250 111 377 112 388 113 256 114 337 ITS 419 116 171 119 278 118 184 62 63 64 65 66 67 68 69 70 71 72 73 74 775 145 146 147 148 149 150 ISI 152 153 154 15$ 156 152 158 159 160 161 2 28 29 30 31 32 33 34 30 31 32 Data Ready MacB6 Times New Roman 12 ili u L115 D F A D 28 29 30 71 72 13 74 75 75 76 10 20 XX 114 115 116 117 118 119 120 121 122 317 435 211 76 374 415 40R 406 196 302 312 31 317 394 348 49 500 466 370 293 164 63 252 4 394 294 109 233 340 78 31 32 33 34 34 35 36 30 37 38 39 40 41 42 43 37 37 38 39 40 41 42 79 80 81 82 430 210 83 84 8S 363 120 429 123 124 125 126 127 128 129 86 113 61
