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
Define the departmental, long-term and non-economic managerial decisions. Departmental, Long-term and Non-Economic decisions: In long term decisions, there time period en

identify and explain the major problems in the case

Every morning a purchasing assistant will take the previous day's prescription log and parse it into two history files: filled prescriptions (drug name and quantity sold), and unfi

QUESTION On-line payment providers have started playing a big role in today's payment system, particularly, when Internet offers new business opportunities, making Epayment ver

A) The future usefulness of any Performance Management initiative in an organization is underpinned by the determination of Key Performance Indicators (KPI). Provide a brief outlin

Total Marks – 15 ( 1-2 pages answers) Large department stores are several storeys high and carry a wide range of products. In many of the departments, there are significant quanti

What kinds of problems can emerge if a firm doesn’t communicate with environmentalists, the news media, and the local community? Why? Do you know of any firms that aren’t responsiv

Question 1: (a) Explain the Communication Process Model and elaborate sequentially through the use of this model the various stages that can ensure effective business communic

QUESTION (a) Describe the levels and stages of decision making (b) What is the difference between a structured, unstructured and semi structured decisions? (c) List the t