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

Significant provisions for employee working hours, What are the important p...

What are the important provisions for employee working hours? Working Hours: The provisions relating to working hours deal along with the given factors: a. Weekly hour

Which parties have basic obligation in collective bargaining, Which parties...

Which parties have a basic obligation in collective bargaining? In collective Bargaining the parties, which are management representatives and also union officials both have a

Identify the basic component of business, A process has 3 basic components ...

A process has 3 basic components - identify each and discuss the role of each in the process cycle - To start with, SDLC (The Systems Development Life Cycle) could be simply s

Write a short note on ethics in retailing, Question 1 Explain logistics ne...

Question 1 Explain logistics networking Question 2 Write a short note on ethics in retailing Question 3 Explain the concept of insurance Question 4 What are the rec

Organizational climate and organizational culture, QUESTION 1 a) Differ...

QUESTION 1 a) Differentiate clearly the concepts "Organizational Climate" and "Organizational Culture". b) Organizations make use of two different approaches for managing or

Define the theory ‘y’ in human relations, Define the Theory ‘Y’ in human re...

Define the Theory ‘Y’ in human relations. Theory ‘Y’: It is a positive approach to human relations wherein a supervisor integrates the requirements of his subordinates al

Discuss the role of the wto, QUESTION 1 The World Trade Organization (W...

QUESTION 1 The World Trade Organization (WTO) deals with the rules of trade between nations at a global or near-global level. Discuss the role of the WTO in promoting internati

Describe the concept of the value chain, Question 1: a) Explain how a b...

Question 1: a) Explain how a business could carry out market research. b) Describe the difference between selling and marketing. c) Describe the 4 main international mark

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