Process Specification Form
Number 1.3
Name Determine Quantity Available
Description Determine if an item is available for sale. If it is not available, create a backordered item record.
Determine the quantity available.
Input Data Flow
Valid item from Process 1.2
Quantity on Hand from Item Record
Output Data Flow
Available Item (Item Number + Quantity Sold) to Processes 1.4 & 1.5
Backordered item to Inventory Control
Type of Process Subprogram/Function Name
Online Batch Manual
Process Logic:
IF the Order Item Quantity is greater than Quantity on Hand
Then Move Order Item Quantity to Available Item Quantity
Move Order Item Number to Available Item Number
ELSE
Subtract Quantity on Hand from Order Item Quantity
giving Quantity Backordered
Move Quantity Backordered to Backordered Item Record
Move Item Number to Backordered Item Record
DO write Backordered Record
Move Quantity on Hand to Available Item Quantity
Move Order Item Number to Available Item Number
ENDIF
Refer to: Name:
Structured English Decision Table Decision Tree
Unresolved Issues: Should the amount that is on order for this item be taken into account? Would this, combined
with the expected arrival date of goods on order, change how the quantity available is calculated?