US 6266655 B1 Abstract A method of valuing resources of an asset intensive manufacturer. Calculations provide a MAV for each resource (machine) for each time horizon. The inputs for the calculations include the prices of products made by the resource, probalistic demand for the products, usage of the resource by various products, and availability of the resource. A series of equations, one equation associated with each resource, is formulated and solved, using lagrangian methods, with lagrangian multipliers representing resource values.
Claims(31) 1. A computer-implemented method of valuing resources used in the manufacture of one or more products, comprising:
modeling the manufacturing process in terms of at least one time period, at least one resource, and one or more products;
providing a usage value for each product per resource;
providing an availability value for each resource;
providing a profit value for each product;
providing an allocation value for each product;
generating a demand function for the products;
generating a value equation for each resource based on the usage value, the availability value, the profit value, the allocation value, and the demand function;
solving the value equations to determine a resource value for each resource using a Lagrangian process, each equation being expressed with a multiplier that represents the resource value for the corresponding resource; and
making the resource values available for use in connection with a manufacturing process.
2. The method of claim
1, wherein the demand function is based on a truncated normal distribution.3. The method of claim
1, wherein the profit values arc prorated for each product on each resource.4. The method of claim
1, further comprising: generating a revenue function for each product based on the allocation value, the profit value, and the demand function; and solving the revenue function for expected revenue of the product.5. The method of claim
1, wherein solving comprises iteratively setting initial values of the Lagrange multiplier and converging to new Lagrange multiplier values.6. The method of claim
1, wherein solving is performed using a binary tree.7. The method of claim
1, further comprising providing the resource values to a scheduling engine.8. The method of claim
1, wherein solving comprises formulating a set of Lagrange equations from the value equations, each Lagrange equation having a multiplier as the single unknown variable.9. The method of claim
8, wherein each Lagrangian equation is a sum of terms, each term associated with a usage value minus the availability value.10. A computer-implemented system for valuing resources used in the manufacture of one or more products, comprising:
memory that stores a model of the manufacturing process in terms of at least one time period, at least one resource, and one or more products;
memory that stores a usage value for each product per resource, an availability value for each resource, a profit value for each product, and an allocation value for each product;
a process for generating a demand function for the products; and
a valuation engine for generating a value equation for each resource based on the usage value, the availability value, the profit value, the allocation value, and the demand function, the valuation engine operable to:
solve the value equations to determine a resource value for each resource using a Lagrangian process, each equation being expressed with a multiplier that represents the resource value for the corresponding resource; and
make the resource values available for use in connection with a manufacturing process.
11. The system of claim
10, further comprising a demand forecast tool for providing demand data to the valuation engine.12. The system of claim
10, further comprising a pricing tool for providing product price data to the valuation engine.13. The system of claim
10, wherein the valuation engine further calculates expected revenue, using the allocation values, the profit values, and the demand function.14. The system of claim
10, further comprising a scheduling engine for generating manufacturing schedules based on the resource values.15. The system of claim
10, further comprising a master planning engine for determining product prices based on the resource values.16. A computer-implemented method of valuing a resource used in the manufacture of one or more products, comprising:
modeling the manufacturing process in terms of at least one time period, the resource, and one or more products to be manufactured using the resource;
generating a value equation for the resource based on information concerning usage of the resource by the products, information concerning the availability of the resource, information concerning profits associated with the products, information concerning allocation of the products, and one or more demand functions associated with the products, the value equation including a multiplier that represents a resource value of the resource;
solving the value equation to determine the resource value; and
making the resource value available for use in connection with a manufacturing process.
17. The method of claim
16, wherein the demand function is based on a truncated normal distribution.18. The method of claim
16, wherein the information concerning profits associated with the products comprises profit values that are prorated for each product for the resource.19. The method of claim
16, further comprising:generating a revenue function for each product based on the allocation information, the profit information, and the demand function; and
solving the revenue function for expected revenue of the product.
20. The method of claim
16, wherein solving is performed using a binary tree.21. The method of claim
16, further comprising providing the resource value to a scheduling, engine.22. The method of claim
16, wherein the value equation is solved using a Lagrangian process.23. The method of claim
22, wherein solving comprises iteratively setting an initial value of a Lagrange multiplier and converging to a new Lagrange multiplier value.24. A computer-implemented system for valuing a resources used in the manufacture of one or more products, comprising:
a process operable to generate a demand function for one or more products; and
a valuation engine operable to:
generate a value equation for the resource based on information concerning usage of the resource by the products, information concerning the availability of the resource, information concerning profits associated with the products, information concerning allocation of the products, and one or more demand functions associated with the products, the value equation including a multiplier that represents a value of the resource;
solve the value equation to determine the resource value; and
make the resource value available for use in connection with a manufacturing process.
25. The system of claim
24, wherein the valuation engine solves the value equation using, a Lagrangian process.26. The system of claim
24, further comprising a demand forecast tool for providing demand data to the valuation engine.27. The system of claim
24, further comprising a pricing tool for providing product price data to the valuation engine.28. The system of claim
24, wherein the valuation engine further calculates expected revenue, using, the allocation information, the profit information, and the demand function.29. The system of claim
24, further comprising, a scheduling engine for generating manufacturing schedules based on the values of the resources.30. The system of claim
24, further comprising a master planning engine for determining, product prices based on the values of the resources.31. Resource valuation software embodied on a computer-readable medium and, when executed by a computer, operable to:
generate a value equation for a resource based on information concerning usage of the resource in the manufacture of one or more products, information concerning the availability of the resource, information concerning profits associated with the products, information concerning allocation of the products, and one or more demand functions associated with the products, the value equation including a multiplier that represents a value of the resource; and
solve the value equation to determine the value of the resource.
Description This application claims the benefit of U.S. provisional application No. 60/093,709, filed Jul. 22, 1998, and entitled “Computer Implemented Method and System for Value Management Problem Formulation for an Asset Intensive (AI) Manufacturer”. This invention relates to computer-implemented enterprise management tools, and more particularly to a computer-implemented method of calculating resource values for an asset intensive manufacturer. One of the unique challenges of any manufacturing enterprise is valuation of its products and resources. In the case of product valuation, traditionally, prices are computed on the basis of a cost-plus measure and some measure of the ability of the customer to pay. Resources are conventionally valued in terms of prices paid for them, for example, the price paid for a machine used to make products. In recent years, computer-implemented enterprise management tools have been developed to assist in management decisions. These tools often include pricing tools, intended to assist in the valuation process. Notable among product pricing tools are those especially developed for airlines. These tools are not necessarily suitable for manufacturers. For example, material intensive manufacturers have limited materials (components) rather than capacity. In contrast, asset intensive manufacturers have limited resource capacity and demand may be serviced before desired. In both cases, probabilistic demand is not in a particular order for different prices, as is the case with airline travel. One aspect of the invention is a method of valuing resources used to manufacture products. The method is especially useful for asset intensive manufacturers, who have limited capacity on their resources. The manufacturing process is modeled in terms of time periods, resources used during each time period, and products made by the resources. From this information, a usage value for each product per resource and an availability value for each resource can be determined. Additional input data parameters are the profit and allocation for each product. A probabilistic demand function is used to represent expected demand for each product. Given these values and the demand function, a value equation is formulated for each resource. Each value equation is expressed as a agrangian equation having a lagrange multiplier that represents the resource value. The equations are then solved for the lagrange multiplier to obtain a value for each resource. FIG. 1 illustrates how time periods, products, and resources of an asset intensive manufacturer are modeled for purposes of the invention. FIG. 2 illustrates an example of time periods, products, and resources of an asset intensive manufacturer. FIG. 3 illustrates additional problem data for the example of FIG. FIG. 4 illustrates how MAV equations are set up and solved. FIG. 5 illustrates the MAV equations for the example of FIG. FIG. 6 illustrates the solutions of the MAV equations of FIG. FIG. 7 illustrates the solution to the example problem in terms of allocations and expected revenues. FIGS. 8A and 8B illustrate Q and Q FIG. 9 illustrates how a MAV calculation engine may be integrated into a larger product planning and scheduling system. The following description is directed to a computer-implemented tool that implements a “value management” (VM) pricing method. The tool is designed especially for use by asset intensive manufacturers. U.S. Pending patent application Ser. No. 09/195,332, entitled “Computer-Implemented Product Valuation Tool”, filed Nov. 18, 1998, describes value management in general, and the concept of MAVs (minimum acceptable values). It further describes how MAVs may be differently calculated depending on the type of enterprise and its primary manufacturing constraints. For example, certain manufacturers, such as those that make high tech computer equipment, may be primarily constrained by availability and price of components. Other manufacturers may be primarily constrained by varying lead times. Still other manufacturers are make-to-order manufacturers, who are set up for low inventories and lead times. U.S. Pending patent Ser. No. 09/195,332 describes MAV calculations for each of these types of manufacturers, and is incorporated by reference herein. Value management applied to asset intensive manufacturers requires special considerations. Asset intensive manufacturing is characterized by limited capacity. Demand may be serviced before desired. Demand is not in any particular order for different price ranges, unless a premium is charged for shorter lead times or a discount is given for longer lead times. An example of an asset intensive manufacturing is steel manufacturing. A primary constraint is machine capacity, as opposed to availability of raw materials. If demand is high, production is most likely to be limited by insufficient machine capacity rather than by other constraints. Value management for asset intensive manufacturing is based on the following principle: Based on future uncertain demand for various products, expected prices for those products, and available capacities of resources during periods required to supply demand when demanded, a value for each resource during those periods can be calculated. The calculation results in threshold prices, referred to as minimum acceptable values (MAVs) for a given demand period. For an asset intensive manufacturer, the MAV of a resource monotonically deceases with increase in availability. As machine usage increases, each consumed unit is more expensive (assuming limited availability). FIG. 1 illustrates time intervals (t0,t1) . . . (tn−1, tn) for which MAVs are to be computed. These intervals may represent seasons in which demands and/or prices for products are significantly different from those in other time intervals, even though the products may be the same. For simplification of example herein, it is assumed that the time intervals are the same for all products, but in practice that may not be the case. Three resources are designated as R Pertinent to the manufacturing scenario of FIG. 1 is that the actual demand on the resources by the products takes place in time periods earlier than the period of demand. The demand could be much earlier for some resources, depending on the lead time. Many manufacturing enterprises use computer-implemented models and schedulers to map the product demand in a time period to the appropriate time period of usage of a resource. As indicated above, solving the valuation problem involves determining the value of each resource (machine). It should be noted that a physical item demanded in one time period is considered as a separate product from the same item demanded in another time period. The prices for these same items in different time periods may also be different. Similarly, a resource in one time period is different from the same resource in another time period. Let there be Np products denoted by P S S U a T s c y f Pr(x≧a)=probability that random variable x is greater than or equal to a v V V=total expected value from sale of all products An example of a suitable allocation is a discrete allocation, such as determined by available-to-promise calculations. The resource valuation problem may be mathematically stated as: Equation (1) states that the total time (capacity) consumed by all products using a resource equals the available time (capacity) on that resource. It may be more appropriate to have an inequality (≦), but dummy products can always be defined with zero value to pick up the slack so that equality is as general as an inequality. However, negative slack should not be allowed. If overbooking is used, the capacity used will be the overbooked capacity. The Lagrangian of the above-stated problem is: where the λ's are the Lagrange multipliers, one for each equality constraint in Equation (1). The necessary conditions (from calculus) are: where Equation (5) is a restatement of the equality constraints in Equation (1). There are (N From Equation (2): In deriving Equation (6), the result has been repeatedly used from calculus that helps differentiate integrals whose limits may also be (along with the integrand) a function of the variable with respect to which the differentiation is being carried out. The demand for products can be modeled as one of various known distributions, such as normal or poisson. Whatever the model, it is assumed that the probability term in Equation (6) is defined as a function by G(a) (it is nothing but the complement of the cumulative distribution function (CDF)). More precisely: The inverse function is defined by G Substituting (7) in (5) results in: The following expression represents the total prorated value of product j on resource i: Using prorated values, Equation (8) can be rewritten as: where v Even if a product has a high profit per unit of product, if it has a high usage of a resource then its prorated value (per unit capacity of resource) on the resource is reduced. Thus, the system of equations can be solved iteratively by assuming some initial λ's, prorating the value of each product used by a resource and solving for the new λ until all the λ's converge. The λ's correspond to the Minimum Acceptable Value (MAV) for a resource. FIGS. 2-7 illustrate an example of calculating MAVs of resources of an asset intensive manufacturer. As indicated above, each resource is valued in terms of its usage. In the example of this description, MAVs are calculated as $/unit-capacity with the unit of capacity being one hour. The MAVs may then be used to allocate and value the products made from the resources. FIG. 2 illustrates a simple model of an asset intensive manufacturer. Products are defined in terms of machine usage, that is, which machines, how much time, and in what order. There are 2 resources (machines) R Products are different if demanded in different time periods. Thus, for example, P FIG. 3 illustrates additional problem data for the example of FIG. Probabilistic demand may be modeled in various ways. An example of a demand distribution is a truncated normal distribution, expressed mathematically as:
where N (μ, σ:x) is a normal distribution with mean, μ, and standard deviation, σ. Q(x) represents a normal distribution function.
A probability density function may be expressed for each product: f f f f f f f f f f The Lagrangian equations formulated above may now be specialized for the demand. Following the above example, the equations are specialized for truncated normal distributions. G(a) is a probability function, as described above in connection with Equation (7). Using Equation (7) we get: From Equation (12): A revenue function is used to calculate expected revenue. Given allocation a, truncated normal demand with mean μ, standard deviation σ, and value v, what is the revenue R? From Equation (6) set out above, where x is demand for a product:
where the limits of integration are from a to ∞. It follows that:
where the limits of integration are from 0 to a. After some manipulation:
where h(x)=xQ(x)−1/(2πe Each equation is now written in terms of one variable using prorated product prices. The prorated value of a product i on resource j may be expressed as:
where V FIG. 4 illustrates a method of setting up and solving the Lagrangian MAV equations. Each of the equations contains one variable, namely the corresponding λ for the resource. The system of equations is solved iteratively by assuming initial λ's (Step FIG. 5 illustrates the MAV equations, one for each resource. As noted above in connection with FIG. 2, although there are eight resources, two are not used. Thus, there are six MAV equations. Each is a sum of “resource usage terms” (U is a factor) minus an availability term (T is a factor). FIGS. 6 illustrates the solutions of the MAV equations of FIG. 5. A MAV has been calculated for each of the six resources. FIG. 7 illustrates allocations and expected revenues for the ten products made with the resources. A determination of whether the allocations are optimal can now be made. As indicated above, the MAV calculations provide a MAV for each resource (machine) for each time horizon. The inputs for the MAV calculations include the prices of products made by the resource, probalistic demand for the products, usage of the resource by various products, and availability of the resource. The output may also include a total expected revenue for the available manufacturing capacity by time horizon and by product. The relationship between MAV and allocation may be specifically expressed mathematically. For a normal distribution, an allocation equation may be expressed as: _{j}=μ_{j}+σ_{j}Q^{−1}(Q(−μ_{j}/σ_{j})1)
If the value of a product is equal to or less than the summation (v;) above, it has zero allocation. In other words, the summation is analogous to consumed opportunity cost and λ is the MAV for a resource. FIGS. 8A and 8B illustrate examples of Q and Q FIG. 9 illustrates how a resource valuation engine Once known, MAVs can be used with other control variables, such as ATP (available to promise) variables from ATP tool A scheduler The output of MAV calculation engine Data such as price and allocation may flow both in and out of valuation engine Although the present invention has been described in detail, it should be understood that various changes, substitutions, and alterations can be made hereto without departing from the spirit and scope of the invention as defined by the appended claims. Patent Citations
Non-Patent Citations
Referenced by
Classifications
Legal Events
Rotate |