Instructions for IFR Allocation Worksheet

This worksheet (in Microsoft Excel format) should be used for the initial request of an IFR account and for the initial allocation for the new year.

Page 1

Account Number
Enter the account number. If a new request, leave blank. As previously mentioned in the Most frequently asked questions, once all steps are completed Accounting will inform you of the account number.
Account Name
Enter the name.
Initiated By
Enter the Account Director's name.
Purpose for which this account is used
Enter the purpose of the account. (i.e. For the collection of revenue and expenses associated with .....)
Major Providers of Revenue
List each of your providers of revenue and their projected annual amounts. (The total amount will carry over to page 2 "Anticipated Collections")
Sources of Revenue
Enter each source and their amounts. (i.e. CPMP funds, research grants)
Proposed Changes
Enter the fiscal year where you anticipate a major change and the reason for the change. (i.e. increase/decrease in rates, level of service)

Page 2

Account Number, Account Name and Initiator
Carry over information from page 1.
Anticipated Cash Available
Ending Cash Balance
Enter the month and the ending cash balance amount as shown on the account's cash page.
+ receivables
Enter billings and/or invoicing which have been issued by your department for which payment has not been received.
+ other
Enter other assets. (i.e. inventory, unrecovered equipment purchases.)
- liabilities
Enter total of bills and/or invoices that you owe others.
Projected cash balance
This is the sum of the items above.
Anticipated collections
This is carried over from page 1.
Anticipated Commitments
Personnel
Enter projected annual requirements for personnel services in each category.
Total PSR and PST
Sum of all personnel requirements.
Fringe Benefits
Will automatically calculate based on the information provided for personnel requirements and the current year's fringe benefit rate.
Total Fringe Benefits
Sum of all fringe benefits calculations.
Other Temp Services
Enter projected annual requirement.
Total Personnel and Fringe Benefits
Will automatically calculate the sum of Total PSR and PST, Total Fringe Benefits and Other Temp Services.
OTPS (other than personnel services)
Supplies and expenses
Enter annual requirements.
Equipment
Enter annual requirements.
Total OTPS
Will automatically calculate sum of supplies and equipment.
Total Allocation
Will automatically calculate the sum of the Total PSR and PST, Other Temp services and Total OTPS. (Fringe Benefits are not included in the allocation. Fringe Benefits are a reduction to cash.)
Total Personnel, Fringe Benefits & OTPS
Will automatically calculate the sum of Total PSR and PST, Other Temp Services and Total OTPS.
Administrative Overhead (AO) and Maintenance and Operations (MO)
Will automatically calculate the assessment amount on Total Personnel, Fringe Benefits and OTPS.
Total Commitments
Will automatically calculate sum of Total Personnel, Fringe Benefits and OTPS and AO and MO.
Projected Cash
Equals Total Cash Available minus Total Commitments. Ending cash must be positive.