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

Reducing balance method and straight line method, Satine Enterprise Ltd. ...

Satine Enterprise Ltd. a) Reducing balance method: Year Depreciation Net Book Value 0 0 $25,000

Steps when selecting and finalizing a provider, What are the factors that m...

What are the factors that must be considered when selecting and finalizing a provider? Deciding on Providers - creation of own unique list of key characteristics for each of i

Discuss the essential components of a business plan, Adam's Big Leap O...

Adam's Big Leap Over the past five years or so, Adam has been working as Supervisor for King Burger and considers himself very fortunate to have landed in such a perfect job r

Scenerio and script ( business society and planet), hi, i m just asking abo...

hi, i m just asking about my subject business,society and planet. i just want to make a assign,ent on the scenerio and script about virgin australia any ethical issuse are you make

Differentiate between the internet and the world wide web, QUESTION The...

QUESTION The advent of the internet in the 1960s and the World Wide Web in the 1990s has revolutionised global communications. (a) Differentiate between the Internet as well

In-door bank services, Modeling and simulation mean using models, prototype...

Modeling and simulation mean using models, prototypes, attributes, and strategies in order to get results that help to choose the right decision. Recently, simulation becomes a maj

objectives of materials handling, Objectives of Materials Handling 1. ...

Objectives of Materials Handling 1. Reduction in Wastage of Machine  time: Proper material handling  system would  ensure  regular  supply  and distribution  of raw  material

Different delivery styles , Explain the different delivery styles that spea...

Explain the different delivery styles that speakers can select for their presentation

Cross-communication is more effective through technology, QUESTION 1 Di...

QUESTION 1 Discuss the importance of communicative behaviour observed in class rooms. QUESTION 2 Music is a powerful means of communication among children. How far do y

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