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 are the pitfalls and benefits of planning, Question 1: i) Differen...

Question 1: i) Differentiate between internal and external environment in which an organization operates. ii) How managers will reduce the influence of the external environ

Quantitative analysis for managerial decision making, what is the role and ...

what is the role and significance of quantitative techniques in modern management?

Critically analyze the stages involved in conflict process, Question 1: ...

Question 1: (a) What is Leadership? (b) What are the three critical situational variables identified by Fiedler? If these are very favorable, what is the most effective styl

IT, #questionExplain the changes in recent years in society, especially wit...

#questionExplain the changes in recent years in society, especially with regard to in technology usage, as it relates to the steady increase in; available computing power, availabl

Explain the risk-taking capability of an entrepreneur, Explain the risk-tak...

Explain the risk-taking capability of an entrepreneur. Risk-Taking Capability: Risk is inseparable and inherent element of entrepreneurship. He supposes about the uncerta

Production process in a company, Production Process in a Company Depic...

Production Process in a Company Depicted below is the production process flow for company with timing requirement for set ups and related processes to take place for all the

Improvement production process, The table below lists the seven wastes as t...

The table below lists the seven wastes as the target for continuous improvement production process. 1. Waste of Overproduction : eliminate by reducing setup times synchronizing qu

Dimensions of workforce diversity, The term 'workforce diversity' in its br...

The term 'workforce diversity' in its broadest sense encompasses many dimensions. The researchers have classified such dimensions into many categories. According to the study ( Spo

Write brief notes on the dictionaries and encyclopaedias, QUESTION 1 (a...

QUESTION 1 (a) Write brief notes on the following: (i) Dictionaries, (ii) Encyclopaedias (b) On what occasions would you use them? (c) Name a few that are found in librar

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