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

Merit of team as compared to a solo player, QUESTION 1 You are the new ...

QUESTION 1 You are the new Human Resource Manager of a company where a thick communication climate is prevailing. In an attempt to resolve this situation, outline and explain a

Describe the banking structure in the united kingdom, QUESTION Outline ...

QUESTION Outline five (5) different principal risks that banks normally face in their day to day business and explain the different Risk Management techniques used by them to m

Report on transformational leader, how to write report on transformational ...

how to write report on transformational leaders as my leader is chistopher luxon how to find the material, how to write. for getting good scores

Discuss about the term marketing briefly, Discuss about the term marketing ...

Discuss about the term marketing briefly. Marketing: All organisations are engaged within producing products or services meant for employ/consumption through people at huge.

Describe the various stages of the negotiation process, Question 1: In ...

Question 1: In analysing managerial approaches to IR, one of the key concepts that need to be considered is managerial style. Discuss Fox's typology of managerial styles. Q

Bulk purchasing, Every morning a purchasing assistant will take the previou...

Every morning a purchasing assistant will take the previous day's prescription log and parse it into two history files: filled prescriptions (drug name and quantity sold), and unfi

Performance of ernest and young in business, Performance of Ernest & Young...

Performance of Ernest & Young in the Industry Earnest and Young is performing well in the professional service industry, because it mainly use the innovative product concept

Quality management system, Briefly introduce the subject and describe its k...

Briefly introduce the subject and describe its key business or operations. Appraise how it plans and manages quality. Analyse how quality can be used to support the strategies o

What is new public management, QUESTION 1 (i) What is New Public Manage...

QUESTION 1 (i) What is New Public Management? (ii) Describe the New Public Management principles which help to transform public sector organisations into entrepreneurial age

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