Docstoc

timesheet-and-cost-allocation-samples

Document Sample
timesheet-and-cost-allocation-samples Powered By Docstoc
					Pay Period Ending 12/15/2008                              Program Assistant
          Program / Project                 M       T       W      Th     F       Sa   Su Total
Program A
 Program A                                         2.00     5.00   4.00   3.00                14.00 43.75%
Program B
 Program B                                         3.00     3.00   2.00   2.00                10.00 31.25%
   Program B-1                                                                                  -   0.00%
   Program B-2                                     2.00                                        2.00 6.25%
Program C
 Program C                                                                                      -     0.00%
Administration
 Administration                                    1.00            1.00                        2.00 6.25%
Fundraising                                                        1.00   3.00                 4.00 12.50%
Total Work Hours                            -      8.00     8.00   8.00   8.00    -    -      32.00 100.00% 32.0
              Leave Time
Sick Leave                                 8.00                                                8.00
Vacation                                                                                        -
Total Leave Hours                          8.00     -        -      -      -      -    -       8.00

Total Paid Hours                              8.00 8.00      8.00 8.00 8.00 -            -      40.00         40.00
    I certify that the information on this timesheet is complete and accurate to the best of my knowledge.
                                     Name:                            Approved:

                                 Date:                                    Date:
For Hourly Employees Only. This Section Must Be Completed
                                     In  9     9    9      9                9
                                  Out 12      12   12     12               12
                                     In 12.3 12.3 12.3 12.3               12.3
                                  Out    5     5    5      5                5
  Did you take your breaks today? Y / N  y     y    y      y                y
PAYROLL PERIOD RECONCILIATION REPORT FOR DATA ENTRY
PAYROLL PERIOD:  FROM 12/1/2008    TO    12/15/2008
                                                                 TIME
DEPARTMENT       Anne      Jane      Bill    Peter   TOTAL    PERCENTAGE
Program A        56.00%    24.00%   25.00%             1.05        26.25%
Program B                  60.00%   25.00%             0.85        21.25%
 Program B-1                        10.00%             0.10         2.50%
 Program B-2     16.00%    16.00%   20.00%             0.52        13.00%
Program C                                              0.00         0.00%
Administration   28.00%             20.00%             0.48        12.00%
Fundraising                                  100.00%   1.00        25.00%
TOTAL            100.00%   100.00% 100.00%   100.00%   4.00       100.00%
PAYROLL PERIOD RECONCILIATION REPORT FOR DATA ENTRY
PAYROLL PERIOD:   FROM      12/1/2008  TO     12/15/2008
                                                                              PAYROLL
DEPARTMENT             Anne       Jane        Bill     Peter     TOTAL      PERCENTAGE
      Gross Payroll   1,200.00   1,400.00   3,000.00    800.00   6,400.00
Program A               672.00     336.00     750.00       -     1,758.00        27.47%
Program B                  -       840.00     750.00       -     1,590.00        24.84%
 Program B-1               -          -       300.00       -       300.00         4.69%
 Program B-2            192.00     224.00     600.00       -     1,016.00        15.88%
Program C                  -          -            -       -          -           0.00%
Administration          336.00        -       600.00       -       936.00        14.63%
Fundraising                -          -            -    800.00     800.00        12.50%
Total                 1,200.00   1,400.00   3,000.00    800.00   6,400.00       100.00%
             Monthly Totals           15-Dec     31-Dec     Total %
Program A                               27.47%     42.45%    34.96%
Program B                               24.84%     13.93%    19.39%
 Program B-1                             4.69%      4.26%     4.47%
 Program B-2                            15.88%     16.00%    15.94%
Program C                                0.00%     17.62%     8.81%
Administration                          14.63%      5.74%    10.18%
Fundraising                             12.50%      0.00%     6.25%
                              Total    100.00%    100.00%   100.00%
                 Cost Pool:     910            910            920            920          Total
                  Account     Supplies       Rent           Salaries      Health Ins.
                 Payroll %      8110          8210           7210           7240
Program A         34.96%      $ 174.80   $   1,398.36   $    12,235.66   $     769.10   14,577.92
Program B         19.39%      $ 96.94    $     775.56   $     6,786.11   $     426.56    8,085.16
 Program B-1       4.47%      $ 22.36    $     178.92   $     1,565.52   $      98.40    1,865.21
 Program B-2      15.94%      $ 79.69    $     637.50   $     5,578.13   $     350.63    6,645.94
Program C          8.81%      $ 44.05    $     352.40   $     3,083.50   $     193.82    3,673.77
Administration    10.18%      $ 50.92    $     407.36   $     3,564.40   $     224.05    4,246.73
Fundraising        6.25%      $ 31.25    $     250.00   $     2,187.50   $     137.50    2,606.25
                  100.00%     $ 500.00 $ 4,000.00 $          35,000.00 $     2,200.00   41,700.00
41,700.97   0.97

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:8/16/2012
language:English
pages:6