Purchasing Productivity Report by Buyer Report
Report Series Name
C-U-PS-BUYER-PRODUCTIVITY
Report Name
PURCHASING PRODUCTIVITY
REPORT (by buyer)
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. The purchasing manager should review this report
each month to monitor the buyers productivity.
Content
This report shows the number
of days required to handle each requisition line, sorted by buyer and then
by the number of processing days. Also produced in this report series is
the Purchasing Productivity Report (by department).
Totals
This report totals by buyer
and report 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
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.