Quantity Ordered FromToPrice Per Roll1 and up OrderQuantity 186 2452 3492 4191 5356 6148 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 $210 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size:Quantity OrderedFromToPrice per Roll ($)1100210101150180151250165251and up150The file RSR_alt.xlsx contains 172 orders that have arrived for the coming six weeks.(a)Use the XLOOKUP function with the preceding pricing table to determine the total revenue (in dollars) from these orders.$ (b)Use the COUNTIF function to determine the number of orders in each price bin.Quantity OrderedFromToPrice per Roll ($)Number of Orders1100210 101150180 151250165 251and up150

Name: Quantity Ordered FromToPrice Per Roll1 and up OrderQuantity
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: Quantity Ordered FromToPrice Per Roll1 and up OrderQuantity 186 2452 3492 4191 5356 6148 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 33

172 orders along with the quantity ordered are provided below:Price charged per roll is given below:

Answered: Richardson Ski Racing (RSR) sells…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Concept explainers

Topic Video

Question

Quantity Ordered
From	To	Price Per Roll
1


	and up

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
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

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 $210 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	210
101	150	180
151	250	165
251	and up	150

The file RSR_alt.xlsx contains 172 orders that have arrived for the coming six weeks.

(a)

Use the XLOOKUP function with the preceding pricing table to determine the total revenue (in dollars) from these orders.

(b)

Use the COUNTIF function to determine the number of orders in each price bin.

Quantity Ordered

From	To	Price per Roll ($)
1	100	210
101	150	180
151	250	165
251	and up	150

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions