D E F G H K L 1 2 3 Price Per Donut 0-11 $0.50 12 $0.40 Total Sales Total Commission $217.55 $0.00 4 5 6 7 8 9 10 Commission Rates Type Threshold Rate Beverage 10% Sales > $5 $5.00 1% Sales > $10 $10.00 2% Buy a donut? Donut Threshold $40.00 Rate 1 36 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Sales Amount Order # 1 Donuts Beverage Price/Donut Donuts 1 $0.00 $0.00 2 12 $0.00 $0.00 3 48 $66.24 $0.00 4 24 $37.20 $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 $56.88 $0.00 10 6 $0.00 $0.00 11 4 $0.00 $0.00 12 3 $0.00 $0.00 13 9 $11.61 $0.00 14 24 $0.00 $0.00 15 7 $0.00 $0.00 16 10 $0.00 $0.00 17 2 $0.00 $0.00 18 60 $0.00 $0.00 19 12 $0.00 $0.00 20 3 $0.00 $0.00 21 24 $0.00 $0.00 22 4 $5.76 $0.00 23 24 $0.00 $0.00 24 8 $10.40 $0.00 25 60 $0.00 $0.00 26 36 $0.00 $0.00 Total $0.00 $0.00 $66.24 $37.20 $0.00 $0.00 $7.50 $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 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 $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 $0.00 IF Function