JP2011145960A - Apparatus and program for managing proportional distribution of commodity - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To manage purchase plans of commodities in respective stores and proportional distribution of the purchased commodities in bulk purchase of commodities for a plurality of stores. <P>SOLUTION: A commodity proportional distribution management apparatus 1 holds (13) an event correlation table indicating correlation between an event and increase/decrease in selling amounts of commodities, collects (101) event information associated with respective stores, increases/decreases (103) purchase prices indicating normal purchase amounts of respective commodities while referring to the event correlation table, and outputs (104) purchase request amounts (purchase plan information) of respective commodities. The commodity proportional distribution management apparatus 1 obtains (105) defined amounts (defined purchase amounts) of purchase of respective commodities, sets (106) a commodity having large profit width of a commodity category in which a proportional distribution coefficient value is increased as a commodity for special sale, calculates the proportional distribution coefficient value of the defined purchase amount, and adjusts (107) the proportional distribution coefficient value of the commodity whose purchase amount is lacking. Further, the commodity proportional distribution management apparatus 1 obtains sales results of commodities in respective stores and updates (108) the event correlation table. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a technology for managing purchase plans and apportionment of purchased products in batch purchase of products sold at multiple stores.

  In the retail business format (chain store business format) that develops multiple stores, the headquarters purchases products collectively to reduce the procurement cost of products sold at each of the multiple stores. Therefore, purchases are planned according to the sales situation of each store, and the purchased products are prorated and delivered.

  In the purchase plan, it is required to increase the profit without missing a sales opportunity by determining the product category and the purchase amount of the product according to the product demand.

  For example, in an online shop, a system is known that determines a sale item that can be expected to increase sales based on information such as weather and holidays (for example, Patent Document 1).

  There is also known a system that determines a sales plan for each product in anticipation of increase or decrease in sales based on weather / temperature, event information, etc. (for example, Patent Document 2).

Japanese Patent Laid-Open No. 2002-7875 JP 2002-24350 A

  In the batch purchase of products handled in multiple store exhibitions, since the sales environment for each store differs, it is necessary to determine the purchase amount of the product according to the sales environment of each store.

  By the way, it is empirically known that there is a correlation in which demand is stimulated or suppressed by holding an event, and the sales volume of products of a specific category increases or decreases.

  Therefore, in the category of products whose sales increase in response to the event, the purchase amount is increased in advance to utilize sales opportunities, and in the categories of sales that decrease in sales, the purchase amount is reduced in advance and unsold. Need to prevent.

  However, it has been a heavy burden to manually perform the work of estimating the purchase amount in consideration of related events for each of a plurality of stores.

  In addition, even if the purchase amount is estimated based on the purchase plan by taking into account the events related to the store, even if the increase in the purchase amount is several times the normal amount due to a sudden order, Because it is temporary, it may not be possible to purchase the entire quantity ordered.

  In such a case, it was not possible to apportion the products to each store according to the purchase plan, and it was necessary to adjust the apportionment of the products, and it was also burdensome to perform this apportionment manually.

  An object of the present invention is to make a purchase plan that can take advantage of an opportunity to increase sales for each of a plurality of stores in consideration of an event that affects the increase or decrease in sales, and to make profits from purchased products more efficient in the entire store. It is to provide a product apportionment management device that manages apportionment of products between stores.

  Another object of the present invention is to provide a product apportionment management program for causing a computer to execute processing executed by each means of the product apportionment management device.

  In view of the above-described object, the product apportionment management device disclosed as one aspect of the present invention manages the product purchase plan and apportionment of products to each store in batch purchase of products sold at a plurality of stores. And a storage unit and a processing unit described below. That is, the merchandise apportionment management device includes 1) a related facility storage unit that stores a facility table indicating a related facility for each store, and 2) event information indicating an event scheduled to be held in the related facility for each store. 3) an event correlation information storage for storing an event correlation table in which an event adjustment coefficient indicating a correlation between an increase / decrease in the sales amount of a predetermined product category and an event is set for each store. A part.

  Further, the product apportionment determination has a function of apportioning and distributing from the required amount for non-event stores in order to secure the required amount for event stores when the purchase amount is lower than the required amount.

  Further, the product apportionment management device obtains event information including an event schedule and event contents of each event held in a facility related to the store for each store, and stores the event information in the event information storage unit. An event information acquisition unit that performs 5) an inventory information acquisition unit that acquires inventory information indicating an inventory amount of each product for each store, and 6) for each store, based on the inventory information, for a predetermined period of time. Events to be held on the business days of each store purchase table based on the event information by creating a store purchase table in which purchase values indicating the normal purchase amount for each product category on each business day are set The purchase adjustment for increasing or decreasing the purchase value of the product category of the business day to which the event is associated in the store purchase table using the event adjustment coefficient corresponding to the event correlation table. 7) Based on the purchase value of each store purchase table of the store, the purchase request amount for each product of the product category of each business day in the entire store is calculated, and the calculated purchase request A purchase plan creation unit for creating purchase plan information indicating a quantity; and 8) a finalized process for acquiring final purchase information indicating a final purchase quantity for each product of the product category based on the purchase plan information. A purchase information acquisition unit; and 9) a product in a product category in which the purchase request amount is increased from the normal purchase amount by the event for each store based on the purchase plan information and the confirmed purchase information. The product with the largest profit margin is set as a special sale item, and the special sale of the special sale item is set in the business day associated with the event in the store purchase table for each store or the period including the business day. A special sales setting section for creating a table; 10) for each product Create a product apportioning coefficient table that sets apportioning factor values for the stores on business days, and based on the purchase plan information and the final purchase information, the final purchase amount for each product is the purchase It is determined whether or not the amount is more than the requested amount, and for the product whose final purchase amount is greater than or equal to the requested purchase amount, the purchase value of the corresponding product in each store purchase table of each store is apportioned to the store. A coefficient value is set in the product apportioning coefficient table, and for products whose final purchase quantity does not exceed the purchase request quantity, the apportioning coefficient value of the product for each store is calculated as the purchase request quantity and the final purchase quantity. A product apportioning determination unit configured to calculate a product apportioning coefficient value, set the calculated apportioning factor value in the product apportioning factor table, and output a product apportioning factor table in which apportioning factor values of all the products are set; Is provided.

  According to the product apportionment management device described above, the event of the facility related to each store is grasped, and the purchase amount of the product in the product category in which the increase or decrease in sales can occur due to the event demand is adjusted from both the increase and decrease sides. And purchase planning.

  In addition, because it is possible to dig up event demand for each store, it is possible to create an opportunity to increase sales and increase profits.

  In particular, since it is possible to distribute a large number of products corresponding to the event demand to other stores as special sales items, it is possible to increase sales efficiently as a whole.

  In addition, the product apportionment management device further includes, based on the process of acquiring sales performance information indicating the actual sales amount of each product for each store, the purchase plan information, and the sales performance information, An event correlation information management unit that analyzes the difference between the purchase request amount and the actual sales amount of the product category for each store, and performs processing for updating the event adjustment coefficient of the event correlation information based on the result of the analysis Is provided.

  Thereby, the accuracy of the event adjustment coefficient of the event correlation table stored in the product apportionment management device can be improved based on the analysis result using the sales performance information.

  A merchandise apportionment management program which is another aspect of the present invention is for causing a computer to process the processing executed by each processing unit of the merchandise apportionment management apparatus.

  According to the product apportionment management device described above, an event related to each of a plurality of stores can be grasped, and a product in a category whose sales increase / decrease is predicted by the event can be adjusted by increasing / decreasing the purchase amount. ， Efficiently increase profits by avoiding lost sales opportunities and unsold sales.

  In addition, according to the product apportionment management device described above, it is possible to set a product in a category having an event demand as a special sale, and therefore it is possible to efficiently increase profits by using the event as an opportunity for sales promotion. .

  Furthermore, according to the product apportionment management device described above, it is possible to apportion more products that are set as special sales according to event demands to stores related to the event. Can do.

It is a figure which shows the structural example in one Embodiment of the merchandise distribution management apparatus. It is a figure which shows the internal structural example in one Embodiment of the merchandise distribution management apparatus. It is a figure which shows the data structural example of a facility table. It is a figure which shows the data structural example of event information. It is a figure which shows the data structural example of an event correlation table. It is a figure for demonstrating acquisition of the event information of a related facility. It is a figure which shows the data structural example of inventory information. It is a figure which shows the data structural example of each shop purchase table. It is a figure which shows the example of a sale table. It is a figure which shows the example of a goods apportioning coefficient table. It is a figure which shows the example of a goods apportioning coefficient table. It is a figure which shows the example of the information which shows the relationship between stores. It is a figure which shows the outline | summary of the flow of a process of the goods apportionment management apparatus. It is a detailed process flowchart of the process of step S1. It is a detailed process flowchart of the process of step S2. It is a detailed process flowchart of the process of step S3. It is a detailed process flowchart of the process of step S5. It is a detailed process flowchart of the process of step S6. It is a detailed process flowchart of the process of step S7.

  Hereinafter, a product distribution management device disclosed as an embodiment of the present invention will be described.

  FIG. 1 is a diagram illustrating a configuration example in an embodiment of a merchandise apportionment management device.

  A product apportionment management device 1 shown in FIG. 1 is a device that manages a purchase plan for product batch purchase and a product apportionment for a plurality of stores 2 (2w, 2x, 2y,...).

  The merchandise apportionment management device 1 has a sales management system (POS system) 3 for managing sales of merchandise in the store 2, inventory quantity, etc., and purchase management for managing batch purchase of merchandise sold in the store 2. It is connected to the system 4 via the network Na.

  The sales management system 3 and each store 2 (2w, 2x, 2y,...) Are connected via a network Nb.

  The merchandise apportionment management apparatus 1 can further access various information providing servers on the Internet I and collect necessary information.

  The information providing server includes a server that provides information on each facility related to the store 2 (2w, 2x, 2y,...), A weather forecast server that provides weather information such as weather and temperature, a calendar, a holiday, a season A calendar information server that provides information on the age of the child is included.

  For example, the information providing server may be a homepage for notifying events such as B elementary school and Z junior high school, which are facilities related to the store 2x, and T exhibition hall, S public hall, P stadium, etc., which are facilities related to the store 2y. Provide a homepage to notify you of events and events.

  FIG. 2 is a diagram illustrating an internal configuration example in one embodiment of the merchandise distribution management device 1.

  The merchandise apportionment management apparatus 1 includes a related facility storage unit 11, an event information storage unit 12, an event correlation information storage unit 13, an event information acquisition unit 101, an inventory information acquisition unit 102, a purchase adjustment unit 103, and a purchase plan creation unit 104. , A confirmed purchase information acquisition unit 105, a special sale setting unit 106, a product apportionment determination unit 107, an event correlation information management unit 108, and a data communication unit 110.

  The related facility storage unit 11 stores a facility table indicating facilities related to each store 2.

  FIG. 3 is a diagram illustrating a data configuration example of the facility table.

  The facility table is an information table in which, for each store 2 (2w, 2x, 2y,...), A facility name of a related facility, an acquisition destination (access destination) of facility event information, and the like are registered.

  In the present embodiment, the related facility is a facility that is located within a predetermined range (for example, within 500 meters) from the store 2 and that performs an event that may affect the sales of the store 2.

  In the example shown in FIG. 3, facilities such as B elementary school and Z junior high school are registered as facilities related to the store 2x.

  The event information storage unit 12 stores event information indicating events scheduled to be held at each facility for each store 2.

  FIG. 4 is a diagram illustrating a data configuration example of event information.

  The event information is information such as an event schedule collected from an information acquisition destination (such as a home page) of a facility related to each store 2. In the event information, information such as the contents and schedule of the event held at the facility is registered.

  In the example shown in FIG. 4, the sports day of September 11 is registered for the B elementary school registered in the facility table of the store 2x, and the concert for September 28 is registered for the Z junior high school. In addition, for the T exhibition hall registered in the facility table of the store 2y, an exhibition from September 11 to 13 is registered.

  The event correlation information storage unit 13 stores, for each store 2, an event correlation table that indicates a correlation between an increase and decrease in sales in a sales record of a predetermined product category and an event.

  FIG. 5 is a diagram illustrating a data configuration example of the event correlation table.

  In the event correlation table, for each store 2, an event adjustment coefficient is set that indicates the relationship between the facility and event contents and the change (increase / decrease) in the sales volume during the event (the day, the day before, the day before the day before). Has been.

  A positive value of the event adjustment coefficient indicates a relationship in which the sales volume increases due to the event, and a negative value indicates a relationship in which the sales volume decreases due to the event. The standard value (0) of the event adjustment coefficient indicates that there is no increase / decrease in sales volume due to the event.

In the example shown in FIG. 5, in the case of “athletic meet” at the B elementary school related to the store 2x, the sales volume of the product in the product category B is a factor of 0.3 on the day before the normal sales volume. The previous day has a coefficient of 0.5 and the current day has a coefficient of 1.8, indicating that there is an increasing relationship. Further, the sales volume of the product of the product category E is a coefficient of -0.2 on the previous day, a coefficient of -0.5 on the previous day, and a coefficient of -0. 8 indicates that there is a decreasing relationship. In addition, products such as product categories A and D indicate that there is no effect on the increase or decrease in sales volume.
A standard value is set, indicating that it is not necessary to adjust the normal purchase amount.

  The event adjustment coefficient of the event correlation table functions as a coefficient (purchase value) for adjusting the purchase amount of each product category in the process of the purchase adjustment unit 103 to be described later. In each store purchase table for each store 2, Based on the event adjustment coefficient, a purchase value indicating an increase / decrease amount with respect to the normal purchase amount for each product category is determined.

  The event information acquisition unit 101 acquires, for each store 2, event information including the schedule (event date) and event contents of each event held at a related facility within a predetermined target period, and the event information storage unit 12 To store. The event information acquisition unit 101 retrieves and acquires event information of related facilities for each store 2 from the information providing server on the Internet I via the data communication unit 110.

  FIG. 6 is a diagram for explaining event information acquisition of facilities related to a store.

  The homepage shown in FIG. 6 is the homepage of Elementary School B, which is a facility related to the store 2x. The event information acquisition unit 101 refers to the facility table of the store 2x, accesses the B elementary school homepage, and acquires event information (September 11 athletic meet) within the target period from “Notice”. Furthermore, the event information acquisition unit 101 accesses the homepage of the Z junior high school, and similarly acquires event information (a concert on September 28) within the target period from “event schedule”.

  The inventory information acquisition unit 102 acquires inventory information indicating the inventory amount of each product for each store 2 from the sales management system 3. The inventory information is all or part of sales management information managed by the sales management system 3.

  FIG. 7 is a diagram illustrating a data configuration example of inventory information.

  The stock information is the stock status of each store in units of days (mm / dd / dd), and for each product in each product category, the manufacturer, purchase price, purchase date, purchase amount, and stock quantity of the product. It is recorded.

  Based on the inventory information acquired by the inventory information acquisition unit 102, the purchase adjustment unit 103 sets, for each store 2, a purchase value (initial value = 0) indicating the normal purchase amount of each product category in the target period. Each set store purchase table is created and based on the event information stored in the event information storage unit 12, an event held on the business day of the target period of each store purchase table is associated.

  Further, the purchase adjustment unit 103 refers to the event correlation table of the event correlation information storage unit 13 and uses the event adjustment coefficient of the associated event for each product category of the corresponding business day in each store purchase table. A purchase increase / decrease coefficient indicating the degree of increase or decrease from the normal purchase amount is set, and a purchase value (initial value is the normal purchase amount) is calculated using the set purchase increase / decrease coefficient.

  It should be noted that the purchase adjustment unit 103 does not perform adjustment for the product category for which no event adjustment coefficient is set, with the purchase value remaining as the initial value (0).

  Further, the purchase adjustment unit 103 holds in advance weather adjustment information indicating a weather adjustment coefficient for adjusting the purchase value according to the weather, temperature, holiday, and time, and the predetermined value is set via the data communication unit 110. The weather information and calendar information of the target period for each store 2 are acquired from the weather forecast server and calendar information server. And the purchase adjustment part 103 can correct the purchase value of each shop purchase table based on a weather adjustment coefficient.

  FIG. 8 is a diagram illustrating a data configuration example of each store purchase table.

  Each store purchase table shown in FIG. 8 is each store purchase table of the store 2x, and indicates the coefficient of the target period including September 9 to September 28.

  The purchase adjustment unit 103 associates an event of the related facility of the store 2x with the business day of each store purchase table of the store 2x of FIG.

  For example, referring to the event correlation table, since the event adjustment coefficient other than the standard value is set for the three days of the previous day to the day of the athletic meet of B elementary school (see FIG. 5), the purchase adjustment unit 103 Associate B elementary school sports day from September 9 to 11 in each store purchase table, and set event adjustment coefficient corresponding to this event as a coefficient (purchase increase / decrease coefficient) indicating the degree of increase or decrease in purchase amount To do.

  Similarly, the purchase adjustment unit 103 associates the concert of Z Junior High School on September 27 and 28 in each store purchase table, and sets the corresponding event adjustment coefficient as the purchase increase / decrease coefficient.

  The purchase plan creation unit 104 selects one or a plurality of products from the products of each product category based on a predetermined purchase determination method.

  The purchase determination method is a method for determining which product is preferentially purchased when there are a plurality of products in the product category. The purchase plan creation unit 104 selects a product to be purchased for each product category using a known method such as a minimum inventory monitoring method, a selling point monitoring method, or a purchase price emphasis method.

  Then, the purchase plan creation unit 104 totals the purchase values of all the store purchase tables of the store 2, calculates the purchase request amount of the selected product for each product category, and creates purchase plan information. And output. The purchase plan information is output to the purchase management system 4.

  The final purchase information acquisition unit 105 acquires final purchase information indicating the final purchase amount of each product in the target period from the purchase management system 4.

  The confirmed purchase information is information indicating the purchase amount of each product that has been confirmed for the target period.

  Based on the purchase plan information created by the purchase plan creation unit 104, the special sale setting unit 106 has the largest profit margin for each store 2 from the product category in which the purchase request amount is increased by the purchase increase / decrease coefficient. The product (the product whose purchase price is the lowest with respect to the selling price) is set as the special sale product.

  Furthermore, the special sale setting unit 106 sets special sale of special sale items during the period (the day, the previous day, the day before, etc.) in which the event is associated with each store purchase table for each store 2.

  The special sale setting unit 106 creates a special sale table indicating special sale and special sale items.

  FIG. 9 is a diagram illustrating an example of a special sale table.

  In the sale table, the sale item set for the business day of the target period is registered. In addition, for each special sale item, a distribution coefficient for the store 2 where the special sale is set is set.

  For example, in each store purchase table shown in FIG. 8, since the purchase increase / decrease coefficient (event adjustment coefficient) is set for the product category B, the sale setting unit 106 selects the sale price and purchase price for the products of the product category B. The products b1, b4, b6 having a large difference from the value (profit margin) are set in the sale table as sale items. Further, based on the event information, a special sale is set for the store 2 and the period associated with the event.

  The product apportioning determination unit 107 calculates the apportioning coefficient of the product to each store 2 from the confirmed purchase information and the purchase plan information.

  The product apportionment determination unit 107 determines whether the final purchase amount of the product satisfies the purchase request amount based on the purchase plan information and the final purchase information. Then, when the final purchase amount of the product satisfies the purchase request amount (determined purchase amount ≧ purchase request amount), the purchase value of the product in each store purchase table is used as the distribution coefficient value of the product. Set to table.

  On the other hand, when the final purchase amount of the product does not satisfy the purchase request amount (final purchase amount <purchase request amount), the product distribution determination unit 107 adjusts the purchase value of the product and sets the distribution coefficient value. Obtain and set in the product distribution coefficient table.

  10 and 11 are diagrams showing examples of the merchandise distribution coefficient table.

  The product apportioning coefficient table shown in FIG. 10 indicates that the apportioning coefficient value for each store 2 (2w, 2x, 2y, 2z,...) For each product in the product category is a product set as a special sale product. It has items for sale items.

  In the product apportioning coefficient table shown in FIGS. 10 and 11, the setting of the flag indicating the product set for the special sale item is indicated by “circle” (◯), and the special sale item setting flag is set (special sale item). Only the apportionment value set for is shown, and apportioning coefficient values for normal products are omitted.

  The merchandise apportionment determination unit 107 adjusts the apportioning coefficient value as follows in setting the apportioning coefficient value of products whose final purchase amount is less than the purchase request amount.

  The product apportioning determination unit 107 obtains a purchase shortage amount that is a difference between the purchase request amount from the final purchase amount of the product, determines the unit amount by dividing the obtained shortage purchase amount into a predetermined number, and , A store where the purchase value of the product has not increased, that is, a store in which the normal purchase amount is unchanged or adjusted to decrease is specified.

  Then, the merchandise apportionment determination unit 107 extracts the stores from the identified stores in descending order of the purchase value of the merchandise, and subtracts a conversion value indicating the determined unit amount from the apportioning coefficient value of the extracted stores. The distribution coefficient value is obtained.

  Alternatively, the product apportionment determination unit 107 obtains a purchase shortage amount that is the difference between the purchase request amount from the final purchase amount of the product, and adjusts the obtained purchase shortage amount by increasing the normal purchase amount by an event. The conversion value corresponding to the amount divided by the number of stores that did not exist is subtracted from the apportioning factor value of the stores that did not increase the normal purchase amount, respectively, to obtain an apportioning factor value.

  As a result, for products that could not secure the required amount of purchase, among the stores that did not adjust the increase after securing the purchase amount that was increased and adjusted to the store that increased the normal purchase amount due to the event. , Adjust the shortage of purchases by apportioning the reduced amount (accommodation) to stores where the demand for goods tends to be suppressed by the event. For this reason, lost sales opportunities due to event demand can be avoided, and the effects of shortage of purchase can be minimized.

  Further, the product apportionment determination unit 107 increases the normal purchase amount by the largest amount based on the information indicating the relationship between the stores when setting the apportioning coefficient value of the product whose final purchase amount is less than the purchase request amount. It is good also as an object store which adjusts the distribution coefficient value by the amount of purchase shortage in an order from a store with low relevance with the adjusted store.

  10 and 11, according to the processing of the product apportionment determination unit 107 when the final purchase amount of the products a2, a5, b3, and c1 that have become special sales items due to the event demand is less than the purchase request amount, A change in the distribution coefficient value will be described. Here, the product apportioning coefficient table in FIG. 10 is an example before processing of the product apportioning determination unit 107, and FIG. 11 is an example of the result after processing.

  In addition, the store 2w is the event target store, the store 2x has a relatively high correlation with the store 2w and the change in sales results, and the stores 2y and 2z have a relatively low relationship with respect to the change in sales results. Suppose that

  As shown in FIG. 10, the distribution coefficient values of the stores 2w, 2x, 2y, and 2z of the product a2 are “2.0”, “1.1”, and “1.0”, respectively, based on the purchase request amount. ”And“ 1.0 ”. In this case, when the final purchase amount of the product a2 is less than the purchase request amount, the difference (insufficient amount) between the final purchase amount and the purchase request amount is divided between the stores 2y and 2z having a low correlation. The coefficient value is lowered, and the apportionment amount of the product a2 is reduced, that is, the accommodation amount to the stores 2x and 2w is secured. When the apportioning coefficient value corresponding to the shortage is “0.6”, the merchandise apportionment determination unit 107, as shown in FIG. 11, apportioning factor values of the stores 2y and 2z having a low sales correlation due to event demand. Are reduced by “0.3” and changed to “0.7” and “0.7”, respectively.

  In this way, the merchandise apportionment determination unit 107 adjusts the apportioning factor value of stores that are unlikely to expect event demand, and maintains the apportioning factor value to stores that can be expected to make sales, thereby confirming batch purchase. Aim for maximum sales in purchases.

  FIG. 12 is a diagram illustrating an example of information indicating store relevance.

  FIG. 12A is an information table showing the distance between stores, and FIG. 12B is an information table showing the linkage of past sales performance fluctuations.

  In the information table of FIG. 12A, the numerical value represents the distance (unit kilometer) between stores. The smaller the value, the closer the distance between stores, indicating that the relationship between stores is high.

  In the information table of FIG. 12 (B), the numerical value represents the linkage of the increase or decrease in sales between stores. As the standard value is 0, the larger the positive value, the more the trend of sales increases and decreases. The higher the negative value, the more the trend of sales increases and decreases. Indicates low.

  Further, the merchandise apportionment determination unit 107 obtains a value corresponding to an amount obtained by dividing the shortage purchase amount of merchandise by the total number of stores, subtracts the obtained value from the apportioning coefficient value of all stores, and calculates the apportioning coefficient value. You may adjust.

  The event correlation information management unit 108 acquires the sales result information indicating the actual sales amount of each product for each store 2 from the sales management system 3, and purchases the sales amount of the sales result information and the purchase of each store purchase table. The difference with the purchase request amount of the product based on the increase / decrease coefficient is analyzed, and the event adjustment coefficient of the event correlation information stored in the event correlation information storage unit 13 is updated based on the analysis result.

  The data communication unit 110 performs data communication with the sales management system 3 or the purchase management system 4 via the network Na, and performs data communication with various information providing servers on the Internet I.

  Below, the flow of processing of the merchandise apportionment management device 1 in one embodiment will be described.

  FIG. 13 is a diagram showing an outline of the processing flow of the merchandise apportionment management device 1.

Step S1: Acquisition of Inventory Information etc. FIG. 14 is a detailed process flow diagram of the process of step S1.

  As pre-processing, the inventory information acquisition unit 102 acquires, from the sales management system 3, the product category of each store 2 on the processing day and the inventory amount for each product (step S11). Further, the purchase adjustment unit 103 acquires the product category of each store 2 and the normal purchase amount for each product (step S12).

Step S2: Creation of Event Information for Each Store FIG. 15 is a detailed process flowchart of the process of step S2.

  The event information acquisition unit 101 reads the facility table from the related facility storage unit 11 (step S21). Then, the event information acquisition unit 101 searches for event information from various information providing servers on the Internet for the related facilities registered in the facility table (step S22). From the retrieved information, it is determined whether there is an event within a predetermined period (step S23), and only when there is an event (Y in step S23), event information (date of event, event content) is acquired (step S24). ).

  Until the search process is completed for all the facilities in the facility table, the process returns to step S22 (N in step S25). If the search process is complete for all facilities (Y in step S25), the search process is completed for all stores. The process returns to step S21 until it is done (N in step S26). When the search process is completed for all stores (Y in step S26), the event information is stored in the event information storage unit 12 and the process is terminated.

Step S3: Adjustment of Purchase and Creation of Purchase Plan FIG. 16 is a detailed process flow diagram of the process of step S3.

  The purchase adjustment unit 103 reads the event correlation table from the event correlation information storage unit 13 (step S31), creates each store purchase table for each store, and sets an initial value (a purchase value indicating a normal purchase amount). Set (step S32).

  Further, the purchase adjustment unit 103 adjusts the purchase value of the product category for each store 2 in which the event is registered in the event information, based on the event adjustment coefficient of the event correlation table, and sets the purchase value in each store purchase table. (Step S33).

  The purchase adjustment unit 103 further accesses a predetermined information providing server on the Internet, acquires calendar information and weather information, and corrects the purchase value in each store purchase table (step S34).

  The purchase plan creation unit 104 checks whether the purchase value is an initial value for each product category in each store purchase table (step S35), and if the purchase value is not the initial value (N in step S35). If the purchase value of the product category is positive (Y in step S36), the product having the largest margin (sell price-purchase value) is selected from the product category (step S37). If the purchase value of the product category is negative (N in step S36), the product with the smallest margin (sale price-purchase value) is selected from the product category (step S38). Then, the purchase request amount of the selected product is calculated based on the purchase value set by the normal purchase amount of the product category and the event adjustment coefficient (step S39).

  On the other hand, when the purchase increase / decrease coefficient is a standard value (Y in step S35), the purchase plan creation unit 104 calculates the normal purchase amount (step S310).

  The purchase plan creation unit 104 creates and outputs purchase plan information indicating the calculated purchase request amount of each product (step S311). The purchase plan information is transmitted to the purchase management system 4.

Step S4: Acquisition of Final Purchase Information The final purchase information acquisition unit 105 acquires final purchase information indicating the final purchase quantity of each product category and product from the purchase management system 4.

Step S5: Special Sale Setting FIG. 17 is a detailed process flow diagram of the process of step S5.

  The sale setting unit 106 sets the sale item with the lowest purchase value in the increase-adjusted sale category based on the confirmed purchase information (step S51). Further, a special sale table is created, and special sale items are set based on the event information during a period associated with the event (step S52).

Step S6: Determination of Product Apportionment FIG. 18 is a detailed process flow diagram of the process of step S6.

  The product apportioning determination unit 107 checks whether the final purchase amount of each product satisfies the purchase request amount (step S61), and the final purchase amount of the product does not satisfy the purchase request amount (insufficient). ) (N in step S61), the distribution coefficient is adjusted (step S62).

  The merchandise apportionment determination unit 107 returns to step S61 until the apportionment adjustment for all the products is completed (N in step S63). A product apportioning coefficient table is set (step S64).

  Note that the product apportionment determination unit 107 may determine the quantity of products to be shipped to each store based on the apportionment coefficient in the product apportionment coefficient table.

Step S7: Management of Event Correlation Information FIG. 19 is a detailed process flow diagram of the process of step S7.

  The event correlation information management unit 108 acquires the product category of each store and the sales performance (sales quantity) for each product from the sales management system 3 (step S71), and based on the event table, the event content and the sales quantity (Step S72), and the event adjustment coefficient in the event correlation table is updated based on the analysis result (step S73).

  In the above embodiment, the present invention has been described for the case where the present invention is applied to collective purchase of a chain store business format, but the present invention is not limited to the described embodiment, and is within the scope of the description. Various modifications are possible.

  Further, the merchandise apportionment management device 1 can be constructed by realizing each processing unit of the merchandise apportionment management device 1 by a computer having an input / output device and an external storage device reading and executing the program. This program can be stored in an appropriate recording medium such as a portable medium memory, a semiconductor memory, or a hard disk, which can be read by a computer, and is provided by being recorded on these recording media. Alternatively, this program is provided by transmission and reception using various communication networks via a communication interface.

DESCRIPTION OF SYMBOLS 1 Merchandise apportionment management apparatus 11 Related facility memory | storage part 12 Event information memory | storage part 13 Event correlation information memory | storage part 101 Event information acquisition part 102 Inventory information acquisition part 103 Purchase adjustment part 104 Purchase plan creation part 105 Final purchase information acquisition part 106 Sale setting unit 107 Product apportionment determination unit 108 Event correlation information management unit 110 Data communication unit 2 (2w, 2x, 2y, ...) Store 3 Sales management system 4 Purchase management system

Claims (8)

A product apportionment management device for managing the product purchase plan and apportionment of products to each store in collective purchase of products to be sold at a plurality of stores,
A related facility storage unit that stores a facility table indicating a related facility for each store;
An event information storage unit for storing event information indicating an event scheduled to be held at the related facility for each store;
An event correlation information storage unit for storing an event correlation table in which an event adjustment coefficient indicating a correlation between an increase / decrease in sales amount of a predetermined product category and an event is set for each store;
For each store, an event information acquisition unit that acquires event information including an event schedule and event contents of each event held in a facility related to the store and stores the event information in the event information storage unit;
An inventory information acquisition unit for acquiring inventory information indicating an inventory amount of each product for each store;
For each store, based on the inventory information, create a store purchase table in which a purchase value indicating a normal purchase amount for each product category on each business day in a predetermined period is created, and the event information is Based on the relationship between the events held on the business day of each store purchase table, the product category of the business day associated with the event of each store purchase table using the corresponding event adjustment coefficient of the event correlation table A purchase adjustment section that increases or decreases the purchase value of
Based on the purchase value of each store purchase table of the store, the purchase request amount for each product of the product category of each business day in the entire store is calculated, and the calculated purchase request amount is indicated. A purchase plan creation section for creating receipt plan information;
A final purchase information acquisition unit for acquiring final purchase information indicating a final purchase amount for each product of the product category based on the purchase plan information;
Based on the purchase plan information and the confirmed purchase information, the profit margin becomes the maximum among the products in the product category in which the purchase request amount is increased from the normal purchase amount by the event for each store. A sale setting unit that sets a sale item in which the sale item is set in a sale date for each store and the sale date of the sale item is set in a business day associated with the event or in a period including the business day; ,
A product apportioning coefficient table for setting apportioning factor values to the stores for each business day is created for each product, and the final purchase for each product is made based on the purchase plan information and the final purchase information. It is determined whether the quantity is equal to or greater than the purchase request quantity, and for a product whose final purchase quantity is equal to or greater than the purchase requirement quantity, the purchase value of the corresponding merchandise in each store purchase table of each store is determined. , The apportioning coefficient value of the store is set in the product apportioning factor table, and the apportioning factor value of the product for each store is set to the purchase request for the product whose final purchase amount does not exceed the purchase request amount. The product apportioning coefficient value is calculated using the difference between the quantity and the final purchase amount, the apportioning coefficient value is set in the product apportioning coefficient table, and the product apportioning coefficient table in which the apportioning coefficient values of all the products are set is output. A product apportioning determination unit Product apportionment management device characterized by The product apportioning determination unit is configured to set an apportioning coefficient value of a product for which the final purchase amount is less than the purchase request amount, and an insufficient purchase amount that is a difference between the final purchase amount of the product and the purchase request amount. And determining a value corresponding to a predetermined division unit amount of the shortage of purchase, and among stores that have not increased the purchase value of the product, store in descending order of the purchase value of the product. The product apportionment management device according to claim 1, wherein the apportioning coefficient value is obtained by subtracting the determined value from the apportioning coefficient value of the extracted store. The product apportioning determination unit sets the apportioning coefficient value of the product for which the confirmed purchase amount is less than the purchase request amount.
Corresponds to the amount obtained by determining the purchase shortage amount that is the difference between the purchase request amount from the final purchase amount of the product and dividing the shortage purchase amount by the number of stores that did not increase the purchase value of the product. The product apportionment management device according to claim 1, wherein the apportioning coefficient value is obtained by subtracting the value from the apportioning factor value of the store that has not increased the purchase value of the product. The product apportionment management according to any one of claims 1 to 3, wherein the event information acquisition unit acquires event information of related facilities for each store from an information providing server on the Internet. apparatus. The purchase adjustment unit obtains environmental information indicating the weather, holidays, and time of the target period for each store;
The weather adjustment information indicating the weather adjustment coefficient for adjusting the purchase value according to the weather, holidays, and time is stored in advance, and the purchase value of each store purchase table of the store is corrected based on the weather adjustment coefficient. The product apportionment management device according to any one of claims 1 to 4, wherein: Processing for obtaining sales performance information indicating the actual sales volume of each product for each store;
Based on the purchase plan information and the sales performance information, the difference between the purchase request amount and the actual sales amount of the product category is analyzed for each store, and the event correlation information is based on the analysis result. The product distribution management device according to claim 1, further comprising an event correlation information management unit that performs a process of updating the event adjustment coefficient. In order to manage the purchase plan of the product and the apportionment of the product to each store in the batch purchase of products sold at a plurality of stores,
A related facility storage unit that stores a facility table indicating a related facility for each store;
An event information storage unit for storing event information indicating an event scheduled to be held at the related facility for each store;
For each store, a computer comprising an event correlation information storage unit that stores an event correlation table in which an event adjustment coefficient indicating a correlation between an increase and decrease in sales performance amount of a predetermined product category and an event is set.
For each store, a process of acquiring event information including the schedule and event contents of each event held at a facility related to the store and storing the event information in the event information storage unit;
A process of acquiring inventory information indicating an inventory amount of each product for each store;
For each store, based on the inventory information, create a store purchase table in which a purchase value indicating a normal purchase amount for each product category on each business day in a predetermined period is created, and the event information is Based on the process of associating the event held on the business day of each store purchase table,
Processing to increase or decrease the purchase value of the product category of the business day associated with the event of each store purchase table using the corresponding event adjustment coefficient of the event correlation table;
Based on the purchase value of each store purchase table of the store, the purchase request amount for each product of the product category of each business day in the entire store is calculated, and the calculated purchase request amount is indicated. The process of creating admission plan information,
A process for acquiring final purchase information indicating a final purchase amount for each product of the product category based on the purchase plan information;
Based on the purchase plan information and the confirmed purchase information, the profit margin becomes the maximum among the products in the product category in which the purchase request amount is increased from the normal purchase amount by the event for each store. A process of setting a product as a special sale item, and creating a special sale table in which the special sale of the special sale item is set in a business day associated with the event of each store purchase table for each store or a period including the business day;
A process of creating a product distribution coefficient table for setting a distribution coefficient value to the store for each business day for each product;
Based on the purchase plan information and the final purchase information, a process for determining whether the final purchase amount is greater than or equal to the purchase request amount for each product;
For a product for which the final purchase amount is equal to or greater than the purchase request amount, the purchase value of the corresponding product in each store purchase table of each store is set in the product apportioning coefficient table as the apportioning factor value of the store. , Calculating the apportioning coefficient value of the product for each store using the difference between the purchase request amount and the final purchase amount for the product whose final purchase amount does not exceed the purchase request amount, A process of setting the calculated apportioning coefficient value in the product apportioning coefficient table and outputting the product apportioning coefficient table in which the apportioning coefficient values of all the products are set;
Product apportionment management program to be executed. In the computer,
Processing for obtaining sales performance information indicating the actual sales volume of each product for each store;
Based on the purchase plan information and the sales performance information, the difference between the purchase request amount and the actual sales amount of the product category is analyzed for each store, and the event correlation information is based on the analysis result. Updating the event adjustment coefficient of
The product apportionment management program according to claim 7 for execution.

Images