Systems and methods for making margin-sensitive price adjustments in an integrated price management system
The present invention presents systems and methods for forecasting data in an integrated price management system including providing forward looking price estimations for products in a selected product set for a selected time interval; calculating total prices for selected product sets for each selected time interval; calculating margins for each selected time interval based on total prices and cost estimates; displaying prices for selected product sets for each selected time interval; and displaying margins for selected product sets for each selected time interval.
1 . A method of providing forecast data in an integrated price adjustment system comprising:
providing at least one forward looking price estimation for at least one product in a selected product set for a selected time interval;
calculating a total price for the selected product set for each selected time interval;
calculating at least one margin for each selected time interval based on the total price and a cost estimate;
displaying the price for the selected product set for each selected time interval; and
displaying the at least one margin for the selected product set for each selected time interval.
2 . The method of claim 1 , wherein the product set corresponds to a single shop keeping unit (SKU) that uniquely represents a product in a catalog of products.
3 . The method of claim 1 wherein the at least one forward looking price estimation for the at least one product in a selected product set is based on historical performance of a similar product.
4 . The method of claim 3 wherein the historical performance is calculated using standard statistical methodology.
5 . The method of claim 1 wherein the selected time interval is at least one month.
6 . The method of claim 1 wherein displaying the price for the selected product set for each selected time interval comprises:
where there is a rise in price between two consecutive time intervals, visually depicting the later time interval price in a first color;
where there is a fall in price between two consecutive time intervals, visually depicting the later time interval price in a second color; and
where price is the same between two consecutive time intervals, visually depicting the later time interval price in a third color.
7 . The method of claim 1 wherein the margin is an apparent margin.
8 . The method of claim 1 wherein six time intervals representing each of six months is concurrently displayed.
9 . The method of claim 1 wherein time intervals which have passed in time are not displayed, but are persistent in memory.
10 . A computer program product for use in conjunction with a computer system for providing forecast data in an integrated price adjustment system, the computer program product comprising a computer readable storage medium and a computer program mechanism embedded therein, the computer program mechanism comprising:
at least one forward looking price estimation module for at least one product in a selected product set for a selected time interval;
instructions for calculating a total price for the selected product set for each selected time interval;
instructions for calculating at least one margin for each selected time interval based on the total price and a cost estimate;
instructions for displaying the price for the selected product set for each selected time interval; and
instructions for displaying the at least one margin for the selected product set for each selected time interval.
11 . The computer program product of claim 10 , wherein the product set corresponds to a single shop keeping unit (SKU) that uniquely represents a product in a catalog of products.
12 . The computer program product of claim 10 wherein the at least one forward looking price estimation for the at least one product in a selected product set is based on historical performance of a similar product.
13 . The computer program product of claim 12 wherein the historical performance is calculated using standard statistical methodology.
14 . The computer program product of claim 10 wherein the selected time interval is at least one month.
15 . The computer program product of claim 10 wherein displaying the price for the selected product set for each selected time interval comprises:
where there is a rise in price between two consecutive time intervals, visually depicting the later time interval price in a first color;
where there is a fall in price between two consecutive time intervals, visually depicting the later time interval price in a second color; and
where price is the same between two consecutive time intervals, visually depicting the later time interval price in a third color.
16 . The computer program product of claim 10 wherein the margin is an apparent margin.
17 . The computer program product of claim 10 wherein six time intervals representing each of six months is concurrently displayed.
18 . The computer program product of claim 10 wherein time intervals which have passed in time are not displayed, but are persistent in memory.
19 . A system of providing forecast data in an integrated price adjustment system comprising:
at least one forward looking price estimation module for at least one product in a selected product set for a selected time interval;
a calculated total price for the selected product set for each selected time interval;
a calculated at least one margin for each selected time interval based on the total price and a cost estimate;
a display for displaying the price for the selected product set for each selected time interval; and
a display for displaying the at least one margin for the selected product set for each selected time interval.