Our Business is Improving Your Bottom Line!

                                    Jack Duncan has Joined Strategy Development                                     

Follow the link above to the SD website for more information

All gave Some....    Some Gave All!

                         

Partners:

Since 1995, Digital Gateway has helped over 800 companies drive their business operations successfully with their innovative e-automate dealer management software.

Digital Gateway website

 

 

Gas is $4.00 per Gallon and Rising!

JDC's Service Technician Territory Project for OMD users extracts information from OMD and places it in a spreadsheet which is then sorted by Zip, City & Model which will show you where the equipment is located as well as how many hours are needed to support it on a Monthly basis along with it's associated Average Monthly Volume.

Branch Zip City Model Serial Description Equip ID Assigned Rep Cust . Name Program Type St Days to Fail Required Monthly Calls Required Monthly Service Hours Avg Mo Usage
50 71001 SOMEWHERE R1224 SOMETHING RICOH AFICIO 1224C D1120 50SE01 OU812 ANY COMPANY JAQ TX 1.5 1.000 1.45 870
50 71001 SOMEWHERE R2510 SOMETHING RICOH MP 2510 COPIER D1525 50SE01 OU813 ANY COMPANY AAQ TX 31.5 0.952 1.38 4,842
50 71001 SOMEWHERE R2510 SOMETHING RICOH MP 2510 COPIER D1504 50SE01 OU814 ANY COMPANY AAM TX 16.7 1.000 1.45 4,761
50 71001 SOMEWHERE RB450 SOMETHING RICOH MP4500 B/W COPIER D1611 50SE01 OU815 ANY COMPANY DBM TX 6.0 1.000 1.45 9
50 71001 SOMEWHERE RB450 SOMETHING RICOH MP4500 B/W COPIER D1609 50SE01 OU816 ANY COMPANY DBM TX 3.0 1.000 1.45 9
50 71001 SOMEWHERE RB450 SOMETHING RICOH MP4500 B/W COPIER D1610 50SE01 OU817 ANY COMPANY DBM TX 42.5 0.706 1.02 17,400
50 71001 SOMEWHERE R2500 SOMETHING RICOH C2500 COLOR COPIER D1592 50SE01 OU818 ANY COMPANY AAP TX 13.0 1.000 1.45 7,764
50 71001 SOMEWHERE R3228 SOMETHING AFCIO 3228C D1160 50SE01 OU819 ANY COMPANY DBP TX 40.5 0.741 1.07 3,145
50 71001 SOMEWHERE R5500 SOMETHING RICOH AFICIO MP 5500 D1075 50SE01 OU820 ANY COMPANY DBP TX 46.2 0.649 0.94 14,200
50 71001 SOMEWHERE R5500 SOMETHING RICOH AFICIO MP 5500 D1095 50SE01 OU821 ANY COMPANY DBP TX 68.3 0.439 0.64 9,663
50 71001 SOMEWHERE R7500 SOMETHING RICOH AFICIO MP 7500 D1085 50SE02 OU822 ANY COMPANY DBP TX 52.6 0.570 0.83 50,820
50 71001 SOMEWHERE RP410 SOMETHING RICOH 410DN COLOR PRINTER D1072 50SE02 OU823 ANY COMPANY DBP TX 105.0 0.286 0.41 2,031
50 71001 SOMEWHERE RP410 SOMETHING RICOH 410DN COLOR PRINTER D1052 50SE02 OU824 ANY COMPANY DBP TX 37.3 0.804 1.17 12,199
50 71001 SOMEWHERE R2020 SOMETHING RICOH AFICIO 2020D D1146 50SE02 OU825 ANY COMPANY AAM TX        

Once assignments are made within the spreadsheet, hours and copies assigned to each technician are totaled for territory balancing purposes.

Branch Rep Name Hours Assigned Copies Assinged
50 50SE01 JIMBOB 12.30 62,663
50 50SE02 JOEBOB 17.69 86,506
50 50SE03 EARL 0.00 0
50 50SE04 FRED 25.37 219,089

Once the technician numbers are loaded into the spreadsheet, we will format it into a csv file which is then loaded automatically into OMD using a program created specifically for that purpose by OMD. NO MANUAL DATA ENTRY INTO OMD IS REQUIRED.

THIS ENTIRE PROCESS CAN BE TAUGHT TO YOUR PERSONNEL FOR FUTURE USE!

Pricing is $1,495 for single branch locations and $1,995 for multiple branches

Key Benefits

  • More Evenly Distributed Workload
  • Decrease in Mileage Re-imbursements or Company Vehicle Expenses
  • Technicians have more Available Customer Hours per Month

 

 

[Up]

 Home                                                                                                                                                                 

Send mail to info@jackduncanconsulting.com with questions or comments about this web site.
Last modified: 10/02/09