DPAS SCR: 01295

• SCR Number
  01295
• Title
  Utilization Report Extract Improvement
• DPAS Module
  MU
• Reporting Organization
  DLA
• State
  New
• History
  Submitted: 20180620
• Description

  Description
  Problem: Tracking utilization is very important in Fleet Management. The new Utilization Report Extract tracks and reports utilization, but needs to be updated for all assets loaded into DPAS. Currently, the report defaults the Util Target Monthly to 1000 for FAST Reportable vehicles and all FAST Reportable Vehicles Util Target Monthly isn't 1000. Also, the report defaults the Util Target Monthly to 0 for all other assets reporting utilization.

  Recommended
  When an Agency or Service is developing the DPAS catalog there are mandatory fields that are required to have data inputted; Yr SVC Life and Util SVC Life.
  Each and every asset placed in DPAS must have a SN created, regardless of agency.
  One agency may use 8yrs/200,000 and another 10yrs/250,000 (not saying either is right or wrong), but there must be values inputted. Everything is driven from these two fields.
    Using the two fields the calculation should be:

  • Util SVC Life (250000)/Yr SVC Life (10)= Util Target Annual (25000)
  • Util Target Annual (25000)/12 (months)=Util Target Monthly (2083)

  The formula is agency neutral, it is the data in the fields that drive the end result.
  This should be the case regardless of type of asset.
  And that value should populate the Util Target Monthly in the MAM, as well as the report.
  These values are already being utilized to develop the Utilization Report Extract.
  Once the Util Target Monthly is calculated and populated request that it be greyed out for all users (this value will be calculated from the information gathered from the catalog), as well as the Minimum Objective Percent and Objective Percent.

  Mission Critical
  This is mission critical because it supports tracking proper use of assets and tracking of under utilized assets correctly.

  Benefits
  This will benefit all activities in DPAS by reducing time and error in reporting. Having DPAS perform the calculations allows the system to work for the user. It removes the human factor from having to perform calculations which can introduce errors.

  Users
  This should affect ALL users utilizing DPAS.