none
Using Project to Schedule a Machine Shop RRS feed

  • Question

  • I am using a "project release board" to release projects by priority but not until capacity to do the work is available.  That is, I am trying to do resource-constrained scheduling.  I am aware of the prolific work with Algorithms, Lean, POLCA, etc. Algorithms are too complicated and we do not yet have enough cells to make POLCA work.  I favor a simple Theory of constraint approach which assumes there is a single constraint.  In job shops constraints move with product mix and other factors.  I envision looking at skilled people (welders) and specific large pieces of equipment where most projects go through as constraints.  I would schedule a finite number of hours work through each constraint using MS Project for each constraint.

    As a novice with MS Project, I am asking 1) is what I propose feasible and 2) can anyone share their experience.

    Tuesday, January 21, 2014 5:33 PM

All replies

  • I have not used TOC or CCPM with MS Project but would recommend you check out Larry Leach's Advanced Projects website http://www.advanced-projects.com.   Larry has written several books and done quite a bit of work in this area (I have heard him speak at numerous PMI meetings).  This may be a good starting point for you.   Good luck.
    Tuesday, January 21, 2014 5:51 PM
  • Hi Bill,

    What you're willing to achieve is feasible with MS Project (either server version or using a shared resource pool).

    Basically you could define a work resource for your welders, specifying the capacity (ie 500% or 5 if you have 5 welders). Then you could also create some material resources for your pieces of equipement. Those resources might be created either in a shared resource pool file (if not using project server) or in the enterprise resource pool (if using project server).

    Once done, you can schedule your projects assigning work and material resources to them. Then you'll be able to consolidate the resource capacity, detect overallocation.

    Here is some links:

    • shares resource pool: http://office.microsoft.com/en-us/project-help/share-resources-using-a-resource-pool-HA010214871.aspx
    • resource type: http://ntrajkovski.wordpress.com/2011/10/17/different-resources-types-in-ms-project-2010-and-what-do-you-have-to-know-about-them/

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Tuesday, January 21, 2014 5:53 PM
    Moderator