Na.total sales, 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.

b.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.

c.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.

d.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.

e.changes to profitability over the past decade, including 2014 figures, sub-totalled by each Trade Fair. Use an appropriate graph/chart to summarise these changes.

f.Who are BTFC’s five best and five worst customers by total sales? Use an appropriate table and graph/chart to summarise these observations.

g.What are BTFC’s best and worst value-added services by total profit? Use an appropriate table and graph/chart to summarise these observations.

h.What are BTFC’s best and worst Trade Fairs by total profit? Use an appropriate table and graph/chart to summarise these observations.

i.What would happen to profits if the rate of pay to Sales Representatives for hours worked on sales was increased by 40%? Use an appropriate table and graph/chart to summarise these calculations.

Read less