|
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).
This Excel spreadsheet 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.
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.
|
|
 |
|
