In this article, we’ll dive into the different types of work schedules, how you can create one, and how an online tool gives you the flexibility to change your work schedule and collaborate with team members across projects.Ī work schedule is a way to document when your team members are working and what they are working on. A work schedule is a simple document-but you can take this document to the next level by adding project timelines and task assignments. To get a rough example you could look at the scheduling part of the Erlang calculator.Use a work schedule to clarify which team members are working, when. You then start your shifts at the individual cells. So you use Time and FTE to make the demand requirement. You list the individual shifts in a column and then the times as the rows.Īt the bottom you just add up the number of staff that you have. The only way to do this is to create a schedule. With thanks to Tawfik You Need to Create A Schedule Time FTE Requirement Shift Duration Lunch Time A – Quantity B – Quantity With thanks to Wendy How to Calculate the Quantity of Shifts Should Be Scheduled to Create the Best Coverage Situation With A Shrinkage of 0%.Ī – Please add in Table B the quantity of shifts you would schedule to create the best coverage situation with a shrinkage of 0%.ī – Please add in Table B the quantity of shifts you would schedule to create the best coverage situation with an estimated shrinkage of 10% of all your scheduled heads.Ĭ – Please share your reasons for your decisions in the Explanation field. Lunch breaks due to cover over the lunch can be busy. Lunch breaks and dse breaks are challenging. With thanks to Jonty 14 Staff Managing Lunch Breaks New Excel Based Erlang Calculator – with Maximum Occupancy You then just need to compare that with expected call volume coming out of an Erlang calculator. Al the bottom of the 100 rows you add in how many people are there for each timeslot. When they are one break then you put in a 0. When the advisor is present then you put a 1 in the appropriate box. Question asked by Danny At 100 Agents I Would Suggest WFM Softwareīy the time that you reach 100 agents I would say that you are probably outside of the capabilities of a spreadsheet and should be considering a WFM system.īut if it is a one off then you could do it in a spreadsheet.īasically you need 48 columns – 1 for every half hour and 100 rows (one for every advisor). I was wondering if anyone had an excel report that will schedule all breaks/ lunches for 100 agents while meeting our SLA target. My center is ramping up from 20 agents to 100 agents for a 1 day special launch. Scheduling Breaks/ Lunches In An Excel Report

Employee availability spreadsheet