Employees the great dilemma of their schedules

Not sure how to program the staff effectively? In this article we share 9 steps that will help you achieve it.

Effective employee scheduling is theoretically simple: Create optimal work schedules, so you never go overboard or understaffed. But in practice, it is just the opposite.

There are many types of shifts to choose between rotary and fixed, and more than 500 shift patterns. Creating a suitable schedule for your business can be a great challenge. Even once you have created a schedule, there is no guarantee that it will still be optimal as you have to deal with last minute shift changes and requests for free time.

Fortunately, there is good news. In this article, you will learn what the keys to effective scheduling are and how to effectively schedule employees in 9 simple steps. See the keys to effective scheduling like building blocks to create a schedule.

The keys to effective programming

Calendar 1904 Effectively blog img3

Creating a solid schedule requires that you carefully balance both staff and business needs. If, for example, you are primarily focused on business needs, such as having a combination of the correct shifts, without considering that some employees will not enjoy a particular shift, employee morale and performance will be affected.

Employee needs

The scheduling needs of your employees will differ depending on their job role. These include:

  • Wishing advance notice to manage their lives. Constant last minute shift notices will cause resentment and unhappiness
  • Have shifts that match your lifestyle. For example, a night shift is probably not suitable for an employee who has a family. On the other hand, someone who is single or just out of college may be happier with this type of shift.
  • Know what their job role is, so they understand what is expected of them
  • Being able to self-manage time off requests, something they can easily do with employee scheduling software
  • The ability to change or purchase additional shifts in no time

Commercial requirements

Your company's scheduling requirements will vary across different departments. These cover:

  • The right combination of shifts for your business. Some types of shifts are better suited to your business than others. Rotary shifts, for example, work well for 24/7 operations. Whereas, fixed hours are ideal for companies that primarily hire career staff
  • A desire for optimal work schedules that ensure you always have the right number of employees working. This helps you maintain costs work under control.
  • Being able to better manage employee turnover rates, which is especially important if you have a restaurant since turnover rates are notoriously high
  • Access programming software that seamlessly integrates with your POS system to reduce the time spent creating and managing programs

How to effectively schedule employees

Calendar 1904 Effectively blog img1

Now that you understand the importance of incorporating business and personnel needs into your schedules, let's look at a simple 9-step process to effectively schedule employees (examples included).

Step 1: Set your work production standards

This is a two-part process:

  1. Determine how much work an employee with a specific job is expected to complete within a certain number of hours. "How much work" can be measured in a number of ways, depending on your business. For example, if you administer a restaurantYou can see how many tapas and place settings a waiter completes in a specific time period. Repeat this process for every job in your business.
  2. Specify the tasks for each job role. Again, these tasks will differ depending on your business. Continuing with the example of restaurant, the kitchen staff will have to prepare food, prepare food for clients and clean their station at the end of the shift.

Step 2: plot current activity levels

Once you understand the job production standards, it's time to examine your current activity levels - how busy you are on certain days and at specific times of the day.

This Insights It will help you determine the optimal number of personnel to schedule during your hours of operation. While you may be tempted to take strategic staff based on your intuition, after all, you know your business better than anyone, try not to. Your intuition may be wrong and lead to less than optimal schedules that leave you or lack staff.

The most effective approach is to analyze business data from sales and labor reports to inform your scheduling process. Sales reports, for example, can tell restaurateurs how many hedges they are doing on certain days, when the busiest times occur, and which months are quieter than others. This data can help identify precise changes that require more staff, and vice versa.

Step 3: Predict future activity levels

Use current activity levels to forecast future activity levels. Consider daily, monthly, quarterly, and annual sales cycles. If, for example, your data tells you that specific times of the day or year are always busier than others, you can predict with some certainty that this pattern will repeat itself and plan accordingly.

Step 4: Determine the exact number of employees you need

Again, avoid the need to blindly follow your intestines and try to determine the exact number of staff you need. Divide production standards by number of customers. For example, if you administer a restaurant He regularly does 150 tapas on a Tuesday and a waiter can make 30 tapas in an 8 hour shift, so he will probably need 5 servers.

Keep in mind that some employees are more productive than others. While you don't want to overload these employees, you can schedule fewer staff when they're on shift. Finally, check your results with your intuition and make the final adjustments that feel good.

Step 5: incorporate staff needs (and other considerations)

The next step is to balance the need for an optimized schedule with the needs of the employees. This means that you must ensure that:

  • Notify staff in advance of schedule changes
  • Combine shifts with the right staff
  • Assign a fair number of shifts per employee
  • Clearly define roles to avoid confusion.
  • Give employees the option to easily change shifts
  • Allow employees to self-manage requests for free time

