Introduction
The Kardex Inventory keeps tracking of:
-Purchase Order cost on every transaction
-Fifo, Lifo, and Average cost method after every purchase.
-Kardex, units before, units of movement, units after purchase or sale.
-Sale price to know how much is the revenue for the three revalorization methods and the real cost of Purchase Order.
Every entry to the Kardex Inventory corresponds to account line movements both for Purchases and Sales. For a complete description of these movements read the article "".
Correspondence of Purchase Order Account movements with Kardex Inventory. Figure 1, account movements. Figure 2 Kardex Inventory movements.
|
Figure 1
Figure
2. Kardex Inventory movement
Correspondence of Sales Account movements with Kardex Inventory. Look that this data gives the exact revenue for the Purchase Order Cost, FLIFO, FIFO and Average methods of revalorization.
Sales Account movements figure 3:
Figure 3
Here the movements Inventory and Sales Cost keep tracks of the cost of the products. It is 1000 per unit. Sale of 4 units gives a total of Sales cost of 4000.
Figure 4. Sales movements for Kardex Inventory.
Figure 4
Important facts:
-Keep track of the LOT for Purchase and Sales to save the Real Cost of the product. Every lot could a different Cost of Purchase. The revalorization of inventory will be different depending on the method.
-The Kardex sale inventory movement keeps the SalePrice. The revenue depends on the revalorization method of inventory and the real cost of the Purchase Order. In this case, the Average, Cost Fifo and Cost Lifo are the same because is the first transaction.
Figure 5
Figure 5 shows different costs for FIFO, LIFO, and Average. The first line is the purchase movement and has 1000 (FIFO), 1200(LIFO ), 1100(average) cost.
The second line is the Sale movement. The sale price is 1500. The revenue will be different for the real cost of purchase and the revalorization method.
Accounts Receivable and Liabilities:
The payments to Providers and received by Clients are kept in a different sheet to control the amount to pay and receive. Generate a projection to see if the Sales are enough to pay the future compromises.
Figure 6: Accounts and Payments
Figure 7 shows that the business has more liabilities than accounts receivable. Also the payments done to liabilities are low, compared with the payments received by clients.
Figure 7
Results Statements.
Figure 8
