If you are working as a manager in a call center company then it is a must to forecast call volume. Sometimes it becomes difficult to calculate due to various variables. I have found a simple way of forecasting call volume with a dataset containing all the data. In this article, I am going to share with you how to forecast call volume in Excel.
How to Forecast Call Volume in Excel: 2 Quick Steps
In the following article, I have shared 2 quick and easy steps to forecast call volume in Excel.
Suppose we have a dataset of yearly call volume divided into different months. Now first we will calculate the Total calls in a year and then forecast call volume for the upcoming years.
Step 1: Use SUM Function to Get Total Call Volume of Each Year
- Choose a cell to write the formula. Here I have selected cell C15.
- Apply the following formula-
=SUM(C5:N5)
- Press Enter.
- Drag the Fill Handle down to fill all the cells.
- Thus we got total call years in a new column.
Read More: Time Series Forecasting Methods in Excel
Step 2: Forecast Total Call Volume in Excel
- Now let’s calculate the total call volume for the upcoming years.
- To do so select a cell. Here I have selected cell F15.
- Put the formula down-
=FORECAST.ETS(E15:E20,C15:C22,B15:B22)
Where,
- The FORECAST.ETS function returns a predicted value according to the existing value given in the string.
- Hit the Enter
- Pull the Fill Handle down to fill all the cells with the output.
- Finally, we have our forecasted call volume for the upcoming few years in an excel sheet.
Read More: How to Do Budgeting and Forecasting in Excel
Things to Remember
- You can also use the FORECAST function against the FORECAST.ETS function to get the forecasted output.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
In this article, I have tried to cover all the simple methods to forecast call volume in Excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We are always responsive to your queries. Stay tuned and keep learning.
Related Articles
- How to Calculate Forecast Accuracy Percentage in Excel
- How to Calculate Accuracy and Precision in Excel
- How to Forecast Sales Using Regression Analysis in Excel
<< Go Back to Forecasting in Excel |Excel for Finance | Learn Excel