What are the best Sales Representative’s best- and worst-selling customers

a. Service fee for each value added services b. Cost for organising each value added services c. Total revenue from ticket sales d. Commission received from space rent e. Sales representative’s wage f. Sales representative’s commission g. Total income h. Total expenses i. Total profit II. Total profit, sub-totalled by each (a) Trade Fair, and (b) Sales Representative. Use Pivot Table(s) and appropriate graph(s)/chart(s) to summarise these calculations. III. Total hours worked, sub-totalled by each (a) Trade Fair, and (b) Sales Representative. Use Pivot Table(s) and appropriate graph(s)/chart(s) to summarise these calculations. Additional calculations (ITECH5005 Students Only): IV. Total income, sub-totalled by each (a) Trade Fair, (b) Sales Representative, and (c) Income type. Use Pivot Table(s) and appropriate graph(s)/chart(s) to summarise these calculations. V. Total expenses, sub-totalled by each (a) Trade Fair, (b) Sales Representative, and (c) Expense type. Use Pivot Table(s) and appropriate graph(s)/chart(s) to summarise these calculations. Task 2: Observations Ms White requires you to make observations to help her with the following questions. General Observations (All students): I. Who are BEMC’s five best and five worst customers by total profit? Use an appropriate table and graph/chart to summarise these observations. II. What are BEMC’s best and worst Trade Fairs by total profit? Use an appropriate table and graph/chart to summarise these observations. III. Who are BEMC’s best and worst sales representatives by total income? Use an appropriate table and graph/chart to summarise these observations. Additional observations (ITECH5005 Students Only): IV. What are the best Sales Representative’s best- and worst-selling customers (by total profit)? Use an appropriate table and graph/chart to summarise these calculations.