Calculates a Replenishment Plan (also called DRP : Distribution Requirement Planning) and the related Projected Inventories and Coverages

Calculates a Replenishment Plan (also called DRP : Distribution Requirement Planning) and the related Projected Inventories and Coverages

drp(dataset, DFU, Period, Demand, Opening, Supply, SSCov, DRPCovDur, MOQ, FH)

Arguments

dataset

a dataframe with the demand and supply features for an item per period

DFU

name of an item, a SKU, or a node like an item x location

Period

a period of time monthly or weekly buckets for example

Demand

the quantity of an item planned to be consumed in units for a given period

Opening

the opening inventories of an item in units at the beginning of the horizon

Supply

the quantity of an item planned to be supplied in units for a given period

SSCov

the Safety Stock Coverage, expressed in number of periods

DRPCovDur

the Frequency of Supply, expressed in number of periods

MOQ

the Multiple Order Quantity, expressed in units, 1 by default or a multiple of a Minimum Order Quantity

FH

defines the Frozen and Free Horizon. It hase 2 values: Frozen or Free. If Frozen : no calculation of Replenishment Plan yet, the calculation starts when the period is defined as Free. We can use this parameter to consider some defined productions plans or supplies (allocations, workorders,...) in the short-term for example.

Value

a dataframe with the calculated Replenishment Plan and related Projected inventories and Coverages

Examples

drp(dataset = blueprint_drp, DFU, Period, Demand, Opening, Supply, SSCov, DRPCovDur, MOQ, FH)
#> Joining, by = c("DFU", "Period")
#> Joining, by = c("DFU", "Period")
#> Joining, by = c("DFU", "Period")
#> # A tibble: 520 × 15
#> # Groups:   DFU [10]
#>    DFU        Period     Demand Opening Supply SSCov DRPCo…¹ Stock…²   MOQ FH   
#>    <chr>      <date>      <dbl>   <dbl>  <dbl> <dbl>   <dbl>   <dbl> <dbl> <chr>
#>  1 Item 0000… 2022-07-03    364    6570      0     4       4       8     1 Froz…
#>  2 Item 0000… 2022-07-10    364       0      0     4       4       8     1 Free 
#>  3 Item 0000… 2022-07-17    364       0      0     4       4       8     1 Free 
#>  4 Item 0000… 2022-07-24    260       0      0     4       4       8     1 Free 
#>  5 Item 0000… 2022-07-31    736       0      0     4       4       8     1 Free 
#>  6 Item 0000… 2022-08-07    859       0      0     4       4       8     1 Free 
#>  7 Item 0000… 2022-08-14    859       0      0     4       4       8     1 Free 
#>  8 Item 0000… 2022-08-21    859       0      0     4       4       8     1 Free 
#>  9 Item 0000… 2022-08-28    273       0      0     4       4       8     1 Free 
#> 10 Item 0000… 2022-09-04    349       0      0     4       4       8     1 Free 
#> # … with 510 more rows, 5 more variables: Safety.Stocks <dbl>,
#> #   Maximum.Stocks <dbl>, DRP.Calculated.Coverage.in.Periods <dbl>,
#> #   DRP.Projected.Inventories.Qty <dbl>, DRP.plan <dbl>, and abbreviated
#> #   variable names ¹​DRPCovDur, ²​Stock.Max