input data - what we need
A LIMITED SCOPE: 50-100 distinct products → could be depending of the subject
Temporal data
At least: - 3 years of historic if weekly (stock, demand, orders)
- 1 years of historic if daily (stock, demand, orders)
Data in separate csv
product_site_id: item id or name (unique for each product) - reference
date: date of the event
demand: value of demand
Aggregation ⇒ research
examples of csv file
product_site_id | date | demand |
---|---|---|
object_0 | 01/01/2021 | 10 |
object_0 | 02/01/2021 | 50 |
object_0 | 03/01/2021 | 15 |
object_1 | 01/01/2021 | 100 |
object_1 | 05/01/2021 | 200 |
Untitled |
Static data
- Category
- Sub-category
Limiter le scope à deux-trois contraintes (Lot size, MOQ)
csv file
product_site_id | category | sub_category | lot size | moq | lead time (day) | supplier_id |
---|---|---|---|---|---|---|
object_0 | fam1 | sub_fam1 | 10 | 3 | 12 | 123 |
object_1 | fam2 | sub_fam2 | 20 | 5 | 84 | 124 |