High School Grading Project Costs - Calculations

	A	B	C	D	F	G	H	I	J
1	PUSH CREW - dozers
2	Number of dozers			2
3
4	Job No.	Nodes		Volume	Labour	Equipment	Crew	Total Labour ($)	Total Crew ($)
5	Job No.	From	To	Bcm	($/Bm3)	($/Bm3)	($/Bm3)	Total Labour ($)	Total Crew ($)
6	1	D2	D1	6.512	0.42	0.73	1.14	2.71	7.43
7	2	D2	E2	89.11	0.41	0.72	1.13	36.63	100.59
8	3	E1	E2	0.011	0.77	1.34	2.11	0.01	0.02
9	4	E2	F2	124.02	0.41	0.72	1.13	50.93	139.86
10	5	F2	G2	70.363	0.41	0.72	1.13	28.93	79.45
11	6	E3	G2	154.144	1.11	1.95	3.06	171.82	471.84
12	7	E3	H2	15.764	1.47	2.56	4.02	23.10	63.42
13	8	E3	F3	25.809	0.41	0.72	1.13	10.58	29.04
14	9	E4	F3	33.822	0.41	0.72	1.13	13.87	38.10
15	10	E4	G3	287.431	1.11	1.95	3.06	320.46	880.03
16	11	E4	H3	130.863	1.47	2.56	4.03	191.96	527.13
17	12	F4	G4	149.456	0.41	0.72	1.13	61.42	168.66
18	13	F4	H4	71.294	0.76	1.33	2.10	54.40	149.38
19	14	E4	H4	85.766	1.11	1.95	3.06	95.60	262.52
20	15	E5	G5	46.641	0.76	1.33	2.10	35.62	97.81
21	16	E5	H5	311.682	1.12	1.95	3.06	347.54	954.37
22	17	E5	H4	85.766	1.47	2.56	4.03	125.80	345.46
23	18	F5	I5	422.711	1.11	1.95	3.06	471.31	1,294.25
24	19	F6	G6	60.263	0.41	0.72	1.13	24.79	68.07
25	20	F6	H6	369.235	0.76	1.33	2.09	281.63	773.39
26	21	E6	H6	125.385	1.11	1.95	3.06	139.76	383.79
27	22	E6	I6	147.066	1.47	2.56	4.03	215.73	592.42
28	23	F7	G7	88.396	0.41	0.72	1.13	36.29	99.67
29	24	F7	H7	198.351	0.76	1.33	2.10	151.35	415.62
30	25	F7	I7	39.549	1.11	1.95	3.06	44.08	121.04
31	26	F7	I6	128.669	1.47	2.56	4.03	188.74	518.31
32	27	G8	H8	15.689	0.41	0.72	1.13	6.43	17.66
33	28	G8	I6	129.403	1.47	2.56	4.03	189.84	521.33
34	29	F8	I6	132.401	1.82	3.18	5.00	240.86	661.42
35	30	F5	I6	200.003	1.47	2.56	4.03	293.39	805.69
36	31	E5	I6	161.318	1.82	3.18	5.00	293.48	805.92
37	32	I5	J5	214.313	0.41	0.72	1.13	88.07	241.85
38	33	I6	J6	454.347	0.41	0.72	1.13	186.63	512.50
39
40	WASTE CREW 1
41	Number of trucks			8
42	Number of excavators			1
43
44	Job No.	Nodes		Volume	Labour	Equipment	Crew	Total Labour ($)	Total Crew ($)
45	Job No.	From	To	Bcm	($/Bm3)	($/Bm3)	($/Bm3)	Total Labour ($)	Total Crew ($)
46	1	C3	W	4.041	7.38	15.97	23.36	29.84	94.39
47	2	C4	W	39.531	7.39	15.97	23.36	291.94	923.41
48	3	D3	W	459.189	7.39	15.98	23.36	3,391.67	10,728.01
49	4	D4	W	75.261	7.40	16.00	23.39	556.63	1,760.64
50	5	C5	W	55.515	7.39	15.99	23.39	410.44	1,298.25
51	6	D5	W	68.611	7.41	16.02	23.43	508.19	1,607.42
52	7	C6	W	123.286	7.41	16.02	23.42	913.01	2,887.89
53	8	D6	W	82.151	7.41	16.03	23.45	608.96	1,926.17
54	9	D7	W	105.1	7.42	16.05	23.47	779.80	2,466.54
55	10	E7	W	210.156	7.43	16.07	23.50	1,561.33	4,938.55
56	11	D8	W	115.744	7.43	16.07	23.50	859.81	2,719.62
57	12	E8	W	168.863	7.44	16.09	23.53	1,255.98	3,972.73
58	13	F8	W	104.787	7.45	16.11	23.55	780.23	2,467.91
59	14	D9	W	532.81	7.44	16.09	23.53	3,963.43	12,536.54
60	15	E9	W	450.276	7.45	16.11	23.56	3,353.61	10,607.63
61	16	F9	W	47.405	7.45	16.12	23.58	353.35	1,117.67
62
63	WASTE CREW 1
64	Number of trucks			8
65	Number of excavators			1
66
67	Job No.	Nodes		Volume	Labour	Equipment	Crew	Total Labour ($)	Total Crew ($)
68	Job No.	From	To	Bcm	($/Bm3)	($/Bm3)	($/Bm3)	Total Labour ($)	Total Crew ($)
69	1	B6	W	17.636	7.38	15.97	23.35	130.18	411.77
70	2	B7	W	119.303	7.39	15.98	23.37	881.44	2,788.02
71	3	C7	W	193.45	7.40	16.00	23.39	1,430.71	4,525.41
72	4	B8	W	309.262	7.40	16.00	23.39	2,287.06	7,234.09
73	5	C8	W	226.012	7.40	16.01	23.42	1,673.34	5,292.87
74	6	B9	W	779.115	7.40	16.02	23.42	5,768.69	18,246.65
75	7	C9	W	1106.264	7.41	16.03	23.45	8,200.63	25,939.03
76	8	A9	W	4.958	7.41	16.04	23.45	36.76	116.28
77	9	A10	W	24.103	7.43	16.07	23.50	179.06	566.36
78	10	B10	W	175.551	7.41	16.04	23.45	1,301.39	4,116.37
79	11	C10	W	11.651	7.42	16.06	23.48	86.50	273.60
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100