In this project I’m aiming to build several applets inspired by construction industry processes, however, applicable to any industry concerned with scheduling, budgeting and resource allocation.
On the agenda:
Estimates the number of work weeks required to complete an activity when provided the following input:
-
The amount to be carried out (e.g Cubic yards of excavated dirt, tons of steel to be erected, etc. )
-
The productivity rate (e.g. cubic yards per hour, man-hour per ton, etc.)
-
Crew size
-
Number of crews per shift
-
Number of shifts (Morning and/or evening)
Automates the scheduling of activities with known dependencies. An activity dependent on another cannot commence until activities it is dependent upon are complete. Considerations include what tasks must be complete before the current task begins, what tasks should be completed at the same time, and what tasks should begin after current task is complete.
After activities are scheduled, the tool will identify the critical path. The critical path represents the longest route (duration) from beginning to end. Delays of activities falling on the critical path cause a delay on the overall project completion.
A tool to allow monitoring of budget and schedule efficiency at individual progress periods and for the overall project cumulatively. At the beginning of a project, a baseline schedule is set.
-
Each progress period is allocated mahours required to complete the tasks in that period (Budgeted Cost of Work Scheduled or Planned Value)
At the end of each period, the following are updated:
-
(Budgeted Cost of Work Performed or Earned Value)
-
(Actual Cost of Work Performed or Actual Cost)
With these three figures, metrics for project performance can be deduced, namely Cost Performance Index and Schedule Performance Index
-
Ability to track number of crews on-site per given shift to reduce jobsite clutter.
-
Ability to list activities by crew.