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 : (i) With the growth of the tourism industry, coastal development projects have the potential to cause significant negative environmental impacts. Using appropriate

QUESTION 1 (a) Write brief notes on the following: (i) Dictionaries, (ii) Encyclopaedias (b) On what occasions would you use them? (c) Name a few that are found in librar

Question: A firm's connected activities are defined as those activities that the firm must perform in order to deliver its customer value. A firm's strategy is said to be sound

Question 1: All organizations are being impacted by changes in both the internal and external business environment. In order to reduce the negative impact of these changes on t

QUESTION 1 a) Illustrate the different processes of effective communication. b) Discuss the different forms of communication existing. QUESTION 2 a) Define the conce

QUESTION Great feats of human achievement such as the Egyptian pyramids, the Great Wall of China, the Colosseum in Rome and the Taj Mahal in India all bear testimony to skilled

The Williams & Wiley partnership has two partners and each partner has $50,000 invested in the firm. Woods is admitted to the partnership for one-third interest and invests $80,000

What is product development? Product Development: Product Development is an activity that comprises design and its redesign and fabrication of modified or new product and

What type of material use in promotion of productivity? Material in promotion of productivity: a. It must be change of design of component b. It must be useful in proc

Q. Economic feasibility analysis? Feasibility Analysis: - The feasibility analysis carefully examine economic, operational, technical, scheduling, legal and strategic factors o