• EmployeeScheduling

The Itch.

Jessica is a manager at a big box retailer and is responsible for the creation of rough-cut employee schedules - manually by hand. The detailed rough-cut is then passed in to HR who process her data through SAP StaffWorks and the print that is generated is vastly different from what she had rough-cut. It seems to me that the only reason for the rough-cut is to find out the days off of the individuals and their available to start times on any given day of the week. To me, this seems like the perfect task to throw a computer at.

Limitations of known apps...

• SAP StaffWorks - Tad pricey, I think you need SAP R/3. Time Trex requires well defined shifts and reliable employees...

There is an installation of the Sporkforge Utility here:

http://wiki.xtuple.org:88/spork/

And some generated results here:

http://wiki.xtuple.org:88/spork/open_sched.php?id=3D9B26AD6249193D

http://sporkforge.com/sched/emplsched/emplsched.php I like how the sporkforge utility presents itself, but it is not flexible enough to meet Jessica's needs. Employer Constraints The Store is open 24 hours

• 6AM - 10PM is Public Hours 10PM - 6AM is Overnight Shift, restocking, receiving, cleaning, etc.

Labor Hours Labor $ per hour Budget per week.

- Should be by Dept rather than overall.

Employee ConstraintsExample:

Daily Start Availabilty (Variable resolution)

• Perry the cashier makes $10.00 per hour and is part time The store schedules him between 20 and 32 hours per week.
• Because they don't like him.

• Joe the cashier makes $20.00 per hour and is considered full time. The store schedules him between 36 and 42 hours per week.
• Because they like him.

Daily Shift Length

• Min Pre Max

Total Hours To Schedule

• Min Pre Max

Total Number of Shifts

• Min Pre Max

Breaks

• Min shift length
  • i.e - work 3 hours no break, work 6 hours get a .5 hr and a .25 hour
  Break length 1 Break length 2 Break length 3

Known Days Off (do not schedule)

• Sun Mon Tue Wed Thu Fri Sat

Number of off-day blocks

• Min Pre

Off-day blocks (in Days)

• Min

Off-day block spacing (in Days)

• Pre Max

Hourly Wage

• $

Breaks

• Break Duration