The present invention is generally related to resource-planning methods used by manufacturing companies and other organizations. More specifically, the present invention includes a strategic resource planning method that accounts for uncertainties inherent in the forecasting process.
In the field of product manufacturing, the term assemble-to-order (ATO) refers to systems where products are not produced until the demand for the products becomes known.
Manufacture-to-stock (MTS) systems, on the other hand, base production on component availability. Unlike ATO manufacturing, MTS systems often produce products before the demand for those products has been determined.
Manufacturing companies typically prefer to use ATO manufacturing operations whenever possible. ATO allows manufacturers to minimize their component inventories. This reduces the amount of capital invested in components and reduces the risk that components will loose value or become obsolete before they are transformed and sold as products.
In ATO manufacturing operations, it is paramount for decision-makers to be able to accurately forecast production on a period-by-period basis. The absence of accurate forecasting means that makes the estimation of important quantities such as expected revenues and costs difficult and in some cases impossible.
Unfortunately, accurately forecasting production can be problematic. Product demand is necessarily an important factor in estimations of this type. At the same time, product demand is not, by itself, a sufficient basis for forecasting. This follows because production can (and often is) constrained by the availability of the components needed to assemble the products. As a result, there is always a chance that the demand for a product will not be met within a particular period. Typically, this means that customers are either turned away or that orders are delayed—the product is “back ordered.”
To accurately forecast production, manufactures must be able to compute expected production from stochastic demand data, component consumption data and component levels. In many cases, this computation will involve a plurality of product and component kinds, potentially numbering in the thousands or more.
In
The probability distribution of demand is illustrated by the concentric ellipses. Each ellipse is an iso-probability curve (i.e. the line connects (P1, P2) points of equal probability). It is clear that there is a nonzero chance that the demand for the product pair may fall in the infeasible region.
If demand falls in the infeasible region, actual production will be less than demand. Hence mean production will be less than mean demand. There is a need for systems that can accurately calculate the differences between mean demand and mean production. This is particularly true for manufacturing operations that involve large numbers of products or large numbers of components. It is also particularly true where the markets for products or the market for components are volatile.
An embodiment of the present invention includes a method for forecasting the mean production (the expected production) for a target planning period. To begin this method, a user, or planner chooses one or more products for which the expected production is desired.
The user then enters data describing each selected product. The data entered for each product includes data describing the demand for that product as well as data describing the components required for each product. Inter-product dependencies are also entered.
The expected production for each selected product for the target planning-period is expressed as a sum of multidimensional integrals involving the data entered in the previous two steps. Once formulated, the integrals are evaluated. The result of this computation is then presented to the user.
Stated differently, the present invention includes a method for the estimation of mean production for assemble-to-order manufacturing operations, the method comprising the steps of: specifying a product to be analyzed; entering data describing the components required to produce the specified product; formulating a sum of multidimensional integrals corresponding to the estimation of mean production for the specified product; and evaluating the sum of multidimensional integrals.
Other aspects and advantages of the present invention will become apparent from the following descriptions and accompanying drawings.
For a more complete understanding of the present invention and for further features and advantages, reference is now made to the following description taken in conjunction with the accompanying drawings, in which:
The preferred embodiments of the present invention and their advantages are best understood by referring to
Definitions
In
Overview of Method and Apparatus for Resource Plan Analysis Under Uncertainty
As shown in
In step 404 the user enters data describing each product selected in step 402. The data entered for each product includes data describing the demand for that product as well as data describing the components required for each product. Inter-product dependencies are also entered.
In step 406 the expected production for the target planning-period is expressed as a sum of multidimensional integrals involving the data entered in the previous two steps.
In step 408 the sum of integrals formulated in the previous step is evaluated. This evaluation may be performed using a range of different methods including Monte Carlo simulation and quadratures. It is preferable, however to use the method disclosed in the copending commonly owned application “Method And Apparatus For Multivariate Allocation Of Resources.” This method is particularly preferable in cases when Method 400 is being performed for large numbers of products or components. In these cases, other evaluation methods may be too slow or unstable.
In step 410 the result of the computation of step 408 is presented to the user.
Product Selection
In step 402, the user identifies the m products that will be analyzed.
Product and Component Data Specification
Step 404, where the user specifies the required data for the mean production calculation, can be further subdivided into the sequence of steps shown in
In the loop of steps 404-2 through 404-10 the following information is entered:
1) The type of components required to produce each product,
1) The number of each component required to produce each product (A),
1) The allocation of each component (d),
1) The mean demand for each product (μ),
1) The standard deviation of the demand for each product,
1) The correlation between each product and any other product.
Within this loop, each data item can be input manually by the user (see step 402-6) or retrieved from a user database (see step 402-8).
In the loop of steps 404-2 through 404-10, an m×n matrix A is created. The matrix A includes one column ai for each of the m products selected for analysis. Each column ai contains the bill of materials required to produce one product. Each of the n elements of a given ai specifies the quantity of a particular component required to produce the corresponding product.
The loop of steps 404-2 through 404-10 also generates a vector d. The vector d includes a total of n elements, one for each component. Each element within d specifies the available quantity of a corresponding component.
The loop of steps 404-2 through 404-10 also generates a vector d. The vector d includes a total of n elements, one for each component. Each element within d specifies the available quantity of a corresponding component.
The loop of steps 404-2 through 404-10 also generates a vector μ. The vector μ includes total of m elements, one for each product. Each element within μ specifies the mean demand for a corresponding product.
Once the data required for each product and component has been input, processing continues at step 404-12. In step 404-12, the product correlations (item 6 above) and demand standard deviations (item 4 above) input in the preceding loop are combined to create a covariance matrix Σ.
Formulation of Expected Production as a Sum of Multidimensional Integrals
In Step 406, the covariance matrix is used to formulate a sum of multidimensional integrals. This step (i.e., creation of the multidimensional integrals) can be further subdivided into the sequence of steps shown in
In step 406-2, a feasible region (denoted Ω) is defined. The feasible region Ω is defined to include all points where the demand for a product can be met with the current levels of the components needed to manufacture the product. To determine Ω, the matrix A and vector d generated in step 404 are used. Ω is defined as the space of those q vectors, for which the inequality d−Aq>0 holds, where q is a vector variable denoting the production of the products.
In step 406-4 a production policy is specified for the feasible region Ω. The production policy for a region is a function that relates production to demand. Within Ω, component availability d equals or exceeds demand. As a result, production is equivalent to demand within the feasible region Ω. For this reason, the production policy for Ω is set to q(x)=x reflecting the fact that production is capable of mirroring demand within Ω.
In step 406-6, an infeasible region (denoted
In step 406-8 a production policy for the infeasible region
A range of different production policies may be used in step 406-8. For the particular implementation being described, a production policy known as the uniform production policy is used. The uniform production policy relates production q to demand x within the infeasible region
This formulation of α(x) ensures that, for any xε
In step 406-10 the expected or mean production
where f(x, μ, Σ) is the multivariate normal density function with mean μ and covariance matrix Σ.
Evaluation of Multidimensional Integrals
In step 408 the sum of the integrals, which were formulated in the previous step, is evaluated to compute the expected or mean production
The Case of Single Component Constraints
In this section we demonstrate the essentials of the technique by first describing the case, when there is a constraint only for a single component. In this case the feasible region Ω is defined by the constraint equation d−a·μ−b·z=0, where b=T′a, and d is a scalar number, describing the single constraint.
After the Cholesky transformation the next step is to perform an orthogonal rotation R, which transforms the vector b to point along a unit vector of the new system, say e1: Rb=|b|e1, where |b| is the magnitude of vector b. After the rotation the new variables will be denoted by w: w=Rz. Because of the orthonormality of R the covariance matrix of w will still be the identity matrix. An advantage of this rotation is that the hyperplane, defining the feasible region Ω is now perpendicular to only one axis, defined by e1, and it is parallel to all the other axis of the rotated coordinate system. Therefore the n dimensional integral, confined by a generic hyperplane, is transformed into an integral, which is confined along a single axis, and is unconfined in the other n−1 directions. The unconfined integrals are straightforward to execute and we are left with a singlevariate integral, which is much easier to perform. In mathematical form the integral of some function h(x) over the feasible region can be written as:
Here h″ (w) is the generic function h(x) after the Cholesky transformation T and the rotation R, wn−1=(w2, . . . , wn), and is the (n−1) dimensional space of real numbers. Finally U=(d−aμ)/|b|, identifying the intersection of the hyperplane and the e1 axis.
In the special case of h(x)=d−ux, the twice transformed function takes the form:
h″(w)=d−u·μ−RT′u·w
With this the integral I can be rewritten as
I=(d−u·μ)ℑ[−∞,U]−s1ℑx[−∞,U].
Here
and
finally
To summarize: as a result of the Cholesky transformation and the rotation R, the original I multivariate integral over a confined subspace has been reduced to a univariate definite integral, which can be executed often analytically, and always numerically.
The Case of Multicomponent Constraints
We now consider the case of having several constraints for the availability of components. These constraints can be written as a set of constraint equations
d−Aq>0
where d is a p dimensional vector, and A is a p times n dimensional matrix. Here p is less than or equal to n. The i-th row of the matrix A corresponds to the constraint vector ai similarly to the case of the single component constraint. The first step of the method, the Cholesky transformation, can be performed in the present case as well, transforming to the new variables z. The constraint vectors ai are transformed into the vectors bi by this transformation.
These equations once again define the feasible region, which is now bounded by a set of hyperplanes. However in a generic case the hyperplanes are not orthogonal to each other. For this reason in general it is hard to separate the multivariate integrals into univariate integrals.
An approximate evaluation of the integral I can be constructed the following way. Define a new r-dimensional orthogonal basis u defined by a set of r hyperplanes, such that each of the original m hyperplanes is mapped to a new hyperplane. In general r is less than or equal to m and in practice r is often 1. The index mapping from the original m-dimensional basis to the new r-dimensional set is represented by σ such that σ(i) is the index of new hyperplane associated with the original hyperplane i. The new basis may be defined in various ways with the objective being to closely approximate the originalfeasible region. In practice we take the new basis to be a single orthanormally transformed hyperplane.
In general the dimension of the space of these new u orthogonal constraint vectors can be smaller than those of the original b constraint vectors. Therefore some of the transformed hyperplanes, which are now orthogonal to only one axis, will be parallel to each other. In this case the integration along the say j-th axis should go up to cj, the minimum of the integrational limits along these axis. In terms of the original variables:
With this finally the integral I is given as:
where r<m.
Now we will employ the above derived relations for the case, when we have to integrate a linear function of the variable h(x)=di−aix. The twice-transformed function takes the form:
h′(w)=di−ai·μ−RT′ai·w.
Introducing s=RT′ai
With this the integral I can be rewritten as
With all these preparations, we are now ready to evaluate the integral of the production policy.
We start with performing the same Cholesky decomposition, which allows α(x) to be reduced as:
where again bi=T′ai+μ.
Next the same orthornormal rotation is performed as before, using the matrix R. Then the m vectors bi are again approximated by r orthonormal vectors uj such that bi≅|bi|uσ(i). This approximation identifies mutually orthogonal hyperplanes, which will allow for a more straightforward evaluation of the integral I. As before, σ is a mapping from the index set [m] into [r]. Substituting for the b and defining the rotation matrix R such that Ruσ(i)=eσ(i) where ei are unit vectors yields:
Noting that |bi|=√{square root over (ai′Σai)}
allows α″(w) to be rewritten as:
We are now ready to compute the value of the expected production. An important part of the calculation is to evaluate the following integral
Using the above preparatory formulae I* reduces to
where we used that the fact that the f multivariate normal density function is normalized to one, thus in the directions where the integration is unconstrained, the integrals can be readily performed to yield unity. Hence only those integrals remain, where a hyperplane introduces a ci upper bound for the integral:
Since α″(w) is a linear function of its argument, once again the preparatory formulae can be applied to yield
Using the notation
the following describes the integrational limit Uik:
In the final analysis the original n dimensional multivariate integral with an arbitrary covariance matrix, constrained by a set of p arbitrary hyperplanes, has been reduced to r independent univariate definite integrals. Note that when r=1, σ−1(i) is the entire set [m].
As can be shown, the original integral is an NP hard problem, requiring exponentially long time for evaluation, whereas the just-derived univariate integrals can be evaluated in a straightforward manner by any known numerical technique, including even the Simpson procedure.
The total expected production is then given by
Here one recognizes that the integration over the Ω+
The Local U-Policy
The uniform policy prescribes a demand-production mapping that is manifestly irrational in some cases. In particular, the problem of “intercomponent” effects arises where a component that gates production for one product will diminish production over all. This arises because the previous policies compute a single α for all products.
On an event by event bases, an “iterated policy” represents rational demand-production mappings, but analytic formulas are not available for the expected production over these policies. A compromise is to compute a separate α for each product. This we refer to as the local u-Policy.
As before, for product i, let D(i) denote the components in the BOM of i. Also, as before, for any component j we can define the subspaces Ω={x:dj−aj·x>0}. We now define the subspaces Ωi for each product i as
Ωi∩jεD(i)Ωj
If xεΩi then component allocation is sufficient to meet product demand for the ith product, even though it may not be sufficient to meet demand for other products.
We make the important observation that in computing expected values for functions h(x) that can be separated into a sum,
h(x)=h1(x1)+ . . . +hn(xn)
the appropriate subspace of integration for the feasible production for each function hj is Ωj.
For any subspace Ω, let EΩ denote the expectation over support Ω. Thus, the expectation of h can be expressed as
where q(x) is any production policy that maps each xε
We define the local u-policy q as
where
We now show that with the preceding definition, for any k, we have that dk−ak·q>0. Substituting q we get
But observe that αk1=0 if k ∉D(i), and therefore
proving that dk−ak·q>0.
Computation of the results in this case is identical to the method described in the previous section except that a separate integration is done for each element of the expected production vector. For each element i, the index set of constraints [m] is replaced by the reduced set D (i) which includes only those components in the BOM for product i. (i.e., the index of rows in the i-th column of the connect matrix A for which the entry is nonzero).
Although particular embodiments of the present invention have been shown and described, it will be obvious to those skilled in the art that changes and modifications may be made without departing from the present invention in its broader aspects, and therefore, the appended claims are to encompass within their scope all such changes and modifications that fall within the true scope of the present invention.
This application is a continuation of U.S. Provisional Application Ser. No. 60/213,189 filed Jun. 21, 2000. That disclosure is incorporated in this document by reference.
Number | Name | Date | Kind |
---|---|---|---|
3670861 | Zenner et al. | Jun 1972 | A |
3782278 | Barnett et al. | Jan 1974 | A |
3804626 | Harvey | Apr 1974 | A |
3810189 | Casperson et al. | May 1974 | A |
3874492 | Hurst | Apr 1975 | A |
3941051 | Barrus et al. | Mar 1976 | A |
3941230 | Bellino et al. | Mar 1976 | A |
3942619 | Nordstrom et al. | Mar 1976 | A |
4159882 | Sanders, Jr. et al. | Jul 1979 | A |
4239403 | Matula et al. | Dec 1980 | A |
4248148 | Mahoney et al. | Feb 1981 | A |
4250808 | Katsura et al. | Feb 1981 | A |
4289069 | Melissa et al. | Sep 1981 | A |
4336751 | Melissa et al. | Jun 1982 | A |
4340848 | Hanagata et al. | Jul 1982 | A |
4351235 | Bringhurst | Sep 1982 | A |
4359289 | Barrus et al. | Nov 1982 | A |
4364024 | Paetsch | Dec 1982 | A |
4387642 | Bringhurst et al. | Jun 1983 | A |
4400104 | McCray et al. | Aug 1983 | A |
4444521 | Rickard et al. | Apr 1984 | A |
4462702 | Fritz et al. | Jul 1984 | A |
4480541 | Grummett | Nov 1984 | A |
4513661 | Melissa et al. | Apr 1985 | A |
4543002 | Bittner et al. | Sep 1985 | A |
4565127 | Pichler et al. | Jan 1986 | A |
4588316 | Everett, Jr. | May 1986 | A |
4601241 | Fujiwara | Jul 1986 | A |
4625638 | Fritz et al. | Dec 1986 | A |
4632584 | Becchi et al. | Dec 1986 | A |
4688956 | Miyake | Aug 1987 | A |
4693618 | Hanagata | Sep 1987 | A |
4869610 | Nishizawa et al. | Sep 1989 | A |
4897589 | Fujiwara et al. | Jan 1990 | A |
5059047 | Nakamura et al. | Oct 1991 | A |
5366303 | Barrus et al. | Nov 1994 | A |
5666880 | Barrus | Sep 1997 | A |
6061662 | Makivic | May 2000 | A |
6151582 | Huang et al. | Nov 2000 | A |
6516313 | Perry | Feb 2003 | B1 |
6684193 | Chavez et al. | Jan 2004 | B1 |
Number | Date | Country |
---|---|---|
63-122562 | May 1988 | JP |
4-301461 | Oct 1992 | JP |
Number | Date | Country | |
---|---|---|---|
60213189 | Jun 2000 | US |