Retail planning application and method for consumer products
View Patent ↗An improved forecasting and modeling tool for planning and estimating sales of consumer products, including social expression products in a retail operation. The tool enables retailers to create a plan based on information shared between the retailer and vendor of social expression products. The methodology employed begins with actual sales totals for the prior term and the plan goal for the current term and provides financial calculations based on a variety of factors to determine the sales bridge needed to meet the current term goal. Information relating to actual sales, significant events, door activity, current forecast, trending data, and vendor initiatives are input into the application and are used in financial calculations to determine a current term sales plan.
1. A retail planning and forecasting tool comprising:
a computer with a processor having circuitry to execute instructions;
a computer-readable storage medium having executable computer code stored thereon, the computer code operative to use the processor to determine a current term sales bridge by executing the following steps:
accept and store data representing a value equal to a total previous term sales dollars;
accept and store financial data affecting the total previous term sales dollars; and
calculate a current term adjusted financial baseline by subtracting the financial data affecting the total previous term sales dollars from the total previous term sales dollars;
accept and store financial data affecting the current term adjusted financial baseline;
calculate a value equal to a total current term estimated sales by adding the financial data affecting the current term baseline to the current term adjusted financial baseline;
accept and store a value equal to a current term sales goal; and
calculate the current term sales bridge by subtracting the current term estimated sales from the current term sales goal.
2. The retail planning and forecasting tool of claim 1 , further comprising a graphical user interface which is operative to accept user-entered information.
3. The retail planning and forecasting tool of claim 2 , wherein the user-entered information is data which is manually entered into the computer via a keyboard and/or data contained in one or more data files which is uploaded to the computer.
4. The retail planning and forecasting tool of claim 2 , wherein the graphical user interface is operative to visually display user-entered and program-generated data.
5. The retail planning and forecasting tool of claim 4 , wherein the visual display of user-entered and program-generated data includes charts and graphs.
6. The retail planning and forecasting tool of claim 3 , wherein program-generated data is re-calculated each time the user-entered data is changed.
7. The retail planning and forecasting tool of claim 1 , wherein the financial data affecting the total previous term sales dollars and the current term adjusted financial baseline are door activity, significant events and sales of seasonal non-card merchandise.