PROJECT PLAN

This is a free version of the "Project Plan" spreadsheet.

To download the complete resource, join You Exec Plus,
and gain access to our entire library of spreadsheet
models and business resources and receive new ones
each week.

Start today

EXPLAINER
 Watch video

We value your input. If you have any comments,

questions, or suggestions on how to improve this
business resource please let us know.

Feedback

Errors and omissions liability (E&O): You Exec LLC makes no guarantee that the formulas, models, analysis, financial
projections, estimates, graphs, reports, numbers, and any derivatives sourcing from this model are free of errors and
omissions. Our financial modelers have audited this model to the best of their capabilities, yet You Exec LLC assumes no
liability for erroneous outcomes derived from this financial model.

Copyright © You Exec LLC. All rights reserved.

TABLE OF CONTENTS

Sheet 1 Cover

Sheet 2 Table of contents

Sheet 3 Fields

Sheet 4 Charter

Sheet 5 Tasks

Sheet 6 Triage

Sheet 7 Risk Paid

Sheet 8 Kanban Paid

Sheet 9 Agile Paid

COLOR KEY
Types Example Description
User inputs $3,400 User inputs
Calculations $3,400 Formula results
Results
Good results $3,400 Favorable outcomes
Bad results $3,400 Unfavorable outcomes
FIELDS
ABC Company's Project X (Project Leader: Lebron Jordan, Project Manager: Roger Nadal)

KANBAN

Priority Stage section Team members

High Backlog Gianluca Lapadula
Medium Research Alexander Callens
Low In Progress Lebron Jordan
No priority Q&A Michael James
Done Roger Nadal
Testing Rafael Federer

RISK

Risk likelihood Risk severity

Improbable Acceptable
Possible Tolerable
Probable Undesirable
Intolerable
TRIAGE

Urgency Importance Action impact

Urgent Important Low
Not urgent Not important High

RISK MATRIX

1 3
Acceptable Tolerable
Improbable Low Medium
Likelihood Possible Low Medium
Probable Medium High
er: Roger Nadal)

Interest / influence
High
Medium
Low
Action effort
Low
High

Severity
3 5 6
Tolerable Undesirable Intolerable
Medium Medium High
Medium High Extreme
High High Extreme
NOTES

These dropdowns define terms used in the rest of the sheet

Do not add 'Triage' dropdowns below the gray bar

Do not add 'Risk' dropdowns below the gray bar

Risk levels and colors can be edited to reflect internal classification

Do not add 'Stage' or 'Team members' dropdowns below the gray bar
CHARTER
ABC Company's Project X (Project Leader: Lebron Jordan, Project Manager: Roger Nadal)

PROJECT CHARTER

Project name ABC Company's Project X

The purpose is to build a new data center facility. It will

start with the planning and design phase, and lead to
Brief description
contractor selection, site selection, and facility
requirement estimations.
Our company is obligated to provide continuous service to
Business case its customers, and as interruptions are unavoidable, we
need to control and minimize these interrumptions.

Size requirements, organization growth estimation,

In
number of servers, racks, UPS systems
Scope
Project documents (plan, budget, risk assessment),
Out contractor selection, site selection, equipment inventory,
facility requirements, vendor communication.

The fast growth of the company has determined a

Time
maximum deadline of 1 year from the KOM

Budget $850 per gross square foot

Quality National standards at least, trend to zero interruptions

Constraints
Some members of the project team are currently working
Team
on the regular activities of the company

Other constraint
TBD
#1

Other constraint
TBD
#2
PROJECT STAKEHOLDERS

Role Contact Category Interest

+1 9876543210
Sponsor Internal High
michael@youexec.com

+1 9876543210
Project leader Internal High
lebron@youexec.com

+1 9876543210
Project manager Internal High
roger@youexec.com

+51 985289443
PMO External High
iamluischarca@gmail.com

Engineering +1 9876543210
Internal High
manager rafael@youexec.com

PROJECT BUDGET

Total cost

$8,936

Planned budget Actual cost

$5,707 $3,800
ger Nadal)

Project leader Lebron Jordan

Sponsor Michael James

Project manager Roger Nadal

Estimated budget $13,100

KPI, milestones fulfillment, the beginning of construction

Success measures works in 4 months after the KOM, adherence to project
budget and timeline

Deliverables and acceptance criteria Based on the constraints and milestones

No climatic phenomena, no corruption (internal &

Assumptions external), no changes in legal & building
parameters/frameworks, no accidents.

Milestone 1 Project documents 11/15/2024

Milestone 2 Contractor and site selection 12/15/2024

Milestones and
deadlines
Milestone 3 Civil works completion 4/15/2025

Milestone 4 End of the project 8/15/2025

 Influence Expectations Comms requirements

Timely completion of the project, and

High Video conference and email
fulfillment of growth requirements

Project to be delivered on time within

High Email and telephone
budget

Clear requirements and timely

High Email and telephone
completion of documentation

Project to be delivered on time within

High budget + Timely approvals to be Email and telephone
obtained

Compliance with national standards,

Medium Email and telephone
effective and modern design

Total cost

$8,936

Remaining budget Used

$1,907 67%
NOTES

Do not add 'Stage' or 'Team members' dropdowns below the gray bar
 TASKS
ABC Company's Project X (Project Leader: Lebron Jordan, Project Manager: Roger Nadal)

OVERALL
Task ID Task Responsible person Work progress
ss_01 A01 Determine IT parameters Gianluca Lapadula 40%
g_01 A02 Develop system concept Alexander Callens 25%
h_01 A03 Determine user requirements Lebron Jordan 20%
ss_02 B01 Generate specification Michael James 100%
A_01 B02 Generate detailed design Roger Nadal 45%
ng_01 C01 Build schedule Rafael Federer 60%
A_02 C02 Detailed estimating Lebron Jordan 100%
A_03 A04 Value engineering Gianluca Lapadula 60%
ss_03 B03 Contractor selection Alexander Callens 60%
h_02 B04 Site selection Roger Nadal 70%
ss_04 C03 Earthworks Roger Nadal 100%
ss_05 C04 Build foundations Lebron Jordan 40%
e_01 C05 Construction of vertical elements Michael James 40%
ss_06 D01 Construction of horizontal elements Rafael Federer 30%
nager: Roger Nadal)

DATES KANBAN
Progress (%) Start date Due date Finish date Stage Priority
04/13/2022 06/01/2022 05/12/2022 In Progress No priority
03/14/2022 05/31/2022 04/18/2022 Backlog Low
03/01/2022 06/02/2022 Research Low
02/21/2022 06/01/2022 In Progress Medium
03/24/2022 05/23/2022 03/29/2022 Q&A High
03/28/2022 04/04/2022 04/01/2022 Testing High
04/13/2022 04/13/2022 04/13/2022 Q&A Medium
03/29/2022 06/01/2022 Q&A Medium
04/13/2022 04/18/2022 04/18/2022 In Progress High
06/01/2022 08/31/2022 Research High
04/19/2022 06/01/2022 In Progress Low
04/27/2022 08/30/2022 In Progress Medium
03/31/2022 04/28/2022 04/30/2022 Done Low
03/31/2022 04/28/2022 04/30/2022 In Progress High
AGILE FINANCIALS
Actual
Sprint Baseline cost Planned budget Remaining budget
cost
Sprint A $1,300 $1,239 $582 $657
Sprint A $1,800 $741 $519 $222
Sprint A $1,300 $130 $92 $38
Sprint B $600 $45 $21 $24
Sprint B $800 $546 $404 $142
Sprint C $1,300 $405 $418 -$13
Sprint C $700 $439 $369 $70
Sprint D $600 $136 $83 $53
Sprint B $400 $159 $83 $76
Sprint E $800 $442 $270 $172
Sprint C $600 $335 $231 $104
Sprint C $1,300 $289 $159 $130
Sprint C $500 $439 $272 $167
Sprint D $1,100 $362 $297 $65
 RISKS
Used (%) Linear forecasted cost Risk description Likelihood
47.0% $1,455 Risk 1 Probable
70.0% $2,076 Risk 2 Probable
70.8% $460 Risk 3 Possible
46.7% $21 Risk 4 Possible
74.0% $898 Risk 5 Possible
103.2% $697 Risk 6 Improbable
84.1% $369 Risk 7 Improbable
61.0% $138 Risk 8 Possible
52.2% $138 Risk 9 Improbable
61.1% $386 Risk 10 Possible
69.0% $231 Risk 11 Improbable
55.0% $398 Risk 12 Possible
62.0% $680 Risk 13 Improbable
82.0% $990 Risk 14 Improbable
RISKS TRIAGE
Severity Risk rating key Urgency Importance Impact Effort
Intolerable Extreme Not urgent Not important High High
Acceptable Medium Not urgent Not important High High
Undesirable High Not urgent Not important Low High
Tolerable Medium Urgent Important Low Low
Undesirable High Not urgent Important Low Low
Tolerable Medium Not urgent Important Low Low
Undesirable Medium Not urgent Important High High
Intolerable Extreme Urgent Important Low Low
Intolerable High Not urgent Important High High
Tolerable Medium Urgent Not important Low Low
Acceptable Low Not urgent Important High High
Undesirable High Not urgent Not important High High
Acceptable Low Urgent Important High High
Acceptable Low Not urgent Important Low High
 OTHER NOTES
Notes
Financials should be updated in real time
Make a copy to the drive
Standards will be checked again
TRIAGE
ABC Company's Project X (Project Leader: Lebron Jordan, Project Manager: Roger Nadal)

IMPACT / EFFORT ANALYSIS

14 Low Effort
Add new rows to display all tasks Quick
Wins
High Impact

Add new rows to display all tasks Fill-Ins

Add new rows to display all tasks
Add new rows to display all tasks
Add new rows to display all tasks
Add new rows to display all tasks
Low Impact
EISENHOWER MATRIX

14 Urgent
Add new rows to display all tasks Do
Add new rows to display all tasks
Add new rows to display all tasks
Important

Add new rows to display all tasks Delegate

Not Important
anager: Roger Nadal)

High Effort
Add new rows to display all tasks Major
Add new rows to display all tasks Projects
Add new rows to display all tasks
Add new rows to display all tasks
Add new rows to display all tasks
Add new rows to display all tasks
Add new rows to display all tasks

Add new rows to display all tasks Thankless

Add new rows to display all tasks Tasks
 Not Urgent
Add new rows to display all tasks Plan
Add new rows to display all tasks
Add new rows to display all tasks
Add new rows to display all tasks
Add new rows to display all tasks
Add new rows to display all tasks

Add new rows to display all tasks Delete

Add new rows to display all tasks
Add new rows to display all tasks
Add new rows to display all tasks
NOTES
RISK
ABC Company's Project X (Project Leader: Lebron Jordan, Project Manager: Roger Nadal)

All these features are included in the complete

version of the spreadsheet. Join today and Start Today
access our entire library of business resources.

RISK ANALYSIS
 High

Medium

Low

All these features are included in the complete

version of the spreadsheet. Join today and Start Today
access our entire library of business resources.
ager: Roger Nadal)

Start Today
Start Today
NOTES
 1 1 2

KANBAN
ABC Company's Project X (Project Leader: Lebron Jordan, Project Manager: Roger Nadal)
6

All these features are included in the

complete version of the spreadsheet.
Start Today
Join today and access our entire library
of business resources.

DETAILS
WIP limit 4

Backlog (Queue) Backlog Research (Queue)

Develop system concept

Alexander Callens

Priority: Low
All these features are included in the
complete version of the spreadsheet.
Join today and access our entire library
of business resources.

All these features are included in the

complete version of the spreadsheet. Start Today
Join today and access our entire library
of business resources.
All these features are included in the
complete version of the spreadsheet. Start Today
Join today and access our entire library
of business resources.
 2 3 3

r: Roger Nadal)

ch (Queue) Research In Progress (Queue) In Progress

Determine user requirements Build foundations Determine IT parameters

Lebron Jordan Lebron Jordan Gianluca Lapadula

Priority: Low Priority: Medium Priority: No priority

Construction of horizontal
Site selection Generate specification
elements
Roger Nadal Rafael Federer Michael James

Priority: High Priority: High Priority: Medium

Contractor selection
Alexander Callens

Priority: High
Earthworks
Roger Nadal

Priority: Low
 4 4 5

Q&A (Queue) Q&A Done (Queue)

Generate detailed design

Roger Nadal

Priority: High

Detailed estimating
Lebron Jordan

Priority: Medium

Value engineering
Gianluca Lapadula

Priority: Medium
 5 6 6

Done Testing (Queue) Testing

Construction of vertical elements Build schedule

Michael James Rafael Federer

Priority: Low Priority: High

7 7 8
8 9 9
10 10

NOTES
 AGILE
ABC Company's Project X (Project Leader: Lebron Jordan, Project Manager: Roger Nadal)

All these features are included in the complete

version of the spreadsheet. Join today and Start Today
access our entire library of business resources.

GANTT CHART

Sprint Feature / Task Feature Type Responsible

### t A Sprint A
### t A Determine IT parameters Gianluca Lapadula
### t A Determine user requirements Lebron Jordan
### t A Develop system concept Alexander Callens
### t B Sprint B
### t B Contractor selection Alexander Callens
### t B Generate detailed design Roger Nadal
### t B Generate specification Michael James
### t C Sprint C
### t C Build foundations Lebron Jordan
### t C Build schedule Rafael Federer
### t C Construction of vertical elements Michael James
### t C Detailed estimating Lebron Jordan
### t C Earthworks Roger Nadal
### t D Sprint D
### t D Construction of horizontal elements Rafael Federer
### t D Value engineering Gianluca Lapadula
### t E Sprint E
### t E Site selection Roger Nadal

All these features are included in the complete

version of the spreadsheet. Join today and Start Today
access our entire library of business resources.
Roger Nadal)

Start Finish Duration (Days) Status

03/01/2022 05/12/2022 73
04/13/2022 05/12/2022 30
03/01/2022 #N/A
03/14/2022 04/18/2022 36
02/21/2022 04/18/2022 57
04/13/2022 04/18/2022 6
03/24/2022 03/29/2022 6
02/21/2022 #N/A
03/28/2022 04/30/2022 34
04/27/2022 #N/A
03/28/2022 04/01/2022 5
03/31/2022 04/30/2022 31
04/13/2022 04/13/2022 1
04/19/2022 #N/A
03/29/2022 04/30/2022 33
03/31/2022 04/30/2022 31
03/29/2022 #N/A
06/01/2022
06/01/2022 #N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
NOTES