MS Project, Project Configurator for Cost Calculation

When we regularly run projects, that produce very similar end products, and besides that we use similar sequence of actions (e.g. we use the same implementation methodology), we can speak about typical projets. On a typical project we more or less start with one of the past projects and make some modifications on it. The basic benefit is that we don’t start with the “blank paper”.

The basic idea in my case was to build the project plan and cost estimates for the potential “full vesrion” of the final product, which can serve me as a configurator for the final product. What I need is a tool to to select only those components, which are interesting for the customer. After selecting appropriate components (activities) of the final product your project plan and cost estimates are ready (we can speak of seconds; what a benefit!!!).  In order to achieve this in MS Project, we have to create custom columns for cost calculation according to the selection critetria.

We add a new column by using “Insert Column” command on the context menu of the title row in the spreadsheet.

The “Cost” column is where the cost of activities are automaticaly calculated (depends on whetehr you have assigned resources to the task and a cost rate for the resources).

We will use “Flag 1” column for the selection flag (Yes – activity is included in the project ; No- this activity is not included).

The “Cost 1” column will be calculated according to the selection flag. If flag is “Yes” then cost will be included, otherwise the cost will be zero.

Now we have to configure the “Cost 1” column. Column will be calculated according to the “Flag 1” status. In order to start configuring the column, select the “Custom fields” column from the context menu.

Select “Formula” button.

In the “Formula” dialog box insert the formula: IIf([Flag1]=Yes;[Cost];0)

In case the Flag1 is “Yes”, the Cost1 column has the value of Column, otherwise it is zero.

Some warning dialogs appear when you close the dialog.

Wea are back in the “Custom fields” dialog. In order to “sum” all costs of the selected sub-activities (Flag1 = Yes) into the activity in the higher level, we have to select “Rollup” buton and “Sum” from the drop-down menu.

Here is the final result:

The activity is not selected (Flag1 = No). Consecuently Cost1= 0 €.

Toggle to Yes.

Now, Flag1 = Yes and consecuently the Cost1 = Cost = 1.120,00 €.

(You will receive the cost value <> 0 only if you assigned resources and costs to the selected resources before.)

Enhanced by Zemanta

About Andrej Dobrovoljc

Andrej Dobrovoljc

Posted on 10. December, 2010, in MS Project, Project Management and tagged , , . Bookmark the permalink. 3 Comments.

  1. Is there an easier way of formulating the budget, actual cost, and balance? Similar to Excel, without using resources?

    • You can use any custom column and insert costs directly on the task. There are columns Cost 1 – Cost 10. So, you don’t need to use resources.

  2. Your article provides verified useful to
    me. It’s really helpful and you’re clearly quite experienced in this area. You have popped our sight for you to numerous opinion of this subject along with intriguing, notable and reliable written content.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: