Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-05-2023, 04:32 AM
YourUncleBob YourUncleBob is offline Auto-adjust predecessors Windows 10 Auto-adjust predecessors Office 2019
Novice
Auto-adjust predecessors
 
Join Date: Dec 2023
Posts: 2
YourUncleBob is on a distinguished road
Default Auto-adjust predecessors

Hi there.


I have a situation where I have a plan template that gets customised for a project, but is obviously still a (good) estimate. A particular set of steps are:
1) Place order (2 days - Internal)
2) Manufacture (13 days - External service provider)
3) Receive (Milestone - Internal).

This gives a total 15 days (3 of 5 day working weeks).

(1) is done on time, and (2) starts on time. We are very fortunate and the ext.SP expects the work to be finished in 10 days. The milestone (3) will then obviously move up 3 days.

My question is as follows: Is there a way where I would change the milestone (3) and have the manufacture duration (2) automatically adjusted.





Thank you.
Etienne
Attached Images
File Type: png Untitled.png (5.4 KB, 4 views)
Reply With Quote
  #2  
Old 12-05-2023, 07:19 AM
DaleHowardMVP DaleHowardMVP is offline Auto-adjust predecessors Windows 10 Auto-adjust predecessors Office 2021
Advanced Beginner
 
Join Date: Apr 2023
Posts: 49
DaleHowardMVP is on a distinguished road
Default

No, what you want Microsoft Project to do is not possible. You should set the Actual Duration of the Manufacture task to 10 days and then the software will automatically adjust the schedule of the Receive milestone. Hope this helps.
Reply With Quote
  #3  
Old 12-06-2023, 02:51 AM
YourUncleBob YourUncleBob is offline Auto-adjust predecessors Windows 10 Auto-adjust predecessors Office 2019
Novice
Auto-adjust predecessors
 
Join Date: Dec 2023
Posts: 2
YourUncleBob is on a distinguished road
Default Many thanks.

Hi DH.


Thank you for your reply.

I had tried a number of different ways and eventually ended up doing that. It is a pity. I don't know their exact Mnf timing, so the 13/10 days is just a (reasonable) all encompassing estimate. So may plan, and my assessment of their capacity and assessment, is based on this.

Oh well.
Thank you very much for your support.
Etienne.
Reply With Quote
  #4  
Old 12-06-2023, 09:28 AM
DaleHowardMVP DaleHowardMVP is offline Auto-adjust predecessors Windows 10 Auto-adjust predecessors Office 2021
Advanced Beginner
 
Join Date: Apr 2023
Posts: 49
DaleHowardMVP is on a distinguished road
Default

No, it is definitely NOT a pity. What you are expecting is not how Microsoft Project works, nor should we expect it to work the way you want.

After planning your project, you need to save a Baseline for the project, which will capture the initial planned schedule of the project. As you begin entering progress in your project during the Execution stage of the project, you will be able to analyze variance between the current schedule and the original planned scheduled. In your case, the original planned Duration of the Manufacture task was 13 days, but the current Duration would only be 10 days. That would generate -3 days of Duration Variance, which is a very GOOD thing, as it shows that the task finished 3 days EARLIER than planned. Performing variance analysis in Microsoft Project is how you learn and grow as a project manager who uses this tool to manage your projects.
Reply With Quote
Reply

Tags
automatic, duration, predecessor



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-adjust predecessors Formula or VB to get max date with multiple dates and predecessors? mjank72 Excel 1 07-02-2015 06:20 PM
Auto-adjust predecessors Splitting Tasks - Predecessors ProjectScotland Project 2 02-19-2015 06:01 PM
Auto-adjust predecessors Multiple predecessors mrgipponi Project 3 09-01-2014 11:38 AM
Auto-adjust predecessors Auto Adjust After Early Finish LeonvdW Project 1 10-04-2013 05:27 AM
Pasting HTML into Excel (height auto-adjust) c-tran Excel 0 03-11-2010 07:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:33 AM.


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