JP2022001986A - Inventory calculation apparatus, inventory calculation method, and inventory calculation program - Google Patents

Abstract

To efficiently perform processing of an inventory of each store.SOLUTION: An inventory calculation apparatus according to the present embodiment includes: acquisition means that acquires a master in which a gross interest is registered for each item, and a sales amount and a purchase amount for each item of each store on a monthly basis; beginning inventory calculation means that, in a normal month, for the first month of the year, sets a carry-forward of a previous period as a beginning inventory for the item of each store and, from the next month onward, transfers an end inventory of the previous month to the beginning inventory; sales cost calculation means that calculates, in the normal month, for the item of each store, calculates a gross profit by multiplying the sales amount by the corresponding gross interest in the master and calculates a sales cost by subtracting the gross profit from the sales amount; and end inventory calculation means that calculates, in the normal month, for the item of each store, the end inventory by the beginning inventory + the purchase amount - the sales amount + gross profit.SELECTED DRAWING: Figure 1

Description

The present invention relates to an inventory amount calculation device, an inventory amount calculation method, and an inventory amount calculation program.

Conventionally, inventory evaluation is often performed by the selling price reduction method in high-mix low-volume retail stores, but when the number of varieties and stores is large, manual calculation is extremely burdensome, and calculation errors and processing time are required. Was there. As a system using the selling price reduction method, for example, there is Patent Document 1.

Japanese Unexamined Patent Publication No. 2007-279998

However, Patent Document 1 does not describe anything about efficiently processing the inventory of each store.

The present invention has been made in view of the above problems, and provides an inventory amount calculation device, an inventory amount calculation method, and an inventory amount calculation program capable of efficiently performing inventory processing of each store. The purpose is.

In order to solve the above-mentioned problems and achieve the object, the present invention is an inventory calculation device including a storage unit and a control unit and using a cost of sales method, and the storage unit is a gross profit margin for each product type. The control unit is equipped with a master that has registered the above, and the control unit has an acquisition method for acquiring the sales amount and purchase amount for each store type on a monthly basis, and for the type of each store in the normal month, for the first month of the year. Is the method of calculating the beginning inventory that transfers the end-of-term inventory of the previous month to the beginning inventory from the next month onward, and the sales amount x the master's response for each store type in the normal month. The cost of sales calculation method that calculates the cost of sales from the gross profit amount and the cost of sales from the gross profit amount, and the beginning inventory + purchase amount-sales amount + for each store type in a normal month. It is characterized by being equipped with a means for calculating the end-of-term inventory amount from the gross profit amount.

Further, according to one aspect of the present invention, the control unit further controls the end-of-term inventory / commodities (however, the amount uses the beginning inventory) and the commodities / end-of-term inventory (however, the amount is) in a normal month. It may be provided with a journal creation means for creating two journals (using end-of-term inventory).

Further, according to one aspect of the present invention, in the term-end inventory calculation means, the physical inventory amount may be set to the term-end inventory amount in the physical inventory month.

Further, according to one aspect of the present invention, the journal entry creating means may create a journal entry in which the physical inventory month is the end-of-term inventory / commodities (however, the amount uses the beginning inventory).

Further, according to one aspect of the present invention, the control unit further calculates and calculates the gross profit rate for the current period based on the aggregated result of totaling the sales amount and the gross profit amount for each type at the end of the period. In order to use the gross profit rate in the next period, the gross profit rate setting means set in the master may be provided.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a method for calculating an inventory amount for an information processing apparatus provided with a control unit and a storage unit to execute the inventory amount calculation method. A master that registers the gross profit margin for each product type is stored, and the acquisition process for acquiring the cost of sales and the purchase price for the product type of each store on a monthly basis, which is executed in the control unit, and the normal month, For the product types of each store, for the first month of the fiscal year, the carry-forward of the previous period is taken as the beginning inventory, and from the following month onward, the beginning inventory calculation process that transfers the ending inventory of the previous month to the beginning inventory, and each store in the normal month. For the varieties of, the cost of sales calculation process that calculates the gross profit amount by the sales amount × the corresponding gross profit rate of the master, and the cost of sales is calculated from the sales amount-gross profit amount, and for the varieties of each store in the normal month. It is characterized by including a process of calculating the end-of-term inventory amount from the beginning inventory amount + purchase amount-sales amount + gross profit amount.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is an inventory amount calculation program for causing an information processing apparatus including a control unit and a storage unit to execute the inventory amount calculation program. A master that registers the gross profit margin for each product type is stored, and in the control unit, the acquisition process for acquiring the sales amount and purchase amount for each store type on a monthly basis, and the acquisition process for each store in a normal month. Regarding varieties, for the first month of the fiscal year, the carry-forward of the previous period is taken as the beginning inventory, and from the following month onward, the beginning inventory calculation process that transfers the ending inventory of the previous month to the beginning inventory, and the varieties of each store in the normal month , Sales amount × The cost of sales calculation process that calculates the gross profit amount from the corresponding gross profit rate of the master and calculates the cost of sales from the sales amount minus the gross profit amount, and the beginning inventory amount for each store type in a normal month. It is characterized by being an inventory calculation program for executing the period-end inventory calculation process of calculating the period-end inventory amount from + purchase amount-sales amount + gross profit amount on a computer.

According to the present invention, it is possible to efficiently carry out inventory processing of each store.

FIG. 1 is a block diagram showing an example of the configuration of the inventory amount calculation device according to the present embodiment. FIG. 2 is a diagram showing a configuration example of a department master, a product type department master, and a gross profit margin master. FIG. 3 is a diagram for explaining the processing of a normal month (inventory amount calculation month) by the selling price reduction method. FIG. 4 is a diagram for explaining the processing of the physical inventory month. FIG. 5 is a diagram for explaining the process of creating the gross profit margin for the next period. FIG. 6 is a diagram showing sample data. FIG. 7 is a diagram showing sample data. FIG. 8 is a diagram showing sample data. FIG. 9 is a diagram showing an example of an inventory data creation screen. FIG. 10 is a diagram showing an example of journal data to be created. FIG. 11 is a diagram showing an example of a journal checklist.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
Conventionally, in high-mix low-volume retail stores, inventory evaluation is often performed by the selling price reduction method, but when the number of varieties and stores is large, manual calculation is extremely burdensome, and calculation errors and processing time are required. It was hanging. In the selling price reduction method, a rational gross profit rate is set for each product type, the cost is calculated from the sales amount, and an inventory journal that matches the cost is generated. In this case, if there is no automatic generation process, it is necessary to calculate cost, end-of-term inventory, and journal entry for each retail store and each product type, which is extremely troublesome for retailers with many stores and many types of products. Is the process.

Therefore, in this embodiment, in order to eliminate the above-mentioned manual work, the gross profit rate is registered for each product group, the cost of sales is calculated from the sales amount and the gross profit rate, and the inventory journal that matches the cost is automatically generated. I created a mechanism to do it. In addition, in this embodiment, the function to control the physical inventory amount to be adopted in the month of physical inventory and the gross profit rate can be registered by updating the gross profit rate calculated from the inventory at the end of the current year to the gross profit rate of the following year. Automated.

Specifically, in the present embodiment, 1. In the normal month, the function to automatically generate the previous month's transfer and the current month's inventory journal by the selling price return method is installed, and in the month of inventory calculation by the selling price return method, the cost of sales is calculated from the set gross profit rate x sales amount and the previous month's inventory. Calculate the end-of-term inventory from the high. 2. 2. In the physical inventory month, priority is given to the entered inventory journal data, and a function to generate only the transfer of the end-of-term inventory is installed. .. 2. 2. At the end of the term, it is equipped with a function to automatically calculate and update the gross profit rate for the next term from the actual results of the current month, update the calculated gross margin rate to the gross margin rate master for the next term, and also for validating the gross margin rate. Output the original data for tracing.

[2. composition]
An example of the configuration of the inventory amount calculation device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the inventory amount calculation device 100.

The inventory amount calculation device 100 is a commercially available desktop personal computer. The inventory calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like on the market. It may be a type information processing device.

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

