80.2K

Verified Solution

Link Copied!

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 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. (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 101 200 $195 201 400 $175 74 401 and up $155 172 D E F G 1 2 3 4 Quantity Ordered From 1 101 201 5 To Price per Roll 100 $215 200 $195 400 $175 $155 6 401 and up 7 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 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 161 18 314 19 442 20 429 21 451 22 32 23 181 24 163 25 336 26 240 27 68 28 317 29 435 30 211 31 76 32 374 33 415 34 408 35 196 36 302 37 312 38 31 39 317 40 394 41 348 43 44 15 45 16 46 17 47 or 40 10 49 50 30 57 31 59 32 52 33 BM 34 D FC 30 37 50 50 39 60 45 45 no 46 17. 47 ne 48 20 49 50 so 51 1 so 32 52. 33 64 34 cc 19 co 62 62 63 20 69 70 70 71 69 70 394 80 81 82 81 82 83 83 84 85 86 363 120 429 113 391 375 487 87 88 89 90 91 92 93 94 95 96 97 98 99 84 85 86 87 88 89 90 91 92 93 4 95 6 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 100 101 102 103 104 11 264 14 177 193 427 320 347 64 430 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 122 123 124 337 419 171 278 184 357 368 409 100 154 160 125 126 239 186 383 127 128 129 130 131 132 156 217 452 111 208 317 60 185 383 133 134 135 136 126 127 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 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 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 153 154 155 156 157 158 152 153 154 155 159 1601 161 162 163 156 157 158 159 160 161 162 163 1641 165 166 167 164 165 166 168 169 170 171 172 173 167 168 169 170 171 172 38 451 374 437 184 455 11 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 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. (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 101 200 $195 201 400 $175 74 401 and up $155 172 D E F G 1 2 3 4 Quantity Ordered From 1 101 201 5 To Price per Roll 100 $215 200 $195 400 $175 $155 6 401 and up 7 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 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 161 18 314 19 442 20 429 21 451 22 32 23 181 24 163 25 336 26 240 27 68 28 317 29 435 30 211 31 76 32 374 33 415 34 408 35 196 36 302 37 312 38 31 39 317 40 394 41 348 43 44 15 45 16 46 17 47 or 40 10 49 50 30 57 31 59 32 52 33 BM 34 D FC 30 37 50 50 39 60 45 45 no 46 17. 47 ne 48 20 49 50 so 51 1 so 32 52. 33 64 34 cc 19 co 62 62 63 20 69 70 70 71 69 70 394 80 81 82 81 82 83 83 84 85 86 363 120 429 113 391 375 487 87 88 89 90 91 92 93 94 95 96 97 98 99 84 85 86 87 88 89 90 91 92 93 4 95 6 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 100 101 102 103 104 11 264 14 177 193 427 320 347 64 430 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 122 123 124 337 419 171 278 184 357 368 409 100 154 160 125 126 239 186 383 127 128 129 130 131 132 156 217 452 111 208 317 60 185 383 133 134 135 136 126 127 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 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 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 153 154 155 156 157 158 152 153 154 155 159 1601 161 162 163 156 157 158 159 160 161 162 163 1641 165 166 167 164 165 166 168 169 170 171 172 173 167 168 169 170 171 172 38 451 374 437 184 455 11

Answer & Explanation Solved by verified expert

See Answer