Abstract An automated inventory management system is provided which is easy to use and user friendly to evaluate the impact of customer demand changes on inventory. For a given item, the system automatically defines an inventory model by accessing an engineering planning database. The system identifies the on-hand raw material inventory and evaluates the work-in-process inventory from the model. The system then accesses an inventory database to identify the finished goods inventory and automatically consolidates all inventory and computes the total impact. The system also provides the practicing manager necessary control limits on raw material and work-in-process inventory dollars to complete a given finished product and establishes the required inventory turns. The user can use the system to compare against acutals and take appropriate action to correct any process deficiencies. This provides the capability to evaluate inventory sensitivity to customer demand and can be used to better serve the customer and his needs.
An automated method implemented on a computer for evaluating sensitivity of inventory cost to fluctuations in customer demand, said method providing an inventory cost analysis due to fluctuations in customer demand and comprising the steps of: inputting planning parameter data describing inventory for a manufacturing process; evaluating an inventory model of the manufacturing process based on said planning parameter data; providing a data input screen for inputting revised demand values; calculating inventory impact values for work-in-process inventory based on input revised demand values and the evaluation of said inventory model; and generating a report of said inventory impact values.
Claim 2
Dependent Claim
99 words
An automated method implemented on a computer for evaluating sensitivity of inventory cost to fluctuations in customer demand, said method providing an inventory cost analysis due to fluctuations in customer demand and comprising the steps of: inputting planning parameter data describing inventory for a manufacturing process; evaluating an inventory model of the manufacturing process based on said planning parameter data; providing a data input screen for inputting revised demand values; calculating inventory impact values for work-in-process inventory based on input revised demand values and the evaluation of said inventory model; and generating a report of said inventory impact values.
Claim 3
Dependent Claim
24 words
The automated method as recited in claim 1 wherein the step of inputting is performed by retrieving said planning parameter data from a database.
Claim 4
Dependent Claim
22 words
The automated method as recited in claim 1 wherein the step of inputting is performed by manually loading said planning parameter data.
Claim 5
Dependent Claim
41 words
The automated method as recited in claim 1 wherein said step of evaluating is performed by the steps of: calculating inventory cost data over a period of time; and generating a histogram showing cumulative inventory costs over said period of time.
Claim 6
Dependent Claim
16 words
The automated method as recited in claim 4 further comprising the step of displaying said histogram.
Claim 7
Dependent Claim
49 words
The automated method as recited in claim 1 further comprising the step of determining if alternative new revised demand values are to be input, and if so, repeating said steps of providing a data input screen, calculating inventory impact values and generating a report of said inventory impact values.