Don't forget to have contingencies: plan absenteeism and wait for last minute shift changes. And finally, work closely with your human resources department to make sure you're not breaking any labor laws, or read the laws in your area to make sure you're still compliant.

Step 6: Select your shift scheduling method

Now is the time to create your schedule. When creating your schedule, there are three methods to choose from: pencil and paper, Google or Excel spreadsheets, and employee scheduling software. To select a suitable method for your business, discuss the pros and cons of each:

  1. Using a pen and paper to create schedules on bulletin boards is the most cost-effective, but also the one that requires the most time.
  2. Employee scheduling software requires the largest monetary investment, but saves you time creating and administration hours, not to mention money, long term. See how a restaurant used employee scheduling software to save up to $ 2,000 / month on labor.
  3. Excel, although more advanced than pen and paper, still requires an investment of time to create programs and cannot automate the programming process as it can with software.

If you are a restaurateur who uses or plans to use Excel to schedule employees, below is an example of how to schedule employees with an employee shift schedule template from restaurants.

Example: create a restaurant shift schedule in Excel

Follow this 6-step process to create a restaurant schedule using Excel:

A) Download your Excel template

Microsoft provides Excel templates for creating work schedules, but they are often generic and not designed to restaurants. Fortunately, if you run a restaurant, you can download one tailored to your needs:

B) Open the excel file
C) Choose the day you want your schedule to start
D) Enter the names of the staff

Select the cell "Employee 1" and enter their name. Do the same for all the remaining employees.

Image 1

Remove the rows that you don't need and add the ones that you do. Just right click on the appropriate cell and select "Delete" or "Insert."

Image 2

E) Edit shifts and roles

Click on the "Shifts" tab, located at the bottom of the spreadsheet.

Image 3

Then add a turn or role:

For shifts, change the start and end times and the shift column will update automatically. Include additional shifts after the first line item (9 am to 5 pm) and before the last order line (7 pm to BD - Business Rejection). For roles, include a new role after the first article and before the last article

F) Build your work schedule

Access the “Schedule” spreadsheet. Choose a cell (under a specific day) next to an employee's name. Select a suitable role and shift. Note that each cell consists of two drop-down menus: one for roles and one for shifts.


Image 4


Image 5

Repeat this process for all employees and days, until you are done. You can also make further customizations to your schedule by entering the "store name" and "time period".

Once you're done, click "save as," choose a schedule name, and save it to an easily accessible folder. If you make changes to the schedule from one week to the next, be sure to save the Excel sheet as a different file name (consider naming it by date).

It may interest you: Creation of a restaurant employee manual this 2020

Step 7: Get senior management approval if you need it

You may or may not need top management approval. In either case, be sure to scrutinize the schedule based on criteria such as labor costs, employee needs, and business requirements. Make the necessary adjustments.

Step 8: Distribute the schedule to employees

Once you are satisfied with the final schedule, send it to your employees so they know when they are working, what is expected of them, and remain responsible. If you are using Excel, you can either distribute it by email or provide access to the cloud.

If you use bulletin boards or whiteboards, let employees know when the new schedule is ready, and make sure employees know they should check it regularly for any changes. You may even consider having regular meetings where you discuss schedule changes.

And if you're using scheduling software, post the schedule on the platform, and staff will instantly receive notification on their mobile device of the new schedule plus any future changes. This distribution method means fewer in-person meetings and less input from the manager.

Step 9: Periodically evaluate your schedule and scheduling process

Your work doesn't stop after you've created your schedule. You should periodically review your programming and programming processes to identify problems and find solutions to improve.


1904 Effectively program the img2 blog

Effective employee scheduling can be a complicated process that never really ends. You must cope with selecting the correct shift types for your business and managing employee requests for free time shifts and even last minute shifts.

Fortunately, employee scheduling doesn't have to be a challenge as long as you incorporate the needs of employees and businesses into your schedules and follow a nine-step process for master scheduling.

If after doing the above, programming is still a tax process, with the waste of time creating, maintaining, and distributing programs, it may be time to change your process or find a new method of programming.

Source: Brown, Douglas Robert. The Restaurant Manager Manual: How to Set Up, Operate, and Manage a Financially Successful Food Service Operation

I am a dreamer and in my dreams I believe that a better world is possible, that no one knows more than anyone, we all learn from everyone. I love gastronomy, numbers, teaching and sharing all the little I know, because by sharing I also learn. "Let's all go together from foundation to success"
Last entries of MBA Yosvanys R Guerra Valverde (see everything)