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
How is the balance, flexibility and stability affected in the organisation? Balance, Flexibility and Stability: Every units of an organization should be balanced to attain

What are the Functions of Marketing Management? Functions of Marketing Management: The extensive functions of marketing management consist of the given below: a. Marke

Question 1: (a) Define Business Process Benchmarking and explain why it is used in a company. (b) Describe four types or forms of Benchmarking methods. Give one a

This case has been framed in order to test the skills in evaluating

the strategies that are used to strengthen a proposal argument and examples of each.

What are the various stages of the decision making process? Decision Making Process: A good decision can merely be made as a result of a rational decision making process.


What would be the aims and objectives of the business Luke is planning to implement after graduation? His Business deals with people that are unaware of the modern world of tech

how to start with assignment for stakeholder analysis and strategy program report

E-Care consultant Medical Network design business goals   We have gone to meet with the technical directors, to have a clear knowledge on their reasons of why they are inte