|
|
Table: | PURCHASE_ORDER | |
Description: | Compute the number of orders for the same part in each month period and show all part numbers and the number of orders where the number is greater than three. | |
Rule Logic: | SELECT | PART_NUMBER, MONTH(DATE_OF_ORDER), |
GROUP BY | PART_NUMBER, | |
WHERE | COUNT(*) > 3 | |
Expectation: | Expect none on the list. The inventory reordering algorithm should be ordering enough quantity not to have to reorder more than once a month. Multiple orders may be acceptable, but only under special circumstances. |
Table: | PURCHASE_ORDER | |
Description: | Compute the total value of all purchase orders for a month by each category of inventory. Then compute the percentage of the total orders placed that each category provided. Compare this with historical distribution of orders. | |
Rule Logic: | SELECT | INVENTORY.TYPE, |
FROM | PURCHASE_ORDER. INVENTORY | |
GROUP BY | INVENTORY.TYPE | |
WHERE | INVENTORY.PART_NUMBER = | |
Expectation: | The percentage of the value of orders placed for each category should not vary from month to month by more than 10%. |
|
|