I. Who are LVPG’s five best and five worst customers by total sales? Use an appropriate table and graph/chart
to summarise these observations.
II. What are LVPG’s best and worst Trade Fairs by total profit? Use an appropriate table and graph/chart to
summarise these observations.
III. Who are LVPG’s best and worst sales representatives by total profit? Use an appropriate table and
graph/chart to summarise these observations.
IV. What are the best Sales Representative’s best- and worst-selling services (by total profit)? Use an
appropriate table and graph/chart to summarise these calculations.
V. 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
I. Should LVPG focus on any particular (a) customer(s) and (b) Trade Fairs, in future, and why?
II. What are your recommendation regarding what other data should be collected to improve decision making
for LVPG?
III. What are your recommendation regarding record-keeping to improve the quality of data collection and
management?
IV. What changes should LVPG make regarding any currently employed Sales Representative(s), or to the fees
paid to the Sales Representatives, and why?