Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

costing

ResolvedVersion 2016

Edward has attended:
Project Advanced course

Costing

I am trying to set up a costing template for projects but am having a problem with my milestones cause an "ERROR" message in the rollup of the %Prof. Forecast (see details below).

1. How do I remove the cost associated to 0 hrs duration on a milestone so that I am not dividing by zero?

2. Is there a better field to use if I want to apply a % margin to a number?

I have set up all my costs e.g:
Labour Travel Total %Prof. Revenue Budget Actual %Prof.
Cost Cost Cost 10% Forecast Cost Forecast

Labour Cost - Cost1
Travel Cost - Cost2
Total Cost - Cost1 + Cost2
%Prof. = [Number1]&"%"
Revenue Forecast = (Total Cost/(1-%Prof.)
Budget = Revenue Forecast
Actual Cost = Input as a duration
%Prof. Forecast = (Revenue Forecast-Total Cost)/(Revenue Forecast)


RE: Costing

Hi Edward

Thank you for using the forum

Could you perhaps send the file to info@microsoft-training.co.uk
I'd like to take a look at the file to get a better idea of what's happening in it

With thanks and kind regards
Wendy

MS Project tip:

Compare Work and Duration

Duration is the timescale within which a task is done; Work is the specific time element used. For example, 3 days work in a duration of 2 weeks. To compare, add the Work field into the Entry table by right clicking a column heading to Add Field.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.