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

How e-crm may help to attract more customers, CASE STUDY: ICT-DEPLOYMENT AT...

CASE STUDY: ICT-DEPLOYMENT AT THE LOW-COST CARRIER RYANAIR, IRELAND Abstract The innovative use of information technology for online booking, e-ticketing and internal comm

A retail co. plans to work on a margin of 54% of ret, Ask question #A retai...

Ask question #A retail co. plans to work on a margin of 54% of retail price & to incur other Variable Cost of 4%. If is expected fixed cost of Br. 40,000. i. Find the equation rel

Explain the value of internal marketing for ib4e, Over the past few years, ...

Over the past few years, the company iB4e has underperformed compared with its competitors which enjoy stronger brand recognition. In addition, lots of experienced staff responsibl

Discuss the essential qualities of robust opportunities, Question 1: Be...

Question 1: Before beginning new ventures entrepreneurs need to acquire essential information. Discuss (a) the major information collection methods, and, (b) crucial infor

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

Describe organizational development and its process, Question 1 What is cu...

Question 1 What is culture? Explain its characteristics and list out the various types of culture Question 2 What is conflict in an organization? What are the sources and

Strong culture, How can a leader or fonder help create a strong culture in ...

How can a leader or fonder help create a strong culture in an organization? Can any founder create a culture? Explain.

Managing diversity - combating challenges, Managing diversity is about more...

Managing diversity is about more than equal employment opportunity and affirmative action (Losyk, 1996). The organisation should create such a working environment as will increase

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