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 is the difference between Power BI and BI tools like Tableau, QlikView, etc.?
Power BI, Tableau, and QlikView are tools used to analyze and visualize data, but they differ in ease of use, performance, and cost. Power BI is user-friendly and integrates well with Microsoft products,...
Manmohan
0 0
5
Should I install Tableau to use Tableau?
Yes, you need to install Tableau.
Avinash
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

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

Ask a Question

Related Lessons

Word cloud in Tableau
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...

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

Tableau is a Good tool for Visualisation
Tableau is one of the best BI Tool we use to show the Data in a Visualization Mode. Tableau is a very Powerful & Fastly growing data visualization tool used in the field of Data Analytics. It will...

Donut Chart
G

Gagan G.

0 0
0

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