C or more. When customers E F K 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. Price Per Donut Commission Rates $217.55 0-11 $0.50 Type Threshold Rate Total Commission $0.00 12+ $0.40 Beverage 10% Sales > $5 $5.00 Buy a donut? Sales > $10 $10.00 Total Sales 1% 2% Rate Commissions Beverage Sales Amount Order #Donuts Beverage Price/Donut Donuts 1 60 $0.00 50.00 2 12 $0.00 $0.00 3 48 $66.24 $0.00 4 24 $3720 $0.00 5 10 $0.00 $0.00 6 3 $0.00 $0.00 7 6 $7.50 $0.00 8 48 $0.00 $0.00 9 36 $56.88 $0.00 10 6 $0.00 $0.00 11 4 $0.00 $0.00 12 3 50.00 50.00 13 9 $1161 $0.00 14 24 $0.00 $0.00 15 7 $0.00 $0.00 16 10 $0.00 $0.00 17 2 50.00 30.00 18 60 50.00 $0.00 19 12 $0.00 50.00 Boolean Functions IF Function Lohun End Total $0.00 $0.00 $66.24 $37.20 $0.00 $0.00 $7.50 $0.00 $56.88 $0.00 50.00 50.00 $11.51 $0.00 $0.00 $0.00 50,00 $0.00 30.00 Sales $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 SO 00 S0.00 $0.00 50.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total Commission $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 30.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $0.00 K Jin 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 3 24 4 24 8 60 36 9 7 8 36 3 11 12 3 60 36 36 36 48 9 60 60 24 24 $0.00 $0.00 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.16 $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 $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 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.16 $0.00 $0.00 $0.00 $0.00 50.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 $0.00 $0.00 $0.00 $0.00 50.00 $0.00 $0.00 $0.00 50.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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 36 12 5 7 5 4