Quarterly report to leadership deck (PT Zava Niaga Nusantara, Q3 2026)
======================================================================

FICTIONAL DEMO DATA. Not a real document. Any resemblance to real organisations or people is coincidental.

Scenario: https://hmarofiq.github.io/copilot-scenarios-asean/scenarios/x-report-deck-017/

CONTENTS
  - 01_QBR_Request_and_Deck_Standard.docx: the Chief of Staff's request, the Direksi's three questions and the QBR deck standard (rules)
  - 02_Q3_2026_Distribution_Operations_Report_v1.0.docx: the report you received (about 10 pages) (v1.0, 1 October)
  - 03_Q3_2026_Distribution_KPI_Workbook.xlsx: the KPI workbook issued with the report (Safety_Log refreshed 2 October)
  - 04_Email_Correction_Surabaya_Volume.docx: the Operations Controller's correction, sent the evening before you start
  - 05_Q2_2026_QBR_Distribution_Operations.pptx: last quarter's deck with the three commitments
  - 06_Zava_Niaga_QBR_Template.pptx: the QBR template to build in

SETUP (your own work tenant; fictional data only)
  1. Upload files 01-06 to one folder in your own OneDrive for work (or attach them where the scenario page says). Open each once.
  2. Keep this README out of Copilot; it contains the answer key.
  3. Follow the steps for your tier on the scenario page: Copilot Chat (Basic), Microsoft 365 Copilot (Premium) or Copilot Cowork.

ANSWER KEY (spoilers: open only after you have built your deck)
  - OTIF (orders on time in full): 92.3% | target 93.0% | +1.0 pts vs Q2 | Amber
  - Fill rate (order lines, like for like): 91.2% | target 92.0% | +0.8 pts vs Q2 | Amber
  - Cost per case (corrected volume): IDR 8,639 | target IDR 8,600 | +1.3% vs Q2 | Amber
  - Inventory days (volume-weighted): 31.4 days | target 32 | -2.0 days vs Q2 | Green
  - Cikarang utilisation (Q3 average): 91.2% | target 88.0% | +2.3 pts vs Q2 | Amber
  - Lost-time injury frequency (per 1M hours): 0.41 | target 0 | 1 LTI vs 0 vs Q2 | Red
  - Customer complaints (count): 18 | target 15 | +5 (from 13) vs Q2 | Amber
  - T1 headline month: the report headlines September OTIF 94.0%; the quarter is 92.3%.
  - T2 averaging: the average of the four DC percentages is 93.3% (Green); from total orders it is 92.3% (Amber), +1.0 pts on Q2.
  - T3 correction: cost per case IDR 8,585 (Green) in the report becomes IDR 8,639 (Amber) after removing 18,400 transfer cases; Surabaya IDR 8,504 -> IDR 8,782.
  - T4 definition change: the report's +3.7 pts fill rate compares case basis with line basis; like for like it is +0.8 pts (lines 91.2% vs 90.4%; cases 94.1% vs 93.3%).
  - T5 safety: the report says zero LTIs; Safety_Log HSE-2026-088 (Medan, 19 Aug) was reclassified to a lost-time injury on 2 Oct. 1 LTI, LTIFR 0.41, Red.
  - T6 utilisation: "excellent utilisation" is a capacity risk. Cikarang 91.2% average is Amber; September month end 93.0% is Red. Q4 forecast about 96%.
  - T7 small count: complaints 13 -> 18 (+5, Amber); do not headline +38.5%.
  - T8 commitments: C1 Done; C2 Partly done; C3 Not started. Surabaya overtime 37,500 hours = 9.0% below Q2, not 20%.
  - T9 people: Appendix C (named disciplinary warning and picker ranking) must not appear in the deck.
  - T10 decision: the overflow warehouse (IDR 4.2 billion a year) and the carrier tender are decisions requested, not approved.
  - Deck: 10 slides or fewer in the template; notes with sources on every content slide.
