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

Managing Knowledge, Discuss what kind of organisational culture promotes or...

Discuss what kind of organisational culture promotes organisational learning.

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

Carrying out a training need analysis for an organization, Question 1: ...

Question 1: "Training is usually treated as a cost in many organizations rather than an investment since in difficult times, many organizations cut their training budget first

Briefly explain the main managerial skills required, QUESTION 1 (a) Wha...

QUESTION 1 (a) What are the management functions? (b) What are the key managerial roles according to Mintzberg? (c) Briefly explain the main managerial skills required

Labor Practices in sweat shops, A clothing company uses sweatshop labor to ...

A clothing company uses sweatshop labor to manufacture clothing products that contribute to low pricing, which is a consumer want. Many companies have engaged in sweatshop labor. D

Practices of management.., HOW WILL YOU INFLUENCE PEOPLE TO STRIVE WILLINGL...

HOW WILL YOU INFLUENCE PEOPLE TO STRIVE WILLINGLY FOR GROUP OBJECTIVES IN YOUR ORGANISATION (TARGET BASED INDUSTRY ) APPLY YOUR INTERPERSONAL INFLUENCE THROUGH COMMUNICATION PROCES

PPD, Identify development opportunities to meet current and future defined ...

Identify development opportunities to meet current and future defined needs

Case study with solution, This case has been framed in order to test the sk...

This case has been framed in order to test the skills

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