Docstoc

Shift Template Weekly

Document Sample
Shift Template Weekly Powered By Docstoc
					Community Living Agencies Network - CLANBC                                                       For help with this spreadsheet, write to ernie@spectrumsociety.org or jrogers@cls-bc.org
Pay Equity Uplift Calculations
December 2009                                                                                    ** CONFIDENTIAL INFORMATION **
Step One: Agency Name:

Step Two: Your Benefits %                                                         (Calculate your current benefits cost as a percent of scheduled hours using the second tab at the bottom, if you don't know that number)
                                                                                  (Line 33 on the tab below)

Step Three: Your Hours and Rates:        (in blue columns below (C) and (E))      (Enter the number of hours for each type of work that you pay weekly, in Column C)
                                                                                  (Enter the average rate you pay for each type of work in Column E)

Step Four: Your Funding in 08/09:                                                 (Confirm the funding number from the CLBC report on Contracts)        Link to CLBC Report

                                                                                                                                                                                0.00%       42.20%         Summary of Wage Equity Increases
                  (A)                                      (B)                       (C)             (D)          (E)          (F)           (G)              (H)            (I)           (J)                     (K)           (L)           (M)          (N)
                                                                                    0809                       Average                                                     Current    Costing Tool
                                                                                    Hours          F0809         Rate                     Current                          Agency       Benefits                                           Costing tool
                                                        Position                    Weekly         Hours        F0910        Step 3       Wages         Step 3 Wages       Benefits      42.2%                                 Current     Benchmarks
Day/Evening                              Supervisor / Coordinator                                       -                      22.78             -               -                -            -           Wages                     -              -
                                         CSW / Counsellor                                               -                      17.36             -               -                -            -
                                         Program Director / Senior Manager                              -                      22.78             -               -                -            -           Benefits                    -             -
                                                                                                        -                                        -               -                -            -
Overnight                                Asleep                                                         -                       14.88            -               -                -            -           Wage & Benefits             -             -
                                         Semi-Awake                                                     -                       14.88            -               -                -            -
                                         Awake                                                          -                       15.42            -               -                -            -           program costs               -             -
                                                                                                                                                                                                           (ballpark of 10%)
Totals                                                                                       0             -                                       -                -              -               -       admin                       -             -
                                                                                                                                                                                                           (10% of costs)
                                                                                                                                                                                                           totals                      -             -    #DIV/0!
                                                                                  Hours                        Gross
Average Wage Calculator                                                           Worked         Rates         Wages                                                                                       new funding                               -
                                         Enter Job Category Here - Level One                                           -
                                         Enter Job Category Here - Level Two                                           -
                                         Enter Job Category Here - Level Three                                         -
                                         Enter Job Category Here - Level Four                                          -
                                         Enter Job Category Here - Level Five                                          -    #DIV/0!
                                                                                                                           Average Hourly Rate


If you have a pay grid and need to determine the average rate for that job category, you can enter the category titles above, the number of hours paid at each level, and the rate of pay at each level.
The average hourly wage for that grid will be calculated at the bottom right of the grid.




                                                                                                                                                             C:\Docstoc\Working\pdf\b663a889-0b7f-4bf6-8c55-462993c35e6a.xls ~ COSTING ~ 8/22/2011 ~ 2:10 PM
Hints:
1. Include direct staff & direct supervisor hours in schedule, exclude all non-direct staff. If direct supervisor is work

     Classification                                    M           T             W                  Th
                                  Shift        Admin         Admin      7-2:30             7-2:30
     Manager
                                  Hours        7.5           7.5        7.5                7.5


2. Deduct any unpaid breaks from total hours.

3. If direct supervisor has different hours/week (ex. 40) then others (ex. 37.5), then overwrite FTE for direct supervis

4. Complete yellow areas. Provide any additional comments in the space provided.
                                                                                              Click this button to print o
5. To save paper and print only this page click this button.                                  Comments page

     Agency Name:                                                                          Program Status:

     Program Name:                                                                         Agency Status:

     Date of Submission:                                                                   FTE Hours/Week:

     Existing Contract #:                                                                  Program Type:

     Service Capacity:


#    Classification                                    M           T             W                  Th
                                  Shift
 1 Coordinator
                                  Hours
                                  Shift
 2 Program Manager
                                  Hours
                                  Shift
 3 Awake Nights
                                  Hours
                                  Shift
 4 Asleep Nights
                                  Hours
                                  Shift
 5 Key Worker
                                  Hours
                                  Shift
 6 Key Worker
                                  Hours
                                  Shift
 7 Community Support Worker 1
                                  Hours
                                  Shift
 8 Community Support Worker 2
                                  Hours
                                  Shift
 9 Community Support Worker 3
                                  Hours
                                  Shift
10
                                  Hours
                                  Shift
11
                                  Hours
                                   Shift
12
                                   Hours
                                   Shift
13
                                   Hours
                                   Shift
14
                                   Hours
                                   Shift
15
                                   Hours
                                   Shift
16
                                   Hours
                                   Shift
17
                                   Hours
                                   Shift
18
                                   Hours
                                   Shift
19
                                   Hours
                                   Shift
20
                                   Hours
                                   Shift
21
                                   Hours
                                   Shift
22
                                   Hours
       Overall Total Hours                               0.00      0.00           0.00            0.00


                                                                          Direct Staff Wage Calculation
Line                                   Backfill        Vac. Days   Hours         Hourly              Unionized Agencies
 #                Classification           %           per Year    /week          Rate            Step
  1 Coordinator                                   0%                   0.00 $             22.79
  2 Program Manager                            50%                     0.00               22.79
  3 Awake Nights                               100%                    0.00               15.42
  4 Asleep Nights                              100%                    0.00               14.88
  5 Key Worker                                 100%                    0.00               17.36
  6 Key Worker                                 100%                    0.00               17.36
  7 Community Support Worker 1                 100%                    0.00               17.36
  8 Community Support Worker 2                 100%                    0.00               17.36
  9 Community Support Worker 3                 100%                    0.00               17.36
 10 0                                          100%                    0.00
 11 0                                                                  0.00
 12 0                                                                  0.00
 13 0                                                                  0.00
 14 0                                                                  0.00
 15 0                                                                  0.00
 16 0                                                                  0.00
 17 0                                                                  0.00
 18 0                                                                  0.00
 19 0                                                                  0.00
 20 0                                                                  0.00
 21 0                                                                  0.00
     22 0                                                                           0.00
        Direct Staffing Subtotal                       850%             -           -

                                                                                         Backfill Wage Calculation
                                               Item                                             Days/FTE               %
     23 Vacation coverage                                                                                     0.00   0.00%
     24 Statutory holiday coverage                                                                         11.00     4.23%
     25 Sick coverage                                                                                         8.00   3.08%
     26 Education & training coverage                                                                         4.00   1.54%
     27 Miscellaneous Leave (Weddings, Births, Bereavement)                                                   2.00   0.77%
     28 Other -                                                                                                      0.00%
        Backfill Staffing Subtotal                                                                         25.00     9.62%

                                                                                Benefit Calculation - Direct Staff
                                               Item                                            $/FTE/ Month            %
     29 CPP                                                                                                          4.95%
     30 EI                                                                                                           2.40%
     31 WCB                                                                                                          1.50%
     32 EHC                                  # FTE for Benefits                0.0000                                0.00%
     33 Dental                               # FTE for Benefits                0.0000                                0.00%
     34 MSP                                  # FTE for Benefits                0.0000                                0.00%
     35 LTD                                                                                                          0.00%
     36 RRSP/Pension                                                                                                 3.00%
     37 Life, EAP                            # FTE for Benefits                                                      0.52%
     38 Other -                                                                                                      0.00%
     39 Other -                                                                                                      0.00%
        Benefits - Direct Subtotal                                                         $                  -      12.37%
                                                                                        Benefit Calculation - Backfill
                                               Item                                             Days/FTE               %
     40 CPP                                                                                                          4.95%
     41 EI                                                                                                           2.42%
     42 WCB                                                                                                          1.50%
     43 Vacation Pay                                                                                                 4.00%
     44 Statutory Holiday Pay                                                                                        2.00%
     45 Other -                                                                                                      0.00%
        Benefits - Backfill Subtotal                                                                          -      14.87%
        TOTAL BENEFITS (DIRECT & BACKFILL)
 1      TOTAL WAGES AND BENEFITS
 2      TOTAL BENEFIT LOAD (BENEFITS & BACKFILL)                                                                     0.0%
 3
 4 Line                                                                     Costs
 5 # Direct Program Costs                                         Monthly                       Annual
 6      Wages and Benefits
 7 1 Direct Staff Wages                                       $         -                  $                  -
 8 2 Backfill Wages                                                     -                                     -
 9 3 Benefits on Direct Staff                                           -                                     -
10 4 Benefits on Backfill                                               -                                     -
11 5 Subtotal Wages & Benefits                                $         -                  $                  -
12      Other Direct Program Costs                                Monthly                       Annual
13 6 Meeting Expenses                                                                                         -
14 7 Program Stationery Supplies                                                                              -
15     8 Staff Training Expenses                                                              -
16     9 Cablevision                                                                          -
17    10 Clothing                                                                             -
18    11 Cleaning Supplies                                                                    -
19    12 Groceries                                                                            -
20    13 Furnishings, Linens                                                                  -
21    14 Medical Supplies                                                                     -
22    15 Professional Supports                                                                -
23    16 Recreation                                                                           -
24    17 Telephone                                                                            -
25    18 Gasoline                                                                             -
26    19 Vehicle Lease                                                                        -
27    20 Vehicle Insurance                                                                    -
28    21 Vehicle Maintenance                                                                  -
29    22 Bus / Taxi Fares                                                                     -
30    23 Mileage                                                                              -
31    24 Cable and Telphone bundle                                                            -
32          Total Direct Program Costs            $         -                $            -
33
34          Facilities                                Monthly                    Annual
35    25 Rent                                                                $                -
36    26 Gas, Electricity                                                                     -
37    27 Insurance                                                                            -
38    28 Maintenance                                                                          -
39    29 Property Taxes                                                                       -
40    30                                                                                      -
41    31                                                                                      -
42    32                                                                                      -
43    33                                                                                      -
44    34                                                                                      -
45    35                                                                                      -
46          Total Facilities Costs                $         -                $            -
47
48          Administration                 %          Monthly                    Annual
49    36 Administration                   10.0%   $            -             $                -
50          Total Costs                           $        -                 $            -
51
52   Line                                                          Funding
53    #     Funding Source                            Monthly                    Annual
54    37 PWD                                                                 $                -
55    38 OAS/GIS                                                                              -
56    39 Transportation Allowance                                                             -
57    40 BCHMC Subsidies                                                                      -
58    41 Donations                                                                            -
59    42 Other -                                                                              -
60    43 Other -                                                                              -
61          Total Funding (non-CLBC)              $         -                $            -
62    44 CLBC Existing Funding Received                                      $                -
63          Total Existing Funding                $        -                 $            -
64
65   Funding Requested from CLBC   $   -   $   -
 direct supervisor is working on administrative tasks vs. direct care, then show

                      F                  Sat           Sun            Total
             7-2:30
             7.5                                                   37.5




te FTE for direct supervisor.



Click this button to print only Staff Schedule data page and not
Comments page

gram Status:                    Non-Union


ency Status:                    CLANBC


 Hours/Week:                    35


gram Type:                      Residential




                                                                                          Position
                      F                  Sat           Sun         Total Hours    FTE        #

                                                                      0.00       0.0000      1

                                                                      0.00       0.0000      2

                                                                      0.00       0.0000      3

                                                                      0.00       0.0000      4

                                                                      0.00       0.0000      5

                                                                      0.00       0.0000      6

                                                                      0.00       0.0000      7

                                                                      0.00       0.0000      8

                                                                      0.00       0.0000      9

                                                                      0.00       0.0000     10

                                                                      0.00       0.0000     11
                                                                0.00    0.0000          12

                                                                0.00    0.0000          13

                                                                0.00    0.0000          14

                                                                0.00    0.0000          15

                                                                0.00    0.0000          16

                                                                0.00    0.0000          17

                                                                0.00    0.0000          18

                                                                0.00    0.0000          19

                                                                0.00    0.0000          20

                                                                0.00    0.0000          21

                                                                0.00    0.0000          22
                    0.00   0.00               0.00              0.00    0.0000


alculation
     Unionized Agencies                      Monthly           Annual    Line
                    Grid   FTE                Cost              Cost      #          Additional Comments:
                                  0.0000 $             -   $       -             1
                                  0.0000               -           -             2
                                  0.0000               -           -             3
                                  0.0000               -           -             4
                                  0.0000               -           -             5
                                  0.0000               -           -             6
                                  0.0000               -           -             7
                                  0.0000               -           -             8
                                  0.0000               -           -             9
                                  0.0000                           -            10
                                  0.0000               -           -            11
                                  0.0000               -           -            12
                                  0.0000               -           -            13
                                  0.0000               -           -            14
                                  0.0000               -           -            15
                                  0.0000               -           -            16
                                  0.0000               -           -            17
                                  0.0000               -           -            18
                                  0.0000               -           -            19
                                  0.0000               -           -            20
                                  0.0000               -           -            21
                                                 0.0000                     -            -          22
                                                 0.0000 $                   -    $   -

culation                                                                                     Line        Backfill Wage Calculation
                           Monthly Cost                               Annual Cost             #          Additional Comments:
             $                                        -       $                          -          23
                                                      -       $                          -          24
                                                      -       $                          -          25
                                                      -       $                          -          26
                                                      -       $                          -          27
                                                      -       $                          -          28
             $                                     -          $                      -

Direct Staff                                                                                 Line        Benefit Calculation - Direct Staff
                           Monthly Cost                               Annual Cost             #          Additional Comments:
             $                                        -       $                          -          29
                                                      -                                  -          30
                                                      -                                  -          31
                                                      -                                  -          32
                                                      -                                  -          33
                                                      -                                  -          34
                                                      -                                  -          35
                                                      -                                  -          36
                                                      -                                  -          37
                                                      -                                  -          38
                                                      -                                  -          39
             $                                     -          $                      -
- Backfill                                                                                   Line
                           Monthly Cost                               Annual Cost             #          Additional Comments:
             $                                        -       $                          -          40
             $                                        -                                  -          41
             $                                        -                                  -          42
             $                                        -                                  -          43
             $                                        -                                  -          44
             $                                        -                                  -          45
             $                                     -          $                      -
             $                                     -          $                      -
             $                                    -            $                     -



                                          Line                Direct Program Costs
                 % of Total Cost           #                  Additional Comments:


                             0.0%                         1
                             0.0%                         2
                             0.0%                         3
                             0.0%                         4
                             0.0%                         0
                 % of Total Cost
                             0.0%                         0
                             0.0%                         0
              0.0%          0
              0.0%          0
              0.0%          10
              0.0%          11
              0.0%          12
              0.0%          13
              0.0%          14
              0.0%          15
              0.0%          16
              0.0%          17
              0.0%          18
              0.0%          19
              0.0%          20
              0.0%          21
              0.0%          22
              0.0%          23
              0.0%          24
              0.0%
                     Line        Facilities
 % of Total Cost      #          Additional Comments:
              0.0%          25
              0.0%          26
              0.0%          27
              0.0%          28
              0.0%          29
              0.0%          30
              0.0%          31
              0.0%          32
              0.0%          33
              0.0%          34
              0.0%          35
              0.0%
                     Line        Administration
 % of Total Cost      #          Additional Comments:
              0.0%          0
             0.0%

                     Line        Funding Source
% of Total Funding    #          Additional Comments:
              0.0%          37
              0.0%          38
              0.0%          39
              0.0%          40
              0.0%          41
              0.0%          42
              0.0%          43
              0.0%
              0.0%          44
             0.0%
n - Direct Staff

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:22
posted:8/22/2011
language:English
pages:15
Description: Shift Template Weekly document sample