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
QUESTION Being able to convey a stunning presentation has become increasingly important in the development of a successful managerial career Based on your own experience, d

OUR AIM IS TO BRING INNOVATION BY ADOPTING FOLLOWING STRATEGIES. - Competitive strategy: want to adopt competitive business strategy; we will attempt a sustainable competitive

Small Business Enterprises (SBE's) do play a major role in the world economy, and they are recognized as one of the main contributors to economic, development and employment growth

Determine the reasons for the team’s effectiveness. (Hint: You might look for web sites sponsored by the group itself, review online news sources for current articles about it, or

What is the Always Better Control Analysis of Inventory Control? ABC Analysis of Inventory Control: Always Better Control Analysis of Inventory Control analysis is the ex

Hello, I have an assignment I need to complete in the next 6 weeks and want to know how your service works? It is 1 of 2 modules I require to complete my studies. Can you please a


Identify the best organizational structure: Q. Southern Industrials Ltd. wants to develop a competency-based approach to executive selection. Which leadership perspective main

What is the objective or necessity of permitting workers to participate in management? The objective or the necessity of allowing workers to participate within management can b

QUESTION (a) What do you understand by ‘Communication' and ‘Organisational Communication'? (b) Work requires communication. Why do workers communicate? (c) Describe the v