Environmental Models

	B	C	D	E	F	G	H	I
1
2
3	Standard Process Variables	Standard Process Value	Units	Recycled Process Variables	Recycled Process Value	Units	Type
4	Total Distance in the Process	290	Miles	Distance between JH to Wash Tech	51.2	Miles	Variable	Total Distance in the Process
5	Amount of CDW	450000	Tons	Amount of CDW	450000	Tons		Amount of CDW
6	Amount of Material allowed in a Truck	22	Tons	Amount of Material allowed in a Truck	38	Tons
7	Fuel Cost	3.4	$/Gallon	Fuel Cost	3.4	$/Gallon	Constant	Amount of Material allowed in a Truck
8	Truck Mileage	4	Miles/Gallon	Truck Mileage	3.5	Miles/Gallon		Fuel Cost
9				Handling/Tipping	10	$/Ton		Handling/Tipping
10	Tipping/Disposal fee	44	$/Ton					Landfilling and Disposal
11	Rent of Trucks	100	$/hour	Rent of Truck	100	$/hour		Rent of Trucks
12	Speed of trucks with 22 tons loaded	30	Miles/Hour	Speed of trucks with 40 tons loaded	25	Miles/Hour		Truck Speed
13				Distance between Wash Tech to Rock Plan	22.6	Mile		Truck Mileage
14	Total Transportation Cost	44615324.17		Percent of Sand got from Soil	60%		Output	Total Transportation Cost
15								Total Transportation Cost/Ton
16	Total Transportation Cost/Ton	99.14516481	$/Ton	Total Transportation Cost	11825799.34			Total Savings/Ton between 2 methods
17
18	Total Savings/Ton	72.86561073	$/Ton	Total Transportation Cost/Ton	26.27955408	$/Ton
19
20
21	Total Cost of Process	Fuel + Tipping/Disposal + Truck Rent		Total Cost of Process	Fuel1 + Tipping1 + Truck Rent1 + Fuel2 + Truck Rent2 + Tipping2
22		44615324.17			11825799.34
23
24	Trucks carrying heavier loads will consume more fuel to travel the same distance, and they will also typically travel at lower speeds.
25
26
27
28	Sensitivity Analysis
29
30	Standard Process Variables			Recycled Process Variables
31	Total Distance in the Process	0.19		Distance_1	0.19
32	Amount of CDW	0.00		Amount of CDW	0.00
33	Amount of Material allowed in a Truck	-2.40		Amount of Material allowed in a Truck	-0.26
34	Fuel Cost	3.30		Fuel Cost	0.49
35	Truck Mileage	-2.24		Truck Mileage	-0.37
36	Tipping/Disposal	1.00		Handling/Tipping	1.60
37	Rent of Trucks	0.44		Rent of Truck	0.09
38	Speed of trucks with 22 tons loaded	-1.42		Speed of trucks with 40 tons loaded	-0.33
39				Distance_2	0.02
40				Percent of Sand got from Soil	0.16
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
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