Schedule Analyzer Overview

SA Pro Resource Planner
By Ron Winter Consulting LLC, Copyright 2005
(770) 587-4903 or email at Ron@RonWinterConsulting.com

Resource Planner

It is not enough to simply resource-level your schedule. You then have to use the results of that leveling and add it to your work plan. You have to actually execute (or at least try to execute) the current resource leveling plan. Today, contractors do not have a simple, clear-cut method of doing this. They can try to "meet the schedule," but that is a difficult target to hit.

Contractors should at least be aware of the direct changes made by the resource leveling system. In other words, the contractor needs a schedule of delayed activities that were delayed due to resource constraints. This is not a list of all delayed activities, just those that were specifically delayed due to resource shortages. They can then use this list for planning the 3-week schedule and reporting on discrepancies to the leveling plan.

To this aim, we have invented a new program called "Resource Planner." It reads the resource leveling report produced when you level your resources and references the actual schedule that created it. It then identifies the resource-delayed activities in sorted date order. More importantly, it identifies the activities and particular resources causing the delay to that activity.

With this information, the Foreman can spot the crew or piece of equipment working on the predecessor activity and tell them their next assignment. If for some reason this does not work out, then the Scheduler will get immediate feedback on the resource plan and be able to adjust the parameters as necessary. The Scheduler will also be in the position to include this deviation in the monthly narrative to prove that they were actually working the resource plan.

Below is a sample Resource Planner report.



RESOURCE PLANNER REPORT

Resource Leveling Report = C:\P3WIN\P3OUT\M-RW06.OUT
Schedule: RW06

Resource Plan was made for Schedule RW06 on Data Date: 31JUL04
------------------------------------------------------------------------------------------------------------

04AUG04: Activity 060ELCD120, Install Control Conduit and Wire (6-10) delayed start waiting for resource,
    ELEC with Activity 060ELCD100, Install Power Conduits (6-10) to complete.

04AUG04: Activity 030ELCD120, Install Control Conduit/Wire (EL-15 to 8) delayed start waiting for resource,
    ELEC with Activity 060ELCD100, Install Power Conduits (6-10) to complete.

06AUG04: Activity 040ELCD100, Install Power Conduits @ Primary Sed Basin delayed start waiting for resource,
    ELEC with Activity 060ELCD120, Install Control Conduit and Wire (6-10) to complete.

09AUG04: Activity 040ELCD110, Install Branch Conduits @ Primary Sed Basin delayed start waiting for resource,
    ELEC with Activity 030ELCD100, Install Power Conduits (EL -15 to 8) to complete.

11AUG04: Activity YYYELDB100, ELB Ductbank: PG&E-17kV, 17kV-MVLT0201 delayed start waiting for resource,
    ELEC with Activity 030ELCD120, Install Control Conduit/Wire (EL-15 to 8) to complete.

11AUG04: Activity YYYUGSS130, ELB 20" SS (Pump Building to IPS) delayed start waiting for resource,
    PF with Activity 120AGPM100, Install 0.5-4" Plumbing Pipe under Slab to complete.

13AUG04: Activity YYYUGSE240, ELB 36" SE & 18" SD along West Edge of job delayed start waiting for resource,
    EX with Activity YYYUGSD170, ELB 6" SD East & South of Odor Contr Biofilters to complete.

14AUG04: Activity 050AGML100, Install 12" ML Recirc Piping AB 5 delayed start waiting for resource,
    PF with Activity 160AGFA120, Install 16"FA Pipe Inside East Wall of Biofilter to complete.

17AUG04: Activity 160ELCD100, Install Power Conduits @ Odor Control Biofilters delayed start waiting for resource,
    ELEC with Activity 040ELCD230, Install Control Conduit and Wire @ Prim Sed Bas to complete.

19AUG04: Activity YYYELDB104, ELB Ductbank: MVLT0202-T5, T5-MVLT0205 delayed start waiting for resource,
    ELEC with Activity 040ELCD110, Install Branch Conduits @ Primary Sed Basin to complete.

19AUG04: Activity YYYUGFA140, ELB 48" FA East & South of Odor Contr Biofilters delayed start waiting for resource,
    EX with Activity YYYUGSS130, ELB 20" SS (Pump Building to IPS) to complete.
    PF with Activity YYYUGSS130, ELB 20" SS (Pump Building to IPS) to complete.

20AUG04: Activity 060COPC210, FPS AB 8 Walls delayed start waiting for resource,
    CAR with Activity 060COPC150, FPS Blower Room Influent Channel/Inlet 2nd Lift to complete.

20AUG04: Activity YYYELDB114, Install Grounding System 17 KV delayed start waiting for resource,
    ELEC with Activity 040ELCD100, Install Power Conduits @ Primary Sed Basin to complete.

24AUG04: Activity YYYELDB108, ELB Ductbank: MVLT0202-MVLT0203 delayed start waiting for resource,
    ELEC with Activity YYYELDB100, ELB Ductbank: PG&E-17kV, 17kV-MVLT0201 to complete.

26AUG04: Activity YYYUGCN180, ELB 6" CEN (from IPS west to connection point) delayed start waiting for resource,
    PF with Activity YYYUGFA140, ELB 48" FA East & South of Odor Contr Biofilters to complete.
    EX with Activity YYYUGFA140, ELB 48" FA East & South of Odor Contr Biofilters to complete.