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

Differences, Difference between selling concept & marketing conceptt

Difference between selling concept & marketing conceptt

Describe effective communication, Problem 1: (a) Describe clearly ‘Job ...

Problem 1: (a) Describe clearly ‘Job Analysis'. (b) Explain fully why ‘Job Analysis' is an important technique in ‘Managing People'. (c) What are the basic steps involved

Behaviour, Question: 1 What is meant by the core competency and synergy ...

Question: 1 What is meant by the core competency and synergy components of strategy? Give examples. Perform a SWOT analysis for the university campus you attend. Do you think yo

Differences between a functionalist and interpretivist, QUESTION 1 (a) ...

QUESTION 1 (a) Discuss the role of each of the three closely related patterns of group communication (cohesiveness, conformity and deviance) in groupthink. (b) Briefly descr

The business environment & corporate culture, Assessment Task 1 Graduat...

Assessment Task 1 Graduate Skills Workshop - Academic Writing. Students will be given a paraphrasing and Summarizing task to be done in class, during the tutorial period and

How is the leadership affected in the organization, How is the Leadership a...

How is the Leadership affected in the organization? Leadership: It is the knack of getting other people to obey you and do willingly the things which you need them to do.

Minimum maximum technique , Minimum Maximum Technique: The minimum maxi...

Minimum Maximum Technique: The minimum maximum system is often used in connection with manual inventory control systems. The minimum quantity is established in the same way a

Describe the decision making process, Question 1: What are the differen...

Question 1: What are the different factors in the external environment that affect your organisation? Question 2: "Working into teams is better than individual work". D

Objectives and applicability of 1948s factories act, What are the objective...

What are the objectives and applicability of 1948s Factories Act? Objectives and applicability of 1948s Factories Act: The Factories Act controls the conditions of work a

Two bin techniques, Two Bin Techniques : One of the oldest systems of i...

Two Bin Techniques : One of the oldest systems of inventory control is the two bin system, which is mainly adopted to control C group inventories. In the two bin system

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