The communication interface unit 104 connects the inventory calculation device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of communicably connecting the inventory amount calculation device 100 to the terminal 400 ... And the server 200, and is, for example, the Internet, a LAN (Local Area Network), or the like. The terminal 400 ... Is a terminal device arranged in each department (for example, a store). The inventory amount calculation device 100 may acquire the monthly sales amount and purchase amount of each department from the terminal 400.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a touch panel). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114 or a printer 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112. Further, the “output” refers to output by the output device 114 and the like, and includes, for example, display output to the monitor 114, print output by the printer 114, and transmission of data to the outside.

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

The storage unit 106 includes a department master 106a, a product type department master 106b, a gross margin master 106c, and a data file 106d. FIG. 2 is a diagram showing a configuration example of a department master 106a, a product type department master 106b, and a gross profit margin master 106c.

As shown in FIG. 2, the department master 106a can be composed of a table or the like in which the department code and the department groups 1 to 3 are registered in association with each other. In the example shown in FIG. 2, the first line is the department "Kamata store women's clothing", the department group 1 "Kamata store", the second line is the department "Kamata store men's clothing", and the department group 1 "Kamata store". ing.

As shown in FIG. 2, the variety department master 106b can be composed of a table or the like in which a division code and a variety are registered in association with each other. In the example shown in FIG. 2, the first line is the department "Kamata store women's clothing" and the variety "women's clothing", and the second line is the department "Kamata store men's clothing" and the variety "men's clothing".

As shown in FIG. 2, the gross profit rate master 106c can be composed of a table or the like in which a product code and a gross profit rate are registered in association with each other. In the example shown in FIG. 2, the first line is the variety "women's clothing" and the gross margin is "6.5%", and the second line is the variety "men's clothing" and the gross margin is "8.0%". ..

The data file 106d is a file for storing various data, and also stores intermediate data (also referred to as “work data”) generated in the process of processing.

The control unit 102 is a CPU or the like that comprehensively controls the inventory amount calculation device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 is functionally conceptually composed of an acquisition unit 102a, an beginning inventory calculation unit 102b, an end-end inventory calculation unit 102c, a cost of sales calculation unit 102d, a journal creation unit 102e, and a gross margin setting unit 102f. It is equipped with a master maintenance unit of 102 g.

The acquisition unit 102a acquires the sales amount and the purchase amount for the varieties of each department on a monthly basis. The acquisition unit 102a may acquire the sales amount and the purchase amount from, for example, the terminals 400 of each department, or may input and acquire the sales amount and the purchase amount from the input device 112.

The beginning inventory calculation unit 102b transfers the carry-over of the previous period to the beginning inventory for the first month of the fiscal year, and transfers the ending inventory of the previous month to the beginning inventory from the following month onward.

The cost of sales calculation unit 102d calculates the gross profit amount by the corresponding gross profit rate of the sales amount × the gross profit rate master 106c for the variety of each department in a normal month, and calculates the cost of sales from the sales amount minus the gross profit amount.

The end-of-term inventory calculation unit 102c calculates the end-of-term inventory amount from the beginning inventory amount + purchase amount-sales amount + gross profit amount for the varieties of each department in a normal month. In addition, the end-of-term inventory calculation unit 102c uses the physical inventory amount as the end-of-term inventory for the physical inventory month.

The journal entry unit 102e normally makes two journal entries in a month: end-of-term inventory / product (however, the amount uses the beginning inventory) and product / end-of-term inventory (however, the amount uses the end-of-term inventory). create. In addition, the journal entry unit 102e creates a journal with the physical inventory month as the end-of-term inventory / commodities (however, the amount uses the beginning inventory).

The gross profit rate setting unit 102f calculates the gross profit rate for the current period based on the aggregated result of totaling the sales amount and the gross profit amount for each product at the end of the period, and uses the calculated gross profit rate for the next period. , Set in the gross profit margin master 106c.

