Schedonomy® Science

  • Home
  • Services
  • Read All About It
  • Exercises
  • Contact Us
  • About the Author

Time Dependant Workload (Part 1 of 2)

16th August, 2013 · andrehoude

The carving will all depend on the profile and the type of workload. For time-dependant workload, a planner needs to transform the requirements curve into blocks of work. Best way to proceed is to view the work as a matrix of work versus a workload. The horizontal axis is time and each column represents the resolution of workload breakdown you decided upon in chapter 3 (remember?).

 

Let’s look at the grid below. The grid has a one-hour resolution (the workload resolution). The required workload for a specific activity is indicated just below. Right under the workload is the coverage. The coverage represents the number of employees present and productive for that activity. In our grid, at this point in the process, it represents the number of shifts covering the hour. Each row under that represents one shift.

 

 0.0 / 26.0 Total

6a

7a

8a

9a

10a

11a

12p

1p

2p

3p

4p

5p

6p

Workload

26

1

1

1

2

3

3

2

2

2

3

3

2

1

Coverage

Shift 1

Shift 2

Shift 3

Shift 4

Shift 5

 

In this example, the workload is small to make it simple to explain. You’ll notice that it is very easy to reproduce this example in a spreadsheet tool. Makes things easier to try out and modify the shifts (making them longer, shorter, etc). We’ll also consider that the longest possible shift is 8 hours. Anything over 8 hours is overtime and shouldn’t necessarily be part of this step.

 

First thing to do is to determine the first shift start time; in our example, we start at 6am when the workload starts. We then pencil in the number 1 in each cell that the shift will cover. When you pencil in a 1, you need to add 1 to the coverage row since you just added a shift. Lets pencil in the shift for 8 hours.

 

 8.0 / 26.0 Total

6a

7a

8a

9a

10a

11a

12p

1p

2p

3p

4p

5p

6p

Workload

26

1

1

1

2

3

3

2

2

2

3

3

2

1

Coverage

8

1

1

1

1

1

1

1

1

Shift 1

8

1

1

1

1

1

1

1

 1

Shift 2

Shift 3

Shift 4

Shift 5

 

Moving right along, we notice the workload going up again at 9a and again at 10a. Therefore, we can pencil in shift 2 starting at 9a and shift 3 starting at 10a for a duration of 8 hours.

 

 24.0 / 26.0 Total

6a

7a

8a

9a

10a

11a

12p

1p

2p

3p

4p

5p

6p

Workload

26

1

1

1

2

3

3

2

2

2

3

3

2

1

Coverage

24

1

1

1

2

3

3

3

3

2

2

2

1

Shift 1

8

1

1

1

1

1

1

 1

1

Shift 2

8

1

1

1

1

1

1

1

1

Shift 3

8

1

1

1

1

1

1

1

1

Shift 4

Shift 5

 

We now move on to shift 4 which would start at 3p since that is when the workload goes back up. This would make shift 4 very short (4 hours) since our workload for that day stops at 7p.

 

 28.0 / 26.0 Total

6a

7a

8a

9a

10a

11a

12p

1p

2p

3p

4p

5p

6p

Workload

26

1

1

1

2

3

3

2

2

2

3

3

2

1

Coverage

28

1

1

1

2

3

3

3

3

2

3

3

2

1

Shift 1

8

1

1

1

1

1

1

1

 1

Shift 2

8

1

1

1

1

1

1

1

1

Shift 3

8

1

1

1

1

1

1

1

1

Shift 4

4

1

1

1

1

Shift 5

 

 

All we did so far was to pencil in three shifts of 8 hours that have different start times based on what the workload requires and one shift of 4 hours. If we compare the workload (what’s needed) and the coverage (what we scheduled), we notice that at 12pm and 1pm, there is one extra person.

 

There are many things a planner can do to reduce this back to 2. We can reduce shift 1 by two hours or we could add lunch breaks for shifts 2 and 3. Let’s leave the breaks out of it for now and reduce shift 1 by 2 hours.

 

 26.0 / 26.0 Total

6a

7a

8a

9a

10a

11a

12p

1p

2p

3p

4p

5p

6p

Workload

26

1

1

1

2

3

3

2

2

2

3

3

2

1

Coverage

26

1

1

1

2

3

3

2

2

2

3

3

2

