Loading current Actual, forecast and Sales KPI position.
Recommended model: 3-month weighted history + 35% capped trend + sector monthly seasonality. The model forecasts every remaining month sequentially (for example Jul → Dec), then sums them into the Full-Year Forecast. Blank past months are ignored; entered zero is treated as a real zero.
Forecast cells include the model output and any manual override. Full-year forecast = Actual YTD + forecast for remaining months.
The rounding rule is always up: THB 953,112 → THB 960,000; THB 1,254,695 → THB 1,260,000; THB 85,695 → THB 90,000.
Forecast Mix by Biz Type
Forecast Mix by Industry
Top Customers Requiring Extra Close This Month
Top Customers Already Above This-Month Close
Lowest Revenue Customers — Continue / Watch / Drop Review
Sales KPI Bridge & Suggested Recovery Focus
Suggested Upside Opportunity List
Forecast by Confidence Level
Forecast Method Mix
Top 10 Low Confidence Customers by FY Forecast
Top FY Forecast Upside vs Selected Snapshot
Top FY Forecast Downside vs Selected Snapshot
China-linked supply chains commonly pull shipments forward ahead of factory closures, then face reduced production, labour availability and slower recovery after the holiday. The curve therefore keeps January steady-to-firm and February slightly softer for manufacturing-linked sectors.
Evidence: Maersk — Chinese New Year 2026
Songkran is a national holiday centred on 13–15 April. In practice, industrial operations, trucking availability and customer receiving schedules can be affected for longer because employees extend leave. April is therefore discounted, most sharply for Automotive and Electronics.
Evidence: Thailand PRD — Songkran holiday period · B&Company — factory shutdown observations
Global retail and electronics supply chains typically replenish inventory during the northern-hemisphere summer/back-to-school period. For China-linked flows, cargo often accelerates before Golden Week in early October, lifting August–September in the Electronics and Logistics curves.
Evidence: Maersk — 2026 peak logistics periods
China’s National Day holiday can constrain factory output and logistics operations in early October. The baseline therefore does not assume the September pre-holiday volume carries fully into October; Logistics is slightly below normal and customer-specific exceptions should be managed through Outlook %.
Evidence: Maersk — September/October peak-shipping capacity pattern
Automotive production and supplier logistics are sensitive to planned plant downtime, model changeovers and long holidays. The default gives Automotive its deepest April reduction, then a controlled recovery from June through November. It is a planning baseline, not a substitute for a customer’s confirmed production plan.
Retail and consumer supply chains typically strengthen ahead of year-end holidays. Retail has the strongest Nov–Dec uplift, while General and Logistics receive only a moderate increase to avoid overstating demand for non-consumer accounts.
| Industry | Primary calendar drivers | How the default is expressed | Use a customer override when… |
|---|---|---|---|
| General | CNY / Songkran / Golden Week / year-end flow | Moderate April dip; light Aug–Sep and Nov uplift. | The account is project-based, not recurring. |
| Electronics | China sourcing, component build and Q3 inventory build | April trough; strongest Aug–Sep. | The customer has a fixed production schedule or new launch. |
| Automotive | Plant downtime, model-year change, supplier release pattern | Deepest April trough; controlled Jun–Nov recovery. | Confirmed OEM shutdown / production plan is available. |
| Foods | Relatively steady essential flow and harvest/commodity timing | Small movements only; May–Aug slightly firmer. | Commodity, harvest, halal, or temperature-control season applies. |
| Retail | CNY, stock replenishment and year-end consumer peak | Firm Jan–Feb; gradual lift from Oct; highest December. | A retailer’s assortment or local calendar differs materially. |
| Logistics | General freight cycle, CNY / Golden Week pull-forward | April and October disruption; stronger Aug–Sep / November. | Revenue is capacity / project / one-off rather than shipment volume-led. |
| Others | Insufficient recurring pattern | Neutral 100% throughout the year. | Enough customer history exists to classify the account. |
Copy the source table from Excel or a report and paste it below. Tab-separated and comma-separated layouts are supported with Customer, Sales PIC, Biz Type, and month columns (Jan–Dec). Headers such as Jan-26 are recognised. Total rows such as External cust are skipped automatically. Optional Industry, Outlook %, Confirmed Add-on, Forecast Method, Confidence Level, Ramp-up %, Business Start Month, and Notes columns are retained when available; missing Industry defaults to General.
Step: Paste the table, then click Apply pasted data → Customer Forecast Input. The imported rows will replace the current customer list, refresh the forecast, and take you to section 5.