Price Trends FEB 24

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

Sep-23

Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24


Project Name COURTYARD COURTYARD COURTYARD COURTYARD COURTYARD COURTYARD
Material Name Unit Qty Rate Qty Rate Qty Rate Qty Rate Qty Rate Qty Rate
Cement (OPC) MT 544.5 6,200.00 373 7,600.00 866 7,490.07 156 6,800.00 634 6,800.00 736 6,400.06

Oct-23

Project Name COURTYARD


Material Name Unit Qty Rate
Cement (OPC) MT 373 7,600.00
Cement (OPC) Bags
Cement (PPC) Bags 100 350.00
AAC Block -200MM Nos 18,800 88.48
AAC Block -150MM Nos 6,900 66.08
AAC Block -100MM Nos 700 43.68
Solid Block -200MM Nos 940.00 66.08
Solid Block -150MM Nos
Solid Block -100MM Nos 800.00 42.48
River Sand Cft
M Sand Rough Cft 20,871.00 46.20
M Sand Nice Cft

Nov-23

Project Name COURTYARD


Material Name Unit Qty Rate
Cement (OPC) MT 866 7,490.07
Cement (OPC) Bags
Cement (PPC) Bags
AAC Block -200MM Nos
AAC Block -150MM Nos
AAC Block -100MM Nos
Solid Block -200MM Nos
Solid Block -150MM Nos
Solid Block -100MM Nos
River Sand Cft
M Sand Rough Cft 31,983.00 45.50
M Sand Nice Cft

Dec-23

Project Name COURTYARD


Material Name Unit Qty Rate
Cement (OPC) MT 156 6,800.00
Cement (OPC) Bags 300 331.67
Cement (PPC) Bags
AAC Block -200MM Nos 26,800 88.48
AAC Block -150MM Nos 10,100 66.08
AAC Block -100MM Nos 1,500 43.68
Solid Block -200MM Nos 5,940.00 64.9
Solid Block -150MM Nos 2800 53.10
Solid Block -100MM Nos 1,130.00 41.3
River Sand Cft
M Sand Rough Cft 36,481.00 45.15
M Sand Nice Cft

Jan-24

Project Name COURTYARD


Material Name Unit Qty Rate
Cement (OPC) MT 634 6,800.00
Cement (OPC) Bags
Cement (PPC) Bags 1,000 325.00
AAC Block -200MM Nos 19,800 88.48
AAC Block -150MM Nos 6,300 66.08
AAC Block -100MM Nos
Solid Block -200MM Nos 1,880.00 64.9
Solid Block -150MM Nos 500 53.10
Solid Block -100MM Nos 1,748.00 41.3
River Sand Cft
M Sand Rough Cft 38,108.00 45.15
M Sand Nice Cft

Feb-24

Project Name COURTYARD


Material Name Unit Qty Rate
Cement (OPC) MT 736 6,400.06
Cement (OPC) Bags
Cement (PPC) Bags
AAC Block -200MM Nos 54,600 88.48
AAC Block -150MM Nos 25,100 66.08
AAC Block -100MM Nos 5,500 43.68
Solid Block -200MM Nos
Solid Block -150MM Nos
Solid Block -100MM Nos
River Sand Cft
M Sand Rough Cft
M Sand Nice Cft
Month Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24
Project Name COURTYARD COURTYARD COURTYARD COURTYARD COURTYARD COURTYARD
Material Name Qty Rate Qty Rate Qty Rate Qty Rate Qty Rate Qty Rate
8mm Fe 550 Steel 50.84 52,950 73.64 51,900 38.71 49,400 77.70 49,700 65.16 48,600 116 48,200
10mm Fe 550 Steel 12.43 52,250 0.00 50,400 4.25 48,700 8.68 48,700 7.02 47,600 19.4 47,500
12mm Fe 550 Steel 14.03 51,750 62.60 50,400 97.83 48,200 54.54 48,200 25.60 47,100 59.5 47,000
16mm Fe 550 Steel 17.18 51,750 33.13 50,400 48,200 45.17 48,200 25.60 47,100 43.4 47,000
20mm Fe 550 Steel 21.34 51,750 6.08 50,400 48,200 17.22 48,200 12.80 47,100 15.8 47,000
7.31 48,200
Sub Total 115.82 175.45 140.79 210.62 136.17 254.09

Oct-23
Project Name
Material Name
8mm Fe 550 Steel
10mm Fe 550 Steel
12mm Fe 550 Steel
16mm Fe 550 Steel
20mm Fe 550 Steel
Sub Total

