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

#SWOT, Rate, from best to worst, each of the sources you indicate in Questi...

Rate, from best to worst, each of the sources you indicate in Question 1 above as being sources you will use in your analysis in terms of its probable reliability. Discuss the ste

Acct manager, What strategies might be used in gaining acceptance for an OD...

What strategies might be used in gaining acceptance for an OD program

Discuss the characteristics of an effective team, QUESTION 1 Write shor...

QUESTION 1 Write short notes on the following- (a) Non-verbal communication (b) Information overload (c) Identify the four categories of cultural differences that need

Character of persuasion and Research, I would like to know how much it woul...

I would like to know how much it would be to do my paperwork that can’t be done with in a few hours it is the characteristics of persuasion and research

Problem based on Deregulation in india, a) Some of the dangers/risks might ...

a) Some of the dangers/risks might include: Cultural differences -British and American businesses may not be aware of the norms and cultures in India. For example, the clot

Culture - organizational culture, Culture - Organizational Culture Som...

Culture - Organizational Culture Some people think of culture as the character or personality of an organization. How an organization looks and "feels" when you enter it is a

Business process analysis, Business Process Analysis 1. Comprehensive b...

Business Process Analysis 1. Comprehensive business process analysis with suggested improvements. Must include projected quantitative results. Report must include use of analyt

Goals of business process reengineering, Goals of Business process reengine...

Goals of Business process reengineering - The goals of business process Reengineering is as follows: - A) To reduce time B) To reduce cost C) For customer satisfaction

Implementation of a formalised structure for an ems, The case study which f...

The case study which follows is based on an Environmental Management System (EMS). Read it carefully and then answer the short structured questions that follow: Vondax Manufactu

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

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