Description
Tracking fleet utilization (miles per year) for DLA and DoD is very important. DLA tracks target utilization and Pct Util YTD to monitor fleet usage.  It sets its objective percent at 100% and minimum objective percent at 80%.  OUSD AT&L/ARA now requires written assessments for vehicles whose utilization is less than 75% of Federal Annual Mileage Minimums to retain vehicles for continued use.  DoD’s main fleet policy directive, DoD Manual 4500.36, sets annual utilization goals in miles.  The problem is that DPAS does not track utilization in miles.  It only tracks "Days Available."  This does not meet DLA fleet management requirements or allow DoD Agencies to determine which vehicles they need to provide written assessments on.  Additionally, VAM surveys, required by EO 13693 to optimize fleets, use annual mileage as an extremely key factor in their analyses.

Recommended
Adding formulas to DPAS to accurately calculate equipment utilization (which can be calculated for either miles or hours per year) and not availability.  We need to calculate utilization (i.e. the miles driven or hours used) for each asset against the objective and mininum objective percentages set for these assets. We need to also calculate the actual utilization against the target monthly utilization to assist equipment managers in a making better use of underutilized equipment.  Examples and formulas will be provided.

Mission Critical
This is mission critical and also mandated. Fleet Managers (FM) are required to manage the use of equipment and minimize under utilization of equipment throughout the FY, as well as report utilization of equipment through FAST. Also OUSD AT&L/ARA Memo, "Underutilized Leased Vehicles Management" 13 Jan 2016 states "written assessments now required for vehicles whose utilization is less than 75% of Federal Annual Mileage Minimums"; they are 9,000 miles for passenger vehicles and 7,500 for light trucks. DoD 4500.36 sets annual utilization goals in miles/hours.

Benefits
This will benefit all agencies in reducing cost by allowing FMs the ability to monitor and effectively manage the use of equipment as well as optimize their fleet. This will provide FMs a great tool for the efficient management of equipment and tracking the day-to-day utilization, while allowing them to eliminate under utilization of equipment. This will also eliminate the use of outside tools to assist FMs in tracking effective and efficient utilization of equipment. Accurately captures equipment mileage/hours used and reduces time to manually enter data.

Users
This should affect ALL users of DPAS.

Completed – Release 6.0 – 27 April 2018

Description
DPAS users utilizing Authorizations want to identify which assets are associated to the Authorization but presently cannot via Inquiry.

Recommended
Add Authorization Property Type Code as an Asset Inquiry Search or as a 'Field' in the Asset Mgmt Inquiry so assets can be identified. There is currently no workaround to identify assets by Authorization Property Type Code.

Mission Critical
Mission critical when trying to identify War Reserve Material (WRM) and Unit Type Coded (UTC) Assets.

Benefits
Reduces time and improves accuracy of inventory

Users
All users

Completed - Release 4.1.40 - 09 December 2016

Description
To meet the FAST Vehicle Level Reporting Out Year Vehicle Acquisition, Disposal and Fleet Cost, we have to capture several data elements.
Unlike other elements, not needed until reporting in October 2017.

Recommended
Attached is the table of data elements required for reporting each Out-Year Requirement. Comments for each element reflect what drop-down table should be. Entry should be given to FAST Manager and FAST Officer Role.

Mission Critical
Mandated by EO 13693 for VLD reporting and FAST interface.

Benefits
Accuracy of reporting

Users
FAST Manager and FAST Officer

Partially Completed – Release 5.2 – 29 September 2017

Partially Completed – Release 5.2.2 – 17 November 2017

Completed – Release 6.0 – 12 January 2018

Description
Effectively planning and scheduling for over 300 Preventative Maintenance (PM) operations on the MHE fleet at DLA's Eastern Distribution Center (EDC) is a critically important function to DLA and the supported warfighter. With limited resources and a heavy PM schedule, it is important for needed DPAS Reports (or Inquiries) to provide users all the needed information and for users to be able to pull these Reports (or Inquiries) easily. Currently, maintenance personnel have to run multiple reports, from different locations (and individually lookup each Asset ID for its "Location" and "Equipment Pool"), for the 4 data sets they service. This is time consuming, costly and does not meet user needs.

Recommended
Add "Equip Pool" and "Location" fields to those that can be selected when running the "Asset Prvn Maint Sch" M&U Inquiry, located through the Inquires>Maintenance>Asset Prvn Maint Sch" menu path. These two fields are available on the Maintenance Asset Inquiry shown on the attached document and highlighted in yellow. Request these fields be added to those available in the Asset Prvn Maint Sch Inquiry and that the same information provided (when selecting these fields in the Maint Asset Inquiry) be provided when selecting these in the Asset Prvn Maint Sch Inquiry.

Mission Critical
Keeping the EDC's MHE fleet operational, by performing required PM, is mission critical. An operational MHE fleet is critical to DLA Distribution's material support of the warfighter.

Benefits
Reduces time, effort and complexity required to obtain data needed to schedule PMs and locate equipment needing PM.

Users
It will effect anyone who works in a Maintenance activity required to track and notify equipment owner and users of upcoming Preventative Maintenance inspections, or a user/owner that wants to know when upcoming inspections are scheduled.

Completed - Release 5.1 - 28 April 2017

Description
Problem: The DPAS Increase/Decrease Report can ONLY be extracted as a ".pdf" file.

Recommended
FSA FIAR Team is requesting the DPAS Increase/Decrease Report be available as an "excel file." With the system extracting the information in a ".pdf" it is time consuming for the team to reconcile the reports against the Key Supporting Documents (KSDs) from the subordinate commands. This will provide the FSA FIAR Team the capability to filter by "UIC" and reconcile the DPAS report by Activities in a more efficient and timely manner.

Mission Critical
BSO General Equipment Corrective Action Plan (CAP) Implementation Guide, CAP 2, KSD to APSR Reconciliation, requires BSO Personal Property Managers (PPM) to verify and validate responses received by Activities. In order to complete this task, the current Increase/Decrease Report can only be downloaded in a .pdf file. The solution would assist in completing mandated tasks and complying to implementation guides in a more efficient and timely manner.

Benefits

1. Reduce Time - Filter for the multiple Activities by UIC more accurately and timely manner
2. Increases Accuracy - Reconcile DPAS Report to Activities report with fewer errors.

The Asset Management 6.2 CAP 2 KSD TO APSR RECONCILIATION states the following:
- On a quarterly basis (or as deemed more frequently required by the Command), the PPM or other designated official obtains:

1. All asset acceptance and disposal documents as of the last review period
2. DPAS reports capturing acceptance and disposals in the system as of the last review period .

The PPM (or other designated official) determines if the documents reconcile with DPAS records created in the last review period. Any discrepancies between the two lists are researched and resolved. Once the reconciliation is completed, the PPM (or other designated official) signs and date-stamps the reconciliation report and retains for audit purposes.
To conduct the reconciliation, the Activity PPM (or delegated official) will: 

• Gather all acceptance/disposal documents (KSDs) for assets acquired as of the last review period
• Generate a DPAS Increase/Decrease report for the applicable quarter (located in the forms-reports tab of DPAS), and compare the two (2) documents, notating any discrepancies/differences. 
• - A comparison can be conducted via an excel worksheet to facilitate the comparison of the DPAS report and acquisition/disposition documentation.
• Research and resolve the noted discrepancies until no differences exist between the DPAS report, and the KSDs

Users
This solution can be useful across all Components/Agencies that use the DPAS Increase/Decrease Report for reconciling. It can decrease time spent on filtering information, decrease the chance of inadvertent errors, and increase efficient work productivity.

Completed - Release 5.1 - 28 April 2017

Description
DPAS assets repaired by non-DPAS Maintenance Activities need to capture maintenance information and cost for FAST reporting. Joint Bases using MAXIMO need to have info loaded into DPAS and the only workaround is manually creating a WO in DPAS.

Recommended
Create an interface or WO load within DPAS to capture maintenance information pulled from a .CSV file. Possibly use data elements from Conversion tab lha1 for load. (ATTACHED).

Mission Critical
Mandated. All vehicles cost have to be reported to FAST.

Benefits
Accurately captures vehicle maintenance cost and reduces time to manually enter data.

Users
Only activities where MAXIMO is used as the Maintenance System.

Description
Files loads to DPAS will happen below the Enterprise/FAST Officer level and need to be flexible enough to assign different functionalities to an individual user.

Recommended
Request creating a Utilities Technician Role as a standalone allowing the individual to load designated files types. The role could be created similar the Work Order Technician where the IO can designate which files the individual may load to DPAS.

Mission Critical
Mission critical to push functionality below Enterprise to allow for smaller, more frequent loads.

Benefits
Reduces time and improves accuracy allowing the MA to load their own data.

Users
Only the users requiring outside DPAS data loads.

Completed – Release 6.3.1 – 11 January 2019

Description
LIMS-EV Vehicle View requires vehicle equivalence value in DPAS/Send value via existing Change Data Capture (CDC) process.

Recommended
Request an update to the current ICD/MOA and for the vehicle equivalence value to be sent via the existing auto data CDC exchange between DPAS and LIMS

Mission Critical
Mission critical because the Equivalence values is used to help determine the maintenance and technical complexities of the vehicle.
It also is a determining factor for manning and budget.

Benefits
This will facilitate the value's display and use in the AF approved vehicle report generating and Business Intelligence System LIMS-EV Vehicle View. It enables the management and project budget requirements for both manpower. This will streamline and automate a manual process and eliminate the need for maintaining a user editable reference table.

Users
Yes. This change will affect all Vehicle Management units across the Air Force an may also benefit other services/agencies.

Completed - Release 5.0 - 03 February 2017

Description
General Ledger balances require a verifiable, accurate and complete asset data population. Currently, the DoN cannot support the balances reported on the Financial Statements with a complete asset data population. FMO-24 has implemented the quarterly Asset Data Universe Data Call to mitigate this risk, which requires BSO's to provide a complete and certified quarterly asset listing. The reliance on multiple BSO's to attain reliable data results in the risk of inaccurate reporting by BSO's due to a time lag by running an inquiry vice a system generated report. This increases the likelihood an end user will add/remove a capital asset and result in the inquiry report not matching the capital asset report totals and the CFO accounting statement balances.

Recommended
Automatically run and archive a capital asset report using requested data fields directly after depreciation posts at the end of the month. This will be used as an authoritative report that is system generated to support asset balances for audit support purposes. Recommended DPAS report data fields:

• ITEM DESC
• SERIAL NBR
• ASSET ID
• UIC
• CUSTODIAN NBR
• STATUS
• UI
• TOT COST
• ACCUMD DEPRN
• PRSNT BK VLU
• DEPRN PERIOD
• ACQ DT ACTVN DT
• LOC
• COND CD

Mission Critical
Mission critical to be implemented by 9/30/16. High level SES interest. This will report will be critical as it will be used as an authoritative report to support asset balances for audit support purposes.

Benefits
Reduce: time, cost, error
Improves: accuracy, consistency of financial reporting
Supports: audit readiness and beginning balances

Users
Yes

Also see SCR 00663

Partially Completed - Release 4.1.40 - 09 December 2016

Fully Completed - Release 5.2 - 29 September 2017

Description
When trying to process a mass disposal of items, like those sent to DRMO, you have to go through individually using Asset ID or using a Stock Nbr to get single items. ****Please see attached picture of area I am talking about****

Recommended
Add another block for search criteria, I would ask to insert a "Sub Location" search criteria to find assets that you can segregate from others to process a mass upload of disposed assets.

Mission Critical
This is neither but could have a positive affect of the system

Benefits
If this search can be added to the "Disposition" drop down for all "*Type Action" it could reduce time spent doing individual disposals/turn-ins/etc. This will improve accountability and accuracy of disposal of assets at the APO level.

Users
This would affect users and myself as an APO in a positive way to streamline a process that is currently slowing me down at the steps you must currently use.

Completed – Release 6.0 – 27 April 2018