JP2010257353A - Program and system for supporting farming - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a farming support program which simulates press and slack of labor accompanying farming or financing in advance in accordance with a brand and a cropping type of cropped crop and the planted area thereof with crops of a plurality of brands and cropping types as an object. <P>SOLUTION: A farming data input tool 10 receives inputs of: farm work diary data including work content and a work amount charged for each farm product and work occurrence date and time; farm expanse data including charged expenses and expense occurrence date and time; and farming data such as farm sales data including collected sales and sales occurrence date and time, and the farming data are formed into a database to build up a farming database 20. A farming simulation tool 30 refers to the farming database 20 and performs a variety of simulations, such as calculating work labor, expenses and sales for each farm product, and visualizes them. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to an agricultural management support program and an agricultural management support system for supporting farmer's agricultural management.

  Agriculture has the same agricultural varieties of the same varieties, but each farmer has agricultural knowledge and agricultural technology accumulated through years of experience. Based on that agricultural knowledge and agricultural technology, the purchase of agricultural materials and agricultural equipment In many cases, the company invests in agricultural management, such as purchasing rice, ordering seedlings, and improving soil. In this way, if only the same crop type crops of the same varieties are used for farming, it is possible to grasp the actual state of farming operations with relative ease even with techniques that rely on years of intuition and experience.

However, in the case of agricultural management using only crops of the same type and the same crop type, there is a problem that seasonal fluctuations increase due to the bias in the contents and generation time of labor, expenses, sales, etc. associated with agricultural management. In addition, there is a problem that the yield decreases when crops of the same crop type with the same variety are planted continuously. Therefore, it is necessary to devise a technique to flatten the contents and generation time of labor, expenses, sales, etc. accompanying farm management and reduce seasonal variation by farming by combining multiple varieties of crops and multiple cropping types. . In addition, even if it is the crop of the same variety, if the cropping pattern is different, the content, time, etc. of the labor, expenses, sales, etc. that occur are different, so the effect of reducing seasonal fluctuations can be obtained.
However, when combining multiple varieties and cropping crops in this way and farming while changing the cultivars and cropping types as appropriate according to the business year, the content and timing of the labor, expenses, sales, etc. that occur will be complicated. Therefore, it is difficult to accurately grasp farm management only by the experience and knowledge of each farmer. This situation is the same for both new farmers and veteran farmers, and it is important to know in advance what kind of farming will be achieved if what kind of cropping type and what kind of cropping are planted. difficult.

  Conventionally, a system for supporting agriculture using a computer has been proposed. For example, the system disclosed in the following patent document 1 and patent document 2 is mentioned as the example. The following Patent Document 1 discloses a system that supports soil improvement, and Patent Document 2 discloses a system that supports fertilization and agricultural chemical application. In addition, Patent Document 3 describes that a new farmer can perform farm management with the same agricultural knowledge as an experienced veteran who can supply crops appropriately requested in the market using a database storing crop order information and agricultural production know-how. A system for assisting such is disclosed.

JP 2002-345331 A JP-A-11-313594 JP 2007-072787 A

  However, the conventional system for supporting agriculture provides support for soil improvement (for example, Patent Document 1) and support for fertilizer application and pesticide application (for example, Patent Document 2), but it is a part of agricultural management, and it is a part of agricultural management. Not enough to support the whole. Moreover, although the technique of patent document 3 will be support for a new farmer, it presupposes the agricultural management of the cultivation of a fixed crop. If multiple varieties / cropping crops are targeted and farming is carried out while changing the cultivated varieties / cropping type as appropriate, not only new farmers but also veteran farmers can choose which varieties / cropping crops There is a problem that it is difficult to grasp in advance what kind of farming will be achieved if planting with a certain planting area. In other words, veteran farmers often struggle to adjust their labor and cash flow when dealing with multiple varieties and crop types.

  In view of the above problems, the present invention also covers crops of a plurality of varieties / cropping types, and if the cultivar / cropping area of the cropping crop is selected, how will the labor of the farming increase and decrease in cash flow? The purpose is to provide an agricultural management support program that can simulate in advance.

In order to achieve the above object, the agricultural management support program of the present invention is an agricultural management support program for supporting farmer's agricultural management,
Agricultural data including farm work diary data including work contents, work amount and work occurrence date and time input for each crop, agricultural expense data including input expense and expense occurrence date, and agricultural sales data including collected sales and sales occurrence date and time Agricultural management data input processing step for receiving management data input;
Agricultural management database construction processing step for constructing an agricultural management database by converting the input agricultural management data into a database;
A labor calculation processing step of referring to the agricultural management database and calculating the work effort generated for each crop together with the work occurrence date and time;
Expense calculation processing step of referring to the agricultural management database and calculating the expenses generated for each crop together with the expense occurrence date and time,
A farm management support program comprising a sales calculation processing step of referring to the farm management database and calculating the sales collected for each crop together with the sales generation date and time.
With the above configuration, it is possible to manage work labor, work occurrence date / time, expenses, expense occurrence date / time, sales, sales occurrence date / time for each crop based on the agricultural management data, and to provide accurate agricultural management support.

Next, a farm work model that models the farm work including the work content, work amount, and scheduled work occurrence date and time expected to be input, and the agricultural cost including the expected expenses and expected cost occurrence date, for a given area for each crop. Agricultural management model database that includes an agricultural management model that includes an agricultural management model that includes an agricultural sales model that models agricultural sales models that include agricultural sales models that include the sales of agricultural products that are expected to be collected and the expected sales date and time. It is preferable that the farm management model data desired to be used is acquired from the farm management model database through the data input processing step and input to the farm management database.
With the above configuration, if there is insufficient farm management data as a result of the farmer's individual farm management, or if there is other farm management model data to be referenced, the relevant farm management model can be obtained and Can support good agricultural management.

Next, in the above configuration, a crop / planting area plan data input processing step for inputting plan data of a variety / cropping type of the crop planned by the farmhouse and a planting area for each of the variety / cropping type, and the farm management Referring to the database, the expected work effort calculation processing step for calculating the expected work effort together with the scheduled work occurrence date and time at the planned cropping area according to the type and crop type of the crop, and the expected expense is calculated together with the expected cost occurrence date and time. And a prospective sales calculation processing step for calculating expected sales together with the estimated sales occurrence date and time, and is capable of farming simulation.
With the above configuration, farm management can be simulated from various angles, and multi-faceted farm management such as selection of cultivated crop varieties and cropping types, increase / decrease in cropping area can be visualized and examined.

Next, the agricultural management support program further includes a total period unit input processing step for arbitrarily designating a period unit for totalization, and the labor calculation processing step totals the work effort in units of the specific period. It is preferable to create a labor plan table that summarizes the subtotal of the work effort required for each period unit.
With the above configuration, it is possible to visualize the busyness of work labor in agricultural management. For example, the work effort plan can be visualized for each designated period such as monthly, weekly, or three-day units.

The agricultural management support program further includes a counting period unit input processing step for arbitrarily designating a period unit for counting, and in the expense calculation processing step, the expenses are tabulated in the period unit for the designation, and the sales In the calculation processing step, it is preferable that the sales can be totaled in the period unit for the designation, and a cash flow table can be created in which the necessary expenses and the subtotal of the sales that can be collected are summarized for each period unit.
With the above configuration, it is possible to visualize the cash flow in agricultural management. For example, the cash flow plan can be visualized for each specified period such as monthly, weekly, or three-day units. In other words, it is possible to analyze not only macro agricultural profits but also agricultural managements in monthly units.

  Further, referring to the agricultural management database, the cultivar / cropping type of the crop planned by the farmer, and the crop / cropping area plan data input processing step for inputting plan data of the planned cropping area for each cultivar / cropping type, The estimated work effort calculation processing step for each period unit for calculating the expected work effort for each period unit in the planned cropping area for each crop, and the expected cost calculation for each period unit for calculating the expected expense for each period unit A processing step and an expected sales calculation processing step by period unit for calculating sales expected for each period unit, and the farm management can be simulated for each period unit through the labor plan table and the cash flow chart. It is preferable to enable agricultural management simulation.

  With the above configuration, a multifaceted farm management simulation can be performed to visualize the farm management. For example, it is possible to visualize the work effort assumed when changing the type of cropping crop or increasing or decreasing the cropping area in the form of a work effort plan for each specified period, such as monthly, weekly, or 3-day units. it can. For example, it is possible to simulate in advance that farm work is concentrated in August due to the balance between the type of crop crop and the cropping area, and August is overloaded. Similarly, it is possible to visualize the rapidity of cash flow in agricultural management. For example, the estimated expenses can be visualized in the form of a cash flow chart for each specified period such as monthly, weekly, or in units of three days. It is possible to simulate in advance that the funds will be tight in August when no sales proceeds due to the balance between the type of planted crop and the planted area.

Next, in the agricultural management support program, the subsidy data input processing step for inputting subsidy data related to the cultivar / cropping type, subsidy amount, subsidy receipt date and time, subsidy conditions for which subsidies are provided, In the sales calculation processing step, the subsidy amount and the subsidy receipt date and time are reflected in the sales and the generation date and time, and the agricultural management simulation including the subsidy is enabled in the agricultural management simulation.
With the above configuration, agricultural simulations with subsidies are also possible. There are administrative subsidies for agriculture for various purposes. There are subsidies for farming work and subsidized crops. Adding subsidies to agricultural simulations is the reality of agricultural management. Is important in thinking about

Next, in the above-mentioned agricultural management support program, agricultural model data including work contents, work amount, work occurrence date and time that are expected to be input, and expenses / expenses that are expected to be input are provided for new varieties and new crop types. A new varieties agricultural management model data input processing step for inputting agricultural expense model data including the date and time and agricultural sales model data including the sales / sales occurrence date and time at which collection is expected, and the expected work effort calculation processing step Reflected in labor and work occurrence schedule date, reflected in expected cost calculation processing step and expected cost generation date, reflected in expected sales calculation processing step and estimated sales occurrence date, Agriculture that takes into account the above-mentioned new varieties and new cropping in management simulation It is preferable to allow the simulation.
With the above configuration, it is possible to create an agricultural plan that appropriately incorporates new varieties that are developed year by year, such as new varieties with high yields, new varieties with high crop value, and new varieties that are resistant to diseases. In consideration of the introduction of new varieties, it is important to consider the actual situation of agricultural management.

  The new varieties of agricultural work model data, agricultural cost model data, and agricultural sales model data may be provided by, for example, agricultural test sites or research institutions that have developed the new varieties. It is possible to respond flexibly, for example, by tentatively making a decision.

Next, it is preferable that fruit crops can be handled in the agricultural management support program. However, fruit farming is different from crops that can be harvested in a single year, and it is fundamental that it takes multiple years to grow from seedling planting and actually harvest the fruit tree. In addition, there is a term that can harvest trees that have been grown before fruit trees can be harvested. This is because when it comes to old trees, it is difficult to bear fruit, or even if the fruit grows, the market value is low.
Therefore, in the agricultural management support program, regarding the fruit crop, in the agricultural management data input processing step, the agricultural management data is stored in the agricultural management database for each year, and in the agricultural management simulation, the expected work effort calculation processing is performed. In the step, the work effort expected for the fruit tree crop is reflected for each year together with the scheduled work occurrence date and time, and in the expected cost calculation processing step, the cost expected for the fruit tree crop is reflected for each year together with the cost occurrence scheduled date and time, In the estimated sales calculation processing step, the sales expected for the fruit crop are reflected every year together with the scheduled sales occurrence date and time, and in the farming simulation, the planting of the fruit crop whose labor, cost, and income vary depending on the year. It is preferable to take into account.
With the above configuration, it is possible to handle fruit crops whose labor, cost, and income vary from year to year in an agricultural management simulation, thereby providing more multifaceted support for agricultural management.

Next, in the above-mentioned agricultural management support program, it is preferable to enable an agricultural management simulation that takes into account the adjustment of cash flow. This is because in actual agricultural management, the problem of cash flow is important and often hindered. Therefore, in the above-mentioned agricultural management support program, when the expected cost calculation processing step by period unit detects a period unit that becomes deficit in the cash flow chart, setting of a loan to a financial entity so that the deficit can be eliminated And the simulation of principal and interest repayment for the loan.
With the above configuration, it is possible to discover in advance a period in which cash flow is severe, and in this period, the loan setting process, the principal for the loan and the simulation of the repayment of interest can be linked, and an agricultural simulation can be performed in consideration of finance.

  Next, in the above-mentioned agricultural management support program, it is preferable to perform an agricultural management simulation that takes into account even short-term employment during busy periods. Therefore, when the estimated work effort calculation processing step by period unit detects an overload period exceeding the predetermined amount of effort in the work effort plan table, short-term employment is performed so that the overload can be eliminated. Can be linked with the farm management simulation that takes into account the increase in wages for the short-term employment.

It is also preferable to link the information on the period unit that requires short-term employment and the information on the wage set for the short-term employment with an employment adjustment system provided by the government.
With the above configuration, it is possible to discover in advance a period in which it is difficult to secure labor in the busy season, and it is possible to perform an agricultural simulation that takes into account the necessity of short-term employment and the increase in expenses due to wage payments for short-term employment. If this employment adjustment can also be linked to the local administrative system, secure employment on the farmers' side and employment promotion measures on the administrative side will be appropriately matched.

The above-mentioned farm management support program preferably aggregates farm management simulations concerning a plurality of farms existing in the area, not the farmer alone as a user. For example, the expected work effort calculation processing step by period unit includes the farm equipment lease plan processing step for collecting the number of farm equipment required for the work effort plan and making a lease plan for the farm equipment held as the region. This is because it can be expected to improve efficiency by reducing costs and securing employment as a whole.
The agricultural management support system of the present invention is a system in which the processing procedure of the above-described agricultural management support program is incorporated in a storage device. For example, it is configured as a device based on a personal computer in which the above-described agricultural management support program is installed in a storage device such as a memory.

