US20060111966A1 - Supplier performance reporting - Google Patents
Supplier performance reporting Download PDFInfo
- Publication number
- US20060111966A1 US20060111966A1 US11/322,348 US32234806A US2006111966A1 US 20060111966 A1 US20060111966 A1 US 20060111966A1 US 32234806 A US32234806 A US 32234806A US 2006111966 A1 US2006111966 A1 US 2006111966A1
- Authority
- US
- United States
- Prior art keywords
- supplier
- caused
- orders
- rejection
- customer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
- 238000000034 method Methods 0.000 claims abstract description 43
- 230000002950 deficient Effects 0.000 claims description 7
- 238000010586 diagram Methods 0.000 description 6
- 230000004044 response Effects 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000737 periodic effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
Definitions
- This invention relates to a system and method for reporting supplier on-time performance and a system and method for reporting supplier reject performance.
- Supplier on-time performance is typically reported as a percentage of orders that are delivered within a specified period of time with respect to a standardized start point and end point.
- a “start point,” i.e. an event triggering the start of a time period used to measure delivery time, must be identified.
- An “end point,” i.e., an event triggering the end of the time period used to measure delivery time, must also be identified.
- the possible start points used for measuring delivery time include: the time at which the buyer placed the order (“order sent” or “OS”), the time at which the supplier received the order (“order received” or “OR”), and the time at which the supplier confirmed the order with the buyer (“order confirmed” or “OC”).
- Possible end points that might be used for measuring delivery time are, for example, the arrival time of the supplier shipment at one of the following: the customer's receiving dock (“CRD”) (note, the terms “customer” and “buyer” are used interchangeably herein); the customer's final destination (“CFD”, e.g.
- OTO origin transport on board
- DTO destination transport onboard
- DCI destination customs inbound
- DCO destination customs outbound
- An aspect of a present embodiment receives and processes data to enable reporting of on-time performance relative to a plurality of order start point/end point pairs.
- Customers and suppliers report on-time performance for system processing using the delivery start and end points collected in the normal course of their business operations.
- System users may obtain supplier on-time performance reports indicating the on-time performance of suppliers relative to the plurality of start point/end point pairs reflected in the collected data.
- Another aspect of a present embodiment collects transaction information predictive of whether an order reject was supplier caused or customer caused.
- the predicted cause of order rejects is reflected in supplier reject performance as reported by a system implementing this aspect of the present invention.
- FIG. 1 is a system level view of the basic components and data flow in a system that may be used to implement an embodiment of the present invention.
- FIG. 2 a is a table illustrative of Basic Purchase Order Data provided by a customer/buyer computer system.
- FIG. 2 b is a table illustrative of Summarized Purchase Order Data stored in system 10 of FIG. 1 .
- FIG. 3 is a process diagram illustrating steps for converting the Basic Purchase Order Data of FIG. 2 a into the Summarized Purchase Order Data of FIG. 2 b.
- FIG. 4 is a sample supplier performance report that may be generated by the system of FIG. 1 .
- FIG. 5 is a process diagram illustrating steps for creating a supplier performance report from Summarized Purchase Order Data.
- FIG. 6 is a sample reject performance report that may be generated by the system of FIG. 1 .
- FIG. 7 is a flow diagram illustrating the use of transaction data to predict whether an order reject is supplier caused or customer caused.
- FIG. 1 shows a system 10 that may be used to implement the present invention.
- System 10 comprises one or more computers.
- System 10 includes at least one processing element and at least one memory storage element.
- the one or more computers of system 10 will have access to executable instruction code in an electronically readable medium (code and medium not separately shown).
- the electronically readable medium may be any medium that either stores or carries electronic signals (including signals referred to as electrical signals and signals referred to as electromagnetic signals).
- the executable instruction code in an electronically readable medium directs the illustrated one or more computers to carry out various tasks described herein.
- the executable code for directing the carrying out of tasks described herein would be typically realized in software. However, it will be appreciated by those skilled in the art, that some computers might utilize code realized in hardware to perform many of the identified tasks without departing from the present invention.
- System 10 is communicatively connected (either periodically or continuously) to computer systems at various subscribers including buyers and/or suppliers including systems 11 a, 11 b, and 11 c.
- System 10 is also be communicatively connected to web portal 12 .
- Web portal 12 is a computer or group of computers that makes information from system 10 available over the Internet to one or more subscribers.
- FIG. 1 illustrates a system that makes supplier performance information available to subscribers over the Internet, supplier performance reports may be generated by system 10 and provided to subscribers through other delivery mechanisms, such as, for example, by fax.
- Blocks 10 - 1 to 10 - 7 and associated arrows indicate the processing and data flow of system 10 .
- data is received relevant to either basic purchase order data or summarized purchase order data (see FIGS. 2 a, 2 b, and 3 and accompanying text) from systems 11 a, 11 b, and 11 c.
- This basic or summarized data may be received through a periodic batch update process or through a persistent connection that provides real time updating of system 10 's stored data.
- Summarized purchase order data is derived from basic purchase order data using process 30 as illustrated and described in FIG. 3 and accompanying text. That process may be performed either on subscriber system 11 a, 11 b, and 11 c or at system 10 .
- system 10 will receive summarized purchase order data, if process 30 is performed at block 10 - 1 of system 10 , then system 10 will receive basic purchase order data. Received data, whether summarized or basic, is converted at block 10 - 1 for storing in the common data base stored at block 10 - 3 . Aside from converting any basic data received to summarized data, system 10 also transforms data using known techniques to ensure data integrity. Those skilled in the art will recognize that, for example, values relevant to primary keys (i.e.
- a subscriber may transmit requests to system 10 through web-portal 12 .
- Requests are received at block 10 - 7 .
- a response to the user request is generated. This generation of a response involves requesting and retrieving information from data storage block 10 - 3 as indicated by the arrows between blocks 10 - 5 and 10 - 3 , and involves performing the processing necessary to generate a suitable data view for display.
- the response is returned to the used through web-portal 12 .
- FIG. 2 a shows Basic Purchase Order Data (“Basic Data”) 20 , exemplary of basic purchase order data that may exist on the system of the system of a buyer “GoodCo, Inc.”
- Basic Data 20 includes records 20 R- 1 to 20 R- 5 (values 1-5 in the field labeled “Record No.) and fields 20 F- 1 to 20 F- 1 5 (note 20 F- 1 is labeled “Supplier Name”, 20 F- 15 is labeled “Buyer Name”, and the intervening fields are labeled as indicated, e.g., “Start Point” field 20 F- 2 , “End Point” field 20 F- 3 , etc.).
- FIG. 2 b shows Summarized Purchase Order Data (“Summary Data”) 25 derived from Basic Data 20 .
- Summary Data 25 includes records 25 R- 1 , 25 R- 2 , and 25 -R 3 (values 1-3 in the field labeled “Record.
- FIGS. 2 a and 2 b show respective Basic and Summarized data in a single table, i.e. in a flat file format.
- data may be stored in other formats such as, for example, a relational data base.
- Basic Data 20 may be stored in multiple tables as may Summarized Data 25 .
- alternative embodiments may store summarized data for each supplier in a separate table.
- variations on the choice of fields will be apparent to those skilled in the art. To cite but one example, the Start Point field may be combined with the End Point field into a single start point/end point pair field without any loss in relevant information.
- FIG. 3 shows an exemplary process that may be used to derive the Summary Data 25 from the Basic Data 20 of FIG. 2 .
- Process 30 has steps 3 - 1 through 3 - 8 .
- step 3 - 1 a Summarized Data table is created with the indicated fields.
- step 3 - 2 subsets of data are identified in Basic Data, each record in a subset having the same supplier name, buyer name, start point, and end point.
- Each subset of Basic Data 20 records identified in step 3 - 2 corresponds to a single record in Summary Data 25 as indicated in step 3 - 4 .
- step 3 - 4 for each Summary Data record created, the Supplier Name, Start Point, End Point, and Buyer name fields are populated with the data from the corresponding subset identified in step 3 - 2 .
- record 25 R- 1 (record number “1”) in Summary Data 25 corresponds to the subset of records 20 R- 1 , 20 R- 2 , and 20 R- 3 (record numbers “1”, “2”, and “3”) in Basic Data 20 since those Basic Data records have the same Supplier Name, Start Point, End Point, and Buyer Name, i.e. “Jane Doe Co.”, “OC”, “CFD”, and “GoodCo, Inc.”. Therefore, the Supplier Name, Start Point, End Point, and Buyer Name fields of Summary Data 25 's record 25 R- 1 are populated with the respective values: “Jane Doe Co.”, “OC”, “CFD”, and “GoodCo, Inc.”
- step 3 - 3 sub-subsets of Basic Data 20 records are identified from the subsets identified in step 3 - 2 .
- subsets are identified within each subset identified in step 3 - 2 .
- the sub-subsets of step 3 - 3 each share the same purchase order number.
- Basic Data 20 can have multiple records for a single purchase order (e.g. records 1 and 2 in Basic Data 20 ).
- step 3 - 5 the “# of POs” field in Summary Data 25 is populated by, for each subset identified in step 3 - 2 , adding up the number sub-subsets identified in step 3 - 3 , and putting the total in the record of Summary Data 25 that corresponds to the step 3 - 2 subset of Basic Data 20 whose step 3 - 3 sub-subsets were totaled.
- Records 20 R- 1 , 20 R- 2 , and 20 R- 3 of Basic Data 20 is a subset identified in step 3 - 2 and thus corresponds to a record in Summary Data 25 (record 25 R- 1 ).
- That subset in turn has two subsets (or “sub-subsets”): ( 20 R 1 , 20 R 2 corresponding to one purchase order number) and ( 20 R- 3 corresponding to another purchase order number). Therefore, the # of POs in record 25 R- 1 is 2.
- this step could also be phrased in terms of identifying the number of unique purchase order numbers in each subset of records identified in step 3 - 2 .
- step 3 - 6 the “# of line items” field in Summary Data 25 is populated by adding up the number of line unique line items in each corresponding subset identified in step 3 - 2 .
- the results of step 3 - 6 in this instance will simply be the number of records in each subset identified in step 3 - 2 (note the number “2” in the “Line Item Number” field of record 20 R- 2 of Basic Data 20 is an identification number, not a number of line items in that record; each record in Basic Data 20 contains a single line item).
- step 3 - 7 the “Orders On Time” field in Summary Data 25 is populated by adding up the total number of sub-subsets identified in step 3 - 3 for which every record in the sub-subset has a “Received Date” value that is earlier that its “Due Date” value. In other words, an order is defined as on time if every line item in the order was delivered on time.
- step 3 - 8 the “Line Items On Time” field in Summary Data 25 is populated by, for each corresponding step 3 - 2 subset, summing together all the records in which the. “Received Date” is equal to or earlier than the “Due Date.”
- process 30 represents just one example of a series of steps that might be used to convert Basic Data 20 to Summary Data 25 .
- first executable code used to carry out a first step in process 30 might be the same code as second executable code used to carry out a second step in process 30 .
- a single piece of executable code might direct a computer to, for each record in Summary Data 25 , store in the “# of POs” field 25 F- 5 , the value obtained by counting the records in Basic Data 20 that have the same the same supplier name, start point, end point, and buyer name as the corresponding Summary Data 25 record and that also have identical purchase order numbers.
- Such a piece of code would be performing step 3 - 5 of process 30 , but would also implicitly be performing step 3 - 3 and 3 - 2 .
- Such a piece of code could be said to be first code for performing step 3 - 2 , second code for performing step 3 - 3 , and third code for performing step 3 - 5 .
- executable code may be organized in a variety of ways without departing from the spirit and scope of the present invention.
- process 30 works to convert Basic Data 20 into Summary Data 25
- customer/buyers and suppliers might have basic purchase order data that is organized differently from the example of Basic Data 20 .
- executable code may, without undue experimentation, be written that will implement processes different that process 30 in order to convert basic data that is organized differently than Basic Data 20 into summary data similar to Summary Data 25 .
- process 30 might be modified to operate only on records whose status is “Closed.” As one other example, process 30 might be modified to leave blank place holders in Summary Data 25 for records that cannot currently be completed (e.g., if all of the records in a subset identified in step 3 - 2 are “open”, a place holder such as “—” might be inserted into Summary Data 25 fields that cannot be properly completed for the corresponding record in Summary Data 25 , and then those records may be ignored or at least partially ignored when creating reports from Summary Data 25 ). In this manner, basic purchase order data such as Basic Data 25 may be processed without having to first remove records for unclosed orders.
- Basic Data 25 may be processed without having to first remove records for unclosed orders.
- FIG. 4 shows sample on-time performance report 40 that may be generated by the system of FIG. 1 .
- Report 40 includes tables 40 a and 40 b and reports on-time performance for a domestic supplier SI during a reporting period.
- Display table 40 a reports supplier S 1 's on time performance across all customer buyers providing data to for the system.
- Table 40 a displays data for on time performance with respect to a plurality of start point/end point pairs.
- Table 40 a includes records 40 a R- 1 , 40 a R- 2 , 40 a R- 3 , and 40 a R- 4 , corresponding, respectively, to the following start point/end point pairs in field 40 a F- 1 : OS-CFD (“order sent”—“customer final destination”), OC-SSD (“order confirmed”—“supplier shipping dock”), OC-DTO (“order confirmed”—“destination transport onboard”), OC-CFD (“order confirmed”—“customer final destination”).
- table 40 a also includes field 40 a F- 2 (“No. of orders”), field 40 a F- 3 (“% on time”), field 40 a F- 4 (“No. of line items”), and field 40 a F- 5 (“% on time”).
- Display table 40 b reports on time performance for orders placed with supplier S 1 by customer/buyer C 1 .
- Table 40 b displays data for on time performance with respect to a plurality of start point/end point pairs.
- Table 40 b includes records 40 b R- 1 , 40 b R- 2 , 40 b R- 3 , and 40 b R- 4 , corresponding to, respectively, the following indicated start point/end point pairs in field 40 b F- 1 .
- table 40 b also includes field 40 b F- 2 (“No. of orders”), field 40 b F- 3 (“% on time”), field 40 b F- 4 (“No. of line items”), and field 40 b F- 5 (“% on time”).
- FIG. 5 shows an exemplary process 50 that may be used to derive displayed Supplier Report 52 from Summarized Purchase Order Data (“Summary Data”) 51 .
- Supplier Report 52 is analogous to display table 40 a in FIG. 4 , in that Supplier Report 52 is indicative of on time performance for a supplier S 1 based on data from all supplier S 1 customers providing data to the system.
- Summary Data 51 is analogous to Summary Data 25 of FIG. 2b .
- Process 50 has steps 5 - 1 through 5 - 8 .
- step 5 - 1 an empty Supplier Report table 52 is created with the indicated fields.
- step 5 - 2 subsets of data are identified in Summary Data 51 , each record in a subset having the same supplier name, start point, and end point.
- Each subset of Summary Data 51 records identified in step 5 - 2 corresponds to a single record in Supplier Report 52 as indicated in step 5 - 3 .
- step 54 for each Supplier Report 52 record created in step 5 - 3 , the “Start point/End point” field of Supplier Report 52 is populated with the start points and end points from the corresponding subset of Summary Data 51 records identified in step 5 - 2 (note, steps 5 - 3 and 5 - 4 are roughly analogous to the single step 3 - 2 illustrated and described in FIG. 3 and accompanying text).
- steps 5 - 3 and 5 - 4 are roughly analogous to the single step 3 - 2 illustrated and described in FIG. 3 and accompanying text).
- step 5 - 6 the “% orders on time” field of Supplier Report 52 is populated for each Supplier Report 52 record with percentages obtained by summing the orders on time values of Summary Data 51 records in the corresponding subsets identified in step 5 - 2 , multiplying each by 100 , and dividing each by the corresponding total obtained in step 5 - 5 .
- step 5 - 7 the “# of line items” field in Supplier Report 52 is populated by summing the number of line items value in each record of the corresponding subset identified in step 5 - 2 .
- step 5 - 8 the “% line items on time” field of Supplier Report 52 is populated for each Supplier Report 52 record with percentages obtained by summing the line items on-time values of Summary Data 51 records in the corresponding subsets identified in step 5 - 2 , multiplying each by 100, and dividing each by the corresponding totals obtained in step 5 - 7 .
- the number of line items or orders delivered on time may readily be reported as a percentage number, an absolute number, or both. Use of a percentage in a display report is desirable for facilitating subscribers to quickly compare on-time performance across several suppliers.
- process 50 represents just one example of a series of steps that might be used to convert Summary Data 51 into Supplier Report 52 .
- first executable code used to carry out a first step in process 50 might be the same code as second executable code used to carry out a second step in process 50 .
- process 50 shows steps for creating display data from summary data with respect to a particular supplier across all customer orders (i.e. display data analogous to table 40 a of FIG. 4 ), it does not show steps for creating display data from summary data with respect to a particular supplier across the orders of only one customer (i.e., display data analogous to table 40 b of FIG. 4 ).
- the reason is that the display data for orders with respect to a single customer is already contained in a summary data table such as Summary Data 25 of FIG. 2 .
- To create a display table such as table 40 b from summary data such as Summary Data 25 it will be understood that one need only pull up those records sharing the same supplier name and buyer name, and display the on time results for each start point/end point pair. The only calculation needed is that of converting an number or orders or line items on time into a percentage. Therefore, such a process is not separately illustrated.
- FIGS. 2-5 show conversion of basic data into summary data which is stored and used to generate supplier reports
- basic purchase order data such as Basic Data 20 might be received and modified only by adding new record numbers to enforce uniqueness for adding to a common data base. Then a process would be written to derive reports such as report 40 directly from basic data such as Basic Data 20 .
- FIG. 6 shows a sample reject report 60 that may be generated by the system of FIG. 1 using the decision flow illustrated in FIG. 7 and accompanying text.
- Report 60 includes table 61 and reports reject performance for a domestic supplier S 3 during a reporting period.
- Column 61 - c 1 shows reject performance information for items in orders placed with supplier S 3 by customer C 2 .
- Column 61 - c 2 shows reject performance items in orders placed by all customers to supplier S 3 .
- Row 61 - r 1 shows total lots in orders placed (at the intersection of row 61 - r 1 and column 61 - c 1 , this reflects total lots in orders placed by customer C 2 to supplier S 3 , and at the intersection for row 61 - r 2 and column 61 - c 2 this reflects total lots in orders placed by customer C 2 ).
- Row 61 - r 2 shows the percentage of lots in row 61 - r 1 that are rejected due to the supplier.
- Row 61 - r 3 shows the percentage of lots in row 61 - r 1 that are rejected to the to customer.
- FIG. 7 is a flow diagram illustrating predictive data elements and the predictions made by the system of FIG. 1 about the cause of rejects based on those predictive data elements in a system implementing an aspect of the present invention.
- the decision flow illustrated in FIG. 7 may be used to obtain a reject report such as reject report 60 of FIG. 6 .
- Customers and suppliers generally gather data that can be used in making a prediction about whether a reject was supplier caused or customer caused.
- Blocks 71 a and 72 - 76 in FIG. 7 reflect predictive data elements that can be used by a supplier performance reporting system to make a prediction and report a reject as either supplier caused or customer caused.
- the result of block 71 is “no.” If the item was not returned, but payment was less than the invoice, the system indicates that the order has, in a sense, been “rejected” in that the customer refused to pay the full amount. In such a case, the result of block 71 a is “yes” and, as reflected by the arrow from block 71 a to block 78 , the system predicts and reports this rejection as supplier caused. If the payment was not less than the invoice and the item was not returned, than the result of block 71 a is “no” and the system reports the order as not rejected as indicated by the arrow from block 71 a to block 71 b.
- the result of block 71 is “yes” as reflected by the arrow from block 71 to block 72 . If the order was cancelled, the result of block 72 is “yes” and the reject is predicted and reported to be customer caused as indicated by the yes arrow from block 72 to block 77 . If the answer is no, then, as illustrated by the arrow from block 72 to block 73 , the system next considers whether or not the same item that was ordered was reshipped after the return. If the item was reshipped, then the result of block 73 is “yes” and the reject is predicted and reported to be supplier caused as indicated by the arrow from block 73 to block 78 .
- the system next considers whether or not the delivery was late. If the delivery was late, the result of block 74 is “yes” and, as indicated by the arrow from block 74 to block 78 , the reject is predicted and reported to be supplier caused. If the result of block 74 is “no”, then, as illustrated by the arrow from block 74 to block 75 , the system next considers whether or not there was a purchase order (“PO”)/invoice mismatch. If there was a PO/Invoice mismatch, then the result of block 75 is “yes” and, as indicated by the arrow from block 75 to block 78 , the reject is predicted and reported as supplier caused.
- PO purchase order
- the system next considers whether or not an item shipped was defective. If an item shipped was defective, then the result of block 76 is “yes” and, as indicated by the arrow from block 76 to block 78 , and the return is predicted and reported as supplier caused. If, however, the item shipped was not defective, then the result of block 76 is “no” and, as indicated by the arrow from block 76 to block 77 , the return is predicted and reported as customer caused.
- blocks 72 - 76 may be varied. Note that if, for example, block 76 were not the last block, its “No” arrow would simply point to the next block rather than to block 77 . If information is not available from either the supplier or customer to make a determination for one or more of the blocks 72 - 76 , a “No” answer is delivered for those blocks with insufficient information and the remaining blocks are used to make a reject determination.
- Executable code may instruct one or more computers to perform the processing steps illustrated in FIG. 7 .
- executable code may be found that do not depart from the spirit and the scope of the present invention, but that, nevertheless, use predictive data elements to create reports analogous to the report illustrated in FIG. 6 , thereby allowing subscribers to evaluate reject performance in light of whether the rejects were supplier caused or customer caused.
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Game Theory and Decision Science (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Educational Administration (AREA)
- Theoretical Computer Science (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
A system and method is provided for improved reporting of supplier performance. A system receives and processes data to enable reporting of on-time performance relative to a plurality of order start points and a plurality of order end points. Buyers and suppliers report on-time performance for system processing using the delivery start points and end points collected in the normal course of their business operations. System users may obtain supplier on-time performance reports indicating the on-time performance of suppliers relative to the plurality of start point/end point pairs reflected in the collected data. A system and method is also provided for improved reporting of reject performance. A system stores collected information predictive of whether an order reject was supplier caused or buyer caused. The predicted cause of order rejects is reflected in supplier reject performance as reported to system users.
Description
- This invention relates to a system and method for reporting supplier on-time performance and a system and method for reporting supplier reject performance.
- Supplier on-time performance is typically reported as a percentage of orders that are delivered within a specified period of time with respect to a standardized start point and end point. In order to measure the amount of time that a supplier takes to deliver product in response to an order, a “start point,” i.e. an event triggering the start of a time period used to measure delivery time, must be identified. An “end point,” i.e., an event triggering the end of the time period used to measure delivery time, must also be identified. Typically, the possible start points used for measuring delivery time include: the time at which the buyer placed the order (“order sent” or “OS”), the time at which the supplier received the order (“order received” or “OR”), and the time at which the supplier confirmed the order with the buyer (“order confirmed” or “OC”). Possible end points that might be used for measuring delivery time are, for example, the arrival time of the supplier shipment at one of the following: the customer's receiving dock (“CRD”) (note, the terms “customer” and “buyer” are used interchangeably herein); the customer's final destination (“CFD”, e.g. customer storeroom, customer assembly line, customer mail stop); the origin transport on board (“OTO”, i.e., loaded onto the shipping vehicle at the origin); destination transport onboard (“DTO”, i.e. when the shipping vehicle arrives at its destination country); destination customs inbound (“DCI”, i.e. arrival at customs in the destination country prior to customs processing); destination customs outbound (“DCO”, i.e., point at which customs processing in the destination country is completed); or the supplier shipping dock (“SSD”).
- Existing supplier performance reporting systems generally pick a single start point and a single end point to use as the standardized start and end points for determining the time period against which to measure whether or not a delivery is “on time.” Such systems require users to report on time performance using a standardized start and end point. This approach has at least two disadvantages. First, the customers that are providing on-time delivery data for use by such systems may not ordinarily track delivery times using the standardized start point and end point required by the system. Thus, customers may have to adjust existing internal procedures in order to report delivery time data that is useable by such systems. A second disadvantage of such systems is that customers whose businesses place an importance on delivery times using start and end points different from those used by the reporting system will not be able to gauge the performance of suppliers in a manner that is consistent with the particular business needs of such customers.
- Existing supplier performance reporting systems also typically report the percentage of orders that are returned. However, existing systems simply report “reject performance” as a percentage of total orders that are returned without distinguishing between whether the return was supplier caused or customer caused. In some contexts, it may be useful for users of a supplier performance reporting system to know how many returns were caused by the supplier and how many were caused the customer.
- The present invention addresses some of the problems of prior supplier performance reporting systems. An aspect of a present embodiment receives and processes data to enable reporting of on-time performance relative to a plurality of order start point/end point pairs. Customers and suppliers report on-time performance for system processing using the delivery start and end points collected in the normal course of their business operations. System users may obtain supplier on-time performance reports indicating the on-time performance of suppliers relative to the plurality of start point/end point pairs reflected in the collected data.
- Another aspect of a present embodiment collects transaction information predictive of whether an order reject was supplier caused or customer caused. The predicted cause of order rejects is reflected in supplier reject performance as reported by a system implementing this aspect of the present invention.
- The novel features of the invention are set forth in the appended claims. However, for purpose of explanation, several aspects of an embodiment of the invention are described by reference to the following figures.
-
FIG. 1 is a system level view of the basic components and data flow in a system that may be used to implement an embodiment of the present invention. -
FIG. 2 a is a table illustrative of Basic Purchase Order Data provided by a customer/buyer computer system. -
FIG. 2 b is a table illustrative of Summarized Purchase Order Data stored insystem 10 ofFIG. 1 . -
FIG. 3 is a process diagram illustrating steps for converting the Basic Purchase Order Data ofFIG. 2 a into the Summarized Purchase Order Data ofFIG. 2 b. -
FIG. 4 is a sample supplier performance report that may be generated by the system ofFIG. 1 . -
FIG. 5 is a process diagram illustrating steps for creating a supplier performance report from Summarized Purchase Order Data. -
FIG. 6 is a sample reject performance report that may be generated by the system ofFIG. 1 . -
FIG. 7 is a flow diagram illustrating the use of transaction data to predict whether an order reject is supplier caused or customer caused. - In the following description, numerous details are set forth for purpose of explanation. However, one of ordinary skill in the art would realize that the invention may be practiced without the use of these specific details. In other instances, well-known structures and devices are shown in block diagram form in order not to obscure the description of the invention with unnecessary detail.
-
FIG. 1 shows asystem 10 that may be used to implement the present invention.System 10 comprises one or more computers.System 10 includes at least one processing element and at least one memory storage element. The one or more computers ofsystem 10 will have access to executable instruction code in an electronically readable medium (code and medium not separately shown). The electronically readable medium may be any medium that either stores or carries electronic signals (including signals referred to as electrical signals and signals referred to as electromagnetic signals). The executable instruction code in an electronically readable medium directs the illustrated one or more computers to carry out various tasks described herein. The executable code for directing the carrying out of tasks described herein would be typically realized in software. However, it will be appreciated by those skilled in the art, that some computers might utilize code realized in hardware to perform many of the identified tasks without departing from the present invention. -
System 10 is communicatively connected (either periodically or continuously) to computer systems at various subscribers including buyers and/orsuppliers including systems System 10 is also be communicatively connected toweb portal 12.Web portal 12 is a computer or group of computers that makes information fromsystem 10 available over the Internet to one or more subscribers. AlthoughFIG. 1 illustrates a system that makes supplier performance information available to subscribers over the Internet, supplier performance reports may be generated bysystem 10 and provided to subscribers through other delivery mechanisms, such as, for example, by fax. - Blocks 10-1 to 10-7 and associated arrows indicate the processing and data flow of
system 10. At block 10-1, data is received relevant to either basic purchase order data or summarized purchase order data (seeFIGS. 2 a, 2 b, and 3 and accompanying text) fromsystems system 10's stored data. Summarized purchase order data is derived from basic purchase orderdata using process 30 as illustrated and described inFIG. 3 and accompanying text. That process may be performed either onsubscriber system system 10. Ifprocess 30 is performed on a subscriber system,system 10 will receive summarized purchase order data, ifprocess 30 is performed at block 10-1 ofsystem 10, thensystem 10 will receive basic purchase order data. Received data, whether summarized or basic, is converted at block 10-1 for storing in the common data base stored at block 10-3. Aside from converting any basic data received to summarized data,system 10 also transforms data using known techniques to ensure data integrity. Those skilled in the art will recognize that, for example, values relevant to primary keys (i.e. fields whose data uniquely identifies each row) may need to be added to the received data to ensure that new data added to stored data is uniquely identified in the data base (e.g., if incoming summarized data has a field for “record number” and record number values in received data repeat pre-existing values in a record number field of a stored table, and if “record number” is a primary key whose values are used to uniquely identify a row, the system will replace received record number values with unique values for adding the data to the pre-existing stored database). These and other well known techniques may be performed bysystem 10, but are not necessarily described in detail herein so as not to obscure the description of the embodiments with unnecessary detail. - A subscriber may transmit requests to
system 10 through web-portal 12. Requests are received at block 10-7. At block 10-5, a response to the user request is generated. This generation of a response involves requesting and retrieving information from data storage block 10-3 as indicated by the arrows between blocks 10-5 and 10-3, and involves performing the processing necessary to generate a suitable data view for display. At block 10-6, the response is returned to the used through web-portal 12. -
FIG. 2 a shows Basic Purchase Order Data (“Basic Data”) 20, exemplary of basic purchase order data that may exist on the system of the system of a buyer “GoodCo, Inc.”Basic Data 20 includesrecords 20R-1 to 20R-5 (values 1-5 in the field labeled “Record No.) and fields 20F-1 to 20F-1 5 (note 20F-1 is labeled “Supplier Name”, 20F-15 is labeled “Buyer Name”, and the intervening fields are labeled as indicated, e.g., “Start Point”field 20F-2, “End Point”field 20F-3, etc.). -
FIG. 2 b shows Summarized Purchase Order Data (“Summary Data”) 25 derived fromBasic Data 20.Summary Data 25 includesrecords 25R-1, 25R-2, and 25-R3 (values 1-3 in the field labeled “Record. No.”) and the following fields: “Record No.”field 25F-1, “Supplier Name”field 25F-2, “Start Point”field 25F-3, “End Point”field 25F-4, “# of POs” (purchase orders)Field 25F-5, “# of Line Items”field 25F-6, “Orders On-Time”field 25F-7, “Line Items On-Time” field 25f-8, and “Buyer Name”field 25F-9. -
FIGS. 2 a and 2 b show respective Basic and Summarized data in a single table, i.e. in a flat file format. It will be appreciated by those skilled in the art, that data may be stored in other formats such as, for example, a relational data base. Thus,Basic Data 20 may be stored in multiple tables as may SummarizedData 25. For example, alternative embodiments may store summarized data for each supplier in a separate table. Also, variations on the choice of fields will be apparent to those skilled in the art. To cite but one example, the Start Point field may be combined with the End Point field into a single start point/end point pair field without any loss in relevant information. These and other variations will be apparent to those skilled in the art and it will be understood that such variations do not depart from the spirit and scope of the present invention. -
FIG. 3 shows an exemplary process that may be used to derive theSummary Data 25 from theBasic Data 20 ofFIG. 2 .Process 30 has steps 3-1 through 3-8. In step 3-1, a Summarized Data table is created with the indicated fields. In step 3-2, subsets of data are identified in Basic Data, each record in a subset having the same supplier name, buyer name, start point, and end point. Each subset ofBasic Data 20 records identified in step 3-2 corresponds to a single record inSummary Data 25 as indicated in step 3-4. Also in step 3-4, for each Summary Data record created, the Supplier Name, Start Point, End Point, and Buyer name fields are populated with the data from the corresponding subset identified in step 3-2. For example,record 25R-1 (record number “1”) inSummary Data 25 corresponds to the subset ofrecords 20R-1, 20R-2, and 20R-3 (record numbers “1”, “2”, and “3”) inBasic Data 20 since those Basic Data records have the same Supplier Name, Start Point, End Point, and Buyer Name, i.e. “Jane Doe Co.”, “OC”, “CFD”, and “GoodCo, Inc.”. Therefore, the Supplier Name, Start Point, End Point, and Buyer Name fields ofSummary Data 25'srecord 25R-1 are populated with the respective values: “Jane Doe Co.”, “OC”, “CFD”, and “GoodCo, Inc.” - In step 3-3, sub-subsets of
Basic Data 20 records are identified from the subsets identified in step 3-2. In other words, in step 3-3 subsets are identified within each subset identified in step 3-2. The sub-subsets of step 3-3 each share the same purchase order number. Note thatBasic Data 20 can have multiple records for a single purchase order (e.g. records - In step 3-5, the “# of POs” field in
Summary Data 25 is populated by, for each subset identified in step 3-2, adding up the number sub-subsets identified in step 3-3, and putting the total in the record ofSummary Data 25 that corresponds to the step 3-2 subset ofBasic Data 20 whose step 3-3 sub-subsets were totaled. For example,Records 20R-1, 20R-2, and 20R-3 ofBasic Data 20 is a subset identified in step 3-2 and thus corresponds to a record in Summary Data 25 (record 25R-1). That subset in turn has two subsets (or “sub-subsets”): (20R1, 20R2 corresponding to one purchase order number) and (20R-3 corresponding to another purchase order number). Therefore, the # of POs inrecord 25R-1 is 2. Of course, this step could also be phrased in terms of identifying the number of unique purchase order numbers in each subset of records identified in step 3-2. - In step 3-6, the “# of line items” field in
Summary Data 25 is populated by adding up the number of line unique line items in each corresponding subset identified in step 3-2. Note that sinceBasic Data 20 has one record for each line item number, the results of step 3-6 in this instance will simply be the number of records in each subset identified in step 3-2 (note the number “2” in the “Line Item Number” field ofrecord 20R-2 ofBasic Data 20 is an identification number, not a number of line items in that record; each record inBasic Data 20 contains a single line item). In step 3-7, the “Orders On Time” field inSummary Data 25 is populated by adding up the total number of sub-subsets identified in step 3-3 for which every record in the sub-subset has a “Received Date” value that is earlier that its “Due Date” value. In other words, an order is defined as on time if every line item in the order was delivered on time. In step 3-8, the “Line Items On Time” field inSummary Data 25 is populated by, for each corresponding step 3-2 subset, summing together all the records in which the. “Received Date” is equal to or earlier than the “Due Date.” - Those skilled in the art will recognize that
process 30 represents just one example of a series of steps that might be used to convertBasic Data 20 toSummary Data 25. Also, those skilled in the art will recognized that first executable code used to carry out a first step inprocess 30 might be the same code as second executable code used to carry out a second step inprocess 30. For example, a single piece of executable code might direct a computer to, for each record inSummary Data 25, store in the “# of POs”field 25F-5, the value obtained by counting the records inBasic Data 20 that have the same the same supplier name, start point, end point, and buyer name as the correspondingSummary Data 25 record and that also have identical purchase order numbers. Such a piece of code would be performing step 3-5 ofprocess 30, but would also implicitly be performing step 3-3 and 3-2. Thus, such a piece of code could be said to be first code for performing step 3-2, second code for performing step 3-3, and third code for performing step 3-5. Those skilled in the art will recognize therefore that executable code may be organized in a variety of ways without departing from the spirit and scope of the present invention. - Furthermore, while
process 30 works to convertBasic Data 20 intoSummary Data 25, customer/buyers and suppliers might have basic purchase order data that is organized differently from the example ofBasic Data 20. In such instances, those skilled in the art will recognize that executable code may, without undue experimentation, be written that will implement processes different thatprocess 30 in order to convert basic data that is organized differently thanBasic Data 20 into summary data similar toSummary Data 25. - It may also be noted that because the “Order Status” values in
field 20F-10 ofBasic Data 20 are “Closed” for each record, other data (e.g. received date) is available for each record. However,process 30 can be easily modified to handle the addition of data that includes some records that are incomplete because the “Order Status” value is “Open”. As one example,process 30 might be modified to operate only on records whose status is “Closed.” As one other example,process 30 might be modified to leave blank place holders inSummary Data 25 for records that cannot currently be completed (e.g., if all of the records in a subset identified in step 3-2 are “open”, a place holder such as “—” might be inserted intoSummary Data 25 fields that cannot be properly completed for the corresponding record inSummary Data 25, and then those records may be ignored or at least partially ignored when creating reports from Summary Data 25). In this manner, basic purchase order data such asBasic Data 25 may be processed without having to first remove records for unclosed orders. -
FIG. 4 shows sample on-time performance report 40 that may be generated by the system ofFIG. 1 .Report 40 includes tables 40 a and 40 b and reports on-time performance for a domestic supplier SI during a reporting period. Display table 40 a reports supplier S1's on time performance across all customer buyers providing data to for the system. Table 40 a displays data for on time performance with respect to a plurality of start point/end point pairs. Table 40 a includesrecords 40 aR-1, 40 aR-2, 40 aR-3, and 40 aR-4, corresponding, respectively, to the following start point/end point pairs infield 40 aF-1: OS-CFD (“order sent”—“customer final destination”), OC-SSD (“order confirmed”—“supplier shipping dock”), OC-DTO (“order confirmed”—“destination transport onboard”), OC-CFD (“order confirmed”—“customer final destination”). In addition to start point/end point field 40 aF-1, table 40 a also includesfield 40 aF-2 (“No. of orders”),field 40 aF-3 (“% on time”),field 40 aF-4 (“No. of line items”), and field 40 aF-5 (“% on time”). - Display table 40 b reports on time performance for orders placed with supplier S1 by customer/buyer C1. Table 40 b displays data for on time performance with respect to a plurality of start point/end point pairs. Table 40 b includes
records 40 bR-1, 40 bR-2, 40 bR-3, and 40 bR-4, corresponding to, respectively, the following indicated start point/end point pairs infield 40 bF-1. In addition to start point/end point field 40 bR-1, table 40 b also includesfield 40 bF-2 (“No. of orders”),field 40 bF-3 (“% on time”),field 40 bF-4 (“No. of line items”), andfield 40 bF-5 (“% on time”). -
FIG. 5 shows anexemplary process 50 that may be used to derive displayedSupplier Report 52 from Summarized Purchase Order Data (“Summary Data”) 51.Supplier Report 52 is analogous to display table 40 a inFIG. 4 , in thatSupplier Report 52 is indicative of on time performance for a supplier S1 based on data from all supplier S1 customers providing data to the system.Summary Data 51 is analogous toSummary Data 25 ofFIG. 2b .Process 50 has steps 5-1 through 5-8. In step 5-1, an empty Supplier Report table 52 is created with the indicated fields. In step 5-2, subsets of data are identified inSummary Data 51, each record in a subset having the same supplier name, start point, and end point. Each subset ofSummary Data 51 records identified in step 5-2 corresponds to a single record inSupplier Report 52 as indicated in step 5-3. In step 54, for eachSupplier Report 52 record created in step 5-3, the “Start point/End point” field ofSupplier Report 52 is populated with the start points and end points from the corresponding subset ofSummary Data 51 records identified in step 5-2 (note, steps 5-3 and 5-4 are roughly analogous to the single step 3-2 illustrated and described inFIG. 3 and accompanying text). In step 5-5 the “No. of POs” field inSupplier Report 52 is populated by adding up the values of the number of orders in each subset ofSummary Data 51 records identified in step 5-2, and putting the respective totals in the corresponding record ofSupplier Report 52. In step 5-6, the “% orders on time” field ofSupplier Report 52 is populated for eachSupplier Report 52 record with percentages obtained by summing the orders on time values ofSummary Data 51 records in the corresponding subsets identified in step 5-2, multiplying each by 100, and dividing each by the corresponding total obtained in step 5-5. In step 5-7, the “# of line items” field inSupplier Report 52 is populated by summing the number of line items value in each record of the corresponding subset identified in step 5-2. In step 5-8, the “% line items on time” field ofSupplier Report 52 is populated for eachSupplier Report 52 record with percentages obtained by summing the line items on-time values ofSummary Data 51 records in the corresponding subsets identified in step 5-2, multiplying each by 100, and dividing each by the corresponding totals obtained in step 5-7. Those skilled in the art will recognize that the number of line items or orders delivered on time may readily be reported as a percentage number, an absolute number, or both. Use of a percentage in a display report is desirable for facilitating subscribers to quickly compare on-time performance across several suppliers. - Those skilled in the art will recognize that
process 50 represents just one example of a series of steps that might be used to convertSummary Data 51 intoSupplier Report 52. Also, those skilled in the art will recognized that first executable code used to carry out a first step inprocess 50, might be the same code as second executable code used to carry out a second step inprocess 50. - Although
process 50 shows steps for creating display data from summary data with respect to a particular supplier across all customer orders (i.e. display data analogous to table 40 a ofFIG. 4 ), it does not show steps for creating display data from summary data with respect to a particular supplier across the orders of only one customer (i.e., display data analogous to table 40 b ofFIG. 4 ). The reason is that the display data for orders with respect to a single customer is already contained in a summary data table such asSummary Data 25 ofFIG. 2 . To create a display table such as table 40 b from summary data such asSummary Data 25, it will be understood that one need only pull up those records sharing the same supplier name and buyer name, and display the on time results for each start point/end point pair. The only calculation needed is that of converting an number or orders or line items on time into a percentage. Therefore, such a process is not separately illustrated. - Although the examples disclosed in
FIGS. 2-5 show conversion of basic data into summary data which is stored and used to generate supplier reports, it will be recognized by those skilled in the art that it is possible to only store data that is in a format that is close to the format ofBasic Data 20 and still generate reports similar to report 40 ofFIG. 4 without the intermediate step of creating and storing summary data such asSummary Data 25. For example, basic purchase order data such asBasic Data 20 might be received and modified only by adding new record numbers to enforce uniqueness for adding to a common data base. Then a process would be written to derive reports such asreport 40 directly from basic data such asBasic Data 20. Although such an approach would not necessarily depart from the scope of the present invention, for operating a system such assystem 10 on a large scale it is preferable for performance reasons to derive reports from a data base of summary data. Less storage space is needed and less processing time is needed to create display data from summary data than would be needed to create display data from basic order data. -
FIG. 6 shows asample reject report 60 that may be generated by the system ofFIG. 1 using the decision flow illustrated inFIG. 7 and accompanying text.Report 60 includes table 61 and reports reject performance for a domestic supplier S3 during a reporting period. Column 61-c 1 shows reject performance information for items in orders placed with supplier S3 by customer C2. Column 61-c 2 shows reject performance items in orders placed by all customers to supplier S3. Row 61-r 1 shows total lots in orders placed (at the intersection of row 61-r 1 and column 61-c 1, this reflects total lots in orders placed by customer C2 to supplier S3, and at the intersection for row 61-r 2 and column 61-c 2 this reflects total lots in orders placed by customer C2). Row 61-r 2 shows the percentage of lots in row 61-r 1 that are rejected due to the supplier. Row 61-r 3 shows the percentage of lots in row 61-r 1 that are rejected to the to customer. -
FIG. 7 is a flow diagram illustrating predictive data elements and the predictions made by the system ofFIG. 1 about the cause of rejects based on those predictive data elements in a system implementing an aspect of the present invention. The decision flow illustrated inFIG. 7 may be used to obtain a reject report such asreject report 60 ofFIG. 6 . Customers and suppliers generally gather data that can be used in making a prediction about whether a reject was supplier caused or customer caused.Blocks 71 a and 72-76 inFIG. 7 reflect predictive data elements that can be used by a supplier performance reporting system to make a prediction and report a reject as either supplier caused or customer caused. - Beginning at the top of the flow diagram, if the item was not returned, the result of
block 71 is “no.” If the item was not returned, but payment was less than the invoice, the system indicates that the order has, in a sense, been “rejected” in that the customer refused to pay the full amount. In such a case, the result ofblock 71 a is “yes” and, as reflected by the arrow fromblock 71 a to block 78, the system predicts and reports this rejection as supplier caused. If the payment was not less than the invoice and the item was not returned, than the result ofblock 71 a is “no” and the system reports the order as not rejected as indicated by the arrow fromblock 71 a to block 71 b. - If the order was returned, then the result of
block 71 is “yes” as reflected by the arrow fromblock 71 to block 72. If the order was cancelled, the result ofblock 72 is “yes” and the reject is predicted and reported to be customer caused as indicated by the yes arrow fromblock 72 to block 77. If the answer is no, then, as illustrated by the arrow fromblock 72 to block 73, the system next considers whether or not the same item that was ordered was reshipped after the return. If the item was reshipped, then the result ofblock 73 is “yes” and the reject is predicted and reported to be supplier caused as indicated by the arrow fromblock 73 to block 78. If the result ofblock 73 is “no”, then, as illustrated by the arrow fromblock 73 to block 74, the system next considers whether or not the delivery was late. If the delivery was late, the result ofblock 74 is “yes” and, as indicated by the arrow fromblock 74 to block 78, the reject is predicted and reported to be supplier caused. If the result ofblock 74 is “no”, then, as illustrated by the arrow fromblock 74 to block 75, the system next considers whether or not there was a purchase order (“PO”)/invoice mismatch. If there was a PO/Invoice mismatch, then the result ofblock 75 is “yes” and, as indicated by the arrow fromblock 75 to block 78, the reject is predicted and reported as supplier caused. If the result ofblock 75 is “no”, then; as illustrated by the arrow fromblock 75 to block 76, the system next considers whether or not an item shipped was defective. If an item shipped was defective, then the result ofblock 76 is “yes” and, as indicated by the arrow fromblock 76 to block 78, and the return is predicted and reported as supplier caused. If, however, the item shipped was not defective, then the result ofblock 76 is “no” and, as indicated by the arrow fromblock 76 to block 77, the return is predicted and reported as customer caused. - The order of blocks 72-76 may be varied. Note that if, for example, block 76 were not the last block, its “No” arrow would simply point to the next block rather than to block 77. If information is not available from either the supplier or customer to make a determination for one or more of the blocks 72-76, a “No” answer is delivered for those blocks with insufficient information and the remaining blocks are used to make a reject determination.
- Executable code may instruct one or more computers to perform the processing steps illustrated in
FIG. 7 . Those skilled in the art, many variations on executable code may be found that do not depart from the spirit and the scope of the present invention, but that, nevertheless, use predictive data elements to create reports analogous to the report illustrated inFIG. 6 , thereby allowing subscribers to evaluate reject performance in light of whether the rejects were supplier caused or customer caused. - Although particular embodiments have been described in detail, various modifications to the embodiments described herein may be made without departing from the spirit and scope of the present invention, thus, the invention is limited only by the appended claims.
Claims (15)
1. In a system for reporting supplier performance, the system including reporting of order rejections, a method of reporting a reason for order rejections comprising:
collecting from a first customer predictive data elements about at least one of a plurality of orders made by the first customer to a first supplier, the predictive data elements being predictive of whether a rejection of items in the at least one of the plurality of orders was customer caused or supplier caused;
making a prediction based on the predictive data elements about whether the rejection of items in the at least one of the plurality of orders was customer caused or supplier caused; and
reporting the rejection as either supplier caused or customer caused based on the prediction.
2. The method of claim 1 wherein a one of the predictive data elements is whether or not the at least one of the plurality of orders was cancelled and wherein if the at least, one of the plurality of orders was cancelled, then the prediction indicates that the rejection was customer caused.
3. The method of claim 1 wherein a one of the predictive data elements is whether or not an item in the at least one of the plurality of orders was re-shipped and wherein if the item was re-shipped then the prediction indicates that the rejection was supplier caused.
4. The method of claim 1 wherein a one of the predictive data elements is whether or not items in the at least one of the plurality of orders were delivered late and wherein if the items in the at least one of the plurality of orders were delivered late, then the prediction is that the rejection was supplier caused.
5. The method of claim 1 wherein a one of the predictive data elements is whether or not a PO/Invoice mismatch exists with respect to the at least one of the plurality of orders and wherein if a PO/Invoice mismatch exists, then the prediction is that the rejection was supplier caused.
6. The method of claim 1 wherein a one of the predictive data elements is whether or not a payment was less than an invoice amount with respect to the at least one of the plurality of orders and wherein if a payment was less than an invoice amount, then the prediction is that the rejection was supplier caused.
7. The method of claim 1 wherein a one of the predictive data elements is whether or not an item in a one of the plurality of orders was defective, and wherein if the item was defective, then the prediction is that the rejection was supplier caused.
8. A system for reporting supplier performance comprising:
at least one computer;
first executable code for storing data collected from a first customer including predictive data elements about items in at least one of a plurality of orders made by the first customer to a first supplier, the predictive data elements being predictive of whether a rejection of items in the at least one of the plurality of orders was customer caused or supplier caused;
second executable code for making a prediction based on the predictive data elements whether the rejection was customer caused or supplier caused; and
third executable code for assembling a report including indication of the rejection as either supplier caused or customer caused based on the prediction;
wherein the first, second, and third executable code is in an electronically readable medium accessible to the at least one computer.
9. The system of claim 8 wherein a one of the predictive data elements is whether or not the at least one of the plurality of orders was cancelled and wherein if the at least one of the plurality of orders was cancelled, then the prediction indicates that the rejection was customer caused.
10. The system of claim 8 wherein a one of the predictive data elements is whether or not an item in the at least one of the plurality of orders was re-shipped and wherein if the item was re-shipped, then the prediction indicates that the rejection was supplier caused.
11. The system of claim 8 wherein a one of the predictive data elements is whether or not the items in the at least one of the plurality of orders were delivered late and wherein if the items in the at leas tone of the plurality of orders were delivered late, then the prediction is that the rejection was supplier caused.
12. The system of claim 8 wherein a one of the predictive data elements is whether or not a PO/Invoice mismatch exists with respect to the at least one of the plurality of orders and wherein if a PO/Invoice mismatch exists, then the prediction is that the rejection was supplier caused.
13. The system of claim 8 wherein a one of the predictive data elements is whether or not a payment was less than an invoice amount with respect to the at least one of the plurality of orders and wherein if a payment was less than an invoice amount, then the prediction is that the rejection was supplier caused.
14. The system of claim 8 wherein a one of the predictive data elements is whether or not an item in a one of the plurality of orders was defective, and wherein if the item was defective, then the prediction is that the rejection was supplier caused.
15. A system for reporting supplier performance comprising:
means for collecting from a first customer predictive data elements about at least one of a plurality of orders made by the first customer to a first supplier, the predictive data elements being predictive of whether a rejection of items in the at least one of the plurality of orders was customer caused or supplier caused;
means for making a prediction based on the predictive data elements about whether the rejection of items in the at least one of the plurality of orders was customer caused or supplier caused; and
means for reporting the rejection as either supplier caused or customer caused based on the prediction.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US11/322,348 US20060111966A1 (en) | 2002-02-06 | 2006-01-03 | Supplier performance reporting |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/071,802 US7010496B2 (en) | 2002-02-06 | 2002-02-06 | Supplier performance reporting |
US11/322,348 US20060111966A1 (en) | 2002-02-06 | 2006-01-03 | Supplier performance reporting |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/071,802 Division US7010496B2 (en) | 2002-02-06 | 2002-02-06 | Supplier performance reporting |
Publications (1)
Publication Number | Publication Date |
---|---|
US20060111966A1 true US20060111966A1 (en) | 2006-05-25 |
Family
ID=27659327
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/071,802 Expired - Lifetime US7010496B2 (en) | 2002-02-06 | 2002-02-06 | Supplier performance reporting |
US11/322,348 Abandoned US20060111966A1 (en) | 2002-02-06 | 2006-01-03 | Supplier performance reporting |
Family Applications Before (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/071,802 Expired - Lifetime US7010496B2 (en) | 2002-02-06 | 2002-02-06 | Supplier performance reporting |
Country Status (5)
Country | Link |
---|---|
US (2) | US7010496B2 (en) |
EP (1) | EP1485839A4 (en) |
AU (1) | AU2003209347A1 (en) |
CA (1) | CA2478617A1 (en) |
WO (1) | WO2003067370A2 (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080162204A1 (en) * | 2006-12-28 | 2008-07-03 | Kaiser John J | Tracking and management of logistical processes |
US20080255896A1 (en) * | 2007-04-12 | 2008-10-16 | Hong Fu Jin Precision Industry (Shenzhen) Co., Ltd. | System and method for aiding a buyer to create a supplier scorecard |
US20090007231A1 (en) * | 2007-06-29 | 2009-01-01 | Caterpillar Inc. | Secured systems and methods for tracking and management of logistical processes |
US20090006164A1 (en) * | 2007-06-29 | 2009-01-01 | Caterpillar Inc. | System and method for optimizing workforce engagement |
US20130041713A1 (en) * | 2011-08-12 | 2013-02-14 | Bank Of America Corporation | Supplier Risk Dashboard |
US20130041714A1 (en) * | 2011-08-12 | 2013-02-14 | Bank Of America Corporation | Supplier Risk Health Check |
Families Citing this family (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7499871B1 (en) * | 2002-05-20 | 2009-03-03 | Honda Motor Co., Ltd. | System and method for procurement of products |
US9311673B2 (en) | 2002-06-05 | 2016-04-12 | Nasdaq, Inc. | Security transaction matching |
US7685028B2 (en) * | 2003-05-28 | 2010-03-23 | Gross John N | Method of testing inventory management/shipping systems |
US8197317B2 (en) * | 2006-05-17 | 2012-06-12 | Bunge Limited | Methods and contests for estimating events or conditions |
US8197316B2 (en) * | 2006-05-17 | 2012-06-12 | Bunge Limited | Systems and user interactive screens for estimating events or conditions |
US20070294124A1 (en) * | 2006-06-14 | 2007-12-20 | John Charles Crotts | Hospitality performance index |
US20080046303A1 (en) * | 2006-08-21 | 2008-02-21 | Gordon Penelope E | Method and system of determining elements of a value priced contract |
US20080115103A1 (en) * | 2006-11-13 | 2008-05-15 | Microsoft Corporation | Key performance indicators using collaboration lists |
US8239248B2 (en) * | 2007-03-07 | 2012-08-07 | Microsoft Corporation | Techniques to manage information for dynamic reports using time periods for a business model |
US8321263B2 (en) * | 2009-04-17 | 2012-11-27 | Hartford Fire Insurance Company | Processing and display of service provider performance data |
US20140207531A1 (en) * | 2011-03-01 | 2014-07-24 | Steeve Teong Sin KAY | Systems And Methods For Assessing Organizations Using User-Defined Criteria |
US20130211884A1 (en) * | 2011-03-01 | 2013-08-15 | Steeve Teong Sin KAY | Performance evaluation in a project management system |
US20120330719A1 (en) * | 2011-05-27 | 2012-12-27 | Ashutosh Malaviya | Enhanced systems, processes, and user interfaces for scoring assets associated with a population of data |
US20180330390A1 (en) * | 2011-05-27 | 2018-11-15 | Ashutosh Malaviya | Enhanced systems, processes, and user interfaces for targeted marketing associated with a population of assets |
US20150356576A1 (en) * | 2011-05-27 | 2015-12-10 | Ashutosh Malaviya | Computerized systems, processes, and user interfaces for targeted marketing associated with a population of real-estate assets |
US8725555B2 (en) * | 2011-09-19 | 2014-05-13 | Alliance Enterprises, Inc. | Vendor performance management system and method for determining a vendor's contribution value and vendor services score |
US10262365B2 (en) | 2012-04-16 | 2019-04-16 | Nasdaq Technology Ab | Method and a computerized exchange system for processing trade orders |
Citations (18)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4887208A (en) * | 1987-12-18 | 1989-12-12 | Schneider Bruce H | Sales and inventory control system |
US5311438A (en) * | 1992-01-31 | 1994-05-10 | Andersen Consulting | Integrated manufacturing system |
US5592378A (en) * | 1994-08-19 | 1997-01-07 | Andersen Consulting Llp | Computerized order entry system and method |
US5627973A (en) * | 1994-03-14 | 1997-05-06 | Moore Business Forms, Inc. | Method and apparatus for facilitating evaluation of business opportunities for supplying goods and/or services to potential customers |
US5666493A (en) * | 1993-08-24 | 1997-09-09 | Lykes Bros., Inc. | System for managing customer orders and method of implementation |
US5696906A (en) * | 1995-03-09 | 1997-12-09 | Continental Cablevision, Inc. | Telecommunicaion user account management system and method |
US5765138A (en) * | 1995-08-23 | 1998-06-09 | Bell Atlantic Network Services, Inc. | Apparatus and method for providing interactive evaluation of potential vendors |
US5809479A (en) * | 1994-07-21 | 1998-09-15 | Micron Technology, Inc. | On-time delivery, tracking and reporting |
US6115690A (en) * | 1997-12-22 | 2000-09-05 | Wong; Charles | Integrated business-to-business Web commerce and business automation system |
US6317415B1 (en) * | 1998-09-28 | 2001-11-13 | Raytheon Company | Method and system for communicating information in a network |
US20020013744A1 (en) * | 2000-07-10 | 2002-01-31 | Tomoo Tsunenari | System and methods to effect return of a consumer product |
US6499657B1 (en) * | 2000-04-21 | 2002-12-31 | General Electric Company | Method, system and storage medium for analyzing product delivery |
US6510427B1 (en) * | 1999-07-19 | 2003-01-21 | Ameritech Corporation | Customer feedback acquisition and processing system |
US6530518B1 (en) * | 2000-05-19 | 2003-03-11 | General Electric Company | Method, system and storage medium for viewing product delivery information |
US6536659B1 (en) * | 2000-11-15 | 2003-03-25 | Returns Online, Inc. | Facilitating returns of merchandise purchased from other sources |
US6539386B1 (en) * | 2000-06-15 | 2003-03-25 | Cisco Technology, Inc. | Methods and apparatus for modifying a customer order |
US6654726B1 (en) * | 1999-11-05 | 2003-11-25 | Ford Motor Company | Communication schema of online system and method of status inquiry and tracking related to orders for consumer product having specific configurations |
US20030225625A1 (en) * | 2002-05-31 | 2003-12-04 | Michael Chew | Returns management systems and methods therefor |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4867208A (en) * | 1988-02-04 | 1989-09-19 | Fitzgerald Robert M | Apparatus for storing and dispensing fluid under pressure |
-
2002
- 2002-02-06 US US10/071,802 patent/US7010496B2/en not_active Expired - Lifetime
-
2003
- 2003-01-23 CA CA002478617A patent/CA2478617A1/en not_active Abandoned
- 2003-01-23 AU AU2003209347A patent/AU2003209347A1/en not_active Abandoned
- 2003-01-23 WO PCT/US2003/002068 patent/WO2003067370A2/en not_active Application Discontinuation
- 2003-01-23 EP EP03707501A patent/EP1485839A4/en not_active Withdrawn
-
2006
- 2006-01-03 US US11/322,348 patent/US20060111966A1/en not_active Abandoned
Patent Citations (22)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4887208A (en) * | 1987-12-18 | 1989-12-12 | Schneider Bruce H | Sales and inventory control system |
US5311438A (en) * | 1992-01-31 | 1994-05-10 | Andersen Consulting | Integrated manufacturing system |
US5666493A (en) * | 1993-08-24 | 1997-09-09 | Lykes Bros., Inc. | System for managing customer orders and method of implementation |
US5758329A (en) * | 1993-08-24 | 1998-05-26 | Lykes Bros., Inc. | System for managing customer orders and method of implementation |
US5627973A (en) * | 1994-03-14 | 1997-05-06 | Moore Business Forms, Inc. | Method and apparatus for facilitating evaluation of business opportunities for supplying goods and/or services to potential customers |
US6029140A (en) * | 1994-07-21 | 2000-02-22 | Micron Technology, Inc. | On-time delivery, tracking and reporting |
US6292784B1 (en) * | 1994-07-21 | 2001-09-18 | Micron Technology, Inc. | On-time delivery, tracking, and reporting |
US5809479A (en) * | 1994-07-21 | 1998-09-15 | Micron Technology, Inc. | On-time delivery, tracking and reporting |
US5960408A (en) * | 1994-07-21 | 1999-09-28 | Micron Technology, Inc. | On-time delivery, tracking and reporting |
US5592378A (en) * | 1994-08-19 | 1997-01-07 | Andersen Consulting Llp | Computerized order entry system and method |
US5696906A (en) * | 1995-03-09 | 1997-12-09 | Continental Cablevision, Inc. | Telecommunicaion user account management system and method |
US5765138A (en) * | 1995-08-23 | 1998-06-09 | Bell Atlantic Network Services, Inc. | Apparatus and method for providing interactive evaluation of potential vendors |
US6115690A (en) * | 1997-12-22 | 2000-09-05 | Wong; Charles | Integrated business-to-business Web commerce and business automation system |
US6317415B1 (en) * | 1998-09-28 | 2001-11-13 | Raytheon Company | Method and system for communicating information in a network |
US6510427B1 (en) * | 1999-07-19 | 2003-01-21 | Ameritech Corporation | Customer feedback acquisition and processing system |
US6654726B1 (en) * | 1999-11-05 | 2003-11-25 | Ford Motor Company | Communication schema of online system and method of status inquiry and tracking related to orders for consumer product having specific configurations |
US6499657B1 (en) * | 2000-04-21 | 2002-12-31 | General Electric Company | Method, system and storage medium for analyzing product delivery |
US6530518B1 (en) * | 2000-05-19 | 2003-03-11 | General Electric Company | Method, system and storage medium for viewing product delivery information |
US6539386B1 (en) * | 2000-06-15 | 2003-03-25 | Cisco Technology, Inc. | Methods and apparatus for modifying a customer order |
US20020013744A1 (en) * | 2000-07-10 | 2002-01-31 | Tomoo Tsunenari | System and methods to effect return of a consumer product |
US6536659B1 (en) * | 2000-11-15 | 2003-03-25 | Returns Online, Inc. | Facilitating returns of merchandise purchased from other sources |
US20030225625A1 (en) * | 2002-05-31 | 2003-12-04 | Michael Chew | Returns management systems and methods therefor |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20080162204A1 (en) * | 2006-12-28 | 2008-07-03 | Kaiser John J | Tracking and management of logistical processes |
US20080255896A1 (en) * | 2007-04-12 | 2008-10-16 | Hong Fu Jin Precision Industry (Shenzhen) Co., Ltd. | System and method for aiding a buyer to create a supplier scorecard |
US20090007231A1 (en) * | 2007-06-29 | 2009-01-01 | Caterpillar Inc. | Secured systems and methods for tracking and management of logistical processes |
US20090006164A1 (en) * | 2007-06-29 | 2009-01-01 | Caterpillar Inc. | System and method for optimizing workforce engagement |
US20130041713A1 (en) * | 2011-08-12 | 2013-02-14 | Bank Of America Corporation | Supplier Risk Dashboard |
US20130041714A1 (en) * | 2011-08-12 | 2013-02-14 | Bank Of America Corporation | Supplier Risk Health Check |
Also Published As
Publication number | Publication date |
---|---|
EP1485839A4 (en) | 2008-10-01 |
AU2003209347A8 (en) | 2003-09-02 |
WO2003067370A3 (en) | 2004-04-08 |
US7010496B2 (en) | 2006-03-07 |
US20030149611A1 (en) | 2003-08-07 |
CA2478617A1 (en) | 2003-08-14 |
WO2003067370A2 (en) | 2003-08-14 |
AU2003209347A1 (en) | 2003-09-02 |
EP1485839A2 (en) | 2004-12-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20060111966A1 (en) | Supplier performance reporting | |
US20080052205A1 (en) | System and method for identifying implicit events in a supply chain | |
US8024218B2 (en) | Method and apparatus for determining the product marketability utilizing a percent coverage | |
US20030149674A1 (en) | Shipment monitoring method and system | |
US20080270269A1 (en) | Method for stock record verification for small inventory populations | |
CN110825813B (en) | Data migration method and device | |
US8082191B2 (en) | Egg code management method and egg search code management system | |
US20100325028A1 (en) | Supplier evaluation method in electronic commerce and system thereof | |
US20070088742A1 (en) | System and Method for Providing Technology Data Integration Services | |
US20080208780A1 (en) | System and method for evaluating documents | |
US20190213548A1 (en) | Unified view operator interface system and method | |
US20030120563A1 (en) | Method of managing inventory | |
KR20210110129A (en) | Systems and methods for a delivery completion audit tool | |
TWI224265B (en) | System, and method for management of rebuilt parts of vehicles | |
CN110852848A (en) | Work order processing method, device and equipment | |
US20080082429A1 (en) | Systems and methods for automatically resolving bin errors | |
WO2005022309A9 (en) | Manufacturing units of an item in response to demand for the item projected from page-view date | |
AU2014100322A4 (en) | Billx is an electronic transfer and storage of invoices for businesses and individuals | |
US20160104230A1 (en) | Cooperation server, non-transitory computer-readable storage medium storing cooperation program, and ec system | |
US20070226085A1 (en) | System and method for automated mapping of data in a multi-valued data structure | |
CN110956307A (en) | Business data standardization processing method and device | |
US20070214139A1 (en) | System and method for mapping data in a multi-valued data structure | |
KR102717734B1 (en) | Product warehousing and forwarding management system | |
US20140351278A1 (en) | Method and apparatus for searching a system with multiple discrete data stores | |
Najmiddinov et al. | The improvement and automation of the processes of the products reception and assembly in the Trade-Warehouse complex |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |