Questions based on case study: Observations

Questions based on case study: Observations (All students):
f) Who are LVPG’s five best and five worst customers by total sales? Use an appropriate table and
graph/chart to summarise these observations.
g) What are LVPG’s best and worst value-added services by total profit? Use an appropriate table and
graph/chart to summarise these observations.
h) What are LVPG’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 50%? Use an appropriate table and graph/chart to summarise these calculations.
Observations (ITECH5005 Students Only):
j) 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.
k) What would happen to profits if the amount of space required to be sold to change the scale of
commission paid was changed from 20 sq.m. to (a) 25 sq.m. and (b) 30 sq.m. Use an appropriate table
and graph/chart to summarise these calculations.