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
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

TPM was introduced to achieve the following objectives . the important ones are listed below: a. Avoid wastage in a quickly changing economic environment. b. Producin

Question: Fun World Ltd is a small manufacturer of computer games, which has been able to compete against the largest businesses in the industry. Simon, the new Managing Direct

Question 1: (i) An organisation evolves in a specific and general environment. Discuss, using examples, the components of each environment. (ii) ‘Ethical workplace behavi

QUESTION 1 i) Explain the following definitions Technical definition Process definition Transactional definition ii) What are the characteristics of a small g

RQ1 What role should external factors of demand play in successful business models? NOTE: first fully define the role and then analyze or discuss. At least 4 paragraphs. RQ2 What i

What are the groups of the inventories of Always Better Control Analysis of Inventory Control? The inventories are classified within three groups as illustrated below: • A-T

Identify and explore NetSuite’s components that relate to your business major

Question 1 Identify and assess the different IRR measurement techniques implemented in a bank Question 2 Describe the use of VaR for capital requirement for market risk Ques

whom do you thikk rajender will eat with ?why