Appendix
B.
Spreadsheets
Supporting
Economic
Analysis
This
appendix
presents
the
calculations,
for
each
sector,
that
underlie
the
economic
analysis
presented
in
the
main
body
of
the
nomination
chapter.
As
noted
in
the
nomination
chapter,
each
sector
is
comprised
of
a
number
of
applications
from
users
of
methyl
bromide
in
the
United
States,
primarily
groups
(
or
consortia)
of
users.
The
tables
below
contain
the
analysis
that
was
done
for
each
individual
application,
prior
to
combining
them
into
a
sector
analysis.
Each
application
was
assigned
a
unique
number
(
denoted
as
CUE
#),
and
an
analysis
was
done
for
each
application
for
technically
feasible
alternatives.
Some
applications
were
further
subdivided
into
analyses
for
specific
sub­
regions
or
production
systems.
A
baseline
analysis
was
done
to
establish
the
outcome
of
treating
with
methyl
bromide
for
each
of
these
scenarios.
Therefore,
the
rows
of
the
tables
correspond
to
the
production
scenarios,
with
each
production
scenario
accounting
for
row
and
the
alternative(
s)
accounting
for
additional
rows.

The
columns
of
the
table
correspond
to
the
estimated
impacts
for
each
scenario.
(
The
columns
of
the
table
are
spread
over
several
pages
because
they
do
not
fit
onto
one
page.)
The
impacts
for
the
methyl
bromide
baseline
are
given
as
zero
percent,
and
the
impacts
for
the
alternatives
are
given
relative
to
this
baseline.
Loss
estimates
include
analyses
of
yield
and
revenue
losses,
along
with
estimates
of
increased
production
costs.
Losses
are
expressed
as
total
losses,
as
well
as
per
unit
treated
and
per
kilogram
of
methyl
bromide.
Impacts
on
profits
are
also
provided.

After
the
estimates
of
economic
impacts,
the
tables
contain
basic
information
about
the
production
systems
using
methyl
bromide.
These
columns
include
data
on
output
price,
output
volume,
and
total
revenue.
There
are
also
columns
that
include
data
on
methyl
bromide
prices
and
amount
used,
along
with
data
on
the
cost
of
alternatives,
and
amounts
used.
Additional
columns
describe
estimates
of
other
production
(
operating)
costs,
and
fixed/
overhead
costs.

The
columns
near
the
end
of
the
tables
combine
individual
costs
into
an
estimate
of
total
production
costs,
and
compare
total
costs
to
revenue
in
order
to
estimate
profits.
Finally,
the
last
several
columns
contain
the
components
of
the
loss
estimates.
#
Notes
1
All
analyses
based
on
the
Net
Present
Value
of
an
acre
of
orchard.
Very
limited
data
are
available
as
to
the
impacts
of
alternatives
on
orchard
establishment
and
no
long­
term
data
are
available
as
to
yield
impacts.
This
analysis
was
conducted
to
determine
what
economic
impacts
and
minimal
biological
effects
would
have
on
orchard
value.

2With
the
exception
of
walnuts,
soil
moisture
requirements
imply
that
a
year
of
fallow
is
necessary
before
the
orchard
can
be
replanted.

31,3D
is
only
feasible
on
light,
sandy
soils
and
is
subject
to
regulation
as
a
potential
carcinogen.

4
According
to
available
crop
budgets,
harvest
costs
of
fruits
and
nuts,
and
plums
in
particular,
are
a
large
proportion
of
costs
and
are
proportional
to
yields,
therefore
yield
losses
result
in
significant
savings
in
harvest
costs.
In
reality,
some
fixed
costs
of
harvesting
will
reduce
these
cost
savings
and
increase
the
economic
losses.

5The
MBTOC
list
was
more
limited
for
vineyard
replanting
than
for
fruits
and
nuts.

Y*
Technically
feasible
on
light
soils
only
*
kg
ai
that
would
be
applied/
ha
=
application
rate
for
the
alternatives
or
requested
application
rate
for
MeBr.

*
Other
pest
control
costs
are
those
other
than
methyl
bromide
or
its
alternatives.
