WO2018043617A1 - Système d'assistance de commandes - Google Patents

Système d'assistance de commandes Download PDF

Info

Publication number
WO2018043617A1
WO2018043617A1 PCT/JP2017/031279 JP2017031279W WO2018043617A1 WO 2018043617 A1 WO2018043617 A1 WO 2018043617A1 JP 2017031279 W JP2017031279 W JP 2017031279W WO 2018043617 A1 WO2018043617 A1 WO 2018043617A1
Authority
WO
WIPO (PCT)
Prior art keywords
order
sales
item
support system
column
Prior art date
Application number
PCT/JP2017/031279
Other languages
English (en)
Japanese (ja)
Inventor
好春 日疋
Original Assignee
株式会社ひびき
好春 日疋
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority claimed from JP2017120917A external-priority patent/JP2018041440A/ja
Application filed by 株式会社ひびき, 好春 日疋 filed Critical 株式会社ひびき
Priority to CN201780066805.8A priority Critical patent/CN109891453A/zh
Priority to SG11201901744UA priority patent/SG11201901744UA/en
Priority to EP17846621.5A priority patent/EP3509029A4/fr
Priority to KR1020197006020A priority patent/KR20190044624A/ko
Priority to US16/328,856 priority patent/US20190188641A1/en
Publication of WO2018043617A1 publication Critical patent/WO2018043617A1/fr
Priority to PH12019500418A priority patent/PH12019500418A1/en

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/06—Buying, selling or leasing transactions

Definitions

  • the present invention relates to an ordering support system that is suitable for application when a store places an order for skewered products of skewered products such as yakitori andonguyaki to a manufacturing factory.
  • Skewered products such as yakitori, touyaki, etc. are processed and processed in chicken, pork, leeks, etc. at the manufacturing plant, combined appropriately and then stabbed into a skewer, onion, skin, lever, chicken wings, etc. Manufacture of skewers. These skewered materials are stored in a storage warehouse attached to the manufacturing factory, and stored refrigerated or frozen until shipment.
  • the number of skewers is determined for each item, taking into account the natural characteristics such as season and weather, the characteristics of the day of the week and holidays, the taste characteristics of the region and customers, etc. And place an order with the manufacturing plant.
  • the skewer material is baked in a charcoal furnace, yakitori, etc. according to customer orders, and sold and provided as skewered products.
  • an ordering system for calculating the order quantity of products has been proposed in consideration of natural characteristics such as seasons and weather, and day-of-week characteristics such as days of the week and holidays (patent document). 1 to 3).
  • JP 2003-67611 A Japanese Patent Laid-Open No. 2002-24350 JP 2001-167168 A
  • order quantity of the product is calculated taking into account the natural characteristics such as season and weather, and the day of the week characteristics such as days of the week, holidays, etc. It wasn't something that could be used properly for inexperienced people who had just started working at the store.
  • the present invention has been made in view of such problems, and it is possible to determine the order quantity from a long-term perspective, taking into account the inventory at the store, and to work at the store. It is an object of the present invention to provide an ordering support system that enables an inexperienced inexperienced person to easily determine the order quantity.
  • an ordering support system of the present invention comprises a server computer installed in a manufacturing factory, a client computer installed in a store, and a network connecting them,
  • the server computer includes a sales result data file storing sales detail data for each item of skewer material for the same month of the previous year and the last two months, fixed items such as identification codes, names, unit prices, etc. for items of the skewer material, stores, A code master file that stores the calendar, and
  • the client computer describes the items of the skewer material handled in the store, the item data file storing the set proper stock quantity, and the order quantity for each item of the skewer material in a table format.
  • An order communication table file that can be stored, and in its internal storage device, daily fluctuations such as weather, sales amount, daily stock quantity for each item of skewering material, predicted value such as order quantity, fixed value, etc. It is characterized by temporarily storing a variable data file comprising data to be processed.
  • the client computer displays an order calculation sheet on its display screen, and the sales results column displays the sales results of the skewered products for each day of the week and weather for several days from the same day last year. It is characterized by that.
  • the client computer inputs the expected sales amount and weather forecast of the skewered product in the sales forecast column, and enters the stock quantity today and the next day receipt quantity for each item of skewer material in the order calculation column, thereby calculating the order.
  • the column is characterized in that automatic calculation is executed based on the reference holding quantity and the above data, and the order quantity of the next day is displayed.
  • warning items may be displayed in yellow and red on the skewer material item depending on the degree of excess quantity.
  • the ordering support system of the present invention can also be applied to fresh foods or daily foods instead of or together with skewered materials.
  • ordering support system of the present invention can be applied to beverages instead of or together with skewer materials.
  • the ordering support system of the present invention it is possible to determine the order quantity from a long-term perspective, taking into account the inventory at the store, and also for those who are inexperienced at work in the store.
  • the order quantity can be easily determined.
  • the ordering support system 1 of the present invention includes a server computer 2 installed in a manufacturing factory, client computers 3, 3, 3, 3,. And a network 4 for connecting the two.
  • the server computer 2 is installed in a manufacturing factory, and as shown in FIG. 4, a database 20 is constructed in an external storage device (auxiliary storage device) 2A such as a hard disk. In the database 20, a code master file 21 and a sales performance data file 22 are stored.
  • the code master file 21 stores skewer material items, identification codes related to stores, etc., fixed item data such as names and unit prices, and calendar data.
  • the sales result data file 22 stores the sales details data for each item of skewer material for the same month of the previous year and the last two months.
  • the client computer 3 is installed in a store, and as shown in FIGS. 2 and 3, a central processing unit (CPU) 3A, an internal storage device (main storage device) 3D such as a memory, and a transmission / reception device 3E are arranged inside the computer body. In addition, an external storage device (auxiliary storage device) 3F such as a hard disk is provided outside. As peripheral devices, as shown in FIGS. 2 and 3, an input device 4 such as a keyboard 4A and a mouse 4B, and an output device 5 such as a display 5A and a printer 5B are connected.
  • a database 30 is constructed in the external storage device (auxiliary storage device) 3F, and an item data file 31 and an order communication table file 32 are stored in the database 30.
  • the fluctuation data file 33 is input at an appropriate time and temporarily stored.
  • the item data file 31 stores items of skewering material handled at the store, a set proper stock quantity, and the like.
  • the order communication table file 32 is a file in which the order quantity and the like for each item of skewered material can be described in a table format, and is transmitted to the manufacturing factory.
  • the fluctuating data file 33 is data that fluctuates daily such as weather, sales amount, forecast value such as stock quantity on the day for each item of skewering material, final value such as order quantity, etc., and an input device such as a keyboard 4A and a mouse 4B.
  • 4 is a file that is input from 4 and temporarily stored in the internal storage device 3E.
  • the order support system 1 of the present invention has the above-described configuration, and can be operated and operated as follows. In the present embodiment, a case will be described in which the store manager performs an ordering operation after totaling the store sales on Friday, September 10, 2010.
  • the store manager turns on the power of the client computer 3 installed in the store, and then starts up the order communication table file 32.
  • the order calculation sheet 101 is displayed on the screen of the display 5A of the client computer 3, as shown in FIG.
  • data is transmitted from the code master file 21 and the sales result data file 22 stored in the database 20 of the server computer 2 to the transmission / reception device 3E of the client computer 3 in accordance with a command from the central processing unit (CPU) 3A. It is stored in the internal storage device 3D and the external storage device 3F.
  • CPU central processing unit
  • the sales result column 110 of the order calculation sheet 101 includes the sales result of skewered products for 9 days from the next day of the previous year, together with the day of the week and the weather. Is displayed.
  • the sales performance of skewered products over three months before and after the corresponding day of the previous year is displayed in the weekday weather result column 112 for each day of the week and each weather.
  • the average value for each day of the sales performance over the three months before and after the corresponding day last year is displayed.
  • 1 is assigned to fine weather
  • 2 is cloudy
  • 3 is rainy
  • 4 is bad weather.
  • the central processing unit (CPU) 3A of the client computer 3 calculates the sales composition ratio A for each skewered product item based on the sales performance data of the skewered product over three months before and after the corresponding date last year, Temporarily store in device 3D.
  • the sales composition ratio A of a predetermined item is a ratio when the sales amount of the item is divided by the sales amount of all items.
  • the person in charge uses the input device 4 such as the keyboard 4A, the mouse 4B, etc. to enter the sales forecast column 120 in the next day, the next day, the next day, three days later, as shown in FIG. Enter the forecasted sales amount and weather forecast for Kushiyaki products.
  • weather forecasts are automatically displayed as clear, cloudy, rainy, or bad weather by appropriately selecting the numbers 1, 2, 3,... Displayed in the selection column with the mouse 4B. Can be made.
  • the responsible person inputs the quantity remaining today for each item of skewered material in the remaining quantity field 131 on the order calculation field 130.
  • the next day storage quantity column 132 the quantity that has already been ordered and received the next day is entered for each skewer material item.
  • an item code column 141 As shown in FIG. 7, in the order calculation column 130, an item code column 141, an item name column 142, and an order lot quantity column 143 are formed.
  • item code column 141 and the item name column 142 item codes and names of skewered products handled in the store are displayed.
  • the order lot quantity column 143 displays a unit of quantity that can be ordered for each skewer material item.
  • the central processing unit (CPU) 3A of the client computer 3 stores in the external storage device 3F and the internal storage device 3D. Various calculations are automatically executed based on the stored various data.
  • the sales forecast quantity for the next day is calculated and displayed for each skewered product item.
  • the sales ratio A 1 of the item by multiplying the forecast value of the next day skewers product entered in forecast column 120 is calculated by dividing the sales prices B of the material.
  • the expected remaining quantity of the next day is calculated and displayed for each skewered product item.
  • the expected remaining quantity for the next day is calculated by adding the quantity received next day to the quantity remaining today and subtracting the expected sales quantity for the next day.
  • next-day sales forecast column 153 the next-day sales forecast quantity is calculated and displayed for each skewered product item.
  • Sales forecast quantity day after next is the sales ratio A 2 of the item by multiplying the forecast amounts skewers products two days later entered in forecast column 120, is calculated by dividing the sales prices V of the item.
  • the sales forecast quantity after 3 days is calculated and displayed for each skewered product item.
  • Sales forecast quantity after three days the sales ratio A 3 of the item by multiplying the forecast amounts skewers product 3 days after you enter the forecast column 120, is calculated by dividing the sales prices B of the item .
  • next-to-day ordering assumed quantity column 155 calculates and displays the next-to-day ordering assumed quantity for each skewered product item.
  • the assumed order quantity for the next day is obtained by multiplying the expected sales quantity after 3 days by the appropriate inventory rate C, adding the expected sales quantity for the next day, and subtracting the remaining expected quantity for the next day. This quantity is compared with the unit of the ordered lot quantity, and is calculated as an integer multiple of the closest ordered lot quantity.
  • the person in charge reviews the expected sales volume for 3 days for each skewer material item, and inputs the next-day order confirmation quantity field 161 in the next-day order confirmation quantity field 161 as shown in FIG.
  • next-day remaining expected quantity column 162 the remaining expected quantity for the next day is calculated and displayed for each skewered product item.
  • the remaining expected quantity for the next day is calculated by adding the order decision quantity for the next day to the remaining expected quantity for the next day and subtracting the expected sales quantity for the next day.
  • a warning and warning display is made in yellow and red on the item of the skewer material depending on the degree of excess quantity.
  • the excess quantity can be understood by dividing the next day's remaining expected quantity by the next day's expected sales quantity. If the divided value is 1.0 or more, the background of the cell is displayed in yellow and care is taken to reconfirm the order quantity. When the numerical value is 2.0 or more, the background of the cell is displayed in red and a warning is given to review the order quantity.
  • the person in charge reconfirms the next-day order decision quantity for each skewer material item, referring to the remaining expected quantity, caution, and warning indications for the next day.
  • the fixed quantity column 161 the final order quantity determined on the next day is input.
  • the person in charge presses a button for overwriting and saving the order calculation sheet 101 on the client computer 3 to determine the order calculation sheet 101 for that day.
  • the order calculation sheet 101 created on that day is stored in the order communication table file 32 of the client computer 3.
  • the person in charge can press the print button on the client computer 3 to print the order calculation sheet 101 by the printer 5B. Further, as shown in FIG. 10, for each skewer material item, an order contact report 201 describing the order determination quantity of the next day can be created and printed at the same time.
  • the data stored in the order communication table file 32 is transmitted to the server computer 2 via the network 4 by the transmission / reception device 3E.
  • the manufacturing factory can ship the skewering material of the order determined quantity for every item to the said store the next day.
  • the ordering support system of the present invention it is possible to place an order from a manufacturing factory from a long-term perspective, taking into account the inventory at the store.
  • the order quantity can be determined almost automatically, the order quantity can be easily determined even for those who have little experience of working at a store.
  • the order communication table file 32 when the order communication table file 32 is started up in the client computer 3 installed in the store, data is transmitted from the code master file 21 and the sales result data file 22 of the server computer 2.
  • the code master file 21 and the sales record data file 22 may be stored in the external storage device 3F of the client computer 3 every predetermined period.
  • the ordering support system of the present invention can be applied to fresh foods and daily foods that are quickly deteriorated in quality and difficult to store for a long time.
  • the ordering support system of the present invention is not so quickly deteriorated in quality and is not so difficult to store for a long time.
  • Beverages such as beer, sake, shochu, Shaoxing liquor, or oolong tea, juice, cola, etc. It can also be applied to soft drinks.
  • an order calculation sheet 301 for beverages as shown in FIG. 11 can be displayed and printed separately from the order calculation sheet 101 for skewered products. It is preferable to make it.
  • the sales results of beverages are displayed from the same month last year result column 311 displayed together with the day of the week and the weather, and from the result column 312 of the day of the week displayed for each day of the week and every weather.
  • a configured sales result column 310 is formed. Then, with reference to the display data in the sales record column 310, the sales forecast amount and the weather forecast of the beverage are input in the sales forecast column 320.
  • an order calculation field 330 having an item code field 341, an item name field 342, and an order lot quantity field 343 is formed. Then, the quantity remaining today is entered in the remaining quantity field 331 on the current day, the quantity already placed in the next day receipt quantity field 332 is entered, and the quantity to be received the next day is entered. To do.
  • the order quantity of beverages can be displayed on the order contact form 201 as shown in FIG. 12 so that the order quantities of both skewered products and beverages can be understood at a glance. It is preferable to make it.
  • the sales result data file 22 stores the sales details data for each item of skewer material for the same month in the previous year and the last two months, but stores the data for the same month in the previous year, the last two months, the last three months, etc.
  • the period of data to be used can be determined as appropriate.
  • the sales result of the skewered product for nine days from the day after the corresponding day of last year is displayed. However, it may not necessarily be nine days from the next day. However, since sales vary considerably depending on the day of the week, it is preferable to display sales results for at least 7 days from the next day.

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

L'invention concerne un système d'assistance de commande permettant même à une personne sans expérience de déterminer facilement une quantité de commandes tout en adoptant une perspective à long terme. Ce système d'assistance de commandes (1) est configuré à partir d'un ordinateur serveur (2) installé dans une usine de fabrication, d'un ordinateur client (3) installé dans un magasin, et d'un réseau (4) reliant l'ordinateur serveur (2) et l'ordinateur client (3). L'ordinateur serveur (2) mémorise un fichier maître de code (21) et un fichier de données d'enregistrement des ventes (22). L'ordinateur client (3) mémorise un fichier de données d'article (31) et un fichier de liste de transmissions de commandes (32), et un fichier de données de variation (33) est mémorisé temporairement dans un dispositif de mémorisation interne (3D).
PCT/JP2017/031279 2016-08-31 2017-08-30 Système d'assistance de commandes WO2018043617A1 (fr)

Priority Applications (6)

Application Number Priority Date Filing Date Title
CN201780066805.8A CN109891453A (zh) 2016-08-31 2017-08-30 订购辅助系统
SG11201901744UA SG11201901744UA (en) 2016-08-31 2017-08-30 Order assistance system
EP17846621.5A EP3509029A4 (fr) 2016-08-31 2017-08-30 Système d'assistance de commandes
KR1020197006020A KR20190044624A (ko) 2016-08-31 2017-08-30 발주 지원 시스템
US16/328,856 US20190188641A1 (en) 2016-08-31 2017-08-30 Order assistance system
PH12019500418A PH12019500418A1 (en) 2016-08-31 2019-02-27 Order assistance system

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
JP2016-168660 2016-08-31
JP2016168660 2016-08-31
JP2017-120917 2017-06-20
JP2017120917A JP2018041440A (ja) 2016-08-31 2017-06-20 発注支援システム

