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.
Simply 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.
NOTE: 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.
The Employee Scheduler is a tool that you can customize to meet the needs of your specific situation. |
