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 90 $215 91 180 $195 181 360 $175 361 and up $155 Click on the datafile logo to reference the data. (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 190 $ 215 91 180 $195 181 360 $175 361 and up $155 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 quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 90 $215 91 180 $195 181 360 $175 361 and up $155 Click on the datafile logo to reference the data. (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 190 $ 215 91 180 $195 181 360 $175 361 and up $155 172
Algebra: Structure And Method, Book 1
(REV)00th Edition
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Chapter8: Introduction To Functions
Section: Chapter Questions
Problem 33CLR
Related questions
Question
None
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 From To Price per Roll
1 90 $215 91 180 $195 181 360 $175 361 and up $155 Click on the datafile logo to reference the data. (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 190 $
215 91 180 $195 181 360 $175 361 and up $155 172
Expert Solution
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 2 steps
Recommended textbooks for you
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…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
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…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill