Excel Packing Shipping Container Spreadsheet - PowerPoint

W
Description

Excel Packing Shipping Container Spreadsheet document sample

Document Sample
scope of work template
							Appendix D—Dar es Salaam
  Detailed Comparisons
Appendix D – Contents
 Motorpool Details                                        Property Management Details

  Motorpool Activities                                    Property Management—Warehousing General

  Motorpool Vehicles                                      Property Management—Warehousing Personnel

  Motorpool Infrastructure                                Property Management—Inventories

  Motorpool Service Characteristics                       Property Management—Warehouse Inventory

  Motorpool Results – Dar Es Salaam                       Property Management—Inventory Control

  Comments about Motorpool – Dar Es Salaam State/ICASS    Property Management Results – Dar Es Salaam

  Comments about Motorpool – Dar Es Salaam USAID          Comments about Property Management – Dar Es Salaam
                                                            State/ICASS
  Motorpool Cost Comparison Statistics
                                                           Comments about Property Management – Dar Es Salaam USAID
  Motorpool Costs Comparisons
                                                           Property Management Costs Comparison Statistics

                                                           Property Management Costs Comparisons




                                                                                                                       D-2
Appendix D – Contents (Cont’d)
  Residential Maintenance Details                                  Leasing Details

   Residential Maintenance—Description                             Leasing

   Residential Maintenance—Personnel                               Leasing Results – Dar Es Salaam

   Residential Maintenance—Description                             Comments about Leasing – Dar Es Salaam State/ICASS

   Residential Maintenance—Service Levels                          Comments about Leasing – Dar Es Salaam USAID

   Residential Maintenance Results – Dar Es Salaam                 Leasing Costs Comparison Statistics

   Comments about Residential Maintenance – Dar Es Salaam          Leasing Costs Comparisons
    State/ICASS

   Comments about Residential Maintenance – Dar Es Salaam USAID

   Residential Maintenance Costs Comparison Statistics

   Residential Maintenance Costs Comparisons




                                                                                                                          D-3
Motorpool—Activities
                                                                                           Opportunities/
      Activity          State/ICASS                           USAID                         Comments
  Drive          16 motorpool drivers             10 drivers (includes 1             Much of the ICASS driving is
                                                  mechanic/driver)                     self-drive:
                 4 water truck drivers
                                                  All drivers are trained to drive    Typically, employees start
                 (35 total motorpool employees.   water trucks                         driving as soon as they are
                 Others include:                                                       oriented with the area
                                                  (11 total motorpool employees,
                 1 supervisor
                                                  including 1 supervisor/             Program employees use
                 1 dispatcher 80%/ driver 20%    dispatcher)                          drivers to go to official
                 1 dispatcher 50%/ records                                            meetings/functions
                                                  (Work week is 48 hours.
                 50%                              Overtime rates:                    Both motorpools have
                 4 Marine Corps drivers          150 % over 96 hours in a pay          relatively high numbers of
                 2 Executive drivers (COM)       period of 2 weeks                     drivers relative to the
                                                                                        number of customers they
                 2 Facilities Maintenance        150 % on American holidays
                                                                                        support.
                 drivers                          200 % on Sundays and
                 1 RAO driver                    holidays)                          Consolidate motorpools and
                                                                                       reduce number of drivers
                 2 Warehouse
                 drivers/warehousemen
                 1 Gas pump attendant
                 1 Mechanic)
                 (Work week is 48 hours.
                 Overtime rates:
                 150 % over 96 hours in a pay
                 period of 2 weeks
                 150 % on American holidays
                 200 % on Sundays and
                 holidays)
                                                                                                                     D-4
Motorpool—Activities (Cont’d)
                                                                                             Opportunities/
      Activity            State/ICASS                           USAID                         Comments
  Customers       ICASS, State, DAO, CDC, MSG        USAID
  Drive utility   Deliveries of water and fuel for   Deliveries of water and fuel for   Water truck routes, vehicles,
  vehicles        generators are motorpool           generators are motorpool           and drivers could be combined
                  activities                         activities                         to improve service levels

                  Motorpool dedicated drivers
                  are used for warehouse,
                  facilities maintenance, water
                  delivery, Chief of Mission,
                  Marines, and RAO
  Schedule        Drivers are scheduled:             Drivers are scheduled:             Consolidation could expand
                                                                                        availability during 24/7
                  0730-1600 (4 drivers/12            0700-1700 and 0730-1730            operations
                  vehicles)
                                                     Duty driver 1400-0100
                  1600-2400 (2 duty drivers on
                  call)                              (no one on duty 0100-0700)

                  2400-0600 (1 driver on duty)       Friday– 0700-1530 (1 driver)

                  Fuel station: 0730-1000 and        Water truck driver on duty on
                  1400-1700, Monday through          Saturday
                  Friday; 0800-1200 on
                  Saturdays

                  Water trucks: 0730-1600,
                  Monday through Saturday and
                  after hours by duty drivers



                                                                                                                     D-5
Motorpool—Activities (Cont’d)
                                                                                      Opportunities/
         Activity          State/ICASS                           USAID                 Comments
  Fuel              Fuel from ICASS refuel point at   Fuel from ICASS fuel point at
                    Embassy                           Embassy

                                                      Also obtain fuel from
                                                      commercial gas stations
  Maintain          Minor maintenance and             Minor maintenance and
                    management performed by 1         management performed by 1
                    mechanic                          mechanic

                    Drivers clean and inspect         Drivers clean and inspect
                    vehicles                          vehicles

                    Major maintenance at preferred    Major maintenance is done
                    local dealership that can fix     commercially
                    Toyotas (BMW dealer)—faster
                    and less expensive than
                    Toyota




                                                                                                       D-6
Motorpool—Activities (Cont’d)
                                                                                    Opportunities/
     Activity           State/ICASS                         USAID                    Comments
  Dispatch      1 dispatcher 80%/ driver 20%     1 supervisor/dispatcher

                1 dispatcher 50%/ record         Request made by filling out
                keeper 50%                       forms

                Use MS Outlook calendar          Accept telephone and email
                                                 request for local transportation
                Motor vehicle request form is
                sent to motorpool and            Working on email approach
                accepted or declined through     with new software package
                reply in Outlook                 (electronic request for all
                                                 services)
                Can specify if driving self in
                MS Outlook request form

                Dispatcher uses resulting
                Outlook schedule to manage
                daily dispatches

                Phone requests are handled by
                updating printout of schedule




                                                                                                     D-7
Motorpool—Activities (Cont’d)
                                                                                               Opportunities/
     Activity              State/ICASS                             USAID                        Comments
  Records          Chronological record of             Dispatcher keeps the written      With consolidation, record
                   schedules on computer and on        forms for dispatching             systems could be reduced
                   clipboard in dispatcher’s office                                      from 2 to 1
                                                       Phone dispatches are handled
                   Trip sheets in each car are         via notes (keeps some of the      Trip logs should be used to
                   used to record details              notes)                            derive and report service level
                                                                                         metrics
                   Self drivers fill out trip sheets   Drivers are filling out vehicle
                                                       log sheets, which are turned in   Reports from trip logs should
                   Transcribe trips sheets to Excel    each day                          be used for more efficient trip
                   spreadsheet—only distance                                             and capacity planning
                   and fuel                            Vehicles’ miles and fuel
                                                       consumption are rolled up in a
                   At end of year, odometer            report
                   readings and total fuel usage
                   figures are manually                At end of year, odometer
                   assembled into report to            readings and total fuel usage
                   Washington                          figures are manually
                                                       assembled into report to
                                                       Washington
  Clean/maintain   Janitorial contractor cleans        Janitorial contractor cleans
  facilities       facilities                          facilities
  Train            2 to train-the-trainer training—    Send drivers to local institute   One standardized training
                   implemented drivers training        for driver training (Tanzanian    curriculum should be
                   course once/month for 1-1.5         school)—safe and defensive        instituted
                   hours                               driving curricula
                   Each new driver must go
                   through comprehensive
                   training provided by the SHEM
                   office (OBO) and be tested

                                                                                                                           D-8
Motorpool—Activities (Cont’d)
                                                                                                Opportunities/
      Activity                State/ICASS                          USAID                         Comments
  Meetings            1 per week for 30 minutes         1 per week for 1-2 hours

  Driver TDYs         2 to 3 trips per month on up      2 overnight trips per month per
                      country trips                     driver

                      Drivers are paid overtime even    Drivers are paid overtime for
                      when on per diem                  work on trips (not sleeping,
                                                        etc.)
                      Can drive up to 10 hours per
                      day during any hours of the       Drivers can’t be on the road
                      day (outside of city they drive   after dark (limits day to 12
                      during daylight only)             hours)
  Manage drivers      1 supervisor                      1 supervisor/dispatcher           Consolidate could reduce at
                                                                                          least 1 supervisor/ dispatcher
  Plan resources      Supervisor manages fuel and       Supervisor/dispatcher plans
                      water supply planning
                                                        EXO reviews and approves
                      Vehicle replacement is
                      managed by GSO and
                      Supervisor together

                      Training supervisor to handle
                      all resource planning
  Order vehicles,     Mechanics make requests, and      Keep some vehicle parts—
  parts, & supplies   supervisor orders through         common consumables
                      procurement
                                                        Supervisor/dispatcher makes
                      Returning to policy of keeping    requests, and procurement
                      some supplies based on price      orders
                      fluctuations

                                                                                                                           D-9
Motorpool—Activities (Cont’d)
                                                                                               Opportunities/
      Activity              State/ICASS                          USAID                          Comments
  Expedite airport   Expediters are not part of motorpools
  arrivals
  Manage special     3-4 special events/visits per    2-3 VIP visits per year (Codels)   All resources should be
  events/visits      year (2 Codels and visits from                                      available to handle special
                     other agencies and large         Handled within USAID               events, which could better
                     conference at off site)          resources—may ask                  maintain non-event service
                                                      employees to defer travel          levels
  Answer             Varies, but average 2 per        Rare
  complaints         month

                     Requesters occasionally make
                     errors in request form

                     Drivers have occasionally
                     made mistakes or need advice
                     on hygiene
  Handle             None                             None
  breakdowns
  Accident reports   7 minor accidents per year on    1-2 minor accidents per year
                     average (on all 49 vehicles)     with taxis in town




                                                                                                                       D-10
Motorpool—Vehicles
                                                                         Opportunities/
    Vehicles        State/ICASS               USAID                       Comments
 Vehicles                         6 Toyota Land Cruisers (4x4)     Other large motorpools exist in
                                                                   DAO, CDC, Peace Corps
                                  1 water truck (7-ton)
                                                                   Total numbers of vehicles can
                                                                   be reduced through
                                                                   consolidation


 Special use                      1 Toyota Land Cruiser (Mission
 vehicles/ others                 Director)

                                  1 truck (8-ton) (Warehouse)

                                  1 pickup (4x2) (Warehouse)

                                  1 minibus (Residential
                                  Maintenance)

                                  1 pickup (4x4) (Residential
                                  Maintenance)
 Total vehicles                   12 total vehicles




                                                                                               D-11
Motorpool—Infrastructure
                                                                                            Opportunities/
  Infrastructure           State/ICASS                          USAID                        Comments
  Facilities       Office and waiting area in        25 square meters for office      ICASS motorpool offices could
                   corner of Embassy building        space                            provide excellent facilities for a
                                                                                      merged motorpool
                   Parking area at Embassy           Supervisor’s cubicle and
                                                     drivers waiting room

                                                     Parking area at Embassy

                                                     Park vehicles at warehouse—
                                                     water truck

  Communications   2-way radios installed in all     2-way radios—some installed      In a consolidated motorpool,
                   vehicles                          in vehicles, some are handheld   all cars should have operable
                                                                                      radios used to dynamically
                   Some handheld in new              Supervisor/dispatcher, water     dispatch drivers to save trips
                   vehicles                          truck driver, duty driver, and
                                                     MD driver have Government
                   Front office, supervisor,         cell phones
                   dispatcher, 2 duty drivers,
                   marine drivers and mechanic
                   have Government cell phones
                   (FM driver also has a cell
                   phone)
                   Other drivers use personal cell
                   phones




                                                                                                                     D-12
Motorpool—Service Characteristics
     Service                                                                               Opportunities/
  Characteristics          State/ICASS                            USAID                     Comments
  Computers/        5 PCs—one for supervisor, one     2 PCs—one for supervisor and    One system would be
  software          for dispatchers, 2 for drivers    one for drivers                 sufficient for a consolidated
                    lounge—motorpool training                                         motorpool
                    and language training             Future—will use new software

                    Use MS Outlook and Excel for      Complete FAST report online
                    managing motorpool
  Service areas     Airport and within city center    Predominant use is around Dar   Consolidation could provide
                                                      es Salaam (70 %)                greater availability of
                    Arusha (next largest city                                         vehicles and drivers for trips
                    center—AICC (tribunals)) (1       Field trips in all areas of     in and outside of Dar es
                    per month)                        Tanzania (30 %)                 Salaam
                    Bagamoyo, Dodoma, and
                    Morogoro seldom (4-5 times
                    per year)
  Shuttles          Neither State, nor USAID, run shuttles




                                                                                                                  D-13
Motorpool—Service Characteristics
     Service                                                                                    Opportunities/
  Characteristics             State/ICASS                           USAID                        Comments
  Unofficial vehicle   People who work after dark will   Newcomers and departing
  use                  be transported by duty drivers    personnel can use vehicles for
                       to nearest bus stop (LES are      30 days after arrival and before
                       not charged, U.S. are charged)    departure, respectively

                       Newcomers can use vehicles        Personnel can use official
                       at their expense for 90 days      vehicles if personal vehicles
                       after arrival, and departing      are broken
                       personnel can use vehicles at
                       their expense for 30 days prior   Charged by mile--$ 0.25 per
                       to departure (charged for         mile
                       vehicle always and charged for
                       driver when used)
  Service levels       1 in 15 requests turned down—     Rarely turn down official          Current service levels are
                       vehicle and/or driver             requests                           high and can be maintained
                                                                                            or enhanced with
                       Water can be delivered anytime    Water can be delivered anytime     consolidation
                       on short notice                   on short notice

                       Motorpool is available 24/7       Normal operating hours are
                                                         0700-1730 with duty driver
                                                         available until 0100

                                                         1 driver (scheduled as duty
                                                         driver) available on Friday
  Coordination         Provide vehicles to ICASS for VIP visits

                       Share water trucks when breakdowns occur



                                                                                                                     D-14
Motorpool Results – Dar Es Salaam

                                   State/ICASS                                                                                                       USAID
       Mean                           (n=11)                                                                                                         (n=7)                                 Mean

                                                                                       1a. Vehicles are well                                                                                4.29
          4.27      0%9%               55%                  36%                                                             0%14%0%      29%                         57%
                                                                                       maintained and clean.


          3.73      0% 18%       18%          36%             27%                   1b. Motorpool services are              0%14%        29%                         57%                    4.43
                                                                                         provided on time.

                                                                          1c. Drivers are familiar with the local traffic
          4.18      0%9%                64%                   27%          patterns, laws and customs and deliver           0%14%0%                        86%                              4.57
                                                                          you to your destination safely and on time.

                                                                                  1d. Motorpool (drivers) staff are
          4.27      0%9%               55%                  36%                                                                14%0%                       86%                              4.43
                                                                                    well trained and courteous.


          3.91      0% 18%                     73%                  9%         1e. The motorpool policy is written,              20%         20%               40%         0% 20%           2.80
                                                                                   available, and appropriate.


                                                                              1f. You are kept informed of the status
          3.73      0% 18%     9%             55%                 18%                                                       0%14%                        71%                  14%           4.00
                                                                                 of your vehicle & driver requests.


          4.18      0%9%                64%                   27%               1g. Overall, you are satisfied with         0%14%0%                        86%                              4.57
                                                                                    the motorpool operation.

                    0%       20%        40%      60%       80%       100%                                                   0%         20%         40%         60%     80%          100%


                                                                   Strongly        Disagree      Neutral       Agree        Strongly
                                                                   Disagree                                                 Agree


  Note: There are no statistically significant differences between the means of
  State/ICASS and USAID for Motorpool, Dar Es Salaam                                                                                                                                               D-15
