Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-01-2016, 01:08 AM
premkumar_m premkumar_m is offline Expected task end date is not reflecting . Need help Windows 7 64bit Expected task end date is not reflecting . Need help Office 2016
Novice
Expected task end date is not reflecting . Need help
 
Join Date: Nov 2016
Posts: 1
premkumar_m is on a distinguished road
Default Expected task end date is not reflecting . Need help

need assistance, how to get the desired result?





Scenario:

A task say "Paint the wall" requires total 24 hours to complete.

For a day, we expect daily working hours for each person is 8 hours.



The project need to start by Wednesday. (i.e., 7 jan 2015 in this video)

3 Persons were assigned to complete this task effectively.

We expected 8 hours from each, hence expected the work to be completed on same day !



But, we have below constraints:

1st Person "A" can work only for 4 hours daily.

2nd Person "B" can also work only for 4 hours daily.

3rd Person "C" can work only for 2 hours daily and also not available to work on Thursday and Friday.

Saturday and Sunday is generally holiday and no work is expected.



With the above constraints, this 24 hours work can be completed by

On Wednesday,

Person "A" and "B" will work for 4 hours each. Person "C" will work for 2 hours.

Hence, 4+4+2 = 10 hours work should be completed.



On Thursday,

Person "A" and "B" will work for 4 hours each. Person "C" will not work.

Hence, 4+4 = 8 hours work should be completed. (Total: 18hours work completed so far. Remaining work expected is 6 hours only)

On friday,

Person "A" and "B" will work for 3 hours each. Person "C" will not work.

Hence, 3+3 = 6 hours work should be completed. (Total: 24hours work completed by Friday. This is the expected output)

But while trying the above scenario, Ms Project calculates differently and splits the work incorrectly to resources and shows that work will be completed by next Tuesday only ! (i.e., 13 Jan 2015 in this video).

Need assistance how to fix this ? or how to achieve desired result in ms project?



The steps tried is showing in video, which incorrectly calculates and shows the work will be completed by 13 Jan 2015 (Tuesday only).

https://www.youtube.com/watch?v=P9fhXiejG7I


Please suggest how to achieve desired result.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make a task adjust its end date depending on another task? (Newbie) ravl13 Project 3 07-27-2014 06:10 PM
Expected task end date is not reflecting . Need help Passed due task end date tcalderini Project 1 09-19-2013 04:56 AM
Expected task end date is not reflecting . Need help macro for reflecting objects along all slides samifox PowerPoint 3 05-05-2012 01:58 AM
Task with Start date but no Due date? bplat Outlook 0 01-12-2012 08:10 AM
Task type relationships not acting as expected Rkramkowski Project 0 12-08-2005 10:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 AM.


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