please help with formula for 1 & 2

Total Sales Bonus Amount Salesperson Name Jimmy Cruz Lily Agar Mary Benjamin Thomas Laura Molly Vanessa Nathan Style 1 $ 19,138.00 $ $ 12,113.00 $ 23,409.00 $ $ 16,044.00 $ $ 17,287.00 $ $ 15,671.00 $ $ 17,445.00 $ $ 19,338.00 $ $ 23,072.00 $ $ 23,883.00 $ $ 19,037.00 $ Product Line Style 2 Style 3 Style 4 19,463.00 $ 17,060.00 $ 18,781.00 $ 15,273.00 $ 17,017.00 $ 18,484.00 $ 19,228.00 $ 22,569.00 $ 18,678.00 $ 18,154.00 $ 18,329.00 $ 23,166.00 $ 22,992.00 $ 20,349.00 $ 14,945.00 $ 16,336.00 $ 13,497.00 $ 19,690.00 $ 23,350.00 $ 14,571.00 $ 17,046.00 $ 13,669.00 $ 22,833.00 $ 22,898.00 $ 14,438.00 $ 17,300.00 $ 22,205.00 $ 16,316.00 $ 22,656.00 $ 23,218.00 $ 14,005.00 $ 23,324.00 $ 13,796.00 $ Style 5 18,774.00 $ 14,712.00 $ 13,424.00 $ 12,283.00 $ 22,941.00 $ 19,098.00 $ 15,273.00 $ 21,923.00 $ 17,051.00 $ 19,397.00 $ 12,204.00 $ Style 6 18,925.00 20,167.00 21,422.00 14,610.00 20,800.00 12,364.00 22,380.00 14,077.00 16,280.00 12,910.00 23,802.00 2 1. Calculate the total sales for each of the Salesperson in Column] Bonsu Rate A Rate B 12.50% 8.75% 2. Calculate the Bonus Amount ($) in Column K for the Salesperson based on the following condition If the totalsales is greater than or equal to 100000 and if the sales in Style 4 is above 20000 - Bonus is given at Rate A (use cell C20) Otherwise Bonus is given at Rate B (use cell D20) Note: Your formula must refer to the cell C20 and D20) 3. Create a Column Chart titled Bonus 4. Creare a Pie Chart titled Bonus Amount