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

Illustrate the major and minor managerial decisions, Illustrate the major a...

Illustrate the major and minor managerial decisions? Major and Minor Decisions: Decision regarding financial outlay can be minor or major. A decision associated to the pu

Sales territory management, Sales Territory Management: To be efficien...

Sales Territory Management: To be efficient and effective the outside sales staff requires to be well managed and focused in their daily activities. The way they direct their

Explain what you understand by the term internal environment, Question : ...

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

Managerial economics.., plot the demand schedule and draw the demand curve ...

plot the demand schedule and draw the demand curve for tha data given for marijuana in the case above

Concept of procedural rationality, (a) Based on the concept of ‘procedural ...

(a) Based on the concept of ‘procedural rationality' discuss how various types of Business Intelligence techniques may improve specific aspects of the organisational decision makin

Explain potential conflict between management and company, CRSL has a large...

CRSL has a large auditorium which can cater for 300 people and is ideal for formal balls and functions. The auditorium can also be reconfigured to cater for 100 people. The Seasons

Strategic issues facing the service industry, Strategic Issues Facing the S...

Strategic Issues Facing the Service Industry In today's challenging business environment, professional service industry is facing various kinds of strategic obstacles related

Controling, measure of actual performances

measure of actual performances

What are types of entrepreneur on the basis of ownership, What are types of...

What are types of Entrepreneur on the basis of ownership? Classification on the Basis of Ownership: a. Founder or "Pure Entrepreneurs": Such individuals who are the f

MTMG320 Business Information Systems, Hi I am Nelson Daniels I am checking ...

Hi I am Nelson Daniels I am checking up on my Ticket ID EM13830601 I see my payment has been authorized I need help on my 5.5 - Research Exercise: Microsoft Dynamics Research Rep

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