JP7373466B2 - Inventory calculation device, inventory calculation method, and inventory calculation program - Google Patents

Description

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

Traditionally, retail stores that sell a wide variety of products in small quantities often use the selling price method to evaluate their inventory, but when there are many products and stores, manual calculations are extremely burdensome, and are prone to calculation errors and processing time. was. As an example of a system using the selling price reduction method, there is Patent Document 1, for example.

Japanese Patent Application Publication No. 2007-279998

However, Patent Document 1 does not describe anything about efficient inventory processing at each store.

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

In order to solve the above-mentioned problems and achieve the objects, the present invention provides an inventory calculation device that includes a storage section and a control section and uses the selling price method, wherein the storage section calculates the gross profit rate for each product type. The control unit includes an acquisition means for acquiring the sales amount and purchase amount for each store's product type on a monthly basis, and an acquisition means for acquiring the sales amount and purchase amount for each store's product type on a monthly basis, and for the first month of the fiscal year for each store's product type in a normal month. The method for calculating the opening inventory amount is the carryover from the previous period as the opening inventory amount, and from the next month onwards, the ending inventory amount of the previous month is transferred to the opening inventory amount, and in a normal month, for each store type, the correspondence of sales amount x the above master data A cost of sales calculation method that calculates the gross profit amount based on the gross profit rate, and then calculates the cost of sales from the sales amount - gross profit amount, and in a normal month, for each store's product type, the beginning inventory amount + purchase amount - sales amount + A period-end inventory calculation means for calculating a period-end inventory amount from a gross profit amount.

According to one aspect of the present invention, the control unit further calculates, in a normal month, end-of-period inventory/products (however, the amount uses the beginning-of-period inventory) and products/end-of-period inventory (however, the amount is It is also possible to provide a journal entry creation means for creating two journal entries (using the period-end inventory amount).

According to one aspect of the present invention, the end-of-period inventory calculating means may determine that the amount of physical inventory is the end-of-period inventory in the month of physical inventory.

Further, according to one aspect of the present invention, the journal entry creation means may create a journal entry in which, for the physical inventory month, the period-end inventory amount/product (however, the beginning inventory amount is used as the amount).

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

Moreover, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides an inventory calculation method for causing an information processing device including a control unit and a storage unit to execute, the storage unit including: A master record in which the gross profit rate is registered for each product type is stored, and an acquisition process is executed by the control unit to obtain the sales amount and purchase amount for each store type on a monthly basis, and in a normal month, For each store's product type, for the first month of the fiscal year, the carryover from the previous period is used as the opening inventory, and from the following month onwards, the opening inventory calculation process transfers the previous month's ending inventory to the opening inventory, and in the normal month, each store For each product type, the gross profit amount is calculated by the sales amount x the corresponding gross profit rate of the master, and the cost of sales is calculated from the sales amount - gross profit amount. It is characterized by including a period-end inventory amount calculation step of calculating the period-end inventory amount from the period-starting inventory amount + purchase amount - sales amount + gross profit amount.

Further, in order to solve the above-mentioned problems and achieve the objects, the present invention provides an inventory calculation program to be executed by an information processing device including a control unit and a storage unit, the storage unit including: A master record in which the gross profit rate is registered for each product type is stored, and the control unit performs an acquisition process to obtain the sales amount and purchase amount for the product type of each store on a monthly basis, and a master record in which the gross profit rate is registered for each product type on a monthly basis. Regarding product types, for the first month of the fiscal year, the carryover from the previous period is used as the opening inventory amount, and from the following month onwards, the opening inventory calculation process transfers the previous month's ending inventory amount to the beginning inventory amount, and in the regular month, the inventory amount for each store is calculated. , a cost of sales calculation process in which the gross profit amount is calculated by the sales amount x the corresponding gross profit rate of the master data, and the cost of sales is calculated from the sales amount - the gross profit amount. The present invention is characterized by an inventory calculation program for executing on a computer a period-end inventory calculation step of calculating a period-end inventory amount from + purchase amount - sales amount + gross profit amount.

According to the present invention, it is possible to efficiently perform inventory processing at each store.

FIG. 1 is a block diagram showing an example of the configuration of an inventory calculation device according to the present embodiment. FIG. 2 is a diagram showing an example of the configuration of a department master, product category master, and gross profit rate master. FIG. 3 is a diagram for explaining processing in a normal month (inventory calculation month) using the selling price reduction method. FIG. 4 is a diagram for explaining the process for the physical inventory month. FIG. 5 is a diagram for explaining the next term gross profit rate creation process. 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 that is created. FIG. 11 is a diagram showing an example of a journal entry checklist.

Embodiments of the present invention will be described in detail based on the drawings. Note that the present invention is not limited to this embodiment.

[1. overview]
Traditionally, retail stores that sell a wide variety of products in small quantities often use the selling price method to evaluate inventory, but when there are a large number of products and stores, manual calculations are extremely burdensome and can lead to calculation errors and processing time. It was on. In the selling price method, a reasonable gross profit rate is set for each product type, the cost is calculated from the sales amount, and an inventory journal entry is generated that matches the cost. In this case, without automatic generation processing, it would be necessary to calculate costs, calculate end-of-period inventory, and create journal entries for each retail store and product type, which is extremely time-consuming for retailers with a large number of stores and product types. This process requires .

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 goods sold is calculated from the sales amount and the gross profit rate, and an inventory journal that matches the cost is automatically generated. We created a system to do this. In addition, in this embodiment, the gross profit rate can be registered by controlling the function to use the physical inventory amount in the month in which the physical inventory is performed and by updating the gross profit rate calculated from the inventory at the end of the current year to the next year's gross profit rate. Automated.

Specifically, in this embodiment, 1. In a normal month, it is equipped with a function that automatically generates a transfer for the previous month using the selling price method and an inventory journal entry for the current month.In the inventory calculation month, using the selling price method, the cost of sales is calculated from the set gross profit rate x sales amount and the inventory for the previous month is calculated. Calculate the ending inventory amount from the high. 2. In the month of physical inventory, the system is equipped with a function that prioritizes the input inventory journal data and only generates a transfer of the end-of-period inventory, and in the month of physical inventory, only the previous month's inventory is returned to confirm the inventory taken. . 2. At the end of the period, it is equipped with a function that automatically calculates and updates the gross profit rate for the next term from the current month's results, updates the calculated gross profit rate to the gross profit rate master for the next term, and also provides a function to verify the validity of the gross profit rate. Output the original data for tracing.

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

The inventory calculation device 100 is a commercially available desktop personal computer. Note that the inventory calculation device 100 is not limited to stationary information processing devices such as desktop personal computers, but also mobile devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers. It may be a type information processing device.

The inventory calculation device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each unit included in the inventory calculation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicatively connects the inventory calculation device 100 to the network 300 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 other devices via a communication line. Here, the network 300 has a function of communicably connecting the inventory calculation device 100 and the terminals 400 . . . and the server 200, and is, for example, the Internet or a LAN (Local Area Network). The terminals 400 are terminal devices placed in each department (for example, a store). The inventory calculation device 100 may obtain 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, in addition to a monitor (including a touch panel), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Note that, below, the output device 114 may be described as the monitor 114 or the printer 114, and the input device 112 may be described as the keyboard 112 or the mouse 112. In addition, "output" refers to outputting on the output device 114, and includes, for example, displaying on the monitor 114, printing on the printer 114, and transmitting data to an external device.

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

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

As shown in FIG. 2, the department master 106a can be composed of a table or the like in which department codes and department groups 1 to 3 are registered in association with each other. In the example shown in Figure 2, the first line is the department ``Kamata Store Women's Clothing,'' department group 1 ``Kamata Store,'' and the second line is the department ``Kamata Store Men's Clothing'' and department group 1 ``Kamata Store.'' ing.

As shown in FIG. 2, the product category master 106b can be composed of a table or the like in which department codes and product types are registered in association with each other. In the example shown in FIG. 2, the first line shows the department ``Kamata Store Women's Clothing'' and the type ``Ladies Clothing,'' and the second line has the department ``Kamata Store Men's Clothing'' and the type ``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 type codes and gross profit rates are registered in association with each other. In the example shown in Figure 2, the first line shows the product type "ladies' clothing" and the gross profit rate is "6.5%", and the second line shows the product type "men's clothing" and the gross profit percentage "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 centrally controls the inventory calculation device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute. Functionally, the control unit 102 includes an acquisition unit 102a, a period-end inventory calculation unit 102b, a period-end inventory calculation unit 102c, a cost of sales calculation unit 102d, a journal creation unit 102e, a gross profit rate setting unit 102f, A master maintenance section 102g is provided.

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

The beginning inventory calculation unit 102b sets the carryover from the previous period as the beginning inventory for the first month of the year for the product types of each department, and transfers the ending inventory of the previous month to the beginning inventory from the next month onward.

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

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

The journal creation unit 102e normally creates two journal entries in a month: end-of-period inventory/products (however, the amount uses the beginning inventory amount) and product/end-of-period inventory amount (however, the amount uses the ending inventory amount). create. In addition, the journal creation unit 102e creates a journal entry in which the period-end inventory amount/product (however, the beginning inventory amount is used as the amount) for the physical inventory month.

At the end of the term, the gross profit rate setting unit 102f calculates the gross profit rate for the current term based on the aggregation results of the sales amount and gross profit amount for the current term for each product type, and uses the calculated gross profit rate for the next term. , is set in the gross profit rate master 106c.

The master maintenance section 102g inputs and inputs data into the department master 106a, product category master 106b, and gross profit rate master 106c in response to operator operations on a master maintenance screen (not shown) displayed on the monitor 114. Perform editing such as additions and changes.

[3. Concrete example]
A specific example of the processing by the control unit 102 of the inventory calculation device 100 in this embodiment will be described with reference to FIGS. 3 to 11. In the following explanation, all monetary amounts will be expressed in units of "10,000 yen" and their notation will be omitted.

(1. Processing of inventory calculation month (normal month) using the selling price method)
FIG. 3 is a diagram for explaining processing in a normal month (inventory calculation month) using the selling price method.
A department master 106a, a product category master 106b, a gross profit rate master 106c, and intermediate data to be generated (journal summary data for the target month, beginning inventory data for the target month, and journal data to be created) are shown. Inventory calculation months (normal months) using the selling price method are performed in normal months other than the second half of the year and the end of the period.

The journal entry summary data for the target month may include the target year and month, office code, department code, sales amount, purchase amount, gross profit amount (=sales amount x gross profit rate), and product data.

The beginning inventory data for the target month may include the target year and month, office code, department code, and end-of-period inventory data for the previous month.

The journal data to be created is the target year and month, office code, department code, beginning inventory amount, cost of sales (= sales amount - gross profit amount), period-end inventory amount (= beginning inventory amount + purchase amount - sales amount + gross amount). It may also include data on profit amount) and gross profit amount (=sales amount x gross profit rate).

The cost of sales is calculated as follows: Cost of sales = Beginning inventory amount + Purchase amount - Ending inventory amount (1). Expanding this formula (1), it becomes: Ending inventory amount = Beginning inventory amount + Purchase amount - Cost of sales (2). Substituting cost of sales = sales amount - gross profit amount into formula (2), the ending inventory amount = beginning inventory amount + purchase amount - (sales amount - gross profit amount) (3).

In a normal month, two journal entries like (1) and (2) are created. (1) Period-end inventory amount/products, however, the period-end inventory amount uses the period-end inventory amount; (2) Period-end inventory amount; however, the period-end inventory amount uses the period-end inventory amount.

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

The beginning inventory data for the target month may include data on the office code, department code, and ending inventory amount of the previous month.

The journal creation data to be created may include data on the target year and month, office code, department code, and beginning inventory amount.

For the physical inventory month, (1) Create a journal entry for end-of-period inventory/products. In this case, the beginning inventory amount is used as the ending inventory amount.

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

The creation target journal creation data may include data on the target year and month, department code, beginning inventory amount, purchase amount, end of period inventory amount, and sales amount. In addition, when verifying the calculation source of the gross profit rate, refer to the journal data to be created.

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

(4. Sample data)
A specific example of the processing of the control unit 102 of the inventory calculation device 100 in this embodiment will be described with reference to the sample data shown in FIGS. 6 to 8. Figure 6 shows an example of the sales amount, gross profit rate, and gross profit amount (tentative) for Kamata store men's wear and Kamata store women's wear from 2019/03 to 2020/02 with March as the beginning. Figures 7 and 8 show calculation samples of sales amount, gross profit amount, beginning inventory amount, purchase amount, ending inventory amount, and cost of sales for Kamata store men's wear and Kamata store women's wear from 2019/03 to 2020/02. It shows.

