Analysis of the Air Force Retail Asset Balance Reporting Process

Abstract

The Standard Base Supply System reports asset inventory balances to AFMC using two methods, a daily report and a quarterly report. The daily report (7LF/9Q(x)) is provided each day an item's asset balance changes. It provides new reports and overwrites previously reported daily balances. The quarterly report (7WS) is generated at the end of each quarter and is a snapshot of SESS asset balances for all Air Force-managed items. When total asset balances from both reporting methods are compared they yield different results. The objective of this analysis was to determine why there are differences in asset balances reported via the two methods. Provide recommended changes to daily Recoverable Assembly Management Process (RAMP) reporting process and/or to the 7WS transaction to provide AFMC accurate asset balances to use for worldwide requirements computation of AF-managed items. There are four reasons why asset balances reported via the daily RAMP process would differ from asset balances reported on the quarterly 7WS transaction. First, the RAMP program (D-28) that generates daily and quarterly asset balance reports uses different program logic to accumulate reportable quantities. Second, the daily RAMP reports are not created for all AF-managed items. Third, the 7WS reports positive balances for L or P serialized NSNs and equipment items. And fourth, not all daily RAMP transmissions successfully get to D035A. Our recommendations include correcting program errors and designing a program to generate end-of-quarter daily RAMP transactions. When both actions are complete, we recommend AFMC use balances reported via daily RAMP transactions for worldwide requirements computations and daily repair and distribution decisions.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Dec 01, 2002
Accession Number
ADA412031

Entities

People

  • Doug Blazer
  • John Dietz
  • Steve Martinez
  • Todd Gilreath
  • Tony Parrish

Organizations

  • Air Force Logistics Management Agency

Tags

Communities of Interest

  • Human Systems
  • Materials and Manufacturing Processes

DTIC Thesaurus Topics

  • Abstracts
  • Accuracy
  • Air Force
  • Air Force Facilities
  • Airborne
  • Assembly
  • Business Administration
  • Computations
  • Controlled Environment
  • Data Transmission
  • End Items
  • Errors
  • Inventory
  • Logistics
  • Logistics Management
  • Maintenance
  • Standards

Readers

  • Climatology
  • Defense Financial Management and Audit.
  • Logistics and Supply Chain Management.