Min/max inventory control system and associated method and computer program product

Abstract

A system for providing products to a customer operates with an open purchase order having an acceptable inventory range bounded by a lower and an upper limit for each product supplied to the customer. The system includes a storage unit, a first processing unit that maintains a product inventory count, and a second processing unit that monitors the product inventory count. A system for transferring electronic files includes a first processing unit that stores and transfers the electronic file, generates a pointer associated with the transferred electronic file, generates a reference electronic file and thereafter includes the pointer in the reference electronic file. A second processing unit then displays the reference electronic file. A system for generating composite electronic files includes a first processing unit having composite locations including component electronic files, and generating the composite electronic files when the respective composite location is accessed from a second processing unit.

Description

FIELD OF THE INVENTION

[0002] The present invention relates to inventory control systems and methods and, more particularly, to lean inventory control systems and methods employing a minimum and a maximum inventory level.

BACKGROUND OF THE INVENTION

[0003] Everyday, businesses in product industries deal with inventory, generally consisting all of the goods and materials held by a business for future sale, use or other type of transfer. Typically, these businesses must engage in some type of inventory control to manage and maintain the proper amount of each good in stock or to provide the required service level of a product at a minimum cost. In one type of traditional inventory control system, a push system, an order for goods is issued for fulfillment in specified quantities, by specified due dates, based on estimated lead-times. In another type of traditional inventory control system, a pull (consumption based) system, an order is placed with the supplier when the on-hand inventory balance reaches a specified level.

[0004] These traditional methodologies of inventory procurement and management are generally transaction intensive, requiring many manual processes in order to keep customers supplied with the stock they need for future sale, use, or other type of transfer. Changes originating from engineering, define, and manufacturing result in a mismatch between the scheduled date and quantity, and the actual needed date and quantity. Due to changes in scheduling, engineering, and line stoppages, a mismatch often exists between the scheduled due date and/or the quantity, and the actual need date and quantity.

[0005] Administrative transactions, such as those entailing Change Orders and/or new Purchase Orders, adjust existing orders to account for these mismatches. New Purchase Orders may also be created to realign the needs of the customer with the inventory received from the supplier. While these administrative transactions seek to help control inventory and satisfy customer demand, the transactions themselves are expensive and wasteful in terms of resources. As an overhead cost, these transactions add no value to the end products of the customer.

[0006] In order to keep from running out of stock of a needed good and missing the delivery of a product incorporating the good to the customer as a result, it is common for suppliers to build excess inventory into their inventory control system to serve as a buffer to protect the supplier from being unable to deliver the required products. Additionally, the customer simultaneously orders and stores extra inventory to buffer the suppliers inability to consistently deliver the required products. This excess inventory is an economic liability for a number of reasons. First, excess inventory is costly for both the supplier and customer, as it ties up valuable, limited resources, such as space, materials, money, capacity, etc. Second, excess inventory exposes the manufacturer of the products to scrapage and rework in the event of a change in the configuration of a good. Third, excess inventory can pose a safety risk in terms of blocking aisles in storage areas or warehouses, as well as slowing down work flow, and reducing the efficiency at which the products can be produced and supplied.

[0007] Lean inventory systems, developed from lean manufacturing principles, can help address some of the problems associated with excess inventory and the waste created thereby. In lean inventory management systems, the emphasis is on real customer demand, which pulls products through the system, as they are needed. As such, lean inventory systems are a type of pull system. In traditional lean inventory systems, the time required to produce a particular good is matched as closely as possible with the rate of customer demand, thus, reducing excess inventory. Generally, the rate of customer demand is based upon projections, such as usage from a previous measured time period. But because the rate of customer demand can be more dynamic than a given projection, it is difficult, if not impossible, to always match production delivery dates and quantities with actual customer demand.

SUMMARY OF THE INVENTION

[0008] In light of the foregoing background, the present invention provides an improved lean inventory control system, method, and computer program product that employ a minimum and a maximum inventory level (min/max inventory) and a customer located warehouse. The system allows the supplier to monitor the customer's inventory levels and deliver needed products based on the customer consumption. By monitoring the inventory of the customer as the inventory changes, the supplier can better eliminate both the supplier and customer's wasteful excess inventory, and better match product supply with customer demand. Also, by providing additional products to the customer, based upon monitored inventory levels instead of schedule or separate Purchase Orders from the customer, expensive and wasteful administrative transactions are reduced. Additionally, the min/max inventory system allows the supplier to provide products to the customer from a warehouse as the customer's inventory level changes. Providing products to the customer from a warehouse near the customer's location reduces wasteful transportation time to better match product delivery with customer demand.

[0009] To facilitate communication between the supplier and the customer, the present invention also provides a system, method and computer program product for transferring at least one electronic file from a first location. The system for transferring electronic files improves the transfer of electronic files by providing a displayable reference electronic file including a pointer to the transferred electronic files. The displayable reference electronic file allows users to verify the location of a transferred file and, thereby access the transferred electronic file. Additionally, the reference electronic file can provide users with information relative to the date and/or time the electronic files were transferred. To facilitate the creation of composite electronic files which can further improve communication between the supplier and the customer, the present invention also provides a system, method and computer program product for generating composite electronic files, including pointers to one or more component electronic files. The system for creating composite electronic files allows originators of component electronic files to have their electronic files formatted and compiled into the composite electronic file without special training, and allows the composite electronic file to be updated each time it is accessed.

[0010] The min/max inventory system of the present invention typically operates in conjunction with a supplier/customer relationship whereby the supplier provides at least one product to the customer, who is often remote from the supplier. According to one embodiment of the present invention, the supplier and the customer have an open purchase order contract or agreement that includes a quantity of each product the supplier is to provide to the customer. The open purchase order contract or agreement also includes an acceptable inventory range bounded by a minimum and maximum amount for each product that the supplier provides to the customer that in order to defines delivery needs of the products to the customer. The system includes a processing unit disposed near the customer for storing a product inventory count associated with an initial amount of the products as the customer receives the initial amount. The customer's processing unit also maintains the product inventory count for each product representative of the amount of the product that is maintained in inventory. For example, the customer's processing unit can store the product inventory count in an electronic file, such as in a hypertext markup language (HTML) format or an extensible markup language (XML) format. The product inventory count is maintained by the customer's processing unit by decreasing the product inventory count as the customer sells, uses, transfers or otherwise ships out each product, and by increasing the product inventory count as the customer receives additional amounts of each product.

[0011] The system also includes a storage unit disposed remote from the supplier and proximate to the customer for storing a supply amount of the products provided to the customer. The products provided to the customer are drawn from the supply amount and, in one embodiment, the supply amount is bounded by the minimum and maximum amounts of the acceptable inventory range. Additionally, the system includes a processing unit disposed near the supplier for monitoring the product inventory count. For example, in embodiments where the customer's processing unit stores the product inventory count in an electronic file, the customer's processing unit may additionally be capable of transferring the electronic file to the supplier's processing unit, such as over the World Wide Web. The supplier's processing unit monitor's the product inventory count so that the supplier and/or the supplier's processing unit can detect product inventory counts that approach the respective lower limit, as evidenced by product inventory counts falling below a notification level between the upper and lower limits. When the supplier and/or supplier's processing unit detects that a product inventory count for a particular product is approaching the lower limit, supplier's processing unit can automatically send a shipment request to the supplier so that the supplier can provide the customer with an additional amount of the respective product. Because of the open purchase order, the supplier can provide the additional amount without a new purchase order associated with the additional amount, as long as the product inventory count is within the acceptable inventory range after the customer receives the additional amount. In one embodiment, the minimum amount is one below the maximum amount so that the supplier can provide the additional amount equal to the decrease in the product inventory count as the product inventory count decreases. Therefore, a constant product inventory count can be maintained by the supplier. Also, in this embodiment, the customer has at least one point-of-use location capable of receiving and shipping out each product. In this manner, the supplier can better match the delivery of the additional products with the customer demand by providing the products to the customer at the respective point-of-use location for the products. This simplifies receipt of the product and reduces the number of steps required for shipment of the required products.

[0012] In another embodiment, each product provided to the customer includes an electronic identifier for tracking the product. In this embodiment, the customer's processing unit can read each electronic identifier as the customer ships out the respective product and immediately thereafter decrease the product inventory count by the number of products shipped out as identified by the electronic identifiers. Additionally, the customer's processing unit can read each electronic identifier as the customer receives the respective product and immediately thereafter increase the product inventory count by the number of products received as identified by the electronic identifiers.

[0013] To facilitate communication between the supplier and the customer, the present invention also provides a system, method and computer program product for transferring at least one electronic file from a first location. The system includes a first processing unit, typically disposed at the customer location or otherwise under the control of the customer, on which the electronic files are stored. The first processing unit is capable of transferring the electronic files, such as by file transfer protocol (FTP), to a remote location, typically disposed at the supplier location or otherwise under the control of the supplier. After the first processing unit transfers the electronic files, the first processing unit generates at least one pointer, such as a hypertext link, associated with the transferred electronic files and the remote location. The first processing unit then generates a reference electronic file and thereafter includes the pointers in the reference electronic file. Additionally, in one embodiment the reference electronic file includes a date and/or time stamp identifying the date and/or time the electronic files were transferred from the first processing unit. The reference electronic file is capable of being displayed, such as an HTML or XML formatted electronic file. The system also includes a second processing unit disposed remote from the first processing unit, such as at the supplier location. Typically, the remote processing unit and the second processing unit are electrically connected, such as over a local area network (LAN). The second processing unit is capable displaying the reference electronic file, including the pointers, so that a user located proximate the second processing unit is capable of locating the electronic files at the remote location based upon the pointers. For example, by including pointers for the electronic files on a reference electronic file, the supplier can locate the electronic files, previously transferred from the customer, on a supplier accessible computer without additional notification from the customer as to the transfer. In one embodiment, the second processing unit displays the reference electronic file, including the pointers, for a predefined period of time. By displaying the reference electronic file, including the pointers, for a predefined period of time, the reference electronic file can be updated with removed or different pointers to take into account any change in file location, as well as any subsequent electronic file transfers to the second processing unit.

[0014] To further facilitate communication between the supplier and the customer, the present invention also provides a system, method and computer program product for generating at least one composite electronic file, such as an HTML or XML formatted electronic file. The system includes a first processing unit having at least one composite location capable of storing at least one component electronic file. The first processing unit may additionally be capable of receiving the component electronic files into the respective composite locations. In one embodiment, the system further includes a remote processing unit, such as a computer connected to the first processing unit over a LAN, having at least one composite location capable of storing, and possibly receiving, the component electronic files. In another embodiment, the first processing unit also includes a master electronic file, such as an HTML or XML formatted electronic file, having a composite pointer, such as a hypertext link, associated with each composite location so that each composite location is accessible via the respective composite pointer.

[0015] The first processing unit is capable of generating the composite electronic files when the respective composite locations are accessed from a second processing unit. The composite electronic files include at least one component pointer, such as a hypertext link, associated with the component electronic files in the respective composite locations. The composite electronic files are capable of being displayed through an interface, such as a graphical user interface (GUI), so that the information within component electronic files are accessible via the interface, based upon the component pointers. When a component electronic file is removed from the respective composite location, the first processing unit generates the respective composite electronic file without the component pointer associated with the respective component electronic file. Automatically generating the composite electronic files as the composite locations are accessed allows users at the customer location, for example, who may comprise users from multiple sectors within the customer's business, to create, delete and otherwise modify electronic files pertaining to their particular sector for display by the supplier.

[0016] The present invention therefore provides an improved lean inventory control system that employs minimum and maximum inventory levels and a customer located warehouse or point-of-use (POU) inventory. The min/max inventory system allows the supplier to monitor the inventory and to provide additional products to the customer as the customer's inventory changes. Monitoring the inventory of the customer as the inventory changes reduces wasteful excess inventory, and facilitates a better match between the production of products and customer demand for the products. Providing additional products to the customer, based upon monitored inventory levels instead of based upon a schedule or separate purchase orders from the customer, reduces expensive and wasteful administrative transactions. Also, the min/max inventory system of the present invention allows the supplier to provide products to the customer from a warehouse at or near the customer's location as the customer's inventory level changes, which reduces wasteful transportation time to better match product delivery with customer demand.

[0017] The present invention also provides a system, method and computer program product for transferring at least one electronic file from a first location. The system provides a displayable reference electronic file including a pointer to the transferred electronic files that allows users to verify the location of a transferred file and, thereby, access the transferred electronic file. The present invention further includes a system for creating composite electronic files that allows originators of component electronic files to have their electronic files formatted and compiled into the composite electronic file without special training.

BRIEF DESCRIPTION OF THE DRAWINGS

[0018] Having thus described the invention in general terms, reference will now be made to the accompanying drawings, which are not necessarily drawn to scale, and wherein:

[0019] FIG. 1 is a block diagram of the system for providing at least one product from a supplier to a customer according to one embodiment of the present invention;

[0020] FIG. 2 is a flow diagram of the operations performed to manage an inventory of at least one product of a supplier that is provided to a customer according to one embodiment;

[0021] FIGS. 3A-3C illustrate some of the operations for transferring at least one electronic file from a first location according to one embodiment of the present invention;

[0022] FIG. 4 is a flow diagram of the operations for transferring the electronic file from the first location according to one embodiment;

[0023] FIG. 5 is a schematic diagram of the reference electronic file including an electronic file transferred according to one embodiment of the method for transferring the electronic file;

[0024] FIG. 6 is a schematic diagram illustrating a file structure for storing component electronic files in accordance with the system for generating at least one composite electronic file according to one embodiment;

[0025] FIGS. 7A-7C illustrates some of the various electronic files used in one embodiment of the method for generating the composite electronic file;

[0026] FIG. 8 is a schematic diagram of a composite electronic file generated according to one embodiment of the method for generating the composite electronic file; and

[0027] FIG. 9 is a flow diagram of the operations for generating the composite electronic file according to one embodiment of the present invention.

DETAILED DESCRIPTION OF THE INVENTION

[0028] The present invention now will be described more fully hereinafter with reference to the accompanying drawings, in which preferred embodiments of the invention are shown. This invention may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art. Like numbers refer to like elements throughout.

[0029] FIG. 1 illustrates a system 10 for providing at least one product from a supplier 20 to at least one customer 30 according to one embodiment of the present invention. The supplier provides the products to the customer and, in turn, the customer receives and thereafter ships out the products, such as by selling, using or transferring the products to third parties. To track the customer's inventory of products provided by the supplier, the system includes a first processing unit 32, such as a personal computer or other high level processor, preferably under the control of the customer. To monitor the customer's inventory of products provided by the supplier, the system also includes a second processing unit 22, such as a personal computer or other high level processor, preferably under the control of the supplier and disposed remote from the first processing unit. Additionally, to reduce transportation time and facilitate matching delivery of the products with customer demand, the system preferably includes a storage unit 40, such as a warehouse under the supplier's control, for storing a supply amount of the products that are thereafter provided to the customer. In a preferred embodiment, the supplier is remote from the customer and the storage unit, and the storage unit is proximate the customer. As such, the time required to deliver products from the storage unit to the customer is thereby decreased relative to deliveries from the supplier's location.

[0030] As shown in FIG. 2, the supplier and each customer have an open purchase order for the products provided to the customer by the supplier (block 100). The open purchase order is typically a contract including any number of different contract terms as agreed to by the supplier and the customer. But instead of providing multiple purchase orders for a specific quantity of each product and a schedule of delivery date or dates, an open purchase order is created that includes a total quantity of products the supplier is to provide to the customer for a contracted period of time. Additionally, the open purchase order includes an acceptable inventory range bounded by a lower (i.e., minimum) and an upper (i.e., maximum) limit for each product, which governs delivered quantities of the product provided to the customer. Typically, the acceptable inventory range is agreed upon and shared between the supplier and customer. The minimum quantity typically represents an amount of inventory required to cover the supplier in areas such as, for example, replenishment lead time, yield factor, packaging requirements and lot sizing requirements. And the maximum quantity typically represents an amount of inventory taking into account the customer's needs in areas such as, for example, consumption, forecast accuracy, yield factor, lot-sizing requirements and inventory turn rate requirements. Delivery times can be specified in a number of manners such as, for example, a specified number of days after the inventory is decreased by a predetermined amount.

[0031] After the terms of the open purchase order have been completed, in one embodiment, the supplier 20 stores a supply amount 50 of each product supplied to the customer 30 in the storage unit 40 (block 101). While the supply amount can be any amount above the lower limit specified in the open purchase order, in a preferred embodiment the supply amount is bounded by the lower and upper limits of the open purchase order.

[0032] The supplier then initiates a method of managing the inventory of the customer by providing the customer with an initial amount of each product (block 102). As the customer receives the products 80, the first processing unit 32 stores a product inventory count representative of the initial amount of each product received by the customer. Whereas the product inventory count can be stored in any number of different manners, the product inventory count is preferably stored in an electronic file, such as in a hypertext markup language (HTML) format or an extensible markup language (XML) format. The description herein of the systems and methods of providing the products to the customer and managing the inventory of the customer are premised on the customer not already having an inventory of the products when the supplier provides the initial amount. It should be understood, however, that the customer can already have an amount of the products in inventory when the supplier provides the initial amount of the products. In such an instance, the product inventory count would be representative of the sum total of the initial amount of each product received by the customer and the amount of the respective product in the customer's inventory when the customer receives the initial amount.

[0033] In one embodiment, each product can include an electronic identifier, such as a radio frequency identification (RFID) tag (not shown). The electronic identifier can be located in any of a number of different locations relative to the respective product, such as on the product itself or on the product's packaging. In this embodiment, the first processing unit 32 reads each electronic identifier as the customer 30 receives the respective product 80 from the storage unit 40. As the first processing unit reads the electronic identifiers, the first processing unit increases the product inventory count by the number of products received as identified by the electronic identifiers. After the customer 30 receives the initial amount of each product, the first processing unit maintains the product inventory count (block 104). As the customer ships out each product 70, the first processing unit 32 decreases the product inventory count by the number of products shipped out (blocks 106 and 108). And as the customer receives additional quantities of each product 80, just as with the initial amount of products, the first processing unit increases the product inventory count by the number of products received (blocks 110 and 112). In embodiments including the electronic identifiers, the first processing unit reads each electronic identifier as the customer ships out the respective product and immediately thereafter decreases the product inventory count by the number of products shipped out as identified by the electronic identifiers. When the customer receives the respective product from the storage unit, the first processing unit reads each electronic identifier and immediately thereafter increases the product inventory count by the number of products received as identified by the electronic identifiers.

[0034] As the first processing unit 32 maintains the product inventory count, the second processing unit 22 and/or the supplier 20 monitors the product inventory count at a location remote from the customer. The second processing unit is typically disposed at a supplier location or is otherwise controller by the supplier. To monitor the product inventory count, in embodiments wherein the first processing unit stores the product inventory count in an electronic file, for example, the first processing unit can transmit the electronic file to the second processing unit, such as via the World Wide Web. In this manner, the second processing unit and/or the supplier can monitor the product inventory count, electronically or through a display of the electronic file, as the product inventory count changes. When the product inventory count falls below a notification level, the second processing unit and/or the supplier can detect the inventory of the customer 30 as approaching the lower limit of acceptable inventory (block 114). The notification level, which is between the upper and lower limits, acts as a buffer to insure that additional products are provided to the customer before the product inventory count falls below the lower limit. In this regard, the notification level can be based on any of a number of different factors, such as the rate at which the customer typically ships out the products and the time required to transport the products to the customer.

[0035] When the second processing unit 22 and/or the supplier 20 detect a product inventory count approaching the lower limit of acceptable of inventory, the second processing unit can send a shipment request to the supplier so that the supplier can provide the customer 30 with an additional amount of the respective product to keep the customer's inventory within the acceptable inventory range (block 116). As the customer receives the additional products, the first processing unit 32 continues to maintain the product inventory count by increasing the product inventory count accordingly. Because the additional products are provided pursuant to the open purchase order and the customer's current inventory level, the supplier can provide the additional products without a separate purchase order from the customer. In this manner, the expensive and wasteful administrative transactions of conventional inventory control systems are reduced.

[0036] In one embodiment, to maximize the reduction of wasteful supplier inventory, the lower limit of the acceptable inventory range is one below the upper limit. In this embodiment, the supplier 20 provides the products to the customer 30 at a predefined frequency that is sensitive to the consumption of the product, such as providing products daily to the customer based on daily consumption of the products. In this regard, the receiving of additional products more closely matches customer demand. In this manner, as the customer ships out a product 70, the first processing unit 32 decreases the product inventory count. The second processing unit 22 and/or the supplier detect the decrease in the product inventory count, and thereafter the supplier provides the customer with the additional amount of the product to increase the product inventory count by the amount of the product previously shipped out. Providing the customer with the additional amount as the product inventory level decreases allows the supplier to provide the customer with products with a stable and regular demand schedule while lowering the supplier's inventory. In operation, for example, assume the lower limit is one below the upper limit for a given product, assume the current inventory level for the product is two, and assume the customer ships out two units of the product on a given day. The following day (or other delivery time as provided for in the open purchase order), the supplier provides the customer with two units of the product to bring the product inventory count back up to two, which is greater than the lower limit, and equal to the upper limit.

[0037] In this embodiment, to further match receiving the products with customer 30 demand, the customer has at least one point-of-use location where the customer uses the products (not shown). As the customer ships out each product from its respective point-of-use location, the supplier 20 provides the additional products to the customer at the respective point of use location, as opposed to a single designated receiving location. This reduces the wasteful delivery time as the customer is not required to ship the products from the customer-designated receiving location to the respective point-of-use location for the product.

[0038] Referring now to FIGS. 3A-3C and 4, to facilitate communication between the supplier 20 and the customer 30, the present invention also provides a system, method and computer program product for transferring at least one electronic file 126 from a first location 124, such as from a memory device at the customer location or otherwise under the control of the customer. According to one embodiment, the system includes a first processing unit 120, such as a personal computer or other high level processor, including a memory device having the first location 124 for storing the electronic file to be transferred. The system also includes a remote processing unit 122, such as a personal computer or other high level processor, disposed remote from the first processing unit, such as at a supplier location or otherwise under the control of the supplier, and including a memory device having a remote location 128 for receiving the electronic file. In operation, the electronic file to be transferred is selected (block 150). Then, as illustrated in FIG. 3A, the first processing unit transfers the electronic file to the remote location in the remote processing unit (block 152). The first processing unit can transfer the electronic file by any method known to those skilled in the art, but in one embodiment the first processing unit transfers the electronic file via a protocol, such as a file transfer protocol (FTP), a hyper text transfer protocol (HTML), or a secured HTML (HTTPS).

[0039] After the first processing unit 120 transfers the electronic file 126, the first processing unit generates a pointer 127, such as a hypertext link, associated with the electronic file and the remote location 128 (block 154). As shown in FIG. 3B, if the first processing unit does not already have a reference electronic file 132, the first processing unit next generates the reference electronic file, such as an HTML or XML formatted file (blocks 156 and 158). The first processing unit includes the pointer in the reference electronic file and may additionally include other information 129, such as information relative to the contents of the electronic file. Additionally, the reference electronic file may include a date and/or time stamp for each transferred electronic file that identifies the date and/or time the electronic file was transferred.

[0040] As illustrated in FIG. 3B, after the pointer 127 has been included in the reference electronic file 132, the reference electronic file can be copied by, transferred to or otherwise accessed by, and displayed by a display 136 associated with a second processing unit 134 (block 162). For example, the reference electronic file can be downloaded via FTP from the World Wide Web from the first processing unit 120 to the second processing unit and thereafter displayed by the second processing unit. Using the pointer on the display of the reference electronic file, a user of the second processing unit can locate and/or access the transferred electronic file 126 from the remote location 122, as shown in FIG. 3C (block 162). Like the remote processing unit, the second processing unit is also typically located at the supplier location or otherwise under the control of the supplier. For example, the remote processing unit and the second processing unit can be connected, such as over a LAN. Whereas the remote processing unit and second processing unit are illustrated as separate components, it should be understood that the second processing unit can be the remote processing unit, including the remote location. In such an embodiment, a user of the remote processing unit could view a display of the reference electronic file and, based upon the pointer, access the transferred electronic file stored in the remote location. Whereas, the system, method and computer program product of transferring the electronic files facilitates communication between the supplier and the customer, it should be understood that the system, method and computer program product can be employed in other contexts as well, without departing from the spirit and scope of the present invention.

[0041] Because a user of the first processing unit 120 may want the contents 129 of the reference electronic file 132 to be accessible for a longer time period than the transferred electronic file 126, the first processing unit may only include the pointer 127 in the reference electronic file for a predefined period of time. After the predefined period of time has expired, the first processing unit may purge the reference electronic file of the pointer to thereby update the reference electronic file (blocks 166 and 168). Removing the pointer allows the reference electronic file to be updated with pointers removed and/or added to take into account transferred electronic files no longer located in the remote location into which they were transferred, and to take into account subsequent electronic files transferred to the same or different remote locations.

[0042] FIG. 5 illustrates an example of the reference electronic file including an electronic file transferred according to one embodiment of the method for transferring the electronic file. Transferring the electronic file from the first processing unit, such as at the customer location, to the second location, such as the supplier location, allows the suppler to receive electronic files from the customer to thereafter locate and access without additional notification from the customer. Referring to FIG. 5, the customer can select electronic files, such as inventory reports, using a file select interface 212 and transfer the electronic files to the supplier location. After the customer has transferred the electronic files, a hypertext link, and possibly a date/time stamp 213, can then be generated for the transferred electronic files 214 on a reference page 210, such as a supplier information page that may additionally include hypertext links to additional miscellaneous information 216. In this manner, any person with access to the reference page can locate and access the transferred electronic files without additional notification as to the transfer, such as an email notifying the supplier of the transferred electronic file or its location. As previously stated, the system, method and computer program product of transferring the electronic files facilitates communication between the supplier and the customer. But it should be understood that the system, method and computer program product can be employed in other contexts as well, without departing from the spirit and scope of the present invention.

[0043] To further facilitate communication between the supplier 20 and the customer 30, the present invention provides a system, method and computer program product for creating at least one composite electronic file. Referring to FIGS. 6 and 7A-7C, one embodiment of the system includes a first processing unit 172, such as a personal computer or other high level processor, comprising a memory device having at least one composite location 176. The first processing unit is capable of storing at least one component electronic file 178, such as HTML or XML formatted electronic files, into the at least one composite location. The first processing may also be capable of receiving the component electronic files and thereafter storing the received component electronic files in the respective composite locations. In one embodiment, the system also includes a remote processing unit (not shown), such as a personal computer or other high level processor, comprising a memory device having at least one composite location. For example, the remote processing unit can be a personal computer in communication with the first processing unit over a local area network. Like the first processing unit, the remote processing unit is capable of storing the at least one component electronic file, and can be capable of receiving the component electronic files and thereafter storing the received component electronic files on the composite locations.

[0044] The system also includes a second processing unit 184 capable of accessing the composite locations 176 and the component electronic files 178 stored therein. In one embodiment, the first processing unit 172 includes a master electronic file 174, such as an HTML or XML formatted electronic file, within the first processing unit. The master electronic file includes at least one composite pointer 182, such as a hypertext link, associated with the at least one composite location. In this embodiment, a user of the second processing unit can access the composite locations via the at least one composite pointer since the second processing unit has access to the master electronic file.

[0045] FIG. 8 is an example composite electronic file generated from the customer location according to one embodiment of the method for generating the composite electronic file. Automatically generating each composite electronic file 218 as the composite locations are accessed allows users at the customer location who may comprise users from multiple sectors within the customer's operation, to create, delete and otherwise modify electronic files pertaining to their particular sector for display by the supplier. In this regard, the component pointers 222 allow the component electronic files to be accessed from one composite electronic file as opposed to requiring the location of each component electronic file to be known. The customer can additionally have a master electronic file, such as a supplier information electronic file, that the supplier can access to access constantly updated composite electronic files and, in turn, component electronic files, such as information relative to the supplier and/or different areas of the customer's business, such as different product lines, different manufacturing areas or different point-of-use locations. In this regard, each composite electronic file can additionally include a master pointer 220, such as a hypertext link, to the master electronic file. Whereas, the system, method and computer program product for creating the composite electronic files further facilitates communication between the supplier and the customer, it should be understood that the system, method and computer program product can be employed in other contexts as well, without departing from the spirit and scope of the present invention.

[0046] Referring to FIG. 9, in operation, the composite locations 176 in the first processing unit 172, and possibly the remote processing unit, are designated (block 192). In embodiments including a master electronic file 174, the master electronic file is created by the first processing unit, and includes the composite pointers 182, as shown in FIG. 7A. For example, a server computer located at the customer location or otherwise under the control of the customer, can include the master electronic file, such as a supplier web page, with pointers, such as hypertext links, to the component locations, such as memory locations on the server computer or on the remote processing unit, such as a computer connected to the server computer over a LAN. The component electronic files 178 are then copied into and/or removed from respective composite locations (blocks 198 and 200). Then, from the second processing unit 184, the composite locations are accessed, such as via the composite pointers in the master electronic file to which the second processing unit has access (block 202).

[0047] When the second processing unit 184, such as a personal computer located at the supplier location or otherwise under the control of the supplier, accesses the composite locations 176, the first processing unit 172 automatically generates the respective composite electronic file 180, such as in HTML or XML format, as shown in FIG. 7B (block 204). The composite electronic file includes at least one component pointer 186, such as a hypertext link, associated with the at least one component electronic file 178 stored in the respective composite location. If one or more of the component electronic files are subsequently removed from the respective composite location, when the second processing unit thereafter accesses the respective composite location, the first processing unit will generate the composite electronic file without the respective component pointers associated with the removed component electronic file or files. After the composite electronic file is generated, the composite electronic file is displayed on a graphical user interface (GUI), such as a display associated with the second processing unit (block 205). In this manner, the user can locate and access the respective component electronic files via the component pointers (block 206). As previously stated, the system, method and computer program product for creating the composite electronic files further facilitates communication between the supplier and the customer. It should be understood that the system, method and computer program product can be employed in other contexts as well, without departing from the spirit and scope of the present invention.

[0048] The present invention provides a lean inventory control system that employs min/max inventory levels and a customer located warehouse, and includes associated methods for transferring at least one electronic file and for generating at least one composite electronic file. The present invention allows the supplier to monitor the inventory to and provide additional products to the customer as the customer's inventory changes. Also, the min/max inventory system of the present invention allows the supplier to provide products to the customer from a warehouse near the customer's location as the customer's inventory level changes, which reduces wasteful transportation time to better match product delivery with customer demand.

[0049] The present invention also provides a system, method and computer program product for transferring at least one electronic file from a first location. The system allows users to verify the location of a transferred file and, thereby, access the transferred electronic file. The present invention further includes a system, method and computer program product for creating composite electronic files to allow originators of component electronic files to have their electronic files formatted and compiled into the composite electronic file without special training. These additional systems, methods and computer program products not only facilitate communication in the supplier/customer context, as described above, but can also be employed in other situations, if so desired.

[0050] In various advantageous embodiments, portions of the system and method of the present invention include a computer program product. The computer program product includes a computer-readable storage medium, such as the non-volatile storage medium, and computer-readable program code portions, such as a series of computer instructions, embodied in the computer-readable storage medium. Typically, the computer program is stored and executed by a processing unit or a related memory device, such as the first processing unit 120 as depicted in FIG. 3A or the first processing unit 172 as depicted in FIG. 6.

[0051] In this regard, FIGS. 1-9 are block diagram, flowchart and control flow illustrations of methods, systems and program products according to the invention. It will be understood that each block or step of the block diagram, flowchart and control flow illustrations, and combinations of blocks in the block diagram, flowchart and control flow illustrations, can be implemented by computer program instructions. These computer program instructions may be loaded onto a computer or other programmable apparatus to produce a machine, such that the instructions which execute on the computer or other programmable apparatus create means for implementing the functions specified in the block diagram, flowchart or control flow block(s) or step(s). These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the block diagram, flowchart or control flow block(s) or step(s). The computer program instructions may also be loaded onto a computer or other programmable apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the block diagram, flowchart or control flow block(s) or step(s).

[0052] Accordingly, blocks or steps of the block diagram, flowchart or control flow illustrations support combinations of means for performing the specified functions, combinations of steps for performing the specified functions and program instruction means for performing the specified functions. It will also be understood that each block or step of the block diagram, flowchart or control flow illustrations, and combinations of blocks or steps in the block diagram, flowchart or control flow illustrations, can be implemented by special purpose hardware-based computer systems which perform the specified functions or steps, or combinations of special purpose hardware and computer instructions.

[0053] Many modifications and other embodiments of the invention will come to mind to one skilled in the art to which this invention pertains having the benefit of the teachings presented in the foregoing descriptions and the associated drawings. Therefore, it is to be understood that the invention is not to be limited to the specific embodiments disclosed and that modifications and other embodiments are intended to be included within the scope of the appended claims. Although specific terms are employed herein, they are used in a generic and descriptive sense only and not for purposes of limitation.

Claims

1. A method for managing an inventory of at least one product of a supplier that is provided to at least one customer, wherein the at least one customer is capable of receiving and shipping out the at least one product, said method comprising: creating an open purchase order comprising an acceptable inventory range bounded by a lower limit and an upper limit for each product that the supplier provides to the at least one customer; storing a supply amount of the at least one product in a storage unit that is remote from the supplier and proximate to the customer; maintaining a product inventory count for each product representative of the amount of the product that is maintained in inventory by the at least one customer, said maintaining comprising: decreasing the product inventory count as the at least one customer ships out the respective product; and increasing the product inventory count as the at least one customer receives additional amounts of the respective product, wherein the at least one customer receives the additional amounts from the supply amount stored in the storage unit; and monitoring the product inventory count at a supplier location such that the supplier is capable of detecting when product inventory counts approach the respective lower limits, wherein the product inventory count approaches the respective lower limit when the product inventory count falls below a notification level between the lower limit and the upper limit, and wherein the supplier location is remote from the customer location.

2. A method according to claim 1 further comprising providing the respective customer with an additional amount of the respective product once the supplier has detected at least one product inventory count approaching the respective lower limit, wherein the additional amount is provided to the customer from the supply amount stored in the storage unit, wherein providing the additional amount occurs independent of a purchase order associated with the additional amount, and wherein the product inventory count is within the acceptable inventory range once the respective customer receives the additional amount.

3. A method according to claim 1, wherein maintaining the product inventory count further comprises storing the product inventory count in an electronic file, and transferring the electronic file to the supplier location to facilitate monitoring the product inventory count at the supplier location, wherein monitoring the product inventory count comprises monitoring the electronic file.

4. A method according to claim 3, wherein transferring the electronic file comprises transferring the electronic file over the World Wide Web, and wherein monitoring the product inventory count comprises monitoring a display of the product inventory count stored within the electronic file.

5. A method according to claim 3, wherein storing the product inventory count in an electronic file comprises storing the product inventory count in an electronic file in an extensible markup language format.

6. A method according to claim 1, wherein each product includes at least one electronic identifier, and wherein maintaining the product inventory count comprises: reading each electronic identifier as the customer ships out the respective product and immediately thereafter decreasing the product inventory count by the number of products shipped out as identified by the electronic identifiers; and reading each electronic identifier as the customer receives the respective product from the storage unit and immediately thereafter increasing the product inventory count by the number of products received as identified by the electronic identifiers.

7. A method according to claim 1 further comprising providing each customer with an initial amount of each product before maintaining the product inventory count, wherein the initial amount of each product is received by the at least one customer from the storage unit.

8. A method according to claim 7, wherein each product includes at least one electronic identifier, and wherein providing each customer with the initial amount of each product further comprises reading each electronic identifier as the initial amount is received.

9. A method according to claim 1, wherein the supply amount is bounded by the lower limit and the upper limit.

10. A method according to claim 1, wherein the lower limit is one below the upper limit of the acceptable inventory range, wherein the notification level equals the lower limit, and wherein the at least one customer has at least one point-of-use location capable of receiving and shipping out each product.

11. A system for providing at least one product from a supplier to at least one remote customer, wherein the customer is capable of receiving and shipping out the at least one product, wherein the supplier and the at least one customer have an open purchase order comprising an acceptable inventory range bounded by a lower and an upper limit for each product that the supplier provides to the at least one customer, said system comprising: a storage unit disposed remote from the supplier and proximate to the at least one customer, wherein a supply amount of the at least one product is stored in said storage unit, wherein the supplier provides the at least one product to the customer from the supply amount stored in the storage unit; a first processing unit disposed proximate the at least one customer for maintaining a product inventory count for each product representative of the amount of the product that is maintained in inventory by the respective customer, wherein the product inventory count is decreased as the customer ships out each product, and wherein the product inventory count is increased as the customer receives additional amounts of each product; and a second processing unit disposed proximate the supplier, wherein at least one of the supplier and said second processing unit is capable of monitoring the product inventory count such that at least one of the supplier and said second processing unit is capable of detecting product inventory counts that approach the respective lower limit, wherein the product inventory count approaches the respective lower limit when the product inventory count falls below a notification level between the lower limit and the upper limit.

12. A system according to claim 11, wherein said second processing unit is further capable of sending a shipment request to the supplier when at least one of the supplier and said second processing unit has detected at least one product inventory count approaching the respective lower limit, wherein when the supplier receives the shipment request the supplier is capable of providing the respective customer with an additional amount of the respective product, wherein the supplier provides the additional amount independent of a purchase order associated with the additional amount, and wherein the product inventory count is within the acceptable inventory range once the additional amount is received.

13. A system according to claim 11, wherein said first processing unit is capable of storing the product inventory count in an electronic file, wherein said first processing unit is capable of transferring the electronic file, wherein said second processing unit is capable of receiving the electronic file, and wherein said second processing unit monitors the electronic file.

14. A system according to claim 13, wherein said first processing unit is capable of transferring the electronic file over the World Wide Web, and wherein said second processing monitors a display of the product inventory count stored within the electronic file.

15. A system according to claim 13, wherein said first processing unit stores the product inventory count in an electronic file in an extensible markup language format.

16. A system according to claim 11, wherein each product includes at least one electronic identifier, wherein said first processing unit reads each electronic identifier as the customer ships out the respective product and immediatey thereafter decreases the product inventory count by the number of products shipped out as identified by the electronic identifiers, and wherein said first processing unit reads each electronic identifier as the customer receives the respective product and immediately thereafter increases the product inventory count by the number of products received as identified by the electronic identifiers.

17. A system according to claim 11, wherein said first processing unit is further capable of storing a product inventory count associated with an initial amount of the at least one product before maintaining the product inventory count, wherein said first processing unit stores the initial amount as the at least one customer receives the initial amount from the storage unit.

18. A system according to claim 17, wherein each product includes at least one electronic identifier, wherein said first processing unit is capable of reading each electronic identifier as the initial amount of the at least one product is received by the customer, wherein said first processing unit stores the product inventory count associated with the initial amount according to the number of products received as identified by the electronic identifiers.

19. A system according to claim 11, wherein the supply amount is bounded by the lower limit and the upper limit.

20. A system according to claim 11, wherein the lower limit is one below the upper limit of the acceptable inventory range, wherein the notification level equals the lower limit, and wherein the supplier has a point-of-use location capable of receiving and shipping out the at least one product, and wherein the supplier provides the at least one product to the customer at the at least one point-of-use location.

21. A method for transferring at least one electronic file from a first location comprising: selecting the at least one electronic file; transferring the at least one electronic file from the first location to a second location, wherein the second location is remote from the first location; generating at least one pointer associated with the at least one electronic file and the second location; generating a reference electronic file at the first location and thereafter including the at least one pointer in the reference electronic file, wherein the reference electronic file is capable of being displayed; and displaying the reference electronic file including the at least one pointer at a display location such that a user located at the display location is capable of locating the at least one electronic file at the second location based upon the at least one pointer.

22. A method according to claim 21, wherein including the at least one pointer in the reference electronic file comprises including the at least one pointer for a predefined period of time.

23. A method according to claim 21, wherein transferring the at least one electronic file comprises transferring the at least one electronic file according to a protocol selected from a group consisting of a file transfer protocol (FTP), a hypertext transfer protocol (HTTP), and a secured HTTP (HTTPS).

24. A method according to claim 21, wherein generating the reference electronic file comprises generating the reference electronic file in a hypertext markup language including at least one hypertext link associated with the at least one pointer such that the user is capable of locating and accessing the at least one electronic file at the second location.

25. A method according to claim 21, wherein generating the reference electronic file comprises generating the reference electronic file in a extensible markup language including at least one interactive link associated with the at least one pointer such that the user is capable of locating and accessing the at least one electronic file at the second location.

26. A system for transferring at least one electronic file, said system comprising: a first processing unit, wherein the at least one electronic file is stored in said first processing unit, wherein said first processing unit is capable of transferring the at least one electronic file to a remote location, wherein said first processing unit is capable of generating at least one pointer associated with the at least one electronic file and the remote location, wherein said first processing unit is capable of generating a reference electronic file and thereafter including the at least one pointer in the reference electronic file, wherein the reference electronic file is capable of being displayed; and a second processing unit disposed remote said first processing unit, wherein said second processing unit is capable of displaying the reference electronic file including the at least one pointer such that a user is capable of at least one of locating and accessing the at least one electronic file at the remote location based upon the at least one pointer.

27. A system according to claim 26, wherein said second processing unit is capable of including the at least one pointer in the reference electronic file for a predefined period of time.

28. A system according to claim 26, wherein said first processing unit is capable of transferring the at least one electronic file using a file transfer protocol.

29. A system according to claim 26, wherein said first processing unit is capable of generating the reference electronic file in a hypertext markup language including at least one hypertext link associated with the at least one pointer.

30. A system according to claim 26, wherein said first processing unit is capable of generating the reference electronic file in an extensible markup language including at least one interactive link associated with the at least one pointer.

31. A computer program product for transferring at least one electronic file, the computer program product comprising a computer-readable storage medium having computer-readable program code embodied in said medium, the computer-readable program code comprising: a first executable portion for selecting the at least one electronic file stored within the processing unit; a second executable portion for transferring the at least one electronic file to a remote location; a third executable portion for generating at least one pointer associated with the at least one electronic file and the remote location; and a forth executable portion for generating a reference electronic file including the at least one pointer, wherein the reference electronic file is capable of being displayed at a remote display location, wherein the electronic file is capable of being displayed such that a user is capable of at least one of locating and accessing the at least one electronic file at the remote location based upon the at least one pointer.

32. A computer program product according to claim 31, wherein said forth executable portion generates the reference electronic file including the at least one pointer such that the reference electronic file is capable of being displayed for a predefined period of time.

33. A computer program product according to claim 31, wherein said second executable portion is capable of transferring the at least one electronic file using a file transfer protocol.

34. A computer program product according to claim 31, wherein said forth executable portion generates the reference electronic file in a hypertext markup language including at least one hypertext link associated with the at least one pointer.

35. A computer program product according to claim 31, wherein said forth executable portion generates the reference electronic file in an extensible markup language including at least one interactive link associated with the at least one pointer.

36. A method for creating at least one composite electronic file including at least one component electronic file, the method comprising: providing the at least one component electronic file disposed in at least one composite location; and accessing the at least one composite location and thereafter automatically generating the respective composite electronic file including at least one component pointer associated with the at least one component electronic file in the respective composite location.

37. A method according to claim 36 further comprising providing a master electronic file before providing the at least one component electronic file, wherein the master electronic file comprises at least one composite pointer associated with the at least one composite location, wherein accessing the at least one composite location comprises accessing the at least one composite location via the at least one composite pointer of the master electronic file.

38. A method according to claim 36, wherein providing the at least one component electronic file comprises transferring the at least one component electronic file into the at least one composite location.

39. A method according to claim 36, wherein generating the composite electronic file comprises generating the composite electronic file in a hypertext markup language including at least one hypertext link associated with the at least one component pointer such that the user is capable of locating and accessing the at least one component electronic file.

40. A method according to claim 36, wherein generating the composite electronic file comprises generating the composite electronic file in an extensible markup language including at least one interactive link associated with the at least one pointer such that the user is capable of locating and accessing the at least one component electronic file.

41. A method according to claim 36, wherein when the at least one component file is removed from the at least one composite location the respective composite electronic file is generated independent of the respective component pointer associated with the respective component electronic file.

42. A system for generating at least one composite electronic file comprising: a first processing unit comprising at least one composite location capable of storing at least one component electronic file; and a second processing unit capable of accessing the at least one composite location, wherein said first processing unit is capable of automatically generating the at least one composite electronic file when the respective composite location is accessed, wherein the at least one composite electronic file includes at least one component pointer that is associated with the at least one component electronic file in the respective composite location, and wherein said second processing unit is capable of displaying the composite electronic file on a graphical user interface (GUI) such that a user is capable of accessing the at least one component electronic file via the GUI based upon the at least one component pointer.

43. A system according to claim 42, wherein said first processing unit is further capable of receiving the at least one component electronic file, and wherein said first processing unit receives the at least one component electronic file into the at least one composite location.

44. A system according to claim 42, wherein said first processing unit is capable of generating the composite electronic file in a hypertext markup language including at least one hypertext link associated with the at least one component pointer such that the user is capable of locating and accessing the at least one component electronic file.

45. A system according to claim 42, wherein said first processing unit is capable of generating the composite electronic file in an extensible markup language including at least one interactive link associated with the at least one component pointer such that the user is capable of locating and accessing the at least one component electronic file.

46. A system according to claim 42, wherein said first processing unit further comprises a master electronic file, wherein the master electronic file comprises at least one composite pointer associated with the at least one composite location, wherein said second processing unit is capable of accessing the at least one composite location based on the at least one composite pointer.

47. A system according to claim 46, wherein the master electronic file is in a hypertext markup language format including at least one hypertext link associated with the at least one composite pointer such that the user is capable of locating and accessing the at least one composite location.

48. A system according to claim 46, wherein the master electronic file is in an extensible markup language format including at least one interactive link associated with the at least one composite pointer such that the user is capable of locating and accessing the at least one composite location.

49. A system according to claim 42, wherein when the at least one component electronic file is removed from the at least one composite location said first processing unit generates the respective composite electronic file independent of the respective component pointer associated with the respective component electronic file.

50. A system according to claim 42, further comprising a remote processing unit, wherein said remote processing unit comprises at least one composite location capable of storing the at least one component electronic file.

51. A system according to claim 50, wherein said remote processing unit is further capable of receiving the at least one component electronic file, and wherein said remote processing unit receives the at least one component electronic file into the at least one composite location.

52. A computer program product for generating at least one composite electronic file, the computer program product comprising a computer-readable storage medium having computer-readable program code embodied in said medium, the computer-readable program code comprising: a first executable portion for storing at least one component electronic file in least one composite location; a second executable portion for accessing the at least one composite location; a third executable portion for automatically generating the at least one composite electronic file once the at least one composite location is accessed, wherein the at least one composite electronic file includes at least one component pointer associated with the at least one component electronic file in the at least one composite location; and a fourth executable portion for formatting the composite electronic file such that the composite electronic file including the at least one component pointer is capable of being displayed on a graphical user interface (GUI), wherein the at least one component electronic file is accessible via the GUI based upon the respective component pointer.

53. A computer program product according to claim 52, wherein said forth executable portion formats the composite electronic file in a hypertext markup language including at least one hypertext link associated with the at least one component pointer such that the user is capable of locating and accessing the at least one component electronic file.

54. A computer program product according to claim 52, wherein said fourth executable portion formats the composite electronic file in an extensible markup language including at least one interactive link associated with the at least one component pointer such that the user is capable of locating and accessing the at least one modified component electronic file.

55. A computer program product according to claim 52 further comprising a fifth executable portion for storing a master electronic file, wherein the master electronic file includes at least one composite pointer associated with the at least one composite location, wherein the master electronic file is capable of being displayed on the GUI, and wherein the at least one composite location is accessible via the GUI based upon the respective composite pointer.

56. A computer program product according to claim 55, wherein the master electronic file is in a hypertext markup language format including at least one hypertext link associated with the at least one composite pointer such that the user is capable of locating and accessing the at least one composite location.

57. A computer program product according to claim 55, wherein the master electronic file is in an extensible markup language format including at least one interactive link associated with the at least one composite pointer such that the user is capable of locating and accessing the at least one composite location.

58. A computer program product according to claim 52, wherein when the at least one component electronic file is removed from the composite location said third executable portion generates the respective composite electronic file independent of the respective component pointer.