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

Decision making, Fred, a 17-year employee with Sam''s Sauna, was fired for ...

Fred, a 17-year employee with Sam''s Sauna, was fired for poor job performance and poor attendance, after accruing five disciplinary penalties within a 12-month period under the co

Carrying cost, Also known as the loading cost or the storage cost carryi...

Also known as the loading cost or the storage cost carrying cost represents the cost that is associated with storing an item in inventory. It is proportional to the amoun

Economic feasibility analysis, Q. Economic feasibility analysis? Feasib...

Q. Economic feasibility analysis? Feasibility Analysis: - The feasibility analysis carefully examine economic, operational, technical, scheduling, legal and strategic factors o

What is product development, What is product development? Product Dev...

What is product development? Product Development: Product Development is an activity that comprises design and its redesign and fabrication of modified or new product and

Describe the decisional roles as proposed by mintzberg, Question: (a) H...

Question: (a) Henry Mintzberg has put a lot of emphasis on decision making as a very aspect of the managers' job. In this context, Describe the decisional roles as proposed by

What are the objectives of work study for any management, What are the obje...

What are the objectives of work study for any management? The objectives of work study for any management are as follows: 1. Enhanced working processes as well as standard p

Form of business ownership, Discuss in detail the form of business ownershi...

Discuss in detail the form of business ownership that you would recommend for Luke's business. Justify your answer. I would recommend that Luke forms a partnership. "These a

What are the types of formal participation, What are the types of formal pa...

What are the types of formal participation? Types of formal participation: (a) Ascending participation: Here elected representative of employees participate into managem

What is inventory control, What is Inventory Control? Inventory Contr...

What is Inventory Control? Inventory Control: Scope and importance of Inventory Control: It is the scientific method of determining how much stock is maintained so as to

What is the ath decision, Do you know What is the ATH decision, and what is...

Do you know What is the ATH decision, and what is it used for? Ans) Most of the investment world worships the bottom line market value of portfolios, and like as focus (without

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