Grocery fruit ripening batch plan calculator

Calculate batch release calendar and cumulative release shortfall by demand date with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use batch release calendar and cumulative release shortfall by demand date to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Batches [identifier,delivery ISO date,units,observed days to release]; enter JSON
[["A","2026-11-01",20,2],["B","2026-11-02",30,3]]
Demand [ISO date,units]; enter JSON
[["2026-11-03",15],["2026-11-05",40]]
Batch release calendar (JSON)
[["2026-11-03","A",20],["2026-11-05","B",30]]
Cumulative release shortfall by demand date (JSON)
[["2026-11-03",0],["2026-11-05",5]]

Try another scenario

Batches [identifier,delivery ISO date,units,observed days to release]; enter JSON
[["A","2026-11-01",25,3],["B","2026-11-03",35,2]]
Demand [ISO date,units]; enter JSON
[["2026-11-04",20],["2026-11-05",50]]
Batch release calendar (JSON)
[["2026-11-04","A",25],["2026-11-05","B",35]]
Cumulative release shortfall by demand date (JSON)
[["2026-11-04",0],["2026-11-05",10]]
Calculation method

Calculation method

Batch release calendar (JSON)

Release date=delivery date+observed delay days; sort date then identifier.

Cumulative release shortfall by demand date (JSON)

For each demand date max(0,cumulative demand through date−all batches released through date).

Symbols and units
a
Batches [identifier,delivery ISO date,units,observed days to release]; enter JSON
b
Demand [ISO date,units]; enter JSON

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Release dates use user-observed stage-specific delay; no biological ripening forecast. Supported limits: All numeric inputs and computed intermediates must remain finite. Supported numeric input magnitude is zero or 1e-12 through 1e12 in absolute value; reject values outside this bounded range. All lists/JSON record tables are limited to 100 records unless a stricter bound is stated; reject malformed record arity and wrong member types. Valid dates; nonnegative integer delays and units; demand dates chronological; no spoilage model.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.