To generate an order, the following data is needed
for the sales period, the number of days to order for, and capturing the reference catalog of items (supplier, warehouse, group, section).
Sales floor balance – balances by sales floors (per the query),
Warehouse balance – item balances by the warehouses in the query,
Balance – total balance,
Sales speed of the item for the given period,
Daily coefficient – the ratio between the number of days with a non-zero item balance and the given period.
Stock – the number of days for which there is enough of the item to sell,
Order – the quantity recommended by the system for ordering,
Number of days – the number of days from the selected period during which the item was in stock, i.e. the number of days with balance > 0,
Total receipt – the quantity of the item across all receipts for the selected period,
Partial receipt - the quantity of the item from receipts for the selected period from the supplier specified by the filter,
Sold – the quantity of the item sold during the given period.
Below are the formulas used to calculate the field values.
KSpeed = KolProd/KolDay,
where KolProd – the quantity of the item sold during the specified period,
KolDay – the number of days in the specified period with balance > 0,
KSpeed – the sales speed coefficient of this item for the specified period, taking balances into account (corresponds to the average quantity of the item sold per day).
If KSpeed <>0, then
DayZapas = (KolSclad+KolZal)/ KSpeed
otherwise
DayZapas = (KolSclad+KolZal)*1000,
where DayZapas - the number of days (how many days ahead there is a supply of the item at a constant sales rate);
KolSclad - the current quantity of the item in the marked warehouses,
KolZal - the current quantity of the item in the marked sales floors.
DayZapas is always rounded to the nearest whole number according to mathematical rules. If the sales speed equals 0, the balance is multiplied by 1000 days ahead, to ignore this item.
Zakaz = KSpeed * KolDay_Zakaz - KolSclad - KolZal + KolMin,
where Zakaz - the quantity of the item to order,
KolDay_Zakaz – the number of days to order for (how many days the order should cover),
KolMin - the minimum quantity of the item (from the minimum balance template) for the divisions marked in the update filter.
If rounding to packages is needed, and this item's card has the quantity per package set, then the quantity of the item to order is rounded up to whole packages.
as a result we get the items to order (highlighted in green in the list) in two cases,
if Zakaz > 0,
if Zakaz = 0, the total quantity in the divisions is less than the total minimum balance (data from the minimum balance template).
in this case the task of forming minimum warehouse balances is related
to
information about the quantity, the amount of orders by supplier (supplier information changes as a result of moving items between different suppliers) and the final order figures.
"Product Sales Register" -data on sales (date, warehouse, quantity, price) of the marked item for the selected sales period.
"Mark for order" – mark the selected item for order.
The following commands allow you to mark all items for order or clear all order marks.
"Supplier Totals Register" opens a window with a list of all suppliers whose goods are included in the order. It also shows the totals of cost and retail prices for each supplier.
printing and saving the order if needed
How can the warehouse size be taken into account as well, not just the sales speed? That is, some warehouse can carry a larger stock than another?
Comments