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
The LD2 group has grown rapidly over the past five years by acquiring a number of smaller kitchen accessory manufacturers and kitchen suppliers and fitters. As a consequence of thi

Evaluating Capital-Expenditure Proposals at Biotechnique Chemicals In submitting a project for senior-management approval, the proposers had to identify it as belonging to one

Question: (a) Henry Mintzberg has put a lot of emphasis on decision making as a very aspect of the managers' job. In this context, Describe the decisional roles as proposed by

advantages and disadvantange of the line organisation


Case study: Mr Jones, an American, accepts a position as an adviser in an African country. He will work directly with Mr Nkosia citizen of the country. Together they have manag

1). Explain the meaning of Goal Setting and how it can increase the employee performance? 2).  The head of operations at Nano Tech Systems announced that the company "empowers i


QUESTION 1 Although all teams are groups, not all groups are teams. Discuss this statement with reference to any organisation of your choice QUESTION 2 Mr Fenworth,

Question: (a) Distinguish between a Management Information System and a Decision Support System. (b) Distinguish between different eBusiness Models. (c) Discuss on four