Commodity purchase and distribution method and device based on unified purchase and distribution mode, and medium

Abstract

The invention discloses a commodity purchase and distribution method and device based on a unified purchase and distribution mode, and a medium, belongs to the technical field of purchase management, and aims to solve the technical problems of high purchase cost, overstock and fund occupation in a traditional purchase and distribution mode. According to the technical scheme, the method comprises the steps of summarizing and analyzing monthly demand quantity of each subordinate department, formulating a preliminary purchase plan, namely monthly connection quantity, of the next month at the end of each month according to market supply, price fluctuation and inventory conditions, adjusting and obtaining corresponding supplement quantity according to actual conditions, and forming a monthly connection total quantity between the monthly connection quantity and the supplement quantity, automatically updating the total monthly connection amount to the purchase amount actually executed in the current month; making a personalized sales plan according to a civilized index distribution strategy and an average monthly prediction distribution strategy based on half-year prediction quantity; and the commodity distribution quantity is formulated by adopting a strategy of distributing the total quantity according to times and a strategy of distributing the residual quantity proportion, so that inventory overstock is avoided, and sufficient market supply is ensured.

Description

Technical Field

[0001] The present invention relates to the technical field of procurement management, and in particular to a commodity procurement and distribution method, equipment and medium based on a centralized procurement and distribution model. Background Art

[0002] Commodity procurement and distribution models are crucial links in modern business activities, and they are directly related to the company's cost control, market coverage and competitiveness.

[0003] Commodity procurement model refers to the way in which an enterprise establishes a cooperative relationship with a supplier in order to obtain the required commodities. Common commodity procurement models include competitive negotiation, inquiry procurement, single source procurement, framework agreement, bidding procurement, and immediate procurement model.

[0004] Distribution model refers to the process by which producers of products or services deliver goods to end consumers through intermediary channels. Common distribution models include agency sales model, wholesale model, retail distribution model, multi-level distribution, e-commerce platform distribution, cross-border distribution model and sinking market distribution model.

[0005] In the traditional commodity procurement and distribution model, each subordinate organization often operates independently and conducts procurement and inventory management independently, which not only increases the purchase cost, but also leads to problems such as inventory backlogs and capital occupation. Summary of the invention

[0006] The technical task of the present invention is to provide a commodity procurement and distribution method, equipment and medium based on the centralized purchasing and distribution model to solve the problems of high purchase cost, inventory backlog and capital occupation in the traditional procurement and distribution model.

[0007] The technical task of the present invention is achieved in the following way: a commodity purchasing and distribution method based on the unified purchasing and distribution model, which is to summarize and analyze the monthly demand of each subordinate department, and formulate a preliminary procurement plan for the next month at the end of each month according to market supply, price fluctuations and inventory status, that is, the monthly connection quantity, and adjust the corresponding supplementary quantity according to the actual situation. The monthly connection quantity and the supplementary quantity constitute the monthly connection total quantity, and the monthly connection total quantity is automatically updated to the actual purchase quantity executed in the current month; then formulate a personalized sales plan based on the civilization indicator allocation strategy and the average monthly forecast allocation strategy based on the half-year forecast quantity; then adopt the total amount allocation strategy based on the number of times and the allocation strategy based on the remaining quantity ratio to formulate the commodity distribution quantity, avoid inventory backlogs, and ensure sufficient market supply.

[0008] As a preferred option, the monthly connection total is automatically updated to the actual purchase volume executed in the month as follows:

[0009] Multi-threaded data acquisition: parallel acquisition of commodity information that each subordinate department needs to purchase;

[0010] Integrate data: Integrate all the products on sale this month and the monthly connection quantity (spuId) in the monthly purchase plan; among them, the products on sale include those that did not exist at the beginning of the month but were added in the middle of the month;

[0011] Actual purchase quantity query: query and record the actual purchase quantity of all commodities in the month;

[0012] Calculate the additional quantity: Based on the goods on sale, calculate the difference between the actual purchase quantity of the month and the monthly connection quantity through the monthly connection quantity association data to obtain the additional quantity;

[0013] Unit conversion and return: convert the supplementary amount according to the front-end parameter unit, and return a data set containing the monthly connection amount and the supplementary amount;

[0014] Front-end update: The front-end loops through the table data, matches and updates the supplementary quantity according to the monthly connection quantity, and automatically adjusts the monthly connection total to be equal to the monthly connection plus the supplementary quantity as the actual purchase quantity for the month.

