Duration calculation for Mining Activity

[Laynne]

Hi ,

I have gone through the threads but do not find an answer to my specific
problem.

I am in the earthmoving business.Weird as it may sound but my tasks is
shifting of ground and I do not have a completion date.My completion date is
dynamic and can change based on the amount of resources " dozers" I want to
allocate to the project.

Inputs :
Task = Each block of ground is a volume lets say 30 000 tons
Resource =I have a dozer that can mine @ 300 tons / hour.
Duration = 30 000/300 = 100 hours , which is then used to update my schedule
finish date.

Objective of this excercise :
I want to adjust the tons / hour value to determine completion date.

I have 475 blocks that needs to calculated and linked to determine my final
completion date.

Maybe the question is stupid , but I would really appreciate a solution

Thanks in advance

 

[John]

Hi ,

I have gone through the threads but do not find an answer to my specific
problem.

I am in the earthmoving business.Weird as it may sound but my tasks is
shifting of ground and I do not have a completion date.My completion date is
dynamic and can change based on the amount of resources " dozers" I want to
allocate to the project.

Inputs :
Task = Each block of ground is a volume lets say 30 000 tons
Resource =I have a dozer that can mine @ 300 tons / hour.
Duration = 30 000/300 = 100 hours , which is then used to update my schedule
finish date.

Objective of this excercise :
I want to adjust the tons / hour value to determine completion date.

I have 475 blocks that needs to calculated and linked to determine my final
completion date.

Maybe the question is stupid , but I would really appreciate a solution

Thanks in advance

Layanne,
Well first of all, your question is NOT stupid.

While reading your post I was doing fine until I came to the part where
you want to adjust the tons/hour. That seems unusual given a dozer can
do 300 tons/hour. Normally to shorten the duration [time], more
resources are added. In this case, it would be additional dozers. But
apparently you are able to adjust the rate at which the dozer works. How
you do dat?

It may very well be that Project is not the application you want to use.
If it is a simple rate calculation problem, a spreadsheet (e.g. Excel),
would probably work better.

John
Project MVP

 

[Rod Gill]

That is fairly simple. Enter a Task and select Window split
Select the resource Dozer and enter units of 100 and hours of 100h
Click Ok and duration of 12.5d is calculated. If you have 2 Dozers, edit
Units to 200% and duration reduces to 6.25d

Hours of work represent your tons/hour figure, so calculate hours to move 1
blocks spoil with available dozer.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Laynne]

Thanks a million guys ,

Sheesh now it seems so simple , hehe

Appreciated

Laynne

 

[Trevor Rabey]

30000 tonnes/dozer = 100 hours is 12.5. Days Duration at 100% of a dozer.
2 x dozers is the same thing assigned at 200% etc.
Just have max units set as high as necessary for the number of available,
but not necessarily committed, dozers

You are better off estimating Duration in days and Work (for Work type
Resources, which is how this equipment can be treated) in Hours, and not
mixing them up, so that you maintain an idea of the distinction between
Duration and Work.
--
Trevor Rabey

0407213955
61 8 92729485
Perfect Project Planning
www.perfectproject.com.au