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

Rough cut capacity planning (rccp) and financial appraisal , 1. Overview an...

1. Overview and Learning Objectives This formative assignment seeks to develop and assess skills associated with basic modern ICT tools and competence in the techniques of Rough

How you would proceed to select a manager for organization, Question: I...

Question: In this period of shortage of talent, (a) The selection exercise is becoming more and more demanding. Explain with details as to how you would proceed to select a

How would you distinguish data and information, QUESTION An information...

QUESTION An information system should provide good and valuable information to its users. (a) How would you distinguish data and information? (b) Write short notes on any

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

MARKETING PRINCIPLES, THE CONCEPT OF SEGMENTATION IN APPLE'' COMPANY IN ORD...

THE CONCEPT OF SEGMENTATION IN APPLE'' COMPANY IN ORDER PLEASE

Modified distribution methods, Step 1: Add to the transportation table a co...

Step 1: Add to the transportation table a column on the E? HS titled u and row in the bottom of it labelled v. Step 2: a. Assign any value arbitrarily to a row or column

The Marketing Environment : Consumers Confound Marketers, Identify all envi...

Identify all environmental factors that can affect the demand for consumers durables and assess the magnitude and direction of there impact.

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