Employee Scheduler was developed by the owner of a small quick service restaurant in the U.S.A. (ala Subway, Blimpie, Quizno's, etc). It is proven to have applications in a wide variety of scheduling situations.

The Employee Scheduler is an affordable spreadsheet to help you schedule hourly employees and manage your labor costs as a percentage of sales. (Requires Microsoft Excel or OpenOffice to run).

Like most small businesses, controlling labor costs was (and is) key to survival. He needed a very simple, easy way of managing his labor costs on the weekly employee schedule. Most scheduling systems he reviewed were too complex or expensive for his needs.

Employee Scheduler for Microsoft Office Excel™ and OpenOffice™ The Employee Scheduler for Excel and OpenOffice is a simple spreadsheet that produces weekly employee schedules. It is designed with the very small business in mind. It doesn¡¯t have a lot of bells and whistles, and is intended to bridge the gap between doing schedules by hand, and spending hundreds of dollars on a ¡°scheduling system.¡±

The Employee Scheduler also allows managers to manage hourly wages as a percentage of sales by calculating how many hours are available to schedule.

To get started, first enter your employees¡¯ names and wages in the left column. Then, in the ¡°Labor Cost Analysis¡± box at the top of the spreadsheet, enter your estimated weekly sales, your labor expense target as a percentage of sales, and average hourly sales.

The Employee Scheduler will automatically estimate the number of hours that you have to schedule. If you have a manager who is hourly, enter their schedule in the first row (labeled ¡°Manager¡±). Hours entered into this row will not decrement the hours available to schedule hourly employees. Since the manager¡¯s fixed salary is a known expense, the Employee Scheduler does not manage it.

The ¡°Hours Available¡± window will show you how many hours over or under you have scheduled, compared to your target goal.

Keep in mind that this scheduler does not calculate or estimate local, state or government taxes. If your wage target goal includes taxes, be certain to include an extra 15% to 25% in the average hourly wage. In other words, adjust your average hourly wage or your labor target percentage to compensate.

One other number to take care with: does your estimated sales include sales tax? We recommend that you NOT include sales taxes in estimating your weekly sales goal, or you may find that you are over scheduling employees.

We hope the Employee Scheduler works well for you, and that it is a tool that you will customize to meet the needs of your specific situation.Our sincere wishes for your continued business success.