Mitigation Curves

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

Cost-wise (WEEK OF) 6-Oct-22 13-Oct-22

PV 72,740.78 224,339.07
Cum.Planned Value Cost 170,781.16 395,120.23
Mitigation Plan (PL) 13,032.00 247,966.95
Mitigation Plan (CUM.PL) 13,032.00 260,998.95
EV 13,032.00 247,966.95
Cum.Earned Value Cost 13,032.00 260,998.95
Mitigation Plan Cum. PL % 0.08% 1.61%
Cum Planned Value [PL] 0 1.05%
Cum Earned Value [EV] 0.08% 1.61%
SV 0.08% 0.56%
SPI - 1.53

18,000,000.00

16,000,000.00

14,000,000.00

12,000,000.00

10,000,000.00

8,000,000.00

6,000,000.00

4,000,000.00
6,000,000.00

4,000,000.00

2,000,000.00

-
6-Oct 13-Oct 20-Oct 27-Oct 3-Nov 10-Nov

Mitigation Plan
20-Oct-22 27-Oct-22 3-Nov-22 10-Nov-22 17-Nov-22
1,254,278.79 1,182,259.75 1,301,856.49 862,411.85 746,659.91
1,649,399.02 2,831,658.78 4,133,515.27 4,995,927.12 5,742,587.03
433,463.48 593,437.57 186,300.00 513,540.00 738,720.00
694,462.43 1,287,900.00 1,474,200.00 1,987,740.00 2,726,460.00
433,463.48 593,437.57 186,300.00 513,540.00 738,720.00
694,462.43 1,287,900.00 1,474,200.00 1,987,740.00 2,726,460.00
4.29% 7.95% 9.10% 12.27% 16.83%
2.44% 10.18% 17.48% 25.52% 30.84%
4.29% 7.95% 9.10% 12.27% 16.83%
1.85% -2.23% -8.38% -13.25% -14.01%
1.76 0.78 0.52 0.48 0.55

MOCKUP OVERALL S-C


3-Nov 10-Nov 17-Nov 24-Nov 1-Dec 8-Dec 15-Dec 22-Dec

Mitigation Plan (PL) EV Cum.Planned Value Cost M


24-Nov-22 1-Dec-22 8-Dec-22 15-Dec-22 22-Dec-22
600,668.44 652,845.46 817,202.83 986,060.12 1,054,693.24
6,343,255.47 6,996,100.92 7,813,303.76 8,799,363.88 9,854,057.12
147,420.00 1,114,560.00 155,520.00 139,320.00 1,080,540.00
2,873,880.00 3,988,440.00 4,143,960.00 4,283,280.00 5,363,820.00
147,420.00 1,114,560.00 155,520.00 139,320.00 1,080,540.00
2,873,880.00 3,988,440.00 4,143,960.00 4,283,280.00 5,363,820.00
17.74% 24.62% 25.58% 26.44% 33.11%
35.45% 40.23% 44.13% 48.23% 54.32%
17.74% 24.62% 25.58% 26.44% 33.11%
-17.71% -15.61% -18.55% -21.79% 0.00%
0.50 0.61 0.58 0.55 1.00

VERALL S-CURVE
5-Dec 22-Dec 29-Dec 5-Jan 12-Jan 19-Jan 26-Jan 2-Feb 9-

ue Cost Mitigation Plan (CUM.PL) Cum.Earned Value Cost


29-Dec-22 5-Jan-23 12-Jan-23 19-Jan-23 26-Jan-23
797,154.31 753,032.83 710,115.75 1,094,418.17 1,237,425.97
10,651,211.43 11,404,244.26 12,114,360.01 13,208,778.18 14,446,204.15
814,860.00 1,137,240.00 1,564,920.00 1,423,980.00 1,210,140.00
6,178,680.00 7,315,920.00 8,880,840.00 10,304,820.00 11,514,960.00

38.14% 45.16% 54.82% 63.61% 71.08%


60.83% 65.75% 70.40% 74.78% 81.54%

1,800,000.00

1,600,000.00

1,400,000.00

1,200,000.00

1,000,000.00

800,000.00

600,000.00

400,000.00
600,000.00

400,000.00

200,000.00

-
2-Feb 9-Feb 16-Feb 23-Feb 2-Mar

