JP2007323680A - Management decision support system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To conduct speedy and appropriate real-time management among management hierarchies. <P>SOLUTION: This management decision support system for supporting management judgment is provided with a management decision support device which accepts input data of a long range schedule plan, a profit and loss target, a sales target, an inventory target, and a profit-loss decision support system which receives the long range schedule plan, the profit and loss target and the sales target, performs simulation calculation on whether it is executable the long range schedule plan or not after developing the long range schedule plan into a middle range schedule plan, and calculates first prediction data of a correction plan, profit and loss prediction and sales prediction of the long range schedule on the basis of the result. The management decision support system further has an inventory/procurement planning support system for calculating a procurement plan on the basis of the middle range schedule plan and calculating second prediction data of inventory prediction and evaluation loss, and pay-out cost schedule on the basis of the middle range schedule, the supply plan and a predetermined purchase unit price. The first and second prediction data are output and displayed on a display means of the management decision support device. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a system that supports managerial decision making for mass sales and production of products.

  In the planning of medium-volume sales and production of products, as described in Non-Patent Document 1, a large-scale plan for the purpose of calculating the production level, inventory level, and labor force level is prepared, and based on the large-scale plan, A mid-schedule plan is drawn up for the purpose of finalizing product production by item and finalizing assumptions for man-hour planning and material requirements planning. Large schedules have a planning period of 6 months to a year and a half, a schedule unit of months to weeks, a schedule revision frequency of every month, and product categories by product group, while medium schedules have a planning period of 1 to 3 months, the unit of the schedule is seasonal to daily, the frequency of plan correction is monthly to seasonal, and the product category is by specification. Due to the difference in these attributes, the impact on the target project is greater for the large schedule, and the medium schedule is a plan that targets the large schedule. In that sense, the large schedule is planned and approved by the chief executive who oversees the business (hereinafter referred to as the manager), and the medium schedule is responsible for the sales and production of the business (hereinafter referred to as the manager). This person is called the sales and production manager). Both large schedule plans and medium schedule plans are planned for the planning period prior to the planning period, and are reviewed with a correction frequency.

  At the time of planning, the general manager makes a large schedule, and based on this, the sales and production manager makes a medium schedule. When reviewing a large schedule, there are material supply contracts (hereinafter referred to as supply constraints) that have already been arranged based on the medium schedule, and capacity restrictions (hereinafter referred to as capacity constraints) in employment contracts and equipment introduction plans. Because it becomes a problem, after reviewing the large schedule, the manager in charge of sales and production expands the large schedule into a medium schedule and confirms the feasibility of the large schedule within supply constraints and capacity constraints. If it is not feasible, repeat the review of the large schedule plan and medium schedule plan between the general manager and the sales / production manager.

"Introduction to Production Management I" by Takahiro Fujimoto, published by Nikkei Inc. (2001)

From the manager's point of view, there are the following problems in the conventional method of formulating a large schedule.
Problem 1: Large and medium schedules are inconsistent.
Problem 2: Information related to profit / loss judgments such as sales, costs, and profits is not taken into account when formulating large-scale plans (plans for production and sales).
Problem 3: There is no information on the balance of shelves that are at risk of being stored (hereinafter referred to as the remaining shelf).
Problem 4: Even if information on problems 2 and 3 is provided, the information is processed into a display format that is easy to determine, and there is no display means that enables quick determination.

  Each problem is described in detail below.

Regarding issue 1:
As mentioned above, in the large schedule, only plans for each product group are made. On the other hand, in the medium schedule plan, a plan that can be executed within the scope of supply constraints and capacity constraints is made for each product specification. Since the parent-child relationship of the specifications of the large schedule plan, product group, and medium schedule plan before the review and the relationship between the quantity of the large schedule plan and the medium schedule plan are not maintained,
When the large schedule is reviewed, the new large schedule and the medium schedule are inconsistent. Also,
Unless a large schedule is developed into a medium schedule, it cannot be compared with supply constraints and capacity constraints. At the time of planning a large schedule, it is not known whether the plan can be executed. For this reason, a large schedule plan is developed into a medium schedule plan using the relationship before the review, and when a medium schedule plan is not feasible compared to supply constraints and capacity constraints, a large schedule plan is not feasible for the first time. It turns out that it becomes. Furthermore, as a feasible medium schedule plan, in order to align with the large schedule plan, the work of the large schedule plan review and the medium schedule plan review must be repeated until it becomes feasible, and the consistency is maintained. It was difficult.

Regarding issue 2:
Previously, profit / loss judgment and sales / production planning were separated. this is,
If the gross profit (= selling price-standard cost) of each product is positive and sales enough to recover fixed costs are achieved, the higher sales are directly linked to profits, so the goal is to exceed the sales budget. Because it was. In other words, if the product is competitive and the number of sales and the gross margin that can always recover fixed costs can be secured, the production cost will be lowered as much as possible to focus on selling and producing the target sales volume. It was all right, so there was no need to consider profit or loss in sales and production. However, in a severe business situation where competition with competitors is intense and profit margins are low or fixed sales can only be recovered, fluctuations in sales volume have a large impact on profit and loss. In particular, when there are multiple product types, the profit rate for each product type is different, and the demand forecast accuracy for each product type varies greatly, the sales volume for each product type has a greater effect on profit and loss. In the severe business situation as described above, it has been difficult to make a precise profit / loss judgment with the conventional method.

Regarding issue 3:
If you sell as planned, you don't have to make inventory. After receiving the order,
Procurement, production, delivery (by customer lead time)
From now on, this period will be referred to as production lead time). In general, the production lead time is longer than the order lead time for medium and high volume products. Also, there is almost no selling as planned. However, in the conventional management decision-making, the budget is drawn up on the assumption that the target is achieved with the sales plan as the target. If a product is sold according to the sales plan, it is impossible for the stock to be generated as described above, so the stock has not been emphasized in the conventional management decision making. However, in a situation where competition with other companies is intense and the accuracy of demand forecasts is low, it is often possible that actual sales will not meet the sales plan. Also, if the product life cycle is shortened, the stock of the old product will not be sold completely, and there is a high possibility of loss due to low price sales or destruction. For this reason, when a higher sales plan is set, the remaining shelf risk when the sales plan is not achieved must be evaluated.

Regarding issue 4:
Indicators such as sales, cost, profit, and shelf remaining in problems 2 and 3 are related to each other. For example, profits usually increase as sales increase. An equation holds between sales, cost, and profit. As sales increase, the shelf space usually increases. The higher the cost, the higher the remaining shelf. For example, since each index has a relationship, even if these are provided individually, if they are individually displayed, it takes time to read the relationship. In other words, increasing the number of indicators to be displayed is necessary for decision making, but just displaying them normally slows down the decision making speed.

Therefore, in order to solve the above problems, in the present invention, in accordance with the review of the large schedule plan, while maintaining the relationship between the pre-review large schedule plan and the pre-review medium schedule plan, It is determined whether or not the schedule is within the limits of supply constraints and capacity constraints, and the feasibility of the large schedule is displayed on a device on which the manager makes a management decision. In addition, the review result of the medium schedule plan is displayed on the device where the manager makes a managerial decision immediately after developing the reverse schedule to the large schedule plan from the relationship between the pre-review large schedule plan and the pre-review medium schedule plan. To do. It also predicts the impact of actual demand fluctuations on the sales plan and provides it to the management's system as management judgment material.

In order to solve the above problems, the present invention calculates the forecast results of sales, cost and profit at the level of the large schedule (product category, planning period, schedule unit) based on the corresponding middle schedule. , These prediction results are displayed on a device on which the manager makes a management decision. In addition, profit and loss information (sales, profit, cost) based on the review result of the medium schedule plan based on the review of the large schedule plan is used to make a management decision graphically with a combination of indicators that managers can easily judge. Display on the device. At this time, in order to improve the cost prediction accuracy, it is necessary to predict the change in the payout unit price due to the change in the inventory forecast due to the review of the sales plan. In addition, it is necessary to be able to predict the impact on profit and loss when actual demand for the sales plan fluctuates.

Further, in order to solve the above-mentioned problems, the present invention immediately predicts the shelf remaining based on the medium schedule plan in accordance with the review of the large schedule plan, and displays it on a device on which the manager makes a management decision. To do. At this time, in order to improve the accuracy of the remaining shelf forecast amount, the fluctuation of the payout unit price due to the change in the stock forecast is predicted. It also predicts the impact on shelf racks when actual demand fluctuates with respect to the sales plan. In addition, in order to incorporate the improvement effect of internal processes into the forecast, the impact on the shelf remaining when the procurement lead time, production lead time, safety stock quantity, procurement lot size, production lot size, procurement frequency, and production frequency are improved. Predict.

In order to solve the above-mentioned problems, in the present invention, a new plan for a large schedule is made based on the past changes in indicators such as sales, cost, profit, and shelf remaining. At this time, a display method is provided so that the transition of these indices themselves and the transition of the relationship between the indices can be viewed at a time. For example, in accordance with the change in sales, the change in sales profit ratio, which is the relationship between sales and profit, is displayed at the same time.

In addition, regarding the update of large schedules, the current values of indicators such as sales, cost, profits, and remaining inventory, how far the current values are progressing with respect to the plans, and the achievement of budget based on future forecasts Provide a display method that allows you to view things at the same time. In addition, the present invention provides a display method that allows the user to view the relationship between each index at the same time for the current index value, current progress, and budget achievement prediction.

According to the embodiment of the present invention, it is possible to quickly communicate information between management decision-making layers, and use prediction results based on information on profit and loss and remaining inventory, so that management decisions of management are accurately and accurately supported. can do.

Hereinafter, an embodiment (first embodiment) of a management decision support system according to the present invention will be described in detail with reference to the drawings.

FIG. 1 is a diagram for explaining a device configuration and a flow of information between devices in a management decision support system according to an embodiment of the present invention. In FIG. 1, reference numeral 101 denotes a management decision support device that supports a manager to newly create a large schedule plan and to make changes according to progress. Reference numeral 102 denotes a distribution schedule and a product sales price schedule based on a large schedule plan 108 input by the manager of the sales / production plan manager.
8 is a profit / loss decision support device that outputs and displays whether or not execution of 8 (may be a revised large schedule plan 117) is possible, and 103 is a profit or loss that predicts whether or not the large schedule 108 (115 is transfer data) can be executed. This is a simulation device. Reference numeral 104 denotes a procurement plan drafting device for drafting a parts procurement plan 120 based on the medium schedule plan 124 output from the profit / loss simulation device 103. Reference numeral 106 denotes a remaining shelf target 108 (112 is a transfer). Data) and the remaining shelf prediction and evaluation loss data 121 output by the remaining shelf simulation apparatus 105, which will be described later.
A shelf plan / procurement plan support device for a procurement plan manager to correct a procurement plan draft,
Is a remaining shelf simulation device that performs a remaining shelf prediction and a prediction calculation of the evaluation loss 121 based on the medium schedule plan 124 and the procurement plan 120 (or the corrected procurement plan 113).

