Web site has been revised. See:
http://www.research.vcu.edu/ospa/budgpkg.htm#worksheets
Chuck
At 12:03 PM 7/26/2004, you wrote:
>Herbert,
>
>I think I accidently replied to the whole group on this email but was
>meaning to ask you if by chance the spreadsheets described below might still
>be available somewhere. I check the web link, but it is no longer active.
>
>Thanks so much.
>
>Dwight Davis
>Baylor College of Medicine
>
>
>
>Herbert B. Chermside [xxxxxx@VCU.EDU]
>-----Original Message-----
>From: Research Administration List [mailto:xxxxxx@HRINET.ORG] On Behalf Of
>Herbert B. Chermside
>Sent: Wednesday, April 23, 2003 7:39 AM
>To: xxxxxx@HRINET.ORG
>Subject: [RESADM-L] Spreadsheets
>
>
>Several of you have requested VCU's budget spreadsheets. They are on the
>web.
>
>Go to
>http://www.research.vcu.edu/ospa_budgpkg.htm#worksheets
>for the descriptive discussion, and download the spreadsheets.
>
>Suggest you should use the "flex" budgets and the "loaded" budget.
>
>The flex budgets allow you to insert your own benefits and F&A rates,
>whereas the "current rate" budgets have VCU's on campus research rates
>"locked" in place. VCU has a single pooled benefits rate for all salaried
>sponsored programs personnel, and another single pooled rate for hourly
>sponsored programs personnel. Our 9-month faculty are on the pooled
>benefits rate for the 9 months, and summer is paid as hourly payroll.
>
>The neat feature of the modular budget spreadsheet is that it keeps a
>running average of the total period's annual cost in the upper right. It
>does NOT calculate for additional modules; as they are almost always for
>equipment, there would be $0 F&A for the module, so adding the module is a
>no-brainer.
>
>The "Loaded" spread sheets calculate the total cost of each item "loaded"
>with benefits and F&A, and the SECOND page shows total costs by category:
>personnel, supplies, etc., and nerver show the detailed first page. We use
>it for our industrial sponsors and others who do not insist on great detail.
>This gives the reviewer no separation of F&A, thus obviating any discussions
>about the F&A cost. As you all know, F&A calculated under A-21 is
>significantly different from any loading that industries use in their
>budgets, and also industries typically deal with loaded costs, so this
>avoids conflicts because we speak of apples and industries speak of oranges.
>
>A really great advantage for our office is that if our faculty use these
>spreadsheets, and attach a copy (as an internal document), we do not have to
>"run the numbers" on their budgets, because we know the calculations are
>correct.
>
>If you have to make changes in these spreadsheets to fit your situation, at
>least here are some starting points for you.
>
>Good luck with these. The charge: if you improve on them, share with us
>what and how you do the improvements, so we may consider using them.
>
>Chuck
>Herbert B. Chermside, CRA
>Director, Sponsored Programs Administration
>Virginia Commonwealth University
>PO BOX 980568
>Richmond, VA 23298-0568
>Express Delivery Only:
> Biotech One, Suite 113
> Virginia Biotechnology Research Park
> 800 East Leigh Street
> Richmond, VA 23219
>Voice: 804-828-6772
>Fax 804-828-2521
>OFFICE e-mail xxxxxx@VCU.EDU
>Personal e-mail xxxxxx@vcu.edu http://www.research.vcu.edu/ospa.htm
>
>
>======================================================================
> Instructions on how to use the RESADM-L Mailing List, including
>subscription information and a web-searchable archive, are available via
>our web site at http://www.hrinet.org (click on "Listserv Lists")
>======================================================================
Herbert B. Chermside, CRA
Special Asst. to VP-Research
Virginia Commonwealth University
PO BOX 980568
Richmond, VA 23298-0568
Voice: 804-827-6036
Fax 804-828-2051
e-mail xxxxxx@vcu.edu
======================================================================
Instructions on how to use the RESADM-L Mailing List, including
subscription information and a web-searchable archive, are available
via our web site at http://www.hrinet.org (click on "Listserv Lists")
======================================================================
