Method and system for accounting for inventory value of marine stores

Abstract

The application provides a marine material inventory value accounting method and system, which comprises the following steps: collecting date data selected by a user, obtaining a purchase order of a batch of materials in a month containing the date, automatically calculating a purchase estimated amount according to the data on the order and adding the purchase estimated amount to the inventory, obtaining an invoice amount of the batch of materials, automatically calculating a difference amount of the batch of materials according to the invoice amount and the purchase estimated amount and recording the difference amount to the inventory, correcting the problematic records by using a specific judgment method, calculating a consumption amount corresponding to the consumption quantity of the materials taken out of the inventory in the month by using a moving weighted average method, and finally automatically calculating and displaying the final quantity of the materials in the inventory at the end of the month and the corresponding inventory amount according to the current inventory quantity, the corresponding inventory amount, the purchase estimated amount, the difference amount and the consumption amount, so that the timeliness and accuracy of data accounting are improved.

Description

Technical Field

[0001] This invention relates to the field of marine shipping technology, specifically to a method and system for calculating the value of marine supplies inventory. Background Technology

[0002] Currently, the accounting for the value (quantity and amount) of marine supplies typically uses an inventory management model: "Inbound" refers to the process from inquiry and procurement to warehousing and payment; "Outbound" refers to the process from quotation and sales to delivery (for ship management, this mainly involves delivery). The ending inventory = beginning inventory + purchases during the period - sales during the period. The key to calculating purchases and deliveries is calculating the average unit price, usually expressed as: "Average Unit Price" = (Amount of goods in stock before this receipt + Amount of goods received this time) / (Quantity of goods in stock before this receipt + Quantity of goods received this time). Then, multiplying the average unit price by the quantity purchased or delivered yields the amount for each change. Finally, accumulating these amounts monthly (or over other time periods) gives the ending balance.

[0003] However, this model is not sufficient to fully cover all business scenarios for marine supplies management. Because marine supplies procurement involves multi-currency settlement and payment transactions, and there are business scenarios such as needing to adjust inventory amounts when inventory is depleted, the calculation of marine supplies inventory value may be inaccurate in certain specific scenarios, requiring review and adjustment. Summary of the Invention

[0004] To address the shortcomings of current methods for calculating the value of marine supplies, such as incomplete coverage of all business scenarios and discrepancies in the calculated inventory value, this invention provides a method for calculating the inventory value of marine supplies. Based on the characteristics of ship management, it employs specific judgment methods combined with a moving weighted average method to automatically calculate the procurement cost and inventory value of supplies. This effectively improves the timeliness and accuracy of data accounting and provides foundational data for relevant statistical and decision-making systems. This invention also relates to a system for calculating the inventory value of marine supplies.

[0005] The technical solution of the present invention is as follows:

[0006] A method for accounting for the value of marine supplies inventory, characterized by comprising the following steps:

[0007] Information collection and amount calculation steps: Collect date data selected by the user through the human-computer interaction interface, obtain the purchase order of a certain batch of materials in the month containing that date, automatically calculate the estimated purchase amount based on the currency, unit price, quantity to be delivered and exchange rate on the order, and record it in the inventory;

[0008] Invoice accounting steps: Obtain the invoice amount for this batch of goods, automatically calculate the difference between the invoice amount and the estimated purchase amount for this batch of goods, and record it in the inventory;

[0009] Judgment and processing steps: Based on the characteristics of ship management, when the invoice amount is less than the estimated purchase amount, the system automatically judges the current inventory quantity and the inventory amount calculated based on the current inventory quantity. If the current inventory quantity is greater than zero and the inventory amount is less than zero, the record is corrected and a first record is generated. When materials have been recorded as received but have been issued and used before invoice confirmation is completed, the system automatically judges the current inventory quantity and the inventory amount calculated based on the current inventory quantity. If the current inventory quantity is zero and the inventory amount is not zero, the record is corrected and a second record is generated. The first and second records are added to the inventory to obtain the corrected current inventory quantity and its corresponding inventory amount.

[0010] Consumption amount calculation steps: Based on the characteristics of ship management, the manually entered outbound material consumption quantity is sent to shore-based personnel for review. If the review fails, the consumption quantity is returned to the current inventory. If the review passes, the consumption quantity is automatically deducted from the current inventory, and the consumption amount corresponding to the consumption quantity is automatically calculated using the moving weighted average method.

[0011] Quantity and Amount Statistics Steps: Based on the corrected current inventory quantity and its corresponding inventory amount, estimated purchase amount, difference amount, and consumption amount, the final quantity of materials and its corresponding inventory amount in the inventory at the end of the month are automatically calculated.

[0012] Human-computer interaction steps: A human-computer interaction interface is adopted, which provides users with date information to select and selection confirmation instructions, and displays the calculation results of the final material quantity and its corresponding inventory value in the quantity and amount statistics steps.

[0013] Preferably, in the judgment and processing step, if the current inventory quantity is greater than zero and the inventory amount is less than zero, the current inventory quantity is updated to zero and the inventory amount calculated based on the inventory quantity is updated to positive to generate the first record.

[0014] Preferably, in the judgment and processing step, if the current inventory quantity is zero and the inventory amount is not zero, the inventory amount calculated based on the inventory quantity will be corrected to zero to generate a second record.

[0015] Preferably, in the consumption amount calculation step, the consumption amount corresponding to the consumption quantity is calculated using the first-in-first-out method based on the quantity of materials consumed.

[0016] Preferably, in the consumption amount calculation step, when entering the quantity of outbound materials consumed, the quantity of materials consumed is less than or equal to the current inventory quantity.

[0017] A marine supplies inventory value accounting system, characterized in that it includes an information collection and amount calculation module, an invoice calculation module, a judgment and processing module, a consumption amount calculation module, a quantity and amount statistics module, and a human-computer interaction module. The human-computer interaction module is connected to the information collection and amount calculation module, the invoice calculation module, the judgment and processing module, the consumption amount calculation module, and the quantity and amount statistics module, respectively. The information collection and amount calculation module, the invoice calculation module, and the judgment and processing module are connected in sequence. The quantity and amount statistics module is connected to the information collection and amount calculation module, the invoice calculation module, the judgment and processing module, and the consumption amount calculation module, respectively.

[0018] The information collection and amount calculation module collects date data selected by the user through a human-computer interaction interface, obtains the purchase order for a certain batch of materials in the month containing that date, automatically calculates the estimated purchase amount based on the currency, unit price, quantity to be delivered, and exchange rate on the order, and records it in the inventory.

[0019] The invoice accounting module obtains the invoice amount for this batch of materials, automatically calculates the difference between the invoice amount and the estimated purchase amount, and records it in the inventory.

[0020] The judgment and processing module, based on the characteristics of ship management, automatically judges the current inventory quantity and the inventory amount calculated based on the current inventory quantity when the invoice amount is less than the estimated purchase amount. If the current inventory quantity is greater than zero and the inventory amount is less than zero, the record is corrected and a first record is generated. When materials have been recorded as received but have been issued and used before invoice confirmation is completed, the module automatically judges the current inventory quantity and the inventory amount calculated based on the current inventory quantity. If the current inventory quantity is zero and the inventory amount is not zero, the record is corrected and a second record is generated. The first and second records are added to the inventory to obtain the corrected current inventory quantity and its corresponding inventory amount.

[0021] The consumption amount accounting module, based on the characteristics of ship management, sends the manually entered outbound material consumption quantity to shore-based personnel for review. If the review fails, the consumption quantity is returned to the current inventory. If the review passes, the consumption quantity is automatically subtracted from the current inventory, and the consumption amount corresponding to the consumption quantity is calculated using the moving weighted average method.

[0022] The quantity and amount statistics module automatically summarizes and calculates the final quantity of materials and their corresponding inventory amount at the end of the month based on the corrected current inventory quantity and its corresponding inventory amount, the estimated purchase amount, the difference amount, and the consumption amount.

[0023] The human-computer interaction module uses a human-computer interaction interface, which allows users to select date information and select confirmation instructions, and displays the final material quantity and its corresponding inventory value calculation results from the quantity and amount statistics module.

[0024] Preferably, in the judgment and processing module, if the current inventory quantity is greater than zero and the inventory amount is less than zero, the current inventory quantity is updated to zero and the inventory amount calculated based on the inventory quantity is updated to positive to generate the first record.

[0025] Preferably, in the judgment and processing module, if the current inventory quantity is zero and the inventory amount is not zero, the inventory amount calculated based on the inventory quantity will be corrected to zero to generate a second record.

[0026] Preferably, the consumption amount calculation module also calculates the consumption amount corresponding to the consumption quantity using the first-in-first-out method based on the quantity of materials consumed.

[0027] Preferably, in the consumption amount calculation module, when entering the quantity of outbound materials consumed, the quantity of materials consumed is less than or equal to the current inventory quantity.

[0028] The beneficial effects of this invention are as follows:

[0029] This invention provides a method for accounting for the value of marine supplies inventory. The accounting process is mainly divided into two parts: material procurement and warehousing, and material consumption and outbound. Material procurement and warehousing is further subdivided into two parts: "invoice underestimation accounting" and "automatic adjustment of invoice entry". During the calculation, the purchase currency and invoice currency are converted to the local currency at a specific time point to facilitate user auditing and verification of the system's calculation process. At the same time, comprehensive statistical reports can be further developed according to users' personalized needs (such as calculating unit consumption amount based on turnover). Then, a specific judgment method is used to correct the warehousing records that need to be corrected, and to check whether the inventory quantity and amount need to be automatically adjusted. Based on the characteristics of ship management, the moving weighted average method is used to calculate the amount of consumed materials. Finally, the final quantity of materials in the end-of-month inventory and its corresponding inventory amount are calculated to achieve the purpose of automatically calculating the material procurement cost (including the estimated purchase amount and the invoice amount) and the inventory value (i.e., the inventory amount). This invention covers the procurement and consumption of ship supplies, and can provide users with a complete method for calculating the value of ship supplies tailored to the characteristics of ship management operations. This effectively improves the timeliness and accuracy of data accounting and provides basic data for relevant statistical and decision-making systems.

[0030] This invention also relates to a marine supplies inventory value accounting system. This system corresponds to the aforementioned marine supplies inventory value accounting method and can be understood as a system that implements the aforementioned marine supplies inventory value accounting method. It is also a marine supplies inventory value (quantity and amount) accounting system based on the characteristics of ship management. It includes an information collection and amount accounting module, an invoice accounting module, a judgment and processing module, a consumption amount accounting module, a quantity and amount statistics module, and a human-computer interaction module. These modules work collaboratively. Based on the characteristics of ship management, it uses specific judgment methods combined with a moving weighted average method to automatically calculate the cost of material procurement and inventory value. The accounting process is mainly divided into two parts: material procurement and warehousing, and material consumption and warehousing. Material procurement and warehousing is further subdivided into two parts: "invoice underestimation accounting and automatic adjustment of invoice entries." The system performs calculations, converting the purchase currency and invoice currency to the local currency at a given point in time. This data, along with other reference information (including vessel, transaction date, order number, supplier, cost entity / accounting company, transaction currency, purchase price, quantity, amount, system-calculated average price based on the local currency, inventory in the local currency before the transaction, and inventory in the local currency after the transaction), is stored in the quantity and amount statistics module. This facilitates user auditing and verification of the system's calculation process. Furthermore, based on the data from the quantity and amount statistics module, other business modules within vessel management can be linked to develop comprehensive statistical reports (e.g., calculating unit consumption based on turnover), effectively improving the timeliness and accuracy of data accounting and providing foundational data for relevant statistical and decision-making systems. Attached Figure Description

[0031] Figure 1 This is a flowchart of the method for calculating the value of marine supplies inventory according to the present invention.

[0032] Figure 2 This is a structural block diagram of the marine supplies inventory value accounting system of the present invention. Detailed Implementation

[0033] The present invention will now be described with reference to the accompanying drawings.

[0034] This invention relates to a method for accounting for the value of marine supplies inventory, the flowchart of which is shown below. Figure 1 As shown, the steps are as follows:

[0035] I. Information Collection and Amount Calculation Steps: Collect date data selected by the user through the human-computer interaction interface, obtain the purchase order for a certain batch of materials in the month containing that date, automatically calculate the estimated purchase amount based on the currency, unit price, quantity to be delivered, and exchange rate on the order, and record it in the inventory.

[0036] Specifically, the system collects user-selected date data through a human-computer interaction interface. This date data includes specific dates and a time period within a given date. It also retrieves purchase orders for a specific batch of materials within the month containing those dates. Based on a business model of "delivery before settlement" for ship-related materials, after confirming delivery, the system first obtains the agreed-upon currency of the order, calculates the original currency amount based on the delivery date, quantity of materials, and corresponding agreed-upon unit price, or directly extracts the original currency amount from the order. Next, it retrieves the shipowner company that placed the order and obtains its functional currency. Based on the functional currency, it determines the accounting month to which the delivery date belongs, and further obtains the exchange rate between the agreed-upon currency and the functional currency within that accounting month. Finally, based on the exchange rate between the agreed-upon currency and the functional currency, it multiplies the obtained original currency amount to automatically calculate the functional currency amount corresponding to this batch of delivered materials, i.e., the estimated purchase amount, and records it in inventory.

[0037] II. Invoice Calculation Steps: Obtain the invoice amount for this batch of materials, automatically calculate the difference between the invoice amount and the estimated purchase amount for this batch of materials, and record it in the inventory.

[0038] Specifically, after the signed receipt and invoice are delivered, and the quantities on the signed receipt and invoice are verified to match, the corresponding purchase estimate record is first located based on the order number. This record is then entered into the current accounting period using a full reversal method, which involves multiplying the quantity and estimated amount of the purchased materials in the purchase estimate record by -1 to obtain a new record. Next, the invoice record is entered into the accounting period. First, the paying shipping company's local currency is obtained from the invoice, along with the exchange rate between the invoice currency and the paying shipping company's local currency for the current month. Based on this exchange rate, the invoice amount is multiplied by the invoice amount to obtain the corresponding local currency amount for the delivered materials, which is then added to inventory. Finally, the local currency amount is matched with the purchase estimate amount to calculate the difference in the quantity of materials for this batch, which is also added to inventory. It should be noted that if the paying shipping company's local currency is the same as the invoice currency, the exchange rate does not need to be considered, and the calculation can be performed directly.

[0039] III. Judgment and Processing Steps: Based on the characteristics of ship management, determine whether automatic adjustment of inventory quantity and value is required. When the invoice amount is less than the estimated purchase amount, automatically determine the current inventory quantity recorded and the inventory value calculated based on the current inventory quantity. If the current inventory quantity is greater than zero and the inventory value is less than zero, then the record is corrected and a first record is generated. When materials have been recorded as received but have been issued and used before invoice confirmation is completed, automatically determine the current inventory quantity recorded and the inventory value calculated based on the current inventory quantity. If the current inventory quantity is zero and the inventory value is not zero, then the record is corrected and a second record is generated. The first and second records are added to the inventory to obtain the corrected current inventory quantity and its corresponding inventory value.

[0040] Specifically, based on the characteristics of ship management, there are situations where all materials are released from the warehouse immediately after being delivered to the ship. That is, materials are recorded as being stored but are released from the warehouse before they arrive. Therefore, there may be situations where "the quantity of materials is 0, but the inventory value is not 0". It is necessary to determine whether the recorded current inventory quantity and the inventory value calculated based on the current inventory quantity are zero. If the current inventory quantity is 0 and the inventory value is not equal to 0, then a new record needs to be automatically generated, namely the first record of storage. The corresponding quantity of this record is 0, and the value is "current inventory value" multiplied by -1. This achieves the effect of "the quantity being 0 is a check to ensure that the inventory value is automatically corrected to 0 as well".

[0041] Furthermore, there are instances where the invoice amount is significantly lower than the estimated amount, resulting in a situation where the inventory quantity is greater than 0 but the inventory value is negative. Therefore, an automatic adjustment is implemented for potentially negative inventory. This involves checking whether the recorded current inventory quantity and the inventory value calculated based on the current inventory quantity are greater than zero. If the current inventory quantity is greater than zero and the inventory value is less than zero, a new record, the second record, is automatically generated. This record corresponds to a quantity of 0, and the amount is "the amount obtained by multiplying the unit price of the most recent purchase invoice in local currency by the current quantity, plus the absolute value of the current inventory value." This achieves the goal of "preventing negative values ​​when the quantity is greater than 0." After the first and second records are entered into the inventory system, the corrected current inventory quantity and its corresponding inventory value are obtained.

[0042] IV. Consumption Amount Calculation Steps: Based on the characteristics of ship management, the manually entered quantity of outbound materials consumed is sent to shore-based personnel for review. If the review fails, the consumption quantity is returned to the current inventory. If the review passes, the consumption quantity is automatically deducted from the current inventory, and the consumption amount corresponding to the consumption quantity is automatically calculated using the moving weighted average method.

[0043] Specifically, according to the division of labor in ship operations management, the quantity of materials consumed is first entered by the crew, but it must be reviewed and confirmed by the shore-based supervisor before being recorded. Therefore, the crew first enters the quantity of materials consumed and issued, and it must be verified that the quantity consumed and issued does not exceed the current inventory quantity. Then, the shore-based operations supervisor reviews it. If the review fails, the quantity is added back to the inventory; if the review passes, the inventory quantity is reduced by the quantity entered this time, and the corresponding consumption amount needs to be automatically calculated. The moving weighted average price method is used to calculate the corresponding consumption amount, and the calculation method is: Consumption amount in local currency = Current total inventory amount in local currency / Current total inventory quantity × Quantity issued this time.

[0044] In addition, if the user requests, they can switch to using a first-in, first-out (FIFO) approach to calculate the cost. The corresponding pseudocode for the algorithm is as follows:

[0045] Assignment: The remaining uncalculated portion of the current consumption quantity x = the consumption quantity entered in S101.

[0046] While (the remaining uncalculated portion of the current consumption x>0){

[0047] Find the most recent unused purchase record a;

[0048] The quantity b consumed in this transaction is calculated as min(find the remaining uncalculated inventory quantity a1 of the most recent unconsumed purchase record a, and the remaining uncalculated portion x of the current consumption quantity);

[0049] Calculate the inbound consumption amount c = the unit price in the local currency of record a multiplied by b; and then record c in the inventory.

[0050] Update assignment: a1 = a1 - b; x = xb

[0051] }

[0052] V. Quantity and Amount Statistics Steps: Based on the corrected current inventory quantity and its corresponding inventory value, estimated purchase amount, discrepancy amount, and consumption amount, the final quantity of materials and its corresponding inventory value in the end-of-month inventory are automatically calculated. That is, as follows... Figure 1 The calculation involves carrying forward the previous period's inventory quantity and value, adding the estimated purchase amount for this month (invoices not yet received), adding the invoices received this month (difference adjustment), and subtracting the quantity and value of materials consumed this month. This summates the calculation to determine the inventory quantity and value at the end of the current period (i.e., at the end of the corresponding statistical period).

[0053] VI. Human-Computer Interaction Steps: A human-computer interaction interface is used, providing users with date information to select and confirmation instructions. It also displays the calculated results of the final material quantity and corresponding inventory value in the quantity and amount statistics steps. The interface includes query and statistical functions, specifically including the following statistical methods:

[0054] 1) View results at a specific point in time: The user enters the query date, and the system returns the following information up to that date: the vessel to which the specified marine supplies belong, the company to which the vessel belongs, the name of the item, the quantity of inventory, the amount of inventory (in local currency), the unit price of inventory (in local currency), the amount of inventory (in RMB), and the unit price of inventory (in RMB).

[0055] 2) View the detailed calculation process of each transaction: The user enters the query date and time period (statistics start time and statistics end time), and the system returns several detailed records (0 or positive integer) in sequence according to the transaction entry time. Each record is the accounting details generated by S101 to S105 above. The displayed content includes: vessel, vessel company, item name, transaction type, transaction date, accounting date, quantity change, settlement unit price (original currency), settlement amount (original currency), exchange rate of original currency to base currency, settlement unit price (base currency), settlement amount (base currency), settlement unit price (RMB), settlement amount (RMB), and supplier name.

[0056] 3) Inventory Consumption Table: To facilitate statistics, another summary statistics function is also provided: the user inputs the query date and time period (statistic start time and statistical end time), and the system automatically calculates the actual inventory quantity and amount of each item on the ship according to the subdivision (one item per line), and summarizes the accounting details generated in S101 to S105 above to calculate the purchase quantity and amount and consumption quantity and amount within the time period. The displayed content includes: ship, ship company, item name, statistical start date, starting inventory quantity, starting inventory amount, purchase quantity during the statistical period, purchase amount during the statistical period (local currency), consumption quantity during the statistical period, consumption amount during the statistical period (local currency), supplier name, statistical end date, inventory quantity at the end date, and inventory amount at the end date.

[0057] This invention provides a systematic inventory accounting method based on the characteristics of ship management by specifically decomposing and classifying ship supplies management business and combining it with the requirements of multi-currency and financial payment period management. This method aims to quickly and accurately calculate the quantity and value of ship supplies, thereby improving the efficiency of ship supplies management.

[0058] This invention also relates to a marine supplies inventory value accounting system, which corresponds to the aforementioned marine supplies inventory value accounting method and can be understood as a system for implementing the aforementioned method. The system structure is as follows: Figure 2 As shown, it includes an information collection and amount calculation module, an invoice calculation module, a judgment and processing module, a consumption amount calculation module, a quantity and amount statistics module, and a human-computer interaction module. The human-computer interaction module is connected to the information collection and amount calculation module, the invoice calculation module, the judgment and processing module, the consumption amount calculation module, and the quantity and amount statistics module, respectively. The information collection and amount calculation module, the invoice calculation module, and the judgment and processing module are connected sequentially. The quantity and amount statistics module is connected to the information collection and amount calculation module, the invoice calculation module, the judgment and processing module, and the consumption amount calculation module, respectively. Specifically,

[0059] The information collection and amount calculation module collects date data selected by the user through a human-computer interaction interface, obtains the purchase order for a certain batch of materials in the month containing that date, automatically calculates the estimated purchase amount based on the currency, unit price, quantity to be delivered, and exchange rate on the order, and records it in the inventory.

[0060] The invoice accounting module obtains the invoice amount for this batch of materials, automatically calculates the difference between the invoice amount and the estimated purchase amount, and records it in the inventory.

[0061] The judgment and processing module, based on the characteristics of ship management, automatically judges the current inventory quantity and the inventory amount calculated based on the current inventory quantity when the invoice amount is less than the estimated purchase amount. If the current inventory quantity is greater than zero and the inventory amount is less than zero, the record is corrected and a first record is generated. When materials have been recorded as received but have been issued and used before invoice confirmation is completed, the module automatically judges the current inventory quantity and the inventory amount calculated based on the current inventory quantity. If the current inventory quantity is zero and the inventory amount is not zero, the record is corrected and a second record is generated. The first and second records are added to the inventory to obtain the corrected current inventory quantity and its corresponding inventory amount.

[0062] The consumption amount accounting module, based on the characteristics of ship management, sends the manually entered outbound material consumption quantity to shore-based personnel for review. If the review fails, the consumption quantity is returned to the current inventory. If the review passes, the consumption quantity is automatically subtracted from the current inventory, and the consumption amount corresponding to the consumption quantity is calculated using the moving weighted average method.

[0063] The quantity and amount statistics module automatically summarizes and calculates the final quantity of materials and their corresponding inventory amount at the end of the month based on the corrected current inventory quantity and its corresponding inventory amount, the estimated purchase amount, the difference amount, and the consumption amount.

[0064] The human-computer interaction module uses a human-computer interaction interface, which allows users to select date information and select confirmation instructions, and displays the final material quantity and its corresponding inventory value calculation results from the quantity and amount statistics module.

[0065] Preferably, in the judgment processing module, if the current inventory quantity is greater than zero and the inventory amount is less than zero, the current inventory quantity is updated to zero and the inventory amount calculated based on the inventory quantity is updated to positive to generate the first record.

[0066] Preferably, in the judgment processing module, if the current inventory quantity is zero and the inventory amount is not zero, the inventory amount calculated based on the inventory quantity will be corrected to zero to generate a second record.

[0067] Preferably, in the consumption amount calculation module, the consumption amount corresponding to the consumption quantity is calculated using the first-in-first-out method based on the quantity of materials consumed.

[0068] Preferably, in the consumption amount calculation module, when entering the quantity of outbound materials consumed, the quantity of materials consumed is less than or equal to the current inventory quantity.

[0069] This invention provides an objective and scientific method and system for calculating the value of marine supplies inventory. Based on the characteristics of ship management, it uses specific judgment methods and combines them with the moving weighted average method to automatically calculate the procurement cost and inventory value of supplies, which can effectively improve the timeliness and accuracy of data accounting and provide basic data for related statistical and decision-making systems.

[0070] It should be noted that the specific embodiments described above enable those skilled in the art to more fully understand the present invention, but do not limit the present invention in any way. Therefore, although the present invention has been described in detail with reference to the accompanying drawings and embodiments, those skilled in the art should understand that modifications or equivalent substitutions can still be made to the present invention. In short, all technical solutions and improvements that do not depart from the spirit and scope of the present invention should be covered within the protection scope of the present invention patent.

Claims

1. A method for accounting for the value of marine supplies inventory, characterized in that, Includes the following steps: Information collection and amount calculation steps: Collect date data selected by the user through the human-computer interaction interface, obtain the purchase order of a certain batch of materials in the month containing that date, automatically calculate the estimated purchase amount based on the currency, unit price, quantity to be delivered and exchange rate on the order, and record it in the inventory; Invoice accounting steps: Obtain the invoice amount for this batch of goods, automatically calculate the difference between the invoice amount and the estimated purchase amount for this batch of goods, and record it in the inventory; Judgment and processing steps: Based on the characteristics of ship management, when the invoice amount is less than the estimated purchase amount, the system automatically judges the current inventory quantity and the inventory amount calculated based on the current inventory quantity. If the current inventory quantity is greater than zero and the inventory amount is less than zero, the current inventory quantity is updated to zero and the inventory amount calculated based on the inventory quantity is updated to positive to generate the first record. When materials have been recorded as stored in the warehouse but have been released and used before the invoice confirmation is completed, the system automatically determines the current inventory quantity and the inventory amount calculated based on the current inventory quantity. If the current inventory quantity is zero and the inventory amount is not zero, the inventory amount calculated based on the inventory quantity will be corrected to zero to generate a second record. The first and second records will be added to the inventory to obtain the corrected current inventory quantity and its corresponding inventory amount. Consumption amount calculation steps: Based on the characteristics of ship management, the manually entered outbound material consumption quantity is sent to shore-based personnel for review. If the review fails, the consumption quantity is returned to the current inventory. If the review passes, the consumption quantity is automatically deducted from the current inventory, and the consumption amount corresponding to the consumption quantity is automatically calculated using the moving weighted average method. Quantity and Amount Statistics Steps: Based on the corrected current inventory quantity and its corresponding inventory amount, estimated purchase amount, difference amount, and consumption amount, the final quantity of materials and its corresponding inventory amount in the end-of-month inventory are automatically calculated. Human-computer interaction steps: A human-computer interaction interface is adopted, which provides users with date information to select and selection confirmation instructions, and displays the calculation results of the final material quantity and its corresponding inventory value in the quantity and amount statistics steps.

