JPH08297695A - Method and device for preparing data for business management and data chart for business management - Google Patents

Abstract

PURPOSE: To provide the method for preparing data for business management with which the estimation of business considered by a president can be supported. CONSTITUTION: This method is provided with a 1st process (A2) for inputting monthly set target values (A1) of respective items such as incomes, outgoings and profits in the beginning to a computer, 2nd process for transferring the same numerical values as the target values inputted in the 1st process as the predictive values of respective monthly result values (A3) and operating data for business management based on these predictive values, 3rd process for inputting the result values of a relevant month in place of the result values transferred in the 1st process in each month (A4) and operating the data for business management again, 4th process for changing the predictive values of result values in a non-execution month based on the data for business management reoperated in this 3rd process (A6) and operating the data for business management again, and 5th process for displaying the inputted and operated results of respective processes (A8).

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a business management data creating method (business read, support system), business management data chart, and business management data creating apparatus.

[0002]

2. Description of the Related Art Currently, even small and medium-sized enterprises use computers to analyze the current state of management.
Business analysis by the president is quite thorough.

In this business analysis, business analysis is performed based on the previous term-end data as the beginning work of the term, and the target setting for each month of this term is performed. Data are comparatively analyzed and various materials are prepared. Based on these materials, the forecast for the president's balance sheet at the end of the term is taken into consideration.

FIG. 43 shows a flow chart thereof. As the first work of the term, (1) a business analysis is made based on the previous term data.

(2) Targets for the current term are set (see FIG. 43B1).
Reference, the same except for the following symbols), and input the target value to the computer (B2).

[0006] As monthly work, (3) a target and actual data (based on the target value for 12 months and the actual value up to the finalized month) for the final confirmed month are compared and analyzed to prepare various materials. Yes (B3).

(4) The forecast for the balance at the end of the term is taken into consideration (B
4).

That is, as a chart, target values for monthly income, expenditure, income, etc. for each department and each item, actual product values for each month, and cumulative values from the beginning of each period, which were created at the beginning of the period, are used as a chart. It was obtained by computer and used for business analysis. However, most companies depended on the intuition of the president when it came to management.

[0009]

[Problems to be Solved by the Invention] However, since the business analysis that has been performed in the past is based on business performance,
There were few data for the future and it was easy to make a difference. Since the work was carried out within the scope of the work of financial accounting, it was managed in yen units.

As described above, the reason why the computer is not fully utilized for the reading of management is that the past data obtained by the conventional method is used when predicting the income, expenditure or earnings required for reading the management. This is because the method was based on a simulation.

However, the recent business environment is volatile,
Forecasts based on past data have made it difficult for most companies to obtain the reference data for business management. In other words, whether or not a company's business performance will rise depends on 100% of the management's reading of the president, and even if output data by a computer is used in the calculation of the income and expenditure forecast, which is the most important work when performing the reading of the management. , The predictions based on past data are no longer useful because they do not match the current situation, and it is necessary to speed up the work.

It is an object of the present invention to provide a method for creating business management data, a business management data chart, and a business management data creation apparatus capable of supporting the business affairs considered by the president. Is.

[0013]

The constitution of the present invention taken to solve the above-mentioned problems is as follows.

The method of creating business management data of the present invention is as follows: (1) At the beginning of the period, for each item of business management data such as income, expenditure, and profit, the target value set for each month is input to the computer. The first step, the same numerical value as the target value input in the first step is transferred as a predicted value of the actual value of each month, and each of the business management data is based on the predicted value. Second step of calculating a predicted value for an item, instead of the predicted value of the actual value transferred in the first step in each month, the actual value of the current month is input and the business management data is recalculated. The third step,
A fourth step of changing the predicted value of the actual value of the non-executed month based on the business management data recalculated in the third step and recalculating the business management data; and
It is characterized by having a fifth step of displaying the input and calculation result of each step.

(2) At the beginning of the period, for each item of business management data such as income, expenditure, profit, etc., the first step of inputting the target value set for each month into the computer, and the first step is input. Transfer the same numerical value as the target value as the predicted value of the actual value of each month, and create a basic table consisting of the predicted value for each item of the business management data calculated based on the predicted value. The second step, the third step of recalculating each item of the business management data by inputting the actual value instead of the forecast value of the corresponding month in the basic table at the time when the trial balance is made at the end of each month, A fourth step of changing the predicted value input instead of the actual product value in a non-execution month based on the management data recalculated in the third step and recalculating the management data; and , Input of each step, Characterized in that it has a fifth step of displaying the calculated results.

