"Case Combat" restaurant business Branch financial Data Analysis System Solution: system function Development

"Case Combat" restaurant business Branch financial Data Analysis System Solution: system function DevelopmentPurpose of Construction

A food and beverage group needs to analyze the financial situation of each branch, currently using Excel to store and view the revenue of each region, the income summary data for each month and year is presented through multi-sheet, because this food and beverage group is a relatively large-scale catering group, many regions have branches. So, just for the income situation, you need to do a lot of Excel to make a summary of the revenue storage. This leads to the query history data is very troublesome, not conducive to the data of the archival regularization, production costs are too high, wasting effective human resources and many other drawbacks, so the use of data analysis system to solve these shortcomings.

Business Requirement Analysis and System construction Overview See: "Case Study" restaurant Business branch financial Data Analysis System Solution: system function Development

system Functions1, System users

The user of the system involves the Finance Department and the sales manager, etc., so according to different users to set different permissions, control the different roles look at the template is not the same.

The user's configuration is the responsibility of the Super Administrator, the user's basic information is stored in the database table, in the system by the administrator configuration, the introduction of database data as the basis for authenticating users, and to configure the user and the corresponding relationship between the operational files.

2, business functionsUnified Application Platform

Data analysis system using B/S architecture, users can access the system through a Web browser, with the user name password to view their corresponding permissions of the report.

Chart analysis of this catering enterprise

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/77/E7/wKioL1ZxC-6SUDx3AAEbcium3fw917.png "title=" 1_ copy. png "alt=" Wkiol1zxc-6sudx3aaebcium3fw917.png "/>

Analysis of the catering business Report

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/77/E7/wKioL1ZxDATASyqMAAFg7ASAvBM996.png "title=" 2_ copy. png "alt=" Wkiol1zxdatasyqmaafg7asavbm996.png "/>

Rights Management

For each store's business income, staff situation and other analytical reports, not everyone can see. The actual situation is that the regional managers can see all the stores in their regional analysis of the relevant reports; Each market manager can see the analysis report of all the stores in the market (North China, east China, etc.); Group general Manager can see the food and beverage group under the various markets, all the stores in the Regional Analysis report.

system Use ProcessEditing and Reporting

fill in the general sales and the sales of the members every day, the editing methods on the page are rich and varied, allowing direct text or digital editing, as well as allowing selection via the Calendar or drop-down boxes.

Business Analysis

Business analysis is the observation and analysis of data through different angles, so that managers have a multi-faceted understanding of the business situation, such as the sales analysis of each store:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/77/E8/wKiom1ZxDA7h-quHAAEAIgSAGGE113.png "title=" 3_ Copy _ copy. png "alt=" Wkiom1zxda7h-quhaaeaigsagge113.png "/>

By analyzing the turnover rate, we can describe the index value of turnover and its scope more clearly.

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/77/E8/wKiom1ZxDB6CijNrAAB5lNYEmo4406.png "title=" 4_ copy. png "alt=" Wkiom1zxdb6cijnraab5lnyemo4406.png "/>

By the weekly business analysis, can be very intuitive to display the week of the per capita/table consumption and the actual turnover of the specific values, but also can show the growth trend of turnover, the manager for the week to make certain decisions to provide data base.

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/77/E7/wKioL1ZxDDWget1mAABFbfsg44w224.png "title=" 5_ Copy _ copy. png "alt=" Wkiol1zxddwget1maabfbfsg44w224.png "/>

By the date of the business analysis, you can see the actual revenue of the month and the estimated turnover of the specific values, but also a visual display of the turnover rate in the month of a progress trend. Provide a data base for managers to view revenue and make next month's revenue forecasts.

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/77/E8/wKiom1ZxDDyR0j1-AABXiyU2CM8053.png "title=" 6_ copy. png "alt=" Wkiom1zxddyr0j1-aabxiyu2cm8053.png "/>

member Analysis

Member analysis report mainly on the number of members analysis, membership analysis and member analysis of the value of the multi-dimensional, with a number of charts and reports through the linkage of the chart to analyze members, when clicking on the pie chart area, then through the column chart to show the member information in the region, click on the column chart of a city, The report shows the status of each store member. If the number of members analysis, can be visualized to show the region, cities, stores the number of members:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/77/E8/wKiom1ZxDFSRw5FGAAHWrdO9Z5o993.png "title=" 7_ Copy _ copy. png "alt=" Wkiom1zxdfsrw5fgaahwrdo9z5o993.png "/>

Member points analysis by region, city, each store for statistical analysis, you can visually display each region accounted for the proportion of points, each city points summary situation and various store points, such as:

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/77/E7/wKioL1ZxDHTR4JMbAADvVte71Ps274.png "title=" 8_ Copy _ copy. png "alt=" Wkiol1zxdhtr4jmbaadvvte71ps274.png "/>

