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

Business and cultural, Judge how the business and cultural environments sha...

Judge how the business and cultural environments shape the behaviour of a selected organisation

Assignment, Dear I have assignment 2100 words I need more 900 words how can...

Dear I have assignment 2100 words I need more 900 words how can I now price

Describe market development life cycle, Discuss the movement of a technolog...

Discuss the movement of a technology of your choice through the 'Market Development Life Cycle' presented by Geoffrey A. Moore (2004) in Darwin and the Demon: Innovating within Est

Tax differential theory, Tax differential theory: a method of valuing share...

Tax differential theory: a method of valuing shares with constant growth to DI/P0 Xg An investor is faced with 2 investment choices: First choice of shares with market price(po)=Rp

Ethical Organisational Management, Evaluate factors which could influence o...

Evaluate factors which could influence organisational ethics.

Definition of entrepreneur by harbison and peter f. drucker, Describe the d...

Describe the definition of entrepreneur according to Harbison and Peter F. Drucker. According to Harbison : "An entrepreneur, it is not an innovation but a business builder

Marketing, short note on marketing

short note on marketing

MTMG320 Business Information Systems, Hi I am Nelson Daniels I am checking ...

Hi I am Nelson Daniels I am checking up on my Ticket ID EM13830601 I see my payment has been authorized I need help on my 5.5 - Research Exercise: Microsoft Dynamics Research Rep

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

Tqm implementation, At this stage as senior managers becomes committed ...

At this stage as senior managers becomes committed and involved in preparing the plan for TQM implementation they start to : a. Point out the benefits of TQM for the o

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