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

Electronic purchase orders, QUESTION 1 (a) Requirements engineering is ...

QUESTION 1 (a) Requirements engineering is the process of discovering, documenting and maintaining a set of requirements for a computer - based system. What are requirements?

Risk and Return, In a report not to exceed five double-spaced typewritten p...

In a report not to exceed five double-spaced typewritten pages, analyze the results obtained from the three simulations performed, identify the source of the differences, and selec

Summarize and briefly explain the problem solving process, QUESTION 1 (...

QUESTION 1 (a) Summarize and briefly explain the problem solving process? (b) List techniques that have been developed to help individual and groups make better decisions

How is the span of control affected in the organisation, How is the span of...

How is the span of control affected in the organisation? Span of control: Span of control implies the number subordinates which report to an executive or the number of su

Explain the different instruments of monetary policies, Question 1 Write a...

Question 1 Write a note on the following Socialistic economy Capitalistic economy Question 2 Explain the different instruments of Monetary Policies Question

Secondary source of information, #questionList out the secondary sources of...

#questionList out the secondary sources of information while pursuing market research..

Left or Right, if you were one of the other foremen, what could you do to m...

if you were one of the other foremen, what could you do to make rajinder?s transition easier?

Essay, Discuss how the four major conceptual blocks apply in today''s firm ...

Discuss how the four major conceptual blocks apply in today''s firm settings. Specifically, discuss how these four major concepts can be applied to your personal experience in a pr

Enterprise resource planning cost benefit analysis, As CEO of SeaSpray Mari...

As CEO of SeaSpray Marine, Ron Greenwood knows it is important to control costs and to Respond quickly to changes in the highly competitive boat-building industry. When IDG Consult

Write a note on classification of business objectives, Q. Write a note on c...

Q. Write a note on classification of business objectives? 1) Economic Objectives - Functions of customer Segment - Innovations - Optimum use of resources 2) Social Objectives -

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