Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

LinkBack Thread Tools Display Modes
Old 03-14-2019, 04:45 PM
klhudson klhudson is offline Windows 10 Office 2016
Join Date: Mar 2019
Posts: 1
klhudson is on a distinguished road
Question Handling multi-employee departments as a single resource for visibility to loading

I could use a little help if anyone has done some similar before. I am trying to predict future loading in several different departments based on expected dates we might land a purchase order for machines we have quoted. I want to create some template projects for a standard machine design and build process for each of several base models we sell. This way, program managers can copy and paste a template structure for the type of machine they have quoted into a master schedule and drive placement of it with a purchase order receipt milestone set to the date we expect to receive it. All good so far, but I run into problems with the way I’m trying to show potential loading. We have a number of departments affected and varying numbers of available employees in each of those department, any or all of whom might be assigned to an engineering task or assembly task. I am not looking for resource leveling or loading for any one specific resource, I just need to get visibility to demand for entire departments for overall manpower requirements against a timescale so I can see if I will expect periods of drastic overload or downtime gaps where there is no work…very rough cut. I cannot schedule and assign individual employees (50-60 people) for this because it will be too complicated and unsustainable for the benefit I’m trying to achieve.

I would like to create a single resource for each department that reflects the entire available hours in the department and be able to enter and/or change a fixed number of hours and have the duration grow or shrink accordingly. If I have 8 employees available in mechanical assembly and they are normally all working in parallel on the mechanical assembly portion of any given project, I have eight times the normal 40 hours week available in a single bucket. How can I accomplish this?

I’ve tried setting the duration based on hours and using 800% availability and that gets me there for the template. The duration shrinks to 1/8 of the time as expected. If I want to change the number of hours, however, I have to calculate what the duration would be if divided by eight and enter that number…fairly complicated and risk prone for the casual users I am trying to get to use this system. Is there some other way to fix or specify the number of hours besides as duration and/or does anyone have a different approach I’m missing?

Using MS Project Standard 2016.

Any help is most appreciated!
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help on separate a single text cell into multi cells by coding Yasso Excel Programming 1 12-01-2015 05:45 PM
Word 2010 - Style Sets not fully loading / loading properly emilypage Word 3 11-09-2012 01:11 AM
Placeholders visibility and ISO_IEC_29500-1_2011 standard Ilya Y PowerPoint 2 06-20-2012 05:32 AM
Visibility of macros in PERSONAL.XLSB Dougiel Excel 0 05-24-2012 12:32 AM
Handling Excel Data msofficeno475 Excel 1 01-17-2010 09:56 AM

All times are GMT -7. The time now is 05:39 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft