SOLVED

Duration1, Duration2, Duration3 used to calculate project costs from Resource Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2941848%22%20slang%3D%22en-US%22%3EDuration1%2C%20Duration2%2C%20Duration3%20used%20to%20calculate%20project%20costs%20from%20Resource%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2941848%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20seeking%20advice%20as%20to%20how%20I%20can%20calculate%20resource%20costs%20from%20Duration%201%2C%20Duration2%20Duration3%2C%20etc%2C%20and%20ignore%20Duration%20which%20all%20costs%20are%20currently%20calculated%20from.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDuration1%2C%202%20%26amp%3B%203%20are%20efforts%20from%20different%20companies%20and%20resources%20which%20I%20want%20to%20account%20for%20individually%20but%20then%20they%20roll%20up%20to%20a%20project%20total.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20present%2C%20I%20am%20planning%20the%20project%20and%20costing%20in%20Excel%20which%20is%20not%20ideal%20for%20building%20resource%20estimates%20and%20costs.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2943102%22%20slang%3D%22en-US%22%3ERe%3A%20Duration1%2C%20Duration2%2C%20Duration3%20used%20to%20calculate%20project%20costs%20from%20Resource%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2943102%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1212164%22%20target%3D%22_blank%22%3E%40dpconsult2025%3C%2FA%3E%3C%2FP%3E%3CP%3EFirst%20you%20need%20to%20understand%20that%20in%20Project%20duration%20is%20simply%20a%20time%20span.%20The%20passage%20of%20time%20accomplishes%20nothing.%20What%20you%20need%20to%20focus%20on%20is%20work.%20Work%20is%20the%20effort%20one%20or%20more%20resources%20expends%20to%20accomplish%20a%20task.%20Cost%20is%20not%20duration%20based%2C%20although%20it%20may%20appear%20that%20way%20depending%20on%20how%20resources%20are%20assigned%2C%20cost%20is%20actually%20based%20on%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20tendency%20for%20new%20users%20of%20Project%20to%20report%20progress%20by%20entering%20a%20value%20into%20the%20%25%20Complete%20field%2C%20when%20they%20should%20be%20entering%20progress%20into%20the%20Actual%20Work%20or%20%25%20Work%20Complete%20field.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20not%20use%20the%20extra%20Duration%20fields%20to%20track%20work%20from%20different%20companies.%20Rather%2C%20I%20suggest%20you%20make%20each%20company%20a%20separate%20resource%20and%20assign%20them%20to%20tasks%20accordingly.%20The%20cost%20associated%20with%20each%20company%20can%20then%20be%20viewed%20either%20on%20the%20Resource%20Sheet%20or%20the%20Resource%20Usage%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2945513%22%20slang%3D%22en-US%22%3ERe%3A%20Duration1%2C%20Duration2%2C%20Duration3%20used%20to%20calculate%20project%20costs%20from%20Resource%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2945513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F917748%22%20target%3D%22_blank%22%3E%40John-project%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20reply%2C%20i%20appreciate%20your%20replying.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20further%20explanation%20if%20you%20have%20the%20time%20and%20inclination.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20task%20that%20has%20a%20duration%20of%2051%20days%20with%20a%20work%20effort%20of%205%20days%20for%20Vendor1%20and%2012.5%20days%20Vendor2.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20assign%20a%20cost%20of%20%241%20per%20hour%20project%20takes%20the%2051%20days%20of%20Duration%20multiplies%20it%20by%208%20to%20get%20408%20hours%20which%20then%20shows%20in%20the%20Gantt%20Cost%20as%20%24408%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20it%20to%20show%20as%20a%20total%20cost%20of%20%24140%26nbsp%3B%20in%20the%20Resource%20cost%20it%20would%20be%20Vendor1%20%2440%20and%20Vendor2%20%24100%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20not%20happening%2C%20have%20attached%20a%20screenshot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2948485%22%20slang%3D%22en-US%22%3ERe%3A%20Duration1%2C%20Duration2%2C%20Duration3%20used%20to%20calculate%20project%20costs%20from%20Resource%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2948485%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1212164%22%20target%3D%22_blank%22%3E%40dpconsult2025%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assume%20the%20work%20effort%2C%20which%20is%20normally%20expressed%20in%20hours%2C%20is%2040%20hours%20(5%20days)%20for%20Vendor%201%20and%20100%20hours%20(12.5%20days)%20for%20Vendor%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20screen%20shot%20shows%20custom%20fields%20for%20TM%20effort%2C%20Change%20Mgmt%20effort%20and%20DXC%20effort%20which%20I%20also%20may%20assume%20are%20the%20Duration1%2C%20Duration2%2C%20and%20Duration3%20fields.%20Extra%20fields%20(e.g.%20Duration1%2C%20etc.)%20are%20static%20fields%2C%20they%20have%20no%20relationship%20to%20Project's%20scheduling%20or%20costing%20calculations.%20You%20have%20assigned%20resource%20DXC%20to%20the%20task%20and%20if%20you%20are%20getting%20a%20task%20cost%20of%20%24408%20then%20you%20apparently%20have%20assigned%20DXC%2C%20whose%20standard%20rate%20is%20%241%2Fhr%2C%20at%20100%25.%20Project%20will%20therefore%20linearly%20spread%20that%20assignment%20over%20the%20full%2051%20days%20of%20task%20duration.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20what%20you%20need%20to%20do.%20Forget%20the%20custom%20Duration%20fields%20to%20entering%2Ftracking%20vendor%20effort.%3C%2FP%3E%3CP%3E1.%20Create%20three%20resources%20on%20the%20Resource%20Sheet%2C%20Vendor%201%2C%20Vendor%202%2C%20Vendor%203%2C%20each%20with%20an%20hourly%20rate%20of%20%241%2Fhr.%3C%2FP%3E%3CP%3E2.%20Create%20a%20Fixed%20Duration%20type%20task%20of%2051%20days.%3C%2FP%3E%3CP%3E3.%20Assign%20Vendor%201%20and%20Vendor%202%20at%20100%25.%20That%20will%20initially%20give%20the%20following%20result%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-11-10_09-29-13.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326070i68089C707B4B298A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-11-10_09-29-13.png%22%20alt%3D%222021-11-10_09-29-13.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E4.%20Switch%20to%20the%20Task%20Usage%20view.%20Edit%20the%20Work%20hours%20for%20each%20resource%20assignment%20as%20shown.%20Note%20Project%20will%20automatically%20linearly%20spread%20each%20resource's%20hours%20over%20the%20full%2051%20day%20task%20duration.%20If%20you%20want%20the%20spread%20to%20be%20different%2C%20manually%20edit%20the%20timescale%20data%20(right%20side%20of%20view)%20as%20needed.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-11-10_09-31-49.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F326072i931DED78ADE44087%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-11-10_09-31-49.png%22%20alt%3D%222021-11-10_09-31-49.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EDoes%20that%20give%20you%20what%20you%20need%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20times%20when%20an%20external%20supplier%20(e.g.%20contract%2C%20vendor%2C%20etc.)%20is%20needed%20for%20a%20plan%2C%20that%20supplier%20has%20a%20fixed%20price%20contract%20to%20do%20whatever%20work%20is%20required.%20Is%20that%20better%20describes%20your%20scenario%2C%20then%20that%20cost%20is%20handled%20differently.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am seeking advice as to how I can calculate resource costs from Duration 1, Duration2 Duration3, etc, and ignore Duration which all costs are currently calculated from. 

 

