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

Business-to-consumer trading through online trading, Technology has transfo...

Technology has transformed organisations, industries and ways of doing business.  Explain the reasons for the growth of business-to-consumer (B2C) trading through onlin

Explain how far money is the main motivating factor at work, QUESTION 1 ...

QUESTION 1 According to the instrumentality theory of motivation, money is the main motivating factor at work. This can explain the existence of performance related pay in many

The relevance and importance of planning in management, QUESTION 1 (a)...

QUESTION 1 (a) Explain the relevance and importance of planning in management (b) Identify the steps involved in problem solving and decision-making QUESTION 2 Is m

What role does fed play, Question 1 As a trader in order to be competitive...

Question 1 As a trader in order to be competitive and successful, how can you address some risks that are peculiar to foreign trade like commercial risks and political risks?

Modified distribution methods, Step 1: Add to the transportation table a co...

Step 1: Add to the transportation table a column on the E? HS titled u and row in the bottom of it labelled v. Step 2: a. Assign any value arbitrarily to a row or column

Describe how we learn new behaviours by operant conditioning, QUESTION 1 ...

QUESTION 1 (a) Define Learning (b) What are the different methods of learning? In operant conditioning, the patterns of rewards, punishments, and other consequences encourag

Define right wing totalitarianism with relevant examples, QUESTION 1 (a...

QUESTION 1 (a)Explain the following terms; Multi Domestic Strategy, international Strategy and Transnational Strategy. (b) Define right wing totalitarianism with relevant exam

Distinguish between oracy and literacy, QUESTION 1 In deciding on means...

QUESTION 1 In deciding on means of communication, there are several factors to be considered. What are they and how important and determinant are they in producing the expected

How can you improve your listening skills, QUESTION We spend a major po...

QUESTION We spend a major portion of our time either transmitting or receiving information. Research has shown that we spend 45% of all our communicating time listening. Since

Measures to ensure security in e-business, QUESTION (a) Describe briefl...

QUESTION (a) Describe briefly five strategies for success in e-Business. (b) List five measures to ensure security in e-Business. (c) Explain the term m-Commerce. Describ

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