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

Develop a spreadsheet solution for project, Start a new workbook and develo...

Start a new workbook and develop a spreadsheet solution for Gareth's Gardens in order for him to efficiently record his garden orders and produce his customer invoices. The soluti

E-care consultant medical centre business constraints, After several discus...

After several discussions and meetings with the technical directors we identified the following constraint: Budget The time frame /Completion of the project is a c

Describe effective communication, Problem 1: (a) Describe clearly ‘Job ...

Problem 1: (a) Describe clearly ‘Job Analysis'. (b) Explain fully why ‘Job Analysis' is an important technique in ‘Managing People'. (c) What are the basic steps involved

What do you mean by dependent in workmen compensation act, What do you mean...

What do you mean by dependent in the workmen compensation act 1923s? Dependent implies that there is as: • A widow, unmarried daughter, a minor son or a widowed mother and

What are the objectives of the inventory control, What are the objectives o...

What are the objectives of the Inventory Control? Inventory control is concerned with achieving an optimum balance between two objectives which are:- 1. For minimising inves

Behavior modelling, Behavior modelling: 1. Jack Santoni works on the f...

Behavior modelling: 1. Jack Santoni works on the field production crew at Gusher Drilling Company. When he joined the company five years ago, the supervisor who hired him said

Explain the recruitment and selection process, QUESTION 1 People are on...

QUESTION 1 People are one of the most important resources in an organization. Consequently, one of the main functions of the human resource manager is to ensure that the organi

Explain the term internal environment of an organisation, QUESTION Many...

QUESTION Many business people tend to forget the importance of the internal environment for the success of their organisation. They rather give more importance to the impact of

Difference between a global business category, QUESTION 1 Mr. Ignorant ...

QUESTION 1 Mr. Ignorant wishes to open a company. He has already chosen the name ‘Xmas Mauritius Ltd' for the company. Since he is ignorant about the procedures, he seeks your

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