Tobacco tax refund application support system and tobacco tax refund application support method

The system automates the identification and aggregation of lost tobacco products across multiple stores to streamline the tobacco tax refund filing process, addressing the inefficiencies in existing systems by reducing the effort required for retailers to declare lost products.

JP7594994B2Active Publication Date: 2024-12-05TS NETWORK CO LTD +1
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
JP2021183441
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2021-11-10
Publication Date
2024-12-05
Estimated Expiration
2041-11-10

AI Technical Summary

Technical Problem

Existing systems for managing tobacco tax refunds do not account for the process of filing declarations for tobacco products lost in disasters, requiring significant effort to identify and report the quantity of damaged products.

Method used

A system and method for acquiring and aggregating quantity information of lost tobacco products across multiple disaster-affected stores, generating data for a tobacco tax refund form, and supporting the filing process through a support server that communicates with a sales distribution system to streamline the refund declaration process.

Benefits of technology

Reduces the effort required to file tobacco tax refunds by automating the identification and aggregation of lost products, facilitating efficient submission of tax refund forms to administrative districts.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007594994000001
    Figure 0007594994000001
  • Figure 0007594994000002
    Figure 0007594994000002
  • Figure 0007594994000003
    Figure 0007594994000003
Patent Text Reader

Abstract

To provide technology to reduce the effort of cigarette tax refund declaration for a cigarette product lost in a disaster.SOLUTION: A cigarette tax refund declaration support system comprises information acquisition means for acquiring information on the quantity of cigarette products lost in a disaster at a plurality of disaster-stricken stores belonging to a predetermined administrative district, and generation means for generating data on a cigarette tax refund form aggregated for the plurality of disaster-stricken stores, for submission to the predetermined administrative district based on the quantity information.SELECTED DRAWING: Figure 6
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to a technology for supporting the filing of tobacco tax refund applications. [Background technology]

[0002] In the distribution of tobacco products, fair and equitable transactions are realized while complying with regulations specific to tobacco products, such as the fixed price system and sales license system stipulated by the Tobacco Business Law, as well as the obligation to pay tobacco taxes. Tobacco distributors distribute tobacco products fairly and equitably to the stores of retailers authorized to sell tobacco products. In such tobacco product transactions, real-time settlement is adopted in order to comply with the tobacco tax payment obligation, and tobacco product retailers have already paid the tobacco tax before selling to customers. Therefore, if tobacco products in a store are damaged by a disaster and cannot be sold as they are, retailers can apply for a tobacco tax refund with the government. However, because the procedures for filing tobacco tax refund claims are difficult for retailers, tobacco distributors handle the refund claims procedures and receive tobacco tax refunds on behalf of retailers, while also providing services such as providing disaster compensation to retailers in the form of tobacco products, etc.

[0003] The following Patent Document 1 proposes a local tax payment management system that can perform accurate and efficient local tobacco tax payment management. This system calculates the delivery volume of tobacco products to be delivered from a logistics warehouse to multiple retail stores from order data from each retail store, tallying up the delivery volumes of tobacco products delivered to each of the multiple retail stores for each local government to which each retail store belongs, and calculates the amount of local tax to be paid to each local government, thereby executing payment processing. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] JP 2003-296507 A Summary of the Invention [Problem to be solved by the invention]

[0005] Although the above-mentioned local tax payment management system processes the payment of taxes, it does not take into account the filing of tobacco tax refund applications. Filing a tobacco tax refund requires effort, such as the need to identify the number of tobacco products that were damaged in the disaster and are no longer able to be sold (i.e., lost in the disaster).

[0006] In view of the above problems, the present invention provides a technique for reducing the effort required for filing a tobacco tax refund claim for tobacco products lost in a disaster. In this specification, the term "tobacco products" is used to encompass all tobacco products that are subject to tobacco tax, including cigarettes, cigars, chewing tobacco, snuff, and pipe tobacco, as well as cartridges used for tobacco products known as electronic cigarettes, heated tobacco products, etc. [Means for solving the problem]

[0007] According to the present invention, a tobacco tax refund claim support system can be provided, which includes an information acquisition means for acquiring quantity information of tobacco products lost in a disaster at multiple affected stores belonging to a specified administrative district, and a generation means for generating data for a tobacco tax refund claim form that aggregates the amounts of the multiple affected stores based on the acquired quantity information to be submitted to the specified administrative district.

[0008] In another aspect, the present invention can provide a tobacco tax refund claim support method executed by one or more computers, the one or more computers acquiring quantity information of tobacco products lost in a disaster at a plurality of affected stores belonging to a specified administrative district, and generating tobacco tax refund claim form data that aggregates the amounts of the plurality of affected stores based on the acquired quantity information to be submitted to the specified administrative district. In addition, for example, a computer program may be provided that causes one or more computers to execute the tobacco tax refund application support method described above, or a computer-readable recording medium having such a computer program recorded thereon may be provided. Effect of the Invention

[0009] According to the present invention, a technique can be provided that reduces the effort required for filing a claim for refund of tobacco tax on tobacco products lost in a disaster. [Brief description of the drawings]

[0010] [Figure 1] 1 is a conceptual diagram of a system configuration of a tobacco tax refund application support system according to an embodiment of the present invention. [Diagram 2] FIG. 13 is a diagram illustrating an example of a customer information table. [Diagram 3] FIG. 13 is a diagram illustrating an example of a brand master table. [Figure 4] FIG. 13 is a diagram illustrating an example of a transaction record table. [Diagram 5] FIG. 2 is a block diagram conceptually showing a hardware configuration of a support server. [Figure 6] FIG. 2 is a block diagram conceptually illustrating an example of the software configuration of a support server. [Figure 7] FIG. 13 is a diagram showing an input screen for the quantity of tobacco products lost in a disaster (lost tobacco products). [Figure 8] FIG. 13 is a diagram showing an example of an amended tobacco tax return. [Figure 9] FIG. 9 is a diagram showing an example of a specification attached to the return shown in FIG. 8. [Figure 10] 3 is a flowchart showing a tobacco tax refund application support method according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0011] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The following describes embodiments of the present invention. Note that the following embodiments are merely examples, and the present invention is not limited to the configurations of the following embodiments.

[0012] [overview] Before describing the details of a tobacco tax refund application support system (hereinafter, sometimes referred to as the present system) 1 according to this embodiment, an overview of the features of the present system 1 will be described. The system 1 includes at least an information acquiring means and a generating means. The information acquisition means acquires quantity information about tobacco products lost in the disaster (hereinafter sometimes abbreviated as lost tobacco products) in a plurality of affected stores in a specified administrative district. The generation means generates data for a tobacco tax refund return form that aggregates the data for the multiple affected stores based on the quantity information acquired by the information acquisition means, to be submitted to the specified administrative district.

[0013] "Prescribed administrative district" means any administrative district that is the tax place for filing a return for tobacco tax refund. For prefectural tobacco tax, each prefecture is a prescribed administrative district, and for ward, city, town, and village tobacco tax, each ward, city, town, and village is a prescribed administrative district. "Multiple affected stores in a specified administrative district" refers to all or some of the affected stores in the specified administrative district that sell tobacco products and that can be handled by this system 1 and in which lost tobacco products occurred. The information acquisition means may acquire quantity information of lost tobacco products from all or some of the computers of the multiple affected stores via communication, or may derive quantity information of lost tobacco products using the information acquired from each computer, or may acquire the information using a method described later in detail in this embodiment. In addition, the quantity information acquired by the information acquisition means need only be quantity information that enables tobacco tax to be calculated using a tax calculation method that corresponds to the classification of the tobacco product, and may be information indicating the number of individually packaged tobacco products, or information indicating the number of cigarettes or the weight or price of tobacco leaves contained in the individually packaged tobacco product. The information acquiring means is exemplified as an information acquiring unit 20 in the details of this embodiment.

[0014] The data of the tobacco tax refund return generated by the generating means is return data in which the necessary information is filled in for the format of an amended return for the prefectural tobacco tax or ward / city / town / village tobacco tax to be submitted to the specified administrative district in order to receive a tobacco tax refund. This data may be data that can be output on a medium (paper, electronic data, etc.) determined by the specified administrative district so that the return can be accepted in the specified administrative district, and may be a data file itself stored in a computer memory, or may be print data to be printed on paper by a printer. The generating means is exemplified as a generating unit 24 in the details of this embodiment, and a declaration outputted from the data generated by the generating means is exemplified in FIG. 8 and FIG.

[0015] In this embodiment, quantity information on tobacco products lost in the disaster at multiple affected stores belonging to a specified administrative district is obtained, and data for tobacco tax refund declaration forms that should be submitted to the administrative district is generated based on that quantity information, tallying up the products for the multiple affected stores. This will significantly reduce the effort required for filing tobacco tax refunds compared to the task of compiling information on the quantity of lost tobacco products at each affected store for each administrative district and manually entering the information into refund forms.

[0016] [Tobacco tax refund application support system] The tobacco tax refund application support system (this system) 1 according to this embodiment having the above-mentioned characteristics will be described in detail below. FIG. 1 is a conceptual diagram of a system configuration of a tobacco tax refund application support system 1 according to this embodiment. This system 1 supports the filing of tobacco tax refund returns by persons such as distributors of tobacco products. The support provided by this system 1 is intended for a situation in which a sales company (including distributors) that sells tobacco products to sales stores acts as an intermediary between the government and sales stores to file tobacco tax refund returns, rather than a situation in which each sales store individually files a tobacco tax refund return. In the following explanation, an example will be given in which a distributor is a user of this system 1. For this reason, a store selling tobacco products may be referred to as a customer store 3, since it is a customer of the distributor, who is a user of this system 1. Customer stores 3 come in a variety of store formats, such as privately owned stores such as tobacco shops and liquor stores, franchised stores such as convenience stores and supermarkets, and directly managed stores operated by businesses.

[0017] The system 1 includes at least a support server 10, and in this embodiment, is configured to be able to communicate with a sales and logistics system 2 for tobacco products. The sales and logistics system 2 supports sales and logistics operations for tobacco products, and includes at least a customer information database (DB) 5 that stores delivery information, delivery record information, and the like for each customer store 3. In addition, in Fig. 1, the present system 1 and the sales and logistics system 2 are shown separately, but they may be configured as one integrated system. In this case, the present system 1 may be provided with a customer information DB5.

[0018] In the following description, when the number or quantity of "tobacco products" (delivered number, delivery quantity, demand number, demand quantity, stock number, stock quantity, etc.) is mentioned, it does not mean the number of cigarettes or cartridges contained in an individually packaged tobacco product, but the number of individually packaged tobacco products themselves. However, as long as it is quantitative information that allows tobacco tax to be calculated using a tax calculation method according to the classification of the tobacco product, it may also be quantitative information such as the number of cigarettes contained in an individually packaged tobacco product, the weight or price of tobacco leaves, etc.

[0019] The customer information DB 5 stores at least a customer information table, a stock master table, and a trading performance table as exemplified in FIG. 2, FIG. 3, and FIG. FIG. 2 is a diagram illustrating an example of a customer information table. The customer information table stores information for each customer store 3, such as store information and transaction terms. Specifically, as shown in Fig. 2, the customer information table stores the store ID, store name, store location, delivery frequency, etc. for each customer store 3. However, as will be described later, the customer information table only needs to store information that enables the derivation of the delivery interval and delivery date for each customer store 3, as well as the administrative district in which the local tobacco tax is paid, and may store data for items not illustrated in Fig. 2 (delivery base, delivery route, number of days required for order fulfillment, payment method, payment timing, order method, etc.).

[0020] The store ID is information (identifier) ​​that identifies a customer store. For example, each customer store that is a franchised store such as a convenience store or supermarket is assigned an individual store ID. The store name indicates the name of the customer store. The store location indicates the location of the customer store. The store location may be any information that can derive the administrative district in which the local tobacco tax is paid. The delivery frequency indicates the frequency of delivery of tobacco products to a customer store, and is set, for example, three times a week, once a week, every other week, every four weeks, once a month, etc. In this embodiment, as described below, this delivery frequency is used as the delivery interval for each customer store 3.

[0021] FIG. 3 is a diagram illustrating an example of a brand master table. The brand master table stores brand information such as brand ID, brand name, tobacco classification, price, tar content, nicotine content, number of individual packs, weight information, etc. for each brand of tobacco product, as exemplified in Fig. 3. Note that the brand master table only needs to store information that can identify the tax calculation method for each brand of tobacco product, as described below, and may also store other brand information such as order start date, discontinuation date, smoking taste, etc., which are not exemplified in Fig. 3.

[0022] The brand ID is information that can identify the brand of a tobacco product, and is an identifier given to each brand that is the product unit that is the subject of order allocation or inventory allocation. The brand ID can also be called the brand code. Each brand record stored in the brand master table contains a unique brand ID. The issue name indicates the name of the issue identified by the issue ID. The tobacco classification indicates a classification that can specify the tax calculation method for the brand of tobacco product identified by the brand ID. For example, tobacco classification "10" indicates cigarettes, tobacco classification "20" indicates heated tobacco, and other tobacco classifications are provided that indicate cigars, shredded tobacco, snuff, etc. The price indicates the price of the stock identified by the stock ID. The tar amount and nicotine amount indicate the tar amount and nicotine amount of the brand identified by the brand ID. The number of individual packages indicates the number of cigarettes or cartridges contained in a tobacco product (individually packaged product) of the brand identified by the brand ID. The weight information indicates the weight of tobacco leaves used in the tax calculation method for tobacco products other than cigarettes, such as cigars, tobacco shreds, snuff, and heated tobacco products.

[0023] FIG. 4 is a diagram illustrating an example of a transaction record table. The transaction history table stores delivery history information of tobacco products to customer stores 3 by distributors who are users of the present system 1. In the example of Fig. 4, the transaction history table stores the invoice number, delivery date, store ID, brand ID, delivery quantity, etc. for each transaction with a customer store 3 during a specified period. The store ID is the same as the store ID stored in the above-mentioned customer information table, and the issue ID is the same as the issue ID stored in the above-mentioned issue master table. The delivery quantity refers to the number of tobacco products (individually packaged products) of the brand specified by the brand ID. However, the total number of cigarettes or cartridges contained in the delivered individually packaged products may be stored as the delivery quantity, or the number of carton products in which multiple individually packaged products of the same brand are packaged together may be stored as the delivery quantity.

[0024] In this embodiment, as described later, based on the delivery history information stored in this transaction history table, the daily demand for tobacco products (number of products sold to customers) for each customer store 3 is predicted, and the closest delivery date before the disaster is obtained for each customer store 3. The most recent delivery date before the disaster means the most recent date on which tobacco products were delivered to the customer store 3 before the disaster occurred. For this reason, the delivery performance information only needs to store information that can predict the daily demand for each brand of tobacco product for each customer store 3 and information that can obtain the most recent delivery date before the disaster for each customer store 3, and it is not necessary for some of the items illustrated in Figure 4 to be stored, and information on other items not illustrated in Figure 4 may be stored. In addition, the period of delivery history information stored in the transaction history table is set to six months or more in this embodiment, but it may be unlimited, or may be set to a period long enough to predict the demand quantity described above.

[0025] [Support Server] FIG. 5 is a block diagram conceptually showing the hardware configuration of the support server 10. As shown in FIG. The support server 10 is a so-called computer, and includes a CPU (Central Processing Unit) 11, a memory 12, an input / output interface (I / F) 13, a communication unit 14, etc., as shown in Fig. 5. The CPU 11 is connected to each of the other units by a communication line such as a bus. The CPU 11 includes not only a general CPU, but also a micro controller unit (MCU), a micro processing unit (MPU), an application specific integrated circuit (ASIC), a digital signal processor (DSP), a graphics processing unit (GPU), and the like. The memory 12 is a random access memory (RAM), a read only memory (ROM), or an auxiliary storage device (such as a hard disk).

[0026] The input / output I / F 13 can be connected to user interface devices such as an output device 15 and an input device 16 . The output device 15 is a device that performs some kind of output to a user, such as a display device, a printing device (printer), etc. The display device is a device that displays a screen corresponding to drawing data processed by the CPU 11, etc., such as an LCD (Liquid Crystal Display) or a CRT (Cathode Ray Tube) display. The input device 16 is a device that accepts input of user operations, such as a keyboard, a mouse, etc. The display device and the input device 16 may be an integrated touch panel, or may not be connected. The communication unit 14 performs wired or wireless communication with other computers and exchanges signals with other devices. In this embodiment, the communication unit 14 can communicate with a computer having a customer information DB5 of the sales and logistics system 2. A portable recording medium or the like can also be connected to the communication unit 14.

[0027] The hardware configuration shown in Fig. 5 is an example, and the hardware configuration of the support server 10 is not limited to the example shown in Fig. 5. The support server 10 may have other hardware elements not shown, and the number of each hardware element is not limited to the example in Fig. 5. For example, the support server 10 may have multiple CPUs 11. Furthermore, the support server 10 may be composed of multiple computers.

[0028] FIG. 6 is a block diagram conceptually showing an example of the software configuration of the support server 10. As shown in FIG. The support server 10 has, as software elements, an information acquisition unit 20, a store identification unit 21, an inventory acquisition unit 22, an estimation unit 23, a generation unit 24, a data reference unit 25, etc. Each of these software elements is realized, for example, by the CPU 11 executing a computer program stored in the memory 12. In addition, the computer program may be installed from a portable recording medium such as a CD (Compact Disc) or a memory card, or from another computer on a network, via the input / output I / F 13 or the communication unit 14, and stored in the memory 12.

[0029] In response to instructions from other software elements, the data reference unit 25 refers to the various tables described above stored in the customer information DB5 by communication via the communication unit 14. When the customer information DB5 is realized in the memory 12 of the support server 10, the data reference unit 25 can directly refer to the customer information DB5. The data reference unit 25 refers to the various tables stored in the customer information DB5 and reads out necessary information from the various tables. For example, the data reference unit 25 can read out customer information of the affected store from the customer information table using the store ID of the affected store. The data reference unit 25 can also read out delivery record information of the affected store from the transaction record table using the store ID of the affected store. Furthermore, the data reference unit 25 can read out tobacco classification, price, number of individual packages, weight information, etc. relating to the brand of the lost tobacco product from the brand master table using the brand ID of the brand of the lost tobacco product.

[0030] The information acquisition unit 20 includes a store identification unit 21, an inventory acquisition unit 22, and an estimation unit 23, and acquires quantity information of lost tobacco products in a plurality of disaster-affected stores belonging to a specified administrative district. As described below, for the affected stores identified by the store identification unit 21, the quantity of lost tobacco products is estimated by processing by the inventory acquisition unit 22 and the estimation unit 23. On the other hand, if there are affected stores that have not been identified by the store identification unit 21, the information acquisition unit 20 can separately acquire quantity information of lost tobacco products in those affected stores. Therefore, the information acquisition unit 20 may cause an input screen such as that shown in Fig. 7 to be displayed on the output device 15, and may cause quantity information of lost tobacco products in one or more affected stores that have not been identified by the store identification unit 21 to be input collectively.

[0031] FIG. 7 shows a screen for inputting the quantity of tobacco products lost in a disaster (lost tobacco products). The input screen illustrated in Fig. 7 allows the user to select the target year and month and the target administrative district. Furthermore, this input screen provides a screen element that allows the user to input the brand ID (brand code) of the lost tobacco product, and a screen element that allows the user to input the lost quantity of the tobacco product of the brand that corresponds to the input brand ID. In addition, the input screen for quantity information of lost tobacco products is not limited to the example of Figure 7, and may be capable of inputting information that identifies affected stores, or may be configured to allow the user to input the quantity of lost tobacco products for each affected store.

[0032] The store identification unit 21 identifies disaster-affected stores. Specifically, the store identification unit 21 identifies, from among all customer stores 3 whose information is stored in the customer information table (see FIG. 2), one or more customer stores 3 in which lost tobacco products occurred due to the target disaster as disaster-affected stores. The store identification unit 21 extracts the store ID of the customer store 3 identified as a disaster-affected store.

[0033] The method of identifying the affected stores by the store identification unit 21 is not limited. For example, the store identification unit 21 can display on the output device 15 a list of customer stores 3 whose information is stored in the customer information table, and identify a customer store 3 selected from the list by a user operation using the input device 16 as the affected store. At this time, the store identification unit 21 may display all information stored in the customer information table on the output device 15. The store identification unit 21 can also obtain store information (store name, store location, etc.) related to the affected stores from the sales logistics system 2 or an external computer operated by a customer representative through communication, and use the store information to search the customer information table to extract the store ID of the affected store. Of course, the store identification unit 21 may obtain the store ID itself of the affected store from an external computer through communication.

[0034] In addition, when identifying a disaster-affected store, the store identification unit 21 acquires information on the day that the disaster-affected store was damaged by the target disaster as disaster day information for each disaster-affected store. The store identification unit 21 can acquire the disaster day information input by a user operation using the input device 16, or can acquire the disaster day information from an external computer.

[0035] The inventory acquisition unit 22 acquires pre-disaster inventory information indicating the inventory quantity of tobacco products in the affected store identified by the store identification unit 21 immediately prior to the disaster. Here, "just before the disaster" may be the disaster date indicated by the disaster date information, or the day before the disaster date, or, if information granularity is required in time units finer than date units, it may be the date and time of the disaster, the opening time on the disaster day, or the closing time on the day before the disaster day.

[0036] The inventory acquisition unit 22 may acquire this pre-disaster inventory information by distinguishing between brands of tobacco products, or may acquire it without distinguishing between brands of tobacco products. In this embodiment, the inventory acquisition unit 22 acquires pre-disaster inventory information indicating the inventory quantity of each brand of tobacco products immediately before the disaster in the disaster-stricken store identified by the store identification unit 21.

[0037] The inventory acquisition unit 22 may acquire the inventory information of a disaster-stricken store immediately before the disaster via communication from a computer (such as a computer connected to a tobacco fixture) of the disaster-stricken store (customer store 3), or may acquire the inventory information immediately before the disaster input by user operation using the input device 16. In this embodiment, the inventory acquisition unit 22 can estimate the pre-disaster inventory quantity by the following method.

[0038] When estimating the inventory quantity immediately before a disaster, the inventory acquisition unit 22 first acquires delivery record information indicating the quantity of tobacco products delivered within a specified period to the disaster-stricken store identified by the store identification unit 21, and delivery interval information for tobacco products to that disaster-stricken store. Specifically, the inventory acquisition unit 22 causes the data reference unit 25 to access the transaction history table, thereby extracting from the transaction history table delivery history information (delivery date, store ID, brand ID, delivery quantity, etc.) that is linked to the store ID of the disaster-stricken store extracted by the store identification unit 21 and whose delivery date falls within a predetermined period. The predetermined period is set to any period before the disaster date, but since a period that is too long increases processing time and a period that is too short reduces estimation accuracy, it is preferably set to between one month and one year, and is set to six months in this embodiment. In addition, the inventory acquisition unit 22 causes the data reference unit 25 to access the customer information table, extracts delivery frequency information linked to the store ID of the affected store from the customer information table, and derives the delivery interval of tobacco products to the affected store from the delivery frequency indicated by this extracted information. For example, if the delivery frequency is once a week, the delivery interval is set to 7 days, and if the delivery frequency is once a month, the delivery interval is set to 30 days (31 days is also acceptable).

[0039] Furthermore, the inventory acquisition unit 22 estimates the daily sales quantity of tobacco products sold to customers in the affected store based on the delivery record information of the affected store acquired as described above. For example, assuming that all tobacco products delivered to a customer store 3 are sold, the number of deliveries per day is regarded as the number of sales per day. In this case, the inventory acquisition unit 22 can estimate the sales quantity per day of tobacco products sold to customers in the affected store by dividing the total number of deliveries of tobacco products during a specified period indicated by the extracted delivery record information by the number of days in the specified period. In addition, the ratio of the number of sales to the number of deliveries may be stored in advance, taking into account unsold items, and the sales volume per day may be estimated by applying this ratio to the total number of deliveries within a specified period and dividing the resulting sales number by the number of days in the specified period. The inventory acquisition unit 22 can estimate the inventory quantity immediately before the disaster using at least the daily sales quantity at the affected store estimated in this manner and the delivery interval days for the affected store derived as described above, using various methods such as the following.

[0040] <<First estimation method for inventory quantity immediately before a disaster>> The inventory acquisition unit 22 estimates the inventory quantity of tobacco products in the affected stores immediately before the disaster based on the daily sales quantity estimated as described above, the delivery interval days derived as described above, and an inventory multiplier indicating the ratio of the inventory quantity to the sales quantity. Here, the quantity obtained by multiplying the sales quantity per day by the number of days between deliveries can be considered to be the sales quantity until the next delivery date, and can also be regarded as the minimum inventory quantity that the customer store 3 will need to hold until the next delivery date. In order to avoid opportunity losses, customer stores 3 generally hold more inventory than the minimum inventory quantity. Therefore, the inventory acquisition unit 22 can determine the number obtained by multiplying the daily sales quantity, the number of days between deliveries, and an inventory multiplication factor indicating the ratio of the inventory quantity to the sales quantity as the inventory quantity of tobacco products in the affected store immediately before the disaster. The inventory multiplier is preferably set to an appropriate value (for example, 1.5 to 2.5 times) based on the trends and track record of retail stores selling tobacco products, and is set to 2 times in this embodiment.

[0041] <<Second estimation method for inventory quantity immediately before a disaster>> In the second estimation method, the inventory acquisition unit 22 further acquires a pre-disaster most recent delivery date, which is the most recent date on which tobacco products were delivered to the disaster-stricken store before the disaster occurred. In this embodiment, the inventory acquisition unit 22 regards the delivery date as the delivery date based on the delivery date information of the delivery performance information of the disaster-stricken store acquired as described above, and identifies the delivery date before the disaster date and most recent among the delivery dates to the disaster-stricken store as the pre-disaster most recent delivery date. However, the inventory acquisition unit 22 may extract the delivery date to the disaster-stricken store from information stored in another table.

[0042] Furthermore, the inventory acquisition unit 22 estimates the sales quantity of tobacco products sold to customers at the affected store between the date of the most recent delivery before the disaster and the date of the disaster as the pre-disaster sales quantity, based on the daily sales quantity at the affected store estimated as described above. For example, the inventory acquisition unit 22 can estimate the pre-disaster sales quantity by multiplying the daily sales quantity at the affected store by the number of days from the date of the most recent delivery before the disaster to the date of the disaster. The second estimation method regards the number obtained by multiplying the daily sales quantity, the delivery interval, and the above-mentioned inventory multiplier as the inventory quantity on the most recent delivery day before the disaster, and regards the number obtained by subtracting the pre-disaster sales quantity estimated as above from the inventory quantity on the most recent delivery day before the disaster as the inventory quantity of tobacco products in the affected store just before the disaster. That is, in the second estimation method, the inventory acquisition unit 22 estimates the inventory quantity of tobacco products on the most recent delivery day before the disaster in the affected store by multiplying the delivery interval, the daily sales quantity, and the inventory multiplier, and estimates the inventory quantity of tobacco products in the affected store just before the disaster by subtracting the pre-disaster sales quantity from the estimated inventory quantity of tobacco products on the most recent delivery day before the disaster.

[0043] The above-mentioned second estimation method assumes that the daily sales quantity calculated from delivery performance information will be depleted from inventory each day between the most recent delivery date before the disaster and the next delivery date, but it is also possible to estimate the inventory quantity immediately before the disaster based on the decreasing trend of the inventory multiplier, that is, how the inventory multiplier to the above-mentioned minimum inventory quantity on the most recent delivery date before the disaster decreases between the most recent delivery date before the disaster and the next delivery date. In this approach, if the inventory multiplier on the most recent delivery date before the disaster to the minimum inventory quantity on the most recent delivery date before the disaster is α, and the inventory multiplier on the next delivery date to the minimum inventory quantity on the most recent delivery date before the disaster is β, then if (α-β) is 1, the inventory reduction quantity between the most recent delivery date before the disaster and the next delivery date will be equal to the minimum inventory quantity, in other words, this is equivalent to the daily sales quantity being depleted from inventory each day, and so this coincides with the second estimation method described above. On the other hand, if 0<(α-β)<1 or 1<(α-β), the inventory quantity immediately before the disaster can be calculated using the following formula.

[0044] Stock quantity just before the disaster = [Minimum stock quantity on the nearest delivery date before the disaster] x A A = α-(α-β) × D / T α and β are as described above, A indicates the inventory ratio immediately before the disaster to the minimum inventory quantity on the most recent delivery date before the disaster, D indicates the number of days from the most recent delivery date before the disaster to the day of the disaster, and T indicates the number of days between deliveries. Here, as described above, the minimum inventory quantity on the nearest delivery date before the disaster can be calculated by [sales quantity per day] × T. Therefore, the above formula can be expressed as follows. Inventory quantity just before the disaster = [Sales quantity per day] × T × {α-(α-β) × D / T} = [Sales quantity per day] × T × α-[Sales quantity per day] × (α-β) × D Furthermore, as mentioned above, the number obtained by multiplying the daily sales volume, the number of days between deliveries (T), and the inventory multiplier (α) indicates the inventory volume on the most recent delivery day before the disaster. Therefore, the above formula can be further expressed as follows. Inventory quantity just before the disaster = [Inventory quantity on the most recent delivery date before the disaster] - [Sales quantity per day] x (α-β) x D

[0045] Therefore, the estimation method of the pre-disaster sales quantity in the above-mentioned second estimation method may be modified to calculate as follows: That is, the inventory acquisition unit 22 assumes that the quantity obtained by multiplying the delivery interval days (T) and the estimated daily sales quantity is the minimum inventory quantity on the nearest delivery day before the disaster, and assumes that the inventory ratio of the nearest delivery day before the disaster to the minimum inventory quantity on the nearest delivery day before the disaster is α, and the inventory ratio of the next delivery day to the minimum inventory quantity on the nearest delivery day before the disaster is β, and estimates the quantity obtained by multiplying the daily sales quantity, the number of days (D) from the nearest delivery day before the disaster to the disaster day, and (α-β) as the pre-disaster sales quantity.

[0046] <<Third estimation method for inventory quantity immediately before a disaster>> In the second estimation method described above, the inventory multiplier α relative to the minimum inventory quantity on the most recent delivery date before the disaster was used to estimate the inventory quantity on the most recent delivery date before the disaster, but the inventory quantity on the most recent delivery date before the disaster may also be estimated taking into account the quantity of tobacco products delivered on that most recent delivery date before the disaster. In the third estimation method, the inventory quantity on the most recent delivery date before the disaster is estimated as the minimum inventory quantity on the most recent delivery date before the disaster plus the quantity of tobacco products delivered on that most recent delivery date before the disaster.

[0047] That is, in the third estimation method, the inventory acquisition unit 22 further acquires pre-disaster most recent delivery quantity information indicating the quantity of tobacco products delivered to the affected store on the pre-disaster most recent delivery date. The inventory acquisition unit 22 causes the data reference unit 25 to access the transaction record table to extract delivery record information linked to the store ID of the affected store and having a delivery date that is the most recent day before the disaster date from the transaction record table, and sets the delivery quantity in the delivery record information as the pre-disaster most recent delivery quantity. Furthermore, the inventory acquisition unit 22 estimates the inventory quantity of tobacco products in the affected store on the most recent delivery date before the disaster by adding the most recent delivery quantity before the disaster to the minimum inventory quantity on the most recent delivery date before the disaster, obtained by multiplying the delivery interval days and the daily sales quantity, and estimates the inventory quantity of tobacco products in the affected store immediately before the disaster by subtracting the pre-disaster sales quantity estimated by the second estimation method described above from this estimated inventory quantity.

[0048] In the third estimation method, the inventory acquisition unit 22 further compares the immediately before disaster inventory quantity estimated by either the first estimation method or the second estimation method (first immediately before disaster inventory quantity) with the immediately before disaster inventory quantity estimated by the third estimation method (second immediately before disaster inventory quantity), and finally determines one of them as the immediately before disaster inventory quantity of tobacco products in the affected store. For example, the inventory acquisition unit 22 determines the larger of the first immediately before disaster inventory quantity estimated by either the first estimation method or the second estimation method, and the second immediately before disaster inventory quantity estimated by the third estimation method, as the immediately before disaster inventory quantity of tobacco products in the affected store.

