Kiln Firing Assignment: Optimizer Example | Vose Software

ModelRisk Optimizer example · Manufacturing

Ceramics Studio: Kiln Firing Assignment

Which kiln should fire each ware batch so no single kiln carries the peak energy load?

  • Complexity: ★★★★★
  • Free Excel workbook
  • Needs ModelRisk with the Optimizer

The optimisation problem

Lowest mean peak kiln energy

Decide
A kiln for each of 15 batches (5 kilns)
Goal
Lowest mean peak kiln energy
Limit
None: a balancing problem
Engine
Vertex Detector

What the Optimizer found

Starting planOptimizer’s plan
Decisions changed–2 of 15
Goal: Mean peak kiln energy (kWh)204203
All 15 decisions starting plan, then the Optimizer’s
Batch 111
Batch 224
Batch 333
Batch 442
Batch 555
Batch 611
Batch 722
Batch 833
Batch 944
Batch 1055
Batch 1111
Batch 1222
Batch 1333
Batch 1444
Batch 1555

ModelRisk Optimizer run on 13 Oct 2026: the Vertex Detector engine, with Turbo simulation, tried 350 plans, each simulated with 10,000 samples, in 4 seconds. Both plans above were then simulated again with the same 10,000 samples.

What the workbook models

A ceramics studio fires 15 ware batches across 5 kilns. Each batch's energy draw is uncertain (lognormal). Loading too many heavy batches into one kiln creates an energy peak (and a demand charge).

Decision, objective and constraint

Decision
15 discrete kiln assignments (each batch then one of 5 kilns)
Objective
Minimise the Mean peak kiln energy (the busiest kiln)
Constraints
none — assignment/balancing

The engine: Vertex Detector

15 independent discrete assignment variables, no group then Method=Auto routes to the Vertex Detector.

The model

Assign each of 15 ware batches to a kiln so peak energy load is balanced across kilns.

InputDecision (the Optimizer changes it)Calculated or uncertain (sampled each iteration)Objective

Parameters

Energy tariff ($/kWh)0.18

Ware batches (decision = kiln 1 to 5)

BatchKiln (dec 1-5)kWh (unc.)
Batch 11uncertain
Batch 22uncertain
Batch 33uncertain
Batch 44uncertain
Batch 55uncertain
Batch 61uncertain
Batch 72uncertain
Batch 83uncertain
Batch 94uncertain
Batch 105uncertain
Batch 111uncertain
Batch 122uncertain
Batch 133uncertain
Batch 144uncertain
Batch 155uncertain

Results

Peak kiln energy (kWh): objectivecalculated
calculated
calculated
calculated
calculated
calculated

Decision cells hold starting values: the workbook opens at the starting plan above, and the Optimizer finds its plan when you run it. The figures are illustrative.

Run it yourself. Open the workbook with ModelRisk, open the Optimizer from the ribbon (the saved task opens with it) and press Start.

Glossary

Peak load
the energy of the most heavily loaded kiln

Find similar models