Skip Navigation
Search

INSTRUCTIONS FOR IFR ALLOCATION WORKSHEET

Worksheet for 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 FAQs, 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.