Show the sales for a product, Business Management

Assignment Help:

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)


Related Discussions:- Show the sales for a product

Useful of Management in business sectors, Management is Really useful fo...

Management is Really useful for decesion making if your statement is true then comment !how?

Discuss the exceptions to the law of demand, Question 1 Discuss the except...

Question 1 Discuss the exceptions to the law of demand Question 2 Explain Elasticity of Supply with the help of a diagram and factors affecting elasticity of supply

Meaning of interpersonal behaviour, Problem 1 List the types of organis...

Problem 1 List the types of organisation structure? Mention the basic elements of Organization Structure. Explain any three elements. List the three types List the bas

Value-focused view, Taken together, the organisation's external environment...

Taken together, the organisation's external environment, internal context and core purpose form the basis of the its value proposition - which is an articulation of the organisatio

Objectives of total productive maintenance, TPM was introduced to achieve ...

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

What is the suitable procedure of job evaluation, What is the suitable proc...

What is the suitable procedure of job evaluation? Procedure of Job Evaluation: 1. Know the job to be evaluated. 2. Define and analyse the needs of the job. Write-down

A retail co. plans to work on a margin of 54% of ret, Ask question #A retai...

Ask question #A retail co. plans to work on a margin of 54% of retail price & to incur other Variable Cost of 4%. If is expected fixed cost of Br. 40,000. i. Find the equation rel

Finance, What are three short-term financing and their examples?

What are three short-term financing and their examples?

Political environment analysis of car industry, Analyse the political Envir...

Analyse the political Environment of car distribution industry.

Explain the techniques of cross cultural communication, QUESTION 1 Gend...

QUESTION 1 Gender communication is also a form of intercultural communication (Jandt, 2004). Discuss this statement with reference to any country of your choice. QUESTION 2

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd