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

Determine the cost and profit of product, You have decided to sell some goo...

You have decided to sell some goods at a local music festival. You have hired a sales stand for $500. Your cost per item is $3 and you will sell each item for $5. When you did your

.Bureaucratic Management, whether bureaucratic approach will be appropriate...

whether bureaucratic approach will be appropriate for the organizational performance or not?

Maintanace, as an enterpreneur ,if given 50000 what business would you do?

as an enterpreneur ,if given 50000 what business would you do?

Departments of e-care consultant medical centre, table show the different d...

table show the different departments within the Medical Centre, although duties within this department are not static to one department (Dept.), as doctors and other professionals

What are the advantages of budgets, What are the advantages of budgets? ...

What are the advantages of budgets? The advantages of budget are as given below: a. Policy plans and actions considered are all reflected within the budgetary control system

Effective use of interpersonal communication skills, QUESTION "There is...

QUESTION "There is a growing emphasis on the importance of interpersonal communication. This arises from the realization that the greatest challenges to management are not prob

Total quality of services, Many services are intangible and by their ver...

Many services are intangible and by their very nature it is difficult to determine their quality. Take for example, the problem that airlines face when they try to determine

Plant layout - product oriented vs. process oriented, Plant Layout: Product...

Plant Layout: Product Oriented Vs. Process Oriented The argument is never going to end and we don't claim either to solve the issue. The simplest explanation to choice of layou

Differences between a functionalist and interpretivist, QUESTION 1 (a) ...

QUESTION 1 (a) Discuss the role of each of the three closely related patterns of group communication (cohesiveness, conformity and deviance) in groupthink. (b) Briefly descr

What is crm, QUESTION 1 a. What is CRM? b. Why is CRM important in a...

QUESTION 1 a. What is CRM? b. Why is CRM important in a service organization? QUESTION 2 What are the various behavioural styles which may be exhibited by a customer

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