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 We spend a major portion of our time either transmitting or receiving information. Research has shown that we spend 45% of all our communicating time listening. Since

You must present a complete HAZOP for one part of the process. The HAZOP should be accompanied by a commentary explaining what decisions were made? Why? What changes are required?

#questionList out the secondary sources of information while pursuing market research..

QUESTION You have been appointed as a Team Leader for a mission in a foreign country. In this context, (a) Explain the difficulties that you might encounter while communicat

Plants : Numbers changes occur about the plant which include plant layout multi function workers, demand pull production kanbans self inspection MRP ( material requirements pla

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

marketing securities are drivers of growing nations

QUESTION The Swoosh Ltd (SW Ltd) is a company engaged in the manufacture of t-shirts for the local market and for exports. SG Ltd is still using manual procedures across all it

QUESTION 1 (i) Discuss the benefits and pitfalls of carrying out formal planning in an organisation. Describe the steps that a manager must take in order to design a feasible