US20120239448A1

US20120239448A1 - Apparatus and method for transportation and upselling of product

Info

Publication number: US20120239448A1
Application number: US13/483,137
Authority: US
Inventors: Richard B. BETTES; Stephen E. JAFFE; Bret R. SANDERFUR; Matthew B. TREVATHAN
Original assignee: International Business Machines Corp
Current assignee: Kyndryl Inc
Priority date: 2006-12-21
Filing date: 2012-05-30
Publication date: 2012-09-20
Also published as: US8595150B2; US8744865B2; US20120239460A1; US20080154659A1; US8554570B2; US20140019376A1; US20120239447A1

Abstract

A system and method for using product profiling to maximize load capacity of a vehicle. The method includes defining product profiles and retrieving product information associated with the product profiles. The method further includes performing cubing operations for products associated with the product information. The system includes components to perform the method steps.

Description

CROSS REFERENCE TO RELATED APPLICATIONS

The present application is a divisional application of co-pending U.S. application Ser. No. 11/614,782, filed on Dec. 21, 2006, the contents of which are incorporated by reference in its entirety herein.

FIELD OF THE INVENTION

The invention generally relates to a system and method of using product profiling for the efficient transportation and upselling of product and, more particularly, to a system and method of using product profiling to maximize transportation capacity while meeting other business objectives, e.g., profitability.

BACKGROUND OF THE INVENTION

It is industry practice for domestic and international shipping and freight (transportation) companies to utilize methods for maximizing the amount of product (load) that can be loaded into a transportation vehicle such as, for example, a truck, an airplane, a train, a shipping container or other means of transportation. This allows the transportation companies to maximize profits by ensuring that the maximum amount of product is placed in the truck, airplane, train, etc. for transportation from one location to another location.
To maximize the load that can be transported, transportation companies use complex algorithms such as, for example, cubing algorithms, to ensure that all available space in the vehicle is used to its maximum capacity. In its simplest form, cubing is the act of placing smaller cubes (e.g., packages) into a large cube (e.g., a container for transport) in order to best fit all the cubes into the larger cube. Since packages can vary in size, a number of algorithms are known to be employed to create a best fit within the transportation space (larger cube), all of which are limited to the volume, dimensions and weight of the packages. Presently, cubing operations do not taken into account, nor are they concerned with the actual product and associated costs of manufacturing, sales data, etc. of the product or other business considerations, since such information is directly related to maximizing the transportation load in the vehicle.
Since most cubing applications center around the transportation industry, the amount of product to be transported is a function of the limitations of capacity of the transportation vehicle such as, for example, a truck. Thus, the cubing algorithms take into account the volume and dimensions of the packages, in addition to the mass of the packages. For example, cubing algorithms take into account the weight to volume ratio of the freight. This allows for the calculation to take into account the absolute capacity of the vehicle which is used to transport the product.
Accordingly, there exists a need in the art to overcome the deficiencies and limitations described hereinabove.

SUMMARY OF THE INVENTION

In a first aspect of the invention a method comprises defining product profiles and retrieving product information associated with the product profiles. The method further includes performing cubing operations for products associated with the retrieved product information.
In another aspect of the invention, a method comprises retrieving rules for defining the products and providing a summary of the products which match the rules. The method further includes correcting a proportionality of the products and performing cubing operations for the products based on the calculated correct proportionality.
In yet another aspect of the invention, a method comprises performing a past time period shipment inventory and retrieving information for products associated with the past time period shipment inventory. A determination is made as to whether the retrieved information for products, are products that are still in existence. The products associated with the retrieved information are cubed for future shipment, when the products were not previously subject to cubing operations.
In a further aspect of the invention, a method for deploying an application using product profiling to maximize load capacity of a vehicle includes providing a computer infrastructure being operable to retrieve product profiles, retrieve product information associated with the product profiles, and perform cubing operations for products associated with the product information.
In another aspect of the invention, a system comprising at least one of a hardware and software component for maximizing load capacity of a vehicle using product profiling is provided. The at least one hardware and software component is configured to retrieve product profiles, retrieve product information associated with the product profiles, and perform cubing operations for products associated with the product information.
In a further aspect of the invention, a computer program product comprises a computer usable medium having readable program code embodied in the medium. The computer program product includes at least one component to provide the method steps of the invention. At least one component can also provide the functionality of the system of the invention.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 shows an illustrative environment for implementing the steps in accordance with the invention;

FIGS. 2 a and 2 b depict a flow chart of steps for implementing aspects of the invention; and

FIG. 3 depicts a flow chart of steps for implementing an alternative aspect of the invention.

DETAILED DESCRIPTION OF EMBODIMENTS OF THE INVENTION

The invention generally relates to a system and method of using product profiling to maximize load capacity of a vehicle and, more particularly, to a system and method using product profiling to maximize load capacity of a vehicle while meeting other business objectives, e.g., maximizing profitability. In an embodiment of the invention, the method and system is configured to leverage cubing methods while using product profiles such as, for example, seasonal product adjustments, customer profiling, historical profiles of product inventories, vehicle loads, profitability of products, ordering profiles, etc. The invention may be implemented for business objectives such as, for example, maximizing product profitability, decreasing product inventory, increasing or decreasing product manufacturing, etc. The invention is equally applicable to direct transporting of the product by the manufacturer, or through a third party distributor, or the aggregation of shipments by traditional carriers.
By implementing the system and method of the invention, it is possible to maximize product profitability while increasing transportation loads, decreasing inventory and/or “moving” product which creates the highest profitability returns. The invention is configured to be applicable in current web based transactions or other real time transactions, using cubing methods in combination with the product profiling.
FIG. 1 shows an illustrative environment 10 for managing the processes in accordance with the invention. To this extent, the processes described herein can be implemented over any distributed network or stand-alone server, for example. The environment 10 of FIG. 1 includes a computer infrastructure 12 that can perform the processes described herein. In particular, the computer infrastructure 12 includes a computing device 14 that comprises a management system 30, which makes computing device 14 operable to, for example, use product profiling with cubing operations in accordance with the invention, e.g., processes described herein. The computing device 14 includes a processor 20, a memory 22A, an input/output (I/O) interface 24, and a bus 26. Further, the computing device 14 is in communication with an external I/O device/resource 28 and a storage system 22B.
In general, the processor 20 executes computer program code, which is stored in memory 22A and/or storage system 22B. While executing computer program code, the processor 20 can read and/or write data to/from memory 22A, storage system 22B, and/or I/O interface 24. The bus 26 provides a communications link between each of the components in the computing device 14. The I/O device 28 can comprise any device that enables an individual to interact with the computing device 14 or any device that enables the computing device 14 to communicate with one or more other computing devices using any type of communications link.
The computing device 14 can comprise any general purpose computing article of manufacture capable of executing computer program code installed thereon (e.g., a personal computer, server, handheld device, etc.). However, it is understood that the computing device 14 is only representative of various possible equivalent computing devices that may perform the processes described herein. To this extent, in embodiments, the functionality provided by computing device 14 can be implemented by a computing article of manufacture that includes any combination of general and/or specific purpose hardware and/or computer program code. In each embodiment, the program code and hardware can be created using standard programming and engineering techniques, respectively.
Similarly, the computer infrastructure 12 is only illustrative of various types of computer infrastructures for implementing the invention. For example, in embodiments, the computer infrastructure 12 comprises two or more computing devices (e.g., a server cluster) that communicate over any type of communications link, such as a network, a shared memory, or the like, to perform the process described herein. Further, while performing the process(es) described herein, one or more computing devices in the computer infrastructure 12 can communicate with one or more other computing devices external to computer infrastructure 12 using any type of communications link. The communications link can comprise any combination of wired and/or wireless links; any combination of one or more types of networks (e.g., the Internet, a wide area network, a local area network, a virtual private network, etc.); and/or utilize any combination of transmission techniques and protocols. As discussed herein, the management system 30 enables the computer infrastructure 12 to, for example, use product profiling with cubing operations.
In embodiments, the invention provides a business method that performs the process steps of the invention on a subscription, advertising, and/or fee basis. That is, a service provider, such as a Solution Integrator, could offer to perform the processes described herein. In this case, the service provider can create, maintain, deploy and support, etc., a computer infrastructure that performs the process steps of the invention for one or more customers. In return, the service provider can receive payment from the customer(s) under a subscription and/or fee agreement and/or the service provider can receive payment from the sale of advertising content to one or more third parties.
FIGS. 2 a and 2 b show a flow diagram implementing steps of the invention which may be implemented in the environment of FIG. 1. FIGS. 2 a and 2 b (and FIG. 3) may equally represent a high-level block diagram of the invention. The steps of FIGS. 2 a and 2 b are directed to a vehicle configuration for top selling product (items). In the flow of FIGS. 2 a and 2 b, the processes determine the top selling product, based on various criteria, e.g., product profiles, which will then be subject to cubing methodologies to ensure that the vehicle is filled to its capacity. In this manner, the invention is configured to most efficiently utilize the available space in a vehicle with particular product.
The steps of FIGS. 2 a and 2 b (and FIG. 3) may be implemented and executed from either a server, in a client server relationship, or they may run on a user workstation with operative information conveyed to the user workstation to automatically resolve calendar events. Additionally, the invention can take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment containing both hardware and software elements.
In an embodiment, the steps of FIGS. 2 a and 2 b (and FIG. 3) may be implemented in software, which includes but is not limited to firmware, resident software, microcode, etc. Furthermore, the invention can take the form of a computer program product accessible from a computer-usable or computer-readable medium providing program code for use by or in connection with a computer or any instruction execution system. The software and/or computer program product can be implemented in the environment of FIG. 1, as should be understood and capable of implementation by those of skill in the art. For the purposes of this description, a computer-usable or computer readable medium can be any apparatus that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. The medium can be an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system (or apparatus or device) or a propagation medium. Examples of a computer-readable medium include a semiconductor or solid state memory, magnetic tape, a removable computer diskette, a random access memory (RAM), a read-only memory (ROM), a rigid magnetic disk and an optical disk. Current examples of optical disks include compact disk-read only memory (CD-ROM), compact disk-read/write (CD-R/W) and DVD.
Referring back to FIGS. 2 a and 2 b, at step 200, the process locates top selling products. Top selling products may be defined as, for example, most profitable products, best selling products, etc. At step 202, the process retrieves rules which will be applied in subsequent steps. The rules may be machine generated or provided by the user. The rules may be, for example, a descriptor used for finding certain product. For example, the rules may be the five top selling products sold over the previous 12 months or the product that has remained in inventory for the longest time over the past 12 months, or other scenarios as determined by the user's needs and requirements. Thus, the rules may be any rule which is applicable for a given situation for later product retrieval. The results may be provided on a percentage or other statistical basis. The information associated with the rules may be gathered from historical product information stored, for example, in a database.
At step 204, a summary is provided of the products (also known as items) which match the rules (product profile). This summary information may be retrieved from a database or calculated and stored in volatile memory. The summary may include information about the products, including the amount of such product in inventory, the length of time the products were in inventory, or other statistical information maintained in the database. In one embodiment, the information is presented in a percentage format, as discussed in greater detail below.
At step 206, the products are sorted by one or combination of various methodologies. For example, the products may be sorted in ascending order or other ranking, depending on the specific user request. By way of illustrative example, the product may be sorted by proportional volume to other product. Illustratively, product “X” may be ranked higher than product “Y” if product “X” is 75% of the volume of the load and product “Y” is 15% of the volume of the load. An example can easily be implemented for weight, number of product, etc.
At optional step 208, a break point is created by the processes of the invention. The break point can be machine generated or input manually by a user. The break point will ensure that the load capacity of the vehicle is most efficiently used by eliminating product(s), for example, that do not fall within a certain percentage sales category. For example, the system and method of the invention may require any product which accounts for less than a certain percentage of sales, e.g., 3% or less, to be excluded from the shipment, even though the product met the rules set forth in step 202. This, in one implementation, will eliminate a skewed proportion of product from being loaded into a vehicle. By way of illustration, any product that is lower than 3% (or other predetermined amount) of sales will not be loaded into the vehicle thus allowing more product that accounts for a higher percentage of sales, e.g., 25% of sales, to be loaded into the vehicle.
Another example may be based on the percentage of profitability of product. For example, the break point may designate that any product which has a profitability of less than 3% (or other predetermined amount) be excluded from the shipment. In this way, more product with a higher profitability can be loaded into the vehicle for shipment. This, by virtue of including more product with higher profitability, will maximize the profitability of the shipment.
At step 210, the sum of all the percentages of all of the retrieved product is calculated. The sum of all percentages of the product can be calculated by the following equation:
P ₁ +P ₂ +P ₃ +P _{4 . . .}=sum of all product.
It is noted that the sum of all product may also be represented numerically as:
$\sum_{n > 0}^{X \geq top} P (x)$
where,
n=the position in the array (in the example above the array includes P₁-P₅);
n>0; and
x is greater than or equal to top, defined as the highest position in the array.
At step 212, the process determines the correct proportionality of the selected product as if the vehicle was filled to capacity (e.g., 100%). In one example, the following equation may be used to correct the proportionality of the selected product:
$P (n) / (\sum_{n > 0}^{X \geq top} P (x))$
where,
P=product;
n=the position in the array (in the example above the array includes P₁-P₅);
n>0; and
x is greater than or equal to top, defined as the highest position in the array.
At step 214, a cubing method is performed using the product obtained in the previous steps. By way of example, at step 216, a determination is made as to whether there is additional space in the vehicle. If not, then the process ends at step 218. If there is additional space, at step 220, a determination is made as to whether the weight limit is equal to or exceeds the maximum allowable weight for the vehicle. If the weight limit is equal to or exceeds the maximum allowable weight, at step 222, a determination is made as to whether the weight limit has been exceeded. It should be understood that steps 220 and 222 can be combined into a single step. If the weight limit has not been exceeded, then the process ends at step 218. If the weight limit has been exceeded, at step 224, product is removed until the weight limit is not exceeded. At step 226, the process ends.
In one embodiment, if the weight limit has been exceeded certain product is removed in an attempt to be as close as possible to the maximum allowable weight of the vehicle. In one embodiment, the product is removed based on its ranking. For example, the product with the least profitability would be removed prior to a product with a greater profitability. Also, other removal schemes are contemplated by the invention such as, for example, removing product that has the least sales potential or profitability relative to its size and aggregate.
If the maximum allowable weight has not been reached, at step 228, the process will determine the remaining available space in the vehicle. At step 230, product will be added to the vehicle based on the results of the cubing operation. At step 232, a determination will be made to determine if the product fits in the vehicle, and if not, the process proceeds to step 234. At step 234, the process finds the next smallest product and then returns to step 230 for further cubing operations. If the product does fit, at step 236, the process ends.
In an embodiment, weight cubing estimation and/or volume cubing estimation may be implemented with the invention. Accordingly, the user may select the weight cubing estimation and/or volume cubing estimation, both of which provide an estimation point for the beginning of cubing operations. The weight cubing estimation workflow may be calculated as follows:
(Total weight capacity of vehicle)(% of vehicle to fill)=total weight to fill for product.
The total weight to fill for product/weight of product=number of product to fill.
The volume cubing estimation workflow may be calculate as follows:
(Total volume capacity of vehicle)(% of vehicle to fill)=total volume to fill for product.
The total volume to fill for product/volume of product=number of product to fill.
FIG. 3 shows another flow of steps in accordance with another embodiment of the invention. The flow of FIG. 3 illustrates one example of using past seasonal data (or data from other time periods) for preparing a list of products to be loaded into a vehicle such as, for example, a truck, shipping container, etc. In this implementation, as a vehicle with products is purchased, a list of the products to be loaded on the vehicle is stored in a profiling system with a vehicle type ID identifying the vehicle, the date the products (e.g., also referred to as a vehicle) was ordered, each product in the vehicle, the maximum volume and weight for the vehicle, a number of times the vehicle type has been purchased, and/or the customer that purchased the vehicle (product in the vehicle).
By way of discussion, at step 300, the process performs a past season (or data from other time periods) shipment inventory. The past season shipment inventory may be considered a rule (or product profile). The past season shipment inventory may include, for example, determining which shipment (e.g., truckload, container) included product that was most profitable. At step 302, the process retrieves the information associated with the previous season or other time periods. This information may be retrieved from a database which stores such information or calculated from a population of historic shipments.
At step 304, a determination is made as to whether the retrieved product still exists (e.g., is in inventory or manufactured). If the product still exists, the product will remain on the list for future shipping, at step 306. At step 308, if the product does not exist, a determination is made as to whether there is a replacement product. If there is a replacement product, then the replacement product is placed on the list at step 310.
If there is no replacement product, then the process continues to step 312. At step 312, if there is no replacement product, then a determination is made as to whether there is another product that is a “hot” product. A “hot” product may be a product with a profitability above a certain threshold, a product that has sales above a certain threshold, etc. If there is a “hot” product, then the “hot” product will be placed on the list at step 314.
Stemming from steps 306, 310 and 314, a determination is made as to whether all of the products are on the list (step 316). If all of the products are not on the list, then the process returns to step 304. If all of the products are on the list, a determination is made as to whether all of the products on the list were loaded onto a vehicle (single vehicle) in the past (step 318). If all of the products are existing product and were previously loaded into a vehicle, then the process ends at step 320. At step 320, the list is stored in a database, flat file, etc. for future retrieval or stored in volatile memory for further processing. In this scenario, cubing of the existing products is not necessary since such cubing operations were previously performed for the past vehicle load.
If all of the products are not from a past vehicle load, the process continues to step 322, where cubing operations are performed. The cubing operations may include, for example, those previously described with reference to FIGS. 2 a and 2 b, including, for example, step 214, etc. Once cubing operations are complete, the process ends at step 320, where the list is stored for future retrieval.
It should be understood that other steps of FIG. 3 may be intermingled with the processes of FIGS. 2 a and 2 b. By way of example, the retrieval of the product information from a previous time period (step 302) may be for the top selling product (step 200) or may be obtained from rules retrieved at step 202. Additionally, the products sold in previous time periods may be sorted (step 208), or a break point may be applied to these products, as well (step 208). In the case that the products are replacement products or other “hot” products, the invention contemplates that steps 210 and 212 may be utilized in order to correct the proportionality of the shipment.

Example of Use

As an illustrative example, using the flow of FIGS. 2 a and 2 b, a user requests the five top selling product (step 202). Using this example, the process retrieves P₁, P₂, P₃, P₄and P₅(step 204) and summarizes and sorts the products based on a ranking, e.g., highest percentage (step 206, step 208). More specifically, as an example, P₁is 30%, P₂is 10%, P₃is 7%, P₄is 5% and P₅is 4%. The process sums the product to obtain 56% (step 210). In this example, there is no break point.
To correct the proportionality of the product to fill the vehicle to 100%, the process applies the following equation:
$P (n) / (\sum_{n > 0}^{X \geq top} P (x))$
Using the above equation, the correct proportionality of the product, P₁would be approximately 54%, P₂would be approximately 18%, P₃would be approximately 13%, P₂would be approximately 9%, P₅would be approximately 6%. The system and method can then perform cubing operations, allocating the volume of the vehicle in accordance with the above percentages.
While the invention has been described in terms of embodiments, those skilled in the art will recognize that the invention can be practiced with modifications and in the spirit and scope of the appended claims.

Claims

1. A method comprising:

performing a past time period shipment inventory;

retrieving, by a processor, information for products associated with the past time period shipment inventory;

determining that the retrieved information is for products still in existence; and

cubing the products associated with the retrieved information for future shipment, when the products were not previously subject to cubing operations.

2. The method of claim 1, wherein:

when the products are still in existence, the products remain on a list for the future shipping; and

when the products are not in existence, replacement products are placed on the list for the future shipping.

3. The method of claim 2, further comprising placing new products on the list for future shipment when the replacement products are not in existence.

4. The method of claim 3, wherein the new products have a profitability or sales over a threshold amount.

5. The method of claim 3, further comprising:

preparing a list of product to be loaded for future shipment;

storing the list in a profiling system with a vehicle type ID identifying the vehicle, a date the products were ordered, each product in the vehicle, a maximum volume and weight for the vehicle, a number of times a vehicle type has been purchased, and a customer that purchased the products to be loaded into the vehicle.

6. A computer program product comprising a computer usable storage medium having readable program code embodied in the storage medium, the computer program product includes at least one component operable to:

perform a past time period shipment inventory, the shipment inventory including determining which shipment included product that was most profitable;

retrieve information for products associated with the past time period shipment inventory;

determine that the retrieved information is for products still in existence; and

cube the products associated with the retrieved information for future shipment, when the products were not previously subject to cubing operations.

7. The computer program product of claim 6, wherein:

8. The computer program product of claim 7, wherein the at least one component is further operable to place new products on the list for future shipment when the replacement products are not in existence.

9. The computer program product of claim 8, wherein the new products have a profitability or sales over a threshold amount.

10. The computer program product of claim 9, wherein the at least one component is further operable to:

prepare a list of product to be loaded for future shipment;

store the list in a profiling system with a vehicle type ID identifying the vehicle, a date the products were ordered, each product in the vehicle, a maximum volume and weight for the vehicle, a number of times a vehicle type has been purchased, and a customer that purchased the products to be loaded into the vehicle.