Sales-based Order Proposal
In
addition to the normal order proposal which is based on the current quantity in
stock, the MICROS Retail OSCAR POS application allows you to create a sales-based order
proposal.
With
a sales-based order proposal, the item sale of a particular time period in the
past is evaluated and, depending on various parameters, an order quantity is
determined automatically.
The following programs and parameters have effects on
the determination of the order quantity:
- In the update program Stock
Item Group, the parameters for the Sales Period and
the Order
Algorithm for the calculation of the order quantity have to be
defined.
- In the update program Stock
Item Group, the Algorithm 1
has to be selected in the field Order Algorithm.
If you select Standard in
this field, all preset parameters will be ignored and the normal
calculations apply to the order proposal.
- In the update program Stock
Item, a Stock Item
Group has to be assigned to the stock item.
- In the update program Stock
Item, an Order
Interval has to be defined for the stock item.
(Please note that an order interval in the stock item is superior to an
order interval in the supplier)
- In the update program Supplier,
an Order Interval has
to be defined for the supplier.
Example of a sales-based order proposal:
The
order quantity is based on the calculated average weekly consumption of the
item. This value is calculated from the actual item sale in the period defined
in the field Weeks Sales
in the update program Stock Item Group.
Example: Calculation of the order quantity
- 140 pieces sold
-------------------------------------- = 35 pcs. / week (average)
4 (Period Weeks
Sales)
- 35
---------------------------- = 5 pcs. average daily consumption
7
- 5 x 10 Order Interval = 50
pcs. calculated order quantity
Further
on, an adjustment factor can be entered in the update program Stock Item Group
in the field Adjustment
Percent to influence the proposed order quantity.
Example Adjustment Percent:
If
the calculated order quantity is 50 pieces and if a value multiplication factor
of 50% has been entered in the field Adjustment Percentage,
the order quantity is 75 pieces.
- A multiplication factor of 0% leaves the order
quantity unchanged.
- With a multiplication factor of 300%, the order
quantity is 200 pieces.
- With a multiplication factor of -50%, the order
quantity is 25 pieces.
- With a multiplication factor of -100%, the order
quantity is 0 pieces.
Minimum and Maximum Quantity in Stock
If
you selected the Order
Algorithm "Algorithm 1"
in the update program Stock Item Group, the
following calculation for the actual quantity to be ordered from a supplier is
carried out.
This
calculation is to definitely guarantee that a quantity is ordered that is at
least keeping the defined Minimum
Stock and at most does not exceed the defined Maximum Stock for this stock item.
- Order quantity + Quantity in stock + Quantity of
the open orders < Minimum quantity in stock
= Minimum quantity
- Order quantity + Quantity in stock+ Quantity of
the open orders > Maximum quantity in stock
= Maximum quantity in stock – Quantity in stock – Quantity of the open
orders
Rounding
After
the calculation has taken place, there will be a rounding of the Minimum Order Quantity for this item
defined in the update program Supplier Item.
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany