JP5883597B2 - Money management device and change reserve calculation program - Google Patents

Description

This invention relates to money management instrumentation 置及 beauty change fund calculation program capable of calculating an appropriate number of the change fund to be loaded into the money handling apparatus before operating the start of the store efficiently.

  Conventionally, in a store such as a supermarket, a money processing apparatus and a cash register (hereinafter referred to as a cash register) that deposit and process a money that a customer pays as a price for purchasing a product and withdraws a change that is a difference between the money and the price of the product. Both are collectively referred to as “cash registers”). The cash register is loaded with a change reserve for each denomination in advance before starting the store.

  For this reason, when there is sufficient change reserve in the cash register, there will be no shortage of change during the store's business hours, so a smooth settlement service can be provided to the customer. However, it is not desirable for the business management of the store to load more cash reserves than necessary into the cash register. On the other hand, if there is not enough change reserve in the cash register, there will be a shortage of change during the store's business hours, and it will be necessary to replenish the change reserve during business hours. Undesirable from the viewpoint.

  From these facts, there is known a conventional technique for calculating the number of change reserves to be loaded into a cash register before the start of business at a store. For example, in Patent Document 1, the amount of money in a cash register is obtained for each denomination, the amount of money found is stored for each transaction, and the difference between the maximum and minimum values of money stored is stored. Has been disclosed. Further, Patent Document 2 discloses a technique for calculating the amount of change reserve for each denomination by obtaining the amount of money per day for a predetermined period for each denomination and multiplying the standard deviation of the amount by a predetermined constant. Is disclosed.

JP 2009-9450 A JP 2008-269150 A

  However, if the difference between the maximum value and the minimum value of money stock is used as the number of change reserves as in Patent Document 1, the number of change reserves may be excessive or insufficient during business hours. . For example, if the number of customers visiting the store in the past is small and many customers visit the store on the day, there is a high possibility that the number of change reserves will be insufficient. On the other hand, if the number of customers visiting the store in the past is large and the number of customers who visit the store on the day is small, the number of change reserves may become excessive.

  Also, as in the above-mentioned Patent Document 2, when the number of change reserves is calculated by multiplying the standard deviation of the stock by a predetermined constant, the number of change reserves is excessive or insufficient during business hours for the same reason. May occur. This is because the actual number of coins required for change increases in proportion to the number of transactions, that is, the number of customers coming to the store. For these reasons, it is an important issue how to efficiently calculate the appropriate number of change reserves to be loaded into the cash register before the store starts business.

The present invention has been made in order to solve the above-described problems of the prior art, and it is possible to efficiently calculate an appropriate number of change reserves to be loaded into a money handling apparatus before the start of business in a store. an object of the present invention is to provide a management instrumentation 置及 beauty change fund calculation program.

  In order to solve the above-described problems and achieve the object, the present invention provides a money processing apparatus for depositing money that has been delivered from a customer and for dispensing change that is the difference between the money and the price of the product. A money management device for calculating the number of change reserves for each denomination of money, and for each denomination, calculates the number of change reserves for a predetermined number of people based on past transaction data of the money handling device. A first calculating unit; a receiving unit that receives an input of a predicted number of people to visit the store; and a change reserve per predetermined number of persons calculated by the first calculating unit when the predicted number is received by the receiving unit. And a second calculating means for calculating the number of change reserves for each denomination based on the estimated number of persons.

  Further, in the present invention according to the above invention, the first calculating means calculates the number of change reserves per predetermined number of denominations for each denomination based on a past transaction result of the money handling apparatus. It is characterized by that.

  Further, the present invention is the above invention, wherein in the above invention, receiving means for receiving transaction data for each transaction from the money handling apparatus via a predetermined communication line, and cumulative addition of the transaction data received by the receiving means for each denomination. The present invention is further characterized by further comprising transaction result management means for managing, as transaction result data, transition data in which the cumulative addition value and the number of transactions change.

  Further, the present invention is the above invention, wherein the first calculation means calculates the cumulative addition value that is the minimum value of the transition data in which the cumulative addition value managed by the transaction performance management means changes. The number of change reserves per predetermined number of persons is calculated for each denomination by dividing the quotient by the number of persons corresponding to the number of persons and multiplying the quotient by the predetermined number of persons.

  Further, the present invention is the above invention, wherein the transaction performance management means manages the transaction performance data for each date, every day of the week, or for each money processing device, and the first calculation means is a date of the money processing device. It is characterized in that the number of change reserves per predetermined number of persons is calculated for each denomination based on past transaction data for each day of the week or each money handling device.

  Further, the present invention is the above invention, wherein, when the second calculating means receives the predicted number of persons by the receiving means, the number of change reserves per predetermined number of persons calculated by the first calculating means, The number of change reserves for each denomination is calculated based on the predicted number of persons and a predetermined safety factor.

  In addition, the present invention provides the number of change reserves for each denomination of the money handling apparatus that deposits and processes the money that is the difference between the money and the price of the product while depositing the money delivered from the customer. A change calculation program for a money management device to be calculated, the first calculation procedure for calculating the number of change reserves per predetermined number of people for each denomination based on past transaction record data of the money handling device And an acceptance procedure for accepting the input of the predicted number of visitors to the store, and the number of change reserves per predetermined number of people calculated by the first calculation procedure and the prediction when the estimated number of people is accepted by the acceptance procedure. The computer is caused to execute a second calculation procedure for calculating the number of change reserves for each denomination based on the number of people.

  According to the present invention, based on the past transaction result data of the money handling apparatus that deposits and processes the money that is the difference between the money and the price of the product while depositing the money delivered from the customer. When the number of change reserves per person is calculated for each denomination and input of the expected number of visitors to the store is accepted, change per denomination based on the number of change reserves per given number of persons and the expected number of persons Since the configuration is such that the number of reserves is calculated, it is possible to efficiently calculate the appropriate number of change reserves to be loaded into the money handling apparatus before the start of business in the store.

FIG. 1 is an explanatory diagram for explaining the concept of the money management system according to the first embodiment. FIG. 2 is a diagram illustrating an apparatus configuration of the money management system according to the first embodiment. FIG. 3 is a functional block diagram showing an internal configuration of the cash register shown in FIG. FIG. 4 is a functional block diagram showing the internal configuration of the money management apparatus. FIG. 5 is an explanatory diagram for explaining the relationship between a transaction in a cash register and transaction result data. FIG. 6 is a graph showing a transition of transaction result data for each denomination shown in FIG. FIG. 7 is a diagram illustrating an example of CI value calculation and change reserve calculation. FIG. 8 is a diagram illustrating an example of a display screen when the predicted number of customers is input. FIG. 9 is a flowchart showing a generation processing procedure for generating the transaction record data shown in FIG. FIG. 10 is a flowchart of the change reserve calculation processing procedure according to the first embodiment. FIG. 11 is an explanatory diagram for explaining the concept of the management system according to the second embodiment. FIG. 12 is a functional block diagram illustrating the internal configuration of the money management apparatus according to the second embodiment. FIG. 13 is an explanatory diagram for more specifically explaining a plurality of CI value data for each cash register and for each day of the week shown in FIG. FIG. 14 is an explanatory diagram for explaining a change reserve calculating operation by the money management apparatus shown in FIG. 12. FIG. 15 is a flowchart showing a generation processing procedure for generating the transaction record data shown in FIG. FIG. 16 is a flowchart of the change reserve calculation processing procedure according to the second embodiment.

Hereinafter, with reference to the accompanying drawings, illustrating preferred embodiments of money management instrumentation 置及 beauty change fund calculation program according to the present invention in detail.

  First, the concept of the money management system according to the first embodiment will be described. FIG. 1 is an explanatory diagram for explaining the concept of the money management system according to the first embodiment. The cash register 20 shown in FIG. 1 is a device that deposits money that a customer pays as a price for purchasing a product, and performs a withdrawal process of a change that is the difference between the money and the price of the product. Is a device for calculating the number of change reserves for each denomination of the cash register 20.

  As shown in FIG. 1, the money management apparatus 40 receives transaction data for each transaction from the cash register 20. Such transaction data is data that is generated each time a customer makes a transaction for purchasing a product, and the number of money stored for each denomination stored in the cash register 20 and for each denomination paid out from the cash register 20 as change. Includes the number of coins.

  Transaction data B1 shown in the figure shows a situation in which two 1000-yen bills are stored in the cash register 20 and one 100-yen coin is paid out from the cash register 20. For example, a case where a customer passes two 1000-yen bills to a store clerk to purchase a 1900-yen product and receives a 100-yen coin as change is applicable. Transaction data B2 shows a situation in which one 5000 yen bill is stored in the cash register 20, and four 1000 yen bills and two 10 yen coins are paid out from the cash register 20. Further, the transaction data B3 shows a situation where one 10000 yen bill is stored in the cash register 20 and one 5000 yen bill and two 1000 yen bills are paid out from the cash register 20.

  The money management device 40 generates transaction result data using the transaction data received from the cash register 20. This transaction result data is transition data in which the cumulative addition value obtained by cumulatively adding transaction data for each denomination and the number of transactions change. In the example shown in FIG. 1, when the money management apparatus 40 receives transaction data B1, transaction data B2, and transaction data B3 in this order, first, the quantity of 1000 yen bills is changed from “0” to “2” according to the transaction data B1. The number of 100-yen coins decreases from “0” to “−1”.

  After that, the transaction data B2 increases the quantity of the 5000 yen bill from “0” to “1”, and the quantity of the 1000 yen bill decreases by 4 from “2” to “−2”. The quantity decreases from “0” to “−2”. Then, the transaction data B3 increases the quantity of the 10,000 yen bill from “0” to “1”, decreases the quantity of the 5000 yen bill from 1 to “0”, and decreases the quantity of the 1000 yen bill by 2 From “−2” to “−4”.

  The money management apparatus 40 calculates a “CI (Charge Index)” value that is an index of change for each denomination from the transaction result data. This CI value is an index similar to a PI (Purchase Index) value that is an index for merchandise sales. The PI value is an index indicating how many products can be sold by 1000 customers, whereas the CI value introduced by the present embodiment is the money when 1000 customers make transactions at the cash register 20. It is an index showing the increase or decrease of money for each species.

  Specifically, the money management apparatus 40 obtains the minimum cumulative addition value for each denomination from the transaction result data, divides the obtained cumulative addition value by the number of transactions, and then multiplies the quotient by 1000 to determine the deduction amount. CI value is calculated. For example, in FIG. 1, when the cumulative added value of each denomination becomes the minimum at the time of the number of transactions “2000”, the cumulative added value of the 5000 yen bill is “−26”, so the CI value is “−13”. " Similarly, since the cumulative added value of the 1000 yen bill is “−72”, the CI value is “−36”, and since the cumulative added value of the 500 yen coin is “−274”, the CI value is “−137”. Become.

  For this reason, if 1000 customers make a transaction in the cash register 20, if they prepare 13 5000 yen bills, 36 1000 yen bills and 137 500 yen coins as change reserves, It is possible to avoid the necessity of preparing an excessive change and to prevent the cash register from being stopped due to a change shortage.

