MS Project 2013 – expert help and advise required

Home Forums Discussion Forum MS Project 2013 – expert help and advise required

  • This topic has 5 replies, 3 voices, and was last updated 8 years ago by Ramil Ganiyev.
Viewing 5 reply threads
  • Author
    Posts
    • #389395
      Ramil Ganiyev
      Guest

      Dear All,

      I would like to kindly ask you to help me on below issue.

      I have more than 500 Tasks in my project which built in MS project. Also we have 250 employees to carry out these tasks during next 1,5 years. Each activity has different scheduled dates and we would like to know how many person we need on site during peak point. So here is the question.

      Task Name : Painting Pipe Supports

      Task dates: 18/06/16 – 24/11/16 (101 days (duration shown by program automatically) – is this only 5 days per week?)

      Amount of Pipe Supports 458 EA.

      As ONE painter can finish 25EA supports per week – in current situation we need 0,9 Painter on workplace to carry out this task during this time frame. So we would like to program somehow MS Project to tell us how many painter we need incase if we reduce duration (instead of 101 days can be 85 days) and also how many total painters we have to have on plant during 18/06/16-24/11/16 time frame to carry out all activities.

      Thank you so much for your comments and advise in advance.

      Your help and support are appreciated.

    • #389507
      Larry Christofaro
      Participant

      Ramil, try using Fixed Work and your task type. That will change the units when duration is changed. Hope this helps…

    • #389543
      Ramil Ganiyev
      Guest

      Thank you Larry for your comment and advise. didn’t work to be honest.
      By the way is there any possibility to assign 1 resource 25EA (can paint 25 item per week) so project can calculate how many person requires for this task?

      Thanks a lot in advance

    • #389592
      Larry Christofaro
      Participant

      Sorry, not that I can think of off the top of my head, at least not this early in the morning. If I can think of something I’ll let you know, but might need to be a combination of setting the resource hours and material units together (with a little math in your head).

    • #389608
      Prakash K P
      Participant

      You can add the custom fields to calculate the number of painters.

    • #389610
      Ramil Ganiyev
      Guest

      Dear Prakash,

      May I kindly ask you to explain with more details what you mentioned as I am newborn on MS Project.

      Thanks a lot in advance

Viewing 5 reply threads
  • You must be logged in to reply to this topic.