How to calculate FTD vs MTD vs QTD vs YTD Sales in FMCG | Sales growth evaluation comparing with LY

In this video, we will discuss how to calculate the terms - FTD, MTD, QTD and YTD. These terms are really important to understand the territory performance.
In all monthly meetings, these terms are used to track and compare with the previous year sales. This helps in taking the right action for better decision making.
00:30 Introduction to FTD | MTD | QTD | YTD
02:54 Calendar Year vs Fiscal Year
03:20 Sales Dump on Microsoft Excel
04:30 Calculating FTD, MTD, QTD, YTD on Excel
06:45 Conclusion
#FMCG #Sales #CPG #MTDSales #SalesPerformance
FMCG Playlist:
www.youtube.co....
Calculate No of Salesmen required in your territory www.youtube.co....
Primary Sales vs Secondary Sales in HINDI www.youtube.co....
ASM Roles & Responsibility
www.youtube.co....
Sales Forecasting in Hindi (Using Excel) www.youtube.co....
What is Fill Rate & How to calculate?
www.youtube.co....
What is SKU in Hindi?
www.youtube.co....
What is ECO in the FMCG industry?
www.youtube.co....

[@avishekghosh2008]

Very Informative.

[@analyticalguy]

I’m glad you liked the video 👍

[@paragchavan7976]

Hope you are also follow your terms. Because initially you said exclued today but while cal. MTD & YTD you take today also.

[@soumyaghosh7389]

Yes

[@rishabhdixit7588]

Transaction last month mtd mtlb bata dijiye sir

[@sasyaashok]

Informetive

[@analyticalguy]

@@sasyaashok thank you Ashok 👍

[@bharatkumarvlog3806]

New products launch ki strategy kaise banaye? Practical example se bataye please..

[@truptividhate9687]

You said, we should not take today's date for MTD, QTD and YTD but took 29th January which today's date

[@analyticalguy]

By default MTD will not take today’s date. But some of the companies include today’s date while computing MTD or QTD.

[@bbiswas84]

Secondery vs primary video not available pls provide

[@analyticalguy]

@@bbiswas84 it’s uploaded pls check :)

[@mon_rich5366]

best

[@RafiqulIslam-dv9cu]

Please share your Excel files

[@syedmanzersultan4459]

Sir aap jo sheet banate ho plz download ke liye available karwaiye mujhe download Karna hai ye sheet aur jitni sheet sabhi taki humlog jaha ghalat hai use sudhar le sir plz

[@analyticalguy]

@@syedmanzersultan4459 it’s available now :)

[@abubakarshehuabubakar1082]

कृपया भाई सामग्री को अंग्रेजी में करने पर विचार करें। मुझे आपकी सामग्री पसंद है लेकिन मैं हिंदी नहीं समझता