By Karen Richardson, Esri writer
As in many Latin American countries, corner stores and snack stands in Colombia serve as popular places to grab a quick bite to eat. Hordes of schoolchildren, workers on their breaks, and neighborhood families frequent these small establishments for a soda or boxed juice and a small bite.
On the shelves, piled high with chips, candies, and sweet delectables, one local brand stands out along with the multinational heavy hitters like Frito Lay and Grupo Bimbo: Productos Ramo (Ramo).
Founded more than 50 years ago, Ramo was the first retailer to offer prepared and packaged snack cakes in Colombia. Children and adults alike enjoy the company's snacks, from its Chocoramo cake squares coated in chocolate to its Mazitos fried corn chips.
The company balances innovation while continuing to embrace the traditional. As Ramo outfits business units and factories with the latest in technology, young men can still be found delivering Ramo products to small neighborhood stores by freight tricycle. This seeming dichotomy works well for the company, especially since the technology being utilized has its roots in tradition as well: GIS.
Ramo uses GIS software from Esri to improve service to the snack stands and stores and boost sales. GIS allows anyone to discover, analyze, and make decisions based on geography using an easy-to-interpret map interface. Mapmaking and using maps for decision making are centuries-old skills still valuable today, as Ramo realized.
Using Esri's GIS technology, Ramo was able to
Using ArcGIS Server and an Oracle relational database management system (RDBMS), Ramo created an enterprise geodatabase to maintain sales-related information in one common location. This geodatabase gives the company the ability to input data once and use it throughout the organization. The information includes Ramo's customers' locations, which are the stores that sell their products. Those locations are tied to sales volumes, street-level datasets, and business-related layers including sales and delivery territories. Ramo relies on this information to help it do business, from finding new clients to sell its products to, to managing existing customers and planning sales and marketing strategies.
Esri's Colombian distributor, Procálculo Prosis S.A., implemented the solution. "It was obvious that the Esri platform would completely fill Ramo's needs," says Oscar Herrera, information technology (IT) manager, Productos Ramo S.A. "Procálculo Prosis had the experience and ability to carry out a successful implementation."
Ramo began using ArcGIS Server to assist in creating the customer survey, which the company uses to make sales decisions more timely and accurate. Surveying the customers, or stores, hinges on client surveys that historically had been performed by first printing and cutting city maps into field zones, or sales territories. After this manual process, the locations of all customers, including every small corner store and snack stand, was drawn on a map. Finally, Ramo sales people hit the streets to survey the customers, finding out if they needed more products to sell, if the mix of products was correct, and other information that would help them meet the needs of the people who shop at their clients' establishments every day. This process, from printing the maps to gathering the data, normally took more than a year. The long time frame meant that by the time Ramo was able to use the information, it was out of date.
Using ArcGIS Desktop automates the mapmaking process. Instead of the survey taking more than a year to complete, four GIS analysts can finish it in four and a half months. Key to the time savings is the analysts' ability to create field zones by digitizing them directly onto the maps. Then, client locations are geocoded using either Colombian street maps or a Global Positioning System (GPS) when street maps are not available. When finished, this information is used by staff to create, visualize, and analyze distribution zones organized by rules from Ramo's sales criteria.
By decreasing the time it takes to finish the survey and having access to more timely data, Ramo met its objective of increasing the number of clients, or stores, in each sales and distribution zone by 10 percent. This was possible by supplying products to new stores that have opened since the last survey, seeing where stores are not serviced because they fell between field zones, and expanding zones because of more efficient routing. In Bogotá alone, for example, Ramo has found 800 new customers.
The next process Ramo optimized was delivery routes. Most products are delivered to stores by a fleet of 700 freight tricycles or motorized trucks. Using the ArcGIS Network Analyst extension, an add-on software to ArcGIS Server, the company is able to quickly find optimal routes. ArcGIS Network Analyst also allows Ramo to manually create routes when necessary in more rural regions where road maps are not available. The software has also been set up to take into account that person-powered freight trikes cannot use streets that are too steep.
Maps created by ArcGIS Server are also incorporated into Ramo's in-house business reporting system as part of hard-copy sales reports and strategy documents. This ensures that marketing analysis, coverage of the distribution zones, and locations of customers are available throughout the organization to sales and marketing staff as well as the company's management team and stakeholders.
Both Ramo and its customers benefit from GIS. The client survey Ramo performs takes much less time than it did traditionally. Having more reliable and timely information from this survey means Ramo can plan better sales strategies.
Field zones have been reorganized based on knowing where clients are located and how they responded to the survey. Using GIS to do everything from creating new field zones to routing the distribution of products instead of doing these tasks by hand ultimately provides better customer service. Having this information readily available helps Ramo analyze the sales of products including identifing where to place them and which clients need more.
"The key to this project's success was selecting a group of top sales representatives to participate," says Herrera. Ramo's general manager and IT manager both supported the project from the beginning and guaranteed they would have enough resources to execute a successful project implementation. Having Procálculo Prosis involved from the beginning and throughout the technology implementation was also very important to the success of the project.