checked,8834,project reveiw meet formats - november

8/2/2019 Checked,8834,Project Reveiw Meet Formats - November

1/30

Master Job Data Sheet

Sl.

No.

Description

1 Contract Commencement Date

2 Original Contract Period (in months)

3 Contractual completion date (As Extended)

4 Expected Completion Date

5 Original Contract Value ( in Rs Cr )

6 Gross Value of work as per latest CE Oct'10 ( in Rs Cr )

7 JTD Work Done till 31/03/2010 ( in Rs Cr )

8 Revised Target Turnover for FY 10-11 ( in Rs Cr )

9 Actual YTM Oct'10 ( in Rs Cr )

10 Asking Rate (Nov'10 Mar'11)( in Rs Cr )

Page 1


2/30

Master Job Data Sheet

Remarks

1st January 2010

22 Months

30th Octomber 2010

30th Octomber 2010

32

32

0.63

17.68

4.322.6

Page 2


3/30

Phy Prg

Sl.

No

Activity Unit Original Scope Revised Scope

1 Excavation Cum 16000 16000

2 Raft Foundation Cum 8354 8354

3 RCC Shell Cum 11896 11896

4

5

6

7

8

9

10

Physical Progress

Page 1


4/30

Phy Prg

Cumulative

Achieved

Balance Remarks

16000

8354

232 11664

Page 2


5/30

Financial Prg

Sl.

No

Activity Unit Original Target

Current Year

Revised Target

Current Year

1 RCC of Shell Cum 9.75 9.75

2 Flue Can Fabrication MT 2.29 2.29

3 Plat form Fabrication MT 2.46 2.46

4

5

6

7

8

9

10

Financial Progress

Page 3


6/30

Financial Prg

YTM Balance

0.21 9.54

2.29

2.46

Page 4


7/30

Financial Progress Billing

Month Revised Budget

(Monthly)

Revised Budget

(Cumulative)

Actual Achieved

(Monthly)

Apr'10 0.64 0.64May'10 0.64 1.28 0.16

Jun'10 0.64 1.92 1.5

Jul'10 0.64 2.56 1.51

Aug'10 0.64 3.2 0.21

Sep'10 3.2Oct'10 2.05 5.25

Nov'10 2.25 7.5

Dec'10 2.37 9.87Jan'11 2.57 12.44

Feb'11 2.67 15.11

Mar'11 2.57 17.68

Total 17.68 17.68 3.38

Page 5


8/30


Amount in Rs Crs

Actual Achieved

(Cumulative)

% Cumulative Remarks

0.16 12.50%

1.66 86.46%

3.17 123.83%

3.38 105.63%

3.38 105.63%3.38 64.38%

3.38 45.07%

3.38 34.25%3.38 27.17%

3.38 22.37%

3.38 19.12%

3.38 19.12%

Page 6


9/30


0.00

Page 7


10/30

FP-Billing

Dec'10 Jan'11

1 Raft Foundation 3.18

2 RCC of Shell 0.21 2 2.25 1.75

3 Plat form Fabrication

4 Flue Can Fabrication 0.76

56

7

8

9

10

3.39 2 2.25 2.51Total

Sl.

No

Top 10 Items YTM Oct'10

Actual

Nov'10

Likely

Proje

Page 8


11/30

FP-Billing

Amount in Rs Crs

Feb'11 Mar'11

3.18

1.75 1.75 9.71

1.25 1.26 2.51

0.76 0.76 2.28

3.76 3.77 17.68

FY 10-11tions

Page 9


12/30

Con Est

Sl.

No

Description

1 Work Done (Undisputed)

a Turnover 32 32b Escalation

c Extra items / Variations / others

A Total (a + b + c ) 32 32

2 Cost

I Blue Sheet Expenditure 15.9 50% 15.9

II Yellow Sheet Expenditure 6.98 22% 6.98

B Sub total (BS+YS) ( I + II ) 22.88 72% 22.88

III Plant Hire (Internal) 1.93 6% 1.93

IV H.O. Overheads 0.74 2% 0.74

V H. O. Finance Cost

VI Contingencies 0.25 1% 0.25

C Sub total (HO Cost) 2.92 9% 2.92

D Total Cost ( B + C ) 25.8 81% 25.8

3 Contribution @ Site Level (A B) 9.12 29% 9.12

4 Profit @ H. O. Level (A D) 6.2 19% 6.2

1st CE Previous CE

Page 10


13/30

Con Est

Amount in Rs Crs

32

32

50% 15.9 50%

22% 6.98 22%

72% 22.88 72%

6% 1.93 6%

2% 0.74 2%

1% 0.25 1%

9% 2.92 9%

81% 25.8 81%

29% 9.12 29%

19% 6.2 19%

Mar'10 Latest CE Oct'10

Page 11


14/30

CE

Sl.

No

Description

1 Work Done (Undisputed)

a Turnover 32 4.32b Escalation

c Extra items / Variations / others

