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	60	$215
61	120	$195
121	240	$175
241	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	60	$215
61	120	$195
121	240	$175
241	and up	$155
			172