Intended learning outcomes: Disclose the concept of allocated quantities. Explain projected available inventory and its components. Disclose planning-related events and their effect on available inventory.
Physical inventory is the actual inventory quantity determined by physical counting (cf. [APIC16]).[note 1201].
Physical inventory is often also called stock on hand or on-hand balance.[note 1202].
Precise physical inventories on their own are not enough to allow efficient inventory management, as the following example shows:
- “A customer orders a certain quantity of a product for delivery in one week’s time. A check of the inventory shows that there is sufficient stock, and the order is confirmed. One week later, however, it emerges that the product cannot be delivered, because in the meantime the stock has been delivered to another customer.”
Solving the problem requires taking future demand into consideration.
An allocated quantity is a quantity of items assigned to a specific customer or production order. It is also known as reserved quantity.
- A quantity ordered in a new customer order is thus not only compared against the physical inventory. It must also be compared against the physical inventory minus the sum of all reserved quantities. The customer requirements in question may only be confirmed if the result is sufficiently large.
On the other hand, it is also necessary to take quantities ordered through current procurement orders or production orders into account.
An open order is either a released order or an unfilled customer order.
An open order quantity is the quantity of an open order that has not yet been delivered or received.
A scheduled receipt is the open order quantity of an open production or procurement order with an assigned completion date.
- The customer demand in question can thus be confirmed on the date of the next scheduled receipt, provided that this date is sufficiently reliable and the expected quantity is sufficiently large.
This example gives us a definition for projected available inventory.
Projected available inventory or projected available balance is defined in Figure 12.1.1.1 for every future transaction or event that changes stock levels. The calculation also includes
- planned demand, i.e., the requirement for planned customer or production orders, and
- planned receipts, i.e., (anticipated) receipts associated with production or procurement orders that have not yet been released.
Fig. 12.1.1.1 Projected available inventory.
Projected available inventory is thus neither a scalar value nor an individually and directly manageable attribute. It changes with every planning-related event. Figure 12.1.1.2 shows the various planning processes or planning-related events or transactions that may change the values of the four totals and also the physical inventory (see also Figure 11.1.2.1):
- Increase in production plan: Every forecast is a planned demand.
- Receipt of a customer order: Every item ordered results in an allocated quantity.
- Delivery of a customer order: Stock quantity is reduced. Reserved quantity and, if necessary, a forecast quantity are also reduced (see also Section 12.2.2).
- Creation of a planned production or procurement order: The planned receipts total is increased.
- Creation of (dependent) demand for each component of a planned production order: The total of planned demand is increased (see also Section 12.3.3).
- Release of a production or procurement order: The scheduled receipts total is increased. If the order already exists as a planned order, then the planned receipts quantity is reduced.
- Allocation of a components requirement: Planned demand in planned production orders is translated into allocated quantities.
- Issuance of an allocated quantity from stock: The stock quantity and the allocated quantities total are reduced when an allocated quantity is issued from stock.
- Unplanned returns or issues: Such transactions occur during distribution and procurement, as well as during production. They may relate to equipment overheads for offices and workshops or to items for R&D, or may be sent as samples, and so on.
- Scrapping during production: Quality control determines the scrap quantity, which reduces scheduled receipts.
- Checking of goods received: Physical receipts into stock raise the stock quantity and reduce the scheduled receipts total.
- Physical inventory alters the stock quantity in both directions.
It is important that available inventory be changed by only one of the transactions listed above. For this reason, the physical inventory or the four summed quantities are never simply corrected. This conforms to the principles of financial accounting, which in turn adhere to the legal requirements.
The scheduling projected available inventory calculation attempts to assign the associated scheduled or planned receipt to every requirement.
Figure 12.1.3.1 shows the previous example using this type of calculation, where customer order 25810 has been moved forward to June 10.
Fig. 12.1.3.1 Scheduling projected available inventory calculation (spreadsheet).
Again, demands are listed in order by date. Receipts, on the other hand, are sorted by the date on which they will be needed in order to have projected available inventory. The following situations result in lists of exceptions (only the first one appears in Fig. 12.1.3.1):
- A demand can only be covered by bringing forward a corresponding receipt. Two receipts of this kind are indicated by an asterisk (*) in the first column in Figure 12.1.3.1.
- A receipt can be deferred, since the associated requirements have a later date than the date of the receipt.
- There are demands without corresponding receipts, so an order proposal should be generated.
- Planned or released orders without assigned demands may be canceled, if necessary.
Thus, the scheduling projected available inventory calculation also creates a link between materials management and scheduling by providing proposals to speed up or slow down production or procurement orders.
Conversely, if the production or procurement orders cannot be speeded up, the scheduling projected available inventory calculation indicates which requirements will have to be delayed. The orders associated with these demands should then be slowed down temporarily and then speeded up again as soon as the demands become available.
The scheduling projected available inventory calculation can also be shown in graph form. The graph in Figure 12.1.3.2 has the same contents as the spreadsheet in Figure 12.1.3.1. Negative projected available inventory corresponds to a backlog and is shaded accordingly, and the two extreme responses — delaying an allocated quantity or speeding up a production or procurement order — are shown as examples.
Fig. 12.1.3.2 The scheduling projected available inventory calculation (graph).
The cumulative projected available inventory calculation contains the same information as the noncumulative calculation, but it also provides the cumulative totals for entries and issues along the time axis.
Store throughput diagram is another name for the graphical representation resulting from the cumulative projected available inventory calculation.
This is illustrated in Figure 12.1.3.3. It is more difficult to represent, because the values along the vertical axis are sometimes very large.
Fig. 12.1.3.3 The cumulative projected available inventory calculation (graph) or store throughput diagram.
The expected projected available inventory is shown as a vertical difference. If the cumulative issues curve is higher than the cumulative receipts curve, then we should expect a negative projected available inventory. This will correspond to the expected backlog and is again shaded accordingly.
Course section 12.1: Subsections and their intended learning outcomes
12.1 Demand and Available Inventory along the Time Axis
Intended learning outcomes: Explain the projected available inventory and its calculation. Describe scheduling and cumulative projected available inventory calculation. Produce an overview on operating curves for stock on hand.
12.1.1 Allocated Quantities, and the Projected Available Inventory
Intended learning outcomes: Disclose the concept of allocated quantities. Explain projected available inventory and its components. Disclose planning-related events and their effect on available inventory.
12.1.2 Projected Available Inventory Calculation
Intended learning outcomes: Differentiate between the spreadsheet representation and the graphical representation (or inventory curve) of the projected available inventory calculation.
12.1.3 Scheduling and Cumulative Projected Available Inventory Calculation
Intended learning outcomes: Explain scheduling projected available inventory calculation (spreadsheet and graphical representation). Describe the cumulative projected available inventory calculation (graph) or store throughput diagram.
12.1.4 Operating Curves for Stock on Hand
Intended learning outcomes: Explain the derivation of an operating curve for stock on hand from the store throughput diagram.