Material resource not spreading over task duration when changing work resources

[PhilipeLaperche]

Hello,

I am having problems when i assign material and work resources to a task if i try to change the work resource assigned, increasing or decreasing, as the material resource is not changing its duration and affecting the duration of the whole task and therefore the project.

For exemple, i set an earthwork task, of 10.000 m³ (material) for a single team for 10 days, which spreads the earthwork for 1.000 m³ / day. Then i increase the task for 2 teams, which decrease the work duration to 5 days (unit or work fixed), but the material stays for 1.000 m³ / day and therefore 10 days.

Whys is this happening? Shouldnt the material recalculate and spread following the work duration? I have tried different calendars, work type, blank project... i have to delete all materials, reschedulate, simulate the project, and when finished reinsert the materials for control.

The following screenshots shows the behavior i am experiencing:

scheduling the work for a single team

iterating the project for more than a team but the material keeps its consumption and the material and work have different end dates, with the task keeping its original end date.

Is it a configuration problem, a corruption or a software limitation? Thank you very much!

[#2 · Accepted solution]

Hi @PhilipeLaperche 

Project works that way, and it's not a configuration issue, nor a corruption issue.

If you want you can try to redistribute the material resources again in the task duration time, based only on the work time of the non-material resources.

As a suggestion, I would set all material resource allocations to zero and re-assign the previous amounts.

To make this procedure easier, first make a backup of your file and load a Resource Usage view that includes the columns: Work and Resource Type (Insert Column).

With all allocations displayed, show only all Material Type resources with the automatic filter in the Resource Type column title area.

Copy the entire Work column to the clipboard (Copy to Column Title)

Set all Work to 0 by selecting the Work column and: Task > Edit > Clear > Clear All .

Select the Work column and Paste.

Remove the Material Type filter.

And that's it.

I hope you find it useful.

Ignacio