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

Features of enterprise resource planning, The general ERP model has a centr...

The general ERP model has a central data base shared by all functions of the enterprise represented by four quadrants in the figure represents the concept of enterprise resources p

Problem based on nature of business activity, Nature of Business Activity ...

Nature of Business Activity a) The fashion magazine is probable to contain text and coloured photos which bring in outlying greater value to the consumer than 100 pages of pap

Managing Customer Relationships, Hello, Please I need help asap. I have $40...

Hello, Please I need help asap. I have $40 for 4 pages assignment. it is just to answer 4 questions and it is due tomorrow midnight. Please let me know asap. Tianna Thank you

What do you understand by the concept intercultural myths, QUESTION 1 (...

QUESTION 1 (a) What are the three main types of communication processes that have emerged from research and study in the field of human communication? (b) What are the key c

Culture - organizational culture, Culture - Organizational Culture Som...

Culture - Organizational Culture Some people think of culture as the character or personality of an organization. How an organization looks and "feels" when you enter it is a

Describe the importance of planning in an organisation, Question 1: PAR...

Question 1: PART 1 Planning is one of the primary functions of management. (a) Describe the importance of planning in an organisation. (b) How will managers develop

Assignment, Hi I have one assignment. Can you please give me a quote? It is...

Hi I have one assignment. Can you please give me a quote? It is Advanced Diploma of Business''s assignment and workbook in which you need to answer the questions in workbook and th

Difficulties that you might encounter while communicating, QUESTION You...

QUESTION You have been appointed as a Team Leader for a mission in a foreign country. In this context, (a) Explain the difficulties that you might encounter while communicat

Different types of business meetings, QUESTION a) The process of develo...

QUESTION a) The process of developing a presentation is a systematic one comprising three distinct phases. Describe in detail each one of these phases and explain their importa

Introduction to opperation research.., discuss the advantages of mathematic...

discuss the advantages of mathematical models over over other types of models

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