Mitigation Curves
Mitigation Curves
Mitigation Curves
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
VERALL S-CURVE
5-Dec 22-Dec 29-Dec 5-Jan 12-Jan 19-Jan 26-Jan 2-Feb 9-
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
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
Engineering S-Curve
24-Nov 1-Dec 8-Dec 15-Dec 22-Dec 29-Dec 5
rve
22-Dec 29-Dec 5-Jan 12-Jan 19-Jan 26-Jan 2-Feb
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
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
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
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-
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
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
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
3,200 3,200
3,100
0 3,000
1,600
1,100
1,100