Excel data base.xlsm

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1	Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9	Column10	Column11	Column12	Column13	Column14	Column15	Column16	Column17	Column18	Column19	Column20	Column21	Column22	Column23	Column24	Column25	Column26	Column27	Column28	Column29	Column30	Column31	Column32	Column33	Column34	Column35	Column36

2	Activity ID	Activity Name	Original Duration	Budgeted Total Cost	Physical WTG	Physical Budgeted Units	Resources																						KPIS
3	Testing Project 1		156	$948,945.00	100.00%	1,000,000.00	Resource1		Resource2		Resource3		Resource4		Resource5		Resource6		Resource7		Resource8		Resource9		Resource10		Resource11		KPI 1		KPI 2		KPI 3		KPI 4
4							Masons (Skilled Labour)	QTY	Unskilled Labour	QTY	Steel Fixers (Skilled Labour)	QTY	Electrician	QTY	Plumber	QTY	Carpenter	QTY	HVAC (Skilled Labour)	QTY	Glass & Aluminium (Skilled Labour)	QTY	Metal works (Skilled Labour)	QTY	Plate Compactor	QTY	Excavator/JCB	QTY	Concrete	QTY	Concrete blocks	QTY	Tiles	QTY	Paint	QTY
5	General		8	$54,000.00	5%
6	TP-1-1120	Start of the project	0	$0.00	0.00%	-
7	TP-1-1130	Preliminaries	4		1.67%	16,666.67
8	TP-1-1140	Mobilisation	8	$30,000.00	3.33%	33,333.33
9	Engineering		110	$0.00	5%
10	Submittals		90	$0.00	1%
11	TP-1-1150	Material submittals	90	$0.00	0.38%	3,750.00
12	TP-1-1160	Drawing submittals	75	$0.00	0.31%	3,125.00
13	TP-1-1170	Method statement submittals	75	$0.00	0.31%	3,125.00
14	Approvals		90	$0.00	2%
15	TP-1-1180	Material approvals	90	$0.00	0.75%	7,500.00
16	TP-1-1190	Drawing approvals	75	$0.00	0.63%	6,250.00
17	TP-1-1200	Method statement approvals	75	$0.00	0.63%	6,250.00
19	TP-1-1210	Order and delivery of materials at the site	100	$0.00	2.00%	20,000.00
20	Construction		134	$894,945.00	85%
21	Sub-structure		32	$253,545.00	23%
22	TP-1-1220	Excavation	6	$58,000.00	5.26%	52,613.93			Unskilled Labour	3																	Excavator/JCB	1
23	TP-1-1230	Foundations	10	$145,245.00	13.18%	131,757.08	Masons (Skilled Labour)	3	Unskilled Labour	5	Steel Fixers (Skilled Labour)	4																	Concrete	17
24	TP-1-1240	Backfilling	3	$4,550.00	0.41%	4,127.47			Unskilled Labour	3															Plate Compactor	1	Excavator/JCB	1
25	TP-1-1250	Tie beams	4	$21,750.00	1.97%	19,730.23	Masons (Skilled Labour)	2	Unskilled Labour	4	Steel Fixers (Skilled Labour)	3																	Concrete	14
26	TP-1-1260	Grade slab	3	$24,000.00	2.18%	21,771.28	Masons (Skilled Labour)	2	Unskilled Labour	4	Steel Fixers (Skilled Labour)	4																	Concrete	25
27	Super-structure		40	$225,700.00	20%
28	TP-1-1270	Columns	12	$15,000.00	1.33%	13,291.98	Masons (Skilled Labour)	2	Unskilled Labour	3	Steel Fixers (Skilled Labour)	3																	Concrete	7
29	TP-1-1280	Staircase	10	$13,500.00	1.20%	11,962.78	Masons (Skilled Labour)	1	Unskilled Labour	2	Steel Fixers (Skilled Labour)	2																	Concrete	8
30	TP-1-1290	Beams and slab	28	$179,200.00	15.88%	158,794.86	Masons (Skilled Labour)	4	Unskilled Labour	6	Steel Fixers (Skilled Labour)	5																	Concrete	35
31	TP-1-1380	Other concrete works	8	$18,000.00	1.60%	15,950.38	Masons (Skilled Labour)	2	Unskilled Labour	3	Steel Fixers (Skilled Labour)	2																	Concrete	10
35	TP-1-1070	HVAC	20	$75,000.00	6.38%	63,829.79			Unskilled Labour	4									HVAC (Skilled Labour)	3
36	Masonary works		25	$46,000.00	4%
37	TP-1-1300	External block works	15	$28,000.00	2.43%	24,347.83	Masons (Skilled Labour)	4	Unskilled Labour	4																					Concrete blocks	245
38	TP-1-1310	Internal block works	22	$18,000.00	1.57%	15,652.17	Masons (Skilled Labour)	3	Unskilled Labour	3																					Concrete blocks	180
39	Waterproofing works		57	$46,000.00	4%
40	TP-1-1000	Wet area waterproofing	16	$18,500.00	1.61%	16,086.96	Masons (Skilled Labour)	1	Unskilled Labour	1
41	TP-1-1010	Combo roof waterproofing	24	$27,500.00	2.39%	23,913.04	Masons (Skilled Labour)	2	Unskilled Labour	4
42	Finishes		68	$62,200.00	8%
43	TP-1-1320	Wall finishes	22	$14,500.00	1.86%	18,649.52	Masons (Skilled Labour)	3	Unskilled Labour	3																							Tiles	175
44	TP-1-1330	External painting works	28	$8,500.00	1.09%	10,932.48	Masons (Skilled Labour)	3	Unskilled Labour	3																									Paint	270
45	TP-1-1340	Internal paiting works	16	$6,500.00	0.84%	8,360.13	Masons (Skilled Labour)	3	Unskilled Labour	3																									Paint	480
46	TP-1-1350	Floor tile and other finishes	22	$15,500.00	1.99%	19,935.69	Masons (Skilled Labour)	3	Unskilled Labour	3																							Tiles	145
47	TP-1-1390	Ceiling finishes	18	$17,200.00	2.21%	22,122.19	Masons (Skilled Labour)	3	Unskilled Labour	3
48	Doors and Windows		47	$67,500.00	8%
49	TP-1-1020	Aluminium works	28	$32,500.00	3.85%	38,518.52			Unskilled Labour	2											Glass & Aluminium (Skilled Labour)	4
50	TP-1-1030	Wood works	25	$21,500.00	2.55%	25,481.48			Unskilled Labour	2							Carpenter	3
51	TP-1-1040	Metal works	12	$13,500.00	1.60%	16,000.00			Unskilled Labour	2													Metal works (Skilled Labour)	2
52	External works		125	$53,000.00	6%
53	TP-1-1080	Boundary wall	32	$21,500.00	2.43%	24,339.62	Masons (Skilled Labour)	2	Unskilled Labour	4																					Concrete blocks	140
54	TP-1-1090	Landscaping	10	$8,500.00	0.96%	9,622.64	Masons (Skilled Labour)	1	Unskilled Labour	3
55	TP-1-1100	External services	8	$13,500.00	1.53%	15,283.02	Masons (Skilled Labour)	1	Unskilled Labour	2
56	TP-1-1110	Metal Gates	6	$9,500.00	1.08%	10,754.72			Unskilled Labour	2													Metal works (Skilled Labour)	2
59	TP-1-1370	Handing over	0	$0.00	0.00%	-
60
61
62
63							16666.67
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106