Nov-23
Project Name
Material Name
8mm Fe 550 Steel
10mm Fe 550 Steel
12mm Fe 550 Steel
16mm Fe 550 Steel
20mm Fe 550 Steel
Sub Total

Dec-23
Project Name
Material Name
8mm Fe 550 Steel
10mm Fe 550 Steel
12mm Fe 550 Steel
16mm Fe 550 Steel
20mm Fe 550 Steel
25mm Fe 550 Steel
Sub Total

Jan-24
Project Name
Material Name
8mm Fe 550 Steel
10mm Fe 550 Steel
12mm Fe 550 Steel
16mm Fe 550 Steel
20mm Fe 550 Steel
25mm Fe 550 Steel
Sub Total

Project Name
Material Name
8mm Fe 550 Steel ###
10mm Fe 550 Steel ###
12mm Fe 550 Steel ###
16mm Fe 550 Steel ###
20mm Fe 550 Steel ###
25mm Fe 550 Steel -
Sub Total ###
PO/WO
S.No Date PO/WO Manual /ERP Project Sub Project Vendor Name Details Catergory UOM QTY Ex GST Rate GST % Total
Number
PO Expiry
Payment Terms Advance% Total VAR Value
Date
1st Payment on
or Before
PO/WO Manual /
S.No Date PO/WO Project Sub Project
Number ERP

10/11/2023 PO PO-107A ERP COURTYARD TOWER-2


37 10/11/2023 PO PO-107A ERP COURTYARD TOWER-2
10/11/2023 PO PO-107A ERP COURTYARD TOWER-2
40 10/11/2023 PO PO-112 ERP COURTYARD TOWER-1 & 3
62 10/16/2023 PO PO-118 ERP COURTYARD TOWER- 1 & 3
10/18/2023 PO PO-121 ERP COURTYARD TOWER-1, 2 & 3
70 10/18/2023 PO PO-121 ERP COURTYARD TOWER-1, 2 & 3
10/18/2023 PO PO-121 ERP COURTYARD TOWER-1, 2 & 3
72 10/18/2023 PO PO-112A ERP COURTYARD TOWER-1 & 3
88 10/21/2023 PO PO-124 ERP COURTYARD TOWER-1&2
Vendor Name Details Catergory UOM

Sumangala Steel Pvt Ltd 12mm Fe 550 Steel A MT


Sumangala Steel Pvt Ltd 16mm Fe 550 Steel A MT
Sumangala Steel Pvt Ltd 20mm Fe 550 Steel A MT
The India Cements Limited Cement OPC A MT
The India Cements Limited Cement OPC A MT
Suryadev Alloys & power Pvt Lt 8mm Fe 550 Steel A MT
Suryadev Alloys & power Pvt Lt 12mm Fe 550 Steel A MT
Suryadev Alloys & power Pvt Lt 16mm Fe 550 Steel A MT
The India Cements Limited Cement OPC A MT
The India Cements Limited Cement OPC A MT
Advance
QTY Ex GST Rate GST % Total Payment Terms
%

19.87 51,271.20 18% 1,202,135.32 100% payable against delivery 100%


16.15 51,271.20 18% 977,075.26
6.08 51,271.20 18% 367,840.10
90.00 5,937.50 28% 684,000.00 100% advance along with PO 100%
160.00 5,937.50 28% 1,216,000.00 100% advance along with PO 100%
73.64 51,900.00 18% 4,510,105.85 100% advance against delivery 100%
42.73 50,400.00 18% 2,541,298.03
16.98 50,400.00 18% 1,009,656.14
33.02 5,937.50 28% 250,952.00 100% advance along with PO 100%
90.00 5,937.50 28% 684,000.00 100% advance along with PO 100%
Total VAR PO Expiry
Value Date

1,202,135.32

684,000.00
1,216,000.00
4,510,105.85

250,952.00
684,000.00
PO/WO
S.No Date PO/WO Manual /ERP Project Sub Project
Number

3 11/1/2023 PO PO-132 ERP COURTYARD TOWER-1


6 11/2/2023 PO PO-118A ERP COURTYARD TOWER-1&3
38 11/8/2023 PO PO-136 ERP COURTYARD TOWER-1,2&3
44 11/10/2023 PO PO-135 ERP COURTYARD TOWER-1
66 11/18/2023 PO PO-139 ERP COURTYARD TOWER-1,2&3
11/18/2023 PO PO-139 ERP COURTYARD TOWER-1,2&3
11/18/2023 PO PO-139 ERP COURTYARD TOWER-1,2&3
67 11/18/2023 PO PO-140 ERP COURTYARD TOWER-3
112 11/27/2023 PO PO-136 ERP COURTYARD TOWER-1,2&3
121 11/28/2023 PO PO-143 ERP COURTYARD Tower-2&3
Vendor Name Details Catergory UOM

