Re: forecasting indirect cost revenues Higginson, David A 21 Mar 1998 16:42 EST

Ross,

We have the same difficulties. The way we have approached the problem is to
:

1) Annualize the direct and indirect costs of each award we currently have
that will have a budget period within the next fiscal year.

2) From this list, determine the percentage of total budget period funding
spent in each of the last x years of the award (i.e. spending trend of the
PI) and apply that % to the amount in (1)

3) Determine a list of pending awards at budget time (the later the
possible), then :

 a) Evaluate submission by submission by talking with PI and dept.
head to determine likelihood of success
 b) Take an historical success rate for each major agency and apply
that to the submissions

Once we have our budgeted total indirect cost revenue, we evaluate the
historical monthly pattern of indirect cost revenue and determine estimated
monthly revenue based on this figure. This is more useful than it may sound
as the assumption that revenue is constant each month is certainly not valid
in our institution (whereas trends in revenue streams are relatively
constant), and it is much easier to spot problems ahead of time by
monitoring this on a month by month basis.

My final strategy is to continually harass our accounting office and
executive committee by pointing out that the primary purpose of budgets is
to provide a tool which allows managers to more effectively make use of
their limited resources. One of the key assumptions of budget theory being
that items on the budget are controllable by the person held responsible.
There is little or no point in making a sponsored research office (or
research institute) a profit center based on indirect costs revenue unless
they have control of faculty/researcher hiring, allocation of researcher
effort, and the success of the research taking place. The day I get any
influence in the three above will be the day I feel somewhat responsible for
the revenue from indirect costs.

-David
David Higginson, ACMA
Administrative Director
Arkansas Children's Hospital Research Institute
Tel: (501) 320-3757
Fax: (501) 320-3547
Email : xxxxxx@exchange.uams.edu
WWW : http://achri.ach.uams.edu

-----Original Message-----
From: Ross, Stuart [mailto:xxxxxx@EXCHANGE.FULLERTON.EDU]
Sent: Friday, March 20, 1998 4:50 PM
To: Multiple recipients of list RESADM-L
Subject: forecasting indirect cost revenues

Has anyone figured out a good method or algorithm for forecasting and
budgeting indirect cost revenues?
We currently use a rough combination of extrapolating recent trends and
estimating the likelihood of future awards, and we are often wrong.  Not
disastrously wrong, but uncomfortably so, and we'd like to do better.
As a relatively small office, we are relatively vulnerable to (a) the
gains and losses of single large grants, as well as (b) the level of
activity on campus and (c) the prevailing national grants climate.
Any tips, advice, or full-blown solutions would be welcome.....

Stuart A. Ross
Cal State Fullerton
xxxxxx@fullerton.edu