0% found this document useful (0 votes)
11 views40 pages

CR6 Template for Small Projects Excel

The document outlines a project communication plan detailing the update frequency for various templates, communication types, and stakeholder engagement strategies. It includes a skills spreadsheet, RACI assignments, and a project plan with specific tasks, owners, and timelines. Additionally, it highlights the status of various project activities and associated risks or issues.

Uploaded by

rahul.frnds1448
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
11 views40 pages

CR6 Template for Small Projects Excel

The document outlines a project communication plan detailing the update frequency for various templates, communication types, and stakeholder engagement strategies. It includes a skills spreadsheet, RACI assignments, and a project plan with specific tasks, owners, and timelines. Additionally, it highlights the status of various project activities and associated risks or issues.

Uploaded by

rahul.frnds1448
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

# Template Name Update Frequency

RESOURCES 1 time and update less


STAKEHOLDERS 1 time and update less
COMM. MATRIX 1 time and update less
PROJECT PLAN WEEKLY updates
BUDGET WEEKLY updates
TIMESHEET WEEKLY or MONTHLY updates
ISSUE LOG WEEKLY MEETING updates
CHANGE LOG WEEKLY MEETING updates
RISK LOG 1 time and update less
PROBLEM SOLVING
CLOSURE 1 time and update less

email us: sales@[Link]


25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses
ALMN2023
[Link]
email us: sales@[Link]
25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses

ALMN2023
[Link]
PROJECT COMMUNICATION PLAN /
Type Name Time
Meeting Weekly Status Meeting weekly
Report Weekly Status Report weekly
Meeting Steering Committee Meeting monthly
Meeting Daily Standup daily
Report Actual Costs Report monthly
Report Timesheet Report monthly
Report Quality Test Report weekly
Meeting Change Control Meeting bi-weekly
T COMMUNICATION PLAN / MATRIX
Who responsible? Who join? Where
PM PT Empire Building
PM All stakeholders and PT email
PM Key stakeholders Pegasus Building C
Team Lead PT Office Rooftop
Finance C&P PM email
HR staff PM email
Quality Manager PMT sharepoint
PM CCB Pegasus Building C

PT: Project Team


PMT: Project Management Team
PM: Project Manager
CCB: Change Control Board Members
C&P: Cost&Progress
SKILLS SPREADSHEET MemberMember2Member3
Capalities/Skills
Project Management Skills 2 2 3
Healthy & Safety Skills 0 0 0
CSA Skills 3 3 2
MEP Skills 3 3 3
Contract Man. Skills 2 2 2

Accounting Skills 2 2 3

Java skills Level 0 0 0

SAP Skill level 1 3 1


English Level 3 3 3
CSA: Civil, Structural & Architectural

MEP: mechanical, electrical and plumbing

ASSIGNMENTS-RACI MemberMember2Member3
Activity-1
Activity-2
Activity-3 R A C
Activity-4
Activity-5 R
Activity-6
Activity-7
Activity-8 R A
Member4Member5Member6Member7Member8Member9Member10
0 0
2 2 3 1 3
0 0 2 3 3 0
1 3 0 1 3 3
3 3 3 2 3 3
2 2 2 0 2
3 2 0 3 0 0 0

0 0 0 1 3 3
3 1 3 3 3
3 3 3

Member4Member5Member6Member7Member8Member9Member10

R A C I
I
R A C I
A C I

R A C I
C I
mber10 Capability Level
0: no capable
1:Basic Skills
2:Intermediate skills
3: Advanced Skills

email us: sales@[Link]


25% Discount Code PMP,CAPM, PgMP, ACP PM
ALMN2023
[Link]

mber10 RACI
R: Responsible to execute task
A: Accountable for the task, only 1 person
C: Consulted & Support for the task
I: Reported for the task status
, PgMP, ACP PMI Courses
1. Stakeholder Register PERSONAL DETAILS
2. Stakeholders Engagement Plan Name Position
Alba Customer PM
Yamini Resource Manager
Vladimir Putin Partner GM
Joe Biden Customer CEO
Angelina Jolie Customer Director

STAKEHOLDER ENGAGE
STAKEHOLDER ENGAGEMENT A
Unaware
Vladimir Putin
Joe Biden X
Angelina Jolie

STRATEGIES/ACTIONS:
NEED TO COLLECT HIS/HER requirements
Need to learn HIS/HER communication type
Need to meet 1 a week with HIS/HER
Better to make team building event with HIS/HER
Meet HIS/HER every Wednesday
Having lunch or Dinner with HIS/HER
KEY STAKEHOLDERs REGISTER
PERSONAL DETAILS STAKEHOLDER ANALYSIS
Type/Category Email Phone Power Interest Expactation / Needs
External Low High ?
Internal Medium High ?
External High Low ?
External High Low ?
External High Low ?

STAKEHOLDER ENGAGEMENT PLAN


AKEHOLDER ENGAGEMENT ASSESSMENT MATRIX
Resistant Neutral Supportive Leading
X

unication type

event with HIS/HER


ANALYSIS
Communication
?
?
? Email or meeting or phone
? Email or meeting or phone
? Email or meeting or phone

email us: sales@[Link]


25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses

ALMN2023
[Link]
Req No Cat.
REQ-01 Technical
REQ-02 Commercial
REQ-03 Regulatory
REQ-04 Operation
REQ-05 Technical
REQ-06 Commercial
REQ-07 Regulatory
REQ-08 Operation
REQ-09 Technical
REQ-10 Commercial

email us: sales@[Link]


25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses

ALMN2023
[Link]
Description Business Priority
Resdential Complex for 5000 people High
Parking complex for 2500 Cars Medium
Ceiling Plastered with a ratio C.M 1:3 mix and 10mm thick Low
1.5:10 Ratio of P.C.C is mixed for foundation and 40 mm for metal. High
1:2: 4 Ratio of R.C.C is mixed for Beam, Loft, sunshade, roof which is used for steel. Medium
DUMMY CONCRETE is mixed in ratio 1:3:6 Low
Steel rods & mild steel are used for Centering & Scaffolding Work High
Reinforcement Work Medium
In foundation with chamber bricks the Brick work in done in the ratio 1:5 c.m. Low
For building Superstructure with Chamber Brick the ratio of 1:5 c.m ratio of Brick work done. High

les@[Link]
nt Code PMP,CAPM, PgMP, ACP PMI Courses

me/66625312951
Status Business Needs? Requestor Department WBS ID Testcase ID Testcase Status
Cancelled Sales 5.1 TC101, TC201
Active IT 5.2 TC101, TC202
Active Logistics 5.3 TC109, TC203
Active Sales 5.4 TC121, TC204
Active IT 5.5 TC301, TC205
Active Logistics 5.6 TC191, TC206
Active Sales 5.7 TC101, TC207
Active IT 5.8 TC107, TC208
Active Logistics 5.9 TC201, TC209
Active Sales 6 TC611, TC210
Project Plan and Dashbard by Coach Serkan
Kaya, Navesse. Edit Blue colors with your project
team. This template can be used small projects PROJECT DASHBOARD V2.3
which have less than 100 tasks. For the big
projects, MS Project Pro is recommended to see Start Finish Duration1
Duration2
critical path, network diagram and EVM metrics.
This tool not integrated with your HR timesheet
tools and company financial tools to see all project 24/10/Mon 18/08/Fri 211 298
costs and status. This tool helps you to control
project schedule and progress.

No. Work Packages/Activities Owner Start Finish Duration Progress


1 Project Initiation 24-Oct-22 19-Feb-23
1.1 Business Case Serkan 24-Oct-22 25-Nov-22 32 100%
1.2 Funding Approval Serkan 25-Nov-22 10-Dec-22 15 100%
1.3 Plan Key Resources Serkan 10-Dec-22 20-Dec-22 10 80%
1.4 Plan Draft Schedule Serkan 22-Dec-22 28-Dec-22 6 100%
1.5 Arrange Kick off Meeting Serkan 31-Dec-22 19-Feb-23 50 90%
2 Collect Requirements - Analysis 19-Feb-23 31-Mar-23
2.1 Business Requirement Specification Besim 19-Feb-23 24-Feb-23 5 65%
2.2 Functional Requirement Specification Besim 24-Feb-23 2-Mar-23 6 90%
2.3 Technical Requirement Specification Besim 2-Mar-23 8-Mar-23 6 45%
2.4 Requirement Walkthrough Besim 8-Mar-23 15-Mar-23 7 25%
2.5 Requirements Sign Off Besim 15-Mar-23 21-Mar-23 6 35%
2.6 Baseline the project Besim 21-Mar-23 31-Mar-23 10 100%
3 Design 21-Mar-23 12-Apr-23
3.1 High Level Design Seinn 21-Mar-23 23-Mar-23 2 5%
3.2 Detailed Design Seinn 23-Mar-23 28-Mar-23 5 23%
3.3 Design Walkthrough Seinn 1-Apr-23 7-Apr-23 6
3.4 Design Sign Off Seinn 7-Apr-23 12-Apr-23 5
4 Development 11-Apr-23 26-Apr-23
4.1 Build Component 1 Thazin 11-Apr-23 16-Apr-23 5
4.2 Unit Testing Component 1 Thazin 20-Apr-23 23-Apr-23 3
4.3 Build Component 2 Thazin 11-Apr-23 16-Apr-23 5
4.4 Unit Testing Component 2 Ko Ko 20-Apr-23 22-Apr-23 2
4.5 Integration Testing Ko Ko 25-Apr-23 26-Apr-23 1
5 Quality Assurance - Testing 26-Apr-23 21-Jun-23
5.1 Create Test Plan Lita 26-Apr-23 4-May-23 8
5.2 Create Test Cases Lita/Yamin 10-May-23 12-May-23 2
5.3 Execute Test Case Round - 1 Lita/Yamin 11-May-23 16-May-23 5
5.4 Record Defects Round - 1 Lita/Yamin 16-May-23 22-May-23 6
5.5 Fix Defects Lita/Yamin 2-Jun-23 6-Jun-23 4
5.6 Execute Test Case Round - 2 Lita/Yamin 10-Jun-23 11-Jun-23 1
5.7 Record Defects Round - 2 Lita/Yamin 16-Jun-23 21-Jun-23 5
5.8 Draft Testing Report Lita/Yamin 19-Jun-23 20-Jun-23 1
6 Customer User Acceptance 21-Jun-23 26-Jul-23
6.1 Draft UAT Test Cases Dalvir 21-Jun-23 24-Jun-23 3
6.2 Perform UAT - Round 1 Dalvir 24-Jun-23 4-Jul-23 10 90%
6.3 Record Defects Dalvir 1-Jul-23 8-Jul-23 7
6.4 Fix Defects Arun 10-Jul-23 15-Jul-23 5
6.5 Perform UAT - Round 2 Kumar 16-Jul-23 26-Jul-23 10
6.6 Provisional Acceptance Certificate Kumar 16-Jul-23 17-Jul-23 1
7 Deployment 25-Jul-23 3-Aug-23
7.1 Draft deployment plan Yamin 25-Jul-23 29-Jul-23 4
7.2 Dry Run deployment Yamin 28-Jul-23 1-Aug-23 4
7.3 Fix Dry Run Observations Lita/Yamin 29-Jul-23 1-Aug-23 3
7.4 Implement Production Lita/Yamin 1-Aug-23 3-Aug-23 2
8 Go Live & Closure 3-Aug-23 18-Aug-23
8.1 Final Acceptance Certificate Jeab 3-Aug-23 7-Aug-23 4
8.2 Handover Checklist Jeab 7-Aug-23 11-Aug-23 4
8.3 Babysitting Monitoring Operation 11-Aug-23 14-Aug-23 3
8.4 Archive documents All 14-Aug-23 16-Aug-23 2
8.5 Financial Closures Finance 17-Aug-23 18-Aug-23 1
total 282

DATA

Holidays
14-Feb-23 14/02/Tue
20-Mar-23 Monday
22-Apr Sat
1-Jul Saturday
17-Jul Monday
2-Aug Wednesday

Status
Not Started
In Progress
Delayed
Complete

EDIT WITH TEAM


AUTO CALC.
OARD V2.3 email us: sales@[Link]

Completion25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses

50.16%
ALMN2023
[Link]

Status Risks/Issues Comments

😃COMPLETED
😃COMPLETED Funding approved.
😡!!!--Delayed--!!!
😃COMPLETED
😡!!!--Delayed--!!! Some concerns raised about the scope

😡!!!--Delayed--!!! Delay in customer input. Reminder sent to SME.


😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!! Last minute changes. Can delay the entire project.
😃COMPLETED Last minute changes. Can delay the entire project.

😡!!!--Delayed--!!! Unplanned leaves.


😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!

😡!!!--Delayed--!!!
😡!!!--Delayed--!!! Customer resources not known
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!

😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!

😡!!!--Delayed--!!!
😡!!!--Delayed--!!! customer resoiurces now known
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!! customer resoiurces now known
😡!!!--Delayed--!!!

😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!

😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
😡!!!--Delayed--!!! extra dedicated resource maybe hired
😡!!!--Delayed--!!!
😡!!!--Delayed--!!!
13-Feb

20-Feb

27-Feb
16-Jan

23-Jan

30-Jan
Resource Type Rate Days Tasks Cost

6-Feb
2-Jan

9-Jan
Team Member-1 PM $700 74 0 $51,800 5 5 5 5 5 5 5 1 1
Team Member-2 Supp. Eng $250 82 0 $20,500 1 5 5 2 5 5 5 5 5
Team Member-3 Tester $550 66 0 $36,300 2 5 1 1 5 5 5 2 5
Team Member-4 BA $400 79 0 $31,600 3 3 4 5 5 5 5 5 5
Team Member-5 BA $300 78 0 $23,400 5 5 4 5 5 5 5 5 5
Team Member-6 Finance $250 75 0 $18,750 5 5 5 1 5 5 5 5 5
Team Member-7 Developer $700 76 0 $53,200 5 5 0 5 5 3 5 4 2

email us: sales@[Link]


25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses

ALMN2023
[Link]
5
3
2
5
1
5
2
6-Mar

5
5
5
5
4
5
2
13-Mar

5
5
3
5
4
5
3 20-Mar

5
2
5
5
1
4
5

27-Mar

4
1
1
5
5
5
5

3-Apr

5
5
5
2
5
5
5

10-Apr

3
3
3
2
5
5
5

5 17-Apr
5
5
5
5
5
5

24-Apr
5
5
5
5
5
5
5

1-May

8-May

15-May

22-May

29-May

5-Jun

12-Jun

19-Jun

26-Jun

3-Jul

10-Jul

17-Jul

24-Jul

31-Jul

7-Aug

14-Aug
21-Aug

28-Aug

4-Sep

11-Sep

18-Sep

25-Sep

2-Oct

9-Oct

16-Oct

23-Oct
Resource Costs
Item Estimated Actual
Resourcing Costs $750,000 $235,550
Consulting Costs $50,000 $35,000
Training Costs $25,000 $1,500

Total Cost $825,000 $272,050

email us: sales@[Link]


25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses

ALMN2023
[Link]
Software and Hardware Costs
Item Estimated Actual
Hardware Costs $12,000 $0
Server Licensing Costs $57,000 $0
Professional Service Fees $25,000 $200
Server Cost $4,000 $1,000
Labor Cost $2,000 $1,500
Testing Tool Licensing Cost $5,000 $0
Developer Tool Cost $4,000 $2,000

Total Cost $109,000 $4,700


Other Costs
Item Estimated Actual
Website Design $5,000 $2,000
Logo Design $1,000 $0
Marketing Plan $500 $200
Conference Room Hire $1,200 $1,000
Travel costs $6,000 $1,000
Team building $2,000 $1,000
Rewards $2,000 $1,000

Total Cost $17,700 $6,200


Risk Risk Details RISK OWNER

Rising material
News story about possible inflation
prices

Good weather Good weather during outside construction

Bad weather Rain during basement construction

Vandalism Theft at construction site

email us: sales@[Link]


25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses

ALMN2023
[Link]
Risk Register
Root Cause Trigger Probability Impact

War Rumor 4 3

Weather Good forecast 5 2

Weather Bad forecast 5 5

No security Lack of security; vandalism in the neighborhood 5 4


Risk Score Risk Strategy Actions

Risks Levels
12
Very High 5

High 4
10
Medium 3

Low 2
25
Very Low 1

20
# Issue Description Owner Priority Due Date Delayed

0001 Defect-1 John Urgent 12/12/2022 -973

0002 Delay in airplane Mary High 4/12/2023 -852

0003 New staff required Harry Medium 1/12/2023 -942

0004 Additional scope added by customer Drogba Low 3/13/2023 -882

0005 issue-5 John High 2/14/2023 -909

0006 issue-6 Mary Medium 2/15/2023 -908


0007 issue-7 Harry Low 1/16/2023 -938
0008 issue-8 Drogba High 1/17/2023 -937
0009 issue-9 John Medium 1/31/2023 -923
0010 issue-10 Mary Low 4/19/2023 -845
0011 issue-11 John
0012 issue-12 Mary
0013 issue-13 Harry
0014 issue-14 Drogba
0015 issue-15 John
0016 issue-16 Mary
0017 issue-17 Harry
0018 issue-18 Drogba
0019 issue-19 John
0020 issue-20 Mary
0021 issue-21 John
0022 issue-22 Mary
0023 issue-23 Harry
0024 issue-24 Drogba
0025 issue-25 John
0026 issue-26 Mary
0027 issue-27 Harry
0028 issue-28 Drogba
0029 issue-29 John
0030 issue-30 Mary
0031 issue-31 John
0032 issue-32 Mary
0033 issue-33 Harry
STATUS Comments
Count of # Delayed
In Progress Priority -942
Solved High
Waiting Low
Not Started Medium 1
In Progress Urgent
Solved Total Result 1
Waiting
Not Started
In Progress
Solved

email us: sales@[Link]


25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses

ALMN2023
[Link]
-938 -937 -923 -909 -908 -882 -852 -845 -46
1 1 1
1 1 1
1 1
1
1 1 1 1 1 1 1 1 1

APM, PgMP, ACP PMI Courses


Total Result
3
3
3
1
10
# Change Description Requester Biz. Priority Date Raised STATUS

0001 New component John Urgent 12/12/2022 Wating CA Decision

0002 UI Design Contract Mary High 4/12/2023 Approved

0003 New staff required Harry Medium 1/12/2023 Approved

0004 Additional scope added by customer Drogba Low 1/13/2023 Rejected


0005 CR5 John High 1/14/2023 On Hold
0006 CR6 Mary Medium 1/15/2023 Implemented
0007 CR7 Harry Low 1/16/2023 Approved
0008 CR8 Drogba High 1/17/2023 Rejected
0009 CR9 John Medium 1/18/2023 Pending
0010 CR10 Mary Low 1/19/2023 Impact Analysis
Cost Impact Time Impact Comments
Count of #
Schedule & budget
5000$ 10d impact STATUS
1000$ 5d Budget Impact . Approved
Schedule impact of 1
no 1mo week. Impact Analysis
no no Dev effort of 1 day. Implemented
no On Hold
Pending
Rejected
Wating CA Decision
Total Result

email us: sales@[Link]


25% Discount Code PMP,CAPM, PgMP, ACP PMI Course

ALMN2023
[Link]
Biz. Priority

High Low Medium Urgent Total Result


1 1 1 3

1 1
1 1
1 1
1 1
1 1 2
1 1
3 3 3 1 10

s@[Link]
Code PMP,CAPM, PgMP, ACP PMI Courses

me/66625312951
email us: sales@[Link]
25% Discount Code PMP,CAPM, PgMP, ACP PMI Courses

ALMN2023
[Link]

DEFINE YOUR PROBLEM


Problem
RCA- ROOT CAUSE ANALYSIS - FISHBONE
DEFINE POSSIBLE REASONS CAUSED THAT PROBLEM
cause1
cause2
cause3
cause4
cause5
cause6
cause7
cause8
cause9
cause10
cause11
cause12
cause13
This chart isn't available in your version of Excel.
VOTE THEM
Editing this shape or saving this workbook into a different file
cause1 20 18% Solve this
cause2 7 6%
cause3 13 11% Solve this
cause4 1 1%
cause5 9 8%
cause6 10 9% Solve this
cause7 3 3%
cause8 33 29% Solve this
cause9 10 9% Solve this
cause10 1 1%
cause11 2 2%
cause12 4 4% Solve these
cause13 1 1%
Total 114
on of Excel.

book into a different file format will permanently break the chart.

80% Line
X

Solve these
# Closure Activities
1 Handover is complete for all deliverables
All deliverables are accepted and signed off by the
2
client
3 Final project status reports are complete
4 All financial processes and reports are complete
5 Project review is done
6 Staff performance evaluations and reports completed
Staff employment on project terminated (no more work
7
is done on the project)
8 All supply contracts and processes are terminated
Site operations and facilities used for project closed
9
down
10 Disposal of all equipment and materials is done
Communication: Announcement of completion of
11
project (internal, external and public relations contacts)
12 Completion of storage for all the project files
13 User System Access Granted
14 Punchlist agreed with customer and operations
Owner Due Date Status email us: sales@[Link]
PT & PM 10-Jul-23 Done 25% Discount Code PMP,CAP
Customer 11-Jul-23 In Process ALMN2023
PM or PMO 12-Jul-23 In Process [Link]
Finance 13-Jul-23 Not Started
PM 14-Jul-23 Not Started
Team Leads 15-Jul-23 Not Started

COO 16-Jul-23 In Process

Procurement 17-Jul-23 In Process

COO 18-Jul-23 In Process

PT 19-Jul-23 Not Started

PM 20-Jul-23 Not Started

PMO 21-Jul-23 Not Started


PT 22-Jul-23 Not Started
PM 23-Jul-23 Not Started
sales@[Link]
ount Code PMP,CAPM, PgMP, ACP PMI Courses

[Link]/66625312951

You might also like