Comments about Motorpool – Dar Es Salaam
State/ICASS
   Motorpool is weak. Occasionally they fail to pick-up travelers at the airport. It works well for me but I call and remind
    the drivers to ensure that they respond.
   Great group of people
   there have been times when i didn't get a driver at the requested time and had not been informed beforehand of any
    problems
   Outstanding and professional in all respects




                                                                                                                                D-16
Comments about Motorpool – Dar Es Salaam
USAID
   The drivers are great!! Service is great.
   Motorpool is very well run




                                                D-17
Motorpool Cost Comparison Statistics
                                                                                                                    State/
               Motorpool Statistic                                    Description                                  ICASS        USAID
                                          Total of USDH, offshore PSCs and FSN-5 and above for all
    Total number of motorpool customers   customer agencies                                                          142          65
                                          Number of vehicles dedicated to motorpool including shuttle
    Number of vehicles                    vehicles                                                                   15            9
                                          Total of vehicles divided by number of customers (total population
    Vehicles/customer                     of staff who can use service)                                              0.10         0.14
                                          Total kilometers driven taken from vehicle odometers for annual
    Total kilometers driven in a year     report                                                                  303,080.00   107,381.00
                                          Total kilometers driven divided by number of vehicles (take out
    Average vehicle kilometers per year   special use vehicles)                                                   20,902.07    11,931.22
                                          Average trips per day divided by number of vehicles (take out
    Average trips/day/vehicle             special use vehicles)                                                      2.92         1.03

    Number of drivers                     Drivers dedicated to motorpool                                             23           10
                                          Total motorpool drivers, including shuttle drivers, divided by number
    Drivers/customer                      of customers                                                               0.16         0.15
                                          From sample trips logs, the total trips divided by days in sample
    Average trips/day/driver              divided by number of drivers in motorpool                                  1.84         0.93
                                          Average trips/day/driver times the average hours/trip divided by
    Driver utilization                    hours in a workday                                                        8.37%       13.79%
                                          Total number of supervisors, dispatcheers, or
    Number of supervisors/ dispatchers    supervisor/dispatchers in motorpool                                         4            3




                                                                                                                                            D-18
Motorpool Costs Comparisons
                                                                                                               State/ ICASS                        State/ ICASS
                                                                              State/ ICASS                      Costs Per         USAID Costs       Costs Per     USAID Costs
 Motorpool Cost Factors                     Description                          Totals       USAID Totals      Customer         Per Customer       Kilometer     Per Kilometer
                          Costs of managers other than
Management                                                                    $    46,945.16 $      2,789.14       $330.60            $42.91           $0.15          $0.03
                          supervisors/dispatchers

                          Total of salaries, benefits, and entitlements for
Drivers                                                                     $     272,918.27 $    161,676.68       $1,921.96         $2,487.33         $0.90          $1.51
                          drivers

                          Driver utilization multiplied times total labor
    Drivers driving                                                           $   22,849.98   $   22,293.80        $160.92           $342.98           $0.08          $0.21
                          costs of drivers

                          1-driver utilization multiplied times total labor
    Drivers standing by                                                       $ 250,075.01    $ 139,381.47         $1,761.09         $2,144.33         $0.83          $1.30
                          costs of drivers

Supervisor/dispatchers    Costs of supervisor/dispatchers                     $   28,399.02   $   24,391.80        $199.99           $375.26           $0.09          $0.23

                          Costs of clerks or other staff assigned to
Other clerical or labor                                                       $         -     $         -           $0.00             $0.00            $0.00          $0.00
                          direct vehicle operations

                          Total costs of maintenance including parts,
Vehicle maintenance                                                           $ 109,206.54    $   36,391.48        $769.06           $559.87           $0.36          $0.34
                          labor, and maintenance facilities

Vehicle fuel              Total costs of fuels and lubricants                 $   18,200.00   $   18,786.06        $128.17           $289.02           $0.06          $0.17

                          Purchase price divided by 5 to 7 years
Vehicle depreciation      depending on type vehicle; or zero, if totally      $   56,317.20   $   19,413.80        $396.60           $298.67           $0.19          $0.18
                          depreciated
                          Costs of facilities, overhead, etc. divided by
Other costs                                                                   $    2,780.00   $      427.56         $19.58            $6.58            $0.01          $0.00
                          total kilometers

Total                                                                         $ 534,766.19    $ 263,876.52     $      3,765.96   $      4,059.64   $       1.76   $       2.46




                                                                                                                                                                          D-19
Property Management—Warehousing General
                                                                                        Opportunities/
        Factor         State/ ICASS                          USAID                       Comments
 Facilities      A new warehouse facility for     Current warehouse is located     Warehouses operations
                 both State and USAID is to be    approximately 30 minutes (15     should be consolidated in the
                 constructed soon—estimated       km) from Embassy                 new warehouse to be built on
                 completion is 3rd Qtr FY2005                                      the NEC
                                                  Warehouse facilities include
                 Only one administrative area     NXP and EXP areas (EXP           Consolidation of warehouses
                 is planned for the warehouse     areas are also located in        will reduce administration and
                                                  USAID building on Embassy        labor requirements
                 Current GO warehouse is 20-
                                                  compound)
                 45 minutes away
                 Includes a series of rooms for   1 large warehouse room with
                 storage with one larger area     4 spaces---receiving, OE,
                                                  program funded and general
                 2 offices—1 upstairs for
                                                  NXP, separate walled off room
                 supply clerks and 1
                                                  for computer gear, and a room
                 downstairs for supervisors
                                                  for welcome kits
                 Moved 2 clerks into main
                 Embassy building due to loss     Single-building for EXP store,
                 of network connectivity with     which also includes some
                 server upgrade                   storage for facilities
                 Warehouse also includes 12       maintenance
                 20’ containers that contain:
                                                  Outside has 3 20’ containers
                 Household appliances, party      and 4 40’ containers
                 equipment/supplies, CDC
                                                  Warehouse also includes
                 furniture, archived files, CDC
                                                  motorpool workshop—full
                 computer desks, IDF, packing
                                                  garage (hydraulic lift, wheel
                 materials, and little computer
                                                  alignment, and crane)
                 gear



                                                                                                               D-20
Property Management—Warehousing General
                                                                                          Opportunities/
       Factor                 State/ ICASS                          USAID                  Comments
 Facilities (Cont’d)   Warehouse contains FM items       Motorpool workshop includes
                       from NOB construction             workshop, office, and store
                                                         room for parts
                       Moving FM items to small
                       warehouse just outside of         Warehouse property has a
                       NEC                               well and 20,000 liters of
                                                         storage capacity (well is also
                       EXP is stored also in
                                                         located on Embassy
                       Embassy
                                                         compound)
                       EXP and NXP staffs are
                       managed together as               Warehouse has fuel pump,
                       warehouse                         but it is no longer used to
                                                         store or dispense fuel
                       Large warehouse Includes
                       backup fuel tanks and water
                       source
                       Management officer wants to
                       keep current warehouse
                       facility for tank farm and well
                       Water capacity at Embassy is
                       inadequate for residential
                       supply needs
                       If can keep 7 acre plot
                       adjoining Embassy, want to
                       install diesel and gasoline
                       tanks there
                       ICASS owns another small
                       warehouse 3 minutes away
                       (EXP for residential and
                       facilities maintenance)

                                                                                                           D-21
Property Management—Warehousing General (Cont’d)
                                                                                           Opportunities/
       Factor                State/ ICASS                        USAID                      Comments
 Climate controlled   Offices are air conditioned     Everything except shipping
 areas                                                containers is air conditioned
                      1 NXP and 1 EXP rooms are
                      air conditioned                 3 offices and a meeting space

                      1 room for office supplies is
                      air conditioned

                      Canteen is air conditioned
 Square meters        750 square meters               533 square meters               Containers not included in
                                                                                      building space
 Customers            State, ICASS, DAO, CDC          USAID OE and projects




                                                                                                                   D-22
Property Management—Warehousing General (Cont’d)
                                                                                     Opportunities/
      Factors           State/ ICASS                        USAID                     Comments
 Communications   1 telephone line               2 telephone lines with
                                                 multiple extensions
                  2 PCs (standalone—recently
                  dropped off network and        3 PCs (2 are networked and 1
                  working to reconnect) (4       standalone)
                  training computers)
                                                 1 room in Embassy with extra
                  3 PCs at Embassy               office furniture (new from
                                                 NOB construction)
                  3 PCs at Maintenance
                  warehouse
 Vehicles         2 large trucks and 1 Toyota    1 large truck (motorpool       Truck and driver requirements
                  Hilux plus 2 drivers           driver)                        can be reduced through
                  (motorpool)                                                   consolidation
                                                 1 pickup (4x2) (warehouse
                  Drivers also move furniture    driver)
 Numbers of       39                             13
 households
 supported        Use Drexel Twentieth Century   Use Drexel Twentieth Century
                  furniture                      furniture




                                                                                                           D-23
Property Management—Warehousing General (Cont’d)
                                                                                         Opportunities/
      Factors              State/ ICASS                           USAID                   Comments
 Special services   Set ups for events for all       Set ups for events/parties   Re-upholstery contracts
                    agencies                                                        should be consolidated
                                                      Re-upholstery is done        reducing administration and
                    Re-upholstery is done             commercially (furniture is   potentially costs
                    commercially (furniture is re-     re-upholstered every 4
                    upholstered during moves           years or more)               ICASS should adopt the
                    unless new)                                                     USAID contract for refinishing
                                                      Furniture refinishing is
                    Furniture refinishing has         done commercially
                    not been done, but now             (furniture is refinished
                    experimenting with                 during move cycles, as
                    refinishing—until now been         needed)
                    replacing furniture that was
                    not considered up to quality      (Draperies are fabricated
                    standard                           through a purchase order
                                                       by purchasing)


 Equipment          1 heavy duty forklift            1 forklift                     1 heavy forklift and 1 normal
                    (containers)                                                    duty forklift can be reduced
                                                     1 hand operated high-lift
                    1 off road forklift
                    2 small forklifts for new
                    warehouse




                                                                                                                    D-24
Property Management—Warehousing General (Cont’d)
                                                                                   Opportunities/
     Factors          State/ ICASS                       USAID                      Comments
 Observations   Currently selling excess       Warehouse is neat, orderly,    ICASS is in the process of
                equipment and furniture from   and clean                      improving its housekeeping
                the 1997 bombing                                              procedures to match USAID
                                                                              quality
                Warehouse is orderly, but
                structure is old
 Payments       Claims for damage to           HHE is stored only
                Government property are        temporarily in the warehouse
                handled by GSO
                                               EXO/DEXO handle claims for
                                               damage to Government
                                               property




                                                                                                           D-25
