Shrinkage Calculation in BPO | Call Center

🔔Subscribe Now It's Free: bit.ly/3z0dilL
Shrinkage is a workforce management metric that refers to time in which agents are being paid but are not available to handle interactions.
There is planned shrinkage, like agents being scheduled for staff meetings and trainings, and there is unplanned shrinkage,
like an agent calling out sick or on vacation.
Best Things to purchase
🎁- Book - Advanced Analytics With Excel 2019:amzn.to/3ws3ZZz
🎁- Book - The 40 Greatest Excel Tips of All Time: amzn.to/36A9drn
🎁- Book - Excel Formulas and Functions: Step-By-Step Guide: amzn.to/2T1Reai
🎁- Book - Illustrated Microsoft Office 365 & Excel 2016: amzn.to/36tw3RO
===============================
MS-Office 2016 For 1 Windows (Activation Key Card): amzn.to/2TVjQCs
Microsoft 365 : amzn.to/3qZWI1Q
THINGS YOU NEED TO KNOW
===============================
🎬 - Excel Tips & Tricks : • Excel Tips & Tricks🔥 ...
🎬 - Customer Survey | Right way to Plot the Data : • Customer Survey | Righ...
🎬 - Data Transpose : • Data Transpose | डेटा ...
🎬 - SUM With OFFSET Functions: • SUM With OFFSET Functi...
🎬 - Automatic Dashboard in Excel: • Automatic Dashboard in...
SOCIAL
===============================
🔔 - KZread: bit.ly/3z0dilL
👥 - FACEBOOK: bit.ly/3yWnD2h
📸 - Instagram: bit.ly/3vSpBid
🐦 - Twitter: bit.ly/3gdSr69
💬 - Linkedin: bit.ly/3pj6KKK
#Shrinkage #PlannedShrinkage #Unplannedshrinkage #Planned #Unplanned
#BPO #CallCenter #KPI #KRA #Absenteeism
#EXCEL #VBA #SQL #ROHITNARANG #Advancement
Your Questions...
how to calculate shrinkage in bpo
how to calculate attrition
how to control attrition in bpo
shrinkage formula in bpo
attrition calculation
attrition formula in call center
attrition formula in excel
calculation attrition rate
calculation shrinkage rate
how to calculate attrition rate
how to calculate shrinkage
how to calculate shrinkage in excel
how to calculate shrinkage rate in bpo
Shrinkage calculation
shrinkage formula in hindi
call center
excel
what is shrinkage?
what are the types of absenteeism in the workplace?
what is planned shrinkage?
what is unplanned shrinkage?
how to calculate unplanned shrinkage?
how to calculate planned shrinkage?
planned absenteeism?
unplanned absenteeism?
excel questions asked in interviews
how to calculate shrinkage %?
what is shrinkage u0026 It's Formula?
excel interview question and answer
bPO interview
shrinkage formula in hindi?
how to calculate shrinkage rate in bpo?
tricks
Shrinkage
Call Center Shrinkage
Learning
Shrinkage and attrition in excel in english
what is shrinkage
Attrition meaning in bpo
call centre job
Team Leader job in bpo
assistant manager job in bpo
Shrinkage and attrition formauls in english
excel tricks
index
text function in excel
data validation in excel
Pivot table
advanced excel
basic excel
microsoft excel 2010
index match
bpo functions
excel in bpo
How to calculate Shrinkage and Attrition rate Formula in Excel Hindi
How to Calculate Attrition | Attrition Formulas in Practice | Attrition Analysis | Attrition Rate
attrition formula
attrition
how to calculate an attrition rate
how to calculate yearly attrition
how to calculate attrition in excel
how to calculate attrition in the bpo industry
how to calculate the monthly attrition formula
Shrinkage and attrition in excel
index+match
and function
Shrinkage in hindi
shrinkage in english video
call center attrition
calculation of shrinkage
calculation of attrition
bpo shrinkage
bpo attrition
wfm
workforce management
utilisation
wfm shrinkage
wfm attrition
importance of wfm
trending wfm
cost saving
fte
agents needed
fte calculation
how to reduce shrinkage
schedule adherence
call center break and lunch
shrinkage formula in bpo in excel
shrinkage and attrition formula in bpo
how to calculate shrinkage formula
planned and unplanned shrinkage formula in bpo
how to control shrinkage in bpo
types of shrinkage in bpo
internal and external shrinkage call center
what is shrinkage in bpo in hindi
unplanned shrinkage formula in bpo
what is shrinkage and attrition formula
attrition formula in bpo in excel
attrition formula in bpo with example
shrinkage calculator online
formula of shrinkage in bpo
shrinkage formula
shrinkage calculator
shrinkage calculator excel
how to manage shrinkage in team
what is shrinkage in bpo
what is shrinkage and attrition in bpo
how to control shrinkage as a team leader
how to control shrinkage and attrition in bpo
how to manage attrition and shrinkage
how to reduce call center shrinkage
shrinkage buffer
how to control shrinkage