Publications (1)

Publication Number Publication Date
WO2018043617A1 true WO2018043617A1 (fr) 2018-03-08

Family

ID=61300876

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/JP2017/031279 WO2018043617A1 (fr) 2016-08-31 2017-08-30 Système d'assistance de commandes

Country Status (1)

Country Link
WO (1) WO2018043617A1 (fr)

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH0696366A (ja) * 1992-06-02 1994-04-08 Nec Corp 発注システムにおける実績画面表示方式
JPH06149833A (ja) * 1992-11-12 1994-05-31 Tokyo Electric Co Ltd 商品発注装置
JP2001084239A (ja) * 1999-09-13 2001-03-30 Toshiba Corp 商品販売数量の分析方法、その予測方法、商品発注量の決定方法、及びプログラムを記憶した記憶媒体
JP2009187151A (ja) * 2008-02-05 2009-08-20 Tsc Consulting:Kk 在庫管理システム及び発注量算出プログラム
JP2012053764A (ja) * 2010-09-02 2012-03-15 Toshiba Tec Corp 発注業務支援システム、データ処理装置、および制御プログラム
JP2014013532A (ja) * 2012-07-05 2014-01-23 Hamasaki Holding Co Ltd 在庫管理サーバ及び在庫管理システム
JP2015219781A (ja) * 2014-05-19 2015-12-07 東芝テック株式会社 発注装置およびプログラム

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH0696366A (ja) * 1992-06-02 1994-04-08 Nec Corp 発注システムにおける実績画面表示方式
JPH06149833A (ja) * 1992-11-12 1994-05-31 Tokyo Electric Co Ltd 商品発注装置
JP2001084239A (ja) * 1999-09-13 2001-03-30 Toshiba Corp 商品販売数量の分析方法、その予測方法、商品発注量の決定方法、及びプログラムを記憶した記憶媒体
JP2009187151A (ja) * 2008-02-05 2009-08-20 Tsc Consulting:Kk 在庫管理システム及び発注量算出プログラム
JP2012053764A (ja) * 2010-09-02 2012-03-15 Toshiba Tec Corp 発注業務支援システム、データ処理装置、および制御プログラム
JP2014013532A (ja) * 2012-07-05 2014-01-23 Hamasaki Holding Co Ltd 在庫管理サーバ及び在庫管理システム
JP2015219781A (ja) * 2014-05-19 2015-12-07 東芝テック株式会社 発注装置およびプログラム

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See also references of EP3509029A4 *

