Loading...
Quick Links

MS Project 2013 – expert help and advise required

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

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #389395 Reply
    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 Reply
    Larry ChristofaroLarry Christofaro
    Participant

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

    #389543 Reply
    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 Reply
    Larry ChristofaroLarry 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 Reply
    Prakash K PPrakash K P
    Participant

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

    #389610 Reply
    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 6 posts - 1 through 6 (of 6 total)
Reply To: MS Project 2013 – expert help and advise required
Your information: