Example of calculation of material collection time in APS system

Set analysis is an important function in the APS system. The set analysis includes both manufactured and purchased parts. The complete set of manufactured products involves the production plan of semi-finished products, and the complete set of purchased parts is calculated based on in-stock inventory and in-transit inventory.

Here we give an example of a suite of analyses:

Example 1: Material collection date for a single order

Assume that the materials of product P include four purchasing parts A, B, C, and D. Their purchasing lead times are as follows:

We assume that the order quantity of P is 100. To simplify the calculation, assume that the consumption of various materials is 1, and the current day is 2022/4/1

Assumption 1:

Inventories in storage and in transit are as follows:

The above calculation is based on B’s arrival date, and the order’s delivery date is 4/5. Although C is short of materials, the lead time is 3 days, and the estimated arrival date is 4/3, which is earlier than 4/5.

Assumption 2:

B’s arrival date is April 2nd, C is out of stock, but the procurement lead time is 3 days. Assume that the purchase order is placed today and the goods can arrive on April 3rd, then the order’s materials collection date is April 3rd.

Assumption 3:

The above B and C are all in short supply. The date of material collection is calculated based on the larger lead time. The date of material collection is 4/7.

Example 2: Distribution of shared materials

Assume that the BOM structure is as follows

We still assume two orders:

Assumption 1: The inventory is as follows:

Since the delivery date of product P1 is earlier, the shared materials will be allocated to P1 first, and the delivery of P2 will be delayed.

Assumption 2: The inventory is as follows:

Under the above conditions, although the delivery date of P1 is earlier, because B is short of material until April 6th, the common material D is allocated to P2 for production first, so that the line body is not empty.