Data processing machine and method of allocating inventory stock for generating work orders for producing manufactured components

• US 4,459,663 A
• Filed: 07/02/1981
• Issued: 07/10/1984
• Est. Priority Date: 07/02/1981
• Status: Expired due to Fees

• Current Assignee: American Business Centers Incorporated
• Original Assignee: American Business Centers Incorporated
• Inventors: Dye, Gordon R.
• Primary Examiner(s): Zache, Raulfe B.
• Application Number:
  US06/280,175
• Time in Patent Office: 1,104 Days
• Field of Search: 364/200 MS File, 364/900 MS File, 364/300, 364/403, 364/468
• US Class Current: 705/29
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: G07C 3/08 Registering or indicating the production of the machine either with or without registering working or idle time

Abstract

A data processing machine is provided for automatically and efficiently controlling the manufacture of designated end item products and components which are used to make them. Product information is entered and stored in memory as job files, inventory files, and bill of materials files. Actual and planned customer orders as well as work orders are represented in the job file in a common format. Each job includes all of the due dates and quantities which relate to a single customer or part number. Once the job file has been created, the existing inventory stock is dynamically allocated under system control to all of the orders in the job file. The system uses the designated stock quantities in the job file to automatically generate internal work orders for the manufactured components necessary to fill the customer orders.

Claims

1. A data processing machine for controlling production of manufactured components, said machine comprising:

input means for receiving production information, said production information including job data consisting of actual customer orders, planned customer orders, and internal work orders;

said production information further including inventory data and bill of materials data;

memory means for storing digitized representations of said production information in a random access storage device, said storage device being divided into separate files, one each for said job data, inventory data, and bill of materials data;

said job file being arranged into a plurality of individual jobs in which the information therefore is presented in the same format, said format including a customer identification number, an end item part number, and a series of due dates and associated end item quantities for the same customer and part number;

the customer identification number for all job files reflecting actual customer orders being assigned a given number associated with the customer, the customer identification number for each job file reflecting planned customer orders being assigned a user selectable number, and the customer identification number for internal work orders being assigned the same number as the part number in the job file;

said inventory file including data representing the quanitity in stock and fabrication lead time for each part;

said bill of materials file including data representing each of the parts and associated quantities used to make a given end item;

control means responsive to a first command for interrogating said job files in a given order and the inventory file for the part associated with the job file interrogated, allocating inventory stock to each job file as a function of the total quantity required therein and the amount of remaining stock, said control means loading a number representing the allocated stock into the job file in said memory means as a designated stock quantity and reducing the quantity in stock in said inventory file;

said stock being allocated first to actual and planned customer orders beginning with the oldest due date and then to work orders;

said control means being responsive to a second command to interrogate said job files in a given order and subtract the designated stock quantity from the total requirements quantity for actual and planned customer orders for each job file thereby calculating total requirements for a given part, said control means reading the bill of materials file and fabrication lead time from the inventory file and generating an extract work file including the quantities and due dates for each manufactured component associated with the total requirements of end item parts defined by the customer orders;

said control means totaling the quantity of said components in the extract work file and subtracting the previously designated stock quantity from corresponding work orders in the job file to arrive at the net quantity of manufactured components necessary to complete the end item part requirements for the customer orders, said control means loading the manufactured component quantities from the extract work file into the job file associated with the work orders whereby said work order portion of the job file contains information defining the type, quantity, and due date by which each manufactured component must be made by the user in order to fill the customer orders; and

output means for utilizing the information in the memory means to control the production of manufactured components.

2. A method of controlling the production of manufactured components, said method comprising:

entering production information into a data processing machine, said production information including actual customer order data for a given end item including quantities required thereof, planned customer order data for a given end item including quantities required thereof, work order data for all manufactured components that are made by the user for incorporation into the end item, inventory data including the in stock quantity and fabrication lead time of parts, and bill of materials data defining the types and quantities of materials required to make the end item;

storing digitized representations of said production information in a memory, said memory being arranged so as to store customer and work order data in a job file, said inventory data in an inventory file, and said bill of material data in a bill of materials file;

commanding said data processing machine to interrogate said job file and said inventory file and to allocate stock from the inventory file first to customer orders and then to work orders by writing designated stock quantities into the job file and reducing the in stock quantity in said inventory file;

commanding said machine to total the quantities required of each end item by reading the customer orders in the job file;

to explode the total quantities required by the data stored in the bill of materials file to obtain a series of extracted records defining the types, quantities, and due dates for all materials used in making the end item;

to store said records as a group in preselected memory locations;

to subtract the designated stock quantity associated with the work orders in the job file from the extract records to obtain net quantities required; and

to load the extract quantities and due dates into the work orders in the job file associated with those extract records relating to the manufactured components whereby to generate in said job file a series of work orders for manufactured components which contains data defining the quantities and dates on which the user should begin making the components; and

reading said job file and using the data therein to control the production of manufactured components.

4. The method of claim 2 or 3 wherein the job file is arranged into a plurality of jobs in which the information therein is presented in the same format, said format including a customer identification number, an end item part number, and a series of due dates and associated end item quantities for the same customer and part number.

5. The method of claim 4 wherein the customer identification number for all jobs reflecting actual customer orders are assigned a given number associated with the customer, the customer identification number for each job reflecting planned customer orders being assigned a user selectable number, and the customer identification number for internal work orders being assigned the same number as the part number.

6. The method of claim 5 wherein inventory is allocated to the job file in chronological order according to the due dates in the job file.

3. A method of allocating inventory for the purpose of generating work orders for producing manufactured components, said method comprising:

entering production information into a data processing machine, said production information including customer order data for a given end item including quantities required thereof, and further including inventory data including the in-stock quantity of parts;

storing digitized representations of said production information in a memory, said memory being arranged so as to store said customer order data in a job file and said inventory data in an inventory file;

commanding said data processing machine to interrogate said job file and said inventory file and to allocate stock from the inventory file by writing designated stock quantities into the job file and reducing the in-stock quantity in said inventory file; and

commanding said data processing machine to read said designated stock quantities in the job file and generate a series of work orders for manufactured components as a function thereof.

7. The method of claim 3 wherein the inventory data further includes fabrication lead time of parts, and wherein bill of materials data is also stored defining the types and quantities of materials required to make the end item;

and wherein the method further includes the steps of;

subtracting said designated stock quantities from required customer quantities to arrive at net end item quantities required;

exploding said net end item quantities by the bill of materials data and using the fabrication lead time to generate information defining the types, quantities and due dates for all manufactured components necessary to satisfy the net end item quantities required; and

loading said information into the job file in the same format as the customer order data was stored.

8. The method of claim 7 wherein the job file is arranged into a plurality of identically formated jobs, the format of each job including a customer identification number, an end item part number, and a series of due dates and associated end item quantities for the same customer and part number.

9. The method of claim 8 wherein said information is loaded into the job file in records whose customer identification number is the same as the part number.

10. The method of claim 9 wherein inventory is allocated to the job file in chronological order according to due dates in the job file.