PPIC Learning Module

PPIC Learning Module - Advanced Level

PPIC LEARNING DASHBOARD

📋 Definisi & Peran PPIC

📊 Jenis Laporan PPIC

📦 Stock Opname

🔄 Cycle Count

📈 Inventory Management

💡 Best Practices & Tips

📋 Definisi & Peran PPIC

Memahami PPIC secara Komprehensif

🎯 Pengertian PPIC Mendalam

🛠️ Framework & Tools PPIC

👥 Skill & Kompetensi PPIC

🔗 Integrasi Departemen

📍 PPIC dalam SCOR Model

⚡ Challenge & Solution

Overview: Apa itu PPIC?

PPIC (Production Planning & Inventory Control) adalah fungsi kritis dalam supply chain yang mengelola produksi dan persediaan perusahaan. Bukan hanya "orangnya", tetapi sistem pengelolaan menyeluruh.

                💡 Analogi Sederhana:

                PPIC itu seperti KONDUKTOR ORKESTRA. Konduktor tidak main musik sendiri, tapi mengatur semua pemain (Sales, Production, Procurement, Warehouse) agar harmonis. Tangan konduktor cuma bergerak dikit, tapi semua pemain berkeringat. Hasilnya? Musik yang indah = Supply chain yang smooth!

⚠️ Fakta dari Lapangan (Survey Podcast Jatayu):
Kenapa PPIC pusing?

Forecast tidak sesuai aktual
Planning sering revisi mendadak
Permintaan dadakan dari sales
Data tidak akurat
Material delay dari supplier
Dikomplain produksi terus
Jadwal kirim maju tiba-tiba
Demand fluktuatif
Stock kurang tapi dimarahin!

Tapi... dengan framework yang benar, semua bisa dikelola! 💪

🎯 Pengertian PPIC Mendalam

Memahami setiap elemen PPIC dengan detail dan contoh nyata

PPIC: Lebih dari Sekedar "Orang yang Bikin Jadwal"

PPIC adalah AKTIVITAS FUNGSIONAL dalam mengelola produksi dan persediaan. Kata kunci: MENGELOLA.

Apa arti "Mengelola"?
Mengelola mencakup 4 aktivitas utama:

MONITORING - Mengawasi proses
CONTROLLING - Mengendalikan & mengambil tindakan
EVALUASI - Menilai performa vs target
REPORTING - Melaporkan ke stakeholders

1. Production Planning (Perencanaan Produksi)

Merencanakan WHAT (produk apa), WHEN (kapan dibuat), HOW MUCH (berapa quantity).

📌 CONTOH NYATA - Pabrik Minuman Kemasan:

Situasi:
Forecast sales bulan Mei 2025:

Teh Botol 500ml: 100,000 botol
Jus Jeruk 500ml: 50,000 botol
Air Mineral 600ml: 200,000 botol

Input Production Planning:

Kapasitas mesin bottling: 50,000 botol/hari (1 shift)
Hari kerja efektif: 24 hari (exclude weekend & libur)
Setup time ganti produk: 2 jam
Target utilization: 85% (sisanya untuk maintenance & buffer)

Output MPS (Master Production Schedule):

Week 1 (Tgl 1-6 Mei):

Senin-Rabu: Produksi Air Mineral 120,000 botol (prioritas - fast moving)
Kamis-Jumat: Setup + Produksi Teh Botol 25,000 botol
Sabtu-Minggu: OFF

Week 2 (Tgl 7-13 Mei):

Senin-Selasa: Lanjut Teh Botol 25,000 botol
Rabu: Setup + Produksi Jus Jeruk 15,000 botol
Kamis-Jumat: Air Mineral 50,000 botol

Week 3 (Tgl 14-20 Mei):

Senin-Rabu: Teh Botol 50,000 botol (finish target 100k)
Kamis-Jumat: Jus Jeruk 20,000 botol

Week 4 (Tgl 21-31 Mei):

Senin-Selasa: Jus Jeruk 15,000 botol (finish 50k)
Rabu-Jumat: Air Mineral 30,000 botol (finish 200k)

Pertimbangan Planning:

Air Mineral diproduksi lebih dulu (fast moving, takut stockout)
Setup time diminimalkan dengan batching (tidak ganti-ganti produk setiap hari)
Customer order yang urgent diprioritaskan
Buffer stock untuk safety

2. Production Control (Pengendalian Produksi)

Memastikan produksi berjalan sesuai plan dan mengontrol kualitas output.

📌 CONTOH MONITORING REAL-TIME:

Target Hari Ini (Senin, 5 Mei): Produksi Air Mineral 40,000 botol

JAM 09:00 - Morning Meeting:

Target pukul 09:00: 5,000 botol (12.5% dari 40k)
Actual: 4,800 botol
Variance: -200 botol (-4%)
Status: ⚠️ Sedikit behind, masih OK

JAM 12:00 - Mid-day Check:

Target: 20,000 botol (50%)
Actual: 18,500 botol
Variance: -1,500 botol (-7.5%)
Status: 🔴 Behind schedule!

Root Cause Analysis:

Mesin breakdown 30 menit di jam 10:00
Reject rate 5% (normal: 2%) - Quality issue!
Operator kurang 1 orang (sakit mendadak)

ACTION dari Production Control:

Immediate: Call maintenance team - cek mesin (solved: spare part diganti)
Quality: Adjust parameter mesin - reject turun jadi 2.5%
Manpower: Koordinasi HRD - backup operator dari line Teh Botol (yang hari ini off)
Planning: Extend shift 1.5 jam (overtime) untuk kejar target
Communication: Inform Sales - kalau tetap gap, mungkin delay delivery 1 hari

JAM 17:00 - End of Day:

Target: 40,000 botol
Actual: 39,200 botol (dengan overtime)
Achievement: 98%
Gap: -800 botol
Decision: Tambah ke besok (masih ada buffer stock 2,000)

Yang Dikontrol Production Control:

Output quantity per jam/shift
Reject ratio (quality)
Machine downtime
Manpower utilization
Material consumption vs standard

3. Inventory Planning (Perencanaan Persediaan)

Merencanakan kebutuhan material untuk support produksi melalui MRP (Material Requirement Planning).

📌 CONTOH LENGKAP MRP PROCESS:

INPUT dari MPS:
Produksi Teh Botol 500ml = 100,000 unit di bulan Mei

BOM (Bill of Material) Teh Botol 500ml:
1 unit Teh Botol butuh:

Botol PET 500ml: 1 pcs
Teh konsentrat: 50 ml
Air mineral: 400 ml
Gula cair: 50 ml
Tutup botol: 1 pcs
Label: 1 pcs
Karton isi 24: 1/24 = 0.042 pcs

STEP 1: Gross Requirement (Kebutuhan Kotor)
Untuk 100,000 unit Teh Botol:

Material	Kebutuhan per Unit	Gross Requirement
Botol PET 500ml	1 pcs	100,000 pcs
Teh Konsentrat	50 ml	5,000 liter
Air Mineral	400 ml	40,000 liter
Gula Cair	50 ml	5,000 liter
Tutup Botol	1 pcs	100,000 pcs
Label	1 pcs	100,000 pcs
Karton	0.042 pcs	4,200 pcs

STEP 2: On Hand (Stock Saat Ini - per 25 April)

Material	Stock On Hand
Botol PET 500ml	15,000 pcs
Teh Konsentrat	1,200 liter
Air Mineral	10,000 liter (dari well sendiri)
Gula Cair	800 liter
Tutup Botol	50,000 pcs
Label	30,000 pcs
Karton	500 pcs

STEP 3: Net Requirement (Kebutuhan Bersih)
Net Requirement = Gross Requirement - On Hand

Material	Gross	On Hand	Net Requirement
Botol PET	100,000	15,000	85,000 pcs
Teh Konsentrat	5,000 L	1,200 L	3,800 liter
Air Mineral	40,000 L	10,000 L	30,000 liter (produksi sendiri OK)
Gula Cair	5,000 L	800 L	4,200 liter
Tutup Botol	100,000	50,000	50,000 pcs
Label	100,000	30,000	70,000 pcs
Karton	4,200	500	3,700 pcs

STEP 4: Planned Order Release (Kapan Order?)
Harus consider Lead Time masing-masing supplier!

Material	Net Req	Lead Time	Order Date	Expected Arrival
Botol PET	85,000	14 hari	16 April	30 April (H-1 produksi)
Teh Konsentrat	3,800 L	7 hari	23 April	30 April
Gula Cair	4,200 L	3 hari	27 April	30 April
Tutup Botol	50,000	7 hari	23 April	30 April
Label	70,000	10 hari	20 April	30 April
Karton	3,700	5 hari	10 Mei	15 Mei (baru butuh di week 3)

STEP 5: Generate PR (Purchase Request)
PPIC create PR untuk Procurement:

PR-001: Botol PET 85,000 pcs - Deadline PO: 16 April
PR-002: Label 70,000 pcs - Deadline PO: 20 April
PR-003: Teh Konsentrat 3,800 L - Deadline PO: 23 April
PR-004: Tutup Botol 50,000 pcs - Deadline PO: 23 April
PR-005: Gula Cair 4,200 L - Deadline PO: 27 April
PR-006: Karton 3,700 pcs - Deadline PO: 10 Mei

✅ Output MRP:

WHAT - Item apa yang harus dibeli
HOW MUCH - Quantity berapa
WHEN - Kapan harus order & kapan harus datang

Ini adalah 7R of Supply Chain!
Right ITEM, Right QUANTITY, Right TIME!

4. Inventory Control (Pengendalian Persediaan)

Mengawasi dan menjaga akurasi stock, memastikan leveling stock optimal.

📌 CONTOH INVENTORY CONTROL DASHBOARD:

Dashboard Update: Real-time (Senin, 5 Mei - Pukul 14:00)

Material	Stock Actual	Min Stock	Reorder Point	Max Stock	Status	Action Required
Botol PET 500ml	12,500	20,000	25,000	100,000	🔴 CRITICAL	URGENT PR + Expedite PO!
Teh Konsentrat	3,500 L	2,000 L	3,000 L	8,000 L	✅ Normal	Monitor
Gula Cair	7,800 L	1,500 L	3,000 L	8,000 L	⚠️ Near Max	Hold new order!
Tutup Botol	48,000	30,000	40,000	120,000	✅ Normal	Monitor
Label	25,000	25,000	35,000	110,000	⚠️ At Min	Check ETA PO incoming

ACTION dari Inventory Control:

CRITICAL - Botol PET (Stock 12,500 vs Min 20,000):

Immediate check: Apakah ada PO incoming? → Yes, PO-12345 qty 85k, ETA 30 April
Call Procurement: "Bisa expedite? Produksi mulai 1 Mei, kita hanya punya 12,500!"
Procurement cek supplier: "Bisa kirim parsial 20k di 28 April, sisanya 30 April"
PPIC decision: "OK, accept! At least ada 20k untuk start produksi"
Inform Production Planning: "Material ready 28 April, tapi limited. Produksi bertahap."

NEAR MAX - Gula Cair (7,800L vs Max 8,000L):

Check: Ada PO incoming? → Yes, PO-12340 qty 4,200L, ETA 27 April
Calculation: 7,800 (current) + 4,200 (incoming) = 12,000L > 8,000L Max!
Problem: Overstock 4,000L! Storage issue + risk expiry
Call Procurement: "HOLD PO-12340! Reschedule delivery!"
Re-calculate: Konsumsi gula = 50ml per botol. Produksi 100k = butuh 5,000L
Solution: "Order 3,000L aja dulu (5,000 - 2,000 buffer). Reschedule jadi split delivery!"

AT MIN - Label (Stock 25,000 = Min 25,000):

Status: Tepat di minimum, belum urgent tapi perlu monitoring
Check PO: PO-12343 qty 70k, ETA 30 April
Assessment: Produksi mulai 1 Mei, ETA 30 April = Cukup!
Action: Daily monitoring 25-30 April. If delay → escalate!

Yang Dikontrol Inventory Control:

Stock level vs Min/Max/Reorder Point
Inventory accuracy (fisik vs sistem)
Aging stock (berapa lama di gudang?)
Expiry date monitoring (FEFO - First Expire First Out)
Slow moving / dead stock identification
DOI (Days of Inventory)
Inventory Turnover Ratio

4 Pilar Mengelola dalam PPIC

Pilar 1: MONITORING (Pengawasan)

Definisi: Mengamati dan mengikuti perkembangan proses secara kontinyu.

Tools Monitoring:

Production Dashboard (Real-time output per jam)
Inventory Level Report (Daily update)
WIP Tracking (Work in Progress di line produksi)
Delivery Schedule Monitoring
Quality Metrics (Reject ratio, rework)

Frequency: Real-time sampai harian (tergantung metric)

📌 Contoh Monitoring Harian PPIC:

Pagi (08:00) - Daily Meeting:

Review production kemarin: Target vs Actual
Check WIP: Berapa yang masih di line?
Material status: Ready untuk produksi hari ini?
Manpower attendance: Ada yang absent?

Siang (12:00) - Mid-day Check:

Production progress: Sudah 50% dari target?
Any issues? Breakdown? Quality problem?
Material consumption: Sesuai standard?

Sore (16:00) - Pre-close Check:

Final push: Bisa achieve target hari ini?
If not: Butuh overtime? Or reschedule?

Malam (17:30) - End of Day Report:

Actual output hari ini
Issues summary
Plan untuk besok

Pilar 2: CONTROLLING (Pengendalian)

Definisi: Mengambil tindakan korektif ketika ada deviasi dari rencana.

Jenis Tindakan Controlling:

Reactive: Respon terhadap masalah yang sudah terjadi
Proactive: Antisipasi masalah sebelum terjadi
Preventive: Cegah masalah berulang

Frequency: On-demand (ketika ada issue) + Preventive (scheduled)

📌 Contoh Controlling - Case Study:

❌ PROBLEM:
Jam 12:00, produksi baru 18,500 botol (target 20,000)
Gap: -1,500 botol (-7.5%)

✅ CONTROLLING ACTION:

Root cause analysis
Fix mesin (maintenance)
Adjust quality parameter
Backup operator
Overtime approval

CONTROLLING - Reactive Example:

Material terlambat datang → Reschedule produksi + inform sales
Mesin breakdown → Reallocate ke mesin backup / overtime
Quality issue → Stop line + adjust parameter + recheck
Absen massal → Call backup operator / reduce target temporary

CONTROLLING - Proactive Example:

Forecast: Besok hujan badai → Inform logistic, antisipasi delay delivery
Material stock mendekati minimum → Expedite PO sebelum stockout
Utilization mesin tinggi (>90%) → Schedule preventive maintenance
Trend reject naik → Quality meeting + operator retraining

Pilar 3: EVALUASI (Penilaian)

Definisi: Menilai performa vs target/standard untuk improvement.

Metrics yang Dievaluasi:

Production: Plan adherence, OEE, Capacity utilization
Inventory: IRA, ITO, DOI, Accuracy
Delivery: OTIF, Lead time, Fulfillment rate
Cost: Variance vs budget, Carrying cost
Quality: Reject ratio, Rework, Customer complaint

Frequency:

Daily: Production output, Stock status
Weekly: Plan vs Actual, Issue summary
Monthly: KPI dashboard, Trend analysis
Quarterly: Strategic review, Improvement plan

📌 Contoh Evaluasi Monthly KPI Review:

KPI	Target	Actual Mei	Status	Trend vs Apr
Production Plan Adherence	95%	92%	⚠️	↓ (April: 94%)
Inventory Record Accuracy	98%	96.5%	⚠️	↓ (April: 97%)
OTIF (On Time In Full)	97%	98.5%	✅	↑ (April: 96%)
Inventory Turnover	8x/tahun	7.5x/tahun	⚠️	→ (April: 7.5x)
DOI (Days of Inventory)	45 hari	48 hari	⚠️	↑ (April: 46 hari)

Root Cause Analysis - Production Plan Adherence 92%:

Week 1: Achievement 95% - OK
Week 2: Achievement 88% - Mesin breakdown 2x
Week 3: Achievement 93% - Material delay 1 hari
Week 4: Achievement 92% - Quality issue, banyak rework

Action Plan untuk Improve:

Preventive maintenance lebih intensive (from monthly → bi-weekly)
Supplier evaluation - penalty untuk delay >2x dalam 1 bulan
Quality training untuk operator - target reject <2%
Target next month: 95% adherence (back to target)

Pilar 4: REPORTING (Pelaporan)

Definisi: Menyampaikan hasil monitoring, controlling, evaluasi ke stakeholders.

Prinsip Good Reporting:

Timely: Tepat waktu (daily, weekly, monthly sesuai jadwal)
Accurate: Data akurat, bukan estimasi asal
Relevant: Sesuai kebutuhan audience (Production Manager beda dengan CFO)
Actionable: Ada insight, bukan cuma data mentah
Visual: Pakai chart/graph, mudah dipahami

Jenis Report berdasarkan Audience:

Stakeholder	Report Type	Frequency	Focus
Production Team	Daily Production Report	Harian	Output, issue, next day plan
Operations Manager	Weekly MPS vs Actual	Mingguan	Achievement%, bottleneck
Procurement	MRP & PR List	Weekly	Material requirement, urgent PR
Sales	Available to Promise	Daily/on-demand	Stock availability, delivery date
Finance	Inventory Valuation	Monthly	Inventory value, DOI, ITO
Top Management	KPI Dashboard	Monthly	Strategic metrics, trend, action plan

                🎯 KESIMPULAN - Pengertian PPIC Mendalam:

                PPIC = SISTEM PENGELOLAAN KOMPREHENSIF yang mencakup:

                4 Fungsi Utama:

                Production Planning: MPS - Jadwal produksi detail (What, When, How Much)
Production Control: Monitor & tindakan korektif agar sesuai plan
Inventory Planning: MRP - Hitung kebutuhan material (Item, Qty, Timing)
Inventory Control: Jaga stock level optimal & akurasi

                4 Pilar Mengelola:

                Monitoring: Awasi proses real-time
Controlling: Ambil tindakan korektif/preventif
Evaluasi: Nilai performa vs target
Reporting: Komunikasi ke stakeholders

                Analoginya: PPIC = Konduktor orkestra supply chain 🎼

🛠️ Framework & Tools PPIC

Sistem, Prosedur, dan Teknologi yang Mendukung PPIC

5 Pilar Framework PPIC yang Efektif

Framework ini adalah "ekosistem" yang harus ada agar PPIC bisa berfungsi optimal.
Tanpa salah satu pilar, PPIC akan pincang!

Pilar 1: MEETING STRUCTURE - S&OP (Sales & Operations Planning)

S&OP adalah pertemuan rutin lintas fungsi untuk align demand & supply.

📌 STRUKTUR S&OP MEETING - 4 MINGGU CYCLE:

WEEK 1 - DEMAND REVIEW MEETING
Peserta: Sales, Marketing, PPIC, Finance (observer)
Agenda:

Review forecast accuracy bulan lalu:
- Forecast vs Actual sales
- MAPE (Mean Absolute Percentage Error)
- Root cause variance (kenapa meleset?)
Demand forecast bulan depan:
- Per product family
- Per region/channel
- Split by week
Special events:
- Promo plan (harbolnas, ramadan, dll)
- New product launch
- Contract/tender yang akan masuk

Output: Consensus demand number (belum final!)

WEEK 2 - SUPPLY REVIEW MEETING
Peserta: Operations, PPIC, Procurement, Warehouse, Quality, Maintenance
Agenda:

Review production achievement bulan lalu:
- Plan vs Actual production
- OEE (Overall Equipment Effectiveness)
- Quality metrics (reject, rework)
Capacity check untuk demand bulan depan:
- Available capacity vs required capacity
- Bottleneck identification
- Need overtime? Sub-contract? New shift?
Material availability:
- Critical materials - ETA aman?
- Supplier risk (delay potential)
Constraints & risks:
- Maintenance schedule (mesin mati berapa hari?)
- Manpower (ada cuti massal? training?)
- Warehouse space (cukup untuk inventory?)

Output: Realistic supply plan

WEEK 3 - RECONCILIATION MEETING
Peserta: Sales, Operations, PPIC, Procurement, Finance, Logistics
Agenda:

Gap Analysis:

Item	Demand	Supply	Gap	Status
Teh Botol 500ml	120,000	100,000	-20,000	⚠️ Shortage!
Jus Jeruk 500ml	50,000	60,000	+10,000	✅ OK (buffer)
Air Mineral 600ml	200,000	200,000	0	✅ Match

Mitigation Plan untuk Gap:
- Option 1: Sales turunkan forecast (push to customer later?)
- Option 2: Operations tambah capacity (overtime? outsource?)
- Option 3: Prioritas produk (fokus ke yang margin tinggi)
- Option 4: Hybrid - nego di tengah
Financial Impact:
- Revenue risk jika shortage
- Cost impact jika overtime/outsource
- Inventory cost jika overstock

Output: Agreed action plan + Revised consensus number

WEEK 4 - EXECUTIVE APPROVAL MEETING
Peserta: GM/Director, Head of Sales, Head of Operations, CFO, Supply Chain Manager
Agenda:

Final presentation:
- Consensus demand & supply plan
- Gap & mitigation strategy
- Financial projection (revenue, cost, profit)
- Risk & contingency plan
Decision making:
- Approve atau revise plan
- Budget allocation untuk action plan
- Strategic direction (prioritas produk, market focus)

Output: FINAL APPROVED PLAN - Ini yang jadi MPS!

✅ Benefit S&OP Meeting:

Semua departemen aligned - tidak jalan sendiri-sendiri
Forecast accuracy meningkat (Sales commit, bukan asal tembak)
Production planning lebih realistic (Operations involved sejak awal)
Proactive problem solving (bukan fire fighting terus)
Financial planning lebih akurat

⚠️ CHALLENGE S&OP - Pengalaman Praktisi:

Problem: "Sales selalu overpromise, Operations selalu underpromise!"

Contoh Real:

Week 1: Sales forecast 150k unit
Week 2: Operations bilang "maksimal cuma 100k, mesin tidak cukup!"
Week 3: Nego alot! Sales: "Customer butuh 150k!" Ops: "Fisik tidak bisa!"
Week 4: GM mutusin: "120k - Sales harus manage expectation, Ops harus overtime!"
Actual: Sales cuma jual 110k (forecast jelek!), Ops produksi 125k (overstock!)

Root Cause:

Sales tidak punya consequence jika forecast salah
Operations tidak punya incentive untuk exceed capacity
Tidak ada data-driven discussion (feeling-based negotiation)

Solution:

KPI Accountability:
- Sales KPI include "Forecast Accuracy" (target 85%+)
- Operations KPI include "Plan Adherence" (target 95%+)
- Bonus terkait achievement vs commitment!
Data-Driven Decision:
- Historical accuracy tracking (siapa yang sering meleset?)
- Capacity model yang clear (bukan "feeling" bisa atau tidak)
- Scenario analysis (best/worst/likely case)
Facilitation by PPIC:
- PPIC sebagai mediator (bukan sales atau ops yang lead)
- Fact-based presentation (data berbicara, bukan ego)
- Win-win solution (bukan zero-sum game)

Pilar 2: BUSINESS PROCESS - Value Stream Mapping (VSM)

VSM adalah peta aliran proses dari supplier sampai customer, termasuk flow informasi dan material.

📌 CONTOH VSM - Pabrik Minuman Kemasan:

Current State VSM:

SUPPLIER → [RECEIVING] → [WH RM] → [PRODUCTION] → [WH FG] → [SHIPPING] → CUSTOMER
   ↓           ↓            ↓           ↓            ↓           ↓
  PO        3 hari       7 hari     5 hari       10 hari     2 hari     = 27 hari total lead time!
                        (waiting)  (proses)    (inventory)  (delivery)
                        
Value-Added Time: 5 hari (produksi aktual)
Non-Value-Added Time: 22 hari (waiting, storage, transport)
VA Ratio: 5/27 = 18.5% saja! 😱

Waste Identification:

Waiting: Material nunggu 3 hari di receiving (kenapa? Karena QC inspect batch by batch, tidak inline!)
Inventory: Finish goods nunggu 10 hari di warehouse (kenapa? Customer order weekly, bukan daily!)
Transportation: Delivery 2 hari (kenapa? Pakai 3PL yang slow, bukan dedicated fleet!)

Future State VSM - After Improvement:

SUPPLIER → [RECEIVING] → [WH RM] → [PRODUCTION] → [WH FG] → [SHIPPING] → CUSTOMER
   ↓           ↓            ↓           ↓            ↓           ↓
  VMI       1 hari       3 hari     5 hari       3 hari      1 hari     = 13 hari! (50% reduction!)
                      (QC inline)  (proses)   (daily ship)  (own fleet)
                        
Value-Added Time: 5 hari (sama)
Non-Value-Added Time: 8 hari (turun dari 22 hari!)
VA Ratio: 5/13 = 38.5%! 🎉

Improvement Actions:

VMI (Vendor Managed Inventory): Supplier stock di dekat pabrik, kita pull as needed
Inline QC: Tidak batch inspect, tapi inline check (faster release)
Raw Material reduction: JIT delivery, turunkan WH RM dari 7 hari → 3 hari
Daily shipment: Nego customer untuk daily order (small batch, frequent delivery)
Finish Good reduction: Dari 10 hari → 3 hari inventory
Own fleet: Dedicated delivery team, bukan 3PL (faster, more control)

💡 Peran PPIC dalam VSM:

PPIC harus tahu VSM secara detail - dari hulu ke hilir
PPIC facilitate VSM workshop (bukan cuma production, tapi end-to-end)
PPIC monitor lead time di setiap stage
PPIC drive improvement untuk reduce non-VA time

Pilar 3: MASTER DATA - Bill of Material (BOM)

BOM adalah "resep" produk - daftar komponen & quantity untuk membuat 1 unit finish good.

⚠️ BOM vs BOQ (Bill of Quantity):

Aspek	BOM (Production)	BOQ (Inventory)
Struktur	Ada leveling (parent-child hierarchy)	Flat - cuma list quantity
Digunakan untuk	MPS → MRP calculation	Costing, purchasing
Detail	Include subassembly, WIP	Cuma raw material + FG
Contoh User	PPIC, Production Planning	Procurement, Finance

📌 CONTOH BOM LENGKAP - Sepeda (Multi-level BOM):

LEVEL 0 - FINISH GOOD:
└── Sepeda Model X (1 unit)
    │
    ├── LEVEL 1 - MAJOR SUBASSEMBLY:
    │   ├── Frame Assembly (1 set)
    │   ├── Wheel Assembly (2 set) ← Front & Rear
    │   ├── Brake System (1 set)
    │   ├── Drivetrain (1 set)
    │   └── Handlebar Assembly (1 set)
    │
    ├── LEVEL 2 - SUBASSEMBLY DETAIL:
    │   │
    │   ├── Frame Assembly breakdown:
    │   │   ├── Main Frame (1 pcs) - Raw Material: Steel Tube 1.5m
    │   │   ├── Fork (1 pcs) - Raw Material: Aluminum Tube 0.5m
    │   │   ├── Seat Post (1 pcs) - Raw Material: Steel Rod 0.3m
    │   │   └── Welding Wire (0.2 kg) - Consumable
    │   │
    │   ├── Wheel Assembly (each) breakdown:
    │   │   ├── Rim (1 pcs) - Purchased Part
    │   │   ├── Hub (1 pcs) - Purchased Part
    │   │   ├── Spokes (36 pcs) - Purchased Part
    │   │   ├── Tire (1 pcs) - Purchased Part
    │   │   └── Inner Tube (1 pcs) - Purchased Part
    │   │
    │   ├── Brake System breakdown:
    │   │   ├── Brake Lever (2 pcs) - Left & Right
    │   │   ├── Brake Cable (2 pcs) - Front & Rear
    │   │   ├── Brake Caliper (2 pcs) - Front & Rear
    │   │   └── Brake Pads (4 pcs) - 2 per caliper
    │   │
    │   ├── Drivetrain breakdown:
    │   │   ├── Crankset (1 set)
    │   │   ├── Chain (1 pcs)
    │   │   ├── Cassette (1 set - 7 speed)
    │   │   └── Derailleur (2 pcs) - Front & Rear
    │   │
    │   └── Handlebar Assembly breakdown:
    │       ├── Handlebar (1 pcs) - Aluminum
    │       ├── Stem (1 pcs)
    │       ├── Grips (2 pcs)
    │       └── Bell (1 pcs)
    │
    └── LEVEL 3 - RAW MATERIAL & FASTENERS:
        ├── Bolts M6x20 (24 pcs) - Various locations
        ├── Nuts M6 (24 pcs)
        ├── Washers (48 pcs)
        ├── Lubricant Oil (50 ml)
        └── Paint (0.3 liter) - Finishing

Bagaimana PPIC Menggunakan BOM ini untuk MRP?

STEP 1: MPS (Master Production Schedule) - Level 0
Production plan bulan Mei: 1,000 unit Sepeda Model X

STEP 2: Explosion ke Level 1 (Major Subassembly)
Untuk 1,000 unit Sepeda, butuh:

Frame Assembly: 1,000 set
Wheel Assembly: 2,000 set (2 per sepeda - front & rear!)
Brake System: 1,000 set
Drivetrain: 1,000 set
Handlebar Assembly: 1,000 set

STEP 3: Explosion ke Level 2 (Component Detail)
Contoh untuk Wheel Assembly 2,000 set:

Rim: 2,000 pcs
Hub: 2,000 pcs
Spokes: 72,000 pcs (36 per wheel × 2,000)
Tire: 2,000 pcs
Inner Tube: 2,000 pcs

STEP 4: Explosion ke Level 3 (Raw Material & Fasteners)
Untuk 1,000 sepeda:

Bolts M6x20: 24,000 pcs (24 per sepeda)
Steel Tube 1.5m: 1,000 pcs (untuk main frame)
Paint: 300 liter (0.3L per sepeda)
Dst...

STEP 5: Netting (Kurangi dengan On-Hand Stock)
Contoh Spokes:

Gross Requirement: 72,000 pcs
On-Hand Stock: 15,000 pcs
Net Requirement: 57,000 pcs

TAPI TUNGGU! Supplier jual dalam pack 100 pcs. Maka:

Order Quantity: 57,000 ÷ 100 = 570 pack
Actual receive: 570 × 100 = 57,000 pcs ✅

STEP 6: Lead Time Offsetting (Kapan harus order?)

Production start: 1 Mei 2025
Spokes lead time: 14 hari
Order date: 1 Mei - 14 hari = 17 April 2025
Expected arrival: 30 April 2025 (H-1 produksi)

✅ Kenapa BOM HARUS multi-level?

Subassembly bisa diproduksi terpisah: Frame Assembly bisa dibuat dulu di workshop A, Wheel Assembly di workshop B, final assembly di line C
Lead time berbeda per level: Raw material 14 hari, subassembly butuh 3 hari, final assembly 2 hari - harus backward schedule!
Inventory control per level: Bisa stock subassembly untuk flexibility (Assemble-to-Order strategy)
Cost breakdown: Finance bisa hitung COGS per level (material cost, labor cost, overhead)

Pilar 4: TECHNOLOGY - ERP & WMS Integration

PPIC adalah power user ERP! User PPIC biasanya punya akses ke banyak modul.

Modul ERP yang Digunakan PPIC:

Production Planning Module (PP):
- Create & maintain MPS
- Run MRP calculation
- Generate production orders
- Capacity planning
Inventory Management (IM):
- Stock level monitoring
- ABC-XYZ analysis
- Reorder point management
- Inventory valuation
Warehouse Management (WM):
- Goods receipt posting
- Goods issue untuk production
- Transfer location
- Cycle count recording
Material Management (MM) / Procurement:
- Create Purchase Requisition (PR)
- Track PO status
- Expedite critical materials
Sales & Distribution (SD) - Read Only:
- Check sales order
- ATP (Available to Promise) check
- Delivery schedule
Finance (FI) - Dashboard Only (untuk Manager level):
- Inventory value
- DOI, ITO metrics
- Budget vs actual

📌 WORKFLOW INTEGRATION - Contoh Real:

Scenario: Customer order 10,000 unit Sepeda Model X, delivery 30 Mei 2025

STEP 1 (SD Module - Sales Input):
Sales create Sales Order SO-2025-001

Customer: PT Toko Sepeda Jaya
Item: Sepeda Model X
Qty: 10,000 unit
Delivery date: 30 Mei 2025

Sistem auto-check ATP (Available to Promise):

Current stock: 1,500 unit
Planned production (MPS): 5,000 unit ready 25 Mei
Total available: 6,500 unit
Gap: -3,500 unit! 🔴

Status: PENDING APPROVAL - PPIC!

STEP 2 (PP Module - PPIC Review):
PPIC dapat notifikasi: "SO baru butuh 10k unit, shortage 3,500!"
PPIC action:

Check capacity: Apakah bisa tambah produksi 3,500 unit di Mei?
Run capacity planning simulation
Result: Bisa! Dengan overtime 20 jam di week 4
Revise MPS: Tambah production order 3,500 unit (start 15 Mei)
Run MRP untuk 3,500 unit tambahan

STEP 3 (MM Module - MRP Output):
Sistem generate Purchase Requisition (PR) untuk additional material:

PR No	Material	Qty	Required Date
PR-2025-045	Spokes	252,000 pcs	14 Mei (H-1 produksi)
PR-2025-046	Tire	7,000 pcs	14 Mei
PR-2025-047	Steel Tube	3,500 pcs	10 Mei (lebih awal - butuh cutting)

PR auto-route ke Procurement untuk di-PO-kan!

STEP 4 (MM Module - Procurement Action):
Procurement convert PR → PO:

PO-2025-123: Spokes 252k pcs ke Supplier A (Lead time 10 hari, order now 4 Mei!)
PO-2025-124: Tire 7k pcs ke Supplier B
PO-2025-125: Steel Tube 3.5k pcs ke Supplier C

Sistem update status PR: PR Converted to PO ✅

STEP 5 (WM Module - Material Receipt):
13 Mei: Spokes arrive 252k pcs
Warehouse create Goods Receipt (GR) di WMS

Scan barcode PO-2025-123
Qty received: 252,000 pcs ✅
QC inline inspection: PASS ✅
Put-away ke location: RACK-A-15-03

Sistem auto-update:

Inventory IM: Stock Spokes +252k
Finance FI: Inventory value +Rp XXX juta
Production PP: Material availability ✅ (ready untuk produksi 15 Mei)

STEP 6 (PP Module - Production Execution):
15 Mei: Production start untuk 3,500 unit

Production order: PO-PROD-2025-089
Status: IN PROGRESS 🔄

20 Mei: Finish (5 hari production time)

Actual output: 3,480 unit (reject 20 unit = 0.57%)
Status: COMPLETED ✅

Sistem auto:

WM: Goods receipt FG +3,480 unit ke WH-FG
IM: Stock Sepeda Model X +3,480
IM: Stock raw materials (Spokes, Tire, dll) -consumed

STEP 7 (SD Module - ATP Update & Delivery):
ATP update otomatis:

Previous: 6,500 unit available
New production: +3,480 unit
Total available: 9,980 unit
SO-2025-001 requirement: 10,000 unit
Gap: -20 unit ⚠️

PPIC decision:

Option 1: Nego sales - partial delivery 9,980 unit dulu, 20 unit menyusul
Option 2: Ambil dari safety stock (jika ada)
Option 3: Express production 20 unit (1 hari)

Pilih Option 1 → Sales inform customer → Customer OK!

30 Mei: Create Delivery Order DO-2025-456

Qty: 9,980 unit
WM: Pick & pack dari WH-FG
Logistics: Shipment dengan 20 truk
Status: DELIVERED ✅

Sistem auto:

IM: Stock Sepeda Model X -9,980
SD: SO-2025-001 status COMPLETED
FI: Revenue recognition Rp XXX miliar

✅ Ini adalah SEAMLESS INTEGRATION!

Semua modul connected:
Sales → PPIC → Procurement → Warehouse → Production → Logistics → Finance

No manual re-input data! No Excel email ping-pong! No WhatsApp "Pak, sudah datang belum materialnya?"

Real-time visibility untuk semua stakeholders!

Pilar 5: BUSINESS METRICS - KPI Dashboard

PPIC HARUS punya KPI yang terukur. Tidak bisa feeling-based!

Framework KPI PPIC - Balanced Scorecard:

1. SAFETY (S)

Lost Time Injury (LTI) - Target: 0
Near-miss incident reporting rate
Safety audit score

2. SERVICE (S)

OTIF (On Time In Full) - Target: 95-99%
Order Fulfillment Rate - Target: >98%
Customer Complaint (terkait delivery) - Target: <5 per bulan

3. COST (C)

Inventory Turnover Ratio - Target: 6-12x per tahun (tergantung industri)
Days of Inventory (DOI) - Target: 30-60 hari
Inventory Accuracy (IRA) - Target: >95%
Obsolete/Dead Stock - Target: <2% dari total inventory value

4. PEOPLE (P)

PPIC Team Competency Score
Training hours per person - Target: 40 jam/tahun
Employee engagement score

📌 CONTOH KPI DASHBOARD - Monthly Review:

KPI Category	Metric	Target	Actual Jun	Status	Trend (vs May)
SERVICE	OTIF	97%	98.2%	✅	↑ (97.5%)
	Fulfillment Rate	98%	99.1%	✅	→ (99%)
	Customer Complaint	<5 kasus	2 kasus	✅	↓ (3 kasus)
COST	Inventory Turnover	8x/year	7.2x/year	⚠️	↓ (7.5x)
	DOI	45 hari	50 hari	⚠️	↑ (48 hari)
	IRA	96%	95.8%	⚠️	↓ (96.2%)
	Dead Stock %	<2%	1.8%	✅	→ (1.7%)
PRODUCTION	Plan Adherence	95%	93.5%	⚠️	↓ (94%)
PRODUCTION	Capacity Utilization	85%	82%	⚠️	↓ (84%)

Root Cause Analysis - COST Metrics Underperform:

ITO turun (7.2x vs target 8x):
- Cause: Slow-moving items naik 15% (summer season, demand turun)
- Action: Promo clearance untuk slow-moving, adjust forecast untuk Q3
DOI naik (50 hari vs target 45 hari):
- Cause: Over-order material di Mei (antisipasi promo yang ternyata tidak sebesar forecast)
- Action: Hold new order untuk excess items, focus consume internal stock dulu
IRA turun (95.8% vs target 96%):
- Cause: Cycle count frequency turun (dari weekly jadi bi-weekly karena manpower kurang)
- Action: Back to weekly cycle count, tambah dedicated team untuk inventory control

Action Plan Next Month:

Intensify cycle count (back to weekly)
Promo slow-moving items (target: jual 50% dalam 1 bulan)
Tighten forecast review dengan Sales (S&OP lebih strict)
Review reorder point untuk fast-moving items (avoid overstock)
Target Jul: ITO 7.8x, DOI 47 hari, IRA 96.5%

                🎯 KESIMPULAN - Framework & Tools PPIC:

                5 Pilar yang HARUS ada:

                Meeting Structure: S&OP Meeting (4-week cycle) untuk align demand & supply
Business Process: VSM (Value Stream Mapping) untuk identify waste & improvement
Master Data: BOM (Bill of Material) multi-level untuk MRP calculation
Technology: ERP & WMS integration untuk seamless data flow
Business Metrics: KPI Dashboard (SSCP framework) untuk track performance

                Tanpa framework ini, PPIC akan:

                ❌ Jalan sendiri-sendiri (Sales vs Ops always conflict!)
❌ Waste tinggi (lead time panjang, inventory banyak)
❌ MRP error (BOM salah = order salah!)
❌ Manual work banyak (Excel email chaos!)
❌ Tidak terukur (feeling-based decision!)

👥 Skill & Kompetensi PPIC

Profil Ideal, Soft Skills, dan Career Path PPIC Profesional

DISC Profile untuk PPIC Sukses

Berdasarkan pengalaman rekrutmen praktisi selama 10+ tahun:
PPIC yang tangguh, adaptif, dan analytical memiliki profil DISC tertentu!

Apa itu DISC?

DISC adalah personality assessment tool yang mengukur 4 dimensi perilaku:

4 Dimensi DISC:

D - DOMINANCE (Drive, Determination)

Karakteristik: Tegas, berani ambil keputusan, goal-oriented, direct communication
Kekuatan: Proactive, hasil-oriented, tidak takut konflik
Kelemahan: Bisa terkesan bossy, kurang patient, kurang empati

I - INFLUENCE (Inspiring, Interaction)

Karakteristik: Komunikatif, persuasif, antusias, people-oriented
Kekuatan: Build relationship, motivasi tim, networking
Kelemahan: Kurang detail, over-optimistic, bisa impulsif

S - STEADINESS (Supportive, Stable)

Karakteristik: Sabar, loyal, team player, konsisten, good listener
Kekuatan: Harmony, reliability, work-life balance
Kelemahan: Resist change, slow decision making, avoid confrontation

C - COMPLIANCE (Cautious, Correctness)

Karakteristik: Detail-oriented, analytical, systematic, data-driven
Kekuatan: Accuracy, quality control, problem solving
Kelemahan: Over-analyze, perfectionis, kurang flexible

Profil DISC Ideal untuk PPIC

📊 PPIC Profile Pattern (Berdasarkan Data Empiris):


                        IDEAL PPIC DISC PATTERN:

D (Dominance)      : ████████████░░░░░░░░ 60% (Tinggi - tapi tidak ekstrem)
I (Influence)      : ██████████░░░░░░░░░░ 50% (Medium-Tinggi)
S (Steadiness)     : ████░░░░░░░░░░░░░░░░ 20% (Rendah)
C (Compliance)     : ████████████████████ 95% (SANGAT TINGGI!)

Visual Pattern: "V" atau "Checkmark" Shape

    D ────┐
          │
    I ────┤
          │         Bentuk "V" atau "✓"
    S ────┴───────  (S paling rendah)
          │
    C ────┘
                        
                    
Kenapa pattern ini ideal?
C Sangat Tinggi (95%): PPIC HARUS detail, analytical, data-driven. Tanpa ini, planning error besar!
D Tinggi (60%): Berani push Sales/Ops/Procurement. Tidak hanya "terima nasib" kalau forecast berubah!
I Medium-Tinggi (50%): Bisa influence semua pihak dengan data (bukan ngotot doang). Communication skill penting!
S Rendah (20%): Adaptif terhadap change! PPIC yang S tinggi = kaku, sulit adjust plan.

⚠️ Pattern yang TIDAK Cocok untuk PPIC:

❌ HIGH S (Steadiness tinggi):
Problem:

Resist change (padahal forecast berubah terus!)
Avoid conflict (padahal harus push Sales/Ops!)
Slow decision (padahal butuh fast response!)

Contoh:
"Waduh, planning-nya sudah saya buat seminggu lalu... sekarang berubah lagi? Stress nih..."

❌ LOW C (Compliance rendah):
Problem:

Tidak detail (MRP salah, BOM salah!)
Malas analisa data (forecast asal-asalan!)
Tidak sistematis (chaos!)

Contoh:
"Ah kira-kira butuh 100 pcs lah... nanti kalau kurang order lagi aja..."

📌 CASE STUDY - Recruitment PPIC Real:

Kandidat A: D=75%, I=40%, S=15%, C=90%
Interview Result:

✅ Sangat analytical - langsung tanya detail BOM, lead time, capacity
✅ Tegas - "Kalau sales forecast tidak akurat, saya akan challenge!"
✅ Adaptif - "Change itu normal, saya bikin plan A B C"
⚠️ Komunikasi agak kaku - tapi bisa dikembangkan

Decision: HIRED! → Setelah 1 tahun: Promoted jadi PPIC Supervisor!

Kandidat B: D=30%, I=70%, S=60%, C=40%
Interview Result:

✅ Sangat komunikatif - bisa ngobrol seharian!
❌ Tidak detail - "Ah kira-kira gitu deh..."
❌ Takut konflik - "Kalau sales minta tambah, ya saya comply aja..."
❌ Resist change - "Wah kalau sering berubah, ribet..."

Decision: NOT SUITABLE for PPIC. Better fit untuk Sales atau Customer Service.

10 Soft Skills Wajib untuk PPIC

Technical skills bisa dipelajari, tapi soft skills menentukan sukses jangka panjang!

1. Analytical Thinking 🧠

Apa itu: Kemampuan memecah masalah kompleks menjadi bagian-bagian kecil, identifikasi root cause, data-driven decision.

Kenapa penting untuk PPIC:

Forecast tidak akurat → Analyze pattern, seasonality, trend
Production delay → Root cause: mesin? material? manpower?
Inventory variance → Trace transaction history, identify gap

Contoh Real:
"Stock opname variance 5% untuk item X. PPIC yang analytical tidak langsung adjust! Dia trace: (1) Cek transaction history 1 bulan terakhir, (2) Interview operator gudang, (3) Review SOP, (4) Temukan: Ada GR yang belum di-post! Fix SOP, variance turun jadi 1%."

2. Communication & Influence 💬

Apa itu: Menyampaikan ide dengan jelas, persuasif, dan mempengaruhi orang lain dengan data (bukan otoritas).

Kenapa penting untuk PPIC:

PPIC tidak punya wewenang langsung ke Sales/Ops/Procurement
Harus "influence" dengan data, logic, win-win solution
Koordinasi lintas departemen setiap hari!

Contoh Bad Communication:
PPIC: "Pak, forecast-nya salah! Sekarang overstock nih! Sales harus tanggung jawab!"
Sales: (defensif) "Lah, yang buat MPS kan lo! Kok salahkan gue?"
Result: Conflict! ❌

Contoh Good Communication:
PPIC: "Pak, saya ada data nih. Forecast bulan lalu 150k, actual 110k. Variance 27%. Saya sudah analisa, ternyata promo tidak sebesar ekspektasi. Kedepan, boleh kita review forecast bareng setiap minggu? Supaya saya bisa adjust MPS lebih cepat."
Sales: "Oh iya ya... Oke, let's do weekly review!"
Result: Collaboration! ✅

3. Problem Solving 🔧

Apa itu: Identifikasi masalah, generate solutions, evaluate options, implement best solution.

Framework: 5 Whys + Fishbone Diagram

Contoh Case:
Problem: Produksi delay 2 hari!

5 Whys Analysis:
Why 1: Kenapa produksi delay?
→ Material belum datang

Why 2: Kenapa material belum datang?
→ Supplier delay

Why 3: Kenapa supplier delay?
→ PO baru di-release H-5 (harusnya H-14!)

Why 4: Kenapa PO telat release?
→ PR dari PPIC baru masuk H-7

Why 5: Kenapa PR telat?
→ MPS revisi dadakan di H-10, MRP baru di-run H-7

Root Cause: MPS revisi tanpa lead time buffer!
Solution: SOP baru - MPS lock H-21, revisi only for urgent case dengan GM approval!

4. Adaptability & Flexibility 🔄

Apa itu: Cepat adjust terhadap perubahan, tidak kaku, embrace change.

Reality Check:

Forecast berubah: SERING!
Customer order dadakan: NORMAL!
Mesin breakdown: TERJADI!
Material delay: ADA AJA!

PPIC yang kaku = stress! PPIC yang adaptif = siap Plan B, C, D!

Mindset:
"Change is the only constant. My job is to make sure we still deliver despite changes!"

5. Time Management & Prioritization ⏰

Apa itu: Manage multiple tasks, prioritize by urgency & impact, meet deadlines.

PPIC Daily Tasks (Example):

08:00 - Daily production meeting
09:00 - Review inventory status (urgent: item A below min!)
09:30 - Call procurement untuk expedite PO-12345
10:00 - Meeting sales: revisi forecast bulan depan
11:00 - Run MRP untuk MPS update
12:00 - Lunch (sambil cek email - ada order dadakan!)
13:00 - Firefighting: mesin breakdown, reschedule MPS!
14:00 - Meeting ops: capacity tambahan untuk order dadakan?
15:00 - Update MPS, re-run MRP, generate PR
16:00 - Prepare report untuk GM (besok meeting!)
17:00 - End of day report

Banyak kan? Tanpa time management = chaos!

Tool: Eisenhower Matrix (Urgent-Important)

Urgent + Important → DO NOW! (expedite PO, reschedule MPS)
Important, not urgent → SCHEDULE (weekly MPS review)
Urgent, not important → DELEGATE (if possible)
Not urgent, not important → ELIMINATE!

6. Stress Management 😌

Reality: PPIC = pusing, spaneng, snewen (kata praktisi!)

Coping Mechanism:

Mindfulness: Jangan panic! Tarik napas, think clearly
Break down problem: Big problem → small chunks (easier to solve!)
Delegate: Don't do everything yourself!
Work-life balance: Jangan bawa pekerjaan ke rumah (mental health penting!)
Exercise & hobby: Release stress!

7. Attention to Detail 🔍

One decimal place error = disaster!

Contoh Horror Story:
BOM salah input: Steel Tube butuh 1.5 meter per unit
PPIC input: 15 meter (lupa decimal!)
MRP calculation untuk 1,000 unit:

Seharusnya: 1.5m × 1,000 = 1,500 meter
Actual order: 15m × 1,000 = 15,000 meter!

Result: Overstock 10x lipat! Inventory value naik Rp 500 juta! 😱

Lesson: ALWAYS double-check data! Especially unit, decimal, UoM (meter vs cm vs mm)!

8. Collaboration & Teamwork 🤝

PPIC = Hub of Supply Chain!
Interaksi dengan: Sales, Ops, Procurement, Warehouse, QC, Maintenance, Finance, Logistics, HRD, IT...

Mindset:

❌ "Saya vs mereka" → ✅ "Kita satu tim!"
❌ Blame game → ✅ Solution-focused
❌ Silo mentality → ✅ End-to-end thinking

9. Continuous Learning 📚

Supply chain & technology terus berkembang!

New ERP features: Harus belajar!
New forecasting method: Harus update!
Industry best practice: Harus follow!
Certification (APICS, CSCP): Nilai tambah!

Growth Mindset: "I don't know... YET!"

10. Integrity & Accountability 🎯

PPIC pegang data sensitif:

Forecast (competitor mau tahu!)
Inventory value (keuangan perusahaan!)
Supplier info (harga, lead time)

Harus dijaga! Confidentiality penting!

Accountability:

Salah forecast? Admit! Analyze! Improve!
MRP error? Own it! Fix! Prevent recurrence!
Jangan lempar ke orang lain!

Career Path PPIC

PPIC adalah posisi strategis dengan career growth yang jelas!

📊 TYPICAL CAREER LADDER:

Level	Posisi	Experience	Salary Range (Jabodetabek)	Key Responsibilities
Entry	PPIC Staff Material Planner Production Planner	0-2 tahun	Rp 5-8 juta	Operasional: Run MRP, create PR, input MPS, daily monitoring
Junior	Senior PPIC Staff Demand Planner Jr	2-4 tahun	Rp 8-12 juta	Forecasting, ABC analysis, safety stock calculation, cycle count
Middle	PPIC Supervisor Production Planning Supervisor	4-7 tahun	Rp 12-18 juta	Lead team 3-5 orang, MPS approval, S&OP meeting, KPI tracking
Senior	PPIC Manager Supply Planning Manager	7-12 tahun	Rp 18-30 juta	Strategic planning, budget, system improvement, vendor negotiation support
Executive	Supply Chain Director VP Operations	12+ tahun	Rp 40-80+ juta	End-to-end supply chain strategy, P&L responsibility, board reporting

✅ SUCCESS STORY - Real Testimony:

"Saya mulai sebagai PPIC Staff di perusahaan pestisida tahun 2018, gaji Rp 6 juta. Aktif ikut training Jatayu, belajar MRP, forecasting, S&OP. Tahun 2020 dipromote jadi Supervisor (gaji Rp 13 juta). Tahun 2022 pindah ke perusahaan FMCG sebagai PPIC Manager (gaji Rp 25 juta). Sekarang 2025, saya Supply Planning Manager di perusahaan multinational (gaji Rp 35 juta + bonus). Kunci sukses: Continuous learning, data-driven decision, collaboration!"
- Anonymous PPIC Professional

⚠️ Skill Upgrade untuk Career Growth:

Entry → Junior:

Master ERP system (SAP, Oracle, Odoo)
Excel advanced (VLOOKUP, Pivot, Macro)
Basic forecasting method

Junior → Supervisor:

Leadership & people management
Advanced forecasting (time series, regression)
S&OP facilitation
KPI design & tracking

Supervisor → Manager:

Strategic thinking
Budget & financial acumen
Change management
Certification (APICS CPIM/CSCP)
Process improvement (Lean, Six Sigma)

Manager → Director:

Business acumen (P&L understanding)
Executive communication
Industry networking
Digital transformation (AI/ML for forecasting, IoT)

                🎯 KESIMPULAN - Skill & Kompetensi PPIC:

                DISC Profile Ideal: D-tinggi, I-medium, S-rendah, C-sangat tinggi (pattern "V")

                10 Soft Skills Wajib:

                Analytical Thinking - Data is king!
Communication & Influence - Persuasif dengan data
Problem Solving - 5 Whys + Fishbone
Adaptability - Change is normal!
Time Management - Prioritize by impact
Stress Management - Stay calm under pressure
Attention to Detail - One error = disaster
Collaboration - Hub of supply chain
Continuous Learning - Never stop growing
Integrity & Accountability - Own your work

                Career Path: Staff → Supervisor → Manager → Director (Rp 5 juta → Rp 80+ juta)

                Kunci: Continuous learning + Data-driven + Collaboration!

🔗 Integrasi Departemen

PPIC sebagai Hub - Interaksi dengan Semua Fungsi

PPIC: The Central Hub of Supply Chain

                    💡 Analogi:

                    Jika supply chain adalah tubuh manusia, maka:

                    Sales = Mata (melihat demand)
Production = Tangan (menghasilkan produk)
Procurement = Kaki (mencari material)
Warehouse = Perut (menyimpan inventory)
Finance = Jantung (pumping cash flow)
PPIC = OTAK! (mengkoordinasikan semua organ!)

                

Pola Interaksi PPIC dengan Departemen Lain

Frequency of Interaction (per hari):

Departemen	Frekuensi	Medium	Topik Utama
Production	10-20x	Meeting, Phone, WA	Daily schedule, material issue, quality problem
Warehouse	8-15x	ERP, WA, Physical check	Stock level, GR/GI, location, accuracy
Procurement	5-10x	ERP, Email, Meeting	PR approval, PO status, expedite, supplier issue
Sales	3-8x	Meeting, Email, Phone	Forecast review, stock availability, delivery date
Finance	2-5x	Email, Monthly meeting	Inventory value, DOI, budget, variance
QC	2-5x	Report, Meeting	Reject ratio, rework, inspection result
Maintenance	1-3x	Meeting, Schedule	Downtime plan, capacity impact
HRD	1-2x	Email, Ad-hoc	Manpower plan, overtime approval, training

Deep Dive: PPIC ↔ Setiap Departemen

1. PPIC ↔ SALES / MARKETING

📌 Interaction Pattern:

DARI SALES KE PPIC:

Forecast (Monthly): "Bulan depan kami predict sales 100k unit"
Promo Plan (Ad-hoc): "Tanggal 10-12 ada flash sale, butuh tambahan 50k!"
Customer Order (Daily): "Customer X order 10k, delivery 15 Mei, bisa?"
Stock Query (Daily): "Stock item A masih berapa? Customer mau 5k nih"

DARI PPIC KE SALES:

ATP (Available to Promise): "Stock ready 3k, produksi 10 Mei baru 5k, jadi max 8k untuk delivery 15 Mei"
Delivery Commitment: "OK confirmed, 10k bisa delivery 15 Mei"
Forecast Accuracy Review: "Forecast bulan lalu 120k, actual 95k. Variance 21%! Please review method"
Constraint Communication: "Bulan depan ada maintenance 3 hari, capacity turun 20%. Please adjust forecast"

⚠️ COMMON CONFLICT & SOLUTION:

Conflict #1: "Sales selalu overpromise!"
Sales bilang ke customer: "Bisa 20k, delivery 1 minggu!"
PPIC: "Stock cuma 5k, produksi butuh 2 minggu. Impossible!"

Solution:

Implement ATP Check MANDATORY before sales confirm customer
Sales punya akses ERP (read-only) untuk cek stock real-time
SOP: Order >10k HARUS approval PPIC dulu sebelum confirm customer

Conflict #2: "Forecast Sales tidak akurat!"
Actual sales selalu 20-30% lebih rendah dari forecast
Result: Overstock, inventory naik, DOI jelek!

Solution:

KPI Sales include "Forecast Accuracy" (target min 80%)
Monthly S&OP meeting dengan historical tracking
Penalty/reward system untuk accuracy
PPIC provide statistical forecast sebagai baseline (Sales bisa adjust, tapi harus reasonable)

2. PPIC ↔ PRODUCTION / OPERATIONS

📌 Interaction Pattern:

DARI PPIC KE PRODUCTION:

MPS (Weekly/Daily): "Minggu ini produksi: Senin item A 5k, Selasa item B 3k, dst"
Production Order: "PO-PROD-123: Item X, qty 10k, start 1 Mei, deadline 5 Mei"
Material Readiness Info: "Material untuk PO-PROD-123 sudah ready di gudang RM, bisa start!"
Urgent Request: "Ada order dadakan 2k unit, bisa di-squeeze ke schedule besok?"

DARI PRODUCTION KE PPIC:

Actual Output (Daily): "Hari ini target 5k, actual 4.8k (reject 200 unit)"
Issue Report: "Mesin breakdown 2 jam, produksi delay. Butuh reschedule?"
Material Issue: "Material Z habis, tolong PPIC cek stock!"
Capacity Feedback: "Kalau mau 10k seminggu, butuh overtime atau tambah shift"

⚠️ COMMON CONFLICT & SOLUTION:

Conflict #1: "PPIC planning-nya tidak realistis!"
PPIC: "Minggu ini produksi 50k!"
Production: "Kapasitas cuma 40k! Dari mana 50k?!"

Solution:

Capacity Model yang jelas: 1 shift = 5k/hari, 2 shift = 9k/hari (ada setup time!), 3 shift = max 12k/hari
PPIC & Production co-create MPS (bukan PPIC bikin sendiri!)
Weekly capacity review meeting

Conflict #2: "Production tidak follow schedule!"
MPS bilang: Senin item A, Selasa item B
Production actual: Senin item A, Selasa masih item A (karena setup lama!)

Solution:

PPIC consider realistic setup time (jangan assume instant changeover!)
Batching strategy (produksi item yang sama beberapa hari untuk minimize setup)
KPI Production: Schedule Adherence (target 95%)

3. PPIC ↔ PROCUREMENT / PURCHASING

📌 Interaction Pattern:

DARI PPIC KE PROCUREMENT:

PR (Purchase Requisition): "Butuh material X qty 10k, required date 15 Mei"
Urgent Expedite Request: "PO-123 harusnya datang hari ini, tapi belum! Tolong follow up supplier!"
Forecast Sharing: "Next 3 months forecast material Y: Mei 50k, Juni 60k, Juli 55k. Untuk nego contract supplier"
Quality Issue: "Batch kemarin reject rate 10%! Tolong koordinasi dengan supplier untuk improvement"

DARI PROCUREMENT KE PPIC:

PO Status Update: "PO-123 sudah release, ETA 14 Mei"
Delay Warning: "Supplier inform delay 3 hari, ETA revise jadi 17 Mei"
PR Clarification: "PR-456 qty 10k, tapi MOQ supplier 15k. Approve order 15k?"
Price Negotiation Impact: "Supplier kasih diskon 5% kalau order 20k. Worth it?"

⚠️ COMMON CONFLICT & SOLUTION:

Conflict #1: "Procurement lambat process PR!"
PPIC submit PR hari ini, required date 10 hari lagi
Procurement baru process 5 hari kemudian → Delay!

Solution:

SLA PR Processing: Critical item = 1 hari, Normal = 2 hari, Bulk order = 3 hari
Auto-notification jika PR overdue
Priority flagging di sistem (Urgent/High/Normal)

Conflict #2: "PPIC sering minta expedite!"
Procurement: "Kenapa planning PPIC selalu mepet? Kami tidak punya magic!"

Solution:

PPIC review lead time accuracy (jangan assume semua supplier 7 hari!)
Supplier performance tracking (actual lead time vs promised)
Safety buffer untuk critical materials

4. PPIC ↔ WAREHOUSE / LOGISTICS

📌 Interaction Pattern:

DARI PPIC KE WAREHOUSE:

Stock Query (Hourly!): "Berapa stock item A sekarang? System bilang 500, actual berapa?"
Cycle Count Request: "Tolong cycle count item B, ada discrepancy 10%"
GI Request for Production: "Produksi besok butuh material X 5k unit, tolong siapkan di staging area"
Space Planning: "Bulan depan produksi naik 20%, warehouse cukup?"

DARI WAREHOUSE KE PPIC:

GR Confirmation: "Material Y sudah diterima 10k unit, sudah di-posting ke sistem"
Stock Discrepancy Report: "Stock opname: System 1000, Actual 950. Selisih -50 unit"
Space Alert: "Warehouse kapasitas 85%, kalau produksi tambah lagi, over capacity!"
Slow Moving Alert: "Item Z sudah 6 bulan tidak ada movement, makan space. Rencana?"

⚠️ COMMON CONFLICT & SOLUTION:

Conflict #1: "Discrepancy terus antara system vs physical!"
Warehouse: "Stock fisik cuma 900, tapi sistem 1000!"
PPIC: "Lah terus produksi besok butuh 1000, dari mana?!"

Solution:

Daily cycle count untuk fast-moving items
Mandatory barcode scan untuk semua transaction
Root cause analysis setiap discrepancy >2%
Punishment & reward untuk warehouse accuracy

Conflict #2: "Warehouse penuh, tidak bisa terima barang!"
Procurement: "Material sudah datang 20 truk!"
Warehouse: "Penuh! Tidak bisa terima!"
PPIC: (pusing di tengah-tengah...)

Solution:

PPIC space planning 1-2 bulan ahead (forecast inventory level)
Coordinate dengan Finance untuk turunkan DOI target jika perlu
Promo untuk clear slow-moving items
Rental temporary warehouse jika urgent

5. PPIC ↔ FINANCE

📌 Interaction Pattern:

DARI PPIC KE FINANCE:

Monthly Inventory Report: "Inventory value: Rp 15 M, DOI: 48 hari, ITO: 7.5x"
Budget Request: "Untuk achieve production target, butuh tambahan RM budget Rp 2 M"
Variance Explanation: "DOI naik dari 45 → 50 hari karena over-order di promo (forecast meleset)"

DARI FINANCE KE PPIC:

DOI Target: "Target DOI 45 hari, sekarang 50. Tolong turunkan!"
Inventory Budget: "Max inventory value Rp 20 M. Jangan exceed!"
COGS Query: "COGS produk A berapa? Untuk pricing review"

⚠️ COMMON CONFLICT & SOLUTION:

Conflict: "Finance minta turunkan inventory, tapi Sales minta stock!"
Finance: "DOI 50 hari terlalu tinggi! Target 40 hari!"
Sales: "Kalau stock kurang, customer komplain! Service level turun!"
PPIC: (di tengah-tengah, bingung!)

Solution:

Balanced KPI: DOI target 45 hari + Service Level target 95% (balance cost vs service!)
ABC strategy: A items (high value) = tight inventory, C items = bisa stock lebih banyak
Improve forecast accuracy (DOI turun natural karena inventory lebih optimal!)

                🎯 KESIMPULAN - Integrasi Departemen:

                PPIC = Central Hub yang interact dengan SEMUA departemen!

                Key Success Factors:

                Communication: Jelas, data-driven, solution-focused (bukan blame game!)
SLA & KPI: Defined & tracked (bukan feeling-based!)
Technology: Integrated ERP (no manual email ping-pong!)
Collaboration: Win-win mindset (satu tim, bukan silo!)
Escalation: Clear procedure jika deadlock (don't stuck forever!)

                Conflict is NORMAL! Yang penting: How to resolve constructively! 💪

📍 PPIC dalam SCOR Model

Supply Chain Operations Reference - Framework Global untuk Supply Chain Excellence

Apa itu SCOR Model?

SCOR (Supply Chain Operations Reference) adalah framework standar industri yang dikembangkan oleh APICS (Association for Supply Chain Management) sejak tahun 1996.

SCOR menstandarisasi proses supply chain menjadi 6 proses utama yang universal untuk semua industri, termasuk manufaktur lantai kayu dan decking.

Referensi: APICS SCOR Model 12.0 (2017) - Supply Chain Council

            🌍 Kenapa SCOR penting untuk Manufaktur Kayu?

            Framework GLOBAL yang dipakai perusahaan flooring internasional (Armstrong, Mohawk, Pergo)
Bahasa standar untuk supply chain - memudahkan kolaborasi dengan supplier kayu global
Best practice benchmark industri woodworking
Foundation untuk digital transformation & Industry 4.0
Membantu trace sustainability (FSC/PEFC certification tracking)

        

6 Proses Utama SCOR Model

📌 SCOR Framework Overview:

SCOR 6 PROCESSES (Model 12.0):

1. PLAN (sP) - Merencanakan seluruh supply chain
   └─ Demand/Supply planning, S&OP, Inventory planning

2. SOURCE (sS) - Procurement bahan baku & komponen  
   └─ Supplier management, purchasing, quality inspection

3. MAKE (sM) - Proses produksi/manufacturing
   └─ Production scheduling, manufacturing execution, quality control

4. DELIVER (sD) - Distribusi ke customer
   └─ Order management, warehouse, transportation, installation

5. RETURN (sR) - Proses pengembalian/reverse logistics
   └─ Defect return, excess material, recycling

6. ENABLE (sE) - Proses pendukung
   └─ IT, HR, Finance, Compliance, Sustainability reporting

PPIC dalam Setiap Proses SCOR - Konteks Pabrik Lantai Kayu

📌 PROSES 1: PLAN (sP) - PPIC sebagai LEADER!

sP1: Plan Supply Chain (Strategic Planning)
Peran PPIC di Pabrik Lantai Kayu:

Demand Planning: Forecast kebutuhan lantai kayu per tipe (Solid Wood Flooring, Engineered Wood, Decking) berdasarkan seasonality
Supply Planning: Kapasitas produksi sawmill, drying kiln, machining, finishing per bulan
Inventory Strategy: Buffer stock log kayu (min 3 bulan karena lead time panjang!), WIP, finish goods

Contoh Real - PT Kayu Jati Indah (Produsen Decking Jati):

Annual demand forecast: 50,000 m2 decking jati
Raw material requirement: 2,500 m3 log jati (asumsi yield 60% setelah sawing, drying, machining)
Lead time procurement log jati dari Perhutani: 2-3 bulan
Safety stock: 800 m3 log (untuk 3 bulan produksi)

sP2: Plan Source (Material Requirement Planning)
Peran PPIC:

Run MRP untuk calculate kebutuhan log kayu, bahan finishing (oil, lacquer), packaging
Coordinate dengan Procurement untuk kontrak tahunan supplier kayu
Monitor FSC/PEFC certification compliance (sustainable forestry)

BOM Example - Decking Jati 19mm x 140mm x 1200mm:

Material	Qty per m2	Lead Time	Supplier
Log Jati Grade A	0.05 m3	60-90 hari	Perhutani / Import Myanmar
Teak Oil (Finishing)	0.12 liter	14 hari	Supplier Lokal
Sandpaper (Consumable)	0.02 lembar	7 hari	Supplier Lokal
Packaging Karton	0.15 pcs	7 hari	Supplier Lokal

sP3: Plan Make (Production Planning)
Peran PPIC:

Create MPS (Master Production Schedule) considering multi-stage process
Capacity planning per work center: Sawmill → Kiln Drying → Machining → Finishing → QC → Packaging
Balance production load (avoid bottleneck di kiln drying yang limited capacity!)

Production Lead Time Breakdown:

Sawmill (log → rough lumber): 1 hari
Kiln Drying (MC 60% → 12%): 21-30 hari (BOTTLENECK!)
Machining (rough → S4S, tongue & groove): 2 hari
Finishing (sanding, oiling/lacquer): 3 hari
QC & Packaging: 1 hari
Total Production Lead Time: 28-37 hari

sP4: Plan Deliver (Distribution Planning)
Peran PPIC:

Coordinate dengan Sales untuk delivery schedule (kontainer export vs domestic)
Plan packaging requirement (kontainer 20ft muat berapa m2?)
Reserve warehouse space untuk finish goods sebelum shipment

sP5: Plan Return (Reverse Logistics Planning)
Peran PPIC:

Reserve capacity untuk rework defective products (re-sanding, re-finishing)
Plan waste utilization (sawdust → briket, offcut → furniture kecil)
Sustainability reporting (berapa % waste yang di-recycle?)

📌 PROSES 2: SOURCE (sS) - PPIC sebagai KEY INPUT PROVIDER

sS1: Source Stocked Product (Material Procurement)
Peran PPIC:

Generate PR (Purchase Requisition) dari MRP output
Provide forecast ke Procurement untuk long-term kontrak log kayu
Monitor PO delivery status (critical karena lead time log panjang!)

Challenge Khusus Industri Kayu:

Seasonality supply: Musim hujan → akses hutan sulit → supply log terbatas
Quality variance: Log kayu tidak uniform (ada mata kayu, retak, busuk) → yield variance 50-70%
Price fluctuation: Harga log jati bisa naik 20-30% dalam 6 bulan
Certification requirement: FSC/PEFC → limited supplier, premium price

sS2: Source Make-to-Order Product
Peran PPIC (untuk custom order):

Special wood species request (Merbau, Bangkirai, Oak import)
Custom dimension di luar standard
Lead time communication ke customer (realistic timeline!)

sS3: Source Engineer-to-Order Product
Peran PPIC:

Collaborate dengan R&D untuk new product development (contoh: WPC Wood Plastic Composite decking)
Trial production planning & material procurement untuk prototype

📌 PROSES 3: MAKE (sM) - PPIC sebagai PRODUCTION CONTROLLER

sM1: Make-to-Stock (Standard Production)
Peran PPIC di Multi-Stage Wood Processing:

Stage 1 - Sawmill: Schedule log cutting, optimize cutting pattern untuk minimize waste
Stage 2 - Kiln Drying: Schedule kiln loading (FIFO, tapi group by thickness untuk uniform drying!), monitor MC (Moisture Content)
Stage 3 - Machining: CNC setup untuk different profiles (tongue & groove, smooth edge, anti-slip grooves untuk decking)
Stage 4 - Finishing: Schedule finishing type (natural oil, UV lacquer, stain + topcoat)
Stage 5 - QC & Grading: Sorting by grade (Premium, Standard, Economy based on defect)

Production Control Metrics:

Stage	KPI	Target	PPIC Action if Below Target
Sawmill	Yield %	65%	Review cutting pattern, operator training
Kiln Drying	MC Achievement (12% ± 2%)	95%	Adjust drying schedule, check kiln condition
Machining	Defect Rate	< 5%	Tool maintenance, CNC calibration
Finishing	Coverage Rate (m2/liter)	8-10 m2/L	Adjust spray parameter, check oil quality
Overall	OEE	75%	Root cause analysis, improvement plan

sM2: Make-to-Order (Custom Production)
Peran PPIC:

Prioritize custom order vs stock production
Special setup untuk non-standard dimension (contoh: decking lebar 200mm instead of standard 140mm)
Track WIP untuk each customer order (avoid mix-up!)

Challenge Unik Produksi Kayu:

Material variance: Tidak ada 2 log yang identik → yield unpredictable
Kiln drying bottleneck: Limited kiln capacity, long cycle time (21-30 hari)
Seasonality impact: Wood lebih mudah di-machining saat MC optimal, quality finishing better di low humidity season
Color matching: Susah match color antara batch (natural wood variation!)

📌 PROSES 4: DELIVER (sD) - PPIC sebagai COORDINATOR

sD1: Deliver Stocked Product
Peran PPIC:

Confirm stock availability untuk sales order
Coordinate warehouse untuk picking & packing (hati-hati! Lantai kayu mudah scratch, butuh protective packaging)
Plan loading untuk kontainer export (optimize space utilization)

Packaging Consideration - Lantai Kayu Export:

Bundle dengan plastic wrap (protect dari moisture)
Pallet fumigasi (ISPM 15 compliance untuk export)
Label FSC/PEFC certificate number
Kontainer 20ft standard: 1,200 - 1,500 m2 decking (tergantung thickness)

sD2: Deliver Make-to-Order Product
Peran PPIC:

Real-time update ke customer tentang production progress
Quality check sebelum delivery (customer biasanya strict untuk custom order!)
Coordinate installation schedule jika include installation service

sD3: Deliver Engineer-to-Order Product
Peran PPIC:

Delivery new product sample untuk customer approval
Technical documentation (installation guide, maintenance manual)

📌 PROSES 5: RETURN (sR) - PPIC sebagai WASTE OPTIMIZER

sR1: Return Defective Product
Peran PPIC:

Reserve capacity untuk rework (re-sanding, re-finishing)
Downgrade system: Premium reject → jadi Standard grade → jadi Economy grade
Track defect rate by production batch (root cause analysis)

Defect Category - Lantai Kayu:

Surface defect: Scratch, dent, rough surface → Rework: Re-sanding + re-finishing
Dimension tolerance: Thickness ±0.5mm, width ±1mm → Rework: Re-machining (jika masih memungkinkan)
Moisture Content: MC > 14% → Rework: Re-drying (back to kiln!)
Structural defect: Crack, severe warp → Downgrade atau Scrap

sR2: Return MRO (Maintenance, Repair, Operating) Product
Peran PPIC:

Return unused material ke supplier (contoh: over-order log, bisa arrange sell-back)
Return defective consumable (sandpaper, blade saw yang tidak sesuai spec)

sR3: Return Excess Product (Circular Economy!)
Peran PPIC dalam Sustainability:

Sawdust utilization: Jual ke pabrik briket, pupuk kompos (revenue stream!)
Offcut utilization: Buat produk smaller (flooring tile 30x30cm, wall panel, garden edging)
Bark & low-grade wood: Boiler fuel untuk kiln heating (reduce energy cost!)
Sanding dust: Cat filler, animal bedding

Waste Utilization Target (Best Practice):

Zero waste to landfill
Min 80% waste utilization (revenue generating or cost saving)
Carbon footprint reporting (sustainability certification requirement)

📌 PROSES 6: ENABLE (sE) - PPIC sebagai STAKEHOLDER

sE1: Enable Plan
Peran PPIC:

Collaborate dengan IT untuk ERP/MRP system implementation
Define data master (BOM accuracy, lead time, capacity model)
KPI dashboard development

sE2: Enable Source
Peran PPIC:

Supplier performance evaluation (lead time accuracy, quality, price)
Vendor certification audit support (FSC/PEFC chain of custody)

sE3: Enable Make
Peran PPIC:

Collaborate dengan HRD untuk manpower planning (seasonal hiring untuk peak season)
Training coordination (operator skill upgrade untuk new machinery)
Health & Safety compliance (dust control, noise protection di sawmill & machining)

sE4: Enable Deliver
Peran PPIC:

Warehouse layout optimization (FIFO implementation, prevent moisture exposure)
Transportation compliance (fumigation certificate untuk export)

sE5: Enable Return
Peran PPIC:

Reverse logistics SOP (customer complaint handling, warranty claim process)
Sustainability reporting (waste to revenue tracking)

SCOR Metrics untuk PPIC - Lantai Kayu Industry

SCOR mendefinisikan 5 Performance Attributes (Level 1 Metrics):

Referensi: APICS SCOR Model - Performance Measurement Framework

📊 SCOR LEVEL 1 METRICS - Lantai Kayu Manufacturing:

Performance Attribute	Metric	Formula	Industry Benchmark	Peran PPIC
RELIABILITY (Customer-facing)	Perfect Order Fulfillment	(Orders delivered complete, on-time, damage-free, with correct docs) / Total orders	92-96%	Ensure MPS accuracy, quality control
RELIABILITY (Customer-facing)	Order Fulfillment Cycle Time	Order receipt → Delivery	35-45 hari (include drying time!)	Optimize production lead time, expedite when needed
RESPONSIVENESS (Customer-facing)	Upside Supply Chain Flexibility	Max sustainable % increase dalam 30 hari	15-20%	Maintain WIP buffer, overtime capacity planning
RESPONSIVENESS (Customer-facing)	Downside Supply Chain Adaptability	% reduction tanpa penalty cost dalam 30 hari	20-25%	Flexible MPS, adjust raw material order
AGILITY (Customer-facing)	Upside Flexibility	Days to achieve 20% increase	60-90 hari (constraint: drying time!)	Long-term capacity planning, kiln expansion
	Downside Adaptability	Days to achieve 20% reduction	30-45 hari	MPS adjustment, workforce flexibility
	Overall Value at Risk	Probability x Impact of supply disruption	< 5% revenue impact	Risk mitigation plan (multi-source log supplier)
COST (Internal-facing)	Total Supply Chain Cost	Plan + Source + Make + Deliver + Return cost	55-65% of revenue	Optimize inventory level, reduce waste
	Cost of Goods Sold	Material + Labor + Overhead	40-50% of revenue	Yield optimization, efficient scheduling
	Days Inventory Outstanding	(Avg Inventory / COGS) x 365	90-120 hari (tinggi karena drying time!)	Balance WIP inventory (dry vs wet lumber)
ASSET EFFICIENCY (Internal-facing)	Cash-to-Cash Cycle Time	DIO + DSO - DPO	60-90 hari	Reduce DIO through better planning
ASSET EFFICIENCY (Internal-facing)	Return on Supply Chain Fixed Assets	Revenue / (Equipment + Facility value)	2.5-3.5x	Maximize kiln & machinery utilization

⚠️ Challenge Khusus Lantai Kayu - Impact ke SCOR Metrics:

Long drying time (21-30 hari):
- Impact: DOI tinggi (90-120 hari vs industri lain 30-60 hari)
- Impact: Order fulfillment cycle time panjang (35-45 hari)
- PPIC Mitigation: Maintain dried lumber buffer stock, forecast-driven drying schedule
Material yield variance (50-70%):
- Impact: Unpredictable production output, sulit achieve perfect order
- PPIC Mitigation: Conservative MPS planning, safety stock policy
Seasonality (musim hujan vs kemarau):
- Impact: Supply chain flexibility terbatas di peak rainy season
- PPIC Mitigation: Build inventory di dry season, multi-source supplier strategy

        🎯 KESIMPULAN - PPIC dalam SCOR Model:

        PPIC adalah KEY PLAYER di 4 dari 6 proses SCOR:

        PLAN: PPIC LEAD semua sub-proses (sP1-sP5) - Demand/Supply/Production/Delivery/Return planning
SOURCE: PPIC provide MRP output, monitor PO delivery
MAKE: PPIC control production execution, monitor KPI (OEE, yield, quality)
DELIVER: PPIC coordinate stock availability, delivery schedule

        Untuk Industri Lantai Kayu, PPIC harus EXTRA aware tentang:

        Kiln drying bottleneck management (biggest constraint!)
Yield variance mitigation (tidak seperti metal/plastic yang predictable!)
Seasonality planning (musim hujan = supply risk!)
Sustainability tracking (FSC/PEFC compliance, waste utilization)
Quality grading system (Premium vs Standard vs Economy)

        SCOR Framework membantu PPIC untuk:

        Standardize process & metrics (benchmark dengan competitor global)
Identify improvement opportunity (gap analysis vs best practice)
Facilitate communication (common language dengan supplier & customer internasional)

1.6 PPIC Challenges & Solutions dalam Industri Lantai Kayu & Decking

Mengatasi tantangan unik industri wood flooring melalui strategi PPIC yang efektif

A. Unique Challenges dalam Wood Flooring Manufacturing

1. Long Lead Time dari Kiln Drying Process

📊 Drying Time Benchmark:

4/4 Oak (1 inch): 28-30 hari kiln drying
4/4 Poplar/Pine: 10-14 hari kiln drying
8/4 - 12/4 (thick lumber): Considerably longer + air drying first
Decking (Ipe, exotic species): Air-dried to ~18% MC, atau kiln-dried to 10-14% MC

Reference: Bailey Wood Products kiln drying guidelines; Robi Decking moisture content standards (2025)

⚠️ PPIC Impact dari Long Drying Time:

High Work-in-Process (WIP) Inventory:
- Material "terperangkap" di kiln selama 21-30 hari
- DOI (Days Inventory Outstanding) bisa mencapai 90-120 hari vs 30-60 hari di industri lain
- Cash flow terikat di inventory → butuh working capital lebih besar
Inflexible Production Capacity:
- Tidak bisa sudden ramp-up production (constraint = kiln capacity)
- Upside flexibility terbatas → jika dapat rush order, kiln sudah full!
- Agility metric: 60-90 hari untuk achieve 20% capacity increase (vs 30 hari di industri lain)
Forecast Dependency:
- Harus mulai drying process 1-2 bulan SEBELUM order diperlukan
- Salah forecast → material kering numpuk (overstock) atau shortage (understock)
- Seasonality impact: musim hujan = slow drying, musim kemarau = faster drying

            ✅ PPIC Solutions untuk Kiln Drying Constraint:


            Maintain Dried Lumber Buffer Stock (Safety Stock Strategy):
                    Keep 15-20% dari monthly demand dalam bentuk dried lumber ready to mill
Formula: Safety Stock = (Lead Time Variance × Demand Average) + (Demand Variance × Lead Time Average)
Example: Jika avg demand 10,000 bd.ft/month, kiln time 30 hari → buffer 1,500-2,000 bd.ft dried oak

                
Forecast-Driven Drying Schedule (Rolling 3-Month Forecast):
                    Jadwalkan kiln loading berdasarkan forecast 3 bulan ke depan (bukan react ke order saat ini!)
Gunakan S&OP process: Sales forecast → PPIC translate ke drying schedule → Procurement adjust log purchase
Review forecast accuracy monthly → adjust buffer stock level accordingly

                
Kiln Capacity Planning & Utilization Optimization:
                    Track kiln utilization rate (target: 85-90% untuk balance efficiency vs flexibility)
Mix fast-drying species (Poplar 10-14 hari) dengan slow-drying species (Oak 28-30 hari) untuk optimize throughput
Consider investment: Additional kiln capacity jika bottleneck terus terjadi (ROI analysis!)
Alternative: Partnership dengan toll-drying service untuk peak season overflow

                
Pre-Drying & Hybrid Drying Strategy:
                    Air-dry thick lumber (8/4 - 12/4) under shade tarps → remove free water SEBELUM masuk kiln
Rule of thumb: 1 inch thickness = 12 months air drying → hybrid approach reduce total time
Example: 8/4 oak → air-dry 3 bulan (50% to 25% MC) → kiln-dry 30 hari (25% to 6-8% MC)

                

        

2. Material Yield Variance & Natural Defects

📊 Typical Yield dalam Wood Processing:

Log to lumber (sawing): 50-60% yield (40-50% sawdust, bark, slabs)
Lumber to finished flooring (after grading, defect removal): 70-85% yield
Overall log to finished product: 35-50% yield (sangat jauh dari metal/plastic yang 80-90%!)
Defect types: Knots, splits, warp, cupping, checking, stain, insect damage, rot

Reference: Wood flooring industry analysis - IBISWorld (2024); NWFA quality standards

⚠️ PPIC Impact dari Yield Variance:

Unpredictable Production Output:
- Input 10,000 bd.ft log ≠ Output 10,000 bd.ft finished flooring (bisa jadi hanya 3,500-5,000 bd.ft!)
- Sulit untuk accurate MPS planning → sering kekurangan atau kelebihan material
- Quality grading unpredictable: rasio Premium vs Standard vs Economy bervariasi per batch
Perfect Order Fulfillment Risk:
- Customer order 5,000 sq.ft Premium grade → setelah production ternyata hanya dapat 4,200 sq.ft Premium
- Impact ke SCOR metric: Perfect Order % turun → customer complaint meningkat
Waste Management Challenge:
- 40-50% material jadi waste (sawdust, offcuts, defect pieces) → perlu waste utilization strategy
- Environmental compliance: FSC/PEFC sustainability certification requirement

            ✅ PPIC Solutions untuk Yield Variance:


            Conservative MPS Planning dengan Yield Factor:
                    Gunakan historical yield data untuk calculate material requirement
Formula: Gross Material Required = (Net Finished Goods / Historical Yield %)
Example: Order 5,000 bd.ft finished flooring, avg yield 45% → order 11,111 bd.ft log
Build in 10-15% safety margin untuk account yield variance antar batch

                
Grade-Based Inventory Tracking:
                    Track inventory BUKAN hanya by total board feet, tapi by grade (Premium / Standard / Economy)
Reason: Customer order specific grade → PPIC harus tahu stock availability per grade
ERP system setup: Separate SKU untuk setiap species + grade combination
Example SKU structure: "OAK-FLOOR-3.25IN-PREMIUM" vs "OAK-FLOOR-3.25IN-STANDARD"

                
Real-Time Yield Monitoring & Adjustment:
                    Daily production reporting: Input bd.ft vs Output bd.ft per grade → calculate actual yield
If yield drop below expected → immediate MPS adjustment (order more logs OR delay shipment)
Root cause analysis: Apakah low yield karena supplier issue, operator skill, atau equipment problem?

                
Waste Utilization Strategy (Circular Economy Approach):
                    Sawdust & chips → sell to biomass/pellet industry (revenue stream!)
Offcuts & defect pieces → use for shorter decking boards, samples, atau furniture parts
Reference: Lean & 6R integration for wood waste reduction (Materials Science & Engineering, 2021)
FSC/PEFC compliance: Document waste utilization untuk sustainability audit

                

        

3. Seasonality & Supply Chain Disruption

📊 Seasonality Impact dalam Wood Industry:

Musim Hujan (Nov-Mar):
- Log supply risk: Logging operation terhambat, transportation sulit (jalan rusak)
- Drying time lebih lama: High ambient humidity → kiln efficiency turun 15-20%
- Quality risk: Higher risk of stain, mold, decay jika log storage terlalu lama
Musim Kemarau (Apr-Oct):
- Optimal logging & drying season: Faster drying, better quality
- Demand spike: Construction activity peak → pressure on supply chain
Global Disruption (Baltic Birch Example):
- Ukraine war 2022 → 50% tariff on Russian Baltic birch plywood
- Engineered flooring manufacturers scramble for alternative core materials
- Impact: Price volatility, lead time extension, supplier diversification urgent

Reference: WFB State of the Wood Flooring Industry (2023); Wood Floor Business survey

⚠️ PPIC Impact dari Seasonality:

Supply Chain Flexibility Terbatas:
- Upside flexibility di peak rainy season sangat sulit (log supply constraint!)
- Downside adaptability juga risky: Cancel PO ke logger → next season mereka prioritize competitor
- SCOR metric challenge: Responsiveness score rendah di Q4-Q1
Inventory Holding Cost vs Stockout Risk:
- Build inventory di dry season → high holding cost (warehouse space, working capital, deterioration risk)
- Tidak build inventory → stockout risk di rainy season (customer complaint, lost sales)
Price Volatility:
- Log price spike di rainy season (scarcity premium) → margin pressure
- Customer contracts (fixed price) → squeezed margin jika material cost naik

            ✅ PPIC Solutions untuk Seasonality:


            Seasonal Inventory Build Strategy:
                    Build log & dried lumber inventory di dry season (Apr-Oct) untuk cover rainy season demand (Nov-Mar)
Target: 2-3 months safety stock sebelum rainy season start
Cost-benefit analysis: Inventory holding cost vs potential stockout cost + premium price
Example calculation: Holding cost 2%/month × 3 months = 6% vs rainy season price premium 15-20% → profitable to build stock!

                
Multi-Source Supplier Strategy (Risk Mitigation):
                    Diversify supplier base: Jangan depend pada 1-2 log suppliers saja
Geographic diversification: Source dari region berbeda (e.g., North vs South, domestic vs import)
Long-term partnership: Secure allocation agreements dengan key suppliers (guaranteed supply di peak season)
Reference: Baltic birch crisis lesson → companies yang multi-source survive better

                
Flexible Pricing & Contract Structure:
                    Price escalation clause dalam customer contracts → mitigate material cost volatility risk
Example: "Price subject to adjustment if raw material cost increase >10% from base period"
Alternative: Seasonal pricing strategy → lower price di dry season, premium di rainy season

                
S&OP Process dengan Seasonality Consideration:
                    Quarterly S&OP meeting: Sales forecast + Seasonality pattern → Production plan + Inventory target
Scenario planning: Best case / Base case / Worst case untuk each season
Example: Worst case rainy season = log supply delay 2 weeks → need extra 10% buffer stock

                

        

B. Implementing Lean Manufacturing dalam Wood Flooring

1. Why Lean Matters untuk Wood Industry

📊 Lean Manufacturing Benefits dalam Wood Industry:

Waste reduction: 80% reduction (sawdust, offcuts, defects)
Cycle time: 50% reduction dalam manufacturing lead time
Capacity improvement: 50% increase tanpa capital investment
Product quality: 50% improvement (less defects, rework)
Inventory: 80% reduction dalam WIP dan finished goods

Reference: Kotelnikov (2001); Virginia Tech Lean Thinking publication (2024)

🏭 Real Example - Merillat Industries (Best Practice):

Merillat Industries Door and Panel Plant (Atkins, Virginia) adalah most successful wood products company dalam Lean implementation:

Implemented full Lean Manufacturing system across all operations
Result: Significant cost savings, improved quality, faster delivery
Tools used: 5S, Value Stream Mapping, Kaizen events, Visual management
Became benchmark untuk wood industry di North America

Reference: Status of lean manufacturing in secondary wood industries (BioResources, 2009)

2. The 8 Wastes (TIMWOODS) dalam Wood Flooring Context

Waste Type	Contoh dalam Wood Flooring	PPIC Countermeasures
Transportation	• Material handling berkali-kali: Log yard → Sawmill → Kiln → Milling → Packaging → Warehouse • Unnecessary forklift movement antar workstations • Offcuts transported to waste area kemudian ke biomass processor	• Layout optimization: One-piece flow design (log → finished goods dalam satu line) • Cellular manufacturing: Group machines by product family • Minimize handling: Direct kiln-to-mill transfer (skip intermediate storage)
Inventory	• Excess log inventory (more than 2-3 months) • WIP stuck di kiln terlalu lama • Finished goods numpuk (wrong species/grade mix) • Obsolete inventory (old stock, unfashionable species)	• JIT purchasing: Order logs based on actual demand (bukan speculation!) • Pull system: Kiln loading triggered by milling demand • Kanban system untuk control WIP level • ABC analysis: Focus on fast-moving SKUs (80/20 rule)
Motion	• Operator walking jauh untuk ambil tools, materials • Excessive bending, reaching untuk load/unload kiln • Manual sorting of boards by grade (repetitive motion) • Unnecessary adjustment of machinery setup	• 5S implementation: Tools & materials organized at point of use • Ergonomic workstation design (reduce bending, reaching) • Automation: Auto-grading system using laser scanner/vision system • Standard work procedures: Optimize motion sequence
Waiting	• Operators waiting untuk kiln loading/unloading • Milling machine idle karena menunggu dried lumber • QC inspector waiting untuk batch completion • Truck waiting untuk loading finished goods	• Heijunka (level loading): Balance kiln schedule untuk smooth flow • TPM (Total Productive Maintenance): Reduce equipment downtime • Cross-training: Operators can do multiple tasks (fill waiting time) • Scheduled delivery window: Coordinate truck arrival dengan production completion
Overproduction	• Producing more flooring than customer orders (speculation) • Making Premium grade when customer needs Standard • Large batch production (economies of scale thinking) • Building inventory "just in case" tanpa forecast basis	• Takt time production: Produce at rate of customer demand • Make-to-order strategy (untuk custom species/sizes) • Small batch production: Reduce batch size, increase frequency • Demand-driven MPS: Base production on actual forecast, bukan assumption
Overprocessing	• Sanding boards lebih halus dari customer spec (overkill!) • Applying 5 coats finish when 3 coats sudah cukup • Excessive quality inspection (checking same thing multiple times) • Using premium material untuk non-premium product	• Customer spec analysis: Understand TRUE requirement (bukan assumption) • Process capability study: Know when "good enough" is actually good enough • Quality at source: Build quality in process (bukan inspect after) • Value engineering: Match material grade to product requirement
Defects	• Warped boards from improper drying (kiln schedule error) • Surface checking, splits dari too-fast drying • Milling defects: Chipped edges, rough surface • Stain, discoloration dari poor handling/storage	• Poka-yoke (error-proofing): Sensors detect moisture before milling • SPC (Statistical Process Control) untuk kiln monitoring • Jidoka (automation with human touch): Machine auto-stop jika defect detected • Root cause analysis (5 Whys, Fishbone) untuk prevent recurrence
Skills (Non-utilized talent)	• Experienced operators stuck on repetitive tasks • Kiln operator tidak involved dalam schedule optimization • QC inspector ideas untuk improvement tidak didengar • Maintenance team tidak consulted dalam equipment purchase decision	• Kaizen events: Employee-driven improvement projects • Suggestion system: Reward employees untuk improvement ideas • Cross-functional teams: PPIC + Production + Maintenance collaborate • Empowerment: Give operators authority untuk stop line jika problem detected

3. Key Lean Tools untuk Wood Flooring PPIC

A. Value Stream Mapping (VSM) - Paling Penting!

Purpose: Visualize entire production flow dari log receipt sampai finished goods shipment → identify waste & improvement opportunity

Typical Wood Flooring VSM Components:

Process boxes: Log receiving → Sawing → Air drying → Kiln drying → Milling → Finishing → Grading → Packaging → Shipping
Data boxes (untuk each process):
- C/T (Cycle Time): Time untuk process 1 unit
- C/O (Changeover Time): Time untuk switch species/size
- Uptime %: Equipment availability
- Batch size: Jumlah unit per batch
- Operator count: Number of workers
Inventory triangles: WIP between each process (e.g., 50,000 bd.ft log, 30,000 bd.ft di kiln, 15,000 bd.ft finished)
Timeline: Value-added time vs Non-value-added time (typically 5% VA vs 95% NVA!)

How PPIC Uses VSM:

Current State VSM: Map existing flow → calculate total lead time, identify bottlenecks
Gap Analysis: Compare dengan customer demand (Takt time) → find improvement areas
Future State VSM: Design ideal flow → eliminate waste, reduce lead time
Implementation Plan: Create action items dengan timeline & responsibilities

Example Insight dari VSM:

Total lead time 45 hari, tapi value-added time hanya 2 hari (kiln drying 21 hari adalah necessary NVA, sisanya pure waste!)
Bottleneck: Kiln capacity (utilization 95%, sering queue) → prioritize kiln expansion investment
Excess inventory: 3 months log stock → reduce to 6 weeks based on supplier reliability

Reference: Lean in wood furniture industry case studies (ISSSP, 2021); VSM & 6R integration research (Materials Science & Engineering, 2021)

B. 5S Workplace Organization (Foundation Tool)

Survey Finding: 73.3% of wood companies implementing Lean start dengan 5S (highest adoption rate!)

5S dalam Wood Flooring Context:

5S Step	Japanese Term	Wood Flooring Application
SORT	Seiri (整理)	• Remove unnecessary tools, equipment dari work area • Dispose obsolete inventory (old stock, damaged material) • Keep only current production materials on shop floor
SET IN ORDER	Seiton (整頓)	• Designated locations untuk each tool (shadow boards, labeled bins) • Visual management: Color-coded species (Oak = Blue, Maple = Yellow) • FIFO lanes untuk dried lumber (first in, first out to prevent aging)
SHINE	Seiso (清掃)	• Daily cleaning schedule (sawdust removal critical!) • Equipment inspection during cleaning (detect issues early) • Maintain kiln vents, fans (prevent inefficiency)
STANDARDIZE	Seiketsu (清潔)	• Standard work procedures (SOP) untuk each process • Checklists untuk kiln loading, QC inspection • Visual standards (photo examples of acceptable vs reject boards)
SUSTAIN	Shitsuke (躾)	• Audit system (monthly 5S scores per area) • Recognition program (best 5S area gets reward) • Training untuk new employees (5S as onboarding requirement)

Reference: Wood Component Manufacturing Association survey - 73.3% usage rate (BioResources, 2009)

C. SMED (Single-Minute Exchange of Dies) - Reduce Changeover Time

Context: Wood flooring production often requires changeover antar species, widths, atau grades → time consuming!

Typical Changeover Scenario:

Milling line switch dari Oak 3.25" width → Maple 5" width
Activities: Stop machine → Adjust blade spacing → Change feed rollers → Adjust sander head → Test run → Resume production
Before SMED: 45-60 menit changeover time (expensive downtime!)
After SMED: 10-15 menit changeover time (reduce by 75%)

SMED Implementation Steps:

Separate Internal vs External activities:
- Internal: MUST be done saat machine stopped (e.g., adjust blade)
- External: CAN be done saat machine running (e.g., prepare next batch material)
Convert Internal to External:
- Pre-set adjustments outside machine → install as module (quick-change system)
- Example: Pre-adjusted blade cartridges → swap in 5 minutes vs adjust in 30 minutes
Streamline Internal activities:
- Eliminate unnecessary steps (e.g., remove bolts → use quick-clamps)
- Standardize procedures (checklist → prevent forgotten steps)
Streamline External activities:
- Stage next batch material BEFORE changeover start
- Prepare tools & adjustments in advance (kitted cart ready to go)

PPIC Benefit dari SMED:

Smaller batch sizes feasible (lower setup time → economic to run small batches)
Higher flexibility (can switch species/sizes more frequently to match demand)
Reduced WIP inventory (less need untuk large batches)
Improved on-time delivery (faster response to rush orders)

Reference: Furniture factory case study - SMED implementation (Bangladesh, published in Academia.edu, 2022)

D. Total Productive Maintenance (TPM) - Critical untuk Kiln & Equipment

Why TPM Matters: Wood flooring equipment (kilns, saws, planers) adalah expensive, high-impact → downtime very costly!

TPM Pillars untuk Wood Flooring:

Autonomous Maintenance (Jishu Hozen):
- Operators perform daily maintenance (cleaning, lubrication, basic inspections)
- Example: Kiln operator checks door seals, vents, fans every day → prevent breakdowns
- Benefit: Early problem detection, reduce unexpected downtime
Planned Maintenance:
- Scheduled preventive maintenance (weekly, monthly, annual based on equipment manual)
- Example: Planer blade sharpening every 40 hours running time (before dull → defects)
- PPIC role: Schedule maintenance during low-production periods (avoid peak season downtime)
Quality Maintenance:
- Maintain equipment settings untuk consistent product quality
- Example: Kiln temperature/humidity calibration monthly → prevent drying defects
- Link TPM dengan QC: Equipment parameter logs vs product quality data
Focused Improvement (Kaizen):
- Target chronic losses (e.g., kiln door air leak → 5% efficiency loss)
- Cross-functional team (Operators + Maintenance + PPIC) solve problem together
- Example result: New Zealand sawmill → 30% energy savings via TPM-driven improvements

OEE (Overall Equipment Effectiveness) Tracking:

Formula: OEE = Availability × Performance × Quality
Target OEE untuk wood flooring equipment: 75-85% (world-class = 85%+)
Example: Kiln OEE calculation
- Availability: 90% (kiln uptime, exclude breakdowns & maintenance)
- Performance: 92% (actual drying time vs standard time, account delays)
- Quality: 95% (good dried lumber vs total input, exclude warped/checked boards)
- OEE = 0.90 × 0.92 × 0.95 = 78.7% (above target, good!)

Reference: New Zealand sawmill TPM case - 30% energy savings (Virginia Tech publication, 2024)

C. Technology Integration untuk Modern PPIC

1. Moisture Content (MC) Monitoring System

📊 Why MC Monitoring is Critical:

Wrong MC = product failure (warping, cupping, gaps, splitting)
Target MC berbeda per application:
- Indoor flooring: 6-8% MC
- Outdoor decking: 10-14% MC (air-dried 18% MC)
- Climate-specific: Dry region 6%, humid region 8%
MC variance within board: Core vs surface can differ 2-3% → need equalization!

Reference: Wood kiln drying cheat sheet (OpenLearning.blog, 2024); Bailey Wood Products MC guidelines

            ✅ Modern MC Monitoring Solutions:

            In-Kiln MC Sensors (Real-time monitoring):
                    Install MC probes inside kiln → continuous moisture reading during drying
Linked to PLC (Programmable Logic Controller) → auto-adjust temperature/humidity
Prevent over-drying (waste energy) atau under-drying (defects)
PPIC benefit: Accurate drying time prediction → better production scheduling

Portable MC Meters (Spot checking):
                    QC inspector check lumber before milling → ensure meet target MC
Pin-type meter (insert pins) vs pinless meter (surface scan) → tradeoff accuracy vs convenience
SOP: Reject lumber if MC outside spec (e.g., >10% untuk indoor flooring)

MC Data Logging & Analysis:
                    Record MC data untuk every batch → build historical database
Statistical analysis: MC variance by species, season, kiln, drying schedule
Optimize drying schedule: If data shows Oak consistently reach 7% MC at day 25 (vs schedule day 28) → can reduce cycle time!

2. Auto-Grading & Vision Inspection System

Traditional Grading Pain Points:

Manual visual inspection → subjective, inconsistent
Labor intensive → high cost, slow throughput
Human error → misgrading (Premium sold as Standard = lost revenue OR Standard sold as Premium = quality complaint)

✅ Auto-Grading Technology Solutions:

Laser Scanner + Vision System:
- Inline scanners capture high-res images of every board (both surfaces)
- AI/ML algorithms detect defects: Knots, splits, warp, color variation, grain pattern
- Auto-grade classification: Premium / Standard / Economy / Reject
- Throughput: 100-200 boards/minute (vs 20-30 manual)
Auto-Sorting System:
- Integrated dengan vision system → boards auto-sorted by grade
- Pneumatic pushers atau diverter gates → physical separation
- Track count per grade real-time → PPIC knows exact inventory by grade!
Traceability & Data Analytics:
- Each board tagged dengan barcode/RFID → link to grade, source log, drying batch
- Quality trend analysis: Which supplier/log source gives best grade yield?
- Feedback loop: Adjust sawing, drying parameters untuk improve grade output

PPIC Benefits dari Auto-Grading:

Real-time inventory visibility: Know exact stock by SKU (species + grade + size)
Accurate yield data: Improve MPS planning (reduce material waste)
Faster throughput: Reduce production lead time (bottleneck eliminated)
Quality consistency: Reduce customer complaints (objective grading standard)

3. ERP/MES Integration untuk End-to-End Visibility

            Modern PPIC Technology Stack:

            A. ERP (Enterprise Resource Planning) System:

            Core Modules untuk Wood Flooring:
                    Material Management: Log inventory, dried lumber, finished goods (by species/grade/size)
Production Planning: MPS, MRP, capacity planning (kiln schedule!)
Sales & Distribution: Customer order, delivery schedule, invoicing
Purchasing: PO management, supplier performance tracking
Finance: Costing, margin analysis, inventory valuation

Key ERP Features for PPIC:
                    Multi-level BOM: Log → Lumber → Flooring (dengan yield factors)
By-product handling: Track sawdust, offcuts sebagai saleable items
Grade-based inventory: Separate SKUs per grade (critical!)
Lot traceability: Batch number tracking dari log to finished goods (untuk recall capability)

            B. MES (Manufacturing Execution System):

            Shop Floor Integration:
                    Real-time production data capture: Kiln status, milling throughput, QC results
Work order execution: Operators receive production instructions via terminals
Equipment monitoring: OEE tracking, downtime logging
Quality management: Inline inspection results, defect recording

MES-ERP Integration Benefits:
                    Automatic inventory update: Production completion → ERP stock increment (no manual entry!)
Actual vs planned comparison: Real-time variance alerts (e.g., yield lower than expected → PPIC notified)
Shop floor visibility: PPIC can see work order status from office (no need walk around)

            C. Advanced Analytics & Dashboards:

            PPIC Dashboard KPIs (Real-time monitoring):
                    Production plan vs actual: Target 50,000 bd.ft, actual 47,500 bd.ft (95% achievement)
Kiln utilization: 5 kilns × 85% average utilization = 4.25 kiln equivalent running
Yield rate: Actual 48% vs standard 50% (investigate why low!)
On-time delivery: 92% orders shipped on-time (target 95%)
Inventory days: 95 days DOI (target 90 days)

Predictive Analytics (AI/ML powered):
                    Demand forecasting: Machine learning model based on historical sales + seasonality + external factors (housing starts, construction index)
Yield prediction: Predict grade output based on log source, species, season
Maintenance prediction: Analyze equipment sensor data → predict failure before it happens

🎯 SUMMARY - PPIC Excellence dalam Wood Flooring Industry:

Key Success Factors:

Master the Constraints: Kiln drying time, yield variance, seasonality → plan around these, don't fight them!
Leverage Technology: MC monitoring, auto-grading, ERP/MES integration → data-driven decisions
Embrace Lean Thinking: VSM, 5S, SMED, TPM → continuous improvement culture
Build Resilience: Multi-source suppliers, seasonal inventory strategy, flexible contracts
Focus on Quality: Grade-based inventory, traceability, waste utilization → sustainable profitability

The Bottom Line:

Wood flooring PPIC is MORE COMPLEX than typical manufacturing (natural material variability!)
But dengan right strategies, tools, dan mindset → dapat achieve world-class performance
Companies seperti Weyerhaeuser, Merillat Industries membuktikan: Lean + Technology = Competitive Advantage
Sustainability bukan hanya compliance requirement → waste reduction = profit improvement!

2. JENIS-JENIS LAPORAN PPIC dalam Industri Lantai Kayu

Navigasi berbagai jenis laporan untuk pengambilan keputusan yang efektif

🎯 Mengapa Laporan PPIC Penting?

Laporan PPIC adalah "dashboard" yang memberikan visibility real-time tentang operasi manufacturing. Tanpa laporan yang baik, PPIC seperti "driving blindfolded".

Key Benefits:

Real-time visibility: Kondisi aktual production, inventory, delivery
Proactive problem-solving: Detect issues SEBELUM jadi crisis
Data-driven decisions: Keputusan based on facts, bukan asumsi
Accountability: Clear ownership & KPI measurement

Overview - Klasifikasi Laporan PPIC

Laporan PPIC dapat diklasifikasikan berdasarkan:

Frekuensi: Real-time, Daily, Weekly, Monthly, Quarterly, Annual
Fungsi: Production, Inventory, Planning, Performance, Quality, Delivery, Cost, Strategic
User: Operator, Supervisor, Manager, Executive

Jenis Laporan	Sub-Bagian (Klik untuk detail)
2.1 Production Reports
2.2 Inventory Reports
2.3 Planning Reports
2.4 Performance Reports
2.5 Quality Reports
2.6 Delivery Reports
2.7 Cost & Efficiency Reports
2.8 Long-Term Strategic Reports

💡 Tips Memilih Laporan yang Tepat:

Operators: Fokus pada Daily Production & Real-Time Dashboard
Supervisors: Daily + Weekly Production, Quality Control Report
PPIC Planners: MPS, MRP, RCCP, MPP, Inventory Status, Capacity Planning
PPIC Managers: Weekly/Monthly Performance, OEE, Inventory Analysis, Cost Reports
Executives: KPI Dashboard, QBR, Budget vs Actual, Annual Plans

2.1 PRODUCTION REPORTS (Laporan Produksi)

Track production output, efficiency, dan performance untuk daily/weekly/monthly monitoring

A. Daily Production Report

📋 Purpose: Track daily production output, identify immediate issues, monitor labor & material consumption

Frequency: End of shift/day | Users: Production Managers, PPIC Planners, QC Supervisors

            Key Contents untuk Wood Flooring:

                    Section
                    Details
                
                    Production Output
                    
                        • By Process: Sawing, Kiln Drying, Milling, Finishing, Packaging

                        • By SKU: Species, Width, Grade, Finish type

                        • Example: Oak 3.25" Premium = 7,500 bd.ft (Target 8,000)
                    
                    Plan vs Actual
                    
                        • Achievement %: Actual / Plan × 100%

                        • Gap Analysis: Reason untuk variance

                        • MTD Cumulative: Running total vs monthly target
                    
                    Material Consumption
                    
                        • Log input vs Finished output → Yield %

                        • Adhesive, Finish coating usage

                        • Packaging materials consumed
                    
                    Labor Utilization
                    
                        • Attendance (planned vs actual)

                        • Overtime hours

                        • Productivity: bd.ft per man-hour
                    
                    Quality Metrics
                    
                        • First Pass Yield: 90% (Target: 92%)

                        • Reject Rate: 3% by defect type

                        • Customer complaints logged
                    
                    Equipment Performance
                    
                        • Downtime log by machine

                        • Reasons: Maintenance, breakdown, changeover

                        • OEE snapshot
                    
                    Issues & Actions
                    
                        • Critical issues identified

                        • Action items: Owner, Due date

                        • Material shortage alerts

Section	Details
Production Output	• By Process: Sawing, Kiln Drying, Milling, Finishing, Packaging • By SKU: Species, Width, Grade, Finish type • Example: Oak 3.25" Premium = 7,500 bd.ft (Target 8,000)
Plan vs Actual	• Achievement %: Actual / Plan × 100% • Gap Analysis: Reason untuk variance • MTD Cumulative: Running total vs monthly target
Material Consumption	• Log input vs Finished output → Yield % • Adhesive, Finish coating usage • Packaging materials consumed
Labor Utilization	• Attendance (planned vs actual) • Overtime hours • Productivity: bd.ft per man-hour
Quality Metrics	• First Pass Yield: 90% (Target: 92%) • Reject Rate: 3% by defect type • Customer complaints logged
Equipment Performance	• Downtime log by machine • Reasons: Maintenance, breakdown, changeover • OEE snapshot
Issues & Actions	• Critical issues identified • Action items: Owner, Due date • Material shortage alerts

📊 Example Daily Production Report Format:

══════════════════════════════════════════════════════════
      DAILY PRODUCTION REPORT - WOOD FLOORING PLANT
══════════════════════════════════════════════════════════
Date: Feb 3, 2026          Shift: Day (07:00-15:00)

1. PRODUCTION OUTPUT SUMMARY
┌────────────────────────────────────────────────────┐
│ SKU                    │ Plan  │ Actual │ Achv %  │
├────────────────────────────────────────────────────┤
│ Oak 3.25" Prem Unfin   │ 8,000 │ 7,500  │  93.75% │
│ Maple 5" Std Pre-fin   │ 5,000 │ 5,200  │ 104.00% │
│ Walnut 3.25" Prem Unf  │ 2,000 │ 1,800  │  90.00% │
├────────────────────────────────────────────────────┤
│ TOTAL (bd.ft)          │15,000│14,500 │ 96.67% │
└────────────────────────────────────────────────────┘

2. PROCESS STAGE DETAILS
- Sawing: 30,000 → 16,500 bd.ft (55% yield) ✓
- Kiln: Batch #45 loaded, Batch #42 unloaded ⚠ 2hr delay
- Milling: 15,200 → 14,500 bd.ft (95% yield) ✓
- Finishing: 5,500 → 5,200 bd.ft ✓
- Packaging: 290 boxes completed ✓

3. QUALITY & EQUIPMENT
- First Pass Yield: 90% (Target: 92%) ⚠
- Reject Rate: 3% (Warping 1.5%, Surface 1%, Check 0.5%)
- OEE Average: 76% (Target: 80%) ⚠ BELOW TARGET
- Downtime: Kiln #3 = 2hrs (power outage)

4. CRITICAL ISSUES
┌────────────────────────────────────────────────────┐
│ Issue              │ Impact        │ Action        │
├────────────────────────────────────────────────────┤
│ Kiln #3 outage     │ -500 bd.ft    │ Backup gen    │
│ Walnut shortage    │ 3 days left   │ Delivery Fri  │
│ High reject (3%)   │ Rework cost↑  │ RCA meeting   │
└────────────────────────────────────────────────────┘

NEXT DAY PLAN: 16,000 bd.ft (catch up gap)
══════════════════════════════════════════════════════════

B. Weekly Production Report

📋 Purpose: Analyze weekly trends, compare week-over-week, identify systemic issues

Frequency: Monday review meeting | Users: Plant Manager, PPIC Manager, Operations Director

            Key Contents:


            Weekly Production Summary:
                    Total output by SKU (this week vs last week vs plan)
Cumulative MTD vs target (on track?)
Top 3 best-performing SKUs, bottom 3 underperforming

                
OEE Trend Analysis:
                    Weekly average OEE by equipment
Downtime breakdown: Planned vs Unplanned
Pareto chart: Top 5 downtime causes

                
Quality Performance:
                    Weekly FPY, reject rate, rework rate trends
Defect analysis by category
Customer complaints summary + RCA status

                
Productivity Metrics:
                    Labor productivity: bd.ft per man-hour
Machine productivity: bd.ft per machine-hour
Yield rate by process

                
Action Items Tracking:
                    Last week's action items: Status update
This week's new action items
Kaizen projects progress

                

        

📊 Weekly Production Meeting Agenda (60 min):

Production Review (10 min): Achievement %, gaps, reasons
OEE & Downtime (15 min): Top issues, action owners
Quality Review (10 min): Trends, customer complaints
Material & Capacity (10 min): Next week forecast, bottlenecks
Continuous Improvement (10 min): Kaizen, 5S audit
Open Issues (5 min): AOB, coordination

C. Monthly Production Dashboard

📋 Purpose: Executive summary for strategic decision-making

Frequency: Monthly management review | Users: GM, Finance Director, Executive Team

Key KPIs untuk Manufacturing Dashboard:

KPI Category	Metric	Target (Wood Flooring)
PRODUCTION	Production Volume	Based on capacity & demand
	Plan Achievement %	95-100%
	Capacity Utilization	80-90%
EFFICIENCY	OEE	75-85%
	Labor Productivity	18-22 bd.ft/man-hour
	Yield Rate	45-52% (log to finished)
QUALITY	First Pass Yield	92-96%
	Scrap/Reject Rate	<2%
	Customer Return Rate	<0.5%
DELIVERY	On-Time Delivery	92-96%
DELIVERY	Order Cycle Time	35-45 days
COST	Cost Per Unit	Benchmark vs budget
COST	Material Cost %	40-50% of total

Reference: Manufacturing KPI standards (SimpleKPI, InsightSoftware, 2025)

2.2 INVENTORY REPORTS (Laporan Persediaan)

Monitor stock levels untuk prevent stockout atau overstock

A. Daily Inventory Status Report

📋 Purpose: Monitor stock levels DAILY, alert untuk reorder point

Frequency: Daily (EOD) | Users: PPIC Inventory Controller, Purchasing

            Key Contents untuk Wood Flooring:

                    Inventory Category
                    Details to Track
                
                    1. Raw Material (Logs)
                    
                        • By Species: Oak, Maple, Walnut (bd.ft)

                        • By Grade: Select & Better vs Common

                        • Days of Supply: Stock ÷ Daily consumption

                        • Reorder Point Alert: RED (<5 days), YELLOW (<15 days)
                    
                    2. WIP (Work-In-Process)
                    
                        • At Kiln: Species, Day X/Total, Expected ready date

                        • At Milling/Finishing: Semi-finished inventory

                        • Aging Analysis: WIP >60 days = quality risk

                        • Value tied up: $$ in WIP
                    
                    3. Finished Goods
                    
                        • By SKU: Species + Width + Grade + Finish

                        • Available vs Committed (ATP = Available To Promise)

                        • Slow-Moving Alert: No movement >90 days

                        • Aging: 0-30, 31-60, 61-90, >90 days
                    
                    4. Inventory Value
                    
                        • By Category: RM ($500K), WIP ($300K), FG ($800K)

                        • DOI: (Avg inventory / COGS) × 365 days

                        • Inventory Turnover: COGS / Avg inventory

Inventory Category	Details to Track
1. Raw Material (Logs)	• By Species: Oak, Maple, Walnut (bd.ft) • By Grade: Select & Better vs Common • Days of Supply: Stock ÷ Daily consumption • Reorder Point Alert: RED (<5 days), YELLOW (<15 days)
2. WIP (Work-In-Process)	• At Kiln: Species, Day X/Total, Expected ready date • At Milling/Finishing: Semi-finished inventory • Aging Analysis: WIP >60 days = quality risk • Value tied up: $$ in WIP
3. Finished Goods	• By SKU: Species + Width + Grade + Finish • Available vs Committed (ATP = Available To Promise) • Slow-Moving Alert: No movement >90 days • Aging: 0-30, 31-60, 61-90, >90 days
4. Inventory Value	• By Category: RM ($500K), WIP ($300K), FG ($800K) • DOI: (Avg inventory / COGS) × 365 days • Inventory Turnover: COGS / Avg inventory

📊 Example Daily Inventory Status:

══════════════════════════════════════════════════════
         DAILY INVENTORY STATUS REPORT
══════════════════════════════════════════════════════
Date: Feb 3, 2026

1. RAW MATERIAL (Logs)
┌──────────────────────────────────────────────────┐
│ Species │ Stock    │ Daily Use │ Days │ Status  │
├──────────────────────────────────────────────────┤
│ Oak     │  80,000  │   3,000   │ 26.7 │  ✓ OK   │
│ Maple   │  50,000  │   2,500   │ 20.0 │  ✓ OK   │
│ Walnut  │   6,000  │   2,000   │  3.0 │ 🔴 LOW! │
│ Pine    │ 100,000  │   1,000   │100.0 │ ⚠ HIGH  │
└──────────────────────────────────────────────────┘

2. WIP (Kiln Drying) - Total: 55,000 bd.ft ($110K)
┌──────────────────────────────────────────────────┐
│ Kiln│ Species │ Day  │ Stock  │ Ready Date      │
├──────────────────────────────────────────────────┤
│ #1  │ Oak 4/4 │12/28 │ 15,000 │ Feb 18          │
│ #2  │ Maple   │ 8/14 │ 10,000 │ Feb 11          │
│ #3  │ Oak 8/4 │20/40 │ 12,000 │ Feb 23          │
└──────────────────────────────────────────────────┘

3. FINISHED GOODS - Total: 63,000 bd.ft
- Available for sale: 19,500 bd.ft
- Committed to orders: 43,500 bd.ft

ALERTS:
🔴 URGENT: Walnut logs (3 days supply!) - PO needed TODAY
⚠️  Pine overstock (100 days) - Reduce next order
══════════════════════════════════════════════════════

B. Monthly Inventory Analysis Report

📋 Purpose: Deep dive analysis untuk optimize inventory policy

Frequency: Monthly | Users: PPIC Manager, Finance, Operations

            Key Analysis Components:


            ABC Analysis (Pareto):
                    Class A (80% revenue): Tight control, frequent review
Class B (15% revenue): Moderate control
Class C (5% revenue): Loose control, consider discontinue

                
FSN Analysis:
                    Fast-Moving: <30 days → priority replenishment
Slow-Moving: 30-90 days → review pricing
Non-Moving: >90 days → clearance sale

                
Inventory Aging:
                    Age buckets: 0-30, 31-60, 61-90, 91-180, >180 days
>180 days = potential write-off (quality degradation)
Wood specific: Check MC of aged inventory!

                
Inventory Accuracy:
                    System vs Physical count (cycle count/opname)
Accuracy % = Accurate records / Total records
Target: >95% (world-class: >99%)

                
Safety Stock Review:
                    Current vs Optimal safety stock
Formula: Z-score × σ(LT) × Demand_avg
Seasonal adjustment: Higher SS before rainy season

                

        

C. Stock Alert Report (Automated)

📋 Purpose: Real-time alert untuk prevent stockout

Frequency: Real-time / As needed | Users: PPIC, Purchasing

            Alert Triggers:

            🔴 CRITICAL (Immediate Action):
                    Raw material <3 days supply
Finished goods stock-out (ATP = 0)
PO delayed >5 days from promised date

🟡 WARNING (Plan Action):
                    Raw material <15 days supply (reorder point)
Slow-moving items >90 days
Overstock items >60 days supply

🟢 INFO (Monitor):
                    Normal stock levels (15-60 days supply)
Regular replenishment orders

2.3 PLANNING REPORTS (Laporan Perencanaan)

Production planning, material planning, dan capacity planning

A. Master Production Schedule (MPS) Report

📋 Purpose: Rolling production plan (4-8 weeks forward)

Frequency: Weekly S&OP meeting | Users: PPIC, Sales, Operations

            MPS Structure untuk Wood Flooring:


            
                
                    SKU
                    Week 1
                    Week 2
                    Week 3
                    Week 4
                

                    Oak 3.25" Premium
                    30,000
                    32,000
                    35,000
                    30,000
                

                    Maple 5" Standard
                    20,000
                    20,000
                    18,000
                    20,000
                

                    Walnut 3.25" Prem
                    8,000
                    10,000
                    10,000
                    8,000
                

                    Pine Decking 5.5"
                    40,000
                    40,000
                    45,000
                    45,000
                

                    TOTAL (bd.ft)
                    98,000
                    102,000
                    108,000
                    103,000
                



            MPS Development Process:

            Input Collection: Sales forecast + Firm orders + Current inventory + Capacity
RCCP (Rough-Cut Capacity Planning): Check kiln capacity feasibility
MRP Run: Calculate raw material requirements
S&OP Approval: Cross-functional review & freeze near-term plan

        

SKU	Week 1	Week 2	Week 3	Week 4
Oak 3.25" Premium	30,000	32,000	35,000	30,000
Maple 5" Standard	20,000	20,000	18,000	20,000
Walnut 3.25" Prem	8,000	10,000	10,000	8,000
Pine Decking 5.5"	40,000	40,000	45,000	45,000
TOTAL (bd.ft)	98,000	102,000	108,000	103,000

B. Material Requirements Planning (MRP) Report

📋 Purpose: Detailed material planning - right material, right quantity, right time

Frequency: Weekly MRP run | Users: PPIC, Purchasing

            MRP Output Components:

                    MRP Output
                    Description
                
                    Planned Orders
                    
                        • What: Oak logs 4/4 Select & Better

                        • Qty: 150,000 bd.ft

                        • Order: Feb 5 | Required: Feb 19 (LT 14 days)
                    
                    Purchase Requisitions
                    
                        • PR #001: Oak logs → Supplier ABC

                        • PR #002: Adhesive PVA → Supplier DEF

                        • PR #003: Finish coating → Supplier GHI
                    
                    Exception Messages
                    
                        • Expedite: PO delayed (action needed!)

                        • De-expedite: Demand dropped (can delay)

                        • Reschedule: Adjust timing

                        • Cancel: No longer needed
                    
                    Pegging Report
                    
                        • Traceability: Link materials to customer orders

                        • Example: Log batch → Kiln batch → Customer order

                        • Purpose: Quick impact analysis if quality issue
                    
                    Capacity Constraints
                    
                        • Alert: Kiln capacity insufficient Week 3

                        • Options: Reduce production, outsource, overtime

                        • PPIC decision required

MRP Output	Description
Planned Orders	• What: Oak logs 4/4 Select & Better • Qty: 150,000 bd.ft • Order: Feb 5 \| Required: Feb 19 (LT 14 days)
Purchase Requisitions	• PR #001: Oak logs → Supplier ABC • PR #002: Adhesive PVA → Supplier DEF • PR #003: Finish coating → Supplier GHI
Exception Messages	• Expedite: PO delayed (action needed!) • De-expedite: Demand dropped (can delay) • Reschedule: Adjust timing • Cancel: No longer needed
Pegging Report	• Traceability: Link materials to customer orders • Example: Log batch → Kiln batch → Customer order • Purpose: Quick impact analysis if quality issue
Capacity Constraints	• Alert: Kiln capacity insufficient Week 3 • Options: Reduce production, outsource, overtime • PPIC decision required

C. RCCP (Rough-Cut Capacity Planning) Report

📋 Purpose: High-level capacity check SEBELUM MPS finalized - apakah capacity cukup?

Frequency: Weekly (before MPS approval) | Users: PPIC Manager, Operations Manager

            ⚠️ PERBEDAAN RCCP vs Detailed Capacity Planning:

                    Aspek
                    RCCP (Rough-Cut)
                    Detailed Capacity Planning
                
                    Timing
                    SEBELUM MPS approved
                    SETELAH MPS approved
                
                    Level Detail
                    Aggregate (product family level)
                    Detailed (SKU level, work center level)
                
                    Resource Focus
                    Critical resources saja (e.g., kiln)
                    ALL resources (sawing, milling, finishing, dll)
                
                    Time Bucket
                    Weekly atau Monthly
                    Daily atau Shift-level
                
                    Purpose
                    FEASIBILITY check (bisa atau tidak?)
                    EXECUTION plan (exact schedule)
                
                    Action if Overload
                    REVISE MPS (change production plan)
                    ADJUST execution (overtime, outsource)

Aspek	RCCP (Rough-Cut)	Detailed Capacity Planning
Timing	SEBELUM MPS approved	SETELAH MPS approved
Level Detail	Aggregate (product family level)	Detailed (SKU level, work center level)
Resource Focus	Critical resources saja (e.g., kiln)	ALL resources (sawing, milling, finishing, dll)
Time Bucket	Weekly atau Monthly	Daily atau Shift-level
Purpose	FEASIBILITY check (bisa atau tidak?)	EXECUTION plan (exact schedule)
Action if Overload	REVISE MPS (change production plan)	ADJUST execution (overtime, outsource)

📌 CONTOH RCCP REPORT - Wood Flooring Plant:

Scenario: MPS proposal Week 1-4 (dari bagian A di atas)

Critical Resource: KILN CAPACITY

Available Kilns: 5 units
Capacity per kiln: 18,000 bd.ft/cycle
Cycle time: 21-30 hari (avg 25 hari)
Effective weekly capacity: 5 kilns × 18,000 bd.ft × (7 days / 25 days) = 25,200 bd.ft/week

RCCP Calculation:

Week	MPS Total (bd.ft)	Kiln Load Required	Kiln Capacity	Utilization %	Status
Week 1	98,000	98,000 / 0.50 yield = 196,000 input 196,000 need drying	25,200/week	—	🔴 Mismatch!
⚠️ WAIT! Calculation error! Kiln capacity adalah THROUGHPUT (berapa yang keluar per minggu), bukan INPUT! Correct Logic: Jika kita butuh 98,000 bd.ft finished goods Week 1, maka kita perlu MULAI DRYING 3-4 minggu SEBELUMNYA (karena cycle time 21-30 hari)! RCCP harus look backward: Week 1 output ← loaded di Week -3 atau -4

CORRECT RCCP Approach untuk Wood Flooring:

STEP 1: Backward Schedule dari MPS
• Week 1 butuh 98,000 bd.ft finished → perlu 196,000 bd.ft dried lumber (asumsi yield 50%)
• Dried lumber harus READY Week 1 → start drying Week -3 (asumsi 25 hari cycle = 3.5 minggu, round up 4 minggu)
• RCCP check: Apakah Week -3 kiln capacity cukup untuk load 196,000 bd.ft?

STEP 2: Calculate Kiln Load per Week (Rolling 4-Week Window)

Week	MPS Finish Goods (bd.ft)	Dried Lumber Needed (÷0.5 yield)	Drying Start Week (Lag -4 weeks)	Kiln Load Required (bd.ft)
Week 1	98,000	196,000	Week -3	196,000
Week 2	102,000	204,000	Week -2	204,000
Week 3	108,000	216,000	Week -1	216,000
Week 4	103,000	206,000	Week 0 (NOW!)	206,000

STEP 3: Capacity vs Load Analysis

Week	Kiln Load Required	Available Capacity	Utilization %	Status
Week -3	196,000 bd.ft	90,000 bd.ft (5 kilns × 18,000)	218%	🔴 OVERLOAD!
Week -2	204,000 bd.ft	90,000 bd.ft	227%	🔴 OVERLOAD!
Week -1	216,000 bd.ft	90,000 bd.ft	240%	🔴 CRITICAL!
Week 0	206,000 bd.ft	90,000 bd.ft	229%	🔴 OVERLOAD!

CONCLUSION: MPS NOT FEASIBLE! Kiln capacity hanya 40-45% dari yang dibutuhkan!

STEP 4: PPIC Action - Revise MPS atau Increase Capacity

Option 1: REDUCE MPS (Adjust Production Plan)

Feasible capacity: 90,000 bd.ft dried/week × 0.50 yield = 45,000 bd.ft finished/week
Current MPS avg: 102,750 bd.ft/week
Reduction needed: 56% cut! (102,750 → 45,000)
Impact: Cannot meet customer demand! Sales akan komplain!

Option 2: INCREASE CAPACITY (Short-term Solutions)

Toll Drying: Outsource drying ke third-party kiln operator (extra cost ~$50-80/MBF)
Reduce Cycle Time: Optimize kiln schedule 25 hari → 21 hari (risky - quality issue!)
Purchase Dried Lumber: Buy pre-dried lumber dari supplier (premium price ~15-20%)
Adjust Mix: Shift dari slow-drying species (Oak 28 hari) → fast-drying (Pine 14 hari)

Option 3: HYBRID APPROACH (Most Realistic)

Reduce MPS by 20% (102,750 → 82,000 bd.ft/week)
Toll drying untuk 30% (24,600 bd.ft/week)
Optimize kiln schedule untuk gain 5% capacity (90,000 → 94,500 bd.ft/week)
Total achievable: 82,000 + (94,500 × 0.5 yield) = ~129,250 bd.ft/week (masih 20% below original MPS, tapi acceptable!)

✅ VALUE OF RCCP:

Early Warning System: Detect capacity issue SEBELUM commit ke customer (avoid late delivery!)
Realistic Planning: Force Sales & PPIC untuk align expectation vs reality
Proactive Solution: Time untuk arrange toll drying, purchase dried lumber, dll (bukan panic mode!)
Cost Optimization: Compare option (reduce MPS vs toll drying vs buy lumber) → choose best ROI

RCCP adalah "Sanity Check" SEBELUM MPS approved! Tanpa RCCP, MPS = wishful thinking! 😅

D. Material Purchase Plan (MPP) Report

📋 Purpose: Rolling 3-6 month material forecast untuk support long-term supplier contracts & pricing negotiation

Frequency: Monthly update | Users: PPIC Manager, Procurement Director, CFO

            🔄 PERBEDAAN MPP vs MRP:

                    Aspek
                    MRP (Weekly)
                    MPP (Monthly)
                
                    Time Horizon
                    4-8 weeks (short-term)
                    3-6 months (long-term)
                
                    Detail Level
                    Exact quantity, exact date
                    Aggregate volume, monthly bucket
                
                    Purpose
                    Generate PR untuk immediate orders
                    Strategic planning, contract negotiation
                
                    Input Source
                    Firm MPS (frozen plan)
                    Sales forecast (not firm yet!)
                
                    Accuracy Expected
                    High (95%+ - execution level)
                    Medium (75-85% - planning level)
                
                    Example Output
                    "Need 85,000 bd.ft Oak logs, deliver Feb 15"
                    "Q2 2026: ~1.2M bd.ft Oak logs total"

Aspek	MRP (Weekly)	MPP (Monthly)
Time Horizon	4-8 weeks (short-term)	3-6 months (long-term)
Detail Level	Exact quantity, exact date	Aggregate volume, monthly bucket
Purpose	Generate PR untuk immediate orders	Strategic planning, contract negotiation
Input Source	Firm MPS (frozen plan)	Sales forecast (not firm yet!)
Accuracy Expected	High (95%+ - execution level)	Medium (75-85% - planning level)
Example Output	"Need 85,000 bd.ft Oak logs, deliver Feb 15"	"Q2 2026: ~1.2M bd.ft Oak logs total"

📌 CONTOH MPP REPORT - Oak Logs (3-Month Rolling Plan):

INPUT: Sales Forecast (Product Family Level)

Month	Oak Flooring Forecast (bd.ft)	Maple Flooring Forecast	Walnut Flooring Forecast
May 2026	120,000	80,000	35,000
Jun 2026	140,000	90,000	40,000
Jul 2026	150,000	85,000	38,000

CALCULATION: Oak Log Requirement

May 2026 Oak Log Calculation:
• Finished goods forecast: 120,000 bd.ft
• Yield factor (log to finished): 45% (industry avg untuk oak)
• Gross log requirement: 120,000 ÷ 0.45 = 266,667 bd.ft logs
• Add safety stock (10%): 266,667 × 1.10 = 293,333 bd.ft
• Less beginning inventory: 50,000 bd.ft on-hand
• NET PURCHASE REQUIREMENT: 243,333 bd.ft

MPP OUTPUT: Material Purchase Plan Summary

Material	May 2026	Jun 2026	Jul 2026	Q2 Total
Oak Logs 4/4	243,333 bd.ft	311,111 bd.ft	333,333 bd.ft	887,777 bd.ft
Maple Logs 4/4	176,000 bd.ft	198,000 bd.ft	187,000 bd.ft	561,000 bd.ft
Walnut Logs 4/4	77,000 bd.ft	88,000 bd.ft	83,600 bd.ft	248,600 bd.ft
TOTAL LOGS	496,333	597,111	603,933	1,697,377 bd.ft
Auxiliary Materials (Based on Finished Goods Volume):
UV Lacquer	2,350 gallons	2,700 gallons	2,730 gallons	7,780 gallons
PVA Adhesive	1,175 gallons	1,350 gallons	1,365 gallons	3,890 gallons
Packaging Boxes	4,700 units	5,400 units	5,460 units	15,560 units

✅ HOW PROCUREMENT USES MPP:

Contract Negotiation (Long-term):
- MPP shows Q2 total: 887,777 bd.ft oak logs needed
- Procurement approach supplier: "We need ~890k bd.ft oak over next 3 months. What's your best price for volume commitment?"
- Leverage volume untuk negotiate discount (e.g., 5% off if commit 800k+ bd.ft)
- Lock-in price untuk 3-6 months → mitigate price volatility risk
Supplier Capacity Reservation:
- Share MPP dengan key suppliers → they can plan their logging operations
- Request allocation commitment: "Reserve 300k bd.ft/month oak capacity untuk us"
- Avoid stockout di peak season (supplier sudah prepare!)
Budget Planning:
- MPP × Unit price = Total material budget Q2
- Example: 887,777 bd.ft oak × $1,200/MBF = $1,065,332 oak budget
- Finance can plan cash flow accordingly
Hedging Strategy (Advanced):
- For volatile materials, consider futures contract atau forward buying
- Example: If oak price trending up, buy 40% of Q2 need NOW at current price

⚠️ MPP CHALLENGES dalam Wood Industry:

Forecast Accuracy Issue:
- Long-term forecast (3-6 months) accuracy biasanya 70-80% saja
- Risk: Commit volume ke supplier based on forecast, actual demand berbeda → overstock atau shortage
- Mitigation: Flexible contract with adjustment clause (e.g., ±15% volume flex)
Lead Time vs Commitment:
- Oak log lead time 60-90 hari → MPP harus project 3+ months ahead
- Semakin panjang horizon, semakin rendah accuracy
- Balance: Commit enough untuk secure supply, tapi tidak terlalu banyak (inventory risk)
Price Volatility:
- Lumber price swing bisa 20-30% dalam 6 bulan (seasonality, market demand)
- Fix price via contract → protected dari price increase, tapi miss opportunity jika price drop
- Hybrid approach: 60% fix contract, 40% spot purchase (balance risk & opportunity)

E. Detailed Capacity Planning Report

📋 Purpose: Work center level capacity analysis untuk execution (SETELAH MPS approved via RCCP)

Frequency: Weekly | Users: PPIC, Production Supervisors

            Capacity Planning Components:

            Available Capacity Calculation:
                    Theoretical capacity: Machine hours × Days × Shifts
Less: Planned downtime (maintenance, breaks, changeover)
Utilization factor: 85-90% (realistic efficiency)
Example Sawmill: 16 hrs/day × 6 days × 85% = 81.6 hrs/week available

Required Capacity (from MPS):
                    MPS volume × Standard time per unit
Example: 30,000 bd.ft oak × 0.003 hrs/bd.ft = 90 hrs sawing required

Load vs Capacity:
                    Week 1: 90 hrs required vs 81.6 hrs available = 110% load (overload!)
Action: Overtime 8.4 hrs ATAU reduce MPS 10%

Bottleneck Identification:
                    Theory of Constraints (TOC): Resource dengan utilization >95% = bottleneck
Focus improvement effort pada bottleneck (maximize throughput!)

2.4 PERFORMANCE REPORTS

Real-time monitoring dan performance KPIs

A. Real-Time Production Dashboard (Shop Floor Display)

📋 Purpose: Visual management untuk operators - immediate feedback

Display: Large screens on shop floor, auto-refresh every 1-5 min | Users: Operators, Supervisors, Visitors

            Key Metrics Displayed:

                    Metric
                    Display Format
                
                    Today's Target vs Actual
                    
                        • Big bold numbers (easy to read dari 10 meter!)

                        • Progress bar: Visual indicator

                        • Color-coded: Green (>95%), Yellow (90-95%), Red (<90%)

                        • Example: 14,500 / 15,000 bd.ft (96.7%)
                    
                    OEE % (Current)
                    
                        • Gauge chart: Like speedometer

                        • Real-time update setiap 5 menit

                        • Breakdown: Availability / Performance / Quality

                        • Example: OEE 78% = Avail 92% × Perf 90% × Qual 94%
                    
                    Quality Metrics
                    
                        • First Pass Yield: 90% (Target: 92%)

                        • Reject count: 450 pcs (3% dari 15,000)

                        • Top 3 defects: Warping (1.5%), Surface (1%), Check (0.5%)
                    
                    Downtime Tracker
                    
                        • Current status: Running / Stopped / Changeover

                        • If stopped: Reason + Duration

                        • Example: "Kiln #3 - STOPPED - Power Outage - 2hrs 15min"

                        • Alert: Blink if downtime >30 min
                    
                    Pace Indicator
                    
                        • Running ahead / On track / Behind schedule

                        • Example: "Behind by 500 bd.ft - Need 8.4 hrs overtime to catch up"

                        • Auto-calculate: Gap ÷ Hourly rate = Extra hours needed
                    
                    Safety Days Counter
                    
                        • "X Days Since Last Accident"

                        • Goal: 365 days accident-free

                        • Build safety culture!

Metric	Display Format
Today's Target vs Actual	• Big bold numbers (easy to read dari 10 meter!) • Progress bar: Visual indicator • Color-coded: Green (>95%), Yellow (90-95%), Red (<90%) • Example: 14,500 / 15,000 bd.ft (96.7%)
OEE % (Current)	• Gauge chart: Like speedometer • Real-time update setiap 5 menit • Breakdown: Availability / Performance / Quality • Example: OEE 78% = Avail 92% × Perf 90% × Qual 94%
Quality Metrics	• First Pass Yield: 90% (Target: 92%) • Reject count: 450 pcs (3% dari 15,000) • Top 3 defects: Warping (1.5%), Surface (1%), Check (0.5%)
Downtime Tracker	• Current status: Running / Stopped / Changeover • If stopped: Reason + Duration • Example: "Kiln #3 - STOPPED - Power Outage - 2hrs 15min" • Alert: Blink if downtime >30 min
Pace Indicator	• Running ahead / On track / Behind schedule • Example: "Behind by 500 bd.ft - Need 8.4 hrs overtime to catch up" • Auto-calculate: Gap ÷ Hourly rate = Extra hours needed
Safety Days Counter	• "X Days Since Last Accident" • Goal: 365 days accident-free • Build safety culture!

✅ BENEFITS Real-Time Dashboard:

Immediate Feedback Loop: Operators tahu performance mereka real-time (bukan tunggu end of day!)
Motivasi & Competition: Team compete untuk best shift performance (gamification!)
Transparency: Management & visitors dapat lihat actual production status
Faster Response: Issue detected immediately → faster corrective action

B. OEE (Overall Equipment Effectiveness) Report

📋 Purpose: Equipment performance analysis - identify improvement opportunities

Frequency: Daily summary, Weekly trend analysis | Users: Maintenance, Production Manager, PPIC

OEE Formula & Components:

                OEE = Availability × Performance × Quality
            
1. AVAILABILITY (Uptime %)

                    Component
                    Formula
                    Example (Kiln)
                
                    Planned Production Time
                    Total time - Planned downtime
                    24 hrs/day - 2 hrs maintenance = 22 hrs
                
                    Actual Operating Time
                    Planned time - Unplanned downtime
                    22 hrs - 2 hrs breakdown = 20 hrs
                
                    Availability
                    Operating time / Planned time
                    20 / 22 = 90.9%
                
2. PERFORMANCE (Speed %)

                    Component
                    Formula
                    Example (Milling Line)
                
                    Ideal Cycle Time
                    Fastest possible time per unit
                    0.003 hrs/bd.ft (200 bd.ft/min)
                
                    Actual Output
                    Total units produced
                    14,500 bd.ft in 20 hrs
                
                    Theoretical Output
                    Operating time / Ideal cycle time
                    20 hrs ÷ 0.003 = 6,667 units MAX
                
                    Performance
                    Actual / Theoretical
                    14,500 / (20×60×200) = 60.4%
                
Wait, calculation error! Let me fix:

            • Ideal rate: 200 bd.ft/min

            • Operating time: 20 hrs = 1,200 min

            • Theoretical output: 1,200 min × 200 bd.ft/min = 240,000 bd.ft MAX

            • Actual output: 14,500 bd.ft

            • Performance: 14,500 / 240,000 = 6%?! ❌ TOO LOW! Something wrong!

Realistic Example (Corrected):

            • Ideal rate: 20 bd.ft/min (more realistic untuk milling)

            • Operating time: 20 hrs = 1,200 min

            • Theoretical output: 1,200 × 20 = 24,000 bd.ft

            • Actual output: 14,500 bd.ft

            • Performance: 14,500 / 24,000 = 60.4% ✓

            • Why not 100%? Micro-stops, speed reductions, jams

3. QUALITY (Good Units %)

                    Component
                    Formula
                    Example
                
                    Total Units Produced
                    All output (good + defect)
                    15,000 bd.ft
                
                    Reject Units
                    Defects + Rework
                    450 bd.ft (3%)
                
                    Good Units
                    Total - Rejects
                    15,000 - 450 = 14,550 bd.ft
                
                    Quality
                    Good units / Total units
                    14,550 / 15,000 = 97%
                
FINAL OEE CALCULATION:

                OEE = 90.9% (Avail) × 60.4% (Perf) × 97% (Qual) = 53.3%
            
Interpretation:
OEE 53% = Below target! (Target 75-85% untuk wood flooring)
Biggest loss: Performance (60%) → Focus improvement here!
Root cause Performance loss: Micro-stops, speed reduction, changeover time
Action: SMED (reduce changeover), TPM (reduce micro-stops), standard work

Component	Formula	Example (Kiln)
Planned Production Time	Total time - Planned downtime	24 hrs/day - 2 hrs maintenance = 22 hrs
Actual Operating Time	Planned time - Unplanned downtime	22 hrs - 2 hrs breakdown = 20 hrs
Availability	Operating time / Planned time	20 / 22 = 90.9%

Component	Formula	Example (Milling Line)
Ideal Cycle Time	Fastest possible time per unit	0.003 hrs/bd.ft (200 bd.ft/min)
Actual Output	Total units produced	14,500 bd.ft in 20 hrs
Theoretical Output	Operating time / Ideal cycle time	20 hrs ÷ 0.003 = 6,667 units MAX
Performance	Actual / Theoretical	14,500 / (20×60×200) = 60.4%

Component	Formula	Example
Total Units Produced	All output (good + defect)	15,000 bd.ft
Reject Units	Defects + Rework	450 bd.ft (3%)
Good Units	Total - Rejects	15,000 - 450 = 14,550 bd.ft
Quality	Good units / Total units	14,550 / 15,000 = 97%

📊 OEE TREND REPORT - Weekly Analysis:

Equipment	Week 1 OEE	Week 2 OEE	Week 3 OEE	Week 4 OEE	Avg	Trend
Sawmill	82%	85%	84%	86%	84.3%	↑ Good
Kiln #1	88%	87%	89%	88%	88%	→ Stable
Milling Line	72%	68%	65%	53%	64.5%	↓ DECLINING!
Finishing Line	78%	76%	79%	77%	77.5%	→ OK

KEY INSIGHT: Milling Line OEE declining dari 72% → 53% in 4 weeks! URGENT ACTION NEEDED!

Root Cause Analysis (Milling Line):

Availability drops: Dari 92% → 85% (more frequent breakdowns)
Performance drops: Dari 85% → 65% (running slower)
Quality OK: Stable at 97%

Action Plan:

Immediate (This Week):
- Inspect milling knives → replace if dull (affect speed!)
- Check belt tension → slipping belt slow down feed rate
- Lubrication all bearings → reduce friction
Short-term (Next 2 Weeks):
- Deep maintenance: Replace worn parts (bearings, belts, chains)
- Operator retraining: Proper setup procedures
- Standard work documentation: Best practice setup
Long-term (Next Quarter):
- Implement TPM program: Daily autonomous maintenance by operators
- Predictive maintenance: Monitor vibration, temperature sensors
- Target: Bring OEE back to 75%+ sustainable

C. KPI Executive Dashboard (Monthly)

📋 Purpose: High-level business intelligence untuk leadership - 1-page snapshot

Frequency: Monthly Board Meeting | Users: GM, BOD, Investors

Dashboard Structure (Balanced Scorecard Approach):


                
                    Category
                    KPI
                    Target
                    Actual
                    Status
                

                    FINANCIAL
                    Revenue (Month)
                    $2.5M
                    $2.65M
                    ✅ 106%
                

                    Gross Margin %
                    35%
                    33.2%
                    ⚠️ 95%
                

                    EBITDA
                    $400K
                    $385K
                    ⚠️ 96%
                

                    Cash Flow (Operating)
                    Positive
                    +$120K
                    ✅
                

                    CUSTOMER
                    OTIF (On-Time In-Full)
                    95%
                    98.5%
                    ✅ 104%
                

                    Customer Satisfaction Score
                    4.5/5
                    4.7/5
                    ✅ 104%
                

                    Customer Complaints
                    <5
                    2
                    ✅
                

                    OPERATIONS
                    Production Volume
                    410K bd.ft
                    396K bd.ft
                    ⚠️ 97%
                

                    OEE Average
                    78%
                    76.5%
                    ⚠️ 98%
                

                    First Pass Yield
                    93%
                    91.8%
                    ⚠️ 99%
                

                    Safety Incident
                    0
                    1 (minor)
                    ⚠️
                

                    SUPPLY CHAIN
                    Inventory Turnover (Annual)
                    8x
                    7.2x
                    ⚠️ 90%
                

                    DOI (Days of Inventory)
                    45 days
                    50 days
                    ⚠️ 90%
                

                    Supplier OTIF
                    90%
                    88%
                    ⚠️ 98%
                

                    PEOPLE
                    Employee Turnover (Annual %)
                    <15%
                    12%
                    ✅
                

                    Training Hours/Person
                    40 hrs/yr
                    38 hrs YTD
                    ✅ On track
                

EXECUTIVE SUMMARY (Narrative for GM):


                ✅ STRENGTHS (Green KPIs):

                Revenue exceeded target by 6% - Demand strong, pricing holding
Customer satisfaction high (4.7/5) - Quality & delivery performing well
OTIF 98.5% - Delivery reliability excellent (industry benchmark 95%)
Low employee turnover (12%) - Team stability good

            

                ⚠️ CONCERNS (Yellow/Red KPIs):

                Margin pressure (33.2% vs 35% target):
                        Root cause: Oak log price increased 8% this month (seasonal)
Action: Procurement negotiating long-term contract to lock price
Alternative: Product mix shift to higher-margin species (Walnut)

                    
Production below target (396k vs 410k bd.ft):
                        Root cause: Milling line OEE declining (see section B above)
Action: Maintenance overhaul scheduled, target recovery in 2 weeks

                    
Inventory metrics weak (DOI 50 days vs 45 target):
                        Root cause: Over-order in anticipation of price increase + Slow-moving SKU buildup
Action: Promo campaign to clear slow-movers, tighten ordering discipline

                    
1 Safety incident (minor - finger cut):
                        Action: Safety training refresher scheduled, glove compliance audit

                    

            

                📊 PRIORITIES NEXT MONTH:

                Fix Milling Line OEE → Target: Back to 75%+ (Currently 53%)
Reduce DOI from 50 → 47 days (Clear slow-movers via promo)
Margin recovery: Lock oak price OR shift product mix
Zero safety incidents (Reinforce safety culture)

            

Category	KPI	Target	Actual	Status
FINANCIAL	Revenue (Month)	$2.5M	$2.65M	✅ 106%
Gross Margin %	35%	33.2%	⚠️ 95%
EBITDA	$400K	$385K	⚠️ 96%
Cash Flow (Operating)	Positive	+$120K	✅
CUSTOMER	OTIF (On-Time In-Full)	95%	98.5%	✅ 104%
Customer Satisfaction Score	4.5/5	4.7/5	✅ 104%
Customer Complaints	<5	2	✅
OPERATIONS	Production Volume	410K bd.ft	396K bd.ft	⚠️ 97%
OEE Average	78%	76.5%	⚠️ 98%
First Pass Yield	93%	91.8%	⚠️ 99%
Safety Incident	0	1 (minor)	⚠️
SUPPLY CHAIN	Inventory Turnover (Annual)	8x	7.2x	⚠️ 90%
DOI (Days of Inventory)	45 days	50 days	⚠️ 90%
Supplier OTIF	90%	88%	⚠️ 98%
PEOPLE	Employee Turnover (Annual %)	<15%	12%	✅
Training Hours/Person	40 hrs/yr	38 hrs YTD	✅ On track

D. Downtime Analysis Report

📋 Purpose: Deep dive into production losses - identify top causes untuk improvement

Frequency: Weekly analysis, Monthly Pareto review | Users: Maintenance, Production, PPIC

            Downtime Classification (6 Big Losses - TPM Framework):

                    Loss Category
                    Examples dalam Wood Flooring
                    Impact
                
                    1. Breakdown Losses
                    
                        • Motor burn out

                        • Chain break

                        • Bearing failure

                        • Kiln door malfunction
                    
                        Availability ↓

                        Typical: 2-5% production time loss
                    
                    2. Setup & Adjustment
                    
                        • Changeover Oak → Maple

                        • Width adjustment 3.25" → 5"

                        • Kiln loading/unloading

                        • Blade replacement
                    
                        Availability ↓

                        Typical: 3-8% production time loss
                    
                    3. Idling & Minor Stops
                    
                        • Jam at feeder (wood stuck)

                        • Sensor false trigger

                        • Waiting for forklift

                        • Material staging delay
                    
                        Performance ↓

                        Typical: 5-10% speed loss
                    
                    4. Reduced Speed
                    
                        • Running slower to avoid defects

                        • Hard wood species (slower feed)

                        • Worn blade (force slow down)

                        • Operator fatigue
                    
                        Performance ↓

                        Typical: 5-15% speed loss
                    
                    5. Startup Rejects
                    
                        • First boards after changeover (scrap)

                        • Warm-up period low quality

                        • Calibration testing
                    
                        Quality ↓

                        Typical: 1-3% material loss
                    
                    6. Production Rejects
                    
                        • Warping (kiln defect)

                        • Surface tear-out (blade dull)

                        • Dimension out of spec

                        • Finish defects
                    
                        Quality ↓

                        Typical: 2-5% material loss

Loss Category	Examples dalam Wood Flooring	Impact
1. Breakdown Losses	• Motor burn out • Chain break • Bearing failure • Kiln door malfunction	Availability ↓ Typical: 2-5% production time loss
2. Setup & Adjustment	• Changeover Oak → Maple • Width adjustment 3.25" → 5" • Kiln loading/unloading • Blade replacement	Availability ↓ Typical: 3-8% production time loss
3. Idling & Minor Stops	• Jam at feeder (wood stuck) • Sensor false trigger • Waiting for forklift • Material staging delay	Performance ↓ Typical: 5-10% speed loss
4. Reduced Speed	• Running slower to avoid defects • Hard wood species (slower feed) • Worn blade (force slow down) • Operator fatigue	Performance ↓ Typical: 5-15% speed loss
5. Startup Rejects	• First boards after changeover (scrap) • Warm-up period low quality • Calibration testing	Quality ↓ Typical: 1-3% material loss
6. Production Rejects	• Warping (kiln defect) • Surface tear-out (blade dull) • Dimension out of spec • Finish defects	Quality ↓ Typical: 2-5% material loss

📊 DOWNTIME PARETO ANALYSIS - Last Month:

Rank	Downtime Cause	Frequency	Total Hours	% of Total	Cumulative %
1	Changeover (Setup)	48x	96 hrs	32%	32%
2	Minor Stops (Jam/Stuck)	215x	72 hrs	24%	56%
3	Kiln Breakdown	3x	38 hrs	13%	69%
4	Blade Replacement	12x	24 hrs	8%	77%
5	Material Shortage	6x	18 hrs	6%	83%
6	Planned Maintenance	4x	16 hrs	5%	88%
7-15	Others (misc)	Various	36 hrs	12%	100%
TOTAL DOWNTIME			300 hrs	100%	—

KEY INSIGHT (80/20 Rule): Top 3 causes (Changeover, Minor Stops, Kiln Breakdown) account for 69% of total downtime!
Focus improvement efforts on these 3 → Maximum impact!

ACTION PLAN (Prioritized by Impact):

PRIORITY #1: Reduce Changeover Time (32% of downtime)
Current State: Avg 2 hrs per changeover × 48x/month = 96 hrs
Target: Reduce to 1 hr per changeover (SMED implementation)
Potential Savings: 48 hrs/month (16% downtime reduction!)

SMED Action Items:

Standardize changeover procedure (document best practice)
External setup: Pre-adjust blades/rollers outside machine (parallel work)
Quick-change tooling: Invest in modular blade cartridge system
Visual aids: Color-coded settings for each species/width
Team training: 2-person changeover team (not solo operator)

PRIORITY #2: Reduce Minor Stops (24% of downtime)
Current State: 215x stops × avg 20 min = 72 hrs
Target: Reduce frequency by 50% (215 → 108 stops)
Potential Savings: 36 hrs/month (12% downtime reduction)

Root Cause (Top 3 Minor Stops):

Jam at feeder (60%): Wood piece stuck → Auto-stop sensor trigger
- Solution: Adjust feeder roller pressure, install anti-jam guide
Sensor false trigger (25%): Dust accumulation on sensor
- Solution: Daily sensor cleaning (add to 5S checklist), upgrade to dust-resistant sensor
Waiting for material (15%): Forklift delay
- Solution: Dedicated material stager (1 person), FIFO lane system

PRIORITY #3: Prevent Kiln Breakdown (13% of downtime)
Current State: 3 major breakdowns × avg 12.7 hrs = 38 hrs
Target: Zero unplanned breakdown (via predictive maintenance)
Potential Savings: 38 hrs/month (13% downtime reduction)

Breakdown Analysis:

Event 1: Kiln #2 fan motor burn out (16 hrs downtime)
- Root cause: Overheating due to bearing wear (no preventive replacement)
- Prevention: Vibration monitoring, scheduled bearing replacement every 6 months
Event 2: Kiln #3 power outage (14 hrs)
- Root cause: Electrical panel failure (old equipment, 15 years)
- Prevention: Electrical system upgrade, backup generator
Event 3: Kiln #1 door seal leak (8 hrs)
- Root cause: Worn gasket (normal wear & tear)
- Prevention: Quarterly gasket inspection, proactive replacement

EXPECTED RESULTS (After Improvement):

Total downtime reduction: 48 + 36 + 38 = 122 hrs/month saved!
From 300 hrs → 178 hrs downtime (40% improvement!)
Availability improvement: From 90% → 94%
OEE impact: +4% availability × existing perf & qual = Significant!

E. Productivity Report

📋 Purpose: Measure labor & machine efficiency - benchmark performance

Frequency: Daily tracking, Weekly review, Monthly analysis | Users: Production Manager, HR, PPIC

            Key Productivity Metrics:

            1. LABOR PRODUCTIVITY

                    Metric
                    Formula
                    Benchmark (Wood Flooring)
                
                    Output per Man-Hour
                    Total bd.ft ÷ Total labor hours
                    18-22 bd.ft/man-hour
                
                    Output per Worker per Day
                    Total bd.ft ÷ Worker count ÷ Days
                    150-180 bd.ft/worker/day
                
                    Value-Added per Hour
                    Revenue ÷ Total labor hours
                    $80-120/labor-hour
                
                    Labor Cost as % Revenue
                    (Labor cost ÷ Revenue) × 100%
                    15-25%
                
            2. MACHINE PRODUCTIVITY

                    Metric
                    Formula
                    Benchmark
                
                    Output per Machine-Hour
                    Total bd.ft ÷ Machine operating hours
                    200-400 bd.ft/machine-hour (varies by process)
                
                    Machine Utilization %
                    (Actual hours / Available hours) × 100%
                    80-90%
                
                    Throughput Rate
                    Units per minute/hour
                    Sawmill: 15-25 bd.ft/min
Milling: 20-30 bd.ft/min

Metric	Formula	Benchmark (Wood Flooring)
Output per Man-Hour	Total bd.ft ÷ Total labor hours	18-22 bd.ft/man-hour
Output per Worker per Day	Total bd.ft ÷ Worker count ÷ Days	150-180 bd.ft/worker/day
Value-Added per Hour	Revenue ÷ Total labor hours	$80-120/labor-hour
Labor Cost as % Revenue	(Labor cost ÷ Revenue) × 100%	15-25%

Metric	Formula	Benchmark
Output per Machine-Hour	Total bd.ft ÷ Machine operating hours	200-400 bd.ft/machine-hour (varies by process)
Machine Utilization %	(Actual hours / Available hours) × 100%	80-90%
Throughput Rate	Units per minute/hour	Sawmill: 15-25 bd.ft/min Milling: 20-30 bd.ft/min

📊 PRODUCTIVITY REPORT - Monthly Comparison:

Department	Last Month	This Month	Change	Status
Sawmill	22 bd.ft/man-hr	24 bd.ft/man-hr	+9%	✅ Improved
Kiln Operation	850 bd.ft/worker/day	880 bd.ft/worker/day	+3.5%	✅ OK
Milling	19 bd.ft/man-hr	16 bd.ft/man-hr	-16%	🔴 DECLINING!
Finishing	18 bd.ft/man-hr	18.5 bd.ft/man-hr	+2.8%	✅ Stable
Packaging	25 bd.ft/man-hr	26 bd.ft/man-hr	+4%	✅ Good

ROOT CAUSE - Milling Productivity Drop:

Output down: 14,500 bd.ft this month vs 15,800 last month (-8%)
Labor hours up: 900 hrs this month vs 830 hrs last month (+8%)
Combined effect: -16% productivity!

Why Output Down & Hours Up?

OEE declined (Milling line issue - see Section B)
More rework hours (Quality issues → reprocess)
Overtime to try catch up target (ineffective - tired operators)

Corrective Action (Same as OEE improvement plan):
Fix Milling equipment → Restore OEE → Productivity auto-recover!

✅ BEST PRACTICE - Productivity Improvement Drivers:

Equipment Reliability (TPM): Well-maintained machines = Less downtime = Higher output per hour
Skill Development: Trained operators = Faster setup, less mistakes
Standard Work: Documented best practice = Consistency across shifts
Ergonomics: Proper workstation design = Less fatigue, faster pace
Material Flow: Smooth logistics = Less waiting time
Incentive System: Productivity-based bonus = Motivation!

2.5 QUALITY REPORTS (Laporan Kualitas)

Monitoring quality metrics untuk ensure product compliance dengan NWFA standards

A. Quality Control Report (Daily/Shift-based)

📋 Purpose: Track quality metrics per production shift - ensure NWFA/NOFMA compliance

Frequency: Per shift / Daily | Users: QC Inspector, Production Supervisor, PPIC

NWFA/NOFMA Quality Standards - Key Criteria:

Quality Aspect	NWFA/NOFMA Standard	Inspection Method
Moisture Content (MC)	• Target: 6-9% MC (depending on climate) • Tolerance: ±2% from target • CRITICAL: Measured at time of manufacture	• Hand-held moisture meter (per ASTM Standard) • Random sampling: 5 boards per 1,000 bd.ft • Both face & core reading
Machining Tolerances	For 3/4" (19mm) standard thickness: • Thickness: ±0.016" (0.4mm) • Width: ±0.031" (0.8mm) • Tongue & Groove fit: Slight contact/friction required	• Digital caliper measurement • Test fit assembly (T&G check) • Sample: 10 boards per batch
Grade Compliance	Select & Better Grade (Clear): • Free from natural defects • 5% tolerance for off-grade pieces #1 Common: • Tasteful variation, visible character #2 Common: • Prominent character marks, knots allowed	• Visual inspection per NWFA A500 guideline • Sort by grade: Clear/Select, #1, #2, Reject • Calculate grade yield %
Surface Quality	• No chipped edges, tear-out • Smooth surface (no skip, machine burn) • For prefinished: 95%+ finish adhesion (ASTM D3359)	• Visual & tactile inspection • Cross-hatch adhesion test (prefinished) • Sample: 100% visual, 5% detailed check
Average Board Length	• Minimum average length: 3.5 ft (varies by manufacturer) • No piece shorter than 9" (228.6mm) • Applied to 1,000 sq.ft shipment	• Measure sample boards • Calculate weighted average • Reject short pieces
Packaging Accuracy	• Square footage per box: Meet or exceed stated amount • No end-match allowance in coverage calculation • Proper labeling: Grade, species, MC	• Count boards per box • Calculate actual sq.ft • Verify label accuracy

Reference: NWFA/NOFMA Factory Finished Standards (Revised 2019), NWFA Technical Publication No. A500 - Grading & Packaging (1999)

📊 DAILY QUALITY CONTROL REPORT - Example:

═════════════════════════════════════════════════════════════
           DAILY QUALITY CONTROL REPORT
═════════════════════════════════════════════════════════════
Date: Feb 3, 2026          Shift: Day (07:00-15:00)
Inspector: John Smith      Product: Oak 3.25" Select & Better

1. MOISTURE CONTENT TEST (Target: 6-8% MC)
┌──────────────────────────────────────────────────────────┐
│ Sample │ Location      │ MC Reading│ Status             │
├──────────────────────────────────────────────────────────┤
│ Batch 1│ Start shift   │   7.2%    │ ✅ OK              │
│ Batch 2│ Mid shift     │   7.8%    │ ✅ OK              │
│ Batch 3│ End shift     │   9.5%    │ ⚠️ HIGH (limit 9%)│
└──────────────────────────────────────────────────────────┘
ACTION: Batch 3 sent back to kiln for re-equilibration

2. DIMENSION TOLERANCE CHECK
Sample: 30 boards random selection
┌──────────────────────────────────────────────────────────┐
│ Parameter      │ Target      │ Avg Actual │ Status      │
├──────────────────────────────────────────────────────────┤
│ Thickness      │ 0.750"      │ 0.748"     │ ✅ (±0.016")│
│ Width          │ 3.250"      │ 3.255"     │ ✅ (±0.031")│
│ T&G Fit        │ Friction fit│ 28/30 OK   │ ✅ 93% pass │
└──────────────────────────────────────────────────────────┘
REJECT: 2 boards (T&G too loose) → Rework or downgrade

3. GRADE YIELD ANALYSIS
Total input: 15,000 bd.ft (pre-sorted rough lumber)
┌──────────────────────────────────────────────────────────┐
│ Grade Output       │ Qty (bd.ft)│ Yield %│ Target %   │
├──────────────────────────────────────────────────────────┤
│ Select & Better    │   10,500   │  70%   │ ✅ 65-75% │
│ #1 Common          │    2,800   │  19%   │ ✅ 15-20% │
│ #2 Common          │      900   │   6%   │ ✅ 5-10%  │
│ Reject/Rework      │      800   │   5%   │ ✅ <6%    │
└──────────────────────────────────────────────────────────┘
COMMENT: Grade distribution excellent, within spec

4. SURFACE DEFECTS TRACKING
Total inspected: 14,500 bd.ft (good boards)
┌──────────────────────────────────────────────────────────┐
│ Defect Type        │ Count  │ Rate   │ Limit  │ Status  │
├──────────────────────────────────────────────────────────┤
│ Chipped Edge       │   45   │ 0.31%  │ <1%    │ ✅ OK   │
│ Surface Tear-out   │   22   │ 0.15%  │ <0.5%  │ ✅ OK   │
│ Machine Burn       │    8   │ 0.06%  │ <0.2%  │ ✅ OK   │
│ Skip (Rough patch) │   15   │ 0.10%  │ <0.3%  │ ✅ OK   │
└──────────────────────────────────────────────────────────┘
TOTAL DEFECT RATE: 0.62% (Target: <2%) ✅ PASS

5. SUMMARY & ACTION ITEMS
✅ PASS: Grade yield, surface quality, dimensions
⚠️  CAUTION: Batch 3 MC high (9.5%) → Re-equalize
📋 Action: Monitor kiln temperature (may be over-drying)
🔧 Maintenance: Planer blade #2 showing wear → Schedule replacement

QC INSPECTOR SIGN-OFF: John Smith
PRODUCTION SUPERVISOR APPROVAL: Jane Doe
═════════════════════════════════════════════════════════════

B. Defect Analysis Report (Weekly/Monthly)

📋 Purpose: Deep dive into quality issues - identify root causes & corrective actions

Frequency: Weekly summary, Monthly trend analysis | Users: QC Manager, Plant Manager, PPIC

Common Wood Flooring Defects - Classification & Causes:

Defect Type	Description & Causes	Prevention & Corrective Action
CUPPING	Appearance: Board edges raised higher than center (U-shape) Causes: • Moisture imbalance (bottom wetter than top) • MC > 12% at installation • High humidity after installation • Moisture from subfloor/concrete (Chen et al., 2015; Wagner Meters, 2024)	Prevention: • Strict MC control: 6-9% before shipping • Proper acclimation (7-14 days on-site) • Vapor barrier under flooring • HVAC system operational before install If occurs: • Identify moisture source → Fix leak/humidity • Allow floor to dry gradually • Monitor with hygrometer • Sand ONLY after MC stabilizes
CROWNING	Appearance: Board center raised higher than edges (Λ-shape) Causes: • Sanding a cupped floor prematurely • Water exposure on top surface • Top of board wetter than bottom (BuildDirect; City Floor Supply, 2024)	Prevention: • NEVER sand cupped floor without drying first! • Protect floor from water spills • Proper finish application If occurs: • Assess moisture - may need replacement • Light sanding after MC normalizes • Worst case: Board replacement
BUCKLING	Appearance: Boards lift off subfloor, creating humps/peaks Causes: • Severe moisture exposure (flooding, leaks) • Insufficient expansion gap at walls • No acclimation before installation • Adhesive failure (US Vintage Wood, 2025)	Prevention: • Minimum 1/2" expansion gap at perimeter • Proper acclimation (match site RH%) • Quality adhesive, correct application • Subfloor MC test before install If occurs: • Remove affected boards • Dry subfloor thoroughly • Install new boards with proper gap
CHECKING (Surface Cracks)	Appearance: Lengthwise cracks on board surface Causes: • Too-fast kiln drying schedule • MC drop too rapid (>4% per day) • Low relative humidity exposure • Wood species prone to checking (Oak, Ash) (Chen et al., 2015; Decks.com, 2025)	Prevention: • Gradual kiln drying (25-30 days for 4/4) • Monitor MC daily during drying • Equalization period at kiln end • Maintain RH% 40-60% in storage If occurs: • Minor checks: Accept (within #1 Common grade) • Severe: Downgrade or reject
WARPING (Twist, Bow, Crook)	Appearance: Board doesn't lie flat, various distortions Causes: • Grain orientation (not parallel to edge) • Uneven drying (stress relief) • Cut too close to pith • Improper storage (no stickers, uneven weight) (Decks.com, 2025)	Prevention: • Select proper grain pattern (quarter-sawn more stable) • Uniform kiln loading & airflow • Proper stickering during air-dry/storage • Avoid cutting boards with juvenile wood If occurs: • Minor bow: Can force flat during install • Severe twist: REJECT (cannot be fixed)
MACHINE BURN	Appearance: Dark discoloration from overheated blades Causes: • Dull planer/moulder knives • Excessive feed pressure • Too-slow feed rate (Decks.com, 2025)	Prevention: • Regular knife sharpening schedule • Optimize feed speed • Monitor knife temp (infrared gun) If occurs: • Light burn: Sand out • Heavy burn: Downgrade or reject
FINISH DEFECTS (Prefinished)	Types: • Bubbles, pinholes • Lines, streaks • Uneven color • Poor adhesion (peeling) Causes: • Contaminated surface (dust, oil) • Improper UV curing time/intensity • Wrong viscosity (too thick/thin) • Application temperature out of spec	Prevention: • Clean room environment (dust control) • Surface prep: Fine sanding (120-150 grit) • UV lamp maintenance & calibration • Temperature control 60-80°F • Viscosity check per batch NWFA Standard: 95%+ adhesion (ASTM D3359 cross-hatch test)

References: Chen et al. (2015) - BioResources; Wagner Meters (2024); BuildDirect; City Floor Supply (2024); US Vintage Wood (2025); Decks.com (2025)

📊 MONTHLY DEFECT ANALYSIS REPORT - Example:

EXECUTIVE SUMMARY - January 2026:

Total production: 410,000 bd.ft
Total rejects: 8,200 bd.ft (2.0% reject rate)
First Pass Yield: 98.0% (Target: 95%+) ✅
Cost of Poor Quality: $18,450 (material + rework labor)

DEFECT PARETO ANALYSIS:

Rank	Defect Type	Frequency	Qty (bd.ft)	% of Total	Cumulative %
1	Surface Checking	1,250 pcs	3,750 bd.ft	45.7%	45.7%
2	Cupping (MC >10%)	800 pcs	2,400 bd.ft	29.3%	75.0%
3	Machine Burn	450 pcs	1,350 bd.ft	16.5%	91.5%
4	Chipped Edges	200 pcs	600 bd.ft	7.3%	98.8%
5-10	Others (twist, skip, etc.)	~33 pcs	100 bd.ft	1.2%	100%
TOTAL DEFECTS			8,200 bd.ft	100%	—

KEY INSIGHT: Top 3 defects (Checking, Cupping, Machine Burn) = 91.5% of total rejects!

ROOT CAUSE ANALYSIS & CORRECTIVE ACTIONS:

PRIORITY #1: Surface Checking (45.7% of defects)

5 Whys Analysis:

Why checking? → Kiln drying too fast
Why too fast? → Temperature increased from 140°F to 160°F
Why increased? → New kiln operator not following schedule
Why not following? → Training incomplete, no SOP posted
Why no SOP? → Documentation gap (assumed knowledge)

ROOT CAUSE: Inadequate training & lack of SOP visibility

CORRECTIVE ACTIONS:

Immediate (Week 1):
- Post kiln schedule SOP at each kiln (laminated poster, large font)
- Retrain all kiln operators (8 hrs hands-on)
- Revert to proven schedule: Max temp 140°F, gradual ramp
Short-term (Month 1):
- Install automated kiln controller (PLC-based, prevent manual override)
- Daily MC check DURING drying (not just at end)
- Supervisor sign-off on each kiln cycle start
Long-term (Quarter 1):
- Develop comprehensive kiln operator certification program
- Monthly competency assessment
- Implement SPC (Statistical Process Control) for kiln MC tracking

TARGET REDUCTION: 3,750 bd.ft → 1,500 bd.ft (-60%) by end Q1

PRIORITY #2: Cupping (29.3% of defects)

Fishbone Diagram Analysis:

Material: Some log batches from Supplier B consistently higher MC (12% vs 8% target)
Method: Kiln equalization period too short (2 days vs should be 3-4 days)
Environment: Warehouse RH% fluctuates 40-70% (should be 45-55%)
Measurement: MC meter not calibrated in 6 months (accuracy drift?)

ROOT CAUSE: Multi-factorial (supplier variation + process + storage)

CORRECTIVE ACTIONS:

Supplier Management:
- Audit Supplier B kiln process
- Require MC certificate with each shipment (5 random samples)
- Penalty clause: >2% MC variance → 5% discount
Process Improvement:
- Extend equalization period: 2 days → 4 days minimum
- Implement kiln MC gradient test (measure core vs surface differential)
- Hold lumber 24 hrs post-kiln before milling (final equilibration)
Storage Environment:
- Install warehouse dehumidifier (target: RH 45-55% constant)
- RH% datalogger (continuous monitoring, alert if out of range)
- Stack lumber with proper air circulation (avoid plastic wrap until ship)
Equipment Calibration:
- Calibrate ALL MC meters (quarterly schedule)
- Use calibration blocks (known MC reference)
- Document calibration in logbook

TARGET REDUCTION: 2,400 bd.ft → 1,000 bd.ft (-58%) by end Q1

PRIORITY #3: Machine Burn (16.5% of defects)

ROOT CAUSE: Planer knife dull (overdue for sharpening by 2 weeks)

CORRECTIVE ACTIONS:

Immediate: Replace ALL planer knives → Fresh sharp knives installed
Preventive Maintenance:
- Strict knife change schedule: Every 40 operating hours (no exceptions!)
- Visual inspection hourly (operator checklist)
- Knife life tracking log (hours used, date changed)
Process Optimization:
- Reduce feed rate if hard species (Oak, Maple) → Prevent knife overheating
- Monitor knife temperature with infrared thermometer
- Cooling air blast system (reduce friction heat)

TARGET REDUCTION: 1,350 bd.ft → 400 bd.ft (-70%) by Month 2

EXPECTED OVERALL IMPROVEMENT:

Current reject rate: 2.0%
Target after improvements: 1.0% (50% reduction)
Cost savings: $9,000/month (avoided material waste + rework)
Quality reputation improvement → Higher Select & Better grade % → Premium pricing!

C. Customer Complaint Report (Monthly)

📋 Purpose: Track customer quality issues - prevent recurrence, maintain brand reputation

Frequency: Weekly log, Monthly summary & trend analysis | Users: QC Manager, Customer Service, Sales, GM

            Customer Complaint Categories - Wood Flooring:

                    Complaint Type
                    Common Customer Descriptions
                    Severity Level
                
                    Dimensional Issues
                    
                        "Boards won't fit together"

                        "Tongue & groove too loose/tight"

                        "Width inconsistent"

                        "Thickness varies - floor not level"
                    
                    🔴 HIGH
(Installation failure)
                
                    Moisture-Related Defects
                    
                        "Floor cupping after install"

                        "Gaps between boards in winter"

                        "Boards warping/buckling"

                        "Finish cracking/peeling"
                    
                    🔴 CRITICAL
(Warranty claim, refund risk)
                
                    Appearance/Grade Issues
                    
                        "Too many knots (ordered Select, got #1)"

                        "Color variation excessive"

                        "Grain pattern not as expected"

                        "Some boards have defects"
                    
                    🟡 MEDIUM
(Customer dissatisfaction)
                
                    Surface Quality
                    
                        "Rough patches, skip marks"

                        "Machine burn visible"

                        "Chipped edges"

                        "Finish uneven (prefinished)"
                    
                    🟡 MEDIUM
(Replacement needed)
                
                    Packaging/Shipping
                    
                        "Boards damaged in transit"

                        "Wrong species/grade shipped"

                        "Square footage short"

                        "Mixed lengths/widths"
                    
                    🟢 LOW
(Easy fix - reship)

Complaint Type	Common Customer Descriptions	Severity Level
Dimensional Issues	"Boards won't fit together" "Tongue & groove too loose/tight" "Width inconsistent" "Thickness varies - floor not level"	🔴 HIGH (Installation failure)
Moisture-Related Defects	"Floor cupping after install" "Gaps between boards in winter" "Boards warping/buckling" "Finish cracking/peeling"	🔴 CRITICAL (Warranty claim, refund risk)
Appearance/Grade Issues	"Too many knots (ordered Select, got #1)" "Color variation excessive" "Grain pattern not as expected" "Some boards have defects"	🟡 MEDIUM (Customer dissatisfaction)
Surface Quality	"Rough patches, skip marks" "Machine burn visible" "Chipped edges" "Finish uneven (prefinished)"	🟡 MEDIUM (Replacement needed)
Packaging/Shipping	"Boards damaged in transit" "Wrong species/grade shipped" "Square footage short" "Mixed lengths/widths"	🟢 LOW (Easy fix - reship)

📊 MONTHLY CUSTOMER COMPLAINT REPORT - Example:

SUMMARY - January 2026:

Total orders shipped: 520 orders (1,200,000 bd.ft)
Total complaints received: 18 cases
Complaint rate: 3.46% of orders (Target: <5%) ✅
Resolution time avg: 4.2 days (Target: <7 days) ✅

COMPLAINT BREAKDOWN BY TYPE:

Complaint Type	Cases	% of Total	Refund/Replace	Cost Impact
Moisture-Related (Cupping)	7	38.9%	5 Refund, 2 Replace	$8,500
Grade Mismatch	4	22.2%	4 Replace	$2,400
Dimensional Issues	3	16.7%	3 Replace	$1,800
Surface Defects	2	11.1%	2 Replace	$800
Shipping Damage	2	11.1%	2 Replace	$600
TOTAL	18	100%	—	$14,100

DETAILED CASE STUDY - Cupping Complaint #1:

Case ID: CC-2026-001
Customer: ABC Flooring Contractor
Product: Oak 3.25" Select & Better, 5,000 bd.ft
Complaint Date: Jan 15, 2026 (30 days after delivery)

Customer Report:
"Installed flooring in client's home. After 2 weeks, 60% of floor showing cupping (edges raised). Client very unhappy, demanding redo. Need replacement or refund ASAP!"

INVESTIGATION (by QC Team + NWFA Certified Inspector):

Factory Records Review:
- Production batch: Jan 2-5, 2026
- MC at shipping: 7.8% (within 6-9% spec) ✅
- QC inspection report: PASS (no defects noted)
On-Site Inspection (Jan 18):
- Visual: Confirmed cupping throughout (edges 3-5mm higher than center)
- MC test: Floor boards 14-16% MC! (Excessive!)
- Subfloor MC test: Concrete slab 8% MC (OK per NWFA)
- Room RH%: 75% (Extremely high!)
- HVAC status: NOT OPERATIONAL (new construction, HVAC not turned on yet)
Installer Interview:
- Q: "Did you acclimate flooring before install?"
  A: "Yes, stored in house 3 days"
- Q: "Was HVAC running during acclimation?"
  A: "No, HVAC not installed yet"
- Q: "Did you test subfloor MC before install?"
  A: "No, concrete looked dry"

ROOT CAUSE DETERMINATION:

PRIMARY CAUSE: Improper installation (NWFA guideline violation)
- Floor installed BEFORE HVAC operational
- Acclimation in non-controlled environment (RH 75%!)
- No subfloor moisture test performed
CONTRIBUTING CAUSE: Lack of installer education
- Installer not NWFA certified
- Did not follow NWFA installation guidelines
MANUFACTURER RESPONSIBILITY: None (product met all specs at shipping)

RESOLUTION:

Technical Consultation: PPIC provided NWFA guideline document to installer
Recommendation:
- Turn on HVAC, stabilize room conditions (RH 45-55%, Temp 60-80°F)
- Wait 4-6 weeks for floor to equilibrate
- Re-measure MC - if returns to 6-9%, cupping should relax naturally
- ONLY if cupping persists after MC stabilizes → Sand & refinish
Warranty Decision:
- Manufacturer warranty: VOID (installation error, not product defect)
- Goodwill gesture: Provide technical support + 10% discount on future order
- NO refund/replacement (not manufacturer fault)

OUTCOME (Follow-up - Feb 20):

HVAC operational since Jan 25
Room stabilized at RH 48%, Temp 68°F
Floor MC dropped to 8.5% by Feb 15
Cupping reduced by 80% (minor residual cupping accepted by client)
No sanding needed!
Customer (contractor) satisfied with technical support ✅

LESSONS LEARNED & PREVENTIVE ACTIONS:

Customer Education Program:
- Create "Installation Best Practices" one-page guide (include with every shipment)
- NWFA guideline summary printed on box label
- QR code → link to NWFA installation video
Installer Certification Incentive:
- Offer 5% discount to NWFA-certified installers
- Build database of certified installers → referral program
Pre-Shipment Customer Checklist:
- Sales team to ask: "Is HVAC operational at install site?"
- If NO → Warning: "Floor must acclimate AFTER HVAC running for 1 week minimum"
- Require customer sign-off on checklist → Protect warranty

2.6 DELIVERY REPORTS (Laporan Pengiriman)

Monitoring delivery performance untuk ensure customer satisfaction dan OTIF achievement

A. Shipment Status Report (Daily/Real-time)

📋 Purpose: Track status pengiriman real-time dari warehouse sampai customer site - critical untuk customer communication!

Frequency: Real-time update / Daily consolidation | Users: Logistics Coordinator, Customer Service, Sales, PPIC

            🚚 SHIPMENT LIFECYCLE - Tracking Stages:

                    Stage
                    Status
                    Typical Duration
                    Action Owner
                
                    1. Order Received
                    📝 Processing
                    0-4 hours (order entry & validation)
                    Customer Service
                
                    2. Stock Allocation
                    📦 Reserved
                    1-8 hours (check ATP, reserve inventory)
                    PPIC / Warehouse
                
                    3. Picking & Packing
                    📋 Preparing
                    4-24 hours (depends on volume)
                    Warehouse Team
                
                    4. Quality Check
                    ✅ QC Passed
                    1-4 hours (final inspection)
                    QC Inspector
                
                    5. Documentation
                    📄 Documents Ready
                    2-6 hours (invoice, packing list, CoA)
                    Admin
                
                    6. Loading
                    🚛 In Transit
                    0.5-2 hours (truck loading)
                    Warehouse + Logistics
                
                    7. On Route
                    🛣️ En Route
                    
                        • Local (same city): 4-8 hours

                        • Regional (Java): 1-3 days

                        • National: 3-7 days

                        • Export: 14-30 days (sea freight)
                    
                    3PL / Own Fleet
                
                    8. Delivered
                    ✅ POD Received
                    —
                    Customer + Logistics
                
                    9. Invoiced
                    💰 Payment Due
                    Payment term: NET 30/60 days
                    Finance

Stage	Status	Typical Duration	Action Owner
1. Order Received	📝 Processing	0-4 hours (order entry & validation)	Customer Service
2. Stock Allocation	📦 Reserved	1-8 hours (check ATP, reserve inventory)	PPIC / Warehouse
3. Picking & Packing	📋 Preparing	4-24 hours (depends on volume)	Warehouse Team
4. Quality Check	✅ QC Passed	1-4 hours (final inspection)	QC Inspector
5. Documentation	📄 Documents Ready	2-6 hours (invoice, packing list, CoA)	Admin
6. Loading	🚛 In Transit	0.5-2 hours (truck loading)	Warehouse + Logistics
7. On Route	🛣️ En Route	• Local (same city): 4-8 hours • Regional (Java): 1-3 days • National: 3-7 days • Export: 14-30 days (sea freight)	3PL / Own Fleet
8. Delivered	✅ POD Received	—	Customer + Logistics
9. Invoiced	💰 Payment Due	Payment term: NET 30/60 days	Finance

📊 DAILY SHIPMENT STATUS REPORT - Example:

═══════════════════════════════════════════════════════════════════════════
              DAILY SHIPMENT STATUS REPORT
═══════════════════════════════════════════════════════════════════════════
Date: Feb 3, 2026                    Report Time: 16:00 WIB

SUMMARY DASHBOARD:
┌──────────────────────────────────────────────────────────────────────┐
│ Status           │ Count │ Volume (m²) │ Revenue (Rp)  │ % Total    │
├──────────────────────────────────────────────────────────────────────┤
│ Processing       │   12  │     850     │   850,000,000 │    8%      │
│ Preparing        │   18  │   1,420     │ 1,420,000,000 │   13%      │
│ QC Passed        │    8  │     680     │   680,000,000 │    6%      │
│ Ready to Ship    │    5  │     425     │   425,000,000 │    4%      │
│ In Transit       │   35  │   4,250     │ 4,250,000,000 │   40%      │
│ Delivered Today  │   22  │   2,890     │ 2,890,000,000 │   27%      │
│ Delayed (Alert!) │    3  │     185     │   185,000,000 │    2%      │
├──────────────────────────────────────────────────────────────────────┤
│ TOTAL ACTIVE    │  103  │  10,700     │10,700,000,000 │  100%      │
└──────────────────────────────────────────────────────────────────────┘

CRITICAL ALERTS - DELAYED SHIPMENTS:
┌──────────────────────────────────────────────────────────────────────┐
│ DO No      │ Customer            │ Due Date │ Delay  │ Reason       │
├──────────────────────────────────────────────────────────────────────┤
│ DO-26-0158 │ PT Graha Properti   │ Feb 1    │ 2 days │ Truck broke  │
│ DO-26-0162 │ CV Jaya Konstruksi  │ Feb 2    │ 1 day  │ Traffic jam  │
│ DO-26-0171 │ Toko Kayu Sentosa   │ Feb 3    │ Today  │ Wrong route  │
└──────────────────────────────────────────────────────────────────────┘

ACTION TAKEN:
- DO-26-0158: Backup truck dispatched, ETA tomorrow 10:00
- DO-26-0162: Customer informed, accepted delay (weekend delivery)
- DO-26-0171: Driver redirected, will arrive before 18:00 today

TODAY'S DELIVERIES COMPLETED (Sample - Top 5 by Value):
┌──────────────────────────────────────────────────────────────────────┐
│ DO No      │ Customer              │ Volume │ POD Time │ Status     │
├──────────────────────────────────────────────────────────────────────┤
│ DO-26-0145 │ Hotel Grand Mahakam   │  450 m²│  09:35   │ ✅ On-time │
│ DO-26-0149 │ Apartemen The Peak    │  385 m²│  11:20   │ ✅ On-time │
│ DO-26-0153 │ Showroom Mewah Auto   │  320 m²│  13:45   │ ✅ On-time │
│ DO-26-0156 │ Villa Bali Seminyak   │  285 m²│  10:15   │ ✅ Early!  │
│ DO-26-0160 │ Kantor Pusat BCA      │  250 m²│  14:30   │ ✅ On-time │
└──────────────────────────────────────────────────────────────────────┘

PENDING SHIPMENTS (Tomorrow Schedule):
- 15 orders queued for Feb 4 dispatch
- Total volume: 1,850 m² (8 trucks required)
- All inventory allocated ✅
- Documentation 90% complete

NOTES:
- OTIF Rate Today: 95.2% (22 on-time / 23 total deliveries)
- Average delivery time: 2.3 days (vs target 3 days) ✅
- Customer complaints: 0 (related to delivery)
═══════════════════════════════════════════════════════════════════════

⚠️ COMMON DELIVERY ISSUES - Root Causes & Prevention:

Issue Type	Root Causes	Prevention Strategy
Late Picking	• Warehouse congestion • Stock not organized (FIFO) • Manpower shortage • Forklift breakdown	• 5S implementation • Dedicated picking zone • Backup forklift ready • Daily manpower planning
Documentation Error	• Wrong item listed • Quantity mismatch • Missing CoA/certificate • Address typo	• Barcode scanning (auto-populate) • Double-check SOP • Template standardization • ERP validation rules
Transit Delay	• Traffic congestion • Vehicle breakdown • Weather (flood, landslide) • Wrong routing	• GPS tracking + route optimization • Fleet maintenance schedule • Weather forecast monitoring • Driver training on alt. routes
Delivery Rejection	• Damage during transit • Wrong item shipped • Customer not ready (site issue) • No receiving person	• Proper packaging (foam, cardboard) • Loading SOP (no overstack) • Delivery appointment confirmation • Backup contact person

B. Order Fulfillment Report (Weekly/Monthly)

📋 Purpose: Analyze order fulfillment performance - measure capability untuk meet customer demand

Frequency: Weekly review, Monthly trend analysis | Users: Sales Manager, PPIC Manager, Customer Service Head, GM

            📊 ORDER FULFILLMENT METRICS - Key Performance Indicators:

                    KPI
                    Formula
                    Target
                    Importance
                
                    Order Fill Rate (OFR)
                    
                        (Orders shipped complete / Total orders) × 100%

                        Measuring: Ability to fulfill entire order
                    
                    95-98%
                    🔴 CRITICAL
                
                    Line Fill Rate
                    
                        (Order lines shipped / Total order lines) × 100%

                        Measuring: Item-level fulfillment
                    
                    97-99%
                    🟡 HIGH
                
                    Unit Fill Rate
                    
                        (Units shipped / Units ordered) × 100%

                        Measuring: Quantity accuracy
                    
                    98-99.5%
                    🟡 HIGH
                
                    Perfect Order Rate
                    
                        Orders with:

                        • Complete quantity ✅

                        • On-time delivery ✅

                        • Damage-free ✅

                        • Correct documentation ✅
                    
                    92-96%
                    🔴 CRITICAL
                
                    Backorder Rate
                    
                        (Orders with backorder / Total orders) × 100%

                        Lower is better!
                    
                    <5%
                    🟢 MEDIUM
                
                    Order Cycle Time
                    
                        Avg days from order receipt → delivery

                        Speed of fulfillment
                    
                        • Stock: 3-5 days

                        • MTO: 35-45 days
                    
                    🟡 HIGH

KPI	Formula	Target	Importance
Order Fill Rate (OFR)	(Orders shipped complete / Total orders) × 100% Measuring: Ability to fulfill entire order	95-98%	🔴 CRITICAL
Line Fill Rate	(Order lines shipped / Total order lines) × 100% Measuring: Item-level fulfillment	97-99%	🟡 HIGH
Unit Fill Rate	(Units shipped / Units ordered) × 100% Measuring: Quantity accuracy	98-99.5%	🟡 HIGH
Perfect Order Rate	Orders with: • Complete quantity ✅ • On-time delivery ✅ • Damage-free ✅ • Correct documentation ✅	92-96%	🔴 CRITICAL
Backorder Rate	(Orders with backorder / Total orders) × 100% Lower is better!	<5%	🟢 MEDIUM
Order Cycle Time	Avg days from order receipt → delivery Speed of fulfillment	• Stock: 3-5 days • MTO: 35-45 days	🟡 HIGH

📊 MONTHLY ORDER FULFILLMENT REPORT - January 2026:

EXECUTIVE SUMMARY:

Total Orders Received: 520 orders
Total Order Value: Rp 7,184,300,000
Average Order Size: 1,231 m² (Rp 13.8 juta)

FULFILLMENT PERFORMANCE:

KPI	Target	Actual	Status	vs Last Month
Order Fill Rate	96%	97.3%	✅ PASS	+1.2%
Line Fill Rate	98%	98.8%	✅ PASS	+0.5%
Unit Fill Rate	98.5%	99.2%	✅ EXCELLENT	+0.4%
Perfect Order Rate	94%	92.7%	⚠️ NEAR TARGET	-1.8%
Backorder Rate	<5%	3.2%	✅ PASS	-0.8%
Avg Cycle Time	4 days	3.8 days	✅ BETTER	-0.3 days

ROOT CAUSE ANALYSIS - Perfect Order Rate 92.7% (Below Target 94%):

BREAKDOWN: Why 38 orders (7.3%) were NOT perfect?

Failure Reason	Count	% of Imperfect	Impact
Late Delivery (1-2 days)	18	47.4%	OTIF miss
Partial Shipment (backorder)	12	31.6%	Incomplete order
Damage in Transit	5	13.2%	Replacement needed
Wrong Documentation	3	7.9%	Admin rework

CORRECTIVE ACTIONS:

Late Delivery (18 cases):
- Root cause: 60% traffic issue, 40% internal delay (warehouse picking)
- Action: Implement GPS routing optimization, warehouse layout redesign (reduce picking time 20%)
Partial Shipment (12 cases):
- Root cause: Stockout pada specific SKU (niche sizes)
- Action: Improve safety stock calculation, prioritize production untuk high-demand SKU
Damage in Transit (5 cases):
- Root cause: Packaging insufficient untuk long-distance shipment (>500 km)
- Action: Upgrade packaging untuk long-haul orders (double cardboard, foam insert)

BACKORDER ANALYSIS (3.2% of orders):

SKU Type	Backorder Cases	Avg Delay (days)	Action Plan
Wide Plank (150mm+)	8	7 days	Increase safety stock 20%
Premium Walnut	4	14 days	Supplier contract untuk faster delivery
Engineered Click-Lock	3	10 days	Build-to-stock strategy (was MTO)
Custom Stain Color	2	21 days	OK (MTO acceptable delay)

✅ POSITIVE HIGHLIGHTS:

Unit Fill Rate 99.2%: Excellent quantity accuracy (only 0.8% quantity variance)
Cycle Time 3.8 days: Faster than target 4 days → Customer satisfaction ↑
Backorder Rate 3.2%: Below target 5% → Inventory planning effective

TARGET NEXT MONTH: Perfect Order Rate 94%+ (current 92.7%)
Focus: Reduce late delivery via route optimization + packaging upgrade

C. On-Time Delivery (OTIF) Report

📋 Purpose: Measure delivery reliability - THE most important metric untuk customer trust & retention!

Frequency: Daily dashboard, Weekly trend, Monthly executive review | Users: All stakeholders (GM, Sales, Ops, PPIC, Logistics)

📈 OTIF (On-Time In-Full) - Industry Gold Standard:

OTIF (%) = (Orders delivered On-Time AND In-Full / Total Orders) × 100%

Definisi "On-Time":

Delivered on or before committed delivery date
Within delivery window if specified (e.g., 08:00-17:00)
Grace period: None! (On-time = exact date, not "1 day late")

Definisi "In-Full":

100% of ordered quantity delivered
100% of ordered line items included
Correct product (species, grade, dimension)
Damage-free (quality check passed)

Industry Sector	OTIF Benchmark	Notes
Automotive	98-99%	Very strict (JIT manufacturing)
Retail / FMCG	95-97%	High volume, fast turnover
Building Materials (Wood Flooring)	92-96%	Project-based, some flexibility
Furniture	90-94%	Custom orders, longer lead time

Source: Supply Chain Benchmarking (Gartner, APQC, 2024)

📊 MONTHLY OTIF PERFORMANCE REPORT - January 2026:

OVERALL PERFORMANCE:

Metric	Jan 2026	Dec 2025	Change	YTD
OTIF %	94.8%	93.5%	+1.3%	94.8%
On-Time % (only)	96.2%	95.8%	+0.4%	96.2%
In-Full % (only)	98.5%	97.6%	+0.9%	98.5%
Total Orders	520	485	+35	520
OTIF Orders	493	453	+40	493
Failed OTIF	27	32	-5	27

FAILURE MODE ANALYSIS - 27 Failed OTIF Orders:

Failure Type	Count	%	Root Cause	Accountability
Late (On-Time fail)	19	70.4%	• Traffic/weather: 8 cases • Production delay: 6 cases • Warehouse delay: 5 cases	Logistics (42%) Operations (32%) Warehouse (26%)
Incomplete (In-Full fail)	5	18.5%	• Stockout: 3 cases • Quality reject: 2 cases	PPIC (60%) QC (40%)
Both (Late + Incomplete)	3	11.1%	• Rush order mis-managed: 3 cases	Cross-functional
TOTAL	27	100%	—	—

DEEP DIVE - Top 3 Failure Root Causes:

FAILURE #1: Traffic/Weather Delays (8 cases, 29.6%):

Case Study - DO-26-0158:

Customer: PT Graha Properti (Hotel project - Surabaya)
Committed Date: Feb 1, 08:00
Actual Delivery: Feb 3, 14:30 (2.3 days late!)
Route: Jombang → Surabaya (120 km, normally 2.5 hours)

Timeline:

Jan 31, 14:00: Truck depart from warehouse
Jan 31, 16:30: Truck breakdown (engine overheat) at Km 45
Jan 31, 18:00: Mechanic called, repair ETA 2 hours
Jan 31, 22:00: Repair complete, but driver exceed driving hours (safety regulation)
Feb 1, 06:00: Driver rest complete, resume journey
Feb 1, 09:00: Arrive customer site, REJECTED! (receiving hours 08:00-17:00, but customer not ready until Feb 3)

Root Cause:

Preventive maintenance gap → truck breakdown (should've been serviced 2 weeks ago!)
No backup truck protocol → delay escalated
Poor communication → customer not informed proactively

Corrective Action:

Implement strict fleet maintenance schedule (every 5,000 km or monthly)
Standby backup truck policy (10% of fleet on standby)
Proactive customer notification SOP (inform within 1 hour of delay)

FAILURE #2: Production Delay (6 cases, 22.2%):

Root Cause Pattern:

Kiln breakdown (3 cases) → Drying delayed 3 days
Material shortage (2 cases) → Log supplier late 5 days
Quality issue (1 case) → Batch reject, need re-production

Impact Chain:
Production delay → Cannot meet committed ship date → Late delivery → OTIF fail

Prevention (Linked to Section 2.4 - OEE & Downtime):

TPM program untuk reduce kiln breakdown
Supplier performance management (penalty for late delivery)
Buffer stock policy untuk critical SKUs

FAILURE #3: Warehouse Picking Delay (5 cases, 18.5%):

Bottleneck Analysis:

Peak order volume week (Jan 15-19): 120 orders in 5 days (normal: 90)
Warehouse capacity: 25 orders/day comfortable, 30 max
Actual demand: 24 orders/day avg, but peaked at 32 on Jan 17!
Result: 5 orders delayed 1 day (picked on next day)

Solution:

Flexible manpower: Part-time pickers untuk peak periods
Advanced warning system: Sales forecast visibility 1 week ahead
Pre-picking for known orders: Allocate stock 1 day in advance

✅ OTIF IMPROVEMENT PLAN - Target: 96% by Q2 2026:

3-Month Roadmap:

Month 1 (Feb 2026):
- Fleet maintenance blitz (service all trucks)
- Implement GPS tracking + route optimization software
- Warehouse layout redesign (reduce picking time 20%)
- Target OTIF: 95.5%
Month 2 (Mar 2026):
- TPM program launch (kiln reliability ↑)
- Backup truck protocol finalized
- Flexible warehouse staffing model
- Target OTIF: 95.8%
Month 3 (Apr 2026):
- Customer communication automation (delay alerts)
- Safety stock optimization (reduce stockout)
- Cross-training warehouse team (multi-skilled)
- Target OTIF: 96%+

Expected Impact:
OTIF 94.8% → 96% = 1.2% improvement = 6 additional perfect orders per month
Revenue protected: 6 orders × Rp 13.8M avg = Rp 82.8M/month (prevented customer loss!)

2.7 COST & EFFICIENCY REPORTS (Laporan Biaya & Efisiensi)

Analisis biaya produksi, efisiensi material, dan evaluasi performa keuangan manufaktur lantai kayu

A. Material Efficiency Report (Yield Analysis)

📋 Purpose: Menganalisis efisiensi penggunaan bahan baku kayu dari log hingga produk jadi - critical untuk cost control!

Frequency: Monthly analysis | Users: PPIC Manager, Operations Director, Finance, Procurement

🌳 YIELD FACTOR dalam Industri Lantai Kayu - Konsep Fundamental:

Definisi Yield: Persentase output produk jadi yang dihasilkan dari input bahan baku (log kayu)

Yield (%) = (Output Finished Product / Input Raw Material) × 100%

Industri Lantai Kayu = MULTI-STAGE CONVERSION dengan Material Loss di Setiap Tahap!

Tahapan Proses & Yield Benchmarks:

Tahap Proses	Yield Range (Industry Standard)	Material Loss & Penyebab
1. LOG → LUMBER (Sawmill)	50-65% Lumber Recovery Factor (LRF) • Hardwood (Jati, Merbau): 50-58% • Softwood (Pine): 55-65%	Material Loss 35-50%: • Slabs (sisi luar log): 15-20% • Edgings (pinggiran): 8-12% • Sawdust: 10-15% • Bark (kulit kayu): 8-12%
2. ROUGH LUMBER → DRIED LUMBER (Kiln)	85-95% Drying Recovery • Schedule optimal: 92-95% • Fast schedule (risky): 85-90%	Material Loss 5-15%: • Checking/splits (retak): 3-8% • Warping (melengkung): 2-5% • End trim (potong ujung rusak): 1-2%
3. DRIED LUMBER → S4S (Surfacing/Planing)	88-94% Surfacing Yield • Clean lumber: 92-94% • Defect removal: 88-90%	Material Loss 6-12%: • Planing dust: 3-5% • Defect cutout: 2-6% • Trim waste: 1-2%
4. S4S → T&G FLOORING (Moulding)	82-88% Moulding Yield • Standard 19mm × 90mm: 85-88% • Wide plank 19mm × 150mm: 82-85%	Material Loss 12-18%: • T&G profile cut: 10-12% • End trim (panjang): 1-3% • Defect reject: 1-3%
5. FINISHING (Prefinished)	95-98% Finishing Yield • UV finish: 96-98% • Oil finish: 95-97%	Material Loss 2-5%: • Finish defects: 1-3% • Contamination: 0.5-1% • Handling damage: 0.5-1%
OVERALL YIELD (LOG → FINISHED FLOORING): = 55% × 93% × 92% × 86% × 97% = 38-45% Artinya: Dari 1,000 bd.ft log → menghasilkan 380-450 bd.ft lantai jadi! 60-62% menjadi by-product/waste!

Referensi: Wood Flooring Manufacturing standards (Transparency Market Research, 2024); Timber industry efficiency benchmarks (Grand View Research, 2024)

📊 CONTOH MONTHLY MATERIAL EFFICIENCY REPORT - PT Kayu Indah Jaya:

PERIODE: Januari 2026
PRODUK: Lantai Jati Solid 19mm × 90mm

INPUT MATERIAL (Raw Material):

Material Input	Quantity	Unit Cost (Rp/m³)	Total Cost (Rp)
Log Jati Grade A/B (mixed)	125 m³	Rp 18,000,000	Rp 2,250,000,000
Log Jati Grade C (untuk backing)	25 m³	Rp 12,000,000	Rp 300,000,000
TOTAL RAW MATERIAL COST		Rp 2,550,000,000

TAHAP 1: SAWMILL (Log → Rough Lumber)

Parameter	Value	Benchmark	Status
Input Log	150 m³	—	—
Output Rough Lumber	82.5 m³	—	—
Sawmill Yield	55%	50-58% (Jati)	✅ GOOD
By-Product Value Recovery: • Slabs (27 m³) → Dijual Rp 2,500,000/m³ = Rp 67,500,000 • Sawdust (18 m³) → Dijual ke pabrik briket Rp 500,000/m³ = Rp 9,000,000 Total By-Product Revenue: Rp 76,500,000 (offset 3% dari material cost!)

TAHAP 2: KILN DRYING (Rough → Dried Lumber)

Parameter	Value	Benchmark	Status
Input Rough Lumber	82.5 m³	—	—
Output Dried Lumber (MC 8%)	76.7 m³	—	—
Drying Yield	93%	92-95%	✅ ON TARGET
Drying Cost (Energy + Labor): • Kiln energy: Rp 850,000/m³ × 82.5 m³ = Rp 70,125,000 • Operator & monitoring: Rp 18,000,000 Total Drying Cost: Rp 88,125,000

TAHAP 3: SURFACING/PLANING (Dried → S4S)

Parameter	Value	Benchmark	Status
Input Dried Lumber	76.7 m³	—	—
Output S4S Lumber	70.6 m³	—	—
Surfacing Yield	92%	92-94%	✅ OK

TAHAP 4: MOULDING (S4S → T&G Flooring)

Parameter	Value	Benchmark	Status
Input S4S Lumber	70.6 m³	—	—
Output T&G Flooring	60.7 m³	—	—
Moulding Yield	86%	85-88%	✅ GOOD

TAHAP 5: FINISHING (Unfinished → Prefinished)

Parameter	Value	Benchmark	Status
Input Unfinished Flooring	60.7 m³	—	—
Output Prefinished Flooring	58.9 m³	—	—
Finishing Yield	97%	96-98%	✅ EXCELLENT

GRADING OUTPUT (After Finishing):

Grade	Output (m³)	% of Total	Price/m² (Rp)	Revenue (Rp)
Select & Better	35.3 m³ (3,917 m²)	60%	Rp 1,250,000	Rp 4,896,250,000
#1 Common	17.7 m³ (1,961 m²)	30%	Rp 950,000	Rp 1,862,950,000
#2 Common	5.9 m³ (654 m²)	10%	Rp 650,000	Rp 425,100,000
TOTAL OUTPUT	58.9 m³ (6,532 m²)	100%	—	Rp 7,184,300,000

📊 OVERALL MATERIAL EFFICIENCY ANALYSIS:

Overall Yield = 58.9 m³ output ÷ 150 m³ input = 39.3%
(Sesuai benchmark 38-45% ✅)

COST BREAKDOWN:

Raw Material Cost: Rp 2,550,000,000
Less: By-product revenue: (Rp 76,500,000)
Net Material Cost: Rp 2,473,500,000
Processing Cost (drying, labor, overhead): Rp 680,000,000
Total Production Cost: Rp 3,153,500,000

UNIT COST ANALYSIS:

Cost per m³ finished product: Rp 3,153,500,000 ÷ 58.9 m³ = Rp 53,538,000/m³
Cost per m² finished product: Rp 3,153,500,000 ÷ 6,532 m² = Rp 482,845/m²

PROFITABILITY ANALYSIS:

Metric	Value
Total Revenue	Rp 7,184,300,000
Total Production Cost	Rp 3,153,500,000
Gross Profit	Rp 4,030,800,000
Gross Margin %	56.1%
✅ Target Gross Margin: 50-60% → ACHIEVED!

⚠️ KEY INSIGHTS & ACTION ITEMS:

Yield Performance: Overall 39.3% SESUAI benchmark (38-45%) ✅
By-Product Revenue: Rp 76.5 juta (3% offset) → Opportunity: Explore biomass pellet production untuk sawdust (potensi revenue 2-3x lipat!)
Grade Distribution: 60% Select grade → EXCELLENT! (industry avg 50-55%)
Cost Control: Unit cost Rp 482,845/m² vs selling price avg Rp 1,100,000/m² → Margin sehat 56%
Improvement Opportunity: Surfacing yield 92% → Target 94% (improve planer blade maintenance schedule)

B. Auxiliary Materials Evaluation Report

📋 Purpose: Monitor konsumsi bahan pembantu (finishing, adhesive, packaging) terhadap standard - detect overuse/waste

Frequency: Monthly | Users: PPIC, Production Manager, Finance

            🎨 KATEGORI AUXILIARY MATERIALS - Industri Lantai Kayu:

                    Material Category
                    Typical Usage Rate
                    Cost Impact
                    Control Method
                
                    1. UV Lacquer (Prefinished)
                    
                        Coverage: 8-10 m²/liter/coat

                        Coats: 2-3 lapis

                        Total: 0.25-0.38 L/m²
                    
                        Rp 85,000-150,000/L

                        Impact: 5-8% dari production cost
                    
                        • Spray gun calibration

                        • Batch mixing control

                        • Overspray reclaim system
                    
                    2. Tung Oil / Natural Oil
                    
                        Coverage: 10-12 m²/liter/coat

                        Coats: 2-3 lapis

                        Total: 0.17-0.30 L/m²
                    
                        Rp 120,000-250,000/L

                        Impact: 3-6% (premium product)
                    
                        • Species-specific rate

                        • Wipe-on method standardization

                        • Absorption rate tracking
                    
                    3. Adhesive (Engineered Flooring)
                    
                        PVA: 150-200 g/m² (30-40 m²/kg)

                        PUR: 100-125 g/m² (40-50 m²/kg)
                    
                        PVA: Rp 25,000-40,000/kg

                        PUR: Rp 85,000-120,000/kg

                        Impact: 2-4%
                    
                        • Glue spreader calibration

                        • Temperature control

                        • Open time monitoring
                    
                    4. Packaging Materials
                    
                        Per 1,000 m²:

                        • Boxes: 200-250 pcs

                        • Plastic wrap: 10-15 rolls

                        • Pallets: 8-12 pcs
                    
                        Total: Rp 8,000-12,000/m²

                        Impact: 0.8-1.2%
                    
                        • Box size optimization

                        • Pallet reuse program

                        • Bulk purchasing
                    
                    5. Abrasives (Sandpaper)
                    
                        Belt sander: 200-300 m²/belt

                        Disc sander: 400-600 m²/disc
                    
                        Belt: Rp 125,000-200,000

                        Disc: Rp 15,000-30,000

                        Impact: 1-2%
                    
                        • Grit progression protocol

                        • Dust collection (extend life)

                        • Usage tracking per shift

📊 MONTHLY AUXILIARY MATERIALS EVALUATION - PT Kayu Indah Jaya:

PERIODE: Januari 2026
PRODUCTION OUTPUT: 6,532 m² Prefinished Flooring

1. UV LACQUER CONSUMPTION ANALYSIS:

Parameter	Standard	Actual	Variance	Status
Production Volume	6,532 m²	6,532 m²	—	—
Coverage Rate (m²/L)	9.0 m²/L	8.2 m²/L	-8.9%	⚠️ OVERUSE
Lacquer Required (L)	725.8 L	796.3 L	+70.5 L	⚠️ OVER
Unit Cost (Rp/L)	Rp 125,000
Total Cost	Rp 90,725,000	Rp 99,537,500	+Rp 8,812,500	🔴 INVESTIGATE!

ROOT CAUSE ANALYSIS - Lacquer Overuse:

5 Whys Investigation:

Why overuse 8.9%? → Coverage rate turun dari 9.0 → 8.2 m²/L
Why coverage turun? → Spray gun tidak konsisten, ada yang boros
Why spray gun tidak konsisten? → Spray gun #2 & #3 pressure setting tidak standar
Why pressure tidak standar? → Operator adjust sendiri tanpa SOP
Why adjust sendiri? → Tidak ada daily calibration check

ROOT CAUSE: Kurangnya spray gun calibration routine + operator discipline

CORRECTIVE ACTION:

Immediate: Re-calibrate ALL spray guns → Standard pressure 25 PSI (saat ini gun #2: 35 PSI, gun #3: 30 PSI)
Short-term: Implement daily pre-shift calibration check (5 menit SOP)
Long-term: Install flow meter pada each spray gun untuk real-time monitoring
Expected Saving: Rp 8.8 juta/bulan = Rp 105 juta/tahun!

2. PACKAGING MATERIALS CONSUMPTION:

Item	Standard Rate	Qty Required	Unit Cost	Total Cost	Status
Carton Box (20 pcs/box)	4.5 m²/box	1,452 boxes	Rp 12,500	Rp 18,150,000	✅ OK
Plastic Wrap	500 m²/roll	14 rolls	Rp 275,000	Rp 3,850,000	✅ OK
Wooden Pallet	750 m²/pallet	9 pallets	Rp 185,000	Rp 1,665,000	✅ OK
Label & Documentation	—	—	—	Rp 1,250,000	✅ OK
TOTAL PACKAGING COST				Rp 24,915,000	✅
Per m² Cost: Rp 24,915,000 ÷ 6,532 m² = Rp 3,815/m² % of Production Cost: 0.79% (Target: <1%) ✅ EFFICIENT

3. ADHESIVE CONSUMPTION (Engineered Flooring Line - jika ada):

Adhesive Type	Usage (kg)	Coverage (m²/kg)	Unit Cost (Rp/kg)	Total Cost
PVA D3 (Water resistant)	185 kg	35 m²/kg	Rp 32,000	Rp 5,920,000
PUR (Premium grade)	95 kg	45 m²/kg	Rp 95,000	Rp 9,025,000
TOTAL ADHESIVE COST				Rp 14,945,000

MONTHLY SUMMARY - ALL AUXILIARY MATERIALS:

Category	Actual Cost (Rp)	Budget (Rp)	Variance	% of Production Cost
UV Lacquer	99,537,500	90,725,000	+8,812,500	3.16%
Packaging	24,915,000	25,500,000	-585,000	0.79%
Adhesive	14,945,000	15,200,000	-255,000	0.47%
Abrasives	8,750,000	9,000,000	-250,000	0.28%
Lain-lain (stain, oil, dll)	22,766,500	23,000,000	-233,500	0.72%
TOTAL AUXILIARY	Rp 170,914,000	Rp 163,425,000	+Rp 7,489,000	5.42%
TARGET: Auxiliary materials <6% dari production cost ACTUAL: 5.42% ✅ Masih dalam target, tapi ada potensi saving dari lacquer!

✅ ACTION PLAN - Auxiliary Materials Optimization:

Lacquer Efficiency Program: Target saving Rp 8.8 juta/bulan via spray gun optimization
Bulk Purchase Negotiation: UV lacquer 1,000L contract → potential 8-12% discount (Rp 1.2 juta/bulan saving)
Returnable Packaging Pilot: Collaborate dengan 3 key customers untuk pallet return program → save Rp 1.5 juta/bulan
Total Potential Monthly Saving: Rp 11.5 juta = Rp 138 juta/tahun!

C. Production Cost Analysis (Cost Buildup Report)

📋 Purpose: Breakdown COMPLETE cost dari raw material sampai finished goods - untuk pricing decision & margin analysis

Frequency: Quarterly review, Annual budget | Users: Finance Director, GM, Sales Manager, PPIC

💰 STRUKTUR BIAYA PRODUKSI LANTAI KAYU - Industry Benchmark:

Cost Component	% of Total Cost	Notes
1. Direct Material (Log)	50-60%	Terbesar! Sangat dipengaruhi oleh: • Species (Jati > Merbau > Pine) • Grade (Select > Common) • Market volatility (bisa swing 20-30%/tahun)
2. Direct Labor	12-18%	Labor cost per m²: • Sawmill: Rp 35,000-50,000 • Kiln operation: Rp 15,000-20,000 • Machining: Rp 45,000-65,000 • Finishing: Rp 40,000-55,000 • QC & Packing: Rp 18,000-25,000
3. Manufacturing Overhead	15-22%	Include: • Energy (kiln gas/electric): 35-40% dari OH • Maintenance & repair: 15-20% • Depreciation equipment: 25-30% • Indirect labor (supervisor, etc): 15-20%
4. Auxiliary Materials	5-8%	Lacquer, adhesive, packaging (see section B)
5. Freight & Packaging	3-5%	Delivery to customer warehouse
TARGET GROSS MARGIN: 35-45% (after deducting all production cost) SELLING PRICE FORMULA: Total Cost ÷ (1 - Target Margin%)

Referensi: Hardwood flooring cost structure analysis (Hallmark Floors, 2025); Manufacturing cost benchmarks (Go Flooring, 2025)

📊 DETAILED COST BUILDUP ANALYSIS - Lantai Jati Select Grade 19mm × 90mm:

PRODUCT SPECIFICATION:

Species: Jati (Tectona grandis)
Dimension: 19mm thick × 90mm wide × random length (600-1200mm)
Grade: Select & Better (minimal defects)
Finish: UV lacquer 3-coat prefinished
Packaging: 20 pcs/carton, 9 m²/carton

STEP-BY-STEP COST BUILDUP (per m²):

1. DIRECT MATERIAL COST:

Item	Calculation	Cost (Rp/m²)
Log Jati Grade A	• Log price: Rp 18,000,000/m³ • Overall yield: 39% (dari log ke finished Select grade) • Required log: 1 m² finished = 1/39% = 2.56 m³ log equivalent • Log cost/m² = (Rp 18,000,000 × 2.56) ÷ 1000 = Rp 46,154 • Less: By-product credit (3%) = -Rp 1,385	Rp 44,769
NET MATERIAL COST per m²		Rp 44,769

2. DIRECT LABOR COST:

Process Stage	Labor Cost (Rp/m²)
Sawmill (cutting, sorting)	Rp 4,200
Kiln Operation (loading, monitoring)	Rp 2,800
Surfacing/Planing	Rp 3,500
Moulding (T&G profile)	Rp 5,800
Sanding (pre-finish)	Rp 3,200
Finishing (UV lacquer 3-coat)	Rp 6,500
QC & Grading	Rp 2,100
Packaging	Rp 1,900
TOTAL DIRECT LABOR	Rp 30,000

3. MANUFACTURING OVERHEAD:

Overhead Category	Cost (Rp/m²)	Basis
Energy (Electricity + Gas)	Rp 8,500	Kiln drying 60%, machinery 40%
Equipment Depreciation	Rp 6,200	Machine hour basis
Maintenance & Repair	Rp 3,800	5% of equipment value/year
Indirect Labor (Supervisor, Foreman)	Rp 4,500	Allocated by output volume
Factory Overhead (Rent, Insurance, etc)	Rp 3,000	Fixed allocation
TOTAL OVERHEAD	Rp 26,000	—

4. AUXILIARY MATERIALS:

Material	Cost (Rp/m²)
UV Lacquer (3 coats)	Rp 15,250
Sandpaper/Abrasives	Rp 2,800
Adhesive (T&G assembly, if engineered)	Rp 0 (solid wood)
Miscellaneous (cleaning, etc)	Rp 950
TOTAL AUXILIARY	Rp 19,000

5. PACKAGING & FREIGHT:

Item	Cost (Rp/m²)
Carton Box	Rp 2,780
Plastic Wrap, Pallet	Rp 1,035
Freight to Customer Warehouse (avg)	Rp 8,500
TOTAL PACKAGING & FREIGHT	Rp 12,315

📊 TOTAL COST SUMMARY:

Cost Element	Cost (Rp/m²)	% of Total
Direct Material	Rp 44,769	33.9%
Direct Labor	Rp 30,000	22.7%
Manufacturing Overhead	Rp 26,000	19.7%
Auxiliary Materials	Rp 19,000	14.4%
Packaging & Freight	Rp 12,315	9.3%
TOTAL PRODUCTION COST	Rp 132,084	100%

💵 PRICING & MARGIN ANALYSIS:

Scenario	Selling Price (Rp/m²)	Gross Profit (Rp/m²)	Gross Margin %	Assessment
Conservative Pricing	Rp 950,000	Rp 817,916	86.1%	✅ EXCELLENT (premium positioning)
Market Competitive	Rp 850,000	Rp 717,916	84.5%	✅ VERY GOOD
Aggressive Market Entry	Rp 750,000	Rp 617,916	82.4%	⚠️ GOOD (consider if building market share)
Minimum Acceptable	Rp 650,000	Rp 517,916	79.7%	⚠️ BORDERLINE (only for clearance)
RECOMMENDATION: Target selling price Rp 850,000-950,000/m² untuk Jati Select grade Market Reference: Retail market Jati Select prefinished: Rp 1,100,000-1,400,000/m² Distributor Margin: Typically 20-25% → Our price Rp 850K gives them room to sell at Rp 1,100K ✅

⚠️ COST SENSITIVITY ANALYSIS - Key Risk Factors:

Log Price Volatility (Biggest Risk!):
- Jika log price naik 10% (Rp 18M → Rp 19.8M/m³) → Material cost naik Rp 4,477/m² → Total cost Rp 136,561/m²
- Impact: Margin turun 3.4% (dari 84.5% → 81.1%) jika selling price fixed!
- Mitigation: Long-term contract (6-12 bulan) dengan supplier untuk lock price
Energy Cost (Kiln Drying):
- Energy = Rp 8,500/m² (6.4% dari total cost)
- Jika gas price naik 20% → Energy cost Rp 10,200/m² → Total cost naik Rp 1,700/m²
- Mitigation: Invest in energy-efficient kiln, solar panel untuk pre-heat air
Labor Cost (UMR increase):
- Direct labor Rp 30,000/m² (22.7% dari total)
- Jika UMR naik 8% → Labor cost Rp 32,400/m² → Total cost naik Rp 2,400/m²
- Mitigation: Automation (CNC moulding, auto-grading), productivity improvement (OEE 75% → 85%)

D. Variance Analysis Report (Budget vs Actual)

📋 Purpose: Identifikasi penyimpangan biaya produksi actual vs budget - ROOT CAUSE analysis untuk corrective action

Frequency: Monthly | Users: Finance Director, GM, PPIC Manager, Operations Director

🎯 COST VARIANCE FRAMEWORK - 3 Dimensi Analisis:

                TOTAL COST VARIANCE = Price Variance + Efficiency Variance + Volume Variance
            
                    Variance Type
                    Formula
                    Interpretation
                
                    Price Variance
                    
                        (Actual Price - Budget Price) × Actual Quantity

                        Mengukur: Perubahan harga material/upah
                    
                        Favorable (F): Actual price < Budget → Cost saving

                        Unfavorable (U): Actual price > Budget → Cost overrun

                        Responsibility: Procurement (material), HR (labor)
                    
                    Efficiency Variance
                    
                        (Actual Quantity - Budget Quantity) × Budget Price

                        Mengukur: Produktivitas & waste
                    
                        Favorable (F): Actual usage < Budget → Efficient

                        Unfavorable (U): Actual usage > Budget → Wasteful

                        Responsibility: Production/Operations
                    
                    Volume Variance
                    
                        (Actual Volume - Budget Volume) × Budget Cost per Unit

                        Mengukur: Production output vs plan
                    
                        Impact Fixed Cost Absorption:

                        • Volume ↓ → Under-absorbed overhead → Unit cost ↑

                        • Volume ↑ → Over-absorbed overhead → Unit cost ↓

📊 MONTHLY VARIANCE ANALYSIS REPORT - PT Kayu Indah Jaya:

PERIODE: Januari 2026
PRODUCT: Lantai Jati Select 19mm × 90mm Prefinished

PRODUCTION VOLUME VARIANCE:

Parameter	Budget	Actual	Variance	%
Production Target	7,000 m²	6,532 m²	-468 m²	-6.7%
Impact: Under-production → Fixed overhead under-absorbed → Unit cost lebih tinggi! Root Cause: Kiln #2 breakdown 3 hari (maintenance issue) + Quality reject lebih tinggi (2.8% vs target 2%)

MATERIAL COST VARIANCE (Direct Material):

Item	Budget	Actual	Variance	Type
LOG JATI (Raw Material)
Log Volume Required	156 m³	150 m³	-6 m³ (F)	Volume
Log Price per m³	Rp 17,500,000	Rp 18,000,000	+Rp 500,000 (U)	Price
Total Log Cost	Rp 2,730,000,000	Rp 2,700,000,000	-Rp 30,000,000 (F)	—
VARIANCE BREAKDOWN: 1. Price Variance (U): (Rp 18M - Rp 17.5M) × 150 m³ = +Rp 75,000,000 Unfavorable → Cause: Log market price spike (seasonality - peak rainy season demand) 2. Efficiency Variance (F): (150 m³ - 156 m³) × Rp 17.5M = -Rp 105,000,000 Favorable → Cause: Yield improvement! Actual 39.3% vs budget 38% (better sawmill operator) NET MATERIAL VARIANCE: -Rp 30M Favorable (efficiency offset price increase!)

LABOR COST VARIANCE:

Item	Budget	Actual	Variance
Standard Labor Hour/m²	0.85 jam	0.92 jam	+0.07 jam (U)
Labor Rate per Hour	Rp 35,000	Rp 36,500	+Rp 1,500 (U)
Production Volume	7,000 m²	6,532 m²	-468 m² (U)
Total Labor Hours	5,950 hrs	6,009 hrs	+59 hrs (U)
Total Labor Cost	Rp 208,250,000	Rp 219,329,000	+Rp 11,079,000 (U)
VARIANCE BREAKDOWN: 1. Rate Variance (U): (Rp 36,500 - Rp 35,000) × 6,009 hrs = +Rp 9,013,500 Unfavorable → Cause: Overtime premium (150%) untuk kejar target + Tunjangan hari raya (THR prorate) 2. Efficiency Variance (U): (6,009 hrs - 5,550 hrs) × Rp 35,000 = +Rp 16,065,000 Unfavorable → Cause: Moulding line OEE turun (76% vs target 85%) + New operator learning curve NET LABOR VARIANCE: +Rp 25,078,500 Unfavorable ⚠️ PERLU ACTION!

OVERHEAD VARIANCE:

Overhead Category	Budget	Actual	Variance
VARIABLE OVERHEAD (Energy, Indirect Material)
Variable OH Rate per m²	Rp 12,500	Rp 14,750	+Rp 2,250 (U)
Production Volume	7,000 m²	6,532 m²	-468 m²
Total Variable OH	Rp 87,500,000	Rp 96,347,000	+Rp 8,847,000 (U)
Root Cause Variable OH Overrun: • Energy cost spike: Gas LPG naik 18% (market volatility) = +Rp 5.2 juta • Kiln inefficiency: Breakdown → longer drying time → more energy = +Rp 2.8 juta • Abrasives overuse: Moulding issue → more sanding = +Rp 847K
FIXED OVERHEAD (Depreciation, Rent, Supervisor)
Budgeted Fixed OH	Rp 95,000,000	Rp 97,150,000	+Rp 2,150,000 (U)
Applied Fixed OH (7,000 m² basis)	Rp 95,000,000	Rp 88,569,000	-Rp 6,431,000 (U)
Volume Variance (Under-absorbed)	+Rp 6,431,000 Unfavorable (karena produksi actual 6,532 m² < budget 7,000 m²)
Root Cause Fixed OH Variance: • Unplanned maintenance: Kiln #2 repair = +Rp 1.8 juta • Insurance premium naik (annual renewal) = +Rp 350K • Volume shortfall → under-absorbed fixed cost = +Rp 6.4 juta (biggest impact!)

📊 TOTAL COST VARIANCE SUMMARY:

Cost Element	Budget	Actual	Variance	Status
Direct Material	Rp 2,730,000,000	Rp 2,700,000,000	-Rp 30,000,000 (F)	✅
Direct Labor	Rp 208,250,000	Rp 219,329,000	+Rp 11,079,000 (U)	⚠️
Variable Overhead	Rp 87,500,000	Rp 96,347,000	+Rp 8,847,000 (U)	⚠️
Fixed Overhead	Rp 95,000,000	Rp 103,581,000	+Rp 8,581,000 (U)	⚠️
TOTAL VARIANCE	—	—	-Rp 1,493,000 Net Unfavorable	🔴

💡 EXECUTIVE SUMMARY & ACTION PLAN:

CRITICAL FINDINGS:

Volume Shortfall (-6.7%): Biggest driver variance → Root cause: Kiln breakdown + Quality issue
- Action: Implement TPM (Total Productive Maintenance) program untuk kiln
- Target: Reduce unplanned downtime dari 3 hari/bulan → <1 hari/bulan
- Expected Impact: Volume recovery +5% = Rp 65 juta/bulan additional revenue
Labor Efficiency Issue (+18% labor cost overrun):
- Root Cause: Moulding line OEE 76% vs target 85% → Waste labor hours
- Action: Equipment upgrade (knife sharpening schedule), operator retraining
- Expected Saving: Rp 15 juta/bulan labor cost reduction
Energy Cost Spike (+18%):
- Action: Hedge LPG price (6-month contract), explore solar pre-heat system
- Expected Saving: Rp 3-5 juta/bulan energy cost

POSITIVE HIGHLIGHTS:

✅ Material Efficiency Improvement: Yield 39.3% vs budget 38% → Saving Rp 105 juta!
✅ Sawmill Team Performance: Excellent recovery rate, continue best practice!

2.8 LONG-TERM STRATEGIC REPORTS

Annual planning, quarterly business review, dan budget analysis untuk strategic decision-making

A. Annual Production Plan (APP)

📋 Purpose: 12-month rolling production forecast - foundation untuk capacity investment, hiring plan, dan budget allocation

Frequency: Annual (with quarterly updates) | Users: Board of Directors, GM, CFO, All Department Heads

📅 ANNUAL PRODUCTION PLAN FRAMEWORK - Hierarchical Approach:

                APP Hierarchy: Corporate Strategy → Sales Forecast → Production Plan → Capacity Plan → Budget
            
                    Planning Level
                    Time Horizon
                    Key Outputs
                
                    Strategic Plan
                    3-5 years (Long-term)
                    
                        • Market growth target (e.g., 15% CAGR)

                        • Product portfolio strategy

                        • Capacity expansion roadmap

                        • Major CAPEX decisions
                    
                    Annual Business Plan
                    12 months (Yearly)
                    
                        • Revenue target by product line

                        • Production volume plan

                        • Hiring & training budget

                        • Annual CAPEX/OPEX budget
                    
                    Quarterly Review
                    3 months (Quarterly)
                    
                        • Plan vs Actual analysis

                        • Forecast revision (rolling 12M)

                        • Resource reallocation

                        • Risk mitigation actions
                    
                    Monthly S&OP
                    1 month (Monthly)
                    
                        • MPS finalization

                        • Material procurement plan

                        • Short-term capacity adjustment

                        • Weekly production schedule

📊 ANNUAL PRODUCTION PLAN 2026 - PT Kayu Indah Jaya:

CORPORATE STRATEGIC CONTEXT:

Vision 2026: Become Top 3 premium wood flooring manufacturer in Indonesia
Growth Target: Revenue Rp 95 billion (vs 2025: Rp 78B = 22% growth)
Market Strategy: Expand engineered flooring (currently 20% → target 35% of sales)
Capacity Plan: Add 1 additional kiln (increase capacity 20%)

SALES FORECAST 2026 (By Product Family):

Product Category	2025 Actual (m²)	2026 Plan (m²)	Growth %	Revenue Plan (Rp)
Solid Jati Premium	45,000	52,000	+15.6%	Rp 52,000,000,000
Solid Merbau	28,000	30,000	+7.1%	Rp 24,000,000,000
Engineered Oak (Import Core)	12,000	18,000	+50%	Rp 12,600,000,000
Decking (Outdoor)	8,000	10,000	+25%	Rp 6,500,000,000
TOTAL	93,000 m²	110,000 m²	+18.3%	Rp 95,100,000,000

PRODUCTION VOLUME PLAN (Accounting for Yield & Safety Stock):

Product	Sales Plan (m²)	+ Safety Stock	- Opening Stock	= Production Plan
Solid Jati Premium	52,000	+5,200 (10%)	-3,800	53,400 m²
Solid Merbau	30,000	+3,000	-2,500	30,500 m²
Engineered Oak	18,000	+1,800	-800	19,000 m²
Decking	10,000	+1,000	-500	10,500 m²
TOTAL	110,000	+11,000	-7,600	113,400 m²

CAPACITY REQUIREMENT ANALYSIS:

CURRENT CAPACITY (2025):

Sawmill: 200,000 bd.ft/month × 12 = 2,400,000 bd.ft/year
Kiln (5 units): 90,000 bd.ft dried/month × 12 = 1,080,000 bd.ft/year
Moulding/Finishing: 100,000 m²/year capacity
BOTTLENECK: Kiln capacity!

REQUIRED CAPACITY (2026 Plan):

Production plan: 113,400 m² finished goods
Dried lumber needed: 113,400 m² ÷ 0.86 moulding yield = 131,860 m² S4S
Rough lumber needed: 131,860 ÷ 0.92 surfacing yield = 143,326 m² dried lumber
Convert to bd.ft: 143,326 m² × 9 bd.ft/m² (avg) = 1,289,934 bd.ft/year dried lumber required

CAPACITY GAP:

Required: 1,289,934 bd.ft/year
Available: 1,080,000 bd.ft/year
GAP: -209,934 bd.ft/year (-19.4% shortage!)

SOLUTION OPTIONS:

Option	Description	CAPEX	Timeline	Pros/Cons
Option 1: Add 1 Kiln	Purchase & install 6th kiln (18k bd.ft capacity)	Rp 2.5 billion	6 months (ready July 2026)	✅ Permanent solution ✅ Increase capacity 20% ❌ High upfront cost
Option 2: Toll Drying	Outsource 210k bd.ft to 3rd party kiln	Rp 0	Immediate	✅ No CAPEX ✅ Flexible ❌ Variable cost Rp 80/bd.ft = Rp 168M/year ❌ Quality control risk
Option 3: Buy Dried Lumber	Purchase pre-dried lumber from supplier	Rp 0	Immediate	✅ No CAPEX ❌ Premium price (~15% more expensive) ❌ Limited species availability
RECOMMENDATION	HYBRID APPROACH: • Q1-Q2 2026: Use toll drying (210k bd.ft × 50% = 105k bd.ft @ Rp 80/bd.ft = Rp 8.4M/month) • July 2026: New kiln operational (eliminate toll drying cost) • ROI: CAPEX Rp 2.5B ÷ Annual saving Rp 100M = 2.5 years payback ✅

MANPOWER PLANNING (Support Production Growth):

Department	Current (2025)	Required (2026)	Hiring Plan	Training Budget
Sawmill Operators	12	14	+2 (Q1)	Rp 20,000,000
Kiln Operators	5	6	+1 (Q3 - new kiln)	Rp 25,000,000
Moulding/Machining	18	22	+4 (Q1-Q2)	Rp 40,000,000
Finishing	10	12	+2 (Q2)	Rp 30,000,000
QC & Packaging	8	10	+2 (Q2)	Rp 15,000,000
Warehouse	6	7	+1 (Q1)	Rp 10,000,000
TOTAL	59	71	+12 headcount	Rp 140,000,000

ANNUAL CAPEX BUDGET 2026:

Project	Amount (Rp)	Priority	Expected ROI
New Kiln (18k bd.ft capacity)	Rp 2,500,000,000	🔴 CRITICAL	2.5 years
Warehouse Expansion (500 m²)	Rp 750,000,000	🟡 HIGH	5 years (space productivity)
Forklift (2 units)	Rp 400,000,000	🟡 HIGH	3 years (reduce labor cost)
ERP System Upgrade	Rp 300,000,000	🟢 MEDIUM	4 years (efficiency gain)
Solar Panel (pre-heat kiln air)	Rp 850,000,000	🟢 MEDIUM	7 years (energy saving)
Misc. Equipment & Tools	Rp 200,000,000	—	—
TOTAL CAPEX 2026	Rp 5,000,000,000	—

✅ ANNUAL PLAN SUMMARY - 2026 Roadmap:

Financial Targets:

Revenue: Rp 95.1 billion (+22% vs 2025)
Gross Margin: 56% (maintain via efficiency improvement)
EBITDA: Rp 18.5 billion (19.4% margin)

Operational Targets:

Production: 113,400 m² (+18% vs 2025)
OTIF: 96% (improve from 94.8%)
OEE: 82% average (from 78%)
Inventory Turnover: 8.5x (from 7.2x)

Strategic Milestones:

Q2: Warehouse expansion complete
Q3: New kiln operational (+20% capacity)
Q4: Engineered flooring line 35% of total sales (from 20%)

B. Quarterly Business Review (QBR)

📋 Purpose: Comprehensive performance review vs annual plan - course correction & reforecast rolling 12 months

Frequency: Quarterly (Mar, Jun, Sep, Dec) | Users: Board of Directors, Executive Team, Department Heads

            📋 QBR STANDARD AGENDA (90-120 Minutes):

                    Time
                    Topic
                    Owner
                    Key Questions
                
                    15 min
                    Financial Performance
                    CFO
                    
                        • Revenue vs plan?

                        • Margin trend?

                        • Cash flow status?
                    
                    20 min
                    Operational Performance
                    Operations Director
                    
                        • Production vs plan?

                        • OEE trend?

                        • Quality metrics?
                    
                    15 min
                    Sales & Market
                    Sales Director
                    
                        • Order book status?

                        • Market share trend?

                        • Customer feedback?
                    
                    10 min
                    Supply Chain Performance
                    PPIC Manager
                    
                        • OTIF achievement?

                        • Inventory level?

                        • Supplier issues?
                    
                    15 min
                    Strategic Initiatives
                    GM
                    
                        • CAPEX project status?

                        • New product launch?

                        • Market expansion?
                    
                    10 min
                    Risk & Issues
                    All
                    
                        • Top 3 risks?

                        • Mitigation plan?

                        • Escalation needed?
                    
                    15 min
                    Forecast Revision
                    CFO + PPIC
                    
                        • Adjust annual plan?

                        • Budget reallocation?

                        • Resource adjustment?
                    
                    10 min
                    Action Items & Close
                    GM
                    
                        • Who owns what?

                        • Deadline?

                        • Next meeting date?

📊 Q1 2026 BUSINESS REVIEW - PT Kayu Indah Jaya (Example):

EXECUTIVE SUMMARY:

Period: Jan-Mar 2026 (Q1)
Revenue: Rp 22.1 billion (Target: Rp 23.8B) = 93% achievement
Production: 26,500 m² (Target: 28,350 m²) = 93.5% achievement
OTIF: 94.8% (Target: 95%) = Near target
Gross Margin: 54.2% (Target: 56%) = Below target

DETAILED PERFORMANCE DASHBOARD:

Category	KPI	Q1 Plan	Q1 Actual	%	Status
FINANCIAL	Revenue (Rp B)	23.8	22.1	93%	⚠️
	Gross Margin %	56%	54.2%	-1.8%	⚠️
	EBITDA (Rp B)	4.5	4.1	91%	⚠️
OPERATIONS	Production (m²)	28,350	26,500	93.5%	⚠️
	OEE Average	80%	77.5%	-2.5%	⚠️
	Quality FPY	93%	92.1%	-0.9%	✅
SUPPLY CHAIN	OTIF	95%	94.8%	-0.2%	✅
SUPPLY CHAIN	Inventory Turnover	8.0x	7.2x	90%	⚠️
STRATEGIC	New Kiln Installation	Design Complete	On Track (90% design done)		✅
STRATEGIC	Engineered Floor % Sales	25%	22%	88%	⚠️

ROOT CAUSE ANALYSIS - Revenue Shortfall (7%):

GAP BREAKDOWN:

Volume Gap: 1,850 m² below target (6.5% shortfall)
- Cause: Production delay from kiln breakdown (3 days Q1)
- Impact: Rp 1.85M × avg price Rp 850K/m² = Rp 1.57 billion revenue loss
Price/Mix Gap: 0.5% lower avg selling price
- Cause: Higher proportion of Merbau (lower price) vs Jati Premium in Q1 sales
- Impact: Rp 110M revenue

TOTAL REVENUE GAP: Rp 1.68 billion (vs plan Rp 23.8B)

CORRECTIVE ACTIONS & FORECAST REVISION:

IMMEDIATE ACTIONS (Q2 2026):

Production Recovery Plan:
- Catch-up production: Add 1,850 m² to Q2 target
- Overtime: 20 hours/week in April-May
- Toll drying: 50k bd.ft untuk accelerate (avoid kiln bottleneck)
- Q2 Revised Target: 30,200 m² (original 28,350 + catch-up 1,850)
Product Mix Rebalancing:
- Sales focus: Push Jati Premium & Engineered Oak (higher margin)
- Promo strategy: Bundle Merbau with premium accessories (increase avg order value)
- Target: Q2 avg selling price Rp 880K/m² (vs Q1: Rp 834K/m²)
Kiln Reliability:
- Complete all 5 kilns preventive maintenance in April (before Q2 peak)
- Accelerate new kiln project (target: June operational instead of July)

ANNUAL FORECAST REVISION (Rolling 12-Month):

Quarter	Original Plan (m²)	Revised Plan (m²)	Change	Rationale
Q1 2026 (Actual)	28,350	26,500	-1,850	Kiln breakdown impact
Q2 2026 (Revised)	28,350	30,200	+1,850	Catch-up + overtime
Q3 2026 (Revised)	28,350	29,500	+1,150	New kiln operational (20% capacity ↑)
Q4 2026 (Revised)	28,350	29,500	+1,150	Full new kiln contribution
FY 2026 Total	113,400	115,700	+2,300	Net positive (new capacity offset Q1 loss)

REVISED FINANCIAL PROJECTION:

Revenue Projection: Rp 95.1B → Rp 96.8B (+Rp 1.7B, +1.8%)
Gross Margin Target: Maintain 56% via efficiency improvement
EBITDA: Rp 18.5B → Rp 19.2B (19.8% margin)

C. Budget vs Actual Variance Report

📋 Purpose: Financial accountability - track spending vs budget, ensure fiscal discipline

Frequency: Monthly detail, Quarterly summary | Users: CFO, GM, All Budget Holders (Dept Heads)

            💰 BUDGET VARIANCE ANALYSIS FRAMEWORK:

                    Variance Type
                    Formula & Measurement
                    Action Threshold
                
                    Favorable Variance (F)
                    
                        Actual Spend < Budget

                        OR

                        Actual Revenue > Budget

                        Good news! (Usually...)
                    
                        • <5% variance: Monitor

                        • 5-10%: Investigate (missed opportunity?)

                        • >10%: Review budget accuracy
                    
                    Unfavorable Variance (U)
                    
                        Actual Spend > Budget

                        OR

                        Actual Revenue < Budget

                        Red flag! Needs action
                    
                        • <5% variance: Monitor closely

                        • 5-10%: Action plan required

                        • >10%: Escalate to GM/CFO
                    
                    Volume Variance
                    
                        (Actual Volume - Budget Volume) × Budget Rate

                        Due to production/sales volume difference
                    
                        Acceptable if explained by market conditions

                        (e.g., demand spike/drop)
                    
                    Rate/Price Variance
                    
                        (Actual Rate - Budget Rate) × Actual Volume

                        Due to price/cost change
                    
                        Requires immediate mitigation if unfavorable

                        (e.g., hedge price, renegotiate contracts)

📊 Q1 2026 BUDGET vs ACTUAL VARIANCE REPORT:

INCOME STATEMENT VARIANCE ANALYSIS:

Line Item	Budget (Rp M)	Actual (Rp M)	Variance (Rp M)	Variance %	F/U
REVENUE
Solid Wood Sales	19,800	18,450	-1,350	-6.8%	U
Engineered Flooring	3,150	2,980	-170	-5.4%	U
Decking	850	720	-130	-15.3%	U
TOTAL REVENUE	23,800	22,150	-1,650	-6.9%	U
COST OF GOODS SOLD
Direct Material	10,472	10,285	-187	-1.8%	F
Direct Labor	3,808	3,945	+137	+3.6%	U
Manufacturing OH	3,094	3,285	+191	+6.2%	U
TOTAL COGS	17,374	17,515	+141	+0.8%	U
GROSS PROFIT	6,426 (27%)	4,635 (20.9%)	-1,791	-27.9%	U
OPERATING EXPENSES
Sales & Marketing	950	885	-65	-6.8%	F
G&A (General & Admin)	720	745	+25	+3.5%	U
R&D	250	180	-70	-28%	F
TOTAL OPEX	1,920	1,810	-110	-5.7%	F
EBITDA	4,506 (18.9%)	2,825 (12.8%)	-1,681	-37.3%	U

KEY INSIGHTS & ACTION ITEMS:

🔴 CRITICAL ISSUES:

Revenue Shortfall -6.9% (Rp 1.65B):
- Already addressed in QBR section - production recovery plan in place
- Target Q2: Make up volume deficit
Gross Margin Erosion: 27% → 20.9% (-6.1 percentage points!):
- Root cause: Fixed cost under-absorption (production volume down 6.5%)
- Impact: Rp 1.79B gross profit loss (vs budget)
- Action: Volume recovery critical! Every 1% production increase = Rp 0.3B gross profit
Manufacturing Overhead Overrun +6.2% (Rp 191M):
- Energy cost spike: LPG price +18% (Rp 120M unfavorable)
- Maintenance cost: Kiln breakdown repair (Rp 45M unfavorable)
- Other: Misc. overhead (Rp 26M)
- Action: Accelerate solar panel project (hedge energy cost), TPM program (reduce breakdown)

✅ POSITIVE HIGHLIGHTS:

Material Cost Favorable -1.8% (Rp 187M): Excellent procurement performance! Yield improvement from 38% → 39.3% = Material saving
OPEX Control -5.7% (Rp 110M): Disciplined spending, good cost management
R&D Underspend -28% (Rp 70M): Project delayed (acceptable, not critical path)

CAPEX VARIANCE TRACKING:

Project	Annual Budget	Q1 Plan	Q1 Actual	Variance	Status
New Kiln	Rp 2,500M	Rp 500M	Rp 450M	-Rp 50M	✅ On Track
Warehouse Expansion	Rp 750M	Rp 150M	Rp 135M	-Rp 15M	✅ On Track
Forklift Purchase	Rp 400M	Rp 0M	Rp 0M	—	Q2 Scheduled
ERP Upgrade	Rp 300M	Rp 75M	Rp 60M	-Rp 15M	✅ On Track
Solar Panel	Rp 850M	Rp 0M	Rp 0M	—	Q3 Scheduled
Misc. Equipment	Rp 200M	Rp 50M	Rp 42M	-Rp 8M	✅ OK
TOTAL CAPEX	Rp 5,000M	Rp 775M	Rp 687M	-Rp 88M (F)	✅ 15.5% YTD

✅ MANAGEMENT ACTIONS - Budget Recovery Plan:

Q2 2026 Focus Areas:

Revenue Recovery: Implement catch-up production plan (target +1,850 m² vs original Q2 plan)
Margin Protection: Volume increase will improve fixed cost absorption → restore gross margin to 56% target
Cost Control: Energy hedging strategy (lock LPG price for Q2-Q4), accelerate solar panel project
CAPEX Discipline: Maintain spending discipline, all projects on track within budget

Full Year Outlook: Despite Q1 shortfall, confident to achieve revised FY2026 target (Rp 96.8B revenue, 56% gross margin) through:

New kiln capacity (June operational)
Improved operational efficiency (OEE 78% → 82%)
Product mix enhancement (higher margin Engineered flooring 35% of sales)

2.8 LONG-TERM STRATEGIC REPORTS

Annual planning, quarterly business review, dan budget analysis untuk strategic decision-making

A. Annual Production Plan (APP)

📅 ANNUAL PRODUCTION PLAN FRAMEWORK - Hierarchical Approach:

                APP Hierarchy: Corporate Strategy → Sales Forecast → Production Plan → Capacity Plan → Budget
            
                    Planning Level
                    Time Horizon
                    Key Outputs
                
                    Strategic Plan
                    3-5 years (Long-term)
                    
                        • Market growth target (e.g., 15% CAGR)

                        • Product portfolio strategy

                        • Capacity expansion roadmap

                        • Major CAPEX decisions
                    
                    Annual Business Plan
                    12 months (Yearly)
                    
                        • Revenue target by product line

                        • Production volume plan

                        • Hiring & training budget

                        • Annual CAPEX/OPEX budget
                    
                    Quarterly Review
                    3 months (Quarterly)
                    
                        • Plan vs Actual analysis

                        • Forecast revision (rolling 12M)

                        • Resource reallocation

                        • Risk mitigation actions
                    
                    Monthly S&OP
                    1 month (Monthly)
                    
                        • MPS finalization

                        • Material procurement plan

                        • Short-term capacity adjustment

                        • Weekly production schedule

📊 ANNUAL PRODUCTION PLAN 2026 - PT Kayu Indah Jaya:

CORPORATE STRATEGIC CONTEXT:

Vision 2026: Become Top 3 premium wood flooring manufacturer in Indonesia
Growth Target: Revenue Rp 95 billion (vs 2025: Rp 78B = 22% growth)
Market Strategy: Expand engineered flooring (currently 20% → target 35% of sales)
Capacity Plan: Add 1 additional kiln (increase capacity 20%)

SALES FORECAST 2026 (By Product Family):

Product Category	2025 Actual (m²)	2026 Plan (m²)	Growth %	Revenue Plan (Rp)
Solid Jati Premium	45,000	52,000	+15.6%	Rp 52,000,000,000
Solid Merbau	28,000	30,000	+7.1%	Rp 24,000,000,000
Engineered Oak (Import Core)	12,000	18,000	+50%	Rp 12,600,000,000
Decking (Outdoor)	8,000	10,000	+25%	Rp 6,500,000,000
TOTAL	93,000 m²	110,000 m²	+18.3%	Rp 95,100,000,000

PRODUCTION VOLUME PLAN (Accounting for Yield & Safety Stock):

Product	Sales Plan (m²)	+ Safety Stock	- Opening Stock	= Production Plan
Solid Jati Premium	52,000	+5,200 (10%)	-3,800	53,400 m²
Solid Merbau	30,000	+3,000	-2,500	30,500 m²
Engineered Oak	18,000	+1,800	-800	19,000 m²
Decking	10,000	+1,000	-500	10,500 m²
TOTAL	110,000	+11,000	-7,600	113,400 m²

CAPACITY REQUIREMENT ANALYSIS:

CURRENT CAPACITY (2025):

Sawmill: 200,000 bd.ft/month × 12 = 2,400,000 bd.ft/year
Kiln (5 units): 90,000 bd.ft dried/month × 12 = 1,080,000 bd.ft/year
Moulding/Finishing: 100,000 m²/year capacity
BOTTLENECK: Kiln capacity!

REQUIRED CAPACITY (2026 Plan):

Production plan: 113,400 m² finished goods
Dried lumber needed: 113,400 m² ÷ 0.86 moulding yield = 131,860 m² S4S
Rough lumber needed: 131,860 ÷ 0.92 surfacing yield = 143,326 m² dried lumber
Convert to bd.ft: 143,326 m² × 9 bd.ft/m² (avg) = 1,289,934 bd.ft/year dried lumber required

CAPACITY GAP:

Required: 1,289,934 bd.ft/year
Available: 1,080,000 bd.ft/year
GAP: -209,934 bd.ft/year (-19.4% shortage!)

SOLUTION OPTIONS:

Option	Description	CAPEX	Timeline	Pros/Cons
Option 1: Add 1 Kiln	Purchase & install 6th kiln (18k bd.ft capacity)	Rp 2.5 billion	6 months (ready July 2026)	✅ Permanent solution ✅ Increase capacity 20% ❌ High upfront cost
Option 2: Toll Drying	Outsource 210k bd.ft to 3rd party kiln	Rp 0	Immediate	✅ No CAPEX ✅ Flexible ❌ Variable cost Rp 80/bd.ft = Rp 168M/year ❌ Quality control risk
Option 3: Buy Dried Lumber	Purchase pre-dried lumber from supplier	Rp 0	Immediate	✅ No CAPEX ❌ Premium price (~15% more expensive) ❌ Limited species availability
RECOMMENDATION	HYBRID APPROACH: • Q1-Q2 2026: Use toll drying (210k bd.ft × 50% = 105k bd.ft @ Rp 80/bd.ft = Rp 8.4M/month) • July 2026: New kiln operational (eliminate toll drying cost) • ROI: CAPEX Rp 2.5B ÷ Annual saving Rp 100M = 2.5 years payback ✅

MANPOWER PLANNING (Support Production Growth):

Department	Current (2025)	Required (2026)	Hiring Plan	Training Budget
Sawmill Operators	12	14	+2 (Q1)	Rp 20,000,000
Kiln Operators	5	6	+1 (Q3 - new kiln)	Rp 25,000,000
Moulding/Machining	18	22	+4 (Q1-Q2)	Rp 40,000,000
Finishing	10	12	+2 (Q2)	Rp 30,000,000
QC & Packaging	8	10	+2 (Q2)	Rp 15,000,000
Warehouse	6	7	+1 (Q1)	Rp 10,000,000
TOTAL	59	71	+12 headcount	Rp 140,000,000

ANNUAL CAPEX BUDGET 2026:

Project	Amount (Rp)	Priority	Expected ROI
New Kiln (18k bd.ft capacity)	Rp 2,500,000,000	🔴 CRITICAL	2.5 years
Warehouse Expansion (500 m²)	Rp 750,000,000	🟡 HIGH	5 years (space productivity)
Forklift (2 units)	Rp 400,000,000	🟡 HIGH	3 years (reduce labor cost)
ERP System Upgrade	Rp 300,000,000	🟢 MEDIUM	4 years (efficiency gain)
Solar Panel (pre-heat kiln air)	Rp 850,000,000	🟢 MEDIUM	7 years (energy saving)
Misc. Equipment & Tools	Rp 200,000,000	—	—
TOTAL CAPEX 2026	Rp 5,000,000,000	—

✅ ANNUAL PLAN SUMMARY - 2026 Roadmap:

Financial Targets:

Revenue: Rp 95.1 billion (+22% vs 2025)
Gross Margin: 56% (maintain via efficiency improvement)
EBITDA: Rp 18.5 billion (19.4% margin)

Operational Targets:

Production: 113,400 m² (+18% vs 2025)
OTIF: 96% (improve from 94.8%)
OEE: 82% average (from 78%)
Inventory Turnover: 8.5x (from 7.2x)

Strategic Milestones:

Q2: Warehouse expansion complete
Q3: New kiln operational (+20% capacity)
Q4: Engineered flooring line 35% of total sales (from 20%)

B. Quarterly Business Review (QBR)

            📋 QBR STANDARD AGENDA (90-120 Minutes):

                    Time
                    Topic
                    Owner
                    Key Questions
                
                    15 min
                    Financial Performance
                    CFO
                    
                        • Revenue vs plan?

                        • Margin trend?

                        • Cash flow status?
                    
                    20 min
                    Operational Performance
                    Operations Director
                    
                        • Production vs plan?

                        • OEE trend?

                        • Quality metrics?
                    
                    15 min
                    Sales & Market
                    Sales Director
                    
                        • Order book status?

                        • Market share trend?

                        • Customer feedback?
                    
                    10 min
                    Supply Chain Performance
                    PPIC Manager
                    
                        • OTIF achievement?

                        • Inventory level?

                        • Supplier issues?
                    
                    15 min
                    Strategic Initiatives
                    GM
                    
                        • CAPEX project status?

                        • New product launch?

                        • Market expansion?
                    
                    10 min
                    Risk & Issues
                    All
                    
                        • Top 3 risks?

                        • Mitigation plan?

                        • Escalation needed?
                    
                    15 min
                    Forecast Revision
                    CFO + PPIC
                    
                        • Adjust annual plan?

                        • Budget reallocation?

                        • Resource adjustment?
                    
                    10 min
                    Action Items & Close
                    GM
                    
                        • Who owns what?

                        • Deadline?

                        • Next meeting date?

📊 Q1 2026 BUSINESS REVIEW - PT Kayu Indah Jaya (Example):

EXECUTIVE SUMMARY:

Period: Jan-Mar 2026 (Q1)
Revenue: Rp 22.1 billion (Target: Rp 23.8B) = 93% achievement
Production: 26,500 m² (Target: 28,350 m²) = 93.5% achievement
OTIF: 94.8% (Target: 95%) = Near target
Gross Margin: 54.2% (Target: 56%) = Below target

DETAILED PERFORMANCE DASHBOARD:

Category	KPI	Q1 Plan	Q1 Actual	%	Status
FINANCIAL	Revenue (Rp B)	23.8	22.1	93%	⚠️
	Gross Margin %	56%	54.2%	-1.8%	⚠️
	EBITDA (Rp B)	4.5	4.1	91%	⚠️
OPERATIONS	Production (m²)	28,350	26,500	93.5%	⚠️
	OEE Average	80%	77.5%	-2.5%	⚠️
	Quality FPY	93%	92.1%	-0.9%	✅
SUPPLY CHAIN	OTIF	95%	94.8%	-0.2%	✅
SUPPLY CHAIN	Inventory Turnover	8.0x	7.2x	90%	⚠️
STRATEGIC	New Kiln Installation	Design Complete	On Track (90% design done)		✅
STRATEGIC	Engineered Floor % Sales	25%	22%	88%	⚠️

ROOT CAUSE ANALYSIS - Revenue Shortfall (7%):

GAP BREAKDOWN:

Volume Gap: 1,850 m² below target (6.5% shortfall)
- Cause: Production delay from kiln breakdown (3 days Q1)
- Impact: Rp 1.85M × avg price Rp 850K/m² = Rp 1.57 billion revenue loss
Price/Mix Gap: 0.5% lower avg selling price
- Cause: Higher proportion of Merbau (lower price) vs Jati Premium in Q1 sales
- Impact: Rp 110M revenue

TOTAL REVENUE GAP: Rp 1.68 billion (vs plan Rp 23.8B)

CORRECTIVE ACTIONS & FORECAST REVISION:

IMMEDIATE ACTIONS (Q2 2026):

Production Recovery Plan:
- Catch-up production: Add 1,850 m² to Q2 target
- Overtime: 20 hours/week in April-May
- Toll drying: 50k bd.ft untuk accelerate (avoid kiln bottleneck)
- Q2 Revised Target: 30,200 m² (original 28,350 + catch-up 1,850)
Product Mix Rebalancing:
- Sales focus: Push Jati Premium & Engineered Oak (higher margin)
- Promo strategy: Bundle Merbau with premium accessories (increase avg order value)
- Target: Q2 avg selling price Rp 880K/m² (vs Q1: Rp 834K/m²)
Kiln Reliability:
- Complete all 5 kilns preventive maintenance in April (before Q2 peak)
- Accelerate new kiln project (target: June operational instead of July)

ANNUAL FORECAST REVISION (Rolling 12-Month):

Quarter	Original Plan (m²)	Revised Plan (m²)	Change	Rationale
Q1 2026 (Actual)	28,350	26,500	-1,850	Kiln breakdown impact
Q2 2026 (Revised)	28,350	30,200	+1,850	Catch-up + overtime
Q3 2026 (Revised)	28,350	29,500	+1,150	New kiln operational (20% capacity ↑)
Q4 2026 (Revised)	28,350	29,500	+1,150	Full new kiln contribution
FY 2026 Total	113,400	115,700	+2,300	Net positive (new capacity offset Q1 loss)

REVISED FINANCIAL PROJECTION:

Revenue Projection: Rp 95.1B → Rp 96.8B (+Rp 1.7B, +1.8%)
Gross Margin Target: Maintain 56% via efficiency improvement
EBITDA: Rp 18.5B → Rp 19.2B (19.8% margin)

C. Budget vs Actual Variance Report

📋 Purpose: Financial accountability - track spending vs budget, ensure fiscal discipline

Frequency: Monthly detail, Quarterly summary | Users: CFO, GM, All Budget Holders (Dept Heads)

            💰 BUDGET VARIANCE ANALYSIS FRAMEWORK:

                    Variance Type
                    Formula & Measurement
                    Action Threshold
                
                    Favorable Variance (F)
                    
                        Actual Spend < Budget

                        OR

                        Actual Revenue > Budget

                        Good news! (Usually...)
                    
                        • <5% variance: Monitor

                        • 5-10%: Investigate (missed opportunity?)

                        • >10%: Review budget accuracy
                    
                    Unfavorable Variance (U)
                    
                        Actual Spend > Budget

                        OR

                        Actual Revenue < Budget

                        Red flag! Needs action
                    
                        • <5% variance: Monitor closely

                        • 5-10%: Action plan required

                        • >10%: Escalate to GM/CFO
                    
                    Volume Variance
                    
                        (Actual Volume - Budget Volume) × Budget Rate

                        Due to production/sales volume difference
                    
                        Acceptable if explained by market conditions

                        (e.g., demand spike/drop)
                    
                    Rate/Price Variance
                    
                        (Actual Rate - Budget Rate) × Actual Volume

                        Due to price/cost change
                    
                        Requires immediate mitigation if unfavorable

                        (e.g., hedge price, renegotiate contracts)

📊 Q1 2026 BUDGET vs ACTUAL VARIANCE REPORT:

INCOME STATEMENT VARIANCE ANALYSIS:

Line Item	Budget (Rp M)	Actual (Rp M)	Variance (Rp M)	Variance %	F/U
REVENUE
Solid Wood Sales	19,800	18,450	-1,350	-6.8%	U
Engineered Flooring	3,150	2,980	-170	-5.4%	U
Decking	850	720	-130	-15.3%	U
TOTAL REVENUE	23,800	22,150	-1,650	-6.9%	U
COST OF GOODS SOLD
Direct Material	10,472	10,285	-187	-1.8%	F
Direct Labor	3,808	3,945	+137	+3.6%	U
Manufacturing OH	3,094	3,285	+191	+6.2%	U
TOTAL COGS	17,374	17,515	+141	+0.8%	U
GROSS PROFIT	6,426 (27%)	4,635 (20.9%)	-1,791	-27.9%	U
OPERATING EXPENSES
Sales & Marketing	950	885	-65	-6.8%	F
G&A (General & Admin)	720	745	+25	+3.5%	U
R&D	250	180	-70	-28%	F
TOTAL OPEX	1,920	1,810	-110	-5.7%	F
EBITDA	4,506 (18.9%)	2,825 (12.8%)	-1,681	-37.3%	U

KEY INSIGHTS & ACTION ITEMS:

🔴 CRITICAL ISSUES:

Revenue Shortfall -6.9% (Rp 1.65B):
- Already addressed in QBR section - production recovery plan in place
- Target Q2: Make up volume deficit
Gross Margin Erosion: 27% → 20.9% (-6.1 percentage points!):
- Root cause: Fixed cost under-absorption (production volume down 6.5%)
- Impact: Rp 1.79B gross profit loss (vs budget)
- Action: Volume recovery critical! Every 1% production increase = Rp 0.3B gross profit
Manufacturing Overhead Overrun +6.2% (Rp 191M):
- Energy cost spike: LPG price +18% (Rp 120M unfavorable)
- Maintenance cost: Kiln breakdown repair (Rp 45M unfavorable)
- Other: Misc. overhead (Rp 26M)
- Action: Accelerate solar panel project (hedge energy cost), TPM program (reduce breakdown)

✅ POSITIVE HIGHLIGHTS:

Material Cost Favorable -1.8% (Rp 187M): Excellent procurement performance! Yield improvement from 38% → 39.3% = Material saving
OPEX Control -5.7% (Rp 110M): Disciplined spending, good cost management
R&D Underspend -28% (Rp 70M): Project delayed (acceptable, not critical path)

CAPEX VARIANCE TRACKING:

Project	Annual Budget	Q1 Plan	Q1 Actual	Variance	Status
New Kiln	Rp 2,500M	Rp 500M	Rp 450M	-Rp 50M	✅ On Track
Warehouse Expansion	Rp 750M	Rp 150M	Rp 135M	-Rp 15M	✅ On Track
Forklift Purchase	Rp 400M	Rp 0M	Rp 0M	—	Q2 Scheduled
ERP Upgrade	Rp 300M	Rp 75M	Rp 60M	-Rp 15M	✅ On Track
Solar Panel	Rp 850M	Rp 0M	Rp 0M	—	Q3 Scheduled
Misc. Equipment	Rp 200M	Rp 50M	Rp 42M	-Rp 8M	✅ OK
TOTAL CAPEX	Rp 5,000M	Rp 775M	Rp 687M	-Rp 88M (F)	✅ 15.5% YTD

✅ MANAGEMENT ACTIONS - Budget Recovery Plan:

Q2 2026 Focus Areas:

Revenue Recovery: Implement catch-up production plan (target +1,850 m² vs original Q2 plan)
Margin Protection: Volume increase will improve fixed cost absorption → restore gross margin to 56% target
Cost Control: Energy hedging strategy (lock LPG price for Q2-Q4), accelerate solar panel project
CAPEX Discipline: Maintain spending discipline, all projects on track within budget

Full Year Outlook: Despite Q1 shortfall, confident to achieve revised FY2026 target (Rp 96.8B revenue, 56% gross margin) through:

New kiln capacity (June operational)
Improved operational efficiency (OEE 78% → 82%)
Product mix enhancement (higher margin Engineered flooring 35% of sales)

Material Category	Typical Usage Rate	Cost Impact	Control Method
1. UV Lacquer (Prefinished)	Coverage: 8-10 m²/liter/coat Coats: 2-3 lapis Total: 0.25-0.38 L/m²	Rp 85,000-150,000/L Impact: 5-8% dari production cost	• Spray gun calibration • Batch mixing control • Overspray reclaim system
2. Tung Oil / Natural Oil	Coverage: 10-12 m²/liter/coat Coats: 2-3 lapis Total: 0.17-0.30 L/m²	Rp 120,000-250,000/L Impact: 3-6% (premium product)	• Species-specific rate • Wipe-on method standardization • Absorption rate tracking
3. Adhesive (Engineered Flooring)	PVA: 150-200 g/m² (30-40 m²/kg) PUR: 100-125 g/m² (40-50 m²/kg)	PVA: Rp 25,000-40,000/kg PUR: Rp 85,000-120,000/kg Impact: 2-4%	• Glue spreader calibration • Temperature control • Open time monitoring
4. Packaging Materials	Per 1,000 m²: • Boxes: 200-250 pcs • Plastic wrap: 10-15 rolls • Pallets: 8-12 pcs	Total: Rp 8,000-12,000/m² Impact: 0.8-1.2%	• Box size optimization • Pallet reuse program • Bulk purchasing
5. Abrasives (Sandpaper)	Belt sander: 200-300 m²/belt Disc sander: 400-600 m²/disc	Belt: Rp 125,000-200,000 Disc: Rp 15,000-30,000 Impact: 1-2%	• Grit progression protocol • Dust collection (extend life) • Usage tracking per shift

Variance Type	Formula	Interpretation
Price Variance	(Actual Price - Budget Price) × Actual Quantity Mengukur: Perubahan harga material/upah	Favorable (F): Actual price < Budget → Cost saving Unfavorable (U): Actual price > Budget → Cost overrun Responsibility: Procurement (material), HR (labor)
Efficiency Variance	(Actual Quantity - Budget Quantity) × Budget Price Mengukur: Produktivitas & waste	Favorable (F): Actual usage < Budget → Efficient Unfavorable (U): Actual usage > Budget → Wasteful Responsibility: Production/Operations
Volume Variance	(Actual Volume - Budget Volume) × Budget Cost per Unit Mengukur: Production output vs plan	Impact Fixed Cost Absorption: • Volume ↓ → Under-absorbed overhead → Unit cost ↑ • Volume ↑ → Over-absorbed overhead → Unit cost ↓

Planning Level	Time Horizon	Key Outputs
Strategic Plan	3-5 years (Long-term)	• Market growth target (e.g., 15% CAGR) • Product portfolio strategy • Capacity expansion roadmap • Major CAPEX decisions
Annual Business Plan	12 months (Yearly)	• Revenue target by product line • Production volume plan • Hiring & training budget • Annual CAPEX/OPEX budget
Quarterly Review	3 months (Quarterly)	• Plan vs Actual analysis • Forecast revision (rolling 12M) • Resource reallocation • Risk mitigation actions
Monthly S&OP	1 month (Monthly)	• MPS finalization • Material procurement plan • Short-term capacity adjustment • Weekly production schedule

Time	Topic	Owner	Key Questions
15 min	Financial Performance	CFO	• Revenue vs plan? • Margin trend? • Cash flow status?
20 min	Operational Performance	Operations Director	• Production vs plan? • OEE trend? • Quality metrics?
15 min	Sales & Market	Sales Director	• Order book status? • Market share trend? • Customer feedback?
10 min	Supply Chain Performance	PPIC Manager	• OTIF achievement? • Inventory level? • Supplier issues?
15 min	Strategic Initiatives	GM	• CAPEX project status? • New product launch? • Market expansion?
10 min	Risk & Issues	All	• Top 3 risks? • Mitigation plan? • Escalation needed?
15 min	Forecast Revision	CFO + PPIC	• Adjust annual plan? • Budget reallocation? • Resource adjustment?
10 min	Action Items & Close	GM	• Who owns what? • Deadline? • Next meeting date?

Variance Type	Formula & Measurement	Action Threshold
Favorable Variance (F)	Actual Spend < Budget OR Actual Revenue > Budget Good news! (Usually...)	• <5% variance: Monitor • 5-10%: Investigate (missed opportunity?) • >10%: Review budget accuracy
Unfavorable Variance (U)	Actual Spend > Budget OR Actual Revenue < Budget Red flag! Needs action	• <5% variance: Monitor closely • 5-10%: Action plan required • >10%: Escalate to GM/CFO
Volume Variance	(Actual Volume - Budget Volume) × Budget Rate Due to production/sales volume difference	Acceptable if explained by market conditions (e.g., demand spike/drop)
Rate/Price Variance	(Actual Rate - Budget Rate) × Actual Volume Due to price/cost change	Requires immediate mitigation if unfavorable (e.g., hedge price, renegotiate contracts)