The master maintenance unit 102g inputs data to the department master 106a, the product type department master 106b, and the gross margin master 106c in response to the operator's operation on the master maintenance screen (not shown) displayed on the monitor 114. Edit such as additions and changes.

[3. Concrete example]
A specific example of the control unit 102 processing of the inventory amount calculation device 100 in the present embodiment will be described with reference to FIGS. 3 to 11. In the following explanation, the unit of the amount of money is "10,000 yen", and the notation is omitted.

(1. Processing of inventory calculation month (normal month) by the selling price reduction method)
FIG. 3 is a diagram for explaining the processing of a normal month (inventory amount calculation month) by the selling price reduction method.
The department master 106a, the product type department master 106b, the gross profit margin master 106c, and the generated intermediate data (journal total data of the target month, beginning inventory data of the target month, and journal data to be created) are shown. The inventory calculation month (normal month) by the selling price reduction method is processed in the normal month other than the second half and the end of the period.

The journal aggregate data of the target month may include the target year / month, business establishment code, department code, sales amount, purchase amount, gross profit amount (= sales amount × gross profit rate), and product data.

The beginning inventory data of the target month may include the target year / month, establishment code, department code, and end-of-term inventory data of the previous month.

The journal data to be created are the target date, establishment code, department code, beginning inventory, cost of sales (= sales amount-gross profit), end inventory (= beginning inventory + purchase amount-sales amount + crude). It may include data of interest amount) and gross profit amount (= sales amount × gross profit rate).

The cost of sales is calculated by the following: cost of sales = beginning inventory + purchase amount-end inventory ... (1). When this formula (1) is expanded, the end-of-term inventory = the beginning inventory + the purchase amount-the cost of sales ... (2). Substituting cost of sales = sales amount-gross profit amount into equation (2) yields end-of-term inventory = beginning inventory + purchase amount- (sales amount-gross profit amount) ... (3).

Normally, a month creates two journals such as (1) and (2). (1) End-of-term inventory / commodity, but the amount of end-of-term inventory uses the beginning inventory, (2) Product / end-of-term inventory, but the amount of end-of-term inventory uses the end-of-term inventory.

(2. Processing of physical inventory month)
FIG. 4 is a diagram for explaining the processing of the physical inventory month, and shows the generated intermediate data (starting inventory data of the target month, journal data to be created). The physical inventory month is processed, for example, at the quarter, the end of the half, and the end of the period.

The beginning inventory data of the target month may include data such as a business establishment code, a department code, and an ending inventory of the previous month.

The journal creation data to be created may include data such as the target date, establishment code, department code, and beginning inventory amount.

For the physical inventory month, (1) Create a year-end inventory / product journal. In this case, the amount of the end-of-term inventory is the beginning inventory.

(3. Creation process of gross profit margin for the next term)
FIG. 5 is a diagram for explaining the process of creating the gross profit rate for the next period, and is a diagram for explaining the department master 106a, the product type department master 106b, the gross profit rate master 106c, and the generated intermediate data (journal data to be created, gross profit rate). Calculated data) and. The process of creating the gross profit margin for the next term is performed at the end of the term.

The target journal creation data may include data on the target date, department code, beginning inventory, purchase amount, end inventory, and sales amount. When verifying as the calculation source of the gross profit margin, refer to the journal data to be created.

The gross profit rate calculation data may include data of the product type code, the gross profit amount (= sales amount- (starting inventory amount + purchase amount-ending period inventory amount)), the sales amount, and the gross profit rate.

(4. Sample data)
A specific example of the processing of the control unit 102 of the inventory amount calculation device 100 in the present embodiment will be described with reference to the sample data of FIGS. 6 to 8. FIG. 6 shows an example of the sales amount, gross profit rate, and gross profit amount (provisional) of Kamata store men's clothing and Kamata store women's clothing from March, 2019 to March 2020. Figures 7 and 8 show sample sales, gross profit, beginning inventory, purchase amount, end inventory, and cost of sales for Kamata store men's clothing and Kamata store women's clothing from March 03 to 2020. Shows.

