JP7277898B2 - Sales information analysis device for cash registers - Google Patents

Description

TECHNICAL FIELD The present invention relates to an apparatus for analyzing sales information using information stored in a storage device built into cash register equipment such as a cash register.

In general, accounting information related to corporate management includes balance sheets, profit and loss statements, and cash flow statements, which are prepared based on bookkeeping accounting. Without knowledge of bookkeeping and accounting, it was difficult to easily judge the state of management. For this reason, an accounting information management system has been developed that facilitates business analysis (see Patent Literature 1).

However, large companies that can allocate specialist staff to handle accounting work can also use the above accounting information management system. In restaurants and retail stores, the accounting work itself was a burden, and it was not possible to perform the accounting work frequently. In addition, when operating multiple stores, in order to grasp the business status of the entire company in addition to the business status of each store, it is necessary to perform accounting work for the entire company in addition to the accounting work for each store. was an even greater burden.

Therefore, the data input to the electronic cash register and POS (Point of Sale) system installed in restaurants and retail stores is sent to the host computer, and the host computer manages the business status of each store, and the entire company. Various processing apparatuses have been developed for the purpose of managing the business status of the company (see Patent Documents 2 and 3).

JP 2005-250914 A JP 2015-153386 A Japanese Patent No. 6042506

The technology disclosed in Patent Document 2 cited above is a system for trade area analysis, for example, for analyzing what kind of products and services are sold in a certain area, By analyzing the linked sales information, it was intended to obtain information that would be useful in considering store opening plans and sales promotions.

In addition, the technology disclosed in Patent Document 3 mentioned above manages and analyzes sales for each food and drink menu in a restaurant, and by setting the profit rate for each food and drink menu, it is possible to calculate the profit of the entire store and , to analyze the degree of contribution to profit for each food and drink menu, and to obtain information that can be used as a reference for improving profitability.

Both of the above technologies are intended to process a large amount of information and attempt to select an average product or service from a wide variety of information. It wasn't for analysis.

However, in restaurants or retail stores operated by small and medium-sized enterprises, the current business method contributes to the overall profit, or the products or In many cases, naive information analysis was required, such as whether the service did not exist, and what was the actual situation during the busy season and the off-season. However, with the techniques disclosed in the above patent documents, it is impossible or insufficient to analyze such information, and the actual situation is that desired information cannot be obtained.

The present invention has been made in view of the above-mentioned points, and its object is to use the functions of the money register device and to check the business status based on the information available from the money register device. It is to provide a device that can be analyzed.

Therefore, the present invention relating to a sales information analysis apparatus provides an input means for inputting information stored in the storage device from a cash register, a POS system, or other money registering device having at least a storage device, and an input means. storage means for storing input information stored in the storage means; processing means for performing processing for calculating necessary data based on the input information stored in the storage means; and output means for outputting the data processed by the processing means wherein the input information includes amount information input when using the money register device, time information related to the input time of the amount information, and products associated with the amount information. or related information related to services, and the processing means performs arithmetic processing of sales information related to profit and profit rate based on the related information from the amount information for each preset period. It is.

According to the above configuration, it is possible to obtain profit, profit rate, and other sales information by performing arithmetic processing from amount information and related information for a specific period that can be organized by time information built into the cash register device. . For example, you can get figures such as total sales amount and net profit for the term ending September 2018. This specific period can be set in units of weeks instead of months, and by setting the units of weeks in advance, it is possible to calculate several weeks of a specific month in units of weeks. In this case, the related information can be calculated separately for profitable products and unprofitable products by associating them with individual products or services.

In the invention having the above configuration, the related information includes individual product names or service names, types of products or services, arbitrary product groups or service groups, and location classifications of products or services on which the price information is based. and payment terms, and the processing means includes information on the individual product name or service name, product or service type, arbitrary product group or service group, product or service location classification and payment terms The amount information may be calculated based on.

In the case of such a configuration, it is possible to calculate the sales amount for each product name and type as the related information, and to output the deficit product and the profitable product for each product. Moreover, by setting arbitrary groups (groups) of products, etc., it is also possible to obtain profitability information for each group. These can be limited to output for each specific period as described above. The related information is limited to the range set in the money registration device, but normally all or part of this information is used as related information according to the product number etc. given to the product, etc. It can be input from time to time and stored in a storage device.

The invention having the above configuration may further include operation means for inputting a command signal for causing the processing means to execute a predetermined calculation, and the command signal input from the operation means may including a selection signal that selects individual information included in the information and a limited signal that limits the period to be processed, the processing means for each limited period based on the command signal input by the operation means The configuration may be such that the processing of accumulating the sales amount included in the amount information is performed while classifying the individual information.

In the case of such a configuration, a command signal can be given from the operating means to the processing means, and when the command signal selects specific individual information in the related information, You can get the sales amount you want. For example, when the individual information is a group of products or a group of services, it is possible to calculate the sales status of each group for each predetermined period, and to grasp the chronological transition of sales. In addition, when the location classification is used as the specific information, if the location classification is by store, the sales transition for each store can be output, and the product display at a specific store with the location classification can be output. In the case of location, it is also possible to output the transition of sales for each display location.

The invention having the above configuration may further include input means for inputting sales-related information that cannot be obtained from the money registration device, and the sales-related information is store information related to the store where the money registration device is installed. , fixed cost information for each store, labor cost information for the store, information on costs or purchases for each individual product or service handled by the store, and holiday information for each store, and the processing means includes The gross profit, net profit, and profit rate may be calculated for each limited period of time based on the command signal input from the operating means.

In the case of such a configuration, various related information can be input based on the information stored in the storage device of the cash register device. For example, a general money registering device contains time information, money amount information, product number, operator name, etc., and cannot input the cost price of individual products, labor costs, and the like. Therefore, by inputting the cost of goods, etc. linked to the product number information, it becomes possible to calculate the gross profit for the sales of the relevant goods. It is also possible to calculate the net profit.

In addition, in the case of the above configuration, the processing means calculates gross profit, net profit and profit rate on a weekly basis, a monthly basis, a quarterly basis, a semi-annual basis and a yearly basis based on the time information. The busy season and off-peak season may be calculated based on the sales volume of the set product or service.

In the case of the above configuration, the number of sales of goods or services set in advance is used as a standard (threshold), and if the sales amount exceeds the threshold, it is determined as a busy season, and if it is less than the threshold, it is determined as a low season. can judge. This threshold can be set to two types, an upper limit value and a lower limit value, and if the state exceeding the upper limit value is determined as a busy season and the case below the lower limit value is determined as a low season, the range from the lower limit value to the upper limit value The period within is judged to be the normal period. By judging the above-mentioned busy season and off-season, it is possible to increase or decrease the number of employees in charge, resulting in efficient product sales, etc., and a guideline for correcting excessive staff allocation. can be.

The present invention relating to a program for analyzing sales information is a computer program for analyzing sales information that causes a computer to function as processing means, stores various information input from a cash register device, and among the stored information, Profit ratio and profit are calculated based on information on the date and time entered for each store, information on the amount, information on sales products or services, and information on the cost entered in advance, and according to the items set by the user, It is characterized by outputting the profit rate and profit amount for the entire store or for each product or service for each hour, day, week, month, quarter, half year, or year.

According to the above configuration, the computer can analyze the sales information based on the information stored in the storage device of the cash register device.

According to the sales information analysis apparatus of the present invention, it is possible to analyze the business status based on the information available from the money register device while using the functions of the money register device. According to the present invention relating to a program, the analysis of the business conditions can be processed by a computer.

It is an explanatory view showing an embodiment of the invention concerning a sales information analysis device. It is explanatory drawing which shows the processing flow by embodiment of a sales information analysis apparatus. It is explanatory drawing which shows the processing flow by embodiment of a sales information analysis apparatus. It is explanatory drawing which shows the processing flow by embodiment of a sales information analysis apparatus.

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 shows an embodiment of the present invention relating to a sales information analysis device. As shown in this figure, the sales information analysis apparatus 1 of this embodiment has an input interface (input means) 11, which enables input of information stored in an external storage device. As for the input method, in addition to transmission via the Internet line, direct input using media is also possible.

The sales information analysis apparatus 1 also includes a storage unit (storage means) 12 and a processing unit (processing means) 13. The storage unit 12 can store information input via the input interface 11. In addition, the information processed by the processing unit 13 can be stored again.

The sales information analysis device 1 is provided with an output module (output unit) 14, which outputs the processing information processed by the processing unit 13 in an appropriate state to an external output device (monitor, etc.) 15 and displays it on the monitor 15. You can check the processed result.

Further, the sales information analysis apparatus 1 is provided with an input module 16 so that various information and commands can be input to the processing section 13 . A general-purpose input device (keyboard, etc.) 17 is used for input.

The information input from the input device (keyboard, etc.) 17 includes first information for initial setting and second, a command signal for changing the calculation format. The initial setting information can include various types of information depending on the method of linking with the product number (or product name or service name) of the product or service (hereinafter sometimes referred to as product or the like). For example, there are the name of each product etc., the type of product etc., the group of products etc. (product group or service group), place of sale etc. and payment terms. The terms of payment are usually cash, but mean the type of payment method such as point reduction or gift certificate. In addition, for each product, etc., the purchase amount (cost price, etc.), transportation costs, and other costs included in the cost calculation can be initially set. Furthermore, fixed costs, labor costs, etc. can be initially set in order to grasp the overall profit.

Various command signals such as selection signals and limiting signals that affect the output format can be input from the input device (keyboard, etc.) 17 . The selection signal is a signal for commanding to calculate and output information centered on information related to products among the information to be output. In this case, it is a signal for commanding arithmetic processing in the period. These signals instruct the processing unit 13 to change the default output format. Such instructions are also used when setting thresholds for determining busy periods and off-peak periods. This is also a command for changing the output format, and the amount of sales or the total number of sales can be used as a threshold.

Here, the information input from the money register device generally includes the following items.

In the above table, the important items are the date and time, product number and amount of money, and the date and time, which is time information, has a particularly important meaning. In other words, in the date and time (time information), a specific time on a specific date entered using the money register device is recorded, and it is possible to specify which products, etc., were sold for how much money at that time. It is from. For example, it is easy to calculate the total number of products, etc. sold in a given day and the total amount of sales by aggregating the above-mentioned input information, but the time of day is important for analyzing changes in each hour of the day. Become. Similarly, when analyzing on a weekly, monthly, or yearly basis, each information such as day, month, and year included in the date and time information is important.

Acquiring information about the product number is important in calculating the profit and profit rate for the sales amount. This is because the profit rate varies depending on the type of product, so there are cases where a large amount of profit is generated compared to the amount of sales, and conversely, little profit is generated.

Note that the input interface (input unit) 11, storage unit (storage means) 12, processing unit (processing means) 13, output module (output unit) 14, monitor (output device) 15, keyboard (operation means) 16 and For the input module 17, a general-purpose computer and its peripherals can be used. A mouse pointer may also be used as the operation means (or input means), and operations or inputs by these operation/input means 16 are performed while referring to various operation screens or input screens displayed on the monitor 15. be able to.

Here, a procedure for processing various information by the sales information analysis device 1 according to this embodiment will be described. Here, it is assumed that necessary initial information has been input in advance. In other words, information such as the purchase price for each product number and the grouping of products has already been registered. Also, the information from the money registration device has already been entered.

FIG. 2 shows a general processing flow. As shown in this figure, when the processing by the sales information analysis device is started, information is first read out from the storage unit (S101). The information read here is the hourly sales information as shown in Table 1 above. Subsequently, related information set for each product number is read (S102). The information read out here is the information input at the time of initial setting, such as the cost of products and the like, groups, and the like.

Here, the read various information is stored again in the storage section with the individual information for the product number added for each input time (S103). By this re-registration, the information can be processed (calculated) in accordance with a predetermined output format. For example, when outputting the amount of sales and the amount of profit for a specific day, the total amount of profit can be calculated by accumulating the sales amount and the cost for the information that has time information for that specific day. can. Then, such an output format is read out (S104), calculation is performed in accordance with the output format (S105), and the calculation result is output (S106).

In the above output format, the default setting outputs the total amount of sales, the total amount of purchases, the total amount of fixed costs and personnel expenses, and the total amount of profits in a specific period (for example, the most recent month). When the specific period is less than one month (for example, weekly), monthly costs such as fixed costs and personnel costs can be calculated on a per diem basis and then multiplied by each week.

In the case of output according to the processing flow as described above, it is possible to output transitions for each week or day for the corresponding month. It is also possible to output transitions for each hour of the corresponding day. When outputting, the amounts may be listed as numerical values, but it is also possible to output them in graph form. This is because the graphical output is easy to understand when the transition of sales and the like is visually displayed, and the enumeration of numerical values is preferable when the specific amount of profit is grasped.

By outputting the sales amounts and the like in various formats in this way, it becomes possible to objectively analyze the business conditions. In particular, by outputting on a yearly basis, it is possible to determine whether there is a surplus or a deficit throughout the year, and also to know the period of surplus and the period of deficit on a monthly or weekly basis. Also, even if the company is in the black, it will be possible to grasp the period when the profit is huge and the period when the profit is very small.

Next, a case where a command signal for arithmetic processing is given will be described. FIG. 3 shows a processing flow when a command signal is input. In this case, the process from reading from the storage unit (S201) to reading the output format (S204) is the same as in the general process described above.

If the command signal is provided, when the output format is read, the presence or absence of the command signal is determined because the output format has been changed (S205). If there is no command signal, arithmetic processing is performed in an output format based on a normal default format, and output is performed in that format (S206, S207). Incidentally, in reality, it is easy to determine whether or not the output format has been changed from the default, and read out the changed portion. Here, the presence and content of the command signal will be described.

If there is a command signal, first read out all of the command signal (S211). It is determined whether the selection signal exists from the read command signal (S212). This is to distinguish between the selection signal and the limitation signal, since the command signal includes the selection signal and the limitation signal. Since one of them does not have priority, it may be read from the limited signal, but here the selection signal is given priority.

If there is no selection signal, it is further determined whether or not there is a limiting signal (S213). At this time, if the limiting signal does not exist, the existence of other command signals is considered, but here, it is assumed that no special command signal exists, and the default format of calculation and output is performed. (S206, S207). If another type of command signal is added, the other command signal may be determined here.

If there is a limited signal, read out only the limited signal again (S214), set a specific period (S215), and perform calculations in a predetermined output format reflecting this (S216). The calculation result is output by the output unit (S217). In this case, the output information is sales information for a limited period such as yearly or weekly, and can be confirmed on the monitor.

Also, when there is a selection signal, it is determined whether or not there is a limiting signal (S223). This is because there may be a qualifying signal in addition to the selection signal. If the limited signal exists, the selection signal and the limited signal are read again (S223), and a specific period for the individual information in the selected related information is set according to these signals (S225). Then, calculation is performed in an output format reflecting these settings (S216), and the result is output (S217).

Furthermore, when the selection signal exists but the limitation signal does not exist, only the selection signal is read again (S234), and the individual information in the related information in the default period is set (S235). It is calculated based on the output format reflecting this setting (S216) and is output (S217).

As mentioned above, when a command signal to change the output format is given, in addition to arithmetic processing for a specific period, arithmetic processing for each specific individual information is performed to extract from the huge amount of information related to sales It is possible to confirm changes, transitions, etc. of desired information.

Next, a processing procedure according to the present embodiment when a default reference value for determining a busy season or the like is set in advance will be described. FIG. 4 shows the processing flow when the index indicating the busy season, the index indicating the off-peak season, or both of them are set in advance in the default settings. For each index, arbitrary conditions such as the amount of sales, the number of sales, or the number of input data can be set. By inputting these indices as thresholds, it is possible to perform processing related to busy periods and the like.

The processing procedure in this case is the same as the general processing described above, from reading from the storage unit (S301) to reading the output format (S304). After completing these procedures, it is determined whether or not the threshold value (index) is set (S305). If no threshold value is set, calculation is performed in a normal default format (S306) and output (S307).

On the other hand, if a threshold (index) is set, it is determined whether or not the number of thresholds to be set is two (S311). If two thresholds are set, it means that the index for distinguishing between the busy season and the off-season is set individually. This is because it means that an index has been set for classifying into two categories.

Therefore, when the number of thresholds is two, first the first threshold is read (S312). Here, the first threshold is defined as an index for the busy season. Therefore, by reading the first threshold, it is possible to determine that a period exceeding the threshold (specific time or duration) of the specific period (default period or arbitrary period based on the command signal) is the busy season ( S313). Furthermore, continuously, the second threshold value is read (S314). Since this second threshold is an index that indicates the boundary with the off-season, it is possible to determine that a period (specific time or duration) that is equal to or less than this second threshold is the off-season (S315). At the same time, it is also possible to determine a so-called normal period that does not belong to any of the periods (S315). When these determinations are finished, the results of these determinations are reflected in the output format and output (S307) together with the calculation results (S306).

On the other hand, if the number of thresholds is other than the above (ie, single), the threshold is read out (S322), and the period (specific time or duration) indicating the threshold value or more and less than the threshold value is used to divide the busy season and the off season. Determine (S325). Also in this case, these determination results are reflected in the output format and output (S307) together with the calculation results (S306).

The output of the busy season and the off-peak season does not require a special output format, and when output in the above output format, the corresponding period may be displayed on the monitor in a color-coded format. At this time, if attention is paid to staffing during the off-peak season, by displaying working staff as a selection signal in the command signal, it can be used as a material for determining whether or not staffing is appropriate. In addition, by aggregating this over a plurality of years, it is also possible to grasp the seasonal busy season or off-peak season. Furthermore, by comparing the profit (amount or rate) in the busy season and the profit (amount or rate) in the off-season, grasp the relationship between the busy state or the off-peak state and the increase or decrease in profit. is also possible.

By grasping this information by themselves, users can help find not only the need for management improvement, but also the specific means for doing so.

Although the embodiment of the present invention is as described above, the above embodiment shows an example of the present invention, and the present invention is not limited to the above embodiment. Therefore, each element of the above embodiment can be changed as appropriate. For example, command signals, particularly selection signals, other than those exemplified above may be selected, and detailed information may be input in advance for default settings.

1 sales information analysis device 11 input interface (input unit)
12 storage unit (storage means)
13 processing unit (processing means)
14 Output module (output section)
15 Monitor (output device)
16 keyboard (operating means)
17 Input module

Claims (2)

an input interface for inputting information stored in the storage device from a cash register having at least a storage device; storage means for storing input information input via the input interface; Processing means for performing processing for calculating necessary data based on stored input information, output means for outputting the data processed by the processing means, and for causing the processing means to execute predetermined calculations and an input means for inputting sales-related information that cannot be acquired from the cash register, wherein
The input information includes amount information entered when using the cash register , time information related to the input time of the amount information, and related information related to products or services associated with the amount information,
The related information that can be acquired from the cash register includes individual product names or service names, types of products or services, arbitrary product groups or service groups, location classification of products or services, and payment It is information related to the conditions,
The sales-related information that cannot be acquired from the cash register includes store information related to the store where the cash register is installed, fixed cost information for each store, personnel cost information for each store, individual products or services handled at the store Information on costs or purchases, and information on closed days for each store,
The command signal input from the operation means is a selection signal for selecting individual information included in the related information and a limitation signal for limiting a period to be processed,
The input interface is for directly inputting information obtainable from the cash register from media,
The processing means performs arithmetic processing on the sales information based on the related information from the amount information for each period set in advance. The amount information is calculated based on the product group or service group, the location classification of the product or service, and the payment terms, and the individual information is displayed for a limited period based on the command signal input by the operation means. Gross profit, net profit, and profit rate are calculated for each limited period of time based on the process of accumulating the sales amount included in the amount information while dividing, and the command signal input from the operation means. to calculate
A sales information analysis device for a cash register characterized by: Based on the time information, the processing means calculates gross profit, net profit and profit rate on a weekly, monthly, quarterly, semi-annual and yearly basis, and calculates a predetermined sales volume of goods or services. 2. The sales information analyzing apparatus for a cash register according to claim 1, wherein the busy season and the off-season are calculated based on .

Images