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

Define the routine and strategic managerial decisions, Define the routine a...

Define the routine and strategic managerial decisions. Routine and Strategic Decisions: Routine decisions are of repetitive nature that does not need much analysis and ev

What do you mean by dependent in workmen compensation act, What do you mean...

What do you mean by dependent in the workmen compensation act 1923s? Dependent implies that there is as: • A widow, unmarried daughter, a minor son or a widowed mother and

Workplace Stress, AsSeek out at least three individuals within your sphere ...

AsSeek out at least three individuals within your sphere of influence and ask the following: What does workplace stress feel like to you? What activities or actions do you or your

Finance Management, This type of risk arise from changes in environmental r...

This type of risk arise from changes in environmental regulations, zoning requirements , fees, licenses and most frequently taxes. (a) Political risk (b) Domestic risk (c) Internat

Responsibilities of an organisation and strategies, a) Justify the purposes...

a) Justify the purposes of dissimalr types of organisation b) Explain the extent to which an organisation meets the objectives of disimilar stakeholders c) Describe the respo

Explain about the management information system, Explain about the Manageme...

Explain about the Management Information System. Management Information System: It is defined as like a formal method of making obtainable to management the precise and t

Explain the advantages and disadvantages of partnership, Q. Explain the adv...

Q. Explain the advantages and disadvantages of partnership? Advantages of Partnership Firm 1. Easy formation: A partnership firm can be formed without any compulsory lega

Managing public and private welfare institutions, QUESTION (a) Managing...

QUESTION (a) Managing Public and Private Welfare Institutions has assumed major importance in the modern era. Discuss this statement giving suitable examples. (b) Welfare In

Industrial and commercial bank of china (icbc), Industrial and Commercial B...

Industrial and Commercial Bank of China (ICBC) a) An Initial Public Offering (IPO) happens when a publicly-listed company floats its shares on a stock exchange for the awfully

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