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

Crystal arts uses the fifo method of stock control., Crystal Arts a) O...

Crystal Arts a) Opening stock is the price of a firm's stocks at the beginning of a trading period. The value is equal to that of the closing stock in the previous trading per

Strategy formulation, hotel and restaurant overall low cost leadership

hotel and restaurant overall low cost leadership

E commerce, explain the generic framework of ecommerce with diagram

explain the generic framework of ecommerce with diagram

What are the factors affected to motivation, What are the factors affected ...

What are the factors affected to motivation? Factors affecting motivation are as follows: a. Achievement: Personal satisfaction within job completion and solving problem

Opportunities and constraints of private welfare institution, Question 1: ...

Question 1: (a) Using relevant examples distinguish clearly between public and private welfare institutions stressing the basic difference in their overall administration.

What is management, QUESTION (a) What is management? Use your own words...

QUESTION (a) What is management? Use your own words to define the concept Discuss the various functions which constitute the process of management (b) Describe the skills

FDI, what are the benefits and cost of freign Direct Investment(FDI)

what are the benefits and cost of freign Direct Investment(FDI)

What are the objectives of the trade unions, What are the objectives of the...

What are the objectives of the trade unions? The Objectives of trade unions are illustrated below: a. To take labour out of the competitive procedure; because when a number

GBED1101, Some people argue that the matrix structure should be adopted onl...

Some people argue that the matrix structure should be adopted only as a last resort because the dual chains of command can create more problems than they solve. Do you agree or dis

Inernationalisation of small scale indutries, i have to write a research pa...

i have to write a research paper on the topic on internationalization

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