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 conceptual skills of a successful manager, Define the conceptual...

Define the conceptual skills of a successful manager. Conceptual skill: Conceptual skill is the capability to see the organization as an entire, to recognize inter-relati

Phases of business process reengineering, According to perter F. Drucker R...

According to perter F. Drucker Reengineering is new and it has to be done. The tasks experts agree upon to successfully perform BPR can be grouped into seven steps or p

Social responsibility by profit-making organisations, QUESTION 1 Using ...

QUESTION 1 Using examples from the local context, illustrate the arguments for and against the assumption of social responsibility by profit-making organisations QUESTIO

Assignement, Explain the different delivery styles that speakers can select...

Explain the different delivery styles that speakers can select for their presentation.

Contribution of education to the social structure, "Society can survive onl...

"Society can survive only if there exists among its members a sufficient degree of homogeneity; education perpetuates and reinforces this homogeneity by fixing in the child from th

Testing facilities, During planning of inspection consideration should a...

During planning of inspection consideration should also be given to the flow of product through the inspection station. The inspection station or station should be so plan

Analyse the business and information management issues , You have been appo...

You have been appointed as part of a consultancy team that has been commissioned to assess the management issues concerned with the delivery of an online system for the submission

Marketing, Ask question #). Has Toyota’s National Parks project been a suc...

Ask question #). Has Toyota’s National Parks project been a success? What indicators suggest that the project has had an impact100 words accepted#

Explain the recruitment and selection process, QUESTION 1 People are on...

QUESTION 1 People are one of the most important resources in an organization. Consequently, one of the main functions of the human resource manager is to ensure that the organi

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