The calculation of inventories gives the company the opportunity to analyze how many goods were stored in the warehouse during the reporting period, how many goods the company was able to sell, and in what quantity of goods of which name new purchases will be required.
It is necessary
balance sheet or other form of accounting for inventory, contracts with suppliers and customers, calculator, notebook, pen
Instructions
Step 1
Calculate your initial inventory. This indicator can be found in the balance sheet of the company for the previous period or in another form of accounting for inventory. The end of the previous year is usually carried over to the beginning of the current period. Suppose a sewing company "X" has material in its warehouse for a total cost of 1,678,000 rubles.
Step 2
Determine the cost of purchases. This value is taken from contracts with suppliers or other documentation confirming the fact of the purchase of goods. Suppose that at the beginning of the year the sewing company "X" purchased material for the amount of 590,000 rubles.
Step 3
Calculate your sales. In this parameter, it is necessary to reflect the amount of sales that the organization was able to carry out at the beginning of the period. Suppose a textile store “Ygrek” bought material for 630,000 rubles from the “X” sewing company.
Step 4
Calculate your inventory using the formula:
TK = NTZ + Z - P, where
TK - inventory, NTZ - initial inventory, Z - purchases, P - sales.
In the above example, TK = 1,678,000 + 590,000 - 630,000 = 1,638,000 rubles.
Step 5
Calculate the inventory for each type of product. For a better analysis of the movement of goods in the warehouse, it is necessary to calculate the TK indicator for each type of product and its variety. In particular, in our example, TK can be calculated separately for silk, separately for woolen fabrics, and separately for synthetics. At the same time, the stock of silk can also be differentiated by color, density or width of a running meter. Therefore, it is recommended to create special computer programs in which the movement of stocks for each specific type of product will be tracked. This will allow the company to quickly respond to the situation - to carry out promotions that promote the sale of goods or to urgently purchase raw materials, materials or finished products from a supplier.