d Value Cost
2-Feb-23 9-Feb-23 16-Feb-23 23-Feb-23 2-Mar-23
1,002,297.18 536,103.13 193,604.91 21,790.63
15,448,501.34 15,984,604.46 16,178,209.37 16,200,000.00 16,200,000.00
915,300.00 1,176,120.00 1,171,260.00 991,440.00 430,920.00
12,430,260.00 13,606,380.00 14,777,640.00 15,769,080.00 16,200,000.00

76.73% 83.99% 91.22% 97.34% 100.00%


89.17% 95.36% 98.67% 99.87% 100.00%
9-Mar-23

16,200,000.00

100.00%
Spreadsheet Field 6-Oct-22
BL1 Total Cost 6,000.00
Cum BL Project Total Cost 6,000.00
Mitigation Plan (PL) 14,652.00
Mitigation Plan (Cum.PL) 14,652.00
Earned Value Cost 14,652.00
Cum Earned Value Cost 14,652.00
Mitigation Cum % 12.21%
Cum Planned Value [PL] 5.00%
Cum Earned Value [EV] 12.21%
SV 7.21%
SPI 2.44

140,000.00

120,000.00

100,000.00

80,000.00
80,000.00

60,000.00

40,000.00

20,000.00

0.00
6-Oct 13-Oct 20-Oct 27-Oct 3-Nov

Earned Value C
13-Oct-22 20-Oct-22 27-Oct-22
12,000.00 12,000.00 12,000.00
18,000.00 30,000.00 42,000.00
7,164.00 936.00 312.00
21,816.00 22,752.00 23,064.00
7,164.00 936.00 312.00
21,816.00 22,752.00 23,064.00
18.18% 18.96% 19.22%
15.00% 25.00% 35.00%
18.18% 18.96% 19.22%
3.18% -6.04% -15.78%
1.212 0.758 0.549

En
-Oct 27-Oct 3-Nov 10-Nov 17-Nov 24-Nov 1-Dec

Earned Value Cost Mitigation Plan (PL) Cum B


3-Nov-22 10-Nov-22 17-Nov-22
22,285.71 22,285.71 22,285.71
64,285.71 86,571.43 108,857.14
9,660.00 3,588.00 4,368.00
32,724.00 36,312.00 40,680.00
9,660.00 3,588.00 4,368.00
32,724.00 36,312.00 40,680.00
27.27% 30.26% 33.90%
53.57% 72.14% 90.71%
27.27% 30.26% 33.90%
-26.30% -41.88% -56.81%
0.509 0.419 0.374

Engineering S-Curve
24-Nov 1-Dec 8-Dec 15-Dec 22-Dec 29-Dec 5

