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 60 $215 61 120 $195 121 240 $175 241 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 Orders 1 60 $215 61 120 $195 121 240 $175 241 and up $155
Added by Shannon D.
Close
Step 1
Step 1: To determine the total revenue from these orders, we need to calculate the revenue for each order and then sum them up. Show more…
Show all steps
Your feedback will help us improve your experience
Sri K and 72 other Intro Stats / AP Statistics educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
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 (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 Orders 1 100 $215 ? 101 200 $195 ? 201 400 $175 ? 401 and up $155 ?
Sri K.
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 Orders 1 | 100 | $215 101 | 200 | $195 201 | 400 | $175 401 | and up | $155 172
T. L.
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 Orders 1 90 $215 91 180 $195 181 360 $175 361 and up $155 172
Ameer S.
Recommended Textbooks
Elementary Statistics a Step by Step Approach
The Practice of Statistics for AP
Introductory Statistics
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD