Excel Spreadsheet

Project Proposal Excel Template

You must be logged in to download this document
Description

Project Proposal Excel Template

Reviews
wow
Rated 10 out of 10

September 15, 2008 (1 years 1 ago)
very detailed, this will be easier to edit into exactly what I was looking for than anything else I have found

Shared by: none none
Categories
Stats
views:
2377
rating:
7.5(2)
reviews:
1
posted:
1/18/2008
language:
English
pages:
0
Definitions Definitions Metric Budget at Completion Actual Cost Abbrev. Description BAC Baseline cost for 100% of project. Total costs actually incurred so far. AC Formula/Value Earned Value Planned Value EV PV Cost Variance CV Cost Performance Index CPI Schedule Variance SV Schedule Performance Index SPI Estimate to Completion ETC Amount of budget earned so far based on physical work accomplished, without reference to actual costs. The budget for the physical work scheduled to be completed by the end of the time period. Measure of cost overrun. The difference between the budget for the work actually done so far and the Earned Value–Actual Cost actual costs so far. EV–AC Cost efficiency ratio. A CPI of 1.0 means that the costs so far are exactly the same as the budget for Earned Value/Actual Cost work actually done so far. EV/AC Measure of schedule slippage. The difference Earned Value–Planned between the budget for the work actually done so far Value and the budgeted cost of work scheduled. EV–PV Earned Value/Planned The schedule efficiency ratio. An SPI of 1.0 means Value that the project is exactly on schedule. EV/PV Estimate at Completion–Actual Cost The expected additional cost to complete the project. EAC–AC Budget at Completion/Cost Performance Index BAC/CPI (Cost Performance Index+Schedule Performance Index)/2 (CPI+SPI)/2 >1.0 >0.85 >0.65 <0.65 Estimate at Completion EAC Expected total cost based on the current cost efficiency ratio. Status Average of CPI & SPI GREEN = On track YELLOW = Slightly behind schedule or over budget RED = Needs immediate attention BLACK = Killed or Restore Page 1 of 2 Project Proposal Project Name: Department: Project Manager: Project Completion Date: Schedule and Cost Budget at Completion (BAC) Earned Value (EV) Actual Cost to Date (AC) Planned Value (PV) Estimate to Completion (ETC) Estimate at Completion (EAC) Cost Variance (CV) Schedule Variance (SV) Cost Performance Index (CPI) Schedule Performance Index (SPI) Status (Average of CPI + SPI) Planned Finish Date Actual Finish Date Milestones Milestones Milestone A: Charter sign-off Milestone B: Business requirement sign-off Milestone C: Functional spec. sign-off Milestone D: Phase gate review Scope Phase Number Phase 1 Phase 2 Phase 3 Phase 4 Phase 5 Resources Variance (Days) Status (G/Y/R) Description [Defined] [Designed] [Developed] [Tested] [Delivered] Changes at Phase End Increase or Decrease Effort Required Total effort required (hours) Issues Currently Open Number of issues Scope Changes Effort Expended Percent of Effort Estimated Effort Expended to Complete Variance Open Last Week Increase or Decrease 0 Closed Past Due Requested Approved Changes Due to Business Requirements Functional Requirements Technical Requirements 0 0 Total changes Changes Due to Approved Scope Changes (Estimate) Effect of changes (increase or decrease) Risks Risks Identified Mitigation Plans Developed Contingency Plans Developed Cost of Mitigations Top 3 Risks Risk 1: Risk 2: Risk 3: Top 3 Issues Issue 1: Issue 2: Issue 3: Comments Deferred Rejected Under Investigation 0 Cost 0 Effort (hours) 0 Schedule (days) Contingency Reserve Last Reviewed Overall Risk (G,Y,R) Submitted by: Date: Page 2 of 2

Related docs
Project Proposal Template Excel Version
Views: 316  |  Downloads: 83
Project Proposal Template
Views: 510  |  Downloads: 76
EXCEL PROPOSAL TEMPLATE
Views: 61  |  Downloads: 9
Project Proposal Template v2.0
Views: 287  |  Downloads: 70
LGI Project Proposal Template
Views: 93  |  Downloads: 4
LGI Project Proposal Template
Views: 29  |  Downloads: 2
Project Proposal
Views: 416  |  Downloads: 51
The Proposal template
Views: 1183  |  Downloads: 75
A Template for Project Proposal
Views: 2647  |  Downloads: 377
Project Tracking Excel Template
Views: 4739  |  Downloads: 567
premium docs
Other docs by none none
Year-end Tax Plan Excel Template
Views: 1087  |  Downloads: 114
Wine Collection List Excel Template
Views: 767  |  Downloads: 72
Weekly Timesheet with Tasks and OT Excel Template
Views: 2004  |  Downloads: 235
Weekly Timesheet with Breaks Excel Template
Views: 1511  |  Downloads: 191
Weekly Timesheet Excel Template
Views: 1831  |  Downloads: 196
Weekly Class Schedule Excel Template
Views: 1703  |  Downloads: 18
Manufacturing Variance Report Excel Template
Views: 700  |  Downloads: 40
Vendor Profile Excel Template
Views: 939  |  Downloads: 62
Variance Report Excel Template
Views: 455  |  Downloads: 28
Travel Service Invoice Excel Template
Views: 616  |  Downloads: 72
Training Session Schedule Excel Template
Views: 861  |  Downloads: 57
Project To Do List Excel Template
Views: 4172  |  Downloads: 365
Timeline Excel Template
Views: 2109  |  Downloads: 152