Spend year against year: price effect and volume effect per article, category or supplier, largest price increases first
compare_spend_periodsTakes spend rows of two years or periods and groups them by article, otherwise by category, otherwise by supplier. Where quantities are given it separates the price effect (same volume, different price per unit) from the volume effect (bought more or less), and shows new and dropped entries separately. Lists the entries with the largest price increase first, with old and new price per unit, and ends with the next step. Without quantities only the amounts are compared. Traffic light by the share of pure price increase in last year's spend (over 5 percent red, over 1 percent yellow). Pass two arrays (old_rows for the previous year, new_rows for the current year) or one array rows with a year column. To check a single announced price increase against official indices use check_price_increase. Licence, or one free check every 30 days.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "compare_spend_periods"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | Alternative to old_rows and new_rows: one list with a year column (for example 2025 and 2026) plus the columns above. | |
| language | No | Language of the answer. Default de. | |
| new_rows | No | Current year with the same columns. | |
| old_rows | No | Previous year: article (or category or supplier), quantity (optional), amount. German column names work too. |