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
Describe briefly the main stages included in the (rational) process of consumer behaviour when making a purchase.   Problem/Need recognition The purchasing process is a pro

Could empowerment lead to powerless leaders, why or why not?

QUESTION Growth and development can be influenced by two sets of factors- The first set of factors cannot be easily modified. They are what we call inherited characteristics

Commonly used for delivery of fuel products, a truck / trailer combination has five product compartments: three in the lead trailer and two in the pup trailer. The lead trailer's c

Explain the relationship of basic components of the organisation. Relationship of the fundamental components of the organization: Objectives as decided within step I abov

What are the uses of control chart? Control chart: It is a daily graphical presentation of the collected information. Therefore information pertains to the measured or ot

Q. Write a short note on Information System Analysis? Ans. System analysis is the analysis of the trouble that the organization will try to solve with an information system. It

Lock-in, as explain by Hax and Wilde, is achieved when?                Ans) An company achieves a proprietary position in its business.

Different organizations & companies have different hierarchies & environments where information can be appeared in many different forms. As well as the flow of information can be c

Globalisation Globalisation is becoming increasingly popular amongst modern day business, due to the business market evolving at an extremely fast pace, it is necessary for or