INTERNATIONAL FOODCHAIN analyzes sales in Uzbekistan using "1C:ERP World Edition", "1C:Catering" module and "1C:Analytics" BI-system
- Customer
- INTERNATIONAL FOODCHAIN (KFC fast food restaurants)
- IT Provider
- 1C-Rarus
- Year of project completion
- 2022
- Project timeline
- April, 2021 - December, 2021
- Project scope
- 2000 man-hours
- Goals
-
- Operational control of sales in each restaurant in real time and detailed sales analytics.
- Creation of a unified information system for automation of production management accounting of the enterprise.
- Implementation of the specifics of production accounting in terms of catering.
The uniqueness of the project
Within the project in Uzbekistan the BI-system "1C:Analytics" was one of the first to be put into production operation. Also for the first time in Uzbekistan the enterprise created and launched a unified information environment "1C:ERP World Edition" + "1C:Catering. Module for 1C:ERP and 1C:KA2".1C:Analytics" has a set of visual dashboards, which allow the management in real time to analyze sales both in each restaurant, and for the whole company in Uzbekistan as a whole: revenue by payment type (cash, several types of cards); hourly earnings for each restaurant and for all restaurants; indicator of current revenue, types of orders, the consumption of dishes, the consumption of combo boxes, etc.
- Used software
-
1C:ERP World Edition: Supply of inventory; Warehouse accounting of inventory; Management accounting; Bank and cash; Fixed assets.
1C:Catering. Module for 1C:ERP: Production (Public Catering).
1C:Analytics: Sales Analysis.
- Difficulty of implementation
-
Deployment of a single information system "ERP WE + Catering" and BI system "1C:Analytics". Complex adaptation of "1C:Catering. Module for 1C:ERP and 1C:Integrated Automation 2" for joint use with "1C:ERP World Edition" configuration. Integrated information system "ERP WE + Catering" is a source of data for "1C:Analytics".
Development of integration between the customer's front system (R-Keeper 7) and the single information system "ERP WE + Catering". The result of integration were the customer's restaurant sales data, which were loaded into the unified IS in the form of catering receipts. Downloaded data serve as input information for operational analysis of sales by means of BI-system "1C-Analytics".
Works on development and adjustment of reports and dashboards, according to the customer's requests were done.
- Project Description
-
There are more than 785 restaurants of INTERNATIONAL FOODCHAIN network on the territory of CIS countries. As part of the expansion of the network, the company opens restaurants in Uzbekistan - at the moment there are already 14 restaurants in the country.
Before the project, the exchange between the "1C:Accounting" 2.0 system and the "R-Keeper" system was adjusted to the specifics of catering enterprises. Due to the lack of management accounting in real time, the company did not receive information on inventory balances in a timely manner, which had a negative impact on the financial statements. It was impossible to analyze sales in real time - only at the end of the day. For the BI-system used it was necessary to constantly buy additional licenses, and it took time to connect each new restaurant to it. Given the high rate of development of the company in Uzbekistan, such delays were critical. Also, the company needed a system that would allow it to work with the specifics of the catering industry: write-offs of dishes, modifiers, etc.
Project results:
- Fully automatic integration between the front-office system "R-Keeper" and the UIS ("1C:ERP World Edition" + "1C:Catering. Module for 1C:ERP and 1C:KA2") was set up. Thanks to the integration, the formation of the document "release of meals" and write-off of materials in production is automated.
- A complex of visual dashboards in 1C: Analytics was adjusted for on-line comprehensive analysis of sales. As a result, the company's management is able to analyze the course of sales in each restaurant in real time and at any time of the day: what dishes are sold, which segment of the product yields the most revenue, etc. Obtaining data for sales analysis was accelerated from 24 hours to 10 minutes.
- Production and regulated accounting was implemented in 1C:ERP World Edition in accordance with the legislation of Uzbekistan and the specifics of the company, but with maximum preservation of the standard configuration.
- User instructions for company employees in Uzbekistan were developed to speed up adaptation to the new system and to provide the possibility of using the system without developers' participation.
- Deep analytical details of sales are set up without referring to additional sources: KKM, responsible manager, supplier of sold products, articles, nomenclature, the number of receipts, etc.
- High speed of the system operation was ensured at the daily number of catering receipts of about 12,000 documents per day.
- In the course of the project, the company's business processes were improved in accordance with international accounting standards.
- Project geography
- Tashkent, Uzbekistan.
On November 30, the professional IT community GlobalCIO hosted a large-scaled international conference "Global CIO Insights: Digital Transformation with AI". During the event, leading experts shared their practical experience in launching projects utilizing artificial intelligence (AI) and highlighted approaches that helped elevate their companies to new heights.
Voting for projects participating in the "Project of the Year" contest is open. The voting began on December 1st and will continue until January 15th inclusive. The winners will be announced on February 7th, 2024.
According to the statistics agency, the number of telecommunication and IT companies has increased 1.8 times in the last five years. At the beginning of 2023, there are more than 12 thousand ICT companies operating in the country. More than 100 thousand people are employed in the industry. At the end of 2022, the volume of ICT services grew by 125.5% and amounted to 22.9 trillion soums, of which 4.2 trillion soums were programming services provided by Uzbek companies and specialists. The total revenue of Uzbekistan's IT sector for the first quarter of 2023 reached 2.38 trillion soums - almost four times more than in the same period of 2022. Exports of digital services increased to $57.2 million. According to IT Park, net income amounted to more than 90% of revenue or 2.158 trillion soums.
According to the statistics agency, the number of telecommunication and IT companies has increased 1.8 times in the last five years. At the beginning of 2023, there are more than 12 thousand ICT companies operating in the country. More than 100 thousand people are employed in the industry. At the end of 2022, the volume of ICT services grew by 125.5% and amounted to 22.9 trillion soums, of which 4.2 trillion soums were programming services provided by Uzbek companies and specialists. The total revenue of Uzbekistan's IT sector for the first quarter of 2023 reached 2.38 trillion soums - almost four times more than in the same period of 2022. Exports of digital services increased to $57.2 million. According to IT Park, net income amounted to more than 90% of revenue or 2.158 trillion soums.
The IT strategy of a large number of companies includes the automation (digitization) of not only accounting processes but also production and logistics processes.