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

Write advantages and disadvantages of structuring a deal., Write advantages...

Write advantages and disadvantages of structuring a deal.

What are the factors of non-monetary motivation, What are the factors of no...

What are the factors of non-monetary motivation? Non-monetary Motivation: The factors leading mainly towards motivation are as follows: a. Achievement: Personal satisfacti

Functions of inventory control, 1. Ensure Timely Availability of Materials:...

1. Ensure Timely Availability of Materials: Inventory control helps is preventing delays due to lack of materials by ensuring regular supply of proper qualities of mater

What is meant by business process management, Define what is meant by 'Busi...

Define what is meant by 'Business Process Management' (BPM) and briefly explain the role of various technologies in assisting BPM achieve its objectives.

Business-to-consumer trading through online trading, Technology has transfo...

Technology has transformed organisations, industries and ways of doing business.  Explain the reasons for the growth of business-to-consumer (B2C) trading through onlin

Discuss how does a persons identity reflects his own culture, QUESTION 1 ...

QUESTION 1 How does body language differ from culture to culture? Using the day to day life situations, give the differences and similarities of the non-verbal communication am

Identify and describe some of the environmental factors, QUESTION Growt...

QUESTION Growth and development can be influenced by two sets of factors- The first set of factors cannot be easily modified. They are what we call inherited characteristics

Identify levels of interdependence - financial institution, Q. Identify thr...

Q. Identify three levels of interdependence and give an organizational example for each Q. A large financial institution is losing market share to savvy upstart companies, and i

9 cor concepts, what are the nine core concepts of marketing?

what are the nine core concepts of marketing?

Explain effective decision making process, Question 1: (a) Why is the f...

Question 1: (a) Why is the function of controlling important to an organisation? (b) What are the steps that need to be followed in implementing an effective control 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