Dự báo cơ sở statsforecast

ABN Demand Planning

2026-11-19 23:56
Báo cáodự báo cơ sở statsforecast
Dùng đểTạo dự báo cơ sở đáng tin cậy làm tham chiếu mặc định cho lập kế hoạch tồn kho và bán hàng.
Câu hỏi trả lờiQ1: Tháng tới dự kiến bán được bao nhiêu sản phẩm, theo từng nhóm hàng × kênh?
DF-2: Dự báo 3 tháng tới theo nhóm hàng × kênh, kèm khoảng tin cậy?
Tạo lúc2026-11-19 23:56
Dữ liệu đến ngày2026-11-19
Phương pháp tính (kỹ thuật)
Huấn luyện AutoARIMA (tự động chọn p,d,q,P,D,Q qua AICc) và AutoETS trên từng chuỗi Phân loại×Kênh. Dự báo 3 tháng tới. Tổ hợp = trung bình đơn giản của cả hai mô hình. Báo cáo khoảng dự đoán 80%/95%.
Lịch sử bán hàng→Nhóm theo Class × Kênh→Dự báo thống kê→Dự báo 3 tháng

Dữ liệu đầu vào

Chuỗi thời gian
9
Class × Channel
Khoảng thời gian
2024-02-01 → 2026-11-01
Tổng số dòng
306
Tầm dự báo
3 tháng
unique_iddsy
Latex_Ecom2024-02-01 00:00:00558
Latex_Ecom2024-03-01 00:00:00453
Latex_Ecom2024-04-01 00:00:00444
Latex_Ecom2024-05-01 00:00:00431
Latex_Ecom2024-06-01 00:00:00388
Latex_Ecom2024-07-01 00:00:00403
Latex_Ecom2024-08-01 00:00:00426
Latex_Ecom2024-09-01 00:00:00419
Latex_Ecom2024-10-01 00:00:00459
Latex_Ecom2024-11-01 00:00:00459
Latex_Ecom2024-12-01 00:00:00492
Latex_Ecom2025-01-01 00:00:00750

Quy trình xử lý

1Đọc dữ liệu doanh số lịch sử từ CSV/BigQuery
↓
2Nhóm theo unique_id (Class × Channel) và tháng
↓
3Chạy AutoARIMA(season_length=12) + AutoETS(season_length=12)
↓
4Xuất dự báo 3 tháng với khoảng tin cậy 80% và 95%

Kết quả dự báo

Tổng quan dự báo
Tổng dự báo 3 tháng: 12,055 đơn vị
Top 3 chuỗi: Pillow_Offline: 2,823, Latex_Offline: 2,284, Pillow_Ecom: 1,653
27 dòng dự báo cho 9 chuỗi thời gian
Forecast Chart
indexunique_iddsAutoARIMAAutoARIMA-lo-95AutoARIMA-lo-80AutoARIMA-hi-80AutoARIMA-hi-95AutoETSAutoETS-lo-95AutoETS-lo-80AutoETS-hi-80AutoETS-hi-95SeasonalNaiveSeasonalNaive-lo-95SeasonalNaive-lo-80SeasonalNaive-hi-80SeasonalNaive-hi-95CrostonCroston-lo-95Croston-lo-80Croston-hi-80Croston-hi-95
0Latex_Ecom2026-12-01 00:00:00450.3529357910156336.17333984375363.49163818359375537.2142333984375564.5325317382812450.265380859375336.025634765625363.3254089355469537.2053833007812564.505126953125457.0407.5249938964844409.1000061035156504.8999938964844506.4750061035156437.1111145019531315.3698425292969343.9886474609375530.2335815429688558.8523559570312
1Latex_Ecom2027-01-01 00:00:00450.3529357910156408.42333984375415.49163818359375485.2142333984375492.2825622558594450.265380859375408.275634765625415.3254089355469485.2053527832031492.255126953125455.0389.07501220703125398.29998779296875511.70001220703125520.9249877929688437.1111145019531387.619873046875395.9886474609375478.23358154296875486.60235595703125
2Latex_Ecom2027-02-01 00:00:00450.3529357910156285.9300231933594324.04833984375576.6575317382812614.77587890625450.265380859375285.97265625324.0724182128906576.4583129882812614.55810546875624.0425.0470.0778.0823.0437.1111145019531275.2948303222656314.5872497558594559.635009765625598.9273681640625
3Latex_Offline2026-12-01 00:00:00761.1764526367188661.2235717773438674.5433959960938847.8095092773438861.12939453125761.06201171875661.2301025390625674.5716552734375847.5524291992188860.8939208984375853.0821.0499877929688824.2000122070312881.7999877929688884.9500122070312739.4890747070312623.9336547851562641.9385986328125837.0396118164062855.0445556640625
4Latex_Offline2027-01-01 00:00:00761.1764526367188648.7276000976562660.5595092773438861.7933959960938873.6253662109375761.06201171875648.70263671875660.4617309570312861.6622924804688873.42138671875793.0743.1500244140625752.5999755859375833.4000244140625842.8499755859375739.4890747070312610.888916015625625.7597045898438853.218505859375868.0892944335938
5Latex_Offline2027-02-01 00:00:00761.1764526367188486.99298095703125538.0231323242188984.3298339843751035.3599853515625761.06201171875487.08135986328125538.08984375984.03417968751035.0427246093751066.0831.25874.01258.01300.75739.4890747070312467.4023132324219513.7473754882812965.23083496093751011.5758666992188
6Latex_Online2026-12-01 00:00:00205.64706420898438154.87173461914062166.36721801757812244.92689514160156256.42236328125205.677734375154.84744262695312166.3590087890625244.9964599609375256.5080261230469231.0206.0500030517578209.1999969482422252.8000030517578255.9499969482422195.34115600585938140.86441040039062153.7747802734375236.9075469970703249.8179168701172
7Latex_Online2027-01-01 00:00:00205.64706420898438161.3240966796875164.90362548828125246.39048767089844249.9700164794922205.677734375161.36058044433594164.92401123046875246.43145751953125249.99490356445312217.0174.3249969482422181.3000030517578252.6999969482422259.67498779296875195.34115600585938152.66192626953125154.82655334472656235.85577392578125238.0203857421875
8Latex_Online2027-02-01 00:00:00205.64706420898438128.4490966796875144.40362548828125266.8905029296875282.8450012207031205.677734375128.48556518554688144.42401123046875266.93145751953125282.8699035644531283.0206.5500030517578223.1999969482422342.79998779296875359.45001220703125195.34115600585938119.78693389892578134.32655334472656256.35577392578125270.8953857421875
9Pillow_Ecom2026-12-01 00:00:00551.11767578125428.39373779296875451.29345703125650.9418334960938673.841552734375551.3687744140625428.7286682128906451.59002685546875651.1475830078125674.0089111328125575.0521.5526.0624.0628.5530.3869018554688399.21258544921875424.67779541015625636.0960693359375661.561279296875
10Pillow_Ecom2027-01-01 00:00:00551.11767578125475.3187561035156479.99346923828125622.2418212890625626.9165649414062551.3687744140625475.6536560058594480.2900390625622.4475708007812627.0839233398438545.0487.3500061035156500.3999938964844589.5999755859375602.6500244140625530.3869018554688446.1376037597656453.3777770996094607.3960571289062614.63623046875
11Pillow_Ecom2027-02-01 00:00:00551.11767578125361.58233642578125400.7183532714844701.5169677734375740.6529541015625551.3687744140625361.7579040527344400.8887939453125701.8488159179688740.9796752929688767.0573.2999877929688619.2000122070312914.7999877929688960.7000122070312530.3869018554688343.48883056640625384.2468566894531676.5269775390625717.2850341796875
12Pillow_Offline2026-12-01 00:00:00940.941162109375734.2673950195312772.74603271484381109.13635253906251147.614990234375941.2390747070312734.416259765625772.89953613281251109.578613281251148.06188964843751025.0992.125995.51054.51057.875910.0355834960938684.2002563476562728.730957031251091.340332031251135.8709716796875
13Pillow_Offline2027-01-01 00:00:00940.941162109375755.1423950195312799.24603271484381082.63635253906251126.739990234375941.2390747070312755.291259765625799.39953613281251083.078613281251127.1868896484375920.0884.0250244140625890.0999755859375949.9000244140625955.9749755859375910.0355834960938704.8900146484375754.48986816406251065.5812988281251115.18115234375
14Pillow_Offline2027-02-01 00:00:00940.941162109375625.6810913085938698.35247802734381183.52990722656251256.2012939453125941.2390747070312625.8703002929688698.6047363281251183.87341308593751256.607910156251332.01012.52502441406251086.09997558593751577.90002441406251651.4749755859375910.0355834960938600.9521484375674.99652099609381145.074707031251219.1190185546875
15Pillow_Online2026-12-01 00:00:00257.0294189453125197.44998168945312200.211669921875313.84716796875316.6088562011719256.9921569824219197.37294006347656200.12339782714844313.86090087890625316.6113586425781273.0249.1999969482422252.8000030517578293.20001220703125296.79998779296875247.0557403564453182.25595092773438186.564697265625307.5467834472656311.85552978515625
16Pillow_Online2027-01-01 00:00:00257.0294189453125219.4749755859375228.31167602539062285.7471618652344294.5838623046875256.9921569824219219.39793395996094228.22340393066406285.76092529296875294.58636474609375270.0241.4250030517578245.6999969482422294.29998779296875298.57501220703125247.0557403564453204.2809600830078214.66470336914062279.4468078613281289.8305358886719
17Pillow_Online2027-02-01 00:00:00257.0294189453125170.75804138183594191.62135314941406322.4374694824219343.30078125256.9921569824219170.6385498046875191.51309204101562322.4712219238281343.34576416015625365.0287.1000061035156302.3999938964844427.6000061035156442.8999938964844247.0557403564453161.40843200683594180.7246856689453313.3868103027344332.70306396484375
18Spring_Ecom2026-12-01 00:00:00265.20587158203125239.50326538085938245.64540100097656284.766357421875290.90850830078125265.1730041503906239.44094848632812245.5724334716797284.7735900878906290.9050598144531280.0243.0749969482422243.3000030517578316.70001220703125316.92498779296875260.7762145996094228.09231567382812235.75341796875285.7989807128906293.4600830078125
19Spring_Ecom2027-01-01 00:00:00265.20587158203125239.49600219726562245.61636352539062284.79541015625290.915771484375265.1730041503906239.44467163085938245.5873260498047284.7586975097656290.9013366699219268.0258.2250061035156258.8999938964844277.1000061035156277.7749938964844260.7762145996094228.01731872558594235.45343017578125286.0989685058594293.53509521484375

Hiển thị 20/27 dòng