Microsoft Office Forums Handling multi-employee departments as a single resource for visibility to loading

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-14-2019, 04:45 PM
klhudson klhudson is offline Handling multi-employee departments as a single resource for visibility to loading Windows 10 Handling multi-employee departments as a single resource for visibility to loading Office 2016
Novice
Handling multi-employee departments as a single resource for visibility to loading
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Handling multi-employee departments as a single resource for visibility to loading Help on separate a single text cell into multi cells by coding Yasso Excel Programming 1 12-01-2015 05:45 PM
Handling multi-employee departments as a single resource for visibility to loading 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 11:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft