To analyse a set of data (in Microsoft Excel), and write a brief report (in Microsoft Word), identifying and explaining your insights into the operation of Trade Fair organized by "Latrobe Valley Product Gallery". Learning Objectives

In the process of this assessment task you will:
• 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.

Calculations (All Students):

a. total sales, sub-totalled by each (a) Trade Fair, (b) Sales Representative, and (c) income type.

b. total profit, sub-totalled by each (a) Trade Fair, and (b) Sales Representative.

c. total expenses, sub-totalled by each (a) Trade Fair, (b) Sales Representative, and (c) cost type.

d. total hours worked, sub-totalled by each (a) Trade Fair, and (b) Sales Representative.

e. changes to profitability over past decade, including 2014 figures, sub-totalled by each Trade Fair.

f. Who are LVPG's five best and five worst customers by total sales?

g. What are LVPG's best and worst value-added services by total profit?

h. What are LVPG's best and worst Trade Fairs by total profit?

i. What would happen to profits if the rate of pay to Sales Representatives for hours worked on sales was increased by 40%?

j. What are the best Sales Representative's best- and worst-selling services (by total profit)?

k. What would happen to profits if the amount of space required to be sold to change the rate of commission paid was changed from 20 sq.m. to (a) 25 sq.m. and (b) 30 sq.m.

l. Should LVPG focus on any particular (a) customer(s), (b) Trade Fairs, and (c) particular sales activities in future, and why?

m. What are your recommendations for resolving any data quality issues observed in the workbook?

n. What are your recommendation regarding what other data should be collected to improve decision making for LVPG?

o. What are your recommendation regarding record-keeping to improve the quality of data collection and management?

p. What changes should LVPG make regarding any currently employed Sales Representative(s), or to the fees paid to the Sales Representatives, and why?

Attachment:- Assignment_data.rar