×

Method of and system for generating feasible, profit maximizing requisition sets

  • US 5,615,109 A
  • Filed: 05/24/1995
  • Issued: 03/25/1997
  • Est. Priority Date: 05/24/1995
  • Status: Expired due to Term
First Claim
Patent Images

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.

View all claims
  • 5 Assignments
Timeline View
Assignment View
    ×
    ×