How do I determine Total cost by year?

[Toshi Basha]

I have been asked to write a 3 year project plan in MS Project (2003), and
also submit a request for funds for each of the years.
How do I obtain a (projected) cost for each of the years?
The sort of thing I am after is like the Report found in
View>Reports>Costs>Budget
where period has been set to 'Years'. The only thing missing for me is the
column total for 'Total Cost' (sub totals per key tasks would be good too...).

Thanks for any help.

 

[Dave]

I have been asked to write a 3 year project plan in MS Project (2003), and
also submit a request for funds for each of the years.
How do I obtain a (projected) cost for each of the years?
The sort of thing I am after is like the Report found in
View>Reports>Costs>Budget
where period has been set to 'Years'. The only thing missing for me is the
column total for 'Total Cost' (sub totals per key tasks would be good too...).

Thanks for any help.

You can see the year-on-year costs in the Task Usage view if you add the
cost row. This will also give you the breakdown by task or summary.

You can also add the Cumulative Cost row if you want to see how things
stack up over the project lifetime.

You may need to adjust the timescales at the top of the chart.

 

[Toshi Basha]

Thanks Dave for taking time to answer my query.
As I am an Amateur Project user, and it took a while for me to figure out
your direction, I thought I might add some things I've learnt (strictly for
beginners, I suspect):

Get task usage view with menu (you will need to have an open project file)-
View>Task Usage

Manipulate what you see in the right hand part of the screen (a calendar
type view) by right hand clicking on a cell in the Detail column, or a cell
in the heading row.

So for my requirement I RH clicked a detail cell and chose "Cost".
To get my year by year costs I adjusted the timescale (RH click in heading
row) to just show 'years'.

Another possibly useful addition (depending on how you have structured your
tasks) is to turn on a project summary row with
Tools>Options>Views
and tick
'Show project summary task'


Thanks.

 

[vanita]

Hi

I think the report that is reqd. by you is View > Reports > Costs > Cash
flow. You edit this report to see 'columns' in 'years'. Now for each task you
will see its cost year wise. Last col. would give you total cost of each
activity and last row would give you total cost for each year (specifically
your req.) and the last cell would give you the total project cost.

I hope it helps.

Vanita

 

[Mike Glen]

Hi Toshi,

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine at this site: http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP