Activities Worksheets - Excel by ghu56923

VIEWS: 52 PAGES: 7

Activities Worksheets document sample

More Info
									       Division
       Branch
       Employee:

       First Name
       Last Name,
       Administrative: Financial
       Management Activities

       1099 Processing

       Accounting
                                                                            Blank Financial Mgmt Activities Worksheet




       Cash Receipts/Management

       Develop/maintain methodologies

       Develop/maintain support systems

       Handle auditor compliance/inquiries
                                             hide the activities again.
                                             4) Click on the "-" sign to




       Review cost allocation reports

       Cost Allocation

       Vendor Processing: Establish
       vendor file
       Vendor Table Maintenance-Agency
       Level

       Vendor Table Maintenance-Central

       Wire Transfer Warrant
                                              see specific activities.




       Blank
                                              2) Click on the "+" sign to




       Blank

       Supervisory Activities

       Blank
       Blank
       Blank - Add more activities.

       SUBTOTALS (FTE's): Financial
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00




       Management
                                                     you have added.




       Comments
                                                     7) Enter comments to
                                                     describe any activities
                               3) Enter % FTEs (on a scale                                     6) Use these columns to
1) Copy these columns from                                   5) Use these columns to enter
                               of 0-1) that each employee                                      enter any other activities
columns A-C of the Personnel                                 any supervisory activities that
                               spends on these activities.                                     that are not listed.
Data Worksheet.                                              have not been listed elsewhere.
                       Mgmt
                       Financial
                                   Division
                                   Branch
                                   Employee:

                                   First Name
                                   Last Name,




                   Roberts, Bill
          Payments Thomas, Sue
                                   Administrative: Financial
                                   Management Activities

                                   1099 Processing

                                   Accounting

                                   Cash Receipts/Management

                                   Develop/maintain methodologies
                                                                                                     Completed Financial Mgmt Activities Worksheet




          0.10
                                   Develop/maintain support systems

                                   Handle auditor compliance/inquiries


          0.10 0.20                Review cost allocation reports
          0.10 0.20


                                   Cost Allocation

                                   Vendor Processing: Establish
                                   vendor file
                                   Vendor Table Maintenance-Agency
                                   Level

                                   Vendor Table Maintenance-Central

                                   Wire Transfer Warrant

                                   Supervises clerical assistant
          0.40




                                   Blank

                                   Supervisory Activities
                                   Blank - Add more activities.

                                   SUBTOTALS (FTE's): Financial
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.80




                                   Management
                                                                         Note: This column sums the

                                                                         FTEs entered for each employee.




     process
     Supervises
     Comments
                                                                         percentages of Financial Management




0.30 receivables.
     assistants who
Note: You do not have to enter 0 if no       Note: If you do add an activity, be sure to give
time is spent on this activity; just leave   it a descriptive name and detail it in the
cell blank.                                  "Comments" column.
                                                               Activities Summary



Completed Summary Activities Worksheet




                                                                                                                    SUBTOTALS (FTE's): Cyclical
                                                                      Financial Management



                                                                                             Materials Management
                                                                      SUBTOTALS (FTE's):



                                                                                             SUBTOTALS (FTE's):




                                                                                                                                                  SUBTOTALS (FTE's):
                                                                                                                                                  Non-Administrative




                                                                                                                                                                        TOTALS (FTEs)



                                                                                                                                                                                         Uses KAPS
                                                                                                                    or Support
                                     Employee:
   Division            Branch        Last Name, First Name
Financial Mgmt Payments              Thomas, Sue                        0.30                   0.00                    0.20                         0.50               1.00               X
                                     Roberts, Bill                      0.80                   0.00                    0.00                         0.20               1.00
                                                                        0.00                   0.00                    0.00                         0.00               0.00
                                                                        0.00                   0.00                    0.00                         0.00               0.00
                                                                        0.00                   0.00                    0.00                         0.00               0.00
                                                                        0.00                   0.00                    0.00                         0.00               0.00
                                                                        0.00                   0.00                    0.00                         0.00               0.00
                                                                        0.00                   0.00                    0.00                         0.00               0.00
                                                                        0.00                   0.00                    0.00                         0.00               0.00




7a742a6a-d2ea-445d-8fe7-e2fc493bfd3a.xls, Activities Summary                                                                                                                            12/5/2010
                                                               Activities Summary


            These columns are automatically                         These columns are           This column sums all of
            copies from the Financial Mgmt                          automatically copied from   the "Subtotal" columns.
            Activities worksheet.                                   the respective activities   Check to be sure each
                                                                    worksheet.                  row equals 1.0!




7a742a6a-d2ea-445d-8fe7-e2fc493bfd3a.xls, Activities Summary                                                              12/5/2010
                                                               Activities Summary

   Uses STARS




7a742a6a-d2ea-445d-8fe7-e2fc493bfd3a.xls, Activities Summary                        12/5/2010

								
To top