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

Ricardian model and heckscher-ohlin model, 1. Wage ratios must lie in betwe...

1. Wage ratios must lie in between the inter-country productivity ratios. 2. Large countries are always less specialized. 3. Low wage countries have bigger gains from trade.

How is responsibility and authority affected in organisation, How is the re...

How is the responsibility and authority affected in the organisation? Responsibility and Authority: Responsibility implies accountability. This is the obligation of the s

Development of an environment management system, Question 1: (a) Briefl...

Question 1: (a) Briefly describe the Environment Impact Assessment Committee and its functions (b) What do you understand by the term 'environmental sustainability' (c) List a

What is meant by planning, QUESTION 1 i) Explain what you understand by...

QUESTION 1 i) Explain what you understand by the term internal environment of an organisation ii) Discuss how managers can reduce the influence of the specific external envi

How should handled a good grievances, How should handled a good grievances?...

How should handled a good grievances? A good grievances handling must: a. It must be simple, easy to know and to operate b. It must settle grievances at lower level c.

Provide leadership across the organization, Examine the strategic and busin...

Examine the strategic and business planning documents of bounce fitness.Evaluate and report if they are consistent with the strategic direction and if they provide clear leadership

Account setup - business processes, When a customer wants a prescription fi...

When a customer wants a prescription filled, a sales associate receives the member's card and prescription and logs the request in a prescription log which contains the member's nu

The benefits of quality standard iso 9000, BC4 is a manufacturer of bedroom...

BC4 is a manufacturer of bedroom furniture with four factories in the south of the country. As a result of declining company financial performance, the Managing Director (MD) engag

Managing communication, understand how to assess information and knowledge...

understand how to assess information and knowledge needs

What is an e-marketing, QUESTION Marketing has been practiced ever sinc...

QUESTION Marketing has been practiced ever since humans engaged with trade and has evolved in line with changes in technology. (a) What is an e-marketing? (b) Explain 10

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