[0049] As described above, according to this embodiment, it is possible to estimate the inventory quantity of tobacco products in a disaster-stricken store immediately prior to the disaster using any one of the first, second, or third estimation methods. The first estimation method reduces the processing load and enables the inventory quantity immediately prior to a disaster to be estimated more quickly, while the second and third estimation methods impose a higher processing load than the first estimation method but enable the inventory quantity immediately prior to a disaster to be estimated with greater accuracy.

[0050] Although not specified in the above description, the inventory acquisition unit 22 can estimate the immediately pre-disaster inventory quantity for each brand of tobacco product. In this case, the daily sales quantity for each brand of tobacco product may be estimated based on delivery performance information for each brand of tobacco product, and the immediately pre-disaster delivery quantity may also be acquired for each brand of tobacco product. In this case, the number of days between deliveries may be acquired for each brand of tobacco product, or may be acquired as information for all brands at once.

[0051] The estimation unit 23 uses at least the pre-disaster inventory information acquired by the inventory acquisition unit 22 to estimate the quantity of tobacco products lost in the disaster at the affected stores. The estimation unit 23 may determine the quantity of lost tobacco products as the pre-disaster stock quantity indicated by the pre-disaster stock information as is, or may determine the quantity of lost tobacco products as a predetermined percentage (for example, 80%) of the pre-disaster stock quantity. The estimation unit 23 can also calculate the number of lost tobacco products by subtracting the inventory quantity of tobacco products in the affected store immediately after the disaster from the inventory quantity immediately before the disaster. The inventory quantity immediately after the disaster may be information input by a user operation using the input device 16, or may be information obtained by communication from another computer.

[0052] The estimation unit 23 may estimate the quantity of each brand of tobacco products lost in the disaster based on the pre-disaster inventory quantity for each brand indicated by the pre-disaster inventory information. In this case, the estimation unit 23 may obtain the inventory quantity of each brand of tobacco products in the affected store immediately after the disaster, and calculate the quantity of lost tobacco products for each brand by subtracting the inventory quantity immediately after the disaster from the pre-disaster inventory quantity for each brand of tobacco products.

[0053] While it would be ideal if inventory information of tobacco products at each customer store 3 could be collected appropriately by the present system 1, the sales and logistics system 2, etc., there may be customer stores 3 for which it is difficult to automatically collect inventory information. Therefore, in this embodiment, the inventory quantity of tobacco products in the affected stores immediately before the disaster is estimated with high accuracy using information managed by the present system 1, i.e., information indicating the number of days between deliveries of tobacco products to each customer store 3, and delivery record information of tobacco products to each customer store 3, etc., and the quantity of lost tobacco products in the affected stores is estimated based on the estimated inventory quantity immediately before the disaster. Therefore, according to this embodiment, even if a customer store 3 that does not have a well-developed IT equipment environment is affected by a disaster, the pre-disaster stock quantity at that customer store 3 can be obtained.

[0054] The generation unit 24 generates data for tobacco tax refund declarations that are aggregated for multiple disaster-stricken stores to be submitted to a specified administrative district, based on the quantity information of lost tobacco products in the disaster-stricken stores acquired by the information acquisition unit 20. Specifically, the generation unit 24 aggregates the quantities of lost tobacco products in each disaster-stricken store for each administrative district to which the disaster-stricken store belongs, converts the quantities of lost tobacco products aggregated for each administrative district into a standard quantity (number of cigarettes) for which tobacco tax can be calculated using a tax calculation method according to the classification of the tobacco product, and calculates the total amount of tobacco tax on the lost tobacco products. At this time, the generating unit 24 instructs the data reference unit 25 to access the brand master table, thereby extracting brand information to be used in a tax calculation method according to the classification of the tobacco product from the brand master table. For example, the generating unit 24 can extract tobacco classification, price, number of individual packages, weight information, etc. related to the brand of the lost tobacco product from the brand master table using the brand ID.

[0055] In addition, when quantity information of lost tobacco products is obtained through an input screen such as that illustrated in Figure 7, the generation unit 24 adds the quantity of lost tobacco products estimated by the processing of the inventory acquisition unit 22 and the estimation unit 23 for the affected store identified by the store identification unit 21 to the quantity of lost tobacco products obtained separately, and performs tallying. The generation unit 24 then generates tax return data by inputting the information calculated in this manner into the necessary fields of the format for an amended tax return for the prefecture tobacco tax or ward / city / town / village tobacco tax to be submitted to the administrative district.

[0056] FIG. 8 is a diagram showing an example of an amended tobacco tax return, and FIG. 9 is a diagram showing an example of a statement of facts attached to the return shown in FIG. For example, the generation unit 24 generates tax return data that enables printing of the amended tax return shown in Fig. 8 and the detailed statement shown in Fig. 9. For this reason, it can be expressed as the generation unit 24 generating detailed statement data for a tax refund return that aggregates the quantities of each brand of tobacco products lost in the disaster for multiple affected stores. The generating unit 24 can hold in advance information on the place of filing and the declarant in the amended tax return and the detailed statement for each administrative district to which the return is to be filed. In addition, information on the tax base quantity and tax amount, and the total tax amount in the amended tax return can be input by separately obtaining information on the tobacco tax already paid. The generating unit 24 may set the base quantity of the lost tobacco products and the total amount of tobacco tax converted as described above in the number and amount columns for which a refund credit is sought in the amended tax return. The generating unit 24 may also set the brand name, brand ID, and converted base quantity (number of cigarettes) for each brand of lost tobacco products in the item and quantity columns in the statement.

[0057] [Tobacco tax refund application support method] The tobacco tax refund claim support method according to this embodiment (hereinafter, sometimes abbreviated as this method) will be described below with reference to Fig. 10. Fig. 10 is a flow chart showing the steps of the tobacco tax refund claim support method according to this embodiment. This method is executed by one or more computers including at least one processor and memory, such as the above-mentioned support server 10. Note that the specific content of each step included in this method is similar to the processing content of each software element of the above-mentioned support server 10, and therefore will be omitted as appropriate.

[0058] First, the support server 10 identifies disaster-affected stores (S101). Specifically, the support server 10 identifies one or more customer stores 3 that have lost tobacco products due to the target disaster as disaster-affected stores from among all customer stores 3 whose information is stored in the customer information table (see FIG. 2), and extracts the store IDs of the customer stores 3 identified as disaster-affected stores. The specific method of identifying disaster-affected stores is as described above with respect to the store identification unit 21. The support server 10 selects one of the disaster-stricken stores identified in (S101), and executes the following steps for the selected disaster-stricken store (hereinafter, referred to as the selected disaster-stricken store).

[0059] In (S102), the support server 10 acquires delivery record information indicating the quantity of tobacco products delivered to one disaster-stricken store (selected disaster-stricken store) selected as described above within a predetermined period and delivery interval information of tobacco products to the selected disaster-stricken store. For example, the support server 10 extracts delivery record information (delivery date, store ID, brand ID, delivery quantity, etc.) linked to the store ID of the selected disaster-stricken store and whose delivery date is within a predetermined period (e.g., six months) from the transaction record table of the customer information DB5. Furthermore, the support server 10 extracts delivery frequency information linked to the store ID of the selected disaster-stricken store from the customer information table of the customer information DB5, and derives the delivery interval of tobacco products to the selected disaster-stricken store from the delivery frequency indicated by this extracted information. However, the specific method of acquiring the delivery record information and the delivery interval information is not limited to this example. The delivery interval information may be derived from the delivery date indicated in the delivery record information.

[0060] Furthermore, the support server 10 acquires information on the most recent delivery date before the disaster, which is the most recent date on which tobacco products were delivered to the selected affected store before the disaster occurred (S103). For example, the support server 10 can identify the most recent delivery date before the disaster from the delivery record information acquired in (S102). However, the specific method of acquiring the closest delivery date before the disaster is not limited to this example.

[0061] The support server 10 also acquires information on the disaster date of the selected disaster-stricken store (S104). The information on the disaster date may be information input by a user operation using the input device 16, or may be information acquired from an external computer. Furthermore, instead of acquiring information on the disaster date for each disaster-stricken store, information on the disaster date may be acquired as common information for all disaster-stricken stores.

