JP2021196714A - Individual product's sales quantity calculation device, individual product's sales quantity calculation method, and individual product's sales quantity calculation program - Google Patents

Abstract

To provide an individual product's sales quantity calculation device, an individual product's sales quantity calculation method, and an individual product's sales quantity calculation program, which can easily and accurately calculate the sales quantity on the day for individual product by using inventory information (the inventory quantity on the previous day for individual product and the inventory quantity on the present day for individual product).SOLUTION: The present embodiment includes (1) acquiring an inventory quantity on a previous day associated with a product code entered through a daily closing input screen from inventory data including the product code and the inventory quantity on the previous day, and (2) subtracting the inventory quantity on a present day entered through the daily closing input screen from the acquired inventory quantity on the previous day, thereby calculating the sales quantity on the present day of a product identified by the input product code.SELECTED DRAWING: Figure 3

Description

The present invention relates to a sales number calculation device for each product, a sales number calculation method for each product, and a sales number calculation program for each product.

Patent Document 1 discloses a shelf label system that can display various data even with an inexpensive shelf label display and can easily confirm the displayed contents (Patent Document 1). (Refer to paragraph 0005 of No. 1), and the sales volume is mentioned as one of the data (see paragraph 0029 of Patent Document 1).

Japanese Unexamined Patent Publication No. 2005-18583

In this way, in fields such as the retail industry, it is important to accurately grasp the number of sales for each product from the viewpoint of management analysis. However, for example, even if a store in a department store uses a cash register that has introduced POS (Point Of Sales), the cash register can only manage the number of sales for each product type, so in the end, the number of sales for each product is the store. There was a problem that the work load was very heavy because the person in charge of the calculation was done manually.

The present invention has been made in view of the above problems, and by using inventory information (the number of stocks on the previous day for each product and the number of stocks on the day for each product), the present invention can be easily and accurately performed on the day of each product. It is an object of the present invention to provide a sales number calculation device for each product, a sales number calculation method for each product, and a sales number calculation program for each product that can calculate the number of sales of the product.

In order to solve the above-mentioned problems and achieve the object, the product-specific sales number calculation device according to the present invention is a product-specific sales number calculation device provided with a control unit, and the control unit uses the product identification data and the previous day. From the inventory data including the previous day's inventory, which is the inventory for each product at the end of the period, the quantity acquisition means for acquiring the previous day's inventory associated with the product identification data input on the screen, and the quantity acquisition means. The input was made by subtracting the number of items in stock at the end of the day for the product specified by the input item identification data from the number of items in stock on the previous day, which is the number of items in stock on the day entered on the screen. It is characterized by providing a sales number calculation means for calculating the number of sales for each product on the day, which is the number of sales on the day of the product specified by the product identification data.

Further, in the sales number calculation device for each product according to the present invention, the quantity acquisition means is input to the screen from the arrival data including the product identification data and the number of arrivals on the day, which is the number of arrivals on the day for each product. The number of arrivals on the day associated with the product identification data is further acquired, and the number of arrivals on the day acquired by the quantity acquisition means is added to the number of stocks on the previous day acquired by the quantity acquisition means. It is characterized in that the number of sales by product on the day is calculated by subtracting the number of stocks on the day.

Further, in the sales number calculation device for each product according to the present invention, the quantity acquisition means is input to the screen from the movement data including the product identification data and the number of movements on the day, which is the number of movements on the day for each product. From the value obtained by further acquiring the number of movements on the day associated with the product identification data, and adding the number of movements on the day acquired by the quantity acquisition means to the total quantity acquired by the sales number calculation means by the quantity acquisition means. It is characterized in that the number of sales by product on the day is calculated by subtracting the number of stocks on the day.

In addition, the product-specific sales number calculation device according to the present invention manufactures the product specified by the input product identification data in the total of the quantities acquired by the sales number calculation means by the quantity acquisition means on the same day. It is characterized in that the number of sales by product on the day is calculated by subtracting the number of stocks on the day from the value obtained by adding the number of products manufactured on the day, which is the number and is input on the screen.

Further, in the sales number calculation device for each product according to the present invention, the control unit obtains a unit price associated with the product identification data input to the screen from the unit price master including the product identification data and the unit price for each product. By multiplying the unit price acquisition means to be acquired and the number of sales by product calculated by the sales number calculation means by the unit price acquired by the unit price acquisition means, the sales of the product specified by the input product identification data on the day It is characterized by further providing a sales amount calculation means for calculating the sales amount for each product on the day, which is the amount.

Further, in the sales number calculation device for each product according to the present invention, the total amount of sales on the day input by the control unit on the screen and the total amount of sales for each product on the day calculated by the sales amount calculation means are used. It is characterized by further providing a difference calculation means for calculating the difference between the two.

Further, the method for calculating the number of sales by product according to the present invention is a method for calculating the number of sales by product executed by an information processing apparatus provided with a control unit, and the product identification data executed by the control unit and the time point at the end of the previous day. From the inventory data including the previous day's inventory, which is the number of products in stock in, the quantity acquisition step to acquire the previous day's inventory linked to the product identification data entered on the screen, and the previous day's inventory acquired in the quantity acquisition step. The input product identification is performed by subtracting the number of products in stock at the end of the day for the product specified by the input product identification data from the number, which is the number of products in stock on the day entered on the screen. It is characterized by including a sales number calculation step for calculating the number of sales for each product on the day, which is the number of sales for the product specified in the data on the day.

Further, the product-specific sales number calculation program according to the present invention is a product-specific sales number calculation program to be executed by an information processing apparatus provided with a control unit, and is the product identification data and the previous day to be executed by the control unit. From the inventory data including the previous day's inventory, which is the inventory for each product at the end, the quantity acquisition step to acquire the previous day's inventory associated with the product identification data entered on the screen, and the quantity acquisition step. The input was made by subtracting the number of items in stock at the end of the day for the product specified by the input item identification data from the number of items in stock on the previous day, which is the number of items in stock on the day entered on the screen. It is characterized by including a sales number calculation step for calculating the number of sales for each product on the day, which is the number of sales on the day of the product specified by the product identification data.

According to the present invention, by using the inventory information (the number of stocks on the previous day for each product and the number of stocks on the day for each product), the effect that the number of sales on the day for each product can be calculated easily and accurately. Play.

FIG. 1 is a block diagram showing an example of the configuration of a sales number calculation device for each product. FIG. 2 is a diagram showing an example of a calculation image of the number of sales by product (number of over-the-counter sales) on the day. FIG. 3 is a diagram showing an example of a daily closing input screen. FIG. 4 is a diagram showing an example of the maintenance screen of the unit price master. FIG. 5 is a diagram showing an example of the relationship between the master and the data. FIG. 6 is a diagram showing an example of the generated sales data and the journal created based on the sales data.

Hereinafter, embodiments of the sales number calculation device for each product, the sales number calculation method for each product, and the sales number calculation program for each product according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment. Hereinafter, a specific configuration and operation will be described.

[1. composition]
An example of the configuration of the sales number calculation device 100 for each product according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the sales number calculation device 100 for each product.

The sales number calculation device 100 for each product is a commercially available desktop personal computer. The sales number calculation device 100 for each product is not limited to a stationary information processing device such as a desktop personal computer, but is not limited to a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like. It may be a portable information processing apparatus of.

The sales number calculation device 100 for each product includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the sales number calculation device 100 for each product is connected so as to be able to communicate with each other via an arbitrary communication path.

The communication interface unit 104 connects the sales number calculation device 100 for each product to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the sales number calculation device 100 for each product and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The data of various masters and the like described later may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). In addition to the keyboard, mouse, and microphone, the input device 112 can use a monitor that realizes a pointing device function in cooperation with the mouse. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 includes, for example, a unit price master 106a, inventory data 106b, arrival data 106c, movement data 106d, and sales data 106e. The relationship between the master and the data is as shown in FIG.

As shown in FIGS. 4 and 5, for example, the unit price master 106a includes product identification data (product code and product name), a unit price for each product (sales body unit price), an application start date, and an application end date. Etc. are included.

Although not shown, the inventory data 106b includes, for example, store identification data, a sales date, the product identification data, and the number of stocks on the previous day, which is the number of stocks for each product as of the end of the previous day. The number of stocks on the previous day in the inventory data 106b is accumulated daily. For example, when the store daily closing input is performed on 2/26, the inventory quantity at the end of 2/25 is stored in the inventory data 106b as the previous day inventory quantity. Then, when the daily closing input for the store on 2/26 is completed, the inventory quantity at the end of 2/26 is newly stored as the stock quantity on the previous day, so that the inventory data 106b is updated. Therefore, when the store daily closing input is performed on 2/27, the inventory quantity at the end of 2/26 is stored in the inventory data 106b as the stock quantity on the previous day.

Although not shown, the arrival data 106c includes, for example, an arrival date, the product identification data, and the number of arrivals on the day, which is the number of arrivals on the day for each product.

Although not shown, the movement data 106d includes, for example, a movement date, the product identification data, and the number of movements on the day, which is the number of movements on the day for each product. The number of movements on the day may be the number of movements to another store (that is, the number of movements and delivery) or the number of movements from other stores (that is, the number of movements and receipts).

As shown in FIG. 6, the sales data 106e includes, for example, the product identification data (product), the number of sales (sales number) by product on the day calculated by the sales number calculation unit 102c described later, the unit price, and the unit price described later. Includes the sales amount (sales amount) for each product on the day calculated by the sales amount calculation unit 102d, and the like.

The control unit 102 is a CPU or the like that collectively controls the sales number calculation device 100 for each product. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 functionally conceptually obtains, for example, (1) a unit price associated with the product identification data input on the screen from the unit price master including the product identification data and the unit price for each product. The day before the product identification data entered on the screen is linked from the inventory data including the unit price acquisition unit 102a as a means and (2) the product identification data and the previous day's stock quantity which is the stock quantity for each product at the end of the previous day. From the quantity acquisition unit 102b as a quantity acquisition means for acquiring the number of stocks and (3) the number of stocks on the previous day acquired by the quantity acquisition means, at the end of the day for the product specified by the input product identification data. Sales for calculating the number of sales by product on the day, which is the number of sales on the day of the product specified by the input product identification data, by subtracting the number of stock on the day, which is the number of stock and is entered on the screen. The input product identification data is obtained by multiplying the sales number calculation unit 102c as the number calculation means and (4) the number of sales by product on the day calculated by the sales number calculation means by the unit price acquired by the unit price acquisition means. The sales amount calculation unit 102d as a sales amount calculation means for calculating the sales amount for each product on the day, which is the sales amount on the day of the specified product, (5) the total sales amount on the day entered on the screen, and the sales. It is provided with a difference calculation unit 102e as a difference calculation means for calculating the difference between the total amount of sales for each product on the day calculated by the amount calculation means.

The unit price acquisition unit 102a is referred to as a screen of FIG. 3 (hereinafter referred to as a “daily closing input screen”) for performing a daily closing input business at a store from the unit price master 106a including the product identification data and the unit price. ) To get the unit price associated with the product identification data.

The quantity acquisition unit 102b acquires the previous day inventory number associated with the product identification data input to the daily closing input screen from the inventory data 106b including the product identification data and the previous day inventory quantity. Further, the quantity acquisition unit 102b may acquire the number of arrivals on the day associated with the product identification data input on the daily closing input screen from the arrival data 106c including the product identification data and the number of arrivals on the day. .. Then, the quantity acquisition unit 102b may acquire the number of movements on the day associated with the product identification data input to the daily closing input screen from the movement data 106d including the product identification data and the number of movements on the day. ..

