Techno49
Techno49
  • 378
  • 641 795
Outbound Forecasting Part - 3 | Moving Average | WMA | WFM Interview Questions | Techno49
Outbound Forecasting Part - 3 | Moving Average | WMA | WFM Interview Questions | Techno49
Hello Friends, This is part-3 of outbound forecasting with the help of moving average and weighted moving average method.
Outbound call center forecasting is the process of estimating the number of calls, emails, or other contacts that a call center will receive in the future. The goal of forecasting is to ensure that the call center has the right number of agents to handle the volume of work, which can help improve customer satisfaction and productivity.
Other metrics that can be tracked in an outbound call center include:
Answer success rate (ASR): The percentage of calls that are answered by the right person. This metric measures how well the call center is reaching its target audience.
Call pickup rate: The percentage of outbound calls that are answered by customers.
Service level: The percentage of calls that are answered within a specific timeframe.
#wfm #sla #workforcemanagement #techno49 #bpo #callcenter #newexcel #excel #aht #qna #mcq #excelformula #education #shrinkage #occupancy #attrition #capacityplanning #demand #forecasting #talktime #formula #student #regressionanalysis #movingaverage #timeseries #planning #rtapashto #rtm #trending #youtubevideo #youtube #youtuber #youtubevideos #aht #talktime #hold #interview
Thanks for watching. 💥 🔥💥 🔥
Please subscribe, share, like. ✔️✔️✔️✔️
UA-cam Channel - ua-cam.com/channels/FvHzzydeVqzKnP2MfNwFEQ.html
✚ Thanks for watching! Don't forget to SUBCRIBE, Like & Share my video please if you enjoy it! Have a nice day!
Just for information, below information. 💯 💯
*FAIR-USE COPYRIGHT DISCLAIMER*
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism,
commenting, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing.
Video is made With the intent of educating and inspiring others.
However, for more information, please contact at email below
Harinder.dagar79@gmail.com
Переглядів: 200

Відео

