PROBLEMS 1. A sales manager is trying to determine appropriate sales performance bonuses for her team this year. The following table contains the data relevant to determining the bonuses, but it is not easy to read and interpret. Reformat the table to improve readabil ity and to help the sales manager make her decisions about bonuses. I I DATA file Total Sales (S) 325,000.78 13,678 21 452,359.19 87,423.91 87,654.21 234,091.39 379,401.94 31.733.59 127.845.22 Salesperson Smith, Michael Yu, Joe Reeves, Bill Hamilton, Joshua Harper, Derek Quinn, Dorothy Graves, Lorrie Sun, Y Thompson, Nicole Average Performance Bonus Previous Years (5) 12,499.3452 239.9434 21.987.2462 7,642.9011 1.250.1393 14,567.9833 27,981.4432 6729111 13,322.9713 Customer Years with Accounts Company 124 14 9 7 175 21 28 3 21 4 48 9 121 12 7 1 17 3 SalesBonuses