Ghantt Chart,s-curve.xlsx

  • Uploaded by: Erwin Eleserio
  • 0
  • 0
  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Ghantt Chart,s-curve.xlsx as PDF for free.

More details

  • Words: 1,963
  • Pages: 41
#

ACTIVITY

1

A

2 3

TASK DESCRIPTION

WORKING DAYS

WORKERS

Mobilization

2

3L, 3H

B

Layouting/Staking

2

2L, 2C, 2H

C

Excavation of Column Footing/Soil Poisoning

2

12L, 5H 6L, 2H

4

D

Excavation of Wall Footing

1

5

E

Preparation of Bars in Column Footing

3

8S, 6H

6

F

Preparation of Bars in Wall Footing

1

4S, 2H

7

G

Preparation of Bars on Slab-on-Fill

3

10S, 6H

8

H

Pouring of Concrete in Column Footing

2

10L, 6H

9

I

Fabrication of Forms in Column

2

8L, 6H

10

J

Preparation of Bars for Column

4

8S, 6H

11

K

Pouring of Concrete in Wall Footing

1

10L, 6H

12

L

Pouring of Concrete in Column

4

10L, 6H

13

M

Pouring of Concrete on Slab-on-Fill

3

10L, 6H

14

N

Backfilling and Compaction

1

12L, 4H

15

O

Laying of CHB for Ground Floor

1

10L, 6H

16

P

Fabrication of Forms for Stairs

1

4L, 4H

17

Q

Fabrication of Forms in Beams

3

8L, 6H

18

R

Fabrication of Forms in 2nd Floor Slab

3

8L, 6H 4L, 4H

19

S

Preparation of Bars for Stairs

1

20

T

Preparation of Bars in Beams

4

10S, 6H

21

U

Preparation of Bars in 2nd Floor Slab

4

10S, 6H

22

V

Pouring of Concrete for Stairs

1

4L, 4H

23

W

Pouring of Concrete in Beams

2

10L, 6H

24

X

Pouring of Concrete in 2nd Floor Slab

3

10L, 6H

25

Y

Preparation of Bars in 2nd Floor Column

3

10S, 6H

26

Z

Fabrication of Forms in 2nd Floor Column

2

8L, 6H

27

AA

Pouring of Concrete in 2nd Floor Column

4

10L, 6H

28

AB

Laying of CHB in 2nd Floor

7

10L, 6H

29

AC

Fabrication of Forms for Stairs

1

4L, 4H

30

AD

Fabrication of Forms in Beams

3

8L, 6H

31

AE

Fabrication of Forms in 3rd Floor Slabs

3

8L, 6H

32

AF

Preparation of Bars for Stairs

1

4L, 4H

33

AG

Preparation of Bars in Beams

4

10S, 6H 10S, 6H

34

AH

Preparation of Bars in 3rd Floor Slab

4

35

AI

Pouring of Concrete for Stairs

1

4L, 4H

36

AJ

Pouring of Concrete in Beams

2

10L, 6H

37

AK

Pouring of Concrete in 3rd Floor Slab

3

10L, 6H

38

AL

Preparation of Bars in 3rd Floor Column

3

10S, 6H

39

AM

Fabrication of Forms in 3rd Floor Column

2

8L, 6H

40

AN

Pouring of Concrete in 3rd Floor Column

4

10L, 6H 10L, 6H

41

AO

Laying of CHB in 3rd Floor

7

42

AP

Fabrication of Forms for Stairs

1

4L, 4H

43

AQ

Fabrication of Forms in Beams

3

8L, 6H

44

AR

Fabrication of Forms in 4th Floor Slabs

3

8L, 6H

45

AS

Preparation of Bars for Stairs

1

4L, 4H

46

AT

Preparation of Bars in Beams

4

10S, 6H

47

AU

Preparation of Bars in 4th Floor Slab

4

10S, 6H

48

AV

Pouring of Concrete for Stairs

1

4L, 4H

49

AW

Pouring of Concrete in Beams

2

10L, 6H

50

AX

Pouring of Concrete in 4th Floor Slab

3

10L, 6H

51

AY

Preparation of Bars in 4th Floor Column

3

10S, 6H

52

AZ

Fabrication of Forms in 4th Floor Column

2

8L, 6H

53

BA

Pouring of Concrete in 4th Floor Column

4

10L, 6H

54

BB

Laying of CHB in 4th Floor

7

10L, 6H

55

BC

Fabrication of Forms for Stairs

1

4L, 4H 8L, 6H

56

BD

Fabrication of Forms in Beams

3

57

BE

Fabrication of Forms in 5th Floor Slabs

3

8L, 6H

58

BF

Preparation of Bars for Stairs

1

4L, 4H

59

BG

Preparation of Bars in Beams

4

10S, 6H

60

BH

Preparation of Bars in 5th Floor Slab

4

10L, 6H

61

BI

Pouring of Concrete for Stairs

1

4L, 4H

62

BJ

Pouring of Concrete in Beams

2

10L, 6H

63

BK

Pouring of Concrete in 5th Floor Slab

3

10L, 6H

64

BL

Preparation of Bars in 5th Floor Column

3

10S, 6H

65

BM

Fabrication of Forms in 5th Floor Column

2

8L, 6H

66

BN

Pouring of Concrete in 5th Floor Column

4

10L, 6H

67

BO

Laying of CHB in 5th Floor

7

10L, 6H

68

BP

Fabrication of Forms for Stairs

1

4L, 4H

69

BQ

Fabrication of Forms in Beams

3

8L, 6H

70

BR

Fabrication of Forms in Roof Deck Slabs

3

8L, 6H 4L, 4H

71

BS

Preparation of Bars for Stairs

1

73

BU

Preparation of Bars in Beams

4

10S, 6H

74

BV

Preparation of Bars in Roof Deck Slab

4

10S, 6H

75

BW

Pouring of Concrete in Beams

2

10L, 6H

76

BX

Pouring of Concrete in Roof Deck Slab

3

10L, 6H

77

BY

Preparation of Bars in Roof Deck Column

2

10S, 6H

78

BZ

Fabrication of Forms in Roof Deck Column

2

8L, 6H

79

CA

Pouring of Concrete in Roof Deck Column

4

10L, 6H

80

CB

Laying of CHB in Roof Deck

7

10L, 6H

81

CC

Plastering of CHB Walls,Columns,Stairs

7

10M, 6L

82

CD

Installation of Doors and Windows

4

6C, 8H

83

CE

Installation of Plumbing and Electrical Fixtures

5

6P, 6E, 4H

84

CF

Installation of Ceiling

3

8C,8H 10M, 4L

85

CG

Painting and Finishing Works

7

86

CH

Laying of Tiles

7

10L, 6H

87

CI

Cleaning and Turnovers

2

6L, 6H

TOTAL ACCOPLISHMENT (%) CUMMULATIVE ACCOMPLISHMENT (%) CASH FLOW CUMMULATIVE CASH FLOW

DIRECT COST

REL. WT. (%)

7,000.00

0.012

7,666.67

0.013

243,725.00

0.426

5,166.67

0.009

292,845.83

0.512

2,620.33

0.005

96,441.58

0.169

475,595.83

0.832

36,904.50

0.065

473,456.23

0.828

5,491.67

0.010

102,275.00

0.179

298,700.00

0.523

10,333.33

0.018

9,122.50

0.016

23,204.65

0.041

24,643.25

0.043

25,627.33

0.045

37,113.13

0.065

5,150,543.48

9.012

96,441.58

0.169

5,900.00

0.010

335,504.17

0.587

335,504.17

0.587

473,456.23

0.828

36,904.50

0.065

102,275.00

0.179

212,987.50

0.373

23,204.65

0.041

24,643.25

0.043

25,627.33

0.045

37,113.13

0.065

5,150,543.48

9.012

96,441.58

0.169

34,762.50

0.061

275,116.67

0.481

335,504.17