In Fig. 6, the annual sales are "1200" for Kamata store men's clothing, "900" for Kamata store women's clothing, the year-end gross margin is "0.625" for Kamata store men's clothing, and Kamata store women's clothing. , "0.528". Each month, a journal is created from the gross profit amount, and the year-end gross profit rate is updated only at the end of the period.

In the calculation samples shown in FIGS. 7 and 8, for the sake of simplicity, the sales amount and the purchase amount are the same each month, and the physical inventory is only at the end of the period.

For 2019/3 of the first month, Kamata store men's clothing has sales amount of "100", gross profit amount of "60", beginning inventory amount "600 (carried over from the previous period)", purchase amount "95", end of period. The inventory amount is "655 (= 600 + 95-100 + 60), and the cost of sales is" 40 ". Kamata store women's clothing has sales amount "80", gross profit amount "40", beginning inventory "750 (carried forward from the previous period)", purchase amount "90", end inventory "800 (= 750 + 90-80 + 40), The cost of sales is "40".

For 2019/4 in the second month, the Kamata store men's clothing has a sales amount of "100", a gross profit amount of "60", an beginning inventory amount of "655 (end of the previous month's inventory amount)", and a purchase amount of "95". , The end-of-term inventory amount is "710 (= 655 + 95-100 + 60), and the cost of sales is" 40 ". Kamata store women's clothing has sales amount "80", gross profit amount "40", beginning inventory "800 (end of the previous month inventory)", purchase amount "90", end inventory "850 (= 800 + 90-80 + 40)" ), The cost of sales is "40".

For 2020/2 at the end of the physical inventory month, the cost of sales for men's clothing at the Kamata store is "100", the beginning inventory "1205 (end of the previous month)", the purchase amount "95", and the end inventory " 1250 (actual inventory amount) ”, cost of sales“ 50 ”, gross profit amount“ 50 (= 100- (1205 + 95-1250) ”. 1300 (end-of-term inventory amount of the previous month) ”, purchase amount“ 90 ”, end-of-term inventory amount“ 750 (physical inventory amount), cost of sales “640”, gross profit amount “-560 (= 80- (1300 + 90-750)” It has become.

When the current year is totaled, the Kamata store men's clothing has a sales amount of "1200", a gross profit amount of "710", and a gross profit rate of "0.59167 (= 710/1200)". Kamata store women's clothing has a sales amount of "960", a gross profit amount of "-120", and a gross profit rate of "0.12500 (= -120 / 960)". The calculated gross profit amount is registered in the gross profit rate master 106c and used in the calculation of the next period.

FIG. 9 is a diagram showing an example of an inventory data creation screen. In the example of the inventory data creation screen 500 shown in FIG. 9, an area for selecting a target month (normal month, physical inventory execution month, end of period), an area for selecting a processing date, and an area for selecting a processing date are It has an area for selecting creation items (inventory data creation, journal checklist, journal data creation). When the target month, the processing date, and the created item are selected, the control unit 102 creates and displays the data of the selected target month, the processing date, and the created item. FIG. 10 is a diagram showing an example of journal data to be created, and FIG. 11 is a diagram showing an example of a journal checklist.

As described above, according to the present embodiment, the gross profit margin master 106c in which the gross profit margin is registered for each product type, and the acquisition unit 102a for acquiring the sales amount and the purchase amount for each store product on a monthly basis. In the normal month, for the product types of each store, for the first month of the year, the carry-over of the previous period is taken as the beginning inventory, and from the next month onward, the ending inventory of the previous month is transferred to the beginning inventory calculation unit 102b. In the normal month, the cost of sales calculation unit 102d, which calculates the gross profit amount from the sales amount x the gross profit rate master 106c, and calculates the cost of sales from the sales amount-gross profit amount, for each store type. Since the end-of-term inventory calculation unit 102c, which calculates the end-of-term inventory amount from the beginning inventory amount + purchase amount-sales amount + gross profit amount, is provided for each store type in a normal month. The processing can be performed efficiently.

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

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

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

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

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

Further, this computer program may be stored in an application program server connected to the inventory calculation device 100 via an arbitrary network, and all or part of the computer program may be downloaded as needed. Is.

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

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

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

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

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

