70.2K

Verified Solution

Link Copied!

Order Quantity

$186$ Quantity Ordered

$2452$ From To Price per Roll

$3492160$ $$215$

$419161120$ $$195$

$5356121240$ $$175$

$6148241$ and up $$155$

$7342$

$8382$

$9276$

$10118$

$11464$

$12188$

$1325$

$14427$

$1530$

$16111$

$17161$

$18314$

$19442$

$20429$

$21451$

$2232$

$23181$

$24163$

$25336$

$26240$

$2768$

$28317$

$29435$

$30211$

$3176$

$32374$

$33415$

$34408$

$35196$

$36302$

$37312$

$3831$

$39317$

$40394$

$41348$

$4249$

$43500$

$44490$

$4594$

$46285$

$47237$

$48101$

$4953$

$50257$

$51273$

$52415$

$53346$

$54133$

$55287$

$56431$

$57113$

$58197$

$596$

$60328$

$61114$

$62207$

$63273$

$64257$

$65113$

$66400$

$67324$

$68500$

$6960$

$70117$

$71466$

$72370$

$73293$

$74164$

$7563$

$76252$

$77394$

$78109$

$79233$

$80340$

$81430$

$82210$

$83363$

$84120$

$85429$

$86113$

$87391$

$88375$

$89487$

$9011$

$91264$

$9214$

$93177$

$94193$

$95427$

$96320$

$97347$

$9864$

$99430$

$100282$

$10166$

$102457$

$103377$

$10415$

$105333$

$10623$

$107230$

$108378$

$109136$

$110250$

$111377$

$112388$

$113256$

$114337$

$115419$

$116171$

$117278$

$118184$

$119357$

$120368$

$121409$

$122100$

$123154$

$124160$

$125239$

$126186$

$127383$

$128156$

$129217$

$130452$

$131111$

$132208$

$133317$

$13460$

$135185$

$136383$

$13752$

$138282$

$139188$

$14052$

$141106$

$142346$

$143277$

$144484$

$145208$

$146229$

$147311$

$148450$

$149304$

$150379$

$15115$

$15299$

$153324$

$154151$

$155179$

$156460$

$157441$

$158309$

$15937$

$160305$

$161348$

$16285$

$163135$

$164288$

$165454$

$166238$

$16738$

$168451$

$169374$

$170437$

$171184$

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

$160$ $$215$

$61120$ $$195$

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

$160$ $$215$

$18$

$61120$ $$195$

$22$

$121240$ $$175$

Answer & Explanation Solved by verified expert

See Answer