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

Bma, 5 steps in the process of evaluating the purchasing and suppy

5 steps in the process of evaluating the purchasing and suppy

Career Goal, Can you check my career goal if this is correct and if not can...

Can you check my career goal if this is correct and if not can you re-write it for me..

Left or Right, if you were one of the other foremen, what could you do to m...

if you were one of the other foremen, what could you do to make rajinder?s transition easier?

International business of ernst & young, International Business of Ernst & ...

International Business of Ernst & Young Ernst & Young is one of the largest global leaders in the professional service provider. As per the changing demand of the customers,

Effects of accidents, Effects  of Accidents The  accidents are  always ...

Effects  of Accidents The  accidents are  always undesirable.  They result in  loss of life  and property. They  produce evil effects  on workers, families employers and on the

Departmental, Define the departmental, long-term and non-economic manageria...

Define the departmental, long-term and non-economic managerial decisions. Departmental, Long-term and Non-Economic decisions: In long term decisions, there time period en

How managers manage their specific environment, Question 1: All organiz...

Question 1: All organizations are being impacted by changes in both the internal and external business environment. In order to reduce the negative impact of these changes on t

Canteen, whom do you thikk rajender will eat with ?why

whom do you thikk rajender will eat with ?why

What do you mean by materials management, Question 1 What is direct sellin...

Question 1 What is direct selling? Explain the popular methods of direct selling Question 2 What do you mean by materials management? State the objectives of materials man

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