Show the sales for a product, Business Management

a) Copy the sales data provided on the VLE into a separate worksheet within your Garden workbook and call it Sales Database. Sort this data into sales for each month in 2010 and show a subtotal of the sales for each month. Use these subtotals to produce a bar chart for total monthly sales during 2010.

b) Sort the data into Sales by Product and create a sub total for quantity of each sold. Produce a pie chart to represent the sales of each garden extra.

c) Add a filter to show the sales for a particular product selected by the user.

d) You should be able to see which product has sold the most and which the least, Use the MIN and Max functions to confirm your view, and to display which product has sold the most and which the least. (VLOOKUP will be required)

Posted Date: 3/25/2013 1:57:11 AM | Location : United States







Related Discussions:- Show the sales for a product, Assignment Help, Ask Question on Show the sales for a product, Get Answer, Expert's Help, Show the sales for a product Discussions

Write discussion on Show the sales for a product
Your posts are moderated
Related Questions
Question 1: (a) Define the concept of ‘organisation' and ‘organisational behavior' (b) Discuss the importance of job satisfaction in organisations. Question 2: (a) D

Think of an organization with which you are familiar, perhaps one you have worked for or where you were a member. Then answer the following questions. 1) Using the jobs characte

QUESTION 1 Discuss the development of libraries in Mauritius. QUESTION 2 Discuss the functions of school libraries. QUESTION 3 Developments in the 21st century

Question : "Strong retention practices may reduce turnover, but they limit the introduction of new talent, knowledge and perspectives, leading organisations to become stale an

Describe any situation in your experience where the communication was a failure. Analyze the barrier(s) which stood in the way of successful communication. Explain how you would ov

QUESTION a) After five years of work in the human resources department at XYZ Co Ltd, you were laid off in a round of cost cutting moves that broke through the financial indust

Explain the individual and group managerial decisions. Individual and Group decisions: Individual decisions are considered by a single individual into context of routine

Row Minima Methods: Steps1: The smallest cost  in the first  row  of the  transportation table  is determined. Let it be C 1j   . allocate as much  as possible amount X 1j

Advantages of Entrepreneurship Development You will be your own boss and the boss of other people and make the decisions that are crucial to the business' success or failu

It is an imperative that when formulating Operational plans the environments in which the business operates in are considered, identify the environments and the tools used to analy