UrbanPro

Learn Tableau from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

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

Why to learn Tableau?
Good question Avinash. In corporate companies while getting the project from some XXXXXXXX we have to update the reports to the client,for that we are using data visualization instead of textual reports...
Avinash
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

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

Ask a Question

Related Lessons

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

Funnel chart in Tableau
G

Gagan G.

0 0
0

Data Extracts vs. Live connections
Live Offer the convenience of real-time updates much faster Parameters like network speed, traffic on that network, and any custom SQL can affect the performance. Extract Snapshots of data...

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...

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

Looking for Tableau Classes?

The best tutors for Tableau Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Tableau with the Best Tutors

The best Tutors for Tableau Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more