PRODUCTIVITY REPORT                 MONTH: March-05
         
TECHNICIAN EFFICIENCY & STANDARDS       PAY RATE SCALE SUMMARY & MONTH IDENTIFIERS
            CUSTOMER  $                -     ABSENTEE - RATE 1  $                -    
EFFICIENCY STANDARD 125.0%           WARRANTY  $                -     ABSENTEE - RATE 2  $                -  
MONTH-TO-DATE AVG 0.0%           INTERNAL  $                -       START DATE # 8  
MEASURED EFFICIENCY -125.0%           GUARANTEE  $                -       END DATE # 37  
           
DATE #[1] PAY WEEK DAY[2] DATE TOTAL CLOCK HOURS[3] FLAT RATE HOURS[4] TOTAL DOLLARS[5] CUSTOMER HOURS[6] WARRANTY HOURS[7] INTERNAL HOURS[8] FIXED $ HOURS[9] FIXED $ INCENTIVE[10] VARIANCES          TIME      $ VALUE[11]  [12] EFFICIENCY RATING GUARANTEE VARIABLE   ABSENTEE HOURS[13] RATE 1[14] RATE 2[15] ABSENTEE PAY     INCENTIVE PAY GUARANTEE PAY ABSENTEE PAY TOTAL PAY
1 WEDNESDAY 23-Feb 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   LOCKED PAY SCALES
2 THURSDAY 24-Feb 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   CUSTOMER  $      16.60
3 FRIDAY 25-Feb 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   WARRANTY  $      19.70
4 SATURDAY 26-Feb 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   INTERNAL  $      16.60
5 SUNDAY 27-Feb 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   GUARANTEE  $      14.25
6 MONDAY 28-Feb 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 1  $      20.31
7 TUESDAY 1-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 2  $      14.25
WEEK 1 TOTALS   0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -   LOCKED N
     
8 WEDNESDAY 2-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   LOCKED PAY SCALES
9 THURSDAY 3-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   CUSTOMER  $      16.60
10 FRIDAY 4-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   WARRANTY  $      19.70
11 SATURDAY 5-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   INTERNAL  $      16.60
12 SUNDAY 6-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   GUARANTEE  $      14.25
13 MONDAY 7-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 1  $      20.31
14 TUESDAY 8-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 2  $      14.25
WEEK 2 TOTALS   0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -   LOCKED N
 
15 WEDNESDAY 9-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   LOCKED PAY SCALES
16 THURSDAY 10-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   CUSTOMER  $      16.60
17 FRIDAY 11-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   WARRANTY  $      19.70
18 SATURDAY 12-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   INTERNAL  $      16.60
19 SUNDAY 13-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   GUARANTEE  $      14.25
20 MONDAY 14-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 1  $      20.31
21 TUESDAY 15-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 2  $      14.25
WEEK 3 TOTALS   0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -   LOCKED N
 
22 WEDNESDAY 16-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   LOCKED PAY SCALES
23 THURSDAY 17-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   CUSTOMER  $      16.60
24 FRIDAY 18-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   WARRANTY  $      19.70
25 SATURDAY 19-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   INTERNAL  $      16.60
26 SUNDAY 20-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   GUARANTEE  $      14.25
27 MONDAY 21-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 1  $      20.31
28 TUESDAY 22-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 2  $      14.25
WEEK 4 TOTALS   0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -   LOCKED N
 
29 WEDNESDAY 23-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   LOCKED PAY SCALES
30 THURSDAY 24-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   CUSTOMER  $      16.60
31 FRIDAY 25-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   WARRANTY  $      19.70
32 SATURDAY 26-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   INTERNAL  $      16.60
33 SUNDAY 27-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   GUARANTEE  $      14.25
34 MONDAY 28-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 1  $      20.31
35 TUESDAY 29-Mar 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 2  $      14.25
WEEK 5 TOTALS   0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -   LOCKED N
     
36 WEDNESDAY 30-Mar 1.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   LOCKED PAY SCALES
37 THURSDAY 31-Mar 1.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   CUSTOMER  $      16.60
38 FRIDAY 1-Apr 1.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   WARRANTY  $      19.70
39 SATURDAY 2-Apr 1.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   INTERNAL  $      16.60
40 SUNDAY 3-Apr 1.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   GUARANTEE  $      14.25
41 MONDAY 4-Apr 1.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 1  $      20.31
42 TUESDAY 5-Apr 1.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0      $                -       $                -    $                -    $                -    $                -   RATE 2  $      14.25
WEEK 6 TOTALS   7.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     0.00 ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -   LOCKED N
     
MONTH-TO-DATE ACTIVITY SUMMARY        
WEEK 1 0.0 0.0  $              -  0.0 0.0 0.0 0.0  $             -    ? 0.0%  $                -     0.0    $                 -     $                 -   $                -    $                 -   $                -  
WEEK 2 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -  
WEEK 3 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -  
WEEK 4 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -  
WEEK 5 0.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -  
WEEK 6 2.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -  
GRAND TOTAL   2.0 0.0  $             -   0.0 0.0 0.0 0.0  $            -     ? 0.0%  $                -     0.0    $                -      $                -    $                -    $                -    $                -  
[1]
EFFICIENCY STANDARD:
Enter the % rate for comparison to their individual Efficiency Rate.
[2]
START & END DATE: Input the Date # of the left-side of worksheet to identify the beginning & ending days of the month.  Use date #'s NOT row #.
[3]
MONTH I.D.:
Use Date # to identify the beginning & end of the month to produce monthly summary totals. Input start & ending day #'s in cells on top right-hand corner of worksheet.
[4]
PAY WEEK DAY:
For ease of calculating & comparing technician weekly pay to productivity. Enter day's  within a pay week.
e.g. Pay week being Wed-Tues, Day 1 = Wednesday
[5]
CLOCK HOURS:
Enter the total hours present: Time Card, punch-in & out equals.
[6]
FLAT RATE HOURS:
Enter total Flat Rate Hours produced on the given day.
[7]
TOTAL DOLLARS:
Enter total calculated dollars earned by technician on the given day.
[8]
CUSTOMER HOURS:
Enter total Customer Pay Hours flagged.
[9]
WARRANTY HOURS:
Enter total Warranty hours flagged.
[10]
INTERNAL HOURS:
Enter total Internal Hours flagged.
[11]
FIXED $ HOURS:
Enter total time flagged, which a flat $ amount is paid. e.g. If for a vehicle inspection you flag, .50 hours and pay a flat $ 7.00. You would enter FIXED $ HOURS AS .50 & FIXED DOLLARS INCENTIVE AS $ 7.00
[12]
FIXED $ INCENTIVE:
Enter total DOLLAR amount due, which a flat $ hour is paid.
[13]
VARIANCES:
If Time or Dollars amount DON'T balance, ERROR value is displayed.
[14]
A "?" mark will appear if Efficiency Rating % is Less than your Standardized Rate assigned to this Technician.
[15]
ABSENTEE HOURS:
Enter # of hours to be paid, which will be multiplied against selected absentee pay Rate 1 or 2.
[16]
RATE 1: Enter a valid value, to generated a calculated value using Rate 1.
                      V-Vacation day     S-Sick day
                      P-Personal day     H-Misc. Roving Holiday (default)
[17]
RATE 2: Enter a valid value, to generated a calculated value using Rate 1.
                      V-Vacation day     S-Sick day
                      P-Personal day     H-Misc. Roving Holiday (default)