How do you calculate sales and profitability by Region?

Asked by Last Modified  

Follow 1
Answer

Please enter your answer

12+ years of BI and Tableau exp & Tableau certified trainer

a. Definition of sales: Is it sales to distributor, sub-distributor, dealer or end customer? Different companies recognise revenue at different layers of the sales process. I am assuming that sales to distributor is recogonised as sales. b. In case of “Sales by Region”, this it is very easily the...
read more
a. Definition of sales: Is it sales to distributor, sub-distributor, dealer or end customer? Different companies recognise revenue at different layers of the sales process. I am assuming that sales to distributor is recogonised as sales. b. In case of “Sales by Region”, this it is very easily the amount of purchase by the distributors in that period, in that region, nett of returns. c. In some cases, people also reduce the old stock (stock >180 days, 360 days, depending on the industry) and write it off from sales recognition. d. Profitability, as you expect is tricky. Let us assume that there is Gross Profit figure: Gross Profit = Cost realised by company - Cost of goods sold including royalties and licence fees. Profitability = Gross Profit - Cost of sales. Cost of sales = Cost of marketing (let us come back to it) + cost of sales discounts + cost of the sales team involved + cost of marketing team involved + logistics cost + all the other costs of the organisation. Cost of marketing= Sometimes, the cost of this is amortised over 1–2 years as some of the marketing campaign have long term impact. Profitability is also linked to “Average Selling Price” of the business. e. Profitability by region: To do this, you might have to derive some simpler metrics. Simplest way: Take the overall profitability and distribute it by volume or by headcount. More complex: Take the overall profitability by product series. Distribute it based on the product series mix of each of the regions. More complex: Take the above number of profitability, take the actual costs (headcount, logistics, stock write off, marketing etc.) and find the actual profitability. If you consider India as a region, I am sure most of the companies do the third approach. But for most practical purposes of within India business (especially not very large), the first or second approach will do good. Hope that helps. read less
Comments

Related Questions

What are the differences between Tableau desktop and Tableau Server?
Tableau desktop is an interface to connect a server, server is a central location for user repository.
Purushotham
0 0
5
Does it make sense to master both Tableau and Qlikview?
Learning both doesn't habe any advantage. It is recommended to learn either Tableau or QlikView. Tableau is rich in features and widely adapted by many corporates. I hope this answers your question.
Divya
0 0
5
Hi Guys!! Please help me. Am going to take a course. Please suggest me which is best? 1. Informatica (or) Tableau? 2.which subject is more easy to learn? 3.Which is having less coding? 4.which is having more opportunities? TIA
Hi Ajith, I would suggest Informatica as having less coding and 90% is graphical interface. 99% IT companies , these days using Informatica as a ETL tool and it is in high demand these days. you can contact me any time for demo.
Deleted
Which institute is better for tableau in hyderabad??
Hi swapna..Instead of being one out of many ,it's better to have a personal trainer who can train you intensively.If you want to have an extensive tableau development course,please feel free to reach me at lakgpal@gmail
Swapna

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Difference between Filter and parameter
Difference Between Filters and Parameters in Tableau Filters and Parameters are essential tools in Tableau but serve different purposes in data visualization and interactivity. Filters are used to...
S

Sandhyapogu Abhijith

0 0
0

What Is Tableau ?
About Tableau: Tableau is a business intelligence (BI) tool that can help you concept attractive and visually-appealing reports, charts, graphs and dashboards using the given data. These reports can easily...

TABLEAU Course Content
Introduction Course Introduction Field Types and Visual Cues Tableau Desktop Scenario Objectives Application Terminology and Definitions Opening and Closing Tableau Data Source Page Tableau...
S

Ssit

0 0
0

Donut Chart
G

Gagan G.

0 0
0

Data Warehousing - End to End
Data warehouse - An Idea Subject Oriented - A data warehouse is subject oriented because it provides information around a subject rather than the organization's ongoing operations. These subjects can...

Recommended Articles

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Looking for Tableau Training?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you