The India Cements Limited Cement OPC A MT


The India Cements Limited Cement OPC A MT
The India Cements Limited Cement OPC A MT
The India Cements Limited Cement OPC A MT
Sumangala Steel Pvt Ltd 08mm Dia Steel A MT
Sumangala Steel Pvt Ltd 10mm Dia Steel A MT
Sumangala Steel Pvt Ltd 12-25mm Dia Steel A MT
The India Cements Limited Cement OPC A MT
The India Cements Limited Cement OPC A MT
The India Cements Limited Cement OPC A MT
QTY Ex GST Rate GST % Total Payment Terms

90 6,300.00 28% 725,760.00 100% Advance along with PO


2.96 5,937.50 28% 22,496.00 100% Advance along with PO
210 6,100.00 28% 1,639,680.00 100% Advance along with PO
40.88 6,300.00 28% 329,656.32 100% Advance along with PO
38.71 49,400.00 18% 2,256,483.32 100% payment against delivery
4.25 48,700.00 18% 244,230.50
97.828 48,200.00 18% 5,564,065.33
213.37 5,859.38 28% 1,600,276.37 100% Advance along with PO
8.48 6,100.00 28% 66,211.84 100% Advance along with PO
300 5,468.75 28% 2,100,000.00 100% Advance along with PO
1st
Advance Total VAR PO Expiry Payment
% Value Date on or
Before
100% 725,760.00
100% 1,215,999.00
100% 1,639,680.00
100% 329,656.32
100% 2,256,483.32

100% 1,600,276.37
100% 66,211.84
100% 2,100,000.00
PO/WO
S.No Date PO/WO Manual /ERP Project
Number
7 12/6/2023 PO PO-147 ERP COURTYARD
12 12/7/2023 WO WO-66 ERP COURTYARD
13 12/7/2023 WO WO-62A ERP COURTYARD
14 12/7/2023 WO WO-03A ERP COURTYARD
30 12/10/2023 PO PO-148 ERP COURTYARD
31 12/10/2023 PO PO-148 ERP COURTYARD
42 12/12/2023 PO PO-149 ERP COURTYARD
43 12/12/2023 PO PO-149 ERP COURTYARD
49 12/14/2023 WO WO-67 ERP COURTYARD
69 12/15/2023 PO PO-150 ERP COURTYARD
88 12/18/2023 WO WO-37 ERP COURTYARD
97 12/18/2023 PO PO-155 ERP COURTYARD
98 12/18/2023 PO PO-155 ERP COURTYARD
99 12/19/2023 PO PO-153 ERP COURTYARD
100 12/19/2023 PO PO-153 ERP COURTYARD
101 12/19/2023 PO PO-154 ERP COURTYARD
102 12/19/2023 PO PO-154 ERP COURTYARD
103 12/19/2023 PO PO-156 ERP COURTYARD
104 12/19/2023 PO PO-156 ERP COURTYARD
105 12/19/2023 PO PO-156 ERP COURTYARD
113 12/20/2023 PO PO-157 ERP COURTYARD
114 12/20/2023 PO PO-157 ERP COURTYARD
115 12/20/2023 PO PO-158 ERP COURTYARD
116 12/20/2023 PO PO-158 ERP COURTYARD
120 12/21/2023 WO WO-68 ERP COURTYARD
121 12/21/2023 WO WO-69 ERP COURTYARD
131 12/23/2023 PO PO-160 ERP COURTYARD
132 12/23/2023 PO PO-160 ERP COURTYARD
133 12/23/2023 PO PO-160 ERP COURTYARD
134 12/23/2023 PO PO-161 ERP COURTYARD
135 12/23/2023 PO PO-161 ERP COURTYARD
136 12/23/2023 PO PO-161 ERP COURTYARD
137 12/26/2023 PO PO-159 ERP COURTYARD
138 12/26/2023 PO PO-159 ERP COURTYARD
157 12/27/2023 PO PO-151 ERP COURTYARD
158 12/27/2023 WO WO-001 Manual COURTYARD
163 12/28/2023 PO PO-163 ERP COURTYARD
164 12/28/2023 WO WO-54D ERP COURTYARD
167 12/28/2023 PO PO-169 ERP COURTYARD
168 12/28/2023 PO PO-166 ERP COURTYARD
169 12/28/2023 PO PO-165 ERP COURTYARD
170 12/28/2023 PO PO-165 ERP COURTYARD
172 12/28/2023 PO PO-168 ERP COURTYARD
173 12/28/2023 PO PO-168 ERP COURTYARD
174 12/28/2023 PO PO-169 ERP COURTYARD
175 12/28/2023 WO WO-01 Manual COURTYARD
179 12/29/2023 PO PO-170 ERP COURTYARD
180 12/29/2023 PO PO-164 ERP COURTYARD
181 12/29/2023 PO PO-164 ERP COURTYARD
182 12/29/2023 PO PO-164 ERP COURTYARD
Sub Project Vendor Name Details

TOWER-3 Jayemmyes Cement PPC


COURTYARD Siva.D Hiring of JCB
COURTYARD Murugan Infrastructure LLP Excavation & Back filling quantity
TOWER-2 Murugan Infrastructure LLP Excavation & Back filling quantity
TOWER-1,2&3 Nitin Wires and Meshes Pvt ltd MS Binding wire
TOWER-1,2&3 Nitin Wires and Meshes Pvt ltd Transportation Charges
TOWER-3 Live Construction Solutions Supply of Non-Shrink grouting chemical
TOWER-3 Live Construction Solutions Transportation Charges
COURTYARD Big fox Engineering Pvt ltd CCTV repair work
General store materials (flexible cable, mccb
COURTYARD Kothari Electricals
etc.,)
TOWER-1 M.Gangamani Hiring of JCB & Tipper
TOWER-1,2&3 Suryadev Alloys Power Pvt Ltd Supply of Steel
TOWER-1,2&3 Suryadev Alloys Power Pvt Ltd Transportation Charges
Sree Maruti Chemicals & Interior
COURTYARD Lock fix
Products
Sree Maruti Chemicals & Interior
COURTYARD Transportation Charges
Products
COURTYARD Sakaria Packaging Inc Hessain cloth
COURTYARD Sakaria Packaging Inc Transportation Charges
COURTYARD MM Concrete 40mm Concrete cover blocks
COURTYARD MM Concrete 25mm Concrete cover blocks
COURTYARD MM Concrete 20mm Concrete cover blocks
COURTYARD Nitin wirenetting india Pvt Ltd GI Mesh
COURTYARD Nitin wirenetting india Pvt Ltd Transportation Charges
COURTYARD Om Shanmuga Cement works Precast Post for Compound wall
COURTYARD Om Shanmuga Cement works Transportation Charges
COURTYARD Murugan Electrical works Calibration and servicing of CP18 batching plant
COURTYARD Tech Civil Material testing laboratory ptesting of concrete cubes, water
TOWER-1,2&3 Sri Venkateswara & Co M Sand Rough
TOWER-1,2&3 Sri Venkateswara & Co 20mm Blue Metal
TOWER-1,2&3 Sri Venkateswara & Co 12mm Blue Metal
TOWER-1,2&3 Kunal Metal M Sand Rough
TOWER-1,2&3 Kunal Metal 20mm Blue Metal
TOWER-1,2&3 Kunal Metal 12mm Blue Metal
TOWER-1,2&3 RS Concrete Blocks 200mm Solid blocks
TOWER-1,2&3 RS Concrete Blocks 100mm Solid blocks
COURTYARD BPCL Fleet Card Diesel
COURTYARD Retna facility service Security service
COURTYARD Eswari Traders Cement PPC
COURTYARD M.Gangamani Hiring charges for JCB for batching plant for additional hours
COURTYARD Sastha Build Tech Joint mortar
COURTYARD Concrete service engineering works Batching plant spares
COURTYARD RS Aercon Blocks 200mm AAC Blocks
COURTYARD RS Aercon Blocks 150mm AAC Blocks
COURTYARD Oryx hardware & Electricals Supply of General store materials
COURTYARD Oryx hardware & Electricals Transportation Charges
Supply of Vibrator Needle Accessories & Mud
COURTYARD Raj Engineering and Vibrators
Pump
COURTYARD Yash Scientific Corporation Repair, Service & Recalibration of CTM
TOWER-3 Standard Building Industries 150mm Solid blocks
TOWER-1 & 3 Kamlesh Greencrete Pvt Ltd 200mm AAC Blocks
TOWER-1 & 3 Kamlesh Greencrete Pvt Ltd 150mm AAC Blocks
TOWER-1 & 3 Kamlesh Greencrete Pvt Ltd 100mm AAC Blocks
Catergory UOM QTY Ex GST Rate GST % Total

A Bags 100 261.72 28% 33,500.16


LS 1 662,500.00 0% 662,500.00
LS 1 159,250.00 18% 187,915.00
LS 1 252,001.90 18% 297,362.24
A Kgs 3000 62.00 18% 219,480.00
A LS 1 2,000.00 18% 2,360.00
B Kgs 480 15.54 18% 8,801.86
B LS 1 960.00 18% 1,132.80
LS 1 21,302.00 18% 25,136.36
C LS 1 44,975.00 18% 53,070.50
LS 1 51,500.00 0% 51,500.00
A LS 1 10,272,382.00 18% 12,121,410.76
A LS 1 12,116.45 0% 12,116.45
B LS 1 12,600.00 18% 14,868.00
B LS 1 1,000.00 18% 1,180.00
C LS 1 150,000.00 5% 157,500.00
C LS 1 2,000.00 0% 2,000.00
A Nos 35000 0.80 18% 33,040.00
A Nos 15000 1.20 18% 21,240.00
A Nos 26000 0.80 18% 24,544.00
C Roll 2 4,000.00 18% 9,440.00
C LS 1 1,000.00 18% 1,180.00
C Nos 80 340.00 18% 32,096.00
C LS 1 2,500.00 18% 2,950.00
LS 1 25,000.00 0% 25,000.00
LS 1 21,350.00 18% 25,193.00
A Cft 18241 43.00 5% 823,581.15
A Cft 21752 39.00 5% 890,744.40
A Cft 12400 39.00 5% 507,780.00
A Cft 18240 43.00 5% 823,536.00
A Cft 21753 39.00 5% 890,785.35
A Cft 12401 39.00 5% 507,820.95
A Nos 5940 55.00 18% 385,506.00
A Nos 1130 35.00 18% 46,669.00
C Liters 5400 94.23 0% 508,842.00
LS 1 2,064,000.00 18% 2,435,520.00
A Bags 200 257.81 28% 66,000.00
nt for additional hours LS 1 408,125.00 0% 408,125.00
A Bags 320 400.00 18% 151,040.00
B LS 1 23,520.00 18% 27,753.60
A Nos 14800 79.00 12% 1,309,504.00
A Nos 3800 59.00 12% 251,104.00
C LS 1 124,944.00 18% 147,433.92
C LS 1 2,700.00 18% 3,186.00
B LS 1 31,719.00 18% 37,428.42
LS 1 23,000.00 18% 27,140.00
A Nos 2800 45.00 18% 148,680.00
A Nos 12000 79.00 12% 1,061,760.00
A Nos 6300 59.00 12% 416,304.00
A Nos 1500 39.00 12% 65,520.00
1st
Advance Total PO Expiry
Payment Terms Payment
% VAR Date on or
Value
Before
30 days from invoice date
30 days from submission of bill

20 days from invoice date/supply

100% payment against delivery 100%

100% Advance along with PO 100%

30 days from date of supply / invoice

30 days from date of supply / invoice

15 days from date of supply / invoice

20 days from date of supply / invoice

100% Advance along with PO 100%

100% Advance along with WO 100%


1 week from invoice date
30 days from invoice date

30 days from date of supply / invoice


100% Advance along with PO 100%
10 days from submission of bill
30 days from date of supply / invoice
30 days from date of submission of bill
100% Advance along with PO 100%
100% payment against delivery 100%
30 days from date of submission of bill

30 days from date of supply / invoice

100% payment against delivery 100%


100% payment against completion of work 100%
30 days from date of supply / invoice
100% Advance along with PO 100%
PO/ PO/WO Manual
S.No Date Project Sub Project
WO Number /ERP

65 1/10/2024 PO PO-171 ERP Courtyard Tower-1,2

106 1/20/2024 PO PO-180 ERP Courtyard Tower-1,2 & 3


107 1/20/2024 PO PO-180 ERP Courtyard Tower-1,2 & 3
108 1/20/2024 PO PO-180 ERP Courtyard Tower-1,2 & 3

138 1/24/2024 PO PO-185 ERP Courtyard Tower-2&3


Catergo
Vendor Name Details UOM QTY Ex GST Rate GST %
ry

The India Cements Limited Cement OPC A MT 300 5,312.50 28%

Pushpit Steel Pvt Ltd 8mm dia Steel A MT 65.164 48,600.00 18%
Pushpit Steel Pvt Ltd 10mm dia Steel A MT 7.02 47,600.00 18%
Pushpit Steel Pvt Ltd 12mm to 20mm dia Steel A MT 63.989 47,100.00 18%

The India Cements Limited Cement OPC A MT 334.32 5,312.50 28%


1st
Total
Advance PO Expiry Payment
Total Payment Terms VAR
% Date on or
Value
Before

2,040,000.00 100% Advance along with PO 100% 2040000

3,737,025.07 100% Advance along with PO 100% 3737025


394,299.36 0
3,556,380.64 0

2,273,376.00 100% Advance along with PO 100% 2273376


Sep-23
Project Name COURTYARD
Material Name Qty Rate
8mm Fe 550 Steel 50.84 52,950.00
10mm Fe 550 Steel 12.43 52,250.00
12mm Fe 550 Steel 14.03 51,750.00
16mm Fe 550 Steel 17.18 51,750.00
20mm Fe 550 Steel 21.34 51,750.00
Sub Total 115.82

Oct-23
Project Name COURTYARD
Material Name Qty Rate
8mm Fe 550 Steel 73.64 51,900.00
10mm Fe 550 Steel 0.00 50,400.00
12mm Fe 550 Steel 62.60 50,400.00
16mm Fe 550 Steel 33.13 50,400.00
20mm Fe 550 Steel 6.08 50,400.00
Sub Total 175.45

Nov-23
Project Name COURTYARD
Material Name Qty Rate
8mm Fe 550 Steel 38.71 57,283.14
10mm Fe 550 Steel 4.25 57,283.14
12mm Fe 550 Steel 97.83 57,283.14
16mm Fe 550 Steel 57,283.14
20mm Fe 550 Steel 57,283.14
Sub Total 140.79

Dec-23
Project Name COURTYARD
Material Name Qty Rate
8mm Fe 550 Steel 77.70 49,700.00
10mm Fe 550 Steel 8.68 48,700.00
12mm Fe 550 Steel 54.54 48,200.00
16mm Fe 550 Steel 45.17 48,200.00
20mm Fe 550 Steel 17.22 48,200.00
25mm Fe 550 Steel 7.31 48,200.00
Sub Total 132.92

Jan-24
Project Name COURTYARD
Material Name Qty Rate
8mm Fe 550 Steel 65.16 48,600.00
10mm Fe 550 Steel 7.02 47,600.00
12mm Fe 550 Steel 25.60 47,100.00
16mm Fe 550 Steel 25.60 47,100.00
20mm Fe 550 Steel 12.80 47,100.00
25mm Fe 550 Steel
Sub Total 136.17

Feb-24
Project Name COURTYARD
Material Name Qty Rate
8mm Fe 550 Steel 116 48,200.00
10mm Fe 550 Steel 19.4 47,500.00
12mm Fe 550 Steel 59.5 47,000.00
16mm Fe 550 Steel 43.4 47,000.00
20mm Fe 550 Steel 15.8 47,000.00
25mm Fe 550 Steel
Sub Total 254.09
PO/WO Manual /
S.No Date PO/WO Project Sub Project
Number ERP
48 2/9/2024 PO PO-196 ERP Courtyard Tower-1,3
65 2/12/2024 PO PO-202 ERP Courtyard Courtyard
66 2/12/2024 PO PO-202 ERP Courtyard Courtyard
67 2/12/2024 PO PO-202 ERP Courtyard Courtyard
186 2/27/2024 PO PO-213 ERP Courtyard Tower-3
Vendor Name

The India Cement Ltd


Sumangala steel pvt ltd
Sumangala steel pvt ltd
Sumangala steel pvt ltd
The India Cement Ltd
Details Catergory UOM

Cement OPC A MT
8mm dia Steel A MT
10mm dia Steel A MT
12mm to 20mm dia Steel A MT
Cement OPC A MT
QTY Ex GST Rate GST % Total Payment Terms

407.95 5,156.25 28% 2,692,470.00 100% Advance along with PO


116.01 48,200.00 18% 6,598,184.76 100% Advance along with PO
19.4 47,500.00 18% 1,087,370.00
118.68 47,000.00 18% 6,581,992.80
328.35 4,843.75 28% 2,035,770.00 100% Advance along with PO
Total VAR 1st Payment on or
Advance% PO Expiry Date
Value Before
100% 2692470
100% 6598184.76
0
0
100% 2035770

