Apprenez à concevoir un système d'information décisionnel pour faire réussir votre entreprise dans un univers concurrentiel !

Liste des produits

Le fichier products.json contient une liste des produits de votre entreprise avec leurs caractéristiques.

Exemple

[
    {
        "product_id":"997d27db-0980-4679-b51b-662637c47180",
        "name":"Nectar (Orange)  - Qualité Normale",
        "category":"Nectar",
        "flavour":"Orange",
        "bio":"False",
        "chilled":"False",
        "quality":"Normale",
        "target_margin":0.2,
        "max_price":5.0,
        "max_quantity":400000.0
    },
    {
        "product_id":"4c768bd6-db30-4346-809a-d82318b358b0",
        "name":"Pur jus (Orange)  - Qualité Faible",
        "category":"Pur jus",
        "flavour":"Orange",
        "bio":"False",
        "chilled":"False",
        "quality":"Faible",
        "target_margin":0.2,
        "max_price":5.0,
        "max_quantity":400000.0
    }
]

Spécifications

name: products.json
description: "A list of your company's products with their characteristics."
  - name: product_id
    type: string
    description: product identifier
  - name: name
    type: string
  - name: category
    type: value in {"Pur jus", "Jus à base de concentré", "Nectar", "Smoothie"}
  - name: flavour
    type: value in {"Orange", "Multi-fruits", "Pomme"}
  - name: bio
    type: value in {"True", "False"}
  - name: chilled
    type: value in {"True", "False"}
  - name: quality
    type: value in {"Premium", "Normale", "Faible"}
  - name: target_margin
    type: float
    description: Target margin (in euros) to be applied to the cost of the product
  - name: max_price
    type: float
    description: Maximum price (in euros) not to be exceeded, the margin can be reduced in this way.
  - name: max_quantity
    type: float
    description: Quantity by month (in liters) of the company's production dedicated to the product. The sum of this quantity for all products must not exceed the company's month maximum capacity.

format: json

ATTENTION ! La somme des max_quantity de tous les produits doit être inférieure ou égale à la capacité de production mensuelle de votre entreprise. Sinon, des produits seront aléatoirement mis à 0 jusqu’à respecter la production maximale. Cette vérification se fait avant la période.

Production

Le fichier production.csv contient les productions de vos usines par mois au cours de la période.

Exemple

"product_id","date","produced_quantity","raw_materials_unit_cost","production_unit_cost"
"997d27db-0980-4679-b51b-662637c47180","2021-01-01",324081.0,1.51,0.17

Spécification

name: production.csv
description: "Production of your factories per month during the period."
  - name: product_id
    type: string
    description: product identifier
  - name: date
    type: date with format YYYY-MM-DD
    description: Date of sale is always the first day of the month.
  - name: produced_quantity
    type: float
    description: Production quantity in litres
  - name: raw_materials_unit_cost
    type: float
    description: cost of raw materials to produce 1L of finished product
  - name: production_unit_cost
    type: float
    description: production cost (factory, staff, packaging, marketing etc.) to produce 1L of finished product

dialect:
    delimiter: ','
    doublequote: true
    escapechar: None
    lineterminator: '\r\n'
    quoting: QUOTE_NONNUMERIC
    quotechar: '"'
    skipinitialspace: true
    header: true

Ventes

Le fichier sales.csv contient les ventes effectuées au cours de la période.

Exemple

"client_id","product_id","network","date","unit_price","sold_quantity"
"f0f55990-a177-4f1a-b092-dc859341611d","aef1efc9-61eb-4be7-bc9e-b8dd2fa0992c","GMS","2021-01-01",2.03,729.0

Spécifications

name: sales.csv
description: "Sales made during the period."
  - name: client_id
    type: string
    description: client identifier
  - name: product_id
    type: string
    description: product identifier
  - name: network
    type: value in {"GMS", "SDMP", "CHR"}
    description: Customer's distribution network
  - name: date
    type: date with format YYYY-MM-DD
    description: Date of sale is always the first day of the month.
  - name: unit_price
    type: float
    description: Product unit price
  - name: sold_quantity
    type: float
    description: Quantity sold in litres

dialect:
    delimiter: ','
    doublequote: true
    escapechar: None
    lineterminator: '\r\n'
    quoting: QUOTE_NONNUMERIC
    quotechar: '"'
    skipinitialspace: true
    header: true