[0062] Next, the support server 10 estimates the daily sales volume of tobacco products sold to customers at the selected disaster-stricken store based on the delivery record information of the selected disaster-stricken store acquired in (S102) (S105). The method of estimating the daily sales volume of tobacco products from the delivery record information is as described above.

[0063] The support server 10 estimates the immediately before disaster stock quantity of the selected disaster-stricken store by using at least the daily sales quantity of the selected disaster-stricken store estimated in (S105) and the delivery interval information of the selected disaster-stricken store acquired in (S102). Various methods are available for estimating the immediately before disaster stock quantity, for example, the first, second, and third estimation methods described above. Since Fig. 10 illustrates the third estimation method (including the second estimation method), the description will be given along with the example of Fig. 10. However, other methods not illustrated in Fig. 10 may be used as the estimation method of the inventory quantity immediately before the disaster.

[0064] The support server 10 estimates (S106) the inventory quantity of the selected disaster-stricken store on the most recent delivery date before the disaster acquired in (S103) for the selected disaster-stricken store. Specifically, the support server 10 estimates the inventory quantity of the selected disaster-stricken store on the most recent delivery date before the disaster by multiplying the daily sales quantity of tobacco products estimated in (S105), the delivery interval days acquired in (S102), and a pre-stored inventory multiplier. The inventory multiplier is as described above and is set to, for example, 2x.

[0065] The support server 10 further estimates the sales quantity of tobacco products sold to customers at the affected store between the date of the most recent delivery before the disaster and the date of the disaster as the pre-disaster sales quantity (S107), based on the sales quantity per day at the selected affected store estimated in (S105). For example, the support server 10 can estimate the pre-disaster sales quantity by multiplying the sales quantity per day at the affected store by the number of days from the date of the most recent delivery before the disaster to the date of the disaster.

[0066] The support server 10 estimates (S108) a first pre-disaster stock quantity of tobacco products at the selected disaster-stricken store by subtracting (S107) the pre-disaster sales quantity estimated from (S106) the stock quantity on the nearest pre-disaster delivery date for the selected disaster-stricken store.

[0067] The support server 10 further acquires pre-disaster most recent delivery quantity information indicating the quantity of tobacco products delivered to the selected disaster-stricken store on the pre-disaster most recent delivery date acquired in (S103) for the selected disaster-stricken store (S109). For example, the support server 10 can extract delivery record information linked to the store ID of the selected disaster-stricken store and having a delivery date that is the most recent day before the disaster date from the transaction record table of the customer information DB5, and set the delivery quantity of the delivery record information as the pre-disaster most recent delivery quantity. However, the specific method of acquiring the pre-disaster immediate delivery quantity of the selected disaster-affected store is not limited to this example.

[0068] The support server 10 estimates the inventory quantity of tobacco products in the selected disaster-stricken store on the nearest delivery date before the disaster using a method other than (S106), and estimates the second immediately before the disaster inventory quantity of tobacco products in the selected disaster-stricken store by subtracting the pre-disaster sales quantity estimated in (S107) for the selected disaster-stricken store from the inventory quantity of tobacco products on the nearest delivery date before the disaster estimated using the other method (S110). As the other method, for example, a method of adding the immediately before the disaster delivery quantity obtained in (S109) to the quantity obtained by multiplying the number of days between deliveries obtained in (S102) for the selected disaster-stricken store by the daily sales quantity estimated in (S105). In this way, the above-mentioned inventory multiplication factor used in estimating the first immediately before the disaster inventory quantity is not used in estimating the second immediately before the disaster inventory quantity.

[0069] The support server 10 compares the first pre-disaster stock quantity estimated in (S108) with the second pre-disaster stock quantity estimated in (S110) for the selected disaster-stricken store, and determines either one as the final pre-disaster stock quantity of tobacco products in the selected disaster-stricken store (S111). For example, the support server 10 determines the larger of the first pre-disaster stock quantity and the second pre-disaster stock quantity as the pre-disaster stock quantity of tobacco products in the disaster-stricken store.

[0070] Then, the support server 10 estimates the quantity of lost tobacco products in the selected affected store (S112) using at least the pre-disaster inventory quantity determined in (S111). The support server 10 may use the pre-disaster inventory quantity as is as the quantity of lost tobacco products, or may use a predetermined percentage (e.g., 80%) of the pre-disaster inventory quantity as the quantity of lost tobacco products, or may calculate the quantity of lost tobacco products by subtracting the inventory quantity of tobacco products in the affected store immediately after the disaster from the pre-disaster inventory quantity. The inventory quantity immediately after the disaster may be information input by a user operation using the input device 16, or may be information obtained by communication from another computer.

[0071] The support server 10 repeats the process until it has completed estimating the quantity of lost tobacco products for all the affected stores identified in (S101) (S113; YES). When the support server 10 completes the estimation of the quantity of lost tobacco products for all the disaster-stricken stores identified in (S101) (S113; NO), it tallies up the quantity of lost tobacco products for each disaster-stricken store for each administrative district to which the disaster-stricken store belongs (S114). In this tallying up, if there is quantity information of lost tobacco products obtained by another method (such as the input screen exemplified in FIG. 7) for disaster-stricken stores other than the disaster-stricken stores identified in (S101), the quantity obtained by the other method may be added to the quantity of lost tobacco products for all the disaster-stricken stores identified in (S101).

[0072] Finally, the support server 10 generates data for an amended prefectural or municipal tobacco tax return and statement to be submitted for each administrative district based on the quantity of lost tobacco products for each administrative district tallied in (S114) (S115). The specific method for generating the amended return and statement data and the details of the data are as described above. Here, when the invoice data is generated in (S115), quantity information needs to be set for each brand of lost tobacco products in the invoice data. Therefore, the daily sales quantity estimated in (S105), the inventory quantity on the most recent delivery date before the disaster estimated in (S106), the pre-disaster sales quantity estimated in (S107), the first pre-disaster inventory quantity estimated in (S108), the most recent delivery quantity before the disaster acquired in (S109), the second pre-disaster inventory quantity estimated in (S110), the pre-disaster inventory quantity determined in (S111), and the quantity of lost tobacco products estimated in (S112) are the quantities for each brand of tobacco products. In addition, the delivery record information acquired in at least (S102) is also delivery record information for each brand of tobacco products. However, the number of days between delivery intervals indicated by the delivery interval information obtained in (S102) and the most recent delivery date before the disaster obtained in (S103) may be information for each brand of tobacco product, or may be information common to all brands.

[0073] [Variations] The above-described embodiment is merely an example, and the above-described contents can be modified as appropriate without departing from the spirit and scope of the invention. For example, in the above embodiment, the data for the amended tax return and the detailed statement are generated as the data for the tobacco tax refund return, but the detailed statement does not have to be generated. In this case, the quantity of lost tobacco products does not have to be estimated for each brand.

[0074] Furthermore, FIG. 10 shows only one example of the flow of the present method, and the order of execution of each step shown in FIG. 10 can be changed as appropriate. For example, if multiple damaged stores are identified, steps (S102) to (S112) for each damaged store may be executed in parallel. Alternatively, a step of designating a certain administrative district may be performed first, and in (S101) only affected stores that belong to the administrative district designated in the previous step may be identified. In this case, data for an amended tax return and a statement of details for either the prefectural tobacco tax or the ward, city, town, or village tobacco tax may be generated according to the designated administrative district. Also, before designating an administrative district, a step of selecting either the prefectural tobacco tax or the ward, city, town, or village tobacco tax as the tobacco tax for which a refund claim is to be filed may be performed first. In this case, for example, a screen for selecting which tobacco tax refund claim is to be filed may be displayed. Furthermore, the steps (S102), (S103), (S104) and (S109) may be executed in parallel, or the order of execution may be changed within the range that does not cause any problems.

[0075] Some or all of the above-described embodiments and modifications may be specified as follows: However, the above-described embodiments and modifications are not limited to the following descriptions. (1) An information acquisition means for acquiring information on the quantity of tobacco products lost in a disaster in a plurality of disaster-affected stores in a specified administrative district; A generating means for generating data of a tobacco tax refund declaration form that aggregates the data of the plurality of disaster-affected stores based on the acquired quantity information to be submitted to the predetermined administrative district; A tobacco tax refund application support system. (2) A store identification means for identifying at least one damaged store among the plurality of damaged stores; an inventory acquisition means for acquiring pre-disaster inventory information indicating the inventory quantity of tobacco products in the identified disaster-stricken store immediately prior to the disaster; an estimation means for estimating the quantity of tobacco products lost in the disaster in the identified disaster-affected store by using at least the acquired pre-disaster inventory information; The tobacco tax refund application support system according to (1) further comprises: (3) The inventory acquisition means acquires the immediately prior to the disaster inventory information indicating the inventory quantity of each brand of tobacco products in the identified affected store immediately prior to the disaster; The estimation means estimates the quantity of each brand of tobacco products lost in the disaster based on the inventory quantity of each brand indicated by the pre-disaster inventory information; The generating means generates detailed data of the refund claim form by tallying the quantities of each brand of tobacco products lost in the disaster for the plurality of affected stores. (2) A tobacco tax refund application support system. (4) The inventory acquisition means includes: Acquire delivery record information indicating the quantity of tobacco products delivered to the identified disaster-stricken store within a predetermined period and delivery interval information of the tobacco products to the disaster-stricken store; estimating a daily sales volume of tobacco products sold to customers at the identified affected store based on the acquired delivery record information; estimating a first pre-disaster inventory quantity of tobacco products in the identified affected store based on the number of delivery interval days indicated by the acquired delivery interval information, the estimated daily sales quantity, and an inventory multiplier indicating a ratio of the inventory quantity to the sales quantity; A tobacco tax refund application support system according to (2) or (3). (5) The inventory acquisition means includes: Further acquiring a most recent delivery date before the disaster, which is the most recent date on which tobacco products were delivered to the identified disaster-stricken store before the occurrence of the disaster; Based on the estimated daily sales volume, estimate a pre-disaster sales volume of tobacco products sold to customers at the identified disaster-affected store between the most recent delivery date before the disaster and the disaster date; multiplying the delivery interval days, the estimated daily sales quantity, and the inventory multiplier to estimate the inventory quantity of tobacco products in the identified affected store on the most recent delivery date before the disaster; estimating the first pre-disaster inventory quantity of tobacco products in the identified disaster-stricken store by subtracting the estimated pre-disaster sales quantity from the estimated pre-disaster inventory quantity of tobacco products on the nearest pre-disaster delivery date; (4) A tobacco tax refund application support system. (6) The inventory acquisition means assumes that the quantity obtained by multiplying the number of days between delivery intervals by the estimated daily sales quantity is the minimum inventory quantity on the most recent delivery day before the disaster, and assumes that the inventory ratio of the most recent delivery day before the disaster to the minimum inventory quantity on the most recent delivery day before the disaster is α, and the inventory ratio of the next delivery day to the minimum inventory quantity on the most recent delivery day before the disaster is β, and estimates the quantity obtained by multiplying the estimated daily sales quantity, the number of days from the most recent delivery day before the disaster to the disaster day, and (α-β) as the pre-disaster sales quantity. (5) A tobacco tax refund application support system. (7) The inventory acquisition means includes: Further acquiring pre-disaster most recent delivery quantity information indicating the quantity of tobacco products delivered to the identified disaster-stricken store on a pre-disaster most recent delivery date, which is the most recent date on which tobacco products were delivered to the identified disaster-stricken store before the occurrence of the disaster; Based on the estimated daily sales volume, estimate a pre-disaster sales volume of tobacco products sold to customers at the identified disaster-affected store between the most recent delivery date before the disaster and the disaster date; estimating the inventory quantity of tobacco products in the identified affected store on the most recent delivery date before the disaster based on the delivery interval days, the daily sales quantity, and the most recent delivery quantity information before the disaster; further estimating a second pre-disaster inventory quantity of the tobacco products in the identified disaster-stricken store by subtracting the estimated pre-disaster sales quantity from the estimated pre-disaster nearest delivery date inventory quantity of the tobacco products; comparing the first immediately-before-disaster inventory quantity with the estimated second immediately-before-disaster inventory quantity, and determining either the first immediately-before-disaster inventory quantity or the second immediately-before-disaster inventory quantity as the immediately-before-disaster inventory quantity of tobacco products in the identified affected store; A tobacco tax refund application support system according to any one of (4) to (6). (8) 1. A tobacco tax refund filing support method executed by one or more computers, comprising: the one or more computers: Acquire information on the quantity of tobacco products lost in a disaster at multiple affected stores in a specified administrative district; generating data for a tobacco tax refund declaration form that aggregates the amount of the plurality of affected stores based on the acquired quantity information to be submitted to the predetermined administrative district; A method to assist with filing tobacco tax refund claims, including: (9) the one or more computers: Identifying at least one damaged store among the plurality of damaged stores; acquire pre-disaster inventory information indicating the inventory quantity of tobacco products in the identified disaster-affected store immediately prior to the disaster; estimating the quantity of tobacco products lost in the disaster at the identified disaster-affected store using at least the acquired pre-disaster inventory information; The tobacco tax refund claim support method according to (8), further comprising: (10) the one or more computers: acquire the pre-disaster inventory information indicating the inventory quantity of each brand of tobacco products in the identified disaster-stricken store immediately before the disaster; estimating the quantity of each brand of tobacco products lost in the disaster based on the inventory quantity of each brand indicated by the acquired pre-disaster inventory information; It further includes: In the generation of the detailed statement data, the quantity of each brand of tobacco product lost in the disaster is totaled for the plurality of affected stores, and detailed statement data for the refund application is generated. (9) A method for supporting filing tobacco tax refund claims. (11) the one or more computers: Acquire delivery record information indicating the quantity of tobacco products delivered to the identified disaster-stricken store within a predetermined period and delivery interval information of the tobacco products to the disaster-stricken store; estimating a daily sales volume of tobacco products sold to customers at the identified affected store based on the acquired delivery record information; estimating a first pre-disaster inventory quantity of tobacco products in the identified affected store based on the number of delivery interval days indicated by the acquired delivery interval information, the estimated daily sales quantity, and an inventory multiplier indicating a ratio of the inventory quantity to the sales quantity; The tobacco tax refund claim support method according to (9) or (10), further comprising: (12) the one or more computers: obtain a most recent delivery date before the disaster, which is the most recent date on which tobacco products were delivered to the identified affected store before the occurrence of the disaster; Based on the estimated daily sales volume, estimate a pre-disaster sales volume of tobacco products sold to customers at the identified disaster-affected store between the most recent delivery date before the disaster and the disaster date; estimating the inventory quantity of tobacco products in the identified affected store on the most recent delivery date before the disaster by multiplying the number of days between deliveries, the estimated daily sales quantity, and the inventory multiplier; It further includes: In estimating the first pre-disaster inventory quantity, the first pre-disaster inventory quantity of the tobacco products in the identified disaster-stricken store is estimated by subtracting the estimated pre-disaster sales quantity from the estimated inventory quantity of the tobacco products on the nearest delivery date before the disaster; (11) A method for supporting filing tobacco tax refund claims. (13) the one or more computers: In estimating the pre-disaster sales quantity, the quantity obtained by multiplying the number of days between deliveries by the estimated daily sales quantity is assumed to be the minimum inventory quantity on the most recent delivery day before the disaster, and the inventory ratio of the most recent delivery day before the disaster to the minimum inventory quantity on the most recent delivery day before the disaster is set to α, and the inventory ratio of the next delivery day to the minimum inventory quantity on the most recent delivery day before the disaster is set to β. The quantity obtained by multiplying the estimated daily sales quantity, the number of days from the most recent delivery day before the disaster to the disaster day, and (α-β) is estimated as the pre-disaster sales quantity. (12) A tobacco tax refund claim support method as described above. (14) the one or more computers: acquire pre-disaster most recent delivery quantity information indicating the quantity of tobacco products delivered to the identified disaster-stricken store on a pre-disaster most recent delivery date, which is the most recent date on which tobacco products were delivered to the identified disaster-stricken store before the occurrence of the disaster; Based on the estimated daily sales volume, estimate a pre-disaster sales volume of tobacco products sold to customers at the identified disaster-affected store between the most recent delivery date before the disaster and the disaster date; estimating the inventory quantity of tobacco products in the identified affected store on the most recent delivery date before the disaster based on the delivery interval days, the daily sales quantity, and the most recent delivery quantity information before the disaster; estimating a second pre-disaster inventory quantity of the tobacco products in the identified disaster-stricken store by subtracting the estimated pre-disaster sales quantity from the estimated pre-disaster inventory quantity of the tobacco products on the nearest pre-disaster delivery date; comparing the first immediately-before-disaster inventory quantity with the estimated second immediately-before-disaster inventory quantity, and determining either the first immediately-before-disaster inventory quantity or the second immediately-before-disaster inventory quantity as the immediately-before-disaster inventory quantity of tobacco products in the identified affected store; The tobacco tax refund claim support method according to any one of (11) to (13), further comprising: (15) A computer program for causing one or more computers to execute the tobacco tax refund application support method according to any one of (8) to (14). [Explanation of symbols]

