Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSRs 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	80	$215
81	160	$195
161	320	$175
321	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
1	80	$215	________________
81	160	$195	_______________
161	320	$175	_______________
321	and up	$155	_______________
			172