Input data system requirements for item-by-item calculation for the list of products.
To work in the service, you must download the source data for the goods:- “Type 1 - Product table with initial parameters (it’s enough to download only this list if the average sales speed V and distribution of receipts are indicated)
- “Type 2 - Statistics of balances and sales (you need to download to automatically calculate the average sales speed V, if the speed is not specified in the file“ Type 1 ")
- “Type 3 - Distribution of receipts (required to download to calculate the distribution of receipts if the distribution is not specified in the file“ Type 1 ”)
File format with source data (* .csv, * .xls, * .xlsx):
Description of the * .csv file format:
- File format: * .csv
- Field Separator: ";" - semicolon
- Fraction separator: "," - comma,
- Distribution of checks: in quotation marks and with a separator of values, the sign ";" semicolon (example: '1 = 0.5; 2 = 0.5').
- Dates: The dates need to specify in quotes (for example: 'YYYYMMDD') .
- It is desirable that the files with the source data do not exceed 100 thousand lines in volume. If you need to download a larger volume, you need to split the files by assortment or contact the administrator of the service.
List of the fields:
- wh_id – point of sales code
- good_id – item code
- V – average sales, in pcs/ days (the default value is 1).
- K_disk – annual discount rate, in % (the default value is 18%).
- T_d – lead time, in days (the default value is 1).
- T_ots – grace period before a payment, in days (given by the supplier)
- T_deb – grace period before a payment, in days (given to the customer)
- C_zak – purchasing payment, in $/ pcs (prime cost).
- C_pr – sale price, in $/ pcs.
- K_doh – trade margin discounted to reflect the TVM (time value of money), in $/pcs (if not specified, calculated automatically on basis of C_pr and C_zak).
- K_hr – cost of storage (discounted to reflect the TVM) and shipment to customer, in $/ pcs/ day (if not specified, calculated automatically).
- K_zak – purchase cost of the product, in $/ item (the default value is 1)
- ai_checks – probability distributions of checks. By default, all checks are equal to 1 (“1=1”).
- S – current stock quantity plus quantity in transit, in pcs (if not specified, considered as null).
- SP – current in transit quantity of the item, in pcs (in not specified, considered as null).
- T_ut – remaining shelf life, in days (if not specified, considered as 365).
- T_int – the interval between orders, or the number of days until the next opportunity to place an order (the default value is 1).
- Shut – disposal costs, in $/ pcs (if not specified, considered as С_zak).
- Sha – stock-out penalty, in $/ item (in not specified, considered as null).
- Solver – optimization method. You must specify the value of “1001” (the threshold solution of the Optimizer). The alternative optimization methods will be added in the future. For example, Optimizer with the limited shelf time (“fresh”).
Example type 1 Excel file with the source data
The list of fields for the file "Type 2 - Statistics of balances and sales":
- wh_id - Object Code
- good_id - Product Code
- dt - date
- stock - Balance in pieces on the morning of the specified date dt.
- ship - The sum of sales in units for the date dt
Example type 2 Excel file with source data
List of fields for the file "Type 3 - Distribution of receipts":
- wh_id - Object Code
- good_id - Product Code
- ai_check - check (number of pieces in the check / waybill)
- cnt - number of checks ai_check
Example type 3 Excel file with source data