[0076] 1. Tobacco Tax Refund Application Support System (this system) 2. Sales and Logistics System 3 Customer store 5 Customer information DB (database) 10 Support Server 11 CPU 12. Memory 13 Input / Output Interface 14 Communication unit 15 Output Devices 16 Input Devices 20 Information acquisition department 21 Store Specific Department 22 Inventory Acquisition Department 23 Estimation part 24 Generation part 25 Data Reference Section

Claims

1. An information acquisition means for acquiring information on the quantity of tobacco products lost in a disaster in a plurality of disaster-affected stores in a specified administrative district; A generating means for generating data of a tobacco tax refund declaration form that aggregates the data of the plurality of disaster-affected stores based on the acquired quantity information to be submitted to the predetermined administrative district; Equipped with The information acquisition means acquires the quantity information from all or some of the computers of the plurality of disaster-stricken stores by communication, derives the quantity information using information acquired by communication from all or some of the computers of the plurality of disaster-stricken stores, or displays an input screen on an output device and acquires the quantity information inputted into the input screen. Tobacco tax refund application support system.

2. An information acquisition means for acquiring quantity information of tobacco products lost in a disaster in a plurality of disaster-affected stores in a specified administrative district; A generating means for generating data of a tobacco tax refund declaration form that aggregates the data of the plurality of disaster-affected stores based on the acquired quantity information to be submitted to the predetermined administrative district; Equipped with The information acquisition means includes a store identification means, an inventory acquisition means, and an estimation means, The store identification means identifies at least one damaged store among the plurality of damaged stores, The inventory acquisition means acquires pre-disaster inventory information indicating the inventory quantity of tobacco products in the identified disaster-stricken store immediately prior to the disaster; The estimation means estimates the quantity of tobacco products lost in the disaster in the identified disaster-stricken store by using at least the acquired pre-disaster inventory information. Tobacco tax refund application support system.

3. The inventory acquisition means acquires the immediately prior to the disaster inventory information indicating the inventory quantity of each brand of tobacco products in the identified affected store immediately prior to the disaster; The estimation means estimates the quantity of each brand of tobacco products lost in the disaster based on the inventory quantity of each brand indicated by the pre-disaster inventory information; The generating means generates detailed data of the refund claim form by tallying the quantities of each brand of tobacco products lost in the disaster for the plurality of affected stores. The tobacco tax refund application support system according to claim 2.

4. The inventory acquisition means includes: Acquire delivery record information indicating the quantity of tobacco products delivered to the identified disaster-stricken store within a predetermined period and delivery interval information of the tobacco products to the disaster-stricken store; estimating a daily sales volume of tobacco products sold to customers at the identified affected store based on the acquired delivery record information; estimating a first immediately before-disaster inventory quantity of tobacco products in the identified affected store based on the number of delivery interval days indicated by the acquired delivery interval information, the estimated daily sales quantity, and an inventory multiplier indicating a ratio of the inventory quantity to the sales quantity; 4. The tobacco tax refund application support system according to claim 2 or 3.

5. The inventory acquisition means includes: Further acquiring a most recent delivery date before the disaster, which is the most recent date on which tobacco products were delivered to the identified disaster-stricken store before the occurrence of the disaster; Based on the estimated daily sales volume, estimate a pre-disaster sales volume of tobacco products sold to customers at the identified disaster-affected store between the most recent delivery date before the disaster and the disaster date; multiplying the delivery interval days, the estimated daily sales quantity, and the inventory multiplier to estimate the inventory quantity of tobacco products in the identified affected store on the most recent delivery date before the disaster; estimating the first pre-disaster inventory quantity of tobacco products in the identified disaster-stricken store by subtracting the estimated pre-disaster sales quantity from the estimated pre-disaster inventory quantity of tobacco products on the nearest pre-disaster delivery date; 5. The tobacco tax refund application support system according to claim 4.

6. The inventory acquisition means assumes that the quantity obtained by multiplying the number of days between delivery intervals by the estimated daily sales quantity is the minimum inventory quantity on the most recent delivery day before the disaster, and assumes that the inventory ratio of the most recent delivery day before the disaster to the minimum inventory quantity on the most recent delivery day before the disaster is α, and the inventory ratio of the next delivery day to the minimum inventory quantity on the most recent delivery day before the disaster is β, and estimates the quantity obtained by multiplying the estimated daily sales quantity, the number of days from the most recent delivery day before the disaster to the disaster day, and (α-β) as the pre-disaster sales quantity; 6. The tobacco tax refund application support system according to claim 5.

7. The inventory acquisition means includes: Further acquiring pre-disaster most recent delivery quantity information indicating the quantity of tobacco products delivered to the identified disaster-stricken store on a pre-disaster most recent delivery date, which is the most recent date on which tobacco products were delivered to the identified disaster-stricken store before the occurrence of the disaster; Based on the estimated daily sales volume, estimate a pre-disaster sales volume of tobacco products sold to customers at the identified disaster-affected store between the most recent delivery date before the disaster and the disaster date; estimating the inventory quantity of tobacco products in the identified affected store on the most recent delivery date before the disaster based on the delivery interval days, the daily sales quantity, and the most recent delivery quantity information before the disaster; further estimating a second pre-disaster inventory quantity of the tobacco products in the identified disaster-stricken store by subtracting the estimated pre-disaster sales quantity from the estimated pre-disaster nearest delivery date inventory quantity of the tobacco products; comparing the first immediately-before-disaster inventory quantity with the estimated second immediately-before-disaster inventory quantity, and determining either the first immediately-before-disaster inventory quantity or the second immediately-before-disaster inventory quantity as the immediately-before-disaster inventory quantity of tobacco products in the identified affected store; The tobacco tax refund application support system according to any one of claims 4 to 6.

8. 1. A tobacco tax refund filing support method executed by one or more computers, comprising: the one or more computers: Acquire information on the quantity of tobacco products lost in a disaster at multiple affected stores in a specified administrative district; generating data for a tobacco tax refund declaration form that aggregates the amount of the plurality of affected stores based on the acquired quantity information to be submitted to the predetermined administrative district; Including, In acquiring the quantity information, the one or more computers acquire the quantity information from all or some of the computers of the plurality of disaster-stricken stores by communication, derive the quantity information using the information acquired by communication from all or some of the computers of the plurality of disaster-stricken stores, or display an input screen on an output device and acquire the quantity information inputted into the input screen. How to help file tobacco tax refunds.

9. A method for assisting in filing a tobacco tax refund claim, executed by one or more computers, comprising: the one or more computers: Identifying at least one damaged store among a plurality of damaged stores belonging to a specified administrative district; acquire pre-disaster inventory information indicating the inventory quantity of tobacco products in the identified disaster-affected store immediately prior to the disaster; Using at least the acquired pre-disaster inventory information, estimate the quantity of tobacco products lost in the disaster at the identified disaster-affected store; acquiring quantity information of tobacco products lost in the disaster in the plurality of affected stores using at least the estimated quantity; generating data for a tobacco tax refund declaration form that aggregates the amount of the plurality of affected stores based on the acquired quantity information to be submitted to the predetermined administrative district; A method to assist with filing tobacco tax refund claims, including:

Citation Information

Patent Citations

  • Local tax payment management system

    JP2003296507A

  • Ordering support device and ordering system

    JP2011008431A

  • Paper diaper inventory managing system and inventory managing method

    JP2020035311A

  • System and method for determining daily profit and loss to improve efficiency of daily business operations activities

    JP2020518933A