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&gt; Sent: Friday, December 6, 2024 10:09 AM To: Elizabeth Tilley <elizabeth.tilley(a)utsa.edu&gt;; rowdy.research(a)lists.it.utsa.edu; Carol Looney <carol.looney(a)utsa.edu&gt; 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/>