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

Benefits of just in time manufacturing, 1. Reduction  of wastes ( defects  ...

1. Reduction  of wastes ( defects  scrap and rework  ) and  increased ability to remain  competitive  through  customer focus and  delivering superior performance of both goods  an

Information needs at the top management, QUESTION Mauritius Institute o...

QUESTION Mauritius Institute of Technology (MIT), is a well-established private tertiary education institution located in Moka. The MIT operates two faculties with around ten d

Benefits of tqm, 1. Advantages Unique to TQM a. It makes company a lea...

1. Advantages Unique to TQM a. It makes company a leader not follower. b. TQM creates goal directed connection between customers management and workers. Every on

Research methods, good morning I have an assignment for research methods ...

good morning I have an assignment for research methods and my topic Is a study on employee retention Strategies among Mohammed LLC & i will send the assignment way and one Exa

Strategy, Explain strategy as an organizational process?

Explain strategy as an organizational process?

Operation of online analytical processing, Compare and contrast the goal, r...

Compare and contrast the goal, role, and operation of Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) tools in the context of Business Intelligence ini

CON216 - Legal Consideration in Contracting, An inventor developed a new tu...

An inventor developed a new turbofan blade for jet engines. He obtains a patent for the new design and sells all his patent rights to the design to Acme Jet Engine Company. Acme th

Markov analysis, on jan 1,2009 klosman firm held 40% of its total market an...

on jan 1,2009 klosman firm held 40% of its total market and two other firms A and B held 40% and 20% respectively.based on a study conducted by a marketing reserch firm, the follow

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