Show the sales for a product, Business Management

Assignment Help:

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)


Related Discussions:- Show the sales for a product

Differentiate between the internet and the world wide web, QUESTION The...

QUESTION The advent of the internet in the 1960s and the World Wide Web in the 1990s has revolutionised global communications. (a) Differentiate between the Internet as well

What do you understand by communication theories, Question 1: i) Wha...

Question 1: i) What do you understand by communication theories? ii) What are the differences or similarities between a post-positivist and interpretive perspective of theor

Customer relationship management , describe your proposed detail process fl...

describe your proposed detail process flows for the following processes 1) questions related to bills 2) question related to moving to other addresses 3) question related to new /

How is the matrix organisation created, How is the matrix organisation crea...

How is the matrix organisation created? Matrix organization is created through merging (as two complementary structures, as like) pure project organization and also functional

Causes of factors contributes to accidents in organization, Accidents  are ...

Accidents  are  usually the  results  of a combination of  factors each one of which  may very  from  situation. An  accident  does no have  a single cause but  multiplicity  of ca

Maintanace, as an enterpreneur ,if given 50000 what business would you do?

as an enterpreneur ,if given 50000 what business would you do?

Explain a business model, Question: Using Amazon.com as a business mode...

Question: Using Amazon.com as a business model: (a) Describe its positioning in the Internet value network. (b) Discuss the value configuration(s) of the online bookshop

The four seasons corporation, what market segment will the company be targe...

what market segment will the company be targeting?why?

Leadership, Why is it important for a leader to be able to manage across cu...

Why is it important for a leader to be able to manage across cultures? Communicate your thoughts on the following statement: “Leaders who cannot understand cultural differences in

Consumer ., "consumer mind is a black box" discuss

"consumer mind is a black box" discuss

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd