Latest month signal
2026-05 revenue $234k, margin 35%, service level 89%.
This page is deliberately dense. It exposes curated monthly slices across a three-year window so you can train or test prompts against profit, demand, customer retention, supplier quality, and cold-chain risk in one place.
2026-05 revenue $234k, margin 35%, service level 89%.
sku-salmon delivered the strongest gross profit in the latest training window.
cust-walmart has the highest churn risk and deserves a retention / payment follow-up.
Use these slices as direct model inputs or as supervision examples.
gross profit $7k, margin 36%
gross profit $6k, margin 38%
gross profit $6k, margin 36%
gross profit $5k, margin 35%
gross profit $5k, margin 35%
orders 3, repeat 66%, days to pay 31.3
orders 4, repeat 67%, days to pay 24
orders 3, repeat 67%, days to pay 27.7
orders 3, repeat 71%, days to pay 31.2
orders 4, repeat 71%, days to pay 30.8
fill 99%, on-time 81%
fill 95%, on-time 83%
fill 96%, on-time 76%
fill 96%, on-time 70%
fill 91%, on-time 92%
Use this text as the basis for evaluation, prompt chaining, or manual annotation.
You are an operations analyst for a frozen seafood wholesaler. Use the following monthly signals to explain what is happening, identify risks, and propose the next action. Focus on revenue, gross margin, OTIF, service level, stockout pressure, customer churn risk, and supplier defects. Do not assume inventory is healthy if forecast accuracy or service level is falling.
Copy these into evaluation runs, fine-tuning examples, or retrieval prompts.
Compare the latest month with the previous three months. Explain margin movement, stockout pressure, OTIF drift, and the operational cause of change.
Given the latest SKU slices, rank the top three SKUs for reorder attention and justify the ranking using service level, forecast error, and gross profit.
Review the customer slices and identify which customers are at churn or credit risk. Mention payment behavior, repeat rate, and order trend.
Review the vendor slices and explain which suppliers are causing operational friction through defects, lead time drift, or on-time performance.
Copy the latest month as a JSON payload for external evaluation or notebook work.
{
"month": "2026-05",
"operating": {
"month": "2026-05",
"revenue": 233846.92,
"cogs": 152013.46,
"grossProfit": 81833.46,
"grossMargin": 0.3499,
"otifRate": 0.82,
"serviceLevel": 0.89,
"forecastAccuracy": 0.95,
"stockoutBoxes": 302,
"stockoutRate": 0.09,
"inventoryTurns": 14.99,
"avgDaysToSell": 2.1,
"overdueInvoiceRate": 0.02,
"cashCollected": 59867.86,
"activeCustomers": 12,
"repeatPurchaseRate": 0.74,
"churnRiskCustomers": 0
},
"sku": [
{
"month": "2026-05",
"skuId": "sku-salmon",
"actualBoxes": 200,
"forecastBoxes": 219,
"revenue": 18440,
"cogs": 11806.52,
"grossProfit": 6633.48,
"grossMargin": 0.3597,
"stockoutBoxes": 22,
"promoLiftFactor": 1.13,
"averageSellPrice": 18.44,
"serviceLevel": 0.89
},
{
"month": "2026-05",
"skuId": "sku-barramundi",
"actualBoxes": 162,
"forecastBoxes": 174,
"revenue": 15169.03,
"cogs": 9364.48,
"grossProfit": 5804.55,
"grossMargin": 0.3827,
"stockoutBoxes": 15,
"promoLiftFactor": 1.04,
"averageSellPrice": 18.36,
"serviceLevel": 0.9074074074074074
},
{
"month": "2026-05",
"skuId": "sku-shrimp",
"actualBoxes": 235,
"forecastBoxes": 246,
"revenue": 15762.62,
"cogs": 10122.19,
"grossProfit": 5640.43,
"grossMargin": 0.3578,
"stockoutBoxes": 30,
"promoLiftFactor": 1.09,
"averageSellPrice": 26.83,
"serviceLevel": 0.8723404255319149
},
{
"month": "2026-05",
"skuId": "sku-prawn",
"actualBoxes": 241,
"forecastBoxes": 233,
"revenue": 15858.28,
"cogs": 10376.83,
"grossProfit": 5481.45,
"grossMargin": 0.3457,
"stockoutBoxes": 37,
"promoLiftFactor": 1.06,
"averageSellPrice": 29.91,
"serviceLevel": 0.8464730290456431
},
{
"month": "2026-05",
"skuId": "sku-tilapia",
"actualBoxes": 262,
"forecastBoxes": 278,
"revenue": 15159.32,
"cogs": 9910.45,
"grossProfit": 5248.87,
"grossMargin": 0.3462,
"stockoutBoxes": 12,
"promoLiftFactor": 1.08,
"averageSellPrice": 10.52,
"serviceLevel": 0.9541984732824428
}
],
"customers": [
{
"month": "2026-05",
"customerId": "cust-loblaws",
"orders": 3,
"revenue": 5071.83,
"boxes": 266,
"repeatRate": 0.66,
"daysToPayAverage": 31.3,
"onTimePaymentRate": 0.88,
"churnRisk": 0.36
},
{
"month": "2026-05",
"customerId": "cust-walmart",
"orders": 4,
"revenue": 6776.57,
"boxes": 254,
"repeatRate": 0.67,
"daysToPayAverage": 24,
"onTimePaymentRate": 0.89,
"churnRisk": 0.36
},
{
"month": "2026-05",
"customerId": "cust-freshco",
"orders": 3,
"revenue": 4622.53,
"boxes": 202,
"repeatRate": 0.67,
"daysToPayAverage": 27.7,
"onTimePaymentRate": 0.95,
"churnRisk": 0.35
},
{
"month": "2026-05",
"customerId": "cust-metro",
"orders": 3,
"revenue": 4081.86,
"boxes": 169,
"repeatRate": 0.71,
"daysToPayAverage": 31.2,
"onTimePaymentRate": 0.97,
"churnRisk": 0.32
},
{
"month": "2026-05",
"customerId": "cust-fortinos",
"orders": 4,
"revenue": 5426.56,
"boxes": 194,
"repeatRate": 0.71,
"daysToPayAverage": 30.8,
"onTimePaymentRate": 0.93,
"churnRisk": 0.32
}
],
"vendors": [
{
"month": "2026-05",
"vendorId": "vend-netherlands",
"poCount": 0,
"fillRate": 0.99,
"onTimeRate": 0.81,
"qualityPassRate": 0.58,
"defectRate": 0.42,
"avgLeadTimeDays": 8.3
},
{
"month": "2026-05",
"vendorId": "vend-chile",
"poCount": 0,
"fillRate": 0.95,
"onTimeRate": 0.83,
"qualityPassRate": 0.58,
"defectRate": 0.42,
"avgLeadTimeDays": 12.5
},
{
"month": "2026-05",
"vendorId": "vend-ecuador",
"poCount": 0,
"fillRate": 0.96,
"onTimeRate": 0.76,
"qualityPassRate": 0.58,
"defectRate": 0.42,
"avgLeadTimeDays": 13
},
{
"month": "2026-05",
"vendorId": "vend-argentina",
"poCount": 0,
"fillRate": 0.96,
"onTimeRate": 0.7,
"qualityPassRate": 0.58,
"defectRate": 0.42,
"avgLeadTimeDays": 13.7
},
{
"month": "2026-05",
"vendorId": "vend-vietnam",
"poCount": 0,
"fillRate": 0.91,
"onTimeRate": 0.92,
"qualityPassRate": 0.58,
"defectRate": 0.42,
"avgLeadTimeDays": 15.5
}
]
}Revenue, margin, service, and stockout pressure by month.
| Month | Revenue | Gross profit | Margin | OTIF | Service | Forecast acc. | Stockouts |
|---|---|---|---|---|---|---|---|
| 2023-06 | $231k | $81k | 35% | 83% | 89% | 95% | 316 |
| 2023-07 | $246k | $86k | 35% | 82% | 88% | 95% | 358 |
| 2023-08 | $243k | $84k | 35% | 82% | 88% | 95% | 362 |
| 2023-09 | $234k | $82k | 35% | 82% | 88% | 95% | 342 |
| 2023-10 | $241k | $83k | 34% | 83% | 88% | 95% | 338 |
| 2023-11 | $229k | $79k | 35% | 83% | 88% | 95% | 310 |
| 2023-12 | $230k | $80k | 35% | 83% | 89% | 95% | 290 |
| 2024-01 | $226k | $78k | 35% | 83% | 90% | 94% | 266 |
| 2024-02 | $212k | $73k | 34% | 83% | 90% | 94% | 238 |
| 2024-03 | $226k | $78k | 35% | 83% | 90% | 95% | 256 |
| 2024-04 | $221k | $77k | 35% | 83% | 90% | 95% | 260 |
| 2024-05 | $235k | $82k | 35% | 83% | 89% | 95% | 299 |
| 2024-06 | $233k | $81k | 35% | 83% | 89% | 95% | 320 |
| 2024-07 | $243k | $84k | 35% | 83% | 88% | 95% | 355 |
| 2024-08 | $243k | $85k | 35% | 83% | 88% | 95% | 346 |
| 2024-09 | $233k | $81k | 34% | 83% | 88% | 94% | 332 |
| 2024-10 | $239k | $82k | 34% | 83% | 88% | 95% | 339 |
| 2024-11 | $223k | $76k | 34% | 82% | 89% | 95% | 283 |
| 2024-12 | $225k | $78k | 34% | 82% | 90% | 95% | 272 |
| 2025-01 | $225k | $77k | 34% | 83% | 90% | 95% | 250 |
| 2025-02 | $206k | $71k | 35% | 83% | 90% | 95% | 216 |
| 2025-03 | $229k | $80k | 35% | 83% | 90% | 95% | 256 |
| 2025-04 | $224k | $78k | 35% | 83% | 90% | 95% | 261 |
| 2025-05 | $238k | $83k | 35% | 84% | 89% | 95% | 307 |
| 2025-06 | $236k | $82k | 35% | 84% | 88% | 95% | 322 |
| 2025-07 | $243k | $85k | 35% | 83% | 88% | 94% | 351 |
| 2025-08 | $244k | $84k | 35% | 83% | 88% | 95% | 357 |
| 2025-09 | $234k | $81k | 35% | 83% | 88% | 95% | 342 |
| 2025-10 | $240k | $83k | 35% | 83% | 88% | 95% | 342 |
| 2025-11 | $229k | $79k | 35% | 83% | 89% | 95% | 303 |
| 2025-12 | $231k | $79k | 34% | 83% | 89% | 95% | 289 |
| 2026-01 | $226k | $78k | 34% | 83% | 90% | 95% | 260 |
| 2026-02 | $202k | $70k | 34% | 83% | 90% | 95% | 223 |
| 2026-03 | $224k | $78k | 35% | 82% | 90% | 95% | 252 |
| 2026-04 | $219k | $76k | 35% | 82% | 90% | 95% | 260 |
| 2026-05 | $234k | $82k | 35% | 82% | 89% | 95% | 302 |
Curated slices for training retrieval, ranking, and explanation tasks.
2023-09 actual 289 boxes, forecast 294
2025-11 actual 274 boxes, forecast 283
2025-10 actual 295 boxes, forecast 311
2025-08 actual 289 boxes, forecast 318
2023-12 actual 268 boxes, forecast 255
2023-07 actual 274 boxes, forecast 291
2024-12 orders 3, days to pay 20.6
2023-07 orders 5, days to pay 22
2023-07 orders 3, days to pay 26.8
2024-09 orders 4, days to pay 29.9
2023-06 orders 4, days to pay 32.7
2024-01 orders 5, days to pay 27.5
2023-06 fill 99%, quality 58%
2023-06 fill 94%, quality 58%
2023-06 fill 96%, quality 58%
2023-06 fill 95%, quality 58%
2023-06 fill 90%, quality 58%
2023-06 fill 89%, quality 58%
These fragments are the most useful facts for model prompts and evaluation sets.
What happened to monthly margin, why service level moved, whether a customer is at churn risk, or which vendor is causing supply pressure.
Explain the best month, identify the weakest supplier, recommend SKU reorder priority, and summarize the risks visible in the latest month.
`/api/mock/monthly-metrics` for raw slices and `/api/mock/training-context` for curated top-risk samples.
Start with the main finding, cite the supporting month-level metrics, then recommend one operational action.