 |
NBER: Re: Automating Other Support: what is Annual Direct Cost?
Re: Automating Other Support: what is Annual Direct Cost?
OK, I have added direct budget requested and awarded fields to the
database. Since we already had the total amount, I did not want to wipe
out data already there, so one can derive the indirect amounts.
I will add this to the other support report tomorrow or Friday.
- Alex
On 07/03/2013 01:34 PM, Alterra Milone wrote:
> Hi Alex,
> The calculation is not that simple because our indirect is on assessed
> on salaries and wages, not total direct costs. The easiest solution
> would be to expand the budget table in the database and have four
> fields, direct_budget_requested, indirect_budget_requested,
> direct_budget_awarded, indirect_budget_awarded, rather than the two
> there now. There will be more data entry up front, but it will save us
> having to do it every time we run other support.
> Thanks,
> Alterra
>
> On 7/3/2013 1:16 PM, Alex Aminoff wrote:
>> On 07/02/2013 11:03 AM, Gwendolyn Reynlds wrote:
>>> Nope. What is in the grants database is the total awarded amount,
>>> which includes both indirect and direct costs. What we need for
>>> other support is the total annual direct cost awarded amount. If
>>> this is not possible, we can just fill it in! I don't want to create
>>> lots and lots of work for you!
>>>
>>
>> Would it be possible to calculate the Direct Cost Awarded by reducing
>> the Total Awarded by the indirect rate, which is entered on some grants?
>>
>> I'm just looking for ways to minimize data entry.
>>
>> - Alex
>>
>>
>>> On Tue, Jul 2, 2013 at 10:58 AM, Alex Aminoff <aminoff_at_nber.org
>>> <mailto:aminoff_at_nber.org>> wrote:
>>>
>>> On 7/2/2013 9:44 AM, Gwendolyn Reynolds wrote:
>>>> It is the budgeted amount. Thank you!!
>>>
>>> OK, so do we already have that in the database? On for example:
>>>
>>> http://admin.nber.org/admin/tools/grant/edit?id=6255
>>>
>>> you can see that there is already an awarded amount filled in for
>>> each year. Is that the number we need or is there a different one.
>>>
>>> So
>>>> On Tue, Jul 2, 2013 at 6:40 AM, Wayne Gray <WGray_at_clarku.edu
>>>> <mailto:WGray_at_clarku.edu>> wrote:
>>>>
>>>> Hi Gwen:
>>>>
>>>> The big question in this case is whether you want the
>>>> budgeted amount for the year or the actual amount spent.
>>>> Your answer suggests that it's the budgeted ("awarded")
>>>> amount that is desired. If so, that makes this easier,
>>>> because it means we don't have to run a separate program on
>>>> the Accounting side of things to calculate actual spending
>>>> for every project - we can just enter the total direct cost
>>>> for each year at the time the other budget-year-specific
>>>> information about the grant is being entered (such as the
>>>> number of months of effort for each PI).
>>>>
>>>> So, if you can confirm that it's the budgeted/awarded amount
>>>> that you need for filling out that report, Alex can just add
>>>> the additional field to the grants database (and data entry
>>>> screens), and then include it in the report he has been
>>>> working on.
>>>>
>>>> Thanks - Wayne
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>> *From:* Gwendolyn Reynolds [reynolds_at_nber.org
>>>> <mailto:reynolds_at_nber.org>]
>>>> *Sent:* Monday, July 01, 2013 3:13 PM
>>>> *To:* Alex Aminoff
>>>> *Cc:* grantadmins_at_nber.org <mailto:grantadmins_at_nber.org>;
>>>> Wayne Gray
>>>> *Subject:* Re: Automating Other Support: what is Annual
>>>> Direct Cost?
>>>>
>>>> My understanding is that Annual Direct Cost is the yearly
>>>> direct cost of the grant, or more specifically, the direct
>>>> cost amount awarded by the funder to the NBER for the current
>>>> year.
>>>>
>>>> On Mon, Jul 1, 2013 at 2:32 PM, Alex Aminoff
>>>> <aminoff_at_nber.org <mailto:aminoff_at_nber.org>> wrote:
>>>>
>>>>
>>>> Wayne and I talked about the web tool to produce Other
>>>> Support Reports. Wayne noted that we can probably
>>>> automate the Annual Direct Cost field as well, if we can
>>>> establish exactly what that number is supposed to be. The
>>>> information may already exist in the database, orsomeone
>>>> upstairs in accounting may be able to get it and export
>>>> it on a periodic basis.
>>>>
>>>> So can someone please explain how Annual Direct Cost
>>>> should be determined?
>>>>
>>>> - Alex
>>>>
>>>>
>>>>
>>>>
>>>> -- Research Project Director
>>>> National Bureau of Economic Research
>>>> 1050 Massachusetts Ave
>>>> Cambridge MA 02138
>>>> Work: 617-588-0349 <tel:617-588-0349>
>>>> Cell: 801-833-3492 <tel:801-833-3492>
>>>>
>>>>
>>>>
>>>>
>>>> -- Research Project Director
>>>> National Bureau of Economic Research
>>>> 1050 Massachusetts Ave
>>>> Cambridge MA 02138
>>>> Work: 617-588-0349 <tel:617-588-0349>
>>>> Cell: 801-833-3492 <tel:801-833-3492>
>>>
>>>
>>>
>>>
>>> --
>>> Research Project Director
>>> National Bureau of Economic Research
>>> 1050 Massachusetts Ave
>>> Cambridge MA 02138
>>> Work: 617-588-0349
>>> Cell: 801-833-3492
>
Received on Wed Jul 03 2013 - 17:40:05 EDT
|
