SL NO |
KEY WORD |
EXPLANATION |
1 |
Area |
It represents each geographic
area that belongs to a chain within the organizational hierarchy. It could be
states or countries based on the geographical. Each area can belong to only
one chain. |
2 |
ARS |
Auto Replenishment System is the
functionality in RMS which calculates the ROQ based on the replenishment
settings done by the PM in RMS |
3 |
ASPD |
Average Sales Per Day is the
average of the quantity sold in a day during the stipulated time period. It
is calculated as (qty_sold / number of days) |
4 |
ATS |
Available To
Sell means a product is in good condition meeting all the necessary standards
for sale of it to a consumer |
5 |
Average Cost |
This is the moving weighted
average of unit cost captured at SKU location level. Used in margin
calculations and General Ledger for stock ledger maintenance. It is
calculated as ((SOH x average cost) + (Incoming qty x
unit cost))/(SOH + incoming qty) |
6 |
Average Holding Inventory |
It is the average stock
value held for particular times. It is used for inventory turnover and return
on investment calculation. It is calculated in general as (opening
Book qty + closing Book quantity)/2 or
as (opening Book qty + closing Book quantity) / (number of months+1) based
on the application of the formula |
7 |
Banner |
Channels are further divided
into banners for better understanding of the different categories in the
respective business channel |
8 |
Barcode |
Barcode is a scanner readable
code in the form of a pattern of lines with varying width that is printed on
a product. This displays the UPC of the product at the POS upon scanning to
register the sales against the respective product |
9 |
BI |
Business Intelligence is an
approach to analyse data to extract facts and relations that can be presented
to the executives of an organisation to make more informed business decisions
and define best practices in different areas of operations |
10 |
Book Stock |
This is the stock on hand held
in the system at a given point in time. Book stock is use in inventory
analysis and variance calculations |
11 |
Branch
/ Store |
A Location where
products are sold i.e. a place where sales and returns take place for the
product sold or service rendered. In general branches/stores are treated as
profit centre in a retail organisation |
12 |
Case Pack Size |
It is the quantity of a single
SKU that can be accommodated in one case that is supplied by the supplier.
Purchase Orders are by default placed in case pack size. This is also known
as supplier pack size |
13 |
Cash Float |
A float is a small amount given
by the head cashier to a cashier while allocating the POS Till during the
opening of the shift. This is given in multiples of smaller currency in order
to return change to customers at the time purchase. The amount it returned to
the head cashier during end of shift |
14 |
Chain |
It is the first level of the
organization hierarchy below company in Oracle Retail. Can
be used to group by store formats, concepts, geographical groups, etc. Operating currency code can be defined for the Chain. |
15 |
Channel |
This defines the
different types of business models the retailer is involved in such as
Catalogues store, Brick and Mortar, Ecommerce, etc. Profit centres or stores
can have designated channels incorporated in the ERP for reporting purpose
and drafting business plans |
16 |
Class |
Class is the second lower level
in the merchandise hierarchy. This is the further subdivision of department
to identify further levels of classification in a product line. Vat setting
is also done at this level |
17 |
Company |
This is the highest of
merchandise and organizational hierarchy in Oracle Retail. This is the level
at which financial accounting is summarised in Oracle Financial system |
18 |
CRM |
Customer Relationship Management
deals with the policies defined by an organisation to communicate with its
existing customers and future potential customers. It covers areas of ERP,
Customer Service Desk, POS, loyalty programme, marketing, data integration,
customer data analysis, analytics and digitalisation |
19 |
Customer Conversion Rate |
It is the percentage of
customers who have actually bought a retailer’s product or service when
compared to the total footfall/Walk-in for the stipulated time period. It is
calculated as (Number of Bills/Footfall) x 100 |
20 |
Customer Return / Sales Return |
This is the process wherein a
customer returns the purchased product to the retailer due to
dissatisfaction, damages or product quality. The product is accepted by the
branch if it falls under the Returns Policy of Nakumatt Holdings and a Credit
Note is given as a token of acceptance which can be used by the customer to
purchase another product of their choice at Nakumatt branches |
21 |
Cycle Count |
These are short span
perpetual inventory checks done at store and warehouse locations for high
value shrinkage SKUs, in order to identify the root cause for loss of
inventory. Cycle counts are also done at warehouse on regular basis to do
health check for internal storage locations to avoid hurdles caused while
picking due to incorrect inventory |
22 |
Data Cleansing |
Data cleansing is an activity
done at short term intervals by technical support team to comb the data in
the database by validating table relations and accuracy of the data
present |
23 |
Department |
Department is
also called as Category is a key level in the merchandise hierarchy where a
cluster of Classes with similar product line is listed under one group for
higher level reporting and classification. Budgeting, markups, intake
margins, tax settings and purchase type of a category is defined at this
level |
24 |
District |
Groups Stores within a Region
(generally geographically) Each District can belong to only one Region |
25 |
Division |
It is the
highest level in merchandise hierarchy below Company. A cluster of groups
with similar product line is listed under one division for higher level
reporting and classification |
26 |
DSR |
Daily Sales Report is generated
as part of EOD activity at stores. It is generated in order to reconcile
tenders and cash collected during the day and compared it against the system
generated report. Short in cash collected or card swipes are identified. |
27 |
End User |
End users are people to use the
application to execute their day to day activities. Any technical change or
process change brought in will impact the end user, hence proper user
training is needed before deploying any
change |
28 |
EOD |
End of Day is the process which
involves closure of POS tills and generation of sales report along with sales
log file for the day from back office system. This marks the end of all the
transaction at store for the day. Post this activity completion, any new
transaction can be done in the next business date only |
29 |
ERP |
Enterprise Resource Planning is
a suite of integrated applications that we use to collect, store, manage and
interpret data from our day to day business activities, including: Product
planning, costing, Pricing, stock ledger maintenance, supply chain management,
Marketing, sales, etc. |
30 |
GMROI |
Gross Margin Return on
Investment ratio helps retailer to know what level of returns can be obtained
upon the investment made for a stipulated time period. In simple terms it
helps us understand the performance of a category/ item with respect to gross
sales margins. This is calculated as (Gross Margin value
/ Average Inventory Cost)
where Gross Margin value is (Gross Sales - COGS)/Gross Sales |
31 |
GMROS |
Gross Margin Return on Selling
Area ratio explains the gross margin made by the product upon the selling
area allocated for the product. This is used by retailers to find the gross
margin per square feet in the selling area and take decision on expansion of
selling area or reduce the selling area or discontinue the product all
together. This is calculated as (gross margin
value/selling area in sq ft) |
32 |
GRN |
Goods Received Note is the
document created when a Purchase Order is received at the branch or warehouse |
33 |
Gross Sale |
This is sum of the total amount
paid by a customer to a retailer for the service enjoyed or a product
purchased. This is used for reconciliation of tenders in Daily Sales Report
during End Of Day Process |
34 |
Group |
This is the second highest level
in merchandise hierarchy below division. A cluster of department with similar
product line is listed under one group for higher level reporting and
classification |
35 |
Help Desk |
A system (application, people
and process) put in to place to provide support and resolve issues and
concerns raised by IT and Business users within an organisation. This acts
both as a bridge and a repository for communications between Business, IT
Department and support team |
36 |
Inner Pack Size |
It is the break pack size of a
supplier case i.e. how many quantities of an SKU are present within the break
pack of a supplier case |
37 |
Intercompany Transfer |
It is the transfer of goods
between two different transfer entities. Such transfers are treated as Sale
of Goods from one transfer entity to another in financials, hence the name
Inter-company |
38 |
Inventory Turnover |
It represents the number
of times a retailer rotates his inventory during the considered time period.
This is used to know how efficiently inventory is handled within the
organisation.
It is calculated as (COGS/Average Inventory Held)x100 |
39 |
IPO |
Import Purchase Orders is the
document released to a supplier from another country for supply of goods for
a requested quantity within the stipulated time period |
40 |
KPI |
Key Performance Indicators are
metrics used by a retail organisation to evaluate the performance in
respective area of interest. KPI differ from organisation to organisation. A
few examples are Sales metrics, Customer loyalty metrics, Vendor Performance Metrics,
Inventory Metrics |
41 |
KRA |
Key
Responsibility Areas are general outputs or responsibilities that are given
to a particular team or role. The performance of the team member or head is
measured based on the fulfillment of his KRAs |
42 |
LPO |
Local Purchase Order is the
document released to a supplier for supply of goods for a requested quantity
within the stipulated time period |
43 |
Master
Data Management |
It is the approach taken by the
retailer to manage the masters related to SKUs, Barcodes, Suppliers,
taxations, locations, SKU – supplier and SKU – Location mapping, etc. As a
best practice retailers form a Central Data Management team to centrally
control all data related to master data changes to ensure better control and
reduce human error |
44 |
Maximum Book Quantity |
This is the maximum stock
expected to be maintained an SKU at a location at any given point in time to
meet the projected demand. This is used as a check for over ordering; thereby
ensuring LPO is not be raised for quantity beyond this point. In general referred
to as MBQ along on with minimum book quantity |
45 |
Minimum Book Quantity |
This is the minimum stock
expected to be maintained for a SKU at a location at any given point in time
to meet the projected demand. This is usually set as the reorder point for
the SKU and when the stock levels hit this point, new LPO is raised to meet the
maximum book quantity. In general referred to as MBQ along on with maximum
book quantity |
46 |
Net Sale |
This is the sales made by a
retailer excluding the VAT amount. Scan margin is calculated from Net Sales
and not from Gross sales. It is calculated as Gross
Sale/(1+(VAT/100)) |
47 |
Non-Trading Item |
These are inventory SKUs for
which stock in maintained but are not sellable at POS. These include
stationary, packing material, carry bags, etc. that are bought for internal
use and packaging purpose. There is no direct revenue generated from these
SKUs |
48 |
Pallet Size |
It is the quantity of SKUs that
can be stacked in a pallet. This is calculated by as (TI
X HI) where in TI is the number of cases that make
up one tier of a pallet and HI is the number of tiers that make up one pallet
vertically |
49 |
Perpetual Inventory |
This is a method of tracking
sales and purchases of an SKU in the system in near real time. This is
achieved by implementation of a robust inventory management ERP |
50 |
Petty Cash |
An easily accessible amount of
cash given on regular intervals to the profit centres in a retail
organisation for purchase of low value non trading items and to accommodate
small expenses related to repair and maintenance. A report on usage of the
fund it given by the profit centre to the head office based on which funds
are reimbursed. |
51 |
Pickup Lead Time |
Time taken for transfer of goods
from the supplier’s dispatch location to the retailer’s warehouse or store.
This is added to the supplier lead time to arrive at the total time taken for
supply of goods from the date of order approval |
52 |
PM |
Procurement manager or head who
handles the buying and allocation of goods for his/her respective category |
53 |
POQ |
Prescaled Order Quantity is the
final order quantity that is requested from the supplier based on the
supplier pack size. This is the nearest rounding off of the ROQ based on
supplier pack size and rounding off threshold set in the system |
54 |
POS |
Point of Sales is a till at the
branch where payment transactions related to sale or return of Goods. It is
the place when the customer pays the retailer for the product or service
offered |
55 |
Rate of Sale |
This is the rate at which
sale has increased or decreased in the current period compared to a similar
period in the past. It is calculated as {(Current Period
sale – Past Period sale)/Past Period Sale}x100 |
56 |
Region |
Groups Districts within an Area,
such as North, South, etc. Each Region can belong to only one Area |
57 |
ReIM |
Retail Invoice Matching is the
ERP module that facilitates users to reconcile vendor invoices with GRN and
raise Credit Note Request, Debit Memos, Credit Memos and release advisory to
OFIN-AP for vendor payments |
58 |
RFM |
Recency Frequency Monetory
Value' is a term used to measure the customer value in retail. It is commonly
used in database marketing and direct marketing and has received particular
attention in retail and professional services industries
Recency : How recently the customer has purchased from the retailer
Frequency : How often does the customer buy
Monetory Value : How much does the customer spend on an average per
purchase |
59 |
RMS |
Retail
Merchandising System is the ERP module that facilitates users to manage the
master data and inventory at Nakumatt |
60 |
ROI |
It is the percentage to measure
the performance of gains obtained from the total investment made in
a product or total capital invested in a business. It will give clarity on
how soon we can recover our investment cost or what percentage of profit
we can expect from our investment. It is calculated as
(Net Profit/Total Investment) x 100 |
61 |
ROQ |
Recommended Order Quantity is
the requirement for goods placed by the branch or warehouse to the
procurement team. This can be system generated through ARS based on SOH and
MBQ set or manually calculated |
62 |
RPM |
Retail Price Management is an
ERP module used to manage pricing for products sold by a retailer.
Promotions, clearance and regular price changes at product level are done
through this module. This publishes the information of price changes made to
POS through interface and batch programs |
63 |
RTV |
Return to Vendor is the document
created to assist to return of goods back to supplier due to various reasons
such as damaged, non-selling, etc. A credit note is given by the supplier as
a receipt of acceptance of the document |
64 |
SBU |
Strategic Business Unit is a
group of profit centres management discretely due to their distinct catchment
attributes though they are all held by a single retail organisation. Each
unit will have a discrete marketing plan, business plan, competitive analysis
done to improve efficiency and sales |
65 |
Scan Margin |
It is the margin made by a
retailer by selling a product or service to a customer. This is arrived from
Net Sale i.e. Sales value after Tax inorder to eliminate the VAT or other tax
factor which are to be paid to the government. It is calculated as {(Net Sale – COGS)/ Net Sale}x100 or as
{{Gross Sale – (COGS x (1+vat/100))}/Gross Sale}x100 |
66 |
Selling Unit Retail |
It is the price at which a
retailer sells a product or service to a customer |
67 |
SIM |
Store Inventory Management is
the ERP module that facilitates users to manage store inventory and
reordering |
68 |
SKU |
Stock Keeping Unit is the level
of the SKU at which stock in maintained in the system. SKU is also called as
Item in retail |
69 |
SME |
Subject Matter Expert is a
person who has high level of expertise in his domain who can guide and bring
in change based on best practices. They are consulted for all changes and
development in their respective domain, both operational and technical |
70 |
SOD |
Start of Day involves the
process of download of master data and price change data into store Back
Office and Point of Sale. This also involves the process of float cash
distribution and opening of POS tills for business transactions |
71 |
SOH |
This stands for Stock On Hand.
In retail operations this refers to the physical stock for an SKU at a
particular location. In RMS this also refers to the book quantity for an SKU
at the respective location |
72 |
SOP |
Standard Operating Procedures
are documents explaining the steps to be followed in various operating areas
within an organisation such as Operations, Environment, Service, Inventory
management, Visual Merchandising, etc. This is done in order to maintain
discipline uniformity and quality standards within the organisation |
73 |
SPF |
Sales Per Square Foot/
Sales Per Footage is a retail calculation made to calculate the sales made
per square feet sales area. This will give us the efficiency of the store
sales team.
It is calculated as (Total Sale)/(Total Sales Area (sq
ft)) |
74 |
Stock Audit |
These are periodic
perpetual inventory checks done at a branch or warehouse location to
reconcile the physical inventory with book stock and arrive at the
shrinkage/variance. The variance is taken against the sales for the time
period to arrive at the variance percentage. This will give a good picture on
loss in margin to the retailer due to variance/shrinkage. It is calculated as
(Variance Cost Value/Total Sales for the period)*100 |
75 |
Stock Holding Days |
Based on the current SOH and the
ASPD, a merchandiser can determine the number of days it would take for the
existing inventory to be exhausted. This is used as an input parameter to
arrive at the recommended order quantity in manual calculations and also in
pricing strategy to liquidate non selling SKUs through discounts |
76 |
Store Order Multiple |
It defines the multiples of
quantity that the store can request from the warehouses. It can be set as
Each, Inner or Cases, so the store’s ROQ and transfer requests are placed as
per inner size and case size defined |
77 |
Subclass |
Subclass is the lowest level of
merchandise hierarchy. This is the further subdivision of class. Subclass is
not unique and can repeat i.e. same subclass featuring in different class
unlike other levels which are unique. Retailers can use Subclass to define
brands |
78 |
Supplier Lead Time |
Time taken from the date an
order is released to the supplier to the date when the supplier readies the
stock for dispatch. This is added to the pickup lead time to arrive at the
total time taken for supply of goods from the date of order approval |
79 |
Tare weight |
Tare weight or Tare in the
weight of the empty container that holds the products. By subtracting the
tare weight from the gross weight, we can obtain the net weight of the goods
carried in the container |
80 |
Transfer Entity |
Transfer entity is a group of
locations that share legal requirements around product management. An
inter-company transfer occurs when product is transferred between locations
with different transfer entities. Inter company is handled as sale of goods
from one entity to another in financials |
81 |
Transfer
Zone |
Clusters of
profit centres or stores defined in the system to allow transfer of goods.
Goods can be transferred only in between stores falling under the same
transfer zone |
82 |
UDA |
User Defined Attributes are
characteristics that can defined for an SKU to identify or group them for
reporting purpose such as Brands, Product type, etc. Other user attributes
that can be defined in RMS as ‘free from text’ UDA used for defining legacy item
code against oracle code for reference purpose and ‘Date’ UDA used for
defining expiry date or manufacturing, etc., |
83 |
Unit Cost |
This is the cost price at which
a product is purchased by the retailer from a supplier. This is always
excluding the vat rate. This can also be expressed as the net selling retail
(net sale) the supplier charges for sale of goods to the retailer |
84 |
UPC |
Unique Product Code is the
unique number given to a product, usually by the manufacturer which is
embedded into a Barcode or a QR code on the product for scanning purpose |
85 |
UTS |
Unavailable To Sell means a
product is not in a good condition or does not meet the necessary standards
for sale to a consumer. Such products are returned back to the supplier or
written off from the book quantity and scrapped |
86 |
Variance / Shrinkage |
These are quantities identified
as Loss in book quantity while doing a cycle count or a stock audit. It is a
direct loss to the organisation. It is calculated as (Physical
Count – Book Stock) |
87 |
VAT |
Value Added Tax is the charge
levied on a product or service based on the selling retail. This is paid to
the government at regular time intervals by the retailer.
Selling price - (selling price/(1+(vat/100))) |
88 |
Warehouse |
A location where products are
stored and distributed centrally for a particular catchment area serviced by
the warehouse. In general warehouses are treated as cost centre in a retail
organisation |
89 |
WMS |
Warehouse Management System is
the ERP module that facilitates users to manage Warehouse inventory, perform
complicated warehouse tasks with ease and receiving/shipping of goods based
on requests created in RMS and SIM |
90 |
Omni Channel |
Omni Channel is a means of
providing the customer with a seamless shopping experience whether they shop
online or through mobile app or telephone or brick and mortar. Omni channel
presence is a big advantage to a retailer because it increase market reach
and sustaining customer base by giving them convenient modes of shopping |