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 40 $215 41 80 $195 81 160 $175 161 and up $155   Click on the datafile logo to reference the data. https://cnow.apps.ng.cengage.com/ilrn/books/cameba04h/datafiles/ch10/rsr_2.xlsx   (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 40 $215   41 80 $195   81 160 $175   161 and up $155         172

Q: Atlanta Airlines routinely overbooks its flight from At- lanta to Boston. Overbooking discounted…

A: Revenue per seat = $300. Overbooking price per seat =$450. The 120-passenger jet costs about $6000…

Q: A tourist has a pamphlet that contains the following list of taxi fares for various distance. How…

A: Given:- n = 4 Formula Used, The equation of the regression line is:- Y= a+bX Where b is the slope…

Q: The lunch meat Mrs. Sanchez bought is listed on the sales receipt below. Lunch Meat Quantity Price…

A: The lunch meat Mrs. Sanchez bought is listed on the sales receipt below. Lunch Meat Quantity…

Q: Complete the following table by finding the net price factor, single equivalent discount, trade…

A:

Q: A local FedEx Office store has a press that can print 5,800 brochures per hour. How many can be…

A: We need to find out the number of prints that FedEx can print in 3.25 hours.

Q: Kiet Ma sells refrigerators.  He carries 3 models.  Price and monthly sales for each model are…

A:

Q: As an intern for an office you are tasked with gathering lunch orders and bringing back the receipt…

A:

Q: Your friend’s office is having a weight loss contest, the winner will get $100. The participants'…

A:

Q: The higher education department of Holmes Institute recorded data on the number of students enrolled…

A: Step-by-step procedure to obtain side-by-side bar chart using EXCEL. Enter the above data in Excel.…

Q: A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that…

A: We have given data as shown in table below Annual Operating Days =250daysAnnual Demand…

Q: United​ Express, a national package delivery​ service, charges a base price for overnight delivery…

A: Given that, United​ Express, a national package delivery​ service, charges a base price for…

Q: A gift shop had overhead expenses totalling ​$2,779 during the month of July. The business recorded…

A: Overhead rate is calculated by the total amount of  sales by total overhead for each department of…

Q: Last year's freshman class at Big State University totaled 5,348 students. Of those, 1,263 received…

A:

Q: The vertical bar graph to the right shows the total sales by the days of the week for a certain gift…

A: Determine the day of the week had the highest amount in sales. The day of the week had the highest…

Q: A six controller thumb covers costs $2.10. At this rate, how much should 32 thumb covers cost? round…

A:

Q: The list price, that means the price without a discount, for a new iPad is $650. The local Apple…

A: 20% of iPad price $650 is=650100×20=$130

Q: Median household incomes tend to increase from one year to the next. In 2019, the median household…

A: In 2019: The median household income was $64101 in Madison, Wisconsin and $42087 in Milwaukee. In…