Workflow · Stock and products · Opening soon

Economic order quantity

Use your NetSuite item cost and demand export to work out the economic order quantity for each item. Run the order quantity step on each row, then use the result to guide replenishment.

Book a demo

Someone typed

“calculate the economic order quantity for each item from annual demand, order cost and holding cost”

The agent read it as

Calculate the economic order quantity for each item from NetSuite item cost and demand export.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

NetSuite item cost and demand export

CSV export · 12 rows

Step

Calculate order quantity

Step 1

Result

Economic Order Quantity

12 rows

Schedule

Runs when you say

Proposed

File
NetSuite item cost and demand export
CSV export · 12 rows
Step
Calculate order quantity
Step 1
Result
Economic Order Quantity
12 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 12 rows came out.

Download NetSuite item cost and demand export sample (12 rows)NetSuite: Lists > Search > Saved Searches > Item Search > Export

What you get back

The result of that run, the rows to look at first.

Economic Order QuantitySample data12 rows

Item	Economic order quantity	Annual demand	Order cost	Holding cost
Aster Shipping Labels	669.33	9,600	42	1.80
Borealis Copy Paper	868.50	14,400	55	2.10
Cedar Bubble Mailers	715.54	7,200	48	1.35
Delta Packing Tape	814.35	8,400	37.50	0.95
Ember Ink Cartridges	379.47	3,600	96	4.80
Fjord File Folders	806.85	12,600	31	1.20
Granite Staples	1,027.62	18,000	22	0.75
Harbor Shipping Boxes	528.71	5,400	88	3.40
Indigo Laser Labels	923.63	10,200	46	1.10
Juniper Sign Holders	239.35	2,400	74	6.20
Keystone Envelopes	994.10	15,000	28	0.85
Lumen Binder Clips	1,089.95	19,800	18	0.60

12 rows in the result. Sample data: illustrative figures, not business results.

How do you calculate the economic order quantity for each item?

Export your item cost and demand data from NetSuite, including annual demand, order cost, and holding cost for each item. Upload the file, then run the order quantity step. Mammoth calculates the economic order quantity for each row and returns the results in a new file.

How it works

How to use the Economic Order Quantity workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Economic Order Quantity: questions

What export should I use?

Use a spreadsheet export that includes one row per item and the fields you need for the calculation, such as annual demand, order cost, and holding cost.

What happens to rows that do not match the rules?

Rows that do not meet the rule stay out of the result. You can review them in the source file and fix the values or the rule before running it again.

How do I change the rules?

Edit the rule in plain words, then run the workflow again. You can change which columns are used and how the calculation is applied to each row.