JP2013164645A - Information output device, information output method, and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information output device in which correction is urged of a quantity and a delivery date of a storage object component arranged by means of output information, and thereby preventing lack of storage space and excessive inventory costs.SOLUTION: An information output device 1 comprises: an arrangement request information input part 14 for receiving an input of arrangement request information containing a quantity and a delivery date of an arranged storage object component; a capacity difference calculator 20 for calculating a capacity difference by subtracting a storage requisite capacity of components for each unit period of a future period including the delivery date, from a storage space capacity; an inventory cost difference calculator 21 for calculating an inventory cost difference by subtracting an inventory cost from a limit value for each unit period; and an information output part 25 that outputs capacity excess information indicating that the storage requisite capacity exceeds the storage space capacity, when there exists a unit period in which the capacity difference is negative, and that outputs inventory cost excess information indicating that the inventory cost exceeds the limit value, when there exists a unit period in which the inventory cost difference is negative.

Description

  The present invention relates to an information output device, an information output method, and a program for outputting information for correcting the quantity and delivery date of parts to be arranged.

  When a product delivered to a customer breaks down, a countermeasure is generally taken to replace the failed part. If this countermeasure is not performed immediately, the customer will wait for a long time in a state where the product cannot be used, and the serviceability for the customer will be greatly reduced. In particular, when the parts supply base arranges a replacement part after receiving the failure notification, the customer is allowed to wait for a longer time. For this reason, the parts supply base arranges replacement parts in advance and stocks them.

  In recent years, a technique for theoretically calculating the quantity at which a supply base arranges a part based on a lead time of a part, a demand prediction value, or the like has been proposed (for example, Patent Documents 1 to 3). However, at present, in order to reliably prevent a situation where parts cannot be supplied due to a shortage of inventory, a quantity obtained by adding an increment based on the judgment of the person in charge to the theoretical value of the arranged quantity has been arranged. As a result, there is a problem that the inventory at the supply base becomes excessive, resulting in a shortage of storage space and an excessive inventory cost.

  Patent Document 4 discloses a device that outputs an alarm that prompts correction of the order quantity. In this apparatus, the quantity of parts arranged is calculated based on the number of products produced by the person in charge. An inventory cost is calculated based on the quantity of parts arranged, and an alarm is output when the inventory cost exceeds the limit.

JP 2009-129092 A JP 2005-276124 A JP 2009-245217 A JP 2004-192169 A

  However, in Patent Document 4, although an alarm is output, the ordered quantity can be corrected from the viewpoint of inventory cost, but the ordered quantity cannot be corrected from the viewpoint of storage space capacity.

  The present invention has been made in view of the circumstances as described above, and its purpose is to urge correction of the quantity and delivery date of the parts to be arranged arranged by the output information, resulting in insufficient storage space due to excess inventory. It is an object to provide an information output device, an information output method, and a program that can prevent inventory costs from becoming excessive.

  An information output apparatus according to the present invention includes an arrangement request information input unit, an inventory quantity transition calculation unit, a necessary volume transition calculation unit, a volume difference calculation unit, an inventory cost transition calculation unit, an inventory cost difference calculation unit, And an information output unit. The arrangement request information input unit accepts input of arrangement request information including the arrangement quantity and delivery date of the parts to be stored. The inventory quantity transition calculation unit calculates the inventory quantity of the parts to be stored for each unit period of the future period including the delivery date based on the arrangement request information. The required volume transition calculation unit is based on the inventory quantity of each unit period calculated by the inventory quantity transition calculation unit and the volume of the package of the storage target part, and the storage required for storing the storage target part in each unit period. Calculate the required volume. The volume difference calculation unit calculates a volume difference obtained by subtracting the storage required volume of each unit period calculated by the required volume transition calculation unit from the volume of the storage space, and has a unit period in which the volume difference is negative. It is determined whether or not. The inventory cost transition calculation unit calculates the inventory cost of the storage target part in each unit period based on the inventory quantity of each unit period calculated by the inventory quantity transition calculation unit and the unit price of the storage target part. For each unit period, the inventory cost difference calculation unit calculates the difference in inventory cost by subtracting the inventory cost calculated by the inventory cost transition calculation unit from the limit value of the inventory cost that can be spent in the unit period. It is determined whether there is a unit period in which the difference between the two is negative. When it is determined that there is a unit period in which the difference in volume is negative, the information output unit outputs excess volume information indicating that the required storage volume exceeds the volume of the storage space, and the difference in inventory cost becomes negative When it is determined that there is a unit period, inventory cost excess information indicating that the inventory cost exceeds the limit value is output.

  According to the present invention, when arrangement request information indicating arrangement details in which the required storage volume exceeds the storage space volume is input, it is determined that there is a unit period in which the difference in volume is negative, and thus the excess volume Information is output. As a result, the person in charge is notified that the volume required for storage exceeds the volume of the storage space, so that it is urged to review the quantity and delivery date of the parts to be stored to be arranged. Therefore, a situation where storage space is insufficient due to excessive inventory is prevented.

  In addition, when arrangement request information indicating the contents of arrangement in which the inventory cost exceeds the limit value is input, it is determined that there is a unit period in which the difference in inventory cost is negative, and the inventory cost excess information is output. Is done. As a result, the person in charge is notified that the inventory cost exceeds the limit value, so that the number and the delivery date of the parts to be stored to be arranged are reviewed. Therefore, the situation where the inventory cost becomes excessive due to excessive inventory is prevented.

It is a block diagram which shows the structure of the information output device which concerns on embodiment of this invention. It is a figure which shows an example of component master information. It is a figure which shows an example of arrangement request information. It is a figure which shows an example of arrangement quantity information. It is a figure which shows an example of supply performance value information. It is a figure which shows an example of supply prediction value information. It is a figure which shows an example of present stock quantity information. It is a figure which shows an example of inventory quantity transition information. It is a figure which shows the state from which the arrangement quantity information of FIG. 4 was changed. It is a figure which shows an example of required volume transition information. It is a figure which shows an example of warehouse information. It is a figure which shows an example of volume difference information. It is a figure which shows an example of inventory cost transition information. It is a figure which shows an example of stock cost limit value information. It is a figure which shows an example of inventory cost difference information. It is a figure which shows an example of alarm information. It is a flowchart which shows operation | movement of an information output device. It is a block diagram which shows the hardware constitutions of an information output device. It is a figure which shows an example of inventory quantity estimated value information. FIG. 20 is a diagram illustrating a state in which inventory quantity prediction value information in FIG. 19 is changed.

  Hereinafter, an information output apparatus 1 according to an embodiment of the present invention will be described with reference to the drawings. The information output device 1 is provided at a supply base for the parts X1 to X3 used for product repair. At the supply base, when receiving a product failure notification, the parts X1 to X3 are arranged in advance by the person in charge so that the parts X1 to X3 can be supplied, and the parts X1 to X3 are stored in the storage space of the warehouse. Stored. The information output device 1 outputs information that prompts correction of the order quantity of the parts to be stored X1 to X3 from the viewpoint of inventory cost and storage space capacity.

  As shown in FIG. 1, the information output device 1 includes a parts master information storage unit 10, an arrangement quantity storage unit 11, a predicted supply value storage unit 12, a current inventory quantity storage unit 13, and an arrangement request information input unit 14. Inventory quantity transition calculation unit 15, required volume transition calculation unit 16, inventory cost transition calculation unit 17, warehouse information storage unit 18, inventory cost limit value information storage unit 19, volume difference calculation unit 20, The inventory cost difference calculation unit 21, the actual supply value storage unit 22, the average supply amount acquisition unit 23, the inventory period number calculation unit 24, and the information output unit 25 are provided.

  The component master information storage unit 10 stores the component master information of FIG. The part master information includes the part number, the product name, the model name, the release year, the lead time, the unit price, and the package volume of the parts X1 to X3 to be stored.

  The arrangement request information input unit 14 receives input of arrangement request information in FIG. The arrangement request information includes the part numbers of the storage target parts X1 and X2 arranged at the judgment of the person in charge, the requested quantities “50” and “20” of the storage target parts X1 and X2, and the delivery date “February 2012” and “2012. March ”.

  The arrangement quantity storage unit 11 stores arrangement quantity information shown in FIG. The arranged quantity information includes the storage target part X1 scheduled to be arranged at the supply base in a monthly unit of “January to December 2012” for the next one year including “February 2012” and “March 2012”. A quantity of ~ X3 is indicated.

  The actual supply value storage unit 22 stores actual supply value information of FIG. The actual supply value information indicates the actual value of the quantity of the parts to be stored X1 to X3 supplied from the storage space to the outside in “January to December 2011” for the past year.

  The predicted supply value storage unit 12 stores the predicted supply value information of FIG. The predicted supply value information indicates the predicted value of the quantity of the parts to be stored X1 to X3 supplied to the outside from the storage space in the monthly unit of “January to December 2012” for the next year. The predicted value for each month is set based on the actual value shown in the actual supply value information. In the example of FIG. 6, the predicted value for each month is set to match the actual value (FIG. 5) of the same month of the previous year.

  The current inventory quantity storage unit 13 stores the current inventory quantity information of FIG. The current inventory quantity information indicates the inventory quantities “170”, “70”, and “350” of the storage target parts X1 to X3 that are currently “end of December 2011”.

  Based on the arrangement request information (FIG. 3), the arrangement quantity information (FIG. 4), the supply forecast value information (FIG. 6), and the current inventory quantity information (FIG. 7), the inventory quantity transition calculation unit 15 The inventory quantity of the storage target parts X1 to X3 in each month of “January to December 2012” is calculated, and inventory quantity transition information (FIG. 8) indicating the calculated inventory quantity of each month is acquired. Details of the processing of the inventory quantity transition calculation unit 15 will be described below.

  First, the inventory quantity transition calculating unit 15 is the arrangement quantity of the storage target parts X1 and X2 indicated in the arrangement request information (FIG. 3) among the arrangement quantities indicated in the arrangement quantity information (FIG. 4), and the arrangement request. The arrangement quantities “140” and “30” in the delivery date “February 2012” of the part X1 and the delivery date “March 2012” of the part X2 indicated in the information are specified.

  Next, the inventory quantity transition calculation unit 15 changes the specified arrangement quantity “140” “30” to a quantity obtained by adding the requested quantity “50” “20” indicated in the arrangement request information (FIG. 3). As a result, the arrangement quantity information is in the state shown in FIG. In the state of FIG. 9, the order quantity of the storage target part X1 in the delivery date “February 2012” is changed to “190”. In addition, the arrangement quantity of the storage target part X2 in the delivery date “March 2012” is changed to “50”.

  Next, the inventory quantity transition calculation unit 15 calculates the future one year based on the supply forecast value information (FIG. 6), the current inventory quantity information (FIG. 7), and the arrangement quantity information whose arrangement quantity has been changed (FIG. 9). The inventory quantity of the parts X1 to X3 to be stored in each month of “January to December 2012” is calculated, and inventory quantity transition information (FIG. 8) indicating the inventory quantity of each month is acquired.

  In FIG. 8, the inventory quantity of the storage target parts X1 to X3 of “January 2012” is the inventory quantity of the current “December 2011” of the current inventory quantity information (FIG. 7) and the arrangement quantity information (FIG. 9). Is obtained by adding the order quantity of “January 2012” and subtracting the predicted value of the supply quantity of “January 2012” in the supply forecast value information (FIG. 6) from the added quantity.

  For example, the inventory quantity “200” (FIG. 8) of the storage target part X1 of “January 2012” is changed to the inventory quantity “170” (FIG. 7) of the part X1 of “December 2011” currently “ The order quantity “100” (FIG. 9) of the part X1 of “Month” is added, and the predicted value “70” of the supply quantity of the part X1 of “January 2012” is added from the added quantity “270” (FIG. 6). It is calculated by subtracting.

  In FIG. 8, the inventory quantity of the parts X1 to X3 to be stored for each month after “February 2012” is calculated by adding the arrangement quantity for the current month in the arrangement quantity information (FIG. 9) to the inventory quantity of the previous month, This is obtained by subtracting the predicted value of the supply quantity for the current month of the supply prediction value information (FIG. 6) from the added quantity.

  For example, the inventory quantity “360” (FIG. 8) of the storage target part X1 of “February 2012” is changed to “February 2012” of the inventory quantity “200” (FIG. 8) of the part X1 of “January 2012”. The order quantity “190” (FIG. 9) of the part X1 is added, and the predicted value “30” (FIG. 6) of the supply quantity of the part X1 “February 2012” is added from the added quantity “390”. It is calculated by subtracting.

  The necessary volume transition calculation unit 16 adds the packing status of the storage target parts X1 to X3 shown in the part master information (FIG. 2) to each stock quantity of the storage target parts X1 to X3 shown in the inventory quantity transition information (FIG. 8). The volume required for storage of each of the storage target parts X1 to X3 is calculated for each month of “January to December 2012” for one year in the future.

  Furthermore, the required volume transition calculation unit 16 adds the storage required volumes of the storage target parts X1 to X3 for each month of “January to December 2012” for the next year, thereby storing the storage target for each month. The necessary storage volume of the parts X1 to X3 is calculated, and necessary volume transition information (FIG. 10) indicating each calculated required storage volume is acquired.

In FIG. 10, for example, the required storage volume “288 m ³ ” of the storage target part X1 in “February 2012” is the inventory quantity “360” (FIG. 8) of the part X1 in “February 2012”. This is calculated by multiplying the volume of the packing form “0.8 m ³ ” (FIG. 2).

In FIG. 10, for example, the storage required volume “409 m ³ ” of the storage target parts X1 to X3 in “February 2012” is the storage required volume “288 m ³ ” of each of the parts X1 to X3 in “February 2012”. It is calculated by summing up “78 m ³ ” and “43 m ³ ”.

  The warehouse information storage unit 18 stores the warehouse information of FIG. The warehouse information indicates the storage capacity of each shelf constituting the storage space of the warehouse.

The volume difference calculation unit 20 adds up the storage volumes of the shelves “No. 1” to “No. 100” shown in the warehouse information of FIG. 11, so that the storage space volume “400 m ³ (= 2.0 m ³ +5). ^{.0m 3 + 6.0m 3 + 4.0m 3} ··· + 4.0m 3 + 3.0m 3 + 4.0m 3) "is calculated.

Further, the volume difference calculation unit 20 calculates the difference between the volumes obtained by subtracting the required storage volumes for each month shown in the required volume transition information (FIG. 10) from the storage space volume “400 m ³ ”. Volume difference information (FIG. 12) indicating the difference between the volumes is acquired. Furthermore, the volume difference calculation unit 20 determines whether there is a month in which the volume difference is negative using the volume difference information.