100 Inventory calculation device 102 Control unit 102a Acquisition unit 102b Beginning inventory calculation unit 102c End period inventory calculation unit 102d Cost of sales calculation unit 102e Journal creation unit 102f Gross profit rate setting unit 102g Master maintenance unit 104 Communication interface unit 106 Storage unit 106a Master 106b Variety department master 106c Gross margin master 106d Data file 200 Server 300 Network 400 Terminal

Claims (7)

It is an inventory calculation device that has a storage unit and a control unit and uses the selling price reduction method.
The storage unit is
Equipped with a master that registered the gross profit margin for each product type
The control unit
How to get the sales amount and purchase amount for each store type on a monthly basis,
In the normal month, for the product types of each store, for the first month of the year, the carry-forward of the previous period is used as the beginning inventory, and from the next month onward, the beginning inventory calculation method that transfers the ending inventory of the previous month to the beginning inventory,
A cost of sales calculation method that calculates the gross profit amount from the sales amount x the corresponding gross profit rate of the master for each store type in a normal month, and calculates the cost of sales from the sales amount-gross profit amount.
A means for calculating the end-of-term inventory amount, which calculates the end-of-term inventory amount from the beginning inventory amount + purchase amount-sales amount + gross profit amount, for each store variety in a normal month.
An inventory calculation device characterized by being equipped with. The control unit further
A journal creation method that creates two journal entries in a normal month: end-of-term inventory / product (however, the amount uses the beginning inventory) and product / end-of-term inventory (however, the amount uses the end-of-term inventory). The inventory amount calculation device according to claim 1, wherein the inventory is provided. The inventory calculation device according to claim 1 or 2, wherein the end-of-term inventory calculation means sets the physical inventory amount as the end-of-term inventory in the physical inventory month. The journal creation means is the inventory calculation device according to claim 2, wherein the journal is created with the physical inventory month as the end-of-term inventory / product (however, the amount uses the beginning inventory). The control unit further
At the end of the period, for each product type, the gross profit margin for the current period is calculated based on the aggregated results of the sales amount and gross profit amount for the current period, and the calculated gross profit rate is set in the master in order to use it in the next period. The inventory calculation device according to any one of claims 1 to 3, further comprising an interest rate setting means. It is an inventory calculation method for causing an information processing device equipped with a control unit and a storage unit to execute.
In the storage unit
A master that registers the gross profit rate for each product type is stored.
Executed in the control unit,
The acquisition process to acquire the sales amount and purchase amount for each store type on a monthly basis,
In the normal month, for the product types of each store, for the first month of the year, the carry-over of the previous period is taken as the beginning inventory, and from the next month onward, the beginning inventory calculation process that transfers the ending inventory of the previous month to the beginning inventory,
In a normal month, for each store type, the cost of sales calculation process is to calculate the gross profit amount by multiplying the sales amount by the corresponding gross profit rate of the master, and then calculate the cost of sales from the sales amount-gross profit amount.
In the normal month, the end-of-term inventory calculation process that calculates the end-of-term inventory amount from the beginning inventory amount + purchase amount-sales amount + gross profit amount for each store variety,
An inventory calculation method characterized by including. It is an inventory calculation program to be executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
A master that registers the gross profit rate for each product type is stored.
In the control unit
The acquisition process to acquire the sales amount and purchase amount for each store type on a monthly basis,
In the normal month, for the product types of each store, for the first month of the year, the carry-over of the previous period is taken as the beginning inventory, and from the next month onward, the beginning inventory calculation process that transfers the ending inventory of the previous month to the beginning inventory,
In a normal month, for each store type, the cost of sales calculation process is to calculate the gross profit amount by multiplying the sales amount by the corresponding gross profit rate of the master, and then calculate the cost of sales from the sales amount-gross profit amount.
In the normal month, the end-of-term inventory calculation process that calculates the end-of-term inventory amount from the beginning inventory amount + purchase amount-sales amount + gross profit amount for each store variety,
An inventory calculation program for running on a computer.

Images