Automated control of pricing using markdown profiles

• US 7,822,692 B2
• Filed: 06/21/2004
• Issued: 10/26/2010
• Est. Priority Date: 03/08/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Zuerl, Ruediger, Fotteler, Christine
• Primary Examiner(s): Hayes; John W
• Assistant Examiner(s): NELSON, FREDA ANN
• Application Number:
  US10/872,816
• Publication Number:
  US 20050194439A1
• Time in Patent Office: 2,318 Days
• Field of Search: 705/1, 705/400, 705/10, 705 26- 27, 705/28, 705/1.1, 705/8, 705/36, 707/102, 706/12
• US Class Current: 705/400
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/0202 Market predictions or forecasting for commercial activities
• CPC Class Codes: G06Q 30/0235 constrained by time limit or expiration date
• CPC Class Codes: G06Q 30/0283 Price estimation or determination
• CPC Class Codes: G06Q 30/0633 Lists, e.g. purchase orders, compilation or processing

Abstract

A method, program product and system for controlling pricing for sale of a product, where the method includes: selecting a markdown profile to be used for the product; selecting a retail price for the product; acquiring updated sales data regarding the product; and determining a markdown to be applied to the retail price from the markdown profile using the updated sales data. The method can further include the step of adjusting a retail price of the product by the markdown. The method, program product, and system may also provide a data structure for implementing a markdown profile by determining retail price adjustments for a product, where the data structure includes: an actual sales quota parameter; a posting period parameter arranged perpendicular to the actual sales quota parameter; and a plurality of data fields containing markdowns, each data field corresponding to a specific posting period and actual sales quota range and each markdown relating to an amount of adjustment of a retail price for the product.

Claims

1. Non-transitory machine-readable media for controlling pricing for sale of a product using an automated process, the non-transitory machine-readable media comprising program code stored therein executable by one or more machines to perform the automated process, the automated process comprising:

selecting a markdown profile to be used for the product;

selecting a retail price for the product;

determining a target sales quota for the product;

acquiring by a program module sales data regarding the product;

comparing by the program module the sales data to the target sales quota;

determining by the program module a best seller based on a sales data to target sales quota comparison;

determining by the program module that the product is within a product lifecycle;

when the product is within the product lifecycle, acquiring by the program module updated sales data regarding the product;

determining by the program module whether the product is still the best seller based on an updated sales data to target sales quota comparison;

when the product is not within the product lifecycle, ending the automated process;

storing at least one of a determination that the product is the best seller and data related to ending the automated process;

wherein the best seller determination is based on at least one of a sales data to target sales quota comparison and an updated sales data to target sales quota comparison.

2. The machine-readable media for controlling pricing for sale of a product according to claim 1, wherein the determination of the best seller is further based on the actual sales data exceeding the targeted sales by a predetermined amount.

3. The machine-readable media for controlling pricing for sale of a product according to claim 1, wherein the determination of the best seller is further based on the actual sales data exceeding the targeted sales by a predetermined percentage.

4. The machine-readable media for controlling pricing for sale of a product according to claim 1, further comprising determining by the program module a slow seller based on the updated sales data to sales plan comparison and determining by the program module a markdown to be applied to the product from the markdown profile based on the updated sales data to sales plan comparison.

5. The machine-readable media for controlling pricing for sale of a product according to claim 4, further comprising adjusting by the program module the retail price of the product by the markdown.

6. The machine-readable media for controlling pricing for sale of a product according to claim 5, wherein the markdown is expressed as a buying incentive.

7. The machine-readable media for controlling pricing for sale of a product according to claim 6, wherein the buying incentive is a volume discount.

8. The machine-readable media for controlling pricing for sale of a product according to claim 1, wherein the markdown profile comprises:

an actual sales quota parameter comprising a plurality of actual sales quota ranges;

a posting period parameter arranged perpendicular to the actual sales quota parameter comprising a plurality of posting periods; and

a plurality of data fields containing markdowns, each data field corresponding to a specific posting period and actual sales quota range and each markdown relating to an amount of adjustment of the retail price for the product.

9. The machine-readable media for controlling pricing for sale of a product according to claim 1, wherein the determining that the product is within the product lifecycle step is performed automatically at regular intervals.

10. The machine-readable media for controlling pricing for sale of a product according to claim 9, wherein the determining that the product is within the product lifecycle step is performed after a posting period for the sale of the product.

11. A system for controlling pricing for sale of a product using an automated process, comprising:

means for selecting a markdown profile to be used for the product;

means for selecting a retail price for the product;

means for determining a target sales quota for the product;

means for acquiring sales data regarding the product;

means for comparing the sales data to the target sales quota;

means for determining a best seller based on a sales data to target sales quota comparison;

means for determining that the product is within a product lifecycle;

when the product is within the product lifecycle, acquiring updated sales data regarding the product;

means for determining whether the product is still the best seller based on an updated sales data to target sales quota comparison;

when the product is not within the product lifecycle, ending the automated process;

means for storing at least one of a determination that the product is the best seller and data related to ending the automated process;

wherein the best seller determination is based on at least one of a sales data to target sales quota comparison and an updated sales data to target sales quota comparison.

12. The system according to claim 11, wherein the determination of the best seller is further based on the actual sales data exceeding the targeted sales by a predetermined amount.

13. The system according to claim 11, wherein the determination of the best seller is further based on the actual sales data exceeding the targeted sales by a predetermined percentage.

14. The system according to claim 11, further comprising means for determining a slow seller based on the updated sales data to sales plan comparison and means for determining a markdown to be applied to the product or service from the markdown profile based on the updated sales data to sales plan comparison.

15. The system according to claim 14, further comprising means for adjusting the retail price of the product by the markdown.

16. The system according to claim 15, wherein the markdown is expressed as a buying incentive.

17. The system according to claim 16, wherein the buying incentive is a volume discount.

18. The system according to claim 11, wherein the markdown profile comprises:

an actual sales quota parameter comprising a plurality of actual sales quota ranges;

a posting period parameter arranged perpendicular to the actual sales quota parameter comprising a plurality of posting periods; and

a plurality of data fields containing markdowns, each data field corresponding to a specific posting period and actual sales quota range and each markdown relating to an amount of adjustment of the retail price for the product.

19. The system according to claim 11, wherein the determining that the product is within the product lifecycle step is performed automatically at regular intervals.

20. The system according to claim 19, wherein the determining that the product is within the product lifecycle step is performed after a posting period for the sale of the product.

21. Non-transitory machine-readable media for controlling pricing for sale of a product using an automated process, the non-transitory machine-readable media comprising program code stored therein executable by one or more machines to perform the automated process, the automated process comprising:

selecting a first markdown profile to be used for a first product;

selecting a second markdown profile to be used for a second product selecting a first retail price for the first product;

selecting a second retail price for the second product;

determining a first target sales quota for the first product;

determining a second target sales quota for the second product;

acquiring by a program module first sales data regarding the first product;

acquiring by the program module second sales data regarding the second product comparing by the program module the first sales data to the first target sales quota;

comparing by the program module the second sales data to the second target sales quota;

determining by the program module a slow seller based on comparing the first sales data to the first target sales quota;

determining by the program module a best seller based on comparing the second sales data to the second target sales quota;

determining by the program module that the first product is within a first product lifecycle;

determining by the program module that the second product is within a second product lifecycle;

when the first product is within the first product lifecycle, acquiring by the program module a first product updated sales data;

when the second product is within the second product lifecycle, acquiring by the program module a second product updated sales data;

determining by the program module whether the first product is still the slow seller based on comparing the first product updated sales data to the first target sales quota;

determining by the program module whether the second product is still the best seller based on comparing the second product updated sales data to the second target sales quota;

when the first product is not within the first product lifecycle, ending a first portion of the automated process relating to the first product;

when the second product is not within the second product lifecycle, ending a second portion of the automated process relating to the second product;

storing at least one of a determination that the first product is the slow seller, the second product is the best seller and data related to ending the first portion of the automated process, and data related to ending the second portion of the automated process;

wherein the best seller determination is based on at least one of a second sales data to second target sales quota comparison and a second product updated sales data to second target sales quota comparison;

wherein the slow seller determination is based on a first sales data to first target sales quota comparison and a first product updated sales data to first target sales quota comparison.

22. The machine-readable media of claim 21, further determining by the program module an exception to the first sales plan based on the first updated sales data.

23. The machine-readable media of claim 22, further comprising determining by the program module a markdown to be applied to the first retail price from the markdown profile using at least one of the exception and the first updated sales data.

24. The machine-readable media of claim 23, further comprising the step of adjusting by the program module the first retail price by the markdown.

25. The machine-readable media of claim 24, wherein the markdown is expressed as a percentage discount.

26. The machine-readable media of claim 25, wherein the markdown profile comprises a plurality of markdown percentages relating to an amount of adjustment of the first retail price.