TO DO -------------------------------------------------------------- Move expenditures off NSF and put on DoD Set up alert system for reports needed DREAMS -------------------------------------------------------------- Personal Refunds Please list all items submitted for refunds at level of credit card entry and travel request. Goal is for me to be able to monitor all my credit card expenses and check that business expenses submitted and refunded Also that all submitted expenses are received by me Indicate date of submittal of refund and "local agency" sent to. Log refunds received by me and check off items on list. Features of "Creative Use of Money" Make certain that when choices, money used "optimally" i.e. use account that respects rules but minimizes overhead paid noting that federal money has no overhead on equipment but pays overhead on people. State and discretionary accounts have no overhead -- implies use federal money for equipment where possible (NSF particularly flexible) Make certain that contract end deadlines are noted well ahead of time and funds expended appropriately. Note DoD is very nervous about "rate of billing" Please monitor this Features of Financial Tracking/Projection Project ahead at least one year. Currently we should be projecting to December 2001 Projections should be done as expected expenditures by month There should be stated assumptions in terms of dollars input for each given source at given begin and end time There should be stated assumptions in terms of who has to be paid (at level of person) with what rate and what constraints as to contracts which can be charged. People have salary, fringe benefits, tuition as appropriate Hardware / Software "special" expenditures should be listed Other expenditures (consulting, sub contracts) should be listed. items should be listed as one time charges or as monthly rates for a particular time period. Subcontracts should not be included below but subtracted from grant ab initio Simplest Summary output is a bunch of columns with one row per month The following output columns should be present 1) Notations as to when slugs of money start 2) Expected monthly expenditures based on constant monthly expenditures of input money slugs with correction for special expected expenditures 3) Special expected expenditures (e.g. IBM machine) 4) Actual monthly expenditure -- as recorded or projected in recurring and special categories (really 2 columns) 5) Cumulative dollars left as cumulative input (pro-rated for expected use till this month) minus expenditgures. This is 2) + 3) - 4) 6) Monthly expenditures divided into following categories Student salaries All people except student salaries but including consultants Tuition Fringe Benefits Travel Hardware or Software / Related Computer Expenses Miscellaneous (telephone, paper ....) Overhead All columns should be totalled in separate rows for a) Last Month for which real expenditures known b) Last Month of projection Analysis should be performed for ALL Money Sources and separately for Federal Grants State Budget The rest -- Eppes/Donations We may wish to divide sources of funding into "groups" corresponding to related contracts. This is not necessary initially