Methods, systems, and media for product sales cost management

Through component design and efficient storage solutions, the flexibility and efficiency of the existing automotive industry sales cost management system during policy changes is solved, rapid adaptation and efficient calculation are achieved, and operational costs are reduced.

CN119048014APending Publication Date: 2024-11-29BMW BRILLIANCE AUTOMOTIVE
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411189627.6
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-28
Publication Date
2024-11-29

AI Technical Summary

Technical Problem

The existing sales cost management system in the automotive industry has poor flexibility, long transformation cycle and high cost when facing policy changes, making it difficult to quickly adapt to market and policy changes, resulting in an impact on operational efficiency.

Method used

Adopt component-based modular design, analyze product sales incentive policies, extract assembled policy components, configure flexible policy templates, and use MongoDB and Redis to store policy information to achieve automatic calculation and rapid adaptation of new policies, reducing manual maintenance. and system transformation.

Benefits of technology

It improves the system's adaptability and computing efficiency to policy changes, reduces the cost of program modification and manual maintenance, and achieves more flexible and efficient sales cost management.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119048014A_ABST
    Figure CN119048014A_ABST
Patent Text Reader

Abstract

The embodiment of the invention relates to a product sales cost management method and system and a medium. According to one aspect of the disclosure, a method for product sales cost management is provided, comprising: uploading a configured offline Excel template to generate an online workbench form, where the generated online workbench form includes the same header line configuration as the uploaded offline Excel template, the offline Excel template is configured on the basis of policies issued for a type of dealers, and at least one column in one or more columns in a title row of the offline Excel template is associated with a performance calculation rule for the type of dealers; and reading data associated with one or more columns in the header rows of the online table form from the one or more external data systems, and automatically populating at least some of the one or more columns in the header rows of the online table form. According to the embodiment of the invention, the working efficiency and accuracy in product sales cost management can be improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present disclosure relates to information processing technology, and more particularly to a method, system and medium for managing product sales cost. Background Art

[0002] On the one hand, in the current automotive industry, sales cost management is a crucial link, which directly affects the profitability and market competitiveness of enterprises. However, the existing sales cost management methods have many limitations, especially in terms of the flexibility and efficiency of cost calculation and management.

[0003] In existing technologies, in addition to relying on manual offline management and calculation, car companies also generally use fixed hardcoded forms to maintain and record basic rules for cost calculation. These forms usually contain a series of fixed parameters and calculation formulas to automatically or semi-automatically calculate costs during the sales process. In actual operations, the system will extract the necessary information from the forms according to these preset rules to complete the cost calculation and management.

[0004] Although the existing sales cost management method can complete the cost calculation and management tasks to a certain extent, it has the following major disadvantages:

[0005] a) Poor policy adaptability: Once the relevant policies change, and the existing forms cannot adapt to the changed policies, the existing system often finds it difficult to adapt to the new rules and needs to be transformed and adapted. This transformation not only involves software updates, but sometimes also hardware upgrades to meet the requirements of the new policies.

[0006] b) Long system transformation cycle and high cost: System transformation usually takes a long time to plan, develop and test, which will incur additional costs. For car companies, this means that during the system transformation period, the efficiency of sales cost management will be affected, which in turn affects the overall operational efficiency.

[0007] c) Mismatch between transformation time and policy release timeliness: Since system transformation takes time, it is often difficult to meet the timeliness requirements of policy release. After the new policy is released, automakers may need to temporarily use manual offline methods to handle sales cost management, which not only increases the workload, but also increases the possibility of errors.

[0008] In summary, the existing sales cost management system in the automotive industry has shown obvious deficiencies in responding to market and policy changes, and a new management system that is more flexible, efficient and can quickly adapt to changes is urgently needed. Based on this background, this application proposes an innovative sales cost management system, which aims to address the deficiencies of the existing technology and improve the adaptability of the sales cost management in the automotive industry to policy changes.

[0009] On the other hand, in the field of sales cost management in the automotive industry, the currently commonly used methods have many shortcomings. Automakers usually rely on hardcoded forms and purely manual offline calculations to manage sales costs and calculate dealer assessments. This traditional method has obvious defects. Hardcoded forms are inflexible and cannot adapt to flexible and changing policies and assessment logic changes. Offline calculations not only consume a lot of manpower and material resources and increase costs, but are also inefficient and prone to errors.

[0010] Due to the limitations of existing technologies, it is difficult for automakers to quickly and accurately complete sales cost management and dealer assessment when responding to market changes and policy adjustments, which has caused certain obstacles to the operation and development of the company. Therefore, there is an urgent need for a more efficient, flexible and convenient sales cost management system to solve these problems. Summary of the invention

[0011] Embodiments of the present disclosure relate to a method, system, and medium for managing product sales costs.

[0012] According to one aspect of the present disclosure, a method for product sales cost management is provided, comprising: uploading a configured offline Excel template to generate an online workbench form, wherein the generated online workbench form includes the same header row configuration as the uploaded offline Excel template, the offline Excel template is configured based on a policy published for a class of dealers, and at least one of the one or more columns in the header row of the offline Excel template is associated with a performance calculation rule for the class of dealers; and reading data associated with one or more columns in the header row of the online workbench form from one or more external data systems, and automatically filling in at least some of the one or more columns in the header row of the online workbench form.

[0013] In some embodiments, the method may further include receiving the published policy for a class of dealers and automatically generating the offline Excel template based on the published policy.

[0014] In some embodiments, the method may further include reading data associated with one or more columns in the header row of the offline Excel template from one or more external data systems and automatically filling at least some of the one or more columns in the header row of the offline Excel template.

[0015] In some embodiments, the method may further include receiving a user's edit to at least one column in a header row of the generated online workbench form, generating a new online workbench form, and saving the generated new online workbench form.

[0016] In some embodiments, the external data system includes at least one of the following: a dealer sales target management system; a product sales incentive policy configuration system; a sales data management system; a user authority management system; and a dealer assessment management system.

[0017] In some embodiments, the method may further include a header row of the online workbench form including at least the following columns: a dealer basic information column, including at least one of a dealer name column, a number column, and a region column; a performance calculation result column, used to output automatically calculated performance results; and a performance calculation factor column, used to input data items on which the performance calculation is based, wherein for the performance calculation result column, calculation rules for calculating the performance results based on the data items in the performance calculation factor column are defined according to published policies.

[0018] In some embodiments, the method may also include receiving user edits to data in at least some columns of the performance calculation factor column, and automatically outputting corresponding performance calculation results in the performance calculation result column in response to receiving user edits to data in at least some columns of the performance calculation factor column.

[0019] In some embodiments, the method may also include at least one of the following information for a policy published for a class of dealers: a policy number associated with the published policy; applicable information indicating the class of dealers; information indicating the applicable period of the published policy; an executable computing policy number associated with the published policy; and computing rules of the executable computing policy associated with the published policy.

[0020] In some embodiments, the method may also include: reading an executable calculation policy number included in a published policy; searching a database for a corresponding performance calculation rule based on the executable calculation policy number; and configuring a column in the header row of an Excel template associated with the performance calculation rule for this type of dealer based on the found calculation rule.

[0021] According to another aspect of the present disclosure, a computer system is provided, comprising: one or more processors, and a memory coupled to the one or more processors, the memory storing computer-readable program instructions, which when executed by the one or more processors perform the method described above.

[0022] According to another aspect of the present disclosure, a computer-readable storage medium is provided, on which computer-readable program instructions are stored. When the instructions are executed by the processor, the method described above is performed. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] The above and other objects, features and advantages of the present disclosure will become more apparent through a more detailed description of exemplary embodiments of the present disclosure in conjunction with the accompanying drawings, wherein like reference numerals generally represent like components in the exemplary embodiments of the present disclosure.

[0024] Figure 1 is a block diagram of a component-based product sales incentive policy configuration system according to an embodiment of the present disclosure.

[0025] Figure 2 It is a flowchart of a component-based product sales incentive policy configuration method according to an embodiment of the present disclosure.

[0026] Figure 3A-3C Portions of an exemplary policy template configuration user interface according to an embodiment of the present disclosure are shown.

[0027] Figures 4A-4B Portions of an exemplary policy template preview user interface are shown according to an embodiment of the present disclosure.

[0028] Figure 5 An example of an exemplary to-be-published policy configuration user interface according to an embodiment of the present disclosure is shown.

[0029] Figure 6A-6B Several portions of a published policy / policy configuration viewing user interface are shown according to an embodiment of the present disclosure.

[0030] Figure 7 A block diagram of a system for managing product sales costs according to an embodiment of the present disclosure is shown.

[0031] Fig. 8A An exemplary workbench management user interface according to an embodiment of the present disclosure is shown.

[0032] Figure 8B An exemplary online workbench form user interface according to an embodiment of the present disclosure is shown.

[0033] Fig. 9A and Fig. 9B A flow chart showing a method for managing product sales costs according to an embodiment of the present disclosure.

[0034] Fig.10 FIG. 4 is a schematic diagram showing a general hardware environment in which a device according to an embodiment of the present disclosure can be implemented. DETAILED DESCRIPTION

[0035] The following description is provided to enable those skilled in the art to make and use the embodiments, and is provided in the context of a specific application and its requirements. Various modifications will be apparent to those skilled in the art, and the general principles defined herein may be applied to other embodiments and applications without departing from the spirit and scope of the embodiments. Therefore, the embodiments are not limited to the embodiments shown, but are to be given the widest scope consistent with the principles and features disclosed herein.

[0036] On the one hand, the present disclosure considers more fine-grained modular integration for the situation of policy changes. By analyzing the hundreds of existing product sales incentive policies, several components common to all or part of the product sales incentive policies are extracted (this allows each complete policy to be divided into multiple parts corresponding to multiple components), and each component can contain information elements common to all or part of the product sales incentive policies. Different policy templates can be configured based on components. In other words, flexible configuration of different policy templates can be achieved through component assembly and integration. This means that when a new policy appears, as long as the new policy can be implemented by combining existing components, there is no need to modify the system code, and there is no need to modify the system's software / hardware. Moreover, the system's adaptation to the new policy is effective immediately, without any time delay.

[0037] In the disclosed embodiment, because the policies in the policy configuration are all in tree structure, MongoDB is selected to store the pre-configured policy templates and the policies to be released / released, which greatly improves the flexibility of the system configuration and facilitates the downstream system to parse the policy configuration information. In addition, the released policies are saved in Redis, because Redis allows query processing to be configured by mapping, which makes the subsequent use processing performance higher.

[0038] The disclosed embodiments achieve flexible policy template configuration by creating a large number of components with diverse functions, which can meet policy changes and better support automatic calculation, solve the problems of maintenance and lack of automatic calculation support caused by annual policy changes, reduce the cost of program modification and the workload of manual maintenance and calculation, and improve the overall efficiency of the enterprise.

[0039] In another aspect, embodiments of the present disclosure provide improved methods, systems, and media for product sales cost management.

[0040] The existing dealer quality assessment business process is to manually create Excel forms offline by reading natural language policy texts, organize sales data and perform performance calculations through Excel forms, and then email them to dealers. This is very inefficient and prone to errors, and cannot adapt to policy changes and sales data changes in a timely manner.

[0041] The disclosed embodiment allows users to upload a configured Excel template (e.g., an Excel template with defined dealer basic information columns, performance calculation factor columns, performance calculation result columns, etc.) with one click, and transforms the offline Excel template into an online workbench form that can be viewed and edited online and integrated in the system. The disclosed embodiment also considers automatically reading data from one or more external data systems to automatically fill in some columns in the online workbench form. This can greatly improve the work efficiency and accuracy of users.

[0042] The disclosed embodiment also considers that when a policy issued to a dealer is received, an Excel template can be automatically created, for example, some columns in the title row of the Excel template can be automatically configured according to the information contained in the policy. When a specific calculation rule is involved in the policy, the calculation rule can be automatically obtained and applied to the definition of the column in the Excel template. This can greatly improve the work efficiency and accuracy of the administrator.

[0043] The disclosed embodiment also allows the administrator to view and edit the automatically generated Excel template, such as adjusting some columns, adding some columns, and changing the settings of some columns. This allows the administrator to configure the Excel template efficiently and flexibly.

[0044] The disclosed embodiment also allows data to be automatically read from an external data system to fill in part of the columns in an Excel template that is manually generated / edited by a user or automatically generated.

[0045] The disclosed embodiment also allows the administrator to view and edit the online workbench form generated based on the uploaded Excel template to generate a new online workbench form with a different header row configuration from the Excel template. This allows the administrator to more flexibly configure the online workbench form to implement different performance management assessments.

[0046] The disclosed embodiments can enable users to completely or almost completely get rid of offline form editing and maintenance, and can realize completely online business work according to the process designed by the system.

[0047] The disclosed embodiments satisfy various assessment calculation methods, reduce manual operation steps, shorten operation time, reduce user workload, speed up calculation speed, and can flexibly respond to changes in policies and assessment logic.

[0048] Figure 1 is a block diagram of a component-based product sales incentive policy configuration system 100 according to an embodiment of the present disclosure.

[0049] like Figure 1As shown, the system 100 may include a component configuration module 1001 , a policy configuration module 1002 , a function control module 1003 and a data storage module 1004 .

[0050] The component configuration module 1001 is used to create various components based on the analysis of existing policies. In the embodiment of the present disclosure, the component is a general small-grained information unit parsed / extracted based on the analysis of a large number of existing policies. The component can be a basic information component that includes some basic static information, and the component can also include a functional information component that defines execution actions / calculation rules.

[0051] The policy configuration module 1002 is used to assemble various policy templates (referred to as pre-configured policy templates) based on at least some of the created components. The policy configuration module 1002 can also be used to provide a preview of the pre-configured policy templates. The policy configuration module 1002 can also be used to configure specific policies / policy configurations to be released to specific dealers based on the dealer's parameters using the pre-configured policy model. The policy configuration module 1002 can also be used to release policies generated using the pre-configured policy templates based on the dealer's parameters.

[0052] The function control module 1003 is used to control the user's control over the functions provided by the component configuration module 1001 and the policy configuration module 1002 according to the user's authority. The function control module 1003 can also control the interaction between the component configuration module 1001, the policy configuration module 1002, and the data storage module 1004.

[0053] The data storage module 1004 is used to save the created components, pre-configured policy templates, and published policies, etc. In some embodiments, the component configuration module 1001 can store the created components in the database in JSON format via the data storage module 1004. The policy configuration module 1002 can store the created components in MangoDB in JSON format via the data storage module 1004 and store the published policies in MangoDB and Redis in JSON format.

[0054] Figure 2 is a flowchart of a component-based product sales incentive policy configuration method 200 according to an embodiment of the present disclosure.

[0055] like Figure 2 As shown, method 200 may include step 2001, in which a user operation for a component is received via a policy template configuration user interface, wherein each component includes information elements common to all product sales incentive policies or at least part of the product sales incentive policies.

[0056] The method 200 may further include step 2002 , in which a preconfigured policy template is created based on a received user operation on a component, wherein the preconfigured policy template includes at least one component.

[0057] The policy template configuration user interface may include a plurality of user-operable components.

[0058] Figure 3A-3C Portions of an exemplary policy template configuration user interface 300 are shown according to an embodiment of the present disclosure.

[0059] like Figure 3A As shown, the left side of the policy template configuration user interface 300 shows a list of configured policy templates, as shown in 301. 3011 indicates the policy template "A Type-i-AC" currently being configured.

[0060] The middle part of the policy template configuration user interface 300 is a display bar of draggable components, as shown in 302. Each icon can represent a component. In some embodiments, an icon can also represent a component item including multiple components.

[0061] On the right side of the policy template configuration user interface 300 is an editing bar 303, and the user can drag the selected component from the component display bar 302 to the editing bar 303, so that the specific composition of the component is displayed in the editing bar 303. Figure 3A , the specific composition of the components "Basic Information" and "Eligible Information" are shown. For example, the component "Basic Information" includes information elements such as "VKH Name".

[0062] Figure 3B Another portion of the policy template configuration user interface 300 is shown. Figure 3B The editing bar 303 shows that the policy being configured also includes a component "A Type-i", which includes various information elements such as "Responsible Role" (person in charge) and "Support level" (support ratio).

[0063] In some cases, "A Type-i" can be considered a component project that includes multiple finer-grained components, such as Supporting level, and Figure 3C In this case, dragging the icon of the component item "A Type-i" can drag all components of the component item to the editing bar.

[0064] In the component display column 302, it can be seen that the user-operable components can be displayed in a hierarchical structure. It can also be seen that the configured policy templates can also be displayed in a hierarchical structure, such as Figures 3A-3C As shown in 301.

[0065] Operation buttons such as "add", "copy", "delete", and "modify" may be set for a component. A user may copy a component by selecting a "copy" button for a component, add a component by selecting an "add" button for a component, delete a component by selecting a "delete" button for a component, and / or edit (e.g., delete) at least one information element of a component by selecting a "modify" button for a component.

[0066] Operation buttons such as "add", "copy", "delete", and "modify" may be set for information elements. A user may copy an information element by selecting a "copy" button for an information element, add an information element by selecting an "add" button for an information element, delete an information element by selecting a "delete" button for an information element, and / or edit an information element by selecting a "modify" button for an information element.

