Business Management

profilemcbvic
individual_update_3.xlsx
Home>Business & Finance homework help>Management homework help>Business Management

WBS

WBS/Responsibility Matrix
Proj ERROR:#REF!
PM: ERROR:#REF!
Responsbilty
ID Task Name Dur PM Customer Sponsor Plumber Electrician Contractor DELIVERABLE
A Demo: Remove tub, toilet, vanitysink, shower tile and fixtures 2 A C
B Paint 2 I A
C Install new tub, toilet, vanity/sink 3 A R
D Install fixtures and GFIs 1 A
E Re-tile shower 2 A C
F Lay new flooring 3 R A C
G Walk-through and punch-list creation with customer 1 A
H Address all punch-list items 2 R A
I Turnover bathroom to customer 1 A
R = Responsible, A = Accountable, C = Consult, I = Inform

&8Spring 2010 &8OLS371 &8Clingerman, Kauffman, Spoonmore

Budget

Budget Baseline
Proj ERROR:#REF!
PM: ERROR:#REF! Date
ID Task Name PM Customer Contractor Plumber Electrician Mats
$15 $10 $50 $50 $50 0 Total
A Demo: Remove tub, toilet, vanitysink, shower tile and fixtures 12 8 4 $460
B Paint 12 $45 $165
C Install new tub, toilet, vanity/sink 12 10 8 4 $1,250 $2,130
D Install fixtures and GFIs 2 12 $420 $1,050
E Re-tile shower 12 8 $285 $545
F Lay new flooring 20 4 $875 $1,275
G Walk-through and punch-list creation with customer 1 1 $25
H Address all punch-list items 4 2 2 $180
I Turnover bathroom to customer 1 1 $25
0 0 $0
0 0 $0
0 0 $0
0 0 $0
0 0 $0
0 0 $0
0 0 $0
0 0 $0
0 0 $0
0 0 $0
0 0 $0
Total $ 5,855.00

&8Spring 2010 &8OLS371 &8Clingerman, Kauffman, Spoonmore

Schedule

Baseline Schedule
Proj ERROR:#REF!
PM: ERROR:#REF!
WBS Plan Dates
ID Task Name Duration Start Date Finish Date
A Demo: Remove tub, toilet, vanitysink, shower tile and fixtures 2 1/15 1/16
B Paint 2 1/17 1/18
C Install new tub, toilet, vanity/sink 3 1/21 1/23
D Install fixtures and GFIs 1 1/21 1/21
E Re-tile shower 2 1/17 1/18
F Lay new flooring 3 1/24 1/28
G Walk-through and punch-list creation with customer 1 1/29 1/29
H Address all punch-list items 2 1/30 1/31
I Turnover bathroom to customer 1 2/1 2/1
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0

&8Spring 2010 &8OLS371 &8Clingerman, Kauffman, Spoonmore

Update 1

Update Cycle #1
Proj Bath remodel Data Date: Day 20 Month 1 page 1 of 2
PM: Date: 1/20/16
PLAN Actual
ID Task Name Start Date Finish Date Budgeted Amount PV Start Finish EV PM Customer Contractor Plumber Electrician Mats Total
$15 $10 $50 $50 $50 Cost (AC)
A Demo: Remove tub, toilet, vanitysink, shower tile and fixtures 1/15 1/16 $460 $460 1/11/16 1/14/16 $460 10 10 $250
B Mold Removal 1/15 1/22 $750 $375 1/15/16 $375 1 $15
C Paint 1/17 1/18 $165 $165 $0
D Install new tub, toilet, vanity/sink 1/21 1/23 $2,130 $0
E Install fixtures and GFIs 1/21 1/21 $1,050 $0
F Re-tile shower 1/17 1/18 $545 $545 $0
G Lay new flooring 1/24 1/28 $1,275 $0
H Walk-through and punch-list creation with customer 1/29 1/29 $25 $0
I Address all punch-list items 1/30 1/31 $180 $0
J Turnover bathroom to customer 2/1 2/1 $25 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
$0
PV= $1,545 EV = $835 AC = $265
Update Cycle #1 Analysis and Recommendations
Proj ERROR:#REF! Data Date: Day 20 Month 1 page 2 of 2
PM: Key Date: 1/20/16
Planned BAC = 5855
Earned Value Values Indication Significance Recommendations
2 Schedule Variances
SV = EV-PV -$710 Yes
SPI=EV/PV 0.54 Good
1 Cost Variances
CV = EV-AC $570
CPI=EV/AC 3.15
3 Quality Variances
Project Variance
EAC = BAC/CPI 1858.17
PC = EV/BAC 0.1426131512
Lessons Learned
Overall Recommendation
Index Graph Up Cyc 1 Up Cyc 2
SPI 0.5
CPI 3.2

&8Spring 2010 &8OLS371 &8Clingerman, Kauffman, Spoonmore

SPI Up Cyc 1 0.54045307443365698 CPI Up Cyc 1 3.1509433962264151

Update 2