0.587

473,456.23

0.828

36,904.50

0.065

1

2

3

4

5

6

7

8

9

10

11

12

0.012 0.013 0.426 0.009 0.512 0.005 0.169 0.832

0.010

13

102,275.00

0.179

212,987.50

0.373

23,204.65

0.041

24,643.25

0.043

25,627.33

0.045

37,113.13

0.065

5,150,543.48

9.012

96,441.58

0.169

34,762.50

0.061

275,116.67

0.481

335,504.17

0.587

473,456.23

0.828

36,904.50

0.065

102,275.00

0.179

212,987.50

0.373

23,204.65

0.041

24,643.25

0.043

25,627.33

0.045

37,113.13

0.065

5,150,543.48

9.012

96,441.58

0.169

34,762.50

0.061

275,116.67

0.481

335,504.17

0.587

473,456.23

0.828

36,904.50

0.065

102,275.00

0.179

212,987.50

0.373

23,204.65

0.041

24,643.25

0.043

25,627.33

0.045

37,113.13

0.065

5,150,543.48

9.012

96,441.58

0.169

275,116.67

0.481

335,504.17

0.587

473,456.23

0.828

36,904.50

0.065

102,275.00

0.179

212,987.50

0.373

14,379,675.00

25.162

3,051,166.67

5.339

995,833.33

1.743

1,048,835.44

1.835

703,166.67

1.230

748,820.60

1.310

15,000.00

0.026

57,149,505.25

100

2.05 2.05 1,173,458.08 1,173,458.08

`

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

0.415 0.415 0.065

0.100 0.828

0.179 0.560

0.523 0.018 0.016 0.041 0.030

0.067

0.043 0.100 0.065

1.60 3.66 917,091.71 2,090,549.79

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

0.043 0.045

9.012 0.169 0.010 0.587 0.587 0.276

0.552 0.065 0.179

10.79 14.45 6,169,095.85 8,259,645.64

667 8,92

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

`

0.179 0.430

0.373 0.060

0.041 0.100

0.043 0.070

0.080

0.030

0.045

0.065 4.340

9.012

0.061

68

1.17 15.62 667,804.49 8,927,450.13

10.50 26.13 6,002,956.75 14,930,406.88

69

70

71

72

73

74

75

76

77

78

79

80

0.169

0.481 0.587 0.828 0.065

81

82

83

84

85

86

87

0.179 0.319

10.50 26.13 6,002,956.75 14,930,406.88

1.39 27.52 795,196.44 15,725,603.32

DURATION (DAYS) 88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

0.319

0.053 0.041 0.043 0.045 0.065 9.012 0.169 0.061 0.481 0.391