According to the agricultural management support program and the agricultural management support system of the present invention, based on the agricultural management data, it is possible to manage work labor, work occurrence date and time, expense, expense occurrence date, sales, and sales occurrence date for each crop, Can support agricultural management with high accuracy.
According to the farm management support program and the farm management support system of the present invention, farm management can be simulated from various angles, and multi-faceted farm management such as selection of cultivated crop varieties and cropping types, increase or decrease of cropping area, etc. Can be visualized and examined.

In addition, the following effects can be expected as a secondary effect.
First of all, as an effect for new farmers, the risk of new entry can be avoided by using the cash flow chart. In addition, for those who focus on their own labor, it is possible to plan effort without difficulty by trying combinations of crops.

  In addition, as an effect for experienced farmers, it is possible to visualize the activities of their own farm management every year, so it is possible to grasp the problems in farm management. In addition, it is possible to actively consider the introduction of crops with little experience so far, and to reduce failures. In addition, it is possible to evaluate borrowings at the time of scale expansion using the cash flow chart.

  In addition, as an effect on research institutes and administrative organizations related to agriculture, it is easy to grasp the problems of regional agriculture, and management guidance and regional guidance with a view to the future become possible, making it possible to plan more appropriate administrative measures. In addition, income compensation-type measures can be taken in accordance with local conditions. In addition, loan guidance and collection plan guidance will be appropriate based on the cash flow chart.

  Hereinafter, the best mode for carrying out the present invention will be described specifically by way of examples. The present invention is not limited to these examples.

An example of an agricultural management support program according to the first embodiment will be described with reference to the drawings.
The example of the agricultural management support program of the first embodiment has a basic agricultural management data input tool, an agricultural management database, and an agricultural management simulation tool. The simulation example also shows basic work effort simulation and cash flow simulation. In this example, it is possible to specify a period unit such as monthly, and an example in which the result of aggregation in a specified period such as monthly can be visualized and displayed in the simulation.

FIG. 1 is a diagram schematically showing the configuration of an agricultural management support program of the present invention.
FIG. 2 is a flowchart showing a processing procedure from input of farm management data to construction of the farm management database 20 in the farm management support program of the present invention.
FIG. 3 is a flowchart showing a processing procedure related to a farm work labor simulation and a cash flow simulation in the agricultural management support program of the present invention.

  As shown in FIG. 1, the agricultural management support program 100 according to the first embodiment includes an agricultural management data input tool 10, an agricultural management database 20, and an agricultural management simulation tool 30. Note that illustrations of other program tools and operating systems that are generally provided in application programs to run on a personal computer are omitted.

  Agricultural management data input tool 10 is a tool for inputting agricultural management data. The farmer's data input tool 10 can be used to write a so-called agricultural diary that farmers have been doing without being aware of the creation of special data. It is a part that provides a user interface that enables data input necessary to grasp agricultural management, in the way of writing an accounting book and the way of writing a sales book in agriculture.

  FIG. 4 is a diagram illustrating an example of the input user interface 11 for each crop variety / cropping type provided by the agricultural management data input tool 10. Although the crop is “A”, the input user interface 11 is called for each type and crop type of the crop to be planted, and the crop is sequentially input. The input user interface 11 of FIG. 4 is a combination of two user interface portions.

The first user interface is a farm work diary data input user interface part for inputting farm work diary data including work contents, work amount, and work occurrence date and time input for each crop in the manner of writing a farm work diary.
The input user interface 11 shown in FIG. 4 has a column group for inputting the date from the left, and then a column group for inputting farm work / technical contents, which are arranged in the same manner as the farm diary. In this example, the spreadsheet software is organized so that it can be easily seen by the rows and columns of the columns. The expression is almost similar to the agricultural diary recorded on paper.

  Here, the farm work diary is basic data on daily farm work including the work contents, work amount, and work occurrence date and time input for each crop. Each farmer manages the farm work he / she is doing in some way, although there is a difference whether the farm work is recorded in the form of a diary or not. The farm management support program provides an input interface that allows easy input of various data related to farm work without any special knowledge about computers.

  Next, the second input interface is the way to write the accounting book and sales book of agriculture. Agricultural expense data including expenses and expenses generated at the time of farm management and sales / sales occurrence date collected by farm management. It is an agricultural accounting data input user interface part for inputting agricultural sales data including.

  In the input user interface 11 shown in FIG. 4, there is a column group for inputting accounting data such as expenses and sales on the right side of the column group for inputting farm work / technical contents, which is arranged in the same manner as the accounting book. In this example, the spreadsheet software is organized so that it can be easily seen by the rows and columns of the columns. The expression is almost similar to the accounting book recorded on paper.

  Here, the agricultural expenses are data including the direct expenses, indirect expenses, and the date and time when these expenses are generated in the agricultural management. Each farmer manages the expenses required for the farm management they are doing in some way. The farm management support program is an input interface that allows you to easily input expenses related to farm management without any special knowledge about computers.

Agricultural sales are data including sales collected in agricultural management and sales occurrence date and time. Each farmer manages the sales that can be collected through the farming they are doing in some way. The farm management support program is an input interface that allows you to easily input sales related to farm management without any special knowledge about computers. In addition, subsidies provided by the government policy can be taken into account for the recovery of agricultural management. This is because there is subsidy income if various conditions such as the variety of crops to be subsidized, the presence or absence of cropping patterns, and the state of agricultural management are satisfied.
As described above, the user can input various agricultural management data through the input user interface 11 for each crop provided by the agricultural management data input tool 10.

The farm management database 20 is a database for managing farm management data input via the farm management data input tool 10.
Here, since farm work and farming techniques vary from farmer to farmer, you will need to enter your own farm management data for each crop type and crop type. For varieties and cropping types that have been planted in the past but for which no detailed data remains, it is difficult for the user to input all the agricultural management data, so the standard agricultural management data is stored in the agricultural management database in advance. In addition, it is possible to use the agricultural model data in the agricultural management database for these crops. The farm management model data is not an essential configuration, and is not shown in the configuration example of FIG. Agricultural management model data refers to a farm work model that models farm work including the work content, work amount, and scheduled work occurrence date and time for a given area for each crop type and cropping type, and inputs are expected. This includes an agricultural expense model that models agricultural expenses including expenses / expected date and time of occurrence of farming, and an agricultural sales model that models agricultural sales that include expected sales and sales of crops that are expected to be collected.

Next, the operation of the agricultural management simulation tool 30 will be described.
The farm management simulation tool 30 is a tool for calculating various farm management simulations described later and presenting them to the user. The farm management simulation tool 30 can perform various simulations. Here, two simulation examples are given. The first is agricultural labor simulation. The second is a cash flow simulation. In addition, the farm management simulation tool 30 has an ability to execute a farm management simulation in which a plurality of cropping crops are combined and designated by specifying the cultivar / cropping area and cropping area.

  First, it is necessary to input the cultivar crop type and cropping area and the cropping area, which are prerequisites for the farm management simulation (step S31). When it is desired to perform a simulation regarding the unit area of a variety / cropping single item, it is only necessary to specify the variety / cropping and unit area (for example, 10 ares) of one type of cropping crop.

  The farm management simulation tool 30 includes a labor calculation processing step (step S32) for calculating the work effort generated for each crop together with the work occurrence date and time with reference to the farm management database 20 as a farm work effort simulation.

  In addition, the farm management simulation tool 30 refers to the farm management database 20 as a cash flow simulation, and calculates a cost calculation processing step (step S33) for calculating the cost generated for each crop together with the cost generation date and time, and the sales collected for each crop are sold. Sales calculation processing step (step S34) to be calculated along with the date and time of occurrence, profit and loss statement creation processing step (step S35) to create a profit and loss statement that summarizes necessary expenses and recoverable sales, and cash flow schedule to create a cash flow schedule A creation processing step (step S36) is provided.

  This example also includes an aggregation period unit input processing step that arbitrarily designates the period unit for aggregation. The work effort is aggregated for the specified period unit, and the subtotal of the required work effort is summarized for each period unit. It is possible to create a work schedule. For example, it is possible to aggregate and display monthly. In the cash flow simulation to be described later, a cash flow chart can be created for each period unit for the specified period unit. For example, it is possible to aggregate and display monthly.

  The farm management simulation tool 30 displays a work effort plan table, a work effort graph that visualizes the work effort in an easy-to-understand manner, a profit and loss plan, a cash flow chart, and a cash flow chart that visualizes the cash flow in an easy-to-understand manner according to the user's display request. Is performed (step S37).

FIG. 5 is a diagram illustrating a simulation example of a labor plan table that is tabulated monthly for a crop A of a certain variety / cropping type. The amount of work is displayed for each month as the number of work hours, and the excess of work to be input is expressed in an easy-to-understand manner.
FIG. 6 is a diagram showing a simulation example in which the labor plan table compiled by month is visualized by a graph so as to be easier to understand. In this example, it can be grasped at a glance that the labor to be input is large in May. In other words, it can be understood that the user must procure the necessary personnel to secure labor in May.
FIG. 7 is a diagram showing an example of the income statement. This is a summary of the basic figures for creating a cash flow chart. The required expenses for each month and the sales that can be recovered are displayed, and it is expressed in an easy-to-understand manner.
FIG. 8 is a diagram showing a simulation example of a cash flow table tabulated by month. Each month shows the cash flow required for that month. In this example, it can be understood that it is necessary to secure funds in advance because the cash flow becomes tight in December and May.
The above is the basic agricultural management data input procedure for individual crops and the simulation procedure for various analysis results.

  Next, the farmer actually uses the agricultural management support program of the present invention to plant crops of various varieties and cropping types on the farmland to be operated, and tries to increase or decrease the cropping area and analyze the results. Examples of various farming simulations are shown.

FIG. 9 is a diagram showing an example in which the user inputs the cultivar crop type and cropping type and their cropping area for the next year through the input user interface provided by the agricultural management data input tool 10. is there.
The input interface 12 of FIG. 9 is an input user interface different from the input user interface 11 for inputting the agricultural management data of the single cultivar / cropping crop shown in FIG. It is possible to specify and input a plurality of varieties and crop types to be planned for the next fiscal year and the planned acreage. In this example, four crops, “Onion (short-term storage)”, “Spinach (October sowing)”, “Spinach (October sowing)”, and “Leek onion”, are selected as cropping crops for the following year. The planted area was entered as 20 ares, 30 ares, 15 ares, and 3 ares in order.

  Numerous simulations can be performed based on this designation input. First, the table of FIG. 10 is an example of a farm labor plan created as a farm labor simulation when a plurality of varieties and crop types are combined. In other words, four crops of “Onion (short-term storage)”, “Spinach (October sowing)”, “Spinach (May sowing)” and “Fat leek” are 20 ares, 30 ares, 15 ares and 3 ares, respectively. This is an agricultural labor plan that is assumed when planting in the planted area. Excessive amount of work to be input by month is expressed in an easy-to-understand manner.

  Further, the table of FIG. 11 is an example in which the agricultural labor plan table of FIG. 10 is visualized by a graph so as to be easier to understand. In this example, it can be understood at a glance that the labor to be input is large in January and June. In other words, it can be understood that the user must procure the necessary personnel to secure labor in January and June.

Next, I conducted a cash flow simulation.
FIG. 12 is a diagram showing an example of a profit and loss statement created as a cash flow simulation in the case of using the cultivar and cropping crop and the cropping area shown in FIG. In other words, four crops of “Onion (short-term storage)”, “Spinach (October sowing)”, “Spinach (May sowing)” and “Fat leek” are 20 ares, 30 ares, 15 ares and 3 ares, respectively. It is a profit and loss statement that is assumed when planted in the planted area.

  Next, the cash flow simulation created based on this income statement is displayed. The table in FIG. 13 is a simulation example of a cash flow table compiled by month based on the profit and loss statement shown in FIG. Each month shows the cash flow required for that month. In addition, the table in FIG. 14 is visualized in a graph so that it is easy to understand the cash flow based on the cash flow chart in FIG. In this example, it can be seen at a glance that the cash flow becomes tight in January, June, and July. Therefore, it can be understood that it is necessary to secure funds in advance in January, June, and July.

  In this manner, the user can repeat the labor planning simulation and the cash flow simulation by changing the cultivar crop type and cropping pattern or changing the cropping area, and can make a plan for the next year.

Next, an agricultural management simulation process in which fruit crops are added in the above agricultural management simulation will be described.
Fruit crops, unlike single-year crops that can be harvested in a single year, are concentrated in planting and other labor and expenses during the growing period from the first year, and then the yield increases and the income exceeds the expenses. It will be the gardening period. In other words, fruit crops are characterized by varying labor, expenses, and income from year to year. For this reason, the farm management simulation differs depending on whether the fruit tree crop is in the growing period or the gardening period in the year in which the simulation is performed. Therefore, the farm management simulation needs to be an agricultural management simulation incorporating the state of the fruit tree crop.
Therefore, the following processing is performed in each processing step in order to perform an agricultural management simulation in consideration of a fruit tree crop.

  First, in the agricultural management data input processing step via the agricultural management data input tool 10, agricultural management data for each year is input for each year and stored in the agricultural management database 20.

  FIG. 15 shows an input interface 13 for inputting multi-year agricultural management data for a single fruit crop. In this example, only a part of the first year that is the start year of the training and the second year of the next year is shown. Enter the data for the third and subsequent years, as well as the gardening period.

Next, an agricultural management simulation with fruit tree cultivation will be described.
The farm management simulation tool 30 reflects the expected work effort as described above for the perennial crops along with the scheduled work occurrence date in the estimated work effort calculation processing step, while for the fruit crops, the growing period and the gardening period. For each year, the expected work effort is reflected along with the scheduled work occurrence date. Fruit crops require labor to grow during the growing period, and labor is required to maintain the fruit tree even after it has become a gardening period and can be harvested.

  FIG. 16 is a display example of a labor plan table in which labor is tabulated for each year. In this example, the result of totaling the total from the first year to the ninth year by month is displayed. In addition, there is a column for specifying the target year at the top, and if the year is specified, the labor plan table in which the specified year is taken out is displayed. FIG. 17 is a diagram in which the fifth year is designated as an example and the labor plan table for only the fifth year is displayed. FIG. 18 is a graph visualizing the labor plan table for the fruit tree crop A shown in FIG. 16 in an easy-to-understand manner. It is possible to grasp at a glance the labor to be applied to the fruit tree crop A.

