clarketaylor_LATE_1222906_51191311_Team 9 Supplement_Cost_DCF Silvopasture Calculation Detail.xlsx

	B	C	D	E	F	H	J	K
1
2	Cost Components	Min	Mean	Max	Source
3	Seedlings	$ 18.00	$ 110.67	$ 286.68	Georgia Forestry Commission Seedling Price List 2024
4	Planting	$ 11.12	$ 11.12	$ 11.12	Market fuel prices and fuel usage, calculated in LCA + 2023 Southeastern Forestry Landowners Survey
5	Fertilizer	$ 69.54	$ 111.88	$ 154.23	Market prices for Nitrogen and Phosphorous fertilizers + 2023 Southeastern Forestry Landowners Survey
6	Herbicide	$ 98.41	$ 98.41	$ 98.41	Market prices + 2023 Southeastern Forestry Landowners Survey
7	Pruning	$ 22.47	$ 27.55	$ 33.83	Market fuel prices and fuel usage, calculated in LCA + 2023 Southeastern Forestry Landowners Survey
8	Thinning	$ 70.26	$ 104.35	$ 152.79	Market fuel prices and fuel usage, calculated in LCA + 2023 Southeastern Forestry Landowners Survey
9	Harvesting	$ 122.59	$ 181.61	$ 258.37	Market fuel prices and fuel usage, calculated in LCA + 2023 Southeastern Forestry Landowners Survey
10	Harvest (thinned)	$ 275.00	$ 352.00	$ 440.00	Market price for pulpwood
11	Harvest (pruned)	$ 275.00	$ 352.00	$ 440.00	Market price for pulpwood
12	Harvest (full)	$ 2,400.00	$ 2,610.00	$ 3,150.00	Market price for timber
13	Burning	$ 32.81	$ 32.81	$ 32.81	2023 Southeastern Forestry Landowners Survey
14	Timber cruising/marking	$ 84.88	$ 84.88	$ 84.88	2023 Southeastern Forestry Landowners Survey + USDA NRCS Technical Officers' Standards Guide / Payments Schedule
15	Transportation	$ 121.92	$ 240.23	$ 632.55	Market fuel prices and fuel usage, calculated in LCA + 2023 Southeastern Forestry Landowners Survey
16
17	Various external data points from the above sources are collated to calculate a min, max and mean value for each cost/revenue component.
18	Below, a few of these calculations are shown explicitly. The actual formulae are in hidden cells in the DCF (Discounted Cash Flow worksheets)
19
20	Seedlings
21	n	1000	500	50
22	Elite Coastal CMP Loblolly	168	109	71
23	Georgia Giants (Loblolly)	78	49	30
24	Elite Straight Loblolly)	78	49	30
25	Super select premium slash	78	49	30
26	Select Piedmont 3 loblolly	73	46	27
27	Select premium slash	73	46	27
28
29	Cost per seedling
30	Elite Coastal CMP Loblolly	0.168	0.218	1.42
31	Georgia Giants (Loblolly)	0.078	0.098	0.6
32	Elite Straight Loblolly)	0.078	0.098	0.6
33	Super select premium slash	0.078	0.098	0.6
34	Select Piedmont 3 loblolly	0.073	0.092	0.54
35	Select premium slash	0.073	0.092	0.54
36		0.0913	0.1160	0.7167
37
38	$/seedling		Min	0.09
39			Mean	0.3
40			Max	0.7167
41
42	Seedlings $/acre		Min	$ 18.00
43			Mean	$ 110.67
44			Max	$ 286.68
45
46	Fertilizer (lb per acre)
47		Nitrogen	Min	80
48			Mean	140
49			Max	200
50
51		Phosphorous	Min	60
52			Mean	87.5
53			Max	115
54
55	Fertilizer ($/lb)	Nitrogen		0.4490569803
56		Phosphorous		0.5601872432
57
58	Fertilizer ($ per acre)	Nitrogen	Min	35.92455843
59			Mean	62.86797725
60			Max	89.81139607
61
62		Phosphorous	Min	33.61123459
63			Mean	49.01638378
64			Max	64.42153296
65
66	Herbicide ($ per acre)		Min
67			Mean	98.41
68			Max
69
70
71	Fuel cost ($/gal)			3.708	average of gas and diesel
72	Planting (gal per acre)			3
73	Pruning (gal per acre)		Min	6.061
74			Mean	7.4311875
75			Max	9.1245
76	Thinning (gal per acre)		Min	18.94833
77			Mean	28.142638
78			Max	41.206189
79	Harvesting (gal per acre)		Min	33.06
80			Mean	48.97828125
81			Max	69.678
82
83
84	Planting ($/acre)		Mean	11.124
85	Pruning ($/acre)		Min	22.474188
86			Mean	27.55484325
87			Max	33.833646
88	Thinning($/acre)		Min	70.26040764
89			Mean	104.3529017
90			Max	152.7925488
91	Harvesting ($/acre)		Min	122.58648
92			Mean	181.6114669
93			Max	258.366024
94
95
96	Harvest (thinned) ($/ton)		Min			Harvest (thinned) (tons/acre)	Min	25
97	pulpwood		Mean	11		pulpwood	Mean	32
98			Max				Max	40
99
100	Harvest (pruned) ($/ton)		Min			Harvest (pruned) (tons/acre)	Min	25