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

OPERATING CYCLE, DISCUSS THE APPLICABILITY OF OPERATING CYCLE IN VEGETABLE ...

DISCUSS THE APPLICABILITY OF OPERATING CYCLE IN VEGETABLE GROWING BUSINESS

Methods of work force in the training and education, What are the methods o...

What are the methods of work force in the training and education? Work Force: At this level the workers are to be familiarised with the job, with the organisation and are

Non tariff measures, The last 30 years has witnessed substantial reduction ...

The last 30 years has witnessed substantial reduction in the level of tariffs applicable by nations members to the WTO. However, this has also been accompagnied by a rapid prolifer

Critically analyze the stages involved in conflict process, Question 1: ...

Question 1: (a) What is Leadership? (b) What are the three critical situational variables identified by Fiedler? If these are very favorable, what is the most effective styl

Reducing balance method and straight line method, Satine Enterprise Ltd. ...

Satine Enterprise Ltd. a) Reducing balance method: Year Depreciation Net Book Value 0 0 $25,000

Explain the individual and group managerial decisions, Explain the individu...

Explain the individual and group managerial decisions. Individual and Group decisions: Individual decisions are considered by a single individual into context of routine

Advantages and disadvantages of ib4e, Over the past few years, the company ...

Over the past few years, the company iB4e has underperformed compared with its competitors which enjoy stronger brand recognition. In addition, lots of experienced staff responsibl

Lateral or horizontal communication , Lateral or horizontal communication i...

Lateral or horizontal communication is more important today than vertical communication. Do you agree or disagree? Justify your answer

Describe inter bank settlements, Question 1 The Banking Laws (Amendment) A...

Question 1 The Banking Laws (Amendment) Act 1983 introduced section 45 ZA in the Banking Regulation Act, 1949, which facilitates applicability of nomination to all deposit account

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