According to the volume difference information in FIG. 12, the volume difference “−9 m ³ ” is negative with the delivery date “February 2012” of the storage target part X1. For this reason, it is determined that there is a month in which the volume difference is negative. The difference between the volume "-9m ^3", from the volume of storage space "400m ^3", required storage volume "409m ^3" of the storage object parts X1~X3 of delivery "February 2012" by subtracting the (Figure 10) It is required. Note that the difference in volume is not necessarily negative in the month of delivery as described above. For example, when the arrangement quantity in other months is large (FIG. 9) and the supply value for other months is small (FIG. 6), the volume difference may be negative in other months.

  The inventory cost transition calculating unit 17 adds the unit price of the storage target parts X1 to X3 shown in the part master information (FIG. 2) to each stock quantity of the storage target parts X1 to X3 shown in the inventory quantity transition information (FIG. 8). By multiplying, the inventory cost of each of the storage target parts X1 to X3 in each month of “January to December 2012” for one year in the future is calculated.

  Next, the inventory cost transition calculation unit 17 sums the inventory costs of the storage target components X1 to X3 for each month of “January to December 2012” for the next year, thereby storing the storage target components for each month. Inventory costs X1 to X3 are calculated, and inventory cost transition information (FIG. 13) indicating the calculated inventory costs is acquired.

  In FIG. 13, for example, the inventory cost “54 million yen” of the storage target part X1 of “February 2012” is changed to the inventory quantity “360” (FIG. 8) of the part X1 of “February 2012”. It is calculated by multiplying the unit price “150,000 yen” (FIG. 2) of X1.

  In FIG. 13, for example, the inventory cost “11,890,000 yen” of the storage target parts X1 to X3 of “February 2012” is the inventory cost “5,5” of the parts X1 to X3 of “February 2012”. It is calculated by summing up “4 million yen”, “52 million yen”, and “12.9 million yen”.

  The inventory cost limit value information storage unit 19 stores the inventory cost limit value information of FIG. The inventory cost limit value information indicates the limit value of the inventory cost that can be spent in each month of “January to December 2012” for one year in the future.

  The inventory cost difference calculation unit 21 calculates the inventory cost transition information (see FIG. 14) from the limit value of the inventory cost indicated in the inventory cost limit value information (FIG. 14) for each month of “January to December 2012” for the next year. The difference of the inventory cost obtained by subtracting the inventory cost of the storage target parts X1 to X3 shown in 13) is calculated, and the inventory cost difference information (FIG. 15) indicating the difference of the inventory cost of each month is obtained. Further, the inventory cost difference calculation unit 21 determines whether there is a month in which the difference in inventory costs is negative using the inventory cost difference information.

  According to the inventory cost difference information in FIG. 15, the inventory cost difference “−31,000,000” is negative with the delivery date “March 2012” of the storage target part X2. For this reason, it is determined that there is a month in which the difference in inventory costs is negative. The difference in inventory cost “−31,000,000” is the storage target part X1 of the delivery date “March 2012” from the limit value “120,000,000 yen” (FIG. 14) of the inventory cost of the delivery date “March 2012”. This is obtained by subtracting the inventory cost of “12.31 million yen” (FIG. 13). Note that the difference in inventory costs is not necessarily negative in the month of delivery as described above. For example, when the other month's order quantity (Fig. 9) is large, the supply quantity forecast value in other months (Fig. 6) is small, and the limit value of inventory costs in other months (Fig. 14) is high, In other months, the difference in inventory costs can be negative.

  The processes of the average supply amount acquisition unit 23, the inventory period number calculation unit 24, and the information output unit 25 are executed when it is determined that there is a month in which the difference in volume or the difference in inventory cost is negative.

  The average supply amount obtaining unit 23, among the actual supply quantity values indicated in the actual supply value information (FIG. 5), provides the actual supply quantity values “X” and X2 indicated in the arrangement request information (FIG. 3). 70, 30, 120, 50,..., 80 ”and“ 30, 40, 20, 50,.

  Furthermore, the average supply amount acquisition unit 23 calculates an average value in units of the actual value of the specified supply quantity for each storage target component X1, X2. For the storage target part X1, the average value “60” is calculated from the calculation of “(70 + 30 + 120 + 50 +... +80) / 12”. For the storage target part X2, the average value “40” is calculated from the calculation of “(30 + 40 + 20 + 50 +... +40) / 12”.

  The inventory period number calculation unit 24 calculates the arrangement request information (FIG. 3) among the inventory quantities indicated in the inventory quantity transition information (FIG. 8) in response to the average values “60” and “40” of the supply quantities being calculated. ) And the inventory quantity “360” in the delivery date “February 2012” of the part X1 and the delivery date “March 2012” of the part X2 shown in the arrangement request information. Specify “160”.

  Further, the inventory period calculation unit 24 divides the specified inventory quantities “360” and “160” by the average values “60” and “40” calculated by the average supply amount acquisition unit 23 for each of the storage target parts X1 and X2. Calculate the number of inventory periods.

  For the storage target part X1, the number of inventory periods “6.0 months” is calculated from the calculation of “360/60”. This inventory period number “6.0 months” indicates that, in the delivery date “February 2012” of the storage target part X1, the part X1 is arranged so that the inventory quantity “360” of the part X1 becomes the supply quantity of the part X1. The average value of “60” is 6 times.

  For the storage target part X2, the number of inventory periods “4.0 months” is calculated from the calculation of “160/40”. The inventory period number “4.0 month” indicates that the inventory quantity “160” of the part X2 becomes the supply quantity of the part X2 by arranging the part X2 in the delivery date “March 2012” of the storage target part X2. The average value of “40” is four times as large.

  The information output unit 25 outputs the alarm information of FIG. 16 in response to the calculation of the inventory period number “6.0 months” and “4.0 months”. The alarm information includes arrangement request information, the number of inventory periods, excess volume information, and excess inventory cost information.

The excess volume information is output when it is determined that there is a month in which the difference in volume is negative. The excess volume information is a graph representing the transition of the storage required volume of the storage target parts X1 to X3 and the storage space volume “400 m ³ ” for the next year “January to December 2012”. The transition of the required storage volume for each month is output based on the required volume transition information (FIG. 10). The excess volume information indicates that the required storage volume of the storage target components X1 to X3 exceeds the storage space volume “400 m ³ ” on the delivery date “February 2012” of the component X1.

  The inventory cost excess information is output when it is determined that there is a month in which the difference in inventory costs is negative. The inventory cost excess information is a graph showing changes in inventory costs and limit values of the parts X1 to X3 to be stored in “January to December 2012” for the next year, and includes inventory cost transition information (FIG. 13) and inventory costs. It is output based on the limit value information (FIG. 14). The inventory cost excess information indicates that the inventory cost of the storage target parts X1 to X3 exceeds the limit value during the delivery date “March 2012” of the storage target part X2.

  The number of inventory periods is output for each of the storage target parts X1 and X2 indicated in the arrangement request information (FIG. 3). According to the example of FIG. 16, it can be understood that the inventory period number “6.0” of the storage target part X1 is larger than the inventory period number “4.0” of the storage target part X2.

  Next, an example of an operation performed by the information output apparatus 1 will be described with reference to the flowchart of FIG.

  First, the arrangement request information input unit 14 accepts input of arrangement request information (FIG. 3) (step S101).

  Next, the inventory quantity transition calculation unit 15 is the arrangement quantity of the storage target parts X1 and X2 shown in the arrangement request information (FIG. 3) among the arrangement quantities shown in the arrangement quantity information (FIG. 4). The arrangement quantity in the delivery date “February 2012” and “March 2012” shown in the information (FIG. 3) is specified (step S102).

  Next, the inventory quantity transition calculation unit 15 changes the arrangement quantity specified in step S102 to a quantity obtained by adding the requested quantities “50” and “20” shown in the arrangement request information (FIG. 3) (step S103).

  Next, the inventory quantity transition calculation unit 15 stores the monthly target for the next year based on the supply forecast value information (FIG. 6), the current inventory quantity information (FIG. 7), and the arranged quantity information (FIG. 9). The inventory quantity of the parts X1 to X3 is calculated, and inventory quantity transition information (FIG. 8) is acquired (step S104).

  Next, the required volume transition calculating unit 16 stores the monthly storage volume for each month in the next year based on the inventory quantity calculated in step S104 and the volume of the package shown in the parts master information (FIG. 2). The necessary storage volume of each of the parts X1 to X3 and the necessary storage volume of the parts to be stored X1 to X3 are calculated, and necessary volume transition information (FIG. 10) is acquired (step S105).

  The inventory cost transition calculating unit 17 calculates the storage target parts X1 to X3 for each month in the future for one year based on the inventory quantity of each month calculated in step S105 and the unit price indicated in the parts master information (FIG. 2). Each inventory cost and inventory cost of the parts X1 to X3 to be stored are calculated, and inventory cost transition information (FIG. 13) is acquired (step S106).

  The volume difference calculation unit 20 calculates the volume of the storage space based on the warehouse information of FIG. 11 (step S107).

  Further, the volume difference calculation unit 20 calculates the difference in volume for each month in the future year by subtracting the required storage volume for each month calculated in step S105 from the volume of the storage space calculated in step S107. (Step S108), it is determined whether there is a month in which the volume difference is negative (Step S109).

  The inventory cost difference calculation unit 21 subtracts the inventory cost of each month calculated in step S106 from the limit value of the inventory cost of each month shown in the inventory cost limit value information (FIG. 14), thereby calculating the month for the future year. A difference in inventory cost is calculated for each (step S110), and it is determined whether there is a month in which the difference in inventory cost is negative (step S111).

When it is determined in step S109 or S111 that there is a month in which the difference in volume or the difference in inventory cost is negative, the average supply amount acquisition unit 23 determines the supply quantity indicated in the supply result value information (FIG. 5). Among these, the actual value of the supply quantity of the storage target parts X1 and X2 shown in the arrangement request information (FIG. 3) is specified (step S112).

  Further, the average supply amount acquisition unit 23 calculates an average value in units of months of the actual value of the supply quantity specified in step S112 for each of the storage target parts X1 and X2 (step S113).

  Next, the inventory period calculation unit 24 is the inventory quantity of the storage target parts X1 and X2 indicated in the arrangement request information (FIG. 3) among the inventory quantities indicated in the inventory quantity transition information (FIG. 11). The inventory quantity at the delivery date indicated in the request information is specified (step S114).

  Further, the inventory period number calculation unit 24 calculates the inventory period number obtained by dividing the inventory quantity specified in step S114 by the average value calculated in step S113 for each of the storage target parts X1 and X2 (step S115). .

  Next, the information output unit 25 outputs arrangement request information input in step S101 and alarm information including the number of inventory periods calculated in step S115 (step S116).

  If it is determined in step S109 that there is a month in which the volume difference is negative, the information output unit 25 calculates the necessary volume transition information (FIG. 10) acquired in step S105 or in step S107. Based on the volume of the storage space, the volume excess information is further output.

  If it is determined in step S111 that there is a month in which the difference in inventory costs is negative, the information output unit 25 determines the inventory cost transition information (FIG. 13) acquired in step S106 and the inventory cost limit value. Based on the information (FIG. 14), the inventory cost excess information is further output.

  Next, the hardware configuration of the information output apparatus 1 will be described with reference to FIG. The information output device 1 includes a control unit 50, a storage unit 51, a display unit 52, and an operation unit 53.

  The control unit 50 is configured by a CPU (Central Processing Unit), and controls the operation of the information output apparatus 1 according to a program stored in the storage unit 51.

  The storage unit 51 includes a nonvolatile memory such as a flash memory, and a RAM (Random Access Memory). The storage unit 51 stores an operation program to be executed by the control unit 50 and various types of information. The storage unit 51 also functions as a work memory for the control unit 50. The parts master information storage unit 10, the arrangement quantity storage unit 11, the supply predicted value storage unit 12, the current inventory quantity storage unit 13, the warehouse information storage unit 18, the inventory cost limit value information storage unit 19, and the actual supply value storage unit 22 The storage unit 51 is configured.

  The display unit 52 includes a CRT (Cathode Ray Tube) or an LCD (Liquid Crystal Display). The display unit 52 displays various information such as arrangement request information, number of inventory periods, storage space volume, excess capacity information, and inventory cost excess information.

  The operation unit 53 includes keys, buttons, or a mouse for inputting various information. The person in charge can input various information such as arrangement request information using the operation unit 53.

  The processing of each unit shown in FIG. 1 is executed by the operation program using the control unit 50, the storage unit 51, the display unit 52, and the operation unit 53 as resources.

  According to the present embodiment, when arrangement request information (FIG. 3) indicating arrangement contents (delivery date, quantity, etc.) whose required storage volume exceeds the storage space is input, there is a month in which the volume difference becomes negative. Is determined, the excess volume information (FIG. 16) is output. As a result, the person in charge is notified that the required storage volume exceeds the storage space, so that it is urged to review the quantity and delivery date of the storage target parts X1, X2 arranged from the viewpoint of the storage space. Therefore, a situation where storage space is insufficient due to excessive inventory is prevented.

  Further, when arrangement request information indicating arrangement contents whose inventory cost exceeds the limit value is input, it is determined that there is a month in which the difference in inventory cost is negative, whereby inventory cost excess information (FIG. 16) is obtained. ) Is output. As a result, the person in charge is notified that the inventory cost exceeds the limit value, so that the quantity and delivery date of the storage target parts X1 and X2 arranged from the viewpoint of the inventory cost are urged. Therefore, it is possible to prevent a situation in which the inventory cost becomes excessive due to excessive inventory.

  Further, by outputting the number of inventory periods (FIG. 16), the person in charge of the storage target parts X1 whose stock quantity is excessive with respect to the supply quantity among the storage target parts X1 and X2 indicated in the arrangement request information. Can be grasped. For this reason, it is urged that the part X1 to be stored whose inventory amount is excessive is selected as a part whose order quantity is to be reduced. Therefore, it is possible to prevent immovable inventory from occurring.

  The present invention is not limited to the above-described embodiment, and various modifications can be made.

  For example, the arrangement request information (FIG. 3) may be automatically input by a system used to arrange the storage target parts X1 to X3.

  Moreover, arrangement quantity information (FIG. 4) and supply predicted value information (FIG. 6) may be omitted. In this case, the information output apparatus 1 stores in advance the stock quantity predicted value information shown in FIG. The inventory quantity prediction value information indicates the prediction value of the inventory quantity of the storage target parts X1 to X3 for each month in the future year.

  Then, the inventory quantity transition calculation unit 15, the required volume transition calculation unit 16, and the inventory cost transition calculation unit 17 use the inventory quantity predicted value information of FIG. 19 to store the parts X1 to X3 to be stored in each month for the next year. Inventory quantity, required storage capacity, and inventory cost. This will be specifically described below.

  In response to the input of the arrangement request information (FIG. 3), the inventory quantity transition calculating unit 15 indicates the arrangement request information (FIG. 3) out of the inventory quantities indicated in the inventory quantity predicted value information (FIG. 19). The stock quantity of the parts X1 and X2 to be stored, and the stock quantity in the month after the delivery date shown in the arrangement request information is specified.

  For the storage target part X1, the inventory quantity “310, 250, 270,..., 150” of the month “February to December 2012” after the delivery date “February 2012” is specified. For the storage target part X2, the inventory quantity “140, 130,..., 80” of the month “March to December 2012” after the delivery date “March 2012” is specified.

  Next, the inventory quantity transition calculating unit 15 changes the specified inventory quantity to a quantity obtained by adding the requested quantities “50” and “20” shown in the arrangement request information (FIG. 3). As a result, the stock quantity prediction value information is in the state shown in FIG.

  In the state of FIG. 20, the order quantity of “February to December 2012” of the storage target part X1 is changed to “360, 300, 320,..., 200” by adding the requested quantity “50”. Yes. In addition, the order quantity of “March to December 2012” of the storage target part X2 is changed to “160, 150,..., 100” by adding the requested quantity “20”.

  Then, the necessary volume transition calculating unit 16 adds the packing status of the storage target part indicated in the part master information (FIG. 2) to each stock quantity of the storage target parts X1 to X3 indicated in the inventory quantity predicted value information in FIG. By multiplying the volume, the storage required volume of each of the storage target parts X1 to X3 is calculated in each month of “January to December 2012” for one year in the future. Furthermore, the required volume transition calculation unit 16 calculates the storage required volume of the storage target parts X1 to X3 for each month by summing the storage required volumes of the storage target parts X1 to X3 for each month. As a result, the necessary volume transition information of FIG. 10 is obtained.

  Further, the inventory cost transition calculating unit 17 adds the storage target parts X1 to X3 shown in the part master information (FIG. 2) to each stock quantity of the storage target parts X1 to X3 shown in the stock quantity predicted value information of FIG. By multiplying the unit price, the inventory cost of each of the storage target parts X1 to X3 in each month for the next year is calculated. Further, the inventory cost transition calculating unit 17 calculates the inventory cost of the storage target parts X1 to X3 for each month by totaling the inventory costs of the storage target parts X1 to X3 for each month. As a result, the inventory cost transition information of FIG. 13 is obtained.

  Moreover, in the said embodiment, although the average value of supply amount was calculated using the actual value of supply amount shown by supply actual value information (FIG. 5), the method of acquiring the average value of supply quantity is this Not limited. For example, the average value of the supply amount may be calculated using the predicted value of the supply amount shown in the supply predicted value information (FIG. 6), or may be input by the person in charge.

  In the above embodiment, the number of inventory periods (FIG. 16) is output only for the month for delivery of the parts to be stored, but may be output for other months. By doing so, the person in charge can grasp the month in which the stock quantity is small relative to the supply quantity, and is therefore urged to reset the delivery date in the month in which the stock quantity is small.

  Further, the types of storage target parts in the storage space are not limited to the three types of storage target parts X1 to X3 shown in the above embodiment, and may be arbitrarily set. Further, the type, requested quantity, and delivery date of the parts to be stored shown in the arrangement request information (FIG. 3) are not limited to the number and date shown in the above embodiment, and can be arbitrarily set.

  Further, the part master information (FIG. 2) may not include the product name, model name, release year, and lead time of the parts to be stored, but may include only the part number, unit price, and packing volume.

  In the above embodiment, the data for one year is included in the arranged quantity information, the actual supply value information, the predicted supply value information, and the inventory cost limit value information. However, the data for any period including the delivery date is included. be able to.

  In the above embodiment, data such as arrangement quantity, supply quantity, inventory quantity, required storage volume, and inventory cost are shown in units of months. However, the period unit of the data is arbitrarily set according to the period unit of delivery date. Can be set. For example, when the delivery date is set on a daily basis, the period unit of the data can be set on a daily basis, weekly basis, monthly basis, and yearly basis.

  Further, the warehouse information may indicate the volume of the storage space (that is, the total storage volume of each shelf). In this case, the process in which the volume difference calculation part 20 totals the storage volume of each shelf is abbreviate | omitted.

  Further, the excess volume information and excess inventory cost information shown in FIG. 16 may indicate that the required storage volume exceeds the volume of the storage space or that the inventory cost exceeds the limit value by characters. In the case of a graph showing the transition of the required storage volume / inventory cost etc. as in the above embodiment, the person in charge has a reduced storage required volume and inventory cost as in “December 2012”. Since the period can be grasped, it is urged to reset the delivery date in the period.

  In addition, the means and method for performing various processes in the information output apparatus 1 of the present embodiment can be realized by either a dedicated hardware circuit or a programmed computer. The program may be provided by a computer-readable recording medium such as a flexible disk or a CD-ROM, or may be provided online via a network such as the Internet. In this case, the program recorded on the computer-readable recording medium is normally transmitted to and stored in a storage unit such as a hard disk. The program may be provided as a single application software, or may be incorporated into the software of the device as one function of the device.

  The present invention can be suitably used for correcting the quantity and delivery date of parts arranged from a parts supply base from the viewpoint of inventory cost and storage space volume.

1 Information output device
10 parts master information storage unit
11 Order quantity storage
12 Supply prediction value storage unit
13 Current inventory quantity storage
14 Arrangement request information input section
15 Inventory Quantity Trend Calculation Department
16 Required volume transition calculator
17 Inventory cost trend calculation part
18 Warehouse information storage
19 Inventory cost limit value information storage unit
20 Volume difference calculator
21 Inventory cost difference calculation part
22 Supply record value storage
23 Average supply volume acquisition unit
24 Inventory period calculation part
25 Information output section
50 Control unit
51 Storage unit
52 Display
53 Operation parts X1, X2, X3 Parts to be stored

Claims (4)

An arrangement request information input unit that accepts input of arrangement request information including arrangement quantity and delivery date of parts to be stored;
Based on the arrangement request information, an inventory quantity transition calculating unit that calculates an inventory quantity of parts to be stored for each unit period of the future period including the delivery date;
Based on the inventory quantity of each unit period calculated by the inventory quantity transition calculation unit and the volume of the package of the storage target part, the required storage volume required for storing the storage target part in each unit period A required volume transition calculating unit for calculating
Whether there is a unit period in which the difference in volume is negative by calculating a difference in volume obtained by subtracting the storage volume required for each unit period calculated by the required volume transition calculation unit from the volume of the storage space. A volume difference calculation unit for determining whether or not
An inventory cost transition calculation unit that calculates an inventory cost of the storage target part in each unit period based on the inventory quantity of each unit period calculated by the inventory quantity transition calculation unit and the unit price of the storage target part;
For each unit period, a difference in inventory cost is calculated by subtracting the inventory cost calculated by the inventory cost transition calculation unit from a limit value of inventory cost that can be spent in the unit period. An inventory cost difference calculation unit that determines whether or not there is a unit period for which
When it is determined that there is the unit period in which the difference in volume is negative, excess volume information indicating that the required storage volume exceeds the volume of the storage space is output, and the difference in inventory cost becomes negative When it is determined that the unit period is present, an information output unit that outputs inventory cost excess information indicating that the inventory cost exceeds the limit value; and
An information output device comprising: When it is determined that there is the unit period in which the difference in volume or the difference in inventory cost is negative, the storage target parts indicated in the arrangement request information per unit period of the quantity supplied to the outside from the storage space An average supply amount calculation unit for obtaining an average value of
Among the inventory quantities calculated by the inventory quantity transition calculation unit, the inventory quantity of the storage target part indicated in the arrangement request information is specified, and the inventory quantity in the delivery date indicated in the arrangement request information is specified, An inventory period number calculation unit for calculating an inventory period number obtained by dividing the inventory quantity obtained by the average value;
Further comprising
The information output device according to claim 1, wherein the information output unit outputs the number of inventory periods. Arrangement request information input stage for accepting input of arrangement request information including arrangement quantity and delivery date of parts to be stored;
Based on the arrangement request information, an inventory quantity transition calculating step for calculating an inventory quantity of parts to be stored for each unit period of the future period including the delivery date;
Based on the inventory quantity of each unit period calculated in the inventory quantity transition calculation step and the volume of the package of the storage target part, the storage requirement required for storing the storage target part in each unit period A necessary volume transition calculation stage for calculating the volume;
Whether there is a unit period in which the difference in volume is negative by calculating the volume difference obtained by subtracting the storage required volume for each unit period calculated in the required volume transition calculation step from the volume of the storage space. A volume difference calculation stage for determining whether or not;
An inventory cost transition calculation stage for calculating an inventory cost of the storage target part in each unit period based on the inventory quantity of each unit period calculated in the inventory quantity transition calculation stage and the unit price of the storage target part; ,
For each unit period, a difference in inventory cost obtained by subtracting the inventory cost calculated in the inventory cost transition calculation stage from a limit value of the inventory cost that can be spent in the unit period is calculated. Inventory cost difference calculation stage for determining whether or not there is the unit period in which the difference is negative;
When it is determined that there is the unit period in which the difference in volume is negative, excess volume information indicating that the required storage volume exceeds the volume of the storage space is output, and the difference in inventory cost becomes negative When it is determined that the unit period is present, an information output step of outputting inventory cost excess information indicating that the inventory cost exceeds the limit value;
An information output method comprising: Computer
An arrangement request information input unit that accepts input of arrangement request information including the arrangement quantity and delivery date of the parts to be stored,
Based on the arrangement request information, an inventory quantity transition calculating unit that calculates an inventory quantity of parts to be stored for each unit period of the future period including the delivery date;
Based on the inventory quantity of each unit period calculated by the inventory quantity transition calculation unit and the volume of the package of the storage target part, the required storage volume required for storing the storage target part in each unit period Required volume transition calculation unit for calculating
Whether there is a unit period in which the difference in volume is negative by calculating a difference in volume obtained by subtracting the storage volume required for each unit period calculated by the required volume transition calculation unit from the volume of the storage space. A volume difference calculation unit for determining whether
An inventory cost transition calculation unit that calculates an inventory cost of the storage target part in each unit period based on the inventory quantity of each unit period calculated by the inventory quantity transition calculation unit and the unit price of the storage target part;
For each unit period, a difference in inventory cost is calculated by subtracting the inventory cost calculated by the inventory cost transition calculation unit from a limit value of inventory cost that can be spent in the unit period. Inventory cost difference calculation unit for determining whether or not there is a unit period for which
When it is determined that there is the unit period in which the difference in volume is negative, excess volume information indicating that the required storage volume exceeds the volume of the storage space is output, and the difference in inventory cost becomes negative When it is determined that the unit period is present, an information output unit that outputs inventory cost excess information indicating that the inventory cost exceeds the limit value;
Program to function as.

Images