Examples
Examples
Try the starting example
- Planned jobs: ID, count
- J1,2 J2,3
- Supplied bill of materials: job ID, item ID, quantity per job
- J1,A,2 J1,B,1 J2,A,1 J2,B,2
- Compatible item inventory: ID, available quantity, quantity per purchase pack, price per pack $
- A,2,4,10 B,1,5,8
- Gross required quantity by item
- A: 7; B: 8
- Net quantity above supplied stock
- A: 5; B: 7
- Whole purchase packs by item
- A: 2; B: 2
- Remaining stock after modeled purchases and jobs
- A: 3; B: 3
- Modeled purchase cash total ($)
- $36.00
Try another scenario
- Planned jobs: ID, count
- J1,1 J2,3
- Supplied bill of materials: job ID, item ID, quantity per job
- J1,A,2 J1,B,1 J2,A,1 J2,B,2
- Compatible item inventory: ID, available quantity, quantity per purchase pack, price per pack $
- A,2,4,10 B,1,5,8
- Gross required quantity by item
- A: 5; B: 7
- Net quantity above supplied stock
- A: 3; B: 6
- Whole purchase packs by item
- A: 1; B: 2
- Remaining stock after modeled purchases and jobs
- A: 1; B: 4
- Modeled purchase cash total ($)
- $26.00
Calculation method
Calculation method
Gross required quantity by item
Sum planned job count×supplied per-job item quantities.
Net quantity above supplied stock
max(0,gross required−available stock).
Whole purchase packs by item
Ceil(net quantity/pack quantity), using exact decimal scaled integers.
Remaining stock after modeled purchases and jobs
Available+whole packs×pack size−gross requirements.
Modeled purchase cash total ($)
Sum pack count×supplied compatible pack price.
Symbols and units
- a
- Planned jobs: ID, count
- b
- Supplied bill of materials: job ID, item ID, quantity per job
- c
- Compatible item inventory: ID, available quantity, quantity per purchase pack, price per pack $
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
- A supplied job/BOM/compatible-stock arithmetic ledger. Quantities for an item must share a unit; product compatibility, task scope and real consumption are external. No stock or orders are changed.
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.
Further reading
OpenStax: ratios, unit rates and supplied measurement arithmetic ↗
Background reading; this does not imply endorsement or independent review of SumFizz.