none
Tracking total production hours projected per month RRS feed

  • Question

  • Our business consists of multiple projects where products are being manufactured for multiple clients.

    The factory has a known maximum of manhours per month of production capacity.

    In setting up project, I need to be able to see at a glance what the total committed manhours is across all projects on a per-month basis.  This is a critical value as it dictates whether or not we can commit to a new project or modify the timing of existing projects. Ideally this would be set up to give a pop-up screen with the current monthly commitment showing.  We need to look ahead by 3-4 months so there would be multiple monthly hours totals required.

    Is this possible with Project desktop 2013?

    Monday, February 17, 2014 12:43 AM

All replies

  • Hi Akored Hill,

    What you want to achieve is totally doable with Project 2013 (desktop assumes you do not use Project Server). I'd suggest to use generic resources with a maximum capacity for each in order to manage workload versus capacity. See this article about generic resources:

    • http://ntrajkovski.wordpress.com/2013/12/18/generic-resources-and-different-capacity-in-ms-project-2013/

    Then you could use a shared resource pool in order to manage your capacity across many projects. See those articles about the shared resource pool:

    • http://www.youtube.com/watch?v=h1A_Q_oyE6w
    • http://ntrajkovski.wordpress.com/2013/06/06/resource-pool-and-tasks-in-ms-project-2013/

    Finally you could use the native reports features of Project 2013 to vizualize monthly workload versus capacity of your generic skills among your projects.

    See below an article about MS Project 2013 reports:

    • http://office.microsoft.com/en-us/project-help/create-a-project-report-HA102829149.aspx

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS


    Monday, February 17, 2014 2:13 AM
    Moderator
  • I would add that you need to get some quality training in Project. Building multiple schedules with accurate resource assignments, updating them accurately and consolidating resource usage across multiple projects is advanced stuff. Training might save you many months of effort.

    You might also like to investigate Project Online as a tool to report on multiple projects, but get help from someone who knows Project Online or Project Server well.


    Rod Gill
    Author of the one and only Project VBA Book
    www.project-systems.co.nz

    Friday, February 21, 2014 8:40 AM
    Moderator