|
INVENTORY MANAGEMENT
(Procedure being followed since 1998)
I. Placement of orders with Local
Manufacturers and Import Suppliers of IMFS/BEER.
The requirement of IMFS and Beer is worked out on the first day of every month.
The monthly depotwise requirement is worked out by adopting the following
procedure.
i) Weighted average sale per day is
arrived at by dividing the total sales with No. of working days during the last
three months with weightage being given to the recent sale.
ii) The monthly order for IMFS and
Beer is generated based on the Weighted average sales per day multiplied by 39
days in the case of local IMFS and 52 days in the case of import IMFS and in
case of Beer the Weighted average sale per day is multiplied by 39 days.
iii) 39 working days in 1 ½ months and 52 working days and 2 months is taken for
calculating the order to be generated, since we need atleast a month’s stock to
be generated on the first of every month. The extra days is allowed for the
transhipment of the stock.
iv) Stock in transit i.e. indent issued but not despatched, goods despatched but
not unloaded and the closing balance available at the Depot on the last day of
that month will be deducted from the monthly requirement arrived at as per the
working mentioned at Point No.(ii) above.
v) The net requirement for IMFS will be rounded off to the nearest multiples of
5 and the net requirement for fast moving Beer 650ml/325ml pack will be rounded
off to the nearest multiples of 700/600 cases. In respect of slow moving Beer
brands the net requirement will be rounded off to the nearest multiples of 50
cases.
II. ISSUE OF INDENTS
On 1st of every month the order is placed with all the local manufacturers and
import suppliers and indent is regulated in order to have 15 days stock of a
particular item in the depots including stock in transit. This ensures that the
brand does not go out of stock at any point of time.
Day to day indents are issued based on the previous day sale, closing balance of
that day, demand of the fast moving items etc., which is reflected in the daily
statement showing depots with ‘Nil stock’ and ‘low stock’ (inclusive of
cumulative stock in Transit) of fast moving items. This statement shows the
depots which have NIL stock, 1-3 days stock, 4-7 days stock, 8-10 days stock,
11-14 days stock and 15-21 days stock for particular brand and for a particular
pack size. Based on the statements, indents are being issued to the suppliers on
a daily basis. If a particular brand and pack size is in exceptional demand in
the current month and there is a likelihood of stock out situation, then
additional order for that particular item is placed and indents issued
thereafter.
No preferential treatment is given to any supplier and the systems mentioned
above (which has been computerized) is strictly followed since 1998. After take
over of retail vending by TASMAC also the same procedure is being followed
without any change.
After the indents are issued the daily despatches from the suppliers is also
being monitored by TASMAC.
The stock position in all the TASMAC depots is updated every day in this
Website.
|
|
|
|
|
|
|
|
|
STATEMENT SHOWING TOP SELLING TEN BRANDS OF IMFS 180 ML. |
|
|
DURING THE PERIOD 29-11-2003 TO
30-04-2006 |
|
|
|
|
TOTAL NUMBER OF BRANDS : 91 |
|
|
|
|
|
SALE OF 180 ML PACK : 82.31% |
|
|
|
|
|
|
|
|
|
|
|
SL. |
Name of the supplier |
Brand Name |
Sales Vol. |
% to total |
|
|
No. |
|
|
(in cases) |
sales |
|
|
|
|
|
|
|
|
|
1 |
Balaji Distilleries Ltd. |
No.1 MC Dowell Medium Brandy |
5428161 |
10.40 |
|
|
|
|
|
|
|
|
|
2 |
Shiva Distilleries Ltd. |
Monitor Ordinary Brandy |
4746453 |
9.10 |
|
|
|
|
|
|
|
|
|
3 |
Mohan Breweries & Distl Ltd |
Old Monk xxx Ordinary Rum |
9357631 |
7.59 |
|
|
|
|
|
|
|
|
|
4 |
Mohan Breweries & Distl Ltd |
Old Monk Deluxe Rum |
2132379 |
4.09 |
|
|
|
|
|
|
|
|
|
5 |
Mac Agro Industries Ltd |
John Exshaw Medium Brandy |
2002765 |
3.84 |
|
|
|
|
|
|
|
|
|
6 |
Midas Golden Dist. Pvt Ltd |
MC Dowell Amber Select Rum |
1497736 |
2.87 |
|
|
|
|
|
|
|
|
|
7 |
Balaji Distilleries Ltd. |
No.1 MC Dowell Medium Whisky |
1485702 |
2.85 |
|
|
|
|
|
|
|
|
|
8 |
Empee Distilleries Ltd. |
Old Secret XXX Rum |
1456916 |
2.79 |
|
|
|
|
|
|
|
|
|
9 |
Shiva Distilleries Ltd |
Monitor Ordinary Whisky |
1449752 |
2.78 |
|
|
|
|
|
|
|
|
|
10 |
Shiva Distilleries Ltd. |
Shivas XXX Ordinary Rum |
1253230 |
2.40 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
STATEMENT SHOWING TOP SELLING FIVE BRANDS OF
BEER - 650 ml. |
|
|
DURING THE PERIOD 29-11-2003 TO
30-04-2006 |
|
|
|
|
TOTAL NUMBER OF BRANDS : 13 |
|
|
|
|
|
SALE OF 650 ML PACK : 85.72% |
|
|
|
|
|
|
|
|
|
|
SL. |
Name of the supplier |
Brand Name |
Sales Vol. |
% to total |
|
|
No. |
|
|
(in cases) |
sales |
|
|
|
|
|
|
|
|
|
1 |
Mohan Breweries & Dist. Ltd |
Haywards 5000 Super Strong Beer |
5463607 |
18.95 |
|
|
|
|
|
|
|
|
|
2 |
Balaji Distilleries Ltd. |
KING Fisher Super Strong Pre. Beer- BAL |
4154145 |
14.41 |
|
|
|
(Brewery Division) |
|
|
|
|
|
3 |
Balaji Distilleries Ltd. |
KING Fisher Premium Lager Beer - BAL |
3587716 |
12.44 |
|
|
|
(Brewery Division) |
|
|
|
|
|
4 |
Mohan Breweries & Dist. Ltd |
Black Knight Super Strong Beer |
2998368 |
10.40 |
|
|
|
|
|
|
|
|
|
5 |
Empee Breweries Ltd. |
Marcopolo Super Strong Beer -EMB |
1958472 |
6.79 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
* * * * * * * * * * * *
|