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

What do you mean by line and staff organisation, What do you mean by Line a...

What do you mean by Line and Staff Organisation? Line and Staff Organisation: When the industry grew within size and complexity, the line executives could not carry

Explain the functions of the financial services commission, QUESTION (a...

QUESTION (a) Mr. Bob is the director of ABC Co. Ltd, a shoe making company. Mr. Bob wants to change the business activities of the company to carry out leasing activities. He s

What are the different types of decisions, What are the different types of ...

What are the different types of decisions? Decisions might be of different types: Several of the significant kinds of managerial decisions are described below: • Programm

Difference between personal and business letters, Problem 1 Explain the...

Problem 1 Explain the importance of Business Letters. Differentiate between Personal and Business Letters. Importance of Business Letters Difference between Personal and

Analysis, an analysis of the fluctuation in share prices of fujitsu LLC and...

an analysis of the fluctuation in share prices of fujitsu LLC and Dell LLC yielded the following results fujitsu LLC Dell LLc Average Price 138.0 118.5

Behavior modelling, Behavior modelling: 1. Jack Santoni works on the f...

Behavior modelling: 1. Jack Santoni works on the field production crew at Gusher Drilling Company. When he joined the company five years ago, the supervisor who hired him said

Explain leverage- run efficient- initiate new frontiers, Boeing has 3 strat...

Boeing has 3 strategies they pursue as a business - devise 4 to 5 tactics you would put in place to support for each strategy - five tactical bullets points per strategy. 1.

What are the advantages of e-marketing, QUESTION (a) In Community Marke...

QUESTION (a) In Community Marketing, what are the dynamics of community formation? (b) Describe five common payment system used in e-Business. (c) What are the advantages

Essence of arbitration as a substitute to litigations, Your Ministry has re...

Your Ministry has retained the services of High Tech Company Limited for laboratory installation in a newly constructed hospital. One of the conditions of the contract is that mat

Explain about the selling concept, Explain about the selling concept. ...

Explain about the selling concept. Selling Concept: The selling concept is a management orientation which seems as that consumer will normally not buy adequate of the com

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