Duration1, 2 & 3 are efforts from different companies and resources which I want to account for individually but then they roll up to a project total.

 

At present, I am planning the project and costing in Excel which is not ideal for building resource estimates and costs. 

3 Replies

@dpconsult2025

First you need to understand that in Project duration is simply a time span. The passage of time accomplishes nothing. What you need to focus on is work. Work is the effort one or more resources expends to accomplish a task. Cost is not duration based, although it may appear that way depending on how resources are assigned, cost is actually based on work.

 

There is a tendency for new users of Project to report progress by entering a value into the % Complete field, when they should be entering progress into the Actual Work or % Work Complete field.

 

Do not use the extra Duration fields to track work from different companies. Rather, I suggest you make each company a separate resource and assign them to tasks accordingly. The cost associated with each company can then be viewed either on the Resource Sheet or the Resource Usage view.

 

Hope this helps.

John

@John-project Thank you for your reply, i appreciate your replying.

 

I need further explanation if you have the time and inclination. 

 

I have a task that has a duration of 51 days with a work effort of 5 days for Vendor1 and 12.5 days Vendor2. 

 

When I assign a cost of $1 per hour project takes the 51 days of Duration multiplies it by 8 to get 408 hours which then shows in the Gantt Cost as $408 

 

I need it to show as a total cost of $140  in the Resource cost it would be Vendor1 $40 and Vendor2 $100 

 

That is not happening, have attached a screenshot.

 

best response confirmed by dpconsult2025 (New Contributor)
Solution

@dpconsult2025 

I assume the work effort, which is normally expressed in hours, is 40 hours (5 days) for Vendor 1 and 100 hours (12.5 days) for Vendor 2.

 

The screen shot shows custom fields for TM effort, Change Mgmt effort and DXC effort which I also may assume are the Duration1, Duration2, and Duration3 fields. Extra fields (e.g. Duration1, etc.) are static fields, they have no relationship to Project's scheduling or costing calculations. You have assigned resource DXC to the task and if you are getting a task cost of $408 then you apparently have assigned DXC, whose standard rate is $1/hr, at 100%. Project will therefore linearly spread that assignment over the full 51 days of task duration.

 

Here's what you need to do. Forget the custom Duration fields to entering/tracking vendor effort.

1. Create three resources on the Resource Sheet, Vendor 1, Vendor 2, Vendor 3, each with an hourly rate of $1/hr.

2. Create a Fixed Duration type task of 51 days.

3. Assign Vendor 1 and Vendor 2 at 100%. That will initially give the following result

2021-11-10_09-29-13.png

4. Switch to the Task Usage view. Edit the Work hours for each resource assignment as shown. Note Project will automatically linearly spread each resource's hours over the full 51 day task duration. If you want the spread to be different, manually edit the timescale data (right side of view) as needed.

2021-11-10_09-31-49.png

Does that give you what you need?

 

Many times when an external supplier (e.g. contract, vendor, etc.) is needed for a plan, that supplier has a fixed price contract to do whatever work is required. Is that better describes your scenario, then that cost is handled differently.

 

John