The number of sales calculation unit 102c is the number of stocks on the day (the number of stocks at the end of the day for the products specified by the product identification data input on the daily closing input screen) from the number of stocks on the previous day acquired by the quantity acquisition unit 102b. By subtracting (the one entered in the daily closing input screen), the number of sales by product on the day, which is the number of sales of the product specified by the product identification data entered in the daily closing input screen, is the number of sales on the day. Is calculated. That is, the formula for calculating the number of sales by product on the day described in this paragraph is simply "the number of stocks on the previous day-the number of stocks on the day".

When the quantity acquisition unit 102b acquires the same-day arrival quantity, the sales quantity calculation unit 102c adds the same-day arrival quantity acquired by the quantity acquisition unit 102b to the previous-day inventory acquisition acquired by the quantity acquisition unit 102b to obtain the same-day arrival quantity. By subtracting the number of stocks, the number of sales by product on the day may be calculated. That is, the formula for calculating the number of sales by product on the day described in this paragraph is simply "the number of stocks on the previous day + the number of arrivals on the day-the number of stocks on the day".

When the quantity acquisition unit 102b acquires the number of movements on the day, the sales number calculation unit 102c adds the number of movements on the day acquired by the quantity acquisition unit 102b to the total of the quantities acquired by the quantity acquisition unit 102b. By subtracting the number of stocks, the number of sales by product on the day may be calculated. That is, the formula for calculating the number of sales by product on the day described in this paragraph is simply "the number of stocks on the previous day + the number of movements on the day-the number of stocks on the day" or "the number of stocks on the previous day + the number of arrivals on the day". + The number of movements on the day-The number of stocks on the day ".

The number of sales calculation unit 102c is the total number of products manufactured on the day (the number of products manufactured on the day for the product specified by the product identification data input to the daily closing input screen) in the total of the quantities acquired by the quantity acquisition unit 102b. The number of sales by product on the day may be calculated by subtracting the number of stocks on the day from the value obtained by adding (the one entered on the daily closing input screen). That is, the formula for calculating the number of sales by product on the day described in this paragraph is simply "the number of stocks on the previous day + the number of products manufactured on the day-the number of stocks on the day" and "the number of stocks on the previous day + the number of arrivals on the day". Number + Number of production on the day-Number of stock on the day "," Number of stock on the previous day + Number of movement on the day + Number of production on the day-Number of stock on the day "or" Number of stock on the previous day + Number of arrival on the day + Number of movement on the day + The number of products manufactured on the day-The number of products in stock on the day ".

The sales amount calculation unit 102d is specified by the product identification data input to the daily closing input screen by multiplying the number of sales by product on the day calculated by the sales number calculation unit 102c by the unit price acquired by the unit price acquisition unit 102a. Calculate the sales amount of each product on the day, which is the sales amount of the product on the day.

The difference calculation unit 102e calculates the difference between the total sales amount input on the daily closing input screen and the total sales amount for each product on the day calculated by the sales number output unit 102d.

[2. Specific example of processing]
In this item, a specific example of the process according to this embodiment will be described. In the daily closing input screen of FIG. 3, characters and numerical values with dot-shaped hatches mean that the information is automatically displayed, and the numerical values shown in white are the information input by the operator. Means. The input order of the information to be input is not limited to the input order in the following description.

From the daily closing input screen in Fig. 3, the store code "100", the base date "2020/02/26", the input staff code "100" and the sales date "2020/02/26" are input by the operator in the header part. And, it is assumed that the product code "SH001, SO002 and SH003" is input by the operator in the detail part. Hereinafter, for convenience of explanation, a method of calculating the number of sales and the sales amount of the product "○ × chocolate (2 pieces)" having the product code "SH001" will be specifically described.

