Purchasing Productivity Report by Agency Report

Report Series Name
C-U-PS-BUYER-PRODUCTIVITY

Report Name
Purchasing Productivity Report (by agency)

Library
Source code is located in PSPUBLIC

Use
This report series indicates the time elaspsed in handling a requisition line, from the time it is approved until the time it is split, summarized for the agencys purchasing department. The purchasing manager should review this report each month to monitor the departments productivity.

Content
This report shows the number of days required to handle each requisition line, sorted by the number of processing days. Also produced in this report series is the Purchasing Productivity Report (by buyer).

Totals
This report gives a grand total for number of PO lines, elapsed days and average elapsed days

Column Headings

• BUY ENTY - Buying entity
• REQUISITION NUMBER - Unique identifier for a particular requisition number
• REQ LINE NUMBER - Requisition line number
• EXTENDED VALUE - Quantity requisitioned times unit price
• BUY ID - NCAS buyer ID code that identifies the buyer assigned to the requisition
• REQUISITION APPROVAL DATE - Date the requisition was approved
• PO CONVERSION DATE - Date the requisition line was converted to a purchase order line
• ELAPSED DAYS - Number of days between the Requisition Approval Date and the PO Conversion Date
• AVG ELAPSED DAYS - Elapsed Days divided by the number of converted lines

Run Statements
The run statement member name is C-U-PS-BUYER-PRODUCTIVITY-RUN

000010 OPTION LIBRARY(PSPUBLIC)
000020 RUN C-U-PS-BUYER-PRODUCTIVITY
000100 INTO LIBRARY XXXXXXXX
000200 VARIABLE REPORT-FROM-DATE
000300 '11/01/90'
000400 VARIABLE REPORT-TO-DATE
000500 '11/30/90'
000600 *SELECT PUR-BUYING-ENTITY
000700 *SELECT PUR-SPLIT-PO-LINE-ENTERED-DT

Type over the displayed variable values with your agencys values