
    EviGm              "          d Z ddddddddg d	dgd

dddddddddg dg dddddddddddg dddgdddddddd dg d!ddgd

d"dd#d$d%d&d'd(d)g d*dd$gdd+d$dd,d-d.d/d)g d0d$dgd

d1d2dd3d4d5d6d)g d7dgd

d8ddd9d4d:d;d)g d<ddgd

d=d>d$d?d@dAdBdCg dDd$gd

dEd$ddFdGdHdIdCg dJd$dgd

dKdddLdMdNdOdCg dPddgd

dQdRdSdTdUdVdWdXg dYg dZd

d[ddRdd\d]d^d_dXg d`ddgddadbdddcdddedfdgg dhddgddiddbdjdkdldmdgg dndgd

dodpddqdkdrdsdCg dtdgd

dudddvdUdwdxdCg dyddgd

dzdddd{d|d}d~dg dg ddddddddddg dddgd

ddddddddg ddgd

ddddddddg dddgd

ddddddddg dddgd

dd$ddddddg dd$dgd

ddddddddg dddgd

gZdS )uI  Mock emails — Tata Steel scenario, Feb 10 – Mar 20 2026.

Storylines:
  A) Coking coal supply delay (procurement → ops → executive escalation)
  B) Die casting line #2 downtime (ops → maintenance → vendor)
  C) Iron ore fill rate drop (analyst signal → manager → VP)
  D) Safety incident — Hot Strip Mill crane (safety → all-ops → VP)
  E) Enterprise Brain project updates (Divami → Naveen, Vijay)
  F) Vendor price renegotiation Q2 (JSW → Rajesh → Naveen)
  G) Q2 capacity planning (Naveen → Vijay)
  H) Client satisfaction escalation (Vijay → Naveen)
zmsg-001zbhp.logistics@bhp.comrajesh.kumar@tatasteel.comu1   PO #TS-4521 — Port Congestion Notice, Hay Pointz
2026-02-10uv   BHP: PO #TS-4521 (45,000 MT coal) delayed 10–14 days due to Hay Point port congestion. New ETA Paradip: Mar 12–14.uY  Dear Rajesh,

This is to inform you that vessel MV Southern Cross carrying your coking coal order (PO #TS-4521, 45,000 MT) is currently held at Hay Point terminal due to port congestion. Estimated delay: 10–14 days. New ETA at Paradip: March 12–14.

We apologise for the inconvenience and will keep you updated daily.

Regards,
BHP Logisticszbf3-coal-supply)procurementdelaysraw-materialsvendor)
idfromtosubjectdatesummarybodyprojectlabelsrecipients_visible_tozmsg-002vijay.kamineni@tatasteel.comnaveen.p@tatasteel.comu2   Coking Coal Delay — BF#3 Feed Risk (PO #TS-4521)z
2026-02-11u   Rajesh to Vijay+Naveen: BHP coal shipment delayed 12 days (ETA Mar 12–14), BF#3 feed at risk. Asks: update schedule, check NMDC spot, assess Q1 output impact.u  Hi Vijay,

FYI — BHP has notified us that the coking coal shipment (PO #TS-4521) is delayed 12 days. New ETA March 12–14. This puts Blast Furnace #3 feed at risk if we don't act.

Immediate asks:
1. Review BF#3 feed schedule and flag any shortfall window.
2. Check if we can source 5,000 MT spot from NMDC as a bridge.
3. Loop in production planning to adjust the schedule.

Copying Naveen for visibility.

Rajesh)r   r   blast-furnace
escalation)r   r   r   )r   r   r	   ccr
   r   r   r   r   r   r   zmsg-003z!production.planning@tatasteel.comu-   Action Required — BF#3 Feed Schedule Updatez
2026-02-12zVijay to planning team: update BF#3 schedule to reflect Mar 12 coal ETA. Assess if 70% capacity on reserves is feasible through Mar 10. Response needed EOD.uU  Team,

Coking coal supply for BF#3 is delayed to ~March 12. Please update the production planning system immediately. Current schedule still shows the original Feb 28 feed date — this is now incorrect and a risk.

Also assess: can we run BF#3 at reduced capacity (70%) on existing reserves through March 10?

Need a response by EOD.

Vijay)
operationsr   zproduction-planningzmsg-004u(   Re: Coking Coal Delay — BF#3 Feed Riskz
2026-02-13u   Naveen to Rajesh: 12-day coal delay unacceptable without contingency. Demands BHP written confirmation, spot pricing from NMDC/Coal India, Q1 output impact — 48hr deadline or escalate to Chairman.uq  Rajesh,

Noted. A 12-day delay on a 45,000 MT order is not acceptable without a contingency plan. Please get me:
1. Written confirmation from BHP on the revised ETA.
2. Spot sourcing options with pricing — NMDC or Coal India.
3. Impact on Q1 steel output if we can't bridge the gap.

I want this resolved within 48 hours or escalated to the Chairman's office.

Naveen)r   r   	executivezmsg-005zops-team@tatasteel.commanisha.g@tatasteel.comu5   Die Casting Line #2 — Unplanned Downtime (03:15 AM)z
2026-02-14u   Line #2 down at 03:15 AM — hydraulic pump failure. 48hr repair estimate, ~15% throughput loss. Rerouting to Lines #1/#4. Manisha to track ops log; Bosch Rexroth contacted.ub  Team,

Die casting line #2 went down at 03:15 AM — hydraulic pump failure. Maintenance estimates a 48-hour repair window. We're rerouting to Line #1 and #4 but expect ~15% throughput loss this week.

Manisha — please track the throughput delta in the daily ops log and flag if it exceeds 18%.
Bosch Rexroth contacted for emergency pump supply.

Vijayzdie-casting-maintenance)r   downtimemaintenancezdie-castingzmsg-006u)   Die Casting Throughput — Day 1 Trackingz
2026-02-15us   Day 1: Line #1 at 110%, Line #4 at 98%, net loss 16.2% — within 18% threshold. Bosch Rexroth quote still pending.u  Vijay,

Day 1 post-downtime numbers:
- Line #1: running at 110% (surge load)
- Line #4: running at 98%
- Net throughput loss: 16.2% vs baseline

Within the 18% threshold for now. Will monitor again at 18:00. Bosch Rexroth quote for pump still awaited — Rajesh is following up.

Manisha)r   r   
monitoringzmsg-007zbosch.rexroth.supply@bosch.comu8   Emergency Quote — Hydraulic Pump A10V045 (Die Casting)z
2026-02-17uq   Bosch Rexroth: pump A10V045 at ₹3,42,000, 5 business days (air freight). PO required within 24hrs to hold slot.u   Dear Rajesh,

Emergency supply quote for 1x Hydraulic Pump A10V045:
- Unit price: ₹3,42,000
- Delivery: 5 business days (air freight from Germany)
- Warranty: 12 months

PO required within 24 hours to hold the slot.

Regards,
Bosch Rexroth Supply)r   vendor-quotesr   zmsg-008u9   Re: Hydraulic Pump — Quote Received, PO Approval Neededuf   Rajesh to Vijay: Bosch quote received (₹3,42,000, 5 days). PO approval needed today — 24hr window.u   Vijay,

Bosch Rexroth quote in: ₹3,42,000, delivery 5 business days (air freight). I need your approval to raise the PO today — the slot holds only 24 hours.

Rajesh)r   	approvalsr   zmsg-009zops-monitoring@tatasteel.comu4   [ALERT] Iron Ore Fill Rate Drop — Jamshedpur Plantz
2026-02-21zAuto-alert: iron ore fill rate at Jamshedpur dropped 2.3% (91.7% vs 94% baseline). Suspected causes: screening vibration anomaly (J-047) or moisture spike. Investigate.uk  Automated alert:

Iron ore fill rate at Jamshedpur has dropped 2.3% over the past 72 hours. Current rate: 91.7% (baseline: 94.0%).

Possible causes flagged by monitoring system:
- Screening equipment vibration anomaly (Sensor J-047)
- Moisture content spike in incoming ore batch

Please investigate and log findings in ops system.
— Automated Monitoring Systemziron-ore-ops)r   iron-ore	fill-ratealert
jamshedpurzmsg-010u,   Iron Ore Fill Rate — Root Cause Identifiedz
2026-02-23zRoot cause: worn mesh on screening deck #3, unit J-047 (40% apertures blocked). Fix: replace at Feb 25 maintenance window. Rate stable at 91.8% until then.u[  Vijay,

Investigated the fill rate drop. Root cause: Screening deck #3 on unit J-047 has a worn mesh — approx 40% of apertures are blocked. Replacing the mesh will restore full throughput.

Estimated repair: 6 hours, next planned maintenance window (Feb 25).
Fill rate is stable at 91.8% in the meantime — no further decline observed.

Manisha)r   r   r   z
root-causezmsg-011u;   Iron Ore Fill Rate — Resolved (Root Cause + Action Taken)z
2026-02-25z}Vijay to Naveen: iron ore fill rate issue resolved. Worn mesh on J-047 replaced Feb 25. Rate back to 94.1%. No output impact.u	  Naveen,

The iron ore fill rate issue at Jamshedpur is resolved. Root cause: worn screening mesh on unit J-047. Replaced during the Feb 25 maintenance window. Fill rate back to 94.1% as of 14:00 today.

No output impact — we caught it early via monitoring.

Vijay)r   r   resolvedr   zmsg-012zsafety@tatasteel.comzall-ops@tatasteel.comu6   INCIDENT REPORT #SR-2026-0089 — Hot Strip Mill Cranez
2026-03-05zNear-miss at Hot Strip Mill: frayed overhead crane cable found at pre-shift inspection. 4hr halt, cable replaced, no injuries. RCA initiated; daily crane inspections mandatory.u  INCIDENT REPORT #SR-2026-0089

Location: Hot Strip Mill, Jamshedpur
Time: 2026-03-05 06:20 AM
Type: Near-miss
Description: Overhead crane cable showed fraying during pre-shift inspection. Operations halted 4 hours for emergency cable replacement. No injuries.

Root cause analysis initiated. Interim: daily crane cable inspections mandatory until full audit complete.

— Safety Divisionzsafety-compliance)safetyincidentz	near-missr!   zhot-strip-mill)r   r   r   zmsg-013uC   Re: Incident #SR-2026-0089 — Escalation to Board Safety Committeez
2026-03-06zNaveen escalating SR-2026-0089 to Board Safety Committee (Mar 10). Demands by Mar 9: full RCA, crane inspection confirmation at both plants, 12-month PM calendar.aq  Team,

Any near-miss involving overhead equipment at a live mill is a board-level matter. I want the following by March 9:
1. Full RCA report with contributing factors.
2. Confirmation that all cranes at Jamshedpur and Kalinganagar have been inspected.
3. A preventive maintenance calendar for the next 12 months.

This goes to the Safety Committee on March 10.

Naveen)r#   r   r   rcazmsg-014zprathima.inolu@divami.comu+   Enterprise Brain — Sprint 3 Status Updatez
2026-03-03zDivami Sprint 3: Gmail/Jira agents live in staging, Chanakya end-to-end working. Oracle Unifier blocked on IT credentials. Dashboard in frontend. Next: RT agent. Demo proposed Mar 20.a  Hi Naveen,

Sprint 3 progress:
- Gmail & Jira data agents: live in staging
- Core agent (Chanakya): query + synthesis working end-to-end
- Oracle Unifier connector: blocked on staging credentials (follow-up sent)
- Dynamic dashboard: wireframes approved, frontend starting this week

Next sprint focus: RT agent (real-time intelligence) + alert lifecycle.

Please confirm: can we schedule a demo for March 20?

Prathimaenterprise-brain)r   r&   statusdivamizmsg-015u3   Re: Enterprise Brain — Oracle Unifier Credentialsz
2026-03-04z}Vijay: IT ticket IT-2890 raised for Oracle Unifier access (5 business days). Mar 20 demo confirmed; finance team will attend.u  Prathima,

I've raised the Oracle Unifier staging access with our IT team. Ticket: IT-2890. Expected resolution: 5 business days.

March 20 demo confirmed from our side. I'll also loop in the finance team — they're the primary users for Unifier data.

Vijay)r   r&   zoracle-unifieritzmsg-016zsupply.chain@jsw.inu*   Q2 2026 Iron Ore Pellets — Revised Quoteui   JSW Q2 quote: Grade A pellets +7% (₹8,450/ton), Grade B +5.9% (₹7,200/ton). Quote valid until Mar 15.u!  Dear Rajesh,

Q2 2026 revised quote for iron ore pellets:
- Grade A (Fe 65%+): ₹8,450/ton (prev ₹7,900 +7%)
- Grade B (Fe 62%+): ₹7,200/ton (prev ₹6,800 +5.9%)
- MOQ: 5,000 tons/month | Net 45

Increase driven by global iron ore index. Quote valid until March 15.

JSW Supply Chain)r   r   r   r   zmsg-017u2   JSW Quote — 7% Price Hike on Iron Ore Pellets Q2u   Rajesh to Naveen: JSW +7% on Grade A pellets = +₹82.5L/month at contracted volume. Recommends counter-offer at 3% + parallel NMDC dual-source evaluation.u  Naveen,

JSW has come back with a 7% hike on Grade A pellets for Q2 — ₹8,450 vs ₹7,900 last quarter. At our contracted volume (15,000 MT/month), that's an additional ₹82.5L/month.

Options:
1. Accept — maintain supply continuity.
2. Counter-offer at 3% — test their flexibility before index review date (Mar 20).
3. Dual-source: bring in NMDC at current rate to reduce JSW dependency.

I recommend Option 2 + begin NMDC evaluation in parallel. Your call.

Rajesh)r   r   r   costzmsg-018u0   Q2 Capacity Plan — Inputs Required by March 14z
2026-03-08zNaveen to Vijay+Rajesh: Q2 board review Mar 17. Need by Mar 14: output projections by product line, maintenance windows, headcount gaps, risks >5% output impact.u  Vijay,

Board reviews Q2 capacity plan on March 17. I need your inputs by March 14:
1. Projected output by product line (HRC, CRC, long products)
2. Planned maintenance windows and estimated downtime impact
3. Headcount gaps — any open positions that will affect throughput
4. Risks: flag anything with >5% output impact

Rajesh — please include raw material availability assumptions for the same period.

Naveenzq2-capacity-planning)planningq2r   capacity)r   r   r   zmsg-019u%   Re: Q2 Capacity Plan — Draft Inputsz
2026-03-13u   Vijay Q2 inputs: HRC 98%, CRC 94%, long products 100%. Key risk: BF#3 at 85% until Mar 18 (→ -3% HRC if coal late). 2 open operator roles in Jamshedpur — fill by Apr 15.u  Naveen,

Q2 capacity inputs:
- HRC: 98% utilisation projected (2 planned maintenance days)
- CRC: 94% — Die Casting Line #2 back to full capacity by Apr 1
- Long products: 100% — no issues

Key risk: BF#3 remains at 85% until coking coal backlog clears (est. Mar 18). If coal doesn't arrive by Mar 18, Q2 HRC output drops ~3%.

Two open senior operator roles in Jamshedpur — won't affect output if filled by Apr 15.

Vijay)r+   r,   r   r-   zmsg-020z(client.relations@tatasteelprocessing.comu:   Client Complaint — Delayed HRC Delivery to Maruti Suzukiz
2026-03-10u   Maruti Suzuki formal complaint: Order #MS-7821 delivered Mar 7 vs Feb 28 (7-day delay). Requesting ₹12L credit note + SLA assurance. Tier-1 account — Vijay to advise.uO  Vijay,

Maruti Suzuki has formally complained about the delayed delivery of HRC coils (Order #MS-7821, due Feb 28, delivered Mar 7 — 7-day delay). Their procurement head is requesting a credit note for ₹12L and assurance on future delivery commitments.

Please advise how to respond. This is a Tier-1 account.

— Client Relationszclient-delivery)clientr   deliverymarutizmsg-021u7   Maruti Suzuki Escalation — Credit Note Request ₹12Lz
2026-03-11u   Vijay to Naveen: Maruti requesting ₹12L credit (₹240Cr/yr account). Cause: BF#3 at 85% during coal gap. Recommends approving credit + SLA commitment letter. Needs decision by Mar 13.u  Naveen,

Maruti Suzuki is requesting a ₹12L credit note for the 7-day HRC delivery delay (Order #MS-7821). The delay was caused by BF#3 reduced output during the coal supply gap.

My recommendation: approve the credit note — this is a ₹240Cr/year account. I'll also send their procurement head a written commitment on lead time SLAs going forward.

Please confirm so I can respond by March 13.

Vijay)r.   r   r   r0   creditzmsg-022u   Re: Maruti Suzuki — Approvedz
2026-03-12u   Naveen approved ₹12L credit note. Issue credit + SLA letter, copy Naveen. BF#3 contingency plan required — this must not recur.u   Vijay,

Approved. Issue the credit note and send them the SLA commitment letter. Copy me on the final response to their procurement head.

This should not happen again — BF#3 supply risk needs a standing contingency plan.

Naveen)r.   r   r   zmsg-023u%   Weekly Ops Summary — Week of Mar 15z
2026-03-15zWeek Mar 15: Line #2 fully restored, iron ore 94.2% stable, BF#3 at 85% (coal ETA Mar 18 on track), no safety incidents. 3 tickets beyond SLA (TS-108, TS-110, TS-112). Overall green except BF#3.aG  Vijay,

Week of Mar 15 summary:
- Die Casting Line #2: fully restored as of Mar 14
- Iron ore fill rate: 94.2% (stable)
- BF#3: 85% capacity, coal ETA Mar 18 on track
- No new safety incidents
- 3 open Jira tickets in 'In Progress' state beyond SLA (TS-108, TS-110, TS-112)

Overall: green except BF#3 coal dependency.

Manisha)r   zweekly-summaryr   zmsg-024u+   Coal Arrived — BF#3 Back to Full Capacityz
2026-03-19z~Rajesh to Naveen: MV Southern Cross docked Paradip Mar 18, unloading complete. BF#3 at 100% as of Mar 19. Q2 targets on track.zNaveen,

MV Southern Cross docked at Paradip on Mar 18. Coal unloading complete. BF#3 back to 100% capacity as of this morning.

Q2 production targets are on track.

Rajesh)r   r   r"   r   N)__doc__EMAILS     :/var/www/html/ai-enterprise-brain/data/mock_data/emails.py<module>r7      s     '*F L& %FFF">!?# ( ,,&G v %JJJ!y!y!y+ 0 .1*B r/ %HHH"@B^!_% * (*= \d %<<<":<X!Y% . .&'J CJ -JJJ"@B[!\% * ),> I` -:::";=[!\% * 0*M G- -AAA">!?% * ,,N{
 -===">@^!_ ( .'I ~. "PPP";!<' , ),A qg "GGG";=[!\# ( .&P SO "EEE"@BZ![! * &%K F" 'UUU!v!v!v) . ($,X xG '>>>":<Z![' 0 +&,@ MO &EEE":<Z![) . .)H Sj &III"@!A! * %*?~> "OOO">!?% * ,&G q] "DDD">@X!Y' 0 (,*E wm *===!y!y!y' , .&: Cq *>>>"@BZ![' 0 :,O @# %@@@"@!A% * .&L PD %KKK"@BZ![# ( (,3 Ym %666":<Z![ & ),: XE *@@@";=[!\' , ,&@ T<
 %KKK">@X!Y {n
r5   