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.

Answer rating: 100% (QA)

Let say mapping of excel sheet column with heading names A order ... View the full answer