Product Listing Service

The “according to the list of goods” calculation window is intended for mass calculations of optimal inventory management parameters (threshold and order), as well as for calculating the current demand according to the list of goods at the facilities. The source information for the product list is downloaded from files prepared according to the instructions .

Group calculations are available to the user with an account at RopRoq.net . To register an account, write us an email: This email address is being protected from spambots. You need JavaScript enabled to view it. or register yourself .

The “according to the list” calculation page is divided into two parts: in the upper part of the “Created Calculations” the initial information is loaded and the calculations are launched, in the lower part of the “Calculation Results” the results are viewed and saved to a file.

Description of the Created Calculations table

The table “Created calculations” contains the headers of the calculations and summary information on the downloaded files and the performed calculations. The user is available to add, modify and delete calculations. To download the file with the source data, you must click on the "download" link in the "Size" column on the newly created calculation. To download the file again, you must click on the link in the “Size” column again. If a file with source data has already been loaded into the selected calculation, then the text of the download link will contain the size of the downloaded file in kilobytes, and not the word “download”. Re-uploading the file to the same location deletes the previous downloaded data within the selected calculation.

When there is no loaded data inside the created calculation, the text “No data” is visible in the “Calculation” field. In the process of uploading the file to the server in the field “Calculation” the text “Loading ...” and the percentage of the downloaded source information in percent are displayed.

The “Date” field contains the date and time of downloading the file with the source data. The “Lines” field contains the number of successfully loaded lines; the “Errors” field contains the number of lines with errors. By clicking on the link in the “Rows” field, a list of downloaded data opens. By clicking on the link in the "Errors" field, a form with a list of error lines opens.

After the download is complete, the "Calculate" link appears in the "Calculation" field, when clicked, the calculation of the optimal control parameters and current demand is launched. During the calculation process, the calculation status changes in percentage in the “Calculation” field. For all completed calculations in the field "Settlement" indicated "100%". When you click on the link “100%”, the recount is repeated.

In the fields “Start of calculation” and “End of calculation” the date and time of the start and end of the last recount are recorded.

The fields of the group “Summary data of the calculation result” provide aggregated information on the source data and the optimal (planned) calculation indicators.

Description of the fields of the group "Summary data of the calculation result":

  • SKU – stock keeping unit (the total quantity of SKU is equal to the number of lines in the original inventory data file)
  • Stock quantity (pcs) – current item quantity in pieces at all points of sales
  • Stock value ($) – current value in RUR at all points of sales
  • Goods-in-transit quantity (pcs) – current total quantity of an item being in transit to all points of sales
  • Goods-in-transit amount ($) – current total value, in RUR, being in transit to all points of sales
  • Demand (pcs) – current total demand of an item (in pieces)
  • Demand ($) – current total demand of an item (in pieces)
  • Items quantity demand (items) – quantity of lines (assortment) of current total demand
  • Planned in-stock amount ($) – optimal planned stock, in RUR, of an item at all points of sales
  • Normative planned inventory (days) - normative optimal planned inventory in terms of days for the item at all points of sales
  • Service level planned (%) – optimal service level planned for all points of sales
  • Service level actual (%) – current service level at all points of sales
  • Sales planned ($) – optimal planned sales value from all points of sales
  • Total demand planned ($) – total demand planned, in $, from all points of sales.
  • Planned number of replenishment acts (items/month) – total optimal (planned) quantity of replenishment acts (quantity of orders).

Description of «Payroll results» table

Item-by-item payroll results for each item at each point of sales. To save the entire list of results in the file, click on the Floppy disk icon. Description of the fields of the Payroll results table:

  • Point of sales – point of sales code
  • Item – item code (unique product ID)
  • ROP (pcs) – the threshold quantity, at which you need to place an order for this item.
  • ROQ (pcs) – the ordered quantity to place when the stock quantity reaches the ROP.
  • Interval (days) – the control interval between orders
  • Service level (%) - service level (percentage of satisfied demand)
  • <Inventory> (days) – planned average inventory in terms of days for the item
  • Total costs ($/days) – the total amount of stock-out, storage and replenishment costs
  • Stock-out costs ($/day) – foregone income
  • Storage costs ($/day) – costs for holding the item in stock
  • Replenishment cost ($/day) – cost of ordering plus taking delivery
  • Profit ($/day) – the maximum possible income at 100% satisfied demand minus total costs.
  • Stock-out quantity (psc/day) – planned amount of item in unmet demand
  • <Stock quantity> – the average stock quantity forecasted
  • <Inventory value> ($) - the average planned inventory value (in purchase price)
  • Maximum (pcs) – quantity of the product in stock at the time of delivery
  • Demanded quantity (pcs) – the current quantity demanded of the item that need to be send to the supplier (order to the supplier).
  • Current order value ($) – the actual order value of the item, in $.
  • Stock quantity (pcs) – current stock quantity, the input data from the original product information from the point of sales.
  • Goods-in-transit quantity (pcs) – current goods-in-transit quantity, the input data from the original product information from the point of sales.
  • Average sales (pcs/ days) – the average daily sales in pieces

Current demand calculation formula

Original data information:

  • S – current stock quantity and in-transit-goods quantity, in pcs (default null).
  • SP – current in-transit-goods quantity, in pcs, (default null).
  • V – average daily sales, in pcs/day (the default value is 1)
  • T_d – lead time, in days (the default value is 1)
  • T_int – the interval between orders, or quantity of days before the next, or the number of days until the next opportunity to place an order (the default value is 1).
The information from payroll results:
  • ROP (pcs) – the threshold quantity, at which you need to place an order for this item..
  • ROQ (pcs) – the ordered quantity to place when the stock quantity reaches the ROP.
Current demand calculation:

Calculation of current needs:

If the stock quantity plus in-transit-goods quantity is less or equals the ROP, taking into account the interval of the T_int:

S+SP<= ROP + (T_int - 1)*V,

then the current demand is equal to the optimal order, adjusted for the deviation of the current balance and goods in transit from the threshold value. If the size of the “Order” is less than the sales for the period T_int, then the value V * T_int will be used as the order:

Demand = MAX(ROQ; V * T_int) – MAX(0;S+SP-V*T_d) + MAX(0;ROP-V*T_d)