First post in the forum, hopefully this will be the one that fixes my woes

I am using Project 2007 to produce a company wide programme. We deal in civil and maintenance engineering, and have a large number of jobs that are either fixed in terms of start/ finish dates, or are floating (currently unallocated dates).
To complicate things, we also produce many of our materials, such as asphalt and concrete and have our plant fleets of excavators, lorries etc.

The programme will eventually include all projects, with the aim being to include all plant, labour and materials so that we can level out resource usage- floating jobs can be moved so that they fill in the low points. For example, if we have a 4 week period when asphalt production is at 150% capacity, we need to buy in materials, and we would like to move the work to a place where there is (for example) 50% production, giving us 100% over the period instead of a high then a low period.



I can allocate plant and labour and use visual reports to give a result, but am stuck on materials. A job will use a fixed amount of product (say asphalt) but the time may vary- if we lay 500 tonnes of asphalt it may br over 1 day or 4 days, depending on the rate of spread, which is determined by various factors. Is there a way to make a resource for materials that will allow me to input the tonnage and have project spread it over the allocated time period?

Currently I am using cost as tonnage, with several different resources such as 200t/day. 100t/day, and then working out the time it takes to lay, and matching this to the actual period- not 100% accurate but close enough. I would love to find a better way to do this, that means I do not need 15 different resources and a calculator all the time to work out where I am.

thanks

Hi,
Welcome to the forum.

To answer your question:

It's not a different method of creating the resource - just assigning the resource. It sounds like you have already created the material resources. Set their cost per unit (tonne it sounds like.) Then split your screen (Window - Split). Select the task in the top pane and in the lower pane, select the resource from the drop-down. In the units field enter the usage per day in the format: unit/day. So, for example if you use 300 tonnes per day - 300/d. If the duration of the task expands or collapses, the 300 units per day stays stable.

As a note, materials resources will not be automatically flagged for overallocation like work resources.

I hope this helps.
Julie

Sorry it took so long, but a big thank you I have been tied down in other projects and didnt get to see this for a while, but it has solved things nicely. I was looking for a way that other people can input data in terms of adjusting times or total durations in a simple way and this has killed two birds with one stone.

Again.. thanks for the assistance.

You're welcome and thank you for the feedback.