Inventory Usage Recap

Enter a valid inventory number to display:

Beginning Count
Beginning Count is the ending inventory count from last week

Purchases
Purchases refer to the total purchase amounts made from outside vendors.

Planned -the planned purchase amount is the summation of all of the original delivery amounts expected in the past week from outside vendors

Actual -the actual purchase amount is the total of all invoices or delivery quantities input for the past week.

Deviation -the purchase deviation is the difference between actual and planned purchases.

Transfers Received

Planned -the planned transfer received quantity is the summation of all original delivery amounts expected from internal suppliers during the past week.

Actual -the actual transfers received amount is the total amount transferred in during the past week.

Deviation -the transfers received deviation is the difference between the actual and planned transfer amounts.

Ending Count
The Ending Count is the amount entered through the Input Inventory Book Program.

Usage
The Usage amounts reflect a comparison between what was forecasted to be used and what was actually used. The usage totals are the same numbers that appear on the inventory analysis report.

Planned The planned amount of usage is the summation of all requirements of the inventory item as forecasted for the week.

Actual The actual usage amount is calculated by adding purchase quantities and amount transferred to the beginning inventory quantity and then subtracting the ending inventory quantity.

Deviation The deviation is the difference in inventory units between the actual and planned usage. the total will include any inventory need that is transferred to another location.

In the preceding example, the usage amounts (which correspond to the Inventory Analysis Report) indicate that the item was underused by 3 cans. further examination of this screen shows that the system expected 18 cans to be purchased but only 6 were received through invoice entry. Several explanations could account for this:

Misplaced invoice was not input through invoice entry.
Error in the quantity input through Invoice Entry or the Input Inventory Book Program.
The amount ordered was decreased from the amount on the purchase requirements.
The vendor did not have enough in stock to fill the order.

The transfers received line shows that although it was not planned, 6 cans were purchased from other FoodPro location(s). This additional information indicates that either the order was reduced or the vendor was out of stock.

To verify that the past week transfers and purchases are correct, select to display the detail listings of transfers received and purchases:
Display Purchases
Display Transfers Received
Display Planned Usage
Display Transfers Sent

Back to the main page