Good at making employee shift schedules?? Want $50??

[TangoJuliet]

So I am in charge of creating schedules at my job. I created a schedule for the year and one of my employees retired so it won't work. If anyone can provide assistance I will paypal you $50! I need this pretty soon - like by this Monday.

Here is what I am working with:

We have 10 employees. I need a minimum of 6 people working every day. Some days could have more then 6 but 6 is the absolute minimum.

All shifts have to rotate days off - usually its rotates a day back
ie. Friday/Sat off then Thurs/Fri then Wed/Thur, etc

Work weeks start on Sunday and end on Saturday.
Days off have to be consecutive ie no split days off

Types of shift(s)

(2) 10 hour days with rotating days off
(6) Hybrid shifts - 1 week of 8 hour days, 1 week of 10 hour days
(2) 8 hour days with rotating days off

I have an excel spreadsheet of this "concept" but I cant seem to get a rotation where I can get a minimum of 6 per day....when the days off rotate I have something like 6,6,7,7,5,6

I can send it to anyone that can help.
Thanks!!

 

[surfsatwerk]

Hire a new employee.

Now gimmie my monies.

 

[Rakehellion]

Just write a program that does the math for you. Assuming it's even possible.

 

[Net]

maybe see if there is software you can use. this might work http://www.clicksoftware.com/optimized-shift-planning-scheduling-software

 

[blackdogdeek]

Employees (10): A,B,C,D,E,F,G,H,I,J
Days (7): Su, Mo, Tu, We, Th, Fr, Sa

Week1 (- = day off):
AAAAA--
BBBB--B
CCC--CC
DD--DDD
E--EEEE
--FFFFF
-GGGGG-
HHHHH--
IIII--I
JJJ--JJ

Week2 (every employee's days off shift 1 day earlier in week):
AAAA--A
BBB--BB
CC--CCC
D--DDDD
--EEEEE
-FFFFF-
GGGGG--
HHHH--H
III--II
JJ--JJJ

Week3:

AAA--AA
BB--BBB
C--CCCC
--DDDDD
-EEEEE-
FFFFF--
GGGG--G
HHH--HH
II--III
J--JJJJ

Repeat this pattern with each employee's days off moving 1 day earlier in the week each week. Everyday has at least 6 employees working and at most 8 employees working.

 

[TangoJuliet]

maybe see if there is software you can use. this might work http://www.clicksoftware.com/optimized-shift-planning-scheduling-software

I tried 3 different types of software and none of them really did what I was looking for. I asked my brother in law who is a programmer at FedEx to write some software and he was stumped too.

 

[TangoJuliet]

Repeat this pattern with each employee's days off moving 1 day earlier in the week each week. Everyday has at least 6 employees working and at most 8 employees working.

That works for people working straight 8s. I need 2 "lines" of 10 hour days with 3 days off and 6 "lines" of 2 weeks of 8s with 2 days off followed by 2 weeks of 10s with 3 days off with the days off rotating.

 

[blackdogdeek]

I misunderstood the problem

 

[NikolaeVarius]

I assume you can't do a sat/sun split?

 

[FallenHero]

That works for people working straight 8s. I need 2 "lines" of 10 hour days with 3 days off and 6 "lines" of 2 weeks of 8s with 2 days off followed by 2 weeks of 10s with 3 days off with the days off rotating.

Your problem is 10 hour shifts are manpower intensive.

But I do want to try to help. Just to clarify

You need 2 people on permanent 10 hour shifts, 3 days off no rotation for them.

You need 6 people with two weeks of 8 hour shifts and two weeks of 10 hour shifts, correct? Not all the 8 hour shifts need to line up with the others, so long as there are two 10 hour work weeks and 2 8 hour work weeks in a month schedule?

Then you also need two more 10 hour shifters with rotating days off all month.

Is this accurate?

 

[TangoJuliet]

I assume you can't do a sat/sun split?

yes, you can do a sat/sun split. You can do that with a 10 hour schedule as well - Sat/Sun/Mon, Fri/Sat/Sun

Your problem is 10 hour shifts are manpower intensive.

But I do want to try to help. Just to clarify

You need 2 people on permanent 10 hour shifts, 3 days off no rotation for them.

You need 6 people with two weeks of 8 hour shifts and two weeks of 10 hour shifts, correct? Not all the 8 hour shifts need to line up with the others, so long as there are two 10 hour work weeks and 2 8 hour work weeks in a month schedule?

Then you also need two more 10 hour shifters with rotating days off all month.

Is this accurate?

The 2 people on permanent 10's WILL rotate. From what I have been able to come up with one line will start with W/Th/Fr off and rotate back (Tu/W/Th).

The other 10 will start with Su/M/Tu off and rotate back. The way both rotate it will only over lap one day per rotation.

You are correct with the 6 people. They dont have to line up with anyone just that their rotations will leave at least 6 people minimum per day

The last 2 will lines will be 2 people on 8 hour shifts that rotate back 1 day.

I can post the excel file so you can see what I came up with but like I said earlier I dont have the rotations set up correctly.

 

[TangoJuliet]

Let me know if this works

https://docs.google.com/spreadsheets/d/1b57VeYEeQiKg3-lTUcMQssdMHLY6f-kek-FZGG0z-fo/edit?usp=sharing

 

[FallenHero]

Requires me to request access

But doing some quick excel work, I'm not sure its possible. You basically will have 5 people on 10 hour days and 5 on 8's any given week. Even offsetting their days off completely and making sure no two are the same creates two days a week you are short (5). Shifting days off around you can get it down to one day a week with 5. I'll keep thinking/looking at it.

There is no possibility of changing everyones schedule around to better fit into a min of 6 working?

 

[JTsyo]

Change employees to colored balls and shifts to bag. Then go to a college math class and write it on the board. The students will think it's a class problem and you should soon have your answer.

 

[Mixolydian]

Everybody's fired.

Problem solved.

 

[jagec]

A,B : standard 8 hr * 5 day workweek
C,D : 10 hr * 4 day workweek
E,F,G,H,I,J: Alternate 8 & 10 hr workweeks
Days (7): Su, Mo, Tu, We, Th, Fr, Sa

Week1 (- = day off):
-AAAAA-
BBBB--B
CC---CC
D---DDD
---EEEE (10 hr days)
--FFFF- (10 hr days)
-GGGG-- (10 hr days)
HHHHH-- (8 hr days)
IIII--I (8 hr days)
JJJ--JJ (8 hr days)
6777666

Week2 (every employee's days off shift 1 day earlier in week):
AAAAA--
BBB--BB
C---CCC
---DDDD
--EEEEE (8 hr days)
-FFFFF- (8 hr days)
GGGGG-- (8 hr days)
HHHH--- (10 hr days)
III---I (10 hr days)
JJ---JJ (10 hr days)
7776666

Week3 (every employee's days off shift 1 day earlier in week):
AAAA--A
BB--BBB
---CCCC
--DDDD-
--EEEE- (10 hr days)
-FFFF-- (10 hr days)
GGGG--- (10 hr days)
HHHH--H (8 hr days)
III--II (8 hr days)
JJ--JJJ (8 hr days)
6777666

Week4 (every employee's days off shift 1 day earlier in week):
AAA--AA
B--BBBB
--CCCC-
-DDDD--
-EEEEE- (8 hr days)
FFFFF-- (8 hr days)
GGGG--G (8 hr days)
HHH---H (10 hr days)
II---II (10 hr days)
J---JJJ (10 hr days)
7776666

And so on.

You guys had better hope that no one ever gets sick.

If you're serious about the $50 PM me for my paypal addy.