Advice 1: How to calculate the area of the warehouse

A very important factor for any entrepreneur is the warehouse area where you will store the finished products. In its calculation quite often there are doubts about the various parameters. If you consider all the characteristics and to follow a certain order, all issues will be resolved.
How to calculate the area of the warehouse
You will need
  • the volume of sales in money equivalent;
  • - the turnover;
  • - the number of tiers in the warehouse.
Determine the turnover of the future warehouse. To do this, the volume of sales in monetary terms, calculated on the basis of the purchase price, divide by the turnover. As a rule, the turnover is determined in a practical way: the average number of goods exported to a warehouse for a certain period, divided into its volume. Period pick, based on the details of your logistics Department. It may be a month, six months or a year depending on intensity of movement of goods in the warehouse.
Determine the average inventory which will be stored in the warehouse. For the remaining goods on stock divide by the cost per square meter. The resulting figure is the stock. Then determine the average inventory over the past year: the stock multiply by a factor of 1.2-1.4 (the ratio depends on the intensity of the movement of goods, the more the turnover, the higher the ratio).
Determine the total area of the zone (OBS.XP), where you will store the products. Necessary for calculation the following initial data:

TSSR - average inventory;
KN.z - the coefficient of uneven loading of the warehouse (for all accepted 1,2);
Crazv - coefficient of development (equal to 2);
Ki.on the utilization of the volume (taken within 0,35-0,45);
Ki.p - coefficient of use of the area (taken in the range of 0.65-0.75);
Cyrus - the number of tiers of storage;
Compl - ratio for the warehouse with order picking in the storage area (equal to 1.1);
Npal - pallet height (1,65-1,8 m).

According to the formula OBS.XP = TSSR * KN.z. * Crazv * Compl / (Ki.about. * Ki.p * Carus * Npal) calculate the area of storage products.
Determine the area of the receiving warehouse. The area of the storage area, multiply by 12%.
Determine the total area of the zone where the product is shipped. The area of the storage area and multiply by 8%.
Calculate the area of the zones of control and order picking in the warehouse. For this area of the store, multiply by 10%.
Find the area of auxiliary rooms in the warehouse. Total area of auxiliary facilities is calculated by multiplying the number of warehouse workers for the norm square for each person. This norm is 4 m2.
If you are unable to determine the warehouse area, you can contact the experts, but for the calculations to a third party will require a certain amount of money.
Useful advice
Calculations of storage space it is better to not over one year but over several. This will determine the rate of development, he usually has a value of 1.3.

Advice 2: How to calculate the stock

The calculation of the commodity reserves gives the company the opportunity to analyze how much of the goods stored in the warehouse during the reporting period, how much the company was able to implement, and in what quantity the goods of some names will require a new purchase.
How to calculate the stock
You will need
  • balance or other form of inventory, contracts with suppliers and customers, calculator, Notepad, pen
Calculate initial inventory. This figure can be found in the balance sheet for the previous period or in any other form of accounting of commodity stocks. The figure at the end of the previous year, as a rule, is transferred at the beginning of the current period. For example, a sewing company "X" is stored in the warehouse the material at a total cost of 1 678 000.
Determine the value of the procurement. This value is taken from the contracts with suppliers or other documentation confirming the fact of purchase. Even in the beginning of the year sewing company "X" purchased the material for the sum of 590 000 roubles.
Calculate the value of sales. This parameter should reflect the amount of sales that could realize the organization at the beginning of the period. Let the garment company "X" fabric store "Y" bought material to 630 000.
Count inventory by the formula:
TZ = NTZ + S – P where
TK – inventory, NTZ – initial inventory S – purchases N sales.
In the above example, TK = 1 678 000 + 590 000 – 630 000 = 1 638 000 rubles.
Calculate the stock on every product. For a more qualitative analysis of the movement of goods in the warehouse is necessary to calculate the index of specification for each type of product and its variety. In particular, in our example, TK can be calculated separately for silk, one for woolen cloth, separately for synthetics. While the stock of silk, you can also differentiate by color, density or width of the meter. Therefore, it is recommended to create a special computer program which will track the movement of commodity inventory for each particular product. This will enable the company to respond quickly to the situation – conduct advertising campaigns that promote the sale of goods or urgently to buy raw materials or finished products from the supplier.
The calculation of inventory is recommended every quarter and at the end of the year, which should be reflected in the relevant reporting forms.
Is the advice useful?