In this embodiment, 1 is input from the manager who is the highest decision maker of the business.
Management decision support device 1 for 08 large schedule plan, profit / loss target, sales target, and shelf remaining target
01 accepts. Then, the “profit / loss target and sales target” 111 is transferred to the profit / loss decision making support device 102, the remaining shelf target 112 is transferred to the remaining shelf / procurement plan support device 106, and the large schedule plan 115 is transferred to the profit / loss simulation device 103. The apparatus 103 and the remaining shelf simulation apparatus 105 are operated. By the calculation in this embodiment, the management decision support apparatus 101 receives 118 large schedule plans, correction plans, profit / loss forecasts, and sales forecasts from the profit / loss simulation apparatus 103, and 119 shelves from the shelf remaining simulation apparatus 105. By acquiring the remaining forecast and valuation loss and providing them to the manager together with 107 sales performance, production performance, and remaining shelf performance data,
Support managers' decision making. Here, data transmission / reception between each device is done in-house LA
It can be realized by communication means such as N (Local Area Network) or the Internet.

FIG. 2 shows in detail a sequence diagram that is the timing of information exchange between the devices.
This will be described according to the steps shown in the figure.

First, in S201, data of “profit / loss target” and “sales target” (111) is transmitted from the management decision support apparatus 101 to the profit / loss decision support apparatus 102. Also,
In S202, the management decision support device 101 to the shelf remaining / procurement plan support device 106
In addition, the data of “remaining shelf target” (112) is transmitted. In S 203, data of “large schedule plan” (115) is transmitted from the management decision support apparatus 101 to the profit / loss simulation apparatus 103. At this time, an activation instruction is transmitted from the management decision support apparatus 101 to the profit / loss decision determination support apparatus 102 and the shelf remaining / procurement plan support apparatus 106. The profit / loss decision-making support apparatus 102 that has received the start-up instruction receives input from the sales manager and production planning manager (large schedule plan, allocation rate 117 and product sales price schedule 110), and the profit / loss simulation apparatus 103 receives it. 122 transfers the large schedule plan, the distribution rate, and the product sales price schedule, and issues and transmits an activation instruction for the profit / loss simulation apparatus 103. Profit and loss simulation apparatus 10 upon receiving the start instruction
3, the procurement plan planning device 104 and the shelf remaining simulation device 105 are operated. Conversely, the remaining shelf / procurement plan support device 106 that has received an activation instruction from the management decision support device 101 replaces the remaining shelf simulation device 105 or the procurement plan planning device 104.
And the mechanism for starting the profit / loss simulation apparatus 103 "Management-Profit-
The launch of a “shelf-remaining system” can be realized.

In S204, the “large schedule plan” transferred from the management decision support apparatus 101
Based on the “allocation ratio” (the ratio of sales / production for each product specification of the medium schedule plan) transferred from the profit / loss decision support device 102 and the “product price schedule” for each product specification, The “plan” and “plan execution” are displayed on the profit / loss simulation apparatus 103
And is transmitted to the profit / loss decision-making support apparatus 102. In the prediction calculation in the profit and loss simulation apparatus 103, a large schedule plan, model configuration information 12
6 (FIG. 1), a large schedule plan expansion calculation is executed based on the distribution ratio to calculate a “medium schedule plan”, and then a plan execution availability calculation is executed using the requirement calculation master 127. A specific embodiment related to profit / loss decision making support will be described in detail in a second embodiment to be described later.

In S <b> 205, the profit / loss forecast / sales forecast / cost forecast and product sales price schedule taking into account the payout cost schedule 125 calculated in the third embodiment to be described later are calculated and transmitted to the profit / loss decision making support apparatus 102. The calculation information is combined with the model configuration information 126 and output to the display screen of the profit / loss decision-making support apparatus 102 in a tree structure as shown in FIG. Based on this display information, the manager in charge of sales / production planning calculates the initial “large schedule plan”, “distribution rate”, and “product sales price plan” numerical values for the profit and loss decision support device 1.
02 can be changed and corrected. In this embodiment, the “large schedule plan” and “distribution rate” are changed and corrected in the next S206, and the “product selling price schedule” is changed and corrected in S209. Can also be modified and changed at the same time (as S206). In this case, the calculation of profit / loss and sales forecast (S210) is executed at the same time as the calculation of S207 described later.

In step S <b> 206, in response to the input of the sales / production plan manager, the profit / loss decision support apparatus 102 transmits “large schedule plan” and “distribution rate” (corrected value) to the profit / loss simulation apparatus 103. In S <b> 207, based on information such as the revised large schedule plan, a large schedule plan expansion calculation and a plan execution possibility calculation are executed, and the calculation result is transmitted to the profit / loss decision making support apparatus 102.

In S208, similar to S205 described above, the profit / loss forecast / sales forecast / cost forecast and product sales price schedule are calculated based on the payout cost schedule 125 recalculated by the remaining shelf simulation of the third embodiment to be described later. The calculation result is transmitted to the profit / loss decision making support apparatus 102. Sales /
The manager in charge of production planning can change and modify the “product sales price schedule” in response to the result, and the correction data is transmitted to the profit / loss simulation apparatus 103 (S209).
. The profit / loss simulation apparatus 103 calculates “profit / loss forecast” and “sales forecast” based on the revised “product sales price schedule”, and transmits it to the profit / loss decision support apparatus 102 (S210).

On the other hand, in S211, the procurement plan planning device 104 executes the profit / loss simulation device 1.
In response to the medium schedule plan 124 calculated by 03, the procurement plan 120 is calculated. The procurement plan drafting device 104 transmits the drafted procurement plan draft to the remaining shelf / purchasing plan support device 106 and the remaining shelf simulation device 105 (S212, S).
213). The shelf-remaining simulation apparatus 105 also receives an input of “daily daily schedule plan” that is detailed on a daily basis (S214), executes the remaining shelf prediction calculation and the evaluation loss prediction calculation, and executes the execution result (remaining shelf prediction / Evaluation loss forecast 121) is used to store shelf / procurement plan support device 10
6 to send. When the shelf remaining / procurement plan manager corrects the procurement plan 120 in consideration of the remaining shelf prediction data and the evaluation loss prediction data 114 displayed on the display screen of the remaining shelf / procurement plan support apparatus 106, the corrected The procurement plan 113 is received and transmitted to the remaining shelf simulation device 105 (S216). If there is a change due to correction, the remaining shelf simulation calculation is executed again, and the calculated “remaining shelf prediction” “
The “evaluation loss prediction” data is transmitted to the remaining shelf / procurement plan support device 106 and the management decision support device 101 (S217, S218). The calculated “paid out cost schedule” data is transmitted to the profit / loss simulation apparatus 103 (S219). Then, the medium schedule data calculated by the recalculation of the profit and loss simulation considering the “paid out cost schedule” is received (S220), and the procurement plan planning device 104 again performs the procurement plan based on the changed medium schedule plan. Plan 120, S221, S22
2 to each device. Similar to the above steps, the procurement planning device 104
Calculates the daily schedule plan (S223), and the shelf-remaining simulation apparatus 105 executes the remaining shelf prediction calculation and the evaluation loss prediction calculation again (S224), and when the shelf remaining / procurement plan manager makes corrections. The procurement plan 113 is the remaining shelf simulation device 10
The remaining shelf simulation calculation is executed again. In this embodiment, since the “large schedule plan” and the “distribution rate” are changed and corrected (S206), the recalculation processing of S220 to S228 is performed, but only “product sales price schedule” is performed. Is corrected and changed, the recalculation process is not performed, and the process of S210 described above is performed.

The recalculated “shelf remaining prediction data” and “evaluation loss prediction data” are transmitted to the shelf remaining / procurement plan support apparatus 106 and the management decision support apparatus 101 (S226, S2).
27) The “paid out cost schedule” is transmitted to the profit / loss simulation apparatus 103 (
S228), used for profit / loss prediction calculation and sales prediction calculation. In S229, “Profit / Loss Forecast”, “Sales Forecast”, and “Executable Large Schedule Plan” are transmitted to the management decision support apparatus 101 and displayed on the display screen together with the information transmitted in S227. . With such a processing flow, the management decision support apparatus 101 can provide the manager with 109 large-scale schedule plans, feasibility, profit / loss prediction, sales prediction, shelf remaining prediction, and evaluation loss. By repeating the above, it becomes possible to provide support information for management decision making in real time, and it becomes possible to make a quick and accurate management decision.

Next, examples of information screens provided by the management decision support apparatus 101 will be described in detail with reference to FIGS.

FIG. 3 shows a screen transition of the management decision support apparatus 101. In brief,
First, from the initial state, the user logs in (301) and waits for a command (30
2). Two commands can be executed from the command waiting state. One is a result history display (303), and the other is a result prediction transition display (actual prediction display) (304).
Each display function has several optional functions. The result history display includes display item selection (305), display index selection (306), and target value setting screen (307).
With optional features. In actual guess display, display item selection (308), display index selection (309), target value review screen (310), large schedule plan change screen (311)
, The scenario review screen (312) has an optional function. Each function is connected in a relationship as shown in FIG. 3, and details will be described when each function is described.

First, the user inputs a user ID and password on the login screen (301) of the management decision support apparatus 101 and clicks the login button.
Only when the user is authenticated, the screen moves to the next command waiting screen (302).

On the command waiting screen (302), “result prediction transition display” “result history display” “
Waiting for any of the “Log Off” buttons to be clicked. When the result history display is clicked, the result history display is displayed (303). When the result prediction transition display is clicked, the display moves to the result prediction transition display (304).

FIG. 4 shows an example of a history record display screen. In FIG. 4, the screen display is divided into four, three of which are marginal profit (profit) transition, profitability transition and inventory transition from the past, and the remaining one is the product model (F30, F310). , F330) shows an example of displaying data. These displays are executed based on information stored in the database 107 of “sales record”, “production record”, and “shelf remaining record” shown in FIG. The product group that is the product category of the large schedule is not limited to the above-described product model (F330, etc.), but, for example, the product form (CT: client, PS: PC server, US: higher group than the product model). UNIX (R) server) product group. These relationships are related by a tree structure as shown in FIG. 37, and an arbitrary group level can be selected according to the intention of the manager.

First, in the marginal profit trend graph, a pasted bar graph with the horizontal axis as the period, the vertical axis as sales by product model and variable costs, and a trend graph with the marginal profit as the vertical axis are displayed. Sales and variable costs in the past period are filled in, and marginal profit is shown in solid lines. For the current period (01 / Lower (October to March)), the beginning budget sales and the beginning budget fluctuation costs are translucent, and the beginning budget marginal profit is indicated by a dotted line.

