The ForestHarvest.xlsx Model

Forest Harvest Model

View the model
Download the model

We have a set of stands or tracts of trees.
We want to decide how much to harvest from each tract
in each year of a multi-year planning horizon.
Inputs:
RevCof( s,p,t) = net revenue from harvesting stand s from product p in period t.
RevCof(s,*) usually has a S shaped curve as a function of t, e.g.,
it grows slowly at first, then rapidly in midlife, and slowly later in life.
VolCof(s,p,t) = volume from stand s of product p if harvested in t.
GoalLO(p,t) = low goal for total harvest of product p in period t,
GoalHI(p,t) = high goal for total harvest of product p in period t
D = discount factor or effective interest rate.

Decision variables:
X(s,t) = fraction of stand s harvested in period t.

Keywords:

Multi-period | Forest planning |