Excel Weekly Status Report Template

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 3

Project Name

BRMS Tech

Project Manager

Swapnil Wale

Date

10-Jan-15

Project Health Card

Green
Green
Amber
Red
Amber
Amber
Red
Green

Schedule
Budget
Resources
Quality
Scope
Risks
Issues
Change Mgt

Green

The project tasks are on track.


The budget is on track but some items are a concern.
The project is well resourced. Some resources have taken unplanned leaves.
There number of unresolved defects has crossed 50.
The project scope is on track. There are 2 change requests pending.
Project Risks are under control.
There are 4 high issues open.
The change management plan for the project is being drafted.
Project Schedule

No

Task

Start

Finish

Progress

Projected Date

1
2
3

Analysis
Build
Quality Assurance

14-Jan-15
30-Jan-15
25-Mar-15

30-Jan-15
20-Mar-15
30-Apr-15

100
60
50

30-Jan-15
31-Jan-15
01-Feb-15

4
5

User Acceptance Testing


Production

30-Apr-15
20-May-15

15-May-15
20-May-15

10
0

02-Feb-15
03-Feb-15

No
No

Support

20-May-15

15-Jun-15

04-Feb-15

No

Concerns
No
No
No

Project Financials
No
1
2
3
4
5

Item

Planned Spend
$450,000

Actual Spend
$500,000

Software Costs
Hardware Costs

$75,000
$50,000

$34,000
$23,000

Vendor Costs
Other Expenses

$35,000
$5,000

$36,000
$3,500

$615,000
Top 5

$596,500

Resourcing Costs

Totals
No
1
2
3
4
5

Type

Description
There is a technical risk with the project which has not been addressed.

Risk

Status

Variance

-$50,000
$41,000
$27,000
-$1,000
$1,500
$18,500
Owner
Neel

Due
12-Jan

Green
Some of the team members have taken unplanned leaves.

Issue

Wale

A key decision regadring technical architecture is pending.

Decision

Sam

23-Feb

Amber

Dependenc The project has a depedency on other project for hardware which has not been
resolved yet.
y
Change
Request

14-Jan

Red

The change requests need be approved at the earliest so that the impact on
the project is less.
Risks

Low; 2

RisksHigh; 5

Ram
Jam

High; 4

Issues

Med; 2

Med; 2

21-Jan

Green

Issues

Low; 3

26-Apr

Green

Pending Items
6
5
4
3
2
1
0

5
2

Status
Red
Green
Amber

Items
Risk
Issue
Decision
Action
Dependancy
Assumption
Change Request

High
Risks
Issues

5
4

Decisions
Actions
Changes
Dependanc

2
3
2
5

Med

Low
2
2

2
3

You might also like