[0015] As a preferred option, the civilization indicator allocation strategy is as follows:

[0016] Accurately calculate the proportion of dual-civilization indicators of each subordinate department to provide an accurate basis for subsequent allocation;

[0017] Set the planned amount for the subordinate departments involved in the allocation. The planned amount is determined by multiplying the total amount of input by the respective proportion, and the rounding down method is used to ensure accurate allocation;

[0018] Calculate the remaining amount after delivery, that is, the total planned delivery amount minus the amount allocated to each subordinate department, to ensure that resources are fully utilized;

[0019] Evenly distribute the remaining amount to each subordinate department to further balance resource allocation;

[0020] If there is still surplus, it will be added to the lower-level department with the largest demand to meet market demand.

[0021] As a preferred method, the average monthly forecast allocation strategy based on the half-year forecast is as follows:

[0022] The half-year cycle to which the selected planning month belongs provides a time frame for the forecast;

[0023] Summarize the estimated demand of each subordinate organization for the half year and calculate the proportion of each demand to the total to ensure a reasonable distribution ratio;

[0024] The planned amount is allocated to each subordinate organization according to the proportion by rounding down to ensure the accuracy of the allocation result;

[0025] Calculate the remaining amount after delivery, that is, the total planned delivery amount minus the amount allocated to each subordinate department, to ensure that resources are fully utilized;

[0026] Evenly distribute the remaining amount to each subordinate department to further balance resource allocation;

[0027] If there is still surplus, it will be added to the lower-level department with the largest demand to meet market demand.

[0028] As a preferred method, in the process of formulating a personalized sales plan based on the civilization indicator allocation strategy and the average monthly forecast allocation strategy based on the half-year forecast, the data is saved by verification, as follows:

[0029] ① Verify whether the product data can be saved as a whole according to the page display unit;

[0030] ② Check whether the total planned quantity is equal to the delivered quantity;

[0031] ③ Ensure that the delivery amount does not exceed the available delivery amount;

[0032] Only when the above three conditions are met, the data is automatically organized and the backend interface is called to perform the save operation.

[0033] As a preferred method, the method also supports modifying the product release quantity (round down mode), and according to the selected plan quantity allocation method, inquires about the allocation ratio of each subordinate organization, and then allocates the plan quantity of each subordinate organization in proportion;

[0034] During the allocation process, the planned total amount, delivery amount, and data of the header table, sub-table, and industrial subtotal are updated in real time, and the data accuracy is ensured;

[0035] If the planned total quantity is inconsistent with the total quantity delivered, or the total quantity delivered exceeds the available quantity, the corresponding product row will be automatically highlighted (yellow background) so that the problem can be discovered and adjusted in time;

[0036] When allocating the planned quantities of each subordinate organization, the result is calculated by rounding down, and it is ensured that the total planned quantities of each subordinate department is not less than the delivery quantity;

[0037] If the calculated total is less than the input amount, the remaining amount will be distributed according to the allocation ratio from large to small, 1 unit at a time; if it is less than 1 unit, the remaining part will be distributed to ensure maximum utilization of resources.

[0038] As a preferred method, the total amount allocation strategy according to the number of times is as follows:

[0039] Accurately calculate the value of the planned remaining amount divided by the preset allocation times as the theoretical allocation benchmark;

[0040] The smaller of the current available inventory and this benchmark value is taken as the total amount for this allocation, ensuring that the allocation amount neither exceeds the planned upper limit nor exceeds the inventory limit.

[0041] Preferably, the allocation strategy based on the remaining amount ratio is as follows:

[0042] Preliminary allocation: Based on the proportion of the planned surplus of each subordinate organization, the allocation amount of each subordinate organization is preliminarily determined by rounding down to ensure the fairness of the allocation process;

[0043] Secondary distribution: The extra surplus generated by rounding in the initial distribution is further distributed in detail based on the proportion of the planned surplus of each subordinate organization, in an effort to maximize resource utilization.

[0044] An electronic device comprising: a memory and at least one processor;

[0045] Wherein, the memory stores a computer program;

[0046] The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the commodity procurement and distribution method based on the centralized purchasing and distribution model as described above.

[0047] A computer-readable storage medium stores a computer program, which can be executed by a processor to implement the above-mentioned commodity procurement and distribution method based on the centralized purchasing and distribution model.

[0048] The commodity purchasing and distribution method, device and medium based on the centralized purchasing and distribution model of the present invention have the following advantages:

[0049] (1) The present invention aims to reduce the operating costs of enterprises, improve inventory turnover, and optimize supply chain management by implementing centralized purchasing strategies, inventory management optimization and efficient distribution strategies, thereby improving the economic benefits and market competitiveness of enterprises, and solving the problems of high purchase costs, inventory backlogs and capital occupation in traditional purchasing and distribution models;

[0050] (ii) The present invention integrates the procurement, sales, inventory and other links within the enterprise through refined process management to achieve more efficient and accurate commodity circulation;

[0051] (3) Through refined management and technological innovation, the present invention enables the enterprise procurement department to respond to market demand more efficiently, realize the precise execution and dynamic adjustment of procurement plans, and provide strong support for the continuous operation and development of the enterprise;

[0052] (IV) Through the present invention, enterprises can improve inventory turnover, reduce capital occupation, and avoid inventory backlogs. Efficient distribution strategies ensure that goods can reach sales terminals quickly and accurately, improve customer satisfaction, and bring significant economic benefits and market competitiveness to enterprises;

[0053] (V) The present invention can be flexibly adjusted according to the actual situation of the enterprise to adapt to different market environments and business needs, and by integrating key links such as centralized purchasing, inventory, distribution and information management, it provides the enterprise with an efficient and flexible commodity procurement and distribution, which helps to improve the overall operational efficiency and market competitiveness of the enterprise. BRIEF DESCRIPTION OF THE DRAWINGS

[0054] The present invention is further described below in conjunction with the accompanying drawings.

[0055] Attached Figure 1 This is a flowchart of the commodity procurement and distribution method based on the unified purchasing and distribution model. DETAILED DESCRIPTION

[0056] The commodity purchasing and distribution method, equipment and medium based on the centralized purchasing and distribution model of the present invention are described in detail below with reference to the drawings and specific embodiments of the specification.

[0057] Embodiment 1:

[0058] As attached Figure 1 As shown, this embodiment provides a commodity procurement and distribution method based on the centralized purchasing and distribution model, and the method is specifically as follows:

[0059] a) Each subordinate organization reports monthly demand:

[0060] Each subordinate organization (such as department, store, etc.) predicts and reports its monthly commodity demand based on its own sales situation, market trends and customer needs. These data will serve as an important basis for the company to formulate procurement and sales plans, ensuring the accuracy and pertinence of the plans.

[0061] b) The corporate procurement department formulates a monthly procurement plan:

[0062] In order to improve the efficiency and accuracy of the procurement process, the corporate procurement department will make fine adjustments to the monthly procurement plan at the end of the month to ensure seamless integration of the plan and actual procurement. The specific process function implementation is outlined as follows:

[0063] Monthly procurement plan formulation and optimization:

[0064] The purchasing department summarizes and analyzes the monthly demand of each subordinate organization, comprehensively considers market supply, price fluctuations and inventory status, and formulates a preliminary purchasing plan for the next month (i.e. monthly connection volume) at the end of each month.

[0065] After the preliminary plan is reviewed, flexible adjustments (supplementary quantities) will be made based on actual conditions to ensure the accuracy and adaptability of the procurement plan.

[0066] The sum of the monthly connection quantity and the supplementary quantity constitutes the monthly connection total, which is the actual procurement quantity implemented in the month.

[0067] One-click alignment of monthly connection total volume function:

[0068] Through the one-click alignment function, the monthly connection total amount is automatically updated to the actual purchase amount of the month, simplifying the tedious manual modification process. The function implementation logic is:

[0069] (1) Multi-threaded data acquisition: Parallel acquisition of commodity information that each subordinate organization needs to purchase.

[0070] Data integration: Integrate all the products on sale this month (including products that did not exist at the beginning of the month but were added in the middle of the month) and the monthly connection quantity (spuId) in their monthly procurement plan.

[0071] (2) Actual purchase quantity query: Query and record the actual purchase quantity of all goods in the current month.

[0072] (3) Calculation of additional quantity: Based on the products on sale, the difference between the actual purchase quantity of the month and the monthly connection quantity is calculated through spuId-related data to obtain the additional quantity.

[0073] (4) Unit conversion and return: Convert the supplementary amount according to the front-end parameter unit and return a data set containing spuId and the supplementary amount.

[0074] (5) Front-end update: The front-end loops through the table data, matches and updates the supplementary quantity according to the spuId, and the page calculation formula automatically adjusts the monthly connection total. The calculation formula is monthly connection quantity + supplementary quantity = actual purchase quantity of the month, ensuring that the monthly connection quantity + supplementary quantity is equal to the actual purchase quantity of the month.

[0075] To sum up, through refined management and technological innovation, corporate procurement departments can respond to market demands more efficiently, achieve accurate execution and dynamic adjustment of procurement plans, and provide strong support for the company's continued operation and development.

[0076] c) The enterprise sales department formulates sales plans:

[0077] The corporate sales department carefully formulates a personalized sales plan for each subordinate organization based on the procurement plan and the monthly demand forecast of each subordinate organization. The formulation of the sales plan strictly follows two scientific strategies:

[0078] 1. Allocation strategy based on civilization indicators:

[0079] (1) Accurately calculate the proportion of dual-civilization indicators of each subordinate organization to provide an accurate basis for subsequent allocation.

[0080] (2) Set a planned amount for each subordinate organization that participates in the allocation. This amount is determined by multiplying the total amount invested by the respective proportion and rounding down to ensure accurate allocation.

[0081] (3) Calculate the remaining amount after delivery, that is, the total planned delivery amount minus the amount allocated to each subordinate organization, to ensure that resources are fully utilized.

[0082] (4) Distribute the remaining amount evenly among subordinate organizations to further balance resource allocation.

[0083] (5) If there is any surplus, it will be added to the subordinate organization with the greatest demand to meet market demand.

[0084] (II) Average monthly forecast allocation strategy based on half-year forecast volume:

[0085] (1) Select the half-year cycle to which the planned month belongs to provide a time frame for the forecast.

[0086] (2) Summarize the estimated demand of each subordinate organization for the six months and calculate the proportion of each demand to the total to ensure that the allocation ratio is reasonable.

[0087] (3) The planned amount is allocated to each subordinate organization according to the proportion by rounding down to ensure the accuracy of the allocation results.

[0088] (4) The method of calculating and allocating the surplus is the same as the civilized indicator allocation strategy to ensure that resources are not wasted. The method of handling the surplus is also consistent with the civilized indicator allocation strategy, that is, adding it to the subordinate organization with the greatest demand.

[0089] When saving data, we follow strict verification logic: first, we verify whether the product data can be saved in its entirety based on the page display unit; second, we verify whether the total planned quantity is equal to the delivery quantity; and finally, we ensure that the delivery quantity does not exceed the available delivery quantity. Only when these three conditions are met will the data be organized and the backend interface be called to perform the save operation.

[0090] In addition, this embodiment also supports modifying the quantity of goods put into production (round down mode), and will query the allocation ratio of each subordinate organization according to the selected plan quantity allocation method, and then allocate the planned quantity of each subordinate organization in proportion. During the allocation process, the planned total amount, the put amount, and the data of the header table, sub-table and industrial subtotal total row are updated in real time to ensure data accuracy. If the planned total amount is inconsistent with the put amount, or the put amount exceeds the available put amount, the commodity row will be automatically highlighted (yellow background) to detect and adjust the problem in time.

[0091] When allocating the planned amount to each subordinate organization, the result is calculated by rounding down, and it is ensured that the calculated total of the planned amount of each subordinate organization is not less than the delivery amount. If the calculated total is less than the delivery amount, the remaining amount will be allocated from large to small according to the allocation ratio, 1 unit at a time. If it is less than 1 unit, the remaining part will be allocated to ensure the maximum utilization of resources.

[0092] d) The enterprise sales department determines the quantity of goods to be allocated:

[0093] In the actual implementation of the company's sales plan, the sales department closely follows the real-time sales performance, inventory dynamics and market feedback of each subordinate organization to flexibly and efficiently adjust the allocation of goods. This adjustment strategy revolves around two core methods:

[0094] ① Strategy of allocating total amount by number of times:

[0095] First, the planned remaining quantity divided by the preset allocation times is accurately calculated as the theoretical allocation benchmark. Then, the smaller of the current available inventory and this benchmark value is taken as the total amount for this allocation, ensuring that the allocation amount does not exceed the planned upper limit or the inventory limit.

[0096] ②Allocation strategy based on the remaining quantity ratio:

[0097] Preliminary allocation: Based on the proportion of the planned surplus of each subordinate organization, the allocation amount of each subordinate organization is preliminarily determined by rounding down to ensure the fairness of the allocation process.

[0098] Secondary distribution: The extra surplus generated by rounding in the initial distribution is further distributed in detail based on the proportion of the planned surplus of each subordinate organization, in an effort to maximize resource utilization.