`
Sep-23

Project Name SIGNATURE ADDRESS COURTYARD ADORNIA


Material Name Unit Qty Rate Qty Rate Qty Rate Qty Rate
Cement (OPC) MT 544.5 6,200.00
Cement (PPC) Bags 4,900 295.00 1200 295.00
AAC Block -200MM Nos 14,650 91.00 30000 89.60
AAC Block -150MM Nos 1,800 68.25 740 67.20
AAC Block -100MM Nos 5,800 45.51 15968 44.80
Solid Block -200MM Nos 10,000 63.72
Solid Block -150MM Nos 1000 51.92
Solid Block -100MM Nos 5,000 40.12
River Sand Cft
M Sand Rough Cft 34105 47.26 50885 46.14
M Sand Nice Cft 11498 55.64 1500 56.87 3027 56.63

Oct-23

Project Name SIGNATURE ADDRESS COURTYARD ADORNIA


Material Name Unit Qty Rate Qty Rate Qty Rate Qty Rate
Cement (OPC) MT 373 7,600.00
Cement (OPC) Bags 1,040 350.00 2,760 367.39
Cement (PPC) Bags 1,800 340.00 2,100 340.00 100 350.00 200.00 345
AAC Block -200MM Nos 15,300 88.48 18,800 88.48
AAC Block -150MM Nos 200 66.08 6,900 66.08
AAC Block -100MM Nos 5,100 43.68 700 43.68
Solid Block -200MM Nos 15,400 66.05 940.00 66.08 1,200.00 66.08
Solid Block -150MM Nos 5,000 42.48
Solid Block -100MM Nos 7,000 45.85 800.00 42.48 665.00 54.28
River Sand Cft
M Sand Rough Cft 5,600 44.33 34,290 45.62 20,871.00 46.20
M Sand Nice Cft 5,000 54.60 10,340 55.34

Nov-23

Project Name SIGNATURE ADDRESS COURTYARD ADORNIA


Material Name Unit Qty Rate Qty Rate Qty Rate Qty Rate
Cement (OPC) MT 866 7,490.07
Cement (OPC) Bags 3,060 342.65 1,960.00 356.12
Cement (PPC) Bags 3,820 316.47 1,500.00 340.00 100.00 335.00
AAC Block -200MM Nos 5,000 88.48 12,500.00 88.48
AAC Block -150MM Nos 400.00 54.88
AAC Block -100MM Nos 4,000.00 47.50
Solid Block -200MM Nos 5,000 88.48 30950 66.08
Solid Block -150MM Nos
Solid Block -100MM Nos 10210 42.48
River Sand Cft
M Sand Rough Cft 21,456 46.26 16,188.00 44.34 31,983.00 45.50 1565 46.20
M Sand Nice Cft 10,032 59.06 14,533.00 55.05 431.485 56.70

Dec-23

Project Name SIGNATURE ADDRESS COURTYARD ADORNIA


Material Name Unit Qty Rate Qty Rate Qty Rate Qty Rate
Cement (OPC) MT 156 6,800.00
Cement (OPC) Bags 1,760.00 350.00 300 331.67
Cement (PPC) Bags 1,200 330.00
AAC Block -200MM Nos 9,800 88.48 26,800 88.48
AAC Block -150MM Nos 1,000 66.08 10,100 66.08
AAC Block -100MM Nos 9,800 43.68 1,500 43.68
Solid Block -200MM Nos 3,000 64.90 5,940.00 64.9
Solid Block -150MM Nos 500 53.10 2800 53.10
Solid Block -100MM Nos 6,000 41.3 1,130.00 41.3
River Sand Cft
M Sand Rough Cft 34,626 44.10 174.00 44.10 36,481.00 45.15 1836.49 45.15
M Sand Nice Cft 17,350 54.60

Jan-24

Project Name SIGNATURE ADDRESS COURTYARD ADORNIA


Material Name Unit Qty Rate Qty Rate Qty Rate Qty Rate
Cement (OPC) MT 634 6,800.00
Cement (OPC) Bags 1,240 350.00 4,020.00 351.49
Cement (PPC) Bags 1,200 325.00 3,000.00 325.00 1,000 325.00
AAC Block -200MM Nos 10,410 88.48 19,800 88.48
AAC Block -150MM Nos 1,000 66.08 6,300 66.08
AAC Block -100MM Nos 10,124 43.68 5,000.00 41.30
Solid Block -200MM Nos 1,880.00 64.9
Solid Block -150MM Nos 9,844 53.10 500 53.10
Solid Block -100MM Nos 1,748.00 41.3
River Sand Cft 2000 89.25
M Sand Rough Cft 9,829 49.73 24,000.00 44.10 38,108.00 45.15 1.00 590.00
M Sand Nice Cft 6,672 44.10 8,348.00 54.60

Feb-24

Project Name SIGNATURE ADDRESS COURTYARD ADORNIA


Material Name Unit Qty Rate Qty Rate Qty Rate Qty Rate
Cement (OPC) MT 736 6,400.06
Cement (OPC) Bags
Cement (PPC) Bags 2,000 310.00
AAC Block -200MM Nos 17,600.00 88.48 54,600 88.48
AAC Block -150MM Nos 25,100 66.08
AAC Block -100MM Nos 5,300.00 43.68 5,500 43.68
Solid Block -200MM Nos 3600 64.9
Solid Block -150MM Nos
Solid Block -100MM Nos
River Sand Cft
M Sand Rough Cft 21,690.00 44.10
M Sand Nice Cft 9,630.00 54.60
Minutes of Meeting – Procurement MIS – 15.12.2023
S No Requirement

1 There should be no pending indents from Feb 24

Usage of the indented material at site to be


2
checked. Mr. Sasi
Cost Control slide to be added in MIS as per
3
Market Trends Analysis
Monthly requirements should be forecasted (for
4
new budgets)
Close (remove) all indents which are not
5
required now

6 Accelerate ERP Adoption for all sites

Clear all the pending indents in the excel before


7
we migrate to ERP

To restrict advance payments to the extent


8
possible

Get the rates of the items for 30 days credit


9
period

Stock value at each site should be presented in


10
MIS
Start Price Charts, advance charts for PO of A&B
11 items using last 4 months data – observe trends –
present analysis
Make a procurement plan for Jan 2024 and
12
present
Week wise breakup of what will be purchased for
A
each site
Non price sensitive items – increase to 3 months
B
at a time
C Packages go up to 50-60 villas at a time

D Non planned procurement requires ED approval

High wastage and low value items – give it to


E
contractor. Present specific items plan
t MIS – 15.12.2023
Status

As per the site requirements, we have closed all crucial indents as of right now (included the file).

We'll add to the next Month MIS report.

We'll add to the next Month MIS report.

We'll finish the upcoming projects.

Streamline right now

the Signature and the Address site ERP


Implemented. Shortclose the PO shortly updated in
ERP

The ERP upload process signature projects will begin.


Following that, we will begin work on the Address
site.

For most of the vendors, with the exception of basic


supplies like steel and cement, we have initiated the
process for upcoming months

For most of the vendors, with the exception of basic


supplies like steel and cement, we have initiated the
process for upcoming months

We'll add to the next Month MIS report.

Major item(A Category) report this months enclosed

We'll add to the next Month MIS report.

We'll add to the next Month MIS report.

We'll add to the next Month MIS report.

We've started

We've started

We've started
SI NO KEY GOALS

Budget Preparation and Standarization report


1
(LAYOUTS/VILLAS/MSB/etc)

2 Procurement Policy ,Procedures and Schedules

3 Strengthening quality assurance processes (MATERIALS)

4 All processes & Reports through ERP

5 Robust planning process for procurement

6 Vendor KYC & Rating Mechanism

7 Minimize the cycle time for processing bills


Value engineering can cut the project budget by upto 2% for
8
our next project.
DEFINITION

* Collect the drawinfg and input from Design team


* Check old data like earlier project completion or ongoing
*Qty take off
*Market Analaysis and projection
*detailed Rate Analaysis

*Perform market testing.


*Develop documentation and detailed specification.
*Supplier selection to participate in the tender process.
*Tender or Quote evaluation, and validation.
*Order award and implementation.
*Stock yard,Storage space and receipts.
*Vendor or Contract performance and improvement.
* Receive Invoice and Process Payment
* Audit of the Stock and payment on Quarter basis.
*Improving supplier performance (to improve supplier performance, organizations can establish
stronger relationships with suppliers, resulting in better quality products and services)
*Delivering stakeholder satisfaction (deliver stakeholder satisfaction, organizations can meet the
expectations of internal and external stakeholders)

to strengthen quality assurance processes, organizations can ensure that the goods and services
they procure meet the highest standards.

*Indent Tracking Reports


*Budget Vs Actual reports
* Bill Tracking reports
*Stock value
*Cost Saving Reports

robust procurement strategy is important in managing uncertainties and risks in the


procurement process

*Know Your Customer (KYC) is a legal requirement for financial institutions to know who their
customers are before they work with them.
*Vendor ratings are a process in which suppliers are assigned status or a title depending on
several parameters. For example, various factors like price, quality of goods delivered, credibility,
delivery time, and other mixed variables affect the ratings.

reduce late payments, minimize paperwork,Time line for advance


payment/Materials/CONTRACTORS and make your construction billing process more efficient
(ERP system)
The value of an item is defined as the most cost-effective way of producing an item without
taking away
TIME LINE

May-24

Jun-24

Jun-24

Jun-24

Jul-24

Aug-24

Jul-24
Mar-25

You might also like