TW200525396A - System and method for managing inventory - Google Patents

Abstract

A system and method for managing inventory is disclosed. It can supply age calculation of stock, warning signals for abnormal inventory situations, inventory and prices calculations and statistics. The system comprises a statistical module to integrate and calculate inventory, age of stock and prices distributing areas, send warring signals to relational ones for overdue and oncoming overdue inventory.

Description

200525396 V. Description of the invention (]) [Technical field to which the invention belongs] The present invention relates to a kind of inventory management system and methods and methods, especially to a [prior art] For manufacturing enterprises,库 在 出 士 + 人 右 相 # 士 Ｍ 4The cost of a mentor occupies a large proportion of the total cost of closing a job. 'How to effectively control inventory and reduce inventory — the weight of a company's total cost reduction and profit improvement _ 疋 It becomes an important task for manufacturing enterprises. As a result, inventory management has been active for a long time and has been active since 2. Century 4. =; Inventory: The origin of the study of the rationale; ^ 目 β, r has been the reorder point method in the 4U era to the present ^ P1-nlng; ERP) What system acridine; quasi inventory-疋: the focus of Γ. The focus of inventory management is on coins. Ding Cai showed quasi-inventory 1 and slammed Huaicheng. Inventory replenishment was performed according to the quasi-inventory and actual inventory. (Reorder P0lnt; R〇p), the wood ^ m. 〇σ I 疋 sends out a certain amount of material when the inventory level is on time. The traditional inventory camp 1 Ding Lo Ί Ί D-D j, Shan Tsai & management methods include various batch methods (quantitative method-111¾, such as batch method, quantitative batch method, economic order 2 = method, regular batch Method and the lowest total cost method. The name is "Inventory Management Mody \ 418,416 US Patent, Patent

System and Method) ί ί (Inventory Management to analyze the best inventory water $, // J to provide a tracking inventory status to use the health report, inventory management related personnel can be disclosed by patent =; the previous inventory status system The shortcomings of this technology are: The above method focuses on inventory 200525396 Description of the invention (2) ------------- ::: Ϊ s does not consider the state of the material storehouse age. At the same time " The legacy of the economic real world exhibition requires the analysis of the inventory of each base in the enterprise. The inventory analysis and trend analysis of each base in the enterprise are not conducive to: The age of the material refers to the time that the material is in the warehouse, that is, : [Summary of Contents] Base 二: Two: To the shortcomings of the foregoing systems and methods, mention # -kinds, 'trend analysis, dynamic inventory management, and inventory of points. The #storage days refer to the most: and inventory days The present invention provides a multi-data base in the inventory and standard average daily volume. J: client computer, network, and "database analysis" analysis system, which includes: a multi-site J-site computer and a multi-site data base application. : Serve! Device, -Database,: : Can perform database and inventory query interface ;; Divided into two alum, query the inventory of each material: 箄 ϋ § Only, stored from the application server :! 4 in the world each-inventory d :. The base computer is placed Enterprise property; material and store it in the base data I: Use: Collect the stock base's library = material number, description of the description, ii4 inventory materials in the library, including the temple. The data library stores the company Xiaoli, Zizhong , Gross weight, unit price, and total: inventory data and users of materials;: all inventory bases in Γ: i description:: point name, name of country where the base is located,: library: data includes base generation, quantity, net weight, gross weight , = :, material number, product name described in the shell and the total amount, customers and carriers, etc. 200525396 V. Description of the invention (3) The user information includes the Emai 1 address of each user, the user set + the required inventory "Data and sending reports", etc. ^ 's series of software function modules for MEMS, also called "徊" version-including one. 7. 实现 Analysis of multi-site inventory by network, among which application server Including a basic data dimension * user / cap dimension; Relevant data of the database can be added:;: delete the inventory data in the tribute library,-permission setting module "Yu; = " Don't expect data, integrate all inventory bases: =; base analysis 2 manage dynamic inventory To carry out the storage age and inventory week 4: display the trend of the material in combination with the chart, analyze the situation, provide predictions for abnormal conditions, and analyze the trend of the inventory days. "Analysis; J lose ;;: and for querying sub-modules based on the user's required inventory data to analyze the operation module includes one, multiple, or all of the first-class operations: the user selects the base, material number and customer Obtain the second query condition of the inventory that meets the search conditions, and use it from the base database to analyze price changes and trends in the sub-module of base price, material classification, and price / trend analysis, and perform ^ ° and material number at one time. Segment display; ~ Dynamic inventory management ^ / data, delivery and the combination of graphical changes in the total amount of inventory and inventory = inventory quantity and amount, and = _ shell; a inventory turnover rate calculation submodule

"Inventory quantity and amount of materials," and the change trend of the amount of materials; the age of the inventory quantity of a warehouse today, and between the Japanese and the Japanese, ^ each material ^ ^, the address is shown in the fifth, the description of the invention ( 4) It is used to count the inventory warning sub-modules according to the materials for the turnover days and inventory turnover rate of the rafters; compare the storage days, such as ::::: Standard inventory days and actual inventory number will display a warning message * .— The number of inventory days is greater than the standard inventory days and the name of each material is displayed; the month ^ inventory days trend analysis sub-module is used to calculate the module used to integrate all two = one-day inventory days; The invention provides two materials: price analysis of the base's inventory, and the second method, which can analyze the multi-rate of the enterprise and the number of days of inventory, and manage the inventory information of the inventory and the inventory turnover point; (B) According to your own point, the following steps ... (a) Obtain the data of each analyzed material at one time; the bucket classification, supplier and material number are combined and displayed in a circular change manner. Change end = amount and amount, and display each 2) In the system _ = to Jaw change trend chart; (the number of inventories and ^ the number of stocks in the base and the amount of m in the age range of each material 枓 = inventory turnover days and inventory between each month: ΐ ::. Of each — Corresponds to the day = calculation and display of each object, as shown in the first figure, system structure diagram. The distributed server is connected to the application server 1 of the multi-site inventory analysis system; the client computer 2 Connected through Internet 4 and Internet 6; "Globally: =: 1 Connected with -Lian Men Service 1; Base Computer 3 / Data :, Computer 3 Connected to Network 5 with Network 4 " Description of the invention (5) Point database 7 is connected. Among them, network 4 is a corporate intranet (1a ", 2 、: electric τ subnet, which can be other types of networks; connection 5 is a type of data Library connection (Internet) or its (〇Pen Database Connectrvi1f; o " m ^ database connection (Java Database c〇nnec DBC), or hva In the present invention, the client computer 2 is the user Vlty 'JDBC), etc. . To achieve graphical inventory query interface user interface, maintenance of the base database From the mistake of the application server-it can carry out operations such as lean material warehouses and inventory situation. There are 3 computers in the base. It is used to collect inventory information for each warehouse industry and is used worldwide. Description of product name, quantity, net weight, gross weight, single = including the material number of the material, t storage of all the stock locations of the company's global distribution bases, etc., database: material and user information, where the inventory data includes the type of material Inventory%, name of the country where the base is located, material σ ", code, base weight of the base, gross weight, eight percent per month, mouth name description, quantity, including the amount of ancient crustaceans, customers and carriers, etc. With 61 daggers, each user's £ 1 ^ 丨 1 address, ^ — temple, user information and time to send reports, etc. Application servo 4 = required inventory data: capable module (as shown in the second picture), with the help of-series software «analysis. Refer to the second figure for the inventory of the Lingxiong base, which is the module diagram of the application month of the invention. The application server] includes one of the following: the power of the kimono 1: the authority setting module η, a pair of resources ^ group 13 and a report rotation module 14. Among them, basic analysis; J analysis operation mode

Page 10 200525396 V. Description of the invention (6) The client computer 2 maintains the relevant data of the database 6, and can newly select the inventory data in the database 6. Privilege setting module 11 series 9 is used to set user restrictions, and specifically includes: system user # ^] :: should be group setting, designated user group corresponding two fingers: use :: should user group , The setting of the system menu and the system menu and the group electricity switch, ^ 6 again. Behr setting module 12 is used to set the system's data, and the two things: classification setting, material standard inventory of each material classification: number setting, and warehouse code setting. Analytical work + ff days computer 3 from rough times 7 / roll knife analysis operation core group 13 is used to collect the inventory data 々 material data in each inventory site by the site = 据 ”沾 沾 枓 warehouse 7 to carry out the price Trend analysis and management kinetic energy: ί Line display ... On inventory days: til; line; the combination of materials and charts to alert. This module includes a pre-latency trend analysis sub-module 131,-dynamic library 4 storage —Take sub-two ° 2, one-one early warning sub-module 135, one inventory days module 134,-inventory material query sub-module U0 is used for users ί = 138. Among them, the base inventory data-one, plural I or all as Inventory data that meets the query conditions in the material number, customer, etc. :: Name, description, quantity, net weight, gross weight, star, storage base name, material number, product selection-a base The inventory note: = amount, etc. If the user can select a material to query the inventory status of the material at 1 = each item, the grid trend analysis submodule 131 is used to store the inventory status of each location according to the King of the King. Price Kang ^ , Material classification, supplier and

200525396 V. Description of the invention (7) The material number is analyzed by a combination of graphic and dynamic trend analysis, and the data is changed: statistics of each material at each base: the second management module 133 is used to change according to the library and the amount Trend item. The number of ages of the pool age analysis and the total If &

The age is calculated as:; ::! = Stock quantity and inventory amount. At A time, when the material is not stored in t, the age of the storage is subtracted from the current time. Inventory turnover rate Leaf tube: $ day: The storage age is the time of storage minus the time of storage. The inventory early warning sub-module 135 is used to compare the number of days of inventory: d = the number of days of storage, if the actual-group 136 is used to calculate and display each material in each month / each site "4 ;; number report = ΓΓ :: Γ7 is used to integrate global scores;: f module u pair = multi-site library is rotated according to user needs! This map of the multi-site inventory analysis system of the present invention makes use of this map. This page displays a global Map, = ΐ; number :: the geographical location of the base (in the figure = four deposit bases: =, 3 ° B, 3 °. And 301), the operation flow of the library is obtained: 四 4d, which is the present invention The first base inventory data query sub-module 130 of the multiple base inventory analysis method is based on the user's page 12, 200525396 ------ 丨 V. Description of the invention (8) Select the base, material number, customer, and carrier as the query conditions. Warehouse 6 and the inventory data based on multiple, multiple or full inquiry conditions (step S40 1), decibels, 7 are obtained to meet the inventory analysis operation (step S4 0 2). Price trend; f module 13 conducts inventory points, Material classification, supplier and part number = group 1 3 1 according to data: grid change trend, and the number The change is combined with the step V40 Sa 3a in the graph section. The dynamic inventory management sub-mold mode displays (, the inventory quantity and amount, and displays each material in :; ten: the change trend of the material in each position and amount (step s4 & ¥ inventory number = 3 different statistics, different material age interval of each material data = ^ analysis of the sub-module amount, and the sum of all inventory age data ^ inventory quantity and step S4 03c '.). Inventory turnover rate calculation sub-module m = inventory amount (inventory turnover days of each base between steps, ,,,, and each material are counted first) ° Inventory warning submodule 135 turns each material warehouse ^ turnover rate (step S4〇3d's inventory days are compared. If the actual inventory days and actual days are not displayed, a warning message will be displayed. Inventory ^ 0 inventory days are greater than the standard inventory count and each material will be counted in a certain trend analysis submodule 136. Step S4 0 3e). The inventory days corresponding to the mother day of month 6 (step

Please refer to the fifth figure, which is the schematic diagram of the A price trend analysis method = Rabbit Mingduo base inventory analysis method, supplier code, material code ^. The user enters the location and material category grid trend analysis sub-module 131 'Check the date and time after step 5 (S501), price). If the date range i is valid, is the period range valid (step S5 02, the range is stopped, and the input stops. :: Step S501 re-enter; if the date part shows the material number corresponding to the date on different dates] 3 pages 200525396 V. Description of the invention (9) Price (step S503), and the price change is displayed graphically (S504). v Weighing Refer to the sixth figure, which is the time price trend chart of the multi-site inventory analysis system of the present invention. In this embodiment, taking the material XX supplied by supplier A as an example, it is assumed that the extended time period is from August i, 2002 to 2 main months! That is, the time axis (horizontal axis) is divided into 9 digits according to the selected time interval.

Include the highest price and lowest price to split. In this formula, it is assumed that the price of the material of 20 from 2020 to 2002 is: 2 0 3, 199, 199,..., L potential analysis submodule, and the price axis is set according to the lowest Price (; 8 mouth 5 = Jagger: grid (20 5, 5)) to divide the interval. After the horizontal axis is established, and 4 south is taken, the price trend analysis sub-module 131 will be used to price the material jf ^ Middle and price of f —B —corresponding to—according to ^. It is indicated by a broken line in the range of time from August 02, 2002 to 2q2 ^ q Door supplier A supply "h @ The daily price trend of the year. The winter chart shows the multi-site library of the present invention; & The schematic diagram of the dynamic inventory management method. According to the analysis method and the amount (step S702), the amount of material inventory at each base of the ball. · ^ The change trend of the inventory quantity and amount (step s? 03) As shown in the eight diagrams of Chayuedi, this is the time of the multi-site inventory analysis system of the present invention.

Page 14 200525396 V. Description of the invention (] 〇) Inventory of supply by supplier a; standard; wide order: = ΓΛ inventory

, (Vertical axis) is based on the material that is taken from the table. S i: "Highest inventory and monthly minimum inventory :: ί ~! In the formula of the material house," "χχ materials in 2〇 ^: In this specific 2J °, 2 ° 5, ....., 18. . Therefore, the second deposit: 215, the inventory axis is based on the monthly minimum inventory n80; Group C will be divided. For the sake of clarity, the vertical coordinate indicated by the inventory of 4 and 5 in this month is not in the original coordinate mode, and the most j: at the appropriate position, so as to prevent the lowest inventory from being higher than the original coincidence. In the establishment of the horizontal axis and vertical = curve and horizontal axis module 132 to store the material in stock ^, the dynamic inventory management subsystem-correspondingly displayed at the coordinate V4 boundary is set = clear in the time interval, for :Inside. Trending as a polyline. The monthly inventory of the supplied XX materials is shown in the ninth figure, which is a schematic diagram of the age analysis method of Taikuo. '= Multiple, the point of inventory analysis method, the number of stocks of each material, the inventory of the material Query Module 1 30 The age analysis of the sub-module 1 3 3 After the material is divided into miles and Meng amount (step S 9 0 1), the inventory quantity and amount of the base and 7 'she counts in different age intervals. Amount of inventory. Among them, the storage age of the inventory is $ 2. The number of days of inventory with the storage age days. The storage age is the current time minus the storage time ^ :: When the material is still in stock, the storage age is the storage time minus the storage time S 'When the material is not in stock , Library ~ time (step S920). Calculate the number of articles] 5 hundred 200525396 V. Description of the invention (]]) The materials are classified in different storage age intervals 丨 S9 03), and the above-mentioned inventory 'Γ' inventory quantity and amount are shown (for the steps, see the tenth figure) And Meng amount (step S9 04). Inventory turnover analysis method: f of the multi-site inventory analysis method of the present invention] 30. After obtaining a 1-site inventory data query submodule at each site, the user loses eight materials and years And the amount (step thank) inventory turnover rate calculation submodule] / Temple greedy materials (step S1002), and the month-to-month employment and D materials are classified in different years sms), and take into account the inventory turnover rate ( Step Τ. Whether the number of days in the inventory is different from the number of days in the inventory. The number of days in the inventory is larger than the standard inventory day 2 (S10 ° 4), and the actual number of days of inventory is greater than the quasi-inventory & (step S 1 00 5). If a warning message is generated (step = deposit) and the number of days in inventory is used, the actual / 'deposit day bank / eight days' small f standard rail is used according to different dates (step S 1 0 0 7). In summary, the change trend of the above-mentioned method is that the method and method proposed by the present invention can indeed meet the requirements of invention patents. The analysis of wheat inventory is consistent, but the above is only a multi-site of the present invention = patent application # 法 之In a preferred embodiment, those who are familiar with the technical aspects of the present case: the knife analysis system and the instrument < and those who make in the spirit of the present invention, the modification or change should be included in the scope of the application. T's search

Page 16 200525396 Brief description of the diagram The first diagram is the hardware architecture diagram of the multi-site inventory analysis system of the present invention. The second figure is a functional module diagram of the application server according to the present invention. The third figure is a schematic diagram of the multi-site inventory analysis page of the multi-site inventory analysis system of the present invention. The fourth diagram is a flowchart of the multi-site inventory analysis method of the present invention. The fifth diagram is not intended for the price trend analysis method flow of the multi-site inventory analysis method of the present invention. The sixth diagram is a time price trend diagram of the multi-site inventory analysis system of the present invention. The seventh diagram is a schematic diagram of the dynamic inventory management method process of the multi-site inventory analysis method of the present invention. The eighth figure is a trend chart of the inventory among bees of the multi-site inventory analysis system of the present invention. The ninth figure is a schematic diagram of the age analysis method of the multi-site inventory analysis method of the present invention. The tenth figure is a schematic diagram of the inventory turnover analysis method of the multi-site inventory analysis method of the present invention. [Symbol of main component] Application server _ 1 Basic data maintenance module 10 Permission setting module 11 Data setting module 12 Analysis operation module 13 Base inventory data query sub-module 130

Page 17 200525396 Schematic description of price trend analysis submodule 131 Dynamic inventory management submodule 132 Library age analysis submodule 133 Inventory turnover calculation submodule 134 Inventory warning submodule 135 Inventory days trend analysis submodule 136 Information integration sub-module 137 Report output module 14 Client computer 2 Base computer, 3 Network 4 Connection 〖5 Database 6 Base database 7

Φ P.18

Claims (1)

200525396 6. Scope of patent application 1. A multi-site inventory analysis system, including an application server, multiple client computers, multiple data point computers, a database and a multiple data point database, where the application server includes: A basic data maintenance A module for maintaining related data of the database by the client computer, which can add, modify, and delete inventory data in the database; and an analysis operation module for collecting the data from the base database by the base computer The material data in the inventory base is integrated into the inventory data of each base material, price trend analysis is performed, dynamic inventory management, inventory age, inventory week, and turnover rate analysis are performed, and the data is combined with charts to display the trend of inventory days. Analyze and provide early warning of abnormal situations. 2. The multi-site inventory & analysis system as described in item 1 of the scope of the patent application, wherein the application server further includes a report output module for outputting the analysis results of the multi-site inventory according to user requirements. 3. The multi-site inventory analysis system as described in item 1 of the scope of patent application, wherein the application server further includes a permission setting module for setting the setting of user permissions. 4. The multi-site inventory analysis system described in item 1 of the scope of patent application, wherein the application server further includes a data setting module for setting system data. 5. The multi-site inventory analysis system described in item 1 of the scope of the patent application, wherein the analysis operation module includes a site inventory data query sub-module for the user to select one of the site, material number, and customer, etc. Plurality or all as the search conditions, from the database to obtain the database that meets the search conditions Page 19 200525396 丨 VI. Scope of Patent Application Poverty News. 6 · The analysis operation module described in the [Scope of Application for Patent] is also == multi-site inventory analysis system, and is implemented by base, material, and supply; the price trend analysis submodule uses price change trend analysis, and uses ^掳 = The show of department number in a period of time. The method of changing the combination of culture and graphics according to the situation 7. As described in item 1 of the scope of the patent application, the division operation module also includes a two-site inventory analysis system. Group the amount of stock in a period of time and the amount and amount of ^ ^ ^ ^ ^, and display each item 8. Such as the patent application scope of the fourth change trend chart. As described in the analysis of the operating point inventory analysis system, it is calculated in different storage age intervals. Each of the two = age analysis' submodules is used to aggregate the amounts, as well as to summarize the inventory quantities and deposits of all the warehouses. Analysis operation module two bases inventory analysis system, which calculates the submodule inventory turnover rate according to the inventory turnover rate of each material at different months. s Count the inventory turnover days of each base and the analysis operation module of the 10th patent scope of the patent application, f =. Also include: Kuo Ji database / inventory analysis system, its standard inventory days = dang — The inventory warning sub-module compares the inventory days of each item that is greater than _ ^ ^. If the actual inventory number is 1 ^, such as the scope of patent application ^ inventory days, a warning message is displayed. The analysis operation item / multiple-site inventory analysis system described in the case includes a trend analysis sub-model of inventory days. Page 20 200525396 Scope of patent application: Calculate the difference and display the number of each material. Inventory days corresponding to each day of the month 1 2 · As mentioned in the application, the as many as eighty-seven u knife operation module described in item 1 of the scope of insult, including one-base inventory analysis system, its king Jade and materials of each base. Beixun integration sub-module is used to integrate 13 two kinds of multi-site inventory analysis methods, soil mouths, and materials at each site including the following steps: According to the site, material, Y, straight, bucket, supplier, and Material% ^ Second, the price trend of the spoon, 告 yy analysis of the material at one time _, display; 'Combined with the data changes and graphics change :: statistics of the total amount of each item * 々 inventory at each site The inventory quantity and total ^ n at the time of the shipment, and display the trend chart of each change of ten different age intervals of each material amount; and the inventory quantity and gold statistics of the right and bismuth 2 bases of the Department of Health. The inventory quantity and inventory amount have a turnover rate; and the inventory turnover days and inventory calculation of each base between the monthly injuries are displayed-4. The number of inventory days corresponding to each day of each month for each material is two of the patent scope The multi-site inventory analysis method described in item 13, the user S trend analysis steps include: = the entry site, material type, supplier code, material ^ Moment has been completed; the price is going to be implemented. Whether the range Effect, if the date range attack ~ 're-enter; 200525396, if the scope of patent application is corresponding to the date range 1 5. If you apply for the library, the dynamic database will be obtained from each base, and the global materials will be displayed. 1 If you are applying for the library, the age of the library will be obtained from each base. And exchange 5 ten different and show the amount. 1 7 · If you apply for a special inventory in which you get materials from each base, calculate a certain number of items, and calculate the actual judgment of the actual inventory. If the actual inventory is the same as the actual inventory J: then it will be displayed according to the rotation conditions: ... Show price Lin '$ material number on different dates as shown in the U range of interest range with changing trends. The steps of inventory management include: 豕 point inventory analysis method, 『inventory quantity and amount of material』 f ^ material inventory quantity and gold 嚭 · inventory quantity during the period and 乂 1 and the profit range described in Item 13 Changes in the amount of moxibustion. The analysis steps include: an inventory analysis method, the inventory quantity and amount of the materials; different inventory age intervals, the total number of inventory age days for each total age age, and the amount of gold materials stored in f in different age intervals; and corresponding Inventory quantity and gold = The multiple-site transfer analysis steps described in item 13 of the range include: 7 car inventory analysis method, the inventory quantity and amount of materials; year and month and other data; turnover rate for the same year and month; ^ ~ Y single inventory turnover days inventory days; whether the inventory days are greater than the standard inventory days, and if the days are greater than the standard inventory days, then the number of days of birth and return is less than the standard inventory days, 3 no message; Φ% J 200525396 々, The scope of patent application, the analysis of the trend of the number of days of inventory 1H page 23