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

International business and managerial implications, International business ...

International business and managerial implications As Havana tries to expand its business internationally, there are few aspects that need to be taken into consideration. Firs

Describe stress management programs, Describe stress management programs: ...

Describe stress management programs: Q. The Director of Nursing at Smalltown General Hospital claims that several nurses are experiencing job burnout. Describe the three compo

Problem based on bags r us ltd, Bags R Us Ltd P&L Account for Bags R Us...

Bags R Us Ltd P&L Account for Bags R Us, year ended 31 st March 2008.   $ $ Sales ($35 * 3,000)   105,000

What types of information systems serve each level, QUESTION 1. The Uni...

QUESTION 1. The University of Technology set up in year 2000 in Mauritius operates three schools around twenty different programmes at Certificates, Diploma and Post-Graduate l

B, #quesExplain the different delivery styles that speakers can select for ...

#quesExplain the different delivery styles that speakers can select for their presentation.tion..

Function of maintenance, The important functions of maintenance can be ...

The important functions of maintenance can be stated as follows: 1. To develop maintenance policies procedures and standards for the organization. 2. To schedule planne

Organising behaviour, what could you do to make Rajinder?s transition easie...

what could you do to make Rajinder?s transition easier?

E-care consultant medical centre business constraints, After several discus...

After several discussions and meetings with the technical directors we identified the following constraint: Budget The time frame /Completion of the project is a c

Describe inter bank settlements, Question 1 The Banking Laws (Amendment) A...

Question 1 The Banking Laws (Amendment) Act 1983 introduced section 45 ZA in the Banking Regulation Act, 1949, which facilitates applicability of nomination to all deposit account

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