[0067] like Figures 3A-3C As shown, the policy template configuration user interface 300 can also be provided with a "Save Template" button. During the process of configuring the policy template, the user can select the "Save Template" button at any time to save the pre-configured policy template in the current state in the database. In some embodiments, the pre-configured policy template is saved in MongoDB in JSON format. It can be understood that various policy templates can be configured based on the analysis of massive policies. These policy templates can be saved in layers according to business types, etc. Such saving will involve rich layers and complex tree structures. Saving the pre-configured policy templates in MongoDB in JSON format can achieve a flexible, efficient and scalable data storage solution.

[0068] It is understandable that the user can call the previously saved pre-configured policy template as needed, and modify it on this basis to obtain the pre-configured policy template he needs.

[0069] It is understandable that those skilled in the art can design various components based on the analysis of policies. These components are smaller in granularity than policies and are often information configuration units commonly required by many policies. This allows various policy templates / policies to be assembled based on components. As long as the components involved in the policy template / policy configuration are within the coverage of the components provided by the system, the policy template / policy configuration can be implemented through modular assembly of components, without the need to modify the system code to adapt to policy changes once the policy changes.

[0070] In some embodiments, a user may be provided with a preview of a preconfigured policy template. Figure 3A-3C As shown, a "preview" button is provided in the edit column 303 of the policy template configuration user interface 300. The user can preview the pre-configured policy template by selecting the "preview" button.

[0071] Figures 4A-4B Portions of an exemplary policy template preview user interface 400 are shown in accordance with an embodiment of the present disclosure.

[0072] Preconfigured policy templates can include user Figure 3A-3C All components configured for a specific policy template to describe the operation.

[0073] like Figures 4A-4B As shown, the preconfigured policy template includes components “Basic Information”, “Eligible Information”, and “A Type-I” (A Type-I quarterly retail quantity), as shown in 401. Each component contains its own information element (as can be seen, these information elements have not yet been configured with specific parameters), as shown in 402.

[0074] For some information elements, you can set operation buttons such as "add", "copy", and "delete".

[0075] For example, a "Submit" button may be provided in the policy template preview user interface 400 so that the pre-configured policy template confirmed by the user is submitted to, for example, business managers for their use. Figures 3A-3C The policy template configuration user interface 300 shown is provided with, for example, a "Submit" button. After previewing the policy template, the user can return to the policy template configuration user interface 300 and select the "Submit" button to submit the pre-configured policy template confirmed by the user to, for example, a business manager.

[0076] like Figure 2 As shown, the method 200 may further include step 2003, in which a policy to be issued is generated based on specific parameters of the dealer and using a pre-configured policy template.

[0077] The business administrator can call the preconfigured policy template according to the business requirements. The business administrator can access the user interface including the list of preconfigured policy templates, and select and call out the preconfigured policy template to be used.

[0078] The business management personnel can configure specific parameters for each information element of the pre-configured policy template for the dealer, thereby generating a policy / policy configuration to be released to the specific dealer.

[0079] It is understandable that before a policy / policy configuration is released, the policy / policy configuration to be released can be saved at any time and the previously saved policy / policy configuration to be released can be accessed when needed.

[0080] Figure 5 An example of a policy configuration user interface 500 to be published according to an embodiment of the present disclosure is shown.

[0081] like Figure 5 As shown, the policy configuration user interface 500 may display the components of the policy to be issued, as shown in 502. It can also be seen that the information elements in each component have been configured with specific parameters, which may be different for different dealers, for example.

[0082] The policy configuration user interface 500 may also include a “Release” button (as shown in 504 ) for publishing the policy.

[0083] The to-be-published policy configuration user interface 500 may also include a “Recall” button for recalling the policy.

[0084] like Figure 2 As shown, method 200 may also include step 2004, in which the generated policy to be issued is issued to the corresponding dealer. This is done, for example, by the user in Figure 5 The "Release" button is selected in the policy configuration user interface 500 to be released to execute.

[0085] Published policies can be saved in MongoDB and Redis in JSON format.

[0086] Resellers can view published policies / policy configurations.

[0087] Figure 6A-6B 6 shows portions of a published policy / policy configuration viewing user interface 600 according to an embodiment of the present disclosure. Fig. 6A As shown, you can see that the published policy includes configured components, including basic information, applicable information, and Class A quarterly retail data.

[0088] Although not shown, Figure 2The method 200 shown may also include creating a component and storing the created component in a database. Taking the creation of a "basic information" component as an example, creating a component may include creating a component name and defining information elements included in the component, as well as value restrictions for each information element.

[0089] Figure 7 A block diagram of a system 700 for managing product sales cost according to an embodiment of the present disclosure is shown.

[0090] like Figure 7 As shown, the system 700 may include a configuration module 7001 , an intelligent computing module 7002 , a function control module 7003 and a data storage module 7004 .

[0091] The configuration module 7001 is used to automatically generate an offline Excel template according to a policy published for a class of dealers, including automatically configuring one or more columns in a header row of the Excel template according to the published policy.

[0092] For example, the title row of the Excel template may include a dealer basic information column (e.g., including but not limited to the dealer name column, number column, region column, etc.); a performance calculation result column for outputting automatically calculated performance results; and a performance calculation factor column for inputting data items based on which the performance calculation is based. For the performance calculation result column, calculation rules for calculating performance results based on data items in the performance calculation factor column may be defined according to published policies. In other words, the configuration module 7001 may also be used to determine corresponding calculation rules for each type / each dealer.

