Production Schedule
Your saved schedule loads automatically. Edit dates below or paste a new one.
Paste schedule below
Copy the production schedule table from your spreadsheet (including headers) and paste here.
Order Form
Paste the current run's order form from Kawada Japan.
Paste order form data
Include headers. The tool will find columns for Product Code, Description, Series, Qty/Ctn, and Unit Price.
Stock on Hand
Paste your current SOH export from Exo.
Paste SOH data
Include headers. The tool will find columns for Stock Code, Description, and SOH Quantity.
Monthly Sales Data
Paste from the "Monthly QTY" tab of your Stock Sale by Month report.
Paste monthly sales data
Copy the Monthly QTY sheet (including the header row with month names) and paste below. The tool will auto-detect months and calculate 3mo, 6mo, 12mo and prior year sales.
Open Purchase Orders
Paste POs for runs that have been ordered but not yet received.
Purchase Order 1
Back Orders
Paste customer back orders — units already committed but not yet shipped.
Paste back order data
Include headers. The tool will find columns for Stock Code, Description, and Quantity on back order. These units are already spoken for and will be subtracted from your available stock.
Review & Adjust
Check the data summary and adjust settings before generating.
Generate Spreadsheet
Everything looks good — generate your order calculator.
Ready to generate
Your spreadsheet will include both sections with all formulas and formatting.