The unit price acquisition unit 102a acquires 500 yen as a unit price associated with the input product code "SH001" from the unit price master 106a (assumed to be shown in FIG. 4), and inputs the daily closing in FIG. Set in the "Unit price" column of the details of the product code "SH001" on the screen.

Further, the quantity acquisition unit 102b acquires 100 as the previous day inventory quantity associated with the input product code "SH001" from the inventory data 106b including the product code "SH001" and the previous day inventory quantity 100. Set in the column of "remaining number on the previous day" of the details of the product code "SH001" on the daily closing input screen of FIG. Further, the quantity acquisition unit 102b acquires 50 as the number of arrivals on the day associated with the input product code "SH001" from the arrival data 106c including the product code "SH001" and the number of arrivals on the day 50. Set in the "Number of arrivals" column of the details of the product code "SH001" on the daily closing input screen of FIG.

Then, in the column of the "manufactured number" of the specification of the product code "SH001" on the daily closing input screen of FIG. 3, "120" is input by the operator as the manufactured number on the day. Further, in the column of "remaining number on the day" of the details of the product code "SH001" on the daily closing input screen of FIG. 3, "50" is input as the number of stocks on the day.

When the above set and input are made, the sales number calculation unit 102c calculates the number of over-the-counter sales of the product "○ × chocolate (2 pieces)" of the product code "SH001" on the day of the previous day, the remaining number 100 + the number of arrivals 50 + the number of production. 120-Calculate that the remaining number on the day is 50 = 220. Subsequently, the sales amount calculation unit 102d acquired the over-the-counter sales amount of the product "○ × chocolate (2 pieces)" of the product code "SH001" to the calculated over-the-counter sales number 220 by the unit price acquisition unit 102a. By multiplying the unit price by 500 yen, it is calculated as 110,000 yen.

By performing the same calculation, a detailed explanation will be omitted, but as shown in FIG. 3, the sales number calculation unit 102c is used at the storefront of the product “○ × chocolate (4 pieces)” with the product code “SH002”. The number of sales is calculated as 150, the number of over-the-counter sales of the product "○ × chocolate (6 pieces)" with the product code "SH003" is calculated as 55, and the sales amount calculation unit 102d is the product code "SH002". The over-the-counter sales amount of the product "○ × chocolate (4 pieces)" of the product "○ × chocolate (4 pieces)" is calculated as 150,000 yen, and the over-the-counter sales amount of the product "○ × chocolate (6 pieces)" of the product code "SH003" is 82. , 500 yen. FIG. 6 shows sales data 106e including the product name, the number of over-the-counter sales on the day, the unit price, and the over-the-counter sales amount on the day for the above three products. Further, FIG. 6 shows an example of a journal entry created based on the sales data 106e of FIG.

Subsequently, it is assumed that "341,500 yen" is input as the cash register amount (excluding tax) and "27,320 yen" is input as the cash register tax amount on the daily closing input screen of FIG. The difference calculation unit 102e is the estimated total cash register sales in FIG. 3 corresponding to the input cash register amount (tax excluded) "341,500 yen" in FIG. 3 and the total amount of over-the-counter sales of the three products on the day. The difference between the amount (tax excluded) "342,500 yen" and the cash register difference (tax excluded) "1,000 yen" in FIG. 3 is calculated. The operator can determine that the store with a large difference is a store with a large amount of disposal or discount sales, and can use it for management analysis.