By the way, in the above description, it is assumed that 1000 customers make transactions at the cash register 20, but the number of customers actually making transactions at the store varies every day. For this reason, in the store, the number of customers who make transactions is predicted, and the number of change reserves for each denomination is calculated by using the predicted number of customers and the CI value for each denomination. Note that the “predicted number of customers” here means the number of transactions substantially, and therefore, when a plurality of transactions are performed by the same person, they are regarded as transactions by different customers. In particular,
Change reserve = CI value x number of expected customers / 1000
From the above formula, the number of change reserves for each denomination is calculated.

  For example, in the example shown in FIG. 1, since the estimated number of customers is “400”, the change reserve for the 5000 yen bill is “−13 × 400 ÷ 1000 = −5.2”, so “6”. It becomes. The sign “-” indicates a situation where the number of change reserves is insufficient. Similarly, the change reserve for the 1000 yen bill is “−36 × 400 ÷ 1000 = −14.4”, so “15”, and the change reserve for the 500 yen coin is “−137 × 400 ÷ 1000”. = −54.8 ”, so“ 55 ”.

  In this way, the increase / decrease in the money in the cash register 20 is managed as transaction result data, and by using the CI value, which is the minimum value of the cumulative addition value of money per 1000 customers, it is only necessary to input the predicted number of customers. The appropriate number of change reserves for each denomination can be calculated efficiently. Here, for convenience of explanation, the case of calculating the number of change reserves of 5000 yen bill, 1000 yen bill and 500 yen coin is shown, but 100 yen coin, 50 yen coin, 10 yen coin, 5 yen coin and The same calculation can be made for 1-yen coins.

  Next, an apparatus configuration of the money management system according to the first embodiment will be described. FIG. 2 is a diagram illustrating an apparatus configuration of the money management system according to the first embodiment. As shown in the figure, the store 50 is provided with a cash register 20a, a cash register 20b, and a cash register 20c (hereinafter collectively referred to as “cache register 20”). The cash register 20 is communicably connected to the cashier 30 and the money management apparatus 40 via the in-store network 10. The money management device 40 is connected to a server device 52 of a security company and a server device 53 of a bank through a network 51 outside the store so as to be communicable.

  The cashier 30 is a device that manages cash handled at the store 50, and cash is deposited and withdrawn by a store clerk operation. For example, if the number of coins of a predetermined denomination in the cash register 20 exceeds the number that can be accommodated, the excess money is taken out from the cash register 20 and deposited in the cashier 30. Further, when the number of change reserves of a certain denomination exceeds the number that can be stored in the cash register 20, the excess change reserve number is deposited in the cashier 30. Then, when the change in the cash register 20 is insufficient or at an appropriate timing, money is withdrawn from the cashier 30 and replenished to the cash register 20 as change.

  As described above, the cash register 20 is a device for depositing money that is paid by a customer as a price for purchasing a product, and for dispensing change that is the difference between the money and the price of the product. Specifically, the barcode attached to the product is read by a barcode reader to recognize the product price, and the product is settled with money received from the customer. Further, the cash register 20 transmits the money type and the number of money deposited / withdrawn to the money management apparatus 40 as transaction data.

  FIG. 3 is a functional block diagram showing an internal configuration of the cash register 20 shown in FIG. As shown in FIG. 3, the cash register 20 includes a display unit 21, an input unit 22, a printing unit 23, a barcode reader 24, a communication I / F unit 25, a bill processing device 26, a coin processing device 27, and a bar metal management device. 27a and a control unit 28.

  The display unit 21 is a display device such as a display device or a liquid crystal panel, and the input unit 22 is an input device such as a keyboard, numeric keys, or operation keys. The printing unit 23 is a processing unit that issues a receipt on which a settlement result is printed. The barcode reader 24 is a device that reads a barcode attached to a product.

  The communication I / F unit 25 is an interface unit for communicating with the cashier 30 and the money management device 40 via the in-store network 10. The banknote processing device 26 is a device that performs banknote storage, denomination identification, authenticity determination, and counting processing, and the coin processing device 27 performs coin storage, denomination identification, authenticity determination, and count processing. Device. The bar metal management device 27 a is a device for storing and managing coins in a bar metal state for replenishing the coin processing device 27.

  The control unit 28 is a control unit that controls the entire cash register 20, and includes a barcode processing unit 28a and a settlement processing unit 28b. Further, the settlement processing unit 28b includes a transaction data transmission unit 28c. Actually, programs corresponding to these functional units are stored in a ROM or a non-volatile memory (not shown), and these programs are loaded into the CPU and executed, whereby the barcode processing unit 28a and the settlement processing unit 28b. And the transaction data transmission unit 28c execute corresponding processes.

  The barcode processing unit 28a is a processing unit that causes the barcode reader 24 to read a barcode attached to a product and decodes the read code to output data relating to the price of the product to the settlement processing unit 28b. is there.

  The settlement processing unit 28b is a processing unit that performs a settlement process for one or a plurality of products purchased by the customer. Specifically, each time data such as the price of a product is received from the barcode processing unit 28a, the price is added to the total amount, and the amount of the product manually input from the operation key is also added to the total amount. Identify the total amount that the customer is willing to purchase. Then, when money is inserted into a money deposit / withdrawal port (not shown) by the store clerk, the money is transported to the banknote processing device 26 or the coin processing device 27 and stored for each denomination, and the sum of the inserted money and merchandise. The change of the amount of money is discharged from the money deposit / withdrawal port.

  The transaction data transmission unit 28 c transmits transaction data including an increase / decrease in the number of money-deposited money denominations to the money management device 40 via the communication I / F unit 25. In addition, the money management apparatus 40 produces | generates transaction performance data based on this transaction data.

  Next, the internal configuration of the money management apparatus 40 will be described. FIG. 4 is a functional block diagram showing the internal configuration of the money management apparatus 40. As shown in the figure, the money management apparatus 40 includes a display unit 41, an input unit 42, a communication I / F unit 43, a communication I / F unit 44, a storage unit 45, and a control unit 46.

  The display unit 41 is a display device such as a liquid crystal panel, and the input unit 42 is an input device such as operation keys. The communication I / F unit 43 is an interface unit for communicating with the cash register 20 via the in-store network 10, and the communication I / F unit 44 is a server device 52 or a bank of a security company via the outside network 51. It is an interface part for communicating with the server apparatus 53.

  The storage unit 45 is a storage device including a hard disk device, a nonvolatile memory, and the like, and stores transaction result data 45a, CI value data 45b, and safety magnification data 45c. Here, the transaction result data 45a is transition data in which the cumulative addition value obtained by accumulating the increase / decrease of the transaction data for each transaction received from the cash register 20 for each denomination and the number of transaction customers change. By referring to the transaction record data 45a, it is possible to grasp the transition of the number of each currency stored in the cash register 20.

  The CI value data 45b is data serving as a change index for each denomination, and indicates an increase / decrease in money for each denomination when 1000 customers trade with the cash register 20. The CI value data 45b is calculated from the cumulative added value that is the minimum value of the transaction record data 45a and the number of customers.

  The safety magnification data 45c is data provided from the viewpoint of preventing a situation where the number of change reserves for each denomination is insufficient, and includes the number of change reserves for each denomination calculated from the CI value and the estimated number of customers. Is multiplied. The reason for providing the safety magnification data 45c is that there is a possibility that customers exceeding the predicted number of customers predicted in advance may visit the store.

  The control unit 46 is a control unit that controls the money management apparatus 40 as a whole, and includes a data management unit 46a, a CI value calculation unit 46b, a change reserve calculation unit 46c, and a change order processing unit 46d. Actually, programs corresponding to these functional units are stored in a ROM or a non-volatile memory (not shown), and these programs are loaded into the CPU and executed, whereby the data management unit 46a and the CI value calculation unit 46b. The change reserve calculation unit 46c and the change order processing unit 46d respectively execute processes corresponding to the change reserve calculation unit 46c and the change order processing unit 46d.

  The data management unit 46a is a management unit that manages the transaction result data 45a. When the transaction data is received from the cash register 20, the data management unit 46a updates the transaction result data 45a by reflecting the increase / decrease in the money included in the transaction data. .

  The CI value calculation unit 46b divides the cumulative addition value, which is the minimum value for each denomination in the transaction result data 45a, by the number of transactions, calculates the CI value by multiplying the quotient by 1000, and calculates the calculated CI value. Is stored in the storage unit 45 as CI value data 45b.

  When transaction data is received from a plurality of cash registers 20, transaction record data 45a is calculated for each cash register 20, and a CI value is calculated using the minimum value of the plurality of transaction record data 45a. Further, the transaction value data 45a for each day within the predetermined period can be generated, and the CI value can be calculated using the average value of the cumulative addition value that is the minimum value of each transaction result data 45a.