Similar Documents

Publication Publication Date Title
Hortaçsu et al. The ongoing evolution of US retail: A format tug-of-war
US8130102B1 (en) Advanced food and or drink organization and or handling system
JP2018041440A (ja) 発注支援システム
JP6929205B2 (ja) 管理システム
US20160092828A1 (en) System and Method for Taking Inventory and Ordering
US20170024751A1 (en) Fresh production forecasting methods and systems
CN110738438A (zh) 一种双平台同步的零售管理装置
JP6054165B2 (ja) 需要予測システムおよび需要予測方法
WO2018043617A1 (fr) Système d'assistance de commandes
JP5244409B2 (ja) 飲食物評価情報管理サーバ、及び飲食物評価情報管理システム
US20080133317A1 (en) Retail production guide for store-prepared food items
Beko et al. Demand models for direct mail and periodicals delivery services: Results for a transition economy
JP5108677B2 (ja) 商品カルテ管理サーバ、及び商品カルテ管理システム
JP6081180B2 (ja) 自動発注システムおよび自動発注方法
Artajaya et al. Analysis the Causes of High Food Costs and Food Cost Control Strategies at the Food and Beverage Product Department at the Four Points Hotel by Sheraton Bali
JP6437603B1 (ja) 発注システム
JP2009181475A (ja) 商品発注システム
JP5244408B2 (ja) 商品評価情報管理サーバ、及び商品評価情報管理システム
Villarreal et al. Reduce slow moving inventory of convenience stores: A case study
Fakokunde Explaining Quality Service Delivery of Nigerian Fast Food Entrepreneurs in the COVID-19 Era
Killeen Food waste at retail
JP7480406B1 (ja) 情報処理装置、情報処理方法およびプログラム
Masâ et al. An Analysis of Inventory Management at MJS Restaurant Jakarta
JP7067096B2 (ja) 売上データ処理装置、経営支援方法、プログラム及び売上データ処理システム
JP2005056236A (ja) 需要予測方法

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 17846621

Country of ref document: EP

Kind code of ref document: A1

ENP Entry into the national phase

Ref document number: 20197006020

Country of ref document: KR

Kind code of ref document: A

NENP Non-entry into the national phase

Ref country code: DE

ENP Entry into the national phase

Ref document number: 2017846621

Country of ref document: EP

Effective date: 20190401