RURAL ROUTE EVALUATION WORKSHEET - Excel by t1LffM

VIEWS: 110 PAGES: 2

									             RURAL ROUTE EVALUATION WORKSHEET
                   MAIL COUNT CALCULATOR
MAKE ENTRIES ONLY IN BLUE CELLS                  WEEKS COUNTED 2.000
PS 4241                     Amount Time AllowanceTime Allowance Office Time                              Route Time
Ref.No. Description          Entered   Office Time  Route Time    (Mins.)                                  (Mins.)
        Route Length              0.00               Miles x 12.0                                              0.00
        Regular Boxes                       0                     Boxes x 2.0 or (1.82L)                  #DIV/0!
        Centralized Boxes                   0                           Boxes x 1.0                            0.00
        NDCBU Coll/Comp                     0                       Compartments x 1.0                         0.00
        Parcel Lockers                      0                          Lockers x 2.0                           0.00
   A    Letter Size                         0(Total / WKS) x .0555                                0.00
   B    Sector Segment                      0(Total / WKS) x .0444                                0.00
   C    Papers,Mags,Cats.                   0 (Total / WKS) x .100                                0.00
   D    Parcels                             0 (Total / WKS) x .333 (Total /WKS) x .167            0.00         0.00
   E    Box Holders                         0 (Total / WKS) x .04                                 0.00
   F    RegCertInsDelSpec/Exp               0 (Total /WKS) x 1.0 (Total /WKS) x 3.466             0.00         0.00
   G    COD Customs Due Del                 0 (Total /WKS) x 1.5 (Total /WKS) x 4.466             0.00         0.00
   H    Postage Dues (Round UP)             0(Total /WKS) /5 Rd up                                0.00
   I    Address Changes                     0 (Total /WKS) x 2.0                                  0.00
   J    Mark Ups                            0 (Total /WKS) x .25                                  0.00
   K    Forms 3821                          0 (Total /WKS) x 2.0                                  0.00
   L    Del. Point Seq. Ltrs.               0                      (Total /WKS) x .0333                        0.00
   M    MO Applications                     0 (Total /WKS) x 1.5 (Total /WKS) x 2.0               0.00         0.00
   N    Letters/Flats Coll.                 0 (Total /WKS) x .04                                  0.00
   O    Ord Ins PP Coll.                    0 (Total /WKS) x 2.0 (Total /WKS) x 2.0               0.00         0.00
   P    Reg & Cert Coll.                    0                        (Total /WKS) x 2.0                        0.00
   Q    Loading Actual                      0 (Total /WKS)                                        0.00
   R    Other Suitable                      0 (Total /WKS)                                        0.00
   S    Stamp Stock (All Rts.)                         20                                        20.00
        Strapping Out                   (A+B+C-J) / WKS X .01428                                  0.00
   T    Return Receipts (L)                 0   (Total /WKS) x .25                            #DIV/0!
        Office & Personal                                                                        30.00
   U    Auth. Dismounts                     0                          (Total /WKS) x .1                       0.00
   V    Auth. Dismount Dist.                0                        (Total / WKS) x .00284                    0.00
   Z    Lock Pouch Stops                    0                        # DAILY Stops x 30.0                      0.00
        Withdraw Mail Y=1 N=0               0     Yes=30 No=0                                     0.00
        USPS Vehicle Y=1 N=0                0   Rt. Mi x 6/100x4.5       (Minimum 30)             0.00
        Reload/Unload                                                         18                              18.00
        IMD Scanner Allowance                           6                                         6.00
                                  HOURS          MINUTES                  TOTAL               OFFICE      ROUTE
         OFFICE STD HOURS         #DIV/0!       #DIV/0!                   #DIV/0!             #DIV/0!     #DIV/0!
         ROUTE STD HOURS          #DIV/0!       #DIV/0!
         TOTAL STD HOURS          #DIV/0!       #DIV/0!




6/6/201211:23 PM
                                 Selected Route Information

                                                    Regular       Centralized
Total Boxes                                  0      #DIV/0!        #DIV/0!

Annual Fueling Time                  312.00      Minutes
Route Density                      #DIV/0!       Boxes per Mile
Annual Driving Miles                       0
Possible Deliveries per year               0
Double Volume Deliveries                   0     After Holidays
Volume Related Time                #DIV/0!       Minutes
Volume Only Box Factor             #DIV/0!
Centralized Boxes Necessary        #DIV/0!       for 1 hour change @ factor #DIV/0!
Regular Boxes Necessary            #DIV/0!       for 1 hour change @ factor #DIV/0!

Automation Impact                       0.00     Minutes                 0.00 Hours
Impact of additional 1% DPS        #DIV/0!       Minutes
DPS Percentage                     #DIV/0!
Annual DPS Letters                         0
Annual DPS Could Ground-cover           0.00     Football Fields
DPS daily casing Time                   0.00     Minutes at 30 pieces per minute standard
                                                 (Does not include time to strapout DPS)

Deliveries per Standard Hour       #DIV/0!
Deliveries per Route Time Hour     #DIV/0!                         Daily Hours
Annual COA Turnover Rate           #DIV/0!
Total Annual Pieces Handled                  0
Annual Pieces per Box              #DIV/0!
Daily pieces handled per Box       #DIV/0!

Office Time %                      #DIV/0!
Route Time %                       #DIV/0!
Office Time Daily Hours            #DIV/0!
Route Time Daily Hours             #DIV/0!


Volume Time                        #DIV/0!             Office Time %   Route Time %
Box Time                           #DIV/0!
Mileage Time                       #DIV/0!
Flats Time                         #DIV/0!
Fueling Time if Gov Vehicle             0.00 Minutes plus        24.00      30.00      6.00
                                 RT MI X 6 / 100 X 4.5           Fixed    Minimum Fueling Credit

								
To top