Finally, as a supplement, the meaning of each item in the daily closing input screen of FIG. 3 will be described. On the daily closing input screen of FIG. 3, the unit price, the number of remaining items on the previous day, the number of arrivals, and the number of movements are automatically displayed as the contents input from another program. Specifically, the unit price is the acquisition of the unit price of the unit price master 106a, the remaining number on the previous day is the display of the remaining number on the day registered from the daily closing process input on the previous day, and the number of arrivals is the head office. It shows the total of the number of arrivals from and the number of purchases from suppliers, and the number of movements is the number of movements to other stores (negative number due to the issue factor) and the number of movements from other stores (receipt). It is a positive number because of the element). Further, on the daily closing input screen of FIG. 3, the number of manufactured products is calculated from the daily closing process input, and specifically, the quantity of the manufacturing results input on the day in the store kitchen is input. be. Then, on the daily closing input screen of FIG. 3, the over-the-counter sales amount is calculated based on the input result, and specifically, is a value calculated by the formula of unit price × number of over-the-counter sales. Further, on the daily closing input screen of FIG. 3, the cash register amount (excluding tax) is the input of the cash register amount excluding tax, and the cash register tax amount is the input of the cash register tax amount, and the estimated total cash register sales amount. (Tax excluded) is the automatic display of the total over-the-counter sales amount, and the over-the-counter sales tax amount is the automatic display of the estimated total sales amount (tax excluded) x consumption tax rate, and the cash register difference (tax excluded). Is the automatic display of the difference between the cash register amount (tax excluded) and the estimated total cash register sales amount (tax excluded), and the cash register difference tax amount is the automatic display of the difference between the cash register tax amount and the over-the-counter sales tax amount.

[3. Summary of this embodiment]
As described above, according to the sales number calculation device 100 for each product according to the present embodiment, by using the inventory information (the number of stocks on the previous day for each product and the number of stocks on the day for each product), it is simple and accurate. In addition, the number of sales on the day for each product can be calculated.

Here, in the past, there was a problem that it was difficult to introduce a POS as a single item because it was a transaction of digestive purchase at a department store and the introduction of POS was used in combination with a department store cash register. Also, at department store cashiers, management by variety (cakes, gifts, etc.) was the limit. Further, there is also a problem that the management of the number of sold products (for example, cake) as a single item can only be managed manually each time the product is sold.

Therefore, in the present embodiment, for example, instead of taking the sales record from the store cash register, the number of product sales can be calculated by calculating the balance of the previous day + the arrival of the day-the balance of the day. In other words, by taking an inventory of the remaining number of products by product at the store, it is possible to capture the sales performance by product. More specifically, as shown in Fig. 2, the over-the-counter sales shown by hatching in Fig. 2 can be calculated by subtracting the remaining number on the day from the total of the remaining number, the manufacturing number, the arrival number, and the moving arrival number the other day. I made it.

In this way, by making it possible to manage the sales of individual products, for example, it is possible to grasp the sales of each product and the best-selling products, which leads to product development, and also manage the profit of each product to make a profit. It is possible to promote sales of a wide range of products and lead to increased profits. Further, for example, it can be determined that a store having a large difference between "number of product sales x fixed price" and "registration amount" is a store that sells a lot by discarding or discounting.

[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all the processes described as being performed manually may be performed. Alternatively, a part thereof can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the sales number calculation device 100 for each product, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the sales number calculation device 100 for each product, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and sales by product are required. It is read mechanically by the number calculation device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the sales number calculation device 100 for each product via an arbitrary network, and all or part of the computer program may be downloaded as needed. Is also possible.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the sales number calculation device 100 for each product may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. .. Further, the sales number calculation device 100 for each product may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Furthermore, the specific form of distribution / integration of the device is not limited to the one shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is useful, for example, in an industry that develops department store stores and handles a wide variety of products.

100 Sales number calculation device for each product 102 Control unit
102a Unit price acquisition department
102b Quantity acquisition unit
102c Sales number calculation unit
102d Sales amount calculation unit
102e Difference calculation unit 104 Communication interface unit 106 Storage unit
106a Unit price master
106b Inventory data
106c arrival data
106d moving data
106e Sales data 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (8)

It is a sales number calculation device for each product equipped with a control unit.
The control unit
A quantity acquisition method for acquiring the previous day's inventory number associated with the product identification data entered on the screen from the inventory data including the product identification data and the previous day's inventory quantity, which is the inventory quantity for each product at the end of the previous day.
From the number of stocks on the previous day acquired by the quantity acquisition means, the number of stocks on the day, which is the number of stocks at the end of the day for the product specified by the input product identification data and is input on the screen, is subtracted. As a result, a sales number calculation means for calculating the number of sales by product on the day, which is the number of sales on the day of the product specified by the input product identification data,
To prepare for
A sales number calculation device for each product. The quantity acquisition means is
From the arrival data including the product identification data and the number of arrivals on the day, which is the number of arrivals on the day for each product, the number of arrivals on the day associated with the product identification data input on the screen is further acquired.
The sales number calculation means is
To calculate the number of sales by product on the day by subtracting the number of stocks on the day from the value obtained by adding the number of stocks on the day acquired by the quantity acquisition means to the number of stocks on the previous day acquired by the quantity acquisition means.
The sales number calculation device for each product according to claim 1. The quantity acquisition means is
From the movement data including the product identification data and the number of movements on the day, which is the number of movements on the day for each product, the number of movements on the day associated with the product identification data input on the screen is further acquired.
The sales number calculation means is
To calculate the number of sales by product on the day by subtracting the inventory quantity on the day from the value obtained by adding the number of movements on the day acquired by the quantity acquisition means to the total quantity acquired by the quantity acquisition means.
The sales number calculation device for each product according to claim 1 or 2. The sales number calculation means is
From the sum of the total quantity acquired by the quantity acquisition means and the number of products manufactured on the day of the product specified by the input product identification data, which is the number of products manufactured on the day entered on the screen. , Calculate the number of sales by product on the day by subtracting the number of stocks on the day.
The device for calculating the number of sales by product according to any one of claims 1 to 3, wherein the device is characterized by. The control unit
A unit price acquisition means for acquiring a unit price associated with the product identification data input on the screen from a unit price master including the product identification data and the unit price for each product.
By multiplying the number of sales by product on the day calculated by the sales number calculation means by the unit price acquired by the unit price acquisition means, the sales by product on the day, which is the sales amount of the product specified by the input product identification data, on the day. Sales amount calculation method to calculate the amount and
To prepare further,
The device for calculating the number of sales by product according to any one of claims 1 to 4, wherein the device is characterized by. The control unit
Further provided with a difference calculation means for calculating the difference between the total sales amount of the day entered on the screen and the total sales amount of each product on the day calculated by the sales amount calculation means.
5. The sales number calculation device for each product according to claim 5. It is a method of calculating the number of sales by product executed by an information processing device equipped with a control unit.
Executed by the control unit,
From the inventory data including the product identification data and the previous day's inventory quantity, which is the inventory quantity for each product at the end of the previous day, the quantity acquisition step to acquire the previous day's inventory quantity associated with the product identification data entered on the screen, and the quantity acquisition step.
From the number of stocks on the previous day acquired in the quantity acquisition step, the number of stocks on the day, which is the number of stocks at the end of the day for the product specified by the input product identification data and is input on the screen, is subtracted. By doing so, the sales number calculation step for calculating the sales number for each product on the day, which is the sales number on the day of the product specified by the input product identification data, and
To include,
A method of calculating the number of sales by product, which is characterized by. It is a sales number calculation program for each product to be executed by an information processing device equipped with a control unit.
To make the control unit execute
From the inventory data including the product identification data and the previous day's inventory quantity, which is the inventory quantity for each product at the end of the previous day, the quantity acquisition step to acquire the previous day's inventory quantity associated with the product identification data entered on the screen, and the quantity acquisition step.
From the number of stocks on the previous day acquired in the quantity acquisition step, the number of stocks on the day, which is the number of stocks at the end of the day for the product specified by the input product identification data and is input on the screen, is subtracted. By doing so, the sales number calculation step for calculating the sales number for each product on the day, which is the sales number on the day of the product specified by the input product identification data, and
To include,
A program for calculating the number of sales by product.

Images