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

International business of ernst & young, International Business of Ernst & ...

International Business of Ernst & Young Ernst & Young is one of the largest global leaders in the professional service provider. As per the changing demand of the customers,

Line and staff conflict, what are the dynamics and consequences of line and...

what are the dynamics and consequences of line and staff conflict

Nature of the production systems, It is characterized by the number of m...

It is characterized by the number of manufacturing stages and the inter relationship between various production operations e, g, in product line systems inventory con

“’Confessions of a Microfinance Heretic’: Talks at G, dear team i need to m...

dear team i need to make a case analysis of 1500 woeds on the following topic, video is also provided with the instructions from university. please contact me asap.

What are the different features of interpersonal skills, QUESTION 1 (a)...

QUESTION 1 (a) What are the different sources of noise and interference that can occur in a communication process? (b) What are the ten aspects of communication that are use

Factors that help to prevent resistance to change, Question 1: (a) Disc...

Question 1: (a) Discuss three different levels of Management. (b) Differentiate between omnipotent and symbolic view of managers. (c) Explain the different functions of M

Concept of maintenance management, Plant  maintenance consists of all activ...

Plant  maintenance consists of all activities  needed to keep the plant machinery  tools and  equipment services including building and fittings in standards working condition. In

Management, tell me the functions of lower management ?

tell me the functions of lower management ?

How does organisational culture develop, Question 1: (a) How does organ...

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

Minority diversity, American Express Company and Merrill Lynch and Company ...

American Express Company and Merrill Lynch and Company use African-American employees to hold workshops and networking receptions in venues such as black museums to attract black i

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