Update Cycle #2
Proj Bath remodel Data Date: page 1 of 2
PM: Key Date:
PLAN Actual
ID Task Name Start Date Finish Date Budgeted Amount PV Start Finish EV PM Customer Contractor Plumber Electrician Mats Total
$15 $10 $50 $50 $50 Cost (AC)
A Demo: Remove tub, toilet, vanitysink, shower tile and fixtures 1/15 1/16 $460 $460 1/11/16 1/14/16 $460 10 10 $250
B Mold Removal 1/15 1/22 $750 $750 1/21/16 1/21/16 $750 1 $15
B Paint 1/17 1/18 $165 $165 1/22/16 1/23/16 $165 0 5 $250 $300
C Install new tub, toilet, vanity/sink 1/21 1/23 $2,130 $2,130 1/24/16 $1,065 5 2 1 2 $1,000 $1,245
D Install fixtures and GFIs 1/21 1/21 $1,050 $1,050 1/24/16 1/30/16 $1,050 3 11 $400 $995
E Re-tile shower 1/17 1/18 $545 $545 1/25/16 1/28/16 $545 6 10 $250 $440
F Lay new flooring 1/24 1/28 $1,275 $1,275 $0
G Walk-through and punch-list creation with customer 1/29 1/29 $25 $25 $0
H Address all punch-list items 1/30 1/31 $180 $180 $0
I Turnover bathroom to customer 2/1 2/1 $25 $25 1/15 1/21 $765 1 $1,000 $1,015
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
$0
PV= $6,605 EV = $4,800 AC = $4,260
Update Cycle #2 Analysis and Recommendations
Proj ERROR:#REF! Data Date: 12/31/99 page 2 of 2
PM: Key Date: 12/31/99
Planned BAC = 5855
Earned Value Values Indication Significance Recommendations
2 Schedule Variances
SV = EV-PV -$1,805 Behind
SPI=EV/PV 0.73 Yes
1 Cost Variances Volunteers should have helped more.
CV = EV-AC $540 Overbudget
CPI=EV/AC 1.13 Yes
3 Quality Variances Mold delayed the project.
Project Variance Majority of tasks are done but should have been done by now.
EAC = BAC/CPI 5196.31
PC = EV/BAC 0.8198121264
Lessons Learned HoA is a pain.
Overall Recommendation
Index Graph Up Cyc 1 Up Cyc 2
SPI 0.7
CPI 1.1

&8Spring 2010 &8OLS371 &8Clingerman, Kauffman, Spoonmore

SPI Up Cyc 1 0.72672218016654055 CPI Up Cyc 1 1.1267605633802817

Update 3

Update Cycle #3
Proj Bath remodel Data Date: Day 8 Month 2 page 1 of 2
PM: Key Date:
PLAN Actual
ID Task Name Start Date Finish Date Budgeted Amount PV Start Finish EV PM Customer Contractor Plumber Electrician Mats Total
$15 $10 $50 $50 $50 Cost (AC)
A Demo: Remove tub, toilet, vanitysink, shower tile and fixtures 1/15 1/16 $460 $460 1/11/16 1/14/16 $460 10 10 $250
B Mold Removal 1/15 1/22 $750 $750 1/21/16 1/21/16 $750 1 $15
B Paint 1/17 1/18 $165 $165 1/22/16 1/23/16 $165 0 5 $250 $300
C Install new tub, toilet, vanity/sink 1/21 1/23 $2,130 $2,130 1/24/16 2/1/16 $2,130 5 2 1 4 $1,000 $1,345
D Install fixtures and GFIs 1/21 1/21 $1,050 $1,050 1/24/16 1/30/16 $1,050 3 11 $400 $995
E Re-tile shower 1/17 1/18 $545 $545 1/25/16 1/28/16 $545 6 10 $250 $440
F Lay new flooring 1/24 1/28 $1,275 $1,275 2/4/16 2/5/16 $1,275 12 5 $900 $1,270
G Walk-through and punch-list creation with customer 1/29 1/29 $25 $25 2/6/16 2/6/16 $25 1 1 $25
H Address all punch-list items 1/30 1/31 $180 $180 2/7/16 2/7/16 $180 4 $25 $225
I Turnover bathroom to customer 2/1 2/1 $25 $25 2/8 2/8 $25 1 1 $25
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
0 0 12/31 12/31 $0 $0
$0
PV= $6,605 EV = $6,605 AC = $4,890
Update Cycle #1 Analysis and Recommendations
Proj ERROR:#REF! Data Date: Day 8 Month 2 page 2 of 2
PM: Key Date: 12/31/99
Planned BAC = 5855
Earned Value Values Indication Significance Recommendations
2 Schedule Variances No recommendations as we are on track.
SV = EV-PV $0 Perfect
SPI=EV/PV 1.00 Yes
1 Cost Variances Went a little over budget with more labor hours due to mold.
CV = EV-AC $1,715 Over
CPI=EV/AC 1.35 Yes
3 Quality Variances
Project Variance All tasks are complete.
EAC = BAC/CPI 4334.74
PC = EV/BAC 1.1280956447
Lessons Learned Lessons that were learned are that the bathrom trim was still missing.
Overall Recommendation The project was a little over budget because of the mold that needed to be removed. Overall schedule wasn't pushed to far. Roughly a week. Also had to wait on the tub.
Index Graph Up Cyc 1 Up Cyc 2
SPI 1.0
CPI 1.4

&8Spring 2010 &8OLS371 &8Clingerman, Kauffman, Spoonmore

SPI Up Cyc 1 1 CPI Up Cyc 1 1.3507157464212678