Calculator
Sort by
 
Product Unit Sales Dollar Sales Price
Brand Type Fragrance Units % Change Dollars % Change Average Price $ Change
Clean It! Spray Orange 4,768,920 7.1% $ 14,163,690.00 3.6% $ 2.97 $ -0.10
Clean It! Aerosol Orange 6,695,560 3.9% $ 21,693,610.00 14.8% $ 3.24 $ 0.31
Deluxe Powder Lemon 525,040 -16.7% $ 1,627,620.00 -23.8% $ 3.10 $ -0.29
Deluxe Aerosol Orange 4,934,600 2.9% $ 12,879,300.00 21.5% $ 2.61 $ 0.40
Deluxe Spray Orange 4,432,700 0.9% $ 16,223,680.00 16.4% $ 3.66 $ 0.49
Dirt Blaster Aerosol Orange 2,440,870 6.9% $ 7,151,740.00 -7.3% $ 2.93 $ -0.45
Dirt Blaster Spray Orange 2,179,130 6.0% $ 6,101,560.00 14.1% $ 2.80 $ 0.20
Incredible Spray Lemon 147,470 -18.3% $ 427,660.00 -24.7% $ 2.90 $ -0.25
Incredible Aerosol Unscented 3,654,370 -11.1% $ 11,547,800.00 -1.4% $ 3.16 $ 0.31
Magic Clean Aerosol Lemon 1,569,200 -4.0% $ 4,613,440.00 9.3% $ 2.94 $ 0.36
Magic Clean Spray Unscented 6,673,490 -1.3% $ 27,494,770.00 8.4% $ 4.12 $ 0.37
Mrs. Grime Aerosol Lemon 5,208,300 -4.1% $ 22,395,690.00 4.6% $ 4.30 $ 0.36
Mrs. Grime Spray Unscented 4,242,520 -2.5% $ 13,109,380.00 3.8% $ 3.09 $ 0.19
Super Clean Spray Fresh 8,674,230 10.8% $ 33,482,520.00 23.2% $ 3.86 $ 0.39
Super Clean Aerosol Fresh 1,248,640 8.2% $ 5,406,610.00 6.9% $ 4.33 $ -0.05
Tornado Spray Fresh 1,694,650 4.4% $ 6,575,240.00 15.0% $ 3.88 $ 0.36
Tornado Aerosol Unscented 1,537,820 -7.9% $ 5,274,720.00 -1.5% $ 3.43 $ 0.22
Ultra Shine Aerosol Fresh 5,010,090 3.1% $ 15,431,070.00 12.2% $ 3.08 $ 0.25
Ultra Shine Spray Fresh 2,235,370 2.1% $ 7,019,060.00 1.7% $ 3.14 $ -0.01
Ultra Shine Powder Lemon 8,661,260 3.3% $ 34,558,420.00 12.0% $ 3.99 $ 0.31
The table above gives sale information for the 20 bathroom cleaners in the United States in 2010. For each product, the table describes the brand of the product, the product type, fragrance, unit sales, percent change in unit sales since 2009, total dollar sales, percent change in dollar sales since 2009, average price of each unit sold, and the dollar change in price since 2009.


TrueFalse 
 Spray bathroom cleaners generated more dollar sales than any other single type of bathroom cleaner in 2010.
 Half of the bathroom cleaners that experienced a drop in average price from 2009 to 2010 were aerosol cleaners.
 Ultra Shine brand bathroom cleaners experienced greater total unit sales growth from 2009 to 2010 than did Deluxe brand bathroom cleaners.
 No orange-scented bathroom cleaner sold more units in 2009 than in 2010.

  1. True With this question, the author is hoping to draw you into a time pit of calculations but will reward you for efficient logic if you see that the calculations are unnecessary. On a true/false question like this, it's typically best to take the statement and hold it up to scrutiny; in this example, the statement is that "Spray cleaners generated more dollar sales than any other single type of bathroom cleaner". Your burden of proof, then, is to find one type that could have outsold spray cleaners - you only need to consider the cleaner types that are even "contenders". Accordingly, Powder cleaners are irrelevant - there are only two such cleaners and the leading cleaner doesn't have enough separation from the field to make it a runaway category. The decision to be made is between Spray and Aerosol, and so your mission is to determine which sold more. You can effectively do this by viewing it as a "horse race" and not a calculation. Spray starts with two higher-sellers than Aerosol, earning approximately $33M and $27M to Aerosol's two biggest totals, $22M and $21M. This gives Spray a $17M "gap" that Aerosol needs to make up, and with the next highest seller also a Spray Cleaner, the gap widens to nearly $18M. From there, you can simply compare one-to-one the remaining Spray and Aerosol cleaners on the Dollar Sales list to see whether the gap will come down to something competitive. It does not - notice that further down the list the dollar figures become so small that they'll make little if any dent in that gap between Spray totals and Aerosol totals. Rather than calculate, you can logically call this one a runaway just by judging the gaps at the top of the list and noting the limited opportunities for Aerosol to close it down.

  2. False. Of the six cleaners to experience a decrease in average price, only two were aerosol cleaners. To most quickly solve this problem, sort by the "$ change" field to get the reduced-price items aligned together so that you can quickly determine which types of cleaners make up that group of six.

  3. True. This question may appear to require you to perform some calculations, but it can safely be inferred from the data that Ultra Shine had a significantly greater increase in unit sales. Deluxe's Lemon Powder cleaner experienced a substantial (16.7%) loss, and its other two cleaners each had lower percentage unit sales changes than did the top two Ultra Shine cleaners, with the Ultra Shine cleaners each having a higher total volume than the highest Deluxe cleaner. With the third Ultra Shine cleaner also experiencing a percentage increase, it should be relatively clear that the Ultra Shine cleaners had a substantially higher unit sales increase than did the cleaners made by Deluxe.

  4. True. Each of the six Orange sprays experienced a positive % change in unit sales. To most efficiently solve a problem like this, sort by the fragrance type to align all six like fragrances together, then check each for a positive or negative % change in unit sales.