Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2013, 04:35 PM
Guloluseus Guloluseus is offline Tracking materials over time Windows 7 64bit Tracking materials over time Office 2007
Competent Performer
Tracking materials over time
 
Join Date: Mar 2013
Posts: 167
Guloluseus is on a distinguished road
Default Tracking materials over time


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
Reply With Quote
  #2  
Old 03-25-2013, 04:52 AM
JulieS JulieS is offline Tracking materials over time Windows 7 64bit Tracking materials over time Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi,
Welcome to the forum.

To answer your question:

Quote:
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
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
Reply With Quote
  #3  
Old 04-02-2013, 09:46 AM
Guloluseus Guloluseus is offline Tracking materials over time Windows 7 64bit Tracking materials over time Office 2007
Competent Performer
Tracking materials over time
 
Join Date: Mar 2013
Posts: 167
Guloluseus is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 04-02-2013, 11:08 AM
JulieS JulieS is offline Tracking materials over time Windows 7 64bit Tracking materials over time Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome and thank you for the feedback.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tracking materials over time Employee time tracking using email iampav Outlook 1 06-07-2012 06:54 AM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in tinfanide Excel Programming 1 03-04-2012 12:05 AM
Tracking materials over time Tracking addenda? markg2 Word 6 01-31-2011 06:04 PM
Tracking materials over time Missing tracking tab Gizmo Outlook 1 11-19-2007 12:11 PM
Tracking materials over time Tracking Messages Matt Outlook 1 12-10-2005 02:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:44 PM.


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