SOLVED

Rounding of partial percentage of a workday

%3CLINGO-SUB%20id%3D%22lingo-sub-2194929%22%20slang%3D%22en-US%22%3ERounding%20of%20partial%20percentage%20of%20a%20workday%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2194929%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20MS%20Project%20Pro.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20observer%20something%20strange%20happening%20to%20my%20project%20plan%20maybe%20somebody%20can%20help%20explain%20what%20is%20happening%3A%20I%20have%20task%20called%20%22Status%20Report%22%20which%20is%20allocated%201hr%20to%20do%20this%20task.%3C%2FP%3E%3CP%3EThis%20is%20allocated%20to%20James%20Bond%20whose%20hourly%20rate%20is%20%2450%20and%20his%20normal%20working%20period%20per%20day%208hr.%20Hence%2C%2012.5%25%20is%20basically%201hr%20(0.125%20x%208%3D1).%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ESo%20I%20assign%20to%20task%20%22Status%20Report%22%2012.5%25%20and%20assign%20it%20to%20James%20Bond.%20This%20is%20what%20I%20am%20observing%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E1.%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ewhen%20I%20type%2012.5%25%20MS%20Project%20displays%20it%20as%2013%25%20and%20calculates%20the%20cost%20as%200.125%20X%20%2450%3D%246%2C25%20-%20fine%20all%20well%20and%20good%3C%2FP%3E%3CP%3E%3CSTRONG%3E2.%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Enow%20when%20I%20change%20the%20allocation%20to%20say%2010%25%20MS%20Project%20displays%20it%20as%2010%25%20and%20calculates%20the%20cost%20as%200.1%20x%20%2450%20%3D%20%245%20-%20all%20correct%20no%20issue%20as%20well%3C%2FP%3E%3CP%3E%3CSTRONG%3E3.%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ethen%20when%20I%20revert%20back%20to%2012.5%25%20MS%20displays%20it%20as%2013%25%20BUT%20now%20calculates%20the%20cost%20as%200.13%20x%20%2450%20%3D%20%246.50%20-%20here%20it%20starts%20show%20inconsistency%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20when%20I%20switch%20back%20to%2012.5%25%20in%20(3)%20it%20actually%20uses%2013%25%20x%20%2550%20%3D%20%246.50%20which%20is%20not%20what%20I%20want%20this%20slightly%20more%20than%201hr's%20cost%2C%20I%20tried%20doing%20various%20changes%20etc%20I%20cannot%20get%20to%20the%20status%20back%20as%20shown%20in%20(1)%20above.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20is%20this%20so%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20let%20me%20know%20how%20I%20can%20fix%20the%20cost%20calculation%20as%200.125%20x%20%2450%20and%20NOT%20as%200.13%20x%20%2450%3C%2FP%3E%3CP%3EHelp%20much%20appreciated.%3C%2FP%3E%3CP%3EBest%20Rgds%3C%2FP%3E%3CP%3EKish%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2194929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2010%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2196417%22%20slang%3D%22en-US%22%3ERe%3A%20Rounding%20of%20partial%20percentage%20of%20a%20workday%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2196417%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F958904%22%20target%3D%22_blank%22%3E%40Kish27%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20example%20is%20not%20clear.%20For%20example%2C%20you%20say%20the%20status%20report%20is%20a%201hr%20task%20but%20then%20you%20assign%20James%20to%20the%20task%20at%2012.5%25.%20That%20means%20he%20has%20a%20work%20content%20of%20.125%20hours%2C%20not%201%20hour.%20Is%20that%20your%20intent%3F%20If%20so%2C%20is%20the%20task%20type%20then%20fixed%20duration%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20exactly%20did%20you%20enter%20the%20assignments%20for%20James%20(i.e.%20what%20view%20field%20or%20form)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20are%20you%20bouncing%20the%20resource's%20assignment%20back%20and%20forth%20between%2012.5%25%20and%2010%25%3F%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi

 

I am using MS Project Pro.


I observer something strange happening to my project plan maybe somebody can help explain what is happening: I have task called "Status Report" which is allocated 1hr to do this task.

