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 quant discounts. The following table shows the price per roll depending on order size: Quantity Ordered To Price per Roll 50 $215 100 $195 200 $175 and up $155 Click on the datafile logo to reference the data. DATA file From 1 51 101 201 (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 Roll 1 51 101 201 To 50 100 200 and up $215 $195 $175 $155 Number of Orders 172
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 quant discounts. The following table shows the price per roll depending on order size: Quantity Ordered To Price per Roll 50 $215 100 $195 200 $175 and up $155 Click on the datafile logo to reference the data. DATA file From 1 51 101 201 (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 Roll 1 51 101 201 To 50 100 200 and up $215 $195 $175 $155 Number of Orders 172
Chapter5: Decimals
Section5.6: Ratios And Rate
Problem 481E: One elementary school in Ohio has 684 students and 45 teachers. Write the student-to-teacher ratio...
Related questions
Question
100%
![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
To
Price per Roll
50
$215
100
$195
200
$175
and up
$155
Click on the datafile logo to reference the data.
From
1
51
101
201
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.
Price per Roll
From
1
51
101
201
To
50
100
200
and up
$215
$195
$175
$155
Number of
Orders
172](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F52476ee9-c360-4937-8f5a-8576cacac103%2F85956494-f7f3-4eff-95fd-3acfece9c35d%2Fw6hso5_processed.png&w=3840&q=75)
Transcribed Image Text: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
To
Price per Roll
50
$215
100
$195
200
$175
and up
$155
Click on the datafile logo to reference the data.
From
1
51
101
201
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.
Price per Roll
From
1
51
101
201
To
50
100
200
and up
$215
$195
$175
$155
Number of
Orders
172
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 7 steps with 10 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![PREALGEBRA](https://www.bartleby.com/isbn_cover_images/9781938168994/9781938168994_smallCoverImage.gif)
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![PREALGEBRA](https://www.bartleby.com/isbn_cover_images/9781938168994/9781938168994_smallCoverImage.gif)
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill