Hi there,

Can project be used to calculate profits?

For example, using an Excavator and Operator to dig a trench for a client requires an estimated 72 hours.

The cost of hire of the Excavator and Operator is $500 per hour, and the charge to the client is $550 per hour.

If you have multiple items such as above, and have different costs for each, can project work out what the overall expected Cost is, and what the expected Profit is?



If so, how do you go about this?

Hello Mark,

Not directly, no. Project will calculate the cost of a task based upon work * standard rate for the resource. I suppose you can work around using two rate tables and then copy/paste the different costs into spare cost fields. Then right a formula in yet another spare field to calculate the difference.

However, I would be more inclined to export the data to Excel and do the calculations there.

Please post back if you need more detailed "How-tos" on any part of the process.

Julie