How the System Calculates RDC Consignment Usage

The following describes how consignment billings of usage are calculated for both Levels and Order count data.

Levels Mode

The consignment billings of usage for Levels mode is calculated with the following formula:

((Beginning On-Hand Quantity + Received Transfers Since Last Hot Sync) - (In-process Customer Consignment Transfers - (Open Consignment Transfers - Cycle Counted Level Uploaded by Palm RDC))) = Usage.

For example:

Your customer has 100 widgets as their beginning on-hand quantity, for which the minimum is 60 and the maximum is 100.
After a week, you cycle count the widgets and find that the customer only has 50 left.
You HotSync the cycle count, and create a consignment transfer for replenishment for 50 more widgets.
You send 40 of the widgets, which the customer receives the following Monday.
Monday you send 5 more widgets, leaving 5 more to fill the transfer order.
On Tuesday, you perform another cycle count of the widgets. The customer has 90, which you upload using the Palm RDC.
After the cycle count, you calculate usage:

(((100 + 40) - (5 - (5 - 90))) = 50

The consignment billing for usage is for 50 widgets.

Order Mode

The consignment billings of usage for Order mode is calculated with the following formula:

((Beginning On-Hand Quantity + Received Transfers Since Last Hot Sync) - (In-process Customer Consignment Transfers - (Open Consignment Transfers - Orders Uploaded by Palm RDC))) = Usage.

For example:

Your customer has 100 widgets as their beginning on-hand quantity, for which the minimum is 60 and the maximum is 100.
After a week, the customer cycle counts the widgets and finds that they only have 50 left.
They HotSync the count, and create a consignment transfer for replenishment for 50 more widgets.
You send 40 of the widgets, which the customer receives the following Monday.
Monday you send 5 more widgets, leaving 5 more to fill the transfer order.
On Tuesday, the customer cycle counts the widgets again. The customer has 90 widgets, which they upload using the Palm RDC.
After the upload, you calculate usage:

(((100 + 40) - (5 - (5 - 90))) = 50

The consignment billing for usage is for 50 widgets.