The change reserve calculation unit 46c is a processing unit that calculates the number of change reserves for each denomination on condition that the number of predicted customers is input. Specifically, the change reserve calculation unit 46c calculates the number of change reserves for each denomination from the formula of CI value × predicted number of customers ÷ 1000 × safety factor.

  The change order processing unit 46d is a processing unit that orders the change reserve calculated by the change reserve calculation unit 46c. Specifically, the change order processing unit 46d orders money as a change reserve to the server device 52 of the police company or the server device 53 of the bank via the communication I / F unit 44.

  Next, the transaction result data 45a shown in FIG. 4 will be described more specifically. FIG. 5 is an explanatory diagram for explaining the relationship between the transaction in the cash register 20 and the transaction result data 45a. 5A to 5C show the state of the cash register 20, and FIG. 5D shows transaction result data 45a.

  FIG. 5A shows transaction 1 using cash register 20 (the total amount of the product is “1825 yen”, the deposit amount is “2000 yen (two 1000-yen bills)”), transaction 2 (the total of products) Amount of money is “980 yen”, deposit amount is “5000 yen (one 5000 yen bill)”, transaction 3 (total amount of product is “2884 yen”, deposit amount is “10000 yen (10000 yen bill is 1 piece) ) "), Transaction 4 (the total amount of the product is" 1872 yen ", the deposit amount is" 10002 yen (one 10000-yen bill, one 2-yen coin) ") ing.

  FIG. 2B shows the change payout status of each transaction 1 to 4 in the cash register 20. In transaction 1, "175 yen (100 yen coin, 1 50 yen coin, 2 10 yen coin, 1 5 yen coin)" is withdrawn as change, and in transaction 2, "4020 yen (1000 yen bill 4 "10 sheets, 10 yen coins 2" as change, and in transaction 3, "7116 yen (1 5000 yen bill, 1 100 yen coin, 1 10 yen coin, 1 5 yen coin, 1 yen coin) 1 ") as change, and in Transaction 4," 8130 yen (1 5000 yen bill, 3 1000 yen bill, 1 100 yen coin, 1 10 yen coin) "is withdrawn as change Yes.

  FIG. 6 (c) shows the amount of money in the cash register 20 in-flight. In the initial state, the total amount is 50,000 yen (five 5,000 yen bills, 20 1000 yen bills, five 500 yen coins, 20 pieces of 100 yen coins, 5 pieces of 50 yen coins, 20 pieces of 10 yen coins, 6 pieces of 5 yen coins, and 20 pieces of 1 yen coins) are prepared.

  Here, when the transaction 1 using the cash register 20 is performed, two 1000 yen bills increase, and as a change, one 100 yen coin, one 50 yen coin, two 10 yen coins, and one 5 yen coin Decrease. For this reason, transaction data of 1000 yen bill “2”, 100 yen coin “−1”, 50 yen coin “−1”, and 5 yen coin “−1” is transmitted to the money management apparatus 40. For this reason, as shown in FIG. 5D, the transaction result data 45a in the case of the number of transactions “1” is 10000 yen bill “0”, 5000 yen bill “0”, 1000 yen bill “2”, 500 yen. The coin is “0”, 100 yen coin “−1”, 50 yen coin “−1”, 10 yen coin “−2”, 5 yen coin “−1”, and 1 yen coin “0”.

  Thereafter, when the transaction 2 using the cash register 20 is performed, one 5000 yen bill is increased, and four 1000 yen bills and two 10 yen coins are decreased as change. For this reason, transaction data of 5000 yen bill “1”, 1000 yen coin “−4”, and 10 yen coin “−2” is transmitted to the money management apparatus 40. For this reason, as shown in FIG. 5D, the transaction result data 45a in the case of the number of transactions “2” is 10000 yen bill “0”, 5000 yen bill “1”, 1000 yen bill “−2”, 500 Yen coin “0”, 100 yen coin “−1”, 50 yen coin “−1”, 10 yen coin “−4”, 5 yen coin “−1”, and 1 yen coin “0”. Similarly, when transactions 3 and 4 are performed, the number of transactions is incremented and transaction result data 45a is calculated as shown in FIG. 5 (d).

  FIG. 6 is a graph showing the transition of the transaction result data 45a for each denomination shown in FIG. As shown in the figure, the transition varies depending on the denomination, but the 10,000 yen bill is increasing because it is not paid out as change, and other currencies tend to decrease as the number of transactions increases. . Since the minimum value of each denomination in this graph indicates the situation where the number of the denomination is the smallest, by obtaining the CI from the minimum value, the number of transactions is 1000 times, that is, the transaction per 1000 customers. You can ask for the number of change reserves you need.

  Next, an example of CI value calculation and change reserve calculation calculation will be described more specifically. FIG. 7 is a diagram illustrating an example of CI value calculation and change reserve calculation. Here, the number of transactions that is the minimum value of the transaction record data 45a is “305 times” in common with each denomination, and the 5000 yen bill “−4”, 1000 yen bill “−11”, 500 yen coin “−” 42, 100 yen coin “−144”, 50 yen coin “−43”, 10 yen coin “−165”, 5 yen coin “−30”, and 1 yen coin “−193”.

  As shown in the figure, when the minimum value of each denomination is divided by the number of transactions “305” and the quotient is multiplied by 1000, the CI value of the 5000 yen bill becomes “−13.114754” The CI value is “−36.065574”, the CI value of the 500 yen coin is “−137.70492”, the CI value of the 100 yen coin is “−4721.3115”, and the CI value of the 50 yen coin is “− The CI value of the 10 yen coin is “−540.98361”, the CI value of the 5 yen coin is “−98.360656”, and the CI value of the 1 yen coin is “−632.778689”. Become.

  Here, if the predicted number of customers on the next business day of the store is “400 people”, the 5000 yen bill becomes “−5.2459” and the 1000 yen bill becomes “CI value × predicted number of customers ÷ 1000”. "-14.262", 500 yen coin becomes "-55.082", 100 yen coin becomes "-188.852", 50 yen coin becomes "-56.3934", 10 yen coin becomes "- 216.393 ", the 5-yen coin becomes" -39.3443 ", and the 1-yen coin becomes" -253.115 ".

  Therefore, 6 5000 yen bills, 15 1000 yen bills, 2 wrapping coins wrapping 50 500 yen coins, 4 wrapping coins wrapping 50 100 yen coins, 50 50 yen coins Two wrapping coins, 50 wrapping coins, 50 wrapping coins, 5 wrapping coins, 50 wrapping coins, 50 wrapping coins, 1 wrapping coin, 50 wrapping coins By doing so, it is possible to secure the necessary number of change reserves for each denomination.

  However, in order to deal with cases where the number of customers on the next business day exceeds the estimated number of customers or cases where each customer uses only high-value bills, the number of change reserves of each denomination is multiplied by a safety factor. In the example shown in FIG. 7, the safety magnification of 5000 yen bills, 500 yen coins, 50 yen coins and 5 yen coins is set to “1.2”, and 1000 yen bills, 100 yen coins, 10 yen coins and 1 yen coins are The safety magnification is set to “1.5”. The reason for this is that the 5000 yen bill, 500 yen coin, 50 yen coin, and 5 yen coin can be replaced with the currency of the next denomination even if there is a lack of change reserve for the applicable money. Because.

  As shown in FIG. 7, the change reserve obtained in this way consists of seven 1000-yen bills, 23 1000-yen bills, two 500-yen wrapping coins, and six 100-yen wrapping coins. , 2 wrapping coins of 50 yen, 8 wrapping coins of 10 yen, 1 wrapping coin of 5 yen, and 9 wrapping coins of 1 yen.

  Next, an example of the display screen when the predicted number of customers is input will be described. FIG. 8 is a diagram illustrating an example of a display screen when the predicted number of customers is input. Here, it is assumed that the estimated number of customers who visit the store on the next business day is calculated in advance using a known technique or the like.

  As shown in FIG. 8, when the clerk inputs the estimated number of customers “400” on the input screen displayed on the display unit 41, the money management device 40 calculates the change reserve of each denomination from the CI value and the safety factor. Calculate the number and display for each denomination. Also, the amount and total amount of change reserve for each denomination are calculated and displayed in the total amount column. In this way, the store clerk can obtain the number of change reserves and the total amount for each denomination by inputting the predicted number of customers.

  In the example of FIG. 8, seven 5000 yen bills are worth 35,000 yen, 23 thousand yen bills are worth 23,000 yen, two 500 yen wrapping coins are 50,000 yen, and 100 yen wrapping coins are six. 3 000 yen, 50 yen wrapping coins for 2 5,000 yen, 10 yen wrapping coins for 8 4,000 yen, 5 yen wrapping coins for 1 250 yen, 1 wrapping coin for 9 yen The book shows that a change reserve of 450 yen is required, and the total amount is 147700 yen.

  Next, a generation processing procedure for generating transaction result data 45a will be described. FIG. 9 is a flowchart showing a generation processing procedure for generating the transaction record data 45a shown in FIG. Here, for convenience of explanation, the product to be settled is a single product, and the barcode attached to the product is read by the barcode reader 24, and the price of the product is received. To do.

