Inventory Management And Distribution In A Retail Chain
Overview of the Company
Background of the ACI Ltd.
ICI Plc of UK had a pharmaceutical business in Bangladesh. In 1992 the business was sold to management and the name of the Company changed to Advanced Chemical Industries (ACI) Limited. ACI inherited the rich ICI culture of product quality, customer service and social responsibility and continues to nurture.
ACI is the first company in Bangladesh to obtain certification of ISO 9001 Quality Management System in 1995. ACI is also the first Company in Bangladesh to get certification of ISO 14001 Environmental Management System in 2000. ACI employees are proud of their work culture, business ethics and environmental consciousness.
ACI values are embodied in its vision and mission statements. ACI quality and environmental concerns are clearly stated through declared policies.
What was primarily a Pharmaceutical business in 1992 with a turnover of Tk.80 million with stagnant growth, the new management brought about fundamental changes in policies and has in year 2005 grown to over Tk. 3413.05 million in turnover through diversified business interest including personal care products, food products, animal health, agrochemicals and seeds in addition to gaining a strong position in Pharmaceuticals.
ACI represents principals like AstraZeneca, UCB, Searle and Fujisawa in Pharmaceuticals business; Colgate-Palmolive, Heinz & Dabur in Consumer Products sector; Synzenta in Agrochemicals; Ranbaxy, Dabur, Wockhardt, Sanofi and Invesa in Animal Health sector.
The trading subsidiary of ACI represents in Bangladesh principals like ICI, Exxon-Mobile, Bayer, and Stahl.
Mission and Vision of ACI
ACI’s mission is to enrich the quality of life of people through responsible application of knowledge, skills and technology. ACI is committed to the pursuit of excellence through world-class products, innovative processes and empowered employees to provide the highest level of satisfaction to its customers.
To realize the mission ACI will
Endeavour to attain a position of leadership in each category of its businesses
Attain a high level of productivity in all its operations through effective and efficient use of resources, adoption of appropriate technology and alignment with our core competencies
Develop its employees by encouraging empowerment and rewarding innovation
Promote an environment for learning and personal growth of its employees
Provide products and services of high and consistent quality, ensuring value for money to its customers
Encourage and assist in the qualitative improvement of the services of its suppliers and distributors
Establish harmonious relationship with the community and promote greater environmental responsibility within its sphere of influence
Overview of ACI Group
1. Health Care (Pharmaceuticals)
2. Consumer Brands
3. Agri -Business:
4. Crop Care Public Health
5. Animal Health
7. ACI Motors
9. 2.3.2 Subsidiaries and Joint Ventures:
12. ACI Salt Limited
Formations of ACI Logistics Limited
To drive strategic synergy among all businesses management has decided to open a new window of business through which ACI can a make bridge between farmers and consumers. So with a view to getting the consumers class under direct umbrella of ACI initiatives have been taken for launching “Retail Chain Operations ‘ throughout the country and hence to give birth of the new company “ACI Logistics Limited” having brand name “Shwapno”. It was basically a dream to change landscape of general people lifestyle in terms of their shopping experience and people like farmers who do not get the right price of their selling products.
Vision of ACILL
To change the lifestyle of Bangladeshi consumers through responsive supply chain operations with a proposition of affordable relevant quality products .
Values and Belief of ACILL
Competitive Advantage of ACILL
Brand Name of ACILL
A product identity, or brand image are typically the attributes one associates with a brand, how the brand owner wants the consumer to perceive the brand – and by extension the branded company, organization, product or service. The brand owner will seek to bridge the gap between the brand image and the brand identity. Effective brand names build a connection between the brand personalities as it is perceived by the target audience and the actual product/service. The brand name should be conceptually on target with the product/service (what the company stands for). Furthermore, the brand name should be on target with the brand demographic.
Functional Overview of ACILL
Supply Chain Management (SCM)
A supply chain is the system of organizations, people, technology, activities, information and resources involved in moving a product or service from supplier to customer. It consists of all parties involved, directly or indirectly, in fulfilling a customer request. Supply chain activities transform natural resources, raw materials and components into a finished product that is delivered to the end customer. In sophisticated supply chain systems, used products may re-enter the supply chain at any point where residual value is recyclable. Supply chains link value chains. A supply chain is dynamic and involves the constant flow of information, product and funds between different stages within the organization as well as with other organization.
The term supply chain conjures up images of product or supply moving from suppliers to manufacturers to distributors to retailers to the end customer along a chain. This is certainly part of supply chain, but it is also important to visualize information, funds and product flows along both direction of the supply chain. The supply chain includes not only the manufacturer and suppliers, but also transporters, warehouses, retailers and even customer themselves.SCM include the following operations-
Non Inventory Procurement
Supply Chain Framework
|Strategic Planning||Supply Chain Framework||Supply Chain Policy|
|Planning||Demand Planning||Supply Planning||S&OP process for demand & supply reconciliation & gap recognition|
|Supplier Development||Supplier Development Program||Supplier Identification & Selection||Supplier Training & Development||Supplier Performance Appraisal, Retention & Reward||Quality|
|Procurement||Procurement Policy||Procurement Execution System||Procurement Evaluation & Monitoring|
|Logistics||Distribution Network||Assessment of distribution variables at Supply Source & Outlet||Selection of WH Locations||Optimization of Distribution Network|
|Warehousing||Physical Management||Process Documentation||Shrinkage & Pilferage Management||Managing Quality at WH|
|Fleet Management||Transportation Policy||Transportation||3PL Management|
|Crisis management||Contingency Inventory Planning||Procurement||Logistics|
|IS Visibility||SC Planning||Supplier visibility||Procurement Visibility||Inventory & Logistics Visibility|
|Supplier visibility||Procurement Visibility||Inventory & Logistics Visibility|
There are classifications of buying in ACIL. One is inventory buying and another is non-inventory procurement. Non-inventory procurement includes specially asset type buying like fixtures, freezers, Gondola, Vehicles etc. This department was the leading dept. for rolling out. the whole project. Without fulfillment of any sort of procurement no stored has been opened.
Imported items also fall under non-inventory procurement. Others jobs like services such as maintenances, renting space are also being handled by this department. Stores consumables Requisitions come also to this department and then further actions taken accordingly by non-inventory procurement personnel.
A constrained forecast is a forecast of bookings as we expect them to be constrained by inventory controls (usually, by recommended inventory controls from an RMS)
A constrained forecast is not a forecast constructed solely from historical constrained demand observation.
|Stratigic planning||Business Plan||Policy & Process mgt||Knowledge & Learning Mgt||Compititive Intelligence|
|Marketing Resousces||Marketing Mearsurement & Understanding||Optimization of Marketing Learning|
|Project Mnagement||Project Portfolio Mgt||Monitoring & Control|
|Enterprise Risk Management||Emplement ERM Framwork||Institutionalize ERM Process|
2.8.3 DC Operation:
The main activities of DC operations are:
Create purchase requisition and inform to buying.
Receive products and serve outlets according to their demand
Product identification and handling
Return and Damaged Product Handling
File and Document Management
Safety and security maintenances’ of products.
All products are distributing to outlets from DC. So DC maintains an important role for Shwapno.
FIGURE1:Shwapno DC is Progress in Space Utilization and Storage
FIGURE2:DC Progress in Bar coding
FIGURE3: DC Progress in Material handling
FIGURE4: DC Progress in Perishables Handling
Three DC throughout the country to serve the total business
Central Distribution Centre (CDC): Dhaka, Narayangonj, Gazipur, Manikgonj, Netrokona, Jamalpur, Sherpur,Tangail, Faridpur.
Chittagong Distribution Centre (Ctg DC): Chittagong, Coz’s Bazar, Rangamati, Feni, Noahkali, Bandorban, Khagrachori.
Sylhet Distribution Centre (Syl DC): Sylhet, Moulovibazar, Hobigonj, Sunamgonj.
Logistics is that part of the supply chain process that plans, implements, and controls the efficient, effective flow and storage of goods, services, and related information from the point-of-origin to the point-of-consumption in order to meet customers’ requirements.
Three objectives of logistics strategy:
Cost reduction (variable costs)
Capital reduction (investment, fixed costs)
Customer Service (outlet)
Demand forecasting (PR generation)
Warehouse site selection
Return goods handling
Salvage and scrap disposal
Traffic and transportation
Warehousing and storage
In retail, Logistics activities will divide into two categories:
The term “Resource” applies to all of the factors of production, including materials (e.g., goods we handle), equipment (e.g., trolley or vehicles), energy (e.g., electricity) and labor.
Fundamental logistics questions are-
When a resource (material, machine or labor) should be put in inventory and taken out of inventory.
Where should a resource be stored?
Some of the important inventory questions are:
How much does it cost to store resources in inventory?
How much “safety stock” should be carried in inventory to prevent against running out of a resource?
How much inventory should be carried in order to smooth out seasonal variations in demand?
Fundamental logistics are:
Where resources should be moved to, and by what mode and route.
When resources should be moved.
The “where” question includes the topics of terminal location,
Vehicle routing, and shortest path methods and network flow
The “when” question includes the topic of distribution rules.
Some of the important questions are:
What are the best vehicle routes?
When should a vehicle be dispatched over a route?
Do we use hired vehicle or own vehicle for a particular delivery?
2.8.5 Marketing and Merchandising:
As per discussion with executives of Marketing and merchandising team, this function work as per following chart activities in summarized format.
|Revenue||Customer||Basket Size||In-Store Activities||Value Added Service|
|Merchandise Assortment Plan||Pricing||Promotion||Demand Plan|
|Brand Mgt||Brand Development & Design||Brand Equity||Brand Communication|
Typical Retail Marketing and Merchandising Departmental Structure:
2.8.6 Finance and corporate affairs:
Typical Retail Finance and corporate Departmental Structure:
2.8.7 Information Systems:
Typical Retail Information Systems Departmental Structure:
2.8.8 Human Resource and Admin
Typical Retail Human Resource and Admin Departmental Structure:
3. Overview of Retail Chain
3.1 Retail Chain:
Chain stores are retail outlets that share a common brand and central/ decentralized management under one umbrella linking with each other and usually have standardized business methods and practices.
The displacement of independent businesses by chains has generated controversy in many countries, and has sparked increased collaboration among independent businesses and communities to prevent chain proliferation. Such efforts occur within national trade groups and community-based coalitions.
3.2 Retail Chain in Bangladesh
In Bangladesh, where economy is based on agriculture altogether, are required to emphasize more on agribusiness and supply chain development since these countries lack sufficient technology to move to industry, which requires natural resources as well as extensive technological knowhow. Every country has comparative advantage on some area, and so does Bangladesh. Comparative advantage of Bangladesh is supposed to be agriculture. It cannot deny the role of agriculture to the economy as it has to import a lot of food every year to meet the local demand, while there are lots of potentiality to grow foods if lands are properly used and modern technology is adopted in agriculture. Understanding the gap in the value chain, ACI has initiated to establish new businesses namely ACI Agribusiness and ACI Logistics to remove this gap, to uproot cartel, and to ensure reasonable price for both farmers and consumers.
The other retail shops are also establish in Bangladesh ,these are, Aagora, Nandon, PQS, Meena Bazar, Lavender, Family Needs. These all are popular and successful retail shop in Bangladesh.
3.3 Different Types of Retail operations
The different types of retail operations are Electronic retail business,Shoe retail chain, cosmetics retail chain, Development retail business,Motor retail chain, Furniture retail business,Car retail chain, Plastics retail chain in our country.
4.Overview of Shwapno- a Retail chain of ACIL
ACI Limited has got a great endeavor to expand its business for going to direct contact with consumers and hence they have launched their retail chain “Shwapno” which is direct consumers interfacing platform. The brand name “Shwapno” has come into the dashboard with the perspective of executions of dreams of transformation of life style of Bangladeshi retail consumers specially wet market consumers and buyers as well as transformations of farmers value chain with objective of right prices for everyone.
4.2Theme and Propositions of “Shwapno” Outlets:
The concept of establishing “Shwapno” has come from the thoughts of keeping pace of changing life style of Bangladeshi people specially growing GDP which supports upgraded buying pattern of general people of middle and lower middle class people. The core focus was alternative platform for overcoming present inconveniences of shopping in wet market. In our wet market (“traditionally called “kachabazar”) there is no right price, right weight and variations of right quality. This is much unstructured market where buyers can not exercise his rights specially women shopping is quite inconvenient whereas in our society women shoppers are growing.
So with view to giving right price, right weight and the shopping conveniences to buyers and consumers ACI has dreamed for opening its retail outlets “Shwapno” across the country. The basic propositions of the store is keeping Grocery, Vegetables & Fruits, Fishes, Meats, Household Items and company goods items. If we look at price propositions of green items then it’s lower than traditional wet market and quality is much better. Specially red meat quality is far better than others normal shops.
4.3Classifications of Store:
Considering variations of socio-economy class of people ACI has established different stores in different segment. Like for “A” class people whose monthly income more than 90,000 they have established “A” type store where Air-conditioned ambience is available and space is more than 3000 sqft and good equipment is available. But for lower middle class people they have created different stores which is less than 2000 sqft but air-conditioned ambience is not always available.
Price proposition is also different from store to store. They have four type of stores “ A” “B” “C” & “D”.
4.4Locations and Networking of Outlets:
ACI has now retail operations in three divisional towns. In Dhaka they have 34 stores, 3 stores @ Chittagong, 3 stores @ Sylhet. In Dhaka they have different stores area like Gulshan , Banani they have high standard store which area is 3500 sqft and product range is also high. But store @ Basabo is different and it’s less than 2000 sqft in size and not that much convenient. If we see top view of its spread its well spread net web of retail chain across the capital city.
Shwapno maintains more than 2000 to 5000 SKUs @ their stores. But it depends on locations and store type. “A” type store keeps 5000 SKUs and but “D” type store keeps around 2200 SKUs. High end personal product is available @ “A” type store like imported personal care items but that’s not available @ “D” type store,
4.6Revenue and Margin Propositions:
Across the world start-up revenue target of the retail chain is not that much attractive but in the long term huge revenue growth is possible though margin is not more than 17%. Retail chain like wall mart and Carrefour is around 18% but their revenue is much higher. Initially ACI has aimed for 500 cr annual revenue target with GP of 17% from its 50 stores. But initially they could not achieve but now a day their sales growth is double digit month on month. And margin is almost near to 15%. They are overcoming lot of hurdles as big player and new entrant in the market. It will take another 2 to 3 yrs to get NP in positive number
4.7Supply Chain Network:
To support all these stores Shwapno has its own central “Distribution Centre “. For perishable items they have specialized DC and for other Goods they have another two DC. One is in the heart of city and another is @ Savar. They have good supplier network for green items across the country which is linked with farmers. Almost more than 100 buying agents are involved for procuring fishes, meats and vegetables across the country.
5.Inventory Management in Shwapno
5.1 Literature overview of Inventory
Inventory is a list for goods and materials, or those goods and materials themselves, held available in stock by a business. Naturally many of the items a firm carries in inventory relate to the kind of business it engages in.
Inventory management is primarily about specifying the size and placement of stocked goods. Inventory management is required at different locations within a facility or within multiple locations of a supply network to protect the regular and planned course of production against the random disturbance of running out of materials or goods. The scope of inventory management also concerns the fine lines between replenishment lead time, carrying costs of inventory, asset management, inventory forecasting, inventory valuation, inventory visibility, future inventory price forecasting, physical inventory, available physical space for inventory, quality management, replenishment, returns and defective goods and demand forecasting.
What Is Retail Inventory Management
Retail inventory management is the process and methods used to keep track of the stock in a retail business. These methods control everything from ordering, shipping, receiving, tracking inventory, retail turn-over, and storage. Retail inventory management can help keep a business’ profits at a steady margin as well as reducing theft and loss of inventory. Many retail businesses lose money every year because they do not have a successful inventory management system in place.
How to Manage Inventory
Most businesses use some form of computer software to manage their inventory. Unless the retail business is very small, doing it manually would be very impractical, especially for large companies that deal in thousands of individual products.
A business that has a successful system for retail management will allow the business to keep a sufficient amount of stock to meet customer demand. If a business does not have enough inventories, then it can slow down cash flow. Too much inventory can cost business money and take up more room.
Managing retail inventory involves several characteristics and steps. One of the most important steps is to make sure that you always remove products from the system as soon as they are sold. The same is true for receiving shipments of new stock. Make sure you record it as quickly as possible.
5.2 Inventory classifications in view of category tree
Gift & Toys
5 .3Process flow/Diagram of inventory movement
5.3.1 Company Goods
5.3.2 Perishables Goods
5.4 Order generations and DC stocks building
As discussed earlier order generations are two types. Order for Company Goods and Perishables. Under broad aspect of perishables commodity is also included. But for DC stocks building order generations specially deal with company goods and commodity as perishables is day to day basis purchase and sell.
So for company goods and commodity, category management team do forecast of sales in line with outlet operations team considering daily average sales, any promotional effect which is coming, any festive effect etc. After that supply chain planning team consider the following things before generations of Order – in SAP terminology – “Purchase Requisition”
On Hand stocks in DC
Supplier Lead Time
Average DC consumptions
Stocks in transit
Open STO for stores
Considering the above parameters order generations take place from supply chain for optimum inventory level to reduce working capital and ensure outlet operations demand to a satisfactory level. This order generation basically passes through to Buying Department for ordering to vendors in the form of PO.
As per order quantity and no of SKUs vendor ensure supply at DC end within lead time. But in real scenario most of the time exact quantity not supplied and on-time delivery not takes place. Overall fill rate not more than 60% by vendors.
5.5 Inventory Receiving
Receiving, for the purpose of distribution center, refers to the collection of goods or products in the DC from Buying & Merchandising team personnel, buying agent, suppliers or distributors or manufacturer of those products.
Receiving procedure varies for:
Direct purchase by B&M Team/ Buying agents
Suppliers or distributors or manufacturer of company goods
For Direct purchase by B&M Team/ Buying agents:
Goods will be received as per chalan copy submitted by buying team; in chalan copy the following three things will be mentioned:
Weight or Quantity of items measured on the basis of set UOM in MAP
Trade price/ Unit price/ Rate/ COGS of items
IS ID for respective line item.
Inventory personnel will generate GRN in system as per provided IS ID, T.P/Rate and quantity or weight of each line item.
Warehouse/ DC personnel will measure the weight of goods or quantify the acceptable goods (as per quality guidelines) physically in number and cross check with respective line items as stated in delivery chalan submitted by B&M Team.
The inventory personnel will treat the following three different situations in below process:
If Goods found in same quantity as mentioned in delivery chalan, then GRN & delivery chalan will be printed and kept along for document processing.
If goods found excess than the quantity mentioned in delivery chalan, there needs to make adjustment conforming the process as per Adjustment Process
If goods found less than the quantity mentioned in delivery chalan, there also needs to make adjustment conforming the process as per Adjustment Process
For Perishable Supplier:
Goods will be received against the demand plan forwarded to B&M team
Inventory personnel will collect a bill copy/ chalan copy from the supplier where the followings should be mentioned:
Trade price/ Unit price/ Rate/ COGS of items
Quantity or weight as appropriate for individual line item.
Total bill for the delivery.
During Receiving, Inventory personnel guided by Quality Assurance Officer, will ensure that only acceptable quality items (as per quality guidelines) is received.
B&M Team will provide the Trade price/ Unit price/ Rate/ COGS of each line item mentioning the IS ID for the respective item.
Warehouse/ DC personnel will measure the weight of goods or quantify the goods physically in number based on the items’ UOM set in MAP.
Inventory personnel will generate GRN in system as per provided IS ID, provided T.P/Rate and measured quantity or weight of each line item.
For suppliers or distributors or manufacturer of Company Goods:
Goods will be received against Purchase Order issued by B&M Team.
Inventory personnel will receive an Invoice/ Delivery chalan from the supplier where the following things should be mentioned:
Delivered quantity or weight as appropriate for individual line item.
Trade price for each line item
Total bill for the delivery
During Receiving, Inventory personnel guided by Quality Assurance Officer, will ensure that only acceptable quality items (as per quality guidelines) is received.
Warehouse/ DC personnel will measure the weight of goods or quantify the goods physically in number based on the items’ UOM set in MAP.
Inventory personnel will generate GRN in system against the PO with actual quantity or weight of each line item.
~ provided that,
If in Invoice it is found that TP/Rate for any line item differs from PO, then they should communicate with respective contact person from B&M team.
If actual quantity or weight is more than the PO issued quantity/ weight, then Inventory personnel should communicate with respective contact person from B&M team before accomplishing GRN.
If actual quantity or weight is less than the PO issued quantity/ weight, then Inventory personnel will simply complete GRN as briefed above.
5.6 Inventory shelving and storage
Supervisors need not to check each product from each cartoon if the cartoon is intact. Normally there is a batch no. on the cartoon. If a product is checked for date expired and each of the cartoons is for the same batch no. that means that, the Mfd and Exp date is similar.
Figure5: Different Batch no. indicating possibility of different mfd. and Exp. Date. Similar Batch refers to same Date for Mfd and Exp.
After receiving it would be helpful if the supervisors tag the cartoon with colored Paper etc. to track the product anytime easily. In this process, we can follow the below arrangement.
Color Tagging (might be by Paper) Formula:
|Green:||Will be expired between Jan-Mar|
|Yellow:||Will be expired between Apr-Jun|
|Black:||Will be expired between Jul-Sep|
|Red:||Will be expired between Oct-Dec|
Chart: Color tagging Formula (Need to be tagged on Cartoon)
Racking: When the tagging will be completed the product should be racked in master category (product type wise) system, keeping a blank column so that product can be delivered accordingly; and the product shuffling would become easy in case of necessity. It’s like the game of matching the no. as per consecutive sl no. which we have played in childhood.
Before Snuffling After Shuffling (need as per color code)
FIGURE6: Racking, Maintaining a blank column.
5.7 Inventory Picking and Delivery process
At the time of delivery supervisors will pick as per the color code. Say for example today is the 13th February, 2010 and so; the supervisor will pick the green color product then yellow and so on. If the yellow color product suggests that there are only few days to be date expired then it should go in return to vendor location of that both physically and as well as in system. Here a question may arise that yellow color may be for Jan –Mar of 2010 or 2011. Then the simple answer is that the outlook of the product is giving the answer.
5.8 Order Process and Replenishment-DC vs. Outlet
5.8.1 Company Goods
As mentioned in the process flow of inventory movement Outlets raise STO-“STOCKS TRANSFER ORDER “in SAP for their stores’ demand. For company goods and commodity usually convention is two times replenishment in a week @ max. But considering back store size and sudden pick in sales stores generate more frequently. However as per STO from outlets DC has to ensure the required stocks supply at outlets within three days based on stocks available in DC. When DC arrange delivery for particular store as per schedule then they consider previous 15 days pending STOs which not served earlier due to stocks unavailability in DC. So compilations of STOs are a major task for order processing and replenishment of stocks to outlets.
For exceptional purpose like Before Friday Sales or During Eid sales Day to Day basis replenishment also takes place though distribution cost has becomes high but for maximizing revenue it isusually done.
Perishables include Protein-Fish, Meat; Vegetables, Fruits etc. So these are the daily basis order and replenishment from DC to outlets. At afternoon stores personnel take his stocks and forecasting rest time sale and next day sales then he/she generates order and sends it to Head Office through SAP systems. It comes to Buyer screen and Buyers compile all the orders from stores and Generate PO for that. Perishables supply basically takes place in two form- from Suppliers and by own Buying Team who work during night and purchase from “The Biggest Wholesale Market-Kawranbazar”
Whatever the source, all these perishables items need to come to DC by Mid-Night for quality check, outlet demand wise segregation then loading to vehicles for delivery
Basically through SAP systems DC get all STOs from stores and then they generate pick notes stores wise and hand over to supervisors. They process the delivery of goods and ensure early morning arrival of stocks at outlets.
5.9 Order Process and Replenishment-Central DC vs RDC
Presently in “Shwapno” Regional Distribution Centre (RDC) take stocks from Central Distribution Centre (CDC) as yet full-fledged regional based company and commodity goods supplier not developed. CDC usually sends stocks to RDC once in a week based upon requirement of RDC which is sent to CDC through excel sheet.
5.10 ABC Analysis-80-20 rule
ABC analysis is methodology that gives us quickly and simple review of our assortments of products in retail, wholesale or manufacturing businesses. But, this analysis is possible to use in all areas of your business when you as an entrepreneur must take decisions about inventories, product assortments, marketing techniques, business processes, costs… ABC analysis gives us mechanism for identifying the products that have high influence on the overall costs of inventory and identifying the category of inventory that requires different management and control.
Similar or the same as ABC analysis is 80/20 rule that is also known as Pareto Principle. This rule tells us that 80% from effects come from 20% of our activity, or 80% of our sell come from 20% of our customers.
In every business exists products that are not equal in their value. Some products are more required from customers, for some products you have larger margin, some you must have inventory for completing the assortment. Because of that, all products are different in sales volume, value, meaning etc. You must tend to have a lower level of inventory or optimal level because inventory has very negative impact of overall business activities. With these method entrepreneurs may to have clearly view of whole assortment of products and meaning of this assortment to whole selling and whole income.
It must differentiate two things, firstly, how much income you have from every product line? Secondly, how much is required these products that mean what is the turnover of that particular products? Some products may to have higher turnover but in the same time have lower income and because of that larger turnover we have larger earnings from that product. Maybe customers in most cases will come in the store because of that particular product and will buy something else or another product. Because of that you must make two tables.
In first you will analyze assortment of products (number of products) versus whole income, and in second table you will analyze assortment of product versus overall turnover. In this way, you may to combine this 2 analysis and to view real situations and to choose variants that maximizing results and give us better results in working.
We can make classification of articles with ABC analysis when we divide assortment (whole articles) in 3 segments.
First segment is segment A where belong in products that are minimum obtained, for example, about 20% from overall turnover and this article give us great income, for example, 70% from overall income.
Second segment is segment B, where we have much more articles in quantity, for example, about 30-50% of all products that we have, but they give us only 20% from overall income.
Third segment is segment C, where we may to have about 50% of all articles that we have, but they give us only 10% from overall income
So based on this analysis “A” type inventory would get priority in terms of ordering .
5.11 EOQ Model
How much to order is determined by using an economic order quantity model.It identifies the optimal order quantity by minimizing the sum of certain annual costs that vary with order size. It is used to determine a fixed order size that will minimize the sum of the annual costs of holding inventory and ordering inventory The unit purchase price of items in inventory is not generally included in the total cost because unit cost is unaffected by the order size unless quantity discounts are a factor. Thus given annual demand, the ordering cost per order and the annual carrying cost per unit , one can compute the optimal order quantity.
|Rental for Animal Penn/ Shed (Hub)||288000||(Tk15/ Sq. Ft./ month* 32 Sq. Ft./ Cattle*50 cattle (carrying capacity of the penn)*12 months)|
|Caretaker Wages||438000||(Tk 200/ caretaker/ day*6 persons*365 days)|
|Cattle Feed||693500||(Tk 38/ cattle/ day*50 cattle*365 days)|
|Annual Total Carrying Cost for 50 cows||14195000|
|Annual carrying cost per kg||283.9||(Storage capacity of the penn = 50 cows; weight of 1 cow = 100 kgs)|
|Hashil & commission||4800||(Tk200/ cattle*24 cattle/ truck)|
|Caretaker cost||800||(Tk 400/ 12 cattle*24/12)|
|Inbound transportation cost||12000||(Tk12000/ truck)|
|Ordering cost/ order||17600||(where 1 order = truckload)|
Example of EOQ model applied for Beef in Shwapno
Annual Demand 1224000 kg(51 outlets* 80 kg per outlet per day*300 days in a year)
EOQ=(2x Annual demand xordering cost)/Annual carrying cost
No of Order per year= 1224000/12319= 99
Average QTY ordered/ store per order=12319/51= 242 kg
Time gap between successive orders (In days)=365/99=3.7 days
5.12 Safety Stock Management
For safety stock management, it is essential to have reliable estimates of the amount & timing of demand. Similarly it is essential to know how long it will take for orders to be delivered as well as the extent to which demand & lead time might vary. Thus there is crucial link between forcasting & inventory inventory management.
In Shwapno for company goods , outlets consider weather forcast , festival occasion for maintaining safety stock whereas safety stock management at DC consider uncertainty of supplier production, supply constraint in the whole sale market, fluctuation of the outlet consumption etc.For perishable items, there is no defined safety stock at DC except some specialized items like Hilsha which is preserved in cold room whereas in each & every outlet keeps some safety stock of perishable itemsto cater uncertainty of demand.
5.13 Out Of Stock and Over Stock Management
In retail business, out of stock and overstock is a very critical issue because in both casesthere is a probability of revenue or profit loss. For example, in the case of over stock of perishable items, the selling price of the same will be decreased by the time & if cannot be sold it will be treated as damaged. So to manage the overstock the forcast accuracy has to be improved.For holidays/ festivals or for seasonal perishable items, 20% over stock is maintained & if all are not sold
then they are sold at trade price or discounted price.
For over stock of company goods, there is an agreement with the vendor for return management.Out of stock means revenue loss for the company because if the customer comes & does not get the desired product then it means that the outlet has has lose lose its customer demand for that productand in the long run it may be the permanent turnover for the customer . So to prevent out of stock situation , ACI is basically taking the following measure
Flexible and quick delivery from DC
Back store shelving for critical items(such as Soyabean oil, milk, sugar for Eid or for promotional business)
Strong supplier of the perishable items for quick replenishment of beef , chicken especially for holidays & festivals. for highly perishable but low value foods it is not advisable to maqintain the back up because it leads more losses rather than customer satisfaction.
5.14 Stock Return Management
In retail stores operation Stocks Return management is huge challenge because it hits inventory cost as a write-off if not possible to return the stocks to vendor. Generally there are some reasons for which stocks return is required- They are-
Over stocks situations if sales drop
Over stocks situations if forecast is grossly wrong
Left over promotional stocks
Handling and Transit Damaged
As financial impact is high so a well-defined stocks return procedure from Stores to DC and Stocks return from Stores to direct Supplier is governed by the clause of contract between Shwapno and that particular vendor. However a SOP is stated below for ‘stocks return’.
List of return stocks to be prepared by respective store manager
Approved by COM
Send it to finance for authorizations
Then send it to DC and then receive physically
5.15 Damaged Stock Management
In Food and Grocery Retail Store operations like “Shwapno’ stocks damage is generic problem. But efforts should be made to minimize damage as it directly hits in P&L account in financial statement as a net loss. So systems and procedures are in place to reduce damage stocks. Generally there are some basic reasons for damage such as
Date expired stocks
Improper temperature and humidity
The above reasons may take place in stores and DC. Now there is set procedure to manage damaged stocks in “Shwapno”. We can say there are two methods-
In both case write-off provision to be taken through proper management approval
Perishables Damaged Stocks:
However in execution side there is schedule to bring perishables damaged stocks back to DC for centralized clearance sales and disposal. Generally one after another the returned empty vehicles which supply perishables in the morning is being used for taking these damaged stocks back to DC. A Clearance Sales team comprising with ‘Quality Assurance Officer’ inspect and do quality check and then decide which are going for Clearance Sales and which are going for Disposal.
Damaged company goods lying at Stores fall under SOP of ‘Stocks Return” subsequently these are being added up to DC damaged stocks. Generally there is segregation process for damaged stocks identifications and storage in different specific storage shelves to avoid cross contaminations, wrong goods delivery. There is also damaged stocks accumulation in DC itself as there are enough reasons for handling damage, improper storage damage etc.
However after accumulations of substantial amount of damaged stocks, DC personnel raise approval note for clearance sales and disposal. As per authorization matrix this approval note is being processed and then DC teams go for execution of clearance sales and disposal.
Clearance Sales Process of execution (When & How):
Damaged/ rotten/ date expired/ inferior quality goods and wastages will be identified under proper guidance of Quality Assurance officer following the quality guidelines.
Quotations are sought from different vendors and a team evaluate price and highest price giver is being awarded for sales.
Identified goods will be measured (in quantity or weight according to set UOM in MAP) and earmarked in assigned area for clearance sales.
Measured goods will be handed over to the clearance goods customer/buyer
An sales invoice will be created in system providing the below information:
IS ID for items to be sold at clearance
Quantity or weight of respective items
Discounted rate for respective items
A Gate pass/ Chalan will be made accordingly and will be duly signed by the customer/buyer.
Sales invoice will also be signed by the customer/buyer and kept along with Gate pass for document processing
The stocks which are not suitable for clearance sales are being disposed off as its approved. Under the guidelines of quality assurance and legal team initiatives are taken to dispose off of the damaged stocks into Govt. designated area.
5.16 Stocks Return to Vendor (RTV)
As per agreement /contract with vendor generally negotiated and finalized by Buying team, there are provisions of stocks return to vendor. As per common practices following types of stocks can be arranged for returns to vendor-
Over stocks but not expired
Damaged products at discounted rates
Some exceptional expired products like Ata, Moida
However in execution side DC team prepare list of products for return to vendor and create a note in SAP and send it to Buying team. Buying does the negotiations with suppliers and get schedule and inform DC. DC arrange accordingly. Generally it takes place when vendor bring another consignment for delivery then they bring back the agreed stocks. On the other hand a
debt notes to be generated in systems against the vendor while goods will be returned to vendor
as per communications.
6.Distributions Model of “Shwapno”
6.1 Overview of different distribution model
Generally in FMCG c