3:49 p.m.
Hello Justin,
Dr. Yu was asked to revise the budget of her incoming NASA award, and when she used the
new budget template for FY 2025, she noticed an error and she emailed me the following:
"I found an error on the 2025 budget form that I want to bring your attention to -
for sub-award, "Indirect Costs are only charged on the first $25,000 of each subaward
regardless of duration. But for the current budget sheet, the indirect cost base is adding
the amount even it already exceeds $25k - so I did my budget in Year 1 okay, but in Year 2
the indirect cost base is calculated wrong.
I share some screenshots on the errors - for Year 2-5, there seems to be typo in the input
cell."
Can you please advise so I may respond to her email? Thank you
Sincerely,
Francesca Bronder, M.A.
Research Administrator II - College Research Administration
College of Sciences
The University of Texas at San Antonio
One UTSA Circle
San Antonio, TX 78249-1644
BSE 1.628
Email: francesca.bronder@utsa.edu<mailto:francesca.bronder@utsa.edu>
http://research.utsa.edu<http://research.utsa.edu/>
From: Justin Marmolejo <Justin.Marmolejo(a)utsa.edu>
Sent: Friday, December 6, 2024 10:09 AM
To: Elizabeth Tilley <elizabeth.tilley(a)utsa.edu>; rowdy.research(a)lists.it.utsa.edu;
Carol Looney <carol.looney(a)utsa.edu>
Subject: [Rowdy.research] Re: New F&A Rates and UTSA Budget Templates
Hi Liz,
Yes, these templates should be used. These have the built in formulas to update the
F&A rate if needed from 52% to 52.5% when a project year crosses into FY27.
Thanks,
Justin
From: Elizabeth Tilley
<elizabeth.tilley@utsa.edu<mailto:elizabeth.tilley@utsa.edu>>
Sent: Friday, December 6, 2024 10:01 AM
To: Justin Marmolejo
<Justin.Marmolejo@utsa.edu<mailto:Justin.Marmolejo@utsa.edu>>;
rowdy.research@lists.it.utsa.edu<mailto:rowdy.research@lists.it.utsa.edu>; Carol
Looney <carol.looney@utsa.edu<mailto:carol.looney@utsa.edu>>
Subject: RE: New F&A Rates and UTSA Budget Templates
OK, so we won't be merging cells going forward and should just use this template?
Some people have asked if they can just change the F&A on the old so I want to make
sure they know not to do that.
Thanks!
From: Justin Marmolejo
<Justin.Marmolejo@utsa.edu<mailto:Justin.Marmolejo@utsa.edu>>
Sent: Friday, December 6, 2024 9:58 AM
To: Elizabeth Tilley
<elizabeth.tilley@utsa.edu<mailto:elizabeth.tilley@utsa.edu>>;
rowdy.research@lists.it.utsa.edu<mailto:rowdy.research@lists.it.utsa.edu>; Carol
Looney <carol.looney@utsa.edu<mailto:carol.looney@utsa.edu>>
Subject: RE: New F&A Rates and UTSA Budget Templates
Hi Liz,
In order to be able to post files online to our website, files must pass accessibility
checks to be compliant with new ADA requirements. This required a lot of the merged cells
to be unmerged.
Thanks,
Justin
From: Elizabeth Tilley
<elizabeth.tilley@utsa.edu<mailto:elizabeth.tilley@utsa.edu>>
Sent: Friday, December 6, 2024 9:06 AM
To: Justin Marmolejo
<Justin.Marmolejo@utsa.edu<mailto:Justin.Marmolejo@utsa.edu>>;
rowdy.research@lists.it.utsa.edu<mailto:rowdy.research@lists.it.utsa.edu>; Carol
Looney <carol.looney@utsa.edu<mailto:carol.looney@utsa.edu>>
Subject: RE: New F&A Rates and UTSA Budget Templates
Hi Justin,
I haven't had a chance to look at this much this week, but Shannon was able to look
through the spreadsheet and noted the items below.
If the only thing changed was the F&A, can we possibly use the template from this year
and change the F&A. There were just a lot of minor glitches with the new one.
Good Afternoon Elizabeth,
Also, in working on getting a budget gathered I also noticed that there are some
formatting issues in the new templates -
1. Project Title - is not merged into one cell so that the whole title fits properly
2. Name - is not merged into one cell
3. Line 76 - is not merged into one cell ("Other - Please Specify")
4. Lines 84 through 86 after Equipment Item 1, 2 or 3 - is not merged into one cell (in
order to have the description flow properly)
5. Lines 88 through 91 participant section - lines are not merged (in order to provide
descriptions for use)
6. Lines 93 through 97 Other Costs (F&A Excluded) - lines are not merged (in order
to provide descriptions if necessary)
These are the ones that I have found at this point.
From: Justin Marmolejo
<Justin.Marmolejo@utsa.edu<mailto:Justin.Marmolejo@utsa.edu>>
Sent: Tuesday, December 3, 2024 4:48 PM
To: rowdy.research@lists.it.utsa.edu<mailto:rowdy.research@lists.it.utsa.edu>; Carol
Looney <carol.looney@utsa.edu<mailto:carol.looney@utsa.edu>>
Subject: [Rowdy.research] Re: New F&A Rates and UTSA Budget Templates
Hello everyone,
Correction to the email below, it looks like excel is case sensitive when locking
worksheets. The password is ut5a1604.
Please reply to this email if you have any issues to keep everyone in the loop.
Thanks,
Justin
From: Justin Marmolejo
<Justin.Marmolejo@utsa.edu<mailto:Justin.Marmolejo@utsa.edu>>
Sent: Tuesday, December 3, 2024 2:58 PM
To: rowdy.research@lists.it.utsa.edu<mailto:rowdy.research@lists.it.utsa.edu>; Carol
Looney <carol.looney@utsa.edu<mailto:carol.looney@utsa.edu>>
Subject: [Rowdy.research] Re: New F&A Rates and UTSA Budget Templates
Hello everyone,
Quick follow up to the email below. The password to both budget templates is UT5A1604.
Thanks,
Justin
From: Justin Marmolejo
Sent: Tuesday, December 3, 2024 2:34 PM
To: rowdy.research@lists.it.utsa.edu<mailto:rowdy.research@lists.it.utsa.edu>; Carol
Looney <carol.looney@utsa.edu<mailto:carol.looney@utsa.edu>>
Subject: New F&A Rates and UTSA Budget Templates
Hello everyone,
We have received the new F&A rate agreement for UTSA which can be found
here<https://research.utsa.edu/research-admin/forms-policies-guideline...;.
As a result of the new F&A rates and changes to the MTDC base, we have updated the
internal UTSA Budget Template.
The new budget template must be used on all proposals being submitted on Monday, December
9th or after. You can find the new budget template under the Proposal Packaging section on
the OSP website<https://research.utsa.edu/osp/proposal-preperation.html>;. Because of
the changes in the MTDC base occurring in FY26, please use the correct budget template as
defined below.
For proposals with a FY25 start date - use the FY25 budget template
For proposals with a FY26 start date - use the FY26 budget template
Please reach out to your respective team lead if you have any questions.
Thanks,
Justin Marmolejo
Assistant Director, Office of Sponsored Projects | Staff Senate
Chair<https://www.utsa.edu/staffsenate/>
Office of Research
The University of Texas at San Antonio
One UTSA Circle
San Antonio, TX 78249-1644
Office: NPB 5.102V04
Phone: 210.458.7049
Email: justin.marmolejo@utsa.edu<mailto:justin.marmolejo@utsa.edu>
http://research.utsa.edu<http://research.utsa.edu/>
