We have recently updated the TC budget template (Excel) in light of changes to sponsor forms and policy, as well as to clarify areas that have been confusing to users. The latest version is dated 9.7.12. All rates embedded in the template are up to date. Effective immediately, please use only this version. Also the instructions and the material in the notes have changed considerably so please review them carefully.
The budget template was designed to accommodate all types of grant budgets. It assumes no prior knowledge of grant budgeting, or of TC salary formulas, indirect cost and fringe benefit rates, or even Excel formulas.
The biggest change in the latest version is that we have changed the default settings for faculty salary calculations using the nine month academic year salary as the basis for all calculations. This is in recognition of the fact that NIH recently changed its budget forms to reflect academic year and summer effort expressed in months rather than percentages. Overage and course release have always been calculated on the nine month base, so the change ought to simplify budgeting with less formula editing.
Below is some guidance for estimating costs of other frequently requested budget items:
Each item below corresponds to a common line item in most grant budgets
1. Faculty Salaries
The 9 month contract leaves the three summer months available for faculty to devote 100% of their effort on grant related work. Therefore, faculty will most frequently request Summer Salary from a grant. The three months of the summer are equal to 1/3 of the academic year, so summer salary is capped at 33% of IBS. Each month of summer salary is equal to 11% of the 9 month salary.
Faculty may also do grant related work during the year. A faculty member may elect to "buy out" of teaching (more formally known as "course release") to work on a sponsored project, at a rate equal to 15% of IBS for each course released. If a faculty member performs work on a sponsored project in addition to his or her normal duties at the college during the academic year, he or she may draw overage compensation. TC policy caps overage at 20% of 9 month salary.
The maximum annual compensation a faculty member may draw from TC and external sources combined is thus 153% of the 9 month base salary. Any grant funds budgeted for a faculty members salary in excess of the 53% summer salary and overage must be budgeted for course release or rebudgeted for other purposes..
NOTE: The National Institutes of Health (NIH) sets an annual salary cap. Effective January 1, 2010, total compensation for individuals receiving funds from NIH and institutional sources may not exceed $199,700. If a faculty member's annualized base salary exceeds this amount, the lower amount must be used.
Grant budgets for the National Science Foundation (NSF) require that salary requests be expressed as months. No more than 2 months salary may be requested for any one individual on one grant.
2. Other Professional Salaries
Other professional staff at TC work on 12 month contracts and are not (in general) entitled to overage payments, so their salaries are far simpler to calculate. For professional staff currently on the TC Payroll, request salary for such individuals as a flat percentage of their current Institutional Base salary.
It's frequently the case that staff positions named in a grant proposal budget will only be created if the grant is funded, in which case we have to estimate what each position's Institutional Base Salary will be. Below is a list of position categories frequently included in grant budgets with a salary range for each.
Senior Research Scientist/PostDoc: $45,000-80,000
Project Director/Business Manager: $45,000-70,000
Project Coordinator/Data Collection Coordinator/Statistical coordinator (doctoral level): $30,000-55,000
Project Tech Support, Network Engineer, Web/Multimedia Designer: $35,000-60,000
Secretary/Clerical Staff : $25,000-50,000
3. Graduate Research Assistants
As of 1/1/08, the college has codified specific types of support for graduate students:
- Doctoral Research Fellowships: Includes a stipend of between $20-24K per year, with 12 credits tuition charged to the grant, matched by the college
- Graduate Assistant: Works no more than 20 hours a week and earns no less than $4000 per semester up to $19,999 per academic year.. Eligible for 6 points tuition waiver.
Part time hourly and part time professional lines may also be used to support graduate students.
4. Fringe Benefits
All full time faculty and professional staff positions are charged fringe benefits at 34.7% of their total compensation. Part time graduate student employees are charged 8.4%.
Subcontracts are budgeted when a project requires collaboration with another institution to fulfill its objectives. Usually, one institution takes the lead on the project, and issues one or more subcontracts to collaborating institutions. Each collaborating institution prepares a budget according to its own salary formulas, fringe benefit and indirect cost rates and submits it to the lead institution with a letter from an institutional official committing to do the work on the project should the grant be funded. Different sponsors have different requirements as to how much detail of each subcontract budget they need, so consult the program guidelines.
TC investigators who plan on submitting a proposal as a subcontractor to another institution must still submit their proposal budget for internal routing.
Consultants are individuals outside of TC with skills or expertise necessary to the conduct of a project, but whose involvement is more limited in time or scope than a subcontractor. Consultants are often engaged on a project to perform statistical analysis, to evaluate research design or program outcomes, or to serve in an advisory capacity to a project. Most of the time, we don't know exactly who will be engaged as a consultant on a project.
Noncompliance in this area can lead to severe IRS penalties, so the Offices of the General Counsel, Purchasing and Payroll are extremely diligent in ensuring compliance with all applicable regulations.
Most research grants budget funds for travel, for the Principal Investigator and other project staff to present and attend conferences. Travel requests of this type should be kept relatively low, no more than $1000-$2000 per year.
Sometimes extensive travel is an integral part of the project, for example, when data collection takes place outside the NYC area or when collaborators work at a distance from one another. To budget in such cases, take the number of individuals who will be travelling, estimate the total number of trips per year each will have to make, and use the Web to get a sense of current airfares and room rates at the locations in question. Local travel should be budgeted on the travel line as well.
8. Supplies and Equipment
Federal guidelines define equipment as costing more than $5000. This means that most computing, software, low end a/v equipment, etc., should go on the supply line with items like toner cartridges, office supplies, etc, rather than on the equipment line. At TC, where we aren't doing research in the physical and health sciences that require major specialized equipment, servers and high end video equipment are the items most frequently found on the equipment line.
We generally budget desktop computers at $1500 per unit (unless we know for certain a higher-end model will be needed). Generally, we request at least one desktop computer for the graduate assistants working on the project to share, as well as one unit for each full time professional (exclusive of faculty) who work on the project. Requesting a laptop for a project can strike a sponsor as frivolous (unless it's clearly justified), but there is nothing to prohibit you from purchasing a laptop once funds are awarded.
Once again, the Web can help you obtain reasonable estimates for supplies and equipment.
9. Participant Support Costs
Items on this line include payments to students in a training program for their time, room and board, travel or study fees. They also include compensation for time and travel of research subjects. The actual dollar amounts of these expenses will vary widely depending on the nature and duration of participants' involvement. Keep in mind, however, that according to federal guidelines on human subjects research, fees paid to subjects may not be set so high that the fees become an enticement to participate.
Most grant applications do not include a specific line for tuition for your graduate assistants; we usually place it on a line marked "other." Tuition for the 2011-12 academic year is at $1231 per credit; budget for 6% annual tuition increases.
11. Telephone/Office Supplies/Postage/Overnight Express Service
Most grant budgets routinely request $300-$500 per year for each of these items. If you can anticipate the need for software upgrades or other routine maintenance expenses, they should go here as well. Your telephone budget should increase if you anticipate needing more lines than you currently have available, if you will be conducting telephone surveys or will be making significant long distance calls. Postage should be increased if you are conducting a mail survey or plan on doing mass mailings as part of the project.Indirect Costs
Teachers College has a federally negotiated indirect cost rate of 69.1% on salaries only.
Not all federal programs will accept our negotiated rate. If a program sets a different rate, please print the guidelines for the reference of the Grants and Contracts Accounting Office. You may budget according to the rate set by the sponsor. Federal Training programs cap indirect costs at 8% of total direct costs, as do most programs from NYSED.
For all other sponsors, TC will follow published sponsor policies on the allowability of indirect costs. For sponsored who have no published guidelines (this includes most international sponsors, many corporate sponsors and contracted work from other governmental agencies within the US such as school districts, states other than New York), the the Office of Sponsored Programs will advise you on the appropriate indirect cost rate during the proposal development and award negotiation stage.
Other Budgeting Issues
Most sponsors set limits on the amount of funds you may request in a given proposal. These budget ceilings must be met by adjusting the direct costs of the proposal budget. Indirect costs may never be waived simply to meet a budget ceiling. There may be certain, limited circumstances when indirect costs may be waived. Formal requests for a Waiver of indirect costs should be submitted to the Associate Dean no later than two weeks prior to the deadline date.
A related issue is cost sharing. Applicants should be aware that, according to federal regulations, cost sharing may only be a consideration in the evaluation of a grant application if the program guidelines require it. Including cost sharing in a grant proposal that doesn't expressly request cost sharing will not help your proposal.
The current budget climate at the College means that we will be looking at proposals that do require cost sharing with particular scrutiny. All applicants are responsible for obtaining commitments to meet the cost share prior to submission of the application.
Budgeting needs to be a collaborative activity between the PI/project staff and OSP. Project staff should decide what its needs are for a given proposal; OSP can perform released time/overage, summer salary, fringe benefits and indirect cost calculations if you make your request at least one week prior to the sponsor deadline.
An issue that arises frequently during the budgeting process concerns the appropriateness of particular budget items. The National Science Foundation usually funds up to two month's salary per faculty investigator on each award, which faculty may take as released time, overage or summer salary. This is a reasonable rule of thumb for applications to other agencies as well, though the scope of a particular project can often make a request for more time entirely appropriate, especially from NIH, which routinely makes multiyear awards in the millions of dollars. Beyond that, there really are not many hard and fast rules about budget requests. Agency program officers can provide important gui
How the budget affects the chances of a proposal's ultimate success or failure is the source of much anxiety on the part of applicants. Reviewers are typically asked to evaluate if the applicant has identified sufficient resources to conduct the project as described, and at this point, coming in too low can hurt your chances just as much as coming in too high. Our indirect cost and fringe benefit rates, etc., will not factor in at this stage of the process. These issues do begin to matter when the peer review process has concluded and program officers have to choose among proposals given equal priority ratings by the review panel. Even so, it is not automatically true that funds will go to the proposal that comes in at the lowest cost. Many other factors come into play at this point, including granting funds to investigators whom the sponsor has supported before, supporting minority investigators and/or institutions (if that is stated as a priority in the RFP) and spreading benefits out over a wide geographical area. Remember that Federal agencies and private foundations are not profit-driven enterprises. If they have a budget of $15 m to give out during a particular funding cycle, they will give out $15 m, or otherwise lose it. No sponsoring agency operates under the assumption that the way to get the most "bang for the buck" is to distribute some funding to as many investigators as possible. If your budget is reasonable in relation to your objectives and contains no obvious padding or unnecessary expenditures, your chances of rejection for budgetary reasons are probably minimal. However, if your proposal received a high priority rating but was rejected for budgetary reasons, the program officer will tell you so if you inquire. In such instances, you will almost always be given advice about where to cut spending and be encouraged to apply during the next cycle.