EMPLOYEE SCHEDULER FOR EXCEL AND OPENOFFICE OVERVIEW
An affordable spreadsheet to help you schedule hourly employees and manage your labor costs as a percentage of sales.
![]() | ||
| Publisher: | MakeSchedules | |
| Date Updated: | Jun 05, 2006 | |
| Limitations: | free trial | |
| Price: | $29.95 USD | |
| Rating: | ||
| OS: | Win98, WinME, Windows2000, WinXP | |
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.
Employee Scheduler in Excel download, schedule spreadsheet, spread
N/A