Explore AIMS360's apparel business software
FREE DEMO
Home › Articles ›
AIMS360 Production Forecasting: Stop Over and Underproducing
AIMS360 article
by

AIMS360 Production Forecasting: Stop Over and Underproducing

Updated November 4, 2026. This page describes the Production Forecast Report as it works in AIMS360 today, including what it does not do.

The short answer

Yes, for styles you keep selling. The AIMS360 Production Forecast Report averages each style's monthly sales over a history window you choose, applies the replenishment percentage you set for that style, then subtracts what is on hand and in open work in process. What is left is the suggested quantity to produce or buy, month by month, for the forecast window you pick. Core styles and the styles on your web store are where it earns its keep.

It is a straightforward calculation, not a machine learning model, and it needs history. New seasonal styles are forecast outside AIMS360 or entered as production planning orders. Lead times are not shortened by the report itself; production tracking is where you see which vendor or stage is slowing a run down.

How the Production Forecast Report works

The report reads three things for every style and color you select: past sales, inventory, and open work in process. It combines them with a replenishment code on the style, which carries a percentage. The math is the same for every style, which makes it easy to check.

  1. Average the past sales

    Forecasted sales per month equal the actual sales in each month of your history window, divided by the number of months.

  2. Apply the replenishment percentage

    Multiply the forecasted sales by the percentage on the style's replenishment code. A code at 0% means never reorder; 100% means replace what sells.

  3. Subtract stock and open WIP

    Take away the previous month's ending inventory and open work in process. Open WIP counts by its issue date, not its completion date.

  4. Read the replenishment quantity

    If the result is below zero, the suggestion is zero. Otherwise it is the quantity to produce or buy for that month.

A worked example. A core tee in black sold 300, 360 and 240 units over the last three months, an average of 300 a month. Its replenishment code is 80%, so the target is 240. Ending inventory is 150 and open WIP is 50, which covers 200. The report suggests 40 more units for the coming month.

Settings you choose each time you run it

Setting What it does
Styles Pick one style, a range, or a filtered set, including by entity tags. Smaller selections run faster
Forecast range How many months ahead to forecast
Sales history range How many months of past sales to average
Order date basis Base the history on the customer order start, complete or entered date
Additional percentage Raise the calculated sales by a percentage, for a style you expect to grow
Exclude open bulk orders Leaves out units still sitting on a bulk order that has not been fully depleted
Minimum stock Uses the minimum stock you set by style, color and size, useful where few orders exist yet
Case details Forecasts the styles inside a case pack as well as the case pack style itself

The output opens in an Excel style viewer. Sort, filter and freeze columns there, then export it with the report export options in AIMS360.

Set it up in four steps

  1. Create replenishment codes

    Under Setup, Codes, Replenishment Codes, add a two character code, a description and a percentage for each rule you plan to use.

  2. Assign a code to every style you want forecast

    The Global Changes Styles screen applies a code to many styles at once. A style without a code gets no forecast at all.

  3. Add minimum stock where it matters

    Enter a minimum quantity by size on the style's size details. It is entered by style and color, not imported.

  4. Run the report

    Open Reports, Styles, Production Forecast Report, choose your styles and ranges, and run it.

Replenishment codes: say what you want more or less of

The code is where your judgment goes in. Phasing out a dress that has run for several seasons? Lower its percentage, or set it to zero, and its forecast falls with it. A style you expect to carry forward at full strength sits at 100%. For a style you expect to outsell its history, use the additional percentage setting when you run the report. Keep the number of codes small, so a buyer can tell at a glance why a style is getting the quantity it gets.

Seasonal collections and new styles

History-based forecasting works for styles that have history. A seasonal collection that is new every drop does not, so most brands plan those quantities from line reviews, retailer pre-books and their own judgment. There are two good ways to bring that plan into AIMS360. Take pre-orders against the line before you commit to production. Or enter a production planning order: a customer order on a planning account that holds the projected quantities by style, color and size, so the material requirements and WIP flow from it. Once production is created, cancel the planning order so open to sell reflects real demand.

Planning production and lead times across factories

No ERP makes a factory sew faster. What it can do is show you where the time goes, so you can move programs, pad dates or change vendors with evidence.

Planning question Where AIMS360 answers it
How much of each core style to reorder? Production Forecast Report
What materials do we need for planned production? Production planning orders and the bill of materials
Which units are in cutting, sewing, on the water or in customs? Production tracking, by style, color and size
Which vendors run late? Estimated against actual dates on each production stage
What is already on order from factories? Vendor purchase orders and cut tickets
What sold, by style, color and size? Style analysis reports

Limits worth knowing

  • No code, no forecast. Styles without a replenishment code are skipped.
  • It is an average. It does not model trend or seasonality on its own; choose a history window that matches the season you are planning.
  • Clean inventory first. Negative ending inventory, usually from receiving or pick ticket mistakes, distorts the result. Fix the cause before you trust the number.
  • WIP timing. Open WIP counts from its issue date, so a run issued early looks available sooner than it lands.

Frequently asked questions

Does AIMS360 forecast demand from historical sales data?

Yes, for continuing styles. The Production Forecast Report averages each style's past monthly sales over a window you choose, applies the style's replenishment percentage, and subtracts inventory and open work in process to suggest how much to produce or buy.

Does the AIMS360 forecast use AI?

No. The Production Forecast Report is a transparent calculation: average past sales, times your replenishment percentage, minus stock and open WIP. That makes every suggested quantity easy to check by hand.

Can AIMS360 forecast new or seasonal styles?

Not from history, because there is none. Plan those quantities from line reviews and pre-books, then bring the plan into AIMS360 as pre-orders or production planning orders so material requirements and WIP follow from it.

How far ahead can I forecast?

You choose the number of months to forecast and the number of months of sales history each time you run the report, so you can match the window to your lead times.

Why is a style missing from the forecast?

It has no replenishment code. The report only calculates styles with a code assigned. Use Global Changes Styles to assign codes to many styles at once.

Does the forecast include work in process?

Yes. Open WIP is subtracted along with ending inventory before a replenishment quantity is suggested. WIP counts by its issue date.

Can AIMS360 help reduce production lead times?

Indirectly. AIMS360 does not schedule factories, but production tracking shows units by stage with estimated and actual dates by vendor, so you can see where time is lost and plan around it.

Can I export the forecast to Excel?

Yes. The report opens in an Excel style viewer where you can sort and filter, and its default output is Excel.

Updated November 4, 2026 by the AIMS360 team against the current behavior of the Production Forecast Report.

See your own forecast

Bring three months of sales for a few core styles. We will set replenishment codes in a demo and show the reorder quantities AIMS360 suggests.

Book a free demoTalk to us