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
QUESTION a) Briefly explain the following two methods of e-procurement: i. Reverse Auctions ii. Industrial Malls b) Elaborate on three characteristics essential for e-


Question 1: (a) What are the features of an eMarket Place? (b) What is a digital signature and how does it provide for confidentiality in an eProcurement System? (c)

Question 1 Explain any five architectural components of CRM solution Question 2 Explain the different wireless technologies Question 3 Explain the meaning of Elect

Question 1: (a) How does organisational culture develop? (b) What are the functions of an organisational culture? (c) What are its drawbacks? Question 2: (a) What are t

QUESTION (a) Describe briefly five main features of an effective e-Business website. (b) Explain the terms intranet and extranet, and their importance in an e-Business compa

Research on environmental attitudes in the context of nature-based tourism and ecotourism in particular have emerged as an interesting topic among tourism researchers in recent yea

Briefly introduce the subject and describe its key business or operations. Appraise how it plans and manages quality. Analyse how quality can be used to support the strategies o

what are the benefits and cost of freign Direct Investment(FDI)

critically analyse diesel''''s marketing mix strategies