This is allocated to James Bond whose hourly rate is $50 and his normal working period per day 8hr. Hence, 12.5% is basically 1hr (0.125 x 8=1).


So I assign to task "Status Report" 12.5% and assign it to James Bond. This is what I am observing:

 

1. when I type 12.5% MS Project displays it as 13% and calculates the cost as 0.125 X $50=$6,25 - fine all well and good

2. now when I change the allocation to say 10% MS Project displays it as 10% and calculates the cost as 0.1 x $50 = $5 - all correct no issue as well

3. then when I revert back to 12.5% MS displays it as 13% BUT now calculates the cost as 0.13 x $50 = $6.50 - here it starts show inconsistency

 

Why when I switch back to 12.5% in (3) it actually uses 13% x %50 = $6.50 which is not what I want this slightly more than 1hr's cost, I tried doing various changes etc I cannot get to the status back as shown in (1) above.

 

Why is this so?

 

Can someone let me know how I can fix the cost calculation as 0.125 x $50 and NOT as 0.13 x $50

Help much appreciated.

Best Rgds

Kish

6 Replies
best response confirmed by Dale Howard (MVP)
Solution

@Kish27 

Your example is not clear. For example, you say the status report is a 1hr task but then you assign James to the task at 12.5%. That means he has a work content of .125 hours, not 1 hour. Is that your intent? If so, is the task type then fixed duration?

 

How exactly did you enter the assignments for James (i.e. what view field or form)?

 

Why are you bouncing the resource's assignment back and forth between 12.5% and 10%?

 

Something else that you should realize is that the resource rate is not $50/hr when the work is less than an hour, it is really .83333333 cents per minute. When the 12.5% assignment is initially entered it goes in as 7.5 minutes giving a cost of $6.4999999. And when the assignment is changed to 10%, the cost ends up being $4.99999. Somewhere in all those calculations round-off errors will accumulate and that is essentially what happens when the assignment goes back to 12.5%, it is no longer processed as 7.5 minutes but is rounded to 8 minutes and hence the cost ends up $6.67 instead of $6.25. Can you force the calculation back to 7.5 minutes? Yes. You can delete the resource and re-enter the original values or you can open the Visual Basic Editor window in Immediate and enter this line of code

activeproject.Tasks(1).Resources(1).assignments(1).Work=7.5

John

Hi

Thank you for responding. Help much appreciated.

What I am doing is I have a Status Report task which is a 1hr task. I am assigning it to James Bond to do this job. In the resource sheet for James I have his hourly rate as $50/hr and he works 100% of his time which 8hrs per day.

Now when I assign James to this task Status Report, I double click on that task and Task Information panel appears and I go to Resource Tab I select, James Bond, under Resource Name and type 12.5% in units col. Immediately it displays 13% (this is fine as MS project rounds up the display ) and cost value shown is $6,25 which is correct 0.125x$50 =$6.25. Why 12,5% because 1hr of work - 0.125 x 8hr = 1hr.

The problem happens when I change it to 10% and back to 12,5% in which case it no longer calculates the last change as 0.125 x $50 but 0.13 x %50 = $6.50

Why am I bouncing between 12,5% to 10% and back to 12.5% is because I am just testing to see it is consistent in its calculation.
Each time I made the change I double click the task Status Report and change it in the Task Information -> Resource tab. Hope I am doing the update correctly!

Hope I made the above clear on what I am doing.
Best Rgds
Kish

Hi

 

I typed a long reply and selected post...I cant see my reply hope u have receive it. Please let me know if u have not.

@Kish27 

Yes I do see your reply.

 

Your assumption is incorrect. Assigning James at 12.5% to a 1 hour task results in a task work content of .125 hours (rounded to .13h), not 1 hour. The work content is based on the task duration, not the resource's max units. You can readily see this in this sample.

2021-03-11_12-57-20.png

As far as why Project gives a slightly different result when a odd value assignment is switched back and forth, I explained in my last response.

John

Hi
I went back and re-checked and did the same thing as u presented above and found out that you are write my original assumption was flawed as I got mixed up with duration and resource max unit. I have corrected what needs to be done.
Thanks a lot for clarifying this mistake.
This now close and resolved
Kish

Kish,
You're welcome and thanks for the feedback.
John