Show the sales for a product, Business Management

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)

Posted Date: 3/25/2013 1:57:11 AM | Location : United States







Related Discussions:- Show the sales for a product, Assignment Help, Ask Question on Show the sales for a product, Get Answer, Expert's Help, Show the sales for a product Discussions

Write discussion on Show the sales for a product
Your posts are moderated
Related Questions
In a paper of 750-1,000 words, describe the strategic marketing process and its three key phases of planning, implementation, and control. Address the following: How does the mark

core competencies of shoppers stop

.discuss the applicability of an operating cycle to poultry business in uganda

Also known as the loading cost or the storage cost carrying cost represents the cost that is associated with storing an item in inventory. It is proportional to the amoun

How to identify and take due account of health and safety issues in the planning, allocation and monitoring of work.

The United States has historically been seen as a "melting pot" of people from many different countries, cultures, and backgrounds. The Bureau of Labour Statistics projects that by

what are the posible implications of capital investment decision?

Describe three specific situations at the workplace where positive non verbal communication could be used effectively to enhance verbal communication.

QUESTION a) Elaborate on three advantages and three disadvantages of online survey. b) One to one marketing is a type of relationship marketing. Explain what is meant by thi

QUESTION 1 (a) Summarize and briefly explain the problem solving process? (b) List techniques that have been developed to help individual and groups make better decisions