TECHNICIAN PRODUCTIVITY REPORT
This template was designed to assist the Fixed Operations, Service, and Payroll Managers.
The overall intention is to help manage technician flat rate time, productivity, and guarantee.
The attached templates will assist in the preparation of payroll & if properly utilized will prevent
discrepancy within W-I-P if compared to your DMS systems totals prior to issuing payroll. You must also
eliminate the back flagging of time.
(Meaning once Payroll is issued you can't adjust time within that pay week, adjust in following week)
You may obtain this data within the R & R system by utilizing report 3618, obtain 4.
(Start and finish dates are your pay week.)
Feeling uncomfortable with W-I-P, re-run DMS report at end of month, and compare to
Technician Month-End Summary totals.
These worksheets will  simplify the use of statistical data & formulas, to the point that clerical support
can easy maintain them.
HOW IT WORKS, Simply on the following Worksheets:
Follow the create worksheet procedures below, one for each technician.
Then, Simply follow direction provided by many comment boxes.
Enter data only into "YELLOW" cells or use Dropdowns to select data.
NEED ADDITIONAL TECHNICIAN WORKSHEETS ?
You can create an endless amount of technician Sheets, Simply by:
Right Click on Sheet Tab.
Select "Move or Copy".
Click on "Create an Copy" box.
Then Click "OK"
You may than rename your worksheet, Simply by:
Right Click on Sheet Tab.
Select "Rename".
Then type new name in highlighted tab area. (Technician Name or #)
Worksheets are protected: Without passwords
Worksheet contains NO Macros.
Feeling creative, create an additional worksheet to summarize Month-To-Date totals.
Final Note: Remember your Feedback and Evaluation of this template is important to us.
E-mail us with your comments
Creation Date:03/2005