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

Explain what you understand by the term planning, Question : According ...

Question : According to Henry Fayol, planning is the primary function of managers in an organization. However, there is no empirical evidence that organizations that plan are

Describe briefly two online advertising methods, QUESTION (a) Describe ...

QUESTION (a) Describe briefly five main features of an effective e-Business website. (b) Explain the terms intranet and extranet, and their importance in an e-Business compa

Planning, explain the steps in planning

explain the steps in planning

Organizational behaviour, using as exsiting company write on how organizati...

using as exsiting company write on how organizational behaviour can play a major role in the company''s organizational development enhancing organizational performence as well as i

Markov analysis, on jan 1,2009 klosman firm held 40% of its total market an...

on jan 1,2009 klosman firm held 40% of its total market and two other firms A and B held 40% and 20% respectively.based on a study conducted by a marketing reserch firm, the follow

Data collection and analysis, Data Collection and Analysis The backbon...

Data Collection and Analysis The backbone of this research is to establish and sustain a clear link between conceptual framework and empirical analysis. The main importance of

Caselet communication failure, What should Mr. Sharma have done to avoid th...

What should Mr. Sharma have done to avoid the misunderstanding?

Explain the problem of industrial marketing in india, Explain the problem o...

Explain the problem of industrial marketing in India. Problem of Industrial Marketing in India: Industrial market comprises all individuals and organisations which acquire

Describe the difficulties that you may encounter, Probelm 1: Show the o...

Probelm 1: Show the official roles of the chairperson, the secretary and members before, during and after formal meetings. Probelm 2: Consider that you are the team lea

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