## IOP-PROJECT-CONFIG
CLIENT_NAME: Singapore Manufacturing Co
--accent: #1B3A6B
--highlight: #C9A84C
--bg: #FFFFFF
--text: #000000
COLOR_RULE: #EF5155 is PROHIBITED. Do not use it anywhere in the report.
## END IOP-PROJECT-CONFIG
================================================================
PROJECT B INSTRUCTIONS - Singapore Manufacturing Co Pte Ltd
Inventory Optimization Pro | inventoryoptimization.pro
================================================================

HOW TO USE THIS FILE — TWO OPTIONS:

OPTION 1 (RECOMMENDED): Paste into Claude Project Instructions box
1. Open Claude.ai
2. Create a new Project (click Projects in the left sidebar)
3. Name it: Singapore Manufacturing - Monthly Closing
4. Go to Project Instructions
5. Copy and paste EVERYTHING below the dashed line into the instructions box
6. Upload the file: project-b-dataset-singapore-manufacturing.csv into the Project files
7. Also upload: monthly-inventory-closing-skill.md into the Project files
8. You are ready. Type: /monthly-inventory-closing run month end closing

OPTION 2 (ALSO WORKS): Upload this file directly
If you upload this file instead of pasting it, the skill will automatically
detect and read the IOP-PROJECT-CONFIG block below. The config block is
machine-readable — the skill knows to look for it.

----------------------------------------------------------------

## IOP-PROJECT-CONFIG
## This block is read by the monthly-inventory-closing skill.
## When this file is uploaded, the skill reads this block before
## writing any HTML. Do not remove or rename this header.

CLIENT_NAME: Singapore Manufacturing Co Pte Ltd
REPORTING_TO: Group CFO, David Tan
INDUSTRY: Precision components manufacturing — aerospace, automotive, industrial

COLOR_ACCENT: #1B3A6B
COLOR_HIGHLIGHT: #C9A84C
COLOR_BG: #F8F9FA
COLOR_TEXT: #1C1C1C

COLOR_RULE: The IOP default color #EF5155 must not appear anywhere in this
report. Navy (#1B3A6B) replaces all red accent uses. Gold (#C9A84C) is used
for all KPI numbers and highlight values. Background is light gray (#F8F9FA),
not white. Body text is near-black (#1C1C1C).

CURRENCY_PRIMARY: SGD
CURRENCY_SECONDARY: USD
FX_SOURCE: Monetary Authority of Singapore (MAS) daily fixing only. No
estimated or interpolated rates. FX rates are embedded in the dataset.

INVENTORY_SPLIT_REQUIRED: YES
INVENTORY_SPLIT_RULE: Every table showing inventory values must have three
columns in this order: Raw Materials (SGD) | Finished Goods (SGD) | Total (SGD).
Never show a consolidated total without the RM and FG breakdown columns first.

SLOW_MOVING_RM_DAYS: 150
SLOW_MOVING_FG_DAYS: 90
SLOW_MOVING_RULE: These two thresholds are independent. Apply 150 days to all
Raw Materials. Apply 90 days to all Finished Goods. The SAP aging report
embedded in the dataset uses a 90-day production planning threshold for all
categories — do not use that threshold. Apply the finance thresholds above.

SECTION_4_REPLACE: YES
SECTION_4_TITLE: Margin Exposure by Product Line
SECTION_4_CONTENT: Show RM and FG closing values per product line (Aerospace,
Automotive, Industrial). Include gross margin percentage and gross margin at
risk (inventory value x GM rate) per line. Source margin rates from the P&L
appendix embedded in the dataset. Flag any product line whose inventory value
exceeds 40% of total portfolio value.

FISCAL_YEAR: April to March (non-calendar)
FISCAL_RULE: Always state the fiscal quarter and month number in the report
header. October 2025 = Q3 FY2025, Month 7 of 12.

DATA_SOURCE: SAP S/4HANA — Plant MFG-SGP-01. Data is authoritative.
DATA_QUALITY_RULE: Do not raise generic data quality warnings. Only flag
anomalies actually found in the data — parked postings, blocked deliveries,
open invoice queries noted in description fields.
DATA_PARKED_RULE: Rows marked "Parked" or "Blocked" must be excluded from
valuation. Rows with blank amounts must be flagged and excluded.

FOOTER_TEXT: Prepared by Inventory Optimization Pro for Singapore Manufacturing Co Pte Ltd
FOOTER_URL: Do not include the inventoryoptimization.pro URL in the footer.

## END IOP-PROJECT-CONFIG

================================================================
PROJECT DETAIL — FULL CONTEXT
================================================================

These sections expand on the config above. Read these after parsing
the config block.

PROJECT: Singapore Manufacturing Co Pte Ltd
INDUSTRY: Precision components manufacturing — aerospace, automotive, industrial
REPORTING TO: Group CFO, David Tan
ERP: SAP S/4HANA

FISCAL YEAR:
April to March (non-calendar). Always state fiscal quarter and month number
in the report header. October 2025 = Q3 FY2025, Month 7 of 12.

DATA FORMAT:
The uploaded CSV is a raw SAP S/4HANA inventory transaction extract.
SAP movement type codes used in this extract:
  101 = Goods receipt (purchase or production)
  261 = Goods issue to production order
  561 = Opening balance / stock transfer in
  601 = Goods issue for delivery (customer shipment / COGS)
Derive opening balance, purchases (GR), RM consumption (GI to production),
and shipments / COGS (GI for delivery) from the movement type column.
Rows with status "Parked" or "Blocked" must be excluded from valuation.

CURRENCY:
SGD is the primary currency. USD is the reference currency shown second.
FX source: MAS daily fixing only. Rates are in the FX reference section
of the dataset. Do not use estimated or interpolated rates.

INVENTORY SPLIT:
Every table showing inventory values must include three columns in this
order: Raw Materials | Finished Goods | Total. Never show a single total
without the category breakdown first. This applies to every section of the
report including the Executive Summary KPI cards.

SLOW-MOVING THRESHOLDS:
Raw Materials: 150 days no consumption (GI to production)
Finished Goods: 90 days no shipment (GI for delivery)
The SAP aging report in the dataset uses a 90-day production planning
threshold for all categories. This is a system flag, not the finance
threshold. Use the finance thresholds above and explicitly note in the
report that the SAP system threshold differs.

SECTION 4 — REPLACEMENT:
Remove the IOP default Section 4 (Write-off and Obsolescence Risk) entirely.
Replace with: Margin Exposure by Product Line.

Content for replacement Section 4:
- Opening paragraph: portfolio concentration analysis
- Table: one row per product line (Aerospace, Automotive, Industrial)
  Columns: Product Line | RM Value (SGD) | FG Value (SGD) | Total (SGD) |
           Portfolio % | Gross Margin % | GM at Risk (SGD) | Flag
- Flag any product line exceeding 40% of total portfolio value as EXCEEDS 40%
- Include a slow-moving monitoring table below the main table showing
  any materials approaching or breaching the finance thresholds
- Narrative paragraph per flagged product line
- Gross margin rates: source from the P&L appendix section of the dataset
  (Q3 FY2025 actuals by product line)

FOOTER:
Exact text: "Prepared by Inventory Optimization Pro for Singapore Manufacturing Co Pte Ltd"
Do not include inventoryoptimization.pro URL.

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