Property Management—Warehousing Personnel
                                                                                   Opportunities/
       Factor             State/ ICASS                         USAID                Comments
 Personnel          1 USDH GSO (15 %)               EXO (2 %)?? (incl admin   Consolidation should reduce
                                                    supply?                   overall level of effort to
                    1 EFM warehouse supervisor                                manage the warehouse
                                                    DEXO (5 %)
                    21 FSNs (includes 2 drivers)                              Specific staff reduction
                                                    1 GSO (20 %)??            opportunities require further
                                                                              investigation, but following
                                                                              reductions should be
                                                                              considered:

 Management        1 warehouse supervisor          1 warehouse supervisor    Reduce 1 supervisor


 Clerical          7 supply clerks                 1 supply clerk            Reduce at least 3 supply
                                                                              clerks
                                                    1 data entry clerk
 Warehousemen      4 warehousemen                  4 warehousemen            Reduce at least 2
                                                                              warehousemen
 Drivers/          2 driver/warehousemen
 warehousemen       (motorpool)
 Storekeeper       1 storekeeper                   1 storekeeper

 Janitorial        Contract janitorial services—
                    same as Embassy building
 Laborers          6 laborers                                                Reduce approximately 4
                                                                              laborers

 ICASS knows they are overstaffed—2 extra FTEs
                                                                                                          D-26
Property Management—Inventories
                                                                                              Opportunities/
       Factor                State/ ICASS                           USAID                      Comments
 Warehouse            Total items: 14,213                Total items: 5,610              Further reduce ICASS
 Inventory items/                                                                        inventories through disposal
 value                Total value: $ 1.58 millions       Total value: $ 2.06’ millions

                      Warehouse items: 2,011             Warehouse items: 1,707

                      Warehouse value: $ 891,570         Warehouse value: $ 738,759

                      Moved an expendables
                      warehouse and found many
                      supplies that were not on the
                      inventory
 Types of inventory   ICASS, State, DAO, CDC, new        Office furniture was sold—
 by funding           Embassy funds (program             little in warehouse
                      money)
                                                         USAID OE and program


 Purpose of           Furnish houses for furniture       Furnish houses for USAID
 inventory            pool customers (95 % of
                      items)

                      Few items of office furniture

                      A container of officer furniture
                      was left over from NOB
                      provisioning




                                                                                                                    D-27
Property Management—Warehouse Inventory
                                                                                         Opportunities/
      Factor                 State/ ICASS                           USAID                 Comments
 Prominent items of   Household furniture and           Household furniture and
 inventory              appliances                        appliances
                       Washers, dryers, and             Washers, dryers, and
                        refrigerators                     refrigerators
                       Water heaters (GO houses)        Water heaters
                       Water distillers                 Microwaves
                       Microwaves                       Mattress
                       Mattress                         Box springs
                       Box springs                      Vacuum cleaners
                       Vacuum cleaners                  Air conditioners
                       Air conditioners                 Ceiling fans
                       Ceiling fans                     Rugs
                       TVs & VCRs (welcome kit only)    Transformers
                       Rugs                             Generators (32 KVA)
                       Transformers                     UPS
                       Generators (32 KVA)              Welcome kits
                       UPS                             Odd items
                       Welcome kits                     Vacuum bags (in EXP)
                      Odd items                          Dishwashers (not all houses)
                       Vacuum bags                      Gardening equipment
                       Dishwashers (not all houses)     Outdoor patio sets
                       Gardening equipment              Manual lawnmowers
                       Outdoor patio sets               Gas-powered mowers (1 in
                       Manual lawnmowers                 warehousing)
                       Gas-powered mowers (3 or 4)




                                                                                                          D-28
Property Management—Inventory Control
                                                                                            Opportunities/
      Factors                 State/ ICASS                         USAID                     Comments
 NEPA criteria
 Volume of services
 Records systems in     NEPA system on PASS              BarScan                       Consolidate on one system
 use                                                                                   and report for both State and
                                                         Use EXO application           USAID
 Accuracy of            0.84 % discrepancies             0.58 % discrepancies or net
 physical inventories                                    value of $ 6,867

 Care of goods           Draperies, linens stored in     Old draperies might be
                          air conditioned room             issued temporarily
                         Material for re-upholstering    Few items of packing
                          is stored in air conditioned     material
                          room




                                                                                                                   D-29
Property Management—Inventory Control
                                                                                        Opportunities/
      Factors            State/ ICASS                         USAID                      Comments
 Welcome kits     16 welcome kits                  4 welcome kits                  Consolidate welcome kit
                                                                                   program
                  Includes TV, VCRs, and
                  computers (5 sets)
 Disposal         Disposal sales are conducted     Use spot bids to sell excess
                  as needed (3 conducted last      items
                  year)
                                                   Normally recoup 25-30 % of
                  Net proceeds of ??? items = $    original costs of items
                  20,795 on value of $ 92,449 or
                  22 % (all agencies using         Net proceeds of 2113 items =
                  warehouse)                       $ ????? on value of $ 705,879

                  Auctioned on site by
                  auctioneer (11 % commission)
                  Recoup approximately 15 % of
                  value (recently disposed of
                  many low value items)
 Appliance pool   1 appliance, furniture, and      N/A                             Establish one appliance,
                  generator pool                                                   furniture, and generator pool
                                                                                   for ICASS and USAID
 Furniture pool   All organizations participate    N/A
                  in the pool except for USAID                                     Work funding issue for
                  and Peace Corps                                                  establishing one housing pool
 Generator pool                                    N/A




                                                                                                               D-30
        Property Management Results – Dar Es Salaam
          Mean                      State/ICASS (n=11)                                                                                                                     USAID (n=7)                      Mean
                                                                                          3a1. All items in your residence have bar code labels                                                                 4.29
             4.10          0%
                         10% 10%           30%                     50%                                                                                        14%0% 14%                 71%
                                                                                      indicating they are in the non-expendable property inventory.

                                                                                               3b1. You have been provided with the annual
             3.60        10%      20%      10%        20%               40%                  inventory & reconciliation of records report and it         0% 17% 0% 17%                      67%                 4.33
                                                                                                      was done in a timely manner.

             4.20          0%
                         10% 10%        20%                       60%                 3a2. All items in your office have bar code labels indicating      0% 14%0%                     86%                       4.71
                                                                                         they are in the non-expendable property inventory.

             3.78        11%0%     22%                33%                33%                   3b2. The annual inventory & reconciliation of             0% 14%          29%                 57%                4.43
                                                                                                records was completed in a timely manner.

             4.18          0%
                         9% 9%            27%                      55%                       3a3. Your work orders for furniture and equipment                14%0% 14%         29%               43%           3.86
                                                                                              are dealt with correctly and in a timely manner.

                                                                                               3b3. Furniture, appliances and equipment are
             4.18        9%0%             45%                          45%                                                                                    14%0% 14%         29%               43%           3.86
                                                                                                reasonably up-to-date and well maintained.

                                                                                                  3a4. The welcome kit was available and                                                                        4.86
             4.55      0%           45%                            55%                                                                                   0% 14%                       86%
                                                                                                            delivered on time.


             4.36      0%9%               45%                          45%                3b4. The welcome kit was complete and serviceable.             0% 14%                       86%                       4.86


             3.91      0%        36%                   36%                   27%                3a5. You are kept informed of the status of              0%         43%                      57%                4.57
                                                                                                        your requests for service.

                                                                                              3b5. The residential furniture & appliance policy
             3.82        9%0%          36%            9%               45%                                                                               0% 14%     14%0%               71%                     4.29
                                                                                                   is written, available, and appropriate.


             4.09        9%0%                55%                         36%                  3o. Overall, you are satisfied with the furniture,         0% 14%          29%                 57%                4.43
                                                                                                    appliance & equipment operation.

                       0%         20%           40%         60%         80%        100%                                                                  0%        20%         40%     60%         80%   100%

                                                                                          Strongly     Disagree       Neutral      Agree      Strongly                                                           D-31
                                                                                          Disagree                                            Agree
Note: There are no statistically significant differences between the
means of State/ICASS and USAID for these questions.
Comments about Property Management – Dar
Es Salaam State/ICASS
  No comments




                                           D-32
Comments about Property Management – Dar
Es Salaam USAID
  No comments




                                           D-33
Property Management Costs Comparison Statistics
 Warehousing/Property Management
            Statistics                                         Description                                State/ ICASS      USAID        Comments
                                     Total of government-owned and short-term leased residences.
 Number of property management
                                     May include vacant residences. Does not include residences used           41             17
 customers
                                     for offices or clubs.
 Number of non-expendable items in   The number of non-expendable items in ICASS NEPA and USAID
                                                                                                           14,210.00       4,812.00
 inventory                           BarScan databases

 Value of non-expendable items in    The value of non-expendable items in ICASS NEPA and USAID
                                                                                                          $5,823,911.02 $1,708,705.78
 inventory                           BarScan databases--includes residential, office, and other items

                                     Value of all non-expendable items divided by the number of
 Value of non-expendables/customer                                                                        $142,046.61    $100,512.10
                                     customers
                                     Area of the warehouse floor space, including isles and offices.
 Net area in warehouse               Area includes space in containerized trailors used for storage.         749.98         978.70
                                     Deos not include areas in parking lots
 Number of non-expendable items in   Items in the NEPA and BarScan inventories that are stored in the
                                                                                                            2,058.00       2,505.00
 warehouse                           warehouse area(s)

 Value of non-expendable items in    Value of items in NEPA and BarScan inventories that are stored in
                                                                                                          $891,570.10    $1,097,188.54
 warehouse                           the warehouse area(s)

 Percentage of value of goods in     Value of items stored in warehouse divided by value of total items
                                                                                                             15.31%         64.21%
 warehouse                           in respective inventories expressed as a percentage




                                                                                                                                                    D-34
Property Management Costs Comparisons
                                                                                                             State/ ICASS
 Warehousing/Property                                                       State/ ICASS                      Costs Per   USAID Costs
Management Cost Factors                    Description                         Totals       USAID Totals      Customer    Per Customer                  Comments
Management by American    Costs of USDH and offshore PSCs who
                                                                             $31,938.85      $5,578.28         $779.00      $328.13
staff                     manage property or warehouses

Management by locally     Costs of all FSN and US locally hired staff
                                                                             $14,314.68      $4,256.90         $349.14      $250.41
engaged staff             who manage property or warehouses

                          Costs of warehousemen, clerks,
Labor                     storekeepers, drivers, and others involved in     $133,274.44     $106,218.92       $3,250.60     $6,248.17
                          property management or warehousing

Rent                      Annual cost of the warehouse lease                   $0.00           $0.00            $0.00        $0.00


                          Other costs of operating the facility such as
Facilities operations                                                        $11,449.00      $17,109.04        $279.24      $1,006.41
                          janitorial contracts, etc.

                          Fuel, maintenance, and depreciation of
Vehicles                                                                     $28,204.80      $4,579.69         $687.92      $269.39
                          vehicles used in warehouse operations

                                                                                                                                          Includes costs of furniture and appliance
                          Cost of refinishing or reupholstering furniture
Furniture repair                                                               $0.00           $0.00            $0.00        $0.00        repair that may have been in Residential
                          used in residences
                                                                                                                                          Maintenance cost center

                          Annual costs of contracts for warehousing and
Contracts                                                                      $0.00           $0.00            $0.00        $0.00
                          other services excluding furnishings repair


Total                                                                         $219,181.77      $137,742.83      $5,345.90     $8,102.52




                                                                                                                                                                            D-35
Residential Maintenance—Description
                                                                                           Opportunities/
      Factors                 State/ ICASS                       USAID                      Comments
 Customers              39 housing customers          13 housing customers
                        24 State, 4 ICASS, 2 CDC, 4    8 USDH
                           DAO, 1 MSG, 2 OBO, 1 DS,
                           and American Club           4 USAID program (usually
                                                        use leased quarters)
                                                       1 OE PSC
 Properties             43 properties                 13 properties                   Reduce number of properties
 supported                                                                            required through
                         26 STL residential (2        5 STL residential             consolidation (reduce vacant
                          vacant)                                                     properties)
                                                       7 GO residential
                         1 STL residential (DAO
                          TDY quarters)                1 GO residential to be sold
                                                        (1 additional not used and
                         1 STL office for USDS         not incurring costs in
                          guard company                 FY2003)
                         13 GO residential (2
                          vacant)
                         1 GO American club
                          (residence used as club)
                         1 GO Representation
                          house in Zanzibar

 Other properties not    1 GO Warehouse               1 LTL warehouse
 counted for
 residential             GO Embassy compound          1 GSO compound to be
 maintenance                                            sold



                                                                                                                 D-36
Residential Maintenance—Personnel
                                                                                 Opportunities/
      Factors          State/ ICASS                        USAID                  Comments
 Personnel
 Managerial    Management Officer (5 %)       EXO (6 %)                    Consolidate maintenance and
                                                                            reduce management to 1 part-
                GSO (40 %)                     DEXO (6 %)
                                                                            time manager and 1 part-time
                A/GSO (35 %)                   1 GSO (45 %)                 assistant manager
                1 U.S. Facilities Mgr (35 %)
                1 Asst Facilities Mgr (58 %)
 Foreman       2 warehouse supervisor (35 %   1 FSN maintenance            Reduce warehouse
                each)                          supervisor                   supervisory requirements
                1 maintenance foreman (70 %)
                1 utilities foreman (60 %)
 Clerical      2 Secretary (60 % each)                                     Reduce administrative staff in
                                                                            ICASS
                2 supply clerk (50 %)
                1 work order clerk (50 %)
 Drivers       (drivers are in motorpool)     (drivers are in motorpool)
 Storekeeper   1 storekeeper (35 %)
 Janitorial    (janitorial contract)          (janitorial contract)
 Gardeners     1 gardener
 Laborers      6 laborer (70% each)




                                                                                                        D-37
Residential Maintenance—Personnel
                                                                          Opportunities/
     Factors          State/ ICASS                      USAID              Comments
 Personnel
 Tradesmen    1 refrigerator & air         1 carpenter             Staffing is approximately 24
               conditioning (75 %)                                  tradesmen to support 52
                                            1 plumber
                                                                    properties
               2 air conditioning (80 %)
                                            1 general maintenance
               2 air conditioning (70 %)    1 electrician           Total staff is excessive and
               1 carpenter (80 %)                                   can be reduced with or
                                                                    without consolidation
               2 carpenters (75 %)
                                                                    Much of the painting is
               2 masons (75 %)
                                                                    outsourced, but ICASS has
               4 painters (90 %)                                    4.5 FTE of painters on board
               2 electricians (90 %)
               2 electrician (80 %)
               2 plumbers (90 %)
               1 plumber (85 %)
               1 electrical helper (80 %)
               1 helper (70 %)




                                                                                                   D-38
Residential Maintenance—Description
                                                                                    Opportunities/
       Factors          State/ ICASS                        USAID                    Comments
 Facilities      Facilities in expendables      1 office                      Consolidation of facilities
                 warehouse (left behind after                                 maintenance into the planned
                 NEC construction)              1 supply room                 warehouse facility could
                                                                              reduce warehouse
                 1 office                       1 technicians room (tools)    administration for
                                                                              maintenance supplies and
                 1 supply area                  Space at warehouse with EXP   reduce security requirements
                                                supplies
                 1 carpentry shop

                 1 welding shop

                 1 lumber container

                 1 paint/ flamable

                 Crews start from the
                 residential maintenance shop
 Vehicles        2 Landcruisers                 1 minibus                     Pickups can be reduced
                                                                              through consolidation
                 4 Pickup trucks                1 pickup (4x4)
                                                                              If the facility is established on
                                                4 three-wheel vehicles        the NEC, vehicles might be
                                                                              reduced further




                                                                                                             D-39
Residential Maintenance—Description
                                                                                         Opportunities/
     Factors          State/ ICASS                            USAID                       Comments
 Management    Transitioning to work order         Excel spreadsheet published      Consolidate work orders onto
 systems       for Windows (WOW) system            everyday                         the WOW system

               Also, use another electronic        Distribute spreadsheet to        Adopt USAID best practices
               form                                management staff and anyone      for communicating
                                                   who has outstanding work         maintenance plans and
               If called in, clerk translates to   orders at the beginning and      actions
               work order                          end of each day

               Preventive maintenance              EXO applications will have a
               program published every             module that tracks work
               three months—generators             orders, costs, etc.
               and distillers
                                                   Employees submit work order
               PM is scheduled with                form or uses email—clerk fills
               residences                          out work order from email

               Trend power bills to look for       Leave work order status
               maintenance problems                report on each visit—what
                                                   was done, what was left to be
                                                   done, expectations for service
                                                   completion, etc.




                                                                                                                 D-40
Residential Maintenance—Service Levels
                                                                                               Opportunities/
       Factors                  State/ ICASS                         USAID                      Comments
  Special capabilities   Generator mechanics are           Contractor does fumigation
                         trained on Cummins                every 3 months
                         generators using computer
                         diagnostics                       Does exterior every 6 months
                                                           (fire ants)
                         1 carpenter is good at making
                         furniture
                         Can refinish furniture
                         Benjamin Moore software
                         program for modeling paint
                         schemes
                         Welder/pipe fitter (assigned to
                         NEC maintenance)
  Work load              8 make-readys per year (last      Normally have 2 make-readys    Reduce make ready
                         year had 19 make-readys)          per year                       requirements through use of a
                                                                                          consolidated housing pool
                         Conduct minor, routine            Employee turnover is very
                         maintenance                       low—5-6 years, reducing
                                                           make-ready requirements
                         Contract out major structural
                         work—floor tiling, roofing,       Routine work orders
                         etc.
                                                           Major renovations are
                         Contract out some major           contracted out—FY2003 has 2
                         painting projects                 major renovations
                         Maintain anything they install    Make-readys are contracted
                                                           out


                                                                                                                     D-41
Residential Maintenance—Service Levels
                                                                                     Opportunities/
       Factors             State/ ICASS                          USAID                Comments
  Service Levels    Respond to emergencies in 1       Routine work orders are
                    hour (goal), but not later than   completed by the end of the
                    2 hours                           following day
                    Respond to leased housing         Exceptional work is
                    for life/safety issues in less    completed over a longer time
                    than 1 hour
                    Routine work orders are
                    completed in ??????
  Operating hours   0730-1700, Monday through         0900-1700, Monday through
                    Friday                            Friday

                    On call 24/7 for emergencies      On call for off duty hours
                    (customers call Facilities        (customers call maintenance
                    Maintenance Supervisor)           supervisor after hours)

                    Maintenance supervisors           Supervisor carries a cell
                    carry cell phones                 phone




                                                                                                      D-42
Residential Maintenance—Service Levels
                                                                                      Opportunities/
       Factors          State/ ICASS                        USAID                      Comments
  Other notes    Conduct weekly generator         USAID uses voltage             Reengineer processes to
                 checks. Check fuel level—put     regulators to reduce voltage   reduce inspection
                 into email to motorpool to       surges and damage to           requirements on generators
                 schedule fuel delivery. Check    appliances and other           and the reading of Luku
                 Luku Meter—electricity           equipment                      meters
                 metering system
                                                                                 Manage fuel level readings
                 Moving distiller units outside                                  and fuel deliveries together to
                 to reduce heat and thus,                                        reduce required trips for
                 electricity costs                                               inspections and fuel
                                                                                 deliveries
                 Moving GFI switches outside
                 for access by guard force                                       Reduce staff requirements
                                                                                 accordingly




                                                                                                              D-43
       Residential Maintenance Results – Dar Es Salaam
          Mean                  State/ICASS (n=11)                                                                                                                               USAID (n=7)                         Mean
                                                                                        4a1. Upon your arrival at post, your residential unit was ready for
            3.80        10%      20% 0% 20%                     50%                     move-in, with the utilities on, repairs & painting completed and the        17%     17% 0%          50%                17%      3.33
                                                                                                                unit thoroughly cleaned.
            4.00      0% 18% 0%             45%                      36%                    4b1. Residential maintenance staff promptly corrected any          0%14%      14%                 71%                       4.57
                                                                                                     problems identified during your move-in.
                                                                                      4c1. Upon your arrival at your new residence, you were given verbal
            3.27      0%        36%               27%         9%       27%             and/or written instruction on how to operate and clean appliances – 0%         29%                   57%                14%      3.86
                                                                                     alarms, generators, location of circuit breakers and water cut-off valves

            3.73        9%0%      27%                36%               27%           4a2. Routine maintenance repairs are performed correctly the first time. 0%14%                   57%                  29%          4.14


            4.30      0% 20%             30%                    50%                           4b2. Work orders are responded to in a timely manner.            0%         43%                      57%                  4.57


            3.10      0%      30%                 40%              20%         10%      4c2. You are routinely asked to provide written or verbal feedback     0%14%      14%               57%                14%      3.71
                                                                                                          on the quality of repairs made.

            4.18      0% 18%                45%                      36%             4d2. The work crews routinely clean up the work area after completion. 0%14%0%                         86%                         4.71

                                                                                        4a3. The residential maintenance office notified you in advance, of
            4.09      0%9% 9%               45%                      36%                                                                                       0%14%            29%                57%                  4.43
                                                                                                        scheduled maintenance activities.

            3.90      0%
                       10% 10%                    60%                      20%                   4b3. Preventative maintenance is done regularly               0%14%                        86%                         4.86
                                                                                                      and the area is cleaned up afterwards.

            4.44      0%11%           33%                      56%                    4a4. Emergency repairs are done quickly so as to minimize damage         0%     29%                     71%                       4.71
                                                                                                             and inconvenience.

            3.33        11%0%               56%                11%       22%                  4b4. There is a clear and published definition of what           0% 17%                       83%                         4.83
                                                                                                       ―emergency maintenance‖ means.

            3.82      0%9%        27%                36%               27%            4a5. You are kept informed of the status of your requests for service. 0%                 57%                     43%             4.43

                                                                                           4b5. The residential maintenance policy is written, available,
            3.50      0%                 70%                    10%        20%                                                                                 0% 17% 0% 17%                      67%                   4.33
                                                                                                                 and appropriate.

            4.10      0%      30%              30%                 40%                    4o. Overall, you are satisfied with the residential maintenance      0%               57%                     43%             4.43
                                                                                                                services provided.
                      0%         20%        40%         60%        80%           100%                                                                          0%         20%         40%    60%         80%     100%
                                                                                                                                                                                                                         D-44
                                                                                         Strongly        Disagree        Neutral       Agree       Strongly
Note: Questions within a shaded box indicate that the difference between the             Disagree                                                  Agree
means of State/ICASS and USAID is statistically significant at 0.05.
Comments about Residential Maintenance –
Dar Es Salaam State/ICASS
  I don't remembers seeing a published definition or policy. However, I have ALWAYS received immediate assistance when
   I requested it whatever the hour or day.
  Efficient operation




                                                                                                                          D-45
Comments about Residential Maintenance –
Dar Es Salaam USAID
  USAID issues a useful calendar for preventive maintenance that is extremely user friendly.




                                                                                                D-46
Residential Maintenance Costs Comparison Statistics
                                                                                                                    State/
      Residential Maintenance Statistics                               Description                                 ICASS      USAID
                                           Total of government-owned and short-term leased residences.
     Total number of residences            May include vacant residences. Does not include residences used           41         17
                                           for offices or clubs.

     Number of government-owned
                                           Number of residences that are government-owned                            14          8
     residences


     Number of leased residences           Number of residences that are short-term leases                           27          9


     Total residential square meters
                                           Total of floor space in all residences that are maintained              7,194.99   3,835.42
     maintained

                                           Average number of new residences to be prepared for occupancy
     Average number of make readys per
                                           and the average number of existing residences that must be maded         16.40       6.80
     year
                                           ready due to occupant turnover
                                           Total of all US direct hire staff, offshore PSCs, and locally engaged
     Total residential maintenance staff   staff that are managerial, clerical, skilled, or unskilled performing     31.2       9.8
                                           residential maintenance


     Contractors                           Total number of contractors, if known                                      0          0


                                           Total residential maintenance staffing divided by the number of
     Staff to residence ratio                                                                                        0.76       0.58
                                           residences maintained




                                                                                                                                         D-47
Residential Maintenance Costs Comparisons
                                                                                                                    State/ ICASS   USAID Costs
 Residential Maintenance                                                              State/ ICASS                   Costs Per         Per
      Cost Factors                               Description                             Totals      USAID Totals    Residence      Residence             Comments
Management by USDH or       Costs of USDH and offshore PSCs who
                                                                                       $87,454.05     $11,156.56     $2,133.03       $656.27
USPSC                       manage residential maintenance
                            Costs of all FSN and US locally hired staff
Management by LES                                                                      $32,615.68     $43,509.20      $795.50       $2,559.36
                            who manage property or warehouses
Skilled tradesmen and other Costs of warehousemen, clerks,
                                                                                      $337,050.16    $105,384.92     $8,220.74      $6,199.11
labor costs                 storekeepers, drivers, and others
                                                                                                                                                 There may be inconsistencies with
                            Costs of all materials that go into maintenance
Materials                                                                              $85,207.00     $15,559.89     $2,078.22       $915.29     the dollar values for residential
                            of residences                                                                                                        generator fuel.

                            Costs to rent, operate, and maintain the
Facilities                                                                             $16,646.00      $914.78        $406.00        $53.81
                            offices and shops
                            Fuel, maintenance, and depreciation of
Vehicles                                                                               $23,921.20     $8,972.47       $583.44        $527.79
                            vehicles used for residential maintenance
                            Costs of all contracts related to residential
Contracts                                                                              $10,749.00       $0.00         $262.17         $0.00
                            maintenance

Total                       Total costs without OBO                                   $593,643.09    $185,497.82     $14,479.10     $10,911.64
                            Costs of facilities maintenance supervisors paid for by
                                                                                                                                                 Paid for by OBO--not an
Management by OBO           OBO (includes the ongoing maintenance costs for           $190,078.00       $0.00        $4,636.05        $0.00
                            GO/LTL Residential Properties also paid for by OBO)                                                                  ICASS cost

Total with OBO              Total of all costs                                        $783,721.09    $185,497.82     $19,115.15     $10,911.64




                                                                                                                                                                                D-48
Leasing
                                                                                     Opportunities/
    Activity          State/ ICASS                         USAID                      Comments
 Leases        28 total leases                 6 total leases                   Consolidate into one housing
                                                                                pool
               26 STL residential (2 vacant)   5 STL residential (for program
                                               personnel)
               1 STL residential (DAO TDY
               quarters)                       1 LTL warehouse

               1 STL office for USDS guard
               company



               Giving up 2 leased houses—
               getting rid of older/costlier
               properties




 Workload      3 new leases last year          1 new lease per year

               5 renewals last year            1 or 2 renewals per year

               Lease term is 6 years           Generally 5 to 9 year terms
                                               with options for renewal
               1/19 went into temp quarters
               for 3 weeks




                                                                                                           D-49
Leasing (Cont’d)
                                                                                                   Opportunities/
      Activity                 State/ ICASS                             USAID                       Comments
  Personnel             Management officer (5 %)           EXO (2 %)                         Reduce requirement to 1 part-
                                                                                             time manager and 1 part-time
                        1 USDH GSO (15 %)                  DEXO (3 %)                        leasing FSN

                        1 FSN A/GSO (55 %)                 GSO (5 %)

                        1 Secretary (5 %)                  Admin Assistant (15 %)
  Identify properties   Use 2-3 local real estate agents   Use 3 local real estate agents    Combine requirements and
                        to find properties                 that assist on request            schedules
                        Conduct preliminary                Maintenance FSN develops list
                        inspection to determine            of requirements for negotiation
                        suitability                        with landlord
                        Facilities management and          RSO inspects property and
                        RSO conduct inspections and        adds to list
                        add to requirements list
                                                           DEXO negotiates list as part of
                        Requirements are used to           rental package
                        negotiate with prospective
                        landlords




                                                                                                                         D-50
Leasing (Cont’d)
                                                                                              Opportunities/
      Activity              State/ ICASS                           USAID                       Comments
  Negotiate leases   A/GSO negotiates contracts         DEXO and EXO negotiate           ICASS and USAID negotiate as
                                                        leases                           one organization
                     A/GSO signs leases
                                                        EXO signs leases
                     Require that landlords do
                     make ready inside and out          Landlord usually will redo
                                                        kitchens, bathrooms, and
                     FM does water pump and roof        floors (terrazo ceramic tile)
                     tank, fire extinguishers, escape
                     windows, and other items           Lease prices are dropping

                     Ask new landlords to add
                     water heater
                     Leasing arrangements and
                     prices have become more
                     favorable for ICASS
  Arrange payments   Rents are paid annually in         Rents are paid annually in
                     advance by check or EFT in         advance by check in dollars
                     dollars
                     Working on semiannual
                     payments in advance

  Maintain records   Maintain lease records using       Leases are maintained in paper   Use one records system
                     Excel                              files

                     Use RPA in PASS system             Use USAID standard lease

                     Signed leases are maintained
                     in hard copy file
                                                                                                                   D-51
Leasing (Cont’d)
                                                                                               Opportunities/
      Activity               State/ ICASS                        USAID                          Comments
  Renew leases        Send letter to landlord in      Renewal process is very            Consolidate efforts of ICASS
                      advance                         simple—landlords generally         and USAID
                                                      perform well
                      Review performance and
                      current condition with          Housing board is involved in
                      occupant, RSO, and facilities   assignments—usually allow
                      management                      agencies to assign within own
                                                      properties to prevent
                      Develop requirements and        expensive transfers of owned
                      market survey data for          generators, air conditioners,
                      negotiation                     etc.
  Maintenance in      Landlords are responsible for   Landlords are responsible for      Adopt USAID processes for
  conjunction with    all major maintenance           major structural maintenance       maintenance only if landlords
  leasing contracts                                   issues—roof leaks, water tank      are not responding effectively
                      Residential maintenance         failures, electrical panel         and in a timely manner to
                      performs all minor, routine     failures, etc.                     requests
                      maintenance
                                                      Frequently, landlords will allow
                                                      USAID to solicit bids from
                                                      contractors directly, oversee
                                                      work, and deduct costs from
                                                      rent

                                                      USAID provides all minor,
                                                      routine maintenance—
                                                      plumbing leaks, minor
                                                      electrical problems, light bulb
                                                      replacements, etc.



                                                                                                                        D-52
Leasing (Cont’d)
                                                                                          Opportunities/
     Activity           State/ ICASS                         USAID                         Comments
  Coordination   Share information on houses      Share information with State      Consolidate leasing activities
                 that they looking at             on identifying properties         and re-address a blanket
                                                                                    waiver from OBO for
                 After selecting house, obtains   Check with agents to make         exceeding $ 25,000 on leases
                 approval from housing board      sure they are not negotiating
                                                  with State on same property
                 Request waivers from OBO for
                 houses over $ 25,000 (all        (One exceptional instance of
                 houses are over that)            Landlord agent dealing with
                                                  USAID for sale while local
                 Sends information over to        relative was dealing with State
                 USAID for houses that will be    for lease)
                 discussed at the housing
                 board

                 Conduct virtual tours for
                 houses


  Other Notes    Looking at pushing more          Decision to buy or lease is       Convene meetings with State,
                 purchases in the future          based on ability to offset        USAID, and OBO to establish
                                                  purchase price over 7 years of    policies in the best interest of
                                                  rent receipts                     the U.S. taxpayer
                                                  Look to purchase properties
                                                  mostly because of the local
                                                  rental prices (as high as
                                                  $ 4,000 per month




                                                                                                                   D-53
Leasing Results – Dar Es Salaam


                                State/ICASS                                                                                                     USAID
                                   (n=11)                                                                                                       (n=7)
       Mean                                                                                                                                                              Mean
                                                                          2a. Your residence is the appropriate size and
                                                                           layout for your family’s needs and MORE or
         4.27                                                                                                                0%17%0%      33%              50%            4.17
                    0% 0%
                     9%           45%                 45%                LESS comparable in size and layout to others at
                                                                              post regarding seniority and family size.


                                                                          2b. The leasing office ensures that the landlord
                                                                             of your residence expeditiously resolves
         4.00                                                                                                                                                             4.50
                    0% 22%                56%               22%            problems with the residence OR the required       0%        50%                 50%
                                                                         repairs are made by staff in accordance with the
                                                                                       terms of the contract.


                                                                                2c. Overall, you are satisfied with                                                       4.40
         4.00       0%
                     10%                  80%                 10%                                                            0%          60%                40%
                                                                                       the leasing office.


                    0%      20%      40%        60%    80%      100%                                                         0%    20%         40%   60%    80%   100%


                                                                    Strongly      Disagree      Neutral      Agree      Strongly
                                                                    Disagree                                            Agree



  Note: There are no statistically significant differences between the
  means of State/ICASS and USAID for Leasing, Dar Es Salaam




                                                                                                                                                                                 D-54
Comments about Leasing – Dar Es Salaam
State/ICASS
  I live in a Government owned residence. GSO is responsive.
  I live in Government-owned housing
  Best house I have ever had.
  As a member of the housing board, I think Washington MUST re-look at what their willing to pay for a standard lease. The
   housing market here for leasing a house has gone up $3,000 to $ 5,000 more per. So the going rate of leasing a house
   here in Dar.
  Nice place :)




                                                                                                                              D-55
Comments about Leasing – Dar Es Salaam
USAID
  No comments




                                         D-56
Leasing Costs Comparison Statistics
                                                                                                                  State/
          Leasing Statistics                                        Description                                  ICASS          USAID                 Comments
                                         Total number of properties leased including residences,
Total number of leases                   warehouses, offices, and parking lots. Does not include                       28               10
                                         Government-owned property


Number of residential leases             Total number of residential properties leased                                 27               9


                                         Other leases that include residences, warehouses, offices, parking
Number of non-residential leases                                                                                           1            1
                                         lots, or other properties


Average area of residential properties   Average area of residential properties calculated using FAM criteria      184.49         221.10


                                         Total annual residential lease costs divided by number of
Average rents of residential leases                                                                             $31,519.23     $34,613.33
                                         residential leases

                                         Total number of residences, including Government-owned, divided
                                                                                                                                             An indicator of leasing
Residential Property Float               by the number of employees eligible for housing at post (number of       100.00%        100.00%
                                                                                                                                             efficiency
                                         customers) express as percentage




                                                                                                                                                                   D-57
Leasing Costs Comparisons

                                                                                                        State/ ICASS
                                                                          State/ ICASS                   Costs Per     USAID Costs
    Leasing Cost Factors                    Description                      Totals      USAID Totals      Lease        Per Lease
  Management by USDH or    Costs of USDH and offshore PSCs who
                                                                           $34,198.80     $5,578.28      $1,221.39       $557.83
  USPSC                    manage leases
                           Costs of all FSN and US locally hired staff
  Management by LES                                                        $10,345.85     $2,978.07       $369.49        $297.81
                           who manage leases
                           Costs of vehicles, office supplies, or other
  Other                                                                    $8,979.00       $529.27        $320.68        $52.93
                           costs associated with leasing

  Total Costs              Total annual costs                              $53,523.65     $9,085.62      $1,911.56       $908.56




                                                                                                                                     D-58

						
Related docs