In the profitability graph, the horizontal axis represents sales for each period and the vertical axis represents marginal profit for each period. For each product model, sales and marginal profit in the past period are displayed in solid lines, and this term (01 / below (October-3)
The initial budget sales and the marginal profit at the beginning of the month are displayed with a semi-transparent line, and the order of the time series information is indicated by “arrows”. In this way, by displaying the transition graph with the relationship between “marginal profit” and “sales”, it is possible to simultaneously grasp the trends of the two management judgment indexes. In addition, the display form according to the present embodiment makes it possible to instantly grasp the relationship (profitability) between the two indicators of the marginal profit transition (growth or decline) to the sales trend (growth or decline). When setting “profit / loss target” and “sales target”, both target values or both target value ranges can be determined simultaneously. Still further, for example, in FIG. 4, the profitability of the product model F330 is high (in terms of the ratio to sales) and the rate of growth is high. A management policy that positions the product model F330 as a priority product model can be easily planned. As described above, according to the management decision support device 101 of the present embodiment, the management depends on whether to take a profit increase policy, a sales increase policy, or a policy to increase both. It is possible to support quick and accurate management target planning (understanding key product models, sales targets, profit / loss targets, etc.) according to the policy of the company.

For the inventory graph, the horizontal axis represents sales for each period, and the vertical axis represents inventory values for each period. For each product model, the stock price in the past period is displayed as a solid line, the initial budget stock value for the current period (01 / bottom) is displayed as a semi-transparent line, and the time series information is shown in the order by "arrows". ing. By displaying the transition graph with the relationship between “sales” and “inventory amount” in this way, it is possible to simultaneously grasp the two management judgment indexes as in the case of the previous profitability. In addition, when the stock amount is large compared to sales, it is possible to easily formulate a management policy that positions the product model as a priority product, and the management's Can provide support quickly and accurately.

As shown in the upper left part of FIG. 4, the option history display screen 303 has three optional functions. Display item selection 305, display index selection 306, target value setting 307 3
One. When each button is clicked, it moves to the corresponding screen. The display item selection 305 will be described in detail with reference to FIG. 5, the display index selection 306 with reference to FIG. 6, and the target value setting 307 with reference to FIG. Results history display screen 3
There are two other buttons on the 03 screen. A button for displaying the predicted transition of results and a logoff button. Clicking on the predicted result transition display button moves to the predicted result transition display 304. Details will be described later. Click the logoff button to move to the login screen 301.

FIG. 5 is a display item selection screen for the history record display 303. The period for displaying the graph on the horizontal axis and the product model to be displayed on the vertical axis are displayed and can be selected with a check box. First, when this screen is displayed, the graph display status at that time is displayed. For example, if the past three periods are displayed, it is displayed as if the check boxes for the three periods are checked. Checked lines, both vertically and horizontally,
The color of the row intersection changes. If OK is clicked, the graph is changed to the combination currently checked.

FIG. 6 is a display index selection screen for the performance history display 303. Either “4-division display” or “non-division display” can be selected with a radio button. The display contents of each part can be selected from a pull-down menu corresponding to the graph arrangement position. The choices are “marginal profit trend”, “profitability”, and “inventory”. When “4-segment display” is clicked, four pull-down menus are displayed. When “No division display” is clicked, the pull-down menu is set to one. At this time, the upper left choice is carried over.
When OK is clicked, the graph is changed to the combination checked at that time, and displayed on the actual result display screen 303. If the cancel button is clicked, the original history display screen 303 is returned to without changing anything.

FIG. 7 is a target value setting screen of the result history display 303. The target item and its details are displayed on the vertical axis, and the period is displayed on the horizontal axis. In this example, the target items are sales, marginal profit,
Variable costs and inventory amounts. Each target value is divided according to product type as a detail. 01 / below is the target period, and the other period is the past period or the present period. Enter the target value that corresponds to the target period for each detail. When the OK button is clicked, the value written in the plan target period column is fetched, set as the target value, and the actual result display is returned. If the Cancel button is clicked, all inputs are ignored and the history display is displayed. In the present embodiment, the method has been described in which the manager directly inputs a numerical value on the target value setting screen. However, the result history display screen 303 in FIG.
In the graph, the target value can be input by clicking or fine-tuning the position on the graph. For example, in the profitability graph of FIG. 4, when a target product model is designated and a target position is clicked, a “sales target” and a “profit / loss (marginal profit) target” can be set simultaneously. In this case, if the numerical values of “sales” and “profit / loss (marginal profit)” corresponding to the position of the pointer on the graph are displayed, the manager can further easily set the target value.

Target value setting screen shown in FIG. 7 (display screen of management decision support apparatus 101)
When the manager presses the OK button after setting various target values, profit / loss / sales /
The target value data related to the remaining shelf is transmitted to the profit / loss decision making support device 102, the profit / loss simulation device 103, and the remaining shelf / procurement plan support device 106. And FIG.
The information described in “Available large schedule plan, correction plan, profit / loss forecast, sales forecast, inventory prediction, loss on valuation” (118, 119) is calculated. After being transmitted to 101, it is edited and processed into graph data by a method described later and output and displayed on the display screen (actual predicted transition display 304
).

FIG. 8 shows a result prediction transition display (actual prediction display screen) 304. In the actual guess display 304, a plurality of management indexes such as “sales”, “performance”, “profitability”, and “inventory” based on the scenario 1 can be browsed at a time. The solid line graphs are actual predictions of the past period and current period (01 / above (April to September)) before the present, and “sales record, production record, remaining shelf record” stored in the database 107 are shown. Graph data is generated based on the result data. In addition, the dotted line graph is the forecast transition display for the current period (01 / above (April to September)) from now on. “Profit / Loss Forecast”, “Sales Forecast”, “Shelves Forecast”
Graph data is generated based on prediction data such as “valuation loss prediction”. here,
Scenarios include “large schedule plan draft (new plan after correction)” and “correction plan (executable medium schedule plan)” output by profit / loss simulation apparatus 103, sales / production plan manager or remaining inventory / procurement This is forecast data determined by the combination of “demand cases (demand forecast data)” selected by the general manager in charge of the plan. As shown in FIG. 14, the number of executable large-scale schedule plans and the number of executable corrected plan plans The number of combinations (two in FIG. 14) and the number of demand prediction cases (three in FIG. 14) are prepared in the stage of S229.

Among these indicators, stock indicators such as sales, sales volume, and profit are displayed cumulatively. By evaluating cumulatively, it is possible to easily grasp the progress toward the target at the end of the term. In the profitability graph of FIG. 8, an index of sales is taken on the X axis instead of time, and an index such as the number of units sold is taken on the X axis in the graph of the market condition index, which is not shown. As a result, it is possible to simultaneously grasp the change in the unit sales price due to the change rate of the number of units and the sales and the change in the profit rate due to the change rate of the sales and the profit with a small screen. In addition, the result database 10 is selected by selecting “overlay”.
7 is displayed superimposed with the data of the same period in the past. This makes it possible to easily evaluate the current progress. Further, future predicted values represented by dotted lines are calculated in cooperation with the profit / loss simulation apparatus 103 and the shelf remaining simulation apparatus 105 shown in FIG. The predicted values are calculated based on scenarios (a large schedule plan, a correction plan (medium schedule plan), and a demand case) that are the basis of prediction, and FIG. 8 shows a prediction graph based on scenario 1. When a prediction graph is displayed based on each of a plurality of scenarios, it is shown as in FIG. 15 (scenarios 1 to 3). The large schedule plan may be a large schedule plan (new plan) initially entered by the manager, but if a modification is changed in the simulation process of FIG. 2, the revised large schedule plan is a scenario. It will be used as an element. Here, the “new plan” in FIG. 8 is a case where a medium schedule plan is created by the large schedule plan expansion function with the initial large schedule plan value created by the manager in the large schedule plan editing shown in FIG. 13 as a constraint. Is a cumulative graph display (monthly) of the management index of, and the "correction plan" is a sales / production plan by the profit / loss decision support device with reference to the medium schedule plan value developed from the large schedule by the profit / loss simulation apparatus 103 This is a cumulative graph display (monthly) of management indicators based on the medium schedule plan created (corrected / changed) by the general manager.

The manager displays the result prediction transition display 304 displayed on the management decision support apparatus 101.
The management index can be further reviewed with reference to the above information, and the support method in that case will be described in detail below.

The actual predicted transition display 304 has five optional functions. Display item selection 3
08, display index selection 309, target value review 310, large schedule plan edit 311, scenario review 312. When each button is clicked as shown on the left side of the screen in FIG. 8, the screen moves to the corresponding screen. 9 for the display item selection 308, FIG. 10 for the display index selection 309, FIG. 12 for the target value review 310, FIG. 13 for the large schedule plan edit 311, and FIG. 14 for the scenario review 312.

FIG. 9 shows a display item selection screen 308 for actual guess display. The period for displaying the graph on the horizontal axis and the product model to be displayed on the vertical axis are displayed and can be selected with a check box. First, when this dialog is displayed, the current graph display status is displayed. For example, if the past three periods are displayed, it is displayed as if the check boxes for the three periods are checked. The color of the intersection of the checked row and column changes vertically and horizontally. If OK is clicked, the graph is changed to the combination currently checked.

FIG. 10 shows a display index selection screen 309 for actual estimation display. "Quarter display" or "
One of “display without division” can be selected with a radio button. The display contents of each part can be selected from a pull-down menu corresponding to the graph arrangement position. Options include “sales”, “performance”, “profitability”, “valuation loss”, “inventory”, and the like. Here, the former four are selected. When “4-segment display” is clicked, four pull-down menus are displayed. When “No division display” is clicked, the pull-down menu is set to one. At this time, the upper left choice is carried over. If OK is clicked, the graph is changed to the combination checked at that time, and the screen returns to the actual guess display screen 304. If the cancel button is clicked, the actual display screen 304 is displayed without changing anything.
Return to.

FIG. 11 shows an example in which the lower right graph is changed from inventory to valuation loss using the screen of FIG.

FIG. 12 shows a target value review screen 310 for actual estimation display. The target item and its details are displayed on the vertical axis, and the period is displayed on the horizontal axis. In this example, the target items are sales, marginal profit, variable cost, and inventory amount. Each target value is divided according to product type as a detail. In this example, 01 / below is the current period and the other period is the past period. Enter the target value in the 01 / down review column, which is the current period for each detail. When the OK button is clicked, the value written in the 01 / down review column is taken in, set as the target value, and the actual display returns. If the Cancel button is clicked, all inputs are ignored and the actual display is returned. Target value for review (large schedule plan, profit / loss, shelf remaining,
The target value such as sales) is developed by the method described in FIG. 2, and a new large schedule plan, correction plan, and various predicted values that are calculated and determined through correction by the manager in charge,
It transmits to the management decision support apparatus 101.

FIG. 13 shows a large schedule plan edit screen 311 of actual estimation display. On this screen, the horizontal axis indicates the product model, and the vertical axis indicates the time period in units of time buckets for the large schedule. The current large schedule (old) is displayed in this matrix, and the new large schedule is written in the "new" column based on this. As will be described later, each time a large schedule is newly created, a scenario that is a combination of a plan value and an assumed value of a parameter (medium schedule plan or demand case) is newly generated. Individual scenarios are distinguished by scenario numbers. This scenario number is displayed at the upper right of the actual guess display screen of FIG.

FIG. 14 is a scenario review screen 312. As described above, the scenario is a combination of demand cases assuming that the actual demand is different from the large schedule, the corrected plan corrected based on the large schedule, and the demand forecast. The actual reasoning display that has been described so far is only for one of these scenarios. This screen allows you to evaluate multiple scenarios simultaneously. In the tabular form, each item is selected, scenario number, large schedule plan number, correction plan number, demand case number, cumulative sales, cumulative unit sales, cumulative marginal profit, inventory amount, and valuation loss. The selection is a mark indicating the current scenario displayed in the actual display. By clicking on each column in this column, it is possible to select a scenario for actual display and to select a large schedule plan itself. The scenario number is a number for identifying a scenario. A new scenario is created when a new large schedule is created, when a new compensation plan is created, or when a new demand case is applied to a combination of a large schedule and compensation plan And
A new number is given. The large schedule plan number is a number for identifying the large schedule plan. The large schedule plan number is a hyperlink, and the large schedule plan edit screen 31
Linked to 1. When a large schedule number is clicked, the large schedule plan with that number is displayed on the edit screen. The correction plan number is the same as the large schedule number. The difference is that the screen to which the user moves from the hyperlink of the number display does not have the plan editing function but only the browsing function. This is because the correction plan editing is not a function of the management decision support device, but a function of the profit and loss decision support device. A hyperlink exists here for browsing the correction plan edited by the profit / loss decision support apparatus. The demand case is the same as the correction plan. There are hyperlinks in the item names and values of cumulative sales, cumulative unit sales, cumulative marginal profit, inventory value, and valuation loss. This is a hyperlink for displaying changes over time. Details of this will be described with reference to FIG. In this way, the scenario review screen 312 can facilitate management decision making by making it possible to list differences in evaluation values for each scenario.

FIG. 15 is a cumulative sales scenario comparison screen. FIG. 14 shows an example when the item name of accumulated sales is clicked. FIG. 15 is a graph of changes in cumulative sales for each scenario. Here, if you select the large schedule plan number from the large schedule plan pull-down at the bottom of the screen and the correction plan (medium schedule plan) number from the correction plan (medium schedule plan) pull-down, the selected large schedule plan will be used. The accumulated sales for each demand case of the medium schedule plan corrected in is displayed. The same applies to other evaluation items.

Next, details of processing of the management decision support apparatus 101 will be described with reference to FIGS. 16 to 28. First, a functional configuration of the management decision support apparatus 101 and a protocol for exchanging information between functions will be described with reference to FIG.

Reference numeral 1601 denotes a result totaling function. Reference numeral 1602 denotes screen data. Reference numeral 1603 denotes a graph data generation function. Reference numeral 1604 denotes graph data. Reference numeral 1605 denotes a screen display function. Reference numeral 1606 denotes a user input reception function. Reference numeral 1607 denotes various target values set by the manager.

The result totaling function 1601 is “sales results, production results,
This is a function of totaling the “shelf remaining record” 107 in the total unit period (for example, month, week, etc.) and outputting the value to the screen data 1602. The graph data generation function 1603 uses the screen data 1602 to generate graph data 1604 that is point sequence data to be plotted on the graph. The graph data generation function 1603 extracts the inflection point of the graph data and writes the attribute to the graph data 1604. The screen display function 1605 displays the screens shown in FIGS. 3 to 17 on the screen from the graph data 1604 and the profit / loss target, the sales target, the remaining shelf target, and the valuation loss target.
The user input acceptance function 1606 is a function for changing the large schedule plan and the profit / loss target, the sales target, the remaining shelf target, and the valuation loss target.

The details of the sales record, production record, and shelf remaining record of the database 107 will be described with reference to FIGS. FIG. 17 and FIG. 18 show details of sales results in the database 107. The sales record is composed of the sales record of FIG. 17 and the profit / loss record of FIG. As shown in FIG. 17, the sales results are shown in units of sales, date of occurrence, product (product specification), channel (corresponding to the node of the tree structure shown in FIG. 37), sales price (unit price),
Consists of number of units and sales. Here, the product (product specification) is one of the product models (PC product lineup), and is identified by the name of the CPU, which is a feature of the product (PC) in this embodiment. As shown in FIG. 18, the profit and loss results are calculated in the unit calculated by the unit period (month, week or day), and the product (product specification).
, Channel, sales, cost, profit. FIG. 19 shows details of production results. As shown in FIG. 19, production results are data accumulated for each production lot, and are composed of the date of recording, product (product specification), number of units, cost, total cost of payout, and total cost of purchase. Is done. FIG. 20 shows the details of the remaining shelf record. As shown in FIG. 20, the shelf remaining results are tabulated on a tabulation date and product basis.

FIG. 21 to FIG. 25 show details of a large schedule plan, profit / loss target, sales target, remaining shelf target, and valuation loss target, which are data edited by the user input reception function 1606.

FIG. 21 shows an example of a large schedule plan. The large schedule plan is composed of a plan number, a plan target period (for example, April 1 to April 31, 2001), a product model, a channel, and the number of units. Here, the target period for planning is one month, but the total period can be six months. The plan number is information for distinguishing a plurality of plans in the form of “new” and “correction”.

FIG. 22 shows an example of the profit / loss target. The profit / loss target consists of target period, product model, channel, and profit. FIG. 23 shows the sales target. The sales target consists of target period, product model, channel, and sales. FIG. 24 shows the remaining shelf target. The remaining shelf target consists of the target period, product type, and remaining shelf price.

The details of 118 sales forecast and profit / loss forecast and 119 shelf remaining forecast and valuation loss forecast will be described with reference to FIGS. FIG. 25 shows the details of the sales forecast. As shown in FIG. 25, the sales forecast includes a forecast category (scenario number), a forecast target date, and a product (product specification).
, Channel, sales price, number of units, sales. The prediction category is data representing a scenario for prediction, and is used for distinguishing the above-mentioned large schedule plan (new plan) from the large schedule plan based on the corrected medium schedule plan. The prediction target date indicates which point in the future is predicted. FIG. 26 shows details of the profit / loss prediction. The profit and loss forecast is
As shown in FIG. 26, it is composed of a prediction category, a prediction target date, a product (product specification), a channel, sales, cost, and profit. FIG. 27 shows the details of the remaining shelf prediction. As shown in FIG. 27, the remaining shelf prediction includes a prediction category, a prediction target date, a product (product specification), and a remaining shelf price. FIG. 28 shows details of the evaluation loss prediction. As shown in FIG. 28, the evaluation loss prediction includes a prediction category, a prediction target date, a product (product specification), and a remaining shelf price.

As described above, in the present embodiment, the management decision support apparatus 101 is configured as shown in FIG. 16 so that useful indicators for management decision making can be displayed in a graph. By linking with the profit / loss simulation apparatus 103 and the shelf-remaining simulation apparatus 105, it is possible to provide a management index quickly and accurately to the manager.

In the above embodiment, the management decision support device 101, the profit / loss decision support device 102, the profit / loss simulation device 103, the procurement plan planning device 104, the shelf remaining simulation device 105, and the shelf remaining / procurement plan support device 106 are within the same company. However, the present invention is not limited to this case, and may be a cooperation system with other companies. For example, the management decision support device 101 is a system owned by company A, and the other device groups are owned by the contract manufacturing company B and the logistics management company C, and they exchange management information through the network. Decision support can be realized. The present invention also includes a management decision support device 101 and a profit / loss decision support device 10.
2 and the shelf remaining / procurement plan support device 106 are owned by the same company or a plurality of companies, and the profit / loss simulation device 103, the procurement plan planning device 104, and the shelf remaining simulation device 105 are connected to a simulation service providing company D (ASP: Application Server).
vice Provider). In this case, the company
The management decision support service can be provided (simulation service provided) simply by holding the hardware that operates the UI function, and the ASP side can receive a price for the service.

  Next, a second embodiment of the present invention will be described.

Embodiments of a profit / loss decision making support system according to the present invention will be described below in detail with reference to the drawings.

FIG. 29 is a diagram illustrating the relationship between various types of information and devices in the profit / loss decision making support system according to the present embodiment. 29, the same parts as those in FIG. 1 are denoted by the same notation, and the same parts are subdivided with symbols again.

2907 is profit / loss target information, 2908 is sales target information, 2909 is large schedule plan information output by the profit / loss simulation apparatus 103, 2910 is medium schedule plan information, 2911 is allocation rate information, 2912 is plan execution possibility information, and 2913 profit / loss ·Sales·
Cost information, 2914 is a product selling price schedule (partition rate, price) information, 2915 is a large schedule plan information modified by the sales / production plan manager, 2916 is allocation rate information, 29
17 product sales price schedule (partition rate, price) information, 2922 is large schedule plan information output by the profit / loss simulation apparatus 103 to the management decision support apparatus 101, 2923 is profit / loss forecast information, and 2924 is sales forecast information.

As shown in FIG. 29, the profit and loss decision support system according to this embodiment includes a management decision support apparatus 101 that generates various management indexes and a large schedule plan, and a large schedule plan generated by the management decision support apparatus 101. Develop plan 115 into a medium schedule plan,
The profit / loss simulation apparatus 103 for calculating / holding the profit / loss information, and the information held by the sales / production simulator 103 and the profit / loss target and the sales target provided by the management decision support apparatus 101 are referred to. The profit / loss decision support apparatus 103 is configured to change various types of information.

At that time, the procurement plan 120 (based on the developed medium schedule 124)
1), a shelf plan simulation device 1 having a function of calculating a payout cost schedule from the medium schedule plan 124 and the procurement plan 120.
By using 05, the payout cost schedule used in the profit / loss simulation apparatus 103 is dynamically calculated.

The profit and loss decision support device 102 that provides various information can be accessed by each decision maker, and the Web, browser, etc. can be used so that the stored information can be taken into the terminal of each decision support side. It is configured as a used device.

  The profit and loss decision support system will be described with reference to the sequence diagram of FIG.

FIG. 30 is a sequence diagram illustrating processing and information exchange between the devices illustrated in FIG. 29 in time series, and is common to the sequence diagram of FIG. 2 described in the first embodiment. In FIG. 30, S204 of FIG.
It differs from the feasibility check process 3003 in that S207 is refined into a large schedule plan development process 3008 and an feasibility check process 3009.

First, a new large-scale schedule 115 prepared by the management decision support apparatus 101 is provided and held in the profit / loss simulation apparatus 103. At the same time, profit / loss target 29
07 and the sales target 2908 are provided and held in the profit and loss decision support apparatus 102.

The profit and loss simulation apparatus 103 that has received the new large schedule 115 is:
First, a new large schedule plan is developed by the large schedule plan development function 3002 to create a new medium schedule plan (124, 2910).

Thereafter, the feasibility check function 3003 checks whether or not the new medium schedule plan can be executed. The created plan execution availability information 2912, the new large schedule plan 2909, the medium schedule plan 2910, and the distribution rate 2911 are transferred and held in the profit and loss decision support apparatus.

At the same time, the new medium schedule plan 124 is transferred to the procurement plan planning device 104.
In the procurement plan planning device 104, a new procurement plan is created based on the new medium schedule plan 124 by the procurement plan planning function 3004. The drafted new procurement plan is transferred to the shelf-remaining simulation apparatus 105, and the payout cost plan 125 at the middle schedule plan level is calculated by the payout cost calculation function 3005. The calculated payout cost schedule 125 is provided to the profit / loss simulation apparatus 103.

The profit / loss simulation apparatus 103 that has received the payout cost 125 performs profit / loss calculation by the profit / loss calculation function 3006 based on the new medium schedule plan, the payout cost, and the product selling price schedule, and obtains the “profit / loss information and payout cost” obtained as a result. 2913 and product sales price schedule 2914 are provided to the profit and loss decision support apparatus 102.

The profit / loss decision-making support apparatus that has received the profit / loss / sales information receives the plan execution availability information 2912 received in advance, the new large schedule plan 2909, and the medium schedule plan 291.
These pieces of information are displayed on the screen using 0, the distribution rate 2911, and the model configuration information 126 represented by a tree structure. An example of the display screen is shown in FIG.

  These values can be changed using the “large schedule plan change function and distribution rate change function” 3007 of the profit and loss decision support apparatus 102. The corrected large schedule plan 2915 and the distribution ratio 2916 are transferred to the profit / loss simulation apparatus, and the expansion / executability check is performed again by the large schedule plan expansion function 3008 and the feasibility check function 3009.

Created plan execution availability information 2912 and the revised large schedule plan 2909.
The medium schedule plan 2910 and the distribution rate 2911 are transferred and held in the profit / loss decision making support apparatus 102.

At the same time, the corrected medium schedule plan 124 is transferred to the procurement plan planning apparatus 104. In the procurement plan planning device 104, a new procurement plan is created based on the corrected medium schedule plan 124 by the procurement plan planning function 3010. The corrected procurement plan draft that has been drafted is transferred to the shelf-remaining simulation apparatus 105 and the paid-out cost calculation function 30
11, the payout cost schedule 125 at the medium schedule level is calculated again.

  The calculated payout cost is provided to the profit / loss simulation apparatus 103 again.

The profit / loss simulation apparatus 103 that has received the paid-out cost calculates the profit / loss again by the profit / loss calculating function 3012 based on the corrected medium schedule plan, the paid-out cost, and the product selling price schedule. The “paid out cost” 2913 and the product sales price schedule 2914 are provided to the profit / loss decision making support apparatus 102.

Further, the product selling price schedule change function 3013 on the profit / loss decision making support apparatus can be used to change the product selling price schedule. In this case, the revised product selling price schedule 3
017 is transferred to the profit / loss simulation apparatus 103, and profit / loss is calculated by the profit / loss calculation function 3014 of the profit / loss simulation apparatus 103, and the result is transferred again to the profit / loss decision making support apparatus 102 and displayed on the screen by the display function. Here, in FIG. 30, the “large schedule plan change function and distribution rate change function” 3007 and the “product sales price schedule change function” 3013 are described separately, but this is for convenience because the processing after the change is different. It is only described separately, and may be summarized as one change function.

When such a simulation is performed several times and a large-scale plan plan that can be executed so as to satisfy the sales / production manager is created, the profit / loss decision-making support apparatus 102 is terminated (3015). 2923, sales forecast information 292
4. The corrected large schedule plan 2922 is transferred to the management decision support apparatus 101,
A series of processing ends.

In this embodiment, in order to perform a simulation when the plan and the actual result deviate due to uncertain factors such as fluctuations in demand, a large schedule plan / corrected plan number set for each scenario on the profit / loss decision support device It is possible to calculate a plurality of solutions using the demand case number and provide them to the manager.

FIG. 31 illustrates the functional configuration and input / output information of the profit / loss simulation apparatus 103 in detail.

The profit / loss simulation apparatus 103 includes a large schedule plan development function 3101, an feasibility check function 3102, and a profit / loss calculation function 3103. The profit / loss simulation apparatus 103 uses, as input information, a large schedule plan, model configuration information, distribution rate, requirement calculation master, product sales price schedule (partition rate, price), and payout cost schedule shown in the upper and left sides of FIG. Large schedule plan, middle schedule plan, allocation rate, plan execution availability, profit / loss, sales, cost information, product selling price schedule (partition rate,
Price) as output information.

The large schedule plan development function 3101 includes a large schedule plan that is a plan value having a plan category, a target period (monthly), a model, a channel, and the number of units as shown in FIG. 42. Model configuration information 126 having a configuration ID, parent component information, and child component information, and necessary for creating a product tree, as shown in FIG. 42, a plan category, a target period (monthly), and a configuration The distribution rate information that has the ID and the distribution rate and provides the distribution rate to be used at the time of deployment is input, and as shown in FIG. 43, it has the plan classification, the target period (monthly), the product name (part name), and the number of units. The medium schedule plan, which is the detailed level plan value, the large schedule plan, which has the same format as the input information, and the allocation rate are output. The large schedule plan development function is calculated according to the procedure described later with reference to FIG.

The feasibility check function 3102 receives the requirement calculation master 127, which is master information necessary for calculating the requirement, and the medium schedule plan, which is output information of the large schedule development function, as shown in FIG. The plan execution availability information having the plan classification, the planning target period, the product name, and the execution availability information is output. The feasibility check function
Calculation is performed according to a procedure described later with reference to FIG.

The profit / loss calculation function 3103 has a plan for selling a product (planned partition rate) having a plan category, a plan target period, channel information, and a partition rate as shown in FIG.
Product price plan with plan target period, product and standard price information, and large schedule plan deployment function 3
The large schedule plan, model configuration information, and distribution rate output in 101 are input, and the profit / loss / sales with plan classification, plan target period, configuration ID, profit / loss information, sales information, and cost information as shown in FIG.・ Output cost information. The profit / loss calculation function is calculated according to the procedure described later with reference to FIG.

Here, with reference to the flow shown in FIG. 32, the calculation procedure performed by the large schedule plan development function will be described.

In step 3201, based on the model configuration information 126, the large schedule plan is developed according to the distribution rate, and the medium schedule plan is calculated.

In step 3202, a large-scale schedule plan at the product model level such as F330 is accumulated and calculated in the upper hierarchy based on the model configuration information. By the accumulation calculation, for example, the total sales of F30, F310, and F330 can be calculated, and the profit / loss calculation of the higher product form level (DT: desktop) can be performed (see FIG. 37).

  In step 3203, the development target period is shifted backward by one period.

In step 3204, it is checked whether or not the calculation target period is not a calculation target. If the calculation target period is not a calculation target, the process returns to step 3201 to continue the process.

Next, a calculation procedure performed by the feasibility check function will be described with reference to the flow shown in FIG.

In step 3301, the member requirement is calculated from the medium schedule plan by using a known method for calculating the required procurement amount considering the ordering unit from the component requirement.

In Step 3302, the required amount of the member developed in Step 3301 is compared with the supply constraint and the capability constraint. If the required amount is less than the constraint in Step 3303, the process proceeds to Step 3905. If the requirement> constraint, an NG flag is set in the execution availability column of the plan execution availability information in step 3304, and the process proceeds to step 3305.

  Step 3305: Shift the middle schedule plan to be expanded one step backward.

In step 3306, it is checked whether there is an uncalculated medium schedule plan. If there is an uncalculated medium schedule plan, the process returns to step 3301, and if not, the constraint check expansion process is terminated.

Next, the calculation procedure performed by the profit / loss calculation function will be described with reference to the flow shown in FIG.

In step 3401, the product price schedule information is multiplied by the partition rate to calculate selling price information for each product. At this time, the channel information of the tree including the target product is specified from the model configuration information, and the partition value set for the channel is used.

In step 3402, the selling price calculated in step 3401 is multiplied by the number of the middle schedule plan to calculate the total selling price at the middle schedule plan level.

In step 3403, the payout cost schedule provided from the remaining shelf simulation apparatus is multiplied by the number of medium schedules to calculate the total cost at the medium schedule level.

In Step 3404, the amount of the total cost calculated in Step 3403 is subtracted from the total selling price calculated in Step 3402 to calculate the profit / loss at the middle schedule plan level.

In step 3405, the profit / loss information at the medium schedule level calculated in step 3404 is calculated up to the upper hierarchy, and the profit / loss information in the entire model configuration tree is calculated.

  In step 3406, the expansion target period is shifted backward by one period.

In step 3407, it is checked whether or not the calculation target period is not a calculation target. If the calculation target period is not a calculation target, the process returns to step 3401 and if not, the profit / loss planning process is terminated.

FIG. 35 is a diagram for explaining functions provided by the profit / loss decision making support apparatus.
The profit / loss decision support apparatus 102 includes a sales target provided from the management decision support apparatus 101, a sales target display function 3501 for displaying the profit / loss target on the screen, a profit / loss target display function 3502, and a profit / loss provided from the profit / loss simulation apparatus.・ Sales / cost, large schedule plan, model configuration information, medium schedule plan, allocation rate, plan execution availability, product sales price schedule (partition rate / price) on the screen Profit / loss / sales / cost display function 350
3, large schedule plan display function 3504, model configuration display function 3505, medium schedule plan display function 3506, distribution rate display function 3507, plan execution availability display function 3508, product sales price schedule display function 3509, large schedule plan draft, allocation rate , A large schedule plan changing function 3510 for changing the product selling price schedule on the screen, an allocation rate changing function 3511, and a product selling price schedule changing function 3512.

Display examples of user interface screens for realizing each function are shown in FIGS. 37 to 39, and transitions of the screens are shown in FIG.

FIG. 36 is a diagram for explaining the transition of the screen displayed on the terminal of the sales / production manager in charge after accessing the profit and loss decision support apparatus 102.

As shown in FIG. 36, by selecting activation of the profit / loss decision making support apparatus from the main menu by clicking the mouse or the like, the profit / loss decision support apparatus shown in FIG. 37 has a configuration tree screen (hereinafter referred to as a configuration tree screen). Transition. Various information can be displayed and changed on the configuration tree screen, and the information is changed. The information is immediately passed to the profit and loss simulation apparatus 103, and the recalculated result is passed to the profit and loss decision support apparatus 102 to display a new value.

Further, by selecting any of the constituent elements on the configuration tree screen by, for example, right-clicking the mouse, it is possible to transit to the distribution rate change screen as shown in FIG.

Furthermore, it is possible to transition to a detailed information display screen as shown in FIG. 39 by selecting any of the constituent elements on the configuration tree screen with, for example, a left click of the mouse.

The operation of the sales / production manager in charge of the screen displayed on the sales / production manager will be briefly described below.

FIG. 37 is a diagram showing a display example of the configuration tree screen. In the configuration tree screen,
First, a period to be displayed is selected from the target period selection field 3701. When a period is selected, various information for that period is displayed.

On the configuration tree screen, a large schedule plan, medium schedule plan, product price plan, distribution rate, plan execution availability provided from the profit / loss simulation apparatus 103, and sales target and profit / loss target provided from the management decision support apparatus 101 are displayed. Further, by using the model configuration information 126, various information can be displayed in the area 3702 according to the tree configuration from the highest hierarchy to the lowest hierarchy.
In addition, on the tree view screen, an information display field 3704 capable of displaying several pieces of information regarding each component 3703 is prepared. In this field, the number of units, allocation rate, price, partition rate, profit / loss It is possible to display an arbitrary value selected by the user from the information held by the profit / loss decision making support apparatus 102 such as cost, plan execution possibility, and the like.

Furthermore, of the information displayed in this information display column, for the information on the large schedule plan, allocation rate, and product sales price schedule (partition rate schedule), place the cursor in this display field and enter the value you want to change. Thus, information change processing is possible.

FIG. 38 is a diagram showing a display example of the distribution rate change screen. In the column 3801, sibling component information associated with a parent component is displayed in a list, and in the column 3802, the distribution ratio set for each component is displayed. While confirming this information,
By inputting the value to be changed in the field 03 and clicking the OK button, the change of the allocation rate is immediately transferred to the profit / loss simulation apparatus 103 and recalculated.

In addition, by checking the check box 3804, it is possible to set the total allocation rate of all siblings as a fixed value and change only another value without changing the allocation rate of a certain component.

Note that the column 3805 is a unit display unit that displays in advance how many units corresponding to the constituent elements will be when development is performed based on the changed distribution rate.

FIG. 39 is a diagram showing a display example of the detailed information screen. The detailed information screen is a screen that can display all the information of a certain component in the area indicated by 3901. In addition, as shown in the 3902 column, the detailed screen can display the plans of the preceding several periods in time series. Similarly to FIG. 37, information can be changed on this screen by placing the cursor on the changeable information column and overwriting the numerical value to be changed.

  Next, a third embodiment of the present invention will be described in detail.

Embodiments of a procurement decision support system according to the present invention will be described below in detail with reference to the drawings.

FIG. 48 is a diagram for explaining input / output of information between devices of the procurement decision support system according to the embodiment of the present invention. In FIG. 48, the same reference numerals are assigned to portions common to FIG. 1, and new portions are attached to different portions or subdivided portions. 128 is the planned purchase unit price, 129 is the item classification master, 4801
Is the daily schedule plan, 4802 is the remaining shelf forecast, and 4803 is the valuation loss.

  As shown in FIG. 48, the entire procurement decision support system according to the present embodiment and its peripheral system include a profit / loss simulation apparatus 103 that outputs a medium schedule plan 124 based on an input payout cost schedule 125, A procurement plan drafting device 104 that outputs a procurement schedule 120 based on the inputted medium schedule plan 124 and the requirement calculation master 127, and a daily medium schedule plan 4801 subdivided into daily units, and an inputted procurement plan The remaining inventory simulation device 105 that outputs the estimated cost of purchase 125, the remaining inventory forecast 4802, and the estimated loss 4803 based on the proposed schedule 120, the daily schedule plan 4801, the planned purchase unit price 128, and the requirement calculation master 127 is input. The management decision support device 101 that displays the remaining shelf prediction 4802 and the evaluation loss 4803 and outputs the remaining shelf target, and the input remaining shelf prediction 480 Are displayed together with the unrealized loss 4803 and the remaining shelf target 112, and the change input of the procurement plan 120 by the manager in charge of the remaining shelf / procurement plan is received, and the changed procurement plan 120 is output to the remaining shelf simulation device 105. It is composed of a shelf remaining / procurement plan support device 106. In particular, the procurement decision support system includes the procurement plan planning device 104, the shelf remaining simulation device 105, and the shelf remaining / procurement plan support device 106 as components.

FIG. 49 illustrates the order of processing of devices and the order in which information flows between devices. Reference numerals 4901 to 4907 in the figure represent processing steps of each device. In step 4901, the management decision support device 101 sends the remaining shelf target 112 to the remaining shelf / procurement plan support device 106. In step 4902, the profit / loss simulation apparatus 103 sends the medium schedule plan 124 to the procurement plan planning apparatus 104. In step 4903, the procurement plan drafting device 104 generates the procurement plan draft 120, sends the procurement plan draft 120 and the daily schedule plan 4801 to the shelf remaining simulation device 105, and the procurement plan draft 120 is sent to the shelf remaining / procurement plan support device. 106. In step 4904, the remaining shelf simulation apparatus 105 generates the “paid out cost plan 125”, the “remaining shelf forecast 4802”, and the “valuation loss 4803” using the procurement plan 120 sent from the procurement planning apparatus 104. The “cost forecast 125” is sent to the profit / loss simulation apparatus 103, and the “shelf remaining prediction 4802” and the “valuation loss 4803” are sent to the shelf remaining / procurement plan support apparatus 106. In step 4905, the shelf remaining / procurement plan support apparatus 106 displays each input index on the display screen, the shelf remaining / procurement plan manager changes the procurement plan, and the modified procurement plan 120 is stored on the shelf. This is sent to the remaining simulation device 105. Step 49
In 06, the remaining shelf simulation device 105 uses the revised and changed procurement plan 120 sent from the remaining shelf / procurement plan support device 106 to “paid out cost schedule 125 ′” and “
The remaining inventory prediction 4802 ′ ”and the“ valuation loss 4803 ′ ”are generated again by recalculation, and the“ paid out cost prediction 125 ′ ”is sent again to the profit / loss simulation apparatus 103, and the“ remaining inventory prediction 4802 ′ ”and the“ valuation loss 4803 ′ ”are transmitted. Is again sent to the shelf remaining / procurement plan support device 106 and the management decision support device 101. Management decision support device 1 at step 4907
01 redisplays each input index.

FIG. 50 illustrates the functional configuration and input / output information of the shelf remaining simulation device 105 in detail. The shelf remaining simulation device 105 includes a shelf remaining calculation function 5001, a paid-out cost calculation function 5002, a valuation loss calculation function 5003, and a shelf remaining amount calculation function 500.
It is composed of four. The shelf-remaining simulation apparatus receives the planned purchase unit price 128, the procurement plan 120, the daily schedule plan 4801 and the requirement calculation master 127 shown in the uppermost part of FIG. The evaluation loss 4803, the payout cost schedule 125, and the remaining shelf forecast (quantity, amount) 4802 shown in FIG.

The shelf remaining calculation function 5001 includes a procurement plan 120 which is procurement information of a part unit having parts, a procurement plan classification, a delivery date, and a quantity illustrated in FIG. 64, and a product, a plan classification, and a scheduled shipping date illustrated in FIG. Necessary for carrying out the required amount calculation described in detail in the daily mid-term schedule 4801 which is the sales information of the product unit with the item of the number of units, and the “ordering system” in Japanese Patent Laid-Open No. 2001-266045 Requirement calculation master 127, which is a large amount of information, is input. Then, by the calculation process by the remaining shelf calculation function 5001, the quantity of goods that are goods information having items of parts, required date, and quantity, the quantity of goods that is goods receipt information having items of parts, delivery date, and quantity, and item ( Including all parts, products and semi-finished products),
Outputs inventory forecast (quantity only), which is quantity-based inventory information with items for the target period, end-of-period inventory, and work in progress flag. The calculation processing by the shelf remaining calculation function 5001 is shown in FIG.
It is executed according to the procedure described in the above.

The payout cost calculation function 5002 receives the amount of warehousing and the remaining inventory prediction (only the quantity) calculated by the remaining inventory calculation function 5001 and the planned purchase unit price 128, which is purchase information having items of parts, target period, and purchase unit price. 65, the planned payout cost plan 125 having the items of item, forecast category, target period, payout unit price that is the unit price when parts are paid out, and payout cost that is the unit price when products and semi-finished products are paid out is output. . The calculation process by the payout cost calculation function 5002 is executed according to the procedure described in FIG.

The valuation loss calculation function 5003 inputs the amount of goods issued by the remaining shelf calculation function 5001, the payout cost schedule 125 calculated by the payout cost calculation function 5002 and the planned purchase unit price 128, and inputs parts, forecast category, target period, and valuation loss amount. An evaluation loss, which is evaluation loss information having the following items, is calculated by the procedure described with reference to FIG.

The shelf remaining amount calculation function 5004 receives the shelf remaining prediction (quantity only) calculated by the shelf remaining calculation function 5001 and the payout cost schedule 125 calculated by the payout cost calculation function 5002 as inputs. The items illustrated in FIG. The shelf remaining prediction (quantity, amount), which is the remaining shelf information having items of the target period, the end-of-period inventory quantity, the end-of-period inventory amount, and the in-process flag, is calculated by the procedure described in FIG.

Here, the calculation procedure performed by the remaining shelf calculation function 5001 will be described with reference to the flow shown in FIG.

In step 5101, from the procurement plan draft using the method of calculating the required procurement quantity considering the ordering unit from the required quantity of parts described in detail in “Ordering System” of JP-A-2001-266045. Calculate the required procurement amount and add the planned receipt amount (order remaining) to the receipt amount.

In step 5102, a daily schedule plan is prepared using a requirement calculation method for obtaining the required amount of parts from the number of product-level plans described in detail in “Ordering System” of JP-A-2001-266045. The required amount is calculated from 4801, and is used as the outgoing amount.

In step 5103, as shown in (Equation 1) for each part, add the sum of the warehousing amount for the relevant period to the ending inventory quantity for the period before the relevant period, and further subtract the sum of the amount of goods issued for the relevant period. Calculate inventory.

Stock at the end of the period = Stock quantity at the end of the previous period
+ Σ Receipt amount within the applicable period
-Σ Issued volume within the applicable period (Equation 1)
In step 5104, it is checked whether or not the end-of-period inventory quantity has been calculated for all the parts. If there are unprocessed parts, the process returns to step 5101 to continue the process, and if there are no unprocessed parts, the process proceeds to step 5105.

In step 5105, an inventory quantity relating to a work-in-process product or a semi-finished product that is being manufactured at the end of the corresponding period is calculated. The sum of the planned shipment quantity from the day following the end of the applicable period of the product or semi-finished product to the day ahead of the production lead time is used as the in-process inventory for that product or semi-finished product, and this is the in-process indicator The amount of stock at the end of the period marked with.

In step 5106, it is checked whether or not the end-of-period inventory with in-process flag is calculated for all products and semi-finished products. If there are unprocessed products and semi-finished products, step 5106
Returning to 105, the processing is continued, and if there is no unprocessed product or semi-finished product, the processing proceeds to step 5107.

  In step 5107, the calculation target period is advanced by one.

In step 5108, it is checked whether or not the calculation target period is not a calculation target. If the calculation target period is not a calculation target, the process returns to step 5101 to continue the process. With the above calculation method, it is possible to execute a process for calculating the quantity of goods delivered, the quantity of goods received, and the remaining shelf prediction (only the quantity).

Next, a calculation procedure performed by the payout cost calculation function 5002 will be described with reference to the flow shown in FIG.

In step 5201, the planned payout unit price is calculated for each part by the calculation formula shown in (Formula 2). FIG. 53 shows an example of calculating the scheduled payout unit price. At this time, the currency of the planned purchase unit price is unified with the exchange rate.

Disbursement unit price plan = (end-of-period inventory before the relevant period x withdrawal unit price prior to the relevant period
+ Total amount of goods received in the relevant period x Planned purchase unit price)
÷ (Stock at the end of the period before the relevant period + Sum of warehousing within the relevant period) (Number 2)
FIG. 53 shows an example of calculating the payout unit price schedule for each month. Here, calculation of the payout unit price schedule for February will be described. Assuming that the end-of-month inventory in January is 50, the payout unit price is 200, the warehousing amount in February is 60, and the planned purchase unit price is 150, the payout unit price plan for February is (50 x 200 + 60 x 150) / (50 + 60)
= 173. The calculation of the payout unit price schedule in March and April can be similarly performed.

In step 5202, it is checked whether the payout unit price schedule has been calculated for all the parts. If there are unprocessed parts, the process returns to step 5201 to continue the process. If there are no unprocessed parts, the process proceeds to step 5203.

In step 5203, the payout unit price schedule of the parts constituting the product and the semi-finished product is calculated based on the parts structure table, and the payout cost schedule of the product and the semi-finished product is calculated.
A specific example will be described with reference to FIG.

FIG. 54 shows an example of calculating a payout cost schedule for a certain product P, semi-finished product X, and semi-finished product Y. According to the BOM, product P has one semi-finished product X and one semi-finished product Y
The semi-finished product X is composed of one part A and one part B, and the semi-finished product Y is composed of one part C and two parts D. Here, part A, part B,
If the payout unit price schedule for parts C and D is 50, 30, 10, 25, respectively, the payout cost schedule for semi-finished product X is the payout unit price schedule for parts A composing semi-finished product X × number of components and part B The payout unit price plan × the number of components is 50 × 1 + 30 × 1 = 80. Similarly, the payout cost schedule of the semi-finished product Y is 10 × 1 + 25 × 2 = 60. Further, the payout cost schedule for product P is 80 using the payout cost schedule for semi-finished product X and semi-finished product Y.
It is calculated as x1 + 60x1 = 140.

In step 5204, it is checked whether the payout cost schedule has been calculated for all products and semi-finished products. If there are unprocessed products and semi-finished products, the process returns to step 5203 to continue the processing. If not, the process proceeds to Step 5205.

  In step 5205, the calculation target period is advanced by one.

In step 5206, it is checked whether or not the calculation target period is not a calculation target. If the calculation target period is not a calculation target, the process returns to step 5201, and if not, the process proceeds to step 5207.

In step 5207, the plan category of the medium schedule plan (scenario in the new plan or the correction plan) is substituted into the forecast category of the payout cost schedule.

Next, a calculation procedure performed by the valuation loss calculation function 5003 will be described with reference to the flow shown in FIG.

In step 5501, an evaluation loss is calculated for each part using the calculation formula shown in (Formula 3).

Valuation loss = (scheduled unit price-planned unit price) x amount of goods issued (Equation 3)
In step 5502, it is checked whether or not evaluation loss has been calculated for all parts. If there is an unprocessed part, the process returns to step 5501 and the process continues. If there is no unprocessed part, the process proceeds to step 5503.

  In step 5503, the calculation target period is advanced by one.

In step 5504, it is checked whether or not the calculation target period is not a calculation target. If the calculation target period is not a calculation target, the process returns to step 5501 and if not, the process proceeds to step 5505.

In step 5505, the plan category of the medium schedule plan (scenario in the new plan and the correction plan) is substituted for the forecast category of valuation loss.

Next, a calculation procedure performed by the remaining shelf price calculation function 5004 will be described with reference to the flow shown in FIG.

In step 5601, the remaining shelf price is calculated for each part using the formula shown in (Formula 4), and the remaining shelf price is calculated using the formula shown in (Formula 5) for each product and semi-finished product.

Shelf remaining amount = planned payout unit price × end-of-period inventory (number 4)
Shelf remaining amount = planned payout cost x end-of-period inventory (5)
In step 5602, it is checked whether the shelf remaining amount has been calculated for all parts, all products, and semi-finished products. If there are unprocessed parts, products, and semi-finished products,
Returning to step 5601, the process is continued, and if there is no unprocessed part, product, or semi-finished product, the process proceeds to step 5603.

  In step 5603, the calculation target period is advanced by one.

In step 5604, it is checked whether or not the calculation target period is not a calculation target. If the calculation target period is not a calculation target, the process returns to step 5601 to continue the process.

In step 5605, the plan category of the medium schedule plan (new plan or scenario in the correction plan) is substituted for the forecast category of the remaining shelf forecast (quantity / amount).

FIG. 57 illustrates the functional configuration and input / output information of the procurement plan planning apparatus 104 in detail. The procurement plan planning apparatus 104 includes a procurement plan planning function 5701 and a medium schedule plan daily function 5702. The procurement plan planning device 104 receives the medium schedule plan 125 and the requirement calculation master 129 shown in the uppermost part of FIG. 57 from another device, and the daily schedule plan 4801 shown in the lowermost part of FIG. The procurement plan 120 is output to another device.

The procurement planning function 5701 receives the daily schedule plan 4801 and the requirement calculation master 129 as inputs, and from the number of plans at the product level described in detail in “Ordering System” of Japanese Patent Laid-Open No. 2001-266045. The procurement plan 120 is calculated from the daily schedule plan 4801 using the requirement calculation method for obtaining the required amount of parts, and the procurement plan classification at this time is set to “original”. Here, “original” means the first procurement plan automatically calculated by the procurement plan planning device 104 based on the medium schedule plan 124 transmitted from the profit / loss simulation device 103.
When correction is made by the manager in charge of the remaining shelf / procurement plan, the procurement plan classification is set to contents such as “change 1” and “change 2”.

The mid-schedule plan schedule function 5702 receives the mid-schedule plan 125 as an input, divides the number of plans for each period with the mid-schedule plan into the number of plans per day, and creates a daily schedule plan 4
801 is calculated.

FIG. 58 illustrates in detail the functional configuration and input / output information of the shelf remaining / procurement plan support apparatus. The shelf remaining / procurement plan support apparatus includes a procurement plan change function 5801 and an index display function 5802. The shelf remaining / procurement plan support apparatus includes a procurement plan 120, a shelf remaining target 112, a valuation loss 4803, and a remaining shelf prediction (quantity / amount) 4 shown in the uppermost part of FIG.
802 and the item classification master 129 are input from another device, and the procurement plan 120 shown at the bottom of FIG. 58 is output.

The procurement plan change function 5801 is a function for displaying the quantity of the input procurement plan 120 by item and by delivery date, a function for arbitrarily changing the quantity of the input procurement plan 120 and a procurement plan for the item to be changed. It has a function to search. FIG.
Shows the screen of the procurement plan change function and will be described in detail.

In FIG. 59, 5901 indicates the quantity of the procurement plan 120 by item (vertical direction in the table).
In addition, the procurement plan display / input unit can display the delivery date (horizontal direction of the table) and change the quantity of the procurement plan by inputting the quantity in the frame. Reference numeral 5902 denotes a procurement plan registration execution button for saving the procurement plan classification of the procurement plan changed by clicking this button as “change 1” or the like. Reference numeral 5903 denotes a search input unit for inputting an item or item code of an item to be searched. 5904 is a search execution button for executing a search of an item or item code input to 5903 by a well-known search method by clicking this button, and 5905 is a procurement plan change function by clicking this button. It is an end execution unit that ends. The procurement plan changer, such as the manager in charge of the remaining inventory / procurement plan, inputs the item or item code in the search input section 5903 for the item to be changed, clicks the search execution section 5904, and is searched and the procurement plan display / input section is searched. Rewrite the quantity of the procurement plan of the item displayed in the item by entering the quantity in the frame of the procurement plan display / input section, and change the procurement plan 120 by clicking the procurement plan registration execution button of 5902 I can do it.

The index display function 5802 includes a shelf remaining target illustrated in FIG. 24, a valuation loss, a shelf remaining prediction (quantity / amount) illustrated in FIG. 66, and item and model classification and (part / product / semi-finished product) classification. This function is a function that counts and displays the remaining shelf prediction 4802 and the evaluation loss 4803, and is executed by the remaining shelf / procurement plan support apparatus 106. In the aggregation process, the remaining shelf amount and the valuation loss amount for each item are totaled according to the item classification master. However, the finished product inventory and in-process stock of products and semi-finished products are classified by referring to the in-process flag of the shelf remaining prediction. Regarding the display processing, first, FIG. 60 shows an outline of a display screen in the shelf remaining / procurement plan support apparatus 106, and specific examples of the screens displayed in FIGS.

FIG. 60 shows an outline of a screen for displaying each indicator of the remaining shelf target 112 and the remaining shelf simulation result. Reference numeral 6001 denotes a shelf remaining target display section.
A specific example will be described. Reference numeral 6002 denotes a shelf remaining prediction display unit, which will be described with a specific example in FIGS. An evaluation loss display unit 6003 can be displayed in the same display format as in FIGS. Reference numeral 6004 denotes a display condition input unit that inputs or selects display conditions for shelf remaining prediction display and evaluation loss display. The display condition refers to a sorting method for displaying the remaining shelf prediction and evaluation loss in various categories such as model type, expense item, and component item. Reference numeral 6005 indicates the input shelf residual prediction (quantity / amount) or evaluation loss prediction classification (scenario 1, 2 etc.), and reference numeral 6006 indicates the procurement plan classification (original, change 1) of the input procurement plan. , Change 2 etc.) are displayed.

FIG. 61 shows an example displayed on the remaining shelf target display portion 6601. The remaining shelf target amount input by the manager using the management decision support apparatus 101 is displayed in a table format by model and by the time to be achieved.

62 and 63 show an example displayed on the shelf remaining prediction display portion 6602. FIG. FIG. 62 shows a display example when the model type is specified as the display condition.
Daily amount, weekly unit, monthly unit, etc.), the amount of money is plotted on the vertical axis, and the remaining amount of shelves that are aggregated and classified by model are displayed in a graph. FIG. 63 is a display example in which model type and cost item are specified as display conditions. The horizontal axis indicates time, the vertical axis indicates the amount of money, and the remaining shelf amount that is tabulated according to model type and cost item is displayed in a graph. . Although not shown in the figure, even when the item by cost, the item by item, or the remaining quantity of a specific item is specified as the display condition, the graph can be displayed in the same manner.

With such a display form, it is possible to simultaneously display various information related to the shelf remaining target and the shelf remaining prediction, and also to change the procurement plan, change the prediction category, etc.
It is possible to appropriately and promptly support the decision making by the department manager in charge of inventory remaining and procurement.

FIG. 70 illustrates the functional configuration and input / output information of the supplier selection decision support apparatus 7005 in detail. A supplier selection decision support apparatus 7005 includes an exchange rate scenario setting function 7001, an exchange fluctuation effect confirmation function 7002, a supplier transaction condition setting function 7003, and a supplier comparison function 7004. The supplier selection decision support device 7005 stores the payout cost schedule 125, the remaining inventory forecast (quantity / amount) 5402, and the item classification master 129 for each exchange rate scenario shown in the top row of FIG. The exchange rate (illustrated in FIG. 68) and transaction conditions (illustrated in FIG. 69) shown at the bottom of FIG. 70 are output from the apparatus.

The exchange rate scenario setting function 7001 has a function of setting a plurality of exchange rate scenarios. FIG. 71 shows a screen for setting an exchange rate scenario, which will be described in detail.

FIG. 71 shows an outline of the exchange rate scenario setting screen. Input unit 71
In 01, an exchange rate scenario name is input, and a plurality of exchange rate scenarios can be registered by distinguishing by the scenario name. The input unit 7102 receives an application target period of a set exchange rate. In the input units 7103 and 7104, an exchange rate and a currency name are input. When the registration button 7105 is pressed, the input exchange rate is registered.

The exchange fluctuation impact confirmation function 7002 is used to estimate the remaining inventory for each exchange rate scenario.
Quantity), paid-out cost prediction, and item classification master, the remaining shelf amount for each exchange rate scenario and the cost of any product are calculated by the remaining shelf simulation device 105 and displayed for each exchange rate scenario. The calculation according to the present embodiment can be realized by a simulation calculation considering exchange fluctuation prediction information (exchange rate scenario).

FIG. 72 shows an example of a screen for confirming the effect of exchange rate fluctuations. FIG. 72 shows an example of a screen that displays the result of the remaining shelf calculation and the payout cost calculation for each set exchange rate scenario. 7201 is a portion for displaying the remaining amount of shelf, and by displaying the remaining amount of shelf for each exchange rate scenario side by side, the influence of each exchange rate scenario can be compared. Reference numeral 7203 denotes a part for displaying the product cost. By displaying the product cost for each exchange rate scenario side by side, the influence of each exchange rate scenario can be compared. The product cost displayed here is the cost for the product selected in 7202. Further, the exchange fluctuation effect confirmation calculation can be executed in units of parts.

The supplier transaction condition setting function 7003 has a function of setting transaction conditions for each supplier. FIG. 73 shows a display example of a supplier transaction condition setting screen.

FIG. 73 shows an outline of a screen for setting transaction conditions with a business partner. The transaction conditions are the procurement lead time, which is the time required for procurement of the parts to be traded, the lot size, which is the unit of order quantity, the minimum number of lots, which is the minimum number of order lots, and the unit price information of parts. That is. In the input unit 7301, information specifying a business partner such as a business partner name or a business partner code is input. Input unit 73
In 02, the procurement rules for the transaction conditions are entered, and the item code, procurement lead time,
You can enter the lot size and the minimum number of lots to trade. Unit price information of transaction conditions is input to the input unit 7303. By pressing a registration button 7304, the input transaction condition of the supplier is registered. Here, the user on the procurement side registers the transaction conditions of each business partner to be compared.

The supplier comparison function 7004 is a function for displaying the remaining shelf price for each supplier and the cost of an arbitrary product by inputting the remaining inventory forecast (amount / quantity), the paid-out cost forecast for each supplier transaction condition, and the item classification master. Have FIG. 74 shows a supplier comparison screen, which will be described in detail.

FIG. 74 shows an example of a screen that displays the result of performing the remaining shelf calculation and the payout cost calculation for each transaction condition of the set business partner. 7401 is a portion for displaying the remaining amount of shelf, and by arranging and displaying the remaining amount of shelf when dealing with each business partner, it is possible to compare the transition of remaining shelf when dealing with each business partner. In addition, 7403 is a part for displaying the product cost. By displaying the product cost when dealing with each customer side by side,
You can compare product costs when dealing with each business partner. The product cost displayed here displays the cost for the product or part selected in 7402.

As described above, according to the present embodiment, it is possible to make a simulation prediction of a shelf remaining amount transition and a product cost transition in consideration of exchange rate fluctuations for each product or part. Also,
Since it is possible to predict the remaining inventory simulation by setting transaction conditions for each business partner, it is possible to provide the user on the procurement side with the remaining inventory prediction information considering the exchange rate fluctuation prediction.
As a result, the procurement user can select a supplier in consideration of exchange rate risk.

The system configuration | structure of this invention and the delivery information between each apparatus are shown. An example of the procedure for exchanging information between devices in the present invention will be described. The transition of the screen which the management decision support apparatus of this invention provides is shown. An example of the results history display screen shown by the management decision support apparatus of the present invention is shown. The display item selection screen of the performance history display of this invention is shown. The index selection screen of the results history display of the present invention is shown. An example of the management index target value setting screen in the present invention is shown. An example of the actual display screen of this invention is shown. An example of the display item selection screen of the actual guess display of this invention is shown. An example of the parameter | index selection screen of the actual guess display of this invention is shown. An example of the other actual guess display screen of the present invention is shown. An example of the target value review screen of the management index of this invention is shown. An example of the large schedule plan edit screen of this invention is shown. An example of the scenario review screen of this invention is shown. An example of the comparison screen for every scenario of this invention is shown. The functional structure of the management decision support apparatus of this invention is shown. The data structure of sales performance data is shown. The data structure of the profit and loss performance data is shown. The data structure of production performance data is shown. The data structure of shelf residual performance data is shown. The data structure of the large schedule plan is shown. The data structure of the profit / loss target is shown. The sales target data structure is shown. The data structure of the remaining shelf target is shown. The data structure of sales forecast data is shown. The data structure of profit and loss forecast data is shown. The data structure of shelf prediction data is shown. The data structure of evaluation loss prediction data is shown. The information exchange centering on the profit-and-loss decision support system of this invention is shown. An example of the procedure of information exchange between each apparatus which comprises the system of this invention is shown. The function structure of the profit and loss simulation apparatus of this invention is shown. The detailed flow of the large schedule plan expansion | deployment function of this invention is shown. The detailed flow of the feasibility check function of this invention is shown. The detailed flow of the profit-and-loss calculation function of this invention is shown. The functional structure of the profit-and-loss decision-making support apparatus of this invention is shown. The screen flow in the profit and loss decision support apparatus of this invention is shown. An example of the product structure tree screen of this invention is shown. An example of the addition rate change screen of this invention is shown. An example of the detailed information screen of this invention is shown. The data of the big schedule plan is shown. Indicates model configuration data. The allocation rate data is shown. The data for the medium schedule plan is shown. Indicates the output result data indicating whether the plan can be executed. The data of the partition ratio is shown. Shows data of product sales schedule. Shows profit / loss / sales / cost data. The information exchange centering on the shelf remaining and procurement plan support system of this invention is shown. An example of the procedure of information exchange between each apparatus which comprises the system of this invention is shown. The functional structure of the shelf remaining simulation apparatus of this invention is shown. The detailed flow of the shelf remaining calculation function of this invention is shown. The detailed flow of the paid-out cost calculation function of this invention is shown. The calculation method of the payout unit price schedule is shown. An example of the calculation method of the payout cost schedule of this invention is shown. The detailed flow of the evaluation loss calculation function of this invention is shown. The detailed flow of the shelf remaining calculation function of this invention is shown. 1 shows a functional configuration of a procurement plan planning apparatus of the present invention. 1 shows a functional configuration of a shelf remaining / procurement plan support apparatus according to the present invention. An example of the screen display by the procurement plan change function of this invention is shown. An example of the screen display by the parameter | index instruction | indication function of this invention is shown. An example shown by the shelf remaining target display part of this invention is shown. An example shown by the shelf remaining prediction display part of this invention is shown. An example shown by the shelf remaining prediction display part of this invention is shown. An example of the procurement plan data of this invention is shown. An example of the payout cost schedule data of this invention is shown. An example of shelf prediction (quantity / amount) data of the present invention is shown. An example of the daily schedule data of this invention is shown. An example of the exchange rate data of this invention is shown. An example of transaction condition data of the present invention is shown. The functional structure of the supplier selection decision support apparatus of this invention is shown. An example of the exchange rate scenario setting screen of this invention is shown. An example of the exchange fluctuation influence confirmation screen of this invention is shown. An example of the transaction condition setting screen of this invention is shown. An example of the result of the supplier comparison of the present invention is shown.

Explanation of symbols

101 ... Management decision support device, 102 ... Profit and loss decision support device,
103 ... Profit and loss simulation device, 104 ... Procurement planning device,
105 ... shelf remaining simulation device, 106 ... shelf remaining / procurement plan support device

Claims (10)

In a management decision support system that supports management decisions,
It has a management decision support device that outputs a large schedule plan, profit / loss target and sales target input support screen to the display means, and transmits input data input by the input support screen to the profit / loss decision support system,
Management decision support apparatus for correcting data of large schedule plan, profit / loss forecast, forecast data of sales forecast calculated based on the result of executing simulation calculation of execution possibility of the large schedule plan by the profit / loss decision support system The management decision support system characterized in that, when received, the prediction data is output and displayed on the display means of the management decision support apparatus. In a management decision support system that supports management decisions,
A management decision support device that outputs a large schedule plan, profit / loss target and sales target input support screen to the display means, and receives input data of the large schedule plan, profit / loss target and sales target by the input support screen,
The input data is received from the management decision support device, a simulation operation is performed to determine whether or not the large schedule plan can be executed, and based on the result, a correction plan for the large schedule plan, profit and loss forecast, forecast data for sales forecast Profit and loss decision support system for calculating
A management decision support system characterized in that the prediction data is output and displayed on the display means of the management decision support apparatus. In a management decision support system that supports management decisions,
Management that accepts input data for large schedule plans, profit / loss targets, sales targets, and remaining inventory targets on the display, and accepts input data for large schedule plans, profit / loss targets, sales targets, and remaining inventory targets A decision support device;
A simulation of whether to execute the large schedule plan after receiving the large schedule plan, the profit / loss target, and the sales target from the management decision support device in the input data, and expanding the large schedule plan into a medium schedule plan A profit and loss decision support system that performs a calculation and calculates first forecast data of a correction plan, profit and loss forecast, and sales forecast of a large schedule based on the result;
Calculate a procurement plan based on the medium schedule plan sent from the profit and loss decision support system, and based on the medium schedule plan, the procurement plan and the planned purchase unit price,
Shelf remaining / procurement plan support system for calculating shelf remaining forecast and second forecast data of valuation loss and payout cost schedule;
Management decision making, wherein the first and second forecast data are output and displayed on a display means of a management decision support device, and the payout cost schedule is transmitted to the profit / loss decision support device Support system. In the management decision support system according to any one of claims 1 to 3,
The profit and loss decision support system executes a simulation calculation of whether or not to execute a large schedule based on a profit and loss decision support apparatus that accepts a correction input of a large schedule plan, an allocation rate, and a product sales price schedule, A management decision support system characterized by having a profit and loss simulation device for calculating a feasible large schedule plan and profit and loss forecast and sales forecast data. In the management decision support system according to claim 3,
The shelf remaining / procurement plan support system includes a procurement plan drafting device that calculates a procurement plan using the middle schedule plan, and a remaining shelf forecast and evaluation based on the procurement plan, the middle schedule plan, and the planned purchase unit price. A management decision support system comprising: a remaining shelf simulation device for calculating a loss and a payout cost schedule, and a remaining shelf / procurement plan support device for receiving a correction input for a procurement plan. In the management decision support system according to any one of claims 1 to 5,
The history of management indicators calculated based on the database data of sales results, production results, and remaining shelf records is displayed for each product group at the high scheduling level using the XY coordinate system with two management indexes as axes. A management decision support system characterized by that. In the management decision support system according to claim 1 or 2,
Based on the XY coordinate system with the two management indices as the axis, the history of management indices calculated based on the database data of sales performance, production performance, and shelf record performance, and the predicted transition based on the forecast data A management decision support system characterized by displaying each product group at the scheduling level. In the management decision support system according to any one of claims 3 to 5,
Two management indicators are the history of the management index calculated based on the data of the sales record, production record, and shelf record record, and the forecast transition based on the first forecast data or the second forecast data. A management decision support system characterized by displaying each product group at a large schedule level using an XY coordinate system with the axis as the axis. In the management decision support system according to claim 7 or 8,
A graph display based on a large-scale schedule plan (new plan) before the simulation,
A management decision support system characterized by displaying a graph display based on a large schedule plan (amendment plan) after the simulation. In the management decision support system according to any one of claims 7 to 9,
A management decision support system, wherein the display is performed for each scenario determined by a combination of a large schedule plan, a correction plan, and a demand prediction case.

Images