Next, a cash flow simulation that takes fruit tree cultivation into account will be described.
In the estimated cost calculation processing step, the farm management simulation tool 30 reflects the expected expenses as described above for the monoperennial crops together with the estimated cost generation date and time, while for the fruit crops, annually for each growing period and gardening period. Each expected expense is reflected along with the estimated expense date and time. In other words, during the growing period, expenses necessary for growing are generated, and expenses are required to maintain fruit trees even after the period of the gardening and the harvesting becomes possible.
In addition, the farm management simulation tool 30 reflects the expected sales as described above for the perennial crops in the estimated sales calculation processing step together with the planned sales occurrence date, while for the fruit crops, it is a year corresponding to the growing period. Expected sales are low, and the expected sales increase if it is a year corresponding to the gardening period, and the sales for each year are reflected together with the scheduled sales date and time.

FIG. 19 is an example of the income statement. The required expenses for each month and the sales that can be recovered are displayed, and it is expressed in an easy-to-understand manner. FIG. 20 is a simulation example of a cash flow chart. Each month shows the cash flow required for that month. Through these processing steps, agricultural simulations that take into account the cultivation of fruit crops are performed. In this way, the user can perform a labor planning simulation and a cash flow simulation in consideration of fruit crops.
The above is an example of the agricultural labor plan simulation and the cash flow simulation that are performed when the user actually specifies the crop crop and the crop area.

  Next, as an application development utilization method, it will be explained that a farm management simulation can be tried using the farm management simulation 30 to improve problems in farm management. As an example, when farm management simulation was performed with the crops and cropping area of the cultivar / cropping type that was initially planned, it was found that there was a busy season when the load was concentrated at a certain time, and the cropping area was changed there When another farm management simulation was tried, it was found that the load during the busy season was improved. However, although the load during the busy season was improved, the amount of profit decreased greatly, so the farm management simulation was performed so that the amount of profit increased. Give an example of repeating.

Now, suppose that the cultivar and crop type to be planted and the planned planting area are planned to be 34 are for AA crop, 21 are for BB crop, 17 are for CC crop, and 4 are for DD crop.
Assuming that the crops to be planted and cropping patterns and the planned cropping area are as described above, a profit and loss statement as shown in FIG. 21 is created with reference to the farm management database 20 as a result of farm management simulation. In the example shown in FIG. 21, as shown in the bottom column, it is understood that the farm management profit is expected to be 2,893,799 yen as a result of the farm management simulation.

  Here, as a result of the farm work labor simulation, it was found that when the farm work plan and its graph were created, they were as shown in FIG. 22 and FIG. As can be seen from FIGS. 22 and 23, it can be seen that the labor load is concentrated in June.

  As a result of the above-mentioned agricultural labor simulation, it has been found that the problem that labor load is concentrated in June occurs, but various measures can be considered to deal with the labor load. For example, reduce the cropping area of varieties and cropping types that cause uneven labor load, change cropping varieties and cropping types, secure short-term employment during periods when labor load is concentrated, It is possible to introduce measures to introduce mechanized work.

Here, first, it will be tried whether or not the concentration of labor load can be reduced by changing the acreage of crops of varieties and cropping types that cause uneven labor load.
22 and 23, it can be seen that the load of AA crop is large in June. Therefore, as shown in FIG. 24, the cropping area of the AA crop was reduced to 3 ares, the cropping area of the CC crop was also reduced to 8 ares, and an agricultural management simulation was tried again. As described above, when the cropping area of the AA crop is changed to 3 ares and the cropping area of the CC crop is changed to 8 ares, the farming labor simulation results are as shown in FIGS. 25 and 26. As can be seen from FIG. 25 and FIG. 26, the labor load that was concentrated in June before the change of the planted area is alleviated after the change of the planted area, and there is no month in which the labor load is particularly concentrated. I understand. That is, the labor load in June exceeded 700 hours as shown in FIGS. 22 and 23 before the change of the planting area, but the labor of June as shown in FIGS. 25 and 26 after the change of the planting area. The load is suppressed to over 160 hours.

  Thus, as a result of agricultural labor simulation, it was found that if the planting area of AA crops was changed to 3 ares and the cropping area of CC crops was changed to 8 ares, the labor load concentrated in June was alleviated. However, as shown in the bottom column of FIG. 24, it can be seen that the profit amount of agricultural management is expected to be 1,341,947 yen. In other words, it can be seen that the profit amount of agricultural management is reduced from 2,893,799 yen to 1,341,947 yen. In other words, in the measure to reduce the cropping area of this AA crop to 3 ares and the cropping area of CC crops to 8 ares, the problem of labor load concentration in farm work has been improved, but the profit amount of farming management is greatly reduced. It turns out that it is not the optimal policy.

Next, in addition to the above-described measures by changing the acreage, other measures such as changing or diversifying crop varieties and cropping types are tried.
Now, as shown in FIG. 27, among the AA crops, BB crops, CC crops, and DD crops, the planting of CC crops has been stopped. Instead, EE crops are 20 ares, FF crops are 4 ares, and GG crops are 4 I tried to plant Earl. In addition, we decided to plant HH crop 40 are, JJ crop 5 are, and KK crop 3 are as additional crops.

  In this case, as shown in the bottom column of FIG. 27, it is understood that the profit amount of agricultural management is expected to be 3,777,999 yen. In other words, it can be seen that the profit amount of agricultural management is improved from 1,341,947 yen to 3,777,999 yen.

As shown in FIG. 27, when the load of agricultural labor generated when changing the cultivar / cropping type and cropping area of crops as shown in FIG. 27 is confirmed again, the agricultural labor plan table is as shown in FIG. 28 and FIG. 29. . As can be seen from FIG. 28 and FIG. 29, it can be seen that it can be suppressed within approximately 200 hours per month except for August and December. 22 and 23, the labor load in June exceeded 700 hours. However, in both the cases of FIGS. 25 and 26 and FIGS. 28 and 29, the labor load in June was suppressed to over 160 hours. ing. In the cases of FIG. 25 and FIG. 26, the amount of profit decreased greatly, but in the cases of FIG. 28 and FIG. 29, the amount of profit hardly decreased, so that the case of FIG. 28 and FIG. I understand.
In the cases shown in FIGS. 28 and 29, the labor for farming is about 250 hours in December. However, it can be expected that personnel for short-term employment can be secured relatively easily and the increase in labor costs is not so large.

  In this way, the simulation can be repeated by changing the farm management conditions on a trial and error basis, and trials can be made so as to be appropriate as a labor plan, a cash flow plan, and a profit amount.

  As described above, according to the agricultural management support program of the present invention, it is possible to simulate agricultural management from various angles, instead of agricultural management that has relied on intuition and experience, selection of cropping crops, increase / decrease of cropping area, etc. Visualize and examine multi-faceted agricultural management.

