At the end of month processes, for the results to be read clearly, "true consumption" and "potential consumption" values are both important. These reports can be received through Reports>Customer Reports tab's "Protel Inventory" section, from Materials Control>Envanterler>F4001 in either K02 or Webreports.
Materials Control is a software that can incorporate the sales made by the establishment by quantity and amount through out sales softwares Micros and Simpra. The steps of the process is as below.
1. Sales items are called/read from the sales program(Micros, Simpra).
2. Receipts or inventory cards created are connected to these sales items.
3. Sales amounts are requested from the sales program.
4. Sales item is updated and the amount of inventory item is reduced from the warehouse as the sales amount as X receipt.
This reduction is "POTENTIAL CONSUMPTION".
Through the example below, we can explain the concept of potential and true consumption of the Coca Cola item in X warehouse.
- Opening: The closing inventory value of the previous inventory period. (A)
- Purchase: The amount of items purchased to the storehouse. (B)
- Transfer (+): The received amount to the storehouse from other storehouses. (C)
- Transfer (-): The transferred inventory amount from this storehouse to another. (D)
- Potential Consumption: The amount that is reduced from the inventory because of the Sale-Receipt integration. (E)
- Usage: The amount reduced from the inventory because of usage processes like wastage, wantage etc. (F)
- What it should be: Amount that is calculated by taking the potential consumption as basis. (G)
- Closing: Value entered to the inventory. (H)
- Consumption: The true consumption amount ignoring the potential consumption. (I)
- Difference: The difference between the true consumption and the potential consumption. (J)
The calculation here is done with the formula below:
What it should be (G) = A+B+C-D-E-F
True Consumption (I) = A+B+C-D-F-H
Difference (J) = I-E
As seen above, the main situation that should be read from the report is the closeness of the true consumption and the potential consumption. How far the two values are from each other determines the difference size. True consumption is the value that is physically consumed from the inventory(if the transfers, usages and purchases are correct). Potential consumption is the situation where the system tells us "the amount you need you consume" if the receipt and the sales information are correct. The growth of difference +/- means that the leakage, accuracy of the receipts and the sales amount arriving from the sales software must be checked.