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

How is advertising affected in marketing management, How is advertising aff...

How is advertising affected in marketing management? Advertising: This is a commercial message to the public, implementation to inform potential and established consumers

Working with other cultures, In this assignment, you will consider the pote...

In this assignment, you will consider the potential challenges and solutions that are inherent when working with other cultures. Identify a country and research the communication a

#titleInternational business perspective, 1.Explain the importance of agric...

1.Explain the importance of agriculture to Brazil’s current success. What role will agriculture play in Brazil’s future? What are the implications of this for other countries? H

The four seasons corporation, what market segment will the company be targe...

what market segment will the company be targeting?why?

Discuss how the masculine and feminine language use differ, QUESTION 1 ...

QUESTION 1 a) Discuss how do stereotypes act as barriers to communication across cultures? Support your answer with examples. b) Explain and discuss on the sources of commun

Economic feasibility analysis, Q. Economic feasibility analysis? Feasib...

Q. Economic feasibility analysis? Feasibility Analysis: - The feasibility analysis carefully examine economic, operational, technical, scheduling, legal and strategic factors o

Option for organising business, compare the liability of the owners of part...

compare the liability of the owners of partnerships, sole proprietorship and corporations.

Strong culture, How can a leader or fonder help create a strong culture in ...

How can a leader or fonder help create a strong culture in an organization? Can any founder create a culture? Explain.

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