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 |