Save Submit Assignment for Grading Problem 10-13 Algo (Some Useful Excel Functions for Modeling) Question 3 of 5 Hint(s) Check My Work 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 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. x (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 100 $215 13 X 101 200 $195 15 X 201 400 $175 37 X 401 and up $155 107 X 172 Hide Feedback Co 72OF Cloudy ~ ( 6 9:52 A 99+ 2/23/20