Outbound Call Center Forecasting Steps | Part 2 | WFM Interview Questions | Techno49
Переглядів 36719 годин тому
Outbound Call Center Forecasting | Part 2 | WFM Interview Questions | Techno49 Hello friends, In this video, you will get to know more about outbound forecasting steps which would help to gain WFM knowledge. #wfm #sla #workforcemanagement #techno49 #bpo #callcenter #newexcel #excel #aht #qna #mcq #excelformula #education #shrinkage #occupancy #attrition #capacityplanning #demand #forecasting #t...
Workforce Management Basics | WFM Call Center Knowledge | Interview Questions | Techno49
Переглядів 865День тому
Workforce Management Basics | WFM Call Center Knowledge | Interview Questions | Techno49
Forecasting Steps In Outbound Call Center | WFM Interview Questions And Answers | Call Center | BPO
Переглядів 1 тис.14 днів тому
Forecasting Steps In Outbound Call Center | WFM Interview Questions And Answers | Call Center | BPO
MS-Excel Job Interview Questions | How To Pass Excel Test | Important Excel Interview Tips
Переглядів 96121 день тому
MS-Excel Job Interview Questions | How To Pass Excel Test | Important Excel Interview Tips
Schedule Adherence Importance | Formula | Definition | WFM Management Call Center Interview Q&A
Переглядів 1 тис.21 день тому
Schedule Adherence Importance | Formula | Definition | WFM Management Call Center Interview Q&A
WFM Analyst Questions💥| ACD | Erlang | Forecasting | Scheduling | WFM Call Center Knowledge
Переглядів 1 тис.Місяць тому
WFM Analyst Questions💥| ACD | Erlang | Forecasting | Scheduling | WFM Call Center Knowledge
WFM Real Time Management Analyst Question💥| Real Time Analyst KPI | Workforce Management Call Center
Переглядів 1,1 тис.Місяць тому
WFM Real Time Management Analyst Question💥| Real Time Analyst KPI | Workforce Management Call Center
Service Level Calculation💥| SLA Definition And Formula | Workforce Management Call Center Knowledge
Переглядів 1,1 тис.Місяць тому
Service Level Calculation💥| SLA Definition And Formula | Workforce Management Call Center Knowledge
Creating Capacity Plan And Staffing Hiring Plan💥| WFM Call Center Interview Knowledge
Переглядів 1 тис.Місяць тому
Creating Capacity Plan And Staffing Hiring Plan💥| WFM Call Center Interview Knowledge
Erlang Calculation | SLA Role In Forecasting | WFM Interview Question | Call Center Knowledge
Переглядів 1 тис.Місяць тому
Erlang Calculation | SLA Role In Forecasting | WFM Interview Question | Call Center Knowledge
AHT Trend l Call Center Past Data | AHT Importance | WFM Interview Questions And Answers | Techno49
Переглядів 1,1 тис.Місяць тому
AHT Trend l Call Center Past Data | AHT Importance | WFM Interview Questions And Answers | Techno49
Agents Or FTE Required Calculation | 1 Day Requirement | WFM Call Center | Techno49
Переглядів 1 тис.Місяць тому
Agents Or FTE Required Calculation | 1 Day Requirement | WFM Call Center | Techno49
How To Manage And Scheduling During Work From Home💥| Managing Schedules | Remote Teams | Techno49
Переглядів 1 тис.Місяць тому
How To Manage And Scheduling During Work From Home💥| Managing Schedules | Remote Teams | Techno49
Occupancy | Shrinkage | SLA | WFM Interview Questions | Call Center|💥| Must Know | Techno49
Переглядів 1,1 тис.Місяць тому
Occupancy | Shrinkage | SLA | WFM Interview Questions | Call Center|💥| Must Know | Techno49
Call Center Part Timers FTE Calculation | WFM Call Center Interview | Techno49
Переглядів 1 тис.2 місяці тому
Call Center Part Timers FTE Calculation | WFM Call Center Interview | Techno49
Correlation Between SLA and Occupancy💥| What If | Approach Required | How To Handle
Переглядів 1 тис.2 місяці тому
Correlation Between SLA and Occupancy💥| What If | Approach Required | How To Handle
Forecasting Interview Questions | Important To Know | Call Center WFM Knowledge
Переглядів 1 тис.2 місяці тому
Forecasting Interview Questions | Important To Know | Call Center WFM Knowledge
Manpower Or FTE Required Calculation In Simple Way💥| Must Know | Call Center WFM Knowledge
Переглядів 1 тис.2 місяці тому
Manpower Or FTE Required Calculation In Simple Way💥| Must Know | Call Center WFM Knowledge
Manpower Calculation Call Center💥| Must Know | Call Center Occupancy | Forecasting | Techno49
Переглядів 1 тис.2 місяці тому
Manpower Calculation Call Center💥| Must Know | Call Center Occupancy | Forecasting | Techno49
Forecast Excel Function💥 How To Do Forecasting | WFM Call Center Interview Question | Techno49
Переглядів 1 тис.2 місяці тому
Forecast Excel Function💥 How To Do Forecasting | WFM Call Center Interview Question | Techno49
Capacity Planning Yearly Wise💥| WFM Interview Questions | #Shrinkage #Occupancy #AHT #WFM #Attrition
Переглядів 1 тис.2 місяці тому
Capacity Planning Yearly Wise💥| WFM Interview Questions | #Shrinkage #Occupancy #AHT #WFM #Attrition
Excel Shrinkage Calculation💥| Interview #wfm #shorts #viralvideo #aht #shrinkage
Переглядів 1,1 тис.2 місяці тому
Excel Shrinkage Calculation💥| Interview #wfm #shorts #viralvideo #aht #shrinkage
WFM Interview Question💥| What Happens if Another Shift Added | WFM Call Center Knowledge
Переглядів 1 тис.3 місяці тому
WFM Interview Question💥| What Happens if Another Shift Added | WFM Call Center Knowledge
WFM Call Center Outbound Dialer Interview Questions and Answers💥| MCQ Knowledge | Techno49
Переглядів 1 тис.3 місяці тому
WFM Call Center Outbound Dialer Interview Questions and Answers💥| MCQ Knowledge | Techno49
Call Center Agents Schedules Releasing Steps💥| WFM Scheduling Interview Questions✔️| Techno49
Переглядів 1 тис.3 місяці тому
Call Center Agents Schedules Releasing Steps💥| WFM Scheduling Interview Questions✔️| Techno49
FTE Calculation💥 | Capacity Planning✔️ | WFM Interview Questions | Techno49
Переглядів 1 тис.3 місяці тому
FTE Calculation💥 | Capacity Planning✔️ | WFM Interview Questions | Techno49
WFM Forecasting Interview Questions and Answers | Part - 3 | #callcenter #techno49 #wfm
Переглядів 1 тис.3 місяці тому
WFM Forecasting Interview Questions and Answers | Part - 3 | #callcenter #techno49 #wfm
What Would be Occupancy % If 50 Agents , 200 Calls , 300 AHT | #occupancy #excel #education
Переглядів 1,1 тис.3 місяці тому
What Would be Occupancy % If 50 Agents , 200 Calls , 300 AHT | #occupancy #excel #education
Logical reasoning questions to trick your brain | WFM | Interview Questions
Переглядів 9273 місяці тому
Logical reasoning questions to trick your brain | WFM | Interview Questions