(3) In (1) or (2), the business management data obtained in the second, third, or fourth step is preset in the fifth step. The method is characterized by having a step of comparing with a value and displaying the comparison result graphically.

(4) At the beginning of the period, the first step of inputting and displaying the target value set for each month for each item of business management data such as income, expenditure, and income from the input terminal of the computer in the target field , A second step in which the same value as the target value for each month input and displayed in the first step is input and displayed as a predicted value in the performance column, based on the predicted value input and displayed in the second step A third step of calculating each item of the business management data, a fourth step of recalculating the business management data by inputting a performance value into the performance column when a trial balance is made at the end of each month; When it is necessary to correct the predicted value of the actual column of the non-elapsed month of the business management data recalculated in the fourth step, the fifth predicted value of the unexisted month of the actual column is changed. Step, based on the change of the actual value by the fifth step Can, and having a sixth step of re-calculating the management data.

(5) In (1) or (2) or (3) or (4), a computer based on the business management data obtained by inputting the actual value in each month in the fourth step. When the result of business management data simulation at the end of the period based on the comparison calculation result with the standard value is displayed on the display device, each expense item is assigned to the human body part, and the achievement rate is displayed by changes in color, pattern, etc. It is characterized by having a step of visually displaying and visually displaying.

In the business management data creation apparatus of the present invention, in (6) (1) or (2) or (3) or (4) or (5), each of the above steps is set in advance, and a keyboard is used. It is characterized by using a notebook computer which can be operated only by input from the computer and which is programmed so as to be able to calculate and display the business management data.

In the business management data chart of the present invention, (7) a target column in which the target value for each month for each item is displayed at the beginning of the period, and the target value for each month is a predicted actual value at the beginning of the period. It is displayed as a value, and when the actual value of each month is confirmed, the actual value is displayed in the elapsed month,
In the non-elapsed month, the target value is displayed as a predicted value, and the target column, various cumulative values based on the values displayed in the actual product column, various year-on-year changes, profits, profit margins, etc. Is provided with a column for displaying the data for business management of.

(8) Computer-generated income,
For each item of business management data such as expenditure and profit, the target value, actual value, cumulative value, etc. are input and displayed for each month, and the target column in which the target value is input The actual value is the actual value column in which the value of the target value of the relevant month is input and displayed as the predicted value in the non-elapsed month, and when the predicted value of the non-elapsed month is changed, the actual value of the non-elapsed month is accordingly , An actual value column in which a cumulative value is recalculated and displayed, a value obtained by comparing the target value with the actual value, and a setting limit value (risk standard,
In comparison with diagnostic criteria such as caution criteria), columns are provided for displaying diagnostic results of business management data such as various cumulative values, various year-on-year changes, profits and profit ratios.

(9) In (8), in each item (expense, sales or gross profit, profit, etc.) of the business management data, the goodness or badness of the prediction with respect to the target is displayed by a change in color, pattern, etc. And

[0023]

In the present invention, the target value determined monthly at the beginning of the period is used as the predicted value of the actual product value, and based on the predicted value,
Create business management data using a computer.
When the actual product value is confirmed, the business management data is created with the predicted value replaced with the actual value.

That is, for example, for any item such as income, expenditure, income, etc., a target value is set every month at the beginning of the period, and at the beginning of the period, the same content as the target value is put in the actual result column as a predicted value. deep. In this way, the actual value of the non-elapsed month is regarded as the predicted value for processing, and the predicted value is changed to the actual value every month when the actual value is fixed. If it is necessary to change the forecast value for any item set at the beginning of the period, the revision will be made immediately.

By using the data input in this way, for example, for each item such as income, expenditure, profit, etc., a target value, an actual value (as a predicted value for a non-elapsed month), a previous year's value Create a basic table that calculates other items.

Based on such a basic table, annual forecast table, comprehensive evaluation chart, item excess and shortage table, break-even forecast,
Data for business management such as income, payment graph, medium-term business plan, etc. can be created.

The above-mentioned work is carried out separately from the financial accounting, and may be handled not in yen but in thousands or millions.
However, for the actual value of each item, it is convenient to use the data calculated by financial accounting.

Therefore, the forecast calculation at the end of the period is performed by the actual value for the elapsed months and by the forecast value for the non-elapsed months, thereby grasping the profit situation at the end of the period.

As described above, according to the method for creating business management data of the present invention, forecasting based on past data is not performed, but management is read on an annual basis, for example. As described above, the business management data creation method of the present invention provides a strong backup for the progress of business because the business activity is based on the actual value and more accurate prediction at that time.

That is, unlike the conventional data for business management based on the target value set at the beginning of the period, it is possible to provide the president with data for business analysis that can respond quickly to the business situation. In addition, as a result of examining the data for business analysis obtained in this way, if it is determined that it is more appropriate to change the target value, enter it in the actual product field and change the value. Based on this, all calculations are recalculated. Various data can be input at this time.

If these operations are carried out using, for example, a laptop computer, it is possible to put them on the right side of the president and immediately obtain business management data when needed and utilize them effectively. Is.

[0032]

EXAMPLE A method for creating business management data according to the present invention will be described below with reference to an example.

In carrying out the method for creating business management data of the present invention, as work at the time of system introduction, (1) each item of income, payment, income, etc. in the basic table is registered in a computer.

(2) A reference value is registered for each item of (1) (for example, the reference value serves as a reference as to how much the actual value with respect to the target value gives a caution signal, and the predicted value vs. the actual value. (Register the value.) (3) For payment items, for example, register fixed costs or variable costs.

(4) Up to the number of registered departments (1),
Register (2) and (3).

Work is performed.

Next, the work performed in each month will be described with reference to the flowchart of the method for creating business management data of the present invention shown in FIG.

As the beginning of the term, (5) Perform a business analysis based on the previous term documents.

(6) Set targets for the current term. In setting this target, the target for this term is set monthly for each item of business management data such as income, expenditure, profit (Fig. 1
(Refer to A1, refer to the following symbols only), and input the target value to the computer (A2). Figure 2 shows the basic table (main part) obtained by entering the target value in the target field by the initial work, DCS sales, Anycom sales, purchase (cost of sales), gross profit, Salary, column for displaying total payments and profits, and columns for the target, actual product, difference, achievement rate, previous year's actual product, previous difference, and cumulative values of these, are provided at the beginning of the period. Examples of companies in June and May are shown. At this time, the target value is manually input, but the subtotal, total, and total fields are automatically calculated by the computer.

(7) Copy the target value for each month into the actual result column of the corresponding month (A3). That is, since the contents of the target column are put in the actual column, the target value and the actual value of each month are the same numbers. Since the actual value thus obtained is actually a non-elapsed month, it is hereinafter referred to as a predicted value.

As described above, the target value is determined by the same method as the conventional method, but the actual value of the non-elapsed month is regarded as the predicted value and processed.

FIG. 3 shows a basic table (main part) at this stage, showing a state in which the target column is copied to the actual column. 4 and 5 show the basic table obtained by automatic calculation by the computer for each item based on the target value and the actual value thus determined. The output contents are shown for the beginning of the term and May (the end of the term). Figure 6 shows the chart and the graph obtained as a result of the annual simulation performed on the gross profit based on these calculation results. However, at the beginning of the period, the cumulative target and the cumulative result are the same amount. It overlaps on the line.

Although only the basic tables for June and May are shown here, the basic table consists of 12 months. The basic table shows the results of calculating the target value, the actual value, and the comparison value with the previous year value for each item of business management data such as income, expenditure, income, etc. (Early period)
The forecast value is included in both the actual column of the basic table for minutes and the actual column for May (end of period) in FIG. An annual forecast table and other materials are prepared based on these basic tables.

The monthly work is as follows: (8) At the time when the monthly trial balance is made in each month (when the actual value is finalized), the actual value of the relevant month in the basic table is entered as the forecast value at the beginning of the period. The actual value is manually input instead of the target value (A4). When the data for the current month is entered, the total calculation for each item from the beginning of the period is automatically calculated by the computer, and the annual forecast table and other materials are recreated (A7, A8). That is, various materials are re-created based on the actual values up to the month when the target value for 12 months is confirmed.

FIG. 7 shows a basic table in which the actual results for June are entered in the actual results column, and FIGS. 8 and 9 are prepared by automatic calculation of the computer based on the input values for the actual results for June. It shows the output contents of June (the beginning of the term) and May (the end of the term) of the first work section. That is, by comparing FIG. 5 and FIG. 9, it can be immediately understood how the difference between the predicted value and the actual value due to the determination of the actual value in June influences at the end of the period (May). An annual forecast table and other materials are prepared based on these basic tables. FIG. 10 shows one of the comprehensive evaluation tables.

(9) By reviewing the created materials, if it is judged that correction is necessary among the items such as income, expenditure, profit in the non-elapsed month (each month after July), the corresponding items The actual value (predicted value) of the relevant month is changed (A5). That is, when it is necessary to change the numerical value of the item of the non-elapsed month, it is corrected immediately (A6).

(10) The basic table is recalculated in accordance with the change of the predicted value to recreate various materials (A7, A8).

FIG. 11 shows a basic table (main part) in the state where the predicted value is corrected. The Maycom sales record of 33,000 k ¥ in May (see FIG. 3) is corrected to 13,000 k ¥, The salary record of 2,000k ¥ in May (see Fig. 3) was revised to 2,600k ¥. FIG. 12 shows the screen output of the computer in May (term end) in that case. FIG. 13 shows the result of the annual simulation of the Sales Division 1 which is revised accordingly.

In creating these figures, the actual values are manually input, but the rows of small totals are automatically calculated, so it is not necessary to input them, and the total actuals column is automatically calculated by the computer.

As described above, in the case of handling the actual result column, the actual results are included in the elapsed months, and the actual data is treated, but the actual result column of the non-elapsed month (the value transcribed the target value at the beginning of the period or thereafter) The corrected value is included in) is treated as prediction data.

A table, a graph, etc. are created based on the target value, the actual value up to the fixed month, and the end-of-year income and expenditure forecast data.

In addition to the chart format, this annual forecast table
It is also possible to use a display that can be visually judged by using a figure as shown in FIG.

In the display of FIG. 10, items are assigned to parts of the human body, for example, the head of the body, the upper body,
The lower part of the body represents profit, sales or gross profit, and expenses, respectively, and the color (for example, red, yellow, blue) or pattern is very good for predicting the target, and very good for the target. , It is possible to read at a glance whether the business situation is good or bad by displaying a state in which there is some problem and the prediction is very bad for the target.

FIG. 14 is a basic table (principal part) in which the trial balance for July is obtained, that is, the trial balance for June and July is obtained, and FIGS. 15 and 16 are the basic charts of FIG. (Main part)
The simulation results for July and May (term end) calculated based on the above are shown. FIG. 17 shows a comprehensive evaluation chart showing the results of simulation in May (end of period) using the human body, and FIG. 18 shows the chart and the results obtained from the annual simulation of gross profit based on these calculation results. Shows a graph Various tables as shown below can be created by the above method of creating business management data.

(A) Income and expense system. Income, expenditure,
A table (for example, refer to FIG. 4 and FIG. 8) in which a target value, a product value (as a forecast value for unaged months), a previous year value, etc. are calculated monthly for any item such as profit is created.

(B) Annual forecast table. Fig. 6 is an annual forecast table for the first division of business (for example, the elapsed months are actual values, and the non-elapsed months are forecast values). Based on this table, annual simulations are performed at the beginning of each period and when the actual amount is determined for each month. be able to. For example, FIG. 6 graphically illustrates an annual simulation of gross profit.

(C) Overall evaluation chart. FIG. 10 shows an example of the comprehensive evaluation diagram.

(D) Excess and shortage table for each item. The value obtained by comparing the target value with the actual value and the setting limit value (risk criterion,
It is a chart with a column for displaying dangers in comparison with diagnostic criteria such as caution criteria), and shows the target excesses and shortages (rates) and the results as of each month. FIG. 19 shows the display and results of the forecast excess and deficiency (rate) as of June in the work department 1. FIG. 20 also shows target excesses and shortages (rates) as of June, and FIG. 21 shows target excesses and shortages (amounts) as of June as in FIG. "," Danger "is displayed.

(E) Break-even graph. FIG. 22 is a graph of a break-even simulation of the first business section, which allows a break-even simulation in a constantly operating state.

(F) Income, payment graph. It is payment, income (cumulative target, cumulative product, cumulative year-on-year change) by each month, and FIG.
Shows a chart and a graph of income by June of Business Division 1, and FIG. 24 shows payment by July.

(G) Medium-term management plan. FIG. 40 shows an example of the medium-term management plan table of the work section 1.

As described above, according to the method of creating business management data in this embodiment, the past output data is not used for prediction in the output material by the computer.

Management is read in units of one period (one year).

For each item of business management data such as income and expenditure, a target value is set monthly at the beginning of the period. At the beginning of the period, the same content as the target value is put in the actual result column, and the actual value of the non-elapsed month is regarded as the predicted value and processed.

If the predicted value of an arbitrary item set at the beginning of the period is expected to change, it is immediately corrected.

When the actual value is fixed every month, the predicted value is changed to the actual value. Only the data for the current month is input, and the total from the beginning of the period is automatically calculated by the computer.

In the forecast calculation at the end of the period, the profit status at the end of the period is grasped by the actual value for the elapsed month and the forecast value for the non-elapsed month.

If the computer automatically calculates based on the input of the actual product value of each month and corrects the predicted value based on this calculated data, the predicted value input to the actual value of this non-elapsed month is obtained. Based on this, all data will be corrected and various data calculated based on this data will be given to the president next month. In addition, a simulation can be performed with the input data. An annual simulation will be conducted at the beginning of each period and when the actual volume is determined at each month.

Whether or not the corporate performance is improved depends on 100% of the president's management, so that the effect of such a method of creating business management data is extremely large.

By using such a method, the present invention enables business activities using business management data based on actual values and more accurate forecasts at that time, and provides a powerful backup for business progress. Therefore, the past problem of forecasting income and expenditure, which is one of the most important tasks when calculating business, is the most important task. It is no longer useful because it does not match the current situation. The points can be removed. In addition, for the problem that it is necessary to speed up the work, for example,
By developing a unique program that uses a laptop computer, you can keep it at hand and immediately grasp the situation at any time, when you need it, and if you need it, you can immediately simulate it, improving work efficiency. It can be measured. Can be performed.

25 to 40, the above operation will be described with reference to another embodiment of the present invention using a notebook computer. The menu screen shown in FIG. 25 is a screen for selecting the management target of the business management system according to the method for creating business management data of the present invention, and FIG. 26 is the menu screen for the case where the first operation section is selected on the menu screen of FIG. Then, it is a screen for selecting an implementation item. 27 is a screen for selecting a month to be processed on the screen when the data input is specified on the menu screen of FIG. 26, and FIG. 28 is a screen for when June is specified on the data input screen of FIG. . 29 is the same as FIG. All items can be input by key operation on the screen when normal input is specified. FIG. 30 shows 2. in FIG. It is an input screen when the transcription input is specified. FIG. 31 is an item-based data input screen, which can be input when, for example, DCS in FIG. 31 is selected and the entry input is designated. In FIG. 32, 2. If you specify the transcription input, the menu screen shown in Fig. 33 appears.
On this screen, enter the copy source month, copy destination month, and target fields (in this case, 6, 7, and 11), that is, when input as shown in FIG. 33 and executed, as shown in the upper and lower parts of FIG. D
The CS target for June is from July to November.

FIG. 35 shows a many-you screen when the optional function of FIG. 26 is selected.

FIG. 36 shows the menu screen for the medium-term management plan, FIG. 37 shows the input screen and the screen after the input is executed, and FIGS. 38 and 39 show the medium-term management from 1994 to 2003. FIG. 40 shows output data of the first business section in the plan, and FIG. 40 shows a comparative diagram and a graph regarding gross profit, payment, and profit obtained based on these outputs.

41 and 42 show the comparison of the output contents of the business management data created by the method of the present invention and the business management data created by the conventional method.
Shows the case of the present invention, and FIG. 42 shows the conventional case.
The actual data was obtained in June and July.
In the conventional case, there was no predicted data, but in the case of the present invention in FIG. 41, the actual data are described in June and July, and
From the month to the end of the year, forecast data is entered in the actual value column, and a simulation is performed and a graph is displayed using these data.

As described above, in the method of creating business management data of this embodiment, it is possible to easily create business management data and utilize it for management by incorporating all the systems in a notebook computer. Is possible.

In the above embodiment, the case of one department and the case of being viewed from a certain angle have been shown, but generally speaking, (1) processing for each department is also possible.

The beginning work and the monthly work in the flowchart of FIG. 1 are shown as works for one department, but it is also possible to enable processing of a plurality of departments. For example, processing can be performed by designating the relevant department on the menu screen of FIG. 25, and total departments can also be processed.

(2) It is also possible to view the material by using a temporary predicted value when viewed from another angle. In such cases,
For example, the work can be easily performed by the following procedure.

(B) The file currently used in production (hereinafter referred to as the production file) is stored in another floppy disk. If data writing is designated on the menu screen of FIG. 26, the result can be immediately obtained.

(B) The production file is changed to a temporary predicted value and the material is created. After that, the data (contents of the production) stored on the floppy disk in (a) is returned to the production file.

According to such a method, the correction material can be created from any angle.

That is, it is possible to easily know whether such a prediction can be made at the lowest in the current period or such a prediction at the highest. It is also possible to change the target settings.

(3) It is also possible to calculate the income and expenditure forecast of a new project.

Since the production file can be easily stored in another floppy disk, it is possible to predict the income and expenditure of a new project based on the current income and expenditure items. You can also keep the contents of the new project on a floppy disk and create various materials as needed.

Further, if the specified department is used as a part of the new project, it is possible to predict the income and expenditure of the new project department, and also to predict the total amount of the current production department and the new project department. If you do, you can also read the future power of the company.

(4) The medium-term management plan can be easily created. 36 to 40 show a method of creating a medium-term management plan.

Since the actual period can be entered by reading the business management file (floppy) at the end of the period,
After that, it is possible to create various materials by inputting the annual increase rate of the plan. Of course, you can freely change the amount.

(5) The input work is in thousands of yen, and the operation is simple using a notebook computer. Although work is performed separately from conventional financial accounting, it is convenient to use the data calculated by financial accounting for the actual values of each item.

Of course, it is possible to set items that are not included in financial accounting.

(6) Since the management activity is based on the actual value and the more accurate predicted value at that time, it is a strong backup for the performance extension.

[0091]

EFFECTS OF THE INVENTION The method for creating business management data according to the present invention is capable of (1) knowing the most important prediction when reading business. That is, since this predicted value is not calculated from past data but is calculated from the latest data on each income and expenditure item at the present time, the predicted value can be calculated in a form that is closest to the ideal. At the middle of the period, you can instantly know the forecast profit at the end of the period. This predicted value is always an important clue to the management's reading of the president.

(2) Notebook computer (portable computer)
Use to enter data in thousands of yen. It can be used separately from normal financial accounting, and forecast calculation can be done instantly using a computer.

(3) In addition to tables, graphs, diagrams, etc. can be created as materials for prediction. By registering the reference value in advance in a computer and comparing the predicted value with the reference value, it is possible to output the evaluation as a graph or evaluation chart (including display in color) in an easy-to-understand manner. (4) Strategy meetings of companies, which are held based on this business management data, can formulate strategies based not only on past data, but also on forecast data for the end of this fiscal year. Since monthly results are displayed as forecast values for the end of the current fiscal year, the forecast values for the end of the current fiscal year that are output fluctuate. You can proactively develop in a more positive, forward-looking manner.

(5) It is possible to instantly predict the income and expenditure of new planning work.

In this case, the new planning department can be managed separately from the current department, and the new planning department alone and the total of the current department and the new planning department can be separated.

The profit situation as a whole company when the new planning work is carried out or when only looking at the new planning work is immediately understood. (It can be instantly created by entering the forecast data of the new planning department for each month.) (6) Medium-term management plan materials can also be created.

(7) Others The predicted value by simulation can also be simulated from another angle.

For example, in order to secure the target year-end profit, it is possible to carry out a simulation such as what numerical value can be set as the effort target for the unaged amount in consideration of the elapsed amount.

As described above, the present invention can provide a method for creating business management data that can support the business affairs that the president thinks of, and has a great industrial effect.

[Brief description of drawings]

FIG. 1 is a flowchart of an embodiment of a method for creating business management data according to the present invention.

FIG. 2 is an explanatory diagram of a basic table (main part) at a stage where a target value is input by initial work of an embodiment of the method for creating business management data according to the present invention.

FIG. 3 is an explanatory diagram of a basic table (main part) in a state obtained by copying the target value into the actual result column in the same manner as the initial work.

FIG. 4 is an explanatory diagram of one of the basic tables (early period).

FIG. 5 is an explanatory diagram of one of the basic tables (term end).

FIG. 6 is also an explanatory diagram of one of the annual simulations.

FIG. 7 is an explanatory diagram of a basic table (main part) in a state where an actual calculated value is fixed as a monthly work.

[Figure 8] Similarly, one of the states where the actual calculation value has been confirmed (end of June)
Is a basic table of.

FIG. 9 is a basic table of one of the states (term end) in which the calculated values are also fixed.

FIG. 10 is also a comprehensive evaluation diagram.

FIG. 11 is an explanatory diagram of an input basic table (main part) at the stage (at the end of July) when the actual calculation value is fixed as monthly work.

[Fig. 12] Similarly, it is one of the basic tables (end of the period) at the stage (end of July) when the actual calculation value is finalized.

FIG. 13 is also an explanatory diagram of one of the annual simulations.

FIG. 14 is also a basic table (main part) of a stage in which the actual value (predicted value) of an undetermined month is changed in the monthly work.

FIG. 15 is one of the basic tables (July) at the stage of changing the actual value (predicted value) of the undetermined month.

FIG. 16 is one of the basic tables (term end) at the stage when the actual value (predicted value) of the undetermined month is changed.

FIG. 17 is also an explanatory diagram of one of the annual simulations.

FIG. 18 is also an explanatory diagram of a comprehensive evaluation diagram.

FIG. 19 is an explanatory diagram of one of the business management data similarly obtained based on the basic table.

FIG. 20 is an explanatory diagram of one piece of business management data similarly obtained based on the basic table.

FIG. 21 is an explanatory diagram of one of the business management data obtained similarly based on the basic table.

FIG. 22 is an explanatory diagram of one of the business management data similarly obtained based on the basic table.

FIG. 23 is an explanatory diagram of one of the business management data similarly obtained based on the basic table.

FIG. 24 is an explanatory diagram of one piece of business management data similarly obtained based on the basic table.

FIG. 25 is a schematic view of one of the menu screens of another embodiment of the method for creating business management data of the present invention.

FIG. 26 is a schematic view of one of the menu screens.

FIG. 27 is a schematic view of one of the menu screens.

FIG. 28 is also a schematic view of one of the menu screens.

FIG. 29 is also a schematic view of one of the menu screens.

FIG. 30 is also a schematic view of one of the menu screens.

FIG. 31 is also a schematic view of one of the menu screens.

FIG. 32 is also a schematic view of one of the menu screens.

FIG. 33 is also a schematic view of one of the menu screens.

FIG. 34 is an explanatory diagram of a screen similarly showing the implementation result of the menu of FIG. 33.

FIG. 35 is also a schematic view of one of the menu screens.

FIG. 36 is also a schematic view of one of the menu screens.

FIG. 37 is an explanatory diagram of a screen similarly showing the implementation result of the menu of FIG. 36.

38 is an explanatory diagram showing details of FIG. 37 in the same manner. FIG.

39 is an explanatory diagram showing details of FIG. 37 in the same manner. FIG.

FIG. 40 is an explanatory diagram showing a simulation result of the present invention.

FIG. 41 is an explanatory diagram of a business management data chart according to the present invention.

FIG. 42 is an explanatory diagram of a business management data chart according to a conventional method.

FIG. 43 is a flowchart of a method for creating business management data according to the conventional method.

[Explanation of symbols]

A1 ... Target setting for this term, A2 ... Input target value into computer, A3 ... Copy target value into actual result column, A4 ... Enter confirmed actual value into actual result column, A5 ... Correct forecast value,
A6 ... Correct forecast values, A7 ... Specify calculation on menu screen, A8 ... Create forecast tables and other materials.

─────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission date] August 24, 1995

[Procedure Amendment 1]

[Document name to be amended] Statement

[Correction target item name] Figure 8

[Correction method] Change

[Correction content]

[Figure 8] Similarly, one of the states where the actual calculation value has been confirmed (end of June)
6 is an explanatory diagram of a basic table of FIG .

[Procedure Amendment 2]

[Document name to be amended] Statement

[Correction target item name] Figure 9

[Correction method] Change

[Correction content]

FIG. 9 is an explanatory diagram of one of the basic tables (end of period) in which the calculated values are fixed.

[Procedure 3]

[Document name to be amended] Statement

[Name of item to be corrected] Fig. 12

[Correction method] Change

[Correction content]

FIG. 12 is an explanatory diagram of one of the basic tables (end of period) at the stage (end of July) when the calculated value is fixed.

[Procedure amendment 4]

[Document name to be amended] Statement

[Name of item to be corrected] Fig. 14

[Correction method] Change

[Correction content]

FIG. 14 is an explanatory diagram of a basic table (main part) at a stage when the actual value (predicted value) of an unconfirmed month is changed in the monthly work.

[Procedure Amendment 5]

[Document name to be amended] Statement

[Correction target item name] Figure 15

[Correction method] Change

[Correction content]

FIG. 15 is an explanatory diagram of one of the basic tables (July) at the stage of changing the actual value (predicted value) of the undetermined month.

[Procedure correction 6]

[Document name to be amended] Statement

[Correction target item name] Fig. 16

[Correction method] Change

[Correction content]

FIG. 16 is an explanatory diagram of one of the basic tables (term end) at the stage when the actual value (predicted value) of the undetermined month is changed.

Claims (9)

[Claims] 1. A first step of inputting a target value set for each month into a computer for each item of business management data such as income, expenditure, income at the beginning of the period, the first step
A numerical value that is the same as the target value input in the process of step 1 is transferred as a predicted value of the actual value of each month, and the predicted value is calculated for each item of the business management data based on the predicted value. Process, the actual value of the current month is input instead of the predicted value of the actual value transferred in the first step in each month, and the operation management data is recalculated.
Step, a fourth step of changing the predicted value of the actual value of the unexecuted month based on the business management data recalculated in the third step, and recalculating the business management data; and The fifth step of displaying the input and calculation result of each step
A method for creating business management data, characterized by having the steps of. 2. At the beginning of the period, for each item of business management data such as income, expenditure, profit, etc., the first step of inputting the target value set for each month into the computer, and the first step is input in the first step. The same numerical value as the target value is transferred as a predicted value of the actual value of each month, and a basic table is created which is composed of the predicted values of the respective items of the business management data calculated based on the predicted value. The third step of recalculating each item of the business management data by inputting the actual value instead of the forecast value of the corresponding month of the basic table at the time when the trial balance is made at the end of each month. A fourth step of changing the predicted value input instead of the actual product value in the unexecuted month based on the management data recalculated in the step 3 and recalculating the management data; and Shows the input and calculation results of each process A method for creating business management data, characterized by having the fifth step shown. 3. The fifth step comprises the second, the third,
3. Creation of business management data according to claim 1 or 2, further comprising a step of comparing the business management data obtained in the fourth step with a preset value and graphically displaying the comparison result. Method. 4. The first step of inputting and displaying a target value set for each month for each item of business management data such as income, expenditure, profit, etc. at the beginning of the period from an input terminal of a computer, A second step in which the same value as the target value for each month input and displayed in the first step is input and displayed as a predicted value in the performance column, and the above-described predicted value input and displayed in the second step A third step of calculating each item of the business management data, a fourth step of inputting a performance value into the performance column and recalculating the business management data when a trial balance is made at the end of each month. If it is necessary to correct the predicted value of the actual column of the non-elapsed month of the business management data recalculated by the process of 4, the fifth step of changing the predicted value of the non-elapsed month of the actual column , Based on the change of the actual value by the fifth step, And a sixth step of recalculating the business management data. 5. A simulation of business management data at the end of the period based on a result of comparison calculation with a standard value by a computer based on the business management data obtained by inputting actual values in each month in the fourth step. The result
When displaying on the display device, each expense item is assigned to the part of the human body, and the achievement rate is displayed visually by changing colors, patterns, etc.,
The method for creating business management data according to any one of claims 1 to 4, further comprising a step of visually displaying. 6. The respective steps are preset,
6. The business management data according to any one of claims 1 to 5, which uses a notebook computer that can be operated only by input from a keyboard and is programmed so as to be able to calculate and display the business management data. Creation device. 7. At the beginning of the period, the target column in which the target value for each item for each month is displayed, and at the beginning of the period, the target value for each month is displayed as the predicted value of the actual value, and the actual value for each month is displayed. At the time of confirmation, the actual value is displayed in the elapsed month, and in the non-elapsed month the actual product column in which the target value is displayed as a predicted value, and the target column and the value displayed in the actual product column. A business management data chart characterized in that it is provided with columns for displaying business management data such as various accumulated values, various year-on-year changes, profits, and profit ratios. 8. A target value, a product value, a cumulative value, etc. for each item of business management data such as income, expenditure, profit, etc. created by a computer are input and displayed for each month, and the target is displayed. The target column where the value is entered, the actual value for the elapsed month, the actual column where the target value for the relevant month is entered and displayed as the predicted value for the non-elapsed month, and the predicted value for the non-elapsed month has been changed At times, the actual value of the non-elapsed month, the actual value column in which the cumulative value is recalculated and displayed, the value obtained by comparing the target value with the actual value, and the setting limit value are compared with each other. A business management data chart provided with columns for displaying diagnosis results of business management data such as cumulative values, various year-on-year changes, profits, and profit ratios. 9. Each item (expense,
Sales or gross profit, profit, etc.), the goodness or badness of the prediction with respect to the target is displayed by color, pattern change, etc.
Data chart for business management described.