Пікірлер: 74

  • @booknow9296
    @booknow929612 күн бұрын

    Please make forecasting ralated video

  • @arnabmondal2558
    @arnabmondal25582 жыл бұрын

    Subscribed

  • @saifkhan-ce6if
    @saifkhan-ce6if8 ай бұрын

    Very nice video, please make excel for Team leaders,

  • @arnabmondal2558
    @arnabmondal25582 жыл бұрын

    Really Helpful

  • @Advancement1

    @Advancement1

    2 жыл бұрын

    Thank you..

  • @kallurisaikumar1546
    @kallurisaikumar15462 жыл бұрын

    awesome ❤️🙏

  • @Advancement1

    @Advancement1

    2 жыл бұрын

    Thank you dear😊

  • @SoniSingh-mk5ib
    @SoniSingh-mk5ib2 жыл бұрын

    It's very helpful

  • @Advancement1

    @Advancement1

    2 жыл бұрын

    Thank you..

  • @RohitKumar-cc7zi
    @RohitKumar-cc7zi10 ай бұрын

    Weldon bro

  • @suryaprakashsingh6133
    @suryaprakashsingh6133 Жыл бұрын

    Total shrinkage me thoda sa doubt ha sir. Baki bahut achcha samjhaya sir thankyou sir

  • @shaikhasif481
    @shaikhasif4818 ай бұрын

    So much helpful video bro thank you🌹❤

  • @Advancement1

    @Advancement1

    7 ай бұрын

    Welcome 😊

  • @shoaiblifegood9079
    @shoaiblifegood90792 жыл бұрын

    Nice sir bhut accha

  • @Advancement1

    @Advancement1

    2 жыл бұрын

    Thank you

  • @themixedbag339
    @themixedbag3396 ай бұрын

    what about break, early logout, late login, unavailable aux and half day? are these all shrinkage? if yes, how to calculate these?

  • @deepakkapoor114
    @deepakkapoor1142 жыл бұрын

    Nice explanation

  • @Advancement1

    @Advancement1

    2 жыл бұрын

    Thank you keep learning..

  • @amrithack9
    @amrithack9Ай бұрын

    Hi Brother, How we will include the Half day leave in this?

  • @shlokkundara7760
    @shlokkundara77606 ай бұрын

    if we calculate unplanned shrinkage like 2/30*100 is it correct or wrong?

  • @ramjisrivastava4378
    @ramjisrivastava43782 жыл бұрын

    Nice sir ji

  • @Advancement1

    @Advancement1

    2 жыл бұрын

    Thank you😊

  • @user-qe6yj5ne7k
    @user-qe6yj5ne7k4 ай бұрын

    Good explanation bro

  • @Advancement1

    @Advancement1

    4 ай бұрын

    Thank you so much 🙂

  • @celebrityssarees345
    @celebrityssarees3455 күн бұрын

    Mujhe lga sahi bta rahe ho but end me aate aate sab kachra kar dia aapne. Aapne planned and unplanned me jisse divide kia dono alag chij hai. To aap last me dono ko add kr k total kese bata dia. It's basic maths right? Jab bhi aap total percentage nikalte ho 2 calculations ka dono calculations me denominator same hi hona chahiye. Please fix this.

  • @nirmaladorji1113
    @nirmaladorji11132 ай бұрын

    Call ka data kaise nikalte hai?

  • @sunilsingh-nr2eo
    @sunilsingh-nr2eo Жыл бұрын

    Formula is correct except unplanned leaves as correct is No. Of advisors absent/total head count But in this video it's divided by rostered count which is incorrect Suppose an example:- Headcount 10 Woff 9 Rostered 1 Unplanned 1 Planned shrinkage 9/10=90% Unplanned 1/1= 100% Total shrinkage=190% but shrinkage cannot exceed 100% So correct is Unplanned 1/10=10% Total shrinkage= 90%+10%=100% As 9 on woff & 1 absent means no one is present 100% shrinkage Hope it's now clear to all. Thanks in advance 😀

  • @nishantchauhan9381

    @nishantchauhan9381

    Жыл бұрын

    Want is headcount

  • @Ranjan7887

    @Ranjan7887

    Жыл бұрын

    Yes it's correct Headcount is 10

  • @paddarsajad1143

    @paddarsajad1143

    Жыл бұрын

    Correct

  • @SalmanKhan-qi8lh

    @SalmanKhan-qi8lh

    6 ай бұрын

  • @brijeshchauhan9135
    @brijeshchauhan91352 жыл бұрын

    Bhai bahut achhe tarike se samjhaye aap bus ek kami rah gayi ager side mai marula likhe hote to maja aajata

  • @Advancement1

    @Advancement1

    2 жыл бұрын

    Thank you..😊

  • @Avinashkumar-tw9hj
    @Avinashkumar-tw9hj Жыл бұрын

    26% is answer

  • @baldnutz8973
    @baldnutz8973 Жыл бұрын

    Incorrect, so shrinkage is not calculated like this instead we calculate the hours so the formula is total hours of external shrinkage + total hours of internal shrinkage / total hours available X 100

  • @Advancement1

    @Advancement1

    Жыл бұрын

    We can calculate in both ways

  • @jaagdeeipsingh8385

    @jaagdeeipsingh8385

    Жыл бұрын

    Exactly, we can calculate in either ways..

  • @Nkfactz01

    @Nkfactz01

    Ай бұрын

    1-p/total agents

  • @formula1214
    @formula1214 Жыл бұрын

    Planned main divide total number of employees kyun kiya?

  • @Advancement1

    @Advancement1

    Жыл бұрын

    To check the planned % from headcount

  • @12345610sam
    @12345610samАй бұрын

    Unplanned is 6.67% I think

  • @myshorts9964
    @myshorts99643 ай бұрын

    Bhai seedha seedha Shrinkage ka definition batao

  • @Advancement1

    @Advancement1

    3 ай бұрын

    In the context of Business Process Outsourcing (BPO), shrinkage refers to the time during which agents are not available to handle customer interactions, and this includes various factors such as scheduled breaks, meetings, training sessions, and also the time when employees are absent or on their scheduled weekly off days. When specifically discussing shrinkage related to absent and weekly off employees in BPO: 1. **Absenteeism**: This refers to the unplanned absence of employees from their scheduled shifts. Absenteeism can occur due to various reasons such as illness, personal emergencies, transportation issues, or other unforeseen circumstances. Absenteeism contributes to shrinkage because it results in a loss of available manpower during scheduled working hours. 2. **Weekly Offs**: In many BPOs, employees have fixed weekly off days as part of their work schedule. During these days, employees are not available to handle customer interactions or perform their regular duties. While weekly offs are planned and scheduled in advance, they still contribute to shrinkage as they represent periods when agents are unavailable for work. Managing absenteeism and scheduling weekly offs effectively is essential for BPO operations to ensure that there are enough agents available to handle customer inquiries and meet service level agreements (SLAs). By accurately tracking and managing shrinkage related to absent and weekly off employees, BPO organizations can optimize workforce planning, maintain service quality, and minimize the impact on overall operational efficiency.

  • @maheshkm2910
    @maheshkm2910 Жыл бұрын

    Sir i have a ques pls ans to it We have total 6 people in a team Feb month we have 6planned leaves each one planned leave. Every week we all get fixed week off So what is the total shrinkage? 2.we are 6 in a team We have 4 planned We have 2 unplanned Same 2 days fixed week off in every week Now what is the shrinkage

  • @Advancement1

    @Advancement1

    Жыл бұрын

    1. (6planned +(6week off*4week)/(6people*28 Days) = 18% 2. (4planned+ 2unplanned + (2 week off*4week*6 people))/(6people*28 Days) = 32%

  • @ManishKumar-os8qy

    @ManishKumar-os8qy

    10 ай бұрын

    Could you please confirm me planned week off 1÷7 how can I calculate this

  • @ssvinoth87
    @ssvinoth87 Жыл бұрын

    How come week off be in Shrinkage

  • @Advancement1

    @Advancement1

    Жыл бұрын

    It comes under planned

  • @celebrityssarees345

    @celebrityssarees345

    5 күн бұрын

    You are correct WO are never calculated in shrinkage. Because while joining the company, it is already told that you will get 2 WO or 1 WO. That means you are only paid for workable days.

  • @maheshkm2910
    @maheshkm2910 Жыл бұрын

    How to calculate for 1month. (avg)

  • @Advancement1

    @Advancement1

    Жыл бұрын

    1. (6planned +(6week off*4week)/(6people*28 Days) = 18% 2. (4planned+ 2unplanned + (2 week off*4week*6 people))/(6people*28 Days) = 32%

  • @RahulGandhiClub
    @RahulGandhiClub Жыл бұрын

    Sir I am still waiting for your revert. Please revert.

  • @Advancement1

    @Advancement1

    Жыл бұрын

    May i know what you want to know?

  • @vishalpanchal5505
    @vishalpanchal5505 Жыл бұрын

    West calculator

  • @TobeContinued-09

    @TobeContinued-09

    6 ай бұрын

    Tu bata de

  • @user-wy7zs7ww2s
    @user-wy7zs7ww2s3 ай бұрын

    dont some any % it will not give accurate numbers

  • @sahilrajora5755
    @sahilrajora5755 Жыл бұрын

    Sab kuch galat bataya bhai... Tumhari vajah se bht log reject hone wale hai... Week off is not part of planned shrinkage and you should not plus 2 percentages. Needs to be calculated from all number ( planned + unplanned) / Schedule headcount

  • @sagarchintala6123

    @sagarchintala6123

    Жыл бұрын

    Please tell in english

  • @Amit-iq9lr
    @Amit-iq9lr2 жыл бұрын

    Incorrect calculation hai

  • @Advancement1

    @Advancement1

    2 жыл бұрын

    What is the correct calculation according to you?

  • @Amit-iq9lr

    @Amit-iq9lr

    2 жыл бұрын

    Total shrinkage should match your individual calculatotion.... Total people not available(planned plus unplanned) divided by total people You Are adding 2 percentages, however the inputs in both percentages are different

  • @Advancement1

    @Advancement1

    2 жыл бұрын

    Shrinkage = Planned shrinkage + Unplanned Shrinkage. Planned Shrinkage = (No. of week-off + No. of leaves)/Total Head-count Unplanned Shrinkage = {No. of absent + (Half day/2)}/ Total Roster-count.

  • @Amit-iq9lr

    @Amit-iq9lr

    2 жыл бұрын

    @@Advancement1 Bhai planned shrinkage main you are dividing by 30 and unplanned division by 26.... When denominators are different, how can you simply add 2 percentages....

  • @cybercriminaldost7819
    @cybercriminaldost781910 ай бұрын

    Wrong

  • @Advancement1

    @Advancement1

    10 ай бұрын

    Whats wrong?

  • @cybercriminaldost7819

    @cybercriminaldost7819

    10 ай бұрын

    @@Advancement1 over-all shrinkage never be Planned+Unplanned...

  • @abhishekjurel3713

    @abhishekjurel3713

    9 ай бұрын

    ​@@cybercriminaldost7819it's correct the actual formula of the shrinkage is planned + unplanned shrinkage so let me say something first there are two ways to calculate the shrinkage see Planned shrinkage 6/30 = 20% 6 is planned WO+ Leaves Total headcount is 30 Unplanned shrinkage should be calculated in two ways 2/24 = 8.33% either 2/30 = 6.66% Unplanned shrinkage should be as per company Total shrinkage 20% + 8.33 = 28.33% Total shrinkage 20% + 6.66% 26.66%

  • @tapandalwadi2637
    @tapandalwadi2637 Жыл бұрын

    Total shrinkage is wrong It should be =(Planned+unplanned+Weekoff)/(Team strength) You added two different calculation. So 26% is the actual total shrinkage.

  • @Advancement1

    @Advancement1

    Жыл бұрын

    we can measure with both ways

  • @virendersingh4527

    @virendersingh4527

    Жыл бұрын

    ​@@Advancement1if we calculate as per (Planned+unplanned+Weekoff)/(Team strength) then how anwser will be 28%. Please enlighten me and what is the formula for calculating shrinkage.

  • @virendersingh4527

    @virendersingh4527

    Жыл бұрын

    If we calculate (Planned+unplanned+weeoff)/ (Team strengy) (4+2+2)/30 =27% Make me correct if I have calculated it wrong

  • @Advancement1

    @Advancement1

    Жыл бұрын

    Week off also comes in planned

  • @Avinashkumar-tw9hj

    @Avinashkumar-tw9hj

    Жыл бұрын

    Yes it's answer 26% only