КОМЕНТАРІ

  • @kirank1544
    @kirank1544 2 дні тому

    Hi, there is an error in freezing, as you said the last end, columns shouldbe freezed but you did wrong

  • @jaydeepvara217
    @jaydeepvara217 5 днів тому

    Sorry, but i didn't get that double "--" right before textsplit. Can you please help?

  • @simplydoing9596
    @simplydoing9596 6 днів тому

    =indirect("="&Substitute(",", "+", a1))

    • @Techno49
      @Techno49 5 днів тому

      Yes please, can use this also.

  • @simplydoing9596
    @simplydoing9596 6 днів тому

    You can use simple formula Substitute

    • @Techno49
      @Techno49 5 днів тому

      Yes sir, can also use substitute.

  • @todaytrending9861
    @todaytrending9861 10 днів тому

    If 5000 calls in a week then 40hours * 60*80% then 5000*6/1920 is that coorect

    • @Techno49
      @Techno49 5 днів тому

      Hi, Please clarify the questions properly. Like calls -5000, Login hours - 40 hours . Like that so things can be clear.

  • @commonsolutionsgyan8578
    @commonsolutionsgyan8578 19 днів тому

    Excellent , Your videos helped me clear the interview. Thanks sir.

    • @Techno49
      @Techno49 5 днів тому

      I'm glad my videos were helpful!

  • @RSMBPO1985
    @RSMBPO1985 19 днів тому

    Please remove script attachment, it's extracting

    • @Techno49
      @Techno49 5 днів тому

      Hi, Please make captions off in video settings. CC button on video.

  • @hawasinghh8088
    @hawasinghh8088 19 днів тому

    3 correct answers , pls make scheduling video

    • @Techno49
      @Techno49 5 днів тому

      Thanks, I have a whole playlist on scheduling topics, please check it out!

  • @bindassmotivation1126
    @bindassmotivation1126 19 днів тому

    very good, make more videos on same please

    • @Techno49
      @Techno49 5 днів тому

      Thanks, will make

  • @notorioustalks6480
    @notorioustalks6480 20 днів тому

    very good explanation

    • @Techno49
      @Techno49 5 днів тому

      Appreciate the feedback!

  • @harshbeniwaal3638
    @harshbeniwaal3638 20 днів тому

    very good

  • @bindassmotivation1126
    @bindassmotivation1126 20 днів тому

    excellent. thanks

    • @Techno49
      @Techno49 5 днів тому

      You are welcome!

  • @excelmaniaworld208
    @excelmaniaworld208 20 днів тому

    I cleared wfm interview. Thanks for your video.

    • @Techno49
      @Techno49 5 днів тому

      Glad to hear it helped you!

  • @shinevine4543
    @shinevine4543 21 день тому

    very good, thanks for uploading, make more

  • @kiranvijusarode9764
    @kiranvijusarode9764 22 дні тому

    Hi want one clarification ], why you taken agent req/85% ( 40.59/(1-15%)

    • @Techno49
      @Techno49 5 днів тому

      Hi, 85% is occupancy and expecting 85% time , agents would be occupied. 15% is shrinkage, it means out of 100%, 15% time , agents will be on unproductive auxes.

  • @JoyceWilkinson-l6u
    @JoyceWilkinson-l6u 26 днів тому

    You're doing a fantastic job! Just a quick off-topic question: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). What's the best way to send them to Binance?

    • @Techno49
      @Techno49 5 днів тому

      Thanks, No idea about off topic question since I do not use same.

  • @shinevine4543
    @shinevine4543 29 днів тому

    4 correct answers. upload more such video, thanks

  • @maxxorcf7641
    @maxxorcf7641 29 днів тому

    We can do it the easy way and use IF!

  • @vinayak1112
    @vinayak1112 29 днів тому

    What shrinkage % and attrition % we can consider in the new business and why?

    • @Techno49
      @Techno49 5 днів тому

      Hi, In new business, 15% shrinkage and 5% attrition can be considered since having a new business and no data available. At the same time, same can be checked in market trend of other type of same business of their shrinkage and attrition.

  • @excelkumbh5302
    @excelkumbh5302 Місяць тому

    Thanks for completed 475 subscribers

  • @excelkumbh5302
    @excelkumbh5302 Місяць тому

    Thanks for completed 475 subscribers

  • @excelkumbh5302
    @excelkumbh5302 Місяць тому

    Thanks for completed 475 subscribers

  • @saleembasha1558
    @saleembasha1558 Місяць тому

    Hi can you provide full information on real time analyst

    • @Techno49
      @Techno49 Місяць тому

      Hi, I have video on real time management , rta interview etc. Please have a look in our channel.

  • @Teban_petmalu
    @Teban_petmalu Місяць тому

    If utilization is high they are being utilized most of the time? Is that correct? If utilization is low? They are not on queue?

    • @Techno49
      @Techno49 Місяць тому

      Hi, Utilisation includes people on avail, coaching, meeting etc . If people lots of time spending on off phone activities like coaching, meeting then it is a loss for company. Utilisation considers to be good when people are logged in as per schedule given to them. If they are following the schedule, utilisation would be higher , if not , will be lower

  • @aniteshmukherjee506
    @aniteshmukherjee506 Місяць тому

    Can we use vlookup with match ?

    • @Techno49
      @Techno49 Місяць тому

      Yes, definitely

  • @shinevine4543
    @shinevine4543 Місяць тому

    very helpful

    • @Techno49
      @Techno49 Місяць тому

      Glad it helped

  • @Techno49
    @Techno49 Місяць тому

    Any doubt, please comment and share

  • @shinevine4543
    @shinevine4543 Місяць тому

    Very good and helpful, apart from that, we can also plan for overtime etc during requirement.

    • @Techno49
      @Techno49 Місяць тому

      Yes, planning for overtime is important for real-time management.

  • @mr.a_a9407
    @mr.a_a9407 Місяць тому

    Thank you

    • @Techno49
      @Techno49 Місяць тому

      You're welcome!

  • @nileshparit3313
    @nileshparit3313 Місяць тому

    A

  • @virenderkaul5846
    @virenderkaul5846 Місяць тому

    Very good and helpful ❤

    • @Techno49
      @Techno49 Місяць тому

      Glad you found it helpful!

  • @Techno49
    @Techno49 Місяць тому

    Any doubt, please comment, Thanks

  • @bhuvantechnical2998
    @bhuvantechnical2998 Місяць тому

    we can calculate in seconds also if AHT in seconds also

  • @neodailyvlogs8127
    @neodailyvlogs8127 Місяць тому

    very good, thanks, keep it up

    • @Techno49
      @Techno49 Місяць тому

      Thanks, glad you found it helpful!

  • @Techno49
    @Techno49 Місяць тому

    Any doubt , please do comment.

  • @TheRajasekar03
    @TheRajasekar03 Місяць тому

    Smart move

  • @santoshgupta4610
    @santoshgupta4610 Місяць тому

    HC is weekly not monthly. It should be multiplied by 4.33

  • @habibpatel7022
    @habibpatel7022 Місяць тому

    Sir i saw your many video on wfm but i m still confuse when have to take workload in sec or in hrs as well when we have to divide occupancy or multiply

    • @Techno49
      @Techno49 Місяць тому

      Hi, It depends on the specific metric you're calculating and the timeframe you're using.

  • @virenderkaul5846
    @virenderkaul5846 Місяць тому

    Very helpful ❤

  • @virenderkaul5846
    @virenderkaul5846 Місяць тому

    Good❤

  • @gyantechnology1445
    @gyantechnology1445 Місяць тому

    very good.

  • @gyantechnology1445
    @gyantechnology1445 Місяць тому

    Thanks, this type of question asked in interview and i provided answer. Interviewer was impressed.

    • @Techno49
      @Techno49 Місяць тому

      Glad you found it helpful, good luck with your interview!

  • @hadiskhan7868
    @hadiskhan7868 Місяць тому

    Can you make a video series on WFM

    • @Techno49
      @Techno49 Місяць тому

      Hi, I have created WFM playlist related to all WFM topics, please have a look. ua-cam.com/video/S3BaEJp2kdQ/v-deo.html&ab_channel=Techno49

  • @Techno49
    @Techno49 Місяць тому

    Any doubt, please comment, Thanks

  • @Techno49
    @Techno49 Місяць тому

    Any questions or doubt, please comment

  • @manoharchaudhary6505
    @manoharchaudhary6505 Місяць тому

    Hi, please confirm timestamp 05:26 if we are dividing the result of 1753/365 by 5/7 to remove the week offs

  • @virenderkaul5846
    @virenderkaul5846 Місяць тому

    Thanks, We can also break monthly volume into weekly, daily intervals

    • @Techno49
      @Techno49 Місяць тому

      Yes, breaking it down further can help with more accurate staffing.

  • @KashyapDharmendra-l1l
    @KashyapDharmendra-l1l Місяць тому

    =chooseclos se bhi ho jayega

  • @KashyapDharmendra-l1l
    @KashyapDharmendra-l1l Місяць тому

    =choosecolms se bhi ho jayega

  • @MoamenAhmed-z9b
    @MoamenAhmed-z9b Місяць тому

    how you get 3600 ?

    • @Techno49
      @Techno49 Місяць тому

      Hi, 3600 is in seconds , 1 hour is converted into seconds. if 30 minutes, then 1800 seconds would be there.

    • @MoamenAhmed-z9b
      @MoamenAhmed-z9b Місяць тому

      @@Techno49 Thanks; I prepare myself for an interview. Lead RTA, your videos are so helpful if you have any advice