Inventory management monitoring systemTechnical Field
The present invention relates to inventory management, and more particularly, to an inventory management monitoring system.
Background
Inventory management refers to the management of the number of commodities in a logistics process, and the past thinks that the commodities in a warehouse are more, so that the enterprise is developed and prosperous. While modern management such as MBA, CEO12 and EMBA, etc., considers zero inventory as the best inventory management. The inventory is more, the occupied funds are more, and the interest burden is increased. However, if inventory is excessively reduced, a gear break may occur.
A reasonable inventory management system can help its enterprise reduce the large amount of capital occupation caused by inventory backlog and also reduce the goods outage.
An inventory management system comprises an inventory counting module and an inventory display module, and judges whether purchasing or sales promotion is needed according to the quantity of the inventory.
However, due to market reasons, whether purchasing is needed is directly judged through the stock quantity, so that the purchasing is unreasonable, and stock backlog caused by excessive purchasing or stock cut caused by insufficient purchasing still occurs.
Disclosure of Invention
Aiming at the defects existing in the prior art, the invention aims at: an inventory management monitoring system is provided which is capable of rationally planning purchases and promotions for inventory quantities.
The technical purpose is realized by the following technical scheme, and the inventory management monitoring system comprises:
an inventory counting module: the system is used for calculating the quantity of the residual goods in real time and outputting a residual quantity signal;
inventory attribute module: a maximum inventory reference and a minimum inventory reference for providing inventory and outputting an inventory reference signal;
overrun confirmation module: the inventory attribute module is coupled with the inventory counting module and the inventory attribute module and is used for receiving the allowance signal and the reference signal and outputting an overrun signal;
and the control module is used for: the system is coupled to the overrun confirmation module and is used for receiving the overrun signal and sending out an alarm signal.
And an alarm module: the system is coupled to the control module and used for receiving the alarm signal and sending out an alarm.
The maximum stock standard is as follows: the product of the maximum capacity and the expiration time of the distance goods in the warehouse and the daily average goods sales is smaller than the product of the maximum capacity and the distance goods in the warehouse, and the minimum stock standard is as follows: product of daily average sales and required purchase time.
According to the technical scheme, the counting module calculates the real-time inventory quantity in the inventory and outputs the allowance signal, the inventory attribute module provides the standard and outputs the standard signal, the overrun confirmation module compares the real-time inventory information with the standard signal to obtain whether the inventory is excessive or insufficient, the control module sends an alarm after receiving the overrun signal and controls the alarm module to send an alarm, so that staff can know that the inventory is excessive or insufficient and react, the allowance in the inventory exceeds the maximum inventory standard, otherwise, the placement of other cargoes is influenced, meanwhile, the excess sales tolerance of the inventory allowance can not be sold before the cargoes expire, the maximum inventory standard is determined through the product of the daily average sales amount and the distance cargo expiration time, so that the backlog of the cargoes and the cargo waste can be reduced, the determination of the minimum inventory standard is based on the condition that the inventory is ensured to be not broken when the inventory is ensured in the time required for purchasing.
Further, the daily average sales amount calculating method comprises the following steps:
s1: calculating an average value K1 of sales in the recent T1 day;
s2: calculating an average value K2 of sales of the last month and the last T2 days, wherein T2 is equal to the time required for purchasing;
s3: an average value K3 of K1 and K2 was calculated, and the daily average sales amount was equal to K3..
According to the technical scheme, the average value of the recent sales volume and the average sales volume of the purchasing days or the goods expiration days required by the last month and the same period in the future are used as daily average sales volume, so that the actual sales volume in the next few days can be more accurately estimated.
Further, the alarm module comprises an approaching alarm and an overrun alarm, wherein the overrun alarm is that a residual signal exceeds a reference signal, and the approaching alarm signal is that a residual information number is close to the reference signal.
Through above-mentioned technical scheme, through approaching alarm module suggestion staff and prepare in advance, avoid because the emergency causes can't handle goods backlog and the backlog condition.
Further, the alarm module comprises an audio alarm module and an image alarm module.
Through the technical scheme, the sound alarm module informs the staff that the stock has a problem, and the image alarm module informs the staff that the specific situation of the problem has occurred.
Further, the sound alarm module comprises a sound box coupled to the control module for receiving the alarm signal.
Through the technical scheme, the sound box is more realistic in processing sound.
Further, the image alarm module comprises a display screen coupled to the central processing unit.
Through the technical scheme, the display screen displays the image or the number of the data, and the inventory information and the reference information can be visually seen, so that the degree of overrun alarm or approaching alarm is judged.
Further, the alarm information in the image alarm module comprises color alarm information.
Through the technical scheme, the alarm information can be more highlighted through the color, and the attention of staff is drawn to be more visual.
Further, the color alarm information is displayed as yellow near alarm color, red out alarm color and green conventional color.
Through the technical scheme, the three different colors are used for distinguishing, so that staff can intuitively know the difference value between the actual inventory information and the reference information.
Further, the control module includes a central processor for storing information.
By the technical scheme, the processing speed of the central processing unit is high.
The invention has the following technical effects:
1. according to the invention, through reasonably customizing the maximum inventory standard and the minimum inventory standard, the inventory processing is more reasonable, and the stock backlog and the stock shortage phenomenon are reduced;
2. according to the invention, the actual sales volume of several days in the future can be better budgeted through a reasonable daily average sales volume calculation method.
Drawings
FIG. 1 is a system diagram of an embodiment;
fig. 2 is a flow chart of an embodiment.
Detailed Description
An embodiment of an inventory management monitoring system, referring to fig. 1 and 2, includes an inventory counting module, an inventory attribute module, an overrun confirmation module, a control module and an alarm module, wherein the inventory allowance is calculated by the counting module, the attribute module provides two reference values of a maximum inventory reference and a minimum inventory reference, the overrun module compares the inventory allowance with the reference value, and finally the alarm module is controlled by the control module to alarm.
The inventory counting module is used for setting an inventory counter in front of a warehouse door, correspondingly increasing or decreasing inventory quantity on the counter every time of taking and feeding, further obtaining actual inventory in the warehouse, wherein the counter is coupled with the control module and uploads the numbers on the counter to a cloud database in real time.
The stock attribute module is provided with a maximum stock standard and a minimum stock standard, two standard values of the maximum stock standard and the minimum stock standard are stored in a cloud database of the computer, when the stock allowance exceeds the maximum stock standard or is lower than the minimum stock standard, an alarm is given out, the calculation method of the maximum stock standard is a smaller value in the product of the expiration time of the maximum capacity and the distance goods in the warehouse and the daily vending amount, the stock allowance cannot exceed the maximum goods amount reserved for placing the goods in the warehouse, otherwise, the storage space of other goods is occupied, the storage of other goods is affected, meanwhile, the stock allowance cannot exceed the sales limit, namely, the stock amount which can be sold out is calculated according to the daily vending amount and the achievement of the goods expiration remaining time, and then whether the existing stock goods can be sold out before expiration is obtained or not is obtained, and the minimum stock allowance is the product of the daily vending amount and the purchasing time.
The daily average sales amount is calculated by the method,
s1: calculating an average value K1 of sales in the recent T1 day;
s2: calculating an average value K2 of sales of the last month and the same period as the current day T2, wherein T2 is equal to the time required for purchasing;
s3: an average value K3 of K1 and K2 was calculated, and the daily average sales amount was equal to K3.
The average value of the recent sales volume is used as the daily average sales volume compared with the average sales volume of the future required purchasing days or the goods expiration days, so that the actual sales volume of the future days can be more reasonably estimated.
And the overrun confirmation module is used for receiving the allowance signal and the reference signal, comparing the overrun signal with the reference signal, and sending out an overrun signal to the control module when the existing allowance stock is higher than the maximum stock reference or smaller than the minimum stock reference so as to control the alarm module to alarm.
The control module is a central processing unit in the computer, and gives an alarm under the control of the central processing unit.
The alarm module includes near alarm and overrun alarm, and alarm mode includes the audible alarm of audible alarm module and the image alarm of image alarm module simultaneously, near alarm sends the warning when the surplus signal when the alarm is 10% from the benchmark in this embodiment, prompt staff prepares in advance, avoid can not adjust sales plan or purchase goods to the backlog or the timely reaction of backorder condition because the emergency causes, audible alarm module sends the suggestion sound through the audio amplifier when near alarm or take place overrun alarm, the image alarm shows different colours through the display screen of coupling on the computer, green represents normal, yellow represents near alarm, red represents overrun alarm in this embodiment. The staff can know the stock condition when seeing the color on the display screen. Meanwhile, the display screen also displays the stock allowance, the maximum stock standard and the minimum stock standard.
The method comprises the steps of calculating the inventory balance, calculating daily average goods quantity, calculating the maximum inventory standard and the minimum inventory standard, comparing the inventory balance with the maximum inventory standard and the minimum inventory standard through a computer, displaying real-time data through a display screen, displaying yellow corresponding numbers on the display screen when the inventory balance is close to the standard range, and sending out prompt tones by a sound box. The staff prepares to purchase or plan the sales plan, when the stock allowance reaches the maximum stock standard or the minimum stock standard, the corresponding data on the display screen displays red. Meanwhile, the sound box gives out a prompt tone, and staff performs purchasing or sales plan execution, so that stock backlog and stock break phenomena can be reduced.
The present embodiment is only for explanation of the present invention and is not to be construed as limiting the present invention, and modifications to the present embodiment, which may not creatively contribute to the present invention as required by those skilled in the art after reading the present specification, are all protected by patent laws within the scope of claims of the present invention.