Resource Template by mjq65510

VIEWS: 10 PAGES: 29

Resource Template document sample

More Info
									                                                   Enter Hours worked for this time period and Justificati
                                                   period). Cost will be calculated by [Enter Program com
Month 1, 2006                                      [enter liaison name and number] TO DO THIS FOR YOU

                                                        Hours             Cost

Enter Program - Division Name from tab 1
Enter Employee Name 1                                                 $        -
Enter Employee Name 2                                                 $        -
Enter Employee Name 3                                                 $        -
Enter Employee Name 4                                                 $        -
Enter Employee Name 5                                                 $        -
Enter Employee Name 6                                                 $        -
Enter Employee Name 7                                                 $        -
Enter Employee Name 8                                                 $        -
Enter Employee Name 9                                                 $        -
Enter Employee Name 10                                          2.0   $      72.92
Enter Employee Name 11                                                $        -
Enter Employee Name 12                                          4.0   $     165.17
Enter Employee Name 13                                                $        -
Enter Employee Name 14                                                $        -
Enter Employee Name 15                                                $        -
Enter Employee Name 16                                                $        -
Enter Employee Name 17                                                $        -
Enter Employee Name 18                                                $        -
                           Sub-Total, Program 1:                6.0   $     238.09

Enter Program - Division Name from tab 1
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                      $          -
                           Sub-Total, Program 2:                -     $          -

Enter Program - Division Name from tab 1
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                      $          -
                                                                     $      -
                            Sub-Total, Program 3:              -     $      -

Enter Program - Division Name from tab 1
                                                                     $      -
                                                                     $      -
                                                                     $      -
                            Sub-Total, Program 4:              -     $      -

Enter Program - Division Name from tab 1
                                                                     $      -
                                                                     $      -
                                                                     $      -
                            Sub-Total, Program 5:              -     $      -

                   Agency Total, this time period:             6.0   $   238.09


D:\Docstoc\Working\pdf\[ea8dced4-3cf6-40c7-a7bd-cbe50c79ce8d.xls]Rates
r this time period and Justification (I.e., what Audit activity you were involved in during this time
 lculated by [Enter Program compiling data]. DO NOT ADD ROWS OR NAMES. PLEASE CONTACT
d number] TO DO THIS FOR YOU.

                                                   Justification




            Internal meetings; correspondence with auditor

            Reviewed auditor docs
                                                   Enter Hours worked for this time period and Justificati
                                                   period). Cost will be calculated by [Enter Program com
Month 2, 2006                                      [enter liaison name and number] TO DO THIS FOR YOU

                                                        Hours            Cost

Enter Program - Division Name from tab 1
                                                                     $          -
Enter Employee Name 1                                                $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -



                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 1:                -    $          -

Enter Program - Division Name from tab 1                             $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 2:                -    $          -

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                    $    -
                            Sub-Total, Program 3:              -    $    -

Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 4:              -    $    -

Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 5:              -    $    -

                   Agency Total, this time period:             -    $    -


D:\Docstoc\Working\pdf\[ea8dced4-3cf6-40c7-a7bd-cbe50c79ce8d.xls]Rates
r this time period and Justification (I.e., what Audit activity you were involved in during this time
 lculated by [Enter Program compiling data]. DO NOT ADD ROWS OR NAMES. PLEASE CONTACT
d number] TO DO THIS FOR YOU.

                                                   Justification
                                                   Enter Hours worked for this time period and Justificati
                                                   period). Cost will be calculated by [Enter Program com
Month 3, 2006                                      [enter liaison name and number] TO DO THIS FOR YOU

                                                        Hours            Cost

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 1:                -    $          -

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 2:                -    $          -

Enter Program - Division Name from tab 1




                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 3:                -    $          -
Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 4:              -    $    -

Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 5:              -    $    -

                   Agency Total, this time period:             -    $    -


D:\Docstoc\Working\pdf\[ea8dced4-3cf6-40c7-a7bd-cbe50c79ce8d.xls]Rates
r this time period and Justification (I.e., what Audit activity you were involved in during this time
 lculated by [Enter Program compiling data]. DO NOT ADD ROWS OR NAMES. PLEASE CONTACT
d number] TO DO THIS FOR YOU.

                                                   Justification
                                                   Enter Hours worked for this time period and Justificati
                                                   period). Cost will be calculated by [Enter Program com
Month 4, 2006                                      [enter liaison name and number] TO DO THIS FOR YOU

                                                        Hours            Cost

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 1:                -    $          -

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 2:                -    $          -

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                    $    -
                            Sub-Total, Program 3:              -    $    -

Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 4:              -    $    -

Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 5:              -    $    -

                   Agency Total, this time period:             -    $    -


D:\Docstoc\Working\pdf\[ea8dced4-3cf6-40c7-a7bd-cbe50c79ce8d.xls]Rates
r this time period and Justification (I.e., what Audit activity you were involved in during this time
 lculated by [Enter Program compiling data]. DO NOT ADD ROWS OR NAMES. PLEASE CONTACT
d number] TO DO THIS FOR YOU.

                                                   Justification
                                                   Enter Hours worked for this time period and Justificati
                                                   period). Cost will be calculated by [Enter Program com
Month 5, 2006                                      [enter liaison name and number] TO DO THIS FOR YOU

                                                        Hours            Cost

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 1:                -    $          -

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 2:                -    $          -

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                    $    -
                            Sub-Total, Program 3:              -    $    -

Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 4:              -    $    -

Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 5:              -    $    -

                   Agency Total, this time period:             -    $    -


D:\Docstoc\Working\pdf\[ea8dced4-3cf6-40c7-a7bd-cbe50c79ce8d.xls]Rates
r this time period and Justification (I.e., what Audit activity you were involved in during this time
 lculated by [Enter Program compiling data]. DO NOT ADD ROWS OR NAMES. PLEASE CONTACT
d number] TO DO THIS FOR YOU.

                                                   Justification
                                                   Enter Hours worked for this time period and Justificati
                                                   period). Cost will be calculated by [Enter Program com
Month 6, 2006                                      [enter liaison name and number] TO DO THIS FOR YOU

                                                        Hours            Cost

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 1:                -    $          -

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                           Sub-Total, Program 2:                -    $          -

Enter Program - Division Name from tab 1
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                     $          -
                                                                    $    -
                            Sub-Total, Program 3:              -    $    -

Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 4:              -    $    -

Enter Program - Division Name from tab 1
                                                                    $    -
                                                                    $    -
                                                                    $    -
                            Sub-Total, Program 5:              -    $    -

                   Agency Total, this time period:             -    $    -


D:\Docstoc\Working\pdf\[ea8dced4-3cf6-40c7-a7bd-cbe50c79ce8d.xls]Rates
r this time period and Justification (I.e., what Audit activity you were involved in during this time
 lculated by [Enter Program compiling data]. DO NOT ADD ROWS OR NAMES. PLEASE CONTACT
d number] TO DO THIS FOR YOU.

                                                   Justification
                                                   DO NOT MODIFY THIS TA
TOTAL - ALL TIME PERIODS                              Hours


Enter Program - Division Name from tab 1
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              2.0
                                                              -
                                                              4.0
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                            Sub-Total, Program 1              6.0

Enter Program - Division Name from tab 1
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                           Sub-Total, Program 2:              -

Enter Program - Division Name from tab 1
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                                                              -
                            Sub-Total, Program 3:                    -

Enter Program - Division Name from tab 1
                                                                     -
                                                                     -
                                                                     -
                            Sub-Total, Program 4:                    -

Enter Program - Division Name from tab 1
                                                                     -
                                                                     -
                                                                     -
                            Sub-Total, Program 5:                    -
Additional Costs
   Attorney Fees (AGO costs)
   Duplication/Printing Costs
   Enter costs as appropriate

                                       Sub-Total
                                    Agency Total:                    6.0


D:\Docstoc\Working\pdf\[ea8dced4-3cf6-40c7-a7bd-cbe50c79ce8d.xls]Rates
OT MODIFY THIS TAB
         Cost




     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $           72.92
     $             -
     $          165.17
     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $          238.09



     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $             -



     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
     $             -
$      -



$      -
$      -
$      -
$      -



$      -
$      -
$      -
$      -




$      -
$   238.09
Y THIS TAB
                                           DO NOT MODIFY THIS TA
                                             Monthly (SPS 10/26/04)
Enter Program - Division Name from tab 1     ENTER Employee Salary
Enter Employee 1                                                 4,540
Enter Employee 2                                                 3,916
Enter Employee 3                                                 4,100
Enter Employee 4                                                 5,112
Enter Employee 5                                                 6,240
Enter Employee 6                                                 7,129
Enter Employee 7                                                 8,444
Enter Employee 8                                                 2,468
Enter Employee 9                                                 5,400
Enter Employee 10                                                5,000
Enter Employee 11                                                5,950
Enter Employee 12                                                5,663
Enter Employee 13                                                6,031
Enter Employee 14                                                7,500
Enter Employee 15                                                4,788
Enter Employee 16                                                9,583
Enter Employee 17                                                2,984
Enter Employee 18                                                5,700


Enter Program - Division Name from tab 1
Enter Empolyee 19                                                5,632
Enter Empolyee 20                                                6,250
Enter Empolyee 21                                                6,610
Enter Empolyee 22                                                3,916
Enter Empolyee 23                                                6,291
Enter Empolyee 24                                                7,900


Enter Program - Division Name from tab 1
                                                                 4,540
                                                                 7,600
                                                                 6,094
                                                                 5,273
                                                                 4,216
                                                                 6,409
                                                                 6,051
                                                                 6,051
                                                                 5,996
                                                                 5,132
Enter Program - Division Name from tab 1
                                           5,805
                                           7,849
                                           6,090


Enter Program - Division Name from tab 1
                                           7,500
                                           5,535
                                           4,540
ODIFY THIS TAB!
       Hourly (M/168)           Benefit (22.5% average)      Total

                        27.02                         6.08           33.10
                        23.31                         5.24           28.55
                        24.40                         5.49           29.90
                        30.43                         6.85           37.28
                        37.14                         8.36           45.50
                        42.43                         9.55           51.98
                        50.26                        11.31           61.57
                        14.69                         3.31           18.00
                        32.14                         7.23           39.38
                        29.76                         6.70           36.46
                        35.42                         7.97           43.39
                        33.71                         7.58           41.29
                        35.90                         8.08           43.98
                        44.64                        10.04           54.69
                        28.50                         6.41           34.91
                        57.04                        12.83           69.88
                        17.76                         4.00           21.76
                        33.93                         7.63           41.56




                        33.52                         7.54           41.07
                        37.20                         8.37           45.57
                        39.35                         8.85           48.20
                        23.31                         5.24           28.55
                        37.45                         8.43           45.87
                        47.02                        10.58           57.60




                        27.02                         6.08           33.10
                        45.24                        10.18           55.42
                        36.27                         8.16           44.44
                        31.39                         7.06           38.45
                        25.10                         5.65           30.74
                        38.15                         8.58           46.73
                        36.02                         8.10           44.12
                        36.02                         8.10           44.12
                        35.69                         8.03           43.72
                        30.55                         6.87           37.42
34.55    7.77   42.33
46.72   10.51   57.23
36.25    8.16   44.41




44.64   10.04   54.69
32.95    7.41   40.36
27.02    6.08   33.10

								
To top