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

Discuss four strategies which can be adopted by businesses, QUESTION 1 ...

QUESTION 1 (a) Businesses are increasingly exposed to scrutiny and criticisms. Discuss four strategies which can be adopted by businesses to respond to these criticisms (b)

Describe the meaning of hyper-competitive strategies, Hyper-competitive str...

Hyper-competitive strategies admit the bases of competitive benefit may not be sustainable and that disruption of the status quo may be significant.

Elaborate - we communicate primarily with words, QUESTION At the Season...

QUESTION At the Seasons Inn . . . Bala is waiting in her supervisor's office. She has come to talk with Manoj about a problem concerning next week's staff schedule. Just aft

Fully operational computer system, Explain the reasons why a department of ...

Explain the reasons why a department of an organisation might continue to use manual records rather than a new, recently installed and fully operational computer system. Severa

Discuss how the masculine and feminine language use differ, QUESTION 1 ...

QUESTION 1 a) Discuss how do stereotypes act as barriers to communication across cultures? Support your answer with examples. b) Explain and discuss on the sources of commun

Weaknesses of eoq formula, Weaknesses of EOQ Formula 1. Erratic Usa...

Weaknesses of EOQ Formula 1. Erratic Usages : The formula we have used assume that the usage of materials is both predictable and evenly distributed. When this is not t

Explain management the difference between transaction, QUESTION You hav...

QUESTION You have been appointed as the head of the treasury of an international firm with many subsidiaries abroad. The management of this multinational consists relatively of

Explain abraham maslows theory on motivation, Question 1: (a) Describe ...

Question 1: (a) Describe why ‘control' is an important function for a manager. (b) Using relevant examples, contrast the three types of control namely feedforward, concurrent

Interview question for manufacturing or service, Company background informa...

Company background information: which sector and industry (manufacturing or service, public or private) organizational characteristics (large versus small, average age

Centralization of authority and responsibility, Ask question the principle ...

Ask question the principle of centralization and responsibility

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