Project Cumulative Cost Data
Your Corporate Name and Logo goes here
Project Name: Reporting Periods:
week 1
week 2
week 3
week
week !
<""""
#nter
Reporting
Periods
"""">
<"""" Planned $osts per Reporting Period """"> Planned P%ase $osts Initiation &1'('''
Planning
#$%000
#$%000
&'('''
#10%000
#10%000
#!0%000
#)ecution
$ontrol
$lose
Project *otal Planned $ost:
&!'('''
*ime unit o+ project:
&onths
Budgeted $ost per Reporting Period:
#$%000
#$%000
#10%000
#10%000
#!0%000
#0
#0
#0
#0
#0
$umulati,e Plan $ost:
#$%000
#10%000
#!0%000
#'0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
-ctual $ost:
#(%'00
#(%800
#11%)00
#9%000
#1"%000
$umulati,e -ctual $ost:
#(%'00
#1'%100
#!)%$00
#''%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
Page 1 of 8
Printed on: 09!1!01"
Your Corporate Name and Logo goes here
Project Cumulative Cost Data
Instructions: Before you enter any data, do the following:
* Determine the total cost of each project phase * Determine the num+er of reporting periods that each project phase ,ill last -e.g. ' months/ * Determine -or guestimate/ the dollar cost that ,ill occur during each reporting period for each phase To enter planned project values (note: all data entry cells are white):
1. nter project name in the space provided !. nter reporting periods in cells D) through ) -e.g. ,ee2s% months or 3uarters as dates -sho,n/ or month1% month!% etc./ '. nter cost of each project phase under Planned Phase Costs ). nter the phase cost planned for each eporting Period in the ,hite cells provided. -see 9. &odif7 the graph in the Cumulative Cost Curve ta+ as e6plained on that sheet .%en s%ould /ou use t%is template: * ;se this template ,hen 7ou need a Cumulative Cost Curv e and 7ou have a good idea of ho, 7our costs ,ill +e +ro2en out over the course of 7our project. 0 *%is template is use+ul +or projects t%at last etween and 2 reporting periods and w%ere dollar estimates o+ cost per reporting period are a,ailale 0 See companion document $umulati,e$ost$ur,e45ollars4Sample5ata)ls to see w%at a completed project looks like
Page ! of 8
Printed on: 09!1!01"
Your Corporate Name and Logo goes here
Project Cumulative Cost Data
week 11
week 12
week 13
week 1
week 1!
week 16
week 17
week 18
19'7
29'7
39'7
9'7
!9'7
#0
#0
#0
#0
#0
#0
#0
#0
#0
#0
#0
#0
#0
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%000
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
#$0%$00
Page ' of 8
Printed on: 09!1!01"
Your Corporate Name and Logo goes here
Project Cumulative Cost Data
69'7
#10%000
#)0%000
#0
#0
#0
#0 #$0%000
#$0%$00
Page ) of 8
Printed on: 09!1!01"
t s o $ e , i t a l u m u $
#(0%000 #$0%000 #)0%000 #'0%000 #!0%000 #10%000 #0 ,ee2 1
,ee2 !
,ee2 ' ont%s
,ee2 )
udget Cost ctual Cost
ee2 $
Raw 5ata *a Instructions: Before you enter any data, do the following: * Determine the total cost of each project phase * Determine the num+er of reporting periods that each project phase ,ill last -e.g. ' months/ * Determine -or guestimate/ the dollar cost that ,ill occur during each reporting period for each phase To enter planned project values (note: all data entry cells are white):
1. nter project name in the space provided !. nter reporting periods in cells D) through ) -e.g. ,ee2s% months or 3uarters as dates -sho,n/ or month1% month!% etc./ '. nter cost of each project phase under Planned Phase Costs ). nter the phase cost planned for each eporting Period in the ,hite cells provided. -see 9. &odif7 the graph in the Cumulative Cost Curve ta+ as e6plained on that sheet .%en s%ould /ou use t%is template: * ;se this template ,hen 7ou need a Cumulative Cost Curve and 7ou have a good idea of ho, 7our costs ,ill +e +ro2en out over the course of 7our project. 0 *%is template is use+ul +or projects t%at last etween and 2 reporting periods and w%ere dollar estimates o+ cost per reporting period are a,ailale
$umulati,e $ost $ur,e ta Initial Setup =nce 7ou have entered all of 7our Planned data in the a, Data ta+% do the follo,ing: * Clic2 once on t%e c%art to select it and then clic2 $%art on the tool+ar
* Clic2 Source 5ata and then Series * Clic2 Budgeted $ost and then in the Values +o6 change 5a, data5 to inlcude onl7 the columns in ,hich 7ou have entered planning data. ?or e6ample% if 7our project ,ill last 1! months 7ou ,ill have planned data in columns D through =% so the value for a, Data should +e @a, Data>#D#!(:#=#!( -dding -ctual $ost 5ata s 7ou add ctual Cost values% clic2 once on t%e c%art and then clic2 $%art on the tool+ar * Clic2 Source 5ata and then Series * the e6ample ,e have ctual data for ' months% so the last ctual data is in Column ?. 4he value for a, Data should +e @a, Data>#D#'0:#?#'0 Note: this chart is easil7 added to a Aord document. Bust clic2 on the chart% right cli c2 and Cop7% then Paste into the Aord document.