Supermarket Information Systems

Super product Information SystemsINTRODUCTIONFollowing the development of engine room, Supermarket information systems have been improve from time to time. From the beginning of buying product from supermarket, to internet shopping system, up to now, Supermarket information system, customers behaviour have changes a lot.However, as retail system get high business analysis procedures, the ePos system and ratiocination support system and Customer Loyalty System has been overlooked. This project aims to improve these Supermarket information systems in human factors perspective.HistoryChina Resources Vanguard Shop (CRV) is one of the largest supermarket chains in Hong Kong. It is a member of China Resources Enterprise, a wholly owned marcher of State-owned enterprise.China Resources Vanguard Shop, or CR Vanguard, is a flagship operating supermarket chains of China Resources. It is the third largest supermarket chain in Hong Kong. It operates approximately 450 stores in Hong Kong, Gu angdong, Zhejiang, Jiangsu, Shanghai, Tianjin and Beijing.PROBLEM expositionDSSFor the decision support system, traditionalistic Invoicing system based on single selective informationbase system, usually including management Information systems and decision support systems, business offshooting subsystem and decision support systems with a informationbase. Composed of a single database-centric database systems often smoke non satisfy the diversification of modern supermarket data processing requirements. Specifically manifested in the following areasCannot integrate internal and external aspects of data.Cannot meet transaction processing and analysis and processing shoots.Difficult to adapt to conglomerate types of users of different levels of data consolidation requirements.RESEARCH METHODOLOGYSWOT B2 A tool that identifies the strengths, weaknesses, opportunities and threats of an organization. SWOT analysis determines what may assist the firm in accomplishing its obj ectives, and what obstacles must be overcome or minimized to arrive at desired results.StrengthsPart of the China Resources Enterprise2926 stores in Hong Kong and China.Provide wide range of productsNo. of Staff 14500 in China curtilage in Hong KongWeaknessesFounded in 1984Branch store less than PARKnSHOP Wellcome in HK.Man king-Only 1000 in Hong KongProduct or service Undifferentiated in apprisal to supermarket.Location.OpportunitiesDeveloping marketChinaMergerAlliance with Manka (Supermarket)TheatersPrice war.Negative impressiona new competitor in your own home marketSubstituteCompetitor also has a new, innovative substitute product.Porters 5 Forces B3 A tools is a simple but powerful tool for understanding where power lies in a business situation. This is useful, because it helps you understand both the strength of your current warlike position, and the strength of a position youre considering moving into.Threat of New Entrants (Low Pressure) in high spirits capital and in vestment requirementHigh likelihood of retaliation from existing industry playersThreat of Substitutes (Low Pressure)Not easy to have substitutionModern family and state of affairs lady dislikes the traditional marketOnline supermarket / phone order is not popularNo delivery delayPower of Supplier (Low Pressure) numerous supplier sourcesMany kind of goodsSupermarket has much bargaining power for price negotiationPower of Buyers (Medium Pressure)Not easy to order the goods from supplier directlyVarious customer concourseEasy to switch to other competitorsCompetitive Rivalry (High Pressure)Many equally sized competitorsParkn, Wellcome, DCH, Jusco and etcPrice WarsDATA GATHERING jukiCRC Business Manager, Roland said We spent a few days, and open business meeting, the Preparatory trend analysis of customer loyalty to a few months, so we prefer to focus on the gripe for our products than our competition Opponents and the development of our business.Questions AskedThe questions that we re asked from the Manager of BusinessMr. Rolando, are How many sales staff do you have? How many customers do they cover daily? What is the process of registering a new customer in your organization and how do the sales people introduce the company products? The way of keeping the customer history?The questions that were asked from the walk of IT are Describe the current environment in the supermarket industry?Current IT capability and infrastructure of the company?RECORD REVIEWING AND ONSITE OBSERVATIONxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxPROPOSED SYSTEMIn the chart, we give be able to see the whole flow of the supermarket system situation, first by the RFID received the data by the customer and sales and supplies and the production storage warehouse, and whence save into the traditional Database, the data have been re-organization store into the Data warehouse, used to support decision analysis (OLAY), at the end, Customer Loyalty system can collect the right information use for the promotion. RFID, OLAY and Customer Loyalty are the object of our study. We recommend the following three waysDSSData warehouse B2 and applied science in the application of DSS on decision support systems has become a new trend. OLAP B1decision-making method according to demand in the process of multi-dimensional view Figure1of various types of information to the data stored in the warehouse, to lead decision makers with a wide range of business analysis. Data Warehouse environment supermarket Invoicing System ArchitectureTraditional Invoicing system has been built with a single database-centric data organization model, decision analysis has been unable to meet the system requirements on the database, but the emergence of data warehouse technology and Development of the above-mentioned problems provides a powerful tool and Means . Data warehous ing is a kind of multiple distributed, heterogeneous databases to provide a unified query technology. Data warehouse management system of enterprises from outside the original data and collate the data together into a data warehouse, on this basis, through smooth, rational, comprehensive information management, so that end users can extract data directly from the data warehouse, associated data analysis.Data warehouse is not a substitute for traditional databases Figure 4, but on the basis of a traditional database, the data re-organization, used to support decision analysis. Data warehouse and traditional database systems assume different tasks, play a different role. That is based on the traditional database, business processing system to complete the daily business of data entry and processing, the data processed are sent to data warehouse based on data warehouse decision support system carrying into action analysis and processing, in order to provide decision makers with comple te, timely and accurate decision-making information. In this way, transaction processing environment and analytical processing environment to achieve the separation, the relative independence, constitute new system environments, while the data warehouse is a system of core-based environment .Data warehouse environment at a supermarket invoicing system Structure shown in Figure 1. System is composed of business processing subsystem, support decision-making subsystem, and data management subsystem consists of three parts. Business processing subsystem in which the accent for the traditional database (can be multiple distributed, heterogeneous database), foreground is a business application systems, the completion of all Invoicing business day processing, the entire Invoicing system data entry, and to support decision-making subsystem provides the raw data support decision-making subsystem, the background for the data warehouse, front from the on-line analytical tools, data mining too ls, etc., and the completion of statistical analysis and predict capabilities to achieve decision-making support data management subsystem is responsible for the entire system of data management, in particular data from various data sources (traditional database) to the transfer of data warehouse and data warehouse data structures and business rules management.GOLBAL SUCCESS STORIESPROPOSED SOLUTION ADVANTAGESDSSCarry out market analysisTrend analysisSubgroups of commodities, layout, purchase of the analysis, tribute and merchandiseThe analysis of the effectiveness of promotional activities carried outCustomer loyalty analysisPROPOSED SOLUTION DISADVANTAGESDSSHigher initial capital investmentStaff should need a special training.Difficult to integrate with other management information system.OVERALL BENEFITS OF THE SOLUTIONDSSData warehouse and multi-dimensional analysis with comprehensive data on capacity and can be fast and accurate analysis of the data to help managers make be tter business decisions, you can bring a competitive advantage for enterprises. The current data warehouse and data mining technology in domestic applications is not very extensive, but because of commercial enterprises have coordination compound business structures, there are a large number of Invoicing business data, there is a specific need for decision analysis, the data warehouse technology in the business enterprise applications has broad prospects.GAINING A COMPETITIVE ADVANTAGREDSS.Carry out market analysisTrend analysisSubgroups of commodities, layout, purchase of the analysis, recommendation and merchandiseThe analysis of the effectiveness of promotional activities carried outCustomer loyalty analysisRESOURCES AND CAPABILITIESxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxMAIN RESEARCH OUTCOMESGiven below are the main research outcomes that we came ac ross. The figures even are derived from observing past data of the organisation. This project can be deployed with an initial cost of around US$.1 million ROI Expectation time in spite of appearance 18-30 months Expected sales growth up to the maximum of 25%-35% Clear competitive advantage with the new systemBIBLIOGAPHYBook referencesB1Jun Chen, Sheng Yi-chi, CHEN Mian-yun. OLAP-based data warehouse DSS application in the study of .2003 (1) 30-31B2 WHInmon. Data warehouse. Mechanical Industry Press, 2000,5 B2 SWOT Analysis I Looking Outside for Threats and OpportunitiesB3 Australias Construction Industry Porters Five Forces dodge Analysis by Aruvians RsearchWeb referencesE1