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
‘Although the elegance and comprehensiveness of transactions costs reasoning has provided the internalisation approach with a powerful logic (Rugman, 1981, 1985), it is still defic

a) Describe how economic systems attempt to allocate resources effectively b) Assess the impact of fiscal and monetary policy on business organisations and their Activities c)

a)from the above case shareholders are very worried that Apple is having too much cash,discuss six reasons of why shareholders are so worried?

Question One: (2.5 Marks) Suppose you are a senior manager in a global management consulting company. Which conflict management style do you think is the best and would you adopt

What should Mr. Sharma have done to avoid the misunderstanding?

1) Discuss fully 7 points of TQMS within the 14 step framework as defined by the Deming. - Please ensure you provide the pros and cons of each point you discuss 2) How is Qualit

QUESTION 1 Library cooperation is a well-integrated activity in developed countries. Discuss the areas in which libraries can cooperate. QUESTION 2 Ranganathan has sugg

QUESTION a) Expand the term B2B and B2C. Give one example of each type of business that each represents. b) Compare traditional commerce with electronic commerce and explain

What is the system concept of organisation? Explain briefly. System concept of Organisation: 1.  System is a group of independent although inter dependent tools (called

Refine your complex spreadsheet model to improve efficiency. a) The user needs to enter at least one of the following contact details: Home Phone, Mobile or E-mail address. If