JP7173515B2 - Business plan data creation program and business plan data creation method - Google Patents

Description

TECHNICAL FIELD The present invention relates to a business plan data creation program and a business plan data creation method that can be suitably used for improving man-hour productivity in a store or the like.

When considering daily staff allocation in stores such as supermarkets, it is important to assist in personnel adjustments and improve profitability by calculating the excess or shortage of personnel relative to the number of personnel required for each department. .

For example, Patent Literature 1 below describes a technique for creating man-hour productivity, which is one indicator of profitability.

Japanese Unexamined Patent Application Publication No. 2001-76049

However, with the above technology, although there is a vague hope of improving man-hour productivity, it is entrusted to human sensory decisions, and there are problems in stably improving man-hour productivity. remains.

In view of the above problems, it is an object of the present invention to provide a business plan data creation program and a business plan data creation method that can improve profitability more stably.

A business plan data creation program according to one aspect of the present invention for solving the above problems comprises steps of recording execution business data for each department, recording sales data for each department, executing business data for each department, and This is for executing a step of calculating profitability data for each division based on the sales data for each division and a step of creating business plan data for each division based on the profitability data for each division.

A business plan data creation method according to another aspect of the present invention includes a step of recording execution business data for each department, a step of recording sales data for each department, a step of recording execution business data for each department, and a step for recording sales data for each department. It comprises a step of calculating profitability data for each department based on the data, and a step of creating planned business data for each department based on the profitability data for each department.

As described above, according to the present invention, it is possible to provide a business plan data creation program and a business plan data creation method that can more stably improve man-hour productivity.

It is a figure which shows an example of the screen of a display apparatus by execution of the step which the program which concerns on embodiment performs. FIG. 10 is a diagram showing an example of a screen of a display device when setting a department to belong to in correspondence with a name; FIG. 10 is a diagram showing an example of a screen regarding skill data input; FIG. 10 is a diagram showing an example of a work schedule resulting from changes in total working hours when the work schedule shown in FIG. 1 is highly profitable; FIG. 10 is a diagram showing an example of a comparison diagram of planned work data, execution work data, and profitability data;

BEST MODE FOR CARRYING OUT THE INVENTION Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. This invention may, however, be embodied in many different forms and should not be limited to the specific illustrations of embodiments set forth below.

A business plan data creation program (hereinafter referred to as "this program") according to the present embodiment provides a computer with (1) a step of recording execution business data for each department, and (2) a step of recording sales data for each department. (3) a step of calculating profitability data for each department based on the execution business data for each department and sales data for each department; (4) creating planned business data for each department based on the profitability data for each department; It is for executing a step.

As described above, this program is executed by an information processing device, that is, a computer. Specifically, it is stored in a recording medium such as a hard disk of the computer, and read into a volatile recording medium such as a memory as necessary. , will be executed. That is, the present program is executed on a computer to perform (1) a step of recording execution business data for each department, (2) a step of recording sales data for each department, (3) a step of recording execution business data for each department and a step of calculating profitability data for each department based on the sales data for each department, and (4) a step of creating planned business data for each department based on the profitability data for each department (hereinafter " (referred to as "this method") can be realized.

The computer used to execute this program is not limited as long as it has the above functions, but a central processing unit (CPU), a non-volatile recording medium such as a hard disk, and a volatile recording medium such as a memory , a bus connecting them, an input device such as a keyboard and a mouse, a display device such as a monitor, and the like, but are not limited to these.

Each step of the method performed by the program will now be described in detail.

First, the method includes the step of (1) recording execution business data for each department. Here, "executed work data" refers to data relating to actually executed work. Specifically, the execution work data includes department data, date data, personnel name data, belonging department data, work content data, work time data, and total working time data, which are recorded in association with each other as necessary. It is FIG. 1 shows an example of a screen of a display device resulting from execution of this step. This figure shows the contents of work executed in one department.

Here, "department data" is data including information about which department it is. For example, taking departments in a supermarket as an example, meat departments, fresh fish departments, fruits and vegetables departments, etc. can be exemplified, but are not limited to these.

Here, "date data" is data including information on the date when the task was actually executed. By including this date-related information, it is possible to recognize the date and time of the execution task data. It is preferable that the date data also include information on the day of the week. For example, in supermarkets and the like, it is not uncommon for sales tendencies to be similar depending on the day of the week, so it is possible to improve profitability with higher accuracy by including information on the day of the week. In the example of this figure, the date and time and the day of the week displayed in the upper center correspond to the date data.

Here, the "personnel name data" is data including information such as names of personnel (employees) who are assigned to perform work. Each of the above data is stored in association with the personnel name data. In addition, since there are usually a plurality of personnel assigned, there will be a plurality of personnel name data. While it is necessary to identify individuals, the personnel name data may be data that simply includes information about identification numbers, for example, from the viewpoint of personal information protection. In the example of this figure, the names described in the name column of the table below correspond to these personnel name data.

"Department data" is, as described above, department data recorded in association with each employee name data, and indicates to which department an assigned employee belongs. . The sector data are as shown above. Since the personnel may change departments depending on the time and day, the department data may also be changed depending on the date and time. A plurality of department data may be assigned to one personnel name data. In addition, in the example of this figure, an example of one department (fruits and vegetables department) is given, and the fact that the name is displayed in the above figure means that the person belongs to this department. FIG. 2 shows an example of the screen of the display device when setting the department to which a person belongs corresponding to the name. This example is an example in which a plurality of affiliations are set for one person, and when affiliations are set here, names are displayed in the table in FIG.

In addition, the "work content data" is data that includes information on what kind of work the assigned personnel are doing, and is associated with not only the above personnel name data, but also the work time data, which will be described later. Recorded. As for the specific work contents, there are a wide variety of work contents in supermarkets and the like, but examples include receipt of goods, sorting, stocking, cleaning up, ordering, product creation, rework, POP creation, opening and closing store preparation, etc. In the example of FIG. 1, the work content (sorting, etc.) displayed in the cell on the right side of each person displayed in the table below corresponds to this.

In addition, "business hours data" is data that includes information related to the time required to specify when and what kind of work the assigned personnel performed. It is preferable to include at least one of the time and end time, information on the time engaged in work, and the like. By doing so, it is possible to grasp the business hours and the content of the business. In the example of FIG. 1, the numbers at the top of the table represent the hours of operation (e.g., 8 means 8 o'clock). Of course, recording may be made in minute units such as 30 minute units, 15 minute units, etc. more finely than shown in the example of this figure.

"Total working hours data" means the sum of the working hours of all employees assigned to each department, and can be obtained by calculation based on the above-mentioned working hours data, employee name data, and the like. This total working hours data is also used for calculation of profitability data, which will be described later.

Further, in this step, "employment type data" may be included, and "remuneration data" may be included. The "employment type data" is data that includes information about the type of employment of the assigned personnel, and can include information such as full-time employees, part-timers, part-time workers, and the like. The "remuneration data" is data relating to the remuneration of the assigned personnel, and more specifically includes information regarding the hourly unit price (hourly wage) of the assigned personnel and information such as fixed wages. By incorporating information on employment status and remuneration in this way, it becomes possible to create more efficient planning work, and for the same work content, more cost-saving planning work.

In addition, this step may further include "skill data". Here, "skill data" is data that includes information on the skill level of work that the assigned personnel can perform. can be prevented. Since this step records the work that has been performed, there are often no large discrepancies between assigned personnel and their skills. It is possible to reduce the risk of allocating inefficient work to a specific person in charge. An example of the input screen in this case is shown in FIG. This figure is an example in which skill data is added to the example of FIG.

Also, as a result of this step, it is possible to grasp the number of people engaged in the work and the time spent there, and to calculate profitability data as described later. The table in FIG. 1 shows data on the total working hours calculated by the input personnel.

This step is data related to the work actually executed as described above, and this data may be data directly input from a keyboard or the like, but recording each work is burdensome for each person. Since there is a possibility that it may become too large, for example, assigned personnel are given a mobile information terminal such as a tablet, and operations such as operations that occur when performing various work and input work (order work, etc.) It may be determined and automatically extracted as data.

In addition, the step (2) of recording sales data for each department in this method is specifically data including sales information for each department. Record sales data corresponding to each.

Here, "department data" is, as described above, data containing information about departments classified by the supermarket, which is the user of this program, and "department data" recorded in association with the above personnel name data. This data is the basis for In other words, the belonging department data is selected from the department data.

Here, "sales data" is data including sales information in each department, as described above. Of course, sales data may include information on total sales obtained through all departments (total sales data).

Of course, it is preferable to include date data in order to link with the execution task data. The date data is the same as the execution task data.

Further, the method includes (3) a step of calculating profitability data for each department based on the business execution data for each department and the sales data for each department.

Here, "profitability data" is data that includes information on profit, and examples of information on profit include man-hour productivity, man-hour sales, and the like, but are not limited thereto. That is, the profitability data includes man-hour productivity data and man-hour sales data.

Here, “man-hour productivity” is a value that evaluates how much profit (gross profit) is obtained or was obtained for the amount of work (man-hour) per person per hour. Specifically, it is a value obtained by the following formula. Here, "gross profit" is the value obtained by subtracting the cost of sales from sales, and "total working hours" is the total sum of input working hours (sum of people x hours). As a result, it is an index that shows how much gross profit is obtained when a person works for one hour. By dividing the gross profit by the total number of hours worked, we can assess how much profit a person makes by working an hour.

Here, the "man-hour sales" is a value for evaluating how much sales there are with respect to input man-hours, and is specifically obtained by the following formula. By obtaining this value, it is possible to grasp how much sales are generated per hour worked by each employee.

As is clear from the above description, the gross profit data is obtained by subtracting the cost of sales data from the sales data. The cost of goods sold data is recorded in advance in a recording medium as data when purchasing each product. When one product is sold or discarded, the cost of the product is counted and The results accumulated within a day are the cost of sales data.

The input man-hour data is data relating to the time of a man who has input, and as described above, is obtained by accumulating the working hours per worker. In particular here they are calculated for each department.

As a result of the above, profitability data such as man-hour productivity data can be calculated.

Further, in this step, calculation may be performed using remuneration data when calculating profitability data. None of the above calculations directly include compensation data and are calculated in man-hours. Therefore, the profitability data is the same for both high labor costs (total remuneration) and low labor costs. On the other hand, remuneration varies depending on length of service and skills. Therefore, by including information about remuneration in this result, evaluation based on cost effectiveness can be made more accurately. As a result, for example, in a situation where overwork occurs, it is possible to add personnel at a lower labor cost. There are advantages such as being able to assign the person with the lowest

Also, as described above, the method includes the step of (4) creating business plan data for each department based on the profitability data for each department. This step is also a characteristic step in this method. In this method, it is possible to propose a more efficient personnel assignment for the next business day (business day) by considering the actual work performed in each department and the sales of that department. That is, in this method, it becomes possible to propose a quantified business plan for improving profitability.

By the way, the "planned work data" in this step is almost the same as the above "executed work data". differ only in respect.

Specifically, in this step, the profitability data is calculated for each department based on the execution work data, and while the total working hours are reduced in the departments with low profitability, the man-hours invested in the departments with high profitability are planned to be increased. Create data. More specifically, the total working hours in departments with high profitability data are increased, while the total working hours in departments with low profitability data are decreased to create the planned work data. By doing so, it becomes possible to aim for higher profitability in a highly profitable department.

Specifically, for example, after obtaining the above-mentioned profitability data for each department, departments showing high profitability and departments showing low profitability are compared, and total working hours in departments showing high profitability are determined. Perform processing to increase by the number of hours. In this case, if it is desired to keep the total working hours constant, the total working hours in departments exhibiting low profitability will be reduced accordingly. This increment and decrement can be adjusted as appropriate. It is preferable to preliminarily record the increment and decrement as increase/decrease data, or to calculate and obtain them according to the ratio of the profitability data for each department. By doing so, it is possible to suppress opportunity loss in a highly profitable department and make it more profitable. On the other hand, it is possible to secure profits more efficiently in less profitable departments. For example, FIG. 4 shows an example of a work schedule resulting from changes in total working hours when the work schedule shown in FIG. 1 is highly profitable. The example in this figure shows an example of increasing the number of workers involved in product creation and product delivery with the support of personnel from other departments.

In addition, in preparing the plan for the total working hours, it is preferable to prepare the plan so as to intensively invest man-hours in work contents that increase profitability. Therefore, it is preferable to add weighting data (for example, weighting coefficient data) to the work content data to be created, and increase working hours based on this weighting data. For example, cleaning up after work is considered to be less likely to be linked to earnings, so it is given a lower weighting. It is preferable to This weighting factor data is preferably determined in advance, but it is also preferable to determine the weighting factor data by performing calculation processing according to the ratio of profitability data for each department, as described above.

Here, in this step, it is also preferable to create plan work data for each department based on the change record data. In this step, we record how sales changed when business plans were changed in the past, and by referring to this data, we can increase the accuracy of improving profitability from the next day onwards. can.

Here, "change record data" refers to data including information relating to a comparison between one execution task data and its sales data and the previous day's execution task data and its sales data. Also, it is preferable to record this change record data for each department. For example, on the previous day, a business plan was created from the profitability data of the day before, but if there was no improvement from the profitability data of the day before, the policy for creating the planned business data of the previous day was wrong. I understand.

Also, for example, it is preferable to include information such as a 3% increase in sales when the total working hours in a certain department are increased by 10% from the previous day. In this case, specifically, it is preferable that the change record data include data on the increase in total working hours and data on the increase in profitability for each department. By doing so, it is possible to find the upper limit of total working hours that maximizes profitability.

For example, FIG. 5 shows an example of a comparison diagram of planned work data, execution work data, and profitability data. In the example of this figure, the horizontal axis represents the date, the actually planned business data and the executed business data are shown as a bar graph, and the profitability data is shown as a line graph. In this way, it is easy to see how profitability changes according to the difference between the planning stage and the execution stage, the business performance data and profitability data in the execution stage, and the changes in the business performance data. It is possible to comprehend.

As described above, this program and this method (hereinafter referred to as "this program, etc.") can improve profitability more stably. More specifically, conventionally, efforts have been made to improve man-hour productivity, but no consideration has been given to how to actually adjust manpower. In addition, in the case of a shortage of personnel, there is concern that the quality of service will decline, so personnel are appropriated, but in the case of an excess of personnel, it is normal to try to give employees leave from the viewpoint of reducing labor costs. is. However, according to this program, etc., even if there seems to be an overstaffing, it becomes possible to allocate staff to departments with high gross profit, which can lead to an increase in sales.

INDUSTRIAL APPLICABILITY The present invention has industrial applicability as a business plan data creation program and business plan data creation method.

Claims (3)

to the computer,
a step of recording execution business data for each department;
recording departmental sales data;
calculating profitability data for each department based on the execution business data for each department and the sales data for each department;
A business plan data creation program for executing a step of creating plan business data for each department based on the profitability data for each department,
The execution work data and the planned work data each include department data, date data, total working hours data, and a plurality of personnel name data, and further, belonging department data recorded in association with each of the personnel name data. , work content data, work hours data and remuneration data,
The step of creating the planned work data includes:
Comparison of the execution work data of the day , the sales data thereof and the profitability data calculated based thereon with the execution work data of the previous day , the sales data thereof and the profitability data calculated based on them A business plan data creation program for creating plan business data for each department based on change performance data including information about The step of creating the planned work data includes:
2. The planned work data is created by increasing the total working hours data in departments with high profitability data values and decreasing the total working hours data in departments with low profitability data values. business plan data creation program. A business plan data creation method realized by executing a business plan data creation program recorded in a computer,
a step of recording execution business data for each department;
recording departmental sales data;
calculating profitability data for each department based on the execution business data for each department and the sales data for each department;
A business plan data creation method comprising the step of creating business plan data for each department based on the profitability data for each department,
The execution work data and the planned work data each include department data, date data, total working hours data, and a plurality of personnel name data, and further, belonging department data recorded in association with each of the personnel name data. , work content data, work hours data and remuneration data,
The step of creating the planned work data includes:
the execution work data of the day , the sales data thereof, and the profitability data calculated based thereon; the execution work data of the previous day, the sales data thereof, and the profitability data calculated based thereon; A business plan data creation method for creating plan business data for each department based on change performance data including information relating to comparison of the above.

Images