PROJECT INSTRUCTIONS — Empresa Costa Rica S.A.
Use these instructions whenever running any IOP Skill for this client.
The config block below is machine-readable and will be picked up automatically by the Skill.

===============================================================================

## IOP-PROJECT-CONFIG

CLIENT: Empresa Costa Rica S.A.
SKILL: monthly-inventory-closing

-- COLORS (Project A keeps IOP brand — no client override) --
--accent:    #EF5155
--highlight: #EF5155
--bg:        #FFFFFF
--text:      #000000
COLOR_RULE:  NONE

-- CURRENCY --
Currency primary: CRC (Costa Rican Colón)
Currency secondary: USD

FX_CHAIN:
  Step 1 — NIO to CRC: multiply NIO value by 14.35 (BCN rate — Banco Central de Nicaragua)
  Step 2 — PAB to CRC: multiply PAB value by 518 (BCCR rate — PAB is pegged 1:1 to USD)
  Step 3 — All CRC to USD: divide total CRC by 518 (BCCR rate — Banco Central de Costa Rica)
  All 3 rates must be declared in the report header. No estimated or approximated rates accepted.

-- PRIOR PERIOD FX RATES (September 2025 close — for Section 3b FX attribution) --
  Sep FX BCN rate:  1 NIO = 14.28 CRC
  Sep FX BCCR rate: 1 USD = 516 CRC
  Sep FX PAB rate:  1 PAB = 516 CRC
  Use these Sep rates to convert prior-period inventory values for working capital comparison.
  The delta between Sep rates and Oct rates drives the FX attribution in Section 3b.

-- LOCATIONS --
LOCATION_1: San Jose — Almacén Central | Currency: CRC | Native — no FX conversion needed
LOCATION_2: Managua — Bodega Norte | Currency: NIO | Apply FX Step 1 before consolidation
LOCATION_3: Panama City — Depósito PTY | Currency: PAB | Apply FX Step 2 before consolidation

-- SLOW-MOVING THRESHOLDS --
Slow-moving RM: 60 days
Slow-moving FG: 60 days
Note: 60-day threshold applies group-wide across all 3 locations. The IOP default of 90 days does not apply to this client.
Managua slow-moving values must always be flagged as ESTIMATED ONLY and disclosed separately — COGS gaps mean last-movement dates cannot be fully verified.

-- REPORT STRUCTURE OVERRIDES --
Inventory split: no (no RM/FG split required)
Section 4: Write-off and Obsolescence Risk (IOP default — no replacement)

ADDITIONAL SECTIONS REQUIRED (added by Project A — run in this order):
  Section 0 — Warehouse Consolidation Bridge
    - Runs BEFORE Section 1. Do not skip or merge into Executive Summary.
    - Show each location individually: local closing value, FX step applied, CRC equivalent, USD equivalent, data quality status.
    - Show consolidated rollup table: local value | CRC converted | USD converted | status per location | consolidated total.
    - If a reconciliation gap exists (ledger vs physical count, or unbooked COGS), calculate the gap amount and disclose it explicitly to the CFO in this section before the report proceeds.

  Section 3b — FX Impact on Working Capital
    - Runs AFTER Section 3, BEFORE Section 4.
    - Show each location's working capital change in local currency, FX step applied, CRC equivalent, USD equivalent.
    - Identify whether WC movement is driven by genuine inventory change or FX rate movement.
    - Use the Sep 2025 prior-period FX rates declared above to attribute volume vs rate effects.
    - Show consolidated WC change in CRC and USD.

-- DATA QUALITY RULES --
Check each warehouse separately and flag independently:
  Managua: flag if data arrives more than 2 days late. Flag if COGS is missing for any week.
  San Jose: flag if any weekly COGS is estimated or unreconciled at close.
  Panama City: confirm physical count reconciliation. Flag if any variance found.
Consolidation gap (if any) must be disclosed to CFO in Section 0 before report proceeds.

-- FOOTER --
Footer text: Prepared by Inventory Optimization Pro | inventoryoptimization.pro

## END IOP-PROJECT-CONFIG

===============================================================================

NOTES FOR HUMAN USE (not read by Skill):

- Upload this file alongside the transaction data CSV whenever running a monthly closing report for Empresa Costa Rica.
- The Skill will scan all uploaded files for the IOP-PROJECT-CONFIG block and apply these settings automatically.
- FX rates (14.35 and 518) are the Oct 2025 declared rates. Sep 2025 prior-period rates (14.28 / 516) are also declared above for Section 3b FX attribution. Update all rates here if they change before the next report run.
- The 60-day slow-moving threshold is a client decision. Any change must be updated in this file before the next report run.
- Managua data is historically late. If the file arrives with gaps, the Skill will flag it per the DATA QUALITY RULES above.
- Prior-period reference data (Sep 2025 DIO, COGS, inventory by location) is embedded in the dataset CSV for Section 3 and Section 3b calculations.
