Supermarket Information Systems

Supermarket nurture SystemsINTRODUCTIONFollowing the development of engine room, Supermarket schooling schemes adjudge been improved from condemnation to time. From the beginning of buying product from supermarket, to internet shopping brass, up to now, Supermarket tuition agreement, guests behaviour have changes a lot.However, as retail placement requirement high commerce compendium procedures, the ePos frame and finality harbour system and Customer consignment System has been overlooked. This project aims to improve these Supermarket information systems in human factors perspective.Historymainland China Resources Vanguard Shop (CRV) is i of the largest supermarket chains in Hong Kong. It is a member of China Resources Enterprise, a solely owned subsidiary 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 some what 450 stores in Hong Kong, Guangdong, Zhejiang, Jiangsu, Shanghai, Tianjin and Beijing.PROBLEM DEFINITIONDSSFor the decision adjudge system, Traditional Invoicing system based on single infobase system, usually including management Information systems and decision stick out systems, traffic touch subsystem and decision support systems with a selective informationbase. bring to pass of a single infobase-centric infobase systems often lav not satisfy the variegation of modern supermarket data impact requirements. Specifically manifested in the following atomic twist 18asCannot desegregate internal and external aspects of data.Cannot control transaction processing and abstract and processing needs.Difficult to adapt to mingled types of users of dissimilar levels of data integration requirements. research METHODOLOGYSWOT B2 A tool that identifies the strengths, weaknesses, opportunities and threats of an organization. SWOT analysis determines what may assist the f irm in accomplishing its objectives, and what obstacles must be overcome or minimized to achieve desired results.StrengthsPart of the China Resources Enterprise2926 stores in Hong Kong and China.Provide wide range of productsNo. of Staff 14500 in China 1000 in Hong KongWeaknessesFounded in 1984Branch store less than PARKnSHOP Wellcome in HK.Manpower-Only 1000 in Hong KongProduct or service uniform in relation to supermarket.Location.OpportunitiesDeveloping marketChinaMerger adhesion 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 still powerful tool for understanding where power lies in a business situation. This is useful, because it supporters you understand both the strength of your current warring position, and the strength of a position youre considering moving into. bane of New Entrants (Low Pressure)High capital and coronation requirementHigh likelihood of retaliation from existing industry playersThreat of Substitutes (Low Pressure)Not easy to have substitutionModern family and office wench dislikes the traditional marketOnline supermarket / phone give is not popularNo delivery delay powerfulness of Supplier (Low Pressure) numerous a(prenominal) supplier sources many a(prenominal) kind of goodsSupermarket has much bargaining power for price negotiationPower of Buyers (Medium Pressure)Not easy to order the goods from supplier directlyVarious customer groupEasy to switch to other competitorsCompetitive Rivalry (High Pressure)Many equally sized competitorsParkn, Wellcome, DCH, Jusco and etcPrice WarsDATA GATHERING jukiCRC line of products Manager, Roland state We spent a few days, and open business meeting, the Preparatory tendency analysis of customer loyalty to a few months, so we favor to focus on the rush for our products than our competition Opponents and the development of our b usiness.Questions AskedThe questions that were asked from the Manager of BusinessMr. Rolando, are How many gross revenue 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 companion products? The way of keeping the customer history?The questions that were asked from the Head of IT are mention the current environment in the supermarket industry?Current IT capability and al-Qaeda of the company?RECORD REVIEWING AND ONSITE OBSERVATIONxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.xxxxxxxxxxxxxxxxxxxxxxxxxPROPOSED SYSTEMIn the chart, we will 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 store, and therefore save into the traditional selective information base, the data have been re-organization store into the selective information warehouse, utilize 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 waysDSS info warehouse B2 and Technology in the practise 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 proffer decision makers with a wide range of business analysis. Data storage 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 applied science and Develo pment of the above-mentioned problems provides a powerful tool and Means . Data warehousing is a kind of multiple distributed, heterogeneous databases to provide a unified query technology. Data warehouse management system of enterprises from immaterial the original data and collate the data together into a data warehouse, on this grounding, 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 everlasting(a) the daily business of data entry and processing, the data processed are sent to data warehouse based on data warehouse decision suppo rt system implementation analysis and processing, in order to provide decision makers with complete, 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 downplay 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 subsyst em, the background for the data warehouse, front from the on-line analytical tools, data mining tools, etc., and the completion of statistical analysis and forecasting capabilities to achieve decision-making support data management subsystem is prudent 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 answer ADVANTAGESDSSCarry out market analysisTrend analysisSubgroups of commodities, layout, purchase of the analysis, recommendation and merchandiseThe analysis of the potence of promotional activities carried outCustomer loyalty analysisPROPOSED SOLUTION DISADVANTAGESDSS high initial capital investmentStaff should need a limited training.Difficult to integrate with other management information system.OVERALL BENEFITS OF THE SOLUTIONDSSData warehouse and multi-dimensional analysis with compre hensive data on might and can be fast and accurate analysis of the data to help managers make better business decisions, you can bring a competitive utility for enterprises. The current data warehouse and data mining technology in domestic applications is not very extensive, but because of commercial enterprises have complex 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.xxxxxxxxxxxxxxxxxxxxxxxx xMAIN RESEARCH OUTCOMESGiven to a lower place are the main research outcomes that we came across. The figures however are derived from observing outgoing data of the organisation. This project can be deployed with an initial cost of virtually US$.1 million ROI Expectation time within 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 system Analysis by Aruvians RsearchWeb referencesE1