Observations (All students): 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...

Observations (All students):
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.
Observations (ITECH5005 Students Only):
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.
Ms Rose also requires you to make recommendations concerning the following business-level questions.
Recommendations (All Students):
I. Should LVPG focus on any particular (a) customer(s) and (b) Trade Fairs, in future, and why?
Assignment
School Engineering and Information Technology
ITECH1005-5005: Business Information Systems
5 of 8
II. What are your recommendation regarding what other data should be collected to improve decision making for LVPG?
Recommendations (ITECH5005 Students Only):
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?