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

Memo format addressed to the vp marketing, As a Sales Manager, prepare a on...

As a Sales Manager, prepare a one page report in memo format addressed to the VP Marketing, providing sales updates for a newly launched FMCG product

How does organisational culture develop, Question 1: (a) How does organ...

Question 1: (a) How does organisational culture develop? (b) What are the functions of an organisational culture? (c) What are its drawbacks? Question 2: (a) What are t

Business environment in strategic formulation, Business environment in stra...

Business environment in strategic formulation A business strategy depicts how a specific business proposes to succeed in its preferred market place versus its competitors. It

Research Project, Undertake the proposed research investigation in accordan...

Undertake the proposed research investigation in accordance with the agreed specification and procedures

Major characteristics and policies of a company, Question 1 A well- for...

Question 1 A well- formulated strategy is vital for growth and development of any organization. Explain the corporate strategy in different types of organization. Question

logistics, whats the economic justification for rapid growth of preminum p...

whats the economic justification for rapid growth of preminum package serivices

What are the control charts in management, What are the control charts in m...

What are the control charts in management? Control Charts: These charts are based upon statistical sampling theory, as per that an enough sized sample drawn, at various f

Reflection, My university lecturer asked me to prepare a reflection on how ...

My university lecturer asked me to prepare a reflection on how was the class and how will the business edge subject will reflect to my life? please answer as soon as possible. abou

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