1

Shift 1

6

1

1

1

1

1

1

Shift 2

8

1

1

1

1

1

1

1

1

Shift 3

8

1

1

1

1

1

1

1

1

Shift 4

4

1

1

1

1

Shift 5

 

Of course, these numbers are laid out this way so that they fit nicely in the example. Notice how shift ends and shift starts overlap to cover the peaks of demand. Also notice that with 26 hours of workload, we get 4 shifts of different durations because of these peaks.

 

 26.0 / 26.0 Total

6a

7a

8a

9a

10a

11a

12p

1p

2p

3p

4p

5p

6p

Workload

26

1

1

1

2

3

3

2

2

2

3

3

2

1

Coverage

26

1

1

1

2

3

3

2

2

2

3

3

2

1

Shift 1

6

1

1

1

1

1

1

Shift 2

8

1

1

1

1

1

1

1

1

Shift 3

8

1

1

1

1

1

1

1

1

Shift 4

4

1

1

1

1

Shift 5

 

Posted in 5.1.1-Time Dependant Workload | Tags: Constraints, Employee, Positions, Schedule, Scheduling, Scheduling software, Shifts, Workforce, Workload |
« Breaking Down the Work
Time Dependant Workload (Part 2 of 2) »

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Pages

  • Home
  • Services
  • Read All About It
  • Exercises
  • Contact Us
  • About the Author

Archives

  • August 2013

Categories

  • 0-Preface (1)
  • 1-Introduction (14)
    • 1.1-Everybody Schedules (1)
    • 1.2-Change is the only constant (1)
    • 1.3-Workforce Scheduling (4)
      • 1.3.1-The Workload (1)
      • 1.3.2-The Employees (1)
      • 1.3.3-The Constraints (1)
    • 1.4-The Process (5)
      • 1.4.1-Breaking down the work (1)
      • 1.4.2-Calculating Positions (1)
      • 1.4.3-Planning the Non-Work (1)
      • 1.4.4-Distributing Shifts (1)
      • 1.4.5-Maintaining the schedule (1)
    • 1.5-Finding Support (2)
      • 1.5.1-Strategy becomes input (1)
      • 1.5.2-Choosing Tools (1)
  • 2-Build your workload (10)
    • 2.1-Workload Identification (2)
    • 2.2-Workload Quantification (7)
      • 2.2.1-Time Dependant Workload (2)
      • 2.2.2-Time Independant Workload (1)
      • 2.2.3-Mixed Workloads (1)
      • 2.2.4-Open and close times (1)
      • 2.2.5-The Wiggle Room (1)
    • 2.3-Other Alternatives (1)
  • 3-Understand the workforce (9)
    • 3.1-Arriving (4)
      • 3.1.1-Training (1)
      • 3.1.2-Workload and Absenteeism (1)
      • 3.1.3-Demographics (1)
    • 3.2-Staying (4)
      • 3.2.1-The idiot virus (1)
      • 3.2.2-Set Expectations (1)
      • 3.2.3-Share Information (1)
      • 3.2.4-Self Scheduling (1)
    • 3.3-Leaving (1)
  • 4-Define your constraints (13)
    • 4.1-Work and Rest (6)
      • 4.1.1-Shift Constraints (1)
      • 4.1.2-Day Constraints (1)
      • 4.1.3-Week Constraints (1)
      • 4.1.4-Horizon Constraints (1)
      • 4.1.5-Sequence Constraints (1)
    • 4.2-Fairness and Rotations (3)
      • 4.2.1-What About Seniority? (1)
      • 4.2.2-Self Scheduling (1)
    • 4.3-Training (1)
    • 4.4-The Agreement (1)
    • 4.5-Breaking the Rules (1)
  • 5-Assembling a Schedule (3)
    • 5.1-Breaking Down the Work (3)
      • 5.1.1-Time Dependant Workload (2)
  • 6-It's Never Over (1)
  • 7-Exercise (4)

WordPress

  • Log in
  • WordPress

Subscribe

  • Entries (RSS)
  • Comments (RSS)
© Schedonomy 2013-2019. All Rights Reserved. SCHEDONOMY is a trade-mark owned by Louis-Marielle Holdings Inc. and used under license
  • Home
  • Services
  • Read All About It
  • Exercises
  • Contact Us
  • About the Author