February Planner
Created By:
Date:
Purpose: Determine the tiered bonus for salespersons
and generate a weekly work schedule
Normalizer
111.111
Salesperson ID Years Employed Bonus
Campbell, Gerry 122 5 $ 222.22
Cuff, Karen 125 5 $ 222.22
Edmunds, Michael 126 4 $ 200.00
Gregory, Joyce 128 3 $ 177.78
Hedges, Lauren 150 4 $ 200.00
Hunt, Trisha 151 4 $ 200.00
Jones, Samantha 155 4 $ 200.00
Knoop, Robert 162 3 $ 177.78
Ledford, Larry 169 3 $ 177.78
Matthews, Andre 173 3 $ 177.78
Pippin, Lauren 174 3 $ 177.78
Poole, Craig 175 2 $ 155.56
Sanford, Dezimon 176 2 $ 155.56
Simmons, Adrian 179 1 $ 133.33
Thompson, Charoletta 180 1 $ 133.33
Winstead, Lindsey 181 1 $ 133.33
Five Senses Emporium
Schedule for the Week of February 10 - 16, 2008
Salesperson ID Sun Mon Tue Wed Thu Fri Sat Total Hours
Campbell, Gerry 122 0 0 0 0 0 0 0 0
Cuff, Karen 125 0 0 0 0 0 0 0 0
Edmunds, Michael 126 0 0 0 0 0 0 0 0
Gregory, Joyce 128 0 0 0 0 0 0 0 0
Hedges, Lauren 150 0 0 0 0 0 0 0 0
Hunt, Trisha 151 0 0 0 0 0 0 0 0
Jones, Samantha 155 0 0 0 0 0 0 0 0
Knoop, Robert 162 0 0 0 0 0 0 0 0
Ledford, Larry 169 0 0 0 0 0 0 0 0
Matthews, Andre 173 0 0 0 0 0 0 0 0
Pippin, Lauren 174 0 0 0 0 0 0 0 0
Poole, Craig 175 0 0 0 0 0 0 0 0
Sanford, Dezimon 176 0 0 0 0 0 0 0 0
Simmons, Adrian 179 0 0 0 0 0 0 0 0
Thompson, Charoletta 180 0 0 0 0 0 0 0 0
Winstead, Lindsey 181 0 0 0 0 0 0 0 0
Salespersons Scheduled 0 0 0 0 0 0 0
Salespersons Needed 8 8 8 8 8 11 11
Difference -8 -8 -8 -8 -8 -11 -11
Total Shortfall -62
Status Scheduling Requests
Shift manager Can't work Tuesday
Shift manager
Shift manager
Shift manager Can't work Wednesday
Full-time Can't work Friday
Full-time Can't work Sunday
Full-time Can't work Monday through Friday
Full-time
Full-time
Full-time Can't work Sunday
Full-time
Full-time
Full-time Can't work Friday
Full-time Can't work Wednesday through Saturday
Part-time
Part-time