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

Short-term financing, Discuss the three approaches to short-term financing ...

Discuss the three approaches to short-term financing with relevant examples

Fiscal and monetary policy , a) Describe how economic systems attempt to al...

a) Describe how economic systems attempt to allocate resources effectively b) Assess the impact of fiscal and monetary policy on business organisations and their Activities c)

Macroeconomic, How could utility theory help us understand the difference b...

How could utility theory help us understand the difference between a federal income tax and a federal sales tax on consumer consumption patterns

Strategies for successfully using communication technology, QUESTION 1 ...

QUESTION 1 a) What is communication? b) Discuss four common types of communication barriers c) Explain five strategies for overcoming communication barriers and briefly e

Resposible business, consider what constitutes ‘responsible business’

consider what constitutes ‘responsible business’

Sorces of finance for the types of business, what are the sources of financ...

what are the sources of finance of a co-operative society

Rule of 72, what is the interest earned for a deposit of $100,000 at 2% for...

what is the interest earned for a deposit of $100,000 at 2% for 5 years

Explain the importance of conducting business meetings, Question 1: (a)...

Question 1: (a) In most business organisations, communication will flow: 1. Upwards 2. Downwards 3. Horizontally Briefly describe each of the above communication flows.

What are the problems of industrial markets, What are the problems of Indus...

What are the problems of Industrial markets? The problems of Industrial markets in India are as illustrated below: a. The customer base is minute and new markets or 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