Employee Scheduler for Excel
$29.99
The Employee Scheduler is an
affordable spreadsheet template for scheduling hourly
employees and manage your labor costs as a percentage of
sales. (Requires Microsoft Excel or OpenOffice).
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). Controlling labor costs was (and is) key to
survival of a small business. 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.
The Employee Scheduler for Excel and
OpenOffice is a simple spreadsheet you 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. |
