JP2005157824A - Business management method and device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To attain quick business judgement by enabling a business manager to grasp accurate business information in real time. <P>SOLUTION: A business system server 20 acquires the account data and plan value of a base system from other system servers 11 and 12, and calculates the approximate values of various business management data and business management plan data on daily basis, and stores them in a database 23. When the result values of the business management data on monthly basis are decided, the business management data and business management plan data calculated by using the result values are corrected. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to business management technology using an electronic computer.

  Companies usually hold a management meeting several times a month, and make management strategies while considering management information such as monthly financial results and forecasts. However, management meetings are rarely conducted while monitoring real-time management information. Many management meetings are held mainly by paper, and the person in charge has to find out the corresponding data from the past performance data stored in the filing. In addition, the person in charge had to explain to the executives until the draft of management data was approved, and it took time to determine management information.

  In addition, there exists a technique described in Unexamined-Japanese-Patent No. 2003-141344 (patent document 1) as what is related as this kind of technique.

JP 2003-141344 A

  As described above, since management information has conventionally been grasped on a monthly basis, it has been difficult to make a quick management decision. In addition, since conventional management information materials were stored and managed in paper form, it took time to investigate past performance. In addition, if the degree of achievement of the forecast value is low compared to the budget value planned by the person in charge, the person in charge needs to correct the forecast value. However, it took about a month for the person in charge to create a revised version of the document, which was reviewed by the manager and reported to the management meeting.

  An object of the present invention is to solve the above-described problems.

  The present invention calculates the cumulative value up to the target date for the various daily business management data of the company, calculates the cumulative value up to the planned date for the various daily business management plan data from this target date, After the cumulative value of the management data for the date has been determined, the cumulative value of the management data calculated after the deadline date and the cumulative value of the management plan data are the cumulative actual values of the management data determined on the cutoff date. It is characterized by business management technology that is corrected using

  According to the present invention, the manager can make a quick management decision while monitoring real-time management information.

  FIG. 1 is a configuration diagram of the business management system of the present embodiment. This system includes a management system server 20, another system server 11 connected to the management system server 20 via a network, another system server 12, another computer 13, and a client terminal connected to the management system server 20 via an intranet 30. 41 and a client terminal 42.

  The other system server 11 is a computer that makes a plan such as a shipment plan. The other system server 12 is a computer that processes daily accounting data such as management of shipping slips. The other computer 13 holds data related to business management in the form of a spreadsheet 15.

  The management system server 20 includes a DB (database) server 21 and an AP (application) server 22. The DB server 21 is a computer and connects the database 23. The database 23 is stored in the storage device of the DB server 21. The DB server 21 and the AP server 22 are connected by a transmission path. The DB server 21 collects data related to business management from the other system server 11, the other system server 12, and the other computer 13 and stores it in the database 23. The DB server 21 processes the collected data, creates easy-to-understand management management data for the manager, and stores it in the database 23.

  The client terminal 41 is a computer operated by a person in charge of management material creation. The client terminal 42 is a computer operated by a manager. The client terminal 41 and the client terminal 42 execute a web browser. The AP server 22 communicates with the client terminal 41 and the client terminal 42 via the intranet 30 using HTTP (Hyper Text Transfer Protocol). The AP server 22 receives a search request for the database 23 from the client terminal 41 and the client terminal 42 and transmits the search request to the DB server 21. The DB server 21 retrieves the requested business management data by searching the database 23 and transmits it to the AP server 22. The AP server 22 creates a Web screen from the business management data and transmits it to the client terminal 41 and the client terminal 42. The Web browsers of the client terminal 41 and the client terminal 42 transmit the search request to the AP server 22 and display the received Web screen. The AP server 22 includes a program for transmitting an e-mail to the client terminal 41. When the DB server 21 detects an error during processing, the DB server 21 transmits a warning mail to the client terminal 41 via the AP server 22.

  FIG. 2 is a diagram showing data transferred from the other system server 11 and the other system server 12 to the DB server 21 and processed. The other system server 11 sends to the DB server 21 the planned shipment number 51, the actual value 52, the cost data information 53, the inventory balance information 54, the general cost 55, the direct sales cost 56, the fixed cost 57, the depreciation cost of the entire company. 58 and 59 business days of the month are transferred. The other system server 12 transfers the daily shipping slip data 60 to the DB server 21.

  The data collection processing unit 70 of the DB server 21 receives these data and stores them in the database 23. After performing a daily calculation process, a forecast calculation process, and a monthly process, which will be described later, on the collected data, the data processing unit 74 processes the acquired and calculated business management data into a format suitable for the manager of the database 23. To store.

  FIG. 3 is a flowchart showing a processing procedure of a related program executed by the DB server 21. The DB server 21 includes program modules of a data collection processing unit 70, a daily calculation processing unit 71, a monthly processing unit 72, and a forecast calculation processing unit 73.

  The data collection processing unit 70 acquires the shipping slip data 60 from the other system server 12 (step 81). Next, the daily calculation processing unit 71 aggregates the shipping slip data 60 and sets it as a daily sales value (step 82). Since not all daily sales data is managed in the shipping slip, this sales value can be regarded as an approximate value. Of course, the sales amount or the daily total value of the sales amount may be acquired from the other system server 12. The data collection processing unit 70 acquires the cost data information 53, the inventory balance information 54, the general cost 55, the direct sales cost 56, the fixed cost 57, the depreciation cost 58 and the current business day number 59 from the other system server 11 (step 83). ). The daily calculation processing unit 71 calculates gross profit from the calculated sales and the acquired manufacturing cost (step 84), and calculates profit / loss from the calculated gross profit and the acquired general cost and direct sales cost (step 85). The marginal profit is calculated from the calculated sales, the acquired direct cost, and the processing subcontracting cost (step 86). The daily calculation processing unit 71 calculates a free cash flow from the calculated marginal profit, the acquired fixed cost monthly budget, the current business day of the month, the inventory balance information, and the depreciation monthly budget (step 87). Next, the daily calculation processing unit 71 uses each calculated value to calculate a cumulative value from the starting date such as half year, year, year, quarter, etc. to the target date, and stores this business management data in the database 23 (step S40). 88). As will be described later, if the correction value for the previous month has been calculated, the cumulative value up to the target date is corrected by the correction value.

  The data collection processing unit 70 acquires the planned shipment quantity 51 from the other system server 11 (step 89). Further, the data collection processing unit 70 acquires the past average selling price actual value as a part of the actual value 52 from the other system server 11 (step 90). Next, the forecast calculation processing unit 73 calculates the daily sales plan value for the future from the target date of the daily calculation processing by the daily calculation processing unit 71 from the acquired daily shipment plan unit value and the past average selling price result. (Step 91). Next, the forecast calculation processing unit 73 calculates a gross profit plan value from the calculated sales plan value and the acquired manufacturing cost forecast value (step 92), and calculates the calculated gross profit plan value and the acquired general cost forecast value, sales. The profit / loss plan value is calculated from the direct cost forecast value (step 93), and the daily marginal profit plan value is calculated from the calculated sales plan value and the acquired direct cost and processing subcontracting cost (step 94). Further, the forecast calculation processing unit 73 calculates the free cash flow plan value from the calculated daily marginal profit plan value and the acquired fixed cost monthly budget, the number of business days in the plan month, inventory balance information, and the depreciation cost monthly budget. Calculate (step 95). Next, the forecast calculation processing unit 73 calculates a cumulative value from the starting date to the planned date using each calculated value, and stores this business management plan data in the database 23. As will be described later, if the correction value for the previous month has been calculated, the cumulative value up to the planned date is corrected by the correction value. The forecast calculation processing unit 73 performs daily forecast calculation processing for the required number of days.

  The data collection processing unit 70 acquires the actual value of the closing date of the current month based on the settlement value from the other system server 11 (step 96). Here, the current month means a month targeted by the daily calculation processing unit 71 for the latest actual value. The monthly processing unit 72 acquires the actual value for the current month (step 97). Next, the monthly processing unit 72 applies correction to each of the management management data and the management management plan data calculated by the daily calculation processing unit 71 and the forecast calculation processing unit 73 after the deadline of the current month by using the actual value. The result is stored in the database 23 (step 98). In other words, each of the cumulative value of business management data and the cumulative value of business management plan data calculated after the deadline date of the current month, the business management value calculated with the cumulative actual value determined on the deadline date of the current month and the deadline date as the target date Correct only the difference from the accumulated data. The monthly processing unit 72 may perform the processing of steps 97 and 98 in the month following the current month.

  FIG. 4 is a diagram for explaining, by way of example, how the cumulative value of business management data and business management plan data obtained by daily processing is corrected by the actual value of the deadline date of the current month. For example, the cumulative value of profit and loss obtained by daily processing is an approximate value, and this daily cumulative value is plotted for each day in April. In this example, since the actual value for April is not fixed even after May 30 after the deadline date, the calculation and plotting of the cumulative value of profit and loss is continued. Since the actual value for April is fixed as of May 15, the cumulative value is replaced with the actual value retroactively to April 30. 101 is the difference between the accumulated value and the actual value as of April 30 and is a corrected value (positive value, 0 or negative value). The value obtained by adding this correction value to the cumulative value for each day up to May 15th, that is, the value obtained by moving the calculated cumulative value for each day up to May 15th by this correction value The cumulative value for each day. The cumulative profit / loss plan value after May 16 is also corrected by adding this correction value. A dotted line 130 is a cumulative profit / loss plan value for April, and a dotted line 140 is a profit / loss plan value corrected by adding the correction value for April to the profit / loss plan value. Since the actual value for May has been determined as of June 15, the accumulated value is replaced with the actual value for May retroactively to May 31 of the May deadline. Reference numeral 102 denotes a difference between the accumulated value and the actual value as of May 31. As with April, the cumulative value of each day up to June 15 and the prospective value ahead are corrected by the correction value for May.

  The data processing unit 74 of the DB server 21 creates a graph showing time-series changes of these data as shown in FIG. 4 from the business management data and business management plan data stored in the database 23 and stores the graph in the database 23. .

  FIG. 5 is a diagram for explaining the operation of the business management system for correcting the forecast value of the business management data. When the management system server 20 detects a deviation between the budget value of the business management data and the prospect value before or after the correction based on the actual value (310), the mail 320 indicating this deviation via the intranet 30 Is transmitted to the client terminal 41. The person in charge 330 who operates the client terminal 41 creates a new prospect value plan 340 and transmits it to the management system server 20 via the client terminal 41 and the intranet 30. The management system server 20 posts the new prospect value plan 340 on the communication board 350 on the storage device. A manager 360 who operates the client terminal 42 browses the new prospect value plan 340 on the communication board 350 and records an approval on the communication board 350 if there is no problem. The management system server 20 monitors the record of this approval, and when the new prospect value plan 340 is approved, the management system server 20 corrects the prospect value to the new prospect value plan 340 (370).

  FIG. 6 is a flowchart showing a processing procedure of the business management system for correcting the forecast value of the business management data. The management system server 20 detects a deviation between the budget value of the management data and the prospect value before or after the correction based on the actual value (step 111). When the difference value exceeds a predetermined threshold value, the management system server 20 transmits a warning mail to the client terminal 41 (step 112). The client terminal 41 receives this mail and displays it. The person in charge 330 creates a new prospect value plan if necessary and transmits it to the management system server 20 via the client terminal 41 (step 113). The management system server 20 registers this new prospect value plan in the communication board 350. When the management manager 360 approves the new prospect value plan via the client terminal 42 (step 114), the management system server 20 detects this and registers it in the database 23 as the new prospect value (step 115). If this series of business processes is constructed as a workflow system, the time required to approve a new prospect value plan can be shortened.

