Adding VAT Column

[MP]

I would like to add a column that automatically calculates the VAT in the
total cost. For example costs of goods is £7,600 and the VAT (based on 17.5%)
is £1,330 and the total cost inc vat is £8,930.

Instead of manually working out the vat, I need MS Project to automatically
do this, so it shows 3 columns, base costs, vat costs and total costs.

I take it I will require a formulae that adds the 17.5%

I am using MS Project 2003.

Could someone advise me how I can do this?

 

[John]

I would like to add a column that automatically calculates the VAT in the
total cost. For example costs of goods is £7,600 and the VAT (based on 17.5%)
is £1,330 and the total cost inc vat is £8,930.

Instead of manually working out the vat, I need MS Project to automatically
do this, so it shows 3 columns, base costs, vat costs and total costs.

I take it I will require a formulae that adds the 17.5%

I am using MS Project 2003.

Could someone advise me how I can do this?

MP,
The formula is pretty straightforward. Since you are working with cost,
first select a spare cost field (e.g. Cost1) for customizing with a
formula. However, be advised that if you select a spare cost field in a
task view, you will NOT see that same cost field in a resource or
combination view (e.g. Resource Sheet or Resource Usage). More more
information go to our MVP website at,
http://www.mvps.org/project/faqs.htm, and take a look at FAQ 51: Data
Types: Task, Resource and Assignment.

Once you have selected the spare field, go to Tools/Customize Fields and
then hit the "formula" button. Type the following:
Cost1 = [cost]*1.175
Note: the "Cost1 =" already appears so don't type it again

To create your total cost column, create a second customized field with
the following formula:
Costx = [cost]+[cost1]

That's it. Your VAT, as you call it, and total cost will appear in the
customized cost fields when they are added as columns in a task view.
You might also want to select the option to use the same formula for
summary and group lines. To do that, select that option before you exit
the Customize Fields window.

Hope this helps.
John
Project MVP

 

[JulieS]

Hello MP,

The default Cost column should contain your resource loaded costs
(labor resources + material resources assigned + any fixed costs). In
addition Project has several custom cost fields you could use to
calculate the other values as needed. Insert two of the custom cost
fields (Cost1 and Cost 2 for example) through Insert > Column.

Click the Cost1 field, right click to show the shortcut menu and
choose customize. Click the Formula button and enter the formula:

[Cost] * 17.5%

to calculate the VAT. You can also click the Rename button to rename
the Cost1 field to VAT

Customize the Cost2 field with the formula:
[Cost1]+ [Cost]

to calculate the total costs.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[John]

I would like to add a column that automatically calculates the VAT in the
total cost. For example costs of goods is £7,600 and the VAT (based on
17.5%)
is £1,330 and the total cost inc vat is £8,930.

Instead of manually working out the vat, I need MS Project to automatically
do this, so it shows 3 columns, base costs, vat costs and total costs.

I take it I will require a formulae that adds the 17.5%

I am using MS Project 2003.

Could someone advise me how I can do this?

MP,
The formula is pretty straightforward. Since you are working with cost,
first select a spare cost field (e.g. Cost1) for customizing with a
formula. However, be advised that if you select a spare cost field in a
task view, you will NOT see that same cost field in a resource or
combination view (e.g. Resource Sheet or Resource Usage). More more
information go to our MVP website at,
http://www.mvps.org/project/faqs.htm, and take a look at FAQ 51: Data
Types: Task, Resource and Assignment.

Once you have selected the spare field, go to Tools/Customize Fields and
then hit the "formula" button. Type the following:
Cost1 = [cost]*1.175
Note: the "Cost1 =" already appears so don't type it again

To create your total cost column, create a second customized field with
the following formula:
Costx = [cost]+[cost1]

That's it. Your VAT, as you call it, and total cost will appear in the
customized cost fields when they are added as columns in a task view.
You might also want to select the option to use the same formula for
summary and group lines. To do that, select that option before you exit
the Customize Fields window.

Hope this helps.
John
Project MVP

MP,
Sorry I made an error in my first formula. Julie got it right in her
response. The formula I gave will provide the total cost.

John
Project MVP

 

[MP]

Julie,


I tried adding the formulae [Cost] * 17.5% but it creates a error sign
"syntax error or contains a reference to a unrecognisable field or function
name.

I created two Cost colums as you said and tried to add the formulae in Cost
1 field

 

[JulieS]

Hello MP,

Sorry, change the formula to:

[Cost]*.175

The field doesn't seem to like the % sign.

Julie

Julie,


I tried adding the formulae [Cost] * 17.5% but it creates a error
sign
"syntax error or contains a reference to a unrecognisable field or
function
name.

I created two Cost colums as you said and tried to add the formulae
in Cost
1 field

--
MP

I would like to add a column that automatically calculates the VAT
in the
total cost. For example costs of goods is £7,600 and the VAT (based
on 17.5%)
is £1,330 and the total cost inc vat is £8,930.

Instead of manually working out the vat, I need MS Project to
automatically
do this, so it shows 3 columns, base costs, vat costs and total
costs.

I take it I will require a formulae that adds the 17.5%

I am using MS Project 2003.

Could someone advise me how I can do this?