OrderQuantity 186 Quantity Ordered 2452 From ToPrice per Roll 3492 130$215 4191 3160$195 5356 61120$175 6148 121and up$155 7342 8382 9276 10118 11464 12188 1325 14427 1530 16111 17161 18314 19442 20429 21451 2232 23181 24163 25336 26240 2768 28317 29435 30211 3176 32374 33415 34408 35196 36302 37312 3831 39317 40394 41348 4249 43500 44490 4594 46285 47237 48101 4953 50257 51273 52415 53346 54133 55287 56431 57113 58197 596 60328 61114 62207 63273 64257 65113 66400 67324 68500 6960 70117 71466 72370 73293 74164 7563 76252 77394 78109 79233 80340 81430 82210 83363 84120 85429 86113 87391 88375 89487 9011 91264 9214 93177 94193 95427 96320 97347 9864 99430 100282 10166 102457 103377 10415 105333 10623 107230 108378 109136 110250 111377 112388 113256 114337 115419 116171 117278 118184 119357 120368 121409 122100 123154 124160 125239 126186 127383 128156 129217 130452 131111 132208 133317 13460 135185 136383 13752 138282 139188 14052 141106 142346 143277 144484 145208 146229 147311 148450 149304 150379 15115 15299 153324 154151 155179 156460 157441 158309 15937 160305 161348 16285 163135 164288 165454 166238 16738 168451 169374 170437 171184 172455 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 OrderedFromТоPrice per Roll30$2153160$19561120$175121and up$155Click 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ТоPrice per RollNumber ofOrders130$21583160$19561120$175121and up$155172

Question

OrderQuantity        186  Quantity Ordered     2452  From ToPrice per Roll   3492  130$215   4191  3160$195   5356  61120$175   6148  121and up$155   7342        8382        9276        10118        11464        12188        1325        14427        1530        16111        17161        18314        19442        20429        21451        2232        23181        24163        25336        26240        2768        28317        29435        30211        3176        32374        33415        34408        35196        36302        37312        3831        39317        40394        41348        4249        43500        44490        4594        46285        47237        48101        4953        50257        51273        52415        53346        54133        55287        56431        57113        58197        596        60328        61114        62207        63273        64257        65113        66400        67324        68500        6960        70117        71466        72370        73293        74164        7563        76252        77394        78109        79233        80340        81430        82210        83363        84120        85429        86113        87391        88375        89487        9011        91264        9214        93177        94193        95427        96320        97347        9864        99430        100282        10166        102457        103377        10415        105333        10623        107230        108378        109136        110250        111377        112388        113256        114337        115419        116171        117278        118184        119357        120368        121409        122100        123154        124160        125239        126186        127383        128156        129217        130452        131111        132208        133317        13460        135185        136383        13752        138282        139188        14052        141106        142346        143277        144484        145208        146229        147311        148450        149304        150379        15115        15299        153324        154151        155179        156460        157441        158309        15937        160305        161348        16285        163135        164288        165454        166238        16738        168451        169374        170437        171184        172455 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 OrderedFromТоPrice per Roll30$2153160$19561120$175121and up$155Click 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ТоPrice per RollNumber ofOrders130$21583160$19561120$175121and up$155172

Accepted Answer

Quantity Ordered

From 
To
Price per Roll

1
30
$215

31
60
$195

61
120
$175

121
and up
$155…






Order	Quantity
1	86	Quantity Ordered
2	452	From	To	Price per Roll
3	492	1	30	$215
4	191	31	60	$195
5	356	61	120	$175
6	148	121	and up	$155
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
42	49
43	500
44	490
45	94
46	285
47	237
48	101
49	53
50	257
51	273
52	415
53	346
54	133
55	287
56	431
57	113
58	197
59	6
60	328
61	114
62	207
63	273
64	257
65	113
66	400
67	324
68	500
69	60
70	117
71	466
72	370
73	293
74	164
75	63
76	252
77	394
78	109
79	233
80	340
81	430
82	210
83	363
84	120
85	429
86	113
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	430
100	282
101	66
102	457
103	377
104	15
105	333
106	23
107	230
108	378
109	136
110	250
111	377
112	388
113	256
114	337
115	419
116	171
117	278
118	184
119	357
120	368
121	409
122	100
123	154
124	160
125	239
126	186
127	383
128	156
129	217
130	452
131	111
132	208
133	317
134	60
135	185
136	383
137	52
138	282
139	188
140	52
141	106
142	346
143	277
144	484
145	208
146	229
147	311
148	450
149	304
150	379
151	15
152	99
153	324
154	151
155	179
156	460
157	441
158	309
159	37
160	305
161	348
162	85
163	135
164	288
165	454
166	238
167	38
168	451
169	374
170	437
171	184
172	455

Quantity Ordered
From	To	Price per Roll
1	30	$215
31	60	$195
61	120	$175
121	and up	$155