Cumulative Cost Curve Percent Template

Tags

finance, value, cost

You must be logged in to download this document

be first to review

user002

Project Cumulative Cost Data Put your Organization Name Here 7/05 8/05 9/05 10/05 11/05 <=== Enter reporting periods here. ===> Initiation $10,000 $4,000 $6,000 $0 $0 $0 $0 40% 60% Planning $40,000 $0 $8,000 $16,000 $16,000 $0 $0 $0 $0 $0 $0 20% 40% 40% Execution $10,000,000 $0 $0 $0 $800,000 $800,000 $800,000 $800,000 $1,000,000 $1,000,000 8% 8% 8% 8% 10% 10% Control $0 Enter percent cost per unit time below Close $0 Enter % cost per unit time below Months $4,000 $6,000 $8,000 $16,000 $16,000 $800,000 $800,000 $800,000 $800,000 $1,000,000 $1,000,000 $4,000 $10,000 $18,000 $34,000 $50,000 $850,000 $1,650,000 $2,450,000 $3,250,000 $4,250,000 $5,250,000 $3,840 $5,580 $7,100 $0 $0 $0 $0 $0 $0 $0 $0 $3,840 $9,420 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 Time unit of project: Planned Phase Cost <==== Planned Cost per Reporting Period ====> Total Planned Project Cost: $10,050,000 Monthly % of cost Budgeted Cost per Reporting Period: Monthly % of cost Monthly % of cost Monthly % of cost Monthly % of cost Project Name: Reporting Periods: Actual Cost: Cumulative Plan Cost: Cumulative Actual Cost: Template: Cumulative Cost Curve -Percent [Rev 1.0 3/29/2005] Page 1 of 8 Printed on: 2/5/2008Project Cumulative Cost Data Put your Organization Name Here 8. Enter Actual Costs per reporting period as the data become available. The cumulative actual cost will display in the Before you enter any data, do the following: 9. Modify the graph in the Cumulative Cost Curve tab as explained on that sheet Instructions: 5. Enter time unit of the project. This is "Months" in the example. This is used as a label on the chart in the next tab. 6. Planned cost per reporting period display in the 'Budgeted Cost per Reporting Period" line 7. Planned Cumulative Cost displays in the "Cumulative Planned Cost" line 1. Enter project name in the space provided 2. Enter reporting periods in cells D4 through AA4 (e.g. weeks, months or quarters as dates (shown) or month1, month2, etc.) -Determine the number of reporting periods that each project phase will last (e.g. 3 months) Cumulative Actual Cost line. It is normal for the last correct cumulative cost figure to repeat through all succeeding months. Do NOT delete these numbers! Cells in column AB will be red until the total percent for the project phase equals 100%. 3. Enter cost of each project phase under Planned Phase Costs When should you use this template: -Use this template when you need a Cumulative Cost Curve and you have a good idea of how your costs will be broken out over the course of your project. -This template is useful for projects that last between 4 and 24 reporting periods and where rough estimates of cost per reporting period are adequate. -See companion document "CumulativeCostCurve_Percent_SampleData.xls" to see what a completed project looks like. 4. Enter the % of phase cost planned for each Reporting Period in the white cells provided. (see Initiation and Planning for an example of how this is done). Leave unused cells blank. Planned cost per period displays above the % you entered. -Determine the total cost of each project phase -Determine (or guestimate) the percent of cost that will occur during each reporting period for each phase To enter planned project values (note: all data entry cells are white): Template: Cumulative Cost Curve -Percent [Rev 1.0 3/29/2005] Page 2 of 8 Printed on: 2/5/2008Project Cumulative Cost Data Put your Organization Name Here 12/05 1/06 2/06 $0 $0 $0 $0 $0 $0 $0 $2,000,000 $3,200,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 20% 32% $2,000,000 $3,200,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,250,000 $10,450,000 $10,450,000 $10,450,000 $10,450,000 $10,450,000 $10,450,000 $10,450,000 $10,450,000 $10,450,000 $10,450,000 $10,450,000 $10,450,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 $16,520 Template: Cumulative Cost Curve -Percent [Rev 1.0 3/29/2005] Page 3 of 8 Printed on: 2/5/2008Project Cumulative Cost Data Put your Organization Name Here Template: Cumulative Cost Curve -Percent [Rev 1.0 3/29/2005] Page 4 of 8 Printed on: 2/5/2008For example, if your project will last 12 months you will have planned data in columns D through O, so the value for Raw Data -Click once on the chart to select it and then click Chart on the toolbar Initial Setup -Click Budgeted Cost and then in the Values box change "Raw data" to inlcude only the columns in which you have entered -Click Source Data and then Series Once you have entered all of your Planned data in the Raw Data tab, do the following: -Click Source Data and then Series -Click Actual Cost and then in the Values box change "Raw data" to inlcude the latest column in which you have Actual Cost the example we have Actual data for 3 months, so the last Actual data is in Column F. The value for Raw Data should Note: this chart is easily added to a Word document. Just click on the chart, right click and Copy, then Paste into the Word document. be ='Raw Data'!$D$26:$O$26 Adding Actual Cost Data be ='Raw Data'!$D$30:$F$30 As you add Actual Cost values, click once on the chart to select it and then click Chart on the toolbar $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 7/05 8/05 9/05 10/05 11/05 Months Cumulative Costcolumns D through O, so the value for Raw Data should the columns in which you have entered planning data. latest column in which you have Actual Cost data. In this F. The value for Raw Data should and Copy, then Paste into the Word document. below> 11/05 Budget Cost Actual CostInstructions: Before you enter any data, do the following: -Determine the total cost of each project phase -Determine the number of reporting periods that each project phase will last (e.g. 3 months) -Determine (or guestimate) the percent of cost that will occur during each reporting period for each phase To enter planned project values (note: all data entry cells are white): 1. Enter project name in the space provided 2. Enter reporting periods in cells D4 through AA4 (e.g. weeks, months or quarters as dates (shown) or month1, month2, etc.) 3. Enter cost of each project phase under Planned Phase Costs 4. Enter the % of phase cost planned for each Reporting Period in the white cells provided. (see Initiation and Planning for an of how this is done). Leave unused cells blank. Planned cost per period displays above the % you entered. Cells in column AB will be red until the total percent for the project phase equals 100%. 5. Enter time unit of the project. This is "Months" in the example. This is used as a label on the chart in the next tab. 6. Planned cost per reporting period display in the 'Budgeted Cost per Reporting Period" line 7. Planned Cumulative Cost displays in the "Cumulative Planned Cost" line 8. Enter Actual Costs per reporting period as the data become available. The cumulative actual cost will display in the Cumulative Actual Cost line. It is normal for the last correct cumulative cost figure to repeat through all succeeding months. NOT delete these numbers! 9. Modify the graph in the Cumulative Cost Curve tab as explained on that sheet When should you use this template: -Use this template when you need a Cumulative Cost Curve and you have a good idea of how your costs will be broken out over the course of your project. -This template is useful for projects that last between 4 and 24 reporting periods and where rough estimates of cost reporting period are adequate. -See companion document "CumulativeCostCurve_Percent_SampleData.xls" to see what a completed project looks Initial Setup Once you have entered all of your Planned data in the Raw Data tab, do the following: -Click once on the chart to select it and then click Chart on the toolbar Adding Actual Cost Data As you add Actual Cost values, click once on the chart to select it and then click Chart on the toolbar -Click Source Data and then Series -Click Source Data and then Series -Click Budgeted Cost and then in the Values box change "Raw data" to inlcude only the columns in which you have entered For example, if your project will last 12 months you will have planned data in columns D through O, so the value for Raw Data be ='Raw Data'!$D$26:$O$26 Template source: http://www.cvr-it.com Note: this chart is easily added to a Word document. Just click on the chart, right click and Copy, then Paste into the Word document. Raw Data Tab Cumulative Cost Curve tab -Click Actual Cost and then in the Values box change "Raw data" to inlcude the latest column in which you have Actual Cost the example we have Actual data for 3 months, so the last Actual data is in Column F. The value for Raw Data should be ='Raw Data'!$D$30:$F$30period for each phase dates (shown) or month1, month2, etc.) provided. (see Initiation and Planning for an example the % you entered. on the chart in the next tab. actual cost will display in the repeat through all succeeding months. Do of how your costs will be broken and where rough estimates of cost per see what a completed project looks like. the columns in which you have entered planning data. columns D through O, so the value for Raw Data should and Copy, then Paste into the Word document. latest column in which you have Actual Cost data. In this F. The value for Raw Data should

Public Domain

downloads:13

rating:not rated

reviews:0

posted:2/5/2008

language:English

Cumulative Cost Curve Percent Template

Cumulative Cost Curve Dollars Template

Cumulative Cost Curve Percent Sample Data

Cumulative Cost Curve Dollars Sample Data

Cost Benefits Analysis_CBA_ Template

Cost Benefit Analysis Template[2]

Costing Template

Cost - Benefit Analysis

Cost Benefit Analysis Form

Cost Benefit Analysis

Cost Estimate Table

Cost Model User Guide

Value Analysis - Cost Justifcation Spreadsheet

PRICING CORN SILAGE

Corn Silage Harvesting Costs Example

Investment Concept Brief

meeting the digital challenge

Introduction to Data Mining

Information Management Framework

Information Management Framework metadata

Information Management Framework Data Quality

Information Management Classification Guideline

Information Management - Privacy and Personal Information Protection Guideline

Information Architecture

How to measure success

HelloPartner Data Model