Plan (PL) Cum BL Project Total Cost Mitigation Plan (Cu

Activity ID Activity Name Start


Engineering 3-Oct-22
Engineering 3-Oct-22
Engineering 3-Oct-22
Engineering 3-Oct-22
Engineering 3-Oct-22
Engineering 3-Oct-22
24-Nov-22 1-Dec-22 8-Dec-22
11,142.86
120,000.00 120,000.00 120,000.00
6,384.00 4,836.00 2,328.00
47,064.00 51,900.00 54,228.00
6,384.00 4,836.00 2,328.00
47,064.00 51,900.00 54,228.00
39.22% 43.25% 45.19%
100.00% 100.00% 100.00%
39.22% 43.25% 45.19%
-60.78% -56.75% -54.81%
0.392 0.433 0.452

rve
22-Dec 29-Dec 5-Jan 12-Jan 19-Jan 26-Jan 2-Feb

Mitigation Plan (Cum.PL) Cum Earned Value Cost

Finish BL Project Duration Original Duration


20-Nov-22 42d 42d
20-Nov-22 42d 42d
20-Nov-22 42d 42d
20-Nov-22 42d 42d
20-Nov-22 42d 42d
20-Nov-22 42d 42d
15-Dec-22 22-Dec-22 29-Dec-22

120,000.00 120,000.00 120,000.00


4,680.00 3,900.00 16,296.00
58,908.00 62,808.00 79,104.00
4,680.00 3,900.00
58,908.00 62,808.00
49.09% 52.34% 65.92%
100.00% 100.00% 100.00%
49.09% 52.34%
-50.91% 0.00%
0.491 1.000

18,000.00

16,000.00

14,000.00

12,000.00

10,000.00
10,000.00

8,000.00

6,000.00

4,000.00

2,000.00

-
an 26-Jan 2-Feb 9-Feb 16-Feb

d Value Cost

BL Project Start BL Project Finish BL Project Total


3-Oct-22 20-Nov-22 120,000.00
3-Oct-22 20-Nov-22 120,000.00
3-Oct-22 20-Nov-22 120,000.00
3-Oct-22 20-Nov-22 120,000.00
3-Oct-22 20-Nov-22 120,000.00
3-Oct-22 20-Nov-22 120,000.00
5-Jan-23 12-Jan-23 19-Jan-23 26-Jan-23

120,000.00 120,000.00 120,000.00 120,000.00


9,096.00 9,084.00 9,084.00 9,084.00
88,200.00 97,284.00 106,368.00 115,452.00

73.50% 81.07% 88.64% 96.21%


100.00% 100.00% 100.00% 100.00%
Performance % CompSchedule % Comp
Spreadsheet Fie 29-Sep-22
0% 0% BL1 Total Cost 6,000.00
0% 0% Cum BL Project 6,000.00
0% 0% Earned Value Cost
0% 0% Cum Earned Value Cost
0% 0% Remaining Tota 6,000.00
0% 0% Cum Remaining 6,000.00
2-Feb-23 9-Feb-23 16-Feb-23

120,000.00 120,000.00 120,000.00


4,548.00
120,000.00 120,000.00 120,000.00

100.00%
100.00%
6-Oct-22 13-Oct-22 20-Oct-22 27-Oct-22 3-Nov-22 ###
12,000.00 12,000.00 12,000.00 22,285.71 22,285.71 22,285.71
18,000.00 30,000.00 42,000.00 64,285.71 86,571.43 ###
12,000.00 12,000.00 12,000.00 22,285.71 22,285.71 22,285.71
18,000.00 30,000.00 42,000.00 64,285.71 86,571.43 ###
###

11,142.86

###
11,142.86

###
Spreadsheet Field 6-Oct-22 13-Oct-22 20-Oct-22
BL1 Total Cost 3,645.00 9,963.00 15,308.25
Cum BL Project Total Cost 3,645.00 13,608.00 28,916.25
Mitigation Plan (PL) 0.00 0.00
Mitigation Plan (Cum.PL) 0.00 0.00 0.00
Earned Value Cost 0.00 0.00
Cum Earned Value Cost 0.00 0.00 0.00
Mitigation Cum % 0.00%
Cum Planned Value [PL] 0.05% 0.17% 0.36%
Cum Earned Value [EV] 0.00%
SV -0.05% -0.17% -0.36%
SPI - - 0.00

9,000,000.00

8,000,000.00

7,000,000.00

6,000,000.00

5,000,000.00

4,000,000.00

3,000,000.00

2,000,000.00
3,000,000.00

2,000,000.00

1,000,000.00

0.00
6-Oct 13-Oct 20-Oct 27-Oct 3-Nov 10-Nov

Mitigation Plan (PL)


27-Oct-22 3-Nov-22 10-Nov-22 17-Nov-22 24-Nov-22
42,815.76 74,837.01 269,420.16 252,466.54 346,200.43
71,732.01 146,569.03 415,989.18 668,455.73 1,014,656.16
233,976.30 51,554.10 103,108.20 79,314.00 143,558.34
233,976.30 285,530.40 388,638.60 467,952.60 611,510.94
233,976.30 51,554.10 103,108.20 79,314.00 143,558.34
233,976.30 285,530.40 388,638.60 467,952.60 611,510.94
2.95% 3.60% 4.90% 5.90% 7.71%
0.90% 1.85% 5.24% 8.43% 12.79%
2.95% 3.6% 4.9% 5.9% 7.7%
2.05% 1.75% -0.34% -2.53% -5.08%
3.26 1.95 0.93 0.70 0.60

Construction S-curve
3-Nov 10-Nov 17-Nov 24-Nov 1-Dec 8-Dec 15-Dec 22-Dec

ation Plan (PL) Earned Value Cost Cum BL Project Total Cost Mitiga
1-Dec-22 8-Dec-22 15-Dec-22 22-Dec-22 29-Dec-22
208,748.52 233,517.98 408,792.97 596,394.13 895,469.04
1,223,404.67 1,456,922.66 1,865,715.63 2,462,109.76 3,357,578.80
196,698.72 63,451.20 135,626.94 303,772.62 435,433.86
808,209.66 871,660.86 1,007,287.80 1,311,060.42 1,746,494.28
196,698.72 63,451.20 135,626.94 303,772.62
808,209.66 871,660.86 1,007,287.80 1,311,060.42
10.19% 10.99% 12.70% 16.53% 22.02%
16.04% 18.89% 23.52% 31.04% 42.33%
10.2% 11.0% 12.7% 16.5%
-5.85% -7.90% -10.82% 0.00%
0.64 0.58 0.54 1.00

S-curve
5-Dec 22-Dec 29-Dec 5-Jan 12-Jan 19-Jan 26-Jan 2-Feb

al Cost Mitigation Plan (Cum.PL) Cum Earned Value Cost


5-Jan-23 12-Jan-23 19-Jan-23 26-Jan-23 2-Feb-23
725,128.75 722,647.46 694,305.00 1,069,801.66 986,172.85
4,082,707.55 4,805,355.01 5,499,660.01 6,569,461.66 7,555,634.51
822,486.18 1,091,360.64 809,795.94 778,863.48 650,374.80
2,568,980.46 3,660,341.10 4,470,137.04 5,249,000.52 5,899,375.32

32.39% 46.15% 56.36% 66.18% 74.38%


51.48% 60.59% 69.34% 82.83% 95.26%

1,400,000.00

1,200,000.00

1,000,000.00

800,000.00

600,000.00

400,000.00
400,000.00

200,000.00

0.00
an 2-Feb 9-Feb 16-Feb
9-Feb-23 16-Feb-23 23-Feb-23 2-Mar-23 9-Mar-23
375,765.49
7,931,400.00 7,931,400.00
885,144.24 1,146,880.44
6,784,519.56 7,931,400.00

85.54% 100.00%
100.00% 100.00%
16-Mar-23 23-Mar-23 30-Mar-23 6-Apr-23
Spreadsheet Field 6-Oct-22 13-Oct-22 20-Oct-22 27-Oct-22
BL1 Total Cost 83,295.38 38,877.78 185,130.82 1,187,563.03
Cum BL Project Total Cost 83,295.38 122,173.16 307,303.98 1,494,867.01
Mitigation Plan (PL) 0.00 249,742.95 682,450.43 43,502.68
Mitigation Plan (Cum.PL) 0.00 249,742.95 932,193.38 975,696.06
Earned Value Cost 0.00 249,742.95 682,450.43 43,502.68
Cum Earned Value Cost 0.00 249,742.95 932,193.38 975,696.06
Mitigation Cum % 3.96% 14.77% 15.46%
Cum Planned Value [PL] 1.32% 1.94% 4.87% 23.69%
Cum Earned Value [EV] 3.96% 14.77% 15.46%
SV -1.32% 2.02% 9.90% -8.23%
SPI - 2.044 3.033 0.653

7,000,000.00

6,000,000.00

5,000,000.00

4,000,000.00

3,000,000.00

2,000,000.00

1,000,000.00
2,000,000.00

1,000,000.00

0.00
6-Oct 13-Oct 20-Oct 27-Oct 3-Nov 10-Nov 17-

Earned Value Cost


3-Nov-22 10-Nov-22 17-Nov-22 24-Nov-22 1-Dec-22 8-Dec-22
1,073,237.03 998,250.62 575,759.60 377,416.62 380,019.92 407,427.47
2,568,104.04 3,566,354.65 4,142,114.25 4,519,530.87 4,899,550.79 5,306,978.27
135,688.65 399,492.63 657,616.62 0.00 910,691.73 66,266.55
1,111,384.71 1,510,877.34 2,168,493.96 2,168,493.96 3,079,185.69 3,145,452.24
135,688.65 399,492.63 657,616.62 0.00 910,691.73 66,266.55
1,111,384.71 1,510,877.34 2,168,493.96 2,168,493.96 3,079,185.69 3,145,452.24
17.61% 23.94% 34.36% 34.36% 48.79% 49.84%
40.69% 56.51% 65.63% 71.61% 79.83% 86.28%
17.61% 23.94% 34.36% 34.36% 48.79% 49.84%
-23.08% -32.57% -31.27% -37.25% -31.04% -36.44%
0.433 0.424 0.524 0.480 0.611 0.578

Procurement S-Curve
v 10-Nov 17-Nov 24-Nov 1-Dec 8-Dec 15-Dec 22-Dec 29-Dec

Earned Value Cost Mitigation Plan (PL) Cum BL Project Total Cost Mitigation Plan (Cum.PL
15-Dec-22 22-Dec-22 29-Dec-22 5-Jan-23 12-Jan-23 19-Jan-23
396,509.86 377,765.99 147,324.20 60,125.57 18,485.37 3,910.75
5,703,488.13 6,081,254.12 6,228,578.32 6,288,703.88 6,307,189.25 6,311,100.00
0.00 636,158.88 472,701.39 290,941.71 497,314.68 485,954.70
3,145,452.24 3,781,611.12 4,254,312.51 4,545,254.22 5,042,568.90 5,528,523.60
0.00 707,474.31
3,145,452.24 3,852,926.55
49.84% 61.05% 67.41% 72.02% 79.90% 87.60%
90.37% 96.36% 98.69% 99.65% 99.94% 100.00%
49.84% 61.05%
-40.53% 0.00%
0.551 1.000

urve
22-Dec 29-Dec 5-Jan 12-Jan 19-Jan 26-Jan 2-Feb 9-Feb 1

Mitigation Plan (Cum.PL) Cum Earned Value Cost


26-Jan-23 2-Feb-23 9-Feb-23 16-Feb-23

6,311,100.00 6,311,100.00 6,311,100.00 6,311,100.00


413,377.05 258,755.10 109,182.03 1,262.22
5,941,900.65 6,200,655.75 6,309,837.78 6,311,100.00

94.15% 98.25% 99.98% 100.00%


100.00% 100.00%

1,000,000.00

900,000.00

800,000.00

700,000.00

600,000.00

500,000.00

400,000.00

300,000.00

200,000.00

100,000.00
300,000.00

200,000.00

100,000.00

0.00
2-Feb 9-Feb 16-Feb
Total Man-hours
6-Oct 13-Oct 20-Oct 27-Oct
Planned man-hour/week 270 660
Actual man-hour/week 270 660
Cum.Planned manhours 270 930
Cum.Actual manhours - - 270 930

4,000

3,500

3,000

2,500

2,000

1,500

1,000 970

660
1,000 970

660

500
270

-
6-Oct 13-Oct 20-Oct 27-Oct 3-Nov
3-Nov 10-Nov 17-Nov 24-Nov 1-Dec 8-Dec 15-Dec
970 780 1,160 1,140 1,030 1,190 1,270
970 780 1,160 1,140 1,030 1,190 1,270
1,900 2,680 3,840 4,980 6,010 7,200 8,470
1,900 2,680 3,840 4,980 6,010 7,200 8,470

Manhours Histog
Planned man-hour/week Actual m

1,270
1,160 1,190
1,140 1,110
1,030
970

780
660
1,140 1,110
1,030
970

780
660

ct 27-Oct 3-Nov 10-Nov 17-Nov 24-Nov 1-Dec 8-Dec 15-Dec 22-De


22-Dec 29-Dec 5-Jan 12-Jan 19-Jan 26-Jan
1,110 1,600 2,100 2,400 3,000 3,200
1,110
9,580 11,180 13,280 15,680 18,680 21,880
9,580

Manhours Histogram
/week Actual man-hour/week

3,200 3,200
3,1
3,000

2,400

2,100

1,600

1,270
190
1,110
1,110

-Dec 15-Dec 22-Dec 29-Dec 5-Jan 12-Jan 19-Jan 26-Jan 2-Feb 9-


2-Feb 9-Feb 16-Feb 23-Feb 2-Mar
3,200 3,100 3,000 1,600 1,100

25,080 28,180 31,180 32,780 33,880


- - -

3,200 3,200
3,100
0 3,000

1,600

1,100
1,100

an 26-Jan 2-Feb 9-Feb 16-Feb 23-Feb 2-Mar

You might also like