A Total (a + b + c ) 32 4.32

2 Cost

I Blue Sheet Expenditure 15.9 50% 2.76 64%

II Yellow Sheet Expenditure 6.98 22% 0.93 22%

B Sub total (BS+YS) ( I + II ) 22.88 72% 3.69 85%

III Plant Hire (Internal) 1.93 6% 0.08 2%

IV H.O. Overheads 0.74 2% 0.03 1%

V H. O. Finance Cost

VI Contingencies 0.25 1%

C Sub total (HO Cost) 2.92 9% 0.11 3%

D Total Cost ( B + C ) 25.8 81% 3.8 88%

3 Contribution @ Site Level (A B) 9.12 29% 0.63 15%

4 Profit @ H.O.Level (A D) 6.2 19% 0.52 12%

Latest CE Oct'10 JTD Sept'10

Page 12


15/30

CE

Amount in Rs Crs

3.69

27.68 3.69 13.99 17.68

13.14 47% 2.31 63% 2.99 21% 5.3

6.05 22% 1.56 42% 0.52 4% 2.08

19.19 69% 3.87 105% 3.51 25%

1.85 7% 0.07 2% 0.84 6%

0.71 3% 0.03 1% 0.32 2%

0.25 1%

2.81 10% 0.09 3% 1.17 8%

22 79% 3.96 107% 4.68 33%

8.49 31% -0.18 -5% 10.48 75%

5.68 21% -0.2739583 -7% 9.3127094 67%

Balance YTM Sept'10 Balance for the

year (10-11)

Page 13


16/30

CashFlow

Amt in Rs Crs.

Description Receipts Recoupment Net Inflow

Actual

April'10 to Sept'10 4.68 3.7 0.98

Oct'10

Total 4.68 3.7 0.98

Projected

Nov'10 1.2 -1.2

Dec'10 1.68 1.38 0.3

Jan'11 3.57 2.22 1.35Feb'11 2.03 2.33 -0.3

March'11 2.26 2.5 -0.24

Total 9.54 9.63 -0.09

Total for Year 10-11 14.22 13.33 0.89

Page 14


17/30

Inflow

Am

Sl.

No.

Description Receipts Recoupment

1 JTD as on 31st March 2010.

2 YTM as on 30th

September 2010. 4.323 JTD as on 30th September 2010 4.68 4.32

4 Projected Oct'10 To March'11 9.72 10.44

5 Expected JTD (31st March 2011) 9.72 10.44

5.4

Page 15


18/30

Inflow

ount in Rs Crs

Net Inflow

4.320.36

-0.72

-0.72

Page 16


19/30


20/30

Work Cap

A

31st

March

2010

30th

Sept 2010 31st

Oct 2010

1 Receivables 4.68 0.08

2 Liability 0.58 1.69 2.45

3 Stock 0.27 1.85 1.92

-0.31 4.84 -0.45

Sl.

No

Description As on

Net Working Capital

Page 18


21/30

Work Cap

ount in Rs Crs

Projected 31st

March 2011

9.72

10.44

-0.72

Page 19


22/30

Plant & Equipment

A

Owned

1 Total no of Plants at Site 84

2 Value of Plant at site (Purchase Price / Gross Block)

3 Energy Consumption

a POL 0.02

b Energy Consumption

Total 0.02

4 Cost of Spares in H1 (April'10 to Sept'10) 0.08

5 Cost of Repairs in H1 (April'10 to Sept'10) 0.02

0.02

6 Hire Charges in H1 (April'10 Sept'10)

(Internal)

Sl.

No

Description Plant & E

Page 20


23/30

Plant & Equipment

ount in Rs Crs

Hired

5

(External)

uipment

Page 21


24/30

Milestone

Start Date End Date Start Date

1 Milestone - I2 Milestone II

3 Milestone III

Sl.

No

Description Planned Achi

Page 22


25/30

Milestone

End Date Remarks

eved Progress %

Page 23


26/30

Right of Way

Both way One way

12

3

4

5

Sl.

No

Chainage Clearance received Remarks

Page 24


27/30

PNM Performance

Productivity

Norms

Unit Achieved

Productivity

1

Batching Plant Schwing

StetterConcrete Cum 20.14 cum/hrs

2 Concrete Pump (Bp-350E) Concrete Cum 4.55 cum/hrs

3

Sl.

No

Plant Description Perfor

Page 25


28/30

PNM Performance

Fuel

Consumption

Weightage Remarks

ance

Page 26


29/30

HR

ASl.

No

Category Head Count Nos

(As on 31/10/10)

H1 Cost

(April'10 to

Sept'10)

Oct'10 Cost

1 H O Staff 22 0.75

2 LMR 71 2368127 549073

3 DMR

4 PRW Workers 175 1737174 448650

Remarks :

Page 27


30/30

HR

ount in Rs CrsExpected Cost

(April'10 to

March'11)

checked,8834,project reveiw meet formats - november

Documents