`

10.36 37.88 5,921,548.81 21,647,152.13

YS) 106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

0.196 0.828 0.065 0.179 0.266

0.106 0.041

1.53 39.41 876,604.38 22,523,756.51

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

0.043 0.045 0.065 9.012 0.169 0.061 0.481 0.196

0.391 0.828 0.065

10.22 49.63 5,840,140.88 28,363,897.39

1.68 51.31 958,012.32 29,321,909.71

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

0.065 0.179 0.213

0.160 0.041 0.043 0.045 0.065 9.012

1.68 51.31 958,012.32 29,321,909.71

10.02 61.32 5,723,970.44 35,045,880.15

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

9.012 0.169 0.481 0.587 0.828 0.065 0.179 0.160

44 15

1.82 63.14 1,039,420.25 36,085,300.40

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

0.160

0.213 25.162 5.339 1.394

0.349

1.835

32.11 95.25 18,349,215.48 54,434,515.88

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

1.835 1.230 0.749

0.562 0.026

4.16 99.41 2,379,066.26 56,813,582.13

0.59 100.00 335,923.12 57,149,505.25

ACTIVITY

51

AY

52

FLOOR LEVEL

WORKING DAYS

LABOR COST

Preparation of Bars in 4th Floor Column

3

68177.70

AZ

Fabrication of Forms in 4th Floor Column

2

5314.25

53

BA

Pouring of Concrete in 4th Floor Column

4

14727.60

54

BB

Laying of CHB in 4th Floor

7

30670.20

55

BC

Fabrication of Forms for Stairs

1

3341.47

56

BD

Fabrication of Forms in Beams

3

3548.63

57

BE

Fabrication of Forms in 5th Floor Slabs

3

3690.34

58

BF

Preparation of Bars for Stairs

1

5344.29

59

BG

Preparation of Bars in Beams

4

743478.26

60

BH

Preparation of Bars in 5th Floor Slab

4

13887.59

61

BI

Pouring of Concrete for Stairs

1

5005.80 39616.80

4TH FLOOR

#

TASK DESCRIPTION

BJ

Pouring of Concrete in Beams

63

BK

Pouring of Concrete in 5th Floor Slab

3

48312.60

64

BL

Preparation of Bars in 5th Floor Column

3

68177.70

65

BM

Fabrication of Forms in 5th Floor Column

2

5314.25

66

BN

Pouring of Concrete in 5th Floor Column

4

14727.60

67

BO

Laying of CHB in 5th Floor

7

30670.20

68

BP

Fabrication of Forms for Stairs

1

3341.47

69

BQ

Fabrication of Forms in Beams

3

3548.63

70

BR

Fabrication of Forms in Roof Deck Slabs

3

3690.34

71

BS

Preparation of Bars for Stairs

1

5344.29

72

BT

Preparation of Bars in Beams

4

743478.26

73

BU

Preparation of Bars in Roof Deck Slab

4

13887.59

74

BV

Pouring of Concrete in Beams

2

39616.80

75

BW

Pouring of Concrete in Roof Deck Slab

3

48312.60

76

BX

Preparation of Bars in Roof Deck Column

2

68177.70 5314.25

5TH FLOOR

62

2

BY

Fabrication of Forms in Roof Deck Column

78

BZ

Pouring of Concrete in Roof Deck Column

4

14727.60

79

CA

Laying of CHB in Roof Deck

7

30670.20

80

CB

Plastering of CHB Walls,Columns,Stairs

7

2070673.20

81

CC

Installation of Doors and Windows

4

439368.00

82

CD

Installation of Plumbing and Electrical Fixtures

5

143400.00

83

CE

Installation of Ceiling

3

151032.30

84

CF

Laying of Tiles

7

101256.00

85

CG

Painting and Finishing Works

7

107830.17

86

CH

Cleaning and Turnovers

2

9000.00

GROUND FLOOR To ROOF DECK

77

2

MATERIAL COST

DIRECT COST

227,258.99

295,436.69

17,714.16

23,028.41

49,092.00

63,819.60

102,234.00

132,904.20

11,138.23

14,479.70

11,828.76

15,377.39

12,301.12

15,991.46

17,814.30

23,158.59

2,478,260.87

3,221,739.13

46,291.96

60,179.55

16,686.00

21,691.80

132,056.00

171,672.80

161,042.00

209,354.60

227,258.99

295,436.69

17,714.16

23,028.41

49,092.00

63,819.60

102,234.00

132,904.20

11,138.23

14,479.70

11,828.76

15,377.39

12,301.12

15,991.46

17,814.30

23,158.59

2,478,260.87

3,221,739.13

46,291.96

60,179.55

132,056.00

171,672.80

161,042.00

209,354.60

227,258.99

295,436.69

17,714.16

23,028.41

49,092.00

63,819.60

102,234.00

132,904.20

6,902,244.00

8,972,917.20

1,464,560.00

1,903,928.00

478,000.00

621,400.00

503,441.01

654,473.31

337,520.00

438,776.00

359,433.89

467,264.06 9,000.00

Related Documents


More Documents from "Erwin Eleserio"

Common Punchlist.docx
June 2020 3
Career Idols.docx
June 2020 5
Tht Soal Erwin.docx
June 2020 30
Abstrak.docx
November 2019 50
Hidroterapi.docx
June 2020 32