Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - How to make a warehouse inventory list
How to make a warehouse inventory list
1. Four methods of warehouse inventory:

(A) sustainable inventory method

The perpetual inventory method or dynamic inventory method is to take stock when the inventory is put into storage.

(B) periodic inventory method

Cycle counting is to count a certain amount of inventory every day. According to the order of warehousing, first come, then arrive, then arrive.

(3) critical inventory method

For example, those with high access frequency and those that are vulnerable and consumable need to be counted to prevent deviation.

(4) periodic inventory method

General warehouses should take regular inventory. A better warehouse should be counted once a week, once a month, once a quarter or once at the end of the year, at least once a year.

2. The warehouse inventory table production:

Warehouse inventory can be created in the form of excel tables, one table can be used if the categories are unified, and two tables can be used if there are many categories. The approximate template is as follows:

It is more convenient to make tables with excel. Note that the first column is the serial number. Don't use the default in the excel table, otherwise it won't be printed when printing.

Warehouse inventory refers to inventory and so on. Common methods include book counting and spot counting, and money counters are often used as tools. Its function is to integrate and summarize warehouses and count inventory. The inventory table is generally the inventory and statistics of the existing goods in the warehouse.