[0093] The policy published for a type of dealers may include, for example, but is not limited to, a policy number associated with the published policy (e.g., CL#), applicable information indicating the type of dealers (e.g., whether it applies to all dealers or dealers in certain areas); information indicating the applicable period of the published policy; an executable computing policy number associated with the published policy (e.g., a VKH number); calculation rules of the executable computing policy associated with the published policy (e.g., calculation rules of KPI), etc.

[0094] It can be understood that when a published policy is received, the executable calculation policy number included in the published policy can be read, and the corresponding performance calculation rules can be found from the database (such as Redis) based on the executable calculation policy number, and the columns associated with the performance calculation rules for this type of dealers in the title row of the Excel template can be configured based on the found calculation rules.

[0095] The configuration module 7001 can save the generated / configured Excel template in a database. The database may include but is not limited to PostgreSQL, Redis, etc.

[0096] The configuration module 7001 can also be used to upload a configured offline Excel template to generate an online workbench form. In some embodiments, the online workbench form includes the same header row configuration as the configured offline Excel template. In other embodiments, the online workbench form can have a different header row from the configured offline Excel template, for example, it can have more columns, fewer columns, or a header row with different columns defined.

[0097] The configuration module 7001 allows the user to view and edit / modify the online workbench form, and save the edited / modified online workbench form to a database, which may include but is not limited to PostgreSQL, Redis, etc.

[0098] In some embodiments, the configuration module 7001 can also be used to read data associated with one or more columns in the header row of the offline Excel template from one or more external data systems, and automatically fill in at least some of the one or more columns in the header row of the offline Excel template.

[0099] The intelligent calculation module 7002 automatically and asynchronously calculates the performance results of each dealer according to the calculation rules of each dealer based on the different data configurations of each dealer in the online workbench form. The intelligent calculation module 7002 can store the calculated performance results in a database.

[0100] The intelligent calculation module 7002 also provides a delayed retry function in the event of calculation failure. The calculation failure may be due to the failure of imported data or the difference between the imported data and the actual data over time. The performance results can be recalculated for each or some of the dealers regularly or based on event triggers.

[0101] Function control module 7003 is used to control user access to functions provided by configuration module 7001, intelligent computing module 7002 and data storage module 7004 according to user rights. User rights include dealer rights and business administrator rights. Dealers can only view their own performance results, and business administrators can view and operate all and / or part of the pages and / or buttons.

[0102] The data storage module 7004 is used to store data from the configuration module 7001 and the intelligent calculation module 2002, and provide the saved data to the configuration module 7001 and the intelligent calculation module 2002. The data storage module 7004 can save various data related to Excel templates and online workbench forms, and can store dealer calculation rules and performance calculation results, etc.

[0103] Fig. 8A An exemplary workbench management user interface 8001 is shown according to an embodiment of the present disclosure.

[0104] As shown in the figure, each entry on the interface may correspond to a policy that has been issued for a class of dealers. A user may select the entry to jump to the online workbench form user interface for the issued policy, such as Figure 8B shown.

[0105] exist Fig. 8A In the user interface, the user can switch to the viewing user interface or the editing user interface by operating the "View" and "Edit" buttons.

[0106] In some embodiments, operation buttons such as "Generate Excel Template" and "Upload Excel Template" may be set for each entry. When the user selects the "Generate Excel Template" button, the system may automatically generate an Excel template according to the corresponding policy. For example, as described above, some columns in the header row of the Excel template are automatically configured according to the information included in the published policy. In some embodiments, the user may also edit some columns in the header row of the Excel template. A "Save" button may be provided to allow the user to save the data of the configured Excel template to the database. When the user selects the "Upload Excel Template" button, the configured and saved Excel template may be uploaded, thereby generating an online workbench form. It will be understood that those skilled in the art may design different workbench management user interfaces as needed.

[0107] Excel template upload can be achieved by using software such as SpreadJS. SpreadJS supports online import / export of Excel (xlsx) and export of PDF documents. Users can load and modify various Excel documents in the browser and save the modified data to the database, thereby supporting the import of template data. SpreadJS's calculation engine supports more than 450 Excel formula functions, including custom functions, array functions, dynamic arrays, asynchronous functions, XMATCH, LET, XLOOKUP functions, etc., so calculation rules can be imported at the same time.

[0108] Figure 8BAn exemplary online workbench form user interface 8002 is shown according to an embodiment of the present disclosure.

[0109] exist Figure 8B In the online workbench form, columns AG may represent dealer basic information columns, such as dealer name, number, etc.; column H may represent performance calculation result columns, which are used to display performance results automatically calculated based on configuration data and calculation rules for specific dealers; columns I to N may represent performance calculation factor columns, of which columns J to M may be automatically filled by reading relevant data from one or more external data systems, and columns I and N are manually filled by users (such as business administrators).

[0110] For the performance calculation result column, a calculation rule can be defined to calculate the output result of the performance calculation result column based on the data in the performance calculation factor column. This is, for example, automatically generated by analyzing the published policy when the Excel template is generated for the published policy. More specifically, for example, the number of the executable calculation policy is extracted from the published policy to obtain the corresponding specific calculation rule, and the calculation rule of the performance calculation result column in the Excel template is defined based on the obtained specific calculation rule.

[0111] Fig. 9A A flowchart of a method 9001 for managing product sales costs according to an embodiment of the present disclosure is shown.

[0112] As shown in the figure, method 9001 includes step 901, in which a policy published for a class of dealers is received.

[0113] The published policy is as follows: Figure 1-6B The described component-based product sales incentive policy configuration method is configured. The published policy includes multiple information components / information elements of small granularity suitable for automatic computer parsing. For example, the published policy can enable the computer system to easily determine the specific calculation rules of the executable calculation policy of each dealer, thereby facilitating subsequent calculations.

[0114] In some embodiments, a policy published for a class of dealers may include at least one of the following information: a policy number associated with the published policy (e.g., CL#), applicability information indicating the class of dealers, information indicating the applicable period of the published policy, an executable computing policy number associated with the published policy (e.g., a VKH number), and computing rules of the executable computing policy associated with the published policy.

[0115] Method 9001 also includes step 902, in which an offline Excel template is automatically generated based on the published policy, including automatically configuring one or more columns in the header row of the Excel template based on the published policy, at least one of the one or more columns in the header row of the Excel template is associated with performance calculation rules for this type of dealer.

[0116] In some embodiments, the executable calculation policy number included in the published policy can be read, the corresponding performance calculation rule can be found from the database based on the executable calculation policy number, and the column associated with the performance calculation rule for this type of dealer in the header row of the Excel template can be configured based on the found calculation rule.

[0117] In some embodiments, method 9001 may also include step 902-1, in which data associated with one or more columns in the header row of the offline Excel template may be read from one or more external data systems and at least some of the one or more columns in the header row of the offline Excel template may be automatically filled.

[0118] The method 9001 further includes step 903 , in which the configured offline Excel template is uploaded to generate an online workbench form, wherein the online workbench form includes the same header row configuration as the configured offline Excel template.

[0119] In some embodiments, method 9001 may also include step 903-1, in which data associated with one or more columns in the header row of the online workbench form is read from one or more external data systems and at least some of the one or more columns in the header row of the online workbench form are automatically populated.

[0120] In some embodiments, the user may further edit the online workbench form generated based on the Excel template to generate a new online workbench form, and then automatically fill in the data columns.

[0121] External data systems may include, but are not limited to: a dealer sales target management system, which is used to set and track sales targets for automobile dealers, including indicators such as sales volume and amount for different models and time periods, so as to evaluate dealers' sales performance and formulate corresponding strategies; a product sales incentive policy configuration system, which is used to help configure and manage various incentive policies for automobile product sales, such as discounts, rebates, gifts, etc., to promote sales and improve market competitiveness; a sales data management system: centrally manages various types of data in the automobile sales process, including sales records, customer information, vehicle configuration, etc., for data analysis and decision support; a user authority management system, which mainly handles user authorities related to automobile sales, such as sales personnel and dealers' operating authorities and access rights, to ensure the security of the system and the compliance of data use; a dealer assessment management system, which is used to evaluate and assess the comprehensive performance of automobile dealers, and decide whether to continue cooperation, give rewards or take improvement measures based on a series of indicators and standards.

[0122] The header row of the online workbench form includes at least the following columns: a dealer basic information column, including at least one of the dealer name column, number column, and region column; a performance calculation result column, used to output automatically calculated performance results; and a performance calculation factor column, used to input data items based on which the performance calculation is based. For the performance calculation result column, the calculation rules for calculating the performance results based on the data items in the performance calculation factor column are defined according to the published policy.

[0123] Method 9001 may further include step 904, in which a user's edit of data of at least some of the performance calculation factor columns is received.

[0124] Method 9001 may further include step 905, in which, in response to receiving a user's edit of data in at least some columns of the performance calculation factor columns, the corresponding performance calculation results are automatically output in the performance calculation result column.

[0125] In some embodiments, the performance calculation factor column can be filled entirely by automatic filling. In this case, step 904 can be omitted. In this case, the corresponding performance calculation result will be automatically output in the performance calculation result column when the automatic filling is completed.

[0126] Although not shown, method 9001 may also determine whether an abnormality occurs after reading data from one or more external data systems, such as whether the data of the columns to be filled is completely filled, or whether the filled data is the latest, etc. In the case of an abnormality, the data may be read and filled again after a certain delay. In other embodiments, the data may be checked regularly for abnormalities, and in the case of an abnormality, the data may be read again and the data of the online workbench form may be filled again, and recalculated based on the updated data.

[0127] Fig. 9B A flow chart of a method 910 for managing product sales costs according to an embodiment of the present disclosure is shown.

[0128] like Fig. 9B As shown, method 910 may include step 911, in which a configured offline Excel template is uploaded to generate an online workbench form, wherein the generated online workbench form includes the same header row configuration as the uploaded offline Excel template, the offline Excel template is configured based on a policy published for a class of dealers, and at least one of the one or more columns in the header row of the offline Excel template is associated with a performance calculation rule for the class of dealers.

[0129] The offline Excel template can be automatically generated by the system based on the published policy. The offline Excel template can also be manually generated by the user based on the published policy. The offline Excel template can also be initially automatically generated by the system based on the published policy, and then manually edited and confirmed by the user.

[0130] like Fig. 9B As shown, method 910 includes step 912, in which data associated with one or more columns in the header row of the online workbench form is read from one or more external data systems and at least some of the one or more columns in the header row of the online workbench form are automatically populated.

[0131] By uploading an Excel template with one click to automatically configure at least some columns of the online workbench form, and automatically reading relevant data from relevant external data systems and filling at least some columns, the efficiency and accuracy of user work can be greatly improved.

[0132] In some embodiments, the columns associated with the performance calculation rules for this type of dealers include a performance calculation result column and a performance calculation factor column. When the performance calculation factor column can be automatically and correctly filled, automatic calculation will be performed according to the performance calculation rules and the specific data of the performance calculation factor column, and the performance calculation result will be automatically output in the performance calculation result column. In some embodiments, some performance calculation factor columns are automatically filled by the system, and some performance calculation factor columns can be filled manually. When all performance calculation factor columns are correctly filled, automatic calculation will be performed according to the performance calculation rules and the specific data of the performance calculation factor column, and the performance calculation result will be automatically output in the performance calculation result column.

[0133] In some embodiments, a user's edit of at least one column in the header row of the generated online workbench form can be received, a new online workbench form can be generated, and the generated new online workbench form can be saved. For example, the user can edit the header row as needed to generate an online work form with a different header row from the uploaded Excel template. This function allows the user to achieve more flexible online configuration. The new online workbench form can be saved in a database, including but not limited to PostgreSQL, Redis, etc.

[0134] Fig.10 FIG. 4 is a schematic diagram showing a general hardware environment in which a device according to an embodiment of the present disclosure can be implemented.

[0135] Reference now Fig.10 , a schematic diagram of an example of a computing node 600 is shown. Computing node 600 is only one example of a suitable computing node and is not intended to imply any limitation on the scope of use or functionality of the embodiments described herein. Regardless, computing node 600 is capable of implementing and / or performing any of the functions set forth above.

[0136] In computing node 600, there is a computer system / server 6012, which can operate with numerous other general or special computing system environments or configurations. Examples of well-known computing systems, environments, and / or configurations that can be suitable for use with computer system / server 6012 include, but are not limited to: personal computer systems, server computer systems, thin clients, thick clients, handheld or laptop devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, small computer systems, large computer systems, and distributed cloud computing technology environments including any of the above systems or devices, etc.

[0137] Computer system / server 6012 can be described in the general context of computer system executable instructions (such as program modules) executed by a computer system. In general, program modules can include routines, programs, objects, components, logic, data structures, etc. that perform specific tasks or implement specific abstract data types. Computer system / server 6012 can be practiced in a distributed cloud computing environment, where tasks are performed by remote processing devices linked through a communication network. In a distributed cloud computing environment, program modules can be located on both local or remote computer system storage media including memory storage devices.

[0138] like Fig.10 As shown, the computer system / server 6012 in the computing node 600 is shown in the form of a general computing device. The components of the computer system / server 6012 may include, but are not limited to: one or more processors or processing units 6016, a system memory 6028, and a bus 6018 that couples different system components including the system memory 6028 to the processing unit 6016.

[0139] Bus 6018 represents any one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor, or a local bus using any of a variety of bus architectures. By way of example and not limitation, these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an Enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, a Peripheral Component Interconnect (PCI) bus, a Peripheral Component Interconnect Express (PCIe), and an Advanced Microcontroller Bus Architecture (AMBA).

[0140] The computer system / server 6012 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the computer system / server 6012, including volatile and nonvolatile media, removable and non-removable media.

[0141] System memory 6028 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 6032. Computer system / server 6012 may also include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, a storage system 6034 may be provided for reading from a non-removable non-volatile magnetic medium (not shown, and commonly referred to as a "hard drive") and writing to a non-removable non-volatile magnetic medium. Although not shown, a disk drive for reading from a removable non-volatile disk (e.g., a "floppy disk") and writing to a removable non-volatile disk, and an optical drive for reading from a removable non-volatile optical disk (such as a CD-ROM, DVD-ROM, or other optical medium) and writing to a removable non-volatile optical disk may be provided. In these cases, each may be connected to bus 6018 via one or more data medium interfaces. As will be further depicted and described below, memory 6028 may include at least one program product having a set (eg, at least one) of program modules configured to perform the functions of embodiments of the present disclosure.

[0142] By way of example and not limitation, a program / utility 6040 having a set (at least one) of program modules 6042 and an operating system, one or more application programs, other program modules, and program data may be stored in memory 6028. Each of the operating system, one or more application programs, other program modules, and program data, or some combination thereof, may include an implementation of a network environment. Program modules 6042 generally perform functions and / or methods as described herein in the embodiments.

[0143] The computer system / server 6012 may also communicate with one or more external devices 6014 (such as a keyboard, pointing device, display 6024, etc.), one or more devices that enable a user to interact with the computer system / server 6012, and / or any device that enables the computer system / server 6012 to communicate with one or more other computing devices (e.g., a network card, a modem, etc.). Such communication may occur via an input / output (I / O) interface 22. Also, the computer system / server 6012 may communicate with one or more networks (such as a local area network (LAN), a general wide area network (WAN), and / or a public network (e.g., the Internet)) via a network adapter 20. As depicted, the network adapter 20 communicates with other components of the computer system / server 6012 via a bus 6018. It should be understood that, although not shown, other hardware and / or software components may be used in conjunction with the computer system / server 6012. Examples include, but are not limited to, microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data archival storage systems, etc.

[0144] The present disclosure may be implemented as a system, method, and / or computer program product. The computer program product may include (one or more) computer-readable storage media having computer-readable program instructions thereon for causing a processor to execute aspects of the present disclosure.

[0145] Computer readable storage medium can be a tangible device that can keep and store instructions for being used by instruction execution device.Computer readable storage medium can be, for example, (but not limited to) electronic storage device, magnetic storage device, optical storage device, electromagnetic storage device, semiconductor storage device or any suitable combination of the above.The non-exhaustive list of more specific examples of computer readable storage medium includes the following: portable computer disk, hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), static random access memory (SRAM), portable compact disk read-only memory (CD-ROM), digital versatile disk (DVD), memory stick, floppy disk, mechanical encoding device (such as punch card or convex structure in groove with instruction stored thereon) and any suitable combination of the above.Computer readable storage medium as used herein is not interpreted as instantaneous signal itself, such as radio wave or other free propagating electromagnetic wave, electromagnetic wave propagated by waveguide or other transmission medium (for example, light pulse by optical fiber cable) or electrical signal transmitted by wire.

[0146] The computer-readable program instructions described herein can be downloaded from a computer-readable storage medium to each computing / processing device, or downloaded to an external computer or external storage device via a network (e.g., the Internet, a local area network, a wide area network, and / or a wireless network). The network can include copper transmission cables, optical fiber transmissions, wireless transmissions, routers, firewalls, switches, gateway computers, and / or edge servers. The network adapter card or network interface in each computing / processing device receives the computer-readable program instructions from the network and forwards these computer-readable program instructions for storage in the computer-readable storage medium in each computing / processing device.

[0147] The computer-readable program instructions for performing the operation of the present disclosure may be assembly instructions, instruction set architecture (ISA) instructions, machine instructions, machine-dependent instructions, microcode, firmware instructions, state setting data, or source code or object code written in any combination of one or more programming languages, including object-oriented programming languages ​​(such as Smalltalk, C++, etc.) and conventional procedural programming languages ​​(such as "C" programming languages ​​or similar programming languages). The computer-readable program instructions may be executed completely on the user's computer, partially on the user's computer, executed as an independent software package, partially on the user's computer, partially on a remote computer, or completely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer via any type of network (including a local area network (LAN) or a wide area network (WAN)), or may be connected to an external computer (such as using an Internet service provider via the Internet). In some embodiments, an electronic circuit may be customized by utilizing the state information of a computer-readable program instruction, including, for example, a programmable logic circuit, a field programmable gate array (FPGA), or a programmable logic array (PLA), and the electronic circuit may execute a computer-readable program instruction to perform aspects of the present disclosure.

[0148] Aspects of the present disclosure are described herein with reference to flowcharts and / or block diagrams of methods, devices (systems) and computer program products according to embodiments of the present disclosure. It will be understood that each box in the flowchart and / or block diagram and the combination of boxes in the flowchart and / or block diagram can be implemented by computer-readable program instructions.

[0149] These computer-readable program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device to produce a machine, so that when these instructions are executed by the processor of the computer or other programmable data processing device, a device that implements the functions / behaviors specified in one or more boxes in the flowchart and / or block diagram is generated. These computer-readable program instructions can also be stored in a computer-readable storage medium, and these computer-readable program instructions can guide the computer, programmable data processing device, and / or other equipment to work in a specific manner, so that the computer-readable medium in which the instructions are stored includes a manufactured product, which includes instructions for implementing aspects of the functions / behaviors specified in one or more boxes in the flowchart and / or block diagram.

[0150] Computer-readable program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other device, so that a series of operating steps are performed on the computer, other programmable apparatus, or other device to produce a computer-implemented process, so that the instructions executed on the computer, other programmable apparatus, or other device implement the functions / behaviors specified in one or more boxes in the flowchart and / or block diagram.

[0151] The flow chart and block diagram in the figure show the possible architecture, function and operation of the system, method and computer program product according to each embodiment of the present disclosure. In this regard, each box in the flow chart or block diagram can represent a part of a module, segment or instruction, and a part of the module, segment or instruction contains one or more executable instructions for realizing the specified (one or more) logical functions. In some alternative implementations, the functions marked in the box can also occur in an order different from that marked in the figure. For example, depending on the functions involved, two continuous boxes can actually be executed substantially in parallel, or these boxes can sometimes be executed in the opposite order. It will also be noted that each box in the block diagram and / or flow chart, and the combination of the boxes in the block diagram and / or flow chart can be implemented by a system based on special hardware that performs a specified function or behavior or performs a combination of special hardware and computer instructions.

[0152] Those skilled in the art should also understand that the various operations illustrated in order in the embodiments of the present disclosure are not necessarily performed in the illustrated order. Those skilled in the art can adjust the order of operations as needed. Those skilled in the art can also add more operations or omit some of the operations as needed.

[0153] The description of various embodiments of the present disclosure has been given for the purpose of illustration, but is not intended to be exhaustive or limited to the disclosed embodiments. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the described embodiments. The terms used herein are selected to best explain the principles of the embodiments, practical applications, or technical improvements over technologies found in the marketplace, or to enable other persons of ordinary skill in the art to understand the embodiments disclosed herein.

Claims

1. A method for managing product sales costs, comprising: Uploading a configured offline Excel template to generate an online workbench form, wherein the generated online workbench form includes the same header row configuration as the uploaded offline Excel template, the offline Excel template is configured based on a policy published for a class of dealers, and at least one of the one or more columns in the header row of the offline Excel template is associated with a performance calculation rule for the class of dealers; and Data associated with one or more columns in a header row of the online workbench form is read from one or more external data systems and at least some of the one or more columns in the header row of the online workbench form are automatically populated.

2. The method of claim 1, further comprising: Receive the policies published for a class of dealers; and The offline Excel template is automatically generated based on the published policy.

3. The method of claim 1, further comprising: Data associated with one or more columns in a header row of the offline Excel template is read from one or more external data systems, and at least some of the one or more columns in the header row of the offline Excel template are automatically populated.

4. The method of claim 1, further comprising: receiving a user's edit of at least one column in a header row of the generated online workbench form and generating a new online workbench form; Save the new online workbench form that is generated.

5. The method of claim 1, wherein: The external data system includes at least one of the following: Dealer sales target management system; Product sales incentive policy configuration system; Sales data management system; User rights management system; and Dealer assessment management system.

6. The method of claim 1, wherein: The header row of the online workbench form includes at least the following columns: A dealer basic information column, including at least one of a dealer name column, a dealer number column, and a dealer region column; Performance calculation result column, used to output automatically calculated performance results; and The Performance Calculation Factor column is used to enter the data items on which the performance calculation is based. For the performance calculation result column, the calculation rules for calculating the performance results based on the data items in the performance calculation factor column are defined according to the published policies.

7. The method of claim 6, further comprising: receiving a user's edit of data of at least some columns of the performance calculation factor columns; and In response to receiving the user's editing of the data of at least some columns in the performance calculation factor column, the corresponding performance calculation results are automatically output in the performance calculation result column.

8. The method of claim 1, wherein: The published policy for a class of dealers includes at least one of the following information: The policy number associated with the published policy; Indicate applicable information for such dealers; Information indicating the period of applicability of the published policy; The executable compute policy number associated with the published policy; The computation rules of the executable computation policy associated with the published policy.

9. The method of claim 8, further comprising: Read the executable computing policy number included in the published policy; Find the corresponding performance calculation rule from the database based on the executable calculation policy number; and Based on the found calculation rules, the columns in the header row of the Excel template that are associated with the performance calculation rules for the type of dealers are configured.

10. A computer system comprising: one or more processors; and A memory coupled to the one or more processors, the memory storing computer-readable program instructions, which, when executed by the one or more processors, perform the method of any one of claims 1-9.

11. A computer-readable storage medium storing computer-readable program instructions, wherein the instructions, when executed by a processor, perform the method according to any one of claims 1 to 9.