It is a block diagram of the business management system of embodiment. It is a figure which shows the example of the data which a business management system handles. It is a flowchart which shows the process sequence of the program performed with DB server 21 of embodiment. It is a figure explaining a mode that calculated management management data is amended. It is a figure explaining operation | movement of the business management system which corrects the outlook value of business management data. It is a flowchart which shows the process sequence of the business management system which corrects the prospect value of business management data.

Explanation of symbols

  20: Management system server, 21: DB server, 22: AP server, 23: Database, 41, 42: Client terminal, 70: Data collection processing unit, 71: Daily calculation processing unit, 72: Monthly processing unit, 73 : Outlook calculation processing unit, 74: Data processing processing unit.

Claims (5)

  Acquire and calculate various business management data such as daily sales, gross profit, profit and loss of the company, calculate the cumulative value up to the target date of the business management data, store it in the storage device, Acquire and calculate various business management plan data such as daily sales plan value, gross profit plan value, profit and loss plan value, and calculate the cumulative value up to the plan date of the business management plan data and store it in the storage device After the cumulative value of the business management data on the deadline date of the month is confirmed, each of the cumulative value of the business management data and the cumulative value of the business management plan data calculated after the deadline date is confirmed at the deadline date. A business management method comprising: correcting a difference between a cumulative actual value of the business management data and a cumulative value of the business management data calculated using the deadline date as the target date.   A means for acquiring and calculating various business management data such as daily sales, gross profit, profit and loss of the company, calculating a cumulative value up to the target date of the business management data and storing it in a storage device, from the target date Acquire and calculate various business management plan data such as future daily sales plan values, gross profit plan values, profit and loss plan values, and calculate the cumulative value of the business management plan data up to the plan date to the storage device. Means for storing, and after determining the cumulative value of the business management data on the deadline date of the month, each of the cumulative value of the business management data and the cumulative value of the business management plan data calculated after the deadline date, And a means for correcting using the difference between the accumulated actual value of the business management data determined on the deadline date and the cumulative value of the business management data calculated as the target date. Machine. A business management system having a management system server computer and a plurality of client terminals,
The management system server computer acquires and calculates various business management data such as daily sales, gross profit, profit and loss of the company, calculates the cumulative value up to the target date of the business management data, and stores it in the database The next calculation processing unit, and obtains and calculates various business management plan data such as planned daily sales figures, gross profit plan values, profit and loss plan values from the target date to the planned date of the business management plan data A forecast calculation processing unit that calculates a cumulative value and stores it in the database; and after the cumulative value of the business management data on the deadline date of the month is determined, the cumulative value of the business management data calculated after the deadline date and the Each of the cumulative values of the business management plan data is determined based on the cumulative management value of the business management data determined on the deadline date and the business management data calculated using the deadline date as the target date. And a monthly processing section to be stored in the database is corrected by using the difference between the product values,
The client terminal has a Web browser that transmits a search request to the management system server computer and displays a display screen including the received cumulative value of the management management data and the cumulative value of the management management plan data. Management system to do.   The management system server computer has processing means for creating a graph display screen showing a time series change of the cumulative value of the business management data and the cumulative value of the business management plan data, and the Web browser of the client terminal is The business management system according to claim 3, wherein the graph display screen is requested and the received graph display screen is displayed.   The management system server computer detects a difference between a budget value and a forecast value indicated by the management management plan data, receives a warning email to the client terminal of the person in charge, and receives a new prospect value draft of the person in charge And a means for detecting the approval of the prospect value plan from the client terminal of the manager and correcting the forecast value to the prospect value plan. Item 3. The business management system according to item 3.

Images