Method of and system for generating feasible, profit maximizing requisition sets
First Claim
1. In a computer, a method of and system for generating feasible, profit maximizing requisition sets for products purchased under a variety of discount regimes, the method comprising the steps of:
- a) specifying by user input to said computer the type of analysis to be run, the controlling forecast, target customer service levels, minimum capital levels and the primary source of historical transaction, forecast element specification and current balance information, user input, electronic files or a basic financial system database,b) specifying by user input to said computer a plurality of templates and data definitions for use in extracting, converting and storing data from the primary source,c) extracting, converting and storing the source data in the application database of the present system in a format suitable for use in the present system,d) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to the extracted source data to create, display and store forecasts of sales by account, sales by customer group, sales by item, cash receipts by account as a function of sales by account and cash receipts by customer group as a function of sales by customer group,e) generating and storing a variable with each forecast element that is calculated in accordance with system default or user specified weighting criteria that facilitates forecast synchronization and obsolescence risk reduction,f.) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to the forecasts of sales by account, sales by customer group and sales by item, cash receipts by account and cash receipts by customer group to create and store a multivalent composite forecast of sales and of cash receipts,g) using the stored variable for each forecast element to prioritize and quantify the adjustments made to each forecast element in the sales by account, sales by customer group, sales by item, cash receipt by account and cash receipt by customer group forecasts as they are adjusted to exactly match the controlling forecast designated by the user,h) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to said sales by item forecast and item balance information to create a set of preliminary requisitions for all items that satisfy forecast demand with current vendors and units of measure while maintaining user specified service level targets,i) calculating the profit maximizing requisition set for all items under a variety of discount regimes within the constraints on vendor and unit of measure substitution established by the user,j) applying a set of prescribed mathematical algorithms as implemented by a computer program stored in the computer system, to account history information and said forecast of sales by account to create a forecast of expenses by account as well as a balance sheet account balance forecast for use in a financial forecast,k) creating and displaying a financial forecast on the computer system in the format specified by the user,l) determining if the forecast financial situation of the commercial enterprise provides for sufficient funds to purchase the profit maximizing set of requisitions (steps a-p are repeated until this condition is satisfied),m) calculating potential profit enhancing requisition sets for specific items under a variety of discount regimes, within the forecast financial constraints after relaxing user specified restrictions on global vendor and unit of measure substitution,n) creating and then displaying on the computer system a listing of the potential profit enhancing changes to the profit maximizing requisition set listed in descending capital efficiency order,o) specifying by user input to said computer the specific profit enhancing changes that are to be included in the profit maximizing requisition set,p) displaying on the computer system a report that summarizes the final profit maximizing requisition set and the forecast inventory status, andq) optionally printing financial management and requisition summary reports.
5 Assignments
0 Petitions
Accused Products
Abstract
In a computer based inventory control method and system, feasible profit maximizing sets of requisitions are created. System processing starts with the creation of detailed, multi-dimensional forecasts of sales and cash receipts using stored algorithms and data preferentially extracted from a basic financial system and the adjustment of the forecasts to match the controlling forecast specified by the user. The adjustment of the forecasts is facilitated by the use of a calculated variable that defines the magnitude of the relative adjustment for each forecast element. All forecasts are adjusted to exactly match a controlling forecast which is either a multivalent combination of the previously generated forecasts or the user specified controlling forecast. The adjusted forecast of sales by item is then used in calculating a requisition set that satisfies expected demand while meeting user specified service level targets. A profit maximized requisition set is then created that utilizes vendor and unit of measure substitution under a variety of discount schedules to the extent possible within the user specified constraints. The processing completed by the system to determine the profit maximizing requisition set utilizes multi-objective, mixed-integer, linear programming techniques. A financial forecast is then calculated and displayed to determine if purchasing the profit maximizing requisition set will be feasible under the forecast financial conditions. Once the constraints and/or forecasts are adjusted as required to produce a feasible solution, processing advances to the profit enhancement stage where overall financial constraints are established and user specified constraints on commitment percentages, global unit of measure substitution and global vendor substitution are optionally relaxed and profit enhancing changes are calculated, stored and displayed. The user optionally accepts displayed enhancements and the financial forecast is recalculated to demonstrate the impact of the accepted changes before the requisitions are modified to reflect the accepted enhancements.
-
Citations
10 Claims
-
1. In a computer, a method of and system for generating feasible, profit maximizing requisition sets for products purchased under a variety of discount regimes, the method comprising the steps of:
-
a) specifying by user input to said computer the type of analysis to be run, the controlling forecast, target customer service levels, minimum capital levels and the primary source of historical transaction, forecast element specification and current balance information, user input, electronic files or a basic financial system database, b) specifying by user input to said computer a plurality of templates and data definitions for use in extracting, converting and storing data from the primary source, c) extracting, converting and storing the source data in the application database of the present system in a format suitable for use in the present system, d) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to the extracted source data to create, display and store forecasts of sales by account, sales by customer group, sales by item, cash receipts by account as a function of sales by account and cash receipts by customer group as a function of sales by customer group, e) generating and storing a variable with each forecast element that is calculated in accordance with system default or user specified weighting criteria that facilitates forecast synchronization and obsolescence risk reduction, f.) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to the forecasts of sales by account, sales by customer group and sales by item, cash receipts by account and cash receipts by customer group to create and store a multivalent composite forecast of sales and of cash receipts, g) using the stored variable for each forecast element to prioritize and quantify the adjustments made to each forecast element in the sales by account, sales by customer group, sales by item, cash receipt by account and cash receipt by customer group forecasts as they are adjusted to exactly match the controlling forecast designated by the user, h) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to said sales by item forecast and item balance information to create a set of preliminary requisitions for all items that satisfy forecast demand with current vendors and units of measure while maintaining user specified service level targets, i) calculating the profit maximizing requisition set for all items under a variety of discount regimes within the constraints on vendor and unit of measure substitution established by the user, j) applying a set of prescribed mathematical algorithms as implemented by a computer program stored in the computer system, to account history information and said forecast of sales by account to create a forecast of expenses by account as well as a balance sheet account balance forecast for use in a financial forecast, k) creating and displaying a financial forecast on the computer system in the format specified by the user, l) determining if the forecast financial situation of the commercial enterprise provides for sufficient funds to purchase the profit maximizing set of requisitions (steps a-p are repeated until this condition is satisfied), m) calculating potential profit enhancing requisition sets for specific items under a variety of discount regimes, within the forecast financial constraints after relaxing user specified restrictions on global vendor and unit of measure substitution, n) creating and then displaying on the computer system a listing of the potential profit enhancing changes to the profit maximizing requisition set listed in descending capital efficiency order, o) specifying by user input to said computer the specific profit enhancing changes that are to be included in the profit maximizing requisition set, p) displaying on the computer system a report that summarizes the final profit maximizing requisition set and the forecast inventory status, and q) optionally printing financial management and requisition summary reports. - View Dependent Claims (2, 3, 4, 5, 6, 9)
-
-
7. In a computer, a method of and system for generating, displaying and storing forecasts of the type used in inventory management and financial planning, the method comprising the steps of:
-
a) specifying by user input to said computer the type of forecast to be run and the primary source of historical transaction, forecast element specification and current balance information, user input, electronic files or a basic financial system database, b) specifying by user input to said computer a plurality of templates and data definitions for use in extracting, converting and storing data from the primary source, c) extracting, converting and storing the source data in the application database of the present system in a format suitable for use in the present system, d) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to the extracted source data to create, display and store forecasts of sales by account, sales by customer group, sales by item, cash receipts by account as a function of sales by account and cash receipts by customer group as a function of sales by customer group, e) generating and storing a variable with each forecast element that is calculated in accordance with system default or user specified weighting criteria that facilitates forecast synchronization and obsolescence risk reduction, f) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to the forecasts of sales by account, sales by customer group and sales by item, cash receipts by account and cash receipts by customer group to create and store a multivalent composite forecast of sales and of cash receipts, and g) using the stored variable for each forecast element to prioritize and quantify the adjustments made to each forecast element in the sales by account, sales by customer group, sales by item, cash receipt by account and cash receipt by customer group forecasts as they are adjusted to exactly match a controlling forecast designated by the user or entered by the user into said computer. - View Dependent Claims (8)
-
-
10. In a computer, a method of and system for generating, displaying and storing forecasts of the type used for cash management, the method comprising the steps of:
-
a) specifying by user input to said computer the primary source of historical transaction, forecast element specification and current balance information, user input, electronic files or a basic financial system database, b) specifying by user input to said computer a plurality of templates and data definitions for use in extracting, converting and storing data from the primary source, c) extracting, converting and storing the source data in the application database of the present system in a format suitable for use in the present system, d) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to the extracted source data to create, display and store multivalent forecasts of sales by account, sales by customer group, sales by item, cash receipts by account as a function of sales by account and cash receipts by customer group as a function of sales by customer group, e) generating and storing a variable with each forecast element that is calculated in accordance with system default or user specified weighting criteria that facilitates forecast synchronization and obsolescence risk reduction, f) applying a set of prescribed mathematical algorithms, as implemented by a computer program stored in the computer system, to the forecasts of sales by account, sales by customer group and sales by item, cash receipts by account and cash receipts by customer group to create and store a multivalent composite forecast of sales and of cash receipts, g) using the stored variable for each forecast element to prioritize and quantify the adjustments made to each forecast element in the sales by account, sales by customer group, sales by item, cash receipt by account and cash receipt by customer group forecasts as they are adjusted to exactly match a controlling forecast designated by the user or entered by the user into said computer h) calculating and storing the variables that define the mathematical relationship between prior and current period sales and current period cash receipts by customer group, l) comparing the variables used to calculate the rate of payment by each customer group with previous payment rate variables for the same customer group in order to highlight any decrease in the rate of payment (i.e., percentage of payments made in later periods is increasing), and m) displaying a listing to the user listing the customer groups that have decreased their rate of invoice payment from prior levels.
-
Specification