TATA HOUSING DEVELOPMENT COMPANY LIMITED

MANAGEMENT INFORMATION SYSTEM

PROJECT :
CONTENTS
1 MIS - Summary
2 NC Report
3 Observation & Flash Reports
4 Material Rejection
5 Pre-dispatch inspection
6 Total Concrete production
7 Quality Walk & Meeting
8 Mock-up Activities
9 COPQ (Direct Cost)
10 COPQ (Indirect Cost)
11 Amount with-held for Quality
12 Log of Good Practices Implemented
 MANAGEMENT INFORMATION SYSTEM (MIS) - QA&QC
Date : 30.12.2012

QUALITY ASSURANCE & QUALITY CONTROL

DAILY / WEEKLY / MONTHLY REPORT
Project Name: TRIL IT City Date: 01-09-2023

Total for FY 2022- Total for FY 2023- Reference

` Key Performance Indicator (KPI) 23 24 Record Remark
April May June July August
1 Quality Performance Indicators 0
1-A No. of NCs raised in the month 95 3 4 6 6 11
1-B No of NCs closed (against raised for the month) 95 3 4 6 6 8
1-C Total NCs closed (From Apr to Date) 760 3 7 13 19 27
1-D No. of Repetitive NCs 0 0 0 0 0 0
1-E No. of Observations raised in the month 154 12 6 12 6 7
1-F No of Observations closed (against raised for the 154 12 6 12 6 5
month)
1-G Total Observation Closed till Last Month 12 18 30 36 41
2 Material Conformance
2-A Total material rejection 0
2-B Pre-Despatch Inspection for Major Material 0 0
2-C Total Concrete Production 4252.5 744.5 428.00 17 229 326
3 Increase in Quality Awareness 0
3-A No. of persons inducted 0 0 0 0
No. of Quality walks conducted (followed by
3-B 48 4 4 4 2 3
meeting)
No. of Observations raised in the month during
3-C 186 12 16 16 12 18
Quality walk
No. of Observations closed in the month during
3-D 186 12 16 16 11 13
Quality walk
3-E No. of Mock-ups done 0 2 1 0 0 0
3-F Details of Good Practices Implemented 4 2 1 0 0 0
4 Cost of Poor Quality (Rework & rejection) 0 0 0 0 Please mention the calculation in the cell itself.
0.00 0 0 0 Note :- Percentage COPQ will be,
4-A COPQ (NC based + Common rework elements)
0.00 0.00 0.00 0.00 (NC based + Common rework elements / RA Bill for the month)
4-B Billed Amount for the Month 37.80 7.00 2.00 0.00 0.00 0.00
4-C Amount with-held for non-compliance 0 0.00 0.00
5 Ratings & Audits
5-A Tata Quality Hallmark Rating
5-B Annual TPQA Rating 100% 100% 100% 100% 100%

Inclusion of THQH Criteria (Signed off Undertaking

from contracts) in contracts ( Every contract
5-C 100% 100% 100% 100% 100%
awarded through site shall have THQM Criteria
incorporated in contract document)

6 Customer 0 0 0 0 0 0

6-A Total number of units handed over to customer 0 0 0 0 0 0

CC: Project Head

 PROJECT NAME: Intellion Park
CLIENT: Tata Realty Infrastructure Ltd.
EMPLOYER: Tata Realty
PMC:
CONSULTANT:
CONTRACTOR:

NON CONFORMANCE REPORT LOG SHEET

DATA DATE

SI. NON CONFORMANCE REPORT DETAILS

NO
SITE ENGINEER/ INCHA
Nature - New /
Month NCR-REF-NO Conractor Area Location DESCRIPTION ORIGINATOR DATE ISSUED Repetitive ROOT CAUSE DISCIPLINE
New
TRIL/TCE

PAGE 3 OF 34 Template Ref: COEG03-TTR-GENE-QU-CN-TMT-012, Rev- R1, Date: 01-09-2020

 FORMULATED COLUMN DO NOT EDIT

STATISTICS FOR QUALITY DASHBOARD CUMULATIVE ROOT CAUSE ANALYSIS SUMMARY

CUMMULATIVE NO OF NCR DETAILS FOR LEGEND DETAILS REFER TO NCR SHEET 1. Cells highlighted in gray and light gray does not require any input since th
STATUS NOS. ITEM NOS. LEGEND NOS. LEGEND NOS. 2. Input review duration required in the contract for the corresponding doc
TOTAL NCR ISSUED 3 1 0 8 0 3. Cells highlighted in red are formula cell do not edit
NCR CLOSURE DURATION 16
TOTAL NCR OPEN 3 2 0 9 0 DATA INPUTS
TOTAL NCR CLOSED 0 AVE. NO OF DAYS TO CLOSED NO ITEM HAS BEEN 3 0 10 0 3. Encode relevant document information in cells in white background as re
NCR CLOSED
4 0 11 0 4. To insert additional rows together with the formula follow the following;
NO. OF NCR WITH IN 14 DAYS 3 5 0 12 0 Step 1. Select the last full row Step 3.
NO. OF NCR EXCEEDS 14DAYS 0 6 0 13 0 Step 2. Right click- select copy Step 4.
7 0 14 0
FORMULATED COLUMN DO NOT EDIT NCR R
STATUS
ENGINEER/ INCHARGE REASON FOR
NCR HISTORY NCR CURRENT STATUS EXCEEDING 16 DAYS NCR-Major
/Moderate CORRECTIVE ACTION
CORRECTIVE /Minor
PROPOSED APPROVED VERIFICATION OF DATE OF
ACTION CURRENT CONTRACTOR CONSULTANT
Contractor ISSUED CORRECTIVE CORRECTIVE CORRECTIVE ACTION CONSULTANT NO. DAYS OPEN ACTION OWNER CORRECTIVE ACTION
IMPLEMENTATION STATUS SUBMITTED DATE RESPONSE DATE
ACTION ACTION DATE DECISION
DATE

PAGE 4 OF 34 Template Ref: COEG03-TTR-GENE-QU-CN-TMT-012, Rev- R1, Date: 01-09-2020

 USER's GUIDE
FORMULATED CELLS
hlighted in gray and light gray does not require any input since they are formulated cells.
view duration required in the contract for the corresponding documents for cell heighted in beige.

elevant document information in cells in white background as required in the table.

additional rows together with the formula follow the following;
Right click the row below
Select insert copied cell

NCR RESPONSE HISTORY

CORRECTIVE ACTION VERIFICATION & CLOSURE

CONTRACTOR CONSULTANT
REMARKS IMPLEMENTATION VERIFICATION ORIGINATOR REMARKS CLOSING DATE REMARKS
DATE DATE

PAGE 5 OF 34 Template Ref: COEG03-TTR-GENE-QU-CN-TMT-012, Rev- R1, Date: 01-09-2020

 PROJECT NAME: FORMULATED COLUMN DO NOT EDIT USER's GUIDE
CLIENT: CUMULATIVE ROOT CAUSE ANALYSIS SUMMARY FORMULATED CELLS
EMPLOYER: Tata Realty FOR LEGEND DETAILS REFER TO SOR SHEET 1. Cells highlighted in gray and light gray does not require any input since they are formulated cells.
PMC: LEGEND NOS. LEGEND NOS. 2. Input review duration required in the contract for the corresponding documents for cell heighted in beige.
CONSULTANT: 1 0 8 0 3. Cells highlighted in red are formula cell do not edit
CONTRACTOR: 2 0 9 0 DATA INPUTS
0 0 3. Encode relevant document information in cells in white background as required in the table.
SITE OBSERVATION REPORT LOG SHEET
3 10

4 0 11 0 4. To insert additional rows together with the formula follow the following;
DATA DATE 5 0 12 0 Step 1. Select the last full row
SI. SITE OBSERVATION REPORT DETAILS FORMULATED COLUMN DO NOT EDIT SOR RESPONSE HISTORY
NO Month STATUS CLOSER SHEET

SOR HISTORY SOR CURRENT STATUS REASON FOR

EXCEEDING 14 CORRECTIVE ACTION VERIFICATION & CLOSURE
CLOSER SHEET
SOR-REF-NO Contractor DESCRIPTION ORIGINATOR DATE ISSUED DAYS NO.
CURRENT CONTRACTOR
ISSUED ACTION OWNER STATUS SUBMITTED DATE
CORRECTIVE ACTION CLOSING DATE REMARKS

PAGE 6 OF 34 Template Ref: COEG03-TTR-GENE-QU-CN-TMT-014, Rev- R1, Date: 01-09-2020

 LOG OF QUALITY WALK & QUALITY MEETINGS

PROJECT : TRIL IT City

Sr. Quality Walk /

No. Month Quality Meeting Date Atteendees Contractor
 LOG OF QUALITY WALK & QUALITY MEETINGS

PROJECT : TRIL IT City

Major Issues Identified Timeline Status

Remark
LOG OF CONCRETE PRODUCTION
PROJECT :TRIL
Monthly Concrete production

Sr. No. Grade of Concrete

Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23

1.0 M7.5

2.0 M10

3.0 M15 20.0 12.00 153.50 222.50

4.0 M20 42.00 39.50

5.0 M25 706.5 408.0 6.00 33.50 64.00

6.0 M25 spcl

7.0 M30
8.0 M35 38.0
9.0 M40(Nor)
10.0 M40(RBCL - Piling)
11.0 M45
12.0 M50
13.0 M60
Total Qty. 744.50 428.00 18.00 229.00 326.00 0.00
Monthly Concrete production
Cum. Conc.
Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Qty. FY 23-24

0.00

0.00

408.00

81.50

1218.00

0.00

0.00

38.00

0.00

0.00

0.00

0.00

0.00

0.00 0.00 0.00 0.00 0.00 0.00 1745.5

DETAILS OF MATERIAL
PROJECT : : Mikado Realtors Pvt. Ltd/ELECTRONIC HARDWARE IT/ITES-SEZ GURUGRAM

Please enter
Multiple dates
wherever
applicable

MIR NO. (Metrial Date of Date of Material

Sr. No. Month Inspaection Material Rejected
Record) Receipt
T/ITES-SEZ GURUGRAM TPL
Please enter reasons
for each in case of
multiple rejections
of a particular
material

Brand Name Supplier Name

 Standrads Filed
refrence / ITP MTC LTC test
no. report

Quality Description
Type of Material compliance of Material
Status Rejected
 Quantity %
Rejected Quantity UNIT Received Material Reason for Procured Material
(MT/ Sqft / Nos) (MT/ (MT/ Rejected Rejection By Rejection Remarks
Sqft / Nos) Sqft / Nos) By Per Month
 LOG OF MOCK-U
S.N. Name of Activity Date of Mock-up Start Date of Activity
LOG OF MOCK-UP ACTIVITIES
Mock-up carried out by
Location of Mock-up Mock-up Approved By
(Name of Agency)
Remarks
 LOG OF PRE-DISPATCH INS
PROJECT : TRIL IT City

Date of
Sr. Type of
Month Material Description of Material (Including Brand)
No. Material
Inspection
OF PRE-DISPATCH INSPECTION

Total
Rejected
Quantity Material % Material
Quantity Procured
Inspected Inspected Reason for Rejection Rejection
(MT/ By
(MT/ By Per Month
Sqft / Nos)
Sqft / Nos)
Remarks
 Template for Cost of Poor Quality (Indirect cost) :-

S.N. Activity Total Total Total Overall Imperical Ratio Direct Indirect Cost Total Cost Billed % of
Labour Material Equipme Direct of Labour Cost/ Cost Amount for COPQ
Cost Cost nt Cost Cost Overhead cost the month wrt to
( App.) billed
amount

Rs. Rs. Rs Rs. Rs. Rs. Rs. Rs. %

A B C (A+B+C)
1 Aluminium work 0 2.5 0.00 0.00 0.00
2 Door frame 0 2.5 0.00 0.00 0.00
3 External development 0 2.5 0.00 0.00 0.00
4 False ceiling 0 2.5 0.00 0.00 0.00
5 Grinding 0 2.5 0.00 0.00 0.00
6 Housekeeping 0 2.5 0.00 0.00 0.00
7 MEP 0 2.5 0.00 0.00 0.00
8 MS Railing 0 2.5 0.00 0.00 0.00
9 Painting 0 2.5 0.00 0.00 0.00
10 Plaster 0 2.5 0.00 0.00 0.00
11 Protection of finish material 0 2.5 0.00 0.00 0.00
12 Repair work 0 2.5 0.00 0.00 0.00
13 Storage 0 2.5 0.00 0.00 0.00
14 Stone work 0 2.5 0.00 0.00 0.00
15 Tiling 0 2.5 0.00 0.00 0.00
16 Brick Work 0 2.5 0.00 0.00 0.00
17 Waterproofing 0 2.5 0.00 0.00 0.00
18 Concrete 0 2.5 0.00 0.00 0.00

Total 0.00 0.00 0.00 #DIV/0!

Note: There are 2 options to calculate indirect cost
Option-1: Multiply Direct cost with a factor(2.5) to derive indirect cost. (Planning team has given for most of the items, the Factor will be 2.5. The 2.5 factor
is derived based on dividing labour cost / overhead cost). Suppose for a particular item, if we get a factor more or less than 2.5, the project specific derived
factor shall be used. Necessary back-up shall be given for the same. If no data is available, the project may use 2.5 as a standard factor to derive indirect
cost.
Or
Option-2: Use the template given below to derive Indirect cost.

COPQ: INDIRECT COST

(TO BE GIVEN BY THE PROJECT HEAD)

Indirect Cost of Poor Quality

S.No. Heads of Indirect cost
1 Cost of meeting / review
2 Cost of C.O / R.O personnel visit
3 Cost of co-ordination / followups
4 Cost of supervision
5 Cost of consultant visit / vendor visit
6 Cost of delay
7 Cost of non availability of work front to
contractors
8 Cost of idle charges
9 Cost of shifting / transportation of
rejected goods
10 Cost of 'Productivity drop / loss'
11 Cost of inventory
12 Cost of additional precautions
PROJECT : TRIL IT City

Date of
Sr No Month Occurrence Description of rework Location

1 Apr-23
2 Apr-23
3 Apr-23
4 Apr-23
5 Apr-23
6 Apr-23
7 Apr-23
8 Apr-23
9 Apr-23
10 Apr-23
11 Apr-23
12 Apr-23
13 Apr-23
 COPQ Template
DIRECT COST OF COPQ
(Manpower + Supervision + Material + Machineries + Tools Used to make good the identi

ANALYSIS FOR
COST OF
POOR
QUALITY

NC given by Qty of Unit Manpower

Type of
NC Activity Internal / Rework (SqMt/ Required (Man
TPQA Done CuM) days)

Engineers
PQ Template
CT COST OF COPQ
Used to make good the identified defective work to acceptable standard)

Male Female
Supervisors Carpenters Fitters Masons Painter Coolie Coolie

0
0
0
0
0
0
0
0
0
0
0
0
0
0
 A B C

Total Total Cost Cost of

Cost of Material of Equipment Equipmen
Labour Required Material Required t used Remarks

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
 LOG OF MOCK-UP ACTIVITIES

Sr No Name of Activity Date of Mock-up Start Date of Activity Location of Mock-up

K-UP ACTIVITIES

Mock-up carried out by

Mock-up Approved By Remarks
(Name of Agency)
 LOG OF AMOUNT WITH-HELD ON ACCOUNT OF NON-COMPLIANCE TO QUALITY (Over & Above Retention & Security Deposit

Amount with held on Date of releasing

Name of Billed Amount
Sr No Month Date of holding account of Quality the with -held Remarks
Contractor (Rs)
(Rs) amount

1 April.19 RAB-12 TPL 33,991.00

2 May.19
3 June.19 RAB-14 TPL 54,385.00
4 July.19
5 Aug-19
6 Sep-19
7 Oct-19
8 Nov-19
9 Dec-19
10 Jan-20

B.I Dated P.O No / work order no Bill no/Dated Item Item Description QTY Amount

5500016494 dated 12-08-

1 12-Oct-20 RA 14 Civil Works Phase 1B Civil Works Phase 1B 64,961,756.00
2019

4500010984 (New SAP PO

2 29-Oct-20 No. 5500015776) dated RA 05 Painting Works Painting Works 3,652,013.00
07-10-2019

4500009709 (New SAP Po

Plumbing & Fire Fighting Plumbing & Fire
3 29-Oct-20 No. 5500015751) dated RA 16 5,500,993.00
Works Fighting Works
07-01-2019

External EIFS Pillars & External EIFS Pillars &

5500016336 dated 04-07-
4 31-Oct-20 RA 02 Shera Board Jali Works Shera Board Jali Works 5,113,522.61
2020
Phase 1A Phase 1A

4500010527( New SAP Po

Non Fire Rated Metal Non Fire Rated Metal
5 31-Oct-20 No. 5500015768) dt: 25- RA 06 521,855.00
Door Works Door Works
06-2019
 Interior Works of
5500016307 dt: 20-06- Interior Works of Tower
6 2-Nov-20 RA 01 Tower 1 & Security 15,823,199.00
2020 1
Guard office

4500010815 (New SAP PO

7 3-Nov-20 No. 5500015773) dt: 26- RA 11 Façade Works Phase 1A Façade Works Phase 1A 6,725,734.00
Aug-2019

Interior Works of Tower Interior Works of

8 19-Jan-21 5500016914 RA 01
2 Tower 2
2,623,008

9 31-Dec-20 5500016494 RA 14 Civil Works Phase 1B Civil Works Phase 1B

47785281
10 4500010723 landscape(Softscape& landscape(Softscape&
Jan-21 RA 04 Irrigation) Irrigation) 4221737

11 5500015754
Jan-21 RA 21 HVAC works HVAC works 5245610
Tracker for inclusion of Tata Housing Quality Hallmark Criteria in all contracts awarded through projects :

Project Name: TRIL IT City

SN. Month & Year of awarding Type of work (Civil, Name of the Contractor
contract (LOI or LOA) Finishing, MEP)
awarded through projects :

Contract value in Indian Date on which THQH Criteria Remarks

Rs. shared with Contractor
 Detais of Good Practices Implemented
S.N. Date Description of Good Practice Source Details
(Internal / External
Benchmarking)
od Practices Implemented
Details of Benefits Name of the Person Duration of Document or Process
Incurred Who Identfied the Implementation at revised, If any
(Improvement in Best Practice & Team Site in Days/ Months
Product Quality/ involved in
Reduction in Cost/ Implementation
Timely Delivery)