US5491629A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for determining the impact of weather and other factors on managerial planning applications
Assignee: Planalytics Inc
•
Filing: 1994-03-04
•
Granted: 1996-02-13
•
Expires: 2014-03-04
Abstract
Abstract A computer-based Executive Information System (EIS) system for determining the impact of weather and other external and internal factors on the retail industry. Utilizing a multiple regression correlation technique in a predictive model, a correlation of weather variables with store information for specific locations and times is performed to quantify a weather impact model in terms of unit or dollar sales volume change, or any other commercially useful benchmark. The EIS system determines these relationships with location and time specificity. Using the relationship between historical weather and historical sales, the EIS system "deweatherizes" the historical weather to create a normalized historical sales relative to weather based upon normal weather (the 30 year average). This deweatherized data may be used in conjunction with a user-provided managerial plan to produce a revised managerial plan. Alternatively, the revised plan can be "weatherized" by the EIS system by applying forecasted weather to the weather impact model to generate a weather-modified managerial plan.
Inventors
- 👤 Frederick D. Fox
- 👤 Douglas R. Pearson
- 👤 Mike A. Rhoads
- 👤 Peter A. Zaleski
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 06:10
CPC Classifications
G; G06; G06Q; G06Q10/00; G06Q10/06
Claims Analysis
Total Claims: 38
Claim 1
Independent Claim
162 words
A computer-based system for generating a weather-modified managerial plan that represents the future impact of weather and other factors on retail sales, comprising: first means for providing store information; second means for providing weather data, said weather data including, historical weather data, normal weather data, and forecasted weather data; third means for providing information external to retailer store environment; database initializer means for performing one or more transformations of said store information, said weather data, and said external information to produce databases; correlation processor means for generating a weather impact model, said weather impact model expressing a correlation between said store information and said external information contained within said databases with said historical weather data, and for substituting said normal weather data for said historical weather data in said weather impact model to generate deweatherized data; and forecasting processor means for substituting said forecasted weather data for said normal weather data in said weather impact model to produce a weather-modified managerial plan.
Claim 2
Dependent Claim
162 words
A computer-based system for generating a weather-modified managerial plan that represents the future impact of weather and other factors on retail sales, comprising: first means for providing store information; second means for providing weather data, said weather data including, historical weather data, normal weather data, and forecasted weather data; third means for providing information external to retailer store environment; database initializer means for performing one or more transformations of said store information, said weather data, and said external information to produce databases; correlation processor means for generating a weather impact model, said weather impact model expressing a correlation between said store information and said external information contained within said databases with said historical weather data, and for substituting said normal weather data for said historical weather data in said weather impact model to generate deweatherized data; and forecasting processor means for substituting said forecasted weather data for said normal weather data in said weather impact model to produce a weather-modified managerial plan.
Claim 3
Dependent Claim
31 words
The system of claim 1, wherein said deweatherized data is made available to a retailer to modify one or more portions of said managerial plan, resulting in a revised managerial plan.
Claim 4
Dependent Claim
32 words
The system of claim 2, wherein said substitution of said forecasted weather data in said weather impact model for said normal weather data is performed in conjunction with said revised managerial plan.
Claim 5
Dependent Claim
26 words
The system of claim 1, wherein said normal weather data comprises a 30 year average of a particular weather parameter for a specific location and time.
Claim 6
Dependent Claim
42 words
The system of claim 1, wherein said store information comprising point of sale data generated at one or more store locations and other store data, said other store data comprising any user specified recordable event taking place in support of consumer sales.
Claim 7
Dependent Claim
25 words
The system of claim 5, wherein said other store data comprises inventory transfer from distribution center to store, promotion data, store traffic, and labor data.
Claim 8
Dependent Claim
25 words
The system of claim 5, wherein said point of sale data is generated by electronic scanners, registers, and other electronic scanning and data gathering devices.
Claim 9
Dependent Claim
21 words
The system of claim 5, wherein said point of sale data includes product data, POS receipt data, promotional data, markdown data.
Claim 10
Dependent Claim
15 words
The system of claim 1, wherein the system is resident within a computer-based MIS architecture.
Claim 11
Dependent Claim
26 words
The system of claim 9, wherein said MIS architecture includes a data storage and retrieval facility configured to store said external information and said internal information.
Claim 12
Dependent Claim
23 words
The system of claim 1, wherein said external information comprises economic, demographic, competitive, or any other retailer-specified information valuable to assessing business performance.
Claim 13
Dependent Claim
17 words
The system of claim 1, wherein said weather data is measured in any user defined time increment.
Claim 14
Dependent Claim
13 words
The system of claim 12, wherein said time increment comprises daily time increments.
Claim 15
Dependent Claim
13 words
The system of claim 12, wherein said time increment comprises weekly time increments.
Claim 16
Dependent Claim
13 words
The system of claim 12, wherein said time increment comprises monthly time increments.
Claim 17
Dependent Claim
29 words
The system of claim 1, wherein said database initializer maps store locations to selected areas, thereby utilizing only necessary portions of said weather data associated with said selected areas.
Claim 18
Dependent Claim
23 words
The system of claim 1, wherein said database initializer creates retailer hierarchial structure tables, said retailer hierarchial structural tables indicating retailer-specified parent-child relationships.
Claim 19
Dependent Claim
13 words
The system of claim 1, wherein said weather data comprises any meteorological factor.
Claim 20
Dependent Claim
13 words
The system of claim 18, wherein said meteorological factors include temperature, precipitation, humidity.
Claim 21
Dependent Claim
29 words
The system of claim 1, wherein said managerial plan comprises buying product, distributing product to specific locations, advertising, promotions, financial budgeting, historical analysis, labor scheduling, and store traffic analysis.
Claim 22
Dependent Claim
18 words
The system of claim 1, wherein said forecasted weather data is in user-determined time increments for user-determined locations.
Claim 23
Dependent Claim
31 words
The system of claim 1, wherein said substitution of said forecasted weather data in said weather impact model for said normal weather data is performed in conjunction with said managerial plan.
Claim 24
Dependent Claim
31 words
The system of claim 1, wherein said substitution of said forecasted weather data in said weather impact model for said normal weather data is performed in conjunction with said deweatherization data.
Claim 25
Dependent Claim
27 words
The system of claim 1, further comprising a data manipulator means, coupled between said first means and said database initializer means, for aggregating said store transaction data.
Claim 26
Dependent Claim
50 words
The system of claim 1, wherein said first means comprises: data gathering means for recording said store transaction data; and a data storage and retrieval facility configured to receive said store transaction data from said data gathering means, and configured to store said store transaction data in a computer-readable format.
Claim 27
Dependent Claim
29 words
The system of claim 1, wherein said database initializer means transforms an aggregate of said store transaction data to a form that adds value to said correlation processor means.
Claim 28
Dependent Claim
103 words
The system of claim 26, wherein said database initializer means comprises: comparing means for comparing a first set of values occurring during a first interval in a first period with a second set of values occurring in a second interval in a second period, and for computing the change in said first and second sets of values, wherein said first and second intervals are equal to a first length of time and said first and second periods are equal to a second length of time, and wherein said first length of time is less than or equal to said second length of time.
Claim 29
Dependent Claim
14 words
The system of claim 27, wherein said first length of time is a week.
Claim 30
Dependent Claim
14 words
The system of claim 28, wherein said second length of time is a year.
Claim 31
Dependent Claim
14 words
The system of claim 27, wherein said first length of time is a day.
Claim 32
Dependent Claim
14 words
The system of claim 30, wherein said second length of time is a year.
Claim 33
Dependent Claim
35 words
The system of claim 27, wherein said database initializer means further comprises: lagging means for lagging said logged values of said historical weather data by a third interval, a fourth interval, and a fifth interval.
Claim 34
Dependent Claim
28 words
The system of claim 1, wherein said correlation processor means is configured to perform a least squares multiple regression on said databases to produce said weather impact model.
Claim 35
Dependent Claim
27 words
The system of claim 33, wherein said weather impact model expresses a correlation between said store transaction data contained in said databases and said historical weather data.
Claim 36
Dependent Claim
34 words
The system of claim 1, further comprising a graphical user interface for receiving said weather-modified managerial plan from said application processor means and for displaying said weather modified managerial plan in a user-specified manner.
Claim 37
Dependent Claim
184 words
A computer-based system for generating a weather-modified managerial plan that represents the future impact of weather and other factors on retail sales, comprising: first means for providing store information; second means for providing weather data, said weather data including, historical weather data, normal weather data, and forecasted weather data; third means for providing external information; database initializer means for performing one or more transformations of said store information, said weather data, and said external information to produce databases, wherein said database initializer maps store locations to selected areas, said database initializer means utilizing only portions of said weather data associated with said selected areas; correlation processor means for generating a weather impact model, said weather impact model expressing a correlation between said store information and said external information contained within said databases with said historical weather data, and for substituting said normal weather data for said historical weather data in said weather impact model to generate deweatherized data; and forecasting processor means for substituting said forecasted weather data for said normal weather data in said weather impact model to produce a weather-modified managerial plan.
Claim 38
Dependent Claim
184 words
A computer-based system for generating a weather-modified managerial plan that represents the future impact of weather and other factors on retail sales, comprising: first means for providing store information; second means for providing weather data, said weather data including, historical weather data, normal weather data, and forecasted weather data; third means for providing external information; database initializer means for performing one or more transformations of said store information, said weather data, and said external information to produce databases, wherein said database initializer maps store locations to selected areas, said database initializer means utilizing only portions of said weather data associated with said selected areas; correlation processor means for generating a weather impact model, said weather impact model expressing a correlation between said store information and said external information contained within said databases with said historical weather data, and for substituting said normal weather data for said historical weather data in said weather impact model to generate deweatherized data; and forecasting processor means for substituting said forecasted weather data for said normal weather data in said weather impact model to produce a weather-modified managerial plan.
References Cited (Backward Citations)
JPH04135271A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-02-12 | 1999-08-14 | 2000-02-13 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-02-12 | 2003-08-14 | 2004-02-13 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-02-12 | 2007-08-14 | 2008-02-13 | $7700.00 | Window Closed / Lapsed |