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

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

I am planning to learn SAS and Tableu. How can I learn in 2 months?

One can get familier with working knowledge of tableau in 16-20hours. Remaining time can be used for learning SAS.
Ashok
Why to learn Tableau?
To earn Handsome Salaries, Interested to Travel international locations, To work directly with clients you can do Tableau to change your career for sure..
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

Type Error In VBA
VBA Error Types: There are three types of VBA error that you may encounter when executing an Excel macro. These are: Compile Errors/Syntax errors: Compile Errors are recognized by the VBA compiler as...

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

Tableau Hands on
This video explains about Parameters, Grouping, Top N parameter, Playing with Filters, Donut charts, Bullet Graphs, Gantt Charts and Box and Whisker charts in Tableau. This video will be very beneficial...

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

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

Sandhyapogu Abhijith

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