Resources Cost

[salim]

I want to generate a database for Resources and Resources Cost . Resources are like (Manpower, Equipment, Material and Money). A Resource Costs should be a cumulative of its basic rate plus the cost of any assigned resources to it in multilevel. Example : I want to generate a composite cost for a car by assigning the cost of the driver and the cost of petrol to its basic rate. at the same time the cost of the driver is a composition of the driver basic rate plus accommodation cost and other benefits. and so on ...What is the best practice to create such a database. Please note that I am not an IT background.(Thank you)

[orange]

Do you have a complete list of
ResourceTypes

and for each a list of attributes that apply

  For a  Road Trip for example  (truck/ haulage
Vehicle  - original cost
            -maintenance/mile
            -fuel/mile

Driver    -base rate
            -rate/mile or rate/hour
            -accommodation/day
            -meals
            -benefits

I think you need a list of Resources; a corresponding list of attributes and then some guesstimate of the "Work" envisioned and the Resource Utilization; then individual costs and assumptions.

Interesting project --suggest you make good use of Google/Bing.
Good luck.

[salim]

Thank you Orange so much, In fact I have a complete list of Resources. I would like to clarify as follows:

A - I have Resources Table with the following fields. ResID, Name, BasicRate, Factor, Output.
and a calculated ResBasiceCost = BasicRate*Factor/Output. (for Basic Resources Level zero)

Now I need to create a Composite Resources in the same table By allocating Many Resources-to-One Resource.

B - I created another table ResourceCost and fields are: ResCostID,ResID(ref above table), ResIDM (FK for above table also), ResQty.

Now, the Sum of Allocated Resources Cost ResCompCost= Sum(ResQty*ResRate)/Output "this is the total cost of the many resources allocated to one resource".
where ResRate should not create a circular Reference.

C - The final Resource Rate ResRate =ResBasicCost+ResCompCost.

My question is what is the best practice to generate such a database. Are those two tables which are linked with two relations One-to-One and One-to-Many at the same time will do the job?. and how to avoid circular references during nesting the resources together in multilevel resources database?.

I hope I have made it clear.