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

Functional and process management, How will officers achieve intergration w...

How will officers achieve intergration when they have no authority over either the administrative functions or programs

Buffer inventories, Buffer inventories are held to protect against the unc...

Buffer inventories are held to protect against the uncertainties of demand and supply. An organizationgenerally knows the average demand for various items that it needs. How

Swot analysis, A government agency in osun state in collaboration with bank...

A government agency in osun state in collaboration with bank of industry organises seminar on strategic management and need to understand event,trend,issues and expectations that s

#titleInternational business perspective, 1.Explain the importance of agric...

1.Explain the importance of agriculture to Brazil’s current success. What role will agriculture play in Brazil’s future? What are the implications of this for other countries? H

introduction to business, The Four Seasons Corporation The Four Seasons ...

The Four Seasons Corporation The Four Seasons Corporation is a new firm to the market that is established recently. Since the garment industry is growing in a pace rate worldwide

Predictive maintenance, This is a modern concept having excellent future...

This is a modern concept having excellent future prospects. Maintenance is more relevant with palnt and machinery of mechanical design having more number of moving parts.

#primary sources of collecting data, Ask question #compare and contrast int...

Ask question #compare and contrast interview and questionnaires as primary sources of collecting data#

Concept of single gender classes, The concept of single gender classes has ...

The concept of single gender classes has been mainly designed and developed based on the fact that there are differences between male and female at various functional and structura

Individual business report, The purpose of this assessment is for each stud...

The purpose of this assessment is for each student to be able to accurately identify a business issue, undertake quality research to uncover both external and internal influences i

Discuss in the light of the benefits and costs arising, QUESTION ‘Sever...

QUESTION ‘Several developing countries have joined one regional integration group or another with the hope of addressing common problems in a collective and coordinated manner.

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