Ocean AI ERP systemOcean Seafood Company / Frozen seafood distributor in Scarborough, Toronto (GTA)
AI training sample explorer

Three years of monthly slices for prompts, evaluation, and retrieval.

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.

36Operating rows
720SKU rows
432Customer rows
720Vendor rows

Latest month signal

2026-05 revenue $234k, margin 35%, service level 89%.

Best SKU slice

sku-salmon delivered the strongest gross profit in the latest training window.

Worst customer risk

cust-walmart has the highest churn risk and deserves a retention / payment follow-up.

Latest month training bundle

Use these slices as direct model inputs or as supervision examples.

SKU bundle

SAL-001

gross profit $7k, margin 36%

89% service
BAR-170

gross profit $6k, margin 38%

91% service
SHR-010

gross profit $6k, margin 36%

87% service
PRA-130

gross profit $5k, margin 35%

85% service
TIL-090

gross profit $5k, margin 35%

95% service

Customer bundle

Loblaws GTA

orders 3, repeat 66%, days to pay 31.3

36% churn
Walmart Supercentre GTA

orders 4, repeat 67%, days to pay 24

36% churn
FreshCo GTA

orders 3, repeat 67%, days to pay 27.7

35% churn
Metro GTA

orders 3, repeat 71%, days to pay 31.2

32% churn
Fortinos GTA

orders 4, repeat 71%, days to pay 30.8

32% churn

Vendor bundle

Dutch Delta Seafoods

fill 99%, on-time 81%

42% defect
Chilean Fjord Seafood

fill 95%, on-time 83%

42% defect
Ecuador Blue Shrimp

fill 96%, on-time 76%

42% defect
Patagonia Marine Foods

fill 96%, on-time 70%

42% defect
Mekong Seafoods

fill 91%, on-time 92%

42% defect

Prompt-ready sample

Use this text as the basis for evaluation, prompt chaining, or manual annotation.

Base analyst prompt
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.

Prompt catalog

Copy these into evaluation runs, fine-tuning examples, or retrieval prompts.

Monthly variance analysis

Compare the latest month with the previous three months. Explain margin movement, stockout pressure, OTIF drift, and the operational cause of change.

SKU recommendation

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.

Customer risk review

Review the customer slices and identify which customers are at churn or credit risk. Mention payment behavior, repeat rate, and order trend.

Vendor quality review

Review the vendor slices and explain which suppliers are causing operational friction through defects, lead time drift, or on-time performance.

Latest bundle export

Copy the latest month as a JSON payload for external evaluation or notebook work.

Latest month JSON bundle
{
  "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
    }
  ]
}

Operating slices

Revenue, margin, service, and stockout pressure by month.

MonthRevenueGross profitMarginOTIFServiceForecast acc.Stockouts
2023-06$231k$81k35%83%89%95%316
2023-07$246k$86k35%82%88%95%358
2023-08$243k$84k35%82%88%95%362
2023-09$234k$82k35%82%88%95%342
2023-10$241k$83k34%83%88%95%338
2023-11$229k$79k35%83%88%95%310
2023-12$230k$80k35%83%89%95%290
2024-01$226k$78k35%83%90%94%266
2024-02$212k$73k34%83%90%94%238
2024-03$226k$78k35%83%90%95%256
2024-04$221k$77k35%83%90%95%260
2024-05$235k$82k35%83%89%95%299
2024-06$233k$81k35%83%89%95%320
2024-07$243k$84k35%83%88%95%355
2024-08$243k$85k35%83%88%95%346
2024-09$233k$81k34%83%88%94%332
2024-10$239k$82k34%83%88%95%339
2024-11$223k$76k34%82%89%95%283
2024-12$225k$78k34%82%90%95%272
2025-01$225k$77k34%83%90%95%250
2025-02$206k$71k35%83%90%95%216
2025-03$229k$80k35%83%90%95%256
2025-04$224k$78k35%83%90%95%261
2025-05$238k$83k35%84%89%95%307
2025-06$236k$82k35%84%88%95%322
2025-07$243k$85k35%83%88%94%351
2025-08$244k$84k35%83%88%95%357
2025-09$234k$81k35%83%88%95%342
2025-10$240k$83k35%83%88%95%342
2025-11$229k$79k35%83%89%95%303
2025-12$231k$79k34%83%89%95%289
2026-01$226k$78k34%83%90%95%260
2026-02$202k$70k34%83%90%95%223
2026-03$224k$78k35%82%90%95%252
2026-04$219k$76k35%82%90%95%260
2026-05$234k$82k35%82%89%95%302

SKU, customer, and vendor samples

Curated slices for training retrieval, ranking, and explanation tasks.

SKU slice

SAL-001

2023-09 actual 289 boxes, forecast 294

80% service
SAL-001

2025-11 actual 274 boxes, forecast 283

81% service
SAL-001

2025-10 actual 295 boxes, forecast 311

80% service
SAL-001

2025-08 actual 289 boxes, forecast 318

81% service
SAL-001

2023-12 actual 268 boxes, forecast 255

82% service
SAL-001

2023-07 actual 274 boxes, forecast 291

82% service

Customer slice

Walmart Supercentre GTA

2024-12 orders 3, days to pay 20.6

40% churn risk
Loblaws GTA

2023-07 orders 5, days to pay 22

39% churn risk
Walmart Supercentre GTA

2023-07 orders 3, days to pay 26.8

39% churn risk
Loblaws GTA

2024-09 orders 4, days to pay 29.9

39% churn risk
Costco Wholesale GTA

2023-06 orders 4, days to pay 32.7

38% churn risk
Loblaws GTA

2024-01 orders 5, days to pay 27.5

38% churn risk

Vendor slice

Dutch Delta Seafoods

2023-06 fill 99%, quality 58%

42% defect
Chilean Fjord Seafood

2023-06 fill 94%, quality 58%

42% defect
Ecuador Blue Shrimp

2023-06 fill 96%, quality 58%

42% defect
Patagonia Marine Foods

2023-06 fill 95%, quality 58%

42% defect
Mekong Seafoods

2023-06 fill 90%, quality 58%

42% defect
Siam Gulf Seafood

2023-06 fill 89%, quality 58%

42% defect

AI retrieval notes

These fragments are the most useful facts for model prompts and evaluation sets.

Use when answering

What happened to monthly margin, why service level moved, whether a customer is at churn risk, or which vendor is causing supply pressure.

Good prompt targets

Explain the best month, identify the weakest supplier, recommend SKU reorder priority, and summarize the risks visible in the latest month.

API entry points

`/api/mock/monthly-metrics` for raw slices and `/api/mock/training-context` for curated top-risk samples.

Model answer shape

Start with the main finding, cite the supporting month-level metrics, then recommend one operational action.