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

$1$

$5$

$0$

$-$

foot rolls and sells for $

$2$

$1$

$5$

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

$5$

$0$

$$$

$2$

$1$

$5$

$5$

$1$

$1$

$0$

$0$

$$$

$1$

$9$

$5$

$1$

$0$

$1$

$2$

$0$

$0$

$$$

$1$

$7$

$5$

$2$

$0$

$1$

$$and up $

$1$

$5$

$5$

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

$1$

$5$

$0$

$$$

$2$

$1$

$5$

$$

$5$

$1$

$1$

$0$

$0$

$$$

$1$

$9$

$5$

$$

$1$

$0$

$1$

$2$

$0$

$0$

$$$

$1$

$7$

$5$

$$

$2$

$0$

$1$

$$and up $

$1$

$5$

$5$

$$

$1$

$7$

$2$

Check My Work

$($

$5$

$$remaining

$)$