TWI879256B - Processing system and method for order forecasting - Google Patents
Processing system and method for order forecasting Download PDFInfo
- Publication number
- TWI879256B TWI879256B TW112145701A TW112145701A TWI879256B TW I879256 B TWI879256 B TW I879256B TW 112145701 A TW112145701 A TW 112145701A TW 112145701 A TW112145701 A TW 112145701A TW I879256 B TWI879256 B TW I879256B
- Authority
- TW
- Taiwan
- Prior art keywords
- sales
- parameter
- parameters
- information
- estimation
- Prior art date
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Computer And Data Communications (AREA)
Abstract
Description
關於一種訂貨貨品數量的處理系統與方法,特別有關一種應用於門市訂貨的訂貨推估的處理系統與方法。The invention relates to a system and method for processing the quantity of ordered goods, and more particularly to a system and method for processing order estimation applied to store orders.
對於在不同客群範圍的超商而言,每一家超商的貨品需求也會有所不同。由於不同客群對於貨品需求都不一樣,所以超商店主除了根據總公司的建議外,僅能以過往銷售歷程作為進貨的判斷。超商店主除了要考量進貨貨品的類別外,也要考慮進貨數量。這對經驗不足的店主而言是一項嚴峻的挑戰。For convenience stores with different customer groups, the product demands of each convenience store will also be different. Because different customer groups have different product demands, supermarket owners can only make purchase decisions based on past sales history in addition to the recommendations of the head office. In addition to considering the types of goods to be purchased, supermarket owners also need to consider the quantity of goods to be purchased. This is a severe challenge for inexperienced store owners.
若貨品進貨數量過多,對於不同保存週期的貨品會產生不同的問題。以長週期貨品而言,門市會產生囤積的情況。對於短週期貨品而言,門市可能會發生大量報廢的情況。If the quantity of goods purchased is too large, different problems will arise for goods with different shelf life. For long-life goods, the store will have a situation of hoarding. For short-life goods, the store may have a large number of scrapped goods.
有鑑於此,在一實施例中,所述的訂貨推估的處理系統包括伺服端與訂貨端。伺服端具有第一通訊單元、第一儲存單元與第一處理單元,第一處理單元連接第一通訊單元與第一儲存單元,第一儲存單元儲存多個銷售參數與銷售歷程資訊,每一銷售參數匹配相應的商品類別,第一處理單元根據銷售歷程資訊與商品類別對銷售參數進行多元迴歸模型,用以選出至少一銷售參數,受選的銷售參數為受選參數,多元迴歸模型根據受選參數產生商品類別的貨量推估值,第一處理單元通過第一通訊單元發送貨量推估值;訂貨端具有第二通訊單元、第二儲存單元與第二處理單元,第二處理單元連接於第二通訊單元與第二儲存單元,第二通訊單元網路連接第一通訊單元,第二通訊單元接收貨量推估值,第二儲存單元儲存至少一商品類別相應的擬庫存數量資訊與在庫數量資訊,第二處理單元根據貨量推估值、擬庫存數量資訊與在庫數量資訊計算商品類別的進貨推估結果。In view of this, in one embodiment, the order estimation processing system includes a server and an ordering end. The server has a first communication unit, a first storage unit and a first processing unit. The first processing unit is connected to the first communication unit and the first storage unit. The first storage unit stores a plurality of sales parameters and sales history information. Each sales parameter matches a corresponding commodity category. The first processing unit performs a multivariate regression model on the sales parameters according to the sales history information and the commodity category to select at least one sales parameter. The selected sales parameter is the selected parameter. The multivariate regression model generates a quantity estimation value of the commodity category according to the selected parameter. The first processing unit generates a quantity estimation value of the commodity category according to the selected parameter. The unit sends a cargo volume estimation through a first communication unit; the ordering end has a second communication unit, a second storage unit and a second processing unit, the second processing unit is connected to the second communication unit and the second storage unit, the second communication unit is network-connected to the first communication unit, the second communication unit receives the cargo volume estimation, the second storage unit stores the virtual inventory quantity information and the inventory quantity information corresponding to at least one commodity category, and the second processing unit calculates the purchase estimation result of the commodity category according to the cargo volume estimation, the virtual inventory quantity information and the inventory quantity information.
所述的訂貨推估的處理系統可以根據不同的商品類別並提供相應的貨量推估值至訂貨端。訂貨端只需要根據貨架上的商品數量與庫存數量調整次回的進貨推估結果。The order estimation processing system can provide corresponding quantity estimation values to the ordering end according to different commodity categories. The ordering end only needs to adjust the purchase estimation result according to the quantity of commodities on the shelf and the inventory quantity.
在一實施例中,所述的訂貨推估的處理方法,包括伺服端對多個銷售參數進行多元迴歸模型,用以選出至少一銷售參數,受選的銷售參數為受選參數;伺服端根據受選參數產生貨量推估值;伺服端發送貨量推估值至訂貨端;訂貨端根據貨量推估值、擬庫存數量資訊、在庫數量資訊產生進貨推估結果。In one embodiment, the order estimation processing method includes a server side performing a multivariate regression model on a plurality of sales parameters to select at least one sales parameter, wherein the selected sales parameter is a selected parameter; the server side generates a quantity estimation value according to the selected parameter; the server side sends the quantity estimation value to the ordering side; the ordering side generates a purchase estimation result according to the quantity estimation value, the simulated inventory quantity information, and the inventory quantity information.
所述的訂貨推估的處理系統與處理方法可以應用在各項商品類別的訂貨數量推估的建議。訂貨推估的處理系統採用多元迴歸模型從多種銷售參數中選擇各店面門市的相應參數。因此處理系統可以提供各家門市相應的貨量推估值。訂貨端只要調整擬庫存數量資訊與在庫數量資訊就可以得到該項商品類別的進貨推估結果。如此一來,訂貨推估的處理系統可以降低門市在訂貨時對商品類別與其數量的評估成本。The order estimation processing system and processing method can be applied to the order quantity estimation suggestions for each commodity category. The order estimation processing system adopts a multivariate regression model to select the corresponding parameters of each store from a variety of sales parameters. Therefore, the processing system can provide the corresponding quantity estimation value of each store. The ordering end only needs to adjust the virtual inventory quantity information and the inventory quantity information to obtain the purchase estimation result of the commodity category. In this way, the order estimation processing system can reduce the evaluation cost of the store for the commodity category and its quantity when placing an order.
請參考圖1與圖2所示,分別為一實施例的訂貨推估的處理系統架構示意圖與系統元件示意圖。訂貨推估的處理系統(以下簡稱處理系統10)包括伺服端100與至少一訂貨端200。訂貨端200相應於各店面門市的計算設備,例如POS機(Point of Sale)、個人電腦(personal computer)、筆記型電腦(notebook)或平板電腦等。每一訂貨端200網路連接於伺服端100。伺服端100可以是雲端伺服器,也可以是設置於企業內部的獨立伺服器。Please refer to FIG. 1 and FIG. 2, which are respectively a schematic diagram of the order estimation processing system architecture and a schematic diagram of the system components of an embodiment. The order estimation processing system (hereinafter referred to as the processing system 10) includes a server 100 and at least one order terminal 200. The order terminal 200 corresponds to the computing equipment of each store, such as a POS (Point of Sale), a personal computer, a notebook or a tablet computer. Each order terminal 200 is connected to the server 100 via a network. The server 100 can be a cloud server or an independent server installed within the enterprise.
伺服端100具有第一通訊單元110、第一儲存單元120與第一處理單元130。第一處理單元130連接於第一通訊單元110與第一儲存單元120。第一儲存單元120儲存複數個商品類別320,該些商品類別320分別具有多個銷售參數121、銷售歷程資訊122與多元迴歸模型123。銷售參數121包括但不限定為月份、星期、季、氣象資訊、週期銷售額、假期銷售額、平日銷售額、平日假期銷售差異量、門市位置、訂貨頻率或其組合。而每一銷售參數121更具有多筆的參數資料。銷售歷程資訊122係為店面門市的各商品類別320的銷售量資訊。若訂貨端200已存在多次的訂貨記錄時,在每一項銷售參數121更包括多筆的參數資料。換言之,每一次訂購後伺服端100將會更新參數資料。參數資料可以是商品的銷售數據外,也可以是經過機器學習的超參數(Hyperparameter)或節點權重(weight)。若訂貨端200首次訂貨,銷售參數121的參數資料則為空集合(empty set)。The server 100 has a first communication unit 110, a first storage unit 120 and a first processing unit 130. The first processing unit 130 is connected to the first communication unit 110 and the first storage unit 120. The first storage unit 120 stores a plurality of commodity categories 320, each of which has a plurality of sales parameters 121, sales history information 122 and a multivariate regression model 123. The sales parameter 121 includes but is not limited to month, week, season, weather information, period sales, holiday sales, weekday sales, weekday holiday sales difference, store location, order frequency or a combination thereof. Each sales parameter 121 has a plurality of parameter data. The sales history information 122 is the sales volume information of each product category 320 of the store. If the ordering end 200 has multiple order records, each sales parameter 121 includes multiple parameter data. In other words, the server 100 will update the parameter data after each order. The parameter data can be the sales data of the product, or it can be a hyperparameter or node weight learned by machine. If the ordering end 200 places an order for the first time, the parameter data of the sales parameter 121 is an empty set.
而每一銷售參數121匹配相應的商品類別320。換言之,不同的商品類別320具有各自的銷售參數121。商品類別320的種類可以是麵食、百貨、常溫飲料、食材調味品、美容保健、糖果、健美機能、紙、生理用品、啤酒、冰品、冷凍食品、零食、烈酒、便利用品、國際精品、香菸、顧客服務、玩具、佣金代收售、自有通訊產品、電子支付儲值等之任一。第一處理單元130對商品類別320分別執行多元迴歸模型123計算,用以產生受選參數與貨量推估值410,其運作於後文詳述。Each sales parameter 121 matches a corresponding product category 320. In other words, different product categories 320 have their own sales parameters 121. The types of product categories 320 can be any of pasta, department stores, room temperature beverages, food and seasonings, beauty and health care, candy, bodybuilding functions, paper, sanitary products, beer, ice cream, frozen food, snacks, spirits, convenience products, international boutiques, cigarettes, customer service, toys, commission collection and sales, proprietary communication products, electronic payment recharge, etc. The first processing unit 130 performs a multivariate regression model 123 calculation on each product category 320 to generate selected parameters and cargo volume estimation 410, and its operation is described in detail later.
訂貨端200具有第二通訊單元210、第二儲存單元220與第二處理單元230。第二處理單元230連接第二通訊單元210與第二儲存單元220。第二通訊單元210可以通過乙太網路或電信網路連接於第一通訊單元110。第二通訊單元210用以傳送銷售歷程資訊122或接收貨量推估值410。第二儲存單元220儲存前端訂貨程式221、擬庫存數量資訊222與在庫數量資訊223。The ordering terminal 200 has a second communication unit 210, a second storage unit 220 and a second processing unit 230. The second processing unit 230 is connected to the second communication unit 210 and the second storage unit 220. The second communication unit 210 can be connected to the first communication unit 110 via an Ethernet or a telecommunications network. The second communication unit 210 is used to transmit sales history information 122 or receive a quantity estimation 410. The second storage unit 220 stores a front-end ordering program 221, a simulated inventory quantity information 222 and an in-stock quantity information 223.
擬庫存數量資訊222係為所指定的商品類別320預計在店面門市中要有的商品庫存數量。在一些實施例中,擬庫存數量資訊222係為貨架可陳列貨品量與安全庫存量之總和。貨架可陳列貨品量係為商品類別320在門市貨架310上可以被陳列的貨品數量。門市貨架310的高度、寬度與深度均會影響商品類別320的可陳列數量,並且每一店面的門市貨架310數量不一,實際可陳列的總數量亦會不同。此外,門市貨架310也會隨著裝潢或其他因素而調整,使得各活動檔期的貨架可陳列貨品量隨之改變。進一步,配合陳列方式或上架及拿取方便考量,貨架可陳列貨品量亦可隨之調整。因此,各訂貨端200需要記錄所屬的貨架可陳列貨品量。安全庫存量係為單店單日的商品銷售數量(per store per day)的倍數值,其中倍數值大於或等於「1」。The simulated inventory quantity information 222 is the quantity of goods that the specified commodity category 320 is expected to have in the store. In some embodiments, the simulated inventory quantity information 222 is the sum of the quantity of goods that can be displayed on the shelf and the safety inventory. The quantity of goods that can be displayed on the shelf is the quantity of goods that can be displayed on the store shelf 310 of the commodity category 320. The height, width and depth of the store shelf 310 will affect the quantity that can be displayed of the commodity category 320, and the number of store shelves 310 in each store is different, and the actual total quantity that can be displayed will also be different. In addition, the store shelves 310 will also be adjusted according to decoration or other factors, so that the quantity of goods that can be displayed on the shelves during each activity period will change accordingly. Furthermore, the quantity of goods that can be displayed on the shelf can be adjusted according to the display method or the convenience of putting on the shelf and taking out. Therefore, each order terminal 200 needs to record the quantity of goods that can be displayed on the shelf. The safety stock quantity is a multiple value of the sales quantity of a single store per day (per store per day), where the multiple value is greater than or equal to "1".
在庫數量資訊223係為店面門市中該項商品類別320的實際庫存數量與在途進貨數量的總和。在途進貨數量係為訂貨端200已發出訂貨要求,但還未入庫的商品數量。The inventory quantity information 223 is the sum of the actual inventory quantity of the product category 320 in the store and the in-transit quantity. The in-transit quantity is the quantity of products that have been ordered by the ordering end 200 but have not yet been put into the warehouse.
為清楚說明處理系統10進行訂貨數量的推估,請配合圖3。訂貨推估的處理方法包括以下步驟: 步驟S310:伺服端100對商品類別320的每一個所具有的多個銷售參數121進行多元迴歸模型計算,用以選出至少一銷售參數121,受選的至少一銷售參數121為受選參數; 步驟S320:伺服端100根據受選參數計算產生每一商品類別320的貨量推估值410; 步驟S330:伺服端100發送貨量推估值410至訂貨端200;以及 步驟S340:訂貨端200根據貨量推估值410、擬庫存數量資訊與在庫數量資訊計算進貨推估結果。 To clearly illustrate the estimation of order quantity by the processing system 10, please refer to FIG. 3. The processing method of order estimation includes the following steps: Step S310: The server end 100 performs a multivariate regression model calculation on the multiple sales parameters 121 of each product category 320 to select at least one sales parameter 121, and the selected at least one sales parameter 121 is a selected parameter; Step S320: The server end 100 calculates and generates a quantity estimation value 410 of each product category 320 according to the selected parameter; Step S330: The server end 100 sends the quantity estimation value 410 to the order end 200; and Step S340: The order end 200 calculates the purchase estimation result according to the quantity estimation value 410, the simulated inventory quantity information and the inventory quantity information.
伺服端100接收各訂貨端200的銷售歷程資訊122。訂貨端200可以定時向伺服端100發送指定時段中商品類別320所對應的銷售歷程資訊122,或是訂貨端200的銷售歷程資訊122累積至指定數量後,再向伺服端100發送銷售歷程資訊122。伺服端100根據新的銷售歷程資訊122附加至(append)現有的銷售歷程資訊122。The server 100 receives the sales history information 122 from each ordering terminal 200. The ordering terminal 200 can periodically send the sales history information 122 corresponding to the product category 320 in a specified time period to the server 100, or send the sales history information 122 to the server 100 after the sales history information 122 of the ordering terminal 200 accumulates to a specified amount. The server 100 appends the new sales history information 122 to the existing sales history information 122.
伺服端100可以在接獲訂貨端200的銷售歷程資訊122後,第一處理單元130對複數商品類別320分別根據銷售歷程資訊122對所有的銷售參數121執行多元迴歸模型123計算。或者,伺服端100於指定時間執行多元迴歸模型123計算,例如:伺服器每週一AM00:00時執行多元迴歸模型123計算。第一處理單元130對銷售參數121執行多元迴歸模型123計算(對應步驟S310)。多元迴歸模型123係為逐步迴歸處理(Stepwise Regression)、多重線性迴歸(Multiple Linear Regression)、多項式迴歸(Polynomial Regression)、主成分迴歸(Principal Component Regression,PCR)或時間序列迴歸(Time Series Regression)之任一。After receiving the sales history information 122 from the ordering end 200, the server end 100 can execute the multivariate regression model 123 calculation on all the sales parameters 121 for the plurality of product categories 320 according to the sales history information 122. Alternatively, the server end 100 executes the multivariate regression model 123 calculation at a specified time, for example, the server executes the multivariate regression model 123 calculation at 00:00 AM every Monday. The first processing unit 130 executes the multivariate regression model 123 calculation on the sales parameters 121 (corresponding to step S310). The multivariate regression model 123 is any one of stepwise regression, multiple linear regression, polynomial regression, principal component regression (PCR), or time series regression.
多元迴歸模型123以迭代(iterative)方式逐次選出一個銷售參數121。銷售參數121選出後會進行判定係數的相關計算,用以判斷此一銷售參數121是否為適格的參數。若為適格的銷售參數121則稱其為受選參數。由於所選出的銷售參數121並非都是受選參數,所以將選出的銷售參數121稱其為暫時參數(無標號)。舉例來說,銷售參數121的集合為(X 1,X 2,X 3...,X n),而受選參數為(X` i),Y為預測目標,R i 2為判定係數(coefficient of determination),其中i為銷售參數121的數量且i∈(1,2,3...,n)。 The multivariate regression model 123 selects a sales parameter 121 in an iterative manner. After the sales parameter 121 is selected, the relevant calculation of the determination coefficient is performed to determine whether the sales parameter 121 is a qualified parameter. If it is a qualified sales parameter 121, it is called a selected parameter. Since not all the selected sales parameters 121 are selected parameters, the selected sales parameters 121 are called temporary parameters (no labels). For example, the set of sales parameters 121 is (X 1 ,X 2 ,X 3 ...,X n ), and the selected parameter is (X` i ), Y is the prediction target, R i 2 is the coefficient of determination, where i is the number of sales parameters 121 and i∈(1,2,3...,n).
多元迴歸模型123在初始階段中,第一處理單元130根據預設週期與相應的銷售歷程資訊122決定至少一預測目標。此外,多元迴歸模型123也可以選擇預設值以作為預測目標。一般而言,預設週期係為店面門市(意即訂貨端200)的訂貨週期的集合。例如:預設週期若為一年,而訂貨週期為一週,則預設週期包含該年中的52週集合。或是在特賣活動的期間,預設週期可以由訂貨端200或伺服端100自行定義。In the initial stage of the multivariate regression model 123, the first processing unit 130 determines at least one prediction target based on the default cycle and the corresponding sales history information 122. In addition, the multivariate regression model 123 can also select a default value as a prediction target. Generally speaking, the default cycle is a set of order cycles of the store outlets (i.e., the ordering end 200). For example: if the default cycle is one year and the order cycle is one week, the default cycle includes a set of 52 weeks in that year. Or during a special sale, the default cycle can be defined by the ordering end 200 or the server end 100.
第一處理單元130計算各暫時參數對預測目標的判定係數,直至第一處理單元130獲得所有暫時參數的判定係數。對於判定係數而言,判定係數的數值介於[0,1]之間。當判定係數的數值越接近「1」代表多元迴歸模型123的擬合結果越好。接著,第一處理單元130選擇判定係數為最大值的暫時參數,並暫存此一暫時參數,在此稱其為第一參數(意即為受選參數)。多元迴歸模型123則完成此次的運算回合,並為便於說明,將此一運算回合的預測目標Y與相應的受選參數記載為「Y->X` a」,a ∈(1,2,3...,n))。 The first processing unit 130 calculates the judgment coefficient of each temporary parameter for the prediction target until the first processing unit 130 obtains the judgment coefficients of all temporary parameters. For the judgment coefficient, the value of the judgment coefficient is between [0,1]. The closer the value of the judgment coefficient is to "1", the better the fitting result of the multivariate regression model 123. Then, the first processing unit 130 selects the temporary parameter with the maximum judgment coefficient and temporarily stores this temporary parameter, which is referred to as the first parameter (that is, the selected parameter). The multivariate regression model 123 completes this round of calculation, and for the convenience of explanation, the prediction target Y of this round of calculation and the corresponding selected parameter are recorded as "Y-> X`a ", a∈(1,2,3...,n)).
在一些實施例中,第一處理單元130可以採用逐步迴歸分析方法。在逐步迴歸分析方法的訓練階段中,為每一個逐步迴歸分析模型迭代重新配適最適合的因子集合與迴歸係數。第一處理單元130首先考慮單一因子對於因變量的解釋力,並逐步添加其他因子。In some embodiments, the first processing unit 130 may use a stepwise regression analysis method. In the training phase of the stepwise regression analysis method, the most suitable factor set and regression coefficient are iteratively refitted for each stepwise regression analysis model. The first processing unit 130 first considers the explanatory power of a single factor for the dependent variable, and gradually adds other factors.
第一處理單元130從多個銷售參數121中選擇任一,並計算所選出的銷售參數121的判斷係數。第一處理單元130保存判斷係數最大的銷售參數121。接著,第一處理單元130再從剩餘的銷售參數121中選擇第二個銷售參數121。第一處理單元130從剩餘的銷售參數121中挑選出能使判斷係數最大的銷售參數121。這個選擇過程形成一個循環,並以信息準則如赤城信息準則(Akaike Information Criterion)、貝葉斯信息量準則(Bayesian information criterion)或錦葵信息量準則(Mallows's CP)作為終止條件。當擬合度不再顯著提升或未達到預定的門檻條件時,循環結束,並確定模型中因子的最終集合,從而獲得最佳的擬合結果。The first processing unit 130 selects any one of the multiple sales parameters 121 and calculates the judgment coefficient of the selected sales parameter 121. The first processing unit 130 saves the sales parameter 121 with the largest judgment coefficient. Then, the first processing unit 130 selects a second sales parameter 121 from the remaining sales parameters 121. The first processing unit 130 selects the sales parameter 121 that can maximize the judgment coefficient from the remaining sales parameters 121. This selection process forms a loop and uses an information criterion such as Akaike Information Criterion, Bayesian information criterion, or Mallows's CP as a termination condition. When the fit is no longer significantly improved or the predetermined threshold condition is not met, the loop ends and the final set of factors in the model is determined to obtain the best fit result.
以赤城信息準則為例,赤城信息準則的計算結果越小,代表多元迴歸模型123的擬合結果越好。所述門檻條件可以是指定數值,也可以是不同運算回合的擬合結果的差值。以多組相鄰兩回合的擬合結果的差值排列,可以判斷擬合結果的差值逐漸降低,則表示擬合結果開始收斂。Taking the Akagi information criterion as an example, the smaller the calculation result of the Akagi information criterion, the better the fitting result of the multivariate regression model 123. The threshold condition can be a specified value or the difference between the fitting results of different calculation rounds. By arranging the difference between the fitting results of two adjacent rounds, it can be judged that the difference between the fitting results gradually decreases, which means that the fitting results begin to converge.
第一處理單元130從剩餘的銷售參數121中選擇任一,將新選出的銷售參數121(意即新選出的暫存參數)與預測目標Y的對應關係記載為「Y->X` a+X` b」。第一處理單元130根據新選出的暫存參數與第一參數對預測目標計算相應的擬合結果。第一處理單元130重複選擇銷售參數121,直至遍歷所有銷售參數121並獲得各銷售參數121與第一參數所相應的判定係數為止。 The first processing unit 130 selects any one of the remaining sales parameters 121, and records the corresponding relationship between the newly selected sales parameter 121 (i.e., the newly selected temporary parameter) and the forecast target Y as "Y->X'a + X'b ". The first processing unit 130 calculates the corresponding fitting result for the forecast target based on the newly selected temporary parameter and the first parameter. The first processing unit 130 repeatedly selects sales parameters 121 until all sales parameters 121 are traversed and the determination coefficient corresponding to each sales parameter 121 and the first parameter is obtained.
接著,第一處理單元130從此一運算回合中的所有判定係數中選擇判定係數最大者為擬合結果。而在此一運算回合中被選出的兩暫存參數,則稱為第二參數(意即為受選參數)。第一處理單元130再以信息準則判斷判定係數的擬合結果是否收斂至門檻條件。Next, the first processing unit 130 selects the one with the largest judgment coefficient from all judgment coefficients in this calculation round as the fitting result. The two temporary parameters selected in this calculation round are called second parameters (i.e., selected parameters). The first processing unit 130 then uses the information criterion to determine whether the fitting result of the judgment coefficient converges to the threshold condition.
若未符合收斂至門檻條件,第一處理單元130重複執行選擇銷售參數121與判斷擬合結果,直至擬合結果收斂至門檻條件為止。第一處理單元130選擇符合門檻條件的受選參數的集合。而所選出的受選參數與預測目標Y可以以下式表示: Y=a 1*X` a+a 2*X` b+.....+a m*X` m,m≤n,a為迴歸係數 式1 If the convergence to the threshold condition is not met, the first processing unit 130 repeatedly executes the selection of sales parameters 121 and the determination of the fitting result until the fitting result converges to the threshold condition. The first processing unit 130 selects a set of selected parameters that meet the threshold condition. The selected selected parameters and the prediction target Y can be expressed as follows: Y = a 1 *X` a + a 2 *X` b + ..... + a m *X` m , m ≤ n, a is the regression coefficient Formula 1
式1係為受選參數通過多元迴歸模型123所輸出的貨量推估F算式。第一處理單元130根據受選參數與貨量推估F算式計算貨量推估值410(對應步驟S320)。Formula 1 is a cargo volume estimation F formula output by the selected parameters through the multivariate regression model 123. The first processing unit 130 calculates the cargo volume estimation value 410 according to the selected parameters and the cargo volume estimation F formula (corresponding to step S320).
舉例來說,受選參數分別為[月份,星期,季,氣溫],且以判定係數與赤城信息準則的計算結果如下表:
從表1可知,受選參數在加入「星期」後,多元迴歸模型123的擬合程度開始提高(意即前述的收斂)。「月份」即為第一參數,而「月份,星期」為第二參數,對於其他運算回合可類推至第三參數或更多。As can be seen from Table 1, after the selected parameters are added with "week", the degree of fit of the multivariate regression model 123 begins to improve (i.e., the aforementioned convergence). "Month" is the first parameter, and "month, week" is the second parameter. For other calculation rounds, the third parameter or more can be inferred.
受選參數「星期」與「季」加入後,對於多元迴歸模型123的擬合程度也有改善。隨後,當「氣溫」被引入多元迴歸模型123時,雖然判斷係數有所增加,但其提升幅度相對於前兩參數的增加較小。這表明「氣溫」對於銷售量變化的解釋能力相對較弱。儘管如此,「氣溫」與銷售量之間存在一定的相關性。在此也將受選參數「氣溫」視為符合門檻條件。第一處理單元130根據前述受選參數與預測目標獲得貨量推估F算式(意即式2)。After the selected parameters "week" and "season" are added, the degree of fit of the multivariate regression model 123 is also improved. Subsequently, when "temperature" is introduced into the multivariate regression model 123, although the judgment coefficient increases, its increase is smaller than the increase of the first two parameters. This shows that the explanatory power of "temperature" for changes in sales volume is relatively weak. Nevertheless, there is a certain correlation between "temperature" and sales volume. Here, the selected parameter "temperature" is also regarded as meeting the threshold condition. The first processing unit 130 obtains the cargo volume estimation F formula (i.e., Formula 2) based on the aforementioned selected parameters and the forecast target.
接著,第一處理單元130可以根據所欲預測銷售參數121與相關資訊帶入式2。為方便說明在此假設迴歸係數分別為[a1=0.4,a2=3,a3=2,a4=0.1],並且預測「 2023 年 8 月第 3 週,星期一,氣溫:30度」的預測目標,但實際上迴歸係數需以所有的銷售參數121進行最小化殘差平方和(Ordinary Least Squares,OLS)而獲得。下式是各受選參數的貢獻度總和從而獲得預測目標Y: 預測目標 = 0.4*8+3*1+2*3+0.1*30 = 15.2≒16 式3 Then, the first processing unit 130 can substitute the sales parameter 121 and related information to be predicted into Formula 2. For the convenience of explanation, it is assumed that the regression coefficients are [a1=0.4, a2=3, a3=2, a4=0.1], and the prediction target of "Monday, the third week of August 2023, temperature: 30 degrees" is predicted, but the actual regression coefficients need to be obtained by minimizing the Ordinary Least Squares (OLS) of all sales parameters 121. The following formula is the sum of the contributions of each selected parameter to obtain the predicted target Y: Prediction target = 0.4*8+3*1+2*3+0.1*30 = 15.2≒16 Formula 3
第一處理單元130將受選參數帶入式2,其中「月份」為"8"、「星期」為"1",「季」為"3",從而獲得式3的計算結果。此一計算結果係為貨量推估值410。第一處理單元130將貨量推估值410發送至訂貨端200(對應步驟S330)。The first processing unit 130 substitutes the selected parameters into Formula 2, where "month" is "8", "week" is "1", and "quarter" is "3", thereby obtaining the calculation result of Formula 3. This calculation result is the estimated quantity 410. The first processing unit 130 sends the estimated quantity 410 to the ordering terminal 200 (corresponding to step S330).
相較於受選參數直接帶入的實施態樣外,在一些實施例中,在第一處理單元130進行預測目標的處理前,第一處理單元130可以針對屬於離散變數種類的受選參數進行獨熱編碼處理(One-Hot Encoding),使屬於離散變數種類的受選參數指派相應的獨熱碼與迴歸係數。Compared to the implementation mode in which the selected parameters are directly introduced, in some embodiments, before the first processing unit 130 performs the processing of the prediction target, the first processing unit 130 can perform one-hot encoding processing (One-Hot Encoding) on the selected parameters belonging to the discrete variable type, so that the selected parameters belonging to the discrete variable type are assigned corresponding one-hot codes and regression coefficients.
承前述例子,若受選參數「星期」屬於離散變數,因此第一處理單元130可以將受選參數「星期」進行獨熱編碼。受選參數「星期」可以用7個位元表示,例如受選參數「星期」的獨熱編碼為(0,0,0,0,0,0,0)。當第一處理單元130獲取受選參數「星期」與預測銷售參數121後,第一處理單元130可以根據預測銷售參數121選擇受選參數「星期」相應的獨熱編碼,請參考下表。
當第一處理單元130選擇「星期一」的預測銷售參數121,第一處理單元130將選擇獨熱編碼(1,0,0,0,0,0,0)與迴歸係數。接著,第一處理單元130將受選的獨熱編碼與迴歸係數進行相乘,用以獲得受選參數的貢獻量。仍以「星期一」為例,第一處理單元130選擇獨熱編碼(1,0,0,0,0,0,0)與迴歸係數「0.5」,並將其相乘1*0.5從而獲得受選參數的貢獻量「0.5」。第一處理單元130將受選參數(對應例子的「星期」)的貢獻量與其他受選參數的貢獻量加總,從而獲得所有受選參數的預測目標。When the first processing unit 130 selects the predicted sales parameter 121 of "Monday", the first processing unit 130 selects the one-hot code (1,0,0,0,0,0,0) and the regression coefficient. Then, the first processing unit 130 multiplies the selected one-hot code and the regression coefficient to obtain the contribution of the selected parameter. Still taking "Monday" as an example, the first processing unit 130 selects the one-hot code (1,0,0,0,0,0,0) and the regression coefficient "0.5", and multiplies them by 1*0.5 to obtain the contribution of the selected parameter "0.5". The first processing unit 130 adds the contribution of the selected parameter (corresponding to the “week” in this example) with the contributions of other selected parameters to obtain the predicted targets of all selected parameters.
此外,第一處理單元130可以對各受選參數的貢獻度總和再加上截距項,藉以調整多元迴歸模型123中各受選參數所產生的無法解釋部分。舉例來說,若截距項為「3.5」,則第一處理單元130將會在式1中加上截距項,如下式4所示: 預測目標 = a 1*X` a+a 2*X` b+.....+a m*X` m+ 3.5 式4 In addition, the first processing unit 130 can add an intercept term to the sum of the contributions of each selected parameter to adjust the unexplained portion generated by each selected parameter in the multivariate regression model 123. For example, if the intercept term is "3.5", the first processing unit 130 will add the intercept term to Formula 1, as shown in Formula 4 below: Prediction target = a 1 *X` a +a 2 *X` b +.....+ am *X` m + 3.5 Formula 4
訂貨端200接獲貨量推估值410後,第二處理單元230執行前端訂貨程式221。前端訂貨程式221根據貨量推估值410、擬庫存數量資訊222、在庫數量資訊223計算該項商品類別320的進貨推估結果,請參考圖4。在一些實施例中,第二處理單元230將貨量推估值410加上擬庫存數量資訊222後,再減去在庫數量資訊223,用以獲得進貨推估結果I(對應步驟S340)。訂貨端200獲得進貨推估結果I後,訂貨端200可以向伺服端100或相關後台提交進貨推估結果I。在圖4的前端訂貨程式221的畫面中,「貨量推估」係為貨量推估值410,其值以「F」為例、「擬庫存數量」係為擬庫存數量資訊222,其值以「M」為例、「在庫數量」係為在庫數量資訊223,其值以「O」為例。因此進貨推估結果I的計算結果為「F+M-O=I」。After the ordering terminal 200 receives the estimated quantity 410, the second processing unit 230 executes the front-end ordering program 221. The front-end ordering program 221 calculates the purchase estimation result of the commodity category 320 according to the estimated quantity 410, the virtual inventory quantity information 222, and the inventory quantity information 223, please refer to FIG. 4. In some embodiments, the second processing unit 230 adds the estimated quantity 410 to the virtual inventory quantity information 222, and then subtracts the inventory quantity information 223 to obtain the purchase estimation result I (corresponding to step S340). After the ordering terminal 200 obtains the purchase estimation result I, the ordering terminal 200 can submit the purchase estimation result I to the server 100 or the related backend. In the screen of the front-end ordering program 221 in FIG. 4, "Stock quantity estimation" is the stock quantity estimation value 410, and its value is "F" as an example, "Pseudo inventory quantity" is the pseudo inventory quantity information 222, and its value is "M" as an example, and "In-stock quantity" is the in-stock quantity information 223, and its value is "O" as an example. Therefore, the calculation result of the purchase estimation result I is "F+M-O=I".
在一些實施例中,伺服端100中針對新設立的店面門市,在取得初次訂貨端200的銷售參數121前,第一儲存單元120中尚無記錄任何訂貨端200的銷售參數121。因此,第一處理單元130執行多元迴歸模型123時,將會判斷第一儲存單元120中是否存在銷售參數121。當銷售參數121為空集合時,第一處理單元130將預設數量直接視為進貨推估結果I,而省略步驟S320至步驟S340的計算。預設數量可以是由訂貨端200所提供,也可以根據其他訂貨端200的銷售參數121所決定。In some embodiments, for a newly established storefront in the server 100, before obtaining the sales parameter 121 of the first ordering end 200, the first storage unit 120 has not recorded any sales parameter 121 of the ordering end 200. Therefore, when the first processing unit 130 executes the multivariate regression model 123, it will determine whether the sales parameter 121 exists in the first storage unit 120. When the sales parameter 121 is an empty set, the first processing unit 130 directly regards the preset quantity as the purchase estimation result I, and omits the calculation of steps S320 to S340. The preset quantity can be provided by the ordering end 200, or it can be determined based on the sales parameter 121 of other ordering ends 200.
在一些實施例中,訂貨端200每經過預設時期後,訂貨端200向伺服端100發送更新要求,用以向伺服端100獲取預設時期的貨量推估值410。舉例來說,訂貨端200可以每到週一向伺服端100發送更新要求,用以獲取接下來一週的貨量推估值410。In some embodiments, after a preset period, the ordering end 200 sends an update request to the server 100 to obtain the estimated quantity 410 of the preset period from the server 100. For example, the ordering end 200 may send an update request to the server 100 every Monday to obtain the estimated quantity 410 of the next week.
所述的訂貨推估的處理系統10與處理方法可以應用在各項商品類別320的進貨數量推估的建議。訂貨推估的處理系統10採用多元迴歸模型123從多種銷售參數121中選擇各店面門市分別最佳的相應參數,而非全部統一使用相同的參數。如此,可避免忽略各店面門市可能應適用的最佳銷售參數121,或增加該店面門市不適用之銷售參數121,進而影響最終計算結果。因此處理系統10可以根據不同店面門市提供各家店面門市相應的貨量推估值410。訂貨端200只要調整擬庫存數量資訊222與在庫數量資訊223就可以得到該項商品類別320的進貨推估結果I。如此一來,訂貨推估的處理系統10可以降低門市在訂貨時對商品類別320與其數量的評估成本。The order estimation processing system 10 and processing method can be applied to the recommendation of purchase quantity estimation for each commodity category 320. The order estimation processing system 10 adopts a multivariate regression model 123 to select the best corresponding parameters for each store from a variety of sales parameters 121, rather than using the same parameters uniformly. In this way, it is possible to avoid ignoring the best sales parameters 121 that may be applicable to each store, or adding sales parameters 121 that are not applicable to the store, thereby affecting the final calculation result. Therefore, the processing system 10 can provide each store with a corresponding quantity estimation value 410 according to different store. The order end 200 only needs to adjust the virtual inventory quantity information 222 and the inventory quantity information 223 to obtain the purchase estimation result I of the commodity category 320. In this way, the order estimation processing system 10 can reduce the evaluation cost of the merchandise category 320 and its quantity when the store places an order.
10:處理系統 100:伺服端 110:第一通訊單元 120:第一儲存單元 121:銷售參數 122:銷售歷程資訊 123:多元迴歸模型 130:第一處理單元 200:訂貨端 210:第二通訊單元 220:第二儲存單元 221:前端訂貨程式 222:擬庫存數量資訊 223:在庫數量資訊 230:第二處理單元 310:門市貨架 320:商品類別 410:貨量推估值 F:貨量推估 M: 擬庫存數量資訊 O:在庫數量 I:進貨推估結果 S310,S320,S330,S340:步驟 10: Processing system 100: Server 110: First communication unit 120: First storage unit 121: Sales parameters 122: Sales history information 123: Multivariate regression model 130: First processing unit 200: Ordering end 210: Second communication unit 220: Second storage unit 221: Front-end ordering program 222: Pseudo inventory quantity information 223: In-stock quantity information 230: Second processing unit 310: Store shelves 320: Product category 410: Quantity estimation F: Quantity estimation M: Pseudo inventory quantity information O: In-stock quantity I: Purchase estimation result S310, S320, S330, S340: Steps
圖1為一實施例的訂貨推估的處理系統架構示意圖。 圖2為一實施例的系統元件示意圖。 圖3為一實施例的訂貨推估的處理流程示意圖。 圖4為一實施例的前端訂貨程式的介面示意圖。 Figure 1 is a schematic diagram of the processing system architecture of an order estimation in an embodiment. Figure 2 is a schematic diagram of the system components in an embodiment. Figure 3 is a schematic diagram of the processing flow of order estimation in an embodiment. Figure 4 is a schematic diagram of the interface of the front-end ordering program in an embodiment.
10:處理系統 10: Processing system
100:伺服端 100: Server side
110:第一通訊單元 110: First communication unit
120:第一儲存單元 120: First storage unit
121:銷售參數 121: Sales parameters
122:銷售歷程資訊 122: Sales history information
123:多元迴歸模型 123:Multivariate regression model
130:第一處理單元 130: First processing unit
200:訂貨端 200: Order side
210:第二通訊單元 210: Second communication unit
220:第二儲存單元 220: Second storage unit
221:前端訂貨程式 221: Front-end ordering program
222:擬庫存數量資訊 222: Specified inventory quantity information
223:在庫數量資訊 223: Inventory quantity information
230:第二處理單元 230: Second processing unit
410:貨量推估值 410: Valuation based on volume
Claims (13)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| TW112145701A TWI879256B (en) | 2023-11-24 | 2023-11-24 | Processing system and method for order forecasting |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| TW112145701A TWI879256B (en) | 2023-11-24 | 2023-11-24 | Processing system and method for order forecasting |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| TWI879256B true TWI879256B (en) | 2025-04-01 |
| TW202522319A TW202522319A (en) | 2025-06-01 |
Family
ID=96142104
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| TW112145701A TWI879256B (en) | 2023-11-24 | 2023-11-24 | Processing system and method for order forecasting |
Country Status (1)
| Country | Link |
|---|---|
| TW (1) | TWI879256B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115131056A (en) * | 2022-05-16 | 2022-09-30 | 中国科学技术大学 | Advertisement inventory estimation method, device and application system |
| TWI793580B (en) * | 2021-04-21 | 2023-02-21 | 財團法人工業技術研究院 | Automated inventory management method and system thereof |
| CN116681380A (en) * | 2023-06-29 | 2023-09-01 | 上海壹佰米网络科技有限公司 | Inventory management method, device, computing equipment and storage medium |
| CN116720811A (en) * | 2023-08-10 | 2023-09-08 | 山东水发大正物联科技有限公司 | Warehouse management method and system based on Internet of things |
| US20230316223A1 (en) * | 2022-04-05 | 2023-10-05 | Thrive Technologies, Inc. | System and processes for optimizing inventory |
| TWM652022U (en) * | 2023-11-24 | 2024-02-21 | 統一超商股份有限公司 | Order estimation processing system |
-
2023
- 2023-11-24 TW TW112145701A patent/TWI879256B/en active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TWI793580B (en) * | 2021-04-21 | 2023-02-21 | 財團法人工業技術研究院 | Automated inventory management method and system thereof |
| US20230316223A1 (en) * | 2022-04-05 | 2023-10-05 | Thrive Technologies, Inc. | System and processes for optimizing inventory |
| CN115131056A (en) * | 2022-05-16 | 2022-09-30 | 中国科学技术大学 | Advertisement inventory estimation method, device and application system |
| CN116681380A (en) * | 2023-06-29 | 2023-09-01 | 上海壹佰米网络科技有限公司 | Inventory management method, device, computing equipment and storage medium |
| CN116720811A (en) * | 2023-08-10 | 2023-09-08 | 山东水发大正物联科技有限公司 | Warehouse management method and system based on Internet of things |
| TWM652022U (en) * | 2023-11-24 | 2024-02-21 | 統一超商股份有限公司 | Order estimation processing system |
Also Published As
| Publication number | Publication date |
|---|---|
| TW202522319A (en) | 2025-06-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Mahajan et al. | Inventory competition under dynamic consumer choice | |
| US11151496B2 (en) | Parallel lead time determinations in supply chain architecture | |
| US10318921B1 (en) | Forecasting returns for retail demand planning | |
| US10181107B2 (en) | Using consumption data and an inventory model to generate a replenishment plan | |
| Acimovic et al. | The fulfillment-optimization problem | |
| US20220284386A1 (en) | Computerized inventory redistribution control system | |
| US20200005209A1 (en) | Method and system for optimizing an item assortment | |
| US20110054982A1 (en) | Methods and systems for randomizing starting retail store inventory when determining distribution center and warehouse demand forecasts | |
| US20160232461A1 (en) | System and method for determining forecast errors for merchandise in retail | |
| TWI809579B (en) | Automated inventory management system and method thereof | |
| US20200111033A1 (en) | Lead time determinations in supply chain architecture | |
| US11403574B1 (en) | Method and system for optimizing an item assortment | |
| CN115879996A (en) | Automatic Forecasting Method of Order Quantity Based on Historical Sales Data and Data Variables | |
| CN110379074A (en) | A kind of system and method for the automatic cycle shipment of vending machine | |
| CN109447732A (en) | Shops's product ordering method and device | |
| Rao et al. | The algorithms that make Instacart roll: How machine learning and other tech tools guide your groceries from store to doorstep | |
| TWM652022U (en) | Order estimation processing system | |
| US12223538B2 (en) | Methods and non-transitory computer readable storage medium for showing availability of orders for concierge shopping service | |
| WO2019161394A1 (en) | Lead time determinations in supply chain architecture | |
| TWI879256B (en) | Processing system and method for order forecasting | |
| CN112132619A (en) | Order decision method and system for fresh products | |
| US12079828B2 (en) | Multi-channel demand planning for inventory planning and control | |
| US7809581B1 (en) | Rule relaxation and subset optimization system | |
| Wang et al. | Integrating dynamic pricing and inventory control for fresh agriproduct under multinomial logit choice | |
| Federgruen et al. | Competition in multi-echelon systems |