Business Information Systems

plan, schedule and execute project tasks with a view to improving your personal productivity;
gain awareness of some typical issues related to the operation of a small-to-medium size business;
use the functionality of Microsoft Excel 2007/2010 to manipulate data, analyse it and visualise it in tabular and chart form; and
use the functionality of Microsoft Word to write a brief report of your business observations and recommendations.
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?


Price: £ 89

100% Plagiarism Free & Custom Written, Tailored to your instructions

Leave your Comments


Can't read the image? click here to refresh