Member analysis of the value of the same according to the region, the city, each store for statistical analysis, the visual display of each area of the proportion of the value of each city, the sum of the total value of each store and the storage value of stores, such as:

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/77/E7/wKioL1ZxDITh0aJsAADfmVyJ_0w509.png "title=" 9_ Copy _ copy. png "alt=" Wkiol1zxdith0ajsaadfmvyj_0w509.png "/>

Analysis of food products

Food analysis report mainly on the level of food, food classification and package analysis, with a number of charts and reports on the food statistics, through the pie chart to show the level of dishes, through the column chart to show the classification of dishes, through the report to show the use of each package, such as:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/77/E7/wKioL1ZxDJ3AjdzCAADms5OD6Ng426.png "title=" 10_ Copy _ copy. png "alt=" Wkiol1zxdj3ajdzcaadms5od6ng426.png "/>

Among them, click on the menu link, can be linked to the corresponding menu of the daily income trend analysis, such as:

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/77/E8/wKiom1ZxDKewrJsWAAFE7srJAe0560.png "title=" 11_ copy. png "alt=" Wkiom1zxdkewrjswaafe7srjae0560.png "/>

Table-Analysis

Table Analysis report mainly on the table standard, table category and table number analysis, with a number of charts and reports to the table statistics, through the pie Chart Display table standard, through the Column Chart Display table category, through the report to show each table usage, such as:

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/77/E8/wKiom1ZxDLrgrwkvAAD1DFiseIw844.png "title=" 12_ Copy _ copy. png "alt=" Wkiom1zxdlrgrwkvaad1dfiseiw844.png "/>

Among them, click on the link to the table number, can link to the corresponding table daily income trend analysis, such as:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/77/E7/wKioL1ZxDNPDVDnKAAA0IfbFe_0548.png "title=" 13_ copy. png "alt=" Wkiol1zxdnpdvdnkaaa0ifbfe_0548.png "/>

Employee Performance Analysis

Statistics of the sales turnover, paid turnover, number of service tables and the number of meals served in a shop. And according to the turnover value of the clerk to sort, so that the high turnover of the clerk listed in front. In this way, managers can clearly see which clerks create higher value, and the detailed service value of each salesperson. and provide a data base for the financial department to calculate employee performance.

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/77/E7/wKioL1ZxDOvgz5GgAADlX9RUCRI721.png "title=" 14_ Copy _ copy. png "alt=" Wkiol1zxdovgz5ggaadlx9rucri721.png "/>

Income Statement Presentation

Look at the monthly income of all stores, take December as an example, statistics rankings, stores, store manager, store rental area, store number of seats, number of store tables, total number of visitors, total number of guest tables accumulated, December total income, December daily Income, actual per square meter yield, last month income, Average number of last month and comparison with last month's average daily growth rate, such as:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/77/E7/wKioL1ZxDP6gRcTyAAC13mKuULE872.png "title=" 15_ Copy _ copy. png "alt=" Wkiol1zxdp6grctyaac13mkuule872.png "/>

To count the annual income of each store in a certain area of this catering enterprise, including: ranking (descending according to annual income), store, opening time, monthly income for each month of the year, average month of the first half, monthly average and annual income.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/77/E8/wKiom1ZxDQbh9BdHAABX2DOFOeY975.png "title=" 16_ copy. png "alt=" Wkiom1zxdqbh9bdhaabx2dofoey975.png "/>

Store budget statistics, the need for each store according to the budget completion of the ascending/descending arrangement, also includes the opening time, the year of the month detailed budget, the sum of the budget and the completion of the situation. Can effectively help managers to locate their budget completed very low/very high store. This allows managers to target the results to find out the reasons for the budget and the actual difference, and to consider the corresponding marketing measures.

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/77/E8/wKiom1ZxDRjiARTAAABVF5b-KUg983.png "title=" 17_ copy. png "alt=" Wkiom1zxdrjiartaaabvf5b-kug983.png "/>

Each store detailed income statement, need to the daily lunch and dinner income to total, as well as the monthly daily income, actual per square meter production efficiency, per capita consumption, turnover rate, seating rate, and many other data. Effectively helps managers understand the revenue details of each store in the region clearly from each dimension.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/77/E7/wKioL1ZxDTywIuipAABq1lAWRRo488.png "title=" 18_ copy. png "alt=" Wkiol1zxdtywiuipaabq1lawrro488.png "/>

"Case Combat" restaurant business Branch financial Data Analysis System Solution: system function Development