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