In Figure 6, annual sales are "1200" for Kamata store men's wear, "900" for Kamata store women's wear, "0.625" for Kamata store men's wear, and "0.625" for Kamata store women's wear, and "0.625" for Kamata store women's wear. , "0.528". Each month, a journal entry is created based on the gross profit amount, and the end-of-period gross profit rate is updated only at the end of the period.

In the calculation samples shown in FIGS. 7 and 8, in order to simplify the explanation, sales amounts and purchase amounts are the same each month, and physical inventory is taken only at the end of the month.

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

For the second month, April 2019, for the Kamata store men's wear, the sales amount is "100", the gross profit amount is "60", the beginning inventory is "655 (the ending inventory of the previous month)", and the purchase amount is "95". , the end-of-period inventory is 710 (=655+95-100+60), and the cost of sales is 40. For the Kamata store women's clothing, sales amount is ``80'', gross profit is ``40'', beginning inventory is ``800 (last month's ending inventory)'', purchase amount is ``90'', and ending inventory is ``850 (= 800 + 90 - 80 + 40)''. ), and the cost of sales is "40".

For 2020/2, which is the month of physical inventory, the sales amount for Kamata store men's clothing is "100," the beginning inventory is "1205 (the ending inventory of the previous month)," the purchase amount is "95," and the ending inventory is " 1250 (physical inventory amount)," cost of sales "50," and gross profit amount "50 (= 100 - (1205 + 95 - 1250).") For the Kamata store women's wear, the sales amount was "80," and the beginning inventory was "50." 1300 (end of previous month's inventory), Purchase amount: 90, End of period inventory: 750 (physical inventory), Cost of sales: 640, Gross profit: -560 (=80 - (1300 + 90 - 750)) It becomes.

Aggregating the current year, the sales amount for the Kamata store's men's clothing is "1200," the gross profit is "710," and the gross profit rate is "0.59167 (=710/1200)." For women's clothing at the Kamata store, the sales amount is "960," the gross profit is "-120," and the gross profit rate is "0.12500 (=-120/960)." This calculated gross profit amount is registered in the gross profit rate master 106c and used in calculations for the next term.

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 the target month (normal month, physical inventory execution month, period end), an area for selecting the processing year and month, an area for selecting the processing year and month, It also includes an area for selecting creation items (inventory data creation, journal checklist, journal data creation). When the target month, processing year and month, and creation item are selected, the control unit 102 creates and displays data for the selected target month, processing year and month, and creation 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 explained above, according to the present embodiment, the gross profit rate master 106c registers the gross profit rate for each product type, and the acquisition unit 102a obtains the sales amount and purchase amount for each store product type on a monthly basis. Then, in a normal month, for each store's product type, for the first month of the year, the beginning inventory is carried over from the previous period, and from the next month onward, the period-end inventory of the previous month is transferred to the beginning inventory. , a cost of sales calculation unit 102d that calculates the gross profit amount for the product type of each store in a normal month by the sales amount x the corresponding gross profit rate of the gross profit rate master 106c, and calculates the cost of sales from the sales amount minus the gross profit amount; In a normal month, the end-of-period inventory calculation unit 102c calculates the end-of-period inventory amount from the beginning inventory amount + purchase amount - sales amount + gross profit amount for each store's product type. It becomes possible to perform processing efficiently.

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

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all of the processes described as being performed manually can be performed manually. Alternatively, some of the steps can be performed automatically using known methods.

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

Furthermore, with respect to the inventory calculation device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the inventory calculation device 100, especially each processing function performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is used to calculate the inventory amount as necessary. Mechanically read by device 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the inventory calculation device 100 via an arbitrary network, and it is also possible to download all or part of it as necessary. It is.

Further, a program for executing the processing described in this 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 EE. PROM (registration Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk) ), DVD (Digital Versatile Disk), Blu-ray (registered trademark) Disc, etc. shall include any “portable physical medium”.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in this embodiment, and the installation procedure after reading.

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

Further, the inventory 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 any peripheral device is connected. Further, the inventory calculation device 100 may be realized by installing software (including a program, data, etc.) that makes the device realize the processing described in this embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

100 Inventory calculation device 102 Control unit 102a Acquisition unit 102b Beginning inventory calculation unit 102c Ending 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 Department Master 106b Product category master 106c Gross profit rate master 106d Data file 200 Server 300 Network 400 Terminal

Claims (7)

An inventory calculation device comprising a storage unit and a control unit and using the selling price method,
The storage unit includes:
Equipped with a master record that records the gross profit rate for each product type,
The control unit includes:
an acquisition means for acquiring the sales amount and purchase amount for each store type on a monthly basis;
In a normal month, for each store's product type, for the first month of the fiscal year, the carryover from the previous period is set as the opening inventory amount, and from the next month onward, the ending inventory amount of the previous month is transferred to the opening inventory amount;
A cost of sales calculation means that calculates the gross profit amount for each store type in a normal month by the sales amount x the corresponding gross profit rate of the master, and calculates the cost of sales from the sales amount minus the gross profit amount;
Period-end inventory calculation means for calculating the period-end inventory amount from the beginning inventory amount + purchase amount - sales amount + gross profit amount for each store type in a normal month;
An inventory calculation device characterized by comprising: The control unit further includes:
A journal creation method that creates two journal entries in a normal month: ending inventory/products (however, the amount uses the beginning inventory amount) and product/end inventory amount (however, the amount uses the ending inventory amount). The inventory calculation device according to claim 1, further comprising an inventory calculation device. 3. The inventory calculation device according to claim 1, wherein the period-end inventory calculation means sets the physical inventory amount as the period-end inventory amount in a physical inventory month. 3. The inventory calculation device according to claim 2, wherein the journal creation means creates a journal entry in which, for the actual inventory month, period-end inventory amount/commodities (however, the beginning-of-period inventory amount is used as the amount). The control unit further includes:
At the end of the period, the gross profit rate for the current period is calculated based on the aggregation results of the sales amount and gross profit amount for the current period for each product, and in order to use the calculated gross profit rate for the next period, 4. The inventory calculation device according to claim 1, further comprising an interest rate setting means. An inventory calculation method to be executed by an information processing device including a control unit and a storage unit, the method comprising:
In the storage unit,
A master record in which the gross profit rate is registered for each product type is stored.
executed in the control unit,
an acquisition step of acquiring the sales amount and purchase amount for each store type on a monthly basis;
In a normal month, for each store's product type, for the first month of the fiscal year, the carryover from the previous period is set as the opening inventory amount, and from the next month onwards, the opening inventory amount is calculated by transferring the ending inventory amount of the previous month to the opening inventory amount;
A cost of sales calculation step of calculating the gross profit amount for the product type of each store in a normal month by the sales amount x the corresponding gross profit rate of the master, and calculating the cost of sales from the sales amount minus the gross profit amount;
In a normal month, a period-end inventory calculation step of calculating the period-end inventory amount from the beginning inventory amount + purchase amount - sales amount + gross profit amount for each store type;
An inventory calculation method characterized by including the following. An inventory calculation program to be executed by an information processing device including a control unit and a storage unit, the program comprising:
In the storage unit,
A master record in which the gross profit rate is registered for each product type is stored.
In the control section,
an acquisition step of acquiring the sales amount and purchase amount for each store type on a monthly basis;
In a normal month, for each store's product type, for the first month of the fiscal year, the carryover from the previous period is set as the opening inventory amount, and from the next month onwards, the opening inventory amount is calculated by transferring the ending inventory amount of the previous month to the opening inventory amount;
A cost of sales calculation step of calculating the gross profit amount for the product type of each store in a normal month by the sales amount x the corresponding gross profit rate of the master, and calculating the cost of sales from the sales amount minus the gross profit amount;
In a normal month, a period-end inventory calculation step of calculating the period-end inventory amount from the beginning inventory amount + purchase amount - sales amount + gross profit amount for each store type;
An inventory calculation program for running on a computer.

Images