This paper circulates around the core theme of Business Information Systems together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
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?
