Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a dozen they cost $.40 each. Beverly earns a commission based on her sales performance. Because the bakery makes so much money on beverages, she earns 10% commission (based on the total sale) when a customer buys a drink. She also earns commission on her sales. She earns 2% on each sale that totals more than $10. She earns 1% commission on each sale that totals more than $5 (but less than $10). She does not earn commission on each sale that totals $5 or less (though she will earn the beverage commission). Complete the table below to help Beverly calculate her commission based on the 50 customers she helped this morning.

Transcribed image text: total sale) when a customer buys a drink. She also earns commission on her sales. She earns 2% or on each sale that totals more than $5 (but less than $10). She does not earn commission on each s commission). Complete the table below to help Beverly calculate her commission based on the 50 B G (though she will earn the beverage commission). Complete the table below to help Beverly calculate her commission based on the 50 customers she helped this morning. Price Per Donut 0-11 $0.50 12+ $0.40 Total Sales Total Commission $217.55 $0.00 Commission Rates Type Threshold Beverage Sales > $5 $5.00 Sales > $10 $10.00 Rate 10% 1% 2% Buy a donut? Sales Amount Order # # Donuts Beverage Price/Donut Donuts Total Rate 1 60 $0.00 $0.00 $0.00 2 12 $0.00 $0.00 $0.00 3 48 $66.24 $0.00 $66.24 4 24 $37.20 $0.00 $37.20 5 10 $0.00 $0.00 $0.00 6 3 $0.00 $0.00 $0.00 7 6 $7.50 $0.00 $7.50 8 48 $0.00 $0.00 $0.00 9 36 $56.88 $0.00 $56.88 Boolean Functions IF Function Lookup Functions Conditional Functions Commissions Sales Beverage Total Commission $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 6 9 B 8 48 9 36 10 6 11 4 12 3 13 9 14 24 15 7 16 10 17 2 18 60 19 12 20 3 21 24 22 4 23 24 24 8 60 26 36 27 9 Boolean Functions $0.00 $56.88 $0.00 $0.00 $0.00 $11.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 IF Function E F $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Lookup Functions H $0.00 $56.88 $0.00 $0.00 $0.00 $11.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 Conditional Functions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 25