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

Knowledge and independence worked for entrepreneur, How are knowledge and i...

How are knowledge and independence worked for an entrepreneur? Knowledge: An entrepreneur has complete knowledge regarding all the technicalities of his business, this is tec

Balance-flexibility-stability affected in the organisation, How is the bala...

How is the balance, flexibility and stability affected in the organisation? Balance, Flexibility and Stability: Every units of an organization should be balanced to attain

Finance, finance via internet

finance via internet

Controling, measure of actual performances

measure of actual performances

Explain the problem of industrial marketing in india, Explain the problem o...

Explain the problem of industrial marketing in India. Problem of Industrial Marketing in India: Industrial market comprises all individuals and organisations which acquire

Describe any two characteristics of a formal organization, QUESTION (a)...

QUESTION (a) Using suitable instances distinguish between formal and informal organization. (b) Describe any two characteristics of a formal organization. (c) Illustrate

Business process analysis, Business Process Analysis 1. Comprehensive b...

Business Process Analysis 1. Comprehensive business process analysis with suggested improvements. Must include projected quantitative results. Report must include use of analyt

The two-tier and three-tier web client-server architectures, QUESTION (...

QUESTION (a) Compare the two- and three-tier Web client-server architectures, and indicate the role of each tier in each architecture. Which architecture is the most likely can

Prepare action plan to implement changes, Select a small business of your c...

Select a small business of your choice and explain how the particular business can be considered as a small business enterprise. List the advantages and disadvantages of being a sm

Political pyramid, gaining comparatively at someone else''s expense

gaining comparatively at someone else''s expense

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