JP2007257272A - Cost information providing program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a cost information providing program capable of promoting proper business activities by making a person in charge of business be conscious of the existence of cast that fluctuates according to an order receiving condition. <P>SOLUTION: A computer is made to perform: an input procedure for inputting at least the number of shipments and the shipping date of a product; an acquiring procedure for acquiring a date when profit becomes zero on the basis of stock maintenance cost of the product; a determination procedure for determining that the stock maintenance cost of the product takes priority over subdivision work cost when the number of days between the shipping date and the date when the profit becomes zero is within a predetermined range and that the subdivision work cost takes priority over the stock maintenance cost when the number of days exceeds the predetermined range; and a display procedure for displaying a determination result in the determination procedure. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a cost information providing program, and more particularly to a cost information providing program that causes a computer to provide information related to the cost of a product.

Patent Document 1 acquires the article unit price of the object to be estimated, transportation means information, packaging secondary material information, secondary material price, logistics cost per article, packaging work cost per shipping unit, etc. Although it is stated that the secondary materials costs are divided into goods price, transportation cost unit price, packing work cost, total cost, etc. for each transportation route, the estimated result is displayed, but how much cost depends on the order conditions during sales activities The sales department generally has a strong concept of sales supremacy, and it is important to ensure that the ordered products are delivered by the delivery date. Business negotiations with customers are conducted with a close eye. Therefore, the number of products to be delivered and the delivery time are in accordance with the customer's request, and it is often prioritized to establish a business negotiation first.
JP 2004-231247 A

  However, the quantity to be delivered (shipment quantity) and the delivery date have an influence on the cost of shipping work in the distribution warehouse (shipment cost) and the cost that increases due to the inventory storage period (inventory cost), resulting in fluctuations in profit. It becomes.

  For example, when the product is a semiconductor chip, in a distribution warehouse, a plurality of chips (for example, 100 chips) are placed on one tray and vacuum packed in units of the tray. Furthermore, a plurality of trays are packed and stored in one case. For example, if it is necessary to ship a shipment quantity that is less than the tray unit (for example, 50), open the vacuum-packed tray, take out 50 of the trays, and vacuum-pack the rest. A troublesome work that must be corrected is required, increasing the shipping cost. On the other hand, if the shipment quantity is a tray unit, it is only necessary to open the case, and if the shipment unit is the case, the case can be shipped as it is, and the shipping cost can be suppressed.

  Also, the inventory cost can be kept lower as soon as the delivery date is earlier if there is an inventory for the ordered product.

  In particular, when the product to be handled is a semiconductor chip, it takes about two to three months before the semiconductor chip can be shipped as a product. Sales activities are carried out with various risks depending on the delivery conditions and purchase conditions from customers. Therefore, it is considered that if the sales staff can raise awareness about the above-mentioned costs and accurately grasp the size of the above-mentioned costs, they can conduct more appropriate sales activities. .

  The present invention has been made in view of the above points, and provides a cost information providing program that allows salespeople to be aware of the existence of costs that fluctuate depending on order conditions and promotes appropriate sales activities. Objective.

  Therefore, in order to solve the above problems, the present invention has an input procedure for causing a computer to input at least the number of products shipped and a shipping date, an acquisition procedure for acquiring a date when the profit becomes zero due to the inventory maintenance cost of the product, When the number of days between the shipping date and the date when the profit becomes zero is within a predetermined range, the stock maintenance cost of the product is given priority over the subdivision work cost, and when it exceeds the predetermined range A determination procedure for determining to give priority to the subdivision work cost over the inventory maintenance cost and a display procedure for displaying a determination result in the preceding determination procedure are executed.

  In such a cost information providing program, it is possible to make sales representatives aware of the existence of a cost that fluctuates depending on order conditions, and to promote appropriate sales activities.

  According to the present invention, it is possible to provide a cost information providing program that can make a sales person aware of the existence of a cost that fluctuates depending on order conditions and promote appropriate sales activities.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a diagram illustrating a configuration example of a cost simulation system according to an embodiment of the present invention. In FIG. 1, a cost simulation system 1 includes a cost simulation server 10, a simulation terminal 20, a data input terminal 30, and the like. These are connected by, for example, a company intranet or the Internet.

  The cost simulation server 10 is a computer on which a function for simulating a cost corresponding to an order condition is implemented for a product that has received an order. The function includes a data editing processing unit 11, a cost simulation unit 12, and a subdivision table 13. , An inventory maintenance cost table 14, an expense table 15, various master tables 16, a sales price table 17, a cost expense table 18, and the like.

  The data editing processing unit 11 displays information input from the data input terminal 30, inventory information in a distribution warehouse acquired from the warehouse management system 2, etc., results obtained by performing a predetermined calculation based on these information, etc. Register in the table. The warehouse management system 2 is a well-known system for managing various information of the distribution warehouse. For example, when a product is received and when it is shipped, how much is in stock, the cost of each product, the procurement cost, Information such as arrival and inspection work cost, storage period, etc. is managed in the inventory DB 210, the warehouse work performance DB 220, and the like.

  The cost simulation processing unit 12 simulates the cost according to the order receiving condition based on each table and the order receiving condition of the product input from the simulation terminal 20 and displays the result on the simulation terminal 20. Details of each table will be described later.

  The data input terminal 20 is a terminal such as a PC (Personal Computer) used for inputting various data used by the cost simulation server 10 for cost simulation.

  The simulation terminal 20 is a terminal such as a PC (Personal Computer) used for inputting order conditions and causing the cost simulation server 10 to execute a cost simulation in response to the input. The simulation terminal 20 may be used by a sales person in an actual business meeting. From such a viewpoint, for example, a notebook PC, a PDA (Personal Digital Assistance), a mobile phone, or the like may be used.

  Next, details of the cost simulation server 10 will be described. FIG. 2 is a diagram illustrating a hardware configuration example of the cost simulation server according to the embodiment of the present invention. The cost simulation server 10 in FIG. 2 includes a drive device 100, an auxiliary storage device 102, a memory device 103, an arithmetic processing device 104, and an interface device 105 that are connected to each other via a bus B. Is done.

  A program that realizes processing in the cost simulation server 10 is provided by a recording medium 101 such as a CD-ROM. When the recording medium 101 on which the program is recorded is set in the drive device 100, the program is installed from the recording medium 101 to the auxiliary storage device 102 via the drive device 100.

  The auxiliary storage device 102 stores the installed program and also stores necessary files and data. For example, the auxiliary storage device 102 stores various tables, which will be described later, necessary for processing the program.

  The memory device 103 reads the program from the auxiliary storage device 102 and stores it when there is an instruction to start the program. The arithmetic processing unit 104 executes a function related to the cost simulation server 10 according to a program stored in the memory device 103. The interface device 105 is used as an interface for connecting to a network.

  By the way, in this embodiment, a semiconductor chip is assumed as a product. However, this does not mean that the present invention is limited to semiconductor chips. In addition, the information simulated according to the order conditions in this embodiment includes a subdivision work cost and an inventory maintenance cost (inventory maintenance cost).

  The subdivision work cost is the cost required for the subdivision work required when shipping semiconductor chips from a distribution warehouse. Generally, in a distribution warehouse, a predetermined number (for example, 100) of semiconductor chips are placed on one tray as a unit, and the trays are vacuum-packed and managed. Further, a plurality of trays are stored in one case. The subdivision operation refers to an operation for taking out a product from a case or a tray or vacuum-packing a product remaining in the tray according to a shipment quantity. As is clear from such a storage form of semiconductor chips, the subdivision work cost increases in the order in which the shipment quantity is in a case unit, in the case of a tray unit, and when a fraction less than the tray unit is generated. . Note that the number of products placed on one tray and the number of trays stored in one case differ depending on the product.

  On the other hand, the inventory maintenance cost refers to a cost caused by inventory storage itself. Therefore, the longer the storage period after the product arrives at the distribution warehouse, the larger the storage period, and eventually the profit becomes zero or negative.

Next, the transition of the screen displayed on the simulation terminal 20 will be described.
For example, when a user such as a sales representative logs in to the cost simulation system 1 via the simulation terminal 20, a screen as shown in FIG. 3 is displayed. In addition, the said operation | work by a user may be performed in the said user's workplace, and may be performed in the field of an actual negotiation, ie, a customer.

  FIG. 3 is a diagram illustrating a display example of an initial state of the cost simulation screen. In FIG. 3, the cost simulation screen 210 includes a delivery destination input area 211, a product code input area 212, a shipment date input area 213, a shipment quantity input area 214, an ideal shipment amount display area 215, a cost priority display area 216, and a profit. It has a zero day display area 217 and the like.

  A delivery destination input area 211, a product code input area 212, a shipment date input area 213, and a shipment quantity input area 214 are areas for inputting order conditions, an ideal shipment amount display area 215, and a cost priority display area 216. The profit zero day display area 217 is an area for displaying the result of the cost simulation. In the area 219, the current date (for example, the current date (“2005.9.01”) when the user uses the cost simulation system 1) that displays the cost simulation screen 210 is displayed. .

  Based on the negotiation with the customer, the user identifies each of the delivery destination identification number (“N001”) in the delivery destination input area 211, the product code input area 212, the shipment date input area 213, and the shipment quantity input area 214, Enter the product code (“S11111”) of the ordered product, the shipping date (“2005.10.1”) of the ordered product, the number of shipments (“50”), and press (or click) the “ENTER” button 218. The cost simulation result is displayed in the ideal shipment amount display area 215, the cost priority display area 216, and the zero profit day display area 217.

  FIG. 4 is a diagram illustrating a display example of the simulation result on the cost simulation screen. 4, the same parts as those in FIG. 3 are denoted by the same reference numerals.

  In the cost simulation screen 210 of FIG. 4, the ideal shipment quantity display area 215 displays an ideal shipment quantity of a product related to the product code “S11111” (hereinafter referred to as “product S11111”). The ideal shipment quantity here is an ideal shipment quantity from the viewpoint of the subdivision work cost. As described above, the subdivision work cost is kept low in the case unit or tray unit of the product. Therefore, the ideal shipment amount display area 215 displays the quantity (“1000”) of one case and the quantity (“100”) of one tray of the product relating to the product code “S11111”.

  In the cost priority display area 216, it is displayed which of the inventory maintenance cost and the subdivision work cost should be prioritized from the viewpoint of obtaining a larger profit in the current stage (2005.9.01) negotiation. Yes. In FIG. 4, inventory maintenance cost is displayed as priority 1, and subdivision work cost is displayed as priority 2. This indicates that the inventory maintenance cost should be given priority.

  In addition, the zero profit day display area 217 displays the date (“2005.10.14”) when the profit of the product S11111 becomes zero from the viewpoint of inventory maintenance cost.

  For example, as shown in FIG. 4, when it is displayed in the cost priority order display area 216 that priority should be given to the inventory maintenance cost, when the user wants to obtain more detailed information regarding the inventory maintenance cost, the user presses the button 222. By pressing, the inventory cost screen can be displayed.

  FIG. 5 is a diagram illustrating a display example of the inventory cost screen. On the inventory cost screen 230 in FIG. 5, a graph 232 is displayed in which the horizontal axis indicates the date (time) and the vertical axis indicates the amount of money. On the graph 232, a straight line 2321 indicates a cost (hereinafter referred to as “total cost”) in consideration (total) of the cost expense and the inventory maintenance cost. Since the inventory maintenance cost increases with time, the total cost is a straight line going up to the right. A broken line 2322 indicates a cost and a broken line 2323 indicates a selling price. A broken line 2324 indicates the shipping date of the product. Further, a broken line 2325 indicates a day when the selling price and the total cost coincide, that is, a day when the profit becomes zero.

  In the area 231 of the inventory cost screen 230, the order conditions (product code, delivery destination, shipping date) input or displayed on the cost simulation screen 210 and a part of the simulation result (the date when the profit becomes zero) are displayed. ) Is displayed.

  In the region 233, the display period of the graph 232 can be changed by changing the start date and the end date of the display period of the graph 232.

  The cost simulation screen 210 notifies that the stock maintenance cost should be prioritized, and the user who refers to the stock cost screen 230 confirms that the profit will be zero if it is not shipped by October 14th. Therefore, it is possible to determine that the negotiation should be advanced so that the shipment can be surely performed before October 14 rather than the reduction of the subdivision work cost. It is also possible to negotiate with the customer whether the shipping date can be further advanced.

  On the other hand, when it is displayed as a cost simulation result that priority should be given to the subdivision work cost in the cost priority display area 216 of the cost simulation screen 210 in FIG. The user can display a subdivision screen by pressing the button 221.

  FIG. 6 is a diagram illustrating a display example of the subdivision screen. As shown in FIG. 6, a table 242 and a table 243 are displayed on the subdivision screen 240.

  Table 242 is information displayed as a reference. For each shipment quantity (in FIG. 6, one, 20, 30, 50, 70, 80, 99, 100 (tray unit), 1000 For each piece (in units of cases), the inventory maintenance cost (stock cost), subdivision work cost (subdivision) and expenses when the shipping date is in accordance with the order conditions, the total value shown on the left, and the cost per product ( The total value shown on the left is divided by the quantity).

  Table 243 displays inventory maintenance cost (inventory cost), subdivision work cost (subdivision), expenses, total value shown on the left, and cost per product in the case of the number of shipments (55) in the order conditions. Has been.

  In the subdivision screen 240, the area 241 includes an order condition (product code, delivery destination, shipment date, number of shipments) or a part of the simulation result (zero profit) input or displayed on the cost simulation screen 210. Is displayed).

  In the area 241, the display contents of the table 243 can be changed by changing the shipment date and the number of shipments.

  The cost simulation screen 210 informs the user that the subdivision work cost should be prioritized, and the user who refers to the subdivision screen 240 should proceed with the negotiation so that the subdivision work cost is reduced as much as possible rather than the reduction of the inventory maintenance cost. It can be determined that there is. Therefore, for example, a quantity (for example, 30 pieces or 70 pieces) whose “one piece cost” is smaller than that of the current order condition of 55 pieces is derived with reference to the table 242, and the quantity is negotiated as the number of shipments. Furthermore, it is possible to negotiate shipments in tray units or case units (ie, packing units).

  Hereinafter, a processing procedure executed in the cost simulation system 1 in order to realize the screen transition described in FIGS. 3, 4, 5, and 6 will be described.

  FIG. 7 is a first flowchart for explaining the processing procedure of the cost simulation system. In FIG. 7, the process executed at the time of transition from FIG. 3 to FIG. 4 will be described.

  When the user logs in to the cost simulation system 1 from the simulation terminal 20, the cost simulation processing unit 12 of the cost simulation server 10 displays the cost simulation screen 210 on the simulation terminal 20 (S101). In the displayed cost simulation screen 210, when the user inputs order conditions including a delivery destination, a product code, a shipping date, and the number of shipments, and clicks the “ENTER” button 218 (S102), the simulation terminal 20 The input order conditions are transmitted to the cost simulation processing unit 12.

  When the order receiving condition is received from the simulation terminal 20, the cost simulation processing unit 12 executes the processes after step S103 based on the order receiving condition.

  First, the quantity for one case and the quantity for one tray are acquired from the subdivision table 13 (S103, S104).

  FIG. 8 is a diagram illustrating a configuration example of the subdivision table. As shown in FIG. 8, in the subdivision table 13, information such as a shipment unit, a product quantity, and a single cost is registered for each product specified by the product code. These pieces of information are registered by the warehouse management system 2.

  The shipping unit takes one of a case, a tray, or a fraction. Here, the fraction means a quantity less than the tray unit. The product quantity indicates the quantity of the product corresponding to each shipping unit. One piece cost indicates a subdivision work cost per one product corresponding to each shipping unit. As for the fraction, since the cost differs depending on the value, a plurality of records are registered. In FIG. 8, only information related to the product S11111 is displayed for the sake of convenience, but actually information related to other products is also registered.

  Therefore, in steps S103 and S104, the product quantity corresponding to the case and tray as the shipping unit is acquired from the subdivision table 13. The value acquired here is displayed in the ideal shipment amount display area 215 of the cost simulation screen 210 in step S110 described later.

  Subsequently, the date when the profit of the ordered product becomes zero (zero profit day) is acquired from the inventory maintenance cost table 14 (S105).

  FIG. 9 is a diagram illustrating a configuration example of the inventory maintenance cost table. As shown in FIG. 9, in the inventory maintenance cost table 13, information such as the arrival date, the zero profit date, the one day cost, the inventory quantity, and the initial profit is registered for each product specified by the product code. Yes. These pieces of information are registered by the warehouse management system 2.

  The arrival date is the date when the product arrives at the distribution warehouse. The zero profit day is a day when the profit becomes zero due to an increase in inventory maintenance cost generated from the arrival date. The daily cost is the inventory maintenance cost per day. The inventory quantity is the inventory quantity of products in the distribution warehouse. The initial profit is a profit obtained when the product can be shipped on the arrival date, that is, a profit obtained when the inventory maintenance cost is zero. In FIG. 9, only information related to the product S11111 is displayed for convenience, but information related to other products is actually registered.

  Therefore, in step S105, the zero profit day in the record relating to the ordered product is acquired from the inventory maintenance cost table 14.

  Subsequently, it is determined whether or not the difference between the shipping date input as the order receiving condition and the profit zero day of the ordered product is equal to or less than a predetermined threshold (for example, two months or 60 days) (S106). This determination is to check whether or not there is a certain margin for the shipping date in the order receiving condition until the profit zero day of the ordered product. Note that the predetermined threshold may be determined based on past results or the like, and may be arbitrarily changed by the user.

  If the difference is within the predetermined threshold (Yes in S106), that is, if there are not many days from the shipment date to the zero profit date, it is determined that the inventory maintenance cost should be given priority over the subdivision work cost. (S107).

  On the other hand, if the difference is larger than the predetermined threshold (No in S106), that is, if there is some margin from the shipment date to zero profit, the number of shipments as an order condition is in case units or tray units Is determined (S108). If the number of shipments is neither a case unit nor a tray unit, that is, if the number of shipments is a fraction (Yes in S108), it is determined that the subdivision work cost should be prioritized over the inventory maintenance cost (S109). On the other hand, if the number of shipments is either a case unit or a tray unit (No in S108), it is determined that the inventory maintenance cost should be prioritized because the subdivision work cost can be kept low (S107).

  Subsequent to step S107 or step S109, the result obtained or determined in the above step is displayed on the cost simulation screen 210. That is, the quantity for one case and the quantity for one tray of the ordered products obtained from the table are displayed in the ideal shipment amount display area 215 and the zero profit day is displayed in the zero profit day display area 217, and the cost priority is set to the cost priority. It is displayed in the rank display area 216. As a result, the cost simulation screen 210 is in the state shown in FIG.

  Next, a processing procedure executed when the button 222 is pressed on the cost simulation screen 210 shown in FIG. 4 at the transition from the cost simulation screen 210 shown in FIG. 4 to the inventory cost screen 230 shown in FIG. explain.

  FIG. 10 is a second flowchart for explaining the processing procedure of the cost simulation system.

  When the button 222 is pressed on the cost simulation screen 210 shown in FIG. 4, the cost simulation unit 12 is notified of this fact, and the cost simulation unit 12 executes the processing after step S <b> 201.

  First, the sales price of the ordered product is acquired from the sales price table 17 (S201). The sales price acquired here is used to display a broken line 2323 indicating the sales price in the graph 232 of the inventory cost screen 230. Although a configuration example of the sales price table 17 is not illustrated, a sales price is registered for each product code.

  Subsequently, the cost expense per order product is obtained from the cost expense table 18 (S202). The cost expense acquired here is used to display a broken line 2322 indicating the cost expense in the graph 232 of the inventory cost screen 230. Although a configuration example of the sales price table 17 is not shown, cost expenses are registered for each product code.

  Subsequently, from the inventory maintenance cost table 14 shown in FIG. 9, the daily inventory maintenance cost of one ordered product is acquired (S203), and each day in a predetermined period (for example, one month) before and after the shipment date. Inventory maintenance costs corresponding to the number of shipments are calculated (S204). The inventory maintenance cost is calculated by the following formula, for example.

Inventory maintenance cost for the number of shipments on each day = inventory maintenance cost per product per day x number of shipments x number of days from the current date Therefore, the arrival date is May 1 and the inventory per product per day If the maintenance cost is 5 yen and the number of shipments is 55, the inventory maintenance cost for the shipments on September 1 is
5 × 55 × 1 = 275 (yen).

  The same calculation is performed for other days.

  Subsequently, the total cost corresponding to the number of shipments of the ordered product on each day in a predetermined period before and after the shipment date is calculated (S205). The total cost is calculated by adding the inventory maintenance cost calculated in step S204 to the cost expense acquired in step S202 multiplied by the number of shipments. The total cost calculated here is used to display a straight line 2321 indicating the total cost in the graph 232 of the inventory cost screen 230.

  Subsequently, based on the value calculated above, the inventory cost screen 230 is displayed on the simulation terminal 20 as shown in FIG. 5 (S206).

  Next, a description will be given of the processing procedure executed when the cost simulation screen 210 in FIG. 4 transitions to the subdivision screen 240 in FIG. 6, that is, when the button 221 is pressed on the cost simulation screen 210 shown in FIG. To do.

  FIG. 11 is a third flowchart for explaining the processing procedure of the cost simulation system.

  When the button 221 is pressed on the cost simulation screen 210 shown in FIG. 4, the fact is notified to the cost simulation unit 12, and the cost simulation unit 12 executes the processing after step S <b> 301.

First, the inventory maintenance cost for each quantity displayed in the tables 242 and 243 of the subdivision screen 240 is calculated (S301). The inventory maintenance cost is
It can be calculated by the inventory storage period (the number of days from the arrival date to the shipping date) × the inventory maintenance cost per product × the quantity.

For example, when the inventory maintenance cost is calculated when the ordered product is the product S11111, the shipping date is October 1, 2005, and the number of shipments is one case (1000 pieces), the product is calculated from the inventory maintenance cost table 14 of FIG. The arrival date of this product is May 1, 2005 (ie, the stock storage period is 154 days), and the daily inventory maintenance cost of the product is 5 yen,
It becomes 154 * 5 * 1000 = 770,000 yen.

In the case of the order quantity (55 pieces) displayed in Table 243,
154 × 5 × 55 = 42350 yen.

Subsequently, the subdivision work cost for each quantity displayed in the tables 242 and 243 of the subdivision screen 240 is calculated based on the subdivision table 13 of FIG. 8 (S302). The subdivision work cost is
It can be calculated by the quantity x subdivision work cost per product.

For example, when the subdivision work cost is calculated when the ordered product is the product S11111 and the number of shipments is one case (1000 pieces), the subdivision work cost per piece when the shipment unit is one case is 20 from the subdivision table 13. Because it is a circle,
1000 × 20 = 20000 yen.

In the case of the order quantity (55 pieces) displayed in the table 243, the subdivision work cost per piece is 50 yen from the subdivision table 13.
55 × 50 = 2750 yen.

  Subsequently, the expense for each quantity displayed in the table 242 and the table 243 of the subdivision screen 240 is calculated based on the expense table 15.

  FIG. 12 is a diagram illustrating a configuration example of the expense table. As shown in FIG. 12, the expense table 15 registers the expense per product for each combination of product code and delivery destination. The reason why the expenses differ depending on the delivery destination even for the same product is because, for example, the shipping conditions (necessity of labeling on the product, etc.) differ depending on the delivery destination.

The expense is
It can be calculated by the quantity × cost per product.

For example, when the order product is the product S11111, the delivery destination is N001, and the number of shipments is 1 case (1000 pieces),
1000 × 50 = 50,000 yen.

In the case of the order quantity (55 pieces) displayed in Table 243,
55 × 50 = 2750 yen.

  Subsequently, the total value of the inventory maintenance cost, the subdivision work cost, and the expense for each quantity displayed in the tables 242 and 243 of the subdivision screen 240 is calculated (S304), and the total value per product is calculated. (S305).

For example, when the ordered product is the product S11111, the delivery destination is N001, and the number of shipments is 1 case (1000 pieces), the total value is
It becomes 770000 + 20000 + 50000 = 840000 yen.

Therefore, the total value per product is
It becomes 840000 ÷ 10000 = 840 yen.

In addition, in the case of the order quantity (55 pieces) displayed in the table 243, the total value is
42350 + 2750 + 2750 = 47850 yen.

Therefore, the total value per product is
47850 yen ÷ 55 = 870 yen.

  Subsequently, the subdivision screen 240 is displayed on the simulation terminal 20, and the respective values calculated above are displayed on the table 242 or the table 243 (S306).

  As described above, according to the cost simulation system 1 according to the embodiment of the present invention, the salesperson can grasp that the profit varies depending on the sales method, so that the salesperson's cost awareness is improved. In addition, it is possible to provide a judgment material for changing the sales method. Therefore, it is possible to carry out appropriate price negotiations in consideration of costs during business negotiations with customers.

  In addition, by having the sales department recognize that the cost fluctuates depending on the order conditions, it can be expected to improve the motivation of the logistics department.

  As mentioned above, although the Example of this invention was explained in full detail, this invention is not limited to the specific embodiment which concerns, In the range of the summary of this invention described in the claim, various deformation | transformation * It can be changed.

Regarding the above description, the following items are further disclosed.
(Appendix 1)
On the computer,
An input procedure for inputting at least the number of products shipped and the date of shipment;
An acquisition procedure for acquiring a day when the profit becomes zero due to the inventory maintenance cost of the product;
When the number of days between the shipping date and the date when the profit becomes zero is within a predetermined range, the stock maintenance cost of the product is given priority over the subdivision work cost, and when it exceeds the predetermined range A determination procedure for determining to prioritize the subdivision work cost over the inventory maintenance cost;
A cost information providing program for executing a display procedure for displaying a judgment result in the preceding judgment procedure.
(Appendix 2)
The determination procedure is characterized in that even if the number of days exceeds the predetermined range, it is determined to prioritize the inventory maintenance cost when the number of shipments matches a unit of packaging of the product. The cost information providing program according to appendix 1.
(Appendix 3)
A calculation procedure for calculating an amount per cost of the product including at least the inventory maintenance cost and the subdivision work cost for each predetermined quantity;
The information providing program according to claim 1 or 2, further comprising: a second display procedure for displaying the amount calculated in the calculation procedure for each of the predetermined quantities.
(Appendix 4)
An inventory maintenance cost acquisition procedure for acquiring a daily inventory maintenance cost of the product;
A second calculation procedure for calculating a value of a cost including an inventory maintenance cost for each day in a predetermined period before and after the shipment date, based on a daily inventory maintenance cost of the product;
A third display procedure for displaying a relationship between the cost including the inventory maintenance cost for each day calculated in the second calculation procedure, the shipping date, and the date when the profit becomes zero. The information providing program according to any one of Supplementary notes 1 to 3, which is characterized by the following.
(Appendix 5)
A computer-readable recording medium on which the information providing program according to any one of appendices 1 to 4 is recorded.
(Appendix 6)
Input means for inputting at least the number of products shipped and the date of shipment;
An acquisition means for acquiring a day when the profit becomes zero due to an inventory maintenance cost of the product;
When the number of days between the shipping date and the date when the profit becomes zero is within a predetermined range, the stock maintenance cost of the product is given priority over the subdivision work cost, and when it exceeds the predetermined range A determination means for determining to prioritize the subdivision work cost over the inventory maintenance cost;
A cost information providing apparatus comprising: a display unit configured to display a determination result obtained by the preceding determination unit.
(Appendix 7)
A cost information providing method executed by a computer,
An input procedure for inputting at least the number of products shipped and the date of shipment;
An acquisition procedure for acquiring a day when the profit becomes zero due to the inventory maintenance cost of the product;
When the number of days between the shipping date and the date when the profit becomes zero is within a predetermined range, the stock maintenance cost of the product is given priority over the subdivision work cost, and when it exceeds the predetermined range A determination procedure for determining to prioritize the subdivision work cost over the inventory maintenance cost;
A cost information providing method comprising: a display procedure for displaying a judgment result in the pre-judgment judgment procedure.

It is a figure which shows the structural example of the cost simulation system in embodiment of this invention. It is a figure which shows the hardware structural example of the cost simulation server in embodiment of this invention. It is a figure which shows the example of a display of the initial state of a cost simulation screen. It is a figure which shows the example of a display of the simulation result in a cost simulation screen. It is a figure which shows the example of a display of an inventory cost screen. It is a figure which shows the example of a display of a subdivision screen. It is a 1st flowchart for demonstrating the process sequence of a cost simulation system. It is a figure which shows the structural example of a subdivision table. It is a figure which shows the structural example of an inventory maintenance cost table. It is a 2nd flowchart for demonstrating the process sequence of a cost simulation system. It is a 3rd flowchart for demonstrating the process sequence of a cost simulation system. It is a figure which shows the structural example of an expense table.

Explanation of symbols

1 Cost simulation system 2 Warehouse management system 10 Cost simulation server 10
11 Data editing processing unit 12 Cost simulation unit 13 Subdivision table 14 Inventory maintenance cost table 15 Expense table 16 Various master tables 16
17 Sales Price Table 18 Cost Expense Table 20 Simulation Terminal 100 Drive Device 101 Recording Medium 102 Auxiliary Storage Device 103 Memory Device 104 Arithmetic Processing Device 105 Interface Device 210 Inventory DB
220 Warehouse work results DB
B bus

Claims (3)

On the computer,
An input procedure for inputting at least the number of products shipped and the date of shipment;
An acquisition procedure for acquiring a day when the profit becomes zero due to the inventory maintenance cost of the product;
When the number of days between the shipping date and the date when the profit becomes zero is within a predetermined range, the stock maintenance cost of the product is given priority over the subdivision work cost, and when it exceeds the predetermined range A determination procedure for determining to prioritize the subdivision work cost over the inventory maintenance cost;
A cost information providing program for executing a display procedure for displaying a judgment result in the preceding judgment procedure.   The determination procedure is characterized in that even if the number of days exceeds the predetermined range, it is determined to prioritize the inventory maintenance cost when the number of shipments matches a unit of packaging of the product. The cost information providing program according to claim 1. A calculation procedure for calculating an amount per cost of the product including at least the inventory maintenance cost and the subdivision work cost for each predetermined quantity;
The information providing program according to claim 1, further comprising a second display procedure for displaying the amount calculated in the calculation procedure for each of the predetermined quantities.

Images