As shown in the figure, when the barcode is read by the barcode reader 24 (step S101; Yes), the cash register 20 decodes the barcode and recognizes the product information including the price of the product ( Step S102).

  If the settlement processing unit 28b of the cash register 20 recognizes the price of the product recognized by the recognition processing, the settlement processing of the product is performed (step S103). When performing the settlement process, money equal to or greater than the total amount is received from the customer and deposit processing is performed, and change corresponding to the difference between the money received from the customer and the total amount is returned to the customer. When a plurality of products are settled at once, the total price is calculated by accumulating the price of each product, and the calculated total price is settled. Thereafter, the transaction data transmitting unit 28c transmits the money increase / decrease number for each denomination when the product is settled to the money management apparatus 40 as transaction data (step S104).

  If the data management unit 46a of the money management apparatus 40 receives the transaction data from the cash register 20 (step S111; Yes), the data obtained by accumulating the increase / decrease number of money for each denomination in the transaction result data 45a of the previous transaction. In addition, 1 is added to the number of transactions and additional registration is performed (step S112).

  Next, a procedure for calculating the number of change reserves will be described. FIG. 10 is a flowchart of the change reserve calculation processing procedure according to the first embodiment. As shown in the figure, the money management device 40 calculates a CI value from the transaction result data 45a (step S201), and receives an input of the predicted number of customers from the store clerk (step S202), CI value × predicted customer. A value ÷ 1000 is calculated for each denomination (step S203), and the safety magnification for each denomination indicated in the safety magnification data 45c is multiplied (step S204) to calculate the number of change reserves (step S204). S205).

  Thereafter, the money management apparatus 40 displays and outputs the calculated change reserve for each denomination on the display unit 41 (step S206), and orders the change reserve based on an operation for instructing an order from the store clerk ( Step S207) and the process is terminated.

  As described above, the money management apparatus 40 according to the first embodiment manages the change of money increase / decrease for each denomination in the cash register 20 as the transaction result data 45a, and the increase / decrease of money increase / decrease for each denomination. Calculate the minimum value of the transition, multiply the quotient obtained by dividing the minimum value by the number of transactions by 1000, and calculate the CI value indicating the increase or decrease of money for each denomination per 1000 people, respectively. When the number of customers is accepted, this forecast customer number and CI value are used to calculate the number of change reserves for the next business day. Therefore, it is possible to calculate the appropriate number of change reserves required.

  In the second embodiment, a management system that takes into account changes in CI values depending on the day of the week and date and the CI difference for each cash register will be described. Customers who come to the store may vary depending on the day of the week, such as many families with families on Saturdays and many housewives from Monday to Friday. This difference appears as a difference in denominations used for payment even at the same transaction unit price. Similarly, a relatively high amount of money is used for payment after the salary or pension benefit date, and a relatively low amount of money tends to be used for payment before the salary or pension benefit date. Arise. Further, there may be a difference in the CI value depending on the position where the cash register is arranged or the sales floor. Therefore, in order to more accurately determine the number of change reserves, it is effective to calculate the CI value for each day of the week, date, or cash register.

  Therefore, in the second embodiment, a case where the CI value is calculated for each day of the week and each cash register will be described. Note that the CI value for each date may be calculated in the same manner as for the day of the week, and thus the description thereof is omitted.

  FIG. 11 is an explanatory diagram for explaining the concept of the management system according to the second embodiment. As shown in FIG. 11, the money management apparatus 140 according to the second embodiment distinguishes between transaction data acquired from the cash register 20a and transaction data acquired from the cash register 20b. Calculate the number of reserves.

  Furthermore, the money management apparatus 140 generates transaction performance data for each day of the week from transaction data acquired from the same cash register, and calculates a CI value for each day of the week. When calculating the number of change reserves, the CI value to be used is selected according to the day of the week for calculating the number of change reserves, and the number of change reserves is calculated.

  Next, the internal configuration of the money management apparatus 140 will be described. FIG. 12 is a functional block diagram showing the internal configuration of the money management apparatus 140. As shown in the figure, the money management apparatus 140 stores a plurality of transaction record data 45d for each cash register and for each day of the week and a plurality of CI value data 45e for each cash register and for each day of the week in the storage unit 45.

  Next, the plurality of CI value data 45e for each cash register and for each day of the week will be described more specifically. FIG. 13 is an explanatory diagram for more specifically explaining the plurality of CI value data 45e for each cash register and each day of the week shown in FIG.

  As shown in FIG. 13, the cash register 20a has a CI value of “−20” on a 5000 yen bill on Sunday, a CI value of “1000” on Sunday, and a 500 yen coin on Sunday. The CI value is “−350”. Further, the cash register 20a has a CI value of “−13” on a 5000 yen bill on Monday, a CI value of “1000” on a 1000 yen bill on Monday, and a CI value of a 500 yen coin on Monday is “−”. 472 ". In the cash register 20a, the CI value of the 5000 yen bill on Tuesday is “−15”, the CI value of the 1000 yen bill on Tuesday is “−36”, and the CI value of the 500 yen coin on Tuesday is “−”. 500 ". The illustration and description of other denominations and days of the week are omitted.

  Similarly, the cash register 20b has a CI value of “−19” on a 5000 yen bill on Sunday, a CI value of “1000” on a Sunday 1000 yen bill, and a CI value of a 500 yen coin on Sunday is “ -360 ". Further, the cash register 20b has a CI value of “−14” on a 5000 yen bill on Monday, a CI value of “1000” on a Monday 1000 yen bill, and a CI value of a 500 yen coin on Monday is “−”. 469 ". The cash register 20b has a CI value of “−15” on the 5000 yen bill on Tuesday, a CI value of “1000” on the Tuesday 1000 yen bill, and a CI value of 500 yen coin on Tuesday is “−”. 490 ". The illustration and description of other denominations and days of the week are omitted.

  The control unit 46 of the money management apparatus 140 includes a CI value selection unit 46f in addition to the data management unit 46a, the CI value calculation unit 46b, the change reserve calculation unit 46c, and the change order processing unit 46d. The CI value selection unit 46f selects CI value data used for calculating the change reserve from the plurality of CI value data 45e based on the identification information of the cash register 20 and the day of the week for calculating the number of change reserves. Process. Therefore, the change reserve calculation unit 46c calculates the number of change reserves for each cash register using the CI value data selected by the CI value selection unit 46f. Since other configurations and operations are the same as those in the first embodiment, the same components are denoted by the same reference numerals and description thereof is omitted.

  Next, the calculation operation of the change reserve by the money management apparatus 140 will be described. FIG. 14 is an explanatory diagram for explaining the calculation operation of the change reserve by the money management apparatus 140. The predicted customer number automatic calculation screen shown in FIG. 14 calculates and displays the predicted customer number for each day based on the monthly sales budget, the customer unit price, the predicted customer number, and the customer number index for each day of the week.

  When the sales clerk inputs the amount of the monthly sales budget, the monthly sales budget is divided by the customer unit price to calculate the predicted number of customers for the month. The unit price of the customer is a value determined by the store brand and handling items, and is set in advance. In the example of FIG. 14, 80000000 yen is input as the monthly sales budget, and the customer unit price is 1850 yen, so the predicted number of customers for the month is 43243.

  The customer index for each day of the week shows the change in the number of customers according to the day of the week. In the example of FIG. 14, the customer index for Sunday is “1.11”, the customer index for Monday is “0.89”, and the customer index for Tuesday Is “0.88”, the customer index on Wednesday is “0.85”, the customer index on Thursday is “1.01”, the customer index on Friday is “1.05”, The number of customers index is “1.21”. By assigning the value of the predicted number of customers for the month according to the customer number index for each day of the week, the predicted number of customers for each day is obtained.

  In the example of FIG. 14, the predicted number of customers on Sunday is “1548”, the predicted number of customers on Monday is “1241”, the predicted number of customers on Tuesday is “1228”, and the predicted number of customers on Wednesday is “1186”. The estimated number of customers on Thursday is “1409”, the estimated number of customers on Friday is “1465”, and the estimated number of customers on Saturday is “1688”. Note that the estimated number of customers for each day can be changed by an operation input by a store clerk.

  When the store clerk selects a date on the predicted customer number automatic calculation screen, the number of change reserves for each cash register on the selected date is displayed. In FIG. 14, the number of change reserves in the cash register with the identification number (ID) “1” is 15 5000 yen bills for 75,000 yen, 30 1000 yen bills for 30 thousand yen, and 500 yen packaging. One coin is 25000 yen, 5 100 yen wrapping coins is 25,000 yen, 50 yen wrapping coins is 2500 yen, 10 wrapping coins is 4 yen, 2000 yen is 5 yen One wrapping coin is equivalent to 250 yen, and five wrapping coins are worth 250 yen, and the total amount of change reserve is 160000 yen.

  Further, although not shown, the number of change reserves for each denomination is calculated for other cash registers, and the total value is displayed to be 1050000 yen. In addition, as information that affects the predicted number of customers, events to be performed in the store, weather, and the like are displayed.

  Next, a generation processing procedure for generating transaction result data 45d will be described. FIG. 15 is a flowchart showing a generation processing procedure for generating the transaction record data 45d shown in FIG. Here, for convenience of explanation, the product to be settled is a single product, and the barcode attached to the product is read by the barcode reader 24, and the price of the product is received. To do.

  As shown in the figure, when the bar code is read by the bar code reader 24 (step S301; Yes), the cash register 20 decodes the bar code and recognizes the merchandise information including the price of the merchandise ( Step S302).

  If the settlement processing unit 28b of the cash register 20 recognizes the price of the product recognized by the recognition processing, the settlement processing of the product is performed (step S303). When performing the settlement process, money equal to or greater than the total amount is received from the customer and deposit processing is performed, and change corresponding to the difference between the money received from the customer and the total amount is returned to the customer. When a plurality of products are settled at once, the total price is calculated by accumulating the price of each product, and the calculated total price is settled. Thereafter, the transaction data transmission unit 28c transmits the increase / decrease number of money for each denomination when the product is settled as transaction data to the currency management apparatus 140 together with an ID for uniquely identifying the cash register (step S304).

  If the data management unit 46a of the money management apparatus 140 receives the transaction data and the ID from the cash register 20 (step S311; Yes), the transaction result of the previous transaction in which the increase / decrease for each denomination is associated with the day of the week and the ID. The data 45d is added and registered by adding 1 to the data accumulated and the number of transactions (step S312).

  Next, a procedure for calculating the number of change reserves will be described. FIG. 16 is a flowchart of the change reserve calculation processing procedure according to the second embodiment. As shown in the figure, the money management device 140 calculates a CI value for each cash register and for each day of the week from the transaction result data 45d (step S401), and receives the monthly sales budget input from the store clerk. The estimated number of customers for each day is calculated from the sales budget (step S402), and the CI value for each day of the week is selected for each cash register (step S403).

  The change reserve calculation unit 46c of the money management apparatus 140 calculates a value of CI value × predicted number of customers / 1000 for each denomination (step S404), and calculates the safety magnification for each denomination indicated in the safety magnification data 45c. Multiplication is performed (step S405), and the number of change reserves is calculated (step S406).

  Thereafter, the money management apparatus 140 displays and outputs the calculated number of change reserves for each denomination on the display unit 41 (step S407), and places an order for change reserve based on an operation for instructing an order from a store clerk. (Step S408), and the process ends.

  As described above, the money management apparatus 140 according to the second embodiment records the increase / decrease in money for each denomination for each cash register and for each day of the week, and increases / decreases the money per 1000 people (1000 transactions). The CI value shown is calculated for each cash register and for each day of the week, and the number of change reserves is calculated for each denomination using the CI value selected according to the day of the week for calculating the cash register ID and the number of change reserves. With this configuration, it is possible to calculate the appropriate number of change reserves in consideration of fluctuations due to the day of the week and the cash register.

  In the first and second embodiments, the cash register 20 that accepts money inserted into a predetermined money deposit / withdrawal port and automatically stores the money, and automatically dispenses money to be changed from the money deposit / withdrawal port, is used. However, the present invention is not limited to this, and can also be applied to the case where money is stored and taken out manually by a store clerk while opening and closing the drawer for storing money.

  In the first and second embodiments, in the description of FIG. 2, the money management device 40 has been described to receive transaction data from the cash register 20 and generate transaction record data. However, when the cash register is a POS register. May cause the POS server to perform the function of the money management apparatus of the present invention. Alternatively, transaction data may be transmitted from the cash register 20 to an external data center so that the external data center performs the function of the money management apparatus of the present invention as an ASP service.

  Moreover, in the said Example 1 and 2, although CI value was defined as an index | index which shows the increase / decrease in the money for every money type when 1000 customers trade with the cash register 20, this invention is limited to this. The CI value can also be defined as an index based on 100 or 200 customers.

  Furthermore, in the said Example 1 and 2, although the cash register 20 and the money management apparatus 40 were connected so that communication was possible, and the case where transaction data was transmitted online was shown, this invention is not limited to this, The present invention can also be applied when transaction data is exchanged offline using a storage device that stores transaction data.

  Moreover, in the said Example 1 and 2, although the case where the cash register 20 and the money management apparatus 40 were used as another apparatus was shown, this invention is not limited to this, The change reserve of the money management apparatus 40 is shown. A function unit for calculating the number of sheets may be provided in the cash register 20.

Thus, money management instrumentation 置及 beauty change fund calculation program according to the present invention, suitable for calculating a proper number of the change fund to be loaded into the money handling apparatus before operating the start of the store efficiently ing.

10 In-store network 20, 20a, 20b, 20c Cash register 21, 41 Display unit 22, 42 Input unit 23 Printing unit 24 Bar code reader 25, 43, 44 Communication I / F unit 26 Banknote processing device 27 Coin processing device 27a Bar Management device 28, 46 Control unit 28a Barcode processing unit 28b Settlement processing unit 28c Transaction data transmission unit 30 Teller machine 40, 140 Money management device 45 Storage unit 45a, 45d Transaction result data 45b, 45e CI value data 45c Safety magnification data 46a Data management unit 46b CI value calculation unit 46c Change reserve calculation unit 46d Change order processing unit 46f CI value selection unit 50 Store 51 Out-of-store network 52 Security device server device 53 Bank server device

Claims (7)

A money management device that calculates the number of change reserves for each denomination of a money handling device that deposits and processes the money that is the difference between the money and the price of goods while depositing and receiving money delivered from a customer. There,
First calculating means for calculating the number of change reserves per predetermined number of people for each denomination based on past transaction result data of the money handling apparatus;
An accepting means for accepting an input of an estimated number of people who will visit the store;
When the predicted number is received by the receiving means, the number of change reserves for each denomination is calculated based on the number of change reserves per predetermined number of persons calculated by the first calculation means and the predicted number of persons. A money management device comprising: a second calculation means.   The said 1st calculation means calculates the number of change reserves per predetermined number of persons for every denomination based on the transaction performance of the said money processing apparatus in the past predetermined period. Money management device. Receiving means for receiving transaction data for each transaction from the money handling apparatus via a predetermined communication line;
Further comprising: transaction result management means for managing, as transaction result data, a cumulative addition value obtained by accumulating the transaction data received by the receiving means for each denomination and a transition data in which the number of transactions changes. Item 3. The money management apparatus according to item 1 or 2.   The first calculation means divides the cumulative addition value, which is the minimum of the transition data in which the cumulative addition value managed by the transaction performance management means changes, by the number of transactions corresponding to the cumulative addition value, 4. The money management apparatus according to claim 3, wherein the quotient is multiplied by a predetermined number of persons to calculate the number of change reserves per predetermined number of persons for each denomination. The transaction performance management means manages the transaction performance data for each date, for each day of the week or for each money handling device,
The first calculating means calculates the number of change reserves per predetermined number of denominations for each denomination based on past transaction record data for each date, day of the week, or for each money handling device. The money management device according to claim 3 or 4, characterized by the above.   The second calculating means is based on the number of change reserves per predetermined number of persons calculated by the first calculating means, the predicted number of persons and a predetermined safety factor when the estimated number of persons is received by the receiving means. The money management device according to claim 1, wherein the number of change reserves for each denomination is calculated. A money management device that calculates the number of change reserves for each denomination of a money handling device that processes money received from a customer and deposits change that is the difference between the money and the price of goods. A change reserve calculation program,
A first calculation procedure for calculating, for each denomination, the number of change reserves per predetermined number of persons based on past transaction record data of the money handling apparatus;
Acceptance procedure to accept the number of people expected to visit the store,
When the estimated number of persons is received by the reception procedure, the number of change reserves for each denomination is calculated based on the number of change reserves per predetermined number of persons calculated by the first calculation procedure and the estimated number of persons. A change reserve calculation program characterized by causing a computer to execute the second calculation procedure.

Images