[0099] The core goal of these two dynamic adjustment strategies is to achieve accurate and efficient allocation of goods, aiming to avoid inventory backlogs and ensure adequate market supply, thereby ensuring the smooth progress of sales activities and improving the overall operational efficiency of the enterprise.

[0100] e) The logistics company starts to distribute the goods:

[0101] According to the distribution instructions from the enterprise sales department, the logistics company began to distribute goods to each subordinate organization.

[0102] f) Physical warehousing and sales of goods by each subordinate organization: After receiving the goods delivered by the logistics company, each subordinate organization will carry out physical warehousing operations and start selling the goods according to the sales plan.

[0103] Through the detailed planning and execution of the above processes, enterprises can achieve efficient coordination in procurement, sales, inventory, logistics and other links, and improve their operational efficiency and market competitiveness.

[0104] Embodiment 2:

[0105] This embodiment also provides an electronic device, including: a memory and a processor;

[0106] Wherein, the memory stores computer-executable instructions;

[0107] The processor executes the computer-executable instructions stored in the memory, so that the processor executes the commodity purchasing and distribution method based on the centralized purchasing and distribution model in any embodiment of the present invention.

[0108] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor may be a microprocessor or any conventional processor, etc.

[0109] The memory can be used to store computer programs and / or modules. The processor realizes various functions of the electronic device by running or executing the computer programs and / or modules stored in the memory, and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc.; the data storage area can store data created according to the use of the terminal, etc. In addition, the memory can also include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SMC), a secure digital (SD) card, a flash memory card, at least one disk storage period, a flash memory device, or other volatile solid-state storage devices.

[0110] Embodiment 3:

[0111] This embodiment also provides a computer-readable storage medium, in which a plurality of instructions are stored, and the instructions are loaded by a processor, so that the processor executes the commodity procurement and distribution method based on the centralized purchase and distribution model in any embodiment of the present invention. Specifically, a system or device equipped with a storage medium can be provided, on which a software program code that implements the functions of any of the above embodiments is stored, and a computer (or CPU or MPU) of the system or device reads and executes the program code stored in the storage medium.

[0112] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.

[0113] The storage medium embodiments for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RYM, DVD-RW, DVD+RW), a magnetic tape, a non-volatile memory card, and a ROM. Alternatively, the program code can be downloaded from a server computer via a communication network.

[0114] In addition, it should be clear that the functions of any of the above embodiments can be implemented not only by executing the program code read by the computer, but also by enabling an operating system operating on the computer to complete part or all of the actual operations based on instructions from the program code.

[0115] In addition, it can be understood that the program code read from the storage medium is written to a memory provided in an expansion board inserted into the computer or written to a memory provided in an expansion unit connected to the computer, and then based on the instructions of the program code, a CPU installed on the expansion board or the expansion unit is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above-mentioned embodiments.

[0116] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A commodity purchasing and distribution method based on the centralized purchasing and distribution model, characterized in that: This method is to summarize and analyze the monthly demand of each subordinate department, and formulate a preliminary procurement plan for the next month at the end of each month based on market supply, price fluctuations and inventory status, that is, the monthly connection quantity, and adjust the corresponding supplementary quantity according to the actual situation. The monthly connection quantity and the supplementary quantity constitute the monthly connection total quantity, and the monthly connection total quantity is automatically updated to the actual procurement volume executed in the current month; then formulate a personalized sales plan based on the civilization indicator allocation strategy and the average monthly forecast allocation strategy based on the half-year forecast quantity; then adopt the total amount allocation strategy based on the number of times and the allocation strategy based on the remaining quantity ratio to formulate the commodity allocation quantity, avoid inventory backlogs, and ensure adequate market supply.

2. The commodity purchasing and distribution method based on the centralized purchasing and distribution model according to claim 1 is characterized in that: The monthly connection total is automatically updated to the actual purchase volume of the month as follows: Multi-threaded data acquisition: parallel acquisition of commodity information that each subordinate department needs to purchase; Integrate data: Integrate all the products on sale this month and the monthly connection volume in the monthly purchase plan; among them, the products on sale include those that did not exist at the beginning of the month but were added in the middle of the month; Actual purchase quantity query: query and record the actual purchase quantity of all commodities in the month; Calculate the additional quantity: Based on the goods on sale, calculate the difference between the actual purchase quantity of the month and the monthly connection quantity through the monthly connection quantity association data to obtain the additional quantity; Unit conversion and return: convert the supplementary amount according to the front-end parameter unit, and return a data set containing the monthly connection amount and the supplementary amount; Front-end update: The front-end loops through the table data, matches and updates the supplementary quantity according to the monthly connection quantity, and automatically adjusts the monthly connection total to be equal to the monthly connection plus the supplementary quantity as the actual purchase quantity for the month.

3. The commodity purchasing and distribution method based on the centralized purchasing and distribution model according to claim 1 is characterized in that: The specific strategy for allocating civilization indicators is as follows: Accurately calculate the percentage of dual-civilization indicators of each subordinate department; Set the planned quantity for the subordinate departments participating in the allocation. The planned quantity is determined by multiplying the total delivery quantity by the respective proportion and rounding down; Calculate the remaining amount after delivery, which is the total planned delivery amount minus the amount already allocated to each subordinate department; Evenly distribute the remaining amount to each subordinate department to further balance resource allocation; If there is still surplus, it will be added to the lower-level department with the largest demand to meet market demand.

4. The commodity purchasing and distribution method based on the centralized purchasing and distribution model according to claim 1 is characterized in that: The specific allocation strategy for the average monthly forecast based on the half-year forecast is as follows: Select the half-year cycle to which the planning month belongs; Summarize the estimated demand of each subordinate organization for the half year and calculate the proportion of each demand to the total; The planned amount is allocated to each subordinate organization according to the proportion by rounding down; Calculate the remaining amount after delivery, which is the total planned delivery amount minus the amount already allocated to each subordinate department; Evenly distribute the remaining amount to each subordinate department to further balance resource allocation; If there is still surplus, it will be added to the lower-level department with the largest demand to meet market demand.

5. The commodity purchasing and distribution method based on the centralized purchasing and distribution model according to claim 1 is characterized in that: In the process of formulating a personalized sales plan based on the civilization indicator allocation strategy and the average monthly forecast allocation strategy based on the half-year forecast, the data is saved by verification, as follows: ① Verify whether the product data can be saved as a whole according to the page display unit; ② Check whether the total planned quantity is equal to the delivered quantity; ③ Ensure that the delivery amount does not exceed the available delivery amount; Only when the above three conditions are met, the data is automatically organized and the backend interface is called to perform the save operation.

6. The commodity purchasing and distribution method based on the centralized purchasing and distribution model according to claim 1 is characterized in that: This method also supports modifying the product release quantity, and according to the selected plan quantity allocation method, it queries the allocation ratio of each subordinate organization, and then allocates the plan quantity of each subordinate organization in proportion; During the allocation process, the planned total amount, delivery amount, and data of the header table, sub-table, and industrial subtotal are updated in real time, and the data accuracy is ensured; If the planned total quantity is inconsistent with the total quantity delivered, or the total quantity delivered exceeds the available quantity, the corresponding product row will be automatically highlighted so that the problem can be discovered and adjusted in time; When allocating the planned quantities of each subordinate organization, the result is calculated by rounding down, and it is ensured that the total planned quantities of each subordinate department is not less than the delivery quantity; If the calculated total is less than the delivery amount, the remaining amount will be distributed according to the distribution ratio from large to small, 1 unit at a time; If there is less than 1 unit, the remaining part will be allocated to ensure maximum utilization of resources.

7. The commodity purchasing and distribution method based on the centralized purchasing and distribution model according to claim 1 is characterized in that: The specific strategy of allocating the total amount by number of times is as follows: Accurately calculate the value of the planned remaining amount divided by the preset allocation times as the theoretical allocation benchmark; The smaller of the current available inventory and this benchmark value is taken as the total amount for this allocation, ensuring that the allocation amount neither exceeds the planned upper limit nor exceeds the inventory limit.

8. The commodity purchasing and distribution method based on the centralized purchasing and distribution model according to any one of claims 1 to 7, characterized in that: The specific allocation strategy based on the remaining amount ratio is as follows: Preliminary allocation: Based on the proportion of the planned surplus of each subordinate organization, the allocation amount of each subordinate organization is preliminarily determined by rounding down; Secondary distribution: The additional surplus caused by rounding in the initial distribution is further distributed in detail based on the proportion of the planned surplus of each subordinate organization.

9. An electronic device, characterized in that: include: memory and at least one processor; Wherein, the memory stores a computer program; The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the commodity procurement and distribution method based on the centralized purchasing and distribution model as described in any one of claims 1 to 8.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, which can be executed by a processor to implement the commodity procurement and distribution method based on the centralized purchasing and distribution model as described in any one of claims 1 to 8.

Images