2. The method for calculating the inventory value of marine supplies according to claim 1, characterized in that, In the consumption amount calculation step, the consumption amount corresponding to the consumption quantity is also calculated using the first-in-first-out method based on the quantity of materials consumed.

3. The method for calculating the inventory value of marine supplies according to claim 1, characterized in that, In the consumption amount calculation step, when entering the quantity of outbound materials consumed, the quantity of materials consumed must be less than or equal to the current inventory quantity.

4. A system for accounting for the value of marine supplies inventory, characterized in that, It includes an information collection and amount calculation module, an invoice calculation module, a judgment and processing module, a consumption amount calculation module, a quantity and amount statistics module, and a human-computer interaction module. The human-computer interaction module is connected to the information collection and amount calculation module, the invoice calculation module, the judgment and processing module, the consumption amount calculation module, and the quantity and amount statistics module, respectively. The information collection and amount calculation module, the invoice calculation module, and the judgment and processing module are connected in sequence. The quantity and amount statistics module is connected to the information collection and amount calculation module, the invoice calculation module, the judgment and processing module, and the consumption amount calculation module, respectively. The information collection and amount calculation module collects date data selected by the user through a human-computer interaction interface, obtains the purchase order for a certain batch of materials in the month containing that date, automatically calculates the estimated purchase amount based on the currency, unit price, quantity to be delivered, and exchange rate on the order, and records it in the inventory. The invoice accounting module obtains the invoice amount for this batch of materials, automatically calculates the difference between the invoice amount and the estimated purchase amount, and records it in the inventory. The judgment and processing module, based on the characteristics of ship management, automatically judges the current inventory quantity and the inventory amount calculated based on the current inventory quantity when the invoice amount is less than the estimated purchase amount. If the current inventory quantity is greater than zero and the inventory amount is less than zero, the current inventory quantity is updated to zero and the inventory amount calculated based on the inventory quantity is updated to positive to generate the first record. When materials have been recorded as stored in the warehouse but have been released and used before the invoice confirmation is completed, the system automatically determines the current inventory quantity and the inventory amount calculated based on the current inventory quantity. If the current inventory quantity is zero and the inventory amount is not zero, the inventory amount calculated based on the inventory quantity will be corrected to zero to generate a second record. The first and second records will be added to the inventory to obtain the corrected current inventory quantity and its corresponding inventory amount. The consumption amount accounting module, based on the characteristics of ship management, sends the manually entered outbound material consumption quantity to shore-based personnel for review. If the review fails, the consumption quantity is returned to the current inventory. If the review passes, the consumption quantity is automatically subtracted from the current inventory, and the consumption amount corresponding to the consumption quantity is calculated using the moving weighted average method. The quantity and amount statistics module automatically summarizes and calculates the final quantity of materials and their corresponding inventory amount at the end of the month based on the corrected current inventory quantity and its corresponding inventory amount, the estimated purchase amount, the difference amount, and the consumption amount. The human-computer interaction module uses a human-computer interaction interface, which allows users to select date information and select confirmation instructions, and displays the final material quantity and its corresponding inventory value calculation results from the quantity and amount statistics module.

5. The marine supplies inventory value accounting system according to claim 4, characterized in that, In the consumption amount calculation module, the consumption amount corresponding to the quantity of materials consumed is also calculated using the first-in-first-out (FIFO) method.

6. The marine supplies inventory value accounting system according to claim 4, characterized in that, In the consumption amount accounting module, when entering the quantity of outbound materials consumed, the quantity of materials consumed must be less than or equal to the current inventory quantity.

Images