Docstoc

0

Document Sample
0 Powered By Docstoc
					                                          CTC FY10 Grant Financial Report
                                                                                                                                                                        Data thru pay period #

    Grant #:                                    Reported as of: July 30, Cycle 1                     0
     Fund #:                                   Funding Agency:
       Org #:                            Grant Begin/End Dates: start date to end date
Grant Focus: Research, training, public srvc?    Contract Type: Cost reimbursable, fixed price, grant?

                                                                 Ad ju sted          B u d g et        YTD                YTD            Exp en se      Exp en se           (Over)/Under
      EXPENSE CATEGORIES                                          B u d g et      Revisio n s        Activity        En cu m b ered Ad ju stm en ts    Pro jectio n s         B u d g et
                                                                                                                                                      to June 30, 2008
      Personal Services                              1000            0.00               0              0.00                                   0           0.00                 0.00
      Travel                                         2000            0.00               0              0.00              0.00                 0           0.00                 0.00
      Contractual Services                           3000            0.00               0              0.00              0.00                 0           0.00                 0.00
      Commodities                                    4000            0.00               0              0.00              0.00                 0           0.00                 0.00
      Capital (Equipment)                            5000            0.00               0              0.00              0.00                 0           0.00                 0.00
      Student Financial Aid                          6000            0.00               0              0.00              0.00                 0           0.00                 0.00
      F&A                                            7000            0.00               0              0.00              0.00                 0           0.00                 0.00
      Misc Expenditures                              8000            0.00               0              0.00              0.00                 0           0.00                 0.00
       Total Expense- Current Yr                                   0.00                 0             0.00               0.00                 0           0.00                 0.00


       Total Expense- Previous FY                                    0.00             0.00             0.00               0.00              0.00           0.00                 0.00

        Inception to Date Balance                                  0.00              0.00             0.00               0.00              0.00           0.00                 0.00



      Indirect Cost Recovery                                    In d irect Rate                                     Reports to Agency                                        Due Date
      Current fiscal year                                            30.0%                                          list here reports or other deliverables

      Indirect recovered YTD by dept                 36.40%           $0

      Indirect to be earned                          36.40%           $0

      Total Indirect Cost Recovery this FY                            $0




      NOTES
      The Indirect Cost Recovery chart uses 30.0 % as an indirect rate, however your grant may have a different rate. Change the rate in cell E27.
      Also, the % of indirect your department keeps needs to be individualized as well. Change the rate in cell D28 and D29.
      The indirect your department keeps is either 54.6% or 36.4%.
      You can delete the text of these footnotes after you make necessary changes.




      Prepared By:                                                                                                                    Phone:




      Approved By:                                                                                                                    Date:
Change LD# each reporting cycle on Summary page cell K4




                                            % Task Complete
                                            Date            0%

                                            Amount Billed YTD
                                                            $0.00
UAA COMMUNITY & TECHNICAL COLLEGE PAYROLL PROJECTION MODEL
FISCAL YEAR 2010
                                                                                                                   Empl Class                         Benefit
                                                                                       Benefit Type                  Codes                             Type        Category

Current as of:                         19-May-13                      0 = Classified                                  NR                                0       Classified
                                       06:44 AM                       1 = Classified Union                            CR                                1       Classified Union
Data thru LD#                               0                         2 = APT (Exempt)                                XR                                2       APT (Exempt)
LD ending date                         30-Jun-09                      3 = Extended Temporary                         NX/XX                              3       Extended Temporary
                                                                      4 = Executive                                   EX                                4       Executive
Change LD# each reporting cycle on Summary page cell K4               5 = Faculty, UNAC                               F9                                5       Faculty, UNAC
                                                                      6 = Faculty, ACCFT                             A9/AR                              6       Faculty, ACCFT
Grant Title                                                           7 = Faculty non-represented                    FN/FR      Use FR leave rates      7       Faculty non-represented
0                                                                     8 = Faculty temp rep/non-rep                   FT/FW                             8        Faculty-Temp rep/non-rep
                                                                      9 = Temporary                               CT/NT/XT/GT                          9        Temporary
                                                                     10 = Student Taxable                             ST                               10       Student Taxable
                                                                     11 = Students non-taxable                       SN/GN                             11       Students non-taxable




Column A                                 Column B         Column C   Column D      Column E       Column F        Column G                           Column J      Column K
                                                                                                                      Hrs                              Days
                                          Hourly                      Benefit          Beg               Stop         Per                               Per          Days
               Name                       Wage              PCN        Type            Date              Date         Day                            Contract        Rem

                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261
                                          $0.00           XXXXXX        0         01-Jul-09           30-Jun-10      0.00                             261            261



                                                             PAYROLL PROJECTION SUMMARY
                                                          UAA COMMUNITY & TECHNICAL COLLEGE
                                                                                                          0
Data thru LD#                        0
LD ending date                       30-Jun-09                                                 No Data Entry
                                                                           Hrs
                   Hourly                Benefit     Beg         Stop      Per     Total     Total     Total      Total
         Name      Wage         PCN       Type       Date        Date      Day     Salary   Benefits   Labor   Leave Days
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
                   $0.00      XXXXXX       0       01-Jul-09   30-Jun-10   0.00      0         0        0         (12)
TOTALS                                                                      0        0         0        0




                TOTAL PERSONNEL SUMMARY


                               Gross     Annual      Sick       Holiday    Total   Total     Total     Total
                              Earnings   Leave      Leave        Leave     Leave   Salary   Benefits   Labor
                (NO DATA ENTRY)
                Total Payroll    0         0          0           0         0        0         0        0


                TOTAL            0         0          0           0         0        0         0        0
                                                                    Start        End                                         Holiday            Holidays          \P

                                            LD#                     Date        Date                                               Date         Remaining
-------------------------------------------------- ------------------------       -                               ------------------------ --------------------




                                                0            6/30/2009        6/30/2009    July 30, Cycle 1            6/30/2009                           12
                                              15               7/1/2009        7/4/2009    July 30, Cycle 1             7/4/2009                           11
                                              16               7/5/2009       7/18/2007    July 30, Cycle 1             7/3/2009                           10     \A
                                              17             7/19/2009         8/1/2009    August 31, Cycle 2           9/7/2009                            9
                                              18               8/2/2009       8/15/2009    August 31, Cycle 2         11/26/2009                            8
                                              19             8/16/2009        8/29/2009    August 31, Cycle 2         11/27/2009                            7
                                              20             8/30/2009        9/12/2009    Sept 30, Cycle 3           12/24/2009                            6
                                              21             9/13/2009        9/26/2009    Sept 30, Cycle 3           12/25/2009                            5     \I
                                              22             9/27/2009        10/10/2009   October 31, Cycle 4        12/31/2009                            4
                                              23           10/11/2009         10/24/2009   October 31, Cycle 4          1/1/2010                            3
                                              24           10/25/2009         11/7/2009    November 30, Cycle 5        1/18/2010                            2
                                              25             11/8/2009        11/21/2009   November 30, Cycle 5        3/12/2010                            1
                                              26           11/22/2009         12/5/2009    December 31, Cycle 6        5/31/2010                            0
                                              a1             12/6/2009        12/19/2009   December 31, Cycle 6
                                              b2           12/20/2009          1/2/2010    January 31, Cycle 7
                                              c3               1/3/2010       1/16/2010    January 31, Cycle 7
                                              d4             1/17/2010        1/30/2010    January 31, Cycle 7                          0                   1
                                              e5             1/31/2010        2/13/2010    February 28, Cycle 8                         1                   1     \D
                                               f6            2/14/2010        2/27/2010    February 28, Cycle 8                         2                   1
                                              g7             2/28/2010        3/13/2010    March 31, Cycle 9                            3                   1
                                              h8             3/14/2010        3/27/2010    March 31, Cycle 9                            4                   1
                                               i9            3/28/2010        4/10/2010    April 30, Cycle 10                           5                   0
                                             j10             4/11/2010        4/24/2010    April 30, Cycle 10                           6                   0
                                            k11              4/25/2010         5/8/2010    May 31, Cycle 11                             7                   1
                                             l12               5/9/2010       5/22/2010    May 31, Cycle 11                             8                   0
                                           m13               5/23/2010         6/5/2010    June 30, Cycle 12                            9                   0
                                            n14                6/6/2010       6/19/2010    June 30, Cycle 12                          11                    0
                                            o15              6/20/2010        6/30/2010    June 30, Cycle 12
                                Annual      Sick      Holiday    Total                 Staff
                                Leave      Leave      Leave      Leave                Benefits

                                 9.12%      5.75%      6.43%     21.30%                57.00%
                                 9.42%      6.78%      6.10%     22.30%                53.83%

                                10.14%      4.59%      5.47%     20.20%                44.10%
Extended Temporary               5.21%      3.35%      5.44%     14.00%                41.90%
                                 9.97%      3.38%      5.35%     18.70%                28.20%
                                 0.00%      1.70%      0.00%     1.70%                 31.90%
                                 0.00%      1.10%      0.00%     1.10%                 32.40%
Faculty non-represented          9.97%      3.38%      5.35%     18.70%                28.20%
Faculty-Temp rep/non-rep         0.00%      0.00%      0.00%     0.00%                 9.50%
                                 0.00%      0.00%      0.00%     0.00%                 8.00%
                                 0.00%      0.00%      0.00%     0.00%                 8.00%
Students non-taxable             0.00%      0.00%      0.00%     0.00%                 0.00%




                  Column L     Column M   Column N   Column O   Column P   Column Q              Column S   Column T   Column U   Column V   Column W   Column X
                                                                             Total                  Net
                        Sick    Holiday    Annual    Personal    Other      Days of                 Hrs      Gross      Annual      Sick      Holiday    Total
                       Leave    Leave      Leave      Leave      Leave       Leave                 Rem      Earnings    Leave      Leave      Leave      Leave

                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
                        0        -12         0          0          0         -12                    0          0          0          0          0          0
/wchL1~/WCHQ1~                                       \P M128..M130

/ppos{esc}\015\143~qagpq
/wcda1..bj1~




/ppos{esc}\015\143~qagpq                             \A M132..M133




                 /WGPD
                 /WIR~
                 {UP}{END}{LEFT}/C{END}{RIGHT 25}~
                 {DOWN}~
                 {DOWN}
                 /RE{RIGHT 7}~
                 /WGPE




                 /rfd~~@date({?})~
                                  Form P-3




Column Y   Column Z   Column AA

 Total      Total       Total
 Salary    Benefits     Labor

   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
   0          0          0
#VALUE!   #VALUE!   #VALUE!   #VALUE!   #VALUE!   #VALUE!
2000- Travel Softledger
0
0

                                                  Year to Date Activity Totals            $0.00     $0.00      $0.00      $0.00
    Updated:     5/19/2013 6:44
                                                                                          Reserv    YTD        Open
                                        Object            Item                            Encumb   Expense    Encumb     Expense
     Date             Vendor            Code           Description           Doc #        Amount   Activity   Balance   Projection

    7/1/2009   TOTAL UNDETAILED PROJECTED EXPENSE                                                                          0.00
Note: Acct codes 2010, 2110, 2210 & 2310 are not normally used for Grants and Contracts    0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
                                                                                           0.00      0.00      0.00        0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
Formula requires input of estimate
Do not use formula when a negative results




      0.00       0.00




      0.00       0.00
3000- Contractual Services Softledger
0
0

                                             Year to Date Activity Totals       $0.00     $0.00      $0.00      $0.00
    Updated:     5/19/2013 6:44
                                                                                Reserv    YTD        Open
                                    Object           Item                       Encumb   Expense    Encumb     Expense
     Date           Vendor          Code          Description           Doc #   Amount   Activity   Balance   Projection

    7/1/2009   TOTAL UNDETAILED PROJECTED EXPENSE                                                                0.00
                                                                                 0.00      0.00      0.00        0.00
Note: Acct code 3008 is not used for Grants and Contracts purchases              0.00      0.00      0.00        0.00
    3018                    FOOD/DECORATIONS FOR SPECIAL EVENTS                  0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
     3118                             SPACE RENTAL                               0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
     3331                         DUPLICATING CHARGES                            0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                      JULY                                                       0.00      0.00      0.00        0.00
                    AUGUST                                                       0.00      0.00      0.00        0.00
                  SEPTEMBER                                                      0.00      0.00      0.00        0.00
                   OCTOBER                                                       0.00      0.00      0.00        0.00
                  NOVEMBER                                                       0.00      0.00      0.00        0.00
                  DECEMBER                                                       0.00      0.00      0.00        0.00
                    JANUARY                                                      0.00      0.00      0.00        0.00
                   FEBRUARY                                                      0.00      0.00      0.00        0.00
                     MARCH                                                       0.00      0.00      0.00        0.00
                      APRIL                                                      0.00      0.00      0.00        0.00
                       MAY                                                       0.00      0.00      0.00        0.00
                      JUNE                                                       0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
     3332                           PRINTING SERVICES                            0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
     3441                         PHONE RENTAL CHARGES                           0.00      0.00      0.00        0.00
                                                                                 0.00      0.00      0.00        0.00
                      JULY                                                       0.00      0.00      0.00        0.00
                    AUGUST                                                       0.00      0.00      0.00        0.00
                  SEPTEMBER                                                      0.00      0.00      0.00        0.00
                   OCTOBER                                                       0.00      0.00      0.00        0.00
                  NOVEMBER                                                       0.00      0.00      0.00        0.00
                  DECEMBER                                                       0.00      0.00      0.00        0.00
                    JANUARY                                                      0.00      0.00      0.00        0.00
                   FEBRUARY                                                      0.00      0.00      0.00        0.00
                     MARCH                                                       0.00      0.00      0.00        0.00
         APRIL                                                0.00   0.00   0.00   0.00
          MAY                                                 0.00   0.00   0.00   0.00
         JUNE                                                 0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
3442             TOLL CHARGES (LONG DISTANCE)                 0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
           JULY                                               0.00   0.00   0.00   0.00
         AUGUST                                               0.00   0.00   0.00   0.00
       SEPTEMBER                                              0.00   0.00   0.00   0.00
        OCTOBER                                               0.00   0.00   0.00   0.00
       NOVEMBER                                               0.00   0.00   0.00   0.00
       DECEMBER                                               0.00   0.00   0.00   0.00
         JANUARY                                              0.00   0.00   0.00   0.00
        FEBRUARY                                              0.00   0.00   0.00   0.00
          MARCH                                               0.00   0.00   0.00   0.00
           APRIL                                              0.00   0.00   0.00   0.00
            MAY                                               0.00   0.00   0.00   0.00
           JUNE                                               0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
3444                         POSTAGE                          0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
           JULY                                               0.00   0.00   0.00   0.00
         AUGUST                                               0.00   0.00   0.00   0.00
       SEPTEMBER                                              0.00   0.00   0.00   0.00
        OCTOBER                                               0.00   0.00   0.00   0.00
       NOVEMBER                                               0.00   0.00   0.00   0.00
       DECEMBER                                               0.00   0.00   0.00   0.00
         JANUARY                                              0.00   0.00   0.00   0.00
        FEBRUARY                                              0.00   0.00   0.00   0.00
          MARCH                                               0.00   0.00   0.00   0.00
           APRIL                                              0.00   0.00   0.00   0.00
            MAY                                               0.00   0.00   0.00   0.00
           JUNE                                               0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
3446                  CELL PHONE CHARGES                      0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
3661               TUITION/REGISTRATION FEES                  0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
3662                 DUES AND MEMBERSHIPS                     0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
3771       Repairs and Alteration Services (physical Plant)   0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                                              0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
3775    Equipment Maintenance       0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
3991   Other Contractual Services   0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
3XXX            BLANK               0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
                                    0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00

0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
Formula requires input of estimate
Do not use formula when a negative results




      0.00       0.00




      0.00       0.00




      0.00       0.00




      0.00       0.00
0.00   0.00




0.00   0.00




0.00   0.00




0.00   0.00




0.00   0.00




0.00   0.00
0.00   0.00




0.00   0.00




0.00   0.00




0.00   0.00




0.00   0.00
4000- Commodities Softledger
0
0

                                                 Year to Date Activity Totals       $0.00     $0.00      $0.00      $0.00
    Updated:     5/19/2013 6:44
                                                                                    Reserv    YTD        Open
                                       Object            Item                       Encumb   Expense    Encumb     Expense
     Date            Vendor            Code           Description           Doc #   Amount   Activity   Balance   Projection

    7/1/2009   TOTAL UNDETAILED PROJECTED EXPENSE                                                                    0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
Note: Acct codes 4010 and 4014 are not used for Grants and Contracts purchases       0.00      0.00      0.00        0.00
    4012                                    Lab Supplies                             0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
     4015                                 Project Supplies                           0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
     4018                      Food/Decorations for Special Events                   0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                                                                                     0.00      0.00      0.00        0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
4112          Parts          0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
4221   Subscriptions/Books   0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
4XXX         BLANK           0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
                             0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
Formula requires input of estimate
Do not use formula when a negative results




      0.00       0.00




      0.00       0.00
0.00   0.00




0.00   0.00




0.00   0.00




0.00   0.00
5000- Equipment (over $5,000)
0
0

                                           Year to Date Activity Totals       $0.00     $0.00      $0.00      $0.00
    Updated:     5/19/2013 6:44
                                                                              Reserv    YTD        Open
                                  Object           Item                       Encumb   Expense    Encumb     Expense
     Date           Vendor        Code          Description           Doc #   Amount   Activity   Balance   Projection

    7/1/2009   TOTAL UNDETAILED PROJECTED EXPENSE                                                              0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
Formula requires input of estimate
Do not use formula when a negative results




      0.00       0.00




      0.00       0.00
8000- Misc Expense Softledger
0
0

                                           Year to Date Activity Totals       $0.00     $0.00      $0.00      $0.00
    Updated:     5/19/2013 6:44
                                                                              Reserv    YTD        Open
                                  Object           Item                       Encumb   Expense    Encumb     Expense
     Date           Vendor        Code          Description           Doc #   Amount   Activity   Balance   Projection

    7/1/2009   TOTAL UNDETAILED PROJECTED EXPENSE                                                              0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
                                                                               0.00      0.00      0.00        0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
0.00   0.00   0.00   0.00
Formula requires input of estimate
Do not use formula when a negative results




      0.00       0.00




      0.00       0.00
Previous Fiscal Year Expense Softledger
0
0

                                                        Year to Date Activity Totals                                  $0.00
    Updated:          5/19/2013 6:44
                                                                                                          Reserv      YTD
                                               Object             Item                                    Encumb     Expense
     Date                 Vendor               Code            Description                 Doc #          Amount     Activity

               TOTAL UNDETAILED PROJECTED EXPENSE
Note: Acct codes not used for Grants and Contracts purchases: 2010, 2110, 2210, 2310, 3008, 4010, 4014
                        PERSONNEL               # HRS             SALARY                 LEAVE BEN       STAFF BEN   TOTAL
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                                                                                     $0.00
                                                        Year to Date Activity Totals                                 $0.00

                                                        TRAVEL                                                         0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                        Year to Date Activity Totals                                  $0.00

                                                   CONTRACTUAL                                                         0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                                                                                       0.00
                                                        Year to Date Activity Totals                                  $0.00
     COMMODITIES                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
        Year to Date Activity Totals   $0.00

INDIRECT COST RECOVERY
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
        Year to Date Activity Totals   $0.00

  MISC 8000 EXPENSE
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
                                        0.00
        Year to Date Activity Totals   $0.00
Cell g5 links to Summary page




data found Qmenu Labor Summary
Grant Budget Model Checklist
If you are setting up the model for the new year, and/or need to input last year's data, these
hints will help, but if you are new the model, please call Kelly Thorngren at 786-6497 for
assistance.

1. Input grant or contract title for fund into cell G2 on the Grant Summary
spreadsheet. Include fund # if you like.
2. Input grant #, fund #, org # and type of grant (grant focus) into cells C4, C5, C6,
C7 on Grant Summary page. Input funding agency, grant begin and end dates, and
contract type into cells H5, H6, and H7 on Grant Summary page.
3. Input appropriate indirect rates as directed on the Summary page into cells E27,
D28 and D29.
4. Refer to grant/contract documnenation to pull out dates that deliverables such
as reports are due to the funding agency. Note these on the Grant Summary page
for PI reference, reminder and tracking.

5. Input latest pay period (LD) number into cell K4 on the Grant Summary page.
6. For non-personnel expense, pull up Inception to Date (ITD) report in either
Qmenu or Banner (FRIGITD). Input non-personnel expense transactions by
account code into Previous FY Expense softledger and Current Year Expense
Softledger, depending upon date. Note: Qmenu ITD will not show detail for any
8000 Misc expense items. Look these up in FRIGITD or FGIBDST in Banner, right
click for detail option. Also, current year transactions can be input monthly from
Vista Plus "Organizational Detail Activity" report as management reports are
completed each cycle.

7. For previous year personnel expense, pull up the Labor Summary Report in
Qmenu or NHIDIST in Banner. Input previous FY labor expense into the Previous
FY Expense softledger. Note: JPAY personnel transfers will not be included on the
Qmenu Labor Summary Report. Research any differences in FRIGITD.

8. Input current year personnel expenses into the Payroll spreadsheet.

9. Pull up current year budget in Banner FGIBDST, also shown on latest Vista Plus
"Budget Status Current Year" report. Input current year budget by account type into
column E on the Summary page.
10. Input current year YTD expense for personnel into cell G12 and cell G18 for
Indirect Cost Recovery
11. Balance bottom line to Inception to Date report balances for total budget,
expense and encumbrance columns. The current fiscal year bottom line can be
balanced to Vista Plus Budget Status report or Banner FGIBDST, depending upon
date of transactions input to current year Expense Softledger.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/19/2013
language:Unknown
pages:59
yan tingting yan tingting
About