An example of an agricultural management support program according to the second embodiment will be described with reference to the drawings.
In addition to the basic configuration shown in Example 1, the example of the agricultural management support program of Example 2 also includes subsidy income that the government provides for agricultural management as a policy of agricultural management data. It has a configuration that allows processing that can be added.
In the example of Example 1, subsidy income could also be input as input of agricultural sales data via the agricultural management data input tool 10. However, the contents and conditions of subsidies vary from year to year, especially when considering new varieties and cropping crops, or when increasing or decreasing the acreage, It is not easy to know if you can receive it under the conditions.

The configuration of the second embodiment has a configuration including a subsidy information database that holds and stores administrative subsidy information for agricultural management.
FIG. 30 is a diagram schematically illustrating the configuration of the agricultural management support program according to the second embodiment. Similar to the configuration shown in FIG. 1, the farm management data input tool 10, the farm management database 20, and the farm management simulation tool 30 are provided and linked to the subsidy information database 21 of the external administrative server 200 via the network 300. . Note that illustrations of other program tools and operating systems that are generally provided in application programs to run on a personal computer are omitted.

  The subsidy information database 21 stores subsidy data related to the types of crops for which subsidies are provided, subsidies, subsidy receipt date and time, and subsidies, and is connected via a network in this example. For example, it is provided on a server operated by a subsidizing entity, a server operated by a municipal government, a server operated by an agricultural technology center, or the like.

  Agricultural management data input tool 10 communicates with subsidy information database 21 through a network, and inputs subsidies for subsidizing data related to crop types, subsidies, subsidies receiving date and subsidies for which subsidies are provided. A data input processing step is provided.

As shown in the first embodiment, the agricultural management data input tool 10 assists via the network 300 in this second embodiment when data on the variety, cropping type, and cropping area of the crop to be planted is input from the user. Access to the gold information database 21, search for subsidy data related to crop crops, and if subsidy data exists, the subsidy data is downloaded and stored in the agricultural management database 20.
In addition, the input of subsidy data by the agricultural management data input tool 10 is performed by the user himself / herself using an input device such as a mouse or a keyboard to access the subsidy information database 21 via the network and obtain desired data. It may be specified and acquired, or the agricultural management data input tool 10 may automatically acquire subsidy data by exchanging with the subsidy information database 21 via the network during system operation.

  The farm management simulation tool 30 checks the sub-conditions specified in the subsidy data in the sales calculation processing step. If the sub-conditions are satisfied, the farm management simulation tool 30 calculates the sub-amount in the sales calculation processing step (step S34). Reflecting the subsidy receipt date and time, it is possible to perform a cash flow simulation in consideration of the subsidy in the cash flow simulation (steps S35 and S36).

  A configuration that prompts the user to input the corresponding information when information for determining whether or not the auxiliary condition is satisfied is also preferable. For example, if there is a condition that only those within 3 years of farming are eligible for assistance, enter the code in the form of a question, such as "Is it within 3 years of farming? Enter 1 for YES and 2 for NO" It can be assumed that the user is prompted to input information.

An example of an agricultural management support program according to the third embodiment will be described with reference to the drawings.
In addition to the basic configuration shown in Example 1, the example of the agricultural management support program of Example 3 is a new cultivar that is provided as a new cultivar by the Agricultural Experiment Station and the Agricultural Technology Center as agricultural management data. Agricultural management model data is taken in from the outside, and the farm management simulation can be performed in consideration of the planting of the new variety.

  In the example of Example 1, it was the structure which inputs the various agricultural management data regarding the crop of the kind and cropping type to be planted through the agricultural management data input tool 10. However, with regard to new crops developed by the Agricultural Experiment Station and the Agricultural Technology Center, each farmer does not have sufficient agricultural management data and knowledge, and this limits the use of the agricultural management support program of the present invention. End up. In view of this, a new farming model data provided by the agricultural test center, agricultural technology center, etc. for new crops is taken in from the outside, and farm management simulation can be performed in consideration of the planting of the new breeds.

  FIG. 31 is a diagram schematically illustrating the configuration of the agricultural management support program according to the third embodiment. Similar to the configuration shown in FIG. 1, the farm management data input tool 10, the farm management database 20, and the farm management simulation tool 30 are provided. It is linked. Note that illustrations of other program tools and operating systems that are generally provided in application programs to run on a personal computer are omitted.

  The new cultivar agricultural management model database 22 includes agricultural work model data including work contents / work volume / work occurrence date / time expected to be input, and agricultural expense model data including expenses / expense occurrence date / time expected to be input for new crops. Agricultural sales model data including sales / sales occurrence date and time that are expected to be collected are stored, and in this example, they are connected via a network. For example, it is provided on a server operated by an agricultural test site or an agricultural technology center.

  The agricultural management data input tool 10 accesses the agricultural management model database 22 of the agricultural technology center server 210 via the network 300 and inputs new varieties of agricultural management model data for inputting new varieties of agricultural management model data regarding new varieties of crops. Processing steps are provided.

When a new cultivar planting is input from the user via the agricultural management data input tool 10 as shown in the first embodiment, the new cultivar agricultural management model database 22 is accessed via the network 300 in this configuration example. The new varieties agricultural management model data relating to the corresponding new varieties are downloaded and stored in the agricultural management database 20.
The new cultivar farm management model data is input to the new cultivar farm management model database 22 via the network by the user himself / herself using an input device such as a mouse or a keyboard. It may be obtained by accessing and specifying desired data, or when the system is in operation, the agricultural management data input tool 10 communicates with the new cultivar agricultural management model database 22 via the network and automatically cultivates the new cultivar It may be one that acquires model data.

  The farm management simulation tool 30 reflects the estimated work effort and the estimated work occurrence date and time in the estimated work effort calculation processing step, reflects the expected expense and the estimated expense occurrence date and time in the estimated expense calculation process step, and calculates the expected sales calculation processing step. In the agricultural management simulation, it is possible to carry out an agricultural simulation that takes into account the planting of new varieties. When the level of work labor is large and changes cropping crops to achieve flattening, if the user's known crops cannot flatten well, or when searching for new varieties that are easy to flatten the work labor Access to the variety agricultural management model database 22 is effective.

An example of an agricultural management support program according to the fourth embodiment will be described with reference to the drawings.
In addition to the basic configuration shown in Example 1, the example of the agricultural management support program of Example 4 is linked to the employment system operated by the government via the network in this example, and the number of people in the busy period of agricultural management The farming management simulation takes into account the securing and adjustment of short-term employment by the government.
In the example of Example 1, in the agricultural labor simulation by the agricultural management simulation 30, it was possible to grasp the analysis of the busy season and how much labor is lacking. However, it is necessary to take steps to secure personnel for short-term employment. On the other hand, the administration is in charge of employment adjustment and employment promotion, and there is a need to grasp the employment demand in the administrative region. Therefore, if the agricultural management support program used by each farmhouse and the employment adjustment system operated by the government are linked, both can exchange useful information.

  FIG. 32 is a diagram schematically illustrating the configuration of the agricultural management support program according to the fourth embodiment. Similar to the configuration shown in FIG. 1, the farm management data input tool 10, the farm management database 20, and the farm management simulation tool 30 are provided, and are linked to the employment adjustment system 23 of the external administrative server 200 via the network 300. Note that illustrations of other program tools and operating systems that are generally provided in application programs to run on a personal computer are omitted.

For example, the employment adjustment system 23 is assumed to be a system operated by so-called Hello Work, etc., and information on the period unit that requires short-term employment with the agricultural management support program 100 (from what month is the busy season? Month)) and information on wages set for short-term employment (how much is the daily salary).
The operation of exchanging data on short-term employment by exchanging with the employment adjustment system 23 is performed by the user himself / herself using an input device such as a mouse or a keyboard to access the employment adjustment system 23 via the network. The agricultural management data input tool 10 may automatically exchange data regarding short-term employment with the employment adjustment system 23 via the network while the system is operating.

  The administration side can accurately provide employment information to job seekers in the employment adjustment system 23 operated by Hello Work or the like. Farmers can also ensure short-term employment during busy periods.

An example of an agricultural management support program according to Example 5 will be described with reference to the drawings.
The example of the agricultural management support program of the fifth embodiment shown in FIG. 33 is a configuration example in which the agricultural management support programs 100 having the basic configuration shown in the first embodiment cooperate with each other via the network 300. In this example, one agricultural management support program 100a also serves as a server program. In this way, a plurality of farmers in the region exchange information, thereby enabling an agricultural management simulation integrated with the region.

  For example, joint use of agricultural equipment can be considered. When each farmer procures farming equipment such as a cultivator or a rice planting machine individually, the cost increases. However, if the farmer purchases jointly and uses it together, the cost of each farmer can be reduced.

  Therefore, in the estimated work effort calculation processing step of the farm management simulation tool 30 of each farm management support program 100, information on expected work effort is transmitted to the farm management support program 100 serving as a server via the network 300. . The farm management support program 100a as a server totals the information of work labor collected from each of the other farm management support programs 100b, c, d, aggregates the number of required farm work equipment, and holds farm work as a region. A farm work equipment loan plan processing step for making a equipment lease plan is provided. In this way, if the farm equipment is jointly used in accordance with the farm equipment rental plan, each farmer only needs to pay for the joint equipment. Expenses expected in the expense calculation processing step may be used as the joint use expenses.

  Although the agricultural management support program according to the present invention has been described above, a computer program that causes a computer system to execute the processing procedure of the agricultural management support program according to the present invention described in any of the first to fifth embodiments. Can be provided in the form of being carried on a computer-readable storage medium or downloaded via a computer network.

  In the first to fifth embodiments, the agricultural management support program according to the present invention has been described. However, the processing procedure of the agricultural management support program according to the present invention described in any of the first to fifth embodiments described above is a computer. It can be installed in the system and constructed as an agricultural management support system 101.

FIG. 34 is a diagram illustrating a configuration example of an agricultural management support system according to the sixth embodiment.
The agricultural management support system 101 includes an agricultural management data input processing unit 110, an agricultural management database 120, an agricultural management simulation unit 130, and an agricultural management data output processing unit 140.

  Agricultural management data input processing unit 110 includes agricultural work diary data including work contents / work amount / work occurrence date / time input for each crop, agricultural expense data including input expenses / expense occurrence date / time, and collected sales / sales generation date / time. Agricultural management data including agricultural sales data including In this configuration example, a keyboard 111 and a mouse 112 are provided.

  The farm management database 120 is a database of farm management data input by the farm management data input processing unit.

  The farm management simulation unit 130 refers to the farm management database 120, calculates the work effort generated for each crop together with the work occurrence date and time, calculates the cost generated for each crop along with the cost generation date and time, A sales calculation process is performed to calculate the sales collected for each crop together with the date and time when the sales occurred, and various simulation results such as a labor calculation table, a profit and loss calculation table, and a cash flow simulation are visualized via the monitor 141 of the agricultural management data output processing unit 140. It has become something that can be.

  The agricultural management data output processing unit 140 is a part that outputs various simulation results such as a labor calculation table, a profit and loss calculation table, and a cash flow simulation. In this configuration example, the farm management data output processing unit 140 includes a monitor 141 and a printer 142.

The configuration example of FIG. 34 is an example, and it is possible to mount other computer peripheral devices. It is also possible to connect to a network and use computer resources on the network.

  As mentioned above, although preferred embodiment in the example of composition of the agricultural management support program and agricultural management system of the present invention has been illustrated and explained, it is understood that various changes are possible without departing from the technical scope of the present invention. Will be done.

  The agricultural management support program and the agricultural management support system of the present invention can be widely applied to applications that support agricultural management.

The figure which shows typically the structure of the agricultural management support program of this invention The flowchart which shows the process sequence from the agricultural management data input in the agricultural management support program of this invention to construction of the agricultural management database 20 The flowchart which shows the process sequence regarding the farm work labor simulation and cash flow simulation in the agricultural management support program of this invention The figure which shows the example of the input user interface 11 for every kind and cropping type of a single crop provided by the agricultural management data input tool 10 The figure which shows the example of a simulation of the labor plan table totaled according to the month about crop A A diagram showing an example of a simulation that visualizes the labor plan table tabulated by month in a graph for easier understanding Diagram showing examples of income statement A diagram showing an example of a cash flow chart compiled by month The figure which shows the example which entered the cropping crop of the next fiscal year and those cropping areas The figure which shows the example of the farming labor plan created as a farming labor simulation when combining crops of multiple varieties and cropping types The figure which shows the example which visualized the agricultural labor plan table of FIG. The figure which shows the example of the profit and loss statement created as a cash flow simulation when it is set as the cropping crop of the variety and cropping type and the cropping area shown in FIG. The figure which shows the example of the cash flow table which is totaled according to the monthly basis based on the income statement shown in FIG. Figure showing a graph visualized to make it easier to understand the cash flow based on the cash flow chart of FIG. The figure which shows the input interface 13 which inputs the agricultural management data of several years regarding a fruit crop A figure showing a display example of a labor plan table that summarizes labor for each fiscal year The figure which designated the 5th year and displayed the labor plan table only for the 5th year Graph that visualizes the labor plan table for fruit crop A shown in FIG. 16 in an easy-to-understand manner The figure which shows the example of the profit and loss statement regarding fruit tree crop A The figure which shows the example of the cash flow table regarding fruit tree crop A The figure which shows the example of the profit and loss statement when changing the variety, cropping type and cropping area of the cropped crop (part 1) The figure which shows the labor plan table when changing the variety, cropping type and cropping area of the cropping crop (part 1) The figure which shows the labor plan graph when changing the variety, cropping type and cropping area of the cropping crop (part 1) The figure which shows the example of the profit and loss statement when changing the variety, cropping type and cropping area of the cropped crop (part 2) The figure which shows the labor plan table when changing the variety, cropping type and cropping area of cropping crop (part 2) The figure which shows the labor plan graph when changing the variety, cropping type and cropping area of the cropped crop (part 2) The figure which shows the example of the profit and loss statement when changing the variety, cropping type and cropping area of the cropped crop (part 3) The figure which shows the labor plan table when changing the variety, cropping type and cropping area of cropped crop (part 3) The figure which shows the labor plan graph when changing the variety, cropping type and cropping area of cropping crop (part 3) The figure which shows typically the structure of the agricultural management support program of Example 2. The figure which shows typically the structure of the agricultural management support program of Example 3. The figure which shows typically the structure of the agricultural management support program of Example 4. The figure which shows typically the structure of the agricultural management support program of Example 5. The figure which shows the structural example of the agricultural management support system of Example 6.

DESCRIPTION OF SYMBOLS 10 Agricultural management data input tool 20 Agricultural management database 30 Agricultural management simulation tool 100 Agricultural management support program 101 Agricultural management support system 110 Agricultural management data input processing part 111 Keyboard 112 Mouse 120 Agricultural management database 130 Agricultural management simulation part 140 Agricultural management data output Processing unit 141 Monitor 142 Printer 200 Administrative server 210 Agricultural Technology Center server 300 Network

Claims (14)

An agricultural management support program that supports farmer farming,
Agricultural data including farm work diary data including work contents, work amount, work occurrence date and time input for each crop, agricultural expense data including input expenses and expense occurrence date, and agricultural sales data including collected sales and sales occurrence date Agricultural management data input processing step for receiving management data input;
Agricultural management database construction processing step for constructing an agricultural management database by converting the input agricultural management data into a database;
A labor calculation processing step of referring to the agricultural management database and calculating the work effort generated for each crop together with the work occurrence date and time;
Expense calculation processing step of referring to the agricultural management database and calculating the expenses generated for each crop together with the expense occurrence date and time,
A farm management support program comprising: a sales calculation processing step of calculating sales collected for each crop together with a sales generation date and time with reference to the farm management database. Agricultural work model that models the farm work including the work content, work amount, scheduled work occurrence date and time expected to be input, and the agricultural cost including the expected expenses and expected cost occurrence date, for a given area for each crop Agricultural management model database that includes a database of agricultural management models, including an agricultural sales model that models agricultural sales models including agricultural sales models that include the sales and expected sales date of crops that are expected to be collected,
The agricultural management support program according to claim 1, wherein through the agricultural management data input processing step, agricultural management model data desired to be used is acquired from the agricultural management model database and input to the agricultural management database. A crop / planting area plan data input processing step for inputting the plan data of the cultivar / cropping type of the crop planned by the farmer and the planting area for each cultivar / cropping type;
With reference to the agricultural management database, the expected work effort calculation processing step for calculating the expected work effort together with the scheduled work occurrence date and time at the planned cropping area for each type and crop type of the crop, and the expected expenses are scheduled to be incurred. The agricultural management support program according to claim 1, comprising an estimated expense calculation processing step that is calculated together with a date and time, and an estimated sales calculation processing step that calculates expected sales together with the scheduled sales occurrence date and time, enabling an agricultural management simulation. . There is an aggregation period unit input processing step that arbitrarily specifies the period unit for aggregation,
2. The labor calculation processing step, wherein the work effort is aggregated in units of the period required for the designation, and a labor plan table summarizing a subtotal of the amount of work labor required for each period unit can be created. The agricultural management support program according to any one of 3 above. There is an aggregation period unit input processing step that arbitrarily specifies the period unit for aggregation,
In the expense calculation processing step, the expenses are totaled in units of the period required for the designation,
In the sales calculation processing step, the sales are totaled in units of the period required for the designation,
The agricultural management support program according to any one of claims 1 to 3, wherein a funding table that summarizes necessary expenses and subtotals of sales that can be collected for each period unit can be created. Crop type / cropping area plan data input processing step for inputting cultivar / cropping type of crop planned by the farmer and plan data of the planned cropping area for each cultivar / cropping type;
With reference to the agricultural management database, the expected work effort calculation processing step for each period unit for calculating the expected work effort for each period unit at the planned cropping area for each crop, and the estimated expenses for each period unit A period-by-period estimated cost calculation processing step, and a period-by-period expected sales calculation processing step for calculating the expected sales for each period unit,
The agricultural management support program according to claim 4 or 5, wherein an agricultural management simulation is made possible so that agricultural management can be simulated for each period unit through the labor plan table and the cash flow table. A subsidy data input processing step is provided for inputting subsidy data related to the type and crop type of the crop for which subsidies are provided, subsidy amount, subsidy receipt date and time, subsidy conditions,
The said sales calculation processing step reflects the said subsidy amount and the said subsidy receipt date and time in the said sales and the said generation | occurrence | production date, The agricultural simulation which considered the subsidy in the said farm management simulation was enabled. Agricultural management support program. Agricultural work model data including work contents / work volume / work occurrence date / time that is expected to be input, agricultural expense model data including cost / expense occurrence date / time expected to be input, and collection provided for new varieties / new crops from outside A new cultivar agricultural management model data input processing step for inputting agricultural sales model data including sales and sales occurrence date and time when
Sales reflected in the estimated work effort calculation processing step and the expected work occurrence date and time, and reflected in the estimated expense calculation processing step and the estimated cost generation date and time, and sales expected in the expected sales calculation processing step The farm management support program according to claim 6, wherein the farming simulation is reflected in the estimated date and time of sales occurrence, and the farming simulation can take into account the new varieties and new cropping. Regarding fruit crops, in the agricultural management data input processing step, the agricultural management data after the start of the cultivation is stored in the agricultural management database by year,
In the farm management simulation,
The expected work effort calculation processing step reflects the expected work effort of the fruit tree crop for each year together with the scheduled work occurrence date and time, and the expected expense calculation processing step calculates the expected cost of the fruit tree crop together with the expected cost generation date and year. Reflected every time, the expected sales calculation process step reflects the sales expected for the fruit crops for each year together with the estimated sales date and time, and in the agricultural management simulation, the labor, cost, and income vary from year to year The agricultural management support program according to claim 6, which enables an agricultural simulation in consideration of the cropping of the fruit crop.   Considering short-term employment so that the overload can be resolved when the estimated work effort calculation processing step by period unit detects an overload exceeding the predetermined amount of labor in the work effort plan table. The agricultural management support program according to claim 6, wherein the farm management simulation and the expected cost calculation processing step for each period unit can be linked to the farm management simulation taking into account the increase in wages for the short-term employment.   The information on the period unit that requires the short-term employment and the information on the wage set for the short-term employment are linked with an employment adjustment system provided by the government. Agricultural management support program.   The agricultural management support program according to any one of claims 1 to 11, wherein the agricultural management simulations relating to a plurality of farmers existing in a region are collected.   The estimated work labor calculation processing step for each period unit includes the farm work equipment lending plan processing step for aggregating the number of farm equipment required for the work effort plan and making a lending plan for the farm equipment held as the region. The agricultural management support program according to claim 12. An agricultural management support system that supports farmer farming,
Agricultural data including farm work diary data including work contents, work amount, work occurrence date and time input for each crop, agricultural expense data including input expenses and expense occurrence date, and agricultural sales data including collected sales and sales occurrence date Agricultural management data input processing unit that receives management data input,
An agricultural management database in which the agricultural management data input by the agricultural management data input processor is databased;
With reference to the agricultural management database, labor calculation processing for calculating the work effort generated for each crop together with the work occurrence date and time, cost calculation processing for calculating the cost generated for each crop with the cost generation date and time, and collection for each crop An agricultural management support system comprising an agricultural management simulation unit for performing sales calculation processing for calculating sales together with the date and time of occurrence of sales.

Images