Buckets

IPW displays the material plan in buckets, where the projected on-hand balance (POHB) is displayed for a specific date and time. MMS080 also displays the same material plan, but as transactions with a date and time when a transaction occurs.

MMS080 displays the material plan over time, starting with the on-hand balance (OHB). There is one record for each supply or demand that displays the material quantity and the new POHB. Each record has a date and time.

IPW displays the material plan in buckets, and the POHB column displays the planned on-hand balance at that specific date and time.

  • POHB (end of bucket) = POHB (start of bucket) + summed supply – summed demands

The POHB column defines the end (date and time) of a bucket, and the previous POHB column defines the start (date and time) of that bucket. IPW calculates the summed supply and the summed demands for each bucket, for example, the transactions occurring from the start of the bucket until the end of the bucket. The date and time of each supply or demand in MMS080 defines which bucket in IPW it is included in.

These are the standard setups for the first three bucket columns:

  1. POHB (Planned on-hand balance at that date & time)

    If demand or supply is on the same date and time as the OHB column, the demand or supply affects the POHB value on that date and time. Therefore, it is included in the bucket that ends at that date and time.

  2. Supply (Supplies between the start of the bucket and the end of the bucket)

    You can make decisions in cells for a bucket covering several days. IPW provides the option to define the date and time of these decisions. For example, the order date and time are defined as an offset from the bucket end. In Data Retrieval 1 > Order and planned order end offset, you can select the number of hours before the end of the bucket that is used for planning date and time when creating a new manufacturing order.

  3. Demand (Demands between the start of the bucket and the end of the bucket)

    Some API transactions for supplies and demands have a date, but the time is not defined. IPW provides the option to define the time for these supplies or demands. For example, the forecast